units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 530
- San Diego, County of 120
- Chula Vista, City of 69
- Poway, City of 63
- Encinitas, City of 54
- Oceanside, City of 43
- Carlsbad, City of 40
- San Marcos, City of 40
- Escondido, City of 34
- California Department of Fish and Wildlife 31
- Home Owners Association - Unknown Name 27
- California Department of Parks and Recreation 21
- California Department of Transportation 21
- The Environmental Trust 21
- Coronado, City of 19
- San Diego Unified Port District 19
- Vista, City of 18
- El Cajon, City of 17
- Fallbrook Land Conservancy 15
- La Mesa, City of 14
- Endangered Habitats Conservancy 14
- Center for Natural Lands Management 13
- Santee, City of 12
- United States Fish and Wildlife Service 10
- United States Bureau of Land Management 7
- National City, City of 7
- Del Mar, City of 7
- San Diego River Park Foundation 7
- San Dieguito River Valley Land Conservancy 6
- Lemon Grove, City of 6
- …
DES_TP >30
- Local Park 646
- Local Recreation Area 309
- Local Other or Unknown 99
- Private Conservation 87
- Local Conservation Area 58
- Private Recreation or Education 38
- State Conservation Area 36
- State Other or Unknown 20
- State Park 16
- National Wildlife Refuge 11
- State Resource Management Area 6
- National Public Lands 4
- Local Historic or Cultural Area 3
- Private Other or Unknown 3
- Conservation Area 2
- State Recreation Area 2
- Local Resource Management Area 2
- State Historic or Cultural Area 2
- National Forest 1
- Recreation Management Area 1
- None 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 21
- City Agency 981
- County Agency 120
- State Agency 86
- Non Profit - Land Trust 69
- Home Owners Association 28
- Non Profit - Conservation 24
- Water District 23
- Federal Agency 21
- Port/Harbor District 19
- Non Profit - Other 6
- Commercial 5
- Recreation/Parks District 4
- Transportation Agency 4
- Open Space District 2
- Irrigation District 2
- Special District - Other 2
- School District 1
- Other 1
- Mitigation Bank 1
- Utility 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,146
- No Public Access 127
- Restricted Access 101
- Unknown Access 27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6149 | 6149 | 6148 | {"type": "Polygon", "coordinates": [[[-117.31046, 33.07653], [-117.30964, 33.07651], [-117.30962, 33.07645], [-117.31043, 33.07647], [-117.31046, 33.07653]]]} | Open Access 1 | 1160 | Grandview | 19428 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.131 | Grandview | None 495 | ||
6246 | 6246 | 6245 | {"type": "Polygon", "coordinates": [[[-116.94799, 32.91919], [-116.9479, 32.9194], [-116.94782, 32.91975], [-116.94779, 32.92], [-116.94773, 32.92102], [-116.94765, 32.92139], [-116.94752, 32.9217], [-116.94737, 32.92196], [-116.94723, 32.92215], [-116.94709, 32.9223], [-116.94682, 32.92256], [-116.94467, 32.92255], [-116.94468, 32.92624], [-116.94182, 32.92273], [-116.94182, 32.92266], [-116.9425, 32.92262], [-116.9425, 32.92233], [-116.9431, 32.92209], [-116.9443, 32.92249], [-116.94467, 32.92196], [-116.94372, 32.92144], [-116.94243, 32.92133], [-116.94217, 32.92151], [-116.94218, 32.92234], [-116.94182, 32.92235], [-116.94182, 32.91918], [-116.94466, 32.91917], [-116.94799, 32.91919]]]} | Open Access 1 | 1322 | Berkeley Hering Holding | 29227 | 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 | 59.032 | Berkeley Hering Holding | None 506 | |||
6287 | 6287 | 6286 | {"type": "Polygon", "coordinates": [[[-116.95334, 32.9409], [-116.94892, 32.94093], [-116.94889, 32.93688], [-116.95331, 32.93686], [-116.95334, 32.9409]]]} | Open Access 1 | 1379 | Iron Mountain | 20235 | 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 | 45.811 | Iron Mtn. | None 510 | |||
6462 | 6462 | 6461 | {"type": "Polygon", "coordinates": [[[-116.18721, 33.15378], [-116.18628, 33.1536], [-116.18497, 33.1533], [-116.18496, 33.15281], [-116.18721, 33.15378]]]} | No Public Access 3 | 2055 | Hwy 78 scenic corridor | 20163 | 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 | San Diego 4 | 1.475 | Hwy 78 scenic corridor | None 522 | |||
7564 | 7564 | 7563 | {"type": "Polygon", "coordinates": [[[-117.23847, 33.42888], [-117.2383, 33.42892], [-117.23814, 33.42891], [-117.23796, 33.42885], [-117.23784, 33.42878], [-117.23755, 33.42869], [-117.23723, 33.42713], [-117.23723, 33.42663], [-117.2379, 33.42694], [-117.23799, 33.427], [-117.23802, 33.42704], [-117.23804, 33.42711], [-117.23807, 33.42759], [-117.23817, 33.4276], [-117.23825, 33.42826], [-117.23847, 33.42888]]]} | Open Access 1 | 7252 | Santa Margarita River Lands | 3669 | 2034 | Fallbrook Public Utility District 870 | Special District 4 | Water District 13 | https://www.fpud.com/ | Special District 4 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/santa-margarita-river-trail.html | San Diego 4 | 4.166 | Santa Margarita River Lands | None 628 | ||
7567 | 7567 | 7566 | {"type": "Polygon", "coordinates": [[[-116.96071, 32.7939], [-116.96071, 32.79487], [-116.96045, 32.79487], [-116.96044, 32.79491], [-116.96011, 32.79491], [-116.9601, 32.7939], [-116.96071, 32.7939]]]} | Open Access 1 | 47692 | Prescott Promenade | 31427 | 1092 | El Cajon, City of 73 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html | City 2 | 1092 | El Cajon, City of 71 | City 2 | City Agency 2 | San Diego 4 | 1.524 | Prescott Promenade | None 629 | |||
7600 | 7600 | 7599 | {"type": "MultiPolygon", "coordinates": [[[[-117.14622, 33.06563], [-117.14613, 33.06566], [-117.14588, 33.06585], [-117.14528, 33.06607], [-117.14395, 33.06651], [-117.14403, 33.07291], [-117.1354, 33.07289], [-117.13529, 33.06938], [-117.13397, 33.06938], [-117.13526, 33.06843], [-117.13522, 33.06723], [-117.13565, 33.06722], [-117.13627, 33.06627], [-117.13698, 33.06604], [-117.13697, 33.0657], [-117.13751, 33.0657], [-117.13751, 33.06452], [-117.13871, 33.06451], [-117.13873, 33.06569], [-117.13792, 33.06571], [-117.13792, 33.06788], [-117.1387, 33.06788], [-117.13956, 33.06701], [-117.14139, 33.06701], [-117.14343, 33.06567], [-117.14394, 33.06566], [-117.14474, 33.0654], [-117.14511, 33.06555], [-117.14583, 33.06531], [-117.14593, 33.06542], [-117.14622, 33.06563]], [[-117.1405, 33.06924], [-117.13933, 33.06837], [-117.1387, 33.06896], [-117.14006, 33.06987], [-117.14072, 33.06942], [-117.1405, 33.06924]]], [[[-117.15278, 33.06829], [-117.15233, 33.06861], [-117.15156, 33.06775], [-117.15135, 33.06683], [-117.1491, 33.06683], [-117.1486, 33.06657], [-117.1484, 33.06641], [-117.14826, 33.06634], [-117.14797, 33.06626], [-117.14766, 33.06624], [-117.14749, 33.06621], [-117.14727, 33.06613], [-117.1463, 33.06547], [-117.14695, 33.06537], [-117.14755, 33.06577], [-117.14788, 33.0658], [-117.14829, 33.06591], [-117.14858, 33.06605], [-117.14921, 33.06644], [-117.15176, 33.06643], [-117.15202, 33.06758], [-117.15242, 33.06802], [-117.15277, 33.06777], [-117.15278, 33.06829]]], [[[-117.15278, 33.06896], [-117.15241, 33.0692], [-117.15221, 33.06918], [-117.15201, 33.06897], [-117.1524, 33.06871], [-117.15278, 33.06843], [-117.15278, 33.06896]]]]} | No Public Access 3 | 7312 | Olivenhain Dam | 23133 | 2102 | Olivenhain Municipal Water District 871 | Special District 4 | Water District 13 | http://www.olivenhain.com/ | Special District 4 | 2102 | Olivenhain Municipal Water District 849 | Special District 4 | Water District 13 | San Diego 4 | 153.269 | Olivenhain Dam | None 632 | |||
7616 | 7616 | 7615 | {"type": "Polygon", "coordinates": [[[-117.26666, 33.13637], [-117.26647, 33.13716], [-117.26627, 33.13719], [-117.26603, 33.13729], [-117.26594, 33.13735], [-117.26581, 33.13752], [-117.26568, 33.13736], [-117.26537, 33.1374], [-117.26513, 33.13702], [-117.2651, 33.13689], [-117.26567, 33.13602], [-117.26591, 33.13616], [-117.26634, 33.1363], [-117.26666, 33.13637]]]} | Open Access 1 | 47629 | Carlsbad Skatepark | 31368 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/skatepark.asp | San Diego 4 | 3.643 | Carlsbad Skatepark | None 634 | ||
7618 | 7618 | 7617 | {"type": "MultiPolygon", "coordinates": [[[[-116.58828, 32.9905], [-116.58825, 32.99071], [-116.58818, 32.9909], [-116.58801, 32.99116], [-116.5879, 32.99127], [-116.58761, 32.99148], [-116.5874, 32.99157], [-116.58719, 32.99163], [-116.5869, 32.99167], [-116.58665, 32.99166], [-116.58142, 32.99099], [-116.5814, 32.99108], [-116.58108, 32.99104], [-116.58084, 32.991], [-116.58063, 32.99093], [-116.58048, 32.99088], [-116.57988, 32.9906], [-116.57971, 32.99055], [-116.57949, 32.99055], [-116.57933, 32.99059], [-116.57914, 32.99068], [-116.57896, 32.99083], [-116.57867, 32.99102], [-116.57852, 32.99107], [-116.57837, 32.9911], [-116.57793, 32.99107], [-116.57771, 32.99101], [-116.57685, 32.99067], [-116.57675, 32.99065], [-116.57647, 32.99066], [-116.57626, 32.99071], [-116.57605, 32.99081], [-116.57587, 32.99094], [-116.57568, 32.99114], [-116.57548, 32.9913], [-116.57545, 32.99118], [-116.57544, 32.99118], [-116.57368, 32.99185], [-116.57278, 32.99241], [-116.57137, 32.99369], [-116.56793, 32.99529], [-116.56657, 32.99852], [-116.56638, 32.99902], [-116.56548, 33.00118], [-116.56333, 33.00224], [-116.56291, 33.00372], [-116.56374, 33.00577], [-116.56384, 33.00633], [-116.5638, 33.00661], [-116.56173, 33.00851], [-116.56074, 33.01059], [-116.5602, 33.01038], [-116.55982, 33.01017], [-116.55945, 33.00989], [-116.5593, 33.00975], [-116.55914, 33.00956], [-116.55893, 33.00928], [-116.55868, 33.00889], [-116.55871, 33.00846], [-116.55796, 33.00715], [-116.55889, 33.00477], [-116.55844, 33.00404], [-116.55765, 33.00348], [-116.55654, 33.0018], [-116.55354, 33.00214], [-116.5523, 33.00058], [-116.55155, 32.99892], [-116.55205, 32.99793], [-116.55211, 32.99628], [-116.55325, 32.9954], [-116.55471, 32.99537], [-116.5569, 32.99538], [-116.55636, 32.99378], [-116.55535, 32.99255], [-116.55513, 32.99154], [-116.55526, 32.99138], [-116.55652, 32.98959], [-116.55693, 32.98801], [-116.55725, 32.98657], [-116.55803, 32.98589], [-116.5583, 32.9844], [-116.56187, 32.9836], [-116.56188, 32.98227], [-116.56635, 32.98249], [-116.56636, 32.98312], [-116.56747, 32.98414], [-116.56898, 32.98471], [-116.56935, 32.98534], [-116.56921, 32.9856], [-116.56929, 32.9864], [-116.56943, 32.98702], [-116.56962, 32.98713], [-116.57098, 32.98721], [-116.57129, 32.98711], [-116.57157, 32.98694], [-116.57204, 32.98548], [-116.57271, 32.98562], [-116.57335, 32.98626], [-116.57363, 32.98619], [-116.57605, 32.98533], [-116.57692, 32.98421], [-116.57714, 32.98288], [-116.57697, 32.98202], [-116.57662, 32.98137], [-116.57615, 32.9811], [-116.57521, 32.98117], [-116.57385, 32.98191], [-116.57299, 32.98196], [-116.57165, 32.98146], [-116.57102, 32.98066], [-116.5713, 32.98014], [-116.57341, 32.98094], [-116.57566, 32.97928], [-116.57639, 32.978], [-116.57747, 32.97841], [-116.57837, 32.97822], [-116.57879, 32.97782], [-116.57898, 32.97751], [-116.58028, 32.97747], [-116.58088, 32.97794], [-116.58068, 32.97842], [-116.58069, 32.97857], [-116.58058, 32.97883], [-116.58052, 32.97945], [-116.58088, 32.97945], [-116.58105, 32.98054], [-116.58105, 32.98062], [-116.58099, 32.98084], [-116.58069, 32.98145], [-116.58065, 32.9816], [-116.58066, 32.98181], [-116.58076, 32.98207], [-116.58157, 32.98307], [-116.58165, 32.98322], [-116.582, 32.98456], [-116.58201, 32.9848], [-116.58199, 32.98488], [-116.58199, 32.98499], [-116.58201, 32.98513], [-116.58212, 32.9854], [-116.58228, 32.98559], [-116.58245, 32.98572], [-116.58261, 32.9858], [-116.58292, 32.98591], [-116.58308, 32.98605], [-116.58316, 32.98614], [-116.58325, 32.98628], [-116.5833, 32.98658], [-116.58428, 32.98766], [-116.58443, 32.98778], [-116.58457, 32.98785], [-116.58482, 32.98793], [-116.58541, 32.98797], [-116.58564, 32.98803], [-116.58576, 32.98807], [-116.58654, 32.98843], [-116.58647, 32.9885], [-116.58648, 32.98851], [-116.5866, 32.98856], [-116.58682, 32.98869], [-116.58698, 32.98883], [-116.58708, 32.98895], [-116.58734, 32.98907], [-116.58763, 32.98942], [-116.58797, 32.98965], [-116.58814, 32.98999], [-116.58819, 32.99043], [-116.58828, 32.99044], [-116.58828, 32.9905]]], [[[-116.55887, 33.00971], [-116.55857, 33.00969], [-116.55861, 33.00936], [-116.55873, 33.00954], [-116.55887, 33.00971]]], [[[-116.56489, 33.01495], [-116.56489, 33.01495], [-116.56483, 33.02105], [-116.56391, 33.0168], [-116.56255, 33.01679], [-116.5626, 33.01656], [-116.56264, 33.01612], [-116.56264, 33.01583], [-116.56262, 33.01571], [-116.56258, 33.01556], [-116.56251, 33.01542], [-116.56188, 33.01444], [-116.56175, 33.01414], [-116.56132, 33.01258], [-116.56125, 33.01223], [-116.56121, 33.01185], [-116.56121, 33.01153], [-116.56121, 33.01124], [-116.56125, 33.01102], [-116.56158, 33.01114], [-116.564, 33.01328], [-116.56489, 33.01495]]], [[[-116.58571, 32.99196], [-116.58562, 32.99276], [-116.58476, 32.99272], [-116.58486, 32.99176], [-116.58558, 32.99185], [-116.58571, 32.99196]]]]} | Open Access 1 | 47619 | Lake Cuyamaca | 20881 | 2046 | Helix Water District 777 | Special District 4 | Water District 13 | http://www.hwd.com | Special District 4 | 2058 | Lake Cuyamaca Park and Recreation District 853 | Special District 4 | Recreation/Parks District 4 | http://www.lakecuyamaca.org/ | San Diego 4 | 1116.016 | Lake Cuyamaca | None 635 | ||
7623 | 7623 | 7622 | {"type": "Polygon", "coordinates": [[[-117.00188, 32.95969], [-117.0015, 32.95981], [-117.00141, 32.95964], [-117.00186, 32.95949], [-117.00188, 32.95969]]]} | Open Access 1 | 47638 | Sycamore Creek Neighborhood Park - West | 31379 | 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 | 0.215 | Sycamore Creek Neighborhood Park - West | None 636 | |||
7698 | 7698 | 7697 | {"type": "Polygon", "coordinates": [[[-117.29518, 33.19613], [-117.29514, 33.19645], [-117.29493, 33.19636], [-117.29482, 33.19634], [-117.29471, 33.19633], [-117.29434, 33.19634], [-117.29392, 33.1964], [-117.29352, 33.19651], [-117.29318, 33.19664], [-117.29279, 33.19648], [-117.29342, 33.19591], [-117.2937, 33.19615], [-117.29393, 33.19577], [-117.29432, 33.19594], [-117.2945, 33.196], [-117.29487, 33.19608], [-117.29518, 33.19613]]]} | Open Access 1 | 47625 | Oceanside Open Space 1 | 31363 | 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 | San Diego 4 | 2.401 | Oceanside OS 1 | None 638 | |||
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.13155, 32.60871], [-117.13082, 32.60779], [-117.1306, 32.6076], [-117.1302, 32.60762], [-117.12999, 32.60766], [-117.12894, 32.60764], [-117.12851, 32.60758], [-117.1281, 32.60746], [-117.12761, 32.60717], [-117.12702, 32.60667], [-117.12658, 32.60618], [-117.1259, 32.60554], [-117.12564, 32.60545], [-117.12498, 32.60536], [-117.12444, 32.60519], [-117.12507, 32.60517], [-117.12808, 32.60599], [-117.1287, 32.60621], [-117.12921, 32.60642], [-117.1296, 32.60663], [-117.12996, 32.60686], [-117.13025, 32.60707], [-117.1305, 32.60731], [-117.13071, 32.60753], [-117.13153, 32.60854], [-117.13155, 32.60871]]]} | No Public Access 3 | 47652 | South Bay Marine Biological Study Area | 31395 | 110 | United States Navy 876 | Federal 1 | Federal Agency 1 | http://www.navy.mil/ | Other Federal 13 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.569 | South Bay Marine Biological Study Area | None 645 | |||
7774 | 7774 | 7773 | {"type": "Polygon", "coordinates": [[[-117.16031, 32.89806], [-117.16022, 32.89821], [-117.15398, 32.89806], [-117.15425, 32.89773], [-117.15444, 32.89769], [-117.15469, 32.89776], [-117.15494, 32.89762], [-117.15521, 32.89731], [-117.15549, 32.89724], [-117.15572, 32.89727], [-117.15591, 32.89727], [-117.15615, 32.89717], [-117.15638, 32.89692], [-117.15658, 32.89683], [-117.15682, 32.89679], [-117.15734, 32.89679], [-117.15761, 32.89668], [-117.158, 32.89642], [-117.15833, 32.89632], [-117.15896, 32.8963], [-117.15939, 32.89626], [-117.1595, 32.89663], [-117.1597, 32.89687], [-117.16014, 32.89725], [-117.16031, 32.89806]]]} | Open Access 1 | 47656 | Vernal Pool Habitat | 31399 | 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 | 19.103 | Vernal Pool Habitat | None 646 | |||
7799 | 7799 | 7798 | {"type": "Polygon", "coordinates": [[[-117.31508, 33.26166], [-117.31432, 33.26259], [-117.31428, 33.26186], [-117.31404, 33.26172], [-117.31338, 33.26127], [-117.31266, 33.2613], [-117.31162, 33.26213], [-117.3132, 33.26337], [-117.31094, 33.26441], [-117.30968, 33.26347], [-117.30968, 33.26342], [-117.30855, 33.26259], [-117.30882, 33.2621], [-117.31085, 33.25891], [-117.31091, 33.25884], [-117.31117, 33.25856], [-117.31145, 33.25829], [-117.31228, 33.25764], [-117.31243, 33.25778], [-117.31258, 33.25767], [-117.31258, 33.25766], [-117.31243, 33.25752], [-117.3135, 33.25671], [-117.31355, 33.2567], [-117.31361, 33.25671], [-117.31372, 33.25681], [-117.31374, 33.25685], [-117.31373, 33.25691], [-117.31385, 33.25702], [-117.31403, 33.25689], [-117.3142, 33.25705], [-117.31396, 33.25708], [-117.31349, 33.26035], [-117.31401, 33.2604], [-117.31487, 33.26041], [-117.31508, 33.26166]]]} | No Public Access 3 | 47673 | Foss Lake Preserve | 31414 | 7016 | Foss Lake Conservation LP 877 | Private 7 | Mitigation Bank 29 | Private 14 | 7016 | Foss Lake Conservation LP 854 | Private 7 | Mitigation Bank 28 | San Diego 4 | 58.822 | Foss Lake Preserve | None 648 | ||||
7803 | 7803 | 7802 | {"type": "Polygon", "coordinates": [[[-117.12407, 32.90826], [-117.1212, 32.90829], [-117.12119, 32.9083], [-117.1212, 32.90846], [-117.12031, 32.90848], [-117.12032, 32.9079], [-117.11968, 32.90787], [-117.11963, 32.90544], [-117.12392, 32.90544], [-117.12399, 32.90551], [-117.12407, 32.90826]]]} | Open Access 1 | 47682 | Hourglass Field Community Park and Field House | 31418 | 2413 | San Diego Community College District 878 | Special District 4 | School District 14 | http://www.sdccd.edu/ | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/centers/recctr/hourglass | San Diego 4 | 31.533 | Hourglass Field Community Park and Field House | None 650 | ||
7841 | 7841 | 7840 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94808, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | 47716 | Otay Valley Regional Park | 31498 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 146.674 | Otay Valley RP | None 656 | ||
7949 | 7949 | 7948 | {"type": "Polygon", "coordinates": [[[-117.29603, 33.03791], [-117.29483, 33.03802], [-117.29481, 33.0378], [-117.29594, 33.0377], [-117.29603, 33.03791]]]} | Open Access 1 | 12338 | J Street Viewpoint | 20290 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.676 | J Street Viewpoint | None 661 | ||
7950 | 7950 | 7949 | {"type": "Polygon", "coordinates": [[[-117.01166, 33.09834], [-117.00724, 33.09846], [-117.00721, 33.10173], [-117.00292, 33.10171], [-117.00293, 33.1048], [-117.00284, 33.10489], [-117.00279, 33.10502], [-117.00276, 33.10523], [-117.00281, 33.1053], [-116.99808, 33.10533], [-116.99803, 33.10898], [-116.98097, 33.10899], [-116.98096, 33.10543], [-116.96332, 33.10566], [-116.96371, 33.09511], [-116.96367, 33.09348], [-116.96393, 33.09332], [-116.96428, 33.09317], [-116.96446, 33.09312], [-116.96564, 33.09286], [-116.96609, 33.09274], [-116.96856, 33.0918], [-116.96876, 33.09173], [-116.96925, 33.09162], [-116.97152, 33.09125], [-116.97191, 33.09117], [-116.97461, 33.09036], [-116.97866, 33.08928], [-116.97854, 33.08932], [-116.97856, 33.09035], [-116.98186, 33.09031], [-116.99163, 33.08849], [-116.99171, 33.08887], [-116.99197, 33.08955], [-116.99249, 33.09015], [-116.99317, 33.09071], [-116.99366, 33.09108], [-116.99411, 33.09135], [-116.99459, 33.0916], [-116.99501, 33.09177], [-116.99945, 33.09342], [-117.00223, 33.09441], [-117.00239, 33.09428], [-117.00232, 33.09447], [-117.00438, 33.09522], [-117.00503, 33.09542], [-117.00567, 33.09558], [-117.00623, 33.09569], [-117.00687, 33.09579], [-117.01086, 33.09625], [-117.01126, 33.09635], [-117.01148, 33.09642], [-117.01165, 33.0965], [-117.01166, 33.09834]]]} | Open Access 1 | 47725 | San Diego Safari Park | 31513 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7020 | San Diego Zoo Global 858 | Non Profit 6 | Non Profit - Other 20 | http://sdzsafaripark.org/ | San Diego 4 | 1699.918 | San Diego Safari Park | None 662 | ||
7964 | 7964 | 7963 | {"type": "Polygon", "coordinates": [[[-117.2302, 32.9787], [-117.2267, 32.9787], [-117.22602, 32.97873], [-117.22534, 32.9788], [-117.22479, 32.97889], [-117.22042, 32.97969], [-117.21955, 32.97992], [-117.21887, 32.98014], [-117.21805, 32.98047], [-117.21727, 32.98086], [-117.21667, 32.98122], [-117.21597, 32.98171], [-117.21558, 32.98203], [-117.21527, 32.98229], [-117.21193, 32.98539], [-117.19708, 32.98498], [-117.19767, 32.9845], [-117.19804, 32.98428], [-117.19828, 32.98417], [-117.19854, 32.98408], [-117.1988, 32.98401], [-117.19907, 32.98397], [-117.19953, 32.98396], [-117.19998, 32.98401], [-117.20025, 32.98407], [-117.20168, 32.9845], [-117.20205, 32.98458], [-117.20243, 32.98461], [-117.20292, 32.9846], [-117.2034, 32.98452], [-117.20381, 32.9844], [-117.20424, 32.98421], [-117.20464, 32.98396], [-117.20498, 32.98366], [-117.20526, 32.98332], [-117.20547, 32.98297], [-117.20562, 32.98262], [-117.20571, 32.98225], [-117.20582, 32.98083], [-117.20589, 32.98046], [-117.20601, 32.98017], [-117.20618, 32.9799], [-117.20636, 32.97968], [-117.2066, 32.97945], [-117.20691, 32.97923], [-117.20857, 32.97828], [-117.21102, 32.97656], [-117.21139, 32.97633], [-117.21164, 32.97622], [-117.21189, 32.97613], [-117.21397, 32.97552], [-117.21428, 32.9754], [-117.21542, 32.97486], [-117.21575, 32.97475], [-117.21615, 32.97465], [-117.21644, 32.97461], [-117.21672, 32.97459], [-117.21775, 32.97456], [-117.2182, 32.97459], [-117.21854, 32.97465], [-117.21886, 32.97473], [-117.22019, 32.97526], [-117.22051, 32.97536], [-117.22083, 32.97543], [-117.22123, 32.97548], [-117.22283, 32.97555], [-117.22461, 32.97568], [-117.22508, 32.97568], [-117.22555, 32.97562], [-117.2259, 32.97554], [-117.22674, 32.97528], [-117.22711, 32.9752], [-117.22829, 32.97511], [-117.22878, 32.9751], [-117.22924, 32.97513], [-117.22961, 32.97519], [-117.23009, 32.97532], [-117.23012, 32.97534], [-117.23013, 32.97537], [-117.2302, 32.9787]]]} | Restricted Access 2 | 47733 | Fairbanks Ranch Country Club | 31535 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 7021 | Bay Club 860 | Private 7 | Commercial 18 | https://www.bayclubs.com/fairbanksranch/ | San Diego 4 | 372.882 | Fairbanks Ranch Country Club | None 664 | ||
8103 | 8103 | 8102 | {"type": "Polygon", "coordinates": [[[-117.00113, 33.02272], [-117.00105, 33.02745], [-117.00102, 33.03009], [-116.9965, 33.03013], [-116.99651, 33.0372], [-116.99193, 33.03718], [-116.99194, 33.03505], [-116.99136, 33.03484], [-116.99041, 33.03574], [-116.99007, 33.03663], [-116.98814, 33.03668], [-116.98782, 33.0369], [-116.98779, 33.03901], [-116.9876, 33.0392], [-116.98747, 33.03926], [-116.98734, 33.03926], [-116.98698, 33.03914], [-116.9869, 33.03914], [-116.98679, 33.03919], [-116.98641, 33.03954], [-116.98604, 33.0395], [-116.98595, 33.0395], [-116.98581, 33.03953], [-116.98564, 33.03953], [-116.98553, 33.0395], [-116.9854, 33.03943], [-116.98519, 33.03935], [-116.98464, 33.0393], [-116.98442, 33.03926], [-116.98428, 33.0392], [-116.98404, 33.03905], [-116.98396, 33.03902], [-116.98461, 33.03854], [-116.9856, 33.03786], [-116.98499, 33.03754], [-116.98499, 33.03716], [-116.98474, 33.03716], [-116.98472, 33.03536], [-116.98542, 33.03536], [-116.98717, 33.03356], [-116.98316, 33.03353], [-116.98315, 33.02731], [-116.98313, 33.02609], [-116.98749, 33.02618], [-116.98755, 33.02902], [-116.98757, 33.02903], [-116.98959, 33.02861], [-116.99067, 33.02822], [-116.9913, 33.02777], [-116.99131, 33.02676], [-116.99153, 33.02626], [-116.99197, 33.02626], [-116.99197, 33.02538], [-116.99226, 33.02477], [-116.99312, 33.02414], [-116.99244, 33.02338], [-116.99242, 33.02251], [-116.99657, 33.02259], [-116.99655, 33.02181], [-117.00002, 33.02187], [-117.00113, 33.02272]]]} | Open Access 1 | 12142 | Lake Ramona | 8896 | 2116 | Ramona Municipal Water District 872 | Special District 4 | Water District 13 | http://www.rmwd.org/ | Special District 4 | 2116 | Ramona Municipal Water District 850 | Special District 4 | Water District 13 | http://www.rmwd.org/lake-ramona | San Diego 4 | 469.886 | Lake Ramona | None 676 |
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]);