superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 347 sorted by map descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
2577 | 2577 | 2576 | {"type": "Polygon", "coordinates": [[[-121.84007, 37.98959], [-121.83832, 37.98955], [-121.83761, 37.98935], [-121.83934, 37.98789], [-121.83963, 37.98826], [-121.83996, 37.9889], [-121.84007, 37.98921], [-121.84007, 37.98959]]]} | Open Access 1 | Canal Park | 16795 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.701 | Canal 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 | ||
4518 | 4518 | 4517 | {"type": "Polygon", "coordinates": [[[-121.8345, 37.99368], [-121.83445, 37.99374], [-121.83442, 37.99388], [-121.83428, 37.99415], [-121.83395, 37.99406], [-121.83374, 37.99446], [-121.83316, 37.99427], [-121.83212, 37.99422], [-121.83225, 37.99259], [-121.83436, 37.99327], [-121.83426, 37.99346], [-121.8345, 37.99368]]]} | Open Access 1 | Gentrytown Park | 19257 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 7.019 | Gentrytown 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 | ||
4154 | 4154 | 4153 | {"type": "Polygon", "coordinates": [[[-121.8275, 38.00952], [-121.82691, 38.0104], [-121.82613, 38.0101], [-121.82625, 38.00983], [-121.82615, 38.00977], [-121.8262, 38.00898], [-121.8275, 38.00952]]]} | Open Access 1 | Fairview Park | 18815 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 2.813 | Fairview Park | ||
3171 | 3171 | 3170 | {"type": "Polygon", "coordinates": [[[-121.82597, 38.00137], [-121.82575, 38.00203], [-121.82478, 38.00185], [-121.82448, 38.00176], [-121.82437, 38.00177], [-121.82402, 38.0017], [-121.82422, 38.00101], [-121.82478, 38.00097], [-121.82597, 38.00137]]]} | Open Access 1 | Contra Loma Estates Park | 17608 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 3.317 | Contra Loma Estates 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 | ||
1753 | 1753 | 1752 | {"type": "Polygon", "coordinates": [[[-121.81971, 38.01823], [-121.81971, 38.01999], [-121.818, 38.01898], [-121.81795, 38.0188], [-121.81877, 38.0185], [-121.81917, 38.01849], [-121.81916, 38.0184], [-121.81862, 38.01842], [-121.81811, 38.01859], [-121.81783, 38.01857], [-121.81744, 38.01825], [-121.8171, 38.0182], [-121.81671, 38.01823], [-121.81617, 38.01813], [-121.81609, 38.01802], [-121.81597, 38.01801], [-121.81592, 38.01785], [-121.81971, 38.01823]]]} | Open Access 1 | Barbara Price Marina Park | 15805 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 6.691 | Barbara Price Marina Park | ||
2894 | 2894 | 2893 | {"type": "Polygon", "coordinates": [[[-121.81595, 37.98584], [-121.81465, 37.98716], [-121.81311, 37.9862], [-121.81337, 37.98593], [-121.81517, 37.98552], [-121.81545, 37.98536], [-121.81593, 37.98578], [-121.81595, 37.98584]]]} | Open Access 1 | Chichibu Park | 17189 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 6.142 | Chichibu Park | ||
88 | 88 | 87 | {"type": "Polygon", "coordinates": [[[-121.81438, 37.97557], [-121.81346, 37.97593], [-121.81013, 37.97849], [-121.80552, 37.97659], [-121.8055, 37.97661], [-121.8055, 37.97675], [-121.80486, 37.9766], [-121.80409, 37.97634], [-121.80327, 37.97567], [-121.80324, 37.9754], [-121.80326, 37.97517], [-121.80333, 37.97497], [-121.80346, 37.97479], [-121.80354, 37.9747], [-121.80373, 37.97456], [-121.80442, 37.97421], [-121.80467, 37.97405], [-121.80478, 37.97396], [-121.80496, 37.97376], [-121.80508, 37.97352], [-121.80529, 37.97278], [-121.80555, 37.97177], [-121.80557, 37.97145], [-121.80557, 37.97081], [-121.80557, 37.97013], [-121.80559, 37.96964], [-121.80559, 37.96849], [-121.81433, 37.96848], [-121.81438, 37.97557]]]} | Restricted Access 2 | Lone Tree Golf Course | 33051 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 198.555 | Lone Tree GC | ||
807 | 807 | 806 | {"type": "Polygon", "coordinates": [[[-121.8135, 37.98299], [-121.81214, 37.983], [-121.81196, 37.98264], [-121.81202, 37.9826], [-121.81187, 37.9813], [-121.81171, 37.98016], [-121.81189, 37.98005], [-121.81216, 37.97992], [-121.81257, 37.97994], [-121.81243, 37.9803], [-121.81247, 37.98053], [-121.81248, 37.98149], [-121.81255, 37.98215], [-121.81265, 37.98236], [-121.81281, 37.98254], [-121.813, 37.98269], [-121.8135, 37.98299]]]} | Open Access 1 | Antioch | 15520 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.226 | Antioch | 2000 | |
4881 | 4881 | 4880 | {"type": "Polygon", "coordinates": [[[-121.81205, 37.96272], [-121.81205, 37.96276], [-121.81178, 37.96317], [-121.81159, 37.96358], [-121.81153, 37.9636], [-121.81117, 37.96355], [-121.81091, 37.96353], [-121.81047, 37.96356], [-121.81016, 37.96361], [-121.80924, 37.96384], [-121.80899, 37.96387], [-121.80873, 37.96389], [-121.80846, 37.96389], [-121.80734, 37.96376], [-121.8073, 37.96374], [-121.80728, 37.9637], [-121.80735, 37.96333], [-121.80752, 37.96273], [-121.80769, 37.96225], [-121.8079, 37.9618], [-121.808, 37.96162], [-121.80842, 37.96178], [-121.80856, 37.96173], [-121.80916, 37.96174], [-121.80925, 37.96167], [-121.80943, 37.96181], [-121.80973, 37.96217], [-121.8098, 37.96228], [-121.80987, 37.96249], [-121.80994, 37.96255], [-121.81005, 37.96256], [-121.8103, 37.96247], [-121.81071, 37.96239], [-121.81097, 37.96238], [-121.81123, 37.96243], [-121.81204, 37.9627], [-121.81205, 37.96272]]]} | Open Access 1 | Hansen Park | 19649 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 16.594 | Hansen Park | ||
1515 | 1515 | 1514 | {"type": "Polygon", "coordinates": [[[-121.808, 38.01005], [-121.80799, 38.01113], [-121.80628, 38.0111], [-121.80617, 38.01105], [-121.80616, 38.01002], [-121.808, 38.01005]]]} | Open Access 1 | Antioch holding 1 | 15524 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 4.787 | Antioch holding 1 | ||
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 | ||
3409 | 3409 | 3408 | {"type": "Polygon", "coordinates": [[[-121.80306, 37.96023], [-121.80282, 37.96064], [-121.80082, 37.96089], [-121.80065, 37.96007], [-121.80169, 37.95988], [-121.80252, 37.95958], [-121.8027, 37.95982], [-121.80296, 37.95969], [-121.80306, 37.96023]]]} | Open Access 1 | Dallas Ranch Park | 17898 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.029 | Dallas Ranch Park | ||
4896 | 4896 | 4895 | {"type": "Polygon", "coordinates": [[[-121.79496, 37.99051], [-121.79483, 37.99073], [-121.79468, 37.99112], [-121.79461, 37.99124], [-121.79446, 37.99143], [-121.79385, 37.99208], [-121.79321, 37.9917], [-121.79245, 37.99201], [-121.79245, 37.99167], [-121.79265, 37.99145], [-121.79274, 37.99116], [-121.7928, 37.99112], [-121.79283, 37.99109], [-121.79283, 37.99102], [-121.79301, 37.991], [-121.79319, 37.99084], [-121.79313, 37.99069], [-121.79284, 37.99048], [-121.79311, 37.99024], [-121.79315, 37.99017], [-121.79316, 37.9901], [-121.79323, 37.99006], [-121.79327, 37.98999], [-121.79338, 37.98995], [-121.79353, 37.98983], [-121.79388, 37.9898], [-121.79392, 37.98985], [-121.79399, 37.98987], [-121.794, 37.98993], [-121.79403, 37.98997], [-121.79428, 37.99017], [-121.79496, 37.99051]]]} | Open Access 1 | Harbour Park | 19670 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 7.884 | Harbour Park | ||
3775 | 3775 | 3774 | {"type": "Polygon", "coordinates": [[[-121.79377, 37.97631], [-121.79376, 37.97722], [-121.79314, 37.97734], [-121.79313, 37.97796], [-121.79278, 37.97797], [-121.7923, 37.97802], [-121.7919, 37.97794], [-121.79202, 37.97757], [-121.79221, 37.97717], [-121.79227, 37.97699], [-121.79231, 37.97682], [-121.79233, 37.97664], [-121.79231, 37.97636], [-121.79233, 37.97633], [-121.79237, 37.97631], [-121.79377, 37.97631]]]} | Open Access 1 | Eaglesridge Park | 18350 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 5.383 | Eaglesridge 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]);