units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_LEV, GAP_STS
MNG_AGENCY >30
- San Diego, City of 533
- San Diego, County of 123
- Chula Vista, City of 70
- Poway, City of 67
- Encinitas, City of 57
- Oceanside, City of 45
- 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 Transportation 22
- California Department of Parks and Recreation 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
- Del Mar, City of 8
- United States Bureau of Land Management 7
- National City, 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Recreation Management Area 1
- None 1
- None 1
- National Monument or Landmark 1
- None 1
- …
MNG_AG_TYP 21
- City Agency 995
- County Agency 123
- State Agency 87
- 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 7
- Commercial 5
- Recreation/Parks District 4
- Transportation Agency 4
- Open Space District 2
- Irrigation District 2
- Special District - Other 2
- Other 2
- School District 1
- Mitigation Bank 1
- Utility 1
- Fire District 1
LAYER 14 ✖
- City 987
- County 120
- Non Governmental Organization 102
- Special District 67
- Other State 38
- Private 35
- California Department of Fish and Wildlife 29
- California Department of Parks and Recreation 19
- US Bureau of Land Management 10
- US Fish and Wildlife Service 7
- US Military/Defense 4
- US Forest Service 1
- National Park Service 1
- Other Federal 1
ACCESS_TYP 4
- Open Access 1,164
- No Public Access 128
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1165 | 1165 | 1164 | {"type": "Polygon", "coordinates": [[[-116.90615, 32.72851], [-116.90484, 32.7283], [-116.90399, 32.72803], [-116.90394, 32.72518], [-116.90608, 32.72533], [-116.90615, 32.72851]]]} | Open Access 1 | 7381 | San Diego National Wildlife Refuge | 24858 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | San Diego 4 | 16.779 | San Diego NWR | 1996 | National Wildlife Refuge 105 | 2 | ||
1625 | 1625 | 1624 | {"type": "Polygon", "coordinates": [[[-117.03443, 32.57835], [-117.03338, 32.57837], [-117.03339, 32.57655], [-117.03443, 32.57653], [-117.03443, 32.57835]]]} | No Public Access 3 | 12395 | Newport 5 Preserve | 22731 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 4.919 | Newport 5 Preserve | 0 | Private Conservation 16 | 2 | ||
3420 | 3420 | 3419 | {"type": "Polygon", "coordinates": [[[-117.05959, 32.78133], [-117.05924, 32.78214], [-117.0579, 32.78173], [-117.05777, 32.78163], [-117.05832, 32.78034], [-117.05875, 32.78051], [-117.05875, 32.78059], [-117.0588, 32.78065], [-117.05889, 32.78067], [-117.05897, 32.78065], [-117.05922, 32.78083], [-117.05921, 32.78113], [-117.05925, 32.78141], [-117.05959, 32.78132], [-117.05959, 32.78133]]]} | Restricted Access 2 | 25123 | Del Cerro Park | 31745 | 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 | 4.764 | Del Cerro Park | 0 | Private Recreation or Education 65 | 4 | ||
3806 | 3806 | 3805 | {"type": "Polygon", "coordinates": [[[-116.97738, 32.65693], [-116.97721, 32.65698], [-116.9771, 32.65706], [-116.97694, 32.65721], [-116.97668, 32.65643], [-116.97706, 32.65643], [-116.97724, 32.65675], [-116.97738, 32.65693]]]} | Restricted Access 2 | 45163 | Cobblestone Park | 33360 | 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.726 | Cobblestone Park | 0 | Private Recreation or Education 65 | 4 | ||
3813 | 3813 | 3812 | {"type": "Polygon", "coordinates": [[[-116.99456, 32.62803], [-116.99407, 32.62875], [-116.99394, 32.62888], [-116.99368, 32.62907], [-116.99364, 32.62907], [-116.99332, 32.62882], [-116.9933, 32.62871], [-116.99399, 32.62774], [-116.99403, 32.62773], [-116.99455, 32.62799], [-116.99456, 32.62803]]]} | Restricted Access 2 | 45186 | Oak Crest Park | 33358 | 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 | 2.168 | Oak Crest Park | 0 | Private Recreation or Education 65 | 4 | ||
3814 | 3814 | 3813 | {"type": "Polygon", "coordinates": [[[-116.96275, 32.65963], [-116.96272, 32.6598], [-116.96273, 32.65988], [-116.96252, 32.65994], [-116.96249, 32.65993], [-116.96238, 32.65998], [-116.96235, 32.65997], [-116.96224, 32.66002], [-116.96221, 32.66001], [-116.96195, 32.6601], [-116.96175, 32.66013], [-116.96165, 32.65965], [-116.96164, 32.6595], [-116.96167, 32.65933], [-116.96188, 32.65935], [-116.962, 32.6594], [-116.96203, 32.65939], [-116.96215, 32.65944], [-116.96218, 32.65943], [-116.96245, 32.65955], [-116.96275, 32.65963]]]} | Restricted Access 2 | 45187 | Madison Lane Park | 33353 | 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.505 | Madison Lane Park | 0 | Private Recreation or Education 65 | 4 | ||
4258 | 4258 | 4257 | {"type": "Polygon", "coordinates": [[[-116.95997, 32.62142], [-116.9593, 32.62156], [-116.95916, 32.62104], [-116.95966, 32.62083], [-116.95972, 32.62084], [-116.95987, 32.6211], [-116.95997, 32.62142]]]} | Restricted Access 2 | 45184 | HOA Park | 31749 | 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.008 | HOA Park | 0 | Private Recreation or Education 65 | 4 | ||
4259 | 4259 | 4258 | {"type": "Polygon", "coordinates": [[[-116.98256, 32.62142], [-116.98251, 32.62145], [-116.98215, 32.62155], [-116.98208, 32.62155], [-116.98189, 32.62107], [-116.98195, 32.62104], [-116.98229, 32.62094], [-116.98237, 32.62094], [-116.98256, 32.62142]]]} | Restricted Access 2 | 45185 | Hillsborough Park | 33348 | 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.702 | Hillsborough Park | 0 | Private Recreation or Education 65 | 4 | ||
4265 | 4265 | 4264 | {"type": "Polygon", "coordinates": [[[-116.9567, 32.66503], [-116.95654, 32.66512], [-116.95638, 32.66517], [-116.95606, 32.66524], [-116.95601, 32.66487], [-116.95602, 32.66467], [-116.95616, 32.66437], [-116.95618, 32.66437], [-116.95629, 32.66455], [-116.95631, 32.66456], [-116.95642, 32.66473], [-116.95646, 32.66474], [-116.9567, 32.66503]]]} | Restricted Access 2 | 45205 | Magnolia Hill Park | 33356 | 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.848 | Magnolia Hill Park | 0 | Private Recreation or Education 65 | 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 | |||
4960 | 4960 | 4959 | {"type": "MultiPolygon", "coordinates": [[[[-116.95389, 32.62879], [-116.95386, 32.62885], [-116.95334, 32.62907], [-116.95288, 32.6293], [-116.94886, 32.63154], [-116.94878, 32.63152], [-116.94777, 32.63021], [-116.94712, 32.62933], [-116.94715, 32.62927], [-116.9473, 32.6292], [-116.94749, 32.62947], [-116.94866, 32.63102], [-116.94885, 32.63109], [-116.94899, 32.63111], [-116.94912, 32.6311], [-116.94923, 32.63107], [-116.95003, 32.63059], [-116.95025, 32.6302], [-116.95064, 32.63024], [-116.95164, 32.62962], [-116.95191, 32.62941], [-116.95206, 32.62932], [-116.95252, 32.62929], [-116.95344, 32.62876], [-116.95358, 32.62861], [-116.95357, 32.62844], [-116.95371, 32.62841], [-116.95389, 32.62879]]], [[[-116.95778, 32.62794], [-116.95704, 32.6281], [-116.95487, 32.62855], [-116.95422, 32.62873], [-116.95415, 32.6287], [-116.954, 32.6284], [-116.95407, 32.62837], [-116.95416, 32.62846], [-116.95443, 32.62854], [-116.95604, 32.62813], [-116.95694, 32.62793], [-116.95724, 32.62792], [-116.95741, 32.62789], [-116.95759, 32.62775], [-116.95778, 32.62794]]]]} | Restricted Access 2 | 45161 | HOA Open Space | 31748 | 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 | 7.416 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
4962 | 4962 | 4961 | {"type": "MultiPolygon", "coordinates": [[[[-116.98594, 32.6469], [-116.98591, 32.64692], [-116.98584, 32.64693], [-116.98545, 32.64674], [-116.98558, 32.64668], [-116.98578, 32.64682], [-116.98594, 32.6469]]], [[[-116.98664, 32.64925], [-116.98652, 32.64925], [-116.98693, 32.64859], [-116.98705, 32.64845], [-116.98707, 32.64834], [-116.98707, 32.64814], [-116.98696, 32.64797], [-116.98662, 32.64767], [-116.98618, 32.64741], [-116.98595, 32.64725], [-116.98675, 32.64765], [-116.98695, 32.64777], [-116.98717, 32.64793], [-116.98748, 32.64821], [-116.98747, 32.64827], [-116.98717, 32.64855], [-116.98694, 32.64882], [-116.98664, 32.64925]]]]} | Restricted Access 2 | 45162 | HOA Open Space | 31748 | 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.099 | HOA OS | 0 | Private Recreation or Education 65 | 4 | ||
5619 | 5619 | 5618 | {"type": "Polygon", "coordinates": [[[-116.95083, 32.62528], [-116.95098, 32.62537], [-116.95112, 32.62549], [-116.95124, 32.62562], [-116.95133, 32.62575], [-116.95141, 32.6259], [-116.95146, 32.62607], [-116.95149, 32.62623], [-116.95148, 32.6264], [-116.95145, 32.62659], [-116.95139, 32.62673], [-116.95131, 32.62689], [-116.9512, 32.62703], [-116.95105, 32.62717], [-116.95092, 32.62727], [-116.95054, 32.62745], [-116.95053, 32.62744], [-116.95055, 32.62738], [-116.9505, 32.62727], [-116.95048, 32.62711], [-116.95051, 32.62704], [-116.95063, 32.62686], [-116.95069, 32.62661], [-116.95065, 32.62654], [-116.95065, 32.62647], [-116.95074, 32.62641], [-116.95075, 32.62617], [-116.95072, 32.62598], [-116.95077, 32.62571], [-116.95079, 32.62547], [-116.95085, 32.62535], [-116.95082, 32.6253], [-116.95083, 32.62528]]]} | Restricted Access 2 | 45188 | HOA Park | 31749 | 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.222 | HOA Park | 0 | Private Recreation or Education 65 | 4 | ||
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 | ||||
8156 | 8156 | 8155 | {"type": "Polygon", "coordinates": [[[-117.06244, 32.94866], [-117.0619, 32.94857], [-117.06188, 32.94879], [-117.06125, 32.9488], [-117.0604, 32.94906], [-117.05975, 32.94933], [-117.0592, 32.94962], [-117.0591, 32.94967], [-117.0591, 32.9497], [-117.05853, 32.94975], [-117.05843, 32.94897], [-117.0585, 32.94904], [-117.05852, 32.94919], [-117.0586, 32.94933], [-117.05864, 32.94936], [-117.05867, 32.94936], [-117.05927, 32.94899], [-117.06002, 32.94867], [-117.06069, 32.94846], [-117.06109, 32.94836], [-117.06167, 32.9483], [-117.06193, 32.94833], [-117.06232, 32.94842], [-117.06244, 32.94856], [-117.06244, 32.94866]]]} | No Public Access 3 | 12362 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 4.784 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8157 | 8157 | 8156 | {"type": "Polygon", "coordinates": [[[-117.17034, 33.16823], [-117.17028, 33.17193], [-117.16599, 33.17203], [-117.16594, 33.16798], [-117.16584, 33.16629], [-117.17034, 33.16823]]]} | No Public Access 3 | 12363 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 52.513 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8158 | 8158 | 8157 | {"type": "MultiPolygon", "coordinates": [[[[-117.17834, 33.15876], [-117.17412, 33.15879], [-117.17398, 33.15703], [-117.16536, 33.15715], [-117.16518, 33.15371], [-117.16539, 33.15373], [-117.16535, 33.15406], [-117.16536, 33.15424], [-117.1653, 33.15459], [-117.16536, 33.15583], [-117.1655, 33.15606], [-117.16571, 33.15631], [-117.16592, 33.15648], [-117.16614, 33.15663], [-117.16637, 33.15671], [-117.16653, 33.15645], [-117.16662, 33.15649], [-117.16673, 33.15647], [-117.1668, 33.15639], [-117.1668, 33.15632], [-117.16676, 33.15627], [-117.1667, 33.15623], [-117.16656, 33.15624], [-117.16644, 33.15618], [-117.16629, 33.15609], [-117.16615, 33.15596], [-117.16607, 33.15585], [-117.16598, 33.15567], [-117.16595, 33.15553], [-117.16595, 33.15533], [-117.16599, 33.15511], [-117.16644, 33.15515], [-117.16644, 33.15488], [-117.16662, 33.15379], [-117.16669, 33.15355], [-117.16782, 33.15355], [-117.16766, 33.15382], [-117.16784, 33.15399], [-117.16813, 33.15402], [-117.16819, 33.15406], [-117.16824, 33.15408], [-117.16833, 33.15407], [-117.16838, 33.15403], [-117.1686, 33.15404], [-117.16859, 33.15441], [-117.16892, 33.15443], [-117.16893, 33.15461], [-117.16881, 33.15502], [-117.16883, 33.15511], [-117.1688, 33.15547], [-117.1687, 33.15564], [-117.16846, 33.15589], [-117.1683, 33.15596], [-117.16809, 33.15611], [-117.16802, 33.15629], [-117.16803, 33.15631], [-117.16829, 33.15631], [-117.16827, 33.15639], [-117.16829, 33.15644], [-117.16833, 33.15648], [-117.16841, 33.15651], [-117.16851, 33.15649], [-117.16858, 33.15641], [-117.16878, 33.15632], [-117.16895, 33.15618], [-117.16928, 33.15642], [-117.16936, 33.15633], [-117.1694, 33.15619], [-117.16953, 33.15608], [-117.1696, 33.15586], [-117.16973, 33.15556], [-117.17004, 33.1547], [-117.16996, 33.15425], [-117.16987, 33.15407], [-117.17073, 33.15411], [-117.1712, 33.15412], [-117.17139, 33.15408], [-117.17199, 33.15391], [-117.17277, 33.15391], [-117.17281, 33.15392], [-117.17278, 33.15402], [-117.17323, 33.15424], [-117.17339, 33.15423], [-117.17355, 33.15411], [-117.1735, 33.15352], [-117.17371, 33.15352], [-117.17399, 33.15703], [-117.17776, 33.15699], [-117.17782, 33.15716], [-117.17793, 33.15737], [-117.17807, 33.15756], [-117.17829, 33.15779], [-117.17834, 33.15876]]], [[[-117.17826, 33.15738], [-117.17816, 33.15727], [-117.17798, 33.15699], [-117.17823, 33.15699], [-117.17826, 33.15738]]]]} | No Public Access 3 | 12366 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 74.622 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8160 | 8160 | 8159 | {"type": "Polygon", "coordinates": [[[-117.14404, 32.97655], [-117.14403, 32.97699], [-117.14363, 32.97685], [-117.14365, 32.97679], [-117.14365, 32.97656], [-117.14404, 32.97655]]]} | No Public Access 3 | 12367 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.366 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8165 | 8165 | 8164 | {"type": "Polygon", "coordinates": [[[-117.02171, 32.65451], [-117.02033, 32.65449], [-117.01985, 32.65443], [-117.01953, 32.65435], [-117.02146, 32.65381], [-117.02171, 32.65451]]]} | No Public Access 3 | 12368 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 2.163 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 |
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]);