units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
533 rows where MNG_AGENCY = 4 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 21
- Local Park 267
- Local Recreation Area 186
- Local Other or Unknown 14
- Local Conservation Area 9
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 4
- Open Access 463
- No Public Access 19
- Restricted Access 10
- Unknown Access 1
MNG_AG_TYP 1
- City Agency 493
MNG_AGENCY 1
- San Diego, City of · 493 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69 | 69 | 68 | {"type": "Polygon", "coordinates": [[[-117.06833, 32.78979], [-117.0681, 32.78985], [-117.06791, 32.78987], [-117.06755, 32.78998], [-117.06712, 32.79007], [-117.0668, 32.78832], [-117.06803, 32.78813], [-117.06823, 32.7894], [-117.06833, 32.78979]]]} | Open Access 1 | 163 | Princess Del Cerro Neighborhood Park | 30167 | 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.472 | Princess Del Cerro Neighborhood Park | 0 | Local Park 2 | 4 | |
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 | |
5839 | 5839 | 5838 | {"type": "Polygon", "coordinates": [[[-117.12352, 32.93435], [-117.12347, 32.93447], [-117.12334, 32.93461], [-117.12333, 32.93474], [-117.12337, 32.93501], [-117.12345, 32.93517], [-117.12349, 32.93548], [-117.11887, 32.9355], [-117.11494, 32.93878], [-117.11486, 32.93848], [-117.11476, 32.93828], [-117.11462, 32.93805], [-117.11453, 32.93791], [-117.11434, 32.9377], [-117.1141, 32.93747], [-117.11366, 32.93719], [-117.11348, 32.93709], [-117.11316, 32.93697], [-117.11291, 32.93709], [-117.11281, 32.93691], [-117.11259, 32.93685], [-117.11222, 32.93673], [-117.11231, 32.93619], [-117.11374, 32.93496], [-117.11388, 32.93453], [-117.11343, 32.93402], [-117.11465, 32.93335], [-117.11548, 32.93082], [-117.11432, 32.92956], [-117.11453, 32.92912], [-117.11471, 32.92867], [-117.1148, 32.92831], [-117.11492, 32.92777], [-117.1152, 32.92622], [-117.11542, 32.92649], [-117.11552, 32.92664], [-117.1156, 32.92684], [-117.11564, 32.92704], [-117.11572, 32.92763], [-117.11603, 32.92796], [-117.11604, 32.92813], [-117.11618, 32.92838], [-117.11648, 32.92855], [-117.11712, 32.92873], [-117.11696, 32.92925], [-117.11698, 32.92969], [-117.11707, 32.92986], [-117.1174, 32.93], [-117.11768, 32.92983], [-117.11775, 32.92986], [-117.1178, 32.92987], [-117.11786, 32.92986], [-117.11792, 32.92982], [-117.11803, 32.92987], [-117.11835, 32.92979], [-117.11897, 32.92937], [-117.11896, 32.92977], [-117.11897, 32.92977], [-117.11913, 32.92962], [-117.11913, 32.92972], [-117.11932, 32.92984], [-117.11934, 32.92993], [-117.1193, 32.93012], [-117.1195, 32.93027], [-117.11965, 32.93031], [-117.11974, 32.93054], [-117.11999, 32.93092], [-117.12009, 32.93121], [-117.12021, 32.93144], [-117.12029, 32.93156], [-117.12047, 32.93199], [-117.12042, 32.93229], [-117.12046, 32.93245], [-117.12087, 32.93264], [-117.12093, 32.93277], [-117.12116, 32.93277], [-117.12142, 32.93308], [-117.12142, 32.93323], [-117.1216, 32.93309], [-117.1217, 32.93305], [-117.12193, 32.93304], [-117.12248, 32.93328], [-117.12272, 32.93331], [-117.12294, 32.93341], [-117.12315, 32.93373], [-117.12338, 32.93397], [-117.12346, 32.93411], [-117.12352, 32.93435]]]} | Open Access 1 | 165 | Canyon Hills Park and Open Space | 16818 | 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 | 142.094 | Canyon Hills Park and OS | 0 | Local Recreation Area 3 | 4 | |
57 | 57 | 56 | {"type": "Polygon", "coordinates": [[[-117.16831, 32.71264], [-117.16831, 32.71356], [-117.1674, 32.71356], [-117.1674, 32.71264], [-117.16831, 32.71264]]]} | Open Access 1 | 170 | Pantoja Neighborhood Park | 30100 | 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.149 | Pantoja Neighborhood Park | 0 | Local Park 2 | 4 | |
5842 | 5842 | 5841 | {"type": "Polygon", "coordinates": [[[-117.24469, 32.72509], [-117.24459, 32.72545], [-117.24424, 32.72539], [-117.24419, 32.72555], [-117.2441, 32.72554], [-117.2441, 32.72547], [-117.24371, 32.72542], [-117.24363, 32.72579], [-117.24395, 32.72584], [-117.24404, 32.72578], [-117.24448, 32.72587], [-117.24442, 32.7261], [-117.2444, 32.72613], [-117.24434, 32.72615], [-117.24351, 32.72598], [-117.24326, 32.72591], [-117.24201, 32.72544], [-117.24196, 32.72538], [-117.24244, 32.72381], [-117.24258, 32.7235], [-117.24408, 32.72379], [-117.24378, 32.7249], [-117.24379, 32.72493], [-117.24386, 32.725], [-117.24446, 32.72511], [-117.24448, 32.72506], [-117.24469, 32.72509]]]} | Open Access 1 | 177 | Point Loma Community Park | 23854 | 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.492 | Point Loma Community Park | 0 | Local Park 2 | 4 | |
5822 | 5822 | 5821 | {"type": "Polygon", "coordinates": [[[-117.16627, 32.73925], [-117.16594, 32.73926], [-117.16593, 32.7388], [-117.16627, 32.7388], [-117.16627, 32.73925]]]} | Open Access 1 | 178 | Banker's Hill Canyon Open Space | 15796 | 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.393 | Banker's Hill Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15899 | 15899 | 15898 | {"type": "Polygon", "coordinates": [[[-117.16654, 32.73769], [-117.16637, 32.73802], [-117.16607, 32.73803], [-117.16607, 32.73863], [-117.16568, 32.73863], [-117.16567, 32.73843], [-117.16534, 32.73844], [-117.16534, 32.7383], [-117.1654, 32.73829], [-117.16539, 32.73764], [-117.16566, 32.73764], [-117.16567, 32.73753], [-117.16593, 32.73753], [-117.16594, 32.73769], [-117.16625, 32.73769], [-117.16624, 32.73773], [-117.16625, 32.73774], [-117.16636, 32.73774], [-117.16638, 32.73769], [-117.16654, 32.73769]]]} | Open Access 1 | 179 | Banker's Hill Canyon Open Space | 15796 | 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 | 1.967 | Banker's Hill Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6492 | 6492 | 6491 | {"type": "Polygon", "coordinates": [[[-117.17175, 32.73853], [-117.17141, 32.73854], [-117.17141, 32.7384], [-117.17175, 32.7384], [-117.17175, 32.73853]]]} | Open Access 1 | 180 | Uptown Open Space | 26740 | 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.122 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
5837 | 5837 | 5836 | {"type": "Polygon", "coordinates": [[[-117.17083, 32.73648], [-117.1707, 32.73656], [-117.17061, 32.73656], [-117.17033, 32.73618], [-117.17009, 32.7358], [-117.17019, 32.73575], [-117.17083, 32.73648]]]} | Open Access 1 | 196 | Uptown Open Space | 26740 | 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.442 | Uptown OS | 0 | Local Recreation Area 3 | 4 | |
15897 | 15897 | 15896 | {"type": "Polygon", "coordinates": [[[-117.16771, 32.73201], [-117.1677, 32.73227], [-117.16745, 32.73228], [-117.16745, 32.73276], [-117.16712, 32.73277], [-117.16712, 32.73304], [-117.16656, 32.73304], [-117.16655, 32.73333], [-117.16564, 32.73334], [-117.16565, 32.73437], [-117.16484, 32.73438], [-117.16484, 32.73487], [-117.16442, 32.73487], [-117.16441, 32.73543], [-117.16407, 32.73543], [-117.16406, 32.73489], [-117.16448, 32.7346], [-117.16447, 32.73439], [-117.16409, 32.73439], [-117.16409, 32.73425], [-117.16441, 32.73425], [-117.16441, 32.73356], [-117.16498, 32.73356], [-117.16499, 32.73306], [-117.1653, 32.73306], [-117.16531, 32.73292], [-117.16563, 32.73264], [-117.16575, 32.73251], [-117.16681, 32.73249], [-117.1668, 32.73201], [-117.16771, 32.73201]]]} | Open Access 1 | 197 | Maple Canyon Open Space | 21772 | 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.84 | Maple Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15524 | 15524 | 15523 | {"type": "Polygon", "coordinates": [[[-117.22892, 32.73309], [-117.22881, 32.73321], [-117.22872, 32.73319], [-117.22845, 32.73238], [-117.22814, 32.73121], [-117.22805, 32.73081], [-117.22812, 32.73078], [-117.22825, 32.73086], [-117.22819, 32.73095], [-117.22843, 32.73188], [-117.2287, 32.73205], [-117.22876, 32.73233], [-117.2286, 32.73251], [-117.22875, 32.73299], [-117.22892, 32.73309]]]} | Open Access 1 | 202 | Wawona Drive Open Space | 27321 | 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.988 | Wawona Drive OS | 0 | Local Recreation Area 3 | 4 | |
5845 | 5845 | 5844 | {"type": "Polygon", "coordinates": [[[-117.23485, 32.72297], [-117.23478, 32.72303], [-117.23437, 32.72274], [-117.2344, 32.72271], [-117.23447, 32.72246], [-117.2345, 32.72246], [-117.23455, 32.72259], [-117.23464, 32.72274], [-117.23485, 32.72297]]]} | Open Access 1 | 217 | Cabrillo Mini-Park North | 30114 | 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.233 | Cabrillo Mini-Park North | 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 | |
4931 | 4931 | 4930 | {"type": "Polygon", "coordinates": [[[-117.08503, 32.83302], [-117.08471, 32.83324], [-117.08463, 32.83339], [-117.08428, 32.83359], [-117.08401, 32.83357], [-117.08388, 32.83401], [-117.0839, 32.83406], [-117.08394, 32.83409], [-117.08399, 32.83411], [-117.08417, 32.83409], [-117.08432, 32.83411], [-117.0843, 32.8344], [-117.08426, 32.83464], [-117.08388, 32.83547], [-117.08379, 32.83556], [-117.08345, 32.83545], [-117.08316, 32.83583], [-117.08287, 32.83572], [-117.08284, 32.83597], [-117.08287, 32.83617], [-117.08286, 32.83621], [-117.08264, 32.83621], [-117.08263, 32.83573], [-117.08257, 32.83556], [-117.08247, 32.83562], [-117.08216, 32.83568], [-117.08217, 32.83588], [-117.08212, 32.83605], [-117.08206, 32.83602], [-117.08182, 32.83613], [-117.08175, 32.8361], [-117.08171, 32.83615], [-117.08165, 32.83637], [-117.08165, 32.83608], [-117.08168, 32.83596], [-117.08233, 32.83503], [-117.0825, 32.83506], [-117.08317, 32.8351], [-117.08346, 32.83491], [-117.0835, 32.83463], [-117.08319, 32.83412], [-117.08355, 32.83365], [-117.08422, 32.83326], [-117.0843, 32.83296], [-117.08488, 32.83288], [-117.08503, 32.83302]]]} | Open Access 1 | 227 | Tierrasanta Open Space | 10608 | 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 | 7.345 | Tierrasanta OS | 0 | Local Recreation Area 3 | 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 | |
15913 | 15913 | 15912 | {"type": "Polygon", "coordinates": [[[-117.10697, 32.83073], [-117.1069, 32.83078], [-117.10255, 32.83271], [-117.10239, 32.83269], [-117.1023, 32.83297], [-117.10214, 32.83295], [-117.10153, 32.83339], [-117.10267, 32.83157], [-117.10286, 32.83124], [-117.1029, 32.83125], [-117.1053, 32.83018], [-117.10534, 32.83014], [-117.10697, 32.83073]]]} | Open Access 1 | 229 | Tierrasanta Open Space | 10608 | 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 | 13.243 | Tierrasanta OS | 0 | Local Recreation Area 3 | 4 | |
4933 | 4933 | 4932 | {"type": "Polygon", "coordinates": [[[-117.10238, 32.83132], [-117.10221, 32.83161], [-117.10222, 32.83162], [-117.10227, 32.8316], [-117.10111, 32.83344], [-117.10107, 32.83348], [-117.101, 32.83347], [-117.09989, 32.83298], [-117.09944, 32.83286], [-117.0991, 32.83283], [-117.09887, 32.83283], [-117.09837, 32.83288], [-117.0979, 32.83303], [-117.09739, 32.8333], [-117.09675, 32.83386], [-117.09636, 32.83364], [-117.09626, 32.83369], [-117.09621, 32.83364], [-117.09615, 32.83364], [-117.09605, 32.83366], [-117.09564, 32.83365], [-117.09562, 32.83369], [-117.09497, 32.83357], [-117.09463, 32.83356], [-117.09459, 32.83383], [-117.09427, 32.83378], [-117.09249, 32.83324], [-117.09202, 32.83307], [-117.08973, 32.83248], [-117.0895, 32.83245], [-117.08935, 32.83247], [-117.08922, 32.8325], [-117.08884, 32.83264], [-117.08858, 32.83278], [-117.08842, 32.83294], [-117.08785, 32.83296], [-117.08735, 32.83307], [-117.08709, 32.83321], [-117.08658, 32.83361], [-117.08664, 32.83397], [-117.08621, 32.83405], [-117.0861, 32.83385], [-117.08599, 32.8337], [-117.08577, 32.83344], [-117.08643, 32.83318], [-117.08628, 32.83233], [-117.086, 32.83236], [-117.08503, 32.83181], [-117.08454, 32.83215], [-117.0832, 32.83072], [-117.08314, 32.83061], [-117.08306, 32.83043], [-117.08302, 32.83027], [-117.083, 32.83001], [-117.08302, 32.82985], [-117.0831, 32.8296], [-117.08466, 32.83086], [-117.08671, 32.83144], [-117.08668, 32.83188], [-117.09065, 32.8325], [-117.09086, 32.83208], [-117.09414, 32.83258], [-117.09574, 32.83226], [-117.09575, 32.83224], [-117.09562, 32.83205], [-117.09601, 32.83197], [-117.09615, 32.83172], [-117.09619, 32.83173], [-117.09606, 32.83196], [-117.09631, 32.83198], [-117.0968, 32.83176], [-117.09716, 32.83155], [-117.09742, 32.83159], [-117.098, 32.83147], [-117.0983, 32.8315], [-117.09861, 32.8314], [-117.09885, 32.83147], [-117.09895, 32.83124], [-117.09897, 32.83125], [-117.09888, 32.83149], [-117.09907, 32.83165], [-117.09912, 32.83176], [-117.10006, 32.83192], [-117.10037, 32.83187], [-117.10102, 32.83181], [-117.10111, 32.83161], [-117.10128, 32.83153], [-117.10156, 32.83152], [-117.10238, 32.83132]]]} | Open Access 1 | 234 | Tierrasanta Open Space | 10608 | 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 | 55.577 | Tierrasanta OS | 0 | Local Recreation Area 3 | 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 | |
4934 | 4934 | 4933 | {"type": "Polygon", "coordinates": [[[-117.08994, 32.84113], [-117.08988, 32.84128], [-117.08972, 32.84134], [-117.08976, 32.84106], [-117.08994, 32.84113]]]} | Open Access 1 | 241 | Tierrasanta Open Space | 10608 | 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.095 | Tierrasanta OS | 0 | Local Recreation Area 3 | 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]);