superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where YR_EST = 1961 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
MNG_AGENCY 18
- San Mateo, City of 13
- Santa Clara, City of 13
- Menlo Park, City of 6
- Millbrae, City of 4
- San Jose, City of 3
- Fremont, City of 3
- Sunnyvale, City of 3
- Los Altos, City of 3
- Oakland, City of 2
- Redwood City, City of 2
- San Bruno, City of 2
- Mountain View, City of 2
- United States Bureau of Land Management 1
- United States Fish and Wildlife Service 1
- California Department of Parks and Recreation 1
- Belmont, City of 1
- Hayward Area Recreation and Park District 1
- Burlingame, City of 1
MNG_AG_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
9570 | 9570 | 9569 | {"type": "Polygon", "coordinates": [[[-122.24632, 37.46136], [-122.24605, 37.46147], [-122.24591, 37.46152], [-122.24588, 37.4615], [-122.24578, 37.46136], [-122.24567, 37.46123], [-122.24595, 37.46103], [-122.24632, 37.46136]]]} | Open Access 1 | Westwood Park | 27442 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 0.403 | Westwood Park | 1961 | |
10092 | 10092 | 10091 | {"type": "Polygon", "coordinates": [[[-122.30921, 37.55932], [-122.30909, 37.55976], [-122.30879, 37.55971], [-122.30855, 37.55964], [-122.30909, 37.55927], [-122.30914, 37.55926], [-122.30919, 37.55927], [-122.30921, 37.55932]]]} | Open Access 1 | Sunnybrae Park | 26005 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 0.408 | Sunnybrae Park | 1961 | |
14021 | 14021 | 14020 | {"type": "Polygon", "coordinates": [[[-122.39528, 37.61104], [-122.39513, 37.61115], [-122.39392, 37.61039], [-122.39406, 37.61024], [-122.39528, 37.61104]]]} | Open Access 1 | Marina Vista Park | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/marina-vista-park | 32591 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 0.653 | Marina Vista Park | 1961 |
6693 | 6693 | 6692 | {"type": "MultiPolygon", "coordinates": [[[[-122.16628, 37.47667], [-122.16608, 37.47688], [-122.16602, 37.47689], [-122.1655, 37.47659], [-122.16567, 37.47641], [-122.16575, 37.4764], [-122.16597, 37.47653], [-122.166, 37.47651], [-122.16628, 37.47667]]], [[[-122.16607, 37.47699], [-122.16585, 37.47723], [-122.16582, 37.47712], [-122.16563, 37.47701], [-122.16576, 37.47686], [-122.16583, 37.47685], [-122.16607, 37.47699]]]]} | Open Access 1 | Marketplace Park | 21872 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 0.67 | Marketplace Park | 1961 | |
7536 | 7536 | 7535 | {"type": "Polygon", "coordinates": [[[-122.27259, 37.52352], [-122.2725, 37.52374], [-122.27206, 37.52424], [-122.27191, 37.52437], [-122.27175, 37.52449], [-122.27154, 37.52459], [-122.2713, 37.52468], [-122.27109, 37.52473], [-122.27253, 37.52348], [-122.27259, 37.52352]]]} | Open Access 1 | O'Donnell Park | 22947 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 0.889 | O'Donnell 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 | |
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 | |
2672 | 2672 | 2671 | {"type": "Polygon", "coordinates": [[[-122.28234, 37.53399], [-122.28208, 37.53415], [-122.28213, 37.53423], [-122.28188, 37.53438], [-122.28187, 37.53441], [-122.28178, 37.53444], [-122.28173, 37.5345], [-122.28169, 37.53449], [-122.28144, 37.53464], [-122.28081, 37.53396], [-122.2823, 37.53395], [-122.28234, 37.53399]]]} | Open Access 1 | Casanova | 16932 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.376 | Casanova | 1961 | |
9016 | 9016 | 9015 | {"type": "Polygon", "coordinates": [[[-122.39721, 37.59372], [-122.39652, 37.59394], [-122.39638, 37.594], [-122.39628, 37.59398], [-122.39625, 37.59395], [-122.39607, 37.59348], [-122.39603, 37.59323], [-122.39648, 37.59325], [-122.39668, 37.59314], [-122.39721, 37.59372]]]} | Open Access 1 | Rotary Park | 24691 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1.461 | Rotary Park | 1961 | |
564 | 564 | 563 | {"type": "Polygon", "coordinates": [[[-122.32314, 37.54969], [-122.32289, 37.54988], [-122.3213, 37.54842], [-122.32142, 37.54837], [-122.32155, 37.54836], [-122.32166, 37.54838], [-122.32176, 37.54843], [-122.32314, 37.54969]]]} | Open Access 1 | Borel Park | 16283 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.549 | Borel Park | 1961 | |
11107 | 11107 | 11106 | {"type": "Polygon", "coordinates": [[[-122.30777, 37.53501], [-122.30722, 37.53524], [-122.30688, 37.53471], [-122.30691, 37.53452], [-122.30676, 37.53429], [-122.30662, 37.53422], [-122.30713, 37.53401], [-122.30777, 37.53501]]]} | Open Access 1 | West Hillsdale | 27361 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1.56 | West Hillsdale | 1961 | |
9960 | 9960 | 9959 | {"type": "Polygon", "coordinates": [[[-121.96482, 37.34592], [-121.96334, 37.34593], [-121.96334, 37.34547], [-121.96482, 37.34547], [-121.96482, 37.34592]]]} | Open Access 1 | Steve Carli Park | 25839 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.631 | Steve Carli Park | 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 | |
9567 | 9567 | 9566 | {"type": "Polygon", "coordinates": [[[-122.00096, 37.33108], [-122.00082, 37.33125], [-122.00061, 37.3316], [-121.99998, 37.33135], [-121.99971, 37.33126], [-121.99986, 37.33096], [-121.99997, 37.33067], [-122.00051, 37.33078], [-122.00074, 37.33076], [-122.00096, 37.33108]]]} | Open Access 1 | Westwood Oaks Park | 27439 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.737 | Westwood Oaks 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 | |
6747 | 6747 | 6746 | {"type": "Polygon", "coordinates": [[[-122.08009, 37.35313], [-122.07973, 37.35313], [-122.07928, 37.35307], [-122.07906, 37.35307], [-122.079, 37.35305], [-122.07861, 37.35271], [-122.07861, 37.35243], [-122.08009, 37.35241], [-122.08009, 37.35313]]]} | Open Access 1 | Marymeade Park | 21938 | 1186 | Los Altos, City of 445 | City 2 | City Agency 2 | http://www.losaltosca.gov/parksites | City 2 | 2.228 | Marymeade 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]);