units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
68 rows where DES_TP = 2 and MNG_AGENCY = 101 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 | |
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 |
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 | |
15161 | 15161 | 15160 | {"type": "Polygon", "coordinates": [[[-117.17283, 32.71998], [-117.17281, 32.72264], [-117.17279, 32.72265], [-117.1728, 32.72408], [-117.17172, 32.72444], [-117.17123, 32.72212], [-117.17121, 32.72193], [-117.1712, 32.71998], [-117.17283, 32.71998]]]} | Open Access 1 | 46010 | Waterfront Park | 29274 | 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/Waterfront.html | San Diego 4 | 16.256 | Waterfront Park | 0 | Local Park 2 | 4 |
15160 | 15160 | 15159 | {"type": "Polygon", "coordinates": [[[-116.93134, 32.608], [-116.93126, 32.60819], [-116.93077, 32.60814], [-116.92998, 32.60819], [-116.92945, 32.60825], [-116.92907, 32.60836], [-116.92898, 32.60832], [-116.92901, 32.60821], [-116.92941, 32.60736], [-116.92939, 32.60723], [-116.92945, 32.60712], [-116.93046, 32.60712], [-116.9308, 32.60725], [-116.93096, 32.60738], [-116.9311, 32.60753], [-116.93127, 32.60761], [-116.93121, 32.60792], [-116.93134, 32.608]]]} | Open Access 1 | 46009 | Otay Lakes County Park | 29273 | 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/OtayLakes.html | San Diego 4 | 5.178 | Otay Lakes County Park | 0 | Local Park 2 | 4 |
4392 | 4392 | 4391 | {"type": "Polygon", "coordinates": [[[-117.00165, 32.68355], [-117.0004, 32.68385], [-117.00037, 32.6838], [-117.0005, 32.68375], [-117.00074, 32.68356], [-117.00061, 32.68345], [-117.00052, 32.68333], [-117.00036, 32.6829], [-116.99999, 32.68213], [-116.9997, 32.68168], [-117.00012, 32.68136], [-117.00066, 32.68121], [-117.00114, 32.68245], [-117.00116, 32.68249], [-117.00127, 32.68246], [-117.00165, 32.68355]]]} | Open Access 1 | 46008 | Eastview County Park | 29272 | 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/Eastview.html | San Diego 4 | 6.275 | Eastview County 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 |
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 |
15155 | 15155 | 15154 | {"type": "Polygon", "coordinates": [[[-117.26172, 33.23522], [-117.26167, 33.23532], [-117.26162, 33.23567], [-117.26158, 33.23571], [-117.26152, 33.23572], [-117.25839, 33.23528], [-117.25808, 33.23522], [-117.2578, 33.23515], [-117.25759, 33.23507], [-117.25758, 33.23505], [-117.25634, 33.23461], [-117.25603, 33.23452], [-117.25573, 33.23445], [-117.25539, 33.23441], [-117.25511, 33.23439], [-117.25261, 33.23448], [-117.25203, 33.23441], [-117.25168, 33.23433], [-117.25138, 33.23423], [-117.25104, 33.23407], [-117.25088, 33.23397], [-117.25053, 33.23371], [-117.25031, 33.23348], [-117.25004, 33.2331], [-117.24996, 33.23293], [-117.24984, 33.23254], [-117.24915, 33.23077], [-117.25154, 33.23012], [-117.25191, 33.227], [-117.25548, 33.22704], [-117.25598, 33.22639], [-117.25833, 33.22825], [-117.25858, 33.22889], [-117.25792, 33.23418], [-117.25992, 33.23456], [-117.26001, 33.23465], [-117.26012, 33.23471], [-117.26172, 33.23522]]]} | Open Access 1 | 46004 | Rancho Guajome Adobe County Park | 29264 | 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/RanchoGuajomeAdobe.html | San Diego 4 | 150.934 | Rancho Guajome Adobe County Park | 0 | Local Park 2 | 4 |
15154 | 15154 | 15153 | {"type": "Polygon", "coordinates": [[[-116.95371, 32.85528], [-116.95174, 32.85529], [-116.95196, 32.85508], [-116.95181, 32.85489], [-116.9518, 32.85479], [-116.95182, 32.85474], [-116.95194, 32.85473], [-116.952, 32.85467], [-116.95203, 32.8546], [-116.95201, 32.85452], [-116.95197, 32.85447], [-116.95202, 32.85441], [-116.95203, 32.85425], [-116.95194, 32.85409], [-116.9519, 32.85407], [-116.95191, 32.85392], [-116.95184, 32.85392], [-116.95169, 32.85397], [-116.9513, 32.85426], [-116.95109, 32.85433], [-116.95107, 32.85446], [-116.95029, 32.85447], [-116.95029, 32.85338], [-116.9537, 32.85336], [-116.95371, 32.85528]]]} | Open Access 1 | 46000 | Lakeside Baseball Park | 29206 | 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/LakesideBallfield.html | San Diego 4 | 12.548 | Lakeside Baseball Park | 0 | Local Park 2 | 4 |
15153 | 15153 | 15152 | {"type": "Polygon", "coordinates": [[[-117.01386, 32.72777], [-117.0139, 32.72806], [-117.0139, 32.72816], [-117.01388, 32.72821], [-117.01382, 32.7283], [-117.01375, 32.72838], [-117.01357, 32.72848], [-117.01357, 32.7277], [-117.01378, 32.72776], [-117.01386, 32.72777]]]} | Open Access 1 | 45999 | Ildica Street Park | 29205 | 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/IldicaStreetPark.html | San Diego 4 | 0.504 | Ildica Street Park | 0 | Local Park 2 | 4 |
3908 | 3908 | 3907 | {"type": "Polygon", "coordinates": [[[-116.93617, 32.74656], [-116.93581, 32.74674], [-116.93549, 32.74631], [-116.93585, 32.74615], [-116.93617, 32.74656]]]} | Open Access 1 | 45998 | Hillsdale Park | 29204 | 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/Hillsdale.html | San Diego 4 | 0.53 | Hillsdale 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 |
14928 | 14928 | 14927 | {"type": "Polygon", "coordinates": [[[-117.25461, 33.36874], [-117.2546, 33.3693], [-117.25423, 33.3693], [-117.25423, 33.36873], [-117.25461, 33.36874]]]} | Open Access 1 | 45505 | Clemmens Lane County Park | 28337 | 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/Clemmens.html | San Diego 4 | 0.544 | Clemmens Lane County Park | 2009 | Local Park 2 | 4 |
13224 | 13224 | 13223 | {"type": "MultiPolygon", "coordinates": [[[[-117.09269, 32.55829], [-117.09263, 32.56415], [-117.09055, 32.56414], [-117.09051, 32.56369], [-117.08947, 32.56369], [-117.08949, 32.56007], [-117.09055, 32.56006], [-117.09056, 32.55828], [-117.09269, 32.55829]]], [[[-117.10137, 32.56011], [-117.10133, 32.56544], [-117.09793, 32.56548], [-117.0971, 32.56548], [-117.09709, 32.56469], [-117.09388, 32.56469], [-117.09387, 32.56424], [-117.09282, 32.56424], [-117.09285, 32.55829], [-117.09377, 32.55829], [-117.09567, 32.559], [-117.09568, 32.55829], [-117.09604, 32.55829], [-117.09604, 32.55914], [-117.09819, 32.55915], [-117.09819, 32.55956], [-117.09926, 32.55957], [-117.09926, 32.56009], [-117.10137, 32.56011]]]]} | Open Access 1 | 45246 | Tijuana River Valley Regional Park | 13879 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | San Diego 4 | 169.576 | Tijuana River Valley RP | 0 | Local Park 2 | 4 |
16429 | 16429 | 16428 | {"type": "MultiPolygon", "coordinates": [[[[-117.08193, 32.54359], [-117.08193, 32.54404], [-117.08176, 32.54414], [-117.08156, 32.5442], [-117.08155, 32.54359], [-117.08193, 32.54359]]], [[[-117.07141, 32.54461], [-117.07128, 32.54463], [-117.07119, 32.54462], [-117.07116, 32.54459], [-117.07116, 32.54444], [-117.07129, 32.54455], [-117.07141, 32.54461]]], [[[-117.07302, 32.54484], [-117.07156, 32.54449], [-117.07146, 32.54445], [-117.07129, 32.54433], [-117.07124, 32.54426], [-117.07116, 32.54411], [-117.07119, 32.54305], [-117.07115, 32.54289], [-117.0711, 32.54274], [-117.07131, 32.54285], [-117.07146, 32.54295], [-117.07173, 32.54316], [-117.07189, 32.54332], [-117.07205, 32.54351], [-117.07215, 32.54367], [-117.07302, 32.54484]]], [[[-117.08194, 32.5453], [-117.08157, 32.5453], [-117.08156, 32.54434], [-117.08174, 32.5443], [-117.08193, 32.54421], [-117.08194, 32.5453]]], [[[-117.10157, 32.53695], [-117.10155, 32.54306], [-117.10157, 32.54478], [-117.10121, 32.54501], [-117.10092, 32.54514], [-117.1002, 32.54563], [-117.09998, 32.54581], [-117.09956, 32.546], [-117.09935, 32.54605], [-117.09903, 32.54607], [-117.09874, 32.54603], [-117.0985, 32.54596], [-117.09686, 32.54563], [-117.09677, 32.54557], [-117.09665, 32.54552], [-117.09639, 32.54545], [-117.09605, 32.54544], [-117.0959, 32.54547], [-117.09562, 32.54548], [-117.09537, 32.54545], [-117.09509, 32.54536], [-117.09495, 32.54528], [-117.09482, 32.54519], [-117.0947, 32.5451], [-117.09458, 32.54496], [-117.09353, 32.54441], [-117.09332, 32.54436], [-117.0931, 32.54435], [-117.09292, 32.54438], [-117.09278, 32.54442], [-117.09276, 32.54356], [-117.08828, 32.54358], [-117.08812, 32.54352], [-117.08642, 32.54351], [-117.08408, 32.54353], [-117.08407, 32.54252], [-117.08272, 32.54252], [-117.08272, 32.54354], [-117.08084, 32.54355], [-117.08084, 32.54437], [-117.08016, 32.54452], [-117.08013, 32.54355], [-117.07795, 32.54357], [-117.07796, 32.54485], [-117.07627, 32.54486], [-117.07627, 32.5459], [-117.07563, 32.54584], [-117.07424, 32.54583], [-117.07411, 32.5458], [-117.07399, 32.54576], [-117.07389, 32.5457], [-117.07377, 32.5456], [-117.07228, 32.5436], [-117.07219, 32.54344], [-117.07199, 32.5432], [-117.07178, 32.54301], [-117.07153, 32.54281], [-117.07128, 32.54267], [-117.0711, 32.54258], [-117.07112, 32.54], [-117.07334, 32.53999], [-117.07946, 32.53946], [-117.08409, 32.53926], [-117.08506, 32.54025], [-117.08758, 32.54023], [-117.08759, 32.53999], [-117.08846, 32.53953], [-117.09009, 32.53933], [-117.09193, 32.53891], [-117.09453, 32.53864], [-117.09532, 32.53862], [-117.09568, 32.53891], [-117.0965, 32.53891], [-117.09718, 32.53853], [-117.09849, 32.53814], [-117.10007, 32.53686], [-117.10157, 32.53695]]], [[[-117.10585, 32.54377], [-117.10584, 32.54731], [-117.10576, 32.54732], [-117.10576, 32.54377], [-117.10585, 32.54377]]], [[[-117.1016, 32.54732], [-117.09288, 32.54732], [-117.09285, 32.54664], [-117.09285, 32.54512], [-117.09284, 32.54473], [-117.09281, 32.54459], [-117.09291, 32.54455], [-117.09314, 32.54451], [-117.09328, 32.54452], [-117.09344, 32.54456], [-117.0936, 32.54463], [-117.0937, 32.54471], [-117.09445, 32.54508], [-117.09457, 32.54521], [-117.09471, 32.54534], [-117.09486, 32.54544], [-117.09503, 32.54552], [-117.09532, 32.54561], [-117.09558, 32.54565], [-117.09582, 32.54565], [-117.09608, 32.5456], [-117.09636, 32.54561], [-117.0966, 32.54568], [-117.09678, 32.54579], [-117.09844, 32.54612], [-117.09853, 32.54616], [-117.09872, 32.5462], [-117.09893, 32.54623], [-117.09923, 32.54623], [-117.09938, 32.54621], [-117.09968, 32.54614], [-117.09987, 32.54607], [-117.10013, 32.54592], [-117.10031, 32.54577], [-117.1007, 32.54551], [-117.10099, 32.5453], [-117.1013, 32.54516], [-117.10157, 32.54498], [-117.1016, 32.54732]]], [[[-117.0885, 32.54724], [-117.08629, 32.54721], [-117.0863, 32.54538], [-117.08739, 32.54537], [-117.08736, 32.54369], [-117.08806, 32.54369], [-117.08816, 32.5437], [-117.08825, 32.54378], [-117.08837, 32.54396], [-117.08845, 32.54413], [-117.0885, 32.54724]]], [[[-117.09384, 32.55778], [-117.09383, 32.55815], [-117.09285, 32.55815], [-117.09285, 32.55777], [-117.09384, 32.55778]]], [[[-117.10606, 32.5586], [-117.10571, 32.55859], [-117.1057, 32.55838], [-117.10148, 32.55833], [-117.10149, 32.5583], [-117.10605, 32.5583], [-117.10606, 32.5586]]], [[[-117.09275, 32.55093], [-117.09268, 32.55815], [-117.08418, 32.55813], [-117.08419, 32.55448], [-117.08437, 32.55447], [-117.08438, 32.55436], [-117.08437, 32.55435], [-117.08419, 32.55436], [-117.08418, 32.55418], [-117.08419, 32.55089], [-117.09275, 32.55093]]], [[[-117.06228, 32.5546], [-117.06228, 32.55681], [-117.06223, 32.55707], [-117.06211, 32.55742], [-117.06201, 32.55751], [-117.06188, 32.55756], [-117.06118, 32.55754], [-117.06066, 32.55742], [-117.06009, 32.55724], [-117.0596, 32.55707], [-117.05707, 32.55606], [-117.05613, 32.55565], [-117.05614, 32.5551], [-117.05646, 32.55509], [-117.05644, 32.55455], [-117.05809, 32.55454], [-117.05811, 32.55279], [-117.06225, 32.55457], [-117.06228, 32.5546]]], [[[-117.10139, 32.55833], [-117.10137, 32.56011], [-117.09925, 32.56009], [-117.09927, 32.55832], [-117.10139, 32.55833]]], [[[-117.08409, 32.5564], [-117.07974, 32.5564], [-117.07974, 32.55815], [-117.07532, 32.55815], [-117.07531, 32.56004], [-117.07196, 32.56004], [-117.07211, 32.55984], [-117.07172, 32.55962], [-117.0716, 32.55962], [-117.0716, 32.55957], [-117.07158, 32.55954], [-117.07152, 32.55949], [-117.07149, 32.55949], [-117.07052, 32.55891], [-117.06727, 32.55688], [-117.06725, 32.55689], [-117.06718, 32.55682], [-117.06694, 32.5567], [-117.06676, 32.55665], [-117.06675, 32.55646], [-117.06643, 32.55659], [-117.06601, 32.55672], [-117.06533, 32.55684], [-117.0647, 32.5569], [-117.06405, 32.5569], [-117.06355, 32.55686], [-117.06302, 32.55678], [-117.06256, 32.55666], [-117.06255, 32.55664], [-117.06256, 32.55265], [-117.06254, 32.55195], [-117.06259, 32.55166], [-117.06266, 32.55143], [-117.0628, 32.55118], [-117.06505, 32.54927], [-117.06956, 32.5526], [-117.06963, 32.55256], [-117.07039, 32.5532], [-117.07057, 32.55332], [-117.07085, 32.55347], [-117.07108, 32.55356], [-117.07109, 32.55348], [-117.0711, 32.55348], [-117.0713, 32.55354], [-117.07152, 32.55356], [-117.0718, 32.55356], [-117.07193, 32.55355], [-117.07197, 32.55366], [-117.07212, 32.55364], [-117.07199, 32.55317], [-117.07187, 32.55319], [-117.07188, 32.55328], [-117.07179, 32.55329], [-117.07154, 32.55329], [-117.07135, 32.55327], [-117.07109, 32.55321], [-117.07108, 32.55314], [-117.07093, 32.55309], [-117.07074, 32.55298], [-117.06992, 32.55231], [-117.06995, 32.55225], [-117.0655, 32.54887], [-117.06764, 32.54711], [-117.06956, 32.54545], [-117.06988, 32.54523], [-117.07016, 32.54509], [-117.07046, 32.54496], [-117.07089, 32.54483], [-117.07135, 32.54476], [-117.0718, 32.54475], [-117.07227, 32.5448], [-117.07289, 32.54495], [-117.07304, 32.545], [-117.0732, 32.5451], [-117.07326, 32.54516], [-117.07364, 32.54568], [-117.07378, 32.5458], [-117.07399, 32.54591], [-117.07414, 32.54596], [-117.07427, 32.54598], [-117.07543, 32.54598], [-117.07543, 32.54677], [-117.07335, 32.54678], [-117.07273, 32.54673], [-117.07243, 32.54667], [-117.07191, 32.54654], [-117.07163, 32.54643], [-117.0711, 32.5462], [-117.07111, 32.54673], [-117.07148, 32.54689], [-117.07188, 32.54702], [-117.07247, 32.54716], [-117.07334, 32.54725], [-117.07542, 32.54723], [-117.07543, 32.54718], [-117.08085, 32.54719], [-117.08397, 32.54717], [-117.08397, 32.55408], [-117.08326, 32.55408], [-117.08325, 32.55454], [-117.08408, 32.55455], [-117.08409, 32.5564]]], [[[-117.08408, 32.55826], [-117.08407, 32.56117], [-117.07896, 32.56115], [-117.07542, 32.56117], [-117.07541, 32.55826], [-117.08408, 32.55826]]]]} | Open Access 1 | 45085 | Tijuana River Valley Regional Park | 13879 | 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/TJRVRP.html | San Diego 4 | 1321.284 | Tijuana River Valley RP | 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 |
3171 | 3171 | 3170 | {"type": "Polygon", "coordinates": [[[-117.07154, 32.66675], [-117.07129, 32.66682], [-117.07133, 32.66693], [-117.07096, 32.66703], [-117.07084, 32.66671], [-117.07146, 32.66654], [-117.07154, 32.66675]]]} | Open Access 1 | 26057 | Lincoln Acres Park | 21245 | 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/LincolnAcres.html | San Diego 4 | 0.484 | Lincoln Acres Park | 0 | Local Park 2 | 4 |
12345 | 12345 | 12344 | {"type": "MultiPolygon", "coordinates": [[[[-116.36349, 32.9753], [-116.36347, 32.97586], [-116.34903, 32.97614], [-116.34864, 32.97612], [-116.34825, 32.97607], [-116.34782, 32.976], [-116.34743, 32.97589], [-116.34678, 32.97561], [-116.34632, 32.97535], [-116.34609, 32.97521], [-116.34606, 32.97518], [-116.3474, 32.97517], [-116.35338, 32.97521], [-116.36349, 32.9753]]], [[[-116.36369, 32.97613], [-116.36368, 32.97685], [-116.3475, 32.97688], [-116.34745, 32.97619], [-116.34765, 32.97624], [-116.34809, 32.97633], [-116.34847, 32.97638], [-116.34903, 32.97642], [-116.34934, 32.97642], [-116.36369, 32.97613]]]]} | Open Access 1 | 26037 | Vallecito County Park | 29260 | 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/Vallecito.html | San Diego 4 | 57.618 | Vallecito County 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]);