units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

5 rows where ACCESS_TYP = 1, AGNCY_NAME = 43 and DES_TP = 3

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

DES_TP 1

  • Local Recreation Area · 5 ✖

ACCESS_TYP 1

  • Open Access · 5 ✖
Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
604 604 603 {"type": "Polygon", "coordinates": [[[-117.28533, 33.07516], [-117.2853, 33.07521], [-117.28527, 33.07522], [-117.28497, 33.07519], [-117.28477, 33.07514], [-117.28457, 33.07503], [-117.28437, 33.07495], [-117.28396, 33.07485], [-117.28367, 33.07484], [-117.28329, 33.07488], [-117.28306, 33.07494], [-117.28302, 33.07497], [-117.28297, 33.07497], [-117.2828, 33.07505], [-117.28249, 33.07525], [-117.28238, 33.07536], [-117.28222, 33.07554], [-117.28212, 33.07569], [-117.28206, 33.07584], [-117.28172, 33.07682], [-117.28167, 33.07691], [-117.28158, 33.07705], [-117.28148, 33.07716], [-117.2814, 33.07724], [-117.28127, 33.07733], [-117.2805, 33.07234], [-117.28049, 33.07122], [-117.2805, 33.07054], [-117.28494, 33.07056], [-117.28494, 33.07238], [-117.28533, 33.07516]]]} Open Access 1 2084 Indian Head Canyon 20201 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2   San Diego 4 55.677 Indian Head Canyon 0 Local Recreation Area 3 4
5076 5076 5075 {"type": "Polygon", "coordinates": [[[-117.22622, 33.05283], [-117.22608, 33.05351], [-117.22591, 33.05411], [-117.22568, 33.05481], [-117.22537, 33.05473], [-117.22596, 33.05276], [-117.22622, 33.05283]]]} Open Access 1 4282 Little Oaks Equestrian Park 21350 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks San Diego 4 1.691 Little Oaks Equestrian Park 0 Local Recreation Area 3 4
6031 6031 6030 {"type": "Polygon", "coordinates": [[[-117.2663, 33.02641], [-117.26626, 33.029], [-117.26557, 33.02899], [-117.26557, 33.02818], [-117.26429, 33.02817], [-117.26427, 33.02813], [-117.2643, 33.02639], [-117.2648, 33.0264], [-117.26482, 33.02544], [-117.26486, 33.02544], [-117.26486, 33.0264], [-117.2663, 33.02641]]]} Open Access 1 725 Cardiff Sports Park 16846 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks San Diego 4 10.684 Cardiff Sports Park 0 Local Recreation Area 3 4
6586 6586 6585 {"type": "Polygon", "coordinates": [[[-117.26461, 33.06108], [-117.26455, 33.06117], [-117.26448, 33.0613], [-117.26387, 33.06304], [-117.26366, 33.06348], [-117.26361, 33.0636], [-117.26311, 33.06359], [-117.26311, 33.06351], [-117.2632, 33.06304], [-117.2632, 33.0629], [-117.26317, 33.06286], [-117.2635, 33.06179], [-117.26335, 33.06149], [-117.26332, 33.06135], [-117.26342, 33.06107], [-117.26368, 33.06107], [-117.26368, 33.06086], [-117.26372, 33.06078], [-117.26379, 33.06074], [-117.26391, 33.06092], [-117.2641, 33.06086], [-117.26461, 33.06108]]]} Open Access 1 3993 Leo Mullen Sports Park 29090 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks San Diego 4 5.639 Leo Mullen Sports Park 0 Local Recreation Area 3 4
7383 7383 7382 {"type": "Polygon", "coordinates": [[[-117.28854, 33.05442], [-117.28768, 33.05441], [-117.28768, 33.05453], [-117.28561, 33.05452], [-117.28569, 33.05184], [-117.28762, 33.05184], [-117.28819, 33.05336], [-117.28839, 33.05414], [-117.28854, 33.05442]]]} Open Access 1 8114 Paul Ecke Sports Park 23530 1100 Encinitas, City of 43 City 2 City Agency 2 http://www.cityofencinitas.org/index.aspx?page=49 City 2 1100 Encinitas, City of 42 City 2 City Agency 2 http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks San Diego 4 16.607 Paul Ecke Sports Park 0 Local Recreation Area 3 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);