units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where MNG_AGENCY = 101 and MNG_AG_LEV = 3 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST, GAP_STS
DES_TP 11
- Local Park 68
- Local Conservation Area 37
- Local Recreation Area 7
- Local Other or Unknown 4
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
AGNCY_WEB 4 ✖
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency 123
MNG_AGENCY 1
- San Diego, County of · 123 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5408 | 5408 | 5407 | {"type": "Polygon", "coordinates": [[[-116.81981, 33.02977], [-116.8111, 33.02981], [-116.81109, 33.03475], [-116.81112, 33.03724], [-116.80247, 33.03726], [-116.80249, 33.03342], [-116.79575, 33.03337], [-116.7939, 33.03338], [-116.78948, 33.03332], [-116.7896, 33.02616], [-116.78509, 33.02618], [-116.78506, 33.0267], [-116.78495, 33.02974], [-116.78077, 33.02975], [-116.78072, 33.03206], [-116.78073, 33.03214], [-116.78051, 33.0373], [-116.77195, 33.03733], [-116.77187, 33.04415], [-116.76347, 33.04418], [-116.7635, 33.04086], [-116.76778, 33.04085], [-116.76776, 33.03734], [-116.77194, 33.03732], [-116.77212, 33.03338], [-116.77631, 33.03336], [-116.77632, 33.03302], [-116.77635, 33.03297], [-116.77634, 33.03283], [-116.77654, 33.02623], [-116.77239, 33.02624], [-116.77253, 33.02267], [-116.77191, 33.00828], [-116.77177, 33.00579], [-116.77467, 33.00636], [-116.78232, 33.01272], [-116.78474, 33.01283], [-116.78474, 33.0184], [-116.7894, 33.01824], [-116.79601, 33.0188], [-116.7999, 33.01916], [-116.79819, 33.0217], [-116.79691, 33.02514], [-116.79561, 33.02902], [-116.7956, 33.02911], [-116.80396, 33.02931], [-116.8139, 33.02775], [-116.81537, 33.0275], [-116.81616, 33.02756], [-116.81691, 33.02777], [-116.81803, 33.02843], [-116.81981, 33.02942], [-116.81981, 33.02977]]]} | Open Access 1 | 12525 | Mt. Gower Preserve | 30285 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/MtGower.html | San Diego 4 | 1522.886 | Mt. Gower Preserve | 0 | Local Conservation Area 4 | 2 |
6865 | 6865 | 6864 | {"type": "Polygon", "coordinates": [[[-116.88206, 32.9016], [-116.87735, 32.90152], [-116.87743, 32.90675], [-116.87754, 32.91269], [-116.87364, 32.91266], [-116.87363, 32.91259], [-116.86927, 32.9126], [-116.86073, 32.91264], [-116.86073, 32.91536], [-116.85906, 32.91535], [-116.85857, 32.91537], [-116.84119, 32.9155], [-116.84121, 32.91914], [-116.84126, 32.92277], [-116.83271, 32.92285], [-116.83293, 32.93288], [-116.83278, 32.93287], [-116.83277, 32.93288], [-116.83424, 32.93483], [-116.82384, 32.93501], [-116.8236, 32.92202], [-116.82359, 32.91926], [-116.8236, 32.91642], [-116.83981, 32.91648], [-116.83994, 32.90146], [-116.83993, 32.90145], [-116.82362, 32.90223], [-116.82372, 32.8874], [-116.828, 32.8874], [-116.82799, 32.89121], [-116.83615, 32.89146], [-116.84492, 32.89538], [-116.84472, 32.89861], [-116.84891, 32.89856], [-116.84889, 32.90108], [-116.8525, 32.90092], [-116.85243, 32.90479], [-116.84825, 32.9049], [-116.84828, 32.9088], [-116.85647, 32.90867], [-116.85649, 32.90782], [-116.8565, 32.90482], [-116.86949, 32.9051], [-116.86958, 32.90132], [-116.86968, 32.8984], [-116.86146, 32.89843], [-116.86208, 32.89371], [-116.87781, 32.88967], [-116.87782, 32.89258], [-116.88195, 32.89201], [-116.88202, 32.89926], [-116.88206, 32.9016]]]} | Open Access 1 | 5516 | El Capitan Preserve | 30283 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElCapitan.html | San Diego 4 | 2603.63 | El Capitan Preserve | 0 | Local Conservation Area 4 | 2 |
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 |
7371 | 7371 | 7370 | {"type": "MultiPolygon", "coordinates": [[[[-116.86639, 32.64508], [-116.85755, 32.65151], [-116.84988, 32.64452], [-116.83978, 32.6535], [-116.84011, 32.64195], [-116.84001, 32.63453], [-116.85687, 32.6339], [-116.86632, 32.63397], [-116.8663, 32.63756], [-116.86637, 32.64162], [-116.86639, 32.64508]]], [[[-116.86655, 32.61902], [-116.86648, 32.62263], [-116.85735, 32.62253], [-116.8575, 32.61887], [-116.85328, 32.61895], [-116.85341, 32.6153], [-116.85765, 32.61523], [-116.85766, 32.61522], [-116.86235, 32.61529], [-116.86229, 32.61895], [-116.86655, 32.61902]]], [[[-116.89127, 32.62103], [-116.88695, 32.62103], [-116.88698, 32.62282], [-116.88243, 32.62281], [-116.88238, 32.62103], [-116.88012, 32.62103], [-116.88014, 32.61181], [-116.88905, 32.61191], [-116.88897, 32.61919], [-116.89126, 32.61923], [-116.89127, 32.62103]]], [[[-116.89403, 32.68807], [-116.88945, 32.68809], [-116.88943, 32.68986], [-116.88507, 32.6899], [-116.88499, 32.6881], [-116.88498, 32.68628], [-116.8872, 32.68625], [-116.88718, 32.68453], [-116.894, 32.68446], [-116.89403, 32.68807]]], [[[-116.9108, 32.60449], [-116.91078, 32.61199], [-116.89349, 32.61196], [-116.8934, 32.60454], [-116.9108, 32.60449]]], [[[-116.9023, 32.67355], [-116.89805, 32.67354], [-116.89802, 32.67032], [-116.90228, 32.6703], [-116.9023, 32.67355]]], [[[-116.92781, 32.66319], [-116.91926, 32.66312], [-116.91924, 32.66405], [-116.91912, 32.66399], [-116.91867, 32.66361], [-116.91849, 32.66338], [-116.91783, 32.66291], [-116.91751, 32.66259], [-116.91698, 32.66218], [-116.91629, 32.66151], [-116.91562, 32.661], [-116.91537, 32.66092], [-116.91511, 32.66091], [-116.91485, 32.66092], [-116.91489, 32.65935], [-116.91629, 32.65938], [-116.91632, 32.65562], [-116.9278, 32.65584], [-116.92781, 32.66319]]], [[[-116.9485, 32.60875], [-116.94821, 32.60883], [-116.94815, 32.60864], [-116.94799, 32.60841], [-116.94773, 32.60837], [-116.9475, 32.6084], [-116.94739, 32.60869], [-116.94739, 32.60906], [-116.94742, 32.60929], [-116.94734, 32.60969], [-116.94734, 32.60992], [-116.94738, 32.61022], [-116.94743, 32.61044], [-116.94749, 32.61058], [-116.9478, 32.61102], [-116.94786, 32.61125], [-116.94789, 32.61154], [-116.94788, 32.61175], [-116.94781, 32.61196], [-116.9477, 32.61218], [-116.94757, 32.61233], [-116.94741, 32.61249], [-116.94719, 32.61264], [-116.94704, 32.61273], [-116.94666, 32.61303], [-116.94652, 32.61342], [-116.94644, 32.61381], [-116.94655, 32.61422], [-116.94661, 32.6148], [-116.94671, 32.61502], [-116.94664, 32.61532], [-116.94647, 32.61551], [-116.94636, 32.61556], [-116.9461, 32.61561], [-116.94598, 32.6156], [-116.94581, 32.61554], [-116.94563, 32.61541], [-116.94524, 32.61528], [-116.94507, 32.61536], [-116.9451, 32.61559], [-116.94526, 32.61583], [-116.94535, 32.61608], [-116.94537, 32.61635], [-116.94531, 32.61658], [-116.94524, 32.61655], [-116.94451, 32.61703], [-116.94436, 32.61718], [-116.94427, 32.61735], [-116.94424, 32.61754], [-116.94426, 32.61802], [-116.94422, 32.61873], [-116.94416, 32.61915], [-116.94408, 32.61957], [-116.94392, 32.62017], [-116.94323, 32.62228], [-116.94298, 32.62294], [-116.94274, 32.62345], [-116.94252, 32.62383], [-116.9422, 32.62431], [-116.94185, 32.62477], [-116.94155, 32.6251], [-116.94113, 32.62552], [-116.94067, 32.62592], [-116.94033, 32.62618], [-116.93446, 32.61192], [-116.93444, 32.61181], [-116.93431, 32.61145], [-116.9337, 32.61008], [-116.93333, 32.60918], [-116.93421, 32.60895], [-116.93327, 32.60677], [-116.93401, 32.60657], [-116.93324, 32.60469], [-116.93298, 32.60475], [-116.93164, 32.60515], [-116.92891, 32.59854], [-116.93933, 32.5955], [-116.93933, 32.59113], [-116.93937, 32.58207], [-116.94513, 32.5821], [-116.94524, 32.59383], [-116.94269, 32.59453], [-116.94534, 32.60102], [-116.94534, 32.60104], [-116.94536, 32.60105], [-116.9485, 32.60875]]], [[[-116.96532, 32.58705], [-116.96529, 32.58711], [-116.96524, 32.58746], [-116.96526, 32.5878], [-116.96532, 32.58792], [-116.96231, 32.5888], [-116.96222, 32.58619], [-116.96221, 32.58429], [-116.96433, 32.58431], [-116.96437, 32.58459], [-116.96435, 32.58468], [-116.96443, 32.58532], [-116.9643, 32.58561], [-116.96436, 32.58577], [-116.96456, 32.58587], [-116.96514, 32.58598], [-116.96514, 32.58611], [-116.96525, 32.58636], [-116.96522, 32.58656], [-116.96532, 32.58705]]], [[[-116.97937, 32.58382], [-116.96896, 32.58686], [-116.9689, 32.5868], [-116.96865, 32.58659], [-116.96838, 32.58631], [-116.96819, 32.58627], [-116.968, 32.58606], [-116.96781, 32.58604], [-116.96723, 32.58604], [-116.96664, 32.5844], [-116.96574, 32.58455], [-116.9656, 32.58432], [-116.96664, 32.58432], [-116.96664, 32.58242], [-116.97107, 32.58246], [-116.97936, 32.58251], [-116.97937, 32.58382]]], [[[-116.98618, 32.61112], [-116.98584, 32.61131], [-116.98592, 32.61153], [-116.98568, 32.61161], [-116.98543, 32.61174], [-116.98533, 32.61174], [-116.98504, 32.61199], [-116.98461, 32.61232], [-116.98453, 32.61251], [-116.98451, 32.61261], [-116.98452, 32.61225], [-116.98456, 32.61219], [-116.9847, 32.61208], [-116.9847, 32.61206], [-116.98466, 32.612], [-116.98446, 32.61187], [-116.98445, 32.61182], [-116.98446, 32.61162], [-116.98449, 32.61153], [-116.98454, 32.61144], [-116.98461, 32.61139], [-116.98463, 32.61135], [-116.98462, 32.61119], [-116.98457, 32.61095], [-116.98458, 32.61089], [-116.98461, 32.61083], [-116.98467, 32.61062], [-116.98478, 32.61049], [-116.98486, 32.61033], [-116.98489, 32.61021], [-116.98496, 32.6101], [-116.98489, 32.60999], [-116.98489, 32.60976], [-116.98502, 32.60993], [-116.98504, 32.60993], [-116.98557, 32.61058], [-116.98618, 32.61112]]], [[[-116.99061, 32.60452], [-116.99046, 32.60532], [-116.99044, 32.60553], [-116.99036, 32.60581], [-116.99001, 32.60644], [-116.98993, 32.60662], [-116.98981, 32.60704], [-116.98935, 32.60734], [-116.98925, 32.60749], [-116.98912, 32.60783], [-116.98913, 32.60813], [-116.98795, 32.60955], [-116.98722, 32.61006], [-116.98659, 32.61084], [-116.98646, 32.61097], [-116.98582, 32.61041], [-116.98531, 32.60978], [-116.98516, 32.60986], [-116.98501, 32.60967], [-116.9852, 32.60968], [-116.98536, 32.60976], [-116.98547, 32.60976], [-116.98566, 32.60973], [-116.98594, 32.60962], [-116.98608, 32.6095], [-116.98621, 32.60935], [-116.98628, 32.60932], [-116.98638, 32.60904], [-116.98655, 32.60894], [-116.98689, 32.60884], [-116.98714, 32.60871], [-116.98726, 32.60852], [-116.98723, 32.6084], [-116.98728, 32.6081], [-116.98732, 32.60803], [-116.98783, 32.60768], [-116.98802, 32.60737], [-116.98804, 32.60681], [-116.98811, 32.60674], [-116.98869, 32.60645], [-116.98882, 32.60631], [-116.98903, 32.60523], [-116.98907, 32.60495], [-116.99061, 32.60452]]]]} | No Public Access 3 | 47589 | Otay Ranch Preserve | 31316 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 3245.845 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
7963 | 7963 | 7962 | {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} | Restricted Access 2 | 47729 | Otay Ranch Preserve | 31529 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 179.037 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
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 | |
256 | 256 | 255 | {"type": "Polygon", "coordinates": [[[-116.59188, 32.61847], [-116.59183, 32.62191], [-116.5879, 32.62185], [-116.57534, 32.62173], [-116.57533, 32.6218], [-116.57501, 32.62179], [-116.57504, 32.61913], [-116.5737, 32.61912], [-116.57357, 32.61185], [-116.5833, 32.61188], [-116.5833, 32.61473], [-116.58772, 32.61475], [-116.58772, 32.61842], [-116.59188, 32.61847]]]} | No Public Access 3 | 845 | Mason Wildlife Refuge | 21944 | 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 | 353.869 | Mason Wildlife Refuge | 0 | Local Conservation Area 4 | 2 | |
273 | 273 | 272 | {"type": "Polygon", "coordinates": [[[-117.22664, 33.05068], [-117.22596, 33.05276], [-117.2242, 33.05232], [-117.22397, 33.05269], [-117.22342, 33.05309], [-117.22333, 33.0532], [-117.22327, 33.05335], [-117.22319, 33.05333], [-117.22285, 33.05437], [-117.2217, 33.05409], [-117.22056, 33.05378], [-117.21929, 33.05347], [-117.21921, 33.05335], [-117.2161, 33.05151], [-117.2152, 33.05153], [-117.21517, 33.05106], [-117.21518, 33.05083], [-117.21545, 33.0506], [-117.21594, 33.05075], [-117.21635, 33.05105], [-117.21679, 33.05145], [-117.21732, 33.05162], [-117.21818, 33.05212], [-117.21855, 33.05236], [-117.2191, 33.05245], [-117.21953, 33.05245], [-117.22, 33.05237], [-117.22063, 33.05218], [-117.22118, 33.05198], [-117.22176, 33.05197], [-117.22196, 33.05142], [-117.22206, 33.05144], [-117.22209, 33.05145], [-117.2219, 33.052], [-117.2221, 33.05204], [-117.22236, 33.0522], [-117.22247, 33.05237], [-117.22239, 33.05293], [-117.22239, 33.05312], [-117.22257, 33.05319], [-117.22287, 33.05307], [-117.22318, 33.05292], [-117.22333, 33.05278], [-117.22331, 33.05265], [-117.22347, 33.05211], [-117.22328, 33.0517], [-117.2231, 33.0515], [-117.22291, 33.05106], [-117.22291, 33.05094], [-117.22294, 33.05091], [-117.22296, 33.0508], [-117.22288, 33.05078], [-117.22291, 33.05061], [-117.22294, 33.0506], [-117.22293, 33.05044], [-117.22297, 33.0501], [-117.22301, 33.0501], [-117.22307, 33.05], [-117.22299, 33.04997], [-117.22302, 33.04982], [-117.22309, 33.04984], [-117.22316, 33.04971], [-117.22322, 33.04966], [-117.2235, 33.04936], [-117.22355, 33.04924], [-117.22352, 33.04914], [-117.22363, 33.049], [-117.22362, 33.04898], [-117.22385, 33.04877], [-117.2239, 33.04867], [-117.22389, 33.04866], [-117.22404, 33.04837], [-117.22402, 33.04835], [-117.22407, 33.04826], [-117.22407, 33.04819], [-117.22411, 33.04819], [-117.22416, 33.04806], [-117.2241, 33.04804], [-117.22416, 33.0479], [-117.2241, 33.04783], [-117.22609, 33.04832], [-117.22544, 33.05038], [-117.22664, 33.05068]]]} | Open Access 1 | 745 | Val Sereno Preserve | 26755 | 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 | 54.542 | Val Sereno Preserve | 0 | Local Conservation Area 4 | 2 | |
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 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://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
433 | 433 | 432 | {"type": "Polygon", "coordinates": [[[-116.59781, 32.61496], [-116.59778, 32.61691], [-116.592, 32.61684], [-116.59195, 32.61847], [-116.58772, 32.61842], [-116.58772, 32.61307], [-116.59204, 32.61313], [-116.59203, 32.6113], [-116.59613, 32.61131], [-116.59619, 32.61494], [-116.59781, 32.61496]]]} | Open Access 1 | 836 | Potrero Park | 23926 | 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/Potrero.html | San Diego 4 | 126.277 | Potrero Park | 0 | Local Park 2 | 4 |
575 | 575 | 574 | {"type": "Polygon", "coordinates": [[[-116.55091, 32.68226], [-116.5509, 32.68904], [-116.54671, 32.68903], [-116.54666, 32.69624], [-116.54247, 32.69617], [-116.54246, 32.69264], [-116.53813, 32.69259], [-116.53815, 32.68901], [-116.53404, 32.68893], [-116.53398, 32.69617], [-116.53815, 32.6962], [-116.53809, 32.71037], [-116.53398, 32.71042], [-116.53382, 32.71605], [-116.53385, 32.72189], [-116.52947, 32.72189], [-116.52952, 32.72556], [-116.52511, 32.72556], [-116.5252, 32.71823], [-116.52073, 32.71818], [-116.52069, 32.71598], [-116.52077, 32.71459], [-116.51671, 32.71461], [-116.5166, 32.70729], [-116.50784, 32.70735], [-116.50786, 32.71104], [-116.50351, 32.71109], [-116.5035, 32.71481], [-116.49896, 32.71499], [-116.4951, 32.71505], [-116.4951, 32.71112], [-116.49937, 32.71107], [-116.49957, 32.6966], [-116.50366, 32.69661], [-116.50364, 32.70018], [-116.50784, 32.70019], [-116.508, 32.69288], [-116.51156, 32.6929], [-116.51245, 32.69289], [-116.51259, 32.68983], [-116.51262, 32.68937], [-116.51405, 32.68937], [-116.51423, 32.68936], [-116.51428, 32.6885], [-116.51487, 32.68809], [-116.51478, 32.68764], [-116.51501, 32.68738], [-116.515, 32.68715], [-116.51517, 32.68685], [-116.51506, 32.68635], [-116.51528, 32.68609], [-116.51576, 32.68605], [-116.51581, 32.68607], [-116.51608, 32.68574], [-116.51671, 32.68596], [-116.51671, 32.68474], [-116.51678, 32.68255], [-116.51675, 32.68254], [-116.51675, 32.68218], [-116.52375, 32.68219], [-116.52543, 32.68216], [-116.52542, 32.67813], [-116.53399, 32.67817], [-116.534, 32.67113], [-116.53823, 32.67113], [-116.5382, 32.67463], [-116.54239, 32.67461], [-116.54239, 32.67817], [-116.54667, 32.67819], [-116.5467, 32.68224], [-116.55091, 32.68226]], [[-116.534, 32.67817], [-116.53399, 32.67818], [-116.53399, 32.68219], [-116.53814, 32.68223], [-116.53816, 32.6782], [-116.534, 32.67817]]]} | Open Access 1 | 3446 | Lake Morena County Park | 10398 | 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/LakeMorena.html | San Diego 4 | 3278.988 | Lake Morena County Park | 0 | Local Park 2 | 4 |
601 | 601 | 600 | {"type": "Polygon", "coordinates": [[[-116.86232, 33.04283], [-116.86091, 33.04362], [-116.85968, 33.04204], [-116.8611, 33.04126], [-116.86164, 33.04196], [-116.86161, 33.04199], [-116.86171, 33.04211], [-116.86175, 33.04209], [-116.86232, 33.04283]]]} | Open Access 1 | 4174 | Collier Park | 17519 | 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/Collier.html | San Diego 4 | 8.145 | Collier Park | 0 | Local Park 2 | 4 |
677 | 677 | 676 | {"type": "Polygon", "coordinates": [[[-117.0076, 32.7182], [-117.00574, 32.7182], [-117.00573, 32.71601], [-117.00759, 32.71601], [-117.0076, 32.7182]]]} | Open Access 1 | 5123 | Sweetwater Lane County Park | 29258 | 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/SweetwaterLane.html | San Diego 4 | 10.435 | Sweetwater Lane 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 | |
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 |
802 | 802 | 801 | {"type": "Polygon", "coordinates": [[[-117.15085, 33.41386], [-117.14988, 33.41386], [-117.14987, 33.41211], [-117.15083, 33.4121], [-117.15085, 33.41386]]]} | Open Access 1 | 5212 | Rainbow Park | 24087 | 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/Rainbow.html | San Diego 4 | 4.328 | Rainbow Park | 0 | Local Park 2 | 4 |
811 | 811 | 810 | {"type": "MultiPolygon", "coordinates": [[[[-117.2369, 32.9958], [-117.23453, 32.99563], [-117.2341, 32.99565], [-117.23297, 32.99578], [-117.23256, 32.99581], [-117.23056, 32.99574], [-117.23036, 32.99575], [-117.23007, 32.99581], [-117.22987, 32.99588], [-117.22968, 32.99599], [-117.22933, 32.99552], [-117.22974, 32.99535], [-117.23001, 32.99528], [-117.23031, 32.99523], [-117.23045, 32.99524], [-117.23061, 32.99523], [-117.23062, 32.99521], [-117.23239, 32.99532], [-117.23242, 32.9953], [-117.23269, 32.99532], [-117.23396, 32.99517], [-117.23465, 32.99513], [-117.23542, 32.99532], [-117.23645, 32.99554], [-117.23678, 32.99567], [-117.2369, 32.9958]]], [[[-117.23859, 32.99818], [-117.23857, 33.00045], [-117.23843, 33.00087], [-117.23822, 33.00122], [-117.23805, 33.00137], [-117.2379, 33.00146], [-117.23668, 33.00197], [-117.23657, 33.00202], [-117.23624, 33.00226], [-117.23614, 33.00236], [-117.23599, 33.00256], [-117.23589, 33.00275], [-117.23581, 33.00295], [-117.23568, 33.0035], [-117.23558, 33.00372], [-117.23543, 33.00395], [-117.23535, 33.00396], [-117.23417, 33.00243], [-117.23417, 33.00241], [-117.23399, 33.00224], [-117.22959, 32.99637], [-117.22976, 32.99622], [-117.22997, 32.99609], [-117.2302, 32.99601], [-117.23041, 32.99596], [-117.23053, 32.99595], [-117.23227, 32.99602], [-117.2326, 32.99602], [-117.23311, 32.99599], [-117.23416, 32.99587], [-117.23453, 32.99585], [-117.23651, 32.99599], [-117.23674, 32.99602], [-117.23695, 32.99611], [-117.23709, 32.99619], [-117.23725, 32.99635], [-117.2373, 32.9964], [-117.23772, 32.99729], [-117.23782, 32.99744], [-117.23808, 32.99773], [-117.23859, 32.99818]]], [[[-117.2386, 32.99605], [-117.2386, 32.99605], [-117.23859, 32.99794], [-117.2382, 32.9976], [-117.23798, 32.99734], [-117.23783, 32.99709], [-117.23749, 32.99637], [-117.23737, 32.99619], [-117.23723, 32.99603], [-117.2386, 32.99605]]]]} | Open Access 1 | 5234 | San Dieguito Park | 24867 | 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/SanDieguito.html | San Diego 4 | 119.501 | San Dieguito Park | 0 | Local Park 2 | 4 |
819 | 819 | 818 | {"type": "Polygon", "coordinates": [[[-117.25791, 33.37491], [-117.25791, 33.37556], [-117.25754, 33.37556], [-117.25754, 33.3752], [-117.25724, 33.37489], [-117.25791, 33.37491]]]} | Open Access 1 | 5304 | Don Dussault Park | 18203 | 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/DonDussault.html | San Diego 4 | 0.746 | Don Dussault Park | 0 | Local Park 2 | 4 |
828 | 828 | 827 | {"type": "Polygon", "coordinates": [[[-116.60586, 33.035], [-116.60569, 33.04233], [-116.60489, 33.0424], [-116.60129, 33.04245], [-116.60127, 33.04251], [-116.60002, 33.04253], [-116.5987, 33.0425], [-116.59842, 33.04233], [-116.59829, 33.04218], [-116.59813, 33.04195], [-116.59794, 33.04155], [-116.59784, 33.04137], [-116.59773, 33.04123], [-116.59756, 33.04106], [-116.59713, 33.04074], [-116.59716, 33.03891], [-116.5931, 33.03889], [-116.59285, 33.03891], [-116.59281, 33.0403], [-116.59279, 33.04249], [-116.58846, 33.04249], [-116.58844, 33.04973], [-116.58419, 33.04971], [-116.58417, 33.05062], [-116.57558, 33.05059], [-116.57561, 33.04971], [-116.57569, 33.0497], [-116.57555, 33.04248], [-116.58428, 33.04247], [-116.58426, 33.03632], [-116.58423, 33.03631], [-116.58416, 33.02825], [-116.58831, 33.02827], [-116.5925, 33.02826], [-116.59259, 33.02534], [-116.59252, 33.02528], [-116.59264, 33.02518], [-116.59278, 33.02511], [-116.59294, 33.02507], [-116.59311, 33.02506], [-116.59328, 33.02508], [-116.59344, 33.02513], [-116.59395, 33.02547], [-116.59409, 33.02551], [-116.59424, 33.02553], [-116.59439, 33.02552], [-116.59468, 33.02542], [-116.59704, 33.02542], [-116.59708, 33.02825], [-116.6015, 33.0282], [-116.60473, 33.02811], [-116.60482, 33.03499], [-116.60586, 33.035]], [[-116.58847, 33.0389], [-116.58852, 33.03726], [-116.58788, 33.03725], [-116.58785, 33.03796], [-116.58784, 33.03889], [-116.58847, 33.0389]], [[-116.5927, 33.03902], [-116.59271, 33.03901], [-116.59269, 33.03895], [-116.59071, 33.03894], [-116.58907, 33.03895], [-116.58908, 33.03902], [-116.5927, 33.03902]]]} | Open Access 1 | 5368 | William Heise County Park | 10697 | 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/WilliamHeise.html | San Diego 4 | 1012.3 | William Heise 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]);