units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7,486 rows where DES_TP = 2 and MNG_AG_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
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 | |
5209 | 5209 | 5208 | {"type": "Polygon", "coordinates": [[[-120.64834, 35.27987], [-120.64777, 35.28012], [-120.64769, 35.28005], [-120.64693, 35.28028], [-120.64762, 35.28098], [-120.64659, 35.28143], [-120.64705, 35.28222], [-120.64729, 35.28232], [-120.64701, 35.28266], [-120.6462, 35.28292], [-120.64597, 35.28404], [-120.64486, 35.28361], [-120.64485, 35.2833], [-120.64358, 35.28331], [-120.64076, 35.28337], [-120.64085, 35.28694], [-120.63102, 35.28738], [-120.63113, 35.27994], [-120.64057, 35.2798], [-120.64326, 35.27863], [-120.64343, 35.27889], [-120.64348, 35.27962], [-120.64386, 35.27961], [-120.64429, 35.27923], [-120.64468, 35.27912], [-120.64499, 35.2792], [-120.64532, 35.27924], [-120.64567, 35.27918], [-120.64605, 35.2792], [-120.64675, 35.2796], [-120.6469, 35.27965], [-120.64704, 35.27963], [-120.64793, 35.27936], [-120.64834, 35.27987]]]} | Open Access 1 | 13 | Bowden Ranch | 16306 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 242.507 | Bowden Ranch | 0 | Local Park 2 | 4 | |
2 | 2 | 1 | {"type": "Polygon", "coordinates": [[[-120.84977, 37.77283], [-120.84915, 37.77309], [-120.84786, 37.77119], [-120.84847, 37.77095], [-120.84977, 37.77283]]]} | Open Access 1 | 14 | Oaklawn Memorial Park | 23029 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.595 | Oaklawn Memorial Park | 0 | Local Park 2 | 4 | |
5782 | 5782 | 5781 | {"type": "Polygon", "coordinates": [[[-120.86258, 37.77084], [-120.86258, 37.77112], [-120.86252, 37.77128], [-120.86241, 37.77142], [-120.8623, 37.77151], [-120.86214, 37.77161], [-120.86161, 37.77183], [-120.86144, 37.7719], [-120.86135, 37.77189], [-120.8612, 37.77166], [-120.86119, 37.77159], [-120.86116, 37.77152], [-120.8611, 37.77148], [-120.86111, 37.77127], [-120.86147, 37.77127], [-120.86147, 37.77099], [-120.86182, 37.77099], [-120.862, 37.77096], [-120.86236, 37.77086], [-120.86258, 37.77084]]]} | Open Access 1 | 18 | River Avenue Park | 24405 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 2.277 | River Avenue Park | 0 | Local Park 2 | 4 | |
5046 | 5046 | 5045 | {"type": "Polygon", "coordinates": [[[-122.11395, 37.80976], [-122.11316, 37.80991], [-122.11228, 37.81015], [-122.11216, 37.81005], [-122.11213, 37.80988], [-122.11204, 37.80964], [-122.11189, 37.80953], [-122.11172, 37.80934], [-122.11196, 37.80911], [-122.11201, 37.80887], [-122.11197, 37.80869], [-122.11196, 37.80869], [-122.11168, 37.80888], [-122.11148, 37.80895], [-122.11136, 37.80891], [-122.11137, 37.8084], [-122.11371, 37.80839], [-122.11394, 37.80953], [-122.11395, 37.80976]]]} | Open Access 1 | 22 | Rancho Laguna Park | 24149 | 1215 | Moraga, Town of 731 | City 2 | City Agency 2 | http://www.ci.moraga.ca.us/dept/park-rec/home | City 2 | 1215 | Moraga, Town of 715 | City 2 | City Agency 2 | Contra Costa 12 | 7.833 | Rancho Laguna Park | 0 | Local Park 2 | 4 | |
5050 | 5050 | 5049 | {"type": "Polygon", "coordinates": [[[-120.42771, 34.96444], [-120.42771, 34.96515], [-120.42677, 34.96515], [-120.42676, 34.96512], [-120.42581, 34.96512], [-120.42581, 34.9647], [-120.42612, 34.9647], [-120.42612, 34.96443], [-120.42677, 34.96443], [-120.42678, 34.96471], [-120.42743, 34.96472], [-120.42768, 34.96471], [-120.42768, 34.96444], [-120.42771, 34.96444]]]} | Open Access 1 | 23 | Rice Park | 24318 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 2.488 | Rice Park | 0 | Local Park 2 | 4 | |
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.46 | Eisenhower 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 | |
8 | 8 | 7 | {"type": "Polygon", "coordinates": [[[-117.70487, 34.09777], [-117.70457, 34.09776], [-117.7046, 34.09775], [-117.70462, 34.09772], [-117.70461, 34.09748], [-117.70381, 34.09747], [-117.7042, 34.09652], [-117.7048, 34.09652], [-117.70482, 34.09772], [-117.70483, 34.09775], [-117.70487, 34.09777]]]} | Open Access 1 | 30 | El Barrio Park | 18477 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 2.099 | El Barrio Park | 0 | Local Park 2 | 4 | |
5779 | 5779 | 5778 | {"type": "Polygon", "coordinates": [[[-120.84035, 37.78027], [-120.8385, 37.7806], [-120.83724, 37.78111], [-120.83628, 37.78184], [-120.836, 37.78154], [-120.83539, 37.7806], [-120.83517, 37.78029], [-120.83748, 37.77946], [-120.8393, 37.77888], [-120.84, 37.77864], [-120.84, 37.77933], [-120.84035, 37.77935], [-120.84035, 37.78027]]]} | Open Access 1 | 34 | Valley View Park | 26806 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 17.928 | Valley View Park | 0 | Local Park 2 | 4 | |
5788 | 5788 | 5787 | {"type": "Polygon", "coordinates": [[[-120.82355, 37.78764], [-120.82233, 37.78798], [-120.8217, 37.78871], [-120.82072, 37.78937], [-120.82016, 37.78948], [-120.81983, 37.78951], [-120.81884, 37.79034], [-120.8183, 37.79059], [-120.81778, 37.7866], [-120.81797, 37.78648], [-120.81786, 37.7856], [-120.81856, 37.7856], [-120.81916, 37.78542], [-120.81965, 37.78535], [-120.82005, 37.78539], [-120.8203, 37.78558], [-120.82222, 37.78558], [-120.82354, 37.78555], [-120.82355, 37.78764]]]} | Open Access 1 | 37 | W T Kerr Community Park | 27201 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 48.179 | W T Kerr Community 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 | |
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | 42 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.055 | Rincon Park | 0 | Local Park 2 | 4 | |
15 | 15 | 14 | {"type": "Polygon", "coordinates": [[[-120.87737, 37.76176], [-120.87616, 37.76176], [-120.87611, 37.76172], [-120.8761, 37.76055], [-120.87615, 37.76051], [-120.87682, 37.76051], [-120.87688, 37.76054], [-120.87736, 37.76051], [-120.87737, 37.76176]]]} | Open Access 1 | 43 | William A. Fish Veterans Memorial Park | 27537 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.803 | William A. Fish Veterans Memorial Park | 0 | Local Park 2 | 4 | |
5792 | 5792 | 5791 | {"type": "Polygon", "coordinates": [[[-117.94385, 33.93367], [-117.94187, 33.93367], [-117.94187, 33.9329], [-117.94297, 33.93289], [-117.94343, 33.93281], [-117.94383, 33.93282], [-117.94385, 33.93284], [-117.94385, 33.93367]]]} | Open Access 1 | 44 | El Centro Park | 18489 | 1155 | La Habra, City of 203 | City 2 | City Agency 2 | http://www.ci.la-habra.ca.us/section.cfm?id=79 | City 2 | 1155 | La Habra, City of 199 | City 2 | City Agency 2 | Orange 3 | 4.032 | El Centro Park | 0 | Local Park 2 | 4 | |
13 | 13 | 12 | {"type": "Polygon", "coordinates": [[[-120.84861, 37.76492], [-120.8483, 37.76505], [-120.84814, 37.76482], [-120.84845, 37.76468], [-120.84861, 37.76492]]]} | Open Access 1 | 49 | William Meyer Park | 27553 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 0.233 | William Meyer Park | 0 | Local Park 2 | 4 | |
5794 | 5794 | 5793 | {"type": "Polygon", "coordinates": [[[-117.69121, 33.59025], [-117.6909, 33.59048], [-117.69087, 33.59047], [-117.6908, 33.59046], [-117.6907, 33.59049], [-117.69068, 33.59055], [-117.69041, 33.59076], [-117.69052, 33.59083], [-117.69026, 33.59105], [-117.68995, 33.59081], [-117.68985, 33.59067], [-117.6898, 33.59062], [-117.68968, 33.5906], [-117.68957, 33.59064], [-117.68951, 33.59069], [-117.68879, 33.58992], [-117.69092, 33.58993], [-117.69121, 33.59025]]]} | Open Access 1 | 50 | El Conejo Park | 18493 | 1165 | Laguna Hills, City of 230 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | Orange 3 | 3.773 | El Conejo 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 | |
5797 | 5797 | 5796 | {"type": "Polygon", "coordinates": [[[-121.1509, 37.46277], [-121.1508, 37.46292], [-121.14988, 37.46396], [-121.14979, 37.46412], [-121.14974, 37.46424], [-121.14971, 37.46426], [-121.14957, 37.46426], [-121.14958, 37.46277], [-121.1509, 37.46277]]]} | Open Access 1 | 55 | Amaryllis Park | 15440 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.566 | Amaryllis 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]);