units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1 and ACRES = "4.869"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
MNG_AGENCY 4
MNG_AG_TYP 1
DES_TP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2170 | 2170 | 2169 | {"type": "Polygon", "coordinates": [[[-121.23276, 37.80831], [-121.23277, 37.80927], [-121.23117, 37.80928], [-121.2311, 37.80828], [-121.23114, 37.80805], [-121.23274, 37.80803], [-121.23276, 37.80831]]]} | Open Access 1 | 17652 | Greystone Park | 19507 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 4.869 | Greystone Park | 0 | Local Park 2 | 4 | |
2990 | 2990 | 2989 | {"type": "Polygon", "coordinates": [[[-118.34178, 34.19079], [-118.34176, 34.19181], [-118.34014, 34.19178], [-118.34014, 34.19041], [-118.34023, 34.19042], [-118.34024, 34.19046], [-118.34178, 34.19079]]]} | Open Access 1 | 20655 | Robert E. Gross Park | 29540 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | Los Angeles 6 | 4.869 | Robert E. Gross Park | 0 | Local Park 2 | 4 | |
7104 | 7104 | 7103 | {"type": "Polygon", "coordinates": [[[-118.40767, 33.92145], [-118.4072, 33.92145], [-118.40716, 33.92144], [-118.40715, 33.92148], [-118.40669, 33.92148], [-118.40667, 33.91952], [-118.40766, 33.91952], [-118.40767, 33.92145]]]} | Open Access 1 | 6157 | Hilltop Park | 19987 | 1096 | El Segundo, City of 300 | City 2 | City Agency 2 | http://www.elsegundo.org/depts/recreation/default.asp | City 2 | 1096 | El Segundo, City of 296 | City 2 | City Agency 2 | Los Angeles 6 | 4.869 | Hilltop Park | 0 | Local Park 2 | 4 | |
8525 | 8525 | 8524 | {"type": "Polygon", "coordinates": [[[-121.85977, 37.69562], [-121.85969, 37.69728], [-121.85872, 37.6973], [-121.85841, 37.69714], [-121.85853, 37.69673], [-121.85848, 37.69604], [-121.85861, 37.69577], [-121.85907, 37.69559], [-121.85977, 37.69562]]]} | Open Access 1 | 15392 | Meadows Park | 22098 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 4.869 | Meadows Park | 0 | Local Park 2 | 4 | |
10125 | 10125 | 10124 | {"type": "Polygon", "coordinates": [[[-121.23082, 37.81398], [-121.2315, 37.81396], [-121.23155, 37.81401], [-121.23156, 37.81455], [-121.23146, 37.81486], [-121.23138, 37.81497], [-121.23135, 37.81505], [-121.2313, 37.81511], [-121.23092, 37.81506], [-121.22966, 37.81507], [-121.22961, 37.81404], [-121.23082, 37.81398]]]} | Open Access 1 | 17595 | Colony Park | 17537 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 4.869 | Colony Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);