units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
102 rows where ACCESS_TYP = 2 and COUNTY = 4 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, YR_EST, GAP_STS
MNG_AGENCY >30
- Home Owners Association - Unknown Name 27
- San Diego, City of 10
- California Department of Fish and Wildlife 10
- Carlsbad, City of 6
- University of California 4
- San Diego River Park Foundation 4
- United States Fish and Wildlife Service 3
- Oceanside, City of 3
- San Diego, County of 3
- San Diego State University 3
- Encinitas, City of 2
- Coronado, City of 2
- Fallbrook Land Conservancy 2
- Nonprofit Organization - Unknown 2
- Private Landowner 2
- United States Bureau of Land Management 1
- California Department of Parks and Recreation 1
- National City, City of 1
- The Nature Conservancy 1
- El Cajon, City of 1
- Escondido, City of 1
- Chula Vista, City of 1
- Poway, City of 1
- Petco Park Owner 1
- United States Department of Defense 1
- The Conservation Fund - California 1
- Borrego Water District 1
- San Diego Audubon Society 1
- Anza-Borrego Foundation 1
- Bay Club 1
- …
DES_TP 17
- Private Recreation or Education 27
- State Conservation Area 17
- Local Recreation Area 16
- Local Park 11
- Private Conservation 11
- Local Conservation Area 5
- National Wildlife Refuge 3
- Private Other or Unknown 3
- Local Other or Unknown 1
- State Park 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 12
ACCESS_TYP 1
- Restricted Access · 102 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
4471 | 4471 | 4470 | {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} | Restricted Access 2 | 1199 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 6.306 | 0 | Private Other or Unknown 399 | 4 | |||
4472 | 4472 | 4471 | {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} | Restricted Access 2 | 1208 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 638.799 | 0 | Private Other or Unknown 399 | 4 | |||
15529 | 15529 | 15528 | {"type": "MultiPolygon", "coordinates": [[[[-116.37339, 33.20669], [-116.37126, 33.20669], [-116.3712, 33.20314], [-116.369, 33.20315], [-116.36895, 33.19964], [-116.37329, 33.19965], [-116.37339, 33.20669]]], [[[-116.36684, 33.20585], [-116.36473, 33.20589], [-116.36486, 33.21146], [-116.36444, 33.2114], [-116.364, 33.21137], [-116.36273, 33.21136], [-116.36269, 33.21043], [-116.36051, 33.21041], [-116.36039, 33.20494], [-116.3647, 33.20498], [-116.36682, 33.20495], [-116.36684, 33.20585]]]]} | Restricted Access 2 | 49075 | Unnamed site - Anza-Borrego Foundation | 33775 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | https://theabf.org/ | San Diego 4 | 128.692 | 2019 | Private Other or Unknown 399 | 4 | |
15677 | 15677 | 15676 | {"type": "MultiPolygon", "coordinates": [[[[-117.10566, 32.79376], [-117.10471, 32.79491], [-117.10095, 32.79737], [-117.09926, 32.79946], [-117.09919, 32.80154], [-117.09938, 32.80248], [-117.10023, 32.80247], [-117.10057, 32.80525], [-117.09796, 32.8068], [-117.09627, 32.80827], [-117.09628, 32.80812], [-117.09632, 32.80799], [-117.0964, 32.80786], [-117.09665, 32.8076], [-117.09673, 32.80748], [-117.09679, 32.80731], [-117.09688, 32.80696], [-117.09698, 32.80677], [-117.09716, 32.80655], [-117.0972, 32.80644], [-117.09722, 32.80635], [-117.09721, 32.8062], [-117.09717, 32.80608], [-117.09689, 32.8056], [-117.09685, 32.80547], [-117.09686, 32.80531], [-117.09697, 32.8051], [-117.09705, 32.80484], [-117.097, 32.8045], [-117.097, 32.80439], [-117.09705, 32.80422], [-117.09705, 32.80407], [-117.097, 32.80394], [-117.09683, 32.80359], [-117.0968, 32.80341], [-117.09682, 32.80323], [-117.09692, 32.80297], [-117.09692, 32.80282], [-117.09688, 32.80262], [-117.09684, 32.8025], [-117.09599, 32.80251], [-117.09513, 32.8006], [-117.09522, 32.79697], [-117.09603, 32.7952], [-117.10024, 32.79307], [-117.10151, 32.79253], [-117.10383, 32.79159], [-117.10383, 32.7909], [-117.10444, 32.79089], [-117.10491, 32.79081], [-117.10498, 32.79113], [-117.10499, 32.79133], [-117.1049, 32.79146], [-117.10488, 32.79161], [-117.10515, 32.79234], [-117.10517, 32.79254], [-117.10517, 32.79275], [-117.10513, 32.79294], [-117.10508, 32.7931], [-117.105, 32.79328], [-117.10502, 32.79346], [-117.10508, 32.7935], [-117.10522, 32.79349], [-117.10566, 32.79376]]], [[[-117.09604, 32.80847], [-117.09592, 32.80858], [-117.09529, 32.80942], [-117.09358, 32.81096], [-117.09346, 32.8143], [-117.09266, 32.81502], [-117.09264, 32.81504], [-117.09251, 32.81505], [-117.0881, 32.8155], [-117.08204, 32.8097], [-117.08135, 32.80787], [-117.08322, 32.8068], [-117.0853, 32.80616], [-117.09164, 32.80733], [-117.09602, 32.80672], [-117.09604, 32.80847]]]]} | Restricted Access 2 | 12871 | Admiral Baker Golf Course | 31857 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | https://www.golfnow.com/courses/1027561-admiral-baker-golf-course-north-course-details | San Diego 4 | 409.719 | Admiral Baker GC | 0 | Recreation Management Area 49 | 4 |
14784 | 14784 | 14783 | {"type": "Polygon", "coordinates": [[[-116.99018, 32.63505], [-116.99014, 32.63512], [-116.98962, 32.63527], [-116.98954, 32.63523], [-116.98938, 32.63482], [-116.99002, 32.63464], [-116.99018, 32.63505]]]} | Restricted Access 2 | 45171 | Alcala Park | 33366 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.85 | Alcala Park | 0 | Private Recreation or Education 65 | 4 | ||
6677 | 6677 | 6676 | {"type": "Polygon", "coordinates": [[[-116.5326, 32.93414], [-116.53245, 32.94818], [-116.51564, 32.94847], [-116.51595, 32.93405], [-116.5326, 32.93414]]]} | Restricted Access 2 | 47524 | Anza-Borrego Desert State Park | 31229 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=638 | San Diego 4 | 609.836 | Anza-Borrego Desert SP | 1933 | State Park 15 | 4 |
14778 | 14778 | 14777 | {"type": "Polygon", "coordinates": [[[-116.95784, 32.6469], [-116.95776, 32.64726], [-116.95776, 32.64742], [-116.95656, 32.64741], [-116.95641, 32.64735], [-116.95632, 32.64703], [-116.95625, 32.64688], [-116.95615, 32.64672], [-116.95619, 32.64666], [-116.95674, 32.64628], [-116.95698, 32.64648], [-116.95726, 32.64666], [-116.95755, 32.6468], [-116.95784, 32.6469]]]} | Restricted Access 2 | 45166 | Augusta Park | 33363 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 3.216 | Augusta Park | 0 | Private Recreation or Education 65 | 4 | ||
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
14600 | 14600 | 14599 | {"type": "Polygon", "coordinates": [[[-116.6979, 32.61031], [-116.69776, 32.61055], [-116.69755, 32.61081], [-116.69751, 32.61111], [-116.69734, 32.61107], [-116.69731, 32.6111], [-116.69726, 32.61135], [-116.6971, 32.61201], [-116.69706, 32.61209], [-116.69699, 32.61214], [-116.69647, 32.61239], [-116.69613, 32.61251], [-116.67769, 32.61194], [-116.67771, 32.61535], [-116.67335, 32.61518], [-116.66931, 32.6152], [-116.66929, 32.61178], [-116.66105, 32.61171], [-116.66108, 32.60812], [-116.66526, 32.60816], [-116.6653, 32.60457], [-116.67347, 32.60464], [-116.67379, 32.60109], [-116.67809, 32.60116], [-116.67831, 32.59756], [-116.68003, 32.59756], [-116.68004, 32.59771], [-116.68008, 32.59783], [-116.68032, 32.59832], [-116.68065, 32.5988], [-116.68081, 32.59898], [-116.68085, 32.59906], [-116.68092, 32.59936], [-116.68091, 32.59942], [-116.68087, 32.59947], [-116.68076, 32.59954], [-116.68065, 32.59963], [-116.68006, 32.60044], [-116.68003, 32.60055], [-116.68004, 32.60061], [-116.68006, 32.60065], [-116.68022, 32.6008], [-116.68036, 32.60088], [-116.6805, 32.6009], [-116.68094, 32.60085], [-116.68139, 32.60088], [-116.68149, 32.60092], [-116.68152, 32.60097], [-116.68153, 32.60102], [-116.6815, 32.60111], [-116.68105, 32.60146], [-116.68093, 32.60169], [-116.6809, 32.60177], [-116.6809, 32.60184], [-116.68094, 32.60195], [-116.68126, 32.60228], [-116.68132, 32.60232], [-116.68139, 32.60235], [-116.68148, 32.60236], [-116.68181, 32.60235], [-116.68211, 32.60241], [-116.68269, 32.60231], [-116.68282, 32.60225], [-116.68328, 32.60194], [-116.68344, 32.60179], [-116.68358, 32.60161], [-116.68364, 32.60157], [-116.68369, 32.60157], [-116.68372, 32.60158], [-116.68377, 32.60163], [-116.68386, 32.60201], [-116.68384, 32.60247], [-116.68373, 32.60271], [-116.68373, 32.60279], [-116.68374, 32.60285], [-116.68384, 32.60307], [-116.68391, 32.60314], [-116.68433, 32.60335], [-116.68509, 32.60396], [-116.68519, 32.60403], [-116.68536, 32.60412], [-116.68559, 32.60418], [-116.68736, 32.60437], [-116.68751, 32.60437], [-116.68767, 32.60433], [-116.68814, 32.60409], [-116.68826, 32.60406], [-116.6887, 32.60406], [-116.68895, 32.60402], [-116.68913, 32.60395], [-116.68955, 32.60373], [-116.68974, 32.6037], [-116.68984, 32.60373], [-116.69022, 32.60398], [-116.69038, 32.60407], [-116.69062, 32.60415], [-116.69109, 32.60427], [-116.69119, 32.60432], [-116.69126, 32.60439], [-116.6915, 32.60473], [-116.69161, 32.60484], [-116.69173, 32.60492], [-116.69192, 32.60503], [-116.69342, 32.60562], [-116.69353, 32.60568], [-116.6947, 32.60666], [-116.69448, 32.60689], [-116.69495, 32.60719], [-116.69584, 32.60787], [-116.69582, 32.60812], [-116.69585, 32.60832], [-116.69591, 32.6085], [-116.69605, 32.60871], [-116.6979, 32.61031]]]} | Restricted Access 2 | 44818 | Barrett Junction | 15831 | 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 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Diego 4 | 810.26 | Barrett Junction | None 1245 | |||
6254 | 6254 | 6253 | {"type": "MultiPolygon", "coordinates": [[[[-116.72083, 32.70426], [-116.71907, 32.7045], [-116.71873, 32.70456], [-116.7182, 32.70471], [-116.71793, 32.70482], [-116.71767, 32.70496], [-116.71735, 32.70515], [-116.71708, 32.70537], [-116.71398, 32.70808], [-116.71371, 32.70826], [-116.71349, 32.70839], [-116.71319, 32.70853], [-116.71283, 32.70866], [-116.70883, 32.70798], [-116.70426, 32.70803], [-116.70439, 32.71165], [-116.70677, 32.71163], [-116.70672, 32.71196], [-116.70667, 32.7121], [-116.70658, 32.71228], [-116.70649, 32.71241], [-116.70538, 32.71375], [-116.70517, 32.71411], [-116.70506, 32.71444], [-116.70502, 32.71464], [-116.705, 32.71489], [-116.70499, 32.71695], [-116.70495, 32.71993], [-116.7049, 32.72027], [-116.70478, 32.72064], [-116.70461, 32.72097], [-116.70444, 32.72123], [-116.70424, 32.72147], [-116.70405, 32.72166], [-116.69956, 32.72557], [-116.69966, 32.7224], [-116.69545, 32.72241], [-116.6953, 32.72599], [-116.6909, 32.726], [-116.69148, 32.71532], [-116.69577, 32.71527], [-116.69593, 32.71173], [-116.7001, 32.71169], [-116.69997, 32.7081], [-116.70112, 32.70807], [-116.70099, 32.7045], [-116.69554, 32.70453], [-116.69514, 32.69711], [-116.6819, 32.69715], [-116.68214, 32.70068], [-116.67793, 32.70075], [-116.67876, 32.71169], [-116.6786, 32.71546], [-116.68281, 32.71546], [-116.68266, 32.71901], [-116.68694, 32.71903], [-116.68659, 32.7261], [-116.67808, 32.72613], [-116.67826, 32.7226], [-116.66961, 32.72265], [-116.66984, 32.71904], [-116.67418, 32.71895], [-116.67435, 32.71542], [-116.6661, 32.71554], [-116.66639, 32.71171], [-116.66252, 32.71174], [-116.66225, 32.70812], [-116.66611, 32.70808], [-116.66584, 32.7045], [-116.66983, 32.70446], [-116.66933, 32.69723], [-116.66139, 32.69733], [-116.66126, 32.69371], [-116.65721, 32.69375], [-116.65703, 32.69021], [-116.65041, 32.68985], [-116.64504, 32.6896], [-116.64512, 32.68579], [-116.64145, 32.68553], [-116.62402, 32.686], [-116.62403, 32.68245], [-116.61982, 32.68242], [-116.61983, 32.67894], [-116.62406, 32.67895], [-116.62828, 32.67883], [-116.62843, 32.68226], [-116.64162, 32.6817], [-116.65303, 32.68272], [-116.65312, 32.68635], [-116.65685, 32.68666], [-116.66102, 32.68661], [-116.66116, 32.69017], [-116.66941, 32.69001], [-116.66943, 32.68647], [-116.66522, 32.68654], [-116.66518, 32.67936], [-116.66938, 32.67923], [-116.66936, 32.66864], [-116.67387, 32.66853], [-116.67418, 32.66477], [-116.67836, 32.6647], [-116.67912, 32.65372], [-116.68316, 32.65371], [-116.68281, 32.65012], [-116.69142, 32.65005], [-116.69107, 32.6537], [-116.68713, 32.65371], [-116.68691, 32.66092], [-116.68275, 32.66096], [-116.68232, 32.66832], [-116.67809, 32.66843], [-116.67805, 32.67191], [-116.67386, 32.67198], [-116.67382, 32.68271], [-116.68213, 32.68268], [-116.68206, 32.68638], [-116.68642, 32.68631], [-116.68641, 32.68978], [-116.69093, 32.68974], [-116.69093, 32.69145], [-116.69097, 32.69352], [-116.7085, 32.69348], [-116.70862, 32.69707], [-116.71266, 32.69772], [-116.71271, 32.7015], [-116.7208, 32.70275], [-116.72083, 32.70426]]], [[[-116.70877, 32.71161], [-116.70809, 32.72584], [-116.69953, 32.72595], [-116.69953, 32.72583], [-116.70419, 32.72176], [-116.70447, 32.72148], [-116.7047, 32.72118], [-116.70487, 32.72089], [-116.70501, 32.72058], [-116.70509, 32.7203], [-116.70515, 32.71995], [-116.70519, 32.71695], [-116.7052, 32.71484], [-116.70523, 32.71452], [-116.70534, 32.71421], [-116.70544, 32.714], [-116.70558, 32.71379], [-116.70662, 32.71254], [-116.70673, 32.71239], [-116.70683, 32.71221], [-116.7069, 32.71203], [-116.70695, 32.71184], [-116.70697, 32.71163], [-116.70877, 32.71161]]], [[[-116.71691, 32.70935], [-116.71691, 32.70935], [-116.71317, 32.70872], [-116.71348, 32.70858], [-116.71373, 32.70845], [-116.71395, 32.70831], [-116.71419, 32.70814], [-116.71683, 32.70582], [-116.71691, 32.70935]]], [[[-116.72086, 32.70635], [-116.72086, 32.70635], [-116.71693, 32.70573], [-116.71727, 32.70544], [-116.71758, 32.70521], [-116.71797, 32.705], [-116.71838, 32.70483], [-116.7187, 32.70474], [-116.719, 32.70467], [-116.72083, 32.70443], [-116.72086, 32.70635]]]]} | Restricted Access 2 | 1327 | Barrett Reservoir | 15833 | 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 | https://www.sandiego.gov/water/recreation/reservoirs/barrett | San Diego 4 | 4177.221 | Barrett Reservoir | 0 | Local Recreation Area 3 | 4 |
15637 | 15637 | 15636 | {"type": "MultiPolygon", "coordinates": [[[[-117.29913, 33.08782], [-117.296, 33.08783], [-117.2961, 33.09165], [-117.29506, 33.09132], [-117.29447, 33.09119], [-117.29399, 33.09112], [-117.29368, 33.09104], [-117.2933, 33.09101], [-117.29317, 33.09104], [-117.29273, 33.09131], [-117.29159, 33.09153], [-117.29145, 33.09161], [-117.29119, 33.09195], [-117.29122, 33.09209], [-117.29092, 33.09265], [-117.29069, 33.09263], [-117.29055, 33.09233], [-117.29061, 33.09211], [-117.29034, 33.09156], [-117.29014, 33.09155], [-117.28933, 33.09103], [-117.28869, 33.09113], [-117.28836, 33.09138], [-117.28839, 33.09145], [-117.28751, 33.09185], [-117.2875, 33.09199], [-117.28707, 33.09197], [-117.28667, 33.09191], [-117.28609, 33.09218], [-117.28594, 33.09218], [-117.2858, 33.09243], [-117.28541, 33.09235], [-117.28503, 33.09256], [-117.28438, 33.09257], [-117.28374, 33.09245], [-117.28356, 33.09233], [-117.28362, 33.0918], [-117.28297, 33.09161], [-117.28264, 33.09145], [-117.28199, 33.09146], [-117.28169, 33.09166], [-117.28148, 33.09219], [-117.28178, 33.09255], [-117.28098, 33.09295], [-117.28058, 33.09312], [-117.27922, 33.09404], [-117.2787, 33.09397], [-117.27868, 33.09395], [-117.27849, 33.09399], [-117.27823, 33.09392], [-117.27784, 33.09398], [-117.27746, 33.09412], [-117.27715, 33.09402], [-117.27744, 33.09379], [-117.27735, 33.09355], [-117.27702, 33.09357], [-117.2769, 33.09367], [-117.27653, 33.09371], [-117.2765, 33.09377], [-117.27625, 33.09371], [-117.27629, 33.09347], [-117.27598, 33.09332], [-117.27567, 33.09331], [-117.27499, 33.09352], [-117.27495, 33.09385], [-117.27485, 33.09385], [-117.27477, 33.09351], [-117.27465, 33.09352], [-117.27448, 33.0933], [-117.27448, 33.09326], [-117.27439, 33.09324], [-117.27412, 33.09316], [-117.27415, 33.09308], [-117.27414, 33.09307], [-117.27356, 33.09311], [-117.27351, 33.09329], [-117.27325, 33.09329], [-117.27313, 33.09348], [-117.27233, 33.09352], [-117.27149, 33.09332], [-117.27163, 33.09308], [-117.27099, 33.09295], [-117.27071, 33.09282], [-117.27048, 33.09283], [-117.2703, 33.09301], [-117.27011, 33.09307], [-117.27011, 33.09336], [-117.26959, 33.09349], [-117.26939, 33.09361], [-117.26927, 33.09402], [-117.26884, 33.09406], [-117.2691, 33.09349], [-117.26905, 33.09328], [-117.26915, 33.09306], [-117.2692, 33.09274], [-117.2694, 33.09233], [-117.26939, 33.09232], [-117.26909, 33.09228], [-117.26959, 33.09091], [-117.26969, 33.09051], [-117.26974, 33.09006], [-117.26973, 33.08974], [-117.26968, 33.0893], [-117.26914, 33.08688], [-117.26907, 33.08645], [-117.26905, 33.08621], [-117.26895, 33.0858], [-117.26896, 33.08569], [-117.26901, 33.0856], [-117.2691, 33.08553], [-117.2692, 33.08549], [-117.26995, 33.08542], [-117.27, 33.08634], [-117.27226, 33.08537], [-117.27266, 33.08545], [-117.27305, 33.08556], [-117.2735, 33.08574], [-117.27549, 33.08667], [-117.27723, 33.08753], [-117.27774, 33.08773], [-117.27833, 33.0879], [-117.27866, 33.08808], [-117.27893, 33.08802], [-117.2795, 33.08807], [-117.28, 33.08809], [-117.28049, 33.08806], [-117.28089, 33.08801], [-117.28337, 33.08757], [-117.28557, 33.08736], [-117.28897, 33.08739], [-117.29074, 33.08746], [-117.29403, 33.08635], [-117.29551, 33.08529], [-117.29563, 33.08547], [-117.29694, 33.08588], [-117.29866, 33.08722], [-117.29913, 33.08782]], [[-117.28911, 33.08744], [-117.28912, 33.08742], [-117.2891, 33.08742], [-117.2891, 33.08744], [-117.28911, 33.08744]]], [[[-117.30633, 33.0891], [-117.30621, 33.08968], [-117.3061, 33.08989], [-117.30599, 33.09005], [-117.30585, 33.09021], [-117.30547, 33.09053], [-117.30534, 33.09068], [-117.30452, 33.09207], [-117.30327, 33.09029], [-117.3049, 33.08911], [-117.30633, 33.0891]]], [[[-117.30981, 33.08934], [-117.30886, 33.08952], [-117.30803, 33.08948], [-117.30787, 33.08951], [-117.30774, 33.08955], [-117.30767, 33.08964], [-117.30769, 33.0898], [-117.30752, 33.08981], [-117.30679, 33.0891], [-117.3097, 33.08909], [-117.30981, 33.08934]]], [[[-117.31196, 33.08767], [-117.31147, 33.08776], [-117.31087, 33.08784], [-117.31081, 33.08787], [-117.3108, 33.08792], [-117.31083, 33.08801], [-117.31145, 33.0887], [-117.31157, 33.08893], [-117.3115, 33.08908], [-117.31131, 33.08917], [-117.31094, 33.08932], [-117.3106, 33.0894], [-117.30986, 33.08747], [-117.31032, 33.08713], [-117.31097, 33.08695], [-117.31177, 33.08717], [-117.31196, 33.08767]]]]} | Restricted Access 2 | 44945 | Batiquitos Lagoon Ecological Reserve | 15864 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Batiquitos-Lagoon-ER | San Diego 4 | 410.657 | Batiquitos Lagoon ER | 1983 | State Conservation Area 8 | 2 |
6086 | 6086 | 6085 | {"type": "MultiPolygon", "coordinates": [[[[-117.00116, 33.01884], [-116.99647, 33.01886], [-116.99635, 33.01507], [-117.00112, 33.01494], [-117.00116, 33.01884]]], [[[-117.01695, 33.01451], [-117.01452, 33.01459], [-117.00983, 33.01471], [-117.00983, 33.01458], [-117.01035, 33.01452], [-117.01054, 33.01217], [-117.01092, 33.01197], [-117.01481, 33.01197], [-117.01603, 33.01335], [-117.01695, 33.01451]]]]} | Restricted Access 2 | 891 | Blue Sky Ecological Reserve | 29220 | 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 | 83.938 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | 45140 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 15.494 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
14796 | 14796 | 14795 | {"type": "Polygon", "coordinates": [[[-117.00158, 32.64883], [-117.00127, 32.64895], [-117.00104, 32.64919], [-117.00075, 32.64957], [-117.00074, 32.64972], [-117.00066, 32.64986], [-117.00056, 32.64961], [-117.00018, 32.64972], [-117.00016, 32.64965], [-117.00053, 32.64954], [-117.00037, 32.64912], [-117.00096, 32.64895], [-117.00084, 32.64865], [-117.00104, 32.6486], [-117.00118, 32.64862], [-117.00145, 32.6487], [-117.00158, 32.64883]]]} | Restricted Access 2 | 45182 | Bonitas Haciendas Mini-Park | 33347 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.39 | Bonitas Haciendas Mini-Park | 0 | Private Recreation or Education 65 | 4 | ||
11552 | 11552 | 11551 | {"type": "Polygon", "coordinates": [[[-116.66912, 32.98862], [-116.65988, 32.98873], [-116.65991, 32.98773], [-116.66058, 32.98745], [-116.66904, 32.98739], [-116.66912, 32.98862]]]} | Restricted Access 2 | 23593 | Boulder Creek Ecological Reserve | 16294 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 29.218 | Boulder Creek ER | 0 | State Conservation Area 8 | 2 | |
5394 | 5394 | 5393 | {"type": "Polygon", "coordinates": [[[-116.66647, 32.96362], [-116.66615, 32.96362], [-116.66613, 32.96401], [-116.66421, 32.96406], [-116.66329, 32.96512], [-116.66112, 32.96511], [-116.6611, 32.96361], [-116.66364, 32.96362], [-116.66451, 32.96339], [-116.66476, 32.96328], [-116.66507, 32.96309], [-116.66533, 32.96298], [-116.66555, 32.963], [-116.66584, 32.96322], [-116.66599, 32.96323], [-116.66612, 32.96329], [-116.66623, 32.96337], [-116.6663, 32.96347], [-116.66644, 32.96353], [-116.66647, 32.96362]]]} | Restricted Access 2 | 47899 | Boulder Creek Preserve | 31862 | 3206 | San Diego River Park Foundation 804 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 15.037 | Boulder Creek Preserve | 0 | Private Conservation 16 | 2 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
7408 | 7408 | 7407 | {"type": "Polygon", "coordinates": [[[-117.04334, 32.65988], [-117.04285, 32.66126], [-117.0421, 32.66117], [-117.0413, 32.66018], [-117.0412, 32.66015], [-117.04094, 32.66055], [-117.04015, 32.66116], [-117.03857, 32.66186], [-117.03858, 32.66188], [-117.04059, 32.66212], [-117.0408, 32.66229], [-117.04084, 32.66253], [-117.04076, 32.6627], [-117.04062, 32.66285], [-117.04042, 32.66298], [-117.0394, 32.6633], [-117.03913, 32.66334], [-117.03859, 32.66336], [-117.03512, 32.66317], [-117.03443, 32.66331], [-117.03443, 32.66338], [-117.03373, 32.66363], [-117.03301, 32.66462], [-117.03291, 32.6647], [-117.03277, 32.66475], [-117.03263, 32.66475], [-117.0325, 32.66471], [-117.03167, 32.6642], [-117.03148, 32.66413], [-117.03126, 32.66409], [-117.03101, 32.6641], [-117.03087, 32.66414], [-117.03072, 32.66419], [-117.02943, 32.66491], [-117.02923, 32.66453], [-117.02836, 32.66501], [-117.02643, 32.66623], [-117.02661, 32.66667], [-117.02554, 32.66792], [-117.02303, 32.66863], [-117.02316, 32.66727], [-117.02417, 32.66612], [-117.02392, 32.66566], [-117.02415, 32.66546], [-117.02459, 32.66513], [-117.02715, 32.66335], [-117.0274, 32.66315], [-117.02752, 32.66308], [-117.02757, 32.66312], [-117.02804, 32.66286], [-117.0291, 32.66239], [-117.03265, 32.66094], [-117.03297, 32.66083], [-117.0334, 32.66074], [-117.03377, 32.66071], [-117.03417, 32.66071], [-117.03416, 32.66077], [-117.03466, 32.66116], [-117.03456, 32.6616], [-117.03457, 32.66161], [-117.03539, 32.66154], [-117.03567, 32.66154], [-117.03594, 32.66152], [-117.03618, 32.66147], [-117.03638, 32.66141], [-117.03682, 32.66123], [-117.03705, 32.66111], [-117.03713, 32.66119], [-117.04058, 32.65915], [-117.04032, 32.65881], [-117.04048, 32.65871], [-117.04051, 32.65874], [-117.0416, 32.65884], [-117.04165, 32.65879], [-117.04334, 32.65988]]]} | Restricted Access 2 | 7602 | Chula Vista Municipal Golf Course | 33025 | 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 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistagc.com/ | San Diego 4 | 128.631 | Chula Vista Municipal GC | 0 | Local Recreation Area 3 | 4 |
14779 | 14779 | 14778 | {"type": "Polygon", "coordinates": [[[-116.95147, 32.64226], [-116.95151, 32.64236], [-116.95151, 32.64247], [-116.95145, 32.64258], [-116.95133, 32.64266], [-116.95118, 32.64269], [-116.95105, 32.64267], [-116.95093, 32.6426], [-116.95086, 32.6425], [-116.95084, 32.6424], [-116.95087, 32.6423], [-116.95094, 32.64221], [-116.95103, 32.64215], [-116.95116, 32.64212], [-116.95126, 32.64213], [-116.95138, 32.64218], [-116.95147, 32.64226]]]} | Restricted Access 2 | 45167 | Circle Park | 33367 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.754 | Circle Park | 0 | Private Recreation or Education 65 | 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]);