units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1974
This data as json, copyable, CSV (advanced)
MNG_AGENCY 8
DES_TP 4
- Local Park 10
- Local Recreation Area 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 13 ✖
ACCESS_TYP 1
- Open Access · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
396 | 396 | 395 | {"type": "Polygon", "coordinates": [[[-122.13963, 37.41148], [-122.13861, 37.41094], [-122.13867, 37.41065], [-122.1386, 37.41047], [-122.13841, 37.41035], [-122.13814, 37.41004], [-122.13828, 37.40965], [-122.13811, 37.40928], [-122.13786, 37.40907], [-122.13807, 37.40875], [-122.13818, 37.40851], [-122.13834, 37.40845], [-122.13963, 37.41148]]]} | Open Access 1 | 1442 | Bol Park | 16235 | 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 | 4.248 | Bol Park | 1974 | Local Park 2 | 4 | |
4268 | 4268 | 4267 | {"type": "Polygon", "coordinates": [[[-122.44874, 37.62685], [-122.44841, 37.6272], [-122.44823, 37.6268], [-122.4477, 37.62634], [-122.44807, 37.62618], [-122.44836, 37.62653], [-122.44874, 37.62685]]]} | Open Access 1 | 14398 | Fleetwood Park | 18941 | 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 | 0.866 | Fleetwood Park | 1974 | Local Park 2 | 4 | |
5288 | 5288 | 5287 | {"type": "Polygon", "coordinates": [[[-122.11692, 37.40842], [-122.1165, 37.40846], [-122.11652, 37.40809], [-122.11656, 37.40805], [-122.11627, 37.40786], [-122.11635, 37.40778], [-122.1164, 37.40776], [-122.11644, 37.40777], [-122.11701, 37.40812], [-122.11702, 37.40816], [-122.11694, 37.40829], [-122.11692, 37.40842]]]} | Open Access 1 | 15201 | Monroe Mini Park | 22373 | 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 | 0.62 | Monroe MP | 1974 | Local Park 2 | 4 | |
8115 | 8115 | 8114 | {"type": "Polygon", "coordinates": [[[-122.18962, 37.88398], [-122.18927, 37.88429], [-122.18879, 37.88445], [-122.18807, 37.88401], [-122.18712, 37.88449], [-122.18675, 37.88522], [-122.18641, 37.88597], [-122.18606, 37.88627], [-122.18561, 37.8862], [-122.1852, 37.8858], [-122.18579, 37.88491], [-122.18655, 37.88397], [-122.18742, 37.8835], [-122.18801, 37.88341], [-122.18866, 37.88312], [-122.18962, 37.88398]]]} | Open Access 1 | 12250 | Orinda Community Center Park | 23202 | 1235 | Orinda, City of 392 | City 2 | City Agency 2 | http://www.cityoforinda.org/index.asp?Type=B_BASIC&SEC={DF30AA31-A638-4650-A63E-8E4033089DBE} | City 2 | 1235 | Orinda, City of 386 | City 2 | City Agency 2 | Contra Costa 12 | 10.574 | Orinda Community Ctr. Park | 1974 | Local Recreation Area 3 | 4 | |
8654 | 8654 | 8653 | {"type": "Polygon", "coordinates": [[[-122.24791, 37.53233], [-122.2468, 37.53333], [-122.24683, 37.53337], [-122.24595, 37.53412], [-122.24595, 37.53416], [-122.24589, 37.53417], [-122.24573, 37.53405], [-122.24778, 37.53226], [-122.24781, 37.53226], [-122.24791, 37.53233]]]} | Open Access 1 | 13878 | Davit Lane | 17956 | 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 | 1.162 | Davit Lane | 1974 | None 726 | ||
8665 | 8665 | 8664 | {"type": "Polygon", "coordinates": [[[-122.24241, 37.53659], [-122.24239, 37.53664], [-122.24214, 37.5369], [-122.24187, 37.53715], [-122.24181, 37.53718], [-122.24168, 37.5372], [-122.24161, 37.53724], [-122.24156, 37.53729], [-122.24156, 37.53736], [-122.24134, 37.5374], [-122.24098, 37.53713], [-122.24188, 37.53635], [-122.24196, 37.53636], [-122.24205, 37.53634], [-122.24211, 37.53636], [-122.24238, 37.53655], [-122.24241, 37.53659]]]} | Open Access 1 | 13931 | Shannon Park | 25360 | 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 | 1.77 | Shannon Park | 1974 | Local Park 2 | 4 | |
8669 | 8669 | 8668 | {"type": "Polygon", "coordinates": [[[-122.23881, 37.53899], [-122.23746, 37.53876], [-122.23707, 37.53889], [-122.23682, 37.53884], [-122.2371, 37.53795], [-122.23697, 37.53794], [-122.23626, 37.53759], [-122.23606, 37.53782], [-122.2354, 37.53759], [-122.23545, 37.53737], [-122.23545, 37.53734], [-122.23542, 37.53732], [-122.23522, 37.53721], [-122.23572, 37.53671], [-122.23579, 37.53669], [-122.23616, 37.5369], [-122.23636, 37.53704], [-122.23649, 37.53715], [-122.23655, 37.53725], [-122.23661, 37.5373], [-122.23668, 37.53733], [-122.23675, 37.53733], [-122.23689, 37.53729], [-122.23767, 37.5379], [-122.23872, 37.53809], [-122.2387, 37.53829], [-122.23872, 37.53874], [-122.23874, 37.53887], [-122.23881, 37.53899]]]} | Open Access 1 | 13943 | Sandpiper Park | 25020 | 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 | 7.126 | Sandpiper Park | 1974 | Local Park 2 | 4 | |
8818 | 8818 | 8817 | {"type": "Polygon", "coordinates": [[[-122.45546, 37.62882], [-122.45529, 37.63015], [-122.45423, 37.63029], [-122.45384, 37.62946], [-122.45378, 37.62906], [-122.45394, 37.62874], [-122.45546, 37.62882]]]} | Open Access 1 | 14372 | Pacific Heights Park | 23300 | 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 | 5.044 | Pacific Heights Park | 1974 | Local Park 2 | 4 | |
8823 | 8823 | 8822 | {"type": "Polygon", "coordinates": [[[-122.42713, 37.63088], [-122.42488, 37.63158], [-122.42457, 37.63098], [-122.42672, 37.63018], [-122.42713, 37.63088]]]} | Open Access 1 | 14380 | Commodore Park | 17559 | 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 | 4.115 | Commodore Park | 1974 | Local Park 2 | 4 | |
8872 | 8872 | 8871 | {"type": "Polygon", "coordinates": [[[-122.3304, 38.32125], [-122.32953, 38.32172], [-122.32925, 38.32138], [-122.32925, 38.32131], [-122.32923, 38.32126], [-122.32918, 38.32123], [-122.3291, 38.3212], [-122.3288, 38.32085], [-122.32958, 38.32041], [-122.3304, 38.32125]]]} | Open Access 1 | 14498 | Dry Creek Park | 18281 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.513 | Dry Creek Park | 1974 | Local Park 2 | 4 | |
9335 | 9335 | 9334 | {"type": "Polygon", "coordinates": [[[-122.1983, 37.42177], [-122.19813, 37.42169], [-122.19708, 37.42144], [-122.19716, 37.42104], [-122.1972, 37.42101], [-122.19752, 37.42095], [-122.19785, 37.42085], [-122.1979, 37.42086], [-122.19796, 37.42094], [-122.19809, 37.4212], [-122.1983, 37.42177]]]} | Open Access 1 | 15564 | Stanford Hills Park | 25787 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 1.539 | Stanford Hills Park | 1974 | Local Park 2 | 4 | |
9651 | 9651 | 9650 | {"type": "Polygon", "coordinates": [[[-122.36032, 37.59115], [-122.35988, 37.59164], [-122.35974, 37.59171], [-122.3578, 37.59173], [-122.35782, 37.59125], [-122.35678, 37.59083], [-122.35618, 37.59173], [-122.35152, 37.59176], [-122.35152, 37.59161], [-122.35171, 37.59164], [-122.35171, 37.59025], [-122.35152, 37.59006], [-122.35152, 37.58901], [-122.33844, 37.58823], [-122.33845, 37.58716], [-122.35329, 37.5875], [-122.35395, 37.58769], [-122.35476, 37.58796], [-122.35556, 37.58826], [-122.35633, 37.58859], [-122.35643, 37.5886], [-122.35708, 37.58878], [-122.35775, 37.5887], [-122.35857, 37.58896], [-122.35973, 37.58963], [-122.36028, 37.59002], [-122.36039, 37.59014], [-122.36047, 37.5903], [-122.36049, 37.59047], [-122.36046, 37.5906], [-122.36024, 37.59109], [-122.36032, 37.59115]]]} | Open Access 1 | 16271 | Burlingame Lagoon Park | 16524 | 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 | 109.714 | Burlingame Lagoon Park | 1974 | Local Park 2 | 4 | |
16532 | 16532 | 16531 | {"type": "Polygon", "coordinates": [[[-122.12131, 36.99905], [-122.12095, 36.99935], [-122.12072, 36.99916], [-122.12107, 36.99886], [-122.12131, 36.99905]]]} | Open Access 1 | 1870 | Wilder Ranch State Park | 27506 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=549 | Santa Cruz 5 | 0.336 | Wilder Ranch SP | 1974 | None 1411 |
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]);