superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
63 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1973
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 63 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
747 | 747 | 746 | {"type": "Polygon", "coordinates": [[[-121.96249, 37.39315], [-121.96184, 37.39343], [-121.96118, 37.39246], [-121.96183, 37.39218], [-121.96249, 37.39315]]]} | Open Access 1 | Agnew Park | 15287 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1.999 | Agnew Park | 1973 | |
1433 | 1433 | 1432 | {"type": "Polygon", "coordinates": [[[-121.90435, 37.45781], [-121.90357, 37.45808], [-121.90341, 37.45809], [-121.9031, 37.45827], [-121.90308, 37.45825], [-121.90336, 37.45806], [-121.90247, 37.45707], [-121.90199, 37.45642], [-121.9025, 37.45622], [-121.90329, 37.45598], [-121.90435, 37.45781]]]} | Open Access 1 | Albert Augustine Park | 15337 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 6.109 | Albert Augustine Park | 1973 | |
1588 | 1588 | 1587 | {"type": "Polygon", "coordinates": [[[-121.93225, 37.50991], [-121.93204, 37.51012], [-121.93181, 37.51023], [-121.93159, 37.51028], [-121.93113, 37.51029], [-121.93086, 37.51035], [-121.93082, 37.51033], [-121.93058, 37.51007], [-121.9304, 37.50992], [-121.93017, 37.50976], [-121.92982, 37.50957], [-121.93049, 37.50885], [-121.93022, 37.50868], [-121.93039, 37.5085], [-121.9304, 37.50844], [-121.9304, 37.50839], [-121.93036, 37.50832], [-121.92988, 37.5079], [-121.92977, 37.50786], [-121.92968, 37.50787], [-121.92962, 37.50789], [-121.92919, 37.50748], [-121.92948, 37.50745], [-121.93084, 37.50722], [-121.93088, 37.50723], [-121.93101, 37.50771], [-121.93102, 37.50784], [-121.93101, 37.50803], [-121.93096, 37.50821], [-121.93089, 37.50837], [-121.9308, 37.5085], [-121.9306, 37.50873], [-121.93058, 37.50878], [-121.93055, 37.50884], [-121.93057, 37.50895], [-121.93061, 37.50899], [-121.93068, 37.50902], [-121.93075, 37.50901], [-121.93081, 37.50899], [-121.93086, 37.50891], [-121.93083, 37.50881], [-121.93083, 37.50876], [-121.93114, 37.50894], [-121.93204, 37.50965], [-121.93201, 37.50975], [-121.93225, 37.50991]]]} | Open Access 1 | Arroyo Agua Caliente Park | 15608 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 8.646 | Arroyo Agua Caliente Park | 1973 | |
1630 | 1630 | 1629 | {"type": "Polygon", "coordinates": [[[-122.03974, 37.52433], [-122.03781, 37.52499], [-122.03779, 37.52499], [-122.03778, 37.52488], [-122.03775, 37.52484], [-122.0377, 37.52481], [-122.03761, 37.52478], [-122.03747, 37.52481], [-122.03718, 37.52491], [-122.03694, 37.52445], [-122.03816, 37.52403], [-122.03938, 37.52364], [-122.03974, 37.52433]]]} | Open Access 1 | Ash Street Park | 15649 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 4.542 | Ash Street Park | 1973 | |
1635 | 1635 | 1634 | {"type": "Polygon", "coordinates": [[[-122.33929, 38.30424], [-122.33903, 38.30485], [-122.33905, 38.30487], [-122.33895, 38.30512], [-122.33886, 38.30508], [-122.33878, 38.30473], [-122.33867, 38.30465], [-122.3383, 38.30466], [-122.33834, 38.30486], [-122.33812, 38.30491], [-122.33806, 38.30453], [-122.33802, 38.30444], [-122.33792, 38.3043], [-122.33775, 38.3042], [-122.33756, 38.30416], [-122.3374, 38.30416], [-122.33716, 38.30428], [-122.33702, 38.30439], [-122.33695, 38.3044], [-122.33679, 38.30438], [-122.33644, 38.3044], [-122.33631, 38.30389], [-122.33659, 38.30418], [-122.33703, 38.30405], [-122.33784, 38.30373], [-122.33808, 38.30371], [-122.33808, 38.30369], [-122.33785, 38.30344], [-122.33792, 38.30341], [-122.33849, 38.30402], [-122.33929, 38.30424]]]} | Open Access 1 | Buhman Park | 16499 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 3.644 | Buhman Park | 1973 | |
1700 | 1700 | 1699 | {"type": "Polygon", "coordinates": [[[-121.99645, 37.5323], [-121.99529, 37.53248], [-121.99431, 37.53369], [-121.99277, 37.53289], [-121.99248, 37.53294], [-121.9924, 37.53304], [-121.992, 37.53283], [-121.99219, 37.5326], [-121.99241, 37.53271], [-121.99421, 37.53243], [-121.99502, 37.53145], [-121.99614, 37.53202], [-121.99626, 37.5321], [-121.99629, 37.5321], [-121.99638, 37.53219], [-121.99645, 37.5323]]]} | Open Access 1 | Azevada Park | 15739 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 7.838 | Azevada Park | 1973 | |
1947 | 1947 | 1946 | {"type": "Polygon", "coordinates": [[[-121.86868, 37.42908], [-121.86866, 37.42913], [-121.86821, 37.42913], [-121.86811, 37.42885], [-121.8678, 37.42872], [-121.86771, 37.429], [-121.86767, 37.429], [-121.86761, 37.42873], [-121.8668, 37.42894], [-121.86674, 37.42899], [-121.86671, 37.42896], [-121.86679, 37.42888], [-121.8667, 37.42863], [-121.86709, 37.42852], [-121.867, 37.42828], [-121.86694, 37.42825], [-121.86695, 37.42816], [-121.86677, 37.42764], [-121.86672, 37.42758], [-121.86679, 37.42751], [-121.86669, 37.42724], [-121.86671, 37.42721], [-121.86654, 37.42696], [-121.86649, 37.42693], [-121.86654, 37.42675], [-121.86654, 37.42662], [-121.86652, 37.42643], [-121.86653, 37.42632], [-121.86656, 37.4262], [-121.86664, 37.42605], [-121.86669, 37.42604], [-121.86701, 37.42607], [-121.86727, 37.42605], [-121.86761, 37.42702], [-121.86798, 37.42704], [-121.86794, 37.42709], [-121.86794, 37.42716], [-121.868, 37.42722], [-121.86807, 37.42725], [-121.86809, 37.42751], [-121.86819, 37.42778], [-121.86824, 37.42781], [-121.86823, 37.42789], [-121.86841, 37.42842], [-121.86847, 37.42849], [-121.86845, 37.42854], [-121.86863, 37.42905], [-121.86868, 37.42908]]]} | Open Access 1 | Ben Rogers Park | 16003 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 8.698 | Ben Rogers Park | 1973 | |
2025 | 2025 | 2024 | {"type": "Polygon", "coordinates": [[[-122.01802, 37.53174], [-122.0169, 37.53312], [-122.01436, 37.53181], [-122.01549, 37.53039], [-122.01802, 37.53174]]]} | Open Access 1 | Birch Grove Park | 16116 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 12.217 | Birch Grove Park | 1973 | |
2153 | 2153 | 2152 | {"type": "Polygon", "coordinates": [[[-121.92081, 37.47824], [-121.92042, 37.47893], [-121.91967, 37.47868], [-121.91913, 37.47883], [-121.91902, 37.47896], [-121.91873, 37.47891], [-121.91828, 37.47906], [-121.91812, 37.47926], [-121.91824, 37.47946], [-121.91842, 37.47985], [-121.9173, 37.48026], [-121.91631, 37.47851], [-121.91682, 37.47833], [-121.9171, 37.47884], [-121.91744, 37.47892], [-121.91786, 37.47879], [-121.91967, 37.47812], [-121.92003, 37.47831], [-121.92062, 37.47809], [-121.92078, 37.47818], [-121.92081, 37.47824]]]} | Open Access 1 | Booster Park | 16273 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 8.181 | Booster Park | 1973 | |
2196 | 2196 | 2195 | {"type": "Polygon", "coordinates": [[[-121.9766, 37.37015], [-121.97596, 37.37005], [-121.97532, 37.3699], [-121.97545, 37.36958], [-121.97534, 37.36894], [-121.97528, 37.36883], [-121.97562, 37.36873], [-121.97577, 37.36875], [-121.97588, 37.36871], [-121.97638, 37.36873], [-121.9766, 37.37015]]]} | Open Access 1 | Bracher Park | 16320 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 3.503 | Bracher Park | 1973 | |
2207 | 2207 | 2206 | {"type": "Polygon", "coordinates": [[[-121.90776, 37.25402], [-121.90738, 37.25423], [-121.90704, 37.25406], [-121.90677, 37.2541], [-121.90671, 37.25396], [-121.90667, 37.2539], [-121.90622, 37.2536], [-121.90607, 37.25347], [-121.90602, 37.25341], [-121.90597, 37.25326], [-121.90599, 37.25284], [-121.90585, 37.25248], [-121.90672, 37.25225], [-121.90776, 37.25402]]]} | Open Access 1 | Branham Park | 16332 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.925 | Branham Park | 1973 | |
2326 | 2326 | 2325 | {"type": "Polygon", "coordinates": [[[-122.43382, 37.61531], [-122.43349, 37.6156], [-122.43305, 37.61566], [-122.43269, 37.61549], [-122.43241, 37.61512], [-122.43206, 37.61487], [-122.43185, 37.61512], [-122.43161, 37.61504], [-122.4317, 37.61477], [-122.43161, 37.61395], [-122.43177, 37.61361], [-122.43184, 37.61353], [-122.43276, 37.61364], [-122.43352, 37.61354], [-122.43333, 37.61385], [-122.43326, 37.61435], [-122.43343, 37.61485], [-122.43382, 37.61531]]]} | Open Access 1 | Buckeye Park | 16473 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 7.476 | Buckeye Park | 1973 | |
2624 | 2624 | 2623 | {"type": "Polygon", "coordinates": [[[-121.88581, 37.44192], [-121.88306, 37.44251], [-121.88177, 37.43851], [-121.88258, 37.43834], [-121.88292, 37.43833], [-121.88319, 37.43838], [-121.88339, 37.43847], [-121.88461, 37.43821], [-121.88581, 37.44192]]]} | Open Access 1 | Cardoza Park | 16848 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 27.456 | Cardoza Park | 1973 | |
2796 | 2796 | 2795 | {"type": "Polygon", "coordinates": [[[-122.33567, 38.30958], [-122.33522, 38.30967], [-122.33532, 38.3104], [-122.33297, 38.31041], [-122.33211, 38.31037], [-122.33111, 38.31037], [-122.33107, 38.30984], [-122.33129, 38.30992], [-122.33245, 38.31017], [-122.33255, 38.31006], [-122.3326, 38.30993], [-122.33266, 38.30991], [-122.3329, 38.30995], [-122.33331, 38.31004], [-122.33364, 38.31009], [-122.33395, 38.31008], [-122.33429, 38.31003], [-122.33478, 38.30974], [-122.33469, 38.30948], [-122.33489, 38.30923], [-122.33483, 38.30889], [-122.33459, 38.30875], [-122.33448, 38.30854], [-122.33445, 38.30831], [-122.33403, 38.30832], [-122.33403, 38.30827], [-122.33444, 38.30822], [-122.33427, 38.30653], [-122.33403, 38.30651], [-122.33394, 38.30654], [-122.33387, 38.30664], [-122.33372, 38.30662], [-122.33366, 38.30649], [-122.33322, 38.30632], [-122.33315, 38.30584], [-122.33408, 38.30607], [-122.33445, 38.30621], [-122.3352, 38.30658], [-122.33547, 38.30668], [-122.33532, 38.30687], [-122.33535, 38.30714], [-122.3355, 38.30732], [-122.33546, 38.30744], [-122.33552, 38.30754], [-122.33567, 38.30958]]]} | Open Access 1 | Century Oaks Park | 17077 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 13.739 | Century Oaks Park | 1973 | |
2997 | 2997 | 2996 | {"type": "Polygon", "coordinates": [[[-122.03031, 37.53412], [-122.02993, 37.53459], [-122.02988, 37.5346], [-122.02984, 37.53453], [-122.02977, 37.53448], [-122.02963, 37.53446], [-122.0295, 37.5345], [-122.02943, 37.53457], [-122.02943, 37.5346], [-122.02944, 37.53463], [-122.0294, 37.53463], [-122.02782, 37.53381], [-122.02842, 37.5331], [-122.02931, 37.53356], [-122.0293, 37.53361], [-122.03031, 37.53412]]]} | Open Access 1 | Civic Center Park | 17361 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 4.391 | Civic Ctr. Park | 1973 | |
3308 | 3308 | 3307 | {"type": "Polygon", "coordinates": [[[-121.8818, 37.42393], [-121.88153, 37.42402], [-121.88146, 37.42415], [-121.88135, 37.42414], [-121.88138, 37.42376], [-121.88118, 37.42355], [-121.8811, 37.42354], [-121.88107, 37.42348], [-121.88065, 37.42301], [-121.88054, 37.42298], [-121.88033, 37.42275], [-121.88002, 37.42252], [-121.87991, 37.42253], [-121.87984, 37.4224], [-121.8798, 37.42217], [-121.88001, 37.42207], [-121.88004, 37.42211], [-121.88011, 37.42213], [-121.88022, 37.42212], [-121.88027, 37.42208], [-121.8803, 37.42205], [-121.8803, 37.42199], [-121.88028, 37.42195], [-121.88051, 37.42183], [-121.8808, 37.42184], [-121.8808, 37.42188], [-121.88084, 37.42194], [-121.8809, 37.42197], [-121.88095, 37.42198], [-121.88102, 37.42197], [-121.88108, 37.42193], [-121.88115, 37.42196], [-121.88151, 37.42189], [-121.88161, 37.42223], [-121.88136, 37.4225], [-121.88158, 37.42322], [-121.88168, 37.42327], [-121.88167, 37.42335], [-121.88172, 37.42342], [-121.88166, 37.42347], [-121.8818, 37.42393]]]} | Open Access 1 | Creighton Park | 17790 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 5.066 | Creighton Park | 1973 | |
3333 | 3333 | 3332 | {"type": "Polygon", "coordinates": [[[-122.24787, 37.52556], [-122.24764, 37.52556], [-122.24737, 37.52561], [-122.24712, 37.52573], [-122.24692, 37.52589], [-122.24683, 37.526], [-122.24678, 37.5261], [-122.24609, 37.52759], [-122.24642, 37.52771], [-122.24643, 37.52775], [-122.246, 37.52784], [-122.24583, 37.52772], [-122.246, 37.5275], [-122.24612, 37.52732], [-122.24622, 37.52709], [-122.24632, 37.52674], [-122.2464, 37.52653], [-122.24692, 37.52562], [-122.24707, 37.52552], [-122.24725, 37.52548], [-122.2478, 37.52546], [-122.24787, 37.52556]]]} | Open Access 1 | Cringle Park | 17821 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1.21 | Cringle Park | 1973 | |
3777 | 3777 | 3776 | {"type": "Polygon", "coordinates": [[[-121.99345, 37.34515], [-121.99312, 37.3453], [-121.99136, 37.34629], [-121.99125, 37.34633], [-121.99079, 37.34645], [-121.99029, 37.34667], [-121.99012, 37.3468], [-121.98981, 37.34711], [-121.98982, 37.3452], [-121.99311, 37.34513], [-121.99345, 37.34515]]]} | Open Access 1 | Earl R. Carmichael Park | 18352 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 8.11 | Earl R. Carmichael Park | 1973 | |
3806 | 3806 | 3805 | {"type": "Polygon", "coordinates": [[[-122.27117, 37.45741], [-122.27093, 37.45788], [-122.2699, 37.45761], [-122.26964, 37.45805], [-122.26951, 37.458], [-122.2692, 37.45781], [-122.26859, 37.45752], [-122.26856, 37.45745], [-122.26881, 37.45705], [-122.26888, 37.45692], [-122.26896, 37.45657], [-122.26895, 37.45638], [-122.27054, 37.45589], [-122.27063, 37.45594], [-122.27091, 37.45618], [-122.27094, 37.45622], [-122.27101, 37.4568], [-122.271, 37.45689], [-122.27096, 37.45703], [-122.27095, 37.45711], [-122.27099, 37.45722], [-122.27117, 37.45741]]]} | Open Access 1 | Easter Bowl | 18390 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 8.866 | Easter Bowl | 1973 | |
3920 | 3920 | 3919 | {"type": "Polygon", "coordinates": [[[-122.00048, 37.28115], [-121.99895, 37.28263], [-121.99808, 37.28248], [-121.99763, 37.28235], [-121.99816, 37.28112], [-122.00037, 37.28108], [-122.00048, 37.28115]]]} | Open Access 1 | El Quito Park | 18533 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 6.63 | El Quito Park | 1973 |
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]);