units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where DES_TP = 2 and YR_EST = 1974
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, MNG_AG_LEV
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 | |
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 | |
9572 | 9572 | 9571 | {"type": "MultiPolygon", "coordinates": [[[[-122.5528, 38.02733], [-122.55283, 38.02772], [-122.55281, 38.02793], [-122.55269, 38.02823], [-122.55228, 38.02886], [-122.55218, 38.02913], [-122.55215, 38.02925], [-122.55202, 38.03069], [-122.55157, 38.03069], [-122.55123, 38.03073], [-122.55098, 38.03081], [-122.55055, 38.03098], [-122.55054, 38.03099], [-122.55071, 38.03126], [-122.55066, 38.03128], [-122.55048, 38.031], [-122.54987, 38.03125], [-122.54942, 38.03139], [-122.54897, 38.03149], [-122.54855, 38.03153], [-122.54825, 38.03154], [-122.54803, 38.03152], [-122.54764, 38.03145], [-122.54735, 38.03135], [-122.54672, 38.03108], [-122.54609, 38.03102], [-122.54569, 38.03116], [-122.54519, 38.03106], [-122.54536, 38.03055], [-122.54584, 38.03079], [-122.54608, 38.03063], [-122.54756, 38.03106], [-122.54796, 38.03081], [-122.54837, 38.0308], [-122.54872, 38.03092], [-122.54932, 38.0307], [-122.5496, 38.03025], [-122.55055, 38.0305], [-122.55082, 38.03019], [-122.55155, 38.02907], [-122.55154, 38.02905], [-122.55105, 38.02888], [-122.55091, 38.02909], [-122.55078, 38.02922], [-122.55059, 38.02935], [-122.55031, 38.0295], [-122.54999, 38.0296], [-122.54965, 38.02966], [-122.54948, 38.02967], [-122.54915, 38.02966], [-122.54704, 38.02934], [-122.54694, 38.02931], [-122.54676, 38.02922], [-122.54661, 38.02909], [-122.54682, 38.0289], [-122.54669, 38.0286], [-122.547, 38.0283], [-122.54719, 38.02803], [-122.5477, 38.0283], [-122.54775, 38.02819], [-122.54786, 38.02808], [-122.54796, 38.028], [-122.54816, 38.02791], [-122.54828, 38.02779], [-122.54837, 38.0278], [-122.54831, 38.02782], [-122.54817, 38.02794], [-122.54801, 38.02801], [-122.54791, 38.02806], [-122.54779, 38.02818], [-122.5478, 38.02822], [-122.54817, 38.02822], [-122.5482, 38.02825], [-122.54881, 38.02825], [-122.54884, 38.02819], [-122.54908, 38.0282], [-122.5493, 38.02816], [-122.5493, 38.02809], [-122.54948, 38.02808], [-122.5496, 38.02813], [-122.55028, 38.02812], [-122.55088, 38.02818], [-122.55139, 38.02811], [-122.55155, 38.0274], [-122.55164, 38.02717], [-122.55257, 38.02716], [-122.55272, 38.02722], [-122.55276, 38.02726], [-122.5528, 38.02733]]], [[[-122.55368, 38.02774], [-122.55368, 38.02777], [-122.55327, 38.02776], [-122.55326, 38.02772], [-122.55368, 38.02774]]]]} | Open Access 1 | 16097 | Las Gallinas Park | 21053 | 2074 | Marinwood Community Service District 916 | Special District 4 | Community Services District 19 | http://www.marinwood.org/ | Special District 4 | 2074 | Marinwood Community Service District 890 | Special District 4 | Community Services District 17 | Marin 23 | 31.224 | Las Gallinas 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 |
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]);