units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,421 rows where COUNTY = 4 sorted by COUNTY
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70 | 70 | 69 | {"type": "Polygon", "coordinates": [[[-117.09581, 32.78702], [-117.0958, 32.78757], [-117.09407, 32.78755], [-117.09403, 32.78751], [-117.09402, 32.78697], [-117.09483, 32.78698], [-117.09581, 32.78702]]]} | Open Access 1 | 164 | Grantville Neighborhood Park | 30217 | 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.604 | Grantville Neighborhood Park | 0 | Local Park 2 | 4 | |
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 | |
80 | 80 | 79 | {"type": "Polygon", "coordinates": [[[-117.02291, 32.84594], [-117.02264, 32.84628], [-117.02204, 32.84691], [-117.02175, 32.84719], [-117.02112, 32.84769], [-117.02078, 32.84792], [-117.02051, 32.84808], [-117.0205, 32.84593], [-117.02291, 32.84594]]]} | Open Access 1 | 194 | West Hills Park | 27359 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/index.aspx?page=70 | San Diego 4 | 7.496 | West Hills Park | 0 | Local Park 2 | 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 | |
110 | 110 | 109 | {"type": "Polygon", "coordinates": [[[-117.29125, 33.04677], [-117.29115, 33.04685], [-117.29116, 33.04711], [-117.29104, 33.04713], [-117.29093, 33.0472], [-117.29088, 33.04731], [-117.29089, 33.04741], [-117.29079, 33.04744], [-117.29081, 33.04755], [-117.29009, 33.04705], [-117.29007, 33.04643], [-117.29016, 33.04643], [-117.29017, 33.04645], [-117.29118, 33.04635], [-117.29125, 33.04677]]]} | Open Access 1 | 297 | Encinitas Viewpoint Park | 18667 | 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/Parks | San Diego 4 | 2.45 | Encinitas Viewpoint Park | 0 | Local Park 2 | 4 |
116 | 116 | 115 | {"type": "Polygon", "coordinates": [[[-117.05346, 32.75727], [-117.05342, 32.75866], [-117.05249, 32.75867], [-117.0525, 32.75802], [-117.05247, 32.75782], [-117.0525, 32.75781], [-117.05247, 32.75726], [-117.05297, 32.75708], [-117.05311, 32.75716], [-117.05346, 32.75727]]]} | Open Access 1 | 346 | Rolando Park | 24573 | 1157 | La Mesa, City of 50 | City 2 | City Agency 2 | http://www.cityoflamesa.com/index.aspx?nid=410 | City 2 | 1157 | La Mesa, City of 48 | City 2 | City Agency 2 | http://www.cityoflamesa.com/398/Rolando-Park | San Diego 4 | 3.646 | Rolando Park | 0 | Local Park 2 | 4 |
118 | 118 | 117 | {"type": "MultiPolygon", "coordinates": [[[[-117.08737, 32.68726], [-117.08735, 32.6873], [-117.08732, 32.68732], [-117.08474, 32.68803], [-117.08468, 32.68802], [-117.08463, 32.68799], [-117.08397, 32.68647], [-117.0868, 32.68568], [-117.08689, 32.68594], [-117.08688, 32.68599], [-117.08551, 32.68639], [-117.0855, 32.68641], [-117.08557, 32.68655], [-117.08691, 32.68616], [-117.08697, 32.68617], [-117.08701, 32.68621], [-117.08715, 32.68658], [-117.0871, 32.68666], [-117.08577, 32.68703], [-117.08576, 32.68704], [-117.08583, 32.68718], [-117.08719, 32.68681], [-117.08726, 32.68685], [-117.08731, 32.68699], [-117.08737, 32.68726]]], [[[-117.09053, 32.68616], [-117.09004, 32.68629], [-117.09002, 32.68627], [-117.08784, 32.68687], [-117.0879, 32.6872], [-117.08756, 32.68724], [-117.08754, 32.68708], [-117.08745, 32.68681], [-117.08694, 32.68547], [-117.08694, 32.68542], [-117.08697, 32.68539], [-117.08723, 32.68531], [-117.08882, 32.68486], [-117.08947, 32.68531], [-117.09053, 32.68616]]]]} | Open Access 1 | 351 | El Toyon Park | 18547 | 1219 | National City, City of 51 | City 2 | City Agency 2 | http://www.ci.national-city.ca.us/index.aspx?page=152 | City 2 | 1219 | National City, City of 49 | City 2 | City Agency 2 | http://www.nationalcityca.gov/city-government/community-services/facilities | San Diego 4 | 22.811 | El Toyon 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 | |
130 | 130 | 129 | {"type": "Polygon", "coordinates": [[[-117.25801, 32.85566], [-117.25562, 32.85961], [-117.25539, 32.8596], [-117.25546, 32.85849], [-117.25734, 32.85536], [-117.25801, 32.85566]]]} | Open Access 1 | 324 | Kellogg Park | 20584 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/kelloggpark | San Diego 4 | 7.979 | Kellogg 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 | |
138 | 138 | 137 | {"type": "Polygon", "coordinates": [[[-117.02028, 32.77066], [-117.01976, 32.77081], [-117.01831, 32.77154], [-117.01648, 32.77216], [-117.01643, 32.77078], [-117.01598, 32.77079], [-117.01506, 32.77127], [-117.01491, 32.77112], [-117.01505, 32.77081], [-117.01461, 32.77081], [-117.01462, 32.77077], [-117.01515, 32.77075], [-117.01514, 32.76953], [-117.01531, 32.76952], [-117.0153, 32.76907], [-117.01532, 32.76875], [-117.0153, 32.76847], [-117.01548, 32.76844], [-117.01657, 32.7684], [-117.01684, 32.76833], [-117.01685, 32.76879], [-117.01687, 32.7688], [-117.01688, 32.76974], [-117.01701, 32.76985], [-117.01733, 32.76984], [-117.01752, 32.76999], [-117.01828, 32.76998], [-117.01898, 32.77016], [-117.01924, 32.77019], [-117.01952, 32.7702], [-117.01952, 32.77067], [-117.02028, 32.77066]]]} | Open Access 1 | 357 | MacArthur Park | 21622 | 1157 | La Mesa, City of 50 | City 2 | City Agency 2 | http://www.cityoflamesa.com/index.aspx?nid=410 | City 2 | 1157 | La Mesa, City of 48 | City 2 | City Agency 2 | http://www.cityoflamesa.com/395/MacArthur-Park | San Diego 4 | 22.714 | MacArthur 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 |
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]);