units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where ACCESS_TYP = 1 and MNG_AGENCY = 122 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 76 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5612 | 5612 | 5611 | {"type": "Polygon", "coordinates": [[[-118.00466, 33.674], [-118.00464, 33.67403], [-118.00463, 33.67443], [-118.00344, 33.67443], [-118.00346, 33.6756], [-118.00191, 33.67561], [-118.00186, 33.6756], [-118.00182, 33.67556], [-118.00181, 33.67537], [-118.00192, 33.67525], [-118.00191, 33.67523], [-118.00381, 33.67338], [-118.00466, 33.674]]]} | Open Access 1 | 47464 | Worthy Park | 31176 | 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/worthy-park.cfm | Orange 3 | 6.81 | Worthy Park | 0 | Local Park 2 | 4 |
5611 | 5611 | 5610 | {"type": "MultiPolygon", "coordinates": [[[[-118.06674, 33.71358], [-118.06655, 33.71373], [-118.06602, 33.71326], [-118.06598, 33.71328], [-118.06503, 33.71281], [-118.06376, 33.71169], [-118.0646, 33.71169], [-118.06674, 33.71358]]], [[[-118.07854, 33.72399], [-118.07834, 33.72413], [-118.06662, 33.7138], [-118.06682, 33.71365], [-118.07854, 33.72399]]]]} | Open Access 1 | 47463 | Sunset Beach Greenbelt | 31175 | 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 | 12.999 | Sunset Beach Greenbelt | 0 | Local Recreation Area 3 | 4 | |
4087 | 4087 | 4086 | {"type": "Polygon", "coordinates": [[[-117.99766, 33.65576], [-117.99763, 33.65581], [-117.99719, 33.65622], [-117.99604, 33.65577], [-117.99615, 33.65556], [-117.99634, 33.65525], [-117.99638, 33.65514], [-117.9971, 33.65543], [-117.99742, 33.65561], [-117.99766, 33.65576]]]} | Open Access 1 | 47461 | Pacific City Park | 31173 | 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.339 | Pacific City Park | 0 | Local Park 2 | 4 | |
4086 | 4086 | 4085 | {"type": "Polygon", "coordinates": [[[-117.95161, 33.68111], [-117.95086, 33.68111], [-117.95084, 33.67975], [-117.95159, 33.67974], [-117.95161, 33.68111]]]} | Open Access 1 | 47458 | Lamb Park | 31172 | 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/lamb-park.cfm | Orange 3 | 2.599 | Lamb 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 |
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 |
4138 | 4138 | 4137 | {"type": "Polygon", "coordinates": [[[-118.0585, 33.7167], [-118.05849, 33.71686], [-118.05845, 33.71692], [-118.0584, 33.71695], [-118.05831, 33.71697], [-118.05784, 33.71697], [-118.05784, 33.7167], [-118.0585, 33.7167]]]} | Open Access 1 | 47450 | Davenport Beach Park | 31164 | 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/davenport-beach-park.cfm | Orange 3 | 0.443 | Davenport Beach 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 |
5269 | 5269 | 5268 | {"type": "Polygon", "coordinates": [[[-117.9999, 33.66174], [-117.9991, 33.66252], [-117.99902, 33.66247], [-117.99902, 33.66178], [-117.99905, 33.66172], [-117.99913, 33.66169], [-117.9993, 33.66173], [-117.99953, 33.66176], [-117.99971, 33.66176], [-117.9999, 33.66174]]]} | Open Access 1 | 47379 | Triangle Park | 31102 | 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/triangle-park.cfm | Orange 3 | 0.929 | Triangle Park | 0 | Local Park 2 | 4 |
12902 | 12902 | 12901 | {"type": "Polygon", "coordinates": [[[-118.06732, 33.72058], [-118.06761, 33.721], [-118.06762, 33.72106], [-118.06761, 33.7211], [-118.06754, 33.72114], [-118.06743, 33.72114], [-118.06703, 33.72096], [-118.06732, 33.72058]]]} | Open Access 1 | 30355 | Tarbox Park | 26189 | 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 | 0.434 | Tarbox Park | 0 | Local Park 2 | 4 | |
12901 | 12901 | 12900 | {"type": "Polygon", "coordinates": [[[-118.07112, 33.7252], [-118.07073, 33.72527], [-118.07071, 33.72521], [-118.07066, 33.72516], [-118.07086, 33.72496], [-118.07101, 33.72503], [-118.07104, 33.72506], [-118.07109, 33.72512], [-118.07112, 33.7252]]]} | Open Access 1 | 30354 | Prince Park | 24007 | 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 | 0.218 | Prince Park | 0 | Local Park 2 | 4 | |
12900 | 12900 | 12899 | {"type": "Polygon", "coordinates": [[[-118.00009, 33.6893], [-117.99911, 33.69028], [-117.99831, 33.68971], [-117.99828, 33.68967], [-117.99828, 33.68963], [-117.9983, 33.6896], [-117.99894, 33.68898], [-117.99921, 33.68877], [-117.99957, 33.68859], [-118.00009, 33.6893]]]} | Open Access 1 | 30353 | Green Park | 19465 | 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/green-park.cfm | Orange 3 | 3.999 | Green Park | 0 | Local Park 2 | 4 |
12899 | 12899 | 12898 | {"type": "Polygon", "coordinates": [[[-118.06828, 33.72459], [-118.06804, 33.72464], [-118.06803, 33.72458], [-118.06796, 33.72452], [-118.06789, 33.72451], [-118.0678, 33.72454], [-118.06773, 33.72449], [-118.06743, 33.72457], [-118.06714, 33.7247], [-118.06707, 33.72464], [-118.06699, 33.72463], [-118.06694, 33.72464], [-118.06688, 33.72468], [-118.06685, 33.72474], [-118.06655, 33.72482], [-118.0666, 33.72492], [-118.06633, 33.72499], [-118.06631, 33.72503], [-118.06623, 33.72502], [-118.06616, 33.72505], [-118.06612, 33.72508], [-118.06609, 33.72514], [-118.06612, 33.72522], [-118.06592, 33.7253], [-118.06555, 33.7253], [-118.06555, 33.72559], [-118.06499, 33.72559], [-118.065, 33.72549], [-118.06519, 33.72548], [-118.06531, 33.72529], [-118.06529, 33.72524], [-118.06536, 33.7252], [-118.06539, 33.72515], [-118.06546, 33.72516], [-118.06572, 33.72507], [-118.06594, 33.7249], [-118.06594, 33.72485], [-118.066, 33.72483], [-118.06605, 33.7248], [-118.0662, 33.72481], [-118.06648, 33.72463], [-118.06662, 33.7244], [-118.06668, 33.72441], [-118.06676, 33.72439], [-118.0668, 33.72437], [-118.06683, 33.72431], [-118.06696, 33.72427], [-118.06712, 33.72403], [-118.06733, 33.72412], [-118.06749, 33.72388], [-118.06775, 33.72403], [-118.06759, 33.72427], [-118.06828, 33.72459]]]} | Open Access 1 | 30352 | Conrad Park | 17595 | 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/conrad-park.cfm | Orange 3 | 2.752 | Conrad Park | 0 | Local Park 2 | 4 |
12896 | 12896 | 12895 | {"type": "Polygon", "coordinates": [[[-118.06, 33.71724], [-118.05953, 33.71725], [-118.05952, 33.71646], [-118.05955, 33.71643], [-118.05972, 33.71641], [-118.05999, 33.71707], [-118.06, 33.71724]]]} | Open Access 1 | 30351 | Booster Park | 16274 | 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/booster-park.cfm | Orange 3 | 0.752 | Booster Park | 0 | Local Park 2 | 4 |
2915 | 2915 | 2914 | {"type": "Polygon", "coordinates": [[[-118.06599, 33.72644], [-118.06594, 33.72672], [-118.06559, 33.72665], [-118.06532, 33.72665], [-118.06529, 33.72668], [-118.06529, 33.72581], [-118.06531, 33.72576], [-118.06531, 33.72601], [-118.06556, 33.72602], [-118.06556, 33.72627], [-118.06565, 33.72631], [-118.06564, 33.72637], [-118.06569, 33.72645], [-118.06573, 33.72647], [-118.0658, 33.72648], [-118.06599, 33.72644]]]} | Open Access 1 | 19008 | Trinidad Park | 26539 | 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/trinidad-park.cfm | Orange 3 | 0.722 | Trinidad 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]);