units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1, DES_TP = 2, LABEL_NAME = "Lions Park" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
438 | 438 | 437 | {"type": "Polygon", "coordinates": [[[-119.84426, 36.80273], [-119.83996, 36.80275], [-119.83995, 36.80098], [-119.84162, 36.80098], [-119.84205, 36.80106], [-119.84262, 36.80112], [-119.84422, 36.80112], [-119.84426, 36.80273]]]} | Open Access 1 | 1388 | Lions Park | 21319 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 17.754 | Lions Park | 0 | Local Park 2 | 4 | |
718 | 718 | 717 | {"type": "Polygon", "coordinates": [[[-117.60541, 34.12], [-117.6054, 34.12133], [-117.60539, 34.12135], [-117.60535, 34.12137], [-117.60497, 34.12137], [-117.60497, 34.12048], [-117.60414, 34.12048], [-117.60415, 34.11982], [-117.6046, 34.11982], [-117.60461, 34.12], [-117.60541, 34.12]]]} | Open Access 1 | 4256 | Lions Park | 21322 | 1263 | Rancho Cucamonga, City of 196 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | San Bernardino 22 | 2.725 | Lions Park | 0 | Local Park 2 | 4 | |
1869 | 1869 | 1868 | {"type": "Polygon", "coordinates": [[[-122.40706, 37.62384], [-122.40529, 37.62418], [-122.40408, 37.62412], [-122.40388, 37.62311], [-122.40617, 37.62255], [-122.40706, 37.62384]]]} | Open Access 1 | 14391 | Lions Park | 21323 | 1294 | San Bruno, City of 440 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | San Mateo 15 | 8.503 | Lions Park | 1954 | Local Park 2 | 4 | |
5374 | 5374 | 5373 | {"type": "Polygon", "coordinates": [[[-117.9232, 33.64208], [-117.92122, 33.64211], [-117.9212, 33.63994], [-117.92319, 33.63992], [-117.9232, 33.64208]]]} | Open Access 1 | 5700 | Lions Park | 21318 | 1071 | Costa Mesa, City of 117 | City 2 | City Agency 2 | http://www.costamesaca.gov/index.aspx?page=70 | City 2 | 1071 | Costa Mesa, City of 114 | City 2 | City Agency 2 | Orange 3 | 10.919 | Lions Park | 0 | Local Park 2 | 4 | |
5745 | 5745 | 5744 | {"type": "Polygon", "coordinates": [[[-120.07377, 36.72311], [-120.07373, 36.72469], [-120.07369, 36.72471], [-120.07341, 36.72472], [-120.0734, 36.72438], [-120.07104, 36.7244], [-120.07054, 36.72434], [-120.07053, 36.72311], [-120.07377, 36.72311]]]} | Open Access 1 | 3077 | Lions Park | 21320 | 1151 | Kerman, City of 212 | City 2 | City Agency 2 | http://cityofkerman.net/parks-and-recreation-department/ | City 2 | 1151 | Kerman, City of 208 | City 2 | City Agency 2 | Fresno 9 | 10.346 | Lions Park | 0 | Local Park 2 | 4 | |
10617 | 10617 | 10616 | {"type": "Polygon", "coordinates": [[[-121.03293, 37.31843], [-121.03291, 37.31976], [-121.03108, 37.31974], [-121.03104, 37.31842], [-121.03293, 37.31843]]]} | Open Access 1 | 18910 | Lions Park | 21321 | 1223 | Newman, City of 527 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | Stanislaus 2 | 5.972 | Lions Park | 0 | Local Park 2 | 4 | |
10743 | 10743 | 10742 | {"type": "Polygon", "coordinates": [[[-116.87239, 33.91809], [-116.86808, 33.91808], [-116.86809, 33.91644], [-116.87127, 33.91643], [-116.87128, 33.91717], [-116.87238, 33.91717], [-116.87239, 33.91809]]]} | Open Access 1 | 19963 | Lions Park | 21324 | 1396 | Banning, City of 370 | City 2 | City Agency 2 | http://www.ci.banning.ca.us/ | City 2 | 1396 | Banning, City of 365 | City 2 | City Agency 2 | Riverside 10 | 15.917 | Lions Park | 0 | Local Park 2 | 4 | |
11499 | 11499 | 11498 | {"type": "Polygon", "coordinates": [[[-119.36509, 36.35194], [-119.36331, 36.35195], [-119.36331, 36.35172], [-119.36327, 36.3517], [-119.36329, 36.35165], [-119.3633, 36.3516], [-119.36324, 36.35151], [-119.36316, 36.35148], [-119.3631, 36.35147], [-119.36304, 36.35149], [-119.36293, 36.35154], [-119.36271, 36.35155], [-119.36271, 36.35115], [-119.36509, 36.35113], [-119.36509, 36.35194]]]} | Open Access 1 | 48207 | Lions Park | 32747 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 4.109 | Lions Park | 0 | Local Park 2 | 4 | |
11812 | 11812 | 11811 | {"type": "Polygon", "coordinates": [[[-120.77696, 38.71885], [-120.77561, 38.71938], [-120.77394, 38.71985], [-120.77409, 38.71832], [-120.773, 38.71831], [-120.77367, 38.71776], [-120.77366, 38.71687], [-120.77378, 38.7164], [-120.7744, 38.71641], [-120.77467, 38.71655], [-120.77594, 38.71687], [-120.77645, 38.71712], [-120.77677, 38.71763], [-120.77675, 38.71815], [-120.77683, 38.71872], [-120.77696, 38.71885]]]} | Open Access 1 | 24116 | Lions Park | 21325 | 1410 | Placerville, City of 530 | City 2 | City Agency 2 | http://www.cityofplacerville.org/depts/parks/default.asp | City 2 | 1410 | Placerville, City of 523 | City 2 | City Agency 2 | El Dorado 34 | 19.436 | Lions 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]);