units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
281 rows where DES_TP = 2 and MNG_AGENCY = 4 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 281
MNG_AGENCY 1
- San Diego, City of · 281 ✖
DES_TP 1
- Local Park · 281 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5775 | 5775 | 5774 | {"type": "Polygon", "coordinates": [[[-117.05795, 32.7466], [-117.05795, 32.74669], [-117.05759, 32.74659], [-117.05761, 32.74652], [-117.05777, 32.74658], [-117.05795, 32.7466]]]} | Open Access 1 | 5 | Zena Mini-Park | 27862 | 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.067 | Zena Mini-Park | 0 | Local Park 2 | 4 | |
5776 | 5776 | 5775 | {"type": "Polygon", "coordinates": [[[-117.12088, 32.74978], [-117.12063, 32.74969], [-117.12063, 32.74952], [-117.12075, 32.74941], [-117.12088, 32.74978]]]} | Open Access 1 | 6 | Wabash Neighborhood Park | 30119 | 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.131 | Wabash Neighborhood Park | 0 | Local Park 2 | 4 | |
6 | 6 | 5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | Open Access 1 | 26 | Azalea Neighborhood Park | 30115 | 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 | 9.138 | Azalea Neighborhood Park | 0 | Local Park 2 | 4 | |
5790 | 5790 | 5789 | {"type": "MultiPolygon", "coordinates": [[[[-117.05865, 32.73857], [-117.05803, 32.73858], [-117.05803, 32.73858], [-117.05803, 32.73856], [-117.05825, 32.73832], [-117.05837, 32.73835], [-117.05865, 32.73857]]], [[[-117.07608, 32.7349], [-117.07553, 32.73603], [-117.07537, 32.7361], [-117.07502, 32.7362], [-117.07475, 32.73625], [-117.07425, 32.73628], [-117.07389, 32.73626], [-117.07368, 32.73623], [-117.07342, 32.73618], [-117.07295, 32.73604], [-117.07392, 32.73416], [-117.07397, 32.73212], [-117.07206, 32.7321], [-117.07202, 32.73303], [-117.06932, 32.733], [-117.06852, 32.73484], [-117.06333, 32.73515], [-117.06296, 32.73519], [-117.06243, 32.73529], [-117.06193, 32.73541], [-117.06145, 32.73556], [-117.06106, 32.73572], [-117.06065, 32.73591], [-117.0602, 32.73616], [-117.05974, 32.73646], [-117.05946, 32.73668], [-117.05898, 32.73711], [-117.05826, 32.73785], [-117.05827, 32.73787], [-117.05822, 32.7379], [-117.05815, 32.73791], [-117.05808, 32.7379], [-117.05804, 32.73788], [-117.05806, 32.73498], [-117.05829, 32.73483], [-117.05962, 32.7333], [-117.06222, 32.73142], [-117.06439, 32.73013], [-117.06626, 32.72932], [-117.06794, 32.72884], [-117.06794, 32.72935], [-117.07536, 32.72946], [-117.07535, 32.73054], [-117.07436, 32.73039], [-117.07431, 32.7322], [-117.07528, 32.73223], [-117.07525, 32.73371], [-117.0751, 32.7337], [-117.0749, 32.73396], [-117.07524, 32.73479], [-117.07525, 32.73489], [-117.07608, 32.7349]]], [[[-117.07739, 32.73587], [-117.07737, 32.73674], [-117.07678, 32.73675], [-117.07676, 32.73801], [-117.07523, 32.73805], [-117.07525, 32.7402], [-117.07485, 32.7404], [-117.07138, 32.74035], [-117.07141, 32.73924], [-117.07138, 32.73918], [-117.07133, 32.73912], [-117.07133, 32.73895], [-117.06827, 32.7393], [-117.06726, 32.73928], [-117.06724, 32.74028], [-117.06672, 32.74028], [-117.06671, 32.73846], [-117.05891, 32.73857], [-117.05887, 32.73852], [-117.05867, 32.73833], [-117.05842, 32.73814], [-117.05854, 32.73799], [-117.05857, 32.738], [-117.05908, 32.73745], [-117.05943, 32.7371], [-117.05966, 32.7369], [-117.05991, 32.73671], [-117.06041, 32.73638], [-117.0608, 32.73616], [-117.06136, 32.73591], [-117.06196, 32.7357], [-117.0625, 32.73556], [-117.06343, 32.73542], [-117.06534, 32.73529], [-117.06849, 32.73512], [-117.06912, 32.73512], [-117.06941, 32.73515], [-117.06966, 32.73521], [-117.07013, 32.73534], [-117.07282, 32.73631], [-117.07351, 32.73649], [-117.07402, 32.73655], [-117.07434, 32.73656], [-117.07465, 32.73654], [-117.07493, 32.7365], [-117.07521, 32.73644], [-117.07551, 32.73635], [-117.0763, 32.73602], [-117.07656, 32.73594], [-117.07693, 32.73587], [-117.07739, 32.73587]]]]} | Open Access 1 | 39 | Chollas Lake Community Park | 30046 | 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 | 341.762 | Chollas Lake Community Park | 0 | Local Park 2 | 4 | |
5795 | 5795 | 5794 | {"type": "Polygon", "coordinates": [[[-117.13499, 32.75399], [-117.13391, 32.75399], [-117.13392, 32.75231], [-117.13395, 32.75221], [-117.13397, 32.7522], [-117.13398, 32.75045], [-117.13451, 32.75045], [-117.13451, 32.75112], [-117.13498, 32.75112], [-117.13499, 32.75399]]]} | Open Access 1 | 51 | North Park Community Park | 22844 | 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.653 | North Park Community Park | 0 | Local Park 2 | 4 | |
26 | 26 | 25 | {"type": "Polygon", "coordinates": [[[-117.08357, 32.75155], [-117.08352, 32.75156], [-117.08352, 32.75251], [-117.08356, 32.75252], [-117.08356, 32.75298], [-117.08332, 32.75306], [-117.08317, 32.75308], [-117.08165, 32.75308], [-117.08164, 32.75303], [-117.08042, 32.75302], [-117.0804, 32.75307], [-117.07989, 32.75305], [-117.07986, 32.753], [-117.07987, 32.75272], [-117.0797, 32.7518], [-117.07969, 32.75051], [-117.07966, 32.7505], [-117.07967, 32.74994], [-117.08202, 32.74993], [-117.08203, 32.75], [-117.08346, 32.75002], [-117.08348, 32.75006], [-117.08343, 32.75131], [-117.08356, 32.75132], [-117.08357, 32.75155]]]} | Open Access 1 | 89 | Colina Del Sol Community Park | 17497 | 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 | 29.899 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
41 | 41 | 40 | {"type": "Polygon", "coordinates": [[[-117.19344, 32.75165], [-117.19315, 32.75181], [-117.19311, 32.75179], [-117.19296, 32.75158], [-117.1933, 32.75139], [-117.19344, 32.75165]]]} | Open Access 1 | 95 | El Campo Santo Neighborhood Park | 30058 | 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.276 | El Campo Santo Neighborhood Park | 0 | Local Park 2 | 4 | |
5817 | 5817 | 5816 | {"type": "Polygon", "coordinates": [[[-117.07929, 32.75187], [-117.07928, 32.75306], [-117.07847, 32.75306], [-117.07843, 32.75304], [-117.0784, 32.75299], [-117.07841, 32.75278], [-117.07845, 32.75266], [-117.0786, 32.75249], [-117.07929, 32.75187]]]} | Open Access 1 | 100 | Colina Del Sol Community Park | 17497 | 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.783 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
49 | 49 | 48 | {"type": "Polygon", "coordinates": [[[-117.04877, 32.81115], [-117.04766, 32.81153], [-117.04656, 32.81065], [-117.04633, 32.81056], [-117.04656, 32.80996], [-117.04591, 32.8096], [-117.04518, 32.80917], [-117.0453, 32.80896], [-117.04544, 32.80897], [-117.04612, 32.8091], [-117.04679, 32.80933], [-117.04712, 32.80941], [-117.04749, 32.80943], [-117.04824, 32.80934], [-117.04829, 32.8096], [-117.0481, 32.80978], [-117.04786, 32.81015], [-117.04788, 32.81022], [-117.04852, 32.81057], [-117.04845, 32.81084], [-117.04877, 32.81115]]]} | Open Access 1 | 107 | Tuxedo Neighborhood Park | 30163 | 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.11 | Tuxedo Neighborhood Park | 0 | Local Park 2 | 4 | |
36 | 36 | 35 | {"type": "Polygon", "coordinates": [[[-117.05461, 32.80729], [-117.05411, 32.80771], [-117.05225, 32.80659], [-117.05423, 32.80617], [-117.05443, 32.80698], [-117.05448, 32.8071], [-117.05461, 32.80729]]]} | Open Access 1 | 118 | Dailard Neighborhood Park | 17891 | 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.634 | Dailard Neighborhood Park | 0 | Local Park 2 | 4 | |
58 | 58 | 57 | {"type": "Polygon", "coordinates": [[[-117.02209, 32.79762], [-117.02195, 32.79979], [-117.02062, 32.79972], [-117.02075, 32.79755], [-117.02202, 32.79758], [-117.02207, 32.7976], [-117.02209, 32.79762]]]} | Open Access 1 | 129 | San Carlos Community Park | 24847 | 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.486 | San Carlos Community Park | 0 | Local Park 2 | 4 | |
5820 | 5820 | 5819 | {"type": "Polygon", "coordinates": [[[-117.09642, 32.93477], [-117.09468, 32.93491], [-117.09432, 32.93597], [-117.09068, 32.9351], [-117.09092, 32.93437], [-117.09231, 32.9336], [-117.09269, 32.93357], [-117.09269, 32.93371], [-117.09284, 32.93402], [-117.09283, 32.93411], [-117.09305, 32.93419], [-117.09552, 32.9345], [-117.09578, 32.93446], [-117.09587, 32.93434], [-117.09578, 32.93292], [-117.09556, 32.93283], [-117.09544, 32.93282], [-117.09539, 32.93277], [-117.09539, 32.93265], [-117.09622, 32.93246], [-117.09637, 32.93247], [-117.09631, 32.93373], [-117.09642, 32.93477]]]} | Open Access 1 | 139 | Spring Canyon Neighborhood Park | 25736 | 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 | 19.013 | Spring Canyon Neighborhood Park | 0 | Local Park 2 | 4 | |
61 | 61 | 60 | {"type": "Polygon", "coordinates": [[[-117.12117, 32.92243], [-117.12114, 32.92415], [-117.11938, 32.9242], [-117.11931, 32.92417], [-117.11913, 32.9225], [-117.11913, 32.92238], [-117.12117, 32.92243]]]} | Open Access 1 | 146 | Westview Park | 27432 | 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.82 | Westview Park | 0 | Local Park 2 | 4 | |
68 | 68 | 67 | {"type": "MultiPolygon", "coordinates": [[[[-117.08318, 32.79598], [-117.08318, 32.79625], [-117.07976, 32.79623], [-117.07979, 32.79489], [-117.08005, 32.79464], [-117.08026, 32.79453], [-117.08041, 32.79449], [-117.08053, 32.79447], [-117.08069, 32.79447], [-117.08088, 32.79451], [-117.08105, 32.79458], [-117.08115, 32.79463], [-117.08253, 32.7958], [-117.0828, 32.79593], [-117.083, 32.79597], [-117.08318, 32.79598]]], [[[-117.08168, 32.79321], [-117.08167, 32.7939], [-117.08165, 32.79398], [-117.08157, 32.79411], [-117.08123, 32.79443], [-117.08117, 32.79444], [-117.08096, 32.79435], [-117.08077, 32.79431], [-117.08057, 32.7943], [-117.08036, 32.79433], [-117.07996, 32.79402], [-117.08082, 32.79319], [-117.08168, 32.79321]]]]} | Open Access 1 | 155 | Allied Gardens Community Park | 15383 | 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.814 | Allied Gardens Community Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 |
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]);