units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 513
- 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 631
- Local Recreation Area 304
- 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 975
- 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
AGNCY_LEV 7 ✖
- City 967
- County 120
- Non Profit 102
- State 86
- Special District 67
- Private 35
- Federal 24
ACCESS_TYP 4
- Open Access 1,144
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76 | 76 | 75 | {"type": "Polygon", "coordinates": [[[-117.21231, 32.83417], [-117.2123, 32.83532], [-117.21045, 32.83532], [-117.21045, 32.83506], [-117.21039, 32.83505], [-117.2104, 32.83456], [-117.2105, 32.83441], [-117.21086, 32.83404], [-117.21145, 32.83441], [-117.21146, 32.8344], [-117.21146, 32.83418], [-117.21231, 32.83417]]]} | Open Access 1 | 228 | Gershwin Neighborhood Park | 30085 | 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 | 5.364 | Gershwin Neighborhood Park | 0 | Local Park 2 | 4 | |
78 | 78 | 77 | {"type": "Polygon", "coordinates": [[[-117.19807, 32.83041], [-117.19753, 32.83309], [-117.19713, 32.83285], [-117.19702, 32.83282], [-117.19501, 32.83283], [-117.19496, 32.83279], [-117.19496, 32.83237], [-117.19537, 32.83236], [-117.19604, 32.83176], [-117.19599, 32.83096], [-117.19602, 32.8307], [-117.19625, 32.83031], [-117.19676, 32.82987], [-117.19728, 32.83002], [-117.19807, 32.83041]]]} | Open Access 1 | 235 | North Clairemont Community Park | 22814 | 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 | 14.501 | North Clairemont Community Park | 0 | Local Park 2 | 4 | |
79 | 79 | 78 | {"type": "Polygon", "coordinates": [[[-117.23873, 32.83257], [-117.23825, 32.83268], [-117.2382, 32.83254], [-117.23868, 32.83244], [-117.23873, 32.83257]]]} | Open Access 1 | 236 | La Jolla Open Space | 20766 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.172 | La Jolla OS | 0 | Local Recreation Area 3 | 4 | |
85 | 85 | 84 | {"type": "Polygon", "coordinates": [[[-117.2351, 32.72159], [-117.23488, 32.72151], [-117.23474, 32.72148], [-117.23481, 32.72123], [-117.23487, 32.72124], [-117.23492, 32.72139], [-117.235, 32.72149], [-117.2351, 32.72159]]]} | Open Access 1 | 221 | Cabrillo Mini-Park South | 30118 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.12 | Cabrillo Mini-Park South | 0 | Local Park 2 | 4 | |
98 | 98 | 97 | {"type": "MultiPolygon", "coordinates": [[[[-117.1681, 32.83591], [-117.16809, 32.83651], [-117.16806, 32.83679], [-117.16796, 32.83715], [-117.16778, 32.8376], [-117.1677, 32.83797], [-117.16768, 32.83814], [-117.16768, 32.83894], [-117.1651, 32.83896], [-117.16509, 32.8392], [-117.1635, 32.83922], [-117.16349, 32.83822], [-117.16255, 32.83823], [-117.16249, 32.83577], [-117.16617, 32.83574], [-117.16618, 32.83593], [-117.1681, 32.83591]]], [[[-117.16833, 32.83894], [-117.16791, 32.83894], [-117.16791, 32.83815], [-117.16794, 32.83788], [-117.16803, 32.83757], [-117.16822, 32.83706], [-117.16831, 32.83659], [-117.16833, 32.83894]]]]} | Open Access 1 | 252 | Hickman Field Athletic Complex | 19895 | 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 | 44.171 | Hickman Field Athletic Complex | 0 | Local Recreation Area 3 | 4 | |
99 | 99 | 98 | {"type": "Polygon", "coordinates": [[[-117.19827, 32.78629], [-117.19822, 32.78654], [-117.19813, 32.78654], [-117.19802, 32.78715], [-117.19689, 32.78688], [-117.19654, 32.78708], [-117.19612, 32.78764], [-117.19569, 32.78779], [-117.19555, 32.78777], [-117.19465, 32.78693], [-117.1948, 32.78573], [-117.19718, 32.78581], [-117.19821, 32.78595], [-117.19816, 32.78627], [-117.19827, 32.78629]]]} | Open Access 1 | 266 | Western Hills Neighborhood Park | 30165 | 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 | 12.876 | Western Hills Neighborhood Park | 0 | Local Park 2 | 4 | |
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 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 | San Diego 4 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
106 | 106 | 105 | {"type": "Polygon", "coordinates": [[[-117.10318, 32.90156], [-117.10307, 32.9016], [-117.10187, 32.90144], [-117.10218, 32.90092], [-117.10229, 32.90072], [-117.10315, 32.90065], [-117.1031, 32.90102], [-117.10311, 32.90134], [-117.10318, 32.90156]]]} | Open Access 1 | 293 | Aviary Neighborhood Park | 30137 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.256 | Aviary Neighborhood Park | 0 | Local Park 2 | 4 | |
123 | 123 | 122 | {"type": "Polygon", "coordinates": [[[-117.0714, 32.91778], [-117.07127, 32.91799], [-117.07094, 32.91786], [-117.07093, 32.91726], [-117.07111, 32.91751], [-117.0714, 32.91778]]]} | Open Access 1 | 311 | Semillon Mini Park | 25294 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.437 | Semillon MP | 0 | Local Park 2 | 4 | |
124 | 124 | 123 | {"type": "MultiPolygon", "coordinates": [[[[-117.26548, 32.84333], [-117.26547, 32.84364], [-117.2652, 32.8437], [-117.26511, 32.84366], [-117.26499, 32.84366], [-117.2649, 32.84372], [-117.26487, 32.84377], [-117.26422, 32.84393], [-117.2641, 32.84393], [-117.26406, 32.84397], [-117.26369, 32.84406], [-117.26355, 32.84406], [-117.26353, 32.84403], [-117.26343, 32.84399], [-117.26317, 32.84393], [-117.26309, 32.84393], [-117.26294, 32.84381], [-117.26284, 32.84379], [-117.26275, 32.84388], [-117.26274, 32.84395], [-117.26275, 32.84399], [-117.2628, 32.84402], [-117.26294, 32.84404], [-117.26305, 32.84407], [-117.26322, 32.84416], [-117.26071, 32.84475], [-117.26029, 32.84487], [-117.26016, 32.84487], [-117.25892, 32.84516], [-117.25842, 32.84358], [-117.25809, 32.84261], [-117.25941, 32.84228], [-117.26273, 32.8415], [-117.26283, 32.84162], [-117.26297, 32.84201], [-117.26303, 32.84209], [-117.26319, 32.84221], [-117.26407, 32.84242], [-117.26441, 32.84253], [-117.26443, 32.84256], [-117.2646, 32.84263], [-117.26461, 32.84265], [-117.26475, 32.84275], [-117.2653, 32.84321], [-117.26548, 32.84333]]], [[[-117.26349, 32.84409], [-117.26328, 32.84414], [-117.26311, 32.84404], [-117.26296, 32.84399], [-117.26281, 32.84397], [-117.26279, 32.84394], [-117.2628, 32.8439], [-117.26287, 32.84384], [-117.26292, 32.84386], [-117.26304, 32.84397], [-117.26308, 32.84398], [-117.26349, 32.84409]]], [[[-117.264, 32.8423], [-117.26331, 32.84213], [-117.2632, 32.84207], [-117.26312, 32.842], [-117.26308, 32.84195], [-117.26297, 32.84161], [-117.26288, 32.84147], [-117.2632, 32.84139], [-117.264, 32.8423]]]]} | Open Access 1 | 314 | La Jolla Heights Natural Park | 20764 | 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 | 41.0 | La Jolla Heights Natural Park | 0 | Local Park 2 | 4 | |
131 | 131 | 130 | {"type": "Polygon", "coordinates": [[[-117.24598, 32.8585], [-117.24408, 32.85853], [-117.24395, 32.85841], [-117.24382, 32.85852], [-117.24358, 32.85817], [-117.24351, 32.85816], [-117.2435, 32.85814], [-117.24337, 32.85812], [-117.24332, 32.85797], [-117.24311, 32.85789], [-117.24304, 32.85789], [-117.24305, 32.85752], [-117.24302, 32.85751], [-117.24302, 32.85746], [-117.24284, 32.85737], [-117.24296, 32.85717], [-117.243, 32.85707], [-117.24302, 32.85694], [-117.243, 32.85678], [-117.24526, 32.85678], [-117.2453, 32.85708], [-117.24538, 32.85735], [-117.24554, 32.85763], [-117.24584, 32.85798], [-117.24589, 32.85807], [-117.24596, 32.85827], [-117.24598, 32.8585]]]} | Open Access 1 | 325 | Cliffridge Neighborhood Park | 30160 | 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 | 10.738 | Cliffridge Neighborhood Park | 0 | Local Park 2 | 4 | |
132 | 132 | 131 | {"type": "MultiPolygon", "coordinates": [[[[-117.21165, 32.84902], [-117.21112, 32.84923], [-117.21114, 32.85113], [-117.21083, 32.85129], [-117.21059, 32.85144], [-117.20911, 32.85244], [-117.20909, 32.85009], [-117.20923, 32.85007], [-117.20987, 32.84839], [-117.20982, 32.84806], [-117.20947, 32.8476], [-117.2096, 32.84703], [-117.20975, 32.84697], [-117.20987, 32.84689], [-117.20987, 32.84729], [-117.21033, 32.8473], [-117.21088, 32.84801], [-117.21144, 32.84826], [-117.21135, 32.8485], [-117.21141, 32.84871], [-117.21165, 32.84902]]], [[[-117.20987, 32.84664], [-117.20968, 32.84681], [-117.20958, 32.84686], [-117.20943, 32.8464], [-117.20915, 32.84622], [-117.20986, 32.84594], [-117.20987, 32.84664]]]]} | Open Access 1 | 336 | Standley Community Park | 25784 | 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 | 20.703 | Standley Community Park | 0 | Local Park 2 | 4 | |
141 | 141 | 140 | {"type": "Polygon", "coordinates": [[[-117.23261, 32.94159], [-117.23242, 32.94201], [-117.23235, 32.9423], [-117.23231, 32.94232], [-117.23227, 32.94233], [-117.23102, 32.94217], [-117.23099, 32.94216], [-117.23098, 32.94214], [-117.23101, 32.94172], [-117.23101, 32.94134], [-117.23261, 32.94159]]]} | Open Access 1 | 445 | Carmel Grove Neighborhood Park | 30152 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.028 | Carmel Grove Neighborhood Park | 0 | Local Park 2 | 4 | |
154 | 154 | 153 | {"type": "Polygon", "coordinates": [[[-116.74026, 33.1805], [-116.73988, 33.18051], [-116.73975, 33.18053], [-116.73967, 33.18056], [-116.7395, 33.18056], [-116.73938, 33.18052], [-116.73921, 33.18041], [-116.73814, 33.18041], [-116.73818, 33.18262], [-116.73708, 33.18261], [-116.73375, 33.18275], [-116.73377, 33.17923], [-116.74025, 33.17921], [-116.74026, 33.1805]]]} | No Public Access 3 | 416 | Ewing Oak Preserve | 18771 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 45.451 | Ewing Oak Preserve | 0 | Private Conservation 16 | 2 | |
157 | 157 | 156 | {"type": "Polygon", "coordinates": [[[-117.2072, 32.92664], [-117.20718, 32.92667], [-117.20702, 32.92675], [-117.20665, 32.92691], [-117.20627, 32.92702], [-117.20576, 32.9271], [-117.20546, 32.92712], [-117.20412, 32.92709], [-117.20242, 32.92702], [-117.20267, 32.9264], [-117.20319, 32.92654], [-117.20435, 32.92653], [-117.20436, 32.92598], [-117.20466, 32.92571], [-117.20468, 32.92565], [-117.2049, 32.92567], [-117.20504, 32.92552], [-117.20586, 32.92558], [-117.20608, 32.92564], [-117.20638, 32.92577], [-117.20651, 32.92585], [-117.20669, 32.92602], [-117.20719, 32.9266], [-117.2072, 32.92664]]]} | Open Access 1 | 498 | Sage Canyon Neighborhood Park | 24781 | 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 | 11.544 | Sage Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
169 | 169 | 168 | {"type": "Polygon", "coordinates": [[[-117.22951, 32.94051], [-117.22941, 32.94054], [-117.22942, 32.94052], [-117.22937, 32.94039], [-117.22922, 32.94033], [-117.22916, 32.94027], [-117.22905, 32.94019], [-117.22877, 32.9401], [-117.22873, 32.94012], [-117.2286, 32.94032], [-117.22857, 32.94039], [-117.22857, 32.94046], [-117.22834, 32.94055], [-117.22821, 32.94046], [-117.22795, 32.9404], [-117.2279, 32.94042], [-117.2278, 32.94057], [-117.22776, 32.94064], [-117.22775, 32.94075], [-117.22777, 32.94082], [-117.2278, 32.94086], [-117.22785, 32.94089], [-117.22783, 32.94095], [-117.22791, 32.94096], [-117.22791, 32.94093], [-117.22811, 32.94103], [-117.22831, 32.94111], [-117.22868, 32.94123], [-117.22874, 32.94117], [-117.22892, 32.9411], [-117.22892, 32.94108], [-117.22898, 32.94104], [-117.22922, 32.94106], [-117.22931, 32.94104], [-117.22937, 32.94097], [-117.2294, 32.94082], [-117.22943, 32.94081], [-117.22945, 32.94081], [-117.22946, 32.94084], [-117.2294, 32.94102], [-117.22931, 32.94117], [-117.22873, 32.94187], [-117.22785, 32.94149], [-117.22745, 32.94126], [-117.22708, 32.9413], [-117.22682, 32.9412], [-117.2262, 32.9412], [-117.22622, 32.94109], [-117.22645, 32.94086], [-117.22653, 32.9406], [-117.22645, 32.94035], [-117.22613, 32.93992], [-117.22789, 32.9393], [-117.22818, 32.93927], [-117.22838, 32.93927], [-117.22869, 32.93934], [-117.2289, 32.93945], [-117.22903, 32.93955], [-117.22914, 32.93966], [-117.22923, 32.93977], [-117.22927, 32.93985], [-117.22944, 32.94023], [-117.22951, 32.94051]]]} | Open Access 1 | 451 | Carmel Del Mar Neighborhood Park | 30150 | 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 | 12.077 | Carmel Del Mar Neighborhood Park | 0 | Local Park 2 | 4 | |
176 | 176 | 175 | {"type": "Polygon", "coordinates": [[[-117.04021, 32.58356], [-117.04017, 32.58359], [-117.03877, 32.5836], [-117.03826, 32.58321], [-117.03819, 32.58213], [-117.03821, 32.58198], [-117.03938, 32.58198], [-117.03947, 32.5819], [-117.03954, 32.58193], [-117.03961, 32.58194], [-117.04018, 32.58193], [-117.04021, 32.58198], [-117.04021, 32.58356]]]} | Open Access 1 | 484 | Palm Ridge Neighborhood Park | 30073 | 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 | 8.09 | Palm Ridge Neighborhood Park | 0 | Local Park 2 | 4 | |
187 | 187 | 186 | {"type": "Polygon", "coordinates": [[[-116.98547, 32.79471], [-116.98538, 32.79502], [-116.98401, 32.79502], [-116.98391, 32.79564], [-116.98443, 32.796], [-116.98415, 32.79631], [-116.98414, 32.79654], [-116.98415, 32.7966], [-116.98374, 32.79652], [-116.98358, 32.79629], [-116.98311, 32.79603], [-116.98248, 32.79604], [-116.98244, 32.79514], [-116.98279, 32.79507], [-116.98298, 32.79497], [-116.98319, 32.7949], [-116.98332, 32.79484], [-116.98364, 32.79465], [-116.98397, 32.79437], [-116.98416, 32.79416], [-116.98435, 32.79387], [-116.98446, 32.79365], [-116.98547, 32.79471]]]} | Open Access 1 | 590 | City of El Cajon Open Space | 17309 | 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 | 9.123 | City of El Cajon OS | 0 | Local Recreation Area 3 | 4 | |
192 | 192 | 191 | {"type": "Polygon", "coordinates": [[[-117.25358, 33.2577], [-117.25022, 33.25616], [-117.25015, 33.25611], [-117.25356, 33.2561], [-117.25358, 33.2577]]]} | Open Access 1 | 527 | San Luis Rey River | 24941 | 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 | 7.039 | San Luis Rey River | None 21 | |||
196 | 196 | 195 | {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]} | No Public Access 3 | 46830 | Palmer Property | 30298 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 2.548 | Palmer Property | 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]);