superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where YR_EST = 1961
This data as json, copyable, CSV (advanced)
MNG_AGENCY 18
- Santa Clara, City of 11
- San Mateo, City of 10
- Menlo Park, City of 6
- Millbrae, City of 4
- Los Altos, City of 3
- San Jose, City of 2
- Fremont, City of 2
- Redwood City, City of 2
- Sunnyvale, City of 2
- San Bruno, City of 2
- United States Bureau of Land Management 1
- United States Fish and Wildlife Service 1
- California Department of Parks and Recreation 1
- Oakland, City of 1
- Belmont, City of 1
- Hayward Area Recreation and Park District 1
- Burlingame, City of 1
- Mountain View, City of 1
MNG_AG_TYP 4
ACCESS_TYP 2
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3150 | 3150 | 3149 | {"type": "Polygon", "coordinates": [[[-122.30455, 37.55525], [-122.30397, 37.55534], [-122.30391, 37.55508], [-122.30448, 37.55498], [-122.30455, 37.55525]]]} | Open Access 1 | Connie Park | 17591 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.389 | Connie Park | 1961 | |
3405 | 3405 | 3404 | {"type": "Polygon", "coordinates": [[[-122.29796, 37.56767], [-122.29795, 37.56824], [-122.29718, 37.56827], [-122.29719, 37.56766], [-122.29738, 37.56766], [-122.2974, 37.5677], [-122.29775, 37.5677], [-122.29777, 37.56767], [-122.29796, 37.56767]]]} | Open Access 1 | Dale Avenue | 17893 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.07 | Dale Avenue | 1961 | |
3725 | 3725 | 3724 | {"type": "Polygon", "coordinates": [[[-122.0708, 37.34489], [-122.0708, 37.34665], [-122.06989, 37.34665], [-122.06989, 37.34631], [-122.06993, 37.34626], [-122.06995, 37.3462], [-122.06996, 37.34583], [-122.06995, 37.34576], [-122.06992, 37.3457], [-122.06986, 37.34566], [-122.06979, 37.34563], [-122.0698, 37.34492], [-122.07023, 37.34489], [-122.0708, 37.34489]]]} | Open Access 1 | Grant Park | 19438 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 3.972 | Grant Park | 1961 | |
3787 | 3787 | 3786 | {"type": "Polygon", "coordinates": [[[-122.0458, 37.66526], [-122.04582, 37.66577], [-122.04507, 37.66859], [-122.04475, 37.66865], [-122.04361, 37.66881], [-122.0429, 37.66542], [-122.0458, 37.66526]]]} | Open Access 1 | East Avenue Park | 18360 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 18.311 | East Avenue Park | 1961 | |
3794 | 3794 | 3793 | {"type": "Polygon", "coordinates": [[[-122.30409, 37.53651], [-122.3036, 37.53671], [-122.30288, 37.53523], [-122.30346, 37.53505], [-122.30372, 37.5359], [-122.30409, 37.53651]]]} | Open Access 1 | East Hillsdale | 18371 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.027 | East Hillsdale | 1961 | |
4102 | 4102 | 4101 | {"type": "Polygon", "coordinates": [[[-121.95707, 37.33348], [-121.9567, 37.33392], [-121.9564, 37.33377], [-121.95614, 37.3337], [-121.95611, 37.3328], [-121.95639, 37.33287], [-121.95664, 37.33299], [-121.95684, 37.33315], [-121.95707, 37.33343], [-121.95707, 37.33348]]]} | Open Access 1 | Everett Alvarez Park | 18761 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.695 | Everett Alvarez Park | 1961 | |
4121 | 4121 | 4120 | {"type": "Polygon", "coordinates": [[[-122.21235, 37.47671], [-122.21207, 37.47697], [-122.21157, 37.47664], [-122.21202, 37.47668], [-122.21235, 37.47671]]]} | Open Access 1 | Fair Oaks Community Cente | 18784 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.275 | Fair Oaks Community Cente | 1961 | |
4217 | 4217 | 4216 | {"type": "Polygon", "coordinates": [[[-122.29641, 37.55058], [-122.2957, 37.55093], [-122.29572, 37.55098], [-122.29509, 37.55128], [-122.29476, 37.5511], [-122.29445, 37.55084], [-122.29433, 37.5509], [-122.29395, 37.55051], [-122.29439, 37.55026], [-122.2946, 37.55016], [-122.296, 37.54977], [-122.29613, 37.55], [-122.2961, 37.55003], [-122.29602, 37.55005], [-122.29602, 37.55007], [-122.29641, 37.55058]]]} | Open Access 1 | Fiesta Meadows | 18892 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 4.906 | Fiesta Meadows | 1961 | |
4296 | 4296 | 4295 | {"type": "Polygon", "coordinates": [[[-122.30386, 37.5286], [-122.30295, 37.52897], [-122.30258, 37.5289], [-122.30234, 37.52882], [-122.30231, 37.52883], [-122.30205, 37.52845], [-122.3034, 37.52789], [-122.30386, 37.5286]]]} | Open Access 1 | Indian Springs | 20207 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.707 | Indian Springs | 1961 | |
4332 | 4332 | 4331 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.53298], [-121.95978, 37.53314], [-121.95949, 37.53297], [-121.95949, 37.53297], [-121.95991, 37.53298]]]} | Open Access 1 | Irvington Plaza | 20274 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 0.081 | Irvington Plaza | 1961 | |
4604 | 4604 | 4603 | {"type": "Polygon", "coordinates": [[[-122.44181, 37.62294], [-122.44167, 37.62295], [-122.44149, 37.62283], [-122.44155, 37.62271], [-122.44171, 37.62265], [-122.44177, 37.62264], [-122.44181, 37.62294]]]} | Open Access 1 | Glenview Park | 19338 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.16 | Glenview Park | 1961 | |
4782 | 4782 | 4781 | {"type": "Polygon", "coordinates": [[[-122.42194, 37.622], [-122.4215, 37.62221], [-122.42162, 37.62242], [-122.42145, 37.62256], [-122.42119, 37.62223], [-122.42061, 37.62251], [-122.42024, 37.62264], [-122.41996, 37.62266], [-122.41963, 37.62259], [-122.41939, 37.62267], [-122.41924, 37.62244], [-122.41996, 37.62208], [-122.42006, 37.62219], [-122.42119, 37.6216], [-122.42132, 37.62174], [-122.42164, 37.62158], [-122.42194, 37.622]]]} | Open Access 1 | Grundy Park | 19538 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 3.354 | Grundy Park | 1961 | |
4895 | 4895 | 4894 | {"type": "Polygon", "coordinates": [[[-122.31523, 37.58098], [-122.31449, 37.58149], [-122.31363, 37.58076], [-122.31441, 37.58023], [-122.31523, 37.58098]]]} | Open Access 1 | Harborview | 19669 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 2.434 | Harborview | 1961 | |
5040 | 5040 | 5039 | {"type": "Polygon", "coordinates": [[[-121.96162, 37.33687], [-121.96029, 37.33736], [-121.95907, 37.33641], [-121.96008, 37.33521], [-121.96012, 37.33518], [-121.96016, 37.33518], [-121.9604, 37.33534], [-121.96115, 37.33593], [-121.96132, 37.33609], [-121.96144, 37.33629], [-121.96162, 37.33687]]]} | Open Access 1 | Henry Schmidt Park | 19829 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 7.657 | Henry Schmidt Park | 1961 | |
5229 | 5229 | 5228 | {"type": "Polygon", "coordinates": [[[-121.98313, 37.3352], [-121.98301, 37.33532], [-121.98292, 37.33545], [-121.98268, 37.33595], [-121.98253, 37.33613], [-121.98227, 37.33638], [-121.9814, 37.33704], [-121.98125, 37.33718], [-121.98112, 37.33735], [-121.98111, 37.33648], [-121.98174, 37.33647], [-121.98215, 37.33519], [-121.98299, 37.33518], [-121.98307, 37.33521], [-121.98313, 37.3352]]]} | Open Access 1 | Homeridge Park | 20062 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 3.365 | Homeridge Park | 1961 | |
5389 | 5389 | 5388 | {"type": "Polygon", "coordinates": [[[-121.8864, 37.31025], [-121.88595, 37.31039], [-121.8854, 37.30953], [-121.8861, 37.3094], [-121.8864, 37.31025]], [[-121.88615, 37.3097], [-121.88616, 37.30968], [-121.88607, 37.30946], [-121.88591, 37.3095], [-121.88599, 37.30973], [-121.88615, 37.3097]]]} | Open Access 1 | J.Frey/Willow Community Garden | 20293 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.216 | J.Frey/Willow Community Garden | 1961 | |
5412 | 5412 | 5411 | {"type": "Polygon", "coordinates": [[[-121.96531, 37.52284], [-121.96529, 37.52287], [-121.96284, 37.52318], [-121.96261, 37.52202], [-121.9627, 37.52208], [-121.96279, 37.52206], [-121.96264, 37.52125], [-121.96266, 37.52125], [-121.96269, 37.5213], [-121.96274, 37.52134], [-121.96285, 37.52135], [-121.96292, 37.52133], [-121.96302, 37.52128], [-121.96455, 37.52108], [-121.96467, 37.52109], [-121.96475, 37.52112], [-121.96481, 37.52118], [-121.96512, 37.5216], [-121.9652, 37.52172], [-121.96526, 37.52188], [-121.96531, 37.52216], [-121.96528, 37.52259], [-121.96531, 37.52284]]]} | Open Access 1 | Irvington Park | 20273 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 11.075 | Irvington Park | 1961 | |
5446 | 5446 | 5445 | {"type": "Polygon", "coordinates": [[[-122.18424, 37.44468], [-122.18381, 37.44519], [-122.18236, 37.44442], [-122.18279, 37.44391], [-122.18424, 37.44468]]]} | Open Access 1 | Jack W. Lyle Park | 20313 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 2.625 | Jack W. Lyle Park | 1961 | |
5608 | 5608 | 5607 | {"type": "Polygon", "coordinates": [[[-122.39939, 37.59473], [-122.39896, 37.59497], [-122.3985, 37.59448], [-122.3984, 37.59452], [-122.39831, 37.59442], [-122.39818, 37.59449], [-122.39802, 37.59432], [-122.39813, 37.59425], [-122.39813, 37.59423], [-122.398, 37.59416], [-122.39788, 37.59423], [-122.39757, 37.594], [-122.39778, 37.59388], [-122.39768, 37.59375], [-122.39738, 37.59391], [-122.3973, 37.59382], [-122.39765, 37.59371], [-122.39801, 37.59326], [-122.39939, 37.59473]]]} | Open Access 1 | Josephine Waugh/Soroptimist Park | 20502 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 2.837 | Josephine Waugh/Soroptimist Park | 1961 | |
5696 | 5696 | 5695 | {"type": "Polygon", "coordinates": [[[-122.17165, 37.4789], [-122.16783, 37.47916], [-122.16777, 37.47856], [-122.16808, 37.47859], [-122.16966, 37.47849], [-122.16984, 37.47853], [-122.16994, 37.47848], [-122.16996, 37.47845], [-122.16996, 37.4784], [-122.16991, 37.47833], [-122.16983, 37.47831], [-122.16808, 37.47843], [-122.1679, 37.47842], [-122.16772, 37.47838], [-122.16789, 37.47815], [-122.16789, 37.47811], [-122.16976, 37.47798], [-122.16976, 37.47779], [-122.17165, 37.4789]]]} | Open Access 1 | Kelly Park | 20588 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 6.934 | Kelly Park | 1961 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);