units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where DES_TP = 2 and YR_EST = 1963
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2044 | 2044 | 2043 | {"type": "Polygon", "coordinates": [[[-122.42983, 37.70536], [-122.42971, 37.70543], [-122.42944, 37.70564], [-122.42915, 37.70553], [-122.42926, 37.70533], [-122.42983, 37.70536]]]} | Open Access 1 | 15588 | Arden Court | 15576 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.282 | Arden Court | 1963 | Local Park 2 | 4 | |
3956 | 3956 | 3955 | {"type": "Polygon", "coordinates": [[[-121.84533, 37.26464], [-121.84499, 37.26587], [-121.8333, 37.26597], [-121.8323, 37.26586], [-121.83182, 37.26587], [-121.83147, 37.26583], [-121.83147, 37.2658], [-121.8314, 37.26579], [-121.83136, 37.26576], [-121.83132, 37.26569], [-121.83129, 37.2657], [-121.83126, 37.26541], [-121.83111, 37.26459], [-121.83109, 37.26311], [-121.83104, 37.2625], [-121.83102, 37.2602], [-121.83107, 37.25982], [-121.83111, 37.25919], [-121.83617, 37.25916], [-121.83639, 37.25952], [-121.83773, 37.26158], [-121.8397, 37.26155], [-121.84206, 37.26469], [-121.84533, 37.26464]]]} | Open Access 1 | 46978 | Martial Cottle Park | 30611 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/martialcottle.aspx | Santa Clara 19 | 150.454 | Martial Cottle Park | 1963 | Local Park 2 | 4 |
6798 | 6798 | 6797 | {"type": "Polygon", "coordinates": [[[-122.1208, 37.44259], [-122.11901, 37.44439], [-122.11896, 37.44441], [-122.1189, 37.44441], [-122.11862, 37.44417], [-122.11799, 37.44357], [-122.11805, 37.4426], [-122.11636, 37.44099], [-122.11573, 37.44141], [-122.11564, 37.44127], [-122.1153, 37.44058], [-122.11656, 37.43987], [-122.11739, 37.44054], [-122.11754, 37.44057], [-122.11798, 37.44033], [-122.11805, 37.44037], [-122.11773, 37.44055], [-122.11772, 37.44057], [-122.1182, 37.44095], [-122.1208, 37.44259]]]} | Open Access 1 | 5308 | John Lucas Greer Park | 20452 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 21.478 | John Lucas Greer Park | 1963 | Local Park 2 | 4 | |
8552 | 8552 | 8551 | {"type": "Polygon", "coordinates": [[[-122.39766, 37.57859], [-122.3979, 37.57884], [-122.39871, 37.57947], [-122.39875, 37.57952], [-122.39874, 37.57956], [-122.3985, 37.57974], [-122.39826, 37.57983], [-122.39678, 37.58002], [-122.39652, 37.58003], [-122.39638, 37.57939], [-122.39766, 37.57859]]]} | Open Access 1 | 13506 | Cuernavaca Park | 17848 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 4.905 | Cuernavaca Park | 1963 | Local Park 2 | 4 | |
8655 | 8655 | 8654 | {"type": "Polygon", "coordinates": [[[-122.25411, 37.47894], [-122.25351, 37.47941], [-122.25343, 37.47934], [-122.25337, 37.47924], [-122.25335, 37.4791], [-122.25338, 37.47896], [-122.25347, 37.47885], [-122.25363, 37.47875], [-122.25376, 37.47872], [-122.25392, 37.47871], [-122.2539, 37.47884], [-122.25402, 37.47888], [-122.25411, 37.47894]]]} | Open Access 1 | 13881 | Dove Beeger Park | 18249 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 0.721 | Dove Beeger Park | 1963 | Local Park 2 | 4 | |
13921 | 13921 | 13920 | {"type": "Polygon", "coordinates": [[[-121.84833, 37.25563], [-121.84663, 37.25985], [-121.84562, 37.26362], [-121.84547, 37.26412], [-121.84533, 37.26464], [-121.84206, 37.26469], [-121.8397, 37.26156], [-121.83774, 37.26159], [-121.83639, 37.25952], [-121.83617, 37.25916], [-121.84291, 37.25912], [-121.84291, 37.25868], [-121.84339, 37.2577], [-121.84335, 37.2575], [-121.8432, 37.2571], [-121.84276, 37.25508], [-121.84294, 37.25507], [-121.84294, 37.25502], [-121.84498, 37.25499], [-121.84601, 37.25529], [-121.84678, 37.25546], [-121.84741, 37.25556], [-121.84833, 37.25563]]]} | Open Access 1 | 46977 | Martial Cottle Park | 30611 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | https://www.sccgov.org/sites/parks/parkfinder/Pages/martialcottle.aspx | Santa Clara 19 | 137.123 | Martial Cottle Park | 1963 | 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]);