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 rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 261
MNG_AGENCY 1
- San Diego, City of · 261 ✖
DES_TP 1
- Local Park · 261 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15434 | 15434 | 15433 | {"type": "Polygon", "coordinates": [[[-117.17505, 32.8389], [-117.17504, 32.84015], [-117.175, 32.84018], [-117.17452, 32.84018], [-117.17365, 32.8389], [-117.17505, 32.8389]]]} | Open Access 1 | 46705 | MacDowell Neighborhood Park | 30086 | 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.156 | MacDowell Neighborhood Park | 0 | Local Park 2 | 4 | |
15433 | 15433 | 15432 | {"type": "Polygon", "coordinates": [[[-117.19159, 32.85461], [-117.19134, 32.85498], [-117.18956, 32.85511], [-117.18834, 32.85409], [-117.1884, 32.85401], [-117.18856, 32.85384], [-117.18874, 32.8537], [-117.18893, 32.85355], [-117.18931, 32.85334], [-117.18957, 32.85322], [-117.19095, 32.8528], [-117.191, 32.8528], [-117.19105, 32.85285], [-117.19128, 32.85333], [-117.19141, 32.85352], [-117.19164, 32.85396], [-117.19168, 32.8541], [-117.19169, 32.85425], [-117.19163, 32.85452], [-117.19159, 32.85461]]]} | Open Access 1 | 46704 | University Gardens Neighborhood Park | 30080 | 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.305 | University Gardens Neighborhood Park | 0 | Local Park 2 | 4 | |
15432 | 15432 | 15431 | {"type": "Polygon", "coordinates": [[[-117.0389, 32.6977], [-117.0379, 32.69841], [-117.03705, 32.69854], [-117.03692, 32.69826], [-117.03679, 32.69821], [-117.03699, 32.69773], [-117.03712, 32.69754], [-117.0373, 32.69741], [-117.0374, 32.69735], [-117.0376, 32.69729], [-117.03773, 32.69728], [-117.03856, 32.69727], [-117.03857, 32.69754], [-117.0389, 32.6977]]]} | Open Access 1 | 46699 | Boone Neighborhood Park | 30066 | 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.404 | Boone Neighborhood Park | 0 | Local Park 2 | 4 | |
15431 | 15431 | 15430 | {"type": "Polygon", "coordinates": [[[-117.1025, 32.70094], [-117.10248, 32.70095], [-117.10248, 32.70114], [-117.10232, 32.70107], [-117.10231, 32.70059], [-117.10249, 32.70059], [-117.1025, 32.70094]]]} | Open Access 1 | 46698 | Ocean View Mini-Park | 30061 | 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.231 | Ocean View Mini-Park | 0 | Local Park 2 | 4 | |
15430 | 15430 | 15429 | {"type": "Polygon", "coordinates": [[[-117.23656, 32.74764], [-117.23563, 32.74871], [-117.23558, 32.74873], [-117.23554, 32.74871], [-117.23516, 32.74848], [-117.23419, 32.74636], [-117.23426, 32.74611], [-117.23552, 32.7469], [-117.23506, 32.74746], [-117.23506, 32.74747], [-117.23571, 32.74789], [-117.23614, 32.74737], [-117.23656, 32.74764]]]} | Open Access 1 | 46697 | Collier Neighborhood Park | 30057 | 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.391 | Collier Neighborhood Park | 0 | Local Park 2 | 4 | |
15429 | 15429 | 15428 | {"type": "Polygon", "coordinates": [[[-117.08183, 32.92904], [-117.08101, 32.92998], [-117.07835, 32.9286], [-117.07852, 32.92835], [-117.0786, 32.92815], [-117.07865, 32.9279], [-117.07866, 32.92775], [-117.07864, 32.92757], [-117.0786, 32.9274], [-117.07854, 32.92725], [-117.07841, 32.92703], [-117.07822, 32.9268], [-117.07837, 32.92651], [-117.07853, 32.92604], [-117.07856, 32.92561], [-117.0785, 32.92537], [-117.07847, 32.92513], [-117.07901, 32.92516], [-117.07959, 32.92496], [-117.07972, 32.92508], [-117.07953, 32.9257], [-117.0796, 32.92668], [-117.0797, 32.92691], [-117.08006, 32.92685], [-117.08039, 32.92696], [-117.08071, 32.92682], [-117.08105, 32.92697], [-117.08112, 32.9271], [-117.08097, 32.92726], [-117.081, 32.92757], [-117.08095, 32.92792], [-117.08099, 32.92811], [-117.08114, 32.92837], [-117.08099, 32.92848], [-117.08143, 32.92883], [-117.08183, 32.92904]]]} | Open Access 1 | 46695 | Scripps Ranch Community Park | 30042 | 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 | 22.265 | Scripps Ranch Community Park | 0 | Local Park 2 | 4 | |
15162 | 15162 | 15161 | {"type": "Polygon", "coordinates": [[[-117.19355, 32.82142], [-117.19339, 32.82154], [-117.19319, 32.82163], [-117.19271, 32.82173], [-117.19251, 32.82239], [-117.19251, 32.82245], [-117.19261, 32.82272], [-117.19262, 32.82292], [-117.19254, 32.82328], [-117.19245, 32.82345], [-117.19102, 32.82277], [-117.1921, 32.82115], [-117.19197, 32.82065], [-117.19355, 32.82142]]]} | Open Access 1 | 46011 | Mount Etna Neighborhood Park | 30092 | 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 | http://www.sandiego.gov/park-and-recreation/pdf/clairemontareamap.pdf | San Diego 4 | 7.311 | Mount Etna Neighborhood Park | 0 | Local Park 2 | 4 |
14802 | 14802 | 14801 | {"type": "Polygon", "coordinates": [[[-117.05292, 32.66817], [-117.05289, 32.66821], [-117.05283, 32.66819], [-117.05277, 32.66819], [-117.05268, 32.66824], [-117.05261, 32.66819], [-117.05234, 32.66826], [-117.05209, 32.66796], [-117.05065, 32.66847], [-117.05064, 32.66831], [-117.05059, 32.66813], [-117.05059, 32.66796], [-117.05063, 32.66779], [-117.05071, 32.66764], [-117.05083, 32.66751], [-117.05097, 32.66741], [-117.05185, 32.66694], [-117.052, 32.66714], [-117.0524, 32.66692], [-117.05241, 32.66694], [-117.05244, 32.66692], [-117.05251, 32.66702], [-117.0526, 32.66725], [-117.05269, 32.66762], [-117.05271, 32.66792], [-117.05275, 32.66803], [-117.05287, 32.66801], [-117.05292, 32.66817]]]} | Open Access 1 | 45216 | Parkside Neighborhood Park | 30068 | 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.497 | Parkside Neighborhood Park | 0 | Local Park 2 | 4 | |
14801 | 14801 | 14800 | {"type": "Polygon", "coordinates": [[[-117.13247, 32.98764], [-117.13212, 32.98793], [-117.13207, 32.98801], [-117.13197, 32.98838], [-117.13148, 32.98882], [-117.13083, 32.98944], [-117.13067, 32.98945], [-117.13054, 32.98952], [-117.13018, 32.99011], [-117.1297, 32.99136], [-117.1296, 32.99146], [-117.12933, 32.9916], [-117.12898, 32.99167], [-117.12836, 32.99169], [-117.12817, 32.99158], [-117.12768, 32.99115], [-117.12664, 32.98999], [-117.12909, 32.98723], [-117.1294, 32.98691], [-117.12977, 32.98658], [-117.13009, 32.98634], [-117.13043, 32.98612], [-117.1311, 32.98573], [-117.13219, 32.98728], [-117.13247, 32.98764]]]} | Open Access 1 | 45212 | Black Mtn Ranch Community Park | 16136 | 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 | 42.914 | Black Mtn Ranch Community Park | 0 | Local Park 2 | 4 | |
14800 | 14800 | 14799 | {"type": "Polygon", "coordinates": [[[-117.13567, 32.94024], [-117.13567, 32.94306], [-117.13387, 32.944], [-117.13387, 32.94545], [-117.13318, 32.9446], [-117.13359, 32.94384], [-117.13294, 32.94339], [-117.13216, 32.9431], [-117.13152, 32.94316], [-117.13122, 32.94329], [-117.13048, 32.94316], [-117.13011, 32.94321], [-117.12927, 32.94056], [-117.12954, 32.94055], [-117.12984, 32.9406], [-117.13002, 32.94067], [-117.13027, 32.94081], [-117.13039, 32.94086], [-117.13076, 32.94096], [-117.13102, 32.94098], [-117.13183, 32.94098], [-117.13245, 32.94104], [-117.13265, 32.94104], [-117.13279, 32.94103], [-117.133, 32.94098], [-117.13327, 32.94086], [-117.13343, 32.94075], [-117.13373, 32.94044], [-117.13399, 32.94024], [-117.13425, 32.94028], [-117.13567, 32.94024]]]} | Open Access 1 | 45211 | Canyonside Community Park | 16829 | 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 | 42.787 | Canyonside Community Park | 0 | Local Park 2 | 4 | |
14799 | 14799 | 14798 | {"type": "Polygon", "coordinates": [[[-117.14969, 32.93434], [-117.14966, 32.93441], [-117.14951, 32.93446], [-117.14893, 32.93448], [-117.14865, 32.93464], [-117.14827, 32.93469], [-117.14816, 32.93473], [-117.14805, 32.93472], [-117.14783, 32.93461], [-117.14761, 32.93471], [-117.14724, 32.93508], [-117.1472, 32.93516], [-117.1471, 32.93523], [-117.14692, 32.93519], [-117.1468, 32.93514], [-117.14672, 32.93508], [-117.14647, 32.93496], [-117.14621, 32.93498], [-117.14602, 32.93492], [-117.14597, 32.93494], [-117.14589, 32.93514], [-117.14573, 32.93508], [-117.14576, 32.93501], [-117.14572, 32.93493], [-117.14563, 32.93484], [-117.14541, 32.9347], [-117.14532, 32.93462], [-117.14516, 32.93427], [-117.14535, 32.93417], [-117.14537, 32.93397], [-117.14529, 32.93389], [-117.14531, 32.93374], [-117.14561, 32.93315], [-117.14539, 32.933], [-117.14518, 32.93282], [-117.14488, 32.9325], [-117.1449, 32.93247], [-117.1452, 32.93229], [-117.14565, 32.93266], [-117.14567, 32.93265], [-117.14607, 32.93284], [-117.14597, 32.93349], [-117.14647, 32.93406], [-117.14657, 32.93404], [-117.14665, 32.93391], [-117.14692, 32.9338], [-117.14718, 32.9338], [-117.1474, 32.9339], [-117.14746, 32.93399], [-117.14769, 32.93405], [-117.14789, 32.93414], [-117.14819, 32.9342], [-117.14833, 32.93414], [-117.1485, 32.9342], [-117.14877, 32.93415], [-117.14886, 32.9342], [-117.14905, 32.9342], [-117.14909, 32.93418], [-117.14912, 32.93418], [-117.1492, 32.93422], [-117.1494, 32.93422], [-117.14962, 32.9341], [-117.14969, 32.93434]]]} | Open Access 1 | 45210 | Camino Ruiz Neighborhood Park | 30130 | 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.138 | Camino Ruiz Neighborhood Park | 0 | Local Park 2 | 4 | |
14698 | 14698 | 14697 | {"type": "Polygon", "coordinates": [[[-117.16575, 32.73251], [-117.16563, 32.73264], [-117.16531, 32.73292], [-117.16531, 32.73252], [-117.16575, 32.73251]]]} | Open Access 1 | 46749 | West Maple Canyon Mini-Park | 30201 | 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.242 | West Maple Canyon Mini-Park | 0 | Local Park 2 | 4 | |
14683 | 14683 | 14682 | {"type": "Polygon", "coordinates": [[[-117.07831, 32.57274], [-117.07633, 32.57273], [-117.07632, 32.5717], [-117.07553, 32.57169], [-117.07553, 32.57057], [-117.07674, 32.57057], [-117.07676, 32.57054], [-117.07712, 32.57054], [-117.07876, 32.57266], [-117.07875, 32.57271], [-117.0787, 32.57274], [-117.07831, 32.57274]]]} | Open Access 1 | 44998 | Southwest Neighborhood Park | 28106 | 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.546 | Southwest Neighborhood Park | 0 | Local Park 2 | 4 | |
14624 | 14624 | 14623 | {"type": "Polygon", "coordinates": [[[-117.22954, 32.84511], [-117.22893, 32.84582], [-117.22787, 32.84581], [-117.22769, 32.84608], [-117.2273, 32.84625], [-117.22603, 32.84564], [-117.22617, 32.84499], [-117.22518, 32.84446], [-117.22536, 32.84424], [-117.22562, 32.84399], [-117.22585, 32.84383], [-117.22615, 32.84366], [-117.22713, 32.84506], [-117.22892, 32.84493], [-117.22954, 32.84511]]]} | Open Access 1 | 44857 | Marcy Neighborhood Park | 30084 | 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.886 | Marcy Neighborhood Park | 0 | Local Park 2 | 4 | |
14623 | 14623 | 14622 | {"type": "Polygon", "coordinates": [[[-117.211, 32.95674], [-117.21069, 32.95703], [-117.21043, 32.95733], [-117.20931, 32.95882], [-117.20928, 32.95884], [-117.20923, 32.95884], [-117.20877, 32.9586], [-117.20858, 32.95847], [-117.20843, 32.95835], [-117.20828, 32.95821], [-117.20812, 32.95801], [-117.20802, 32.95785], [-117.20794, 32.95764], [-117.20789, 32.95744], [-117.20787, 32.95721], [-117.20789, 32.957], [-117.20795, 32.95674], [-117.20802, 32.95657], [-117.20814, 32.95635], [-117.20826, 32.95621], [-117.20834, 32.95614], [-117.20834, 32.95612], [-117.20851, 32.95594], [-117.20854, 32.95596], [-117.20855, 32.95598], [-117.20856, 32.95614], [-117.20852, 32.95619], [-117.20859, 32.95621], [-117.20859, 32.95655], [-117.20853, 32.95669], [-117.20843, 32.95703], [-117.2091, 32.95705], [-117.20914, 32.95667], [-117.20932, 32.95668], [-117.20935, 32.95671], [-117.20938, 32.9567], [-117.20938, 32.95668], [-117.20966, 32.95669], [-117.20965, 32.95671], [-117.20969, 32.95673], [-117.20979, 32.95665], [-117.20999, 32.95666], [-117.21003, 32.95607], [-117.2101, 32.95607], [-117.211, 32.95674]]]} | Open Access 1 | 44855 | Ashley Falls Neighborhood Park | 30154 | 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.655 | Ashley Falls Neighborhood Park | 0 | Local Park 2 | 4 | |
14490 | 14490 | 14489 | {"type": "Polygon", "coordinates": [[[-117.15766, 32.9055], [-117.15651, 32.90626], [-117.1561, 32.90582], [-117.15673, 32.90517], [-117.15693, 32.90501], [-117.15764, 32.9055], [-117.15766, 32.9055]]]} | Restricted Access 2 | 47149 | Salk Neighborhood Park | 31627 | 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.342 | Salk Neighborhood Park | 0 | Local Park 2 | 4 | |
14146 | 14146 | 14145 | {"type": "Polygon", "coordinates": [[[-117.13176, 32.74788], [-117.13144, 32.74787], [-117.13144, 32.74774], [-117.13112, 32.74774], [-117.13112, 32.74748], [-117.13176, 32.74748], [-117.13176, 32.74788]]]} | Open Access 1 | 46809 | North Park Mini Park | 32786 | 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.541 | North Park MP | 0 | Local Park 2 | 4 | |
13727 | 13727 | 13726 | {"type": "Polygon", "coordinates": [[[-117.10185, 32.75039], [-117.10185, 32.75069], [-117.10169, 32.75069], [-117.10169, 32.75039], [-117.10185, 32.75039]]]} | Open Access 1 | 48831 | City Heights Square Mini Park | 33550 | 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.123 | City Heights Square MP | 0 | Local Park 2 | 4 | |
13700 | 13700 | 13699 | {"type": "Polygon", "coordinates": [[[-117.10891, 32.76431], [-117.10845, 32.76431], [-117.10847, 32.76337], [-117.10865, 32.76342], [-117.10891, 32.76431]]]} | Open Access 1 | 48830 | Terrace Drive Mini Park | 33549 | 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/sites/default/files/adams.pdf | San Diego 4 | 0.759 | Terrace Drive MP | 0 | Local Park 2 | 4 |
13167 | 13167 | 13166 | {"type": "MultiPolygon", "coordinates": [[[[-117.06575, 32.85148], [-117.06108, 32.85142], [-117.05338, 32.85136], [-117.05338, 32.85293], [-117.05221, 32.8528], [-117.05147, 32.85255], [-117.05108, 32.852], [-117.05061, 32.85144], [-117.0501, 32.85094], [-117.0495, 32.85046], [-117.04913, 32.8502], [-117.04868, 32.84993], [-117.04767, 32.84943], [-117.04769, 32.84785], [-117.06406, 32.84798], [-117.06575, 32.85148]]], [[[-117.05339, 32.85425], [-117.0534, 32.85544], [-117.05338, 32.85558], [-117.05244, 32.8541], [-117.05339, 32.85425]]]]} | Open Access 1 | 45149 | Mission Trails Regional Park | 29248 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 155.468 | Mission Trails RP | 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]);