units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 1977
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
2016 | 2016 | 2015 | {"type": "Polygon", "coordinates": [[[-122.45998, 37.69444], [-122.45997, 37.69606], [-122.45929, 37.69615], [-122.4594, 37.69697], [-122.45881, 37.69702], [-122.45876, 37.69737], [-122.45633, 37.6972], [-122.45644, 37.69551], [-122.45705, 37.69542], [-122.45816, 37.69609], [-122.4592, 37.69552], [-122.45914, 37.69444], [-122.45998, 37.69444]]]} | Open Access 1 | 16956 | Hillside Park | 19980 | 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 | 13.991 | Hillside Park | 1977 | Local Park 2 | 4 | |
5781 | 5781 | 5780 | {"type": "MultiPolygon", "coordinates": [[[[-121.80741, 37.17115], [-121.80285, 37.17191], [-121.79887, 37.17199], [-121.79722, 37.17205], [-121.79728, 37.1727], [-121.79736, 37.17316], [-121.78788, 37.17503], [-121.7893, 37.17799], [-121.79494, 37.17797], [-121.79605, 37.18286], [-121.79617, 37.18353], [-121.79629, 37.18479], [-121.79633, 37.18496], [-121.7964, 37.1851], [-121.7962, 37.18495], [-121.79607, 37.18431], [-121.7958, 37.18378], [-121.79436, 37.1843], [-121.79508, 37.18557], [-121.79575, 37.18532], [-121.79662, 37.18563], [-121.79646, 37.18632], [-121.79682, 37.18686], [-121.79728, 37.18677], [-121.7974, 37.18695], [-121.79626, 37.18738], [-121.79592, 37.18737], [-121.79591, 37.18738], [-121.79601, 37.18743], [-121.7936, 37.18804], [-121.78948, 37.18799], [-121.78441, 37.18813], [-121.78435, 37.18834], [-121.77815, 37.18935], [-121.77689, 37.19008], [-121.77598, 37.18908], [-121.77558, 37.18925], [-121.77487, 37.18905], [-121.77352, 37.18889], [-121.77271, 37.18868], [-121.77205, 37.18841], [-121.77138, 37.18805], [-121.77089, 37.18757], [-121.77041, 37.18722], [-121.76982, 37.18699], [-121.7694, 37.18663], [-121.76883, 37.18636], [-121.76749, 37.18612], [-121.76591, 37.18769], [-121.76547, 37.19018], [-121.75932, 37.1849], [-121.75986, 37.18469], [-121.75987, 37.18468], [-121.75939, 37.18475], [-121.75391, 37.17994], [-121.75339, 37.17942], [-121.75147, 37.17778], [-121.7528, 37.17709], [-121.7528, 37.17707], [-121.75238, 37.177], [-121.75302, 37.17608], [-121.75434, 37.17605], [-121.7547, 37.17614], [-121.75783, 37.17451], [-121.75786, 37.17447], [-121.75908, 37.17381], [-121.75902, 37.17337], [-121.75887, 37.17268], [-121.75865, 37.17212], [-121.75844, 37.17189], [-121.75839, 37.17168], [-121.75829, 37.17154], [-121.75843, 37.17149], [-121.75844, 37.17148], [-121.75739, 37.17002], [-121.75693, 37.16794], [-121.7569, 37.16485], [-121.7571, 37.16463], [-121.75749, 37.16388], [-121.7586, 37.16306], [-121.75836, 37.16284], [-121.75875, 37.16269], [-121.75928, 37.16264], [-121.76032, 37.16276], [-121.76084, 37.16112], [-121.75966, 37.15731], [-121.75946, 37.15714], [-121.75814, 37.15585], [-121.75693, 37.15576], [-121.75636, 37.1547], [-121.756, 37.15396], [-121.75516, 37.15293], [-121.76061, 37.15263], [-121.7606, 37.15205], [-121.76101, 37.15178], [-121.76132, 37.15137], [-121.76206, 37.15031], [-121.76223, 37.15014], [-121.7624, 37.15001], [-121.76278, 37.14977], [-121.76303, 37.14965], [-121.76326, 37.14958], [-121.76365, 37.14949], [-121.76382, 37.14944], [-121.76406, 37.14932], [-121.76494, 37.14909], [-121.76519, 37.14899], [-121.7656, 37.14877], [-121.7665, 37.14846], [-121.767, 37.14835], [-121.76715, 37.14835], [-121.76772, 37.14851], [-121.768, 37.14857], [-121.76835, 37.14859], [-121.76979, 37.14858], [-121.77065, 37.14846], [-121.77096, 37.14844], [-121.77193, 37.14852], [-121.77212, 37.14846], [-121.77255, 37.1482], [-121.77276, 37.14813], [-121.77298, 37.14812], [-121.77367, 37.1482], [-121.77394, 37.14819], [-121.77406, 37.14815], [-121.77435, 37.14796], [-121.77472, 37.14779], [-121.78247, 37.14947], [-121.78446, 37.15094], [-121.78459, 37.15092], [-121.78478, 37.15092], [-121.78501, 37.15079], [-121.78511, 37.15076], [-121.78566, 37.15061], [-121.78604, 37.15061], [-121.78625, 37.15065], [-121.78641, 37.15071], [-121.78651, 37.15071], [-121.78666, 37.15069], [-121.78672, 37.15918], [-121.79063, 37.1586], [-121.79387, 37.15983], [-121.79367, 37.1625], [-121.79586, 37.16251], [-121.79691, 37.1642], [-121.80259, 37.16407], [-121.80276, 37.16935], [-121.80724, 37.16821], [-121.80741, 37.17115]]], [[[-121.76811, 37.14836], [-121.76806, 37.14852], [-121.76774, 37.14845], [-121.76716, 37.1483], [-121.76699, 37.1483], [-121.76647, 37.1484], [-121.76557, 37.14872], [-121.76516, 37.14894], [-121.76491, 37.14903], [-121.76404, 37.14927], [-121.76379, 37.14939], [-121.76362, 37.14944], [-121.76324, 37.14953], [-121.763, 37.1496], [-121.76274, 37.14972], [-121.76236, 37.14997], [-121.76218, 37.1501], [-121.762, 37.15028], [-121.76167, 37.15074], [-121.76209, 37.14994], [-121.76476, 37.14815], [-121.76645, 37.14803], [-121.76775, 37.14833], [-121.76793, 37.14835], [-121.76811, 37.14836]]], [[[-121.79714, 37.18572], [-121.79713, 37.18573], [-121.79691, 37.18562], [-121.79674, 37.18545], [-121.79689, 37.18547], [-121.79714, 37.18572]]]]} | Open Access 1 | 7 | Calero County Park | 11893 | 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 | http://www.sccgov.org/sites/parks/parkfinder/Pages/Calero.aspx | Santa Clara 19 | 3487.484 | Calero County Park | 1977 | Local Park 2 | 4 |
8787 | 8787 | 8786 | {"type": "Polygon", "coordinates": [[[-122.40918, 37.59933], [-122.40913, 37.5994], [-122.4085, 37.59926], [-122.40864, 37.59886], [-122.40894, 37.59893], [-122.40893, 37.59904], [-122.40903, 37.59922], [-122.40907, 37.59925], [-122.40917, 37.59926], [-122.40918, 37.59933]]]} | Open Access 1 | 14293 | Bill Mitchell Lions Park | 16107 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/lion-bill-mitchell-park | San Mateo 15 | 0.477 | Bill Mitchell Lions Park | 1977 | Local Park 2 | 4 |
8859 | 8859 | 8858 | {"type": "Polygon", "coordinates": [[[-122.31425, 38.29491], [-122.31317, 38.29529], [-122.31275, 38.29453], [-122.31383, 38.29416], [-122.31425, 38.29491]]]} | Open Access 1 | 14485 | Laurel Park | 21104 | 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.342 | Laurel Park | 1977 | Local Park 2 | 4 | |
8860 | 8860 | 8859 | {"type": "Polygon", "coordinates": [[[-122.35256, 38.30267], [-122.35256, 38.30309], [-122.35243, 38.30311], [-122.35241, 38.30324], [-122.352, 38.30336], [-122.35131, 38.30326], [-122.35116, 38.30326], [-122.35036, 38.30355], [-122.3502, 38.30354], [-122.35002, 38.30343], [-122.34981, 38.30363], [-122.34967, 38.3037], [-122.34938, 38.30378], [-122.34928, 38.30375], [-122.34926, 38.3038], [-122.34877, 38.30371], [-122.34864, 38.30365], [-122.34856, 38.30368], [-122.34808, 38.30347], [-122.34813, 38.30339], [-122.34825, 38.30346], [-122.34842, 38.30351], [-122.34861, 38.30356], [-122.34899, 38.30361], [-122.34922, 38.30359], [-122.34936, 38.30355], [-122.34951, 38.30348], [-122.34967, 38.30338], [-122.34959, 38.30328], [-122.35044, 38.30295], [-122.35022, 38.3025], [-122.35129, 38.30192], [-122.35075, 38.3014], [-122.34988, 38.30078], [-122.34892, 38.30023], [-122.34864, 38.30025], [-122.34876, 38.30005], [-122.35003, 38.29971], [-122.35073, 38.29969], [-122.35189, 38.29978], [-122.35178, 38.30006], [-122.35057, 38.3005], [-122.35256, 38.30267]]]} | Open Access 1 | 14486 | Timber Hill Park | 26368 | 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 | 14.691 | Timber Hill Park | 1977 | Local Park 2 | 4 | |
9041 | 9041 | 9040 | {"type": "Polygon", "coordinates": [[[-121.89776, 37.45803], [-121.8975, 37.45832], [-121.8973, 37.4589], [-121.89716, 37.45941], [-121.89604, 37.45917], [-121.89599, 37.45904], [-121.89613, 37.45902], [-121.89668, 37.45912], [-121.8967, 37.45902], [-121.89625, 37.45894], [-121.89636, 37.45886], [-121.89644, 37.45877], [-121.89643, 37.45861], [-121.89639, 37.45854], [-121.89631, 37.45851], [-121.89625, 37.45853], [-121.89615, 37.45862], [-121.89604, 37.4585], [-121.89608, 37.4584], [-121.89617, 37.45826], [-121.89629, 37.45813], [-121.89643, 37.45802], [-121.89725, 37.45755], [-121.8973, 37.45754], [-121.89736, 37.45757], [-121.89776, 37.45803]]]} | Open Access 1 | 14965 | Higuera Adobe Park | 19954 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 4.369 | Higuera Adobe Park | 1977 | Local Park 2 | 4 | |
9336 | 9336 | 9335 | {"type": "Polygon", "coordinates": [[[-122.41374, 37.70263], [-122.41365, 37.70283], [-122.41296, 37.70283], [-122.413, 37.70307], [-122.41298, 37.70324], [-122.41292, 37.70342], [-122.41281, 37.70358], [-122.41189, 37.70309], [-122.41234, 37.70208], [-122.41268, 37.70218], [-122.41267, 37.70221], [-122.41281, 37.70225], [-122.41309, 37.70201], [-122.41335, 37.70208], [-122.41318, 37.70247], [-122.41374, 37.70263]]]} | Open Access 1 | 15602 | David Rowe Park | 17944 | 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 | 3.507 | David Rowe Park | 1977 | Local Park 2 | 4 | |
9370 | 9370 | 9369 | {"type": "Polygon", "coordinates": [[[-121.83805, 37.30715], [-121.83802, 37.30722], [-121.83797, 37.30729], [-121.83797, 37.30749], [-121.83793, 37.30755], [-121.83786, 37.30756], [-121.83775, 37.30754], [-121.83748, 37.3067], [-121.83743, 37.30651], [-121.83768, 37.30643], [-121.83774, 37.30646], [-121.83778, 37.30649], [-121.83781, 37.3066], [-121.83791, 37.30676], [-121.83795, 37.30691], [-121.83801, 37.30703], [-121.83805, 37.30715]]]} | Open Access 1 | 15653 | Stonegate Park | 25887 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.944 | Stonegate Park | 1977 | Local Park 2 | 4 | |
9863 | 9863 | 9862 | {"type": "MultiPolygon", "coordinates": [[[[-122.15302, 37.6263], [-122.15283, 37.62659], [-122.1515, 37.6266], [-122.14838, 37.62665], [-122.14826, 37.62667], [-122.14763, 37.62687], [-122.14728, 37.62691], [-122.14546, 37.62688], [-122.14478, 37.62685], [-122.14441, 37.62681], [-122.144, 37.6268], [-122.14248, 37.62687], [-122.14139, 37.62687], [-122.14047, 37.62683], [-122.14027, 37.6268], [-122.13998, 37.62671], [-122.13982, 37.62673], [-122.13956, 37.62689], [-122.13937, 37.62323], [-122.13707, 37.62323], [-122.13704, 37.6234], [-122.13625, 37.62359], [-122.13581, 37.62359], [-122.13521, 37.62378], [-122.13519, 37.62365], [-122.13545, 37.623], [-122.13965, 37.6221], [-122.14706, 37.62481], [-122.14837, 37.62508], [-122.14973, 37.62515], [-122.1508, 37.62499], [-122.15138, 37.62484], [-122.15259, 37.62462], [-122.15302, 37.6263]]], [[[-122.14879, 37.65606], [-122.14479, 37.65609], [-122.14396, 37.65627], [-122.14392, 37.65609], [-122.14392, 37.65591], [-122.14433, 37.64981], [-122.14879, 37.65606]]], [[[-122.16185, 37.6312], [-122.16174, 37.64456], [-122.16171, 37.65587], [-122.16161, 37.65596], [-122.15072, 37.65604], [-122.15069, 37.65593], [-122.15098, 37.65355], [-122.14947, 37.65148], [-122.15252, 37.65117], [-122.15483, 37.65108], [-122.15483, 37.65097], [-122.15538, 37.65153], [-122.15604, 37.65308], [-122.15606, 37.65308], [-122.15555, 37.65077], [-122.15547, 37.65072], [-122.15521, 37.64933], [-122.15539, 37.64918], [-122.15538, 37.64917], [-122.15521, 37.64913], [-122.15538, 37.64891], [-122.15541, 37.64883], [-122.15518, 37.64882], [-122.15504, 37.64871], [-122.15489, 37.64814], [-122.15466, 37.64699], [-122.15488, 37.6468], [-122.15488, 37.64676], [-122.15469, 37.64672], [-122.1544, 37.64599], [-122.15437, 37.64555], [-122.15426, 37.64537], [-122.15389, 37.64384], [-122.1538, 37.64376], [-122.15348, 37.6423], [-122.15368, 37.64213], [-122.15367, 37.64208], [-122.15349, 37.64195], [-122.15351, 37.64192], [-122.15381, 37.64187], [-122.1539, 37.64184], [-122.15408, 37.64173], [-122.15408, 37.64167], [-122.15511, 37.64162], [-122.15521, 37.63118], [-122.16185, 37.6312]]]]} | Open Access 1 | 16897 | Hayward Shoreline | 4363 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 595.87 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
10324 | 10324 | 10323 | {"type": "Polygon", "coordinates": [[[-121.84268, 37.39519], [-121.84107, 37.39567], [-121.84011, 37.39362], [-121.84086, 37.3934], [-121.84087, 37.39345], [-121.84081, 37.39352], [-121.84081, 37.39354], [-121.84075, 37.39357], [-121.84085, 37.39377], [-121.84055, 37.39387], [-121.84076, 37.39423], [-121.84078, 37.39423], [-121.84081, 37.39428], [-121.84087, 37.39429], [-121.84088, 37.3943], [-121.84132, 37.39431], [-121.84133, 37.39423], [-121.84138, 37.39422], [-121.84139, 37.39416], [-121.8413, 37.39415], [-121.8413, 37.39412], [-121.84128, 37.39411], [-121.84131, 37.39393], [-121.84129, 37.39388], [-121.84138, 37.39379], [-121.84143, 37.39382], [-121.84142, 37.39383], [-121.84144, 37.39386], [-121.84183, 37.39376], [-121.84182, 37.39372], [-121.84192, 37.39368], [-121.84238, 37.39469], [-121.84248, 37.39476], [-121.84268, 37.39519]]]} | Open Access 1 | 18216 | Noble Park | 22780 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 6.855 | Noble Park | 1977 | Local Park 2 | 4 | |
10395 | 10395 | 10394 | {"type": "Polygon", "coordinates": [[[-121.85742, 37.36514], [-121.85473, 37.36697], [-121.85203, 37.36421], [-121.85465, 37.36245], [-121.85472, 37.36244], [-121.85742, 37.36514]]]} | Open Access 1 | 18374 | Overfelt Botanical Gardens | 23270 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 29.813 | Overfelt Botanical Gardens | 1977 | 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]);