units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
74 rows where DES_TP = 2 and MNG_AGENCY = 122 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 54
MNG_AGENCY 1
- Huntington Beach, City of · 54 ✖
DES_TP 1
- Local Park · 54 ✖
ACCESS_TYP 1
- Open Access 54
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8408 | 8408 | 8407 | {"type": "Polygon", "coordinates": [[[-117.95827, 33.67701], [-117.95936, 33.67701], [-117.9594, 33.67707], [-117.9594, 33.67765], [-117.95937, 33.67768], [-117.95933, 33.67769], [-117.95882, 33.67769], [-117.95873, 33.67771], [-117.95826, 33.67769], [-117.95825, 33.67781], [-117.95819, 33.67781], [-117.95818, 33.6777], [-117.958, 33.67751], [-117.95803, 33.67743], [-117.95798, 33.67731], [-117.95795, 33.67708], [-117.95826, 33.67707], [-117.95827, 33.67701]]]} | Open Access 1 | 13024 | Bushard Park | 16539 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bushard-park.cfm | Orange 3 | 2.372 | Bushard Park | 0 | Local Park 2 | 4 |
8381 | 8381 | 8380 | {"type": "Polygon", "coordinates": [[[-117.95978, 33.66175], [-117.95953, 33.66177], [-117.95945, 33.6618], [-117.95939, 33.66186], [-117.95936, 33.66197], [-117.95937, 33.66243], [-117.95934, 33.66247], [-117.95888, 33.66264], [-117.95866, 33.66266], [-117.95859, 33.66263], [-117.95857, 33.66158], [-117.95855, 33.6615], [-117.95978, 33.66149], [-117.95978, 33.66175]]]} | Open Access 1 | 12978 | Burke Park | 16521 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/burke-park.cfm | Orange 3 | 2.488 | Burke Park | 0 | Local Park 2 | 4 |
8078 | 8078 | 8077 | {"type": "Polygon", "coordinates": [[[-118.07235, 33.72659], [-118.07228, 33.72661], [-118.07221, 33.72666], [-118.0722, 33.72671], [-118.07221, 33.72677], [-118.07183, 33.72757], [-118.07183, 33.72762], [-118.07179, 33.72768], [-118.07173, 33.72773], [-118.07178, 33.7276], [-118.07151, 33.72691], [-118.07117, 33.72671], [-118.07101, 33.72674], [-118.07094, 33.72682], [-118.07049, 33.72655], [-118.07125, 33.72566], [-118.07173, 33.72594], [-118.07178, 33.72605], [-118.07184, 33.72612], [-118.07173, 33.7263], [-118.07235, 33.72659]]]} | Open Access 1 | 12030 | Sea Bridge Park | 25230 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.714 | Sea Bridge Park | 0 | Local Park 2 | 4 | |
7906 | 7906 | 7905 | {"type": "Polygon", "coordinates": [[[-118.0394, 33.73704], [-118.03823, 33.73704], [-118.03823, 33.73653], [-118.03938, 33.73653], [-118.0394, 33.73704]]]} | Open Access 1 | 10219 | Robinwood Park | 24503 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.51 | Robinwood Park | 0 | Local Park 2 | 4 | |
7760 | 7760 | 7759 | {"type": "Polygon", "coordinates": [[[-117.98513, 33.6855], [-117.98491, 33.68534], [-117.98477, 33.68528], [-117.98462, 33.68524], [-117.98445, 33.68522], [-117.98444, 33.68423], [-117.98511, 33.68423], [-117.98513, 33.6855]]]} | Open Access 1 | 8350 | Perry Park | 23613 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.867 | Perry Park | 0 | Local Park 2 | 4 | |
7594 | 7594 | 7593 | {"type": "Polygon", "coordinates": [[[-117.95873, 33.64693], [-117.95787, 33.64693], [-117.95785, 33.64543], [-117.95811, 33.64541], [-117.95837, 33.64536], [-117.9587, 33.64535], [-117.95873, 33.64693]]]} | Open Access 1 | 12172 | Seeley Park | 25283 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.371 | Seeley Park | 0 | Local Park 2 | 4 | |
6943 | 6943 | 6942 | {"type": "Polygon", "coordinates": [[[-117.96654, 33.66494], [-117.96582, 33.66494], [-117.9658, 33.66366], [-117.96652, 33.66365], [-117.96654, 33.66494]]]} | Open Access 1 | 5846 | Sowers Park | 25709 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.359 | Sowers Park | 0 | Local Park 2 | 4 | |
6824 | 6824 | 6823 | {"type": "Polygon", "coordinates": [[[-117.97583, 33.66579], [-117.97583, 33.66648], [-117.9743, 33.66637], [-117.97438, 33.66607], [-117.97442, 33.66579], [-117.97583, 33.66579]]]} | Open Access 1 | 5408 | Moffett Park | 22347 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/moffett-park.cfm | Orange 3 | 2.381 | Moffett Park | 0 | Local Park 2 | 4 |
6760 | 6760 | 6759 | {"type": "Polygon", "coordinates": [[[-117.99511, 33.67831], [-117.99421, 33.67831], [-117.9942, 33.6782], [-117.99413, 33.6782], [-117.99413, 33.67831], [-117.99318, 33.67832], [-117.99316, 33.67714], [-117.9951, 33.67712], [-117.99511, 33.67831]]]} | Open Access 1 | 5193 | McCallen Park | 21991 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/mccallen-park.cfm | Orange 3 | 5.812 | McCallen Park | 0 | Local Park 2 | 4 |
6574 | 6574 | 6573 | {"type": "Polygon", "coordinates": [[[-117.95262, 33.66614], [-117.95257, 33.66614], [-117.95256, 33.66584], [-117.95215, 33.66586], [-117.95156, 33.66593], [-117.95157, 33.66564], [-117.95152, 33.66493], [-117.95072, 33.66492], [-117.95046, 33.66512], [-117.95042, 33.66523], [-117.95031, 33.66523], [-117.9502, 33.66514], [-117.9502, 33.66567], [-117.95018, 33.6656], [-117.95014, 33.66553], [-117.95007, 33.66548], [-117.94998, 33.66546], [-117.94957, 33.66546], [-117.94934, 33.66543], [-117.94923, 33.66546], [-117.94917, 33.6655], [-117.94902, 33.66545], [-117.94885, 33.66542], [-117.94914, 33.6644], [-117.94963, 33.66441], [-117.94975, 33.66446], [-117.95008, 33.66446], [-117.95009, 33.66439], [-117.9526, 33.66437], [-117.95262, 33.66614]]]} | Open Access 1 | 3852 | LeBard Park | 21126 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lebard-park.cfm | Orange 3 | 9.388 | LeBard Park | 0 | Local Park 2 | 4 |
6556 | 6556 | 6555 | {"type": "Polygon", "coordinates": [[[-118.01959, 33.71377], [-118.01947, 33.71376], [-118.01937, 33.71373], [-118.01912, 33.71353], [-118.01894, 33.71347], [-118.01878, 33.71345], [-118.01873, 33.7134], [-118.01872, 33.71317], [-118.01876, 33.713], [-118.01873, 33.7129], [-118.01883, 33.71281], [-118.01883, 33.71227], [-118.01904, 33.7123], [-118.01916, 33.71225], [-118.01922, 33.71218], [-118.01956, 33.71218], [-118.01959, 33.71377]]]} | Open Access 1 | 3605 | Lark View Park | 21028 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lark-view-park.cfm | Orange 3 | 2.749 | Lark View Park | 0 | Local Park 2 | 4 |
6456 | 6456 | 6455 | {"type": "Polygon", "coordinates": [[[-117.98765, 33.67267], [-117.98687, 33.67386], [-117.98688, 33.67419], [-117.98733, 33.67419], [-117.98734, 33.67457], [-117.98688, 33.67458], [-117.9869, 33.67599], [-117.98641, 33.67682], [-117.98645, 33.67935], [-117.98583, 33.67934], [-117.98577, 33.6793], [-117.98576, 33.67902], [-117.98573, 33.67883], [-117.98566, 33.67864], [-117.98556, 33.67846], [-117.98544, 33.6783], [-117.98528, 33.67815], [-117.98511, 33.67802], [-117.98486, 33.67788], [-117.98473, 33.67777], [-117.98478, 33.67771], [-117.98439, 33.67729], [-117.98438, 33.67724], [-117.98457, 33.677], [-117.98469, 33.67675], [-117.98473, 33.67649], [-117.98472, 33.67606], [-117.98474, 33.6759], [-117.98479, 33.67575], [-117.98565, 33.67392], [-117.98579, 33.67354], [-117.98585, 33.67328], [-117.98588, 33.67301], [-117.98588, 33.67237], [-117.98765, 33.67236], [-117.98765, 33.67267]]]} | Open Access 1 | 1992 | Bartlett Park | 15843 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bartlett-park.cfm | Orange 3 | 27.756 | Bartlett Park | 0 | Local Park 2 | 4 |
6344 | 6344 | 6343 | {"type": "Polygon", "coordinates": [[[-118.06802, 33.72364], [-118.06785, 33.7239], [-118.06769, 33.72381], [-118.06745, 33.72369], [-118.06762, 33.72346], [-118.06802, 33.72364]]]} | Open Access 1 | 47453 | French Park | 31168 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/french-park.cfm | Orange 3 | 0.334 | French Park | 0 | Local Park 2 | 4 |
6343 | 6343 | 6342 | {"type": "MultiPolygon", "coordinates": [[[[-118.00137, 33.66846], [-118.00124, 33.66851], [-118.00109, 33.66855], [-118.00094, 33.66855], [-118.0009, 33.66854], [-118.00066, 33.668], [-118.00113, 33.66787], [-118.00137, 33.66846]]], [[[-118.00141, 33.66844], [-118.00107, 33.6676], [-118.00128, 33.66748], [-118.00145, 33.66737], [-118.0015, 33.66736], [-118.00154, 33.66739], [-118.0017, 33.66763], [-118.00178, 33.66769], [-118.00192, 33.66772], [-118.00207, 33.6677], [-118.00218, 33.66772], [-118.00232, 33.66779], [-118.00238, 33.66786], [-118.00242, 33.66795], [-118.00241, 33.66808], [-118.00236, 33.66816], [-118.00229, 33.66823], [-118.00219, 33.66827], [-118.00208, 33.66829], [-118.00185, 33.66824], [-118.00172, 33.66825], [-118.00163, 33.66829], [-118.00141, 33.66844]]]]} | Open Access 1 | 47452 | Farquhar Park | 31167 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/farquhar-park.cfm | Orange 3 | 2.802 | Farquhar Park | 0 | Local Park 2 | 4 |
6342 | 6342 | 6341 | {"type": "MultiPolygon", "coordinates": [[[[-117.97078, 33.65111], [-117.96703, 33.65113], [-117.96703, 33.65064], [-117.97069, 33.65061], [-117.97075, 33.65064], [-117.97077, 33.65069], [-117.97078, 33.65111]]], [[[-117.97752, 33.65107], [-117.97529, 33.65108], [-117.97531, 33.65291], [-117.97363, 33.65292], [-117.97364, 33.65408], [-117.97108, 33.6541], [-117.97104, 33.65111], [-117.97111, 33.6511], [-117.9711, 33.65068], [-117.97112, 33.65065], [-117.97116, 33.65062], [-117.97751, 33.65057], [-117.97752, 33.65107]]]]} | Open Access 1 | 47451 | Edison Park | 31166 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/edison-park.cfm | Orange 3 | 39.989 | Edison Park | 0 | Local Park 2 | 4 |
6340 | 6340 | 6339 | {"type": "Polygon", "coordinates": [[[-117.99902, 33.7319], [-117.99897, 33.73195], [-117.99898, 33.73197], [-117.99897, 33.73199], [-117.99899, 33.732], [-117.99897, 33.73202], [-117.99899, 33.73204], [-117.99897, 33.73206], [-117.99899, 33.73208], [-117.99891, 33.73212], [-117.99888, 33.7322], [-117.99871, 33.73219], [-117.99871, 33.73203], [-117.99868, 33.73203], [-117.99867, 33.73198], [-117.99867, 33.73192], [-117.99871, 33.73191], [-117.9987, 33.73161], [-117.99867, 33.73159], [-117.99867, 33.73152], [-117.99877, 33.73152], [-117.99879, 33.73154], [-117.99881, 33.73154], [-117.99881, 33.73152], [-117.99888, 33.73152], [-117.99888, 33.73155], [-117.9989, 33.73155], [-117.99891, 33.73151], [-117.99896, 33.73151], [-117.99895, 33.73156], [-117.99898, 33.73158], [-117.99896, 33.7316], [-117.99898, 33.73161], [-117.99896, 33.73163], [-117.99898, 33.73165], [-117.99897, 33.73166], [-117.99898, 33.73168], [-117.99897, 33.7317], [-117.99899, 33.73172], [-117.99902, 33.73169], [-117.99897, 33.73175], [-117.99898, 33.73177], [-117.99897, 33.73179], [-117.99898, 33.73181], [-117.99897, 33.73183], [-117.99898, 33.73184], [-117.99897, 33.73186], [-117.99898, 33.73188], [-117.99897, 33.7319], [-117.99899, 33.73191], [-117.99902, 33.73188], [-117.99902, 33.7319]]]} | Open Access 1 | 47448 | Boardwalk Park | 31163 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/boardwalk-park.cfm | Orange 3 | 0.461 | Boardwalk Park | 0 | Local Park 2 | 4 |
6339 | 6339 | 6338 | {"type": "Polygon", "coordinates": [[[-118.03212, 33.67979], [-118.02419, 33.67306], [-118.02306, 33.67218], [-118.00691, 33.66057], [-118.00615, 33.65996], [-118.00628, 33.65984], [-118.00705, 33.66045], [-118.02319, 33.67205], [-118.02433, 33.67294], [-118.03211, 33.67955], [-118.03212, 33.67979]]]} | Open Access 1 | 47447 | Bluff Top Park | 31162 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bluff-top-park.cfm | Orange 3 | 14.823 | Bluff Top Park | 0 | Local Park 2 | 4 |
6338 | 6338 | 6337 | {"type": "Polygon", "coordinates": [[[-117.9811, 33.65217], [-117.97985, 33.65217], [-117.97981, 33.65214], [-117.9798, 33.6521], [-117.9798, 33.6516], [-117.97983, 33.65157], [-117.97987, 33.65155], [-117.98043, 33.65155], [-117.98051, 33.65156], [-117.98063, 33.65163], [-117.98073, 33.65163], [-117.98082, 33.6516], [-117.98102, 33.65144], [-117.98109, 33.65136], [-117.9811, 33.65217]]]} | Open Access 1 | 47446 | Bauer Park | 31161 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bauer-park.cfm | Orange 3 | 2.024 | Bauer Park | 0 | Local Park 2 | 4 |
6337 | 6337 | 6336 | {"type": "Polygon", "coordinates": [[[-117.9718, 33.64249], [-117.9714, 33.64287], [-117.97112, 33.64322], [-117.97106, 33.64322], [-117.97105, 33.64195], [-117.9718, 33.64249]]]} | Open Access 1 | 47443 | Banning/Magnolia Park | 31160 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/banning-magnolia-park.cfm | Orange 3 | 1.21 | Banning/Magnolia Park | 0 | Local Park 2 | 4 |
6330 | 6330 | 6329 | {"type": "Polygon", "coordinates": [[[-118.05687, 33.72512], [-118.05686, 33.72528], [-118.05681, 33.72534], [-118.05676, 33.72538], [-118.05667, 33.72539], [-118.0562, 33.7254], [-118.0562, 33.72512], [-118.05687, 33.72512]]]} | Open Access 1 | 47455 | Humboldt Beach | 31169 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/humboldt-beach.cfm | Orange 3 | 0.446 | Humboldt Beach | 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]);