units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
45 rows where COUNTY = 4 and MNG_AGENCY = 75 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
DES_TP 9
- Local Park 28
- Local Recreation Area 10
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 45
MNG_AGENCY 1
- Oceanside, City of · 45 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
7792 | 7792 | 7791 | {"type": "Polygon", "coordinates": [[[-117.34567, 33.22133], [-117.34531, 33.22156], [-117.34498, 33.22181], [-117.34466, 33.22207], [-117.34437, 33.22235], [-117.34432, 33.2223], [-117.34451, 33.22209], [-117.34469, 33.22184], [-117.34484, 33.22158], [-117.34494, 33.22133], [-117.34501, 33.22129], [-117.34538, 33.22134], [-117.34567, 33.22133]]]} | Open Access 1 | 47674 | Alex Road Skate Park | 31416 | 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/alexpark.asp | San Diego 4 | 0.81 | Alex Road Skate Park | 0 | Local Recreation Area 3 | 4 |
354 | 354 | 353 | {"type": "Polygon", "coordinates": [[[-117.36947, 33.17694], [-117.36912, 33.17714], [-117.36883, 33.1768], [-117.3692, 33.17658], [-117.36947, 33.17694]]]} | Open Access 1 | 976 | Buccaneer Beach Access | 16467 | 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 | San Diego 4 | 0.466 | Buccaneer Beach Access | 0 | Local Recreation Area 3 | 4 | |
1594 | 1594 | 1593 | {"type": "Polygon", "coordinates": [[[-117.36963, 33.17804], [-117.36862, 33.17865], [-117.36726, 33.17705], [-117.36809, 33.17656], [-117.36871, 33.17696], [-117.36963, 33.17804]]]} | Open Access 1 | 12164 | Buccaneer Beach Park | 16468 | 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#47 | San Diego 4 | 6.084 | Buccaneer Beach 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 |
8689 | 8689 | 8688 | {"type": "Polygon", "coordinates": [[[-117.38395, 33.2121], [-117.38144, 33.21404], [-117.38138, 33.21398], [-117.38224, 33.2126], [-117.38183, 33.21211], [-117.37985, 33.212], [-117.37987, 33.21189], [-117.37992, 33.21175], [-117.38008, 33.21151], [-117.38061, 33.21105], [-117.3808, 33.21095], [-117.381, 33.21089], [-117.38129, 33.21087], [-117.38156, 33.21092], [-117.38176, 33.211], [-117.38233, 33.21135], [-117.38252, 33.21142], [-117.38268, 33.21145], [-117.3828, 33.21145], [-117.38306, 33.2114], [-117.38321, 33.21132], [-117.3832, 33.21167], [-117.38395, 33.2121]]]} | Open Access 1 | 14051 | Capistrano Park | 16835 | 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#21 | San Diego 4 | 12.004 | Capistrano Park | 0 | Local Park 2 | 4 |
15140 | 15140 | 15139 | {"type": "Polygon", "coordinates": [[[-117.36976, 33.19608], [-117.36957, 33.19609], [-117.36957, 33.19581], [-117.36976, 33.19581], [-117.36976, 33.19608]]]} | Open Access 1 | 45965 | Cesar Chavez Park | 29114 | 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#34 | San Diego 4 | 0.138 | Cesar Chavez Park | 0 | Local Park 2 | 4 |
6262 | 6262 | 6261 | {"type": "Polygon", "coordinates": [[[-117.2722, 33.23324], [-117.27092, 33.23441], [-117.26866, 33.23481], [-117.269, 33.23353], [-117.26892, 33.2335], [-117.26927, 33.23204], [-117.26989, 33.23228], [-117.27007, 33.23157], [-117.27137, 33.23208], [-117.2715, 33.23242], [-117.27176, 33.23279], [-117.2722, 33.23324]]]} | Open Access 1 | 1729 | City of Oceanside Open Space | 17324 | 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 | San Diego 4 | 17.519 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
16008 | 16008 | 16007 | {"type": "Polygon", "coordinates": [[[-117.2855, 33.22691], [-117.28548, 33.22693], [-117.28508, 33.22706], [-117.28476, 33.22719], [-117.28433, 33.22742], [-117.28393, 33.2277], [-117.2835, 33.22804], [-117.28332, 33.22792], [-117.28331, 33.22789], [-117.28316, 33.22777], [-117.28314, 33.22774], [-117.28298, 33.22763], [-117.28298, 33.22758], [-117.28281, 33.22748], [-117.2828, 33.22744], [-117.28263, 33.22729], [-117.28262, 33.22727], [-117.2824, 33.2271], [-117.28225, 33.22701], [-117.28206, 33.22703], [-117.28185, 33.227], [-117.28167, 33.22712], [-117.2815, 33.22732], [-117.28144, 33.22751], [-117.2812, 33.22732], [-117.28101, 33.22719], [-117.28067, 33.22715], [-117.28051, 33.22721], [-117.28015, 33.22748], [-117.28012, 33.22766], [-117.28025, 33.22794], [-117.28085, 33.22823], [-117.2812, 33.22844], [-117.28133, 33.22858], [-117.28146, 33.22876], [-117.28163, 33.22892], [-117.28186, 33.22904], [-117.28134, 33.22959], [-117.28119, 33.22971], [-117.28054, 33.23032], [-117.2786, 33.22891], [-117.27844, 33.22881], [-117.27751, 33.22853], [-117.27737, 33.2285], [-117.2769, 33.22847], [-117.27676, 33.22844], [-117.27662, 33.22837], [-117.27677, 33.22818], [-117.27756, 33.22804], [-117.27813, 33.22785], [-117.27826, 33.22775], [-117.27853, 33.22799], [-117.27883, 33.22837], [-117.27912, 33.22859], [-117.27957, 33.22859], [-117.28017, 33.22899], [-117.28042, 33.22898], [-117.28048, 33.22882], [-117.28033, 33.22859], [-117.27992, 33.22818], [-117.27982, 33.22801], [-117.27903, 33.2272], [-117.2787, 33.22693], [-117.27959, 33.22561], [-117.27971, 33.2255], [-117.27984, 33.22543], [-117.28004, 33.2254], [-117.28048, 33.22539], [-117.28059, 33.22594], [-117.28089, 33.22616], [-117.28127, 33.22616], [-117.28302, 33.22595], [-117.28319, 33.226], [-117.28335, 33.22608], [-117.28342, 33.22623], [-117.28346, 33.22639], [-117.28347, 33.22659], [-117.28363, 33.22688], [-117.28393, 33.22693], [-117.28436, 33.22674], [-117.28443, 33.22655], [-117.28433, 33.22615], [-117.28419, 33.2258], [-117.28428, 33.22581], [-117.28443, 33.22569], [-117.28474, 33.22555], [-117.2853, 33.22604], [-117.28524, 33.22612], [-117.28524, 33.22618], [-117.28535, 33.22638], [-117.28541, 33.22664], [-117.2855, 33.22691]]]} | Open Access 1 | 1733 | City of Oceanside Open Space | 17324 | 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 | San Diego 4 | 35.391 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
16219 | 16219 | 16218 | {"type": "Polygon", "coordinates": [[[-117.17233, 33.2342], [-117.17202, 33.23604], [-117.17189, 33.23648], [-117.17178, 33.23675], [-117.17165, 33.23702], [-117.17032, 33.23703], [-117.1702, 33.23718], [-117.17023, 33.23751], [-117.17011, 33.23751], [-117.16988, 33.23783], [-117.16972, 33.23784], [-117.16977, 33.2384], [-117.16849, 33.23842], [-117.16846, 33.24102], [-117.16803, 33.24124], [-117.16763, 33.24094], [-117.16776, 33.24042], [-117.16769, 33.2402], [-117.16743, 33.23991], [-117.16592, 33.23931], [-117.16579, 33.23935], [-117.16431, 33.23922], [-117.16405, 33.23994], [-117.16386, 33.23992], [-117.16381, 33.23961], [-117.16384, 33.23934], [-117.15908, 33.23938], [-117.15804, 33.23852], [-117.15919, 33.23818], [-117.15945, 33.23775], [-117.15995, 33.23749], [-117.16145, 33.23719], [-117.16196, 33.23581], [-117.1627, 33.23526], [-117.16318, 33.23561], [-117.16327, 33.23494], [-117.16638, 33.23486], [-117.16638, 33.23119], [-117.16608, 33.23118], [-117.16622, 33.2307], [-117.16638, 33.23055], [-117.16638, 33.23112], [-117.16644, 33.23112], [-117.16649, 33.23108], [-117.16651, 33.23101], [-117.16644, 33.23081], [-117.16645, 33.23065], [-117.16653, 33.23046], [-117.16659, 33.23041], [-117.16665, 33.23038], [-117.16671, 33.23037], [-117.16745, 33.2305], [-117.16762, 33.2305], [-117.16779, 33.23047], [-117.1683, 33.23026], [-117.16876, 33.22996], [-117.16893, 33.22982], [-117.16899, 33.22975], [-117.1691, 33.22972], [-117.16919, 33.22975], [-117.1693, 33.22992], [-117.16944, 33.23004], [-117.16958, 33.23012], [-117.16978, 33.23017], [-117.16979, 33.23023], [-117.16989, 33.23025], [-117.16996, 33.23029], [-117.17, 33.23033], [-117.17008, 33.23044], [-117.17016, 33.23051], [-117.17022, 33.23053], [-117.17059, 33.23058], [-117.1706, 33.23248], [-117.17094, 33.2325], [-117.17188, 33.23359], [-117.17209, 33.23384], [-117.17201, 33.23419], [-117.17233, 33.2342]]]} | No Public Access 3 | 44881 | City of Oceanside Open Space | 17323 | 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 | San Diego 4 | 175.69 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
15143 | 15143 | 15142 | {"type": "Polygon", "coordinates": [[[-117.33221, 33.20195], [-117.33257, 33.20245], [-117.33274, 33.20273], [-117.33285, 33.20295], [-117.33299, 33.20326], [-117.33313, 33.20362], [-117.33323, 33.20398], [-117.33332, 33.20433], [-117.33337, 33.20483], [-117.33337, 33.2052], [-117.33328, 33.20774], [-117.33324, 33.2085], [-117.33318, 33.20853], [-117.33258, 33.20854], [-117.33214, 33.2086], [-117.33176, 33.20869], [-117.33095, 33.20898], [-117.33059, 33.20909], [-117.33038, 33.20912], [-117.32982, 33.20917], [-117.3293, 33.20919], [-117.32902, 33.20922], [-117.32862, 33.2093], [-117.32824, 33.20942], [-117.32788, 33.20958], [-117.32755, 33.20976], [-117.32704, 33.21013], [-117.32508, 33.21146], [-117.32466, 33.21168], [-117.3242, 33.21183], [-117.32392, 33.21189], [-117.32364, 33.21193], [-117.32272, 33.21198], [-117.32246, 33.21201], [-117.32213, 33.21209], [-117.32183, 33.21221], [-117.32176, 33.21212], [-117.31667, 33.21217], [-117.31642, 33.21188], [-117.31615, 33.21161], [-117.3157, 33.21123], [-117.31521, 33.21089], [-117.31382, 33.21007], [-117.31352, 33.20984], [-117.31311, 33.20948], [-117.31267, 33.20901], [-117.31236, 33.20859], [-117.3121, 33.20809], [-117.31196, 33.20775], [-117.31186, 33.2074], [-117.31176, 33.20687], [-117.31174, 33.20667], [-117.31176, 33.20654], [-117.31166, 33.20547], [-117.31149, 33.20468], [-117.31146, 33.20445], [-117.31123, 33.20339], [-117.31124, 33.20334], [-117.31129, 33.20331], [-117.31156, 33.20325], [-117.31196, 33.20321], [-117.31221, 33.20311], [-117.31221, 33.20307], [-117.31238, 33.20302], [-117.31679, 33.20205], [-117.31737, 33.20194], [-117.31796, 33.20185], [-117.31885, 33.20177], [-117.31975, 33.20174], [-117.33007, 33.20188], [-117.33097, 33.20195], [-117.33221, 33.20195]]]} | Open Access 1 | 45968 | El Corazon | 29117 | 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#25 | San Diego 4 | 473.941 | El Corazon | None 1319 | ||
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 |
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 |
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 |
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 |
5897 | 5897 | 5896 | {"type": "Polygon", "coordinates": [[[-117.37222, 33.20456], [-117.37148, 33.20494], [-117.37038, 33.20345], [-117.37099, 33.20314], [-117.37115, 33.20337], [-117.37129, 33.2033], [-117.37222, 33.20456]]]} | Open Access 1 | 738 | Joe Balderrama Park and Center | 29101 | 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#26 | San Diego 4 | 3.787 | Joe Balderrama Park and Ctr. | 0 | Local Recreation Area 3 | 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 |
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 |
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 |
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 |
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]);