superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 347
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5155 | 5155 | 5154 | {"type": "Polygon", "coordinates": [[[-121.77661, 37.99122], [-121.77629, 37.99133], [-121.77607, 37.99207], [-121.77573, 37.99262], [-121.77594, 37.99276], [-121.77592, 37.99281], [-121.77593, 37.99287], [-121.77596, 37.99291], [-121.77603, 37.99294], [-121.77559, 37.99398], [-121.77434, 37.99372], [-121.77393, 37.99359], [-121.77467, 37.99252], [-121.77464, 37.99096], [-121.77427, 37.99091], [-121.77428, 37.99081], [-121.77468, 37.99081], [-121.77471, 37.98988], [-121.77471, 37.98962], [-121.7749, 37.98916], [-121.77506, 37.98908], [-121.77506, 37.98869], [-121.77601, 37.98869], [-121.77602, 37.98917], [-121.77599, 37.9893], [-121.77628, 37.98947], [-121.77626, 37.98951], [-121.77626, 37.98955], [-121.77593, 37.98966], [-121.77587, 37.99028], [-121.77589, 37.99048], [-121.77608, 37.99087], [-121.77645, 37.99087], [-121.77658, 37.99111], [-121.77661, 37.99122]]]} | Open Access 1 | Hillcrest Park | 19968 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 17.525 | Hillcrest Park | ||
5462 | 5462 | 5461 | {"type": "Polygon", "coordinates": [[[-121.78692, 38.00858], [-121.78687, 38.00878], [-121.78677, 38.0088], [-121.78661, 38.00949], [-121.78662, 38.0095], [-121.78665, 38.0095], [-121.78658, 38.00977], [-121.78609, 38.00977], [-121.78643, 38.00858], [-121.78692, 38.00858]]]} | Open Access 1 | Jacobsen Park | 20332 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1.293 | Jacobsen Park | ||
5592 | 5592 | 5591 | {"type": "Polygon", "coordinates": [[[-121.85047, 38.00036], [-121.84999, 38.00162], [-121.84848, 38.00125], [-121.84896, 38.0], [-121.85047, 38.00036]]]} | Open Access 1 | Marchetti Park | 21795 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 4.992 | Marchetti Park | ||
5763 | 5763 | 5762 | {"type": "Polygon", "coordinates": [[[-121.76517, 37.9663], [-121.76408, 37.96617], [-121.76403, 37.96462], [-121.76407, 37.96436], [-121.76501, 37.96434], [-121.76515, 37.96468], [-121.76517, 37.9663]]]} | Open Access 1 | Knoll Park | 20698 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 4.945 | Knoll Park | ||
6695 | 6695 | 6694 | {"type": "Polygon", "coordinates": [[[-121.85469, 37.99042], [-121.85194, 37.99044], [-121.85187, 37.99044], [-121.85207, 37.98997], [-121.85468, 37.98964], [-121.85469, 37.99042]]]} | Open Access 1 | Markley Creek Park | 21874 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 4.065 | Markley Creek Park | ||
6858 | 6858 | 6857 | {"type": "Polygon", "coordinates": [[[-121.78224, 38.00152], [-121.78223, 38.00289], [-121.782, 38.00291], [-121.78203, 38.00356], [-121.78215, 38.0037], [-121.782, 38.00378], [-121.78185, 38.00358], [-121.78163, 38.00341], [-121.78158, 38.00331], [-121.78173, 38.00246], [-121.78174, 38.00151], [-121.78224, 38.00152]]]} | Open Access 1 | Meadow Brook Park | 22068 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 2.404 | Meadow Brook Park | ||
6859 | 6859 | 6858 | {"type": "Polygon", "coordinates": [[[-121.75444, 37.96717], [-121.75437, 37.96758], [-121.7542, 37.96784], [-121.7539, 37.96806], [-121.75358, 37.96816], [-121.75281, 37.96822], [-121.75239, 37.96832], [-121.75206, 37.96846], [-121.75239, 37.96712], [-121.75444, 37.96717]]]} | Open Access 1 | Meadow Creek Estates Park | 22069 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.134 | Meadow Creek Estates Park | ||
7035 | 7035 | 7034 | {"type": "Polygon", "coordinates": [[[-121.83573, 37.9804], [-121.83523, 37.98052], [-121.8351, 37.98023], [-121.83472, 37.98031], [-121.83339, 37.98033], [-121.83331, 37.9803], [-121.83334, 37.98022], [-121.83337, 37.97991], [-121.83317, 37.97954], [-121.833, 37.97944], [-121.8327, 37.97883], [-121.83375, 37.97845], [-121.83396, 37.97838], [-121.83441, 37.97831], [-121.83484, 37.97831], [-121.8348, 37.97862], [-121.83488, 37.97909], [-121.83523, 37.97986], [-121.83547, 37.98011], [-121.83564, 37.98014], [-121.83573, 37.9804]]]} | Open Access 1 | Mira Vista Hills Park | 22277 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 9.213 | Mira Vista Hills Park | ||
7036 | 7036 | 7035 | {"type": "Polygon", "coordinates": [[[-121.82895, 37.98684], [-121.82876, 37.98847], [-121.82748, 37.98844], [-121.82681, 37.98756], [-121.82716, 37.98739], [-121.82724, 37.98733], [-121.82731, 37.98725], [-121.82735, 37.98716], [-121.82737, 37.98707], [-121.82737, 37.98679], [-121.82738, 37.98675], [-121.8274, 37.98674], [-121.82816, 37.98674], [-121.82858, 37.98678], [-121.82895, 37.98684]]]} | Open Access 1 | Mira Vista Park | 22278 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 6.798 | Mira Vista Park | ||
7162 | 7162 | 7161 | {"type": "Polygon", "coordinates": [[[-121.8233, 38.01369], [-121.8233, 38.01397], [-121.821, 38.01396], [-121.821, 38.01369], [-121.8233, 38.01369]]]} | Open Access 1 | Prosserville Park | 24023 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1.534 | Prosserville Park | ||
7254 | 7254 | 7253 | {"type": "Polygon", "coordinates": [[[-121.80318, 37.98855], [-121.80305, 37.98876], [-121.80295, 37.98898], [-121.80288, 37.98921], [-121.80284, 37.98945], [-121.80283, 37.98968], [-121.80285, 37.98992], [-121.80291, 37.99019], [-121.80294, 37.99027], [-121.80099, 37.99028], [-121.80104, 37.99001], [-121.80144, 37.98999], [-121.80165, 37.98888], [-121.80223, 37.98874], [-121.80224, 37.98876], [-121.80318, 37.98855]]]} | Open Access 1 | Mountaire Park | 22565 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.35 | Mountaire Park | ||
8405 | 8405 | 8404 | {"type": "Polygon", "coordinates": [[[-121.77993, 37.96623], [-121.77965, 37.96672], [-121.77954, 37.96705], [-121.7795, 37.96742], [-121.77956, 37.96795], [-121.77973, 37.96888], [-121.77847, 37.96953], [-121.76923, 37.96768], [-121.76918, 37.96356], [-121.77859, 37.96572], [-121.77993, 37.96623]]]} | Open Access 1 | Prewett Family Park | 23997 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 98.057 | Prewett Family Park | ||
10896 | 10896 | 10895 | {"type": "Polygon", "coordinates": [[[-121.84156, 37.99558], [-121.84004, 37.99597], [-121.83892, 37.99486], [-121.83898, 37.99475], [-121.84156, 37.99558]]]} | Open Access 1 | Village Park East | 27120 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 2.969 | Village Park East | ||
11207 | 11207 | 11206 | {"type": "Polygon", "coordinates": [[[-121.76194, 37.96045], [-121.76194, 37.96158], [-121.76011, 37.96155], [-121.76007, 37.96101], [-121.75997, 37.9605], [-121.76011, 37.96044], [-121.76194, 37.96045]]]} | Open Access 1 | Williamson Ranch Park | 27568 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.106 | Williamson Ranch Park | ||
14412 | 14412 | 14411 | {"type": "Polygon", "coordinates": [[[-121.75885, 37.9833], [-121.75881, 37.98336], [-121.75746, 37.98336], [-121.75658, 37.98337], [-121.75598, 37.98342], [-121.75566, 37.98346], [-121.75526, 37.98354], [-121.75406, 37.98381], [-121.75375, 37.98385], [-121.75331, 37.98388], [-121.7527, 37.98385], [-121.75068, 37.98354], [-121.75068, 37.98323], [-121.75427, 37.98321], [-121.75432, 37.98323], [-121.75493, 37.98323], [-121.75727, 37.98321], [-121.7574, 37.98319], [-121.75883, 37.98318], [-121.75885, 37.9833]]]} | Open Access 1 | Nelson Ranch Park | 33468 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 7.293 | Nelson Ranch Park |
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]);