units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where MNG_AGENCY = 347 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15689 | 15689 | 15688 | {"type": "Polygon", "coordinates": [[[-121.81438, 37.97557], [-121.81346, 37.97593], [-121.81013, 37.97849], [-121.80552, 37.97659], [-121.8055, 37.9766], [-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.97375], [-121.80508, 37.97352], [-121.80529, 37.97278], [-121.80555, 37.97177], [-121.80558, 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 | 16938 | Lone Tree Golf Course | 33051 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 198.557 | Lone Tree GC | 0 | Local Recreation Area 3 | 4 | |
14301 | 14301 | 14300 | {"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 | 44234 | Markley Creek Park | 21874 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 4.067 | Markley Creek Park | 0 | Local Park 2 | 4 | |
13679 | 13679 | 13678 | {"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 | 36335 | Antioch holding 1 | 15524 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 4.788 | Antioch holding 1 | 0 | Local Other or Unknown 14 | 4 | |
12158 | 12158 | 12157 | {"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.75739, 37.98319], [-121.75883, 37.98318], [-121.75885, 37.9833]]]} | Open Access 1 | 48742 | Nelson Ranch Park | 33468 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 7.295 | Nelson Ranch Park | 0 | Local Park 2 | 4 | |
11591 | 11591 | 11590 | {"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 | 23694 | Heidorn Park | 19792 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 2.013 | Heidorn Park | 0 | Local Park 2 | 4 | |
11587 | 11587 | 11586 | {"type": "Polygon", "coordinates": [[[-121.78975, 38.0104], [-121.78975, 38.01097], [-121.78887, 38.01096], [-121.78886, 38.01112], [-121.78881, 38.01112], [-121.78873, 38.01117], [-121.78869, 38.01126], [-121.7887, 38.0113], [-121.78876, 38.01136], [-121.78894, 38.01148], [-121.78905, 38.01153], [-121.78916, 38.01156], [-121.78984, 38.01157], [-121.78998, 38.0116], [-121.79004, 38.01166], [-121.79007, 38.01175], [-121.79008, 38.01207], [-121.79006, 38.0121], [-121.79001, 38.01212], [-121.78868, 38.01212], [-121.78867, 38.01216], [-121.78822, 38.01217], [-121.78821, 38.01221], [-121.78752, 38.01206], [-121.78753, 38.0104], [-121.78975, 38.0104]]]} | Open Access 1 | 23685 | Gaylord Sports Park | 19245 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 8.395 | Gaylord Sports Park | 0 | Local Recreation Area 3 | 4 | |
9896 | 9896 | 9895 | {"type": "Polygon", "coordinates": [[[-121.8345, 37.99368], [-121.83445, 37.99374], [-121.83442, 37.99388], [-121.83428, 37.99415], [-121.83395, 37.99405], [-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 | 16971 | Gentrytown Park | 19257 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 7.016 | Gentrytown Park | 0 | Local Park 2 | 4 | |
9874 | 9874 | 9873 | {"type": "Polygon", "coordinates": [[[-121.77993, 37.96623], [-121.77965, 37.96672], [-121.77954, 37.96704], [-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 | 17046 | Prewett Family Park | 23997 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 98.061 | Prewett Family Park | 0 | Local Park 2 | 4 | |
9868 | 9868 | 9867 | {"type": "Polygon", "coordinates": [[[-121.77845, 37.97689], [-121.77844, 37.98059], [-121.77843, 37.98283], [-121.77817, 37.98283], [-121.77704, 37.97935], [-121.77559, 37.97642], [-121.77605, 37.97655], [-121.77632, 37.97657], [-121.7766, 37.97655], [-121.77723, 37.97646], [-121.7773, 37.9767], [-121.77784, 37.9772], [-121.77845, 37.97689]]]} | Open Access 1 | 16906 | Country Manor Park | 17701 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 20.041 | Country Manor Park | 0 | Local Park 2 | 4 | |
9847 | 9847 | 9846 | {"type": "Polygon", "coordinates": [[[-121.77661, 37.99122], [-121.77629, 37.99133], [-121.77607, 37.99207], [-121.77573, 37.99263], [-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.99095], [-121.77427, 37.99091], [-121.77428, 37.99081], [-121.77468, 37.99082], [-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 | 16835 | Hillcrest Park | 19968 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 17.507 | Hillcrest Park | 0 | Local Park 2 | 4 | |
8011 | 8011 | 8010 | {"type": "Polygon", "coordinates": [[[-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], [-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.80917, 37.96174], [-121.80925, 37.96167]]]} | Open Access 1 | 11308 | Hansen Park | 19649 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 16.593 | Hansen Park | 0 | Local Park 2 | 4 | |
8004 | 8004 | 8003 | {"type": "Polygon", "coordinates": [[[-121.76403, 38.00147], [-121.76386, 38.00181], [-121.76394, 38.00213], [-121.76344, 38.00229], [-121.76313, 38.00233], [-121.76272, 38.00224], [-121.76218, 38.00197], [-121.76169, 38.00185], [-121.76172, 38.00162], [-121.76137, 38.00008], [-121.76207, 38.00035], [-121.76239, 38.00037], [-121.76276, 38.00027], [-121.76284, 38.00033], [-121.76296, 38.0006], [-121.76328, 38.00087], [-121.7636, 38.00108], [-121.76403, 38.00147]]]} | Open Access 1 | 11200 | Almondridge Park | 15401 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 8.775 | Almondridge Park | 0 | Local Park 2 | 4 | |
7962 | 7962 | 7961 | {"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.9544], [-121.7645, 37.95427], [-121.76527, 37.95427], [-121.76535, 37.95485], [-121.7659, 37.9559]]]} | Open Access 1 | 11288 | Chaparral Park | 17126 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 4.094 | Chaparral Park | 0 | Local Park 2 | 4 | |
7669 | 7669 | 7668 | {"type": "Polygon", "coordinates": [[[-121.75444, 37.96717], [-121.75437, 37.96758], [-121.7542, 37.96784], [-121.7539, 37.96806], [-121.75358, 37.96816], [-121.75282, 37.96822], [-121.75239, 37.96832], [-121.75206, 37.96846], [-121.75239, 37.96712], [-121.75444, 37.96717]]]} | Open Access 1 | 11277 | Meadow Creek Estates Park | 22069 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 5.134 | Meadow Creek Estates Park | 0 | Local Park 2 | 4 | |
7655 | 7655 | 7654 | {"type": "Polygon", "coordinates": [[[-121.78692, 38.00858], [-121.78687, 38.00878], [-121.78678, 38.00879], [-121.78661, 38.00949], [-121.78661, 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 | 11224 | Jacobsen Park | 20332 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 1.292 | Jacobsen Park | 0 | Local Park 2 | 4 | |
7654 | 7654 | 7653 | {"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.99108], [-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.79429, 37.99017], [-121.79496, 37.99051]]]} | Open Access 1 | 11188 | Harbour Park | 19670 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 7.881 | Harbour Park | 0 | Local Park 2 | 4 | |
7644 | 7644 | 7643 | {"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.99], [-121.80165, 37.98888], [-121.80223, 37.98874], [-121.80224, 37.98876], [-121.80318, 37.98855]]]} | Open Access 1 | 11176 | Mountaire Park | 22565 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 5.347 | Mountaire Park | 0 | Local Park 2 | 4 | |
4513 | 4513 | 4512 | {"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 | 11127 | Marchetti Park | 21795 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 4.993 | Marchetti Park | 0 | Local Park 2 | 4 | |
4028 | 4028 | 4027 | {"type": "Polygon", "coordinates": [[[-121.7718, 37.97394], [-121.77103, 37.97391], [-121.76888, 37.9739], [-121.76887, 37.9738], [-121.7689, 37.97375], [-121.76906, 37.97372], [-121.7693, 37.97364], [-121.76951, 37.97352], [-121.7696, 37.97345], [-121.76976, 37.97328], [-121.77, 37.97291], [-121.77007, 37.97288], [-121.77096, 37.97324], [-121.77121, 37.97336], [-121.77136, 37.97346], [-121.77161, 37.97368], [-121.7718, 37.97394]]]} | Open Access 1 | 44158 | Deerfield Park | 18009 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 3.943 | Deerfield Park | 0 | Local Park 2 | 4 | |
3332 | 3332 | 3331 | {"type": "Polygon", "coordinates": [[[-121.77048, 37.97119], [-121.76895, 37.97357], [-121.76872, 37.9736], [-121.76848, 37.97358], [-121.76959, 37.97186], [-121.76975, 37.97186], [-121.7698, 37.97183], [-121.76983, 37.97178], [-121.76984, 37.97173], [-121.76981, 37.97152], [-121.77011, 37.97104], [-121.77028, 37.97108], [-121.77048, 37.97119]]]} | Open Access 1 | 23689 | Deerfield Park | 18009 | 1007 | Antioch, City of 350 | City 2 | City Agency 2 | http://www.ci.antioch.ca.us/Recreation/parks.asp | City 2 | 1007 | Antioch, City of 347 | City 2 | City Agency 2 | Contra Costa 12 | 2.672 | Deerfield Park | 0 | 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]);