units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 527
- San Diego, County of 122
- Chula Vista, City of 69
- Poway, City of 65
- 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
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 21
- City Agency 980
- County Agency 122
- State Agency 85
- 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
- Special District - Other 2
- Other 2
- Irrigation District 1
- School District 1
- Mitigation Bank 1
- Utility 1
- Fire District 1
AGNCY_LEV 7 ✖
- City 971
- County 119
- Non Profit 102
- State 84
- Special District 66
- Private 35
- Federal 24
ACCESS_TYP 4
- Open Access 1,146
- No Public Access 126
- Restricted Access 102
- 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4391 | 4391 | 4390 | {"type": "Polygon", "coordinates": [[[-116.36536, 33.23412], [-116.36466, 33.23413], [-116.3643, 33.23433], [-116.36296, 33.23237], [-116.3634, 33.23211], [-116.36371, 33.23196], [-116.36404, 33.23184], [-116.36438, 33.23175], [-116.36473, 33.23167], [-116.36508, 33.23163], [-116.36526, 33.23161], [-116.3653, 33.23163], [-116.36533, 33.23167], [-116.36536, 33.23412]]]} | Open Access 1 | 45996 | Borrego Springs Park Site Dedication | 29191 | 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 | 11.154 | Borrego Springs Park Site Dedication | None 392 | |||
5056 | 5056 | 5055 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75509], [-117.13393, 32.75509], [-117.13391, 32.75416], [-117.13499, 32.75415], [-117.13499, 32.75509]]]} | Restricted Access 2 | 46 | San Diego Indoor Soccer Center | 30288 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 2.583 | San Diego Indoor Soccer Ctr. | None 416 | |||
5282 | 5282 | 5281 | {"type": "Polygon", "coordinates": [[[-116.9986, 32.96095], [-116.99776, 32.96117], [-116.99758, 32.96085], [-116.99794, 32.96067], [-116.9981, 32.96063], [-116.99835, 32.96059], [-116.99841, 32.96063], [-116.9985, 32.96081], [-116.9986, 32.96095]]]} | Open Access 1 | 47639 | Sycamore Creek Neighborhood Park - East | 31380 | 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.91 | Sycamore Creek Neighborhood Park - East | None 426 | |||
6084 | 6084 | 6083 | {"type": "Polygon", "coordinates": [[[-117.03743, 32.96938], [-117.03742, 32.97105], [-117.03627, 32.97104], [-117.03628, 32.96938], [-117.03743, 32.96938]]]} | Open Access 1 | 890 | Old Poway Park and Railroad | 23098 | 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 | http://poway.org/452/Old-Poway-Park | San Diego 4 | 4.928 | Old Poway Park and Railroad | None 491 | ||
6136 | 6136 | 6135 | {"type": "Polygon", "coordinates": [[[-116.38064, 33.25292], [-116.3793, 33.25356], [-116.37899, 33.25374], [-116.37872, 33.25392], [-116.37866, 33.25393], [-116.3784, 33.25375], [-116.37788, 33.25326], [-116.37753, 33.25281], [-116.37726, 33.25241], [-116.37712, 33.25213], [-116.37694, 33.2517], [-116.37682, 33.25124], [-116.37676, 33.2508], [-116.37759, 33.25077], [-116.37785, 33.25082], [-116.37806, 33.25092], [-116.37822, 33.25101], [-116.3789, 33.25157], [-116.38064, 33.25292]]]} | Open Access 1 | 1161 | Borrego Springs Holding | 29228 | 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 | 15.939 | Borrego Springs Holding | None 494 | |||
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 | |||
7601 | 7601 | 7600 | {"type": "MultiPolygon", "coordinates": [[[[-117.13327, 33.06758], [-117.13262, 33.068], [-117.13262, 33.068], [-117.13262, 33.06788], [-117.13279, 33.06775], [-117.13327, 33.06758]]], [[[-117.13526, 33.06843], [-117.13397, 33.06938], [-117.13266, 33.06938], [-117.13262, 33.06807], [-117.13345, 33.06764], [-117.13364, 33.06788], [-117.13524, 33.06788], [-117.13526, 33.06843]]], [[[-117.14073, 33.06941], [-117.14006, 33.06987], [-117.13869, 33.06896], [-117.13932, 33.06837], [-117.14073, 33.06941]]]]} | No Public Access 3 | 7313 | Olivenhain Dam | 23134 | 2132 | San Diego County Water Authority 873 | Special District 4 | Water District 13 | http://www.sdcwa.org/ | Special District 4 | 2132 | San Diego County Water Authority 851 | Special District 4 | Water District 13 | San Diego 4 | 12.229 | Olivenhain Dam | 0 | None 633 | ||
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 |
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]);