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 PARK_URL descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1668 | 1668 | 1667 | {"type": "MultiPolygon", "coordinates": [[[[-117.3924, 33.20255], [-117.39152, 33.20308], [-117.39131, 33.20289], [-117.39122, 33.20285], [-117.39111, 33.20282], [-117.39097, 33.20283], [-117.39044, 33.20299], [-117.39029, 33.20298], [-117.39019, 33.20291], [-117.3897, 33.20233], [-117.39105, 33.20148], [-117.38998, 33.2002], [-117.39021, 33.20006], [-117.39052, 33.20038], [-117.3924, 33.20255]]], [[[-117.39137, 33.20317], [-117.38901, 33.20458], [-117.38859, 33.20303], [-117.3895, 33.20246], [-117.38964, 33.20251], [-117.38969, 33.20255], [-117.39008, 33.20302], [-117.39021, 33.2031], [-117.39038, 33.20314], [-117.39048, 33.20313], [-117.39097, 33.20297], [-117.39108, 33.20296], [-117.39122, 33.203], [-117.39137, 33.20317]]], [[[-117.38874, 33.20493], [-117.38867, 33.20496], [-117.38863, 33.20493], [-117.38831, 33.20514], [-117.38824, 33.20504], [-117.38719, 33.20572], [-117.38723, 33.20587], [-117.3864, 33.2064], [-117.38595, 33.20646], [-117.38572, 33.20653], [-117.38553, 33.2066], [-117.38488, 33.20556], [-117.38472, 33.20527], [-117.38462, 33.205], [-117.38484, 33.20502], [-117.38574, 33.20449], [-117.38583, 33.20462], [-117.38605, 33.20441], [-117.38617, 33.20434], [-117.38691, 33.20351], [-117.38708, 33.20341], [-117.38711, 33.20352], [-117.38719, 33.20353], [-117.38738, 33.20333], [-117.38752, 33.20324], [-117.3877, 33.20317], [-117.38774, 33.20314], [-117.38775, 33.20311], [-117.38771, 33.20292], [-117.38752, 33.20236], [-117.38735, 33.202], [-117.38711, 33.20158], [-117.38768, 33.20157], [-117.38793, 33.20208], [-117.38804, 33.20235], [-117.38817, 33.20276], [-117.38822, 33.20303], [-117.38874, 33.20493]]], [[[-117.38491, 33.20748], [-117.38061, 33.21078], [-117.38039, 33.21092], [-117.37989, 33.21137], [-117.37972, 33.21159], [-117.37963, 33.21181], [-117.37959, 33.21198], [-117.37958, 33.21241], [-117.37904, 33.21238], [-117.37905, 33.21223], [-117.37904, 33.21222], [-117.37879, 33.21245], [-117.37782, 33.21293], [-117.37788, 33.21089], [-117.3782, 33.21064], [-117.37854, 33.21034], [-117.37845, 33.21024], [-117.38078, 33.20856], [-117.38108, 33.20862], [-117.38152, 33.20827], [-117.38184, 33.20798], [-117.38224, 33.20757], [-117.38223, 33.20755], [-117.38186, 33.20784], [-117.38206, 33.20749], [-117.38213, 33.2074], [-117.38207, 33.20734], [-117.38317, 33.2065], [-117.38318, 33.20684], [-117.38275, 33.2072], [-117.38275, 33.20722], [-117.38317, 33.20743], [-117.38384, 33.207], [-117.384, 33.20701], [-117.38427, 33.20707], [-117.38449, 33.20716], [-117.3847, 33.20729], [-117.38491, 33.20748]]], [[[-117.36001, 33.21374], [-117.35982, 33.21379], [-117.35942, 33.21376], [-117.35734, 33.21264], [-117.35734, 33.21251], [-117.35941, 33.21359], [-117.35954, 33.21363], [-117.36001, 33.21374]]], [[[-117.35254, 33.22043], [-117.35125, 33.22017], [-117.35089, 33.2201], [-117.35035, 33.22005], [-117.35008, 33.22004], [-117.34954, 33.22006], [-117.34888, 33.22016], [-117.34776, 33.22042], [-117.34711, 33.22063], [-117.34589, 33.22112], [-117.34568, 33.22116], [-117.34545, 33.22116], [-117.34506, 33.22109], [-117.34501, 33.22103], [-117.34503, 33.22082], [-117.34502, 33.22047], [-117.34859, 33.21929], [-117.3486, 33.21871], [-117.34958, 33.21855], [-117.34958, 33.21883], [-117.35209, 33.21842], [-117.35254, 33.22043]]], [[[-117.37768, 33.21103], [-117.37762, 33.21303], [-117.37715, 33.21325], [-117.37482, 33.2146], [-117.373, 33.21517], [-117.37088, 33.21542], [-117.36865, 33.21578], [-117.36748, 33.21603], [-117.36813, 33.21588], [-117.36813, 33.21565], [-117.36597, 33.21568], [-117.36596, 33.21572], [-117.3648, 33.21579], [-117.36459, 33.21581], [-117.36426, 33.2159], [-117.36396, 33.21601], [-117.36372, 33.21601], [-117.36213, 33.21654], [-117.36199, 33.21666], [-117.36192, 33.2168], [-117.36191, 33.21695], [-117.36198, 33.21718], [-117.36191, 33.2174], [-117.36184, 33.21755], [-117.36175, 33.21768], [-117.36114, 33.21842], [-117.36101, 33.21852], [-117.36083, 33.21859], [-117.36057, 33.21919], [-117.3607, 33.21926], [-117.36057, 33.21979], [-117.36053, 33.22002], [-117.36049, 33.22036], [-117.36046, 33.2208], [-117.36039, 33.22097], [-117.36032, 33.22106], [-117.35966, 33.22162], [-117.35956, 33.22168], [-117.35945, 33.22173], [-117.35928, 33.22177], [-117.35909, 33.22177], [-117.35859, 33.22167], [-117.35852, 33.2216], [-117.35856, 33.22141], [-117.35858, 33.22115], [-117.35855, 33.22089], [-117.35851, 33.2207], [-117.35844, 33.22049], [-117.35835, 33.22028], [-117.35804, 33.21969], [-117.3579, 33.21934], [-117.35787, 33.21919], [-117.3589, 33.21775], [-117.35746, 33.21711], [-117.35744, 33.2164], [-117.35747, 33.21499], [-117.35755, 33.21497], [-117.35756, 33.21492], [-117.36172, 33.21391], [-117.36596, 33.21302], [-117.36706, 33.21292], [-117.3671, 33.21313], [-117.3673, 33.21312], [-117.36731, 33.21307], [-117.36834, 33.21304], [-117.36865, 33.21308], [-117.37189, 33.21318], [-117.37274, 33.21319], [-117.37334, 33.21315], [-117.37417, 33.21299], [-117.37477, 33.21281], [-117.37552, 33.2125], [-117.37598, 33.21226], [-117.37642, 33.212], [-117.37768, 33.21103]]], [[[-117.35833, 33.22089], [-117.35812, 33.22108], [-117.35787, 33.22126], [-117.35736, 33.22155], [-117.3569, 33.22177], [-117.35652, 33.22192], [-117.35603, 33.22208], [-117.35555, 33.22219], [-117.35511, 33.22227], [-117.35355, 33.22242], [-117.35288, 33.22243], [-117.35247, 33.22239], [-117.35222, 33.22235], [-117.35177, 33.22224], [-117.35164, 33.22224], [-117.3509, 33.22209], [-117.35048, 33.22204], [-117.35018, 33.22203], [-117.34976, 33.22204], [-117.34939, 33.22207], [-117.34904, 33.22214], [-117.34873, 33.22221], [-117.34851, 33.22228], [-117.34736, 33.22269], [-117.34706, 33.22282], [-117.34671, 33.223], [-117.3466, 33.22309], [-117.34658, 33.22313], [-117.3463, 33.22335], [-117.34601, 33.22363], [-117.34597, 33.22369], [-117.34596, 33.22375], [-117.34598, 33.2238], [-117.34613, 33.22394], [-117.34615, 33.22399], [-117.34614, 33.22408], [-117.34601, 33.22428], [-117.34586, 33.22412], [-117.34468, 33.22302], [-117.34445, 33.22281], [-117.34417, 33.22259], [-117.34424, 33.22249], [-117.34437, 33.22235], [-117.34482, 33.22193], [-117.34531, 33.22156], [-117.34567, 33.22133], [-117.34601, 33.22126], [-117.34708, 33.22082], [-117.34761, 33.22064], [-117.34876, 33.22035], [-117.34927, 33.22026], [-117.34966, 33.22022], [-117.35, 33.22021], [-117.35069, 33.22025], [-117.35104, 33.2203], [-117.35254, 33.2206], [-117.35291, 33.22066], [-117.35297, 33.22065], [-117.35304, 33.22062], [-117.35494, 33.22047], [-117.3557, 33.22034], [-117.35595, 33.22028], [-117.35623, 33.22017], [-117.35691, 33.21985], [-117.35704, 33.21977], [-117.35737, 33.21951], [-117.35738, 33.21946], [-117.3577, 33.21928], [-117.35774, 33.2195], [-117.35777, 33.21962], [-117.35821, 33.22048], [-117.35829, 33.22068], [-117.35833, 33.22089]]], [[[-117.34597, 33.22544], [-117.34569, 33.22514], [-117.34562, 33.22503], [-117.34556, 33.22489], [-117.34554, 33.22468], [-117.34555, 33.2246], [-117.34561, 33.2244], [-117.34562, 33.22422], [-117.34561, 33.22415], [-117.34571, 33.22422], [-117.34583, 33.22434], [-117.34593, 33.22452], [-117.34596, 33.22466], [-117.34596, 33.22483], [-117.34597, 33.22484], [-117.34597, 33.22544]]], [[[-117.36568, 33.22618], [-117.36071, 33.23001], [-117.35738, 33.23258], [-117.35738, 33.22687], [-117.35819, 33.22685], [-117.35817, 33.22233], [-117.35835, 33.22206], [-117.35846, 33.22181], [-117.35855, 33.22179], [-117.35904, 33.22189], [-117.35917, 33.2219], [-117.35934, 33.22189], [-117.3595, 33.22185], [-117.35962, 33.22179], [-117.35973, 33.22172], [-117.36048, 33.22104], [-117.36056, 33.22093], [-117.3606, 33.22081], [-117.36062, 33.22036], [-117.3607, 33.21981], [-117.36084, 33.21932], [-117.36139, 33.21961], [-117.3619, 33.21977], [-117.36219, 33.22024], [-117.36238, 33.22089], [-117.36199, 33.22094], [-117.36203, 33.22114], [-117.36282, 33.22117], [-117.36316, 33.22184], [-117.36333, 33.22185], [-117.36568, 33.22618]]], [[[-117.31047, 33.23792], [-117.30894, 33.23791], [-117.30849, 33.2379], [-117.3093, 33.2372], [-117.30934, 33.23719], [-117.30939, 33.23721], [-117.30968, 33.23747], [-117.30997, 33.23768], [-117.3102, 33.2378], [-117.31047, 33.23792]]], [[[-117.34668, 33.22643], [-117.34652, 33.22656], [-117.34631, 33.22676], [-117.34601, 33.22713], [-117.34584, 33.22744], [-117.34575, 33.22768], [-117.34567, 33.22793], [-117.34563, 33.22814], [-117.34549, 33.22913], [-117.34531, 33.23061], [-117.34526, 33.23083], [-117.34517, 33.23113], [-117.34503, 33.23143], [-117.34537, 33.23157], [-117.34519, 33.23187], [-117.34511, 33.23198], [-117.34453, 33.23261], [-117.34441, 33.23278], [-117.34423, 33.23235], [-117.34398, 33.23264], [-117.34394, 33.23423], [-117.34368, 33.23798], [-117.34352, 33.24232], [-117.34474, 33.24237], [-117.34264, 33.24404], [-117.33842, 33.24089], [-117.33769, 33.24132], [-117.33609, 33.24142], [-117.33608, 33.24159], [-117.33664, 33.24159], [-117.33683, 33.24175], [-117.33691, 33.24213], [-117.33694, 33.2423], [-117.3365, 33.24245], [-117.33638, 33.24264], [-117.33632, 33.24288], [-117.33635, 33.24316], [-117.33619, 33.24342], [-117.33604, 33.24375], [-117.33602, 33.24397], [-117.33602, 33.24423], [-117.33588, 33.2444], [-117.33585, 33.24483], [-117.33608, 33.24505], [-117.33641, 33.24517], [-117.33693, 33.24503], [-117.33683, 33.24534], [-117.3367, 33.24549], [-117.33651, 33.24581], [-117.33621, 33.24619], [-117.33642, 33.24649], [-117.33655, 33.24685], [-117.33658, 33.24723], [-117.33683, 33.24756], [-117.33708, 33.24822], [-117.33562, 33.24932], [-117.33514, 33.24814], [-117.33419, 33.24728], [-117.33369, 33.24558], [-117.33243, 33.24497], [-117.33109, 33.24498], [-117.33106, 33.24131], [-117.32829, 33.24131], [-117.32826, 33.24129], [-117.32682, 33.24129], [-117.32681, 33.24128], [-117.32459, 33.24128], [-117.32433, 33.24132], [-117.32368, 33.24132], [-117.32347, 33.24129], [-117.32311, 33.2413], [-117.32286, 33.24167], [-117.32277, 33.24167], [-117.32276, 33.24118], [-117.32272, 33.24117], [-117.32269, 33.23965], [-117.32281, 33.23964], [-117.32278, 33.23929], [-117.3228, 33.23929], [-117.32315, 33.23973], [-117.32787, 33.23969], [-117.32788, 33.23974], [-117.33102, 33.23974], [-117.33103, 33.23958], [-117.33178, 33.23957], [-117.33227, 33.23949], [-117.3352, 33.23947], [-117.33523, 33.23805], [-117.33855, 33.23805], [-117.33859, 33.23641], [-117.33859, 33.23551], [-117.33837, 33.23515], [-117.3395, 33.23455], [-117.33953, 33.2327], [-117.33955, 33.23229], [-117.33965, 33.22712], [-117.34169, 33.22708], [-117.3417, 33.22707], [-117.34161, 33.22684], [-117.34265, 33.22684], [-117.34247, 33.22568], [-117.34252, 33.22522], [-117.34263, 33.22462], [-117.34282, 33.22404], [-117.34311, 33.22343], [-117.34383, 33.22251], [-117.34401, 33.22264], [-117.34417, 33.22278], [-117.34529, 33.22385], [-117.34537, 33.22398], [-117.34542, 33.22417], [-117.34542, 33.22433], [-117.34535, 33.22461], [-117.34535, 33.22483], [-117.34537, 33.22493], [-117.34544, 33.22509], [-117.34555, 33.22526], [-117.34633, 33.22609], [-117.34668, 33.22643]]], [[[-117.32245, 33.24112], [-117.31436, 33.24123], [-117.31383, 33.24167], [-117.31195, 33.24167], [-117.31192, 33.24127], [-117.31135, 33.24125], [-117.31057, 33.24126], [-117.30964, 33.24132], [-117.30851, 33.24145], [-117.30779, 33.24157], [-117.30786, 33.24175], [-117.30607, 33.24329], [-117.30521, 33.2433], [-117.30519, 33.24297], [-117.30518, 33.24296], [-117.3049, 33.24307], [-117.30469, 33.24318], [-117.30435, 33.24347], [-117.30417, 33.24366], [-117.30381, 33.24399], [-117.30336, 33.24453], [-117.30294, 33.24518], [-117.3029, 33.24529], [-117.3029, 33.24535], [-117.30288, 33.24542], [-117.30197, 33.24688], [-117.30147, 33.24775], [-117.30135, 33.24798], [-117.3013, 33.24814], [-117.30119, 33.24827], [-117.30109, 33.24824], [-117.30104, 33.24834], [-117.30094, 33.24845], [-117.30066, 33.24891], [-117.30063, 33.24915], [-117.30071, 33.24923], [-117.30089, 33.24923], [-117.30099, 33.2492], [-117.30081, 33.2494], [-117.30081, 33.24941], [-117.30056, 33.24974], [-117.30031, 33.25017], [-117.30017, 33.25046], [-117.30002, 33.25063], [-117.29727, 33.24977], [-117.29734, 33.24962], [-117.29739, 33.24956], [-117.29756, 33.24948], [-117.29771, 33.24948], [-117.29782, 33.24936], [-117.29834, 33.24872], [-117.29884, 33.24817], [-117.29943, 33.24743], [-117.29961, 33.24719], [-117.29994, 33.24667], [-117.30043, 33.24589], [-117.30103, 33.24486], [-117.30151, 33.2441], [-117.30162, 33.24386], [-117.30168, 33.24375], [-117.302, 33.24328], [-117.30235, 33.24283], [-117.30274, 33.2424], [-117.3033, 33.24187], [-117.30359, 33.24164], [-117.30358, 33.24163], [-117.3008, 33.24162], [-117.30091, 33.24146], [-117.30102, 33.24116], [-117.30113, 33.24113], [-117.30122, 33.24115], [-117.30153, 33.2412], [-117.30178, 33.24121], [-117.30358, 33.24117], [-117.30396, 33.24113], [-117.30426, 33.24106], [-117.30454, 33.24098], [-117.30477, 33.24089], [-117.30517, 33.2407], [-117.30553, 33.24046], [-117.30837, 33.23802], [-117.31165, 33.23801], [-117.31379, 33.23803], [-117.31381, 33.23868], [-117.31771, 33.23865], [-117.31816, 33.23895], [-117.31817, 33.23911], [-117.32236, 33.23911], [-117.32234, 33.23965], [-117.32243, 33.23966], [-117.32245, 33.24112]]], [[[-117.29983, 33.25083], [-117.29981, 33.25088], [-117.29821, 33.2528], [-117.29801, 33.253], [-117.29783, 33.25314], [-117.29705, 33.25391], [-117.29693, 33.25407], [-117.29665, 33.25455], [-117.29646, 33.25457], [-117.29614, 33.25463], [-117.29567, 33.25477], [-117.29536, 33.2549], [-117.29484, 33.25517], [-117.29445, 33.25536], [-117.29377, 33.25562], [-117.29304, 33.25582], [-117.29243, 33.25593], [-117.29002, 33.25592], [-117.28954, 33.25583], [-117.28896, 33.25568], [-117.28771, 33.25525], [-117.28846, 33.25423], [-117.28808, 33.25404], [-117.2878, 33.25438], [-117.287, 33.25395], [-117.28735, 33.25349], [-117.28743, 33.25337], [-117.28094, 33.24997], [-117.27814, 33.25354], [-117.27758, 33.25322], [-117.28119, 33.24865], [-117.28943, 33.25295], [-117.28914, 33.25334], [-117.29066, 33.25459], [-117.29113, 33.25462], [-117.29155, 33.25462], [-117.29205, 33.25457], [-117.29261, 33.25447], [-117.29312, 33.25433], [-117.29345, 33.25421], [-117.2939, 33.25401], [-117.29442, 33.25372], [-117.29468, 33.25354], [-117.29499, 33.2533], [-117.2953, 33.253], [-117.29544, 33.25285], [-117.29646, 33.2515], [-117.29753, 33.25004], [-117.29776, 33.25012], [-117.29774, 33.25014], [-117.29774, 33.25016], [-117.29978, 33.2508], [-117.29983, 33.25083]]]]} | Open Access 1 | 12612 | San Luis Rey River Trail | 30381 | 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 | https://www.ci.oceanside.ca.us/gov/ns/parks/amenities/trails.asp | San Diego 4 | 1136.596 | San Luis Rey River Trail | 0 | Local Recreation Area 3 | 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 |
15141 | 15141 | 15140 | {"type": "Polygon", "coordinates": [[[-117.32181, 33.23522], [-117.32171, 33.23556], [-117.32162, 33.23557], [-117.32159, 33.23552], [-117.32146, 33.23545], [-117.32138, 33.23537], [-117.32154, 33.23522], [-117.32176, 33.23511], [-117.32181, 33.23522]]]} | Open Access 1 | 45966 | Mission Wells Historical Lot | 29115 | 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#9 | San Diego 4 | 0.286 | Mission Wells Historical Lot | 0 | Local Other or Unknown 14 | 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 |
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 |
8237 | 8237 | 8236 | {"type": "Polygon", "coordinates": [[[-117.30159, 33.24391], [-117.30151, 33.2441], [-117.30103, 33.24486], [-117.30043, 33.24589], [-117.29961, 33.24719], [-117.29884, 33.24818], [-117.29836, 33.24868], [-117.29782, 33.24936], [-117.2977, 33.24948], [-117.29756, 33.24948], [-117.29743, 33.24954], [-117.29734, 33.24962], [-117.29727, 33.24977], [-117.29659, 33.24956], [-117.29658, 33.2495], [-117.29549, 33.24912], [-117.29547, 33.24907], [-117.29552, 33.24895], [-117.29554, 33.24885], [-117.29739, 33.24885], [-117.29741, 33.24795], [-117.29762, 33.24708], [-117.29898, 33.24525], [-117.29951, 33.24284], [-117.30159, 33.24391]]]} | Open Access 1 | 12613 | Mance Buchanon | 21729 | 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#56 | San Diego 4 | 30.237 | Mance Buchanon | None 689 | ||
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 |
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 |
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 |
4386 | 4386 | 4385 | {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} | Restricted Access 2 | 45967 | South Oceanside School Park | 31598 | 2100 | Oceanside Unified School District 756 | Special District 4 | School District 14 | http://www.oside.k12.ca.us/ | Special District 4 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 | San Diego 4 | 4.254 | South Oceanside School Park | 0 | Local Park 2 | 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 |
333 | 333 | 332 | {"type": "Polygon", "coordinates": [[[-117.36415, 33.18341], [-117.36312, 33.1846], [-117.36238, 33.18376], [-117.36324, 33.18324], [-117.36415, 33.18341]]]} | Open Access 1 | 961 | Marshall Street Swim Center & Park | 21898 | 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#46 | San Diego 4 | 3.024 | Marshall Street Swim Ctr. & Park | 0 | Local Park 2 | 4 |
1488 | 1488 | 1487 | {"type": "Polygon", "coordinates": [[[-117.38198, 33.1918], [-117.3816, 33.19202], [-117.38153, 33.19195], [-117.38151, 33.19189], [-117.38155, 33.19186], [-117.38052, 33.19067], [-117.38086, 33.19047], [-117.38198, 33.1918]]]} | Open Access 1 | 12699 | Tyson Street Park | 26633 | 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#43 | San Diego 4 | 1.725 | Tyson Street Park | 0 | Local Park 2 | 4 |
8228 | 8228 | 8227 | {"type": "Polygon", "coordinates": [[[-117.38275, 33.19269], [-117.38235, 33.19291], [-117.38201, 33.19252], [-117.3824, 33.19229], [-117.38275, 33.19269]]]} | Open Access 1 | 12668 | Strand Beach Park (Seagaze Park) | 25906 | 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#42 | San Diego 4 | 0.6 | Strand Beach Park (Seagaze Park) | None 687 | ||
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 |
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 |
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 |
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 |
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]);