units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where COUNTY = 12, DES_TP = 2 and MNG_AGENCY = 347
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 32
MNG_AGENCY 1
- Antioch, City of · 32 ✖
DES_TP 1
- Local Park · 32 ✖
ACCESS_TYP 1
- Open Access 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1344 | 1344 | 1343 | {"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.95983], [-121.80296, 37.95969], [-121.80306, 37.96023]]]} | Open Access 1 | 11320 | Dallas Ranch Park | 17898 | 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.028 | Dallas Ranch Park | 0 | Local Park 2 | 4 | |
1345 | 1345 | 1344 | {"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 | 11331 | Diablo West Park | 18137 | 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.559 | Diablo West Park | 0 | Local Park 2 | 4 | |
1534 | 1534 | 1533 | {"type": "Polygon", "coordinates": [[[-121.83573, 37.9804], [-121.83523, 37.98052], [-121.83511, 37.98023], [-121.83472, 37.98031], [-121.83339, 37.98033], [-121.83331, 37.9803], [-121.83334, 37.98023], [-121.83337, 37.97991], [-121.83317, 37.97954], [-121.833, 37.97944], [-121.8327, 37.97883], [-121.83375, 37.97845], [-121.83397, 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 | 11151 | Mira Vista Hills Park | 22277 | 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 | 9.21 | Mira Vista Hills Park | 0 | Local Park 2 | 4 | |
1535 | 1535 | 1534 | {"type": "Polygon", "coordinates": [[[-121.78224, 38.00152], [-121.78223, 38.00289], [-121.782, 38.0029], [-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 | 11212 | Meadow Brook Park | 22068 | 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.401 | Meadow Brook Park | 0 | Local Park 2 | 4 | |
1536 | 1536 | 1535 | {"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.97716], [-121.79227, 37.97699], [-121.79231, 37.97681], [-121.79233, 37.97664], [-121.79231, 37.97636], [-121.79233, 37.97633], [-121.79237, 37.97631], [-121.79377, 37.97631]]]} | Open Access 1 | 11236 | Eaglesridge Park | 18350 | 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.379 | Eaglesridge Park | 0 | Local Park 2 | 4 | |
1541 | 1541 | 1540 | {"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 | 11253 | Knoll Park | 20698 | 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.946 | Knoll Park | 0 | Local Park 2 | 4 | |
1543 | 1543 | 1542 | {"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 | 11265 | Williamson Ranch Park | 27568 | 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.106 | Williamson Ranch Park | 0 | Local Park 2 | 4 | |
1877 | 1877 | 1876 | {"type": "Polygon", "coordinates": [[[-121.81971, 38.01823], [-121.81971, 38.01999], [-121.818, 38.01898], [-121.81795, 38.0188], [-121.81877, 38.0185], [-121.81919, 38.01849], [-121.81916, 38.0184], [-121.81862, 38.01842], [-121.81811, 38.01859], [-121.81783, 38.01857], [-121.81744, 38.01825], [-121.81711, 38.0182], [-121.81671, 38.01823], [-121.81617, 38.01813], [-121.81609, 38.01801], [-121.81597, 38.01801], [-121.81592, 38.01785], [-121.81971, 38.01823]]]} | Open Access 1 | 11044 | Barbara Price Marina Park | 15805 | 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 | 6.689 | Barbara Price Marina Park | 0 | Local Park 2 | 4 | |
1878 | 1878 | 1877 | {"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 | 11056 | Prosserville Park | 24023 | 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.535 | Prosserville Park | 0 | Local Park 2 | 4 | |
1879 | 1879 | 1878 | {"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 | 11067 | Fairview Park | 18815 | 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.812 | Fairview Park | 0 | Local Park 2 | 4 | |
1880 | 1880 | 1879 | {"type": "Polygon", "coordinates": [[[-121.82597, 38.00137], [-121.82575, 38.00203], [-121.82478, 38.00185], [-121.82447, 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 | 11077 | Contra Loma Estates Park | 17608 | 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.318 | Contra Loma Estates Park | 0 | Local Park 2 | 4 | |
1881 | 1881 | 1880 | {"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 | 11099 | Village Park East | 27120 | 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.97 | Village Park East | 0 | Local Park 2 | 4 | |
1882 | 1882 | 1881 | {"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 | 11111 | Canal Park | 16795 | 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.703 | Canal Park | 0 | Local Park 2 | 4 | |
2348 | 2348 | 2347 | {"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.98732], [-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 | 11139 | Mira Vista Park | 22278 | 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 | 6.799 | Mira Vista Park | 0 | Local Park 2 | 4 | |
2350 | 2350 | 2349 | {"type": "Polygon", "coordinates": [[[-121.81545, 37.98536], [-121.81593, 37.98578], [-121.81595, 37.98584], [-121.81465, 37.98716], [-121.81311, 37.9862], [-121.81337, 37.98593], [-121.81517, 37.98552], [-121.81545, 37.98536]]]} | Open Access 1 | 11164 | Chichibu Park | 17189 | 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 | 6.142 | Chichibu 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 | |
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 | |
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 | |
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 | |
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 |
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]);