superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AGENCY = 347 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
3600 | 3600 | 3599 | {"type": "Polygon", "coordinates": [[[-121.78833, 37.96151], [-121.78833, 37.96151], [-121.7875, 37.9627], [-121.78747, 37.96115], [-121.78782, 37.96133], [-121.78833, 37.96151]]]} | Open Access 1 | Diablo West Park | 18137 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1.559 | Diablo West Park | ||
5011 | 5011 | 5010 | {"type": "Polygon", "coordinates": [[[-121.75666, 37.95965], [-121.75655, 37.96002], [-121.756, 37.95991], [-121.755, 37.95968], [-121.75496, 37.95966], [-121.75495, 37.95962], [-121.75503, 37.95947], [-121.75529, 37.95908], [-121.75666, 37.95965]]]} | Open Access 1 | Heidorn Park | 19792 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 2.012 | Heidorn 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
2835 | 2835 | 2834 | {"type": "Polygon", "coordinates": [[[-121.7659, 37.9559], [-121.76581, 37.95601], [-121.76532, 37.95596], [-121.76481, 37.95573], [-121.7643, 37.95528], [-121.76413, 37.95511], [-121.76441, 37.95485], [-121.76451, 37.95462], [-121.76455, 37.95441], [-121.7645, 37.95427], [-121.76527, 37.95427], [-121.76535, 37.95485], [-121.7659, 37.9559]]]} | Open Access 1 | Chaparral Park | 17126 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 4.094 | Chaparral 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 |
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]);