units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where DES_TP = 2 and MNG_AGENCY = 7 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
AGNCY_NAME 2 ✖
MNG_AG_TYP 1
MNG_AGENCY 1
- Santa Barbara, County of · 40 ✖
DES_TP 1
- Local Park · 40 ✖
ACCESS_TYP 1
- Open Access 40
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9804 | 9804 | 9803 | {"type": "Polygon", "coordinates": [[[-119.82652, 34.43735], [-119.82651, 34.43749], [-119.82615, 34.43748], [-119.82615, 34.43734], [-119.82652, 34.43735]]]} | Open Access 1 | 18096 | Nectarine Mini Park | 22682 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.13 | Nectarine MP | 0 | Local Park 2 | 4 | |
8900 | 8900 | 8899 | {"type": "Polygon", "coordinates": [[[-119.87867, 34.42332], [-119.87847, 34.42368], [-119.87808, 34.42365], [-119.87803, 34.42368], [-119.87799, 34.42375], [-119.878, 34.42402], [-119.87795, 34.42403], [-119.87793, 34.42372], [-119.87812, 34.42327], [-119.87829, 34.42335], [-119.87847, 34.42349], [-119.87865, 34.42326], [-119.87867, 34.42332]]]} | Open Access 1 | 14564 | Armstrong Mini Park | 15594 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.463 | Armstrong MP | 0 | Local Park 2 | 4 | |
9791 | 9791 | 9790 | {"type": "Polygon", "coordinates": [[[-120.14736, 34.60188], [-120.14677, 34.60214], [-120.14633, 34.60186], [-120.1463, 34.60186], [-120.1463, 34.60182], [-120.14633, 34.60183], [-120.14665, 34.6018], [-120.14665, 34.60173], [-120.14672, 34.60171], [-120.14701, 34.60175], [-120.14726, 34.60186], [-120.14736, 34.60188]]]} | Open Access 1 | 16735 | Hans Christian Andersen Park | 19646 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.566 | Hans Christian Andersen Park | 0 | Local Park 2 | 4 | |
6131 | 6131 | 6130 | {"type": "MultiPolygon", "coordinates": [[[[-119.8405, 34.44897], [-119.84028, 34.44897], [-119.84023, 34.44897], [-119.84042, 34.44887], [-119.8405, 34.44897]]], [[[-119.84221, 34.45083], [-119.84133, 34.45085], [-119.84133, 34.45014], [-119.84133, 34.45014], [-119.84221, 34.45083]]]]} | Open Access 1 | 1119 | Stonebridge Park | 25879 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.819 | Stonebridge Park | 0 | Local Park 2 | 4 | |
9933 | 9933 | 9932 | {"type": "Polygon", "coordinates": [[[-119.85595, 34.4093], [-119.85537, 34.40921], [-119.85537, 34.40853], [-119.85595, 34.40862], [-119.85595, 34.4093]]]} | Open Access 1 | 18473 | Pelican Park | 23568 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.002 | Pelican Park | 0 | Local Park 2 | 4 | |
12077 | 12077 | 12076 | {"type": "MultiPolygon", "coordinates": [[[[-120.46427, 34.59959], [-120.46406, 34.60047], [-120.46387, 34.60048], [-120.46389, 34.60024], [-120.46393, 34.60008], [-120.46404, 34.59976], [-120.46412, 34.59961], [-120.46427, 34.59959]]], [[[-120.46586, 34.59723], [-120.46532, 34.59812], [-120.46507, 34.59806], [-120.46561, 34.59718], [-120.46586, 34.59723]]]]} | Open Access 1 | 24847 | Miguelito County Park | 22211 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.082 | Miguelito County Park | 0 | Local Park 2 | 4 | |
579 | 579 | 578 | {"type": "Polygon", "coordinates": [[[-119.89552, 34.4344], [-119.89508, 34.43471], [-119.89486, 34.4345], [-119.89513, 34.43431], [-119.89512, 34.4338], [-119.89489, 34.4336], [-119.8955, 34.43359], [-119.89552, 34.4344]]]} | Open Access 1 | 1927 | Winchester I Park | 27619 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.139 | Winchester I Park | 0 | Local Park 2 | 4 | |
581 | 581 | 580 | {"type": "Polygon", "coordinates": [[[-119.89864, 34.43647], [-119.89778, 34.43649], [-119.89777, 34.43593], [-119.89862, 34.43591], [-119.89864, 34.43647]]]} | Open Access 1 | 1936 | Winchester II Park | 27620 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.211 | Winchester II Park | 0 | Local Park 2 | 4 | |
6017 | 6017 | 6016 | {"type": "Polygon", "coordinates": [[[-119.86649, 34.40896], [-119.86649, 34.40971], [-119.86582, 34.40971], [-119.86582, 34.40896], [-119.86649, 34.40896]]]} | Open Access 1 | 696 | Sea Lookout Park | 25234 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 1.288 | Sea Lookout Park | 0 | Local Park 2 | 4 | |
5814 | 5814 | 5813 | {"type": "Polygon", "coordinates": [[[-119.89151, 34.43413], [-119.89122, 34.43427], [-119.8914, 34.43453], [-119.89147, 34.43483], [-119.89136, 34.43502], [-119.89074, 34.43377], [-119.8905, 34.43295], [-119.89037, 34.43294], [-119.89009, 34.43279], [-119.89018, 34.43279], [-119.89036, 34.43289], [-119.89048, 34.43289], [-119.8905, 34.43294], [-119.89083, 34.43292], [-119.891, 34.43284], [-119.89098, 34.43312], [-119.891, 34.43328], [-119.89106, 34.43344], [-119.89113, 34.43357], [-119.89151, 34.43413]]]} | Open Access 1 | 123 | Brandon Park | 16330 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.073 | Brandon Park | 0 | Local Park 2 | 4 | |
7691 | 7691 | 7690 | {"type": "Polygon", "coordinates": [[[-119.82469, 34.45032], [-119.82467, 34.45037], [-119.8243, 34.45031], [-119.82425, 34.45076], [-119.82391, 34.45073], [-119.8239, 34.45101], [-119.82372, 34.451], [-119.82373, 34.45072], [-119.82337, 34.45073], [-119.8231, 34.45076], [-119.8231, 34.45046], [-119.82295, 34.45043], [-119.82295, 34.45038], [-119.8231, 34.45033], [-119.8231, 34.45002], [-119.82389, 34.45001], [-119.8239, 34.44994], [-119.82433, 34.44998], [-119.82431, 34.45025], [-119.82469, 34.45032]]]} | Open Access 1 | 7682 | Andamar Park | 15472 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 2.445 | Andamar Park | 0 | Local Park 2 | 4 | |
3849 | 3849 | 3848 | {"type": "MultiPolygon", "coordinates": [[[[-120.08509, 34.61217], [-120.08485, 34.61225], [-120.08464, 34.61234], [-120.08421, 34.61266], [-120.08416, 34.61268], [-120.08416, 34.61217], [-120.08509, 34.61217]]], [[[-120.08517, 34.61149], [-120.08516, 34.61204], [-120.0845, 34.61203], [-120.08451, 34.61148], [-120.08517, 34.61149]]], [[[-120.08606, 34.6115], [-120.08594, 34.61162], [-120.08572, 34.61198], [-120.08555, 34.61204], [-120.08543, 34.61204], [-120.08543, 34.61149], [-120.08606, 34.6115]]], [[[-120.08723, 34.61005], [-120.08718, 34.61013], [-120.08634, 34.61118], [-120.08635, 34.6112], [-120.08626, 34.61128], [-120.08554, 34.61129], [-120.08554, 34.61123], [-120.08561, 34.61111], [-120.0859, 34.61112], [-120.08608, 34.61102], [-120.08625, 34.6111], [-120.08632, 34.61104], [-120.08622, 34.61074], [-120.08647, 34.61044], [-120.0867, 34.61044], [-120.08691, 34.61018], [-120.08706, 34.61005], [-120.08723, 34.61005]]]]} | Open Access 1 | 626 | Santa Ynez Park | 25143 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.195 | Santa Ynez Park | 0 | Local Park 2 | 4 | |
9900 | 9900 | 9899 | {"type": "MultiPolygon", "coordinates": [[[[-119.8647, 34.40971], [-119.86462, 34.40971], [-119.86462, 34.40897], [-119.8647, 34.40897], [-119.8647, 34.40971]]], [[[-119.86421, 34.40971], [-119.86396, 34.40971], [-119.86396, 34.40902], [-119.8642, 34.40901], [-119.86421, 34.40971]]], [[[-119.86379, 34.40971], [-119.86363, 34.40971], [-119.86363, 34.40905], [-119.86379, 34.40904], [-119.86379, 34.40971]]], [[[-119.86943, 34.40918], [-119.86943, 34.40945], [-119.86919, 34.40943], [-119.86913, 34.40981], [-119.86907, 34.4098], [-119.86911, 34.40942], [-119.86807, 34.40933], [-119.86802, 34.40971], [-119.86798, 34.40971], [-119.86798, 34.40933], [-119.86772, 34.40933], [-119.86772, 34.40971], [-119.86759, 34.40971], [-119.86758, 34.40933], [-119.86719, 34.40933], [-119.86666, 34.40933], [-119.86666, 34.40971], [-119.86649, 34.40971], [-119.8665, 34.40896], [-119.86943, 34.40918]]]]} | Open Access 1 | 16980 | Isla Vista Beach | 20277 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.442 | Isla Vista Beach | 0 | Local Park 2 | 4 | |
314 | 314 | 313 | {"type": "Polygon", "coordinates": [[[-119.69311, 34.46023], [-119.69221, 34.46094], [-119.69162, 34.46037], [-119.6916, 34.46001], [-119.69199, 34.45915], [-119.69235, 34.45915], [-119.69311, 34.46023]]]} | Open Access 1 | 847 | Skofield Park | 25529 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 4.077 | Skofield Park | 0 | Local Park 2 | 4 | |
2555 | 2555 | 2554 | {"type": "Polygon", "coordinates": [[[-120.47151, 34.59209], [-120.4715, 34.59302], [-120.4694, 34.59376], [-120.46933, 34.59299], [-120.47003, 34.59241], [-120.47066, 34.59232], [-120.47151, 34.59209]]]} | Open Access 1 | 17819 | Miguelito County Park | 22211 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 5.367 | Miguelito County Park | 0 | Local Park 2 | 4 | |
9300 | 9300 | 9299 | {"type": "Polygon", "coordinates": [[[-119.74515, 34.40323], [-119.74476, 34.40436], [-119.74399, 34.40382], [-119.7439, 34.40379], [-119.74377, 34.4038], [-119.74365, 34.40385], [-119.74357, 34.40392], [-119.74349, 34.4035], [-119.74345, 34.40311], [-119.74339, 34.40313], [-119.74343, 34.40351], [-119.74352, 34.40399], [-119.74332, 34.40425], [-119.74318, 34.40435], [-119.74305, 34.40439], [-119.74231, 34.40436], [-119.74274, 34.40423], [-119.74327, 34.40268], [-119.74515, 34.40323]]]} | Open Access 1 | 15495 | Arroyo Burro Beach County Park | 15610 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 5.986 | Arroyo Burro Beach County Park | 0 | Local Park 2 | 4 | |
9965 | 9965 | 9964 | {"type": "MultiPolygon", "coordinates": [[[[-119.8348, 34.45306], [-119.83472, 34.45336], [-119.83473, 34.45393], [-119.83358, 34.45393], [-119.83346, 34.45366], [-119.83327, 34.45366], [-119.83316, 34.45389], [-119.83241, 34.45389], [-119.83209, 34.45412], [-119.83206, 34.45426], [-119.8319, 34.45426], [-119.83184, 34.45381], [-119.83212, 34.45376], [-119.83261, 34.45358], [-119.83287, 34.45353], [-119.83313, 34.45353], [-119.83355, 34.4536], [-119.83367, 34.45359], [-119.83379, 34.45357], [-119.83391, 34.45352], [-119.83401, 34.45346], [-119.83426, 34.45322], [-119.83432, 34.45318], [-119.83441, 34.45314], [-119.83465, 34.45311], [-119.8348, 34.45306]]], [[[-119.83502, 34.45281], [-119.83464, 34.45297], [-119.83442, 34.45301], [-119.83435, 34.45301], [-119.83432, 34.45299], [-119.83419, 34.45248], [-119.83415, 34.45237], [-119.83409, 34.45227], [-119.83398, 34.45214], [-119.83388, 34.45207], [-119.83372, 34.452], [-119.83358, 34.45198], [-119.83366, 34.45161], [-119.83475, 34.45158], [-119.83461, 34.45187], [-119.83496, 34.45206], [-119.83491, 34.45218], [-119.83488, 34.45234], [-119.83492, 34.4525], [-119.83504, 34.45277], [-119.83504, 34.45279], [-119.83502, 34.45281]]], [[[-119.83411, 34.45306], [-119.83392, 34.45326], [-119.83383, 34.45332], [-119.83372, 34.45336], [-119.8337, 34.45333], [-119.83385, 34.45324], [-119.83397, 34.45312], [-119.83407, 34.45305], [-119.83409, 34.45301], [-119.83411, 34.45306]]]]} | Open Access 1 | 17138 | La Goleta Park | 20757 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 6.108 | La Goleta Park | 0 | Local Park 2 | 4 | |
2465 | 2465 | 2464 | {"type": "Polygon", "coordinates": [[[-119.60451, 34.42018], [-119.60401, 34.42022], [-119.60381, 34.42025], [-119.6035, 34.42034], [-119.60326, 34.42037], [-119.60294, 34.42044], [-119.60259, 34.42056], [-119.60257, 34.42054], [-119.60186, 34.42055], [-119.60192, 34.42063], [-119.60149, 34.42059], [-119.6015, 34.42054], [-119.60119, 34.42046], [-119.60115, 34.42057], [-119.60107, 34.42054], [-119.6011, 34.42044], [-119.60054, 34.42031], [-119.60027, 34.41974], [-119.59999, 34.41968], [-119.6, 34.4196], [-119.59979, 34.41952], [-119.5994, 34.41953], [-119.59921, 34.41946], [-119.5993, 34.41913], [-119.60007, 34.41924], [-119.60003, 34.4195], [-119.60215, 34.41991], [-119.60216, 34.42013], [-119.60228, 34.42012], [-119.60228, 34.41991], [-119.60362, 34.41996], [-119.60381, 34.41998], [-119.60451, 34.41995], [-119.60451, 34.42018]]]} | Open Access 1 | 17402 | Lookout Park and Beach | 21461 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 6.582 | Lookout Park and Beach | 0 | Local Park 2 | 4 | |
10364 | 10364 | 10363 | {"type": "MultiPolygon", "coordinates": [[[[-119.82218, 34.45596], [-119.82169, 34.45592], [-119.82106, 34.45592], [-119.82106, 34.45542], [-119.82103, 34.45521], [-119.82103, 34.45517], [-119.82106, 34.45515], [-119.82112, 34.45514], [-119.82174, 34.45515], [-119.82207, 34.45508], [-119.82215, 34.45529], [-119.82218, 34.45596]]], [[[-119.82397, 34.45496], [-119.82392, 34.45497], [-119.82394, 34.45538], [-119.82378, 34.45558], [-119.82369, 34.45581], [-119.82347, 34.45604], [-119.82351, 34.45614], [-119.82364, 34.45625], [-119.82374, 34.45636], [-119.82376, 34.45652], [-119.82369, 34.45676], [-119.82367, 34.45697], [-119.82357, 34.45723], [-119.82345, 34.45737], [-119.82369, 34.45756], [-119.82344, 34.45767], [-119.82325, 34.4581], [-119.82325, 34.45838], [-119.82322, 34.45844], [-119.82309, 34.45845], [-119.82311, 34.45784], [-119.82326, 34.45725], [-119.82355, 34.45682], [-119.82331, 34.45625], [-119.82331, 34.45601], [-119.8239, 34.45464], [-119.82388, 34.45359], [-119.82323, 34.45372], [-119.82271, 34.45436], [-119.82251, 34.45444], [-119.82248, 34.45482], [-119.82173, 34.455], [-119.8211, 34.45499], [-119.82099, 34.455], [-119.82099, 34.45492], [-119.82177, 34.45493], [-119.82216, 34.45444], [-119.82242, 34.45432], [-119.8226, 34.45383], [-119.82286, 34.4536], [-119.82319, 34.45339], [-119.82365, 34.45304], [-119.82395, 34.45304], [-119.82397, 34.45496]]]]} | Open Access 1 | 18310 | Oro Verde Park | 23208 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 7.464 | Oro Verde Park | 0 | Local Park 2 | 4 | |
10288 | 10288 | 10287 | {"type": "Polygon", "coordinates": [[[-119.59152, 34.42005], [-119.5914, 34.42049], [-119.59123, 34.42047], [-119.59109, 34.42098], [-119.59149, 34.42106], [-119.59139, 34.42142], [-119.59146, 34.42144], [-119.59133, 34.42188], [-119.59085, 34.42179], [-119.59074, 34.42219], [-119.58939, 34.42193], [-119.58987, 34.42067], [-119.5899, 34.42066], [-119.59047, 34.41985], [-119.59152, 34.42005]]]} | Open Access 1 | 18250 | Ocean View Park | 23057 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 8.037 | Ocean View 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]);