units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
309 rows where COUNTY = 4 and DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY 23
- San Diego, City of 183
- Carlsbad, City of 12
- San Marcos, City of 12
- Poway, City of 10
- Oceanside, City of 8
- San Diego, County of 7
- Chula Vista, City of 7
- Escondido, City of 6
- Encinitas, City of 5
- El Cajon, City of 2
- Coronado, City of 2
- Valley Center Water District 2
- Sweetwater Authority 2
- Olivenhain Municipal Water District 2
- National City, City of 1
- Vista, City of 1
- Yuima Municipal Water District 1
- Helix Water District 1
- San Diego County Water Authority 1
- Vallecitos Water District 1
- Vista Unified School District 1
- Rainbow Municipal Water District 1
- Otay Water District 1
MNG_AG_TYP 5
ACCESS_TYP 4
- Open Access 237
- Restricted Access 16
- No Public Access 15
- Unknown Access 1
DES_TP 1
- Local Recreation Area · 269 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3419 | 3419 | 3418 | {"type": "Polygon", "coordinates": [[[-117.18086, 32.69355], [-117.18013, 32.69481], [-117.17921, 32.69442], [-117.17996, 32.69317], [-117.18086, 32.69355]], [[-117.18043, 32.6934], [-117.18043, 32.69338], [-117.18037, 32.69337], [-117.17965, 32.69459], [-117.17972, 32.69461], [-117.18043, 32.6934]]]} | Restricted Access 2 | 25118 | Cutler Field | 31610 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | San Diego 4 | 3.436 | Cutler Field | 0 | Local Recreation Area 3 | 4 | |
3556 | 3556 | 3555 | {"type": "Polygon", "coordinates": [[[-117.23771, 32.92887], [-117.23764, 32.92911], [-117.23752, 32.9294], [-117.23732, 32.92977], [-117.23735, 32.9298], [-117.23727, 32.92994], [-117.23672, 32.93067], [-117.23651, 32.93102], [-117.23436, 32.93101], [-117.23431, 32.92669], [-117.23586, 32.92657], [-117.23762, 32.92885], [-117.23771, 32.92887]]]} | Open Access 1 | 12154 | Arroyo Sorrento Open Space | 15633 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 29.661 | Arroyo Sorrento OS | 0 | Local Recreation Area 3 | 4 | |
3756 | 3756 | 3755 | {"type": "Polygon", "coordinates": [[[-117.18035, 32.94266], [-117.17962, 32.94267], [-117.1796, 32.94186], [-117.17996, 32.94211], [-117.18002, 32.94218], [-117.18014, 32.9424], [-117.18035, 32.94266]]]} | Open Access 1 | 464 | Del Mar Mesa Open Space | 18033 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.868 | Del Mar Mesa OS | 0 | Local Recreation Area 3 | 4 | |
3797 | 3797 | 3796 | {"type": "MultiPolygon", "coordinates": [[[[-117.007, 32.87455], [-117.00513, 32.87459], [-117.00513, 32.87459], [-117.0059, 32.87307], [-117.00666, 32.87307], [-117.00676, 32.87322], [-117.00643, 32.87323], [-117.00642, 32.87324], [-117.007, 32.87455]]], [[[-117.01663, 32.86839], [-117.01493, 32.86948], [-117.01329, 32.8671], [-117.01455, 32.86624], [-117.01459, 32.86612], [-117.01663, 32.86839]]], [[[-117.01772, 32.87281], [-117.01479, 32.87318], [-117.01447, 32.87138], [-117.01765, 32.87049], [-117.01772, 32.87281]]]]} | Open Access 1 | 45131 | City Open Space | 17337 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 34.702 | City OS | 0 | Local Recreation Area 3 | 4 | |
3798 | 3798 | 3797 | {"type": "MultiPolygon", "coordinates": [[[[-116.9578, 33.32443], [-116.94941, 33.3289], [-116.94271, 33.33233], [-116.93544, 33.32958], [-116.92862, 33.32705], [-116.91095, 33.32034], [-116.90797, 33.31919], [-116.91534, 33.31418], [-116.92002, 33.31102], [-116.92765, 33.31311], [-116.92793, 33.31298], [-116.92835, 33.31273], [-116.92842, 33.31228], [-116.929, 33.31186], [-116.92931, 33.31159], [-116.92979, 33.31131], [-116.93077, 33.311], [-116.93042, 33.31167], [-116.92952, 33.31213], [-116.92917, 33.31283], [-116.92805, 33.31344], [-116.92704, 33.31409], [-116.92582, 33.31491], [-116.92483, 33.31573], [-116.92386, 33.31674], [-116.92361, 33.31727], [-116.92383, 33.31777], [-116.92675, 33.31811], [-116.93088, 33.31862], [-116.93485, 33.318], [-116.93823, 33.31644], [-116.93821, 33.31671], [-116.93823, 33.31709], [-116.9382, 33.31734], [-116.93815, 33.31744], [-116.93808, 33.31751], [-116.93778, 33.31765], [-116.93785, 33.31774], [-116.93818, 33.31759], [-116.93827, 33.31749], [-116.93832, 33.31739], [-116.93836, 33.31715], [-116.93834, 33.31671], [-116.93837, 33.31633], [-116.94031, 33.31541], [-116.94087, 33.31561], [-116.94023, 33.31693], [-116.94024, 33.31695], [-116.94325, 33.31647], [-116.94478, 33.31671], [-116.94578, 33.31681], [-116.94575, 33.31803], [-116.94491, 33.31761], [-116.94483, 33.31757], [-116.94482, 33.31758], [-116.94292, 33.32426], [-116.95073, 33.32383], [-116.9542, 33.32362], [-116.9578, 33.32443]]], [[[-116.92717, 33.31458], [-116.92717, 33.31471], [-116.927, 33.31471], [-116.927, 33.31458], [-116.92717, 33.31458]]]]} | No Public Access 3 | 45133 | YMWD Open Space | 27772 | 2320 | Yuima Municipal Water District 684 | Special District 4 | Water District 13 | http://www.yuimamwd.com/ | Special District 4 | 2320 | Yuima Municipal Water District 675 | Special District 4 | Water District 13 | San Diego 4 | 1090.211 | YMWD OS | 0 | Local Recreation Area 3 | 4 | |
3822 | 3822 | 3821 | {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15822, 33.14036], [-117.15821, 33.14035], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13857], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} | No Public Access 3 | 45235 | San Marcos City Open Space | 24944 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 10.993 | San Marcos City OS | 0 | Local Recreation Area 3 | 4 | |
3826 | 3826 | 3825 | {"type": "Polygon", "coordinates": [[[-117.046, 33.25229], [-117.0459, 33.25362], [-117.04581, 33.25622], [-117.04584, 33.25988], [-117.04315, 33.25987], [-117.04304, 33.25622], [-117.04149, 33.2562], [-117.04135, 33.25228], [-117.046, 33.25229]]]} | No Public Access 3 | 45243 | Valley Center MWDD Open Space | 26786 | 2321 | Valley Center Water District 689 | Special District 4 | Water District 13 | http://www.vcmwd.org/ | Special District 4 | 2321 | Valley Center Water District 672 | Special District 4 | Water District 13 | San Diego 4 | 70.32 | Valley Ctr. MWDD OS | 0 | Local Recreation Area 3 | 4 | |
3945 | 3945 | 3944 | {"type": "Polygon", "coordinates": [[[-117.36791, 33.19918], [-117.36736, 33.19918], [-117.36709, 33.1993], [-117.36675, 33.19957], [-117.36642, 33.19973], [-117.36586, 33.19975], [-117.36586, 33.19902], [-117.36583, 33.19901], [-117.36582, 33.19886], [-117.3658, 33.19885], [-117.36579, 33.19846], [-117.3658, 33.19845], [-117.3658, 33.19825], [-117.36584, 33.19824], [-117.36584, 33.19795], [-117.36591, 33.19718], [-117.3661, 33.19717], [-117.36633, 33.19713], [-117.36658, 33.19704], [-117.3669, 33.19685], [-117.36694, 33.19684], [-117.367, 33.19687], [-117.36718, 33.19706], [-117.36758, 33.19753], [-117.36777, 33.19778], [-117.36785, 33.19792], [-117.3679, 33.19812], [-117.36791, 33.19918]]]} | Open Access 1 | 5770 | Ron Ortega Recreation Park | 24587 | 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#29 | San Diego 4 | 11.869 | Ron Ortega Rec. Park | 0 | Local Recreation Area 3 | 4 |
4207 | 4207 | 4206 | {"type": "Polygon", "coordinates": [[[-117.14189, 32.97462], [-117.14188, 32.97539], [-117.1417, 32.97557], [-117.14153, 32.97536], [-117.14155, 32.97482], [-117.14177, 32.97471], [-117.14189, 32.97462]]]} | Open Access 1 | 45283 | Torrey Brooke Open Space | 26469 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.654 | Torrey Brooke OS | 0 | Local Recreation Area 3 | 4 | |
4261 | 4261 | 4260 | {"type": "MultiPolygon", "coordinates": [[[[-117.03242, 32.56189], [-117.03233, 32.56408], [-117.0318, 32.56433], [-117.03151, 32.56443], [-117.03117, 32.56452], [-117.03079, 32.56457], [-117.03012, 32.56456], [-117.02974, 32.56461], [-117.02961, 32.56458], [-117.02954, 32.56454], [-117.02825, 32.56345], [-117.0281, 32.5634], [-117.02721, 32.56331], [-117.02723, 32.56173], [-117.02555, 32.56167], [-117.02535, 32.56199], [-117.02528, 32.5623], [-117.02503, 32.5626], [-117.02496, 32.56276], [-117.025, 32.5629], [-117.02509, 32.56296], [-117.02532, 32.56297], [-117.02504, 32.5632], [-117.0247, 32.56351], [-117.02421, 32.56407], [-117.02411, 32.56425], [-117.02344, 32.56567], [-117.02339, 32.56575], [-117.02328, 32.56586], [-117.02317, 32.56591], [-117.02277, 32.56602], [-117.0228, 32.55797], [-117.02719, 32.55808], [-117.02724, 32.56172], [-117.03242, 32.56189]]], [[[-117.03233, 32.56424], [-117.03228, 32.5654], [-117.03159, 32.56538], [-117.03088, 32.56542], [-117.03051, 32.56541], [-117.03025, 32.56543], [-117.03003, 32.56548], [-117.02985, 32.56554], [-117.02902, 32.56593], [-117.0289, 32.56603], [-117.02863, 32.56645], [-117.0286, 32.56658], [-117.0285, 32.5667], [-117.02815, 32.56674], [-117.02785, 32.56695], [-117.0278, 32.56725], [-117.0279, 32.56768], [-117.0277, 32.56775], [-117.02549, 32.56781], [-117.02393, 32.56803], [-117.02386, 32.56803], [-117.02424, 32.56757], [-117.02436, 32.56737], [-117.0247, 32.56708], [-117.02489, 32.56704], [-117.0254, 32.56685], [-117.02553, 32.56698], [-117.02554, 32.56697], [-117.02556, 32.56687], [-117.0259, 32.56708], [-117.02608, 32.56705], [-117.02629, 32.56695], [-117.02647, 32.56678], [-117.02659, 32.56644], [-117.02666, 32.56614], [-117.02673, 32.56603], [-117.02684, 32.5657], [-117.0269, 32.56568], [-117.027, 32.56531], [-117.02692, 32.56507], [-117.02674, 32.56481], [-117.02677, 32.56466], [-117.02654, 32.56438], [-117.02639, 32.56425], [-117.02599, 32.564], [-117.02594, 32.56374], [-117.02573, 32.5635], [-117.02549, 32.56335], [-117.02545, 32.56309], [-117.02555, 32.56303], [-117.02573, 32.56299], [-117.0259, 32.563], [-117.026, 32.56303], [-117.02666, 32.56332], [-117.02696, 32.56342], [-117.0272, 32.56346], [-117.02721, 32.56345], [-117.02807, 32.56353], [-117.02814, 32.56355], [-117.02821, 32.56359], [-117.02943, 32.56464], [-117.02953, 32.5647], [-117.02965, 32.56474], [-117.02981, 32.56475], [-117.03017, 32.5647], [-117.03078, 32.56471], [-117.03117, 32.56466], [-117.03142, 32.5646], [-117.03179, 32.56449], [-117.03205, 32.56438], [-117.03233, 32.56424]]]]} | Open Access 1 | 45194 | City of San Diego Open Space | 10307 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 127.055 | City of San Diego OS | 0 | Local Recreation Area 3 | 4 | |
4398 | 4398 | 4397 | {"type": "Polygon", "coordinates": [[[-117.18329, 33.14634], [-117.1828, 33.14626], [-117.17872, 33.14576], [-117.1788, 33.14537], [-117.17884, 33.14494], [-117.1789, 33.1446], [-117.17915, 33.1445], [-117.17921, 33.1445], [-117.17956, 33.14463], [-117.17994, 33.14406], [-117.18015, 33.14392], [-117.18033, 33.1437], [-117.18045, 33.1436], [-117.18329, 33.14634]]]} | Open Access 1 | 1831 | Mission Sports Park | 22312 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/163/1081 | San Diego 4 | 15.175 | Mission Sports Park | 0 | Local Recreation Area 3 | 4 |
4409 | 4409 | 4408 | {"type": "Polygon", "coordinates": [[[-117.0893, 32.71155], [-117.08929, 32.7132], [-117.08822, 32.7132], [-117.0882, 32.71148], [-117.08903, 32.71149], [-117.08918, 32.71151], [-117.0893, 32.71155]]]} | Open Access 1 | 2056 | Guymon Arms Open Space | 19577 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.762 | Guymon Arms OS | 0 | Local Recreation Area 3 | 4 | |
4913 | 4913 | 4912 | {"type": "Polygon", "coordinates": [[[-117.0835, 33.16545], [-117.08297, 33.16569], [-117.08281, 33.16578], [-117.08258, 33.16596], [-117.0824, 33.16616], [-117.0823, 33.16631], [-117.08099, 33.1689], [-117.08055, 33.16784], [-117.08057, 33.16783], [-117.0806, 33.16791], [-117.08073, 33.16802], [-117.08107, 33.16808], [-117.08126, 33.1679], [-117.0813, 33.16781], [-117.08104, 33.16772], [-117.08106, 33.16768], [-117.08136, 33.16777], [-117.08181, 33.16687], [-117.08187, 33.16673], [-117.0819, 33.16659], [-117.08189, 33.16635], [-117.0818, 33.16611], [-117.08154, 33.16625], [-117.08156, 33.16621], [-117.08344, 33.16511], [-117.0835, 33.16545]]]} | Open Access 1 | 12921 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 3.546 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
4915 | 4915 | 4914 | {"type": "Polygon", "coordinates": [[[-117.08135, 33.16636], [-117.08112, 33.1665], [-117.08077, 33.16723], [-117.08057, 33.16742], [-117.08047, 33.16756], [-117.08057, 33.16782], [-117.08055, 33.16784], [-117.0802, 33.167], [-117.08128, 33.16637], [-117.08135, 33.16636]]]} | Open Access 1 | 12925 | City of Escondido Open Space | 17312 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.075 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
4920 | 4920 | 4919 | {"type": "Polygon", "coordinates": [[[-117.10225, 32.79223], [-117.10151, 32.79253], [-117.10149, 32.79052], [-117.10171, 32.79054], [-117.10172, 32.79062], [-117.10193, 32.79058], [-117.102, 32.79053], [-117.10223, 32.79053], [-117.10225, 32.79223]]]} | Open Access 1 | 162 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.473 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
4931 | 4931 | 4930 | {"type": "Polygon", "coordinates": [[[-117.08503, 32.83302], [-117.08471, 32.83324], [-117.08463, 32.83339], [-117.08428, 32.83359], [-117.08401, 32.83357], [-117.08388, 32.83401], [-117.0839, 32.83406], [-117.08394, 32.83409], [-117.08399, 32.83411], [-117.08417, 32.83409], [-117.08432, 32.83411], [-117.0843, 32.8344], [-117.08426, 32.83464], [-117.08388, 32.83547], [-117.08379, 32.83556], [-117.08345, 32.83545], [-117.08316, 32.83583], [-117.08287, 32.83572], [-117.08284, 32.83597], [-117.08287, 32.83617], [-117.08286, 32.83621], [-117.08264, 32.83621], [-117.08263, 32.83573], [-117.08257, 32.83556], [-117.08247, 32.83562], [-117.08216, 32.83568], [-117.08217, 32.83588], [-117.08212, 32.83605], [-117.08206, 32.83602], [-117.08182, 32.83613], [-117.08175, 32.8361], [-117.08171, 32.83615], [-117.08165, 32.83637], [-117.08165, 32.83608], [-117.08168, 32.83596], [-117.08233, 32.83503], [-117.0825, 32.83506], [-117.08317, 32.8351], [-117.08346, 32.83491], [-117.0835, 32.83463], [-117.08319, 32.83412], [-117.08355, 32.83365], [-117.08422, 32.83326], [-117.0843, 32.83296], [-117.08488, 32.83288], [-117.08503, 32.83302]]]} | Open Access 1 | 227 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.345 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
4933 | 4933 | 4932 | {"type": "Polygon", "coordinates": [[[-117.10238, 32.83132], [-117.10221, 32.83161], [-117.10222, 32.83162], [-117.10227, 32.8316], [-117.10111, 32.83344], [-117.10107, 32.83348], [-117.101, 32.83347], [-117.09989, 32.83298], [-117.09944, 32.83286], [-117.0991, 32.83283], [-117.09887, 32.83283], [-117.09837, 32.83288], [-117.0979, 32.83303], [-117.09739, 32.8333], [-117.09675, 32.83386], [-117.09636, 32.83364], [-117.09626, 32.83369], [-117.09621, 32.83364], [-117.09615, 32.83364], [-117.09605, 32.83366], [-117.09564, 32.83365], [-117.09562, 32.83369], [-117.09497, 32.83357], [-117.09463, 32.83356], [-117.09459, 32.83383], [-117.09427, 32.83378], [-117.09249, 32.83324], [-117.09202, 32.83307], [-117.08973, 32.83248], [-117.0895, 32.83245], [-117.08935, 32.83247], [-117.08922, 32.8325], [-117.08884, 32.83264], [-117.08858, 32.83278], [-117.08842, 32.83294], [-117.08785, 32.83296], [-117.08735, 32.83307], [-117.08709, 32.83321], [-117.08658, 32.83361], [-117.08664, 32.83397], [-117.08621, 32.83405], [-117.0861, 32.83385], [-117.08599, 32.8337], [-117.08577, 32.83344], [-117.08643, 32.83318], [-117.08628, 32.83233], [-117.086, 32.83236], [-117.08503, 32.83181], [-117.08454, 32.83215], [-117.0832, 32.83072], [-117.08314, 32.83061], [-117.08306, 32.83043], [-117.08302, 32.83027], [-117.083, 32.83001], [-117.08302, 32.82985], [-117.0831, 32.8296], [-117.08466, 32.83086], [-117.08671, 32.83144], [-117.08668, 32.83188], [-117.09065, 32.8325], [-117.09086, 32.83208], [-117.09414, 32.83258], [-117.09574, 32.83226], [-117.09575, 32.83224], [-117.09562, 32.83205], [-117.09601, 32.83197], [-117.09615, 32.83172], [-117.09619, 32.83173], [-117.09606, 32.83196], [-117.09631, 32.83198], [-117.0968, 32.83176], [-117.09716, 32.83155], [-117.09742, 32.83159], [-117.098, 32.83147], [-117.0983, 32.8315], [-117.09861, 32.8314], [-117.09885, 32.83147], [-117.09895, 32.83124], [-117.09897, 32.83125], [-117.09888, 32.83149], [-117.09907, 32.83165], [-117.09912, 32.83176], [-117.10006, 32.83192], [-117.10037, 32.83187], [-117.10102, 32.83181], [-117.10111, 32.83161], [-117.10128, 32.83153], [-117.10156, 32.83152], [-117.10238, 32.83132]]]} | Open Access 1 | 234 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 55.577 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
4934 | 4934 | 4933 | {"type": "Polygon", "coordinates": [[[-117.08994, 32.84113], [-117.08988, 32.84128], [-117.08972, 32.84134], [-117.08976, 32.84106], [-117.08994, 32.84113]]]} | Open Access 1 | 241 | Tierrasanta Open Space | 10608 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.095 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
4935 | 4935 | 4934 | {"type": "Polygon", "coordinates": [[[-117.13894, 32.76418], [-117.13897, 32.7643], [-117.13895, 32.76456], [-117.13872, 32.76547], [-117.13868, 32.76573], [-117.13868, 32.76599], [-117.1379, 32.76599], [-117.1379, 32.76539], [-117.13854, 32.76539], [-117.13852, 32.76419], [-117.13894, 32.76418]]]} | Open Access 1 | 18884 | University Heights Open Space | 26681 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.316 | University Heights OS | 0 | Local Recreation Area 3 | 4 | |
4936 | 4936 | 4935 | {"type": "Polygon", "coordinates": [[[-117.15971, 32.75841], [-117.15888, 32.75825], [-117.15729, 32.75799], [-117.15739, 32.7577], [-117.1582, 32.75752], [-117.15858, 32.75737], [-117.15939, 32.75751], [-117.15947, 32.75753], [-117.15971, 32.7578], [-117.15971, 32.75841]]]} | Open Access 1 | 18889 | Mission Valley Hillsides Open Space | 22316 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.051 | Mission Valley Hillsides OS | 0 | Local Recreation Area 3 | 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]);