units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 138 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP 10
- Local Park 35
- Local Conservation Area 19
- Local Other or Unknown 10
- Local Recreation Area 5
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
LAYER 3 ✖
- County 71
- City 2
- Special District 2
ACCESS_TYP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Orange, County of · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13439 | 13439 | 13438 | {"type": "Polygon", "coordinates": [[[-117.62942, 33.68702], [-117.62839, 33.68717], [-117.62837, 33.68738], [-117.62818, 33.6877], [-117.62813, 33.68775], [-117.62743, 33.68762], [-117.62754, 33.6872], [-117.6276, 33.68684], [-117.62873, 33.68685], [-117.62887, 33.68684], [-117.62926, 33.68677], [-117.6293, 33.6868], [-117.62942, 33.68702]]]} | Open Access 1 | 35572 | Orange holding 3 | 23170 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.452 | Orange holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13546 | 13546 | 13545 | {"type": "Polygon", "coordinates": [[[-117.63087, 33.67292], [-117.63058, 33.67337], [-117.6304, 33.67329], [-117.63037, 33.67331], [-117.63009, 33.67319], [-117.62988, 33.67335], [-117.62977, 33.6733], [-117.62957, 33.67326], [-117.62939, 33.67329], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62914, 33.67323], [-117.62913, 33.67308], [-117.62914, 33.67295], [-117.62924, 33.67274], [-117.62944, 33.67259], [-117.62946, 33.67244], [-117.62955, 33.67229], [-117.63087, 33.67292]]]} | Open Access 1 | 35861 | Orange holding 4 | 23171 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.903 | Orange holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13373 | 13373 | 13372 | {"type": "Polygon", "coordinates": [[[-117.63726, 33.57438], [-117.63727, 33.57449], [-117.63717, 33.57496], [-117.63702, 33.57514], [-117.63615, 33.57531], [-117.63567, 33.5756], [-117.63515, 33.57558], [-117.63505, 33.57537], [-117.63485, 33.57548], [-117.63422, 33.57516], [-117.63384, 33.57494], [-117.63357, 33.57506], [-117.63345, 33.57529], [-117.63341, 33.57524], [-117.63358, 33.57484], [-117.63367, 33.57479], [-117.63511, 33.57517], [-117.63594, 33.57518], [-117.63671, 33.5749], [-117.63726, 33.57438]]]} | Open Access 1 | 35457 | Orange holding 6 | 23173 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.925 | Orange holding 6 | 0 | Local Other or Unknown 14 | 4 | |
12982 | 12982 | 12981 | {"type": "Polygon", "coordinates": [[[-117.88557, 33.90604], [-117.88552, 33.9061], [-117.88537, 33.90606], [-117.88523, 33.90589], [-117.8851, 33.9056], [-117.88475, 33.90521], [-117.88437, 33.90554], [-117.88411, 33.9054], [-117.88466, 33.90489], [-117.88471, 33.90482], [-117.8847, 33.90456], [-117.88463, 33.90446], [-117.88463, 33.9043], [-117.88473, 33.90417], [-117.88498, 33.90406], [-117.8852, 33.90402], [-117.88534, 33.90411], [-117.88542, 33.90436], [-117.88526, 33.90474], [-117.88526, 33.90495], [-117.88544, 33.9058], [-117.88557, 33.90604]]]} | Open Access 1 | 30439 | Craig Regional Park | 17752 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.996 | Craig RP | 0 | Local Park 2 | 4 | |
12977 | 12977 | 12976 | {"type": "Polygon", "coordinates": [[[-117.78424, 33.86528], [-117.78305, 33.86527], [-117.78304, 33.8649], [-117.78267, 33.86486], [-117.78237, 33.86485], [-117.78238, 33.86457], [-117.78242, 33.86453], [-117.78244, 33.86454], [-117.78255, 33.86453], [-117.7837, 33.8643], [-117.78397, 33.86429], [-117.78402, 33.86476], [-117.78407, 33.86489], [-117.7841, 33.86489], [-117.78419, 33.86506], [-117.78423, 33.86516], [-117.78424, 33.86528]]]} | Open Access 1 | 30443 | Woodgate Park | 27710 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.092 | Woodgate Park | 0 | Local Park 2 | 4 | |
430 | 430 | 429 | {"type": "Polygon", "coordinates": [[[-117.69087, 33.64713], [-117.69085, 33.64716], [-117.69051, 33.64729], [-117.68995, 33.64727], [-117.68923, 33.64768], [-117.68869, 33.64759], [-117.68877, 33.64738], [-117.68882, 33.64717], [-117.68975, 33.64643], [-117.69027, 33.64681], [-117.69087, 33.64713]]]} | Open Access 1 | 1728 | Heritage Hill Historic Site | 19835 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.228 | Heritage Hill Historic Site | 0 | Local Historic or Cultural Area 19 | 4 | |
13376 | 13376 | 13375 | {"type": "Polygon", "coordinates": [[[-117.62419, 33.69092], [-117.62398, 33.69096], [-117.62396, 33.69093], [-117.62376, 33.69096], [-117.62351, 33.69104], [-117.62298, 33.69101], [-117.62301, 33.69097], [-117.62305, 33.69074], [-117.6231, 33.69026], [-117.62314, 33.69005], [-117.62321, 33.6899], [-117.62345, 33.6895], [-117.62353, 33.68947], [-117.62395, 33.68963], [-117.62408, 33.69006], [-117.62399, 33.69007], [-117.62398, 33.69008], [-117.62419, 33.69092]]]} | Open Access 1 | 35460 | Orange holding 8 | 23175 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.388 | Orange holding 8 | 0 | Local Other or Unknown 14 | 4 | |
9945 | 9945 | 9944 | {"type": "Polygon", "coordinates": [[[-117.75367, 33.87309], [-117.7534, 33.8731], [-117.75323, 33.87313], [-117.75305, 33.87321], [-117.75276, 33.87329], [-117.75249, 33.8734], [-117.7522, 33.87353], [-117.75193, 33.87367], [-117.75157, 33.87392], [-117.75115, 33.87428], [-117.75095, 33.87452], [-117.7508, 33.87474], [-117.7507, 33.87478], [-117.74982, 33.87457], [-117.75063, 33.8741], [-117.75188, 33.87343], [-117.75274, 33.87301], [-117.75361, 33.87262], [-117.75367, 33.87309]]]} | Open Access 1 | 47963 | Yorba Regional Park | 27778 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/parks/yorba | Orange 3 | 3.53 | Yorba RP | 0 | Local Park 2 | 4 |
13377 | 13377 | 13376 | {"type": "Polygon", "coordinates": [[[-117.63832, 33.55179], [-117.63825, 33.55193], [-117.63806, 33.55195], [-117.63749, 33.55165], [-117.63722, 33.55113], [-117.63732, 33.55058], [-117.63776, 33.55016], [-117.63796, 33.55008], [-117.63803, 33.55011], [-117.63826, 33.55094], [-117.63832, 33.55179]]]} | Open Access 1 | 35462 | Orange holding 12 | 23159 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.606 | Orange holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13485 | 13485 | 13484 | {"type": "Polygon", "coordinates": [[[-117.63608, 33.56053], [-117.63599, 33.56078], [-117.63595, 33.56079], [-117.63584, 33.561], [-117.63553, 33.56083], [-117.63503, 33.56079], [-117.63423, 33.56105], [-117.63372, 33.56095], [-117.63375, 33.56083], [-117.63376, 33.56069], [-117.63371, 33.56049], [-117.63382, 33.5605], [-117.63434, 33.56033], [-117.6345, 33.56025], [-117.63477, 33.56004], [-117.63505, 33.55994], [-117.6351, 33.55995], [-117.63526, 33.56023], [-117.63598, 33.56045], [-117.636, 33.5605], [-117.63608, 33.56053]]]} | Open Access 1 | 35770 | Orange holding 16 | 23163 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.721 | Orange holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13530 | 13530 | 13529 | {"type": "Polygon", "coordinates": [[[-117.63308, 33.68047], [-117.63275, 33.68098], [-117.63268, 33.68098], [-117.63235, 33.6812], [-117.63229, 33.68167], [-117.63149, 33.68159], [-117.63135, 33.68156], [-117.63122, 33.68152], [-117.63106, 33.68143], [-117.63107, 33.68139], [-117.63124, 33.6812], [-117.63246, 33.68007], [-117.63255, 33.68007], [-117.63308, 33.68047]]]} | Open Access 1 | 35831 | Orange holding 1 | 23155 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.943 | Orange holding 1 | 0 | Local Other or Unknown 14 | 4 | |
720 | 720 | 719 | {"type": "Polygon", "coordinates": [[[-117.64606, 33.71715], [-117.64569, 33.71705], [-117.6455, 33.71693], [-117.64478, 33.71604], [-117.64591, 33.71499], [-117.64598, 33.71518], [-117.64608, 33.71555], [-117.64612, 33.7158], [-117.64612, 33.71618], [-117.64606, 33.71715]]]} | Open Access 1 | 5401 | Modjeska Home and Garden | 22342 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 4.245 | Modjeska Home and Garden | 0 | Local Park 2 | 4 | |
1731 | 1731 | 1730 | {"type": "MultiPolygon", "coordinates": [[[[-117.81129, 33.76654], [-117.81097, 33.77124], [-117.8108, 33.77342], [-117.81067, 33.77342], [-117.81095, 33.76974], [-117.81117, 33.76654], [-117.81129, 33.76654]]], [[[-117.81175, 33.75996], [-117.81146, 33.76454], [-117.81131, 33.76637], [-117.81119, 33.76638], [-117.81132, 33.76454], [-117.81133, 33.76422], [-117.8115, 33.76143], [-117.81161, 33.75995], [-117.81175, 33.75996]]]]} | Open Access 1 | 12930 | Esplanade Park | 18714 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 4.697 | Esplanade Park | 0 | Local Park 2 | 4 | |
13370 | 13370 | 13369 | {"type": "Polygon", "coordinates": [[[-117.64456, 33.55733], [-117.64456, 33.55832], [-117.64446, 33.55917], [-117.64411, 33.55996], [-117.64407, 33.55994], [-117.64408, 33.55991], [-117.64401, 33.55988], [-117.64398, 33.55992], [-117.64392, 33.55989], [-117.64387, 33.55995], [-117.64407, 33.56004], [-117.64406, 33.56007], [-117.64384, 33.55998], [-117.64352, 33.55741], [-117.64456, 33.55733]]]} | Open Access 1 | 35454 | Orange holding 11 | 23158 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.148 | Orange holding 11 | 0 | Local Other or Unknown 14 | 4 | |
8270 | 8270 | 8269 | {"type": "Polygon", "coordinates": [[[-117.71813, 33.46914], [-117.71782, 33.46914], [-117.71759, 33.46875], [-117.71627, 33.4669], [-117.71623, 33.46688], [-117.71581, 33.46699], [-117.71576, 33.46684], [-117.71616, 33.46674], [-117.71618, 33.46673], [-117.71618, 33.46669], [-117.71605, 33.46642], [-117.71602, 33.4663], [-117.71589, 33.46599], [-117.71512, 33.46478], [-117.71464, 33.46368], [-117.71535, 33.46391], [-117.71545, 33.46419], [-117.71551, 33.4647], [-117.71576, 33.46533], [-117.71605, 33.46569], [-117.71634, 33.46625], [-117.71644, 33.46654], [-117.71691, 33.46711], [-117.71701, 33.46745], [-117.71715, 33.46761], [-117.71731, 33.46791], [-117.71741, 33.46805], [-117.71749, 33.46833], [-117.71763, 33.46861], [-117.71779, 33.4688], [-117.71797, 33.46895], [-117.71813, 33.46914]]]} | Open Access 1 | 12658 | Silver Strand Beach County Park | 25495 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.163 | Silver Strand Beach County Park | 0 | Local Park 2 | 4 | |
10406 | 10406 | 10405 | {"type": "Polygon", "coordinates": [[[-117.88675, 33.63629], [-117.88676, 33.63671], [-117.88656, 33.63756], [-117.88651, 33.63789], [-117.88644, 33.63864], [-117.88628, 33.63944], [-117.88624, 33.64024], [-117.88617, 33.64049], [-117.88615, 33.64054], [-117.88604, 33.64067], [-117.88588, 33.64072], [-117.88507, 33.64081], [-117.88518, 33.64074], [-117.88577, 33.64058], [-117.88601, 33.64014], [-117.88595, 33.63961], [-117.88605, 33.63868], [-117.8862, 33.638], [-117.88625, 33.63711], [-117.88644, 33.63657], [-117.88657, 33.63646], [-117.88649, 33.63611], [-117.88598, 33.63572], [-117.88576, 33.63561], [-117.88532, 33.63466], [-117.88467, 33.63416], [-117.88461, 33.63407], [-117.88479, 33.63397], [-117.88534, 33.63446], [-117.88542, 33.63454], [-117.88552, 33.63478], [-117.88576, 33.63522], [-117.88604, 33.63554], [-117.88649, 33.63592], [-117.88675, 33.63629]]]} | Open Access 1 | 18399 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.179 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
10403 | 10403 | 10402 | {"type": "Polygon", "coordinates": [[[-117.87426, 33.65171], [-117.87411, 33.65186], [-117.87368, 33.65165], [-117.87349, 33.65159], [-117.87309, 33.65154], [-117.87287, 33.65155], [-117.87262, 33.6516], [-117.87254, 33.65162], [-117.87253, 33.65194], [-117.87219, 33.65186], [-117.87188, 33.65195], [-117.87143, 33.65239], [-117.87108, 33.65252], [-117.87085, 33.65215], [-117.87074, 33.65219], [-117.8706, 33.65196], [-117.8698, 33.65217], [-117.87, 33.65204], [-117.87103, 33.65164], [-117.87218, 33.65124], [-117.8725, 33.65115], [-117.87249, 33.6511], [-117.87303, 33.65086], [-117.87426, 33.65171]]]} | Open Access 1 | 18396 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.536 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
2737 | 2737 | 2736 | {"type": "MultiPolygon", "coordinates": [[[[-117.88993, 33.65132], [-117.88915, 33.65163], [-117.88901, 33.65178], [-117.88892, 33.65213], [-117.88878, 33.6524], [-117.88858, 33.6525], [-117.88842, 33.65252], [-117.88878, 33.65161], [-117.88869, 33.65158], [-117.88957, 33.65102], [-117.88975, 33.65122], [-117.88993, 33.65132]]], [[[-117.89068, 33.65184], [-117.89057, 33.65202], [-117.89045, 33.65216], [-117.88972, 33.6529], [-117.88932, 33.65262], [-117.88889, 33.65246], [-117.88867, 33.65249], [-117.88881, 33.65241], [-117.88895, 33.65214], [-117.88904, 33.65178], [-117.88917, 33.65166], [-117.88993, 33.65135], [-117.88998, 33.65135], [-117.89031, 33.65154], [-117.89043, 33.65169], [-117.89061, 33.65181], [-117.89068, 33.65184]]]]} | Open Access 1 | 18389 | Upper Newport Bay Nature Preserve | 26732 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.762 | Upper Newport Bay Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
11325 | 11325 | 11324 | {"type": "Polygon", "coordinates": [[[-117.71884, 33.57576], [-117.71881, 33.57578], [-117.71873, 33.57603], [-117.71834, 33.57736], [-117.71799, 33.57769], [-117.7177, 33.57776], [-117.71697, 33.5773], [-117.71696, 33.57726], [-117.7171, 33.57705], [-117.71724, 33.57692], [-117.71744, 33.57679], [-117.71759, 33.57667], [-117.71771, 33.57652], [-117.71775, 33.5765], [-117.71782, 33.57635], [-117.71788, 33.57615], [-117.71789, 33.57604], [-117.71787, 33.57583], [-117.71784, 33.57569], [-117.71784, 33.57561], [-117.71795, 33.57538], [-117.71804, 33.57492], [-117.71858, 33.57549], [-117.71849, 33.57547], [-117.71841, 33.57548], [-117.71836, 33.5755], [-117.71832, 33.57555], [-117.7183, 33.5756], [-117.71834, 33.57569], [-117.71842, 33.57574], [-117.71849, 33.57574], [-117.71873, 33.57565], [-117.71884, 33.57576]]]} | Open Access 1 | 22038 | Springdale Park | 25746 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.781 | Springdale Park | 0 | Local Park 2 | 4 | |
12496 | 12496 | 12495 | {"type": "Polygon", "coordinates": [[[-117.77687, 33.7649], [-117.77713, 33.76457], [-117.77646, 33.76411], [-117.77593, 33.76388], [-117.77537, 33.76368], [-117.77447, 33.76339], [-117.77528, 33.76258], [-117.77535, 33.76253], [-117.77543, 33.76254], [-117.77665, 33.76339], [-117.77667, 33.76338], [-117.77774, 33.76413], [-117.77775, 33.76416], [-117.77773, 33.7642], [-117.7774, 33.76452], [-117.77704, 33.76493], [-117.77697, 33.76495], [-117.77687, 33.7649]]]} | Open Access 1 | 36503 | Orange holding 19 | 23166 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 6.636 | Orange holding 19 | 0 | Local Other or Unknown 14 | 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]);