units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where DES_TP = 2 and MNG_AGENCY = 75 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 28
MNG_AGENCY 1
- Oceanside, City of · 28 ✖
DES_TP 1
- Local Park · 28 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6489 | 6489 | 6488 | {"type": "MultiPolygon", "coordinates": [[[[-117.31856, 33.23041], [-117.31821, 33.23053], [-117.31763, 33.23064], [-117.31727, 33.23066], [-117.31693, 33.23065], [-117.31661, 33.23061], [-117.31398, 33.23], [-117.31384, 33.22993], [-117.31384, 33.22969], [-117.3144, 33.22937], [-117.315, 33.22906], [-117.31629, 33.22852], [-117.3163, 33.22893], [-117.31709, 33.22859], [-117.31754, 33.22844], [-117.3179, 33.22835], [-117.31798, 33.22837], [-117.31805, 33.22846], [-117.31808, 33.2293], [-117.31811, 33.22945], [-117.31819, 33.22976], [-117.3183, 33.23], [-117.31856, 33.23041]]], [[[-117.32126, 33.22934], [-117.32103, 33.22942], [-117.32077, 33.22962], [-117.31887, 33.2303], [-117.31873, 33.23003], [-117.3186, 33.22964], [-117.31857, 33.22948], [-117.31854, 33.2292], [-117.31854, 33.22868], [-117.31863, 33.22861], [-117.31891, 33.22852], [-117.31908, 33.22851], [-117.31924, 33.22852], [-117.31948, 33.22858], [-117.31985, 33.22877], [-117.32113, 33.22934], [-117.32126, 33.22934]]]]} | Open Access 1 | 2351 | Ivey Ranch Park | 20286 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#13 | San Diego 4 | 24.433 | Ivey Ranch Park | 0 | Local Park 2 | 4 |
9066 | 9066 | 9065 | {"type": "MultiPolygon", "coordinates": [[[[-117.36226, 33.19259], [-117.3624, 33.19418], [-117.36239, 33.19436], [-117.36236, 33.1945], [-117.36229, 33.19468], [-117.36217, 33.19484], [-117.36184, 33.19519], [-117.36174, 33.19536], [-117.36168, 33.19556], [-117.36166, 33.19568], [-117.36167, 33.19787], [-117.35722, 33.19787], [-117.35719, 33.19485], [-117.3578, 33.1945], [-117.35787, 33.19463], [-117.35788, 33.19477], [-117.35789, 33.19478], [-117.35989, 33.1938], [-117.35892, 33.19244], [-117.35886, 33.1924], [-117.35923, 33.19222], [-117.36, 33.1934], [-117.36139, 33.19286], [-117.36187, 33.1922], [-117.36216, 33.19256], [-117.36226, 33.19259]]], [[[-117.36694, 33.19659], [-117.36651, 33.19688], [-117.36621, 33.19699], [-117.36599, 33.19702], [-117.3651, 33.19703], [-117.36509, 33.19795], [-117.36187, 33.19796], [-117.36185, 33.1957], [-117.36187, 33.19558], [-117.36191, 33.19546], [-117.36199, 33.19529], [-117.36232, 33.19494], [-117.36246, 33.19475], [-117.36253, 33.19461], [-117.36259, 33.19439], [-117.3626, 33.19418], [-117.36246, 33.19267], [-117.3633, 33.19295], [-117.36402, 33.19299], [-117.36569, 33.19499], [-117.36694, 33.19659]]]]} | Restricted Access 2 | 15007 | Goat Hill Park | 29108 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.goathillpark.com/ | San Diego 4 | 94.712 | Goat Hill Park | 0 | Local Park 2 | 4 |
8190 | 8190 | 8189 | {"type": "MultiPolygon", "coordinates": [[[[-117.36414, 33.17398], [-117.36407, 33.17403], [-117.36394, 33.17406], [-117.36377, 33.17399], [-117.36364, 33.17388], [-117.36356, 33.17374], [-117.36354, 33.17333], [-117.36357, 33.1733], [-117.36414, 33.17398]]], [[[-117.36467, 33.17459], [-117.36444, 33.17473], [-117.36397, 33.17424], [-117.36424, 33.17407], [-117.36467, 33.17459]]]]} | Open Access 1 | 12435 | Lion's Club Park | 21310 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#49 | San Diego 4 | 1.021 | Lion's Club Park | 0 | Local Park 2 | 4 |
8155 | 8155 | 8154 | {"type": "Polygon", "coordinates": [[[-117.25657, 33.17292], [-117.25539, 33.17477], [-117.2534, 33.17386], [-117.25339, 33.17383], [-117.25561, 33.17227], [-117.25572, 33.17238], [-117.25602, 33.17261], [-117.25604, 33.17261], [-117.25631, 33.17279], [-117.25657, 33.17292]]]} | Open Access 1 | 12361 | Lake Park | 20960 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#53 | San Diego 4 | 9.883 | Lake Park | 0 | Local Park 2 | 4 |
459 | 459 | 458 | {"type": "Polygon", "coordinates": [[[-117.26352, 33.2475], [-117.26338, 33.24756], [-117.26307, 33.24774], [-117.26289, 33.24789], [-117.26274, 33.24797], [-117.26268, 33.24799], [-117.26264, 33.24797], [-117.26261, 33.24793], [-117.26219, 33.24649], [-117.26249, 33.24656], [-117.26272, 33.24654], [-117.26296, 33.24672], [-117.26296, 33.24678], [-117.26298, 33.24681], [-117.26308, 33.24687], [-117.26352, 33.2475]]]} | Open Access 1 | 1841 | Spring Creek Park | 25737 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#7 | San Diego 4 | 2.688 | Spring Creek Park | 0 | Local Park 2 | 4 |
7861 | 7861 | 7860 | {"type": "Polygon", "coordinates": [[[-117.27095, 33.17716], [-117.27037, 33.17714], [-117.26985, 33.17705], [-117.26944, 33.17693], [-117.26891, 33.17667], [-117.26866, 33.17651], [-117.26839, 33.17628], [-117.26822, 33.17611], [-117.26762, 33.17542], [-117.26737, 33.1752], [-117.26708, 33.175], [-117.26706, 33.17494], [-117.26708, 33.17489], [-117.26725, 33.17468], [-117.2681, 33.17511], [-117.26855, 33.17425], [-117.26843, 33.17396], [-117.2692, 33.17371], [-117.26979, 33.17546], [-117.27093, 33.17543], [-117.27095, 33.17716]]]} | Open Access 1 | 12531 | Oak Riparian Park | 29106 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#52 | San Diego 4 | 16.426 | Oak Riparian Park | 0 | Local Park 2 | 4 |
552 | 552 | 551 | {"type": "Polygon", "coordinates": [[[-117.28166, 33.238], [-117.28055, 33.23915], [-117.2798, 33.23858], [-117.27974, 33.23844], [-117.2797, 33.23839], [-117.27957, 33.23832], [-117.27948, 33.23832], [-117.27889, 33.23787], [-117.27903, 33.23769], [-117.27913, 33.23751], [-117.27931, 33.23711], [-117.28166, 33.238]]]} | Open Access 1 | 1838 | Alamosa Park | 15324 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#8 | San Diego 4 | 6.929 | Alamosa Park | 0 | Local Park 2 | 4 |
2453 | 2453 | 2452 | {"type": "Polygon", "coordinates": [[[-117.2876, 33.19566], [-117.28529, 33.19565], [-117.28525, 33.19561], [-117.28526, 33.19391], [-117.28759, 33.19394], [-117.2876, 33.19566]]]} | Open Access 1 | 12339 | John Landes Park | 20451 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#38 | San Diego 4 | 10.373 | John Landes Park | 0 | Local Park 2 | 4 |
6390 | 6390 | 6389 | {"type": "Polygon", "coordinates": [[[-117.29218, 33.22514], [-117.29215, 33.22517], [-117.29173, 33.22534], [-117.29035, 33.22574], [-117.2886, 33.22296], [-117.28911, 33.22279], [-117.29032, 33.22226], [-117.29041, 33.22226], [-117.29218, 33.2251], [-117.29218, 33.22514]]]} | Open Access 1 | 1837 | Rancho del Oro Park | 24137 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#16 | San Diego 4 | 16.347 | Rancho del Oro Park | 0 | Local Park 2 | 4 |
5610 | 5610 | 5609 | {"type": "Polygon", "coordinates": [[[-117.29877, 33.27281], [-117.29876, 33.27284], [-117.29871, 33.27288], [-117.29849, 33.27289], [-117.29828, 33.27293], [-117.29812, 33.27299], [-117.29632, 33.27334], [-117.29624, 33.27327], [-117.29624, 33.27323], [-117.29628, 33.2731], [-117.29629, 33.27295], [-117.29626, 33.27276], [-117.29629, 33.27246], [-117.2965, 33.27125], [-117.29687, 33.27128], [-117.2972, 33.2712], [-117.29749, 33.27122], [-117.29777, 33.27139], [-117.2979, 33.27143], [-117.29842, 33.27147], [-117.2985, 33.2716], [-117.29843, 33.27163], [-117.29837, 33.27168], [-117.29834, 33.27174], [-117.29834, 33.27182], [-117.29836, 33.27187], [-117.29844, 33.27194], [-117.29863, 33.27231], [-117.29877, 33.27281]]]} | Open Access 1 | 1706 | Luiseno Park | 21591 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#1 | San Diego 4 | 10.124 | Luiseno Park | 0 | Local Park 2 | 4 |
355 | 355 | 354 | {"type": "Polygon", "coordinates": [[[-117.29995, 33.19809], [-117.29955, 33.19846], [-117.29838, 33.19904], [-117.29818, 33.19932], [-117.2981, 33.19952], [-117.29778, 33.20011], [-117.29732, 33.20052], [-117.29686, 33.20066], [-117.29686, 33.20026], [-117.29703, 33.20018], [-117.29712, 33.20012], [-117.29721, 33.20002], [-117.29724, 33.19993], [-117.29722, 33.19987], [-117.29716, 33.19982], [-117.29708, 33.1998], [-117.29702, 33.19981], [-117.29697, 33.19984], [-117.29693, 33.19989], [-117.29692, 33.19994], [-117.29694, 33.20001], [-117.29693, 33.20003], [-117.29686, 33.20007], [-117.29686, 33.19902], [-117.29579, 33.19847], [-117.29574, 33.19825], [-117.29571, 33.19819], [-117.2958, 33.19813], [-117.29584, 33.19804], [-117.29584, 33.19798], [-117.29581, 33.1979], [-117.29581, 33.19763], [-117.29582, 33.19752], [-117.29586, 33.19743], [-117.29599, 33.19729], [-117.29622, 33.19713], [-117.29636, 33.19699], [-117.29647, 33.19678], [-117.29651, 33.19659], [-117.29684, 33.19658], [-117.29684, 33.19622], [-117.29694, 33.19623], [-117.297, 33.19627], [-117.29704, 33.19656], [-117.29702, 33.19677], [-117.29691, 33.19683], [-117.29687, 33.19687], [-117.29685, 33.19693], [-117.29688, 33.197], [-117.29691, 33.19704], [-117.29697, 33.19706], [-117.29706, 33.19706], [-117.29713, 33.19703], [-117.29717, 33.19697], [-117.29756, 33.19702], [-117.29809, 33.19703], [-117.29847, 33.19696], [-117.2988, 33.19676], [-117.29924, 33.19706], [-117.29948, 33.19732], [-117.29934, 33.19745], [-117.29926, 33.19757], [-117.29921, 33.1977], [-117.29923, 33.19778], [-117.29929, 33.19783], [-117.29935, 33.19785], [-117.29941, 33.19784], [-117.29948, 33.19781], [-117.29995, 33.19809]]]} | Open Access 1 | 977 | John Sepulveda Park | 31207 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#37 | San Diego 4 | 22.08 | John Sepulveda Park | 0 | Local Park 2 | 4 |
1289 | 1289 | 1288 | {"type": "Polygon", "coordinates": [[[-117.30731, 33.21604], [-117.30669, 33.21637], [-117.30593, 33.21686], [-117.30592, 33.21717], [-117.30486, 33.21746], [-117.30396, 33.21792], [-117.30357, 33.21823], [-117.30238, 33.21711], [-117.30306, 33.2166], [-117.30352, 33.21636], [-117.30388, 33.21623], [-117.3058, 33.21574], [-117.30625, 33.21555], [-117.30645, 33.21543], [-117.30665, 33.2153], [-117.30731, 33.21604]]]} | Open Access 1 | 5715 | Martin Luther King Jr Park | 21908 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#17 | San Diego 4 | 15.423 | Martin Luther King Jr Park | 0 | Local Park 2 | 4 |
7573 | 7573 | 7572 | {"type": "Polygon", "coordinates": [[[-117.3089, 33.19722], [-117.30873, 33.19753], [-117.30863, 33.19778], [-117.30859, 33.19791], [-117.3079, 33.19824], [-117.30632, 33.1981], [-117.30633, 33.19708], [-117.30688, 33.19709], [-117.30689, 33.19715], [-117.30761, 33.19717], [-117.30788, 33.19715], [-117.30815, 33.19706], [-117.30845, 33.19704], [-117.30861, 33.19705], [-117.30886, 33.19712], [-117.3089, 33.19717], [-117.3089, 33.19722]]]} | Open Access 1 | 7487 | Palisades Park | 23331 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#36 | San Diego 4 | 6.288 | Palisades Park | 0 | Local Park 2 | 4 |
6061 | 6061 | 6060 | {"type": "Polygon", "coordinates": [[[-117.3096, 33.25064], [-117.30897, 33.25063], [-117.30836, 33.25134], [-117.30767, 33.2519], [-117.30764, 33.25254], [-117.30614, 33.25253], [-117.30711, 33.25081], [-117.30546, 33.25031], [-117.30528, 33.25031], [-117.30528, 33.25], [-117.30573, 33.24999], [-117.30667, 33.25004], [-117.30763, 33.24989], [-117.30826, 33.25001], [-117.30853, 33.24993], [-117.30876, 33.24931], [-117.30895, 33.2495], [-117.30903, 33.24964], [-117.3096, 33.24943], [-117.3096, 33.25064]]]} | Open Access 1 | 775 | Libby Lake Park | 21203 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#4 | San Diego 4 | 15.089 | Libby Lake Park | 0 | Local Park 2 | 4 |
8147 | 8147 | 8146 | {"type": "Polygon", "coordinates": [[[-117.32183, 33.23493], [-117.32157, 33.23502], [-117.32141, 33.23512], [-117.32132, 33.2352], [-117.32114, 33.23539], [-117.32106, 33.23554], [-117.32101, 33.2357], [-117.32099, 33.23434], [-117.32144, 33.23434], [-117.32144, 33.23451], [-117.32183, 33.23474], [-117.32183, 33.23493]]]} | Open Access 1 | 12328 | Heritage Park | 19853 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#10 | San Diego 4 | 1.507 | Heritage Park | 0 | Local Park 2 | 4 |
8129 | 8129 | 8128 | {"type": "Polygon", "coordinates": [[[-117.33965, 33.22712], [-117.33962, 33.22818], [-117.33865, 33.22819], [-117.33856, 33.22817], [-117.33841, 33.22811], [-117.33811, 33.22786], [-117.33811, 33.22781], [-117.33835, 33.22759], [-117.33845, 33.22745], [-117.33851, 33.22726], [-117.33851, 33.22713], [-117.33965, 33.22712]]]} | Open Access 1 | 12307 | Fireside Park | 18913 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#12 | San Diego 4 | 3.486 | Fireside Park | 0 | Local Park 2 | 4 |
6094 | 6094 | 6093 | {"type": "Polygon", "coordinates": [[[-117.3428, 33.19775], [-117.34138, 33.19797], [-117.34133, 33.19795], [-117.34131, 33.19791], [-117.34131, 33.19675], [-117.34171, 33.19675], [-117.34172, 33.19655], [-117.34243, 33.19709], [-117.34263, 33.1971], [-117.3428, 33.19775]]]} | Open Access 1 | 978 | Joseph Carrasco Park | 20493 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#35 | San Diego 4 | 3.641 | Joseph Carrasco Park | 0 | Local Park 2 | 4 |
790 | 790 | 789 | {"type": "Polygon", "coordinates": [[[-117.34745, 33.23316], [-117.34696, 33.23302], [-117.34672, 33.23298], [-117.34621, 33.23294], [-117.34596, 33.23294], [-117.34546, 33.23299], [-117.34496, 33.2331], [-117.34461, 33.2331], [-117.34461, 33.23301], [-117.34463, 33.23293], [-117.3447, 33.23278], [-117.34516, 33.23227], [-117.34534, 33.23204], [-117.34538, 33.23202], [-117.34544, 33.23201], [-117.34575, 33.23212], [-117.34589, 33.23215], [-117.34615, 33.23218], [-117.34697, 33.23217], [-117.34712, 33.23219], [-117.34727, 33.23226], [-117.34736, 33.23232], [-117.34747, 33.23243], [-117.34755, 33.23253], [-117.34759, 33.23266], [-117.3476, 33.23276], [-117.34758, 33.2329], [-117.34745, 33.23316]]]} | Open Access 1 | 5134 | Marlado Highlands Park | 21877 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#11 | San Diego 4 | 5.8 | Marlado Highlands Park | 0 | Local Park 2 | 4 |
8144 | 8144 | 8143 | {"type": "Polygon", "coordinates": [[[-117.34865, 33.20849], [-117.34781, 33.2094], [-117.34673, 33.20972], [-117.34594, 33.20913], [-117.34634, 33.20881], [-117.34648, 33.20864], [-117.34654, 33.20853], [-117.34673, 33.20775], [-117.34746, 33.20617], [-117.34817, 33.2049], [-117.34822, 33.20486], [-117.3483, 33.20489], [-117.34855, 33.20525], [-117.34865, 33.20535], [-117.34865, 33.20849]]]} | Open Access 1 | 12325 | Buddy Todd Memorial Park | 16481 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#24 | San Diego 4 | 17.845 | Buddy Todd Memorial Park | 0 | Local Park 2 | 4 |
10689 | 10689 | 10688 | {"type": "Polygon", "coordinates": [[[-117.35304, 33.1914], [-117.35291, 33.19183], [-117.35226, 33.19212], [-117.3519, 33.1927], [-117.35141, 33.1937], [-117.3516, 33.19417], [-117.35188, 33.19442], [-117.35222, 33.19467], [-117.35004, 33.19593], [-117.34742, 33.19266], [-117.3481, 33.19219], [-117.34927, 33.19368], [-117.35173, 33.19232], [-117.35239, 33.19167], [-117.35285, 33.19113], [-117.35304, 33.1914]]]} | Open Access 1 | 19840 | Skylark/ John currasco Park | 25538 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#35 | San Diego 4 | 21.938 | Skylark/ John currasco 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]);