units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
533 rows where MNG_AGENCY = 4
This data as json, copyable, CSV (advanced)
DES_TP 21
- Local Park 266
- Local Recreation Area 206
- Local Other or Unknown 15
- 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
AGNCY_TYP 6 ✖
- City Agency 505
- School District 3
- State Agency 2
- Federal Agency 1
- County Agency 1
- Commercial 1
ACCESS_TYP 4
- Open Access 483
- No Public Access 19
- Restricted Access 10
- Unknown Access 1
MNG_AG_TYP 1
- City Agency 513
MNG_AGENCY 1
- San Diego, City of · 513 ✖
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
306 | 306 | 305 | {"type": "Polygon", "coordinates": [[[-117.09493, 32.57468], [-117.09492, 32.57638], [-117.093, 32.57635], [-117.09294, 32.57631], [-117.09293, 32.57625], [-117.09288, 32.57625], [-117.09287, 32.57478], [-117.09288, 32.57477], [-117.09289, 32.57468], [-117.09493, 32.57468]]]} | Open Access 1 | 1043 | Robert Egger Sr., South Bay Community Park | 30049 | 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.871 | Robert Egger Sr., South Bay Community Park | 0 | Local Park 2 | 4 | |
335 | 335 | 334 | {"type": "Polygon", "coordinates": [[[-117.26243, 32.81163], [-117.26192, 32.81174], [-117.26174, 32.81106], [-117.26223, 32.81095], [-117.26243, 32.81163]]]} | Open Access 1 | 914 | Bird Rock Neighborhood Park | 30091 | 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.929 | Bird Rock Neighborhood Park | 0 | Local Park 2 | 4 | |
342 | 342 | 341 | {"type": "Polygon", "coordinates": [[[-117.07324, 32.98201], [-117.073, 32.98257], [-117.07296, 32.98296], [-117.07307, 32.98326], [-117.07181, 32.98294], [-117.07129, 32.98252], [-117.07232, 32.98157], [-117.07242, 32.98166], [-117.07244, 32.98178], [-117.07248, 32.98182], [-117.07253, 32.98184], [-117.07257, 32.98183], [-117.07268, 32.98173], [-117.07299, 32.9819], [-117.07324, 32.98201]]]} | Open Access 1 | 935 | Highland Ranch Neighborhood Park | 30148 | 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 | 4.765 | Highland Ranch 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]);