units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where DES_TP = 2, MNG_AGENCY = 101 and MNG_AG_TYP = 3 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- County Agency · 68 ✖
MNG_AGENCY 1
- San Diego, County of · 68 ✖
DES_TP 1
- Local Park · 68 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
254 | 254 | 253 | {"type": "Polygon", "coordinates": [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30167, 33.05611], [-117.30173, 33.05629]]]} | Open Access 1 | 704 | Seaside Gardens County Park | 25250 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 0.15 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
761 | 761 | 760 | {"type": "Polygon", "coordinates": [[[-117.2805, 33.06873], [-117.28049, 33.07082], [-117.2805, 33.07144], [-117.27943, 33.07144], [-117.27942, 33.07234], [-117.27801, 33.07234], [-117.27792, 33.07143], [-117.27683, 33.07143], [-117.27656, 33.06872], [-117.2805, 33.06873]]]} | Open Access 1 | 4959 | Magdalena Ecke Park | 21667 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 29.785 | Magdalena Ecke Park | 0 | Local Park 2 | 4 | |
843 | 843 | 842 | {"type": "Polygon", "coordinates": [[[-116.9683, 32.73338], [-116.9683, 32.73465], [-116.96616, 32.73505], [-116.9659, 32.73378], [-116.96606, 32.73382], [-116.96615, 32.73378], [-116.96618, 32.73375], [-116.96619, 32.73366], [-116.96615, 32.73359], [-116.96606, 32.73356], [-116.96598, 32.73356], [-116.96587, 32.73363], [-116.96582, 32.73336], [-116.9683, 32.73338]]]} | Open Access 1 | 4978 | Del Parque Park | 18044 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 8.751 | Del Parque Park | 0 | Local Park 2 | 4 | |
854 | 854 | 853 | {"type": "Polygon", "coordinates": [[[-116.11437, 32.67551], [-116.11002, 32.6755], [-116.10767, 32.67548], [-116.10778, 32.67525], [-116.10795, 32.67478], [-116.10802, 32.67445], [-116.10806, 32.67418], [-116.10805, 32.6737], [-116.10792, 32.67306], [-116.10777, 32.67268], [-116.10697, 32.67118], [-116.10689, 32.67095], [-116.10682, 32.67052], [-116.10683, 32.6702], [-116.10686, 32.66997], [-116.10714, 32.66874], [-116.10721, 32.6682], [-116.11014, 32.66819], [-116.11432, 32.66822], [-116.11437, 32.67551]]]} | Open Access 1 | 5543 | Mountain Springs County Park | 22548 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 129.801 | Mtn. Springs County Park | 0 | Local Park 2 | 4 | |
1159 | 1159 | 1158 | {"type": "Polygon", "coordinates": [[[-116.86115, 32.85694], [-116.85942, 32.85842], [-116.85825, 32.85715], [-116.85827, 32.85712], [-116.86003, 32.85568], [-116.86115, 32.85694]]]} | Open Access 1 | 7359 | Rios Canyon Park | 24393 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 10.061 | Rios Canyon Park | 0 | Local Park 2 | 4 | |
4240 | 4240 | 4239 | {"type": "Polygon", "coordinates": [[[-117.30167, 33.05611], [-117.30158, 33.05598], [-117.30138, 33.05554], [-117.30104, 33.05461], [-117.30076, 33.05468], [-117.30008, 33.0527], [-117.30033, 33.05262], [-117.30167, 33.05611]]]} | Open Access 1 | 1699 | Seaside Gardens County Park | 25250 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 1.833 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
5190 | 5190 | 5189 | {"type": "Polygon", "coordinates": [[[-116.9854, 32.75274], [-116.98539, 32.75383], [-116.98392, 32.75381], [-116.98395, 32.75166], [-116.98499, 32.75167], [-116.98497, 32.75273], [-116.9854, 32.75274]]]} | Open Access 1 | 4996 | Estrella Park | 29276 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 6.925 | Estrella Park | 0 | Local Park 2 | 4 | |
6026 | 6026 | 6025 | {"type": "Polygon", "coordinates": [[[-117.3003, 33.05251], [-117.30004, 33.05256], [-117.29996, 33.05233], [-117.29941, 33.05098], [-117.29921, 33.05081], [-117.29929, 33.05081], [-117.29929, 33.0508], [-117.2992, 33.05012], [-117.29918, 33.04985], [-117.29908, 33.04958], [-117.29912, 33.04946], [-117.29967, 33.05081], [-117.29972, 33.05081], [-117.30002, 33.05167], [-117.30005, 33.05183], [-117.3003, 33.05251]]]} | Open Access 1 | 706 | Seaside Gardens County Park | 25250 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 2.1 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
7405 | 7405 | 7404 | {"type": "MultiPolygon", "coordinates": [[[[-117.23498, 33.26852], [-117.23496, 33.27233], [-117.23359, 33.27235], [-117.23078, 33.27536], [-117.2318, 33.27604], [-117.23496, 33.27267], [-117.23495, 33.27324], [-117.23464, 33.27384], [-117.23427, 33.27442], [-117.23398, 33.27479], [-117.2335, 33.27532], [-117.23297, 33.2758], [-117.23238, 33.27624], [-117.23175, 33.27664], [-117.23131, 33.27687], [-117.2296, 33.27764], [-117.22894, 33.27798], [-117.22851, 33.27823], [-117.22812, 33.2785], [-117.22775, 33.27877], [-117.2274, 33.27907], [-117.22706, 33.27938], [-117.2263, 33.28031], [-117.22556, 33.28144], [-117.22523, 33.28242], [-117.22503, 33.28174], [-117.22578, 33.27963], [-117.22622, 33.27921], [-117.22623, 33.2761], [-117.22649, 33.2759], [-117.22668, 33.27572], [-117.22705, 33.27529], [-117.22744, 33.27491], [-117.22765, 33.27474], [-117.22792, 33.27457], [-117.22842, 33.27429], [-117.22867, 33.27417], [-117.22899, 33.27408], [-117.22942, 33.27402], [-117.22972, 33.27394], [-117.22985, 33.2739], [-117.23058, 33.27357], [-117.23079, 33.27345], [-117.23183, 33.27282], [-117.23212, 33.27261], [-117.23234, 33.27239], [-117.23282, 33.27179], [-117.23295, 33.27157], [-117.23302, 33.27139], [-117.23305, 33.27113], [-117.23304, 33.27089], [-117.23312, 33.27088], [-117.23313, 33.26857], [-117.23498, 33.26852]]], [[[-117.22101, 33.29299], [-117.22101, 33.29463], [-117.22047, 33.29505], [-117.2195, 33.29631], [-117.21933, 33.29663], [-117.21973, 33.29664], [-117.21935, 33.29772], [-117.21915, 33.29819], [-117.21898, 33.29849], [-117.21878, 33.29877], [-117.21791, 33.29973], [-117.21752, 33.30024], [-117.21752, 33.30028], [-117.21746, 33.30029], [-117.2171, 33.30092], [-117.21714, 33.30094], [-117.21679, 33.30156], [-117.2167, 33.30187], [-117.21659, 33.3021], [-117.21638, 33.30236], [-117.21613, 33.30257], [-117.21582, 33.30273], [-117.21461, 33.3032], [-117.21433, 33.30334], [-117.21402, 33.30354], [-117.21369, 33.3032], [-117.21166, 33.30492], [-117.20899, 33.30653], [-117.20816, 33.30681], [-117.20803, 33.30738], [-117.20798, 33.3074], [-117.208, 33.30742], [-117.20575, 33.30789], [-117.1988, 33.30926], [-117.19536, 33.30995], [-117.19489, 33.31006], [-117.19476, 33.3096], [-117.19539, 33.30858], [-117.19637, 33.308], [-117.19704, 33.30771], [-117.19751, 33.30765], [-117.19807, 33.30773], [-117.19838, 33.30772], [-117.19871, 33.30758], [-117.19925, 33.30719], [-117.1994, 33.30701], [-117.19949, 33.30671], [-117.2, 33.30637], [-117.2002, 33.30614], [-117.20024, 33.30599], [-117.20274, 33.30505], [-117.20322, 33.30471], [-117.20374, 33.30425], [-117.20445, 33.3039], [-117.20626, 33.30282], [-117.20718, 33.30208], [-117.20829, 33.30028], [-117.21061, 33.29909], [-117.21174, 33.29842], [-117.21174, 33.2984], [-117.21162, 33.29828], [-117.2121, 33.29803], [-117.21283, 33.2976], [-117.21304, 33.29744], [-117.21387, 33.29677], [-117.21415, 33.29663], [-117.21459, 33.29651], [-117.21472, 33.29646], [-117.21484, 33.29639], [-117.21517, 33.29616], [-117.21526, 33.29608], [-117.21533, 33.29599], [-117.2154, 33.29588], [-117.21543, 33.29577], [-117.21555, 33.29434], [-117.21563, 33.29409], [-117.21572, 33.29395], [-117.21588, 33.2938], [-117.21658, 33.29325], [-117.2167, 33.29311], [-117.21677, 33.29298], [-117.22101, 33.29299]]], [[[-117.17733, 33.31358], [-117.17383, 33.31428], [-117.16985, 33.3143], [-117.16983, 33.31791], [-117.16585, 33.31793], [-117.16581, 33.31518], [-117.16597, 33.31501], [-117.1661, 33.31492], [-117.16631, 33.31513], [-117.16754, 33.31432], [-117.16932, 33.31297], [-117.17072, 33.31254], [-117.17158, 33.31259], [-117.17432, 33.31214], [-117.17474, 33.31238], [-117.17529, 33.3124], [-117.17733, 33.31358]]]]} | No Public Access 3 | 47590 | San Luis Rey River Park | 31317 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 473.331 | San Luis Rey River Park | 0 | Local Park 2 | 4 | |
7619 | 7619 | 7618 | {"type": "Polygon", "coordinates": [[[-116.82786, 32.82212], [-116.82777, 32.82238], [-116.82768, 32.82304], [-116.82756, 32.82342], [-116.82751, 32.82344], [-116.82696, 32.82328], [-116.82688, 32.82324], [-116.82678, 32.8231], [-116.82662, 32.82264], [-116.8266, 32.82253], [-116.82663, 32.82209], [-116.82665, 32.82201], [-116.82738, 32.82222], [-116.82739, 32.82221], [-116.82738, 32.82197], [-116.82786, 32.82212]]]} | Open Access 1 | 47633 | Old Ironsides County Park | 31372 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 3.365 | Old Ironsides County Park | 0 | Local Park 2 | 4 | |
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 0 | Local Park 2 | 4 |
1324 | 1324 | 1323 | {"type": "Polygon", "coordinates": [[[-117.28327, 33.05261], [-117.28325, 33.0544], [-117.28105, 33.05439], [-117.27903, 33.05436], [-117.27912, 33.0521], [-117.27921, 33.0508], [-117.28122, 33.05083], [-117.28114, 33.05261], [-117.28327, 33.05261]]]} | Open Access 1 | 47628 | San Diego Botanic Garden | 31367 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdbgarden.org/ | San Diego 4 | 28.386 | San Diego Botanic Garden | 0 | Local Park 2 | 4 |
6239 | 6239 | 6238 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 1304 | 4S Ranch Heritage Park | 29226 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.39 | 4S Ranch Heritage Park | 0 | Local Park 2 | 4 |
15150 | 15150 | 15149 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11261, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 45993 | 4S Ranch Liberty Park | 29187 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 4.774 | 4S Ranch Liberty Park | 0 | Local Park 2 | 4 |
15156 | 15156 | 15155 | {"type": "Polygon", "coordinates": [[[-117.10945, 33.02613], [-117.1071, 33.02507], [-117.10729, 33.02431], [-117.10808, 33.02445], [-117.10808, 33.02453], [-117.10813, 33.02459], [-117.10823, 33.02463], [-117.10995, 33.02563], [-117.10997, 33.02568], [-117.10993, 33.02573], [-117.10955, 33.02601], [-117.10945, 33.02613]]]} | Open Access 1 | 46005 | 4S Ranch Patriot Park | 29266 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.762 | 4S Ranch Patriot Park | 0 | Local Park 2 | 4 |
15157 | 15157 | 15156 | {"type": "Polygon", "coordinates": [[[-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.0117], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151]]]} | Open Access 1 | 46006 | 4S Ranch Homestead Park | 29267 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | San Diego 4 | 1.801 | 4S Ranch Homestead Park | 0 | Local Park 2 | 4 |
3654 | 3654 | 3653 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11707, 33.00365], [-117.11615, 33.00356], [-117.11606, 33.00392], [-117.11566, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 29594 | 4S Ranch Community Park | 29225 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | San Diego 4 | 5.809 | 4S Ranch Community Park | 0 | Local Park 2 | 4 |
16318 | 16318 | 16317 | {"type": "Polygon", "coordinates": [[[-116.31206, 32.9622], [-116.31195, 32.96223], [-116.30382, 32.96232], [-116.29498, 32.9623], [-116.29506, 32.95855], [-116.28653, 32.95866], [-116.28678, 32.95114], [-116.29521, 32.951], [-116.29529, 32.94721], [-116.30306, 32.94726], [-116.31135, 32.94726], [-116.31206, 32.9622]]]} | Open Access 1 | 5247 | Agua Caliente Regional Park | 29024 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/AguaCaliente.html | San Diego 4 | 802.564 | Agua Caliente RP | 0 | Local Park 2 | 4 |
763 | 763 | 762 | {"type": "Polygon", "coordinates": [[[-117.00133, 32.74581], [-117.00084, 32.74581], [-117.00081, 32.74585], [-117.00087, 32.74595], [-117.00053, 32.74629], [-117.00034, 32.74616], [-117.00008, 32.74645], [-116.99996, 32.74633], [-116.99954, 32.74618], [-116.99953, 32.74531], [-117.00019, 32.74531], [-117.0002, 32.74539], [-117.00067, 32.74538], [-117.00066, 32.74515], [-117.00083, 32.74497], [-117.00083, 32.74462], [-117.00132, 32.74461], [-117.00133, 32.74581]]]} | Open Access 1 | 4973 | Bancroft Park | 15792 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Bancroft.html | San Diego 4 | 4.676 | Bancroft Park | 0 | Local Park 2 | 4 |
6709 | 6709 | 6708 | {"type": "MultiPolygon", "coordinates": [[[[-116.91484, 32.86884], [-116.91485, 32.87034], [-116.91482, 32.87063], [-116.91469, 32.87097], [-116.91454, 32.87121], [-116.91438, 32.87142], [-116.91412, 32.87164], [-116.91342, 32.87076], [-116.91262, 32.87037], [-116.91096, 32.87045], [-116.91023, 32.86652], [-116.91402, 32.86599], [-116.91456, 32.86881], [-116.91484, 32.86884]]], [[[-116.91825, 32.86993], [-116.91733, 32.87197], [-116.91627, 32.87239], [-116.91504, 32.87239], [-116.91426, 32.87179], [-116.91425, 32.87177], [-116.91446, 32.87159], [-116.91462, 32.87141], [-116.91477, 32.8712], [-116.91487, 32.87103], [-116.91497, 32.87078], [-116.91502, 32.87058], [-116.91505, 32.87035], [-116.91505, 32.8701], [-116.91599, 32.87019], [-116.91531, 32.87033], [-116.91536, 32.87052], [-116.91825, 32.86993]]]]} | Open Access 1 | 5036 | Cactus Park | 16651 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cactus.html | San Diego 4 | 61.039 | Cactus 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]);