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 = 253 sorted by id descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Hayward Area Recreation and Park District · 74 ✖
DES_TP 1
- Local Park · 74 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12100 | 12100 | 12099 | {"type": "Polygon", "coordinates": [[[-122.02692, 37.71714], [-122.02691, 37.71717], [-122.02654, 37.71755], [-122.02638, 37.71747], [-122.02451, 37.71785], [-122.02432, 37.71778], [-122.02444, 37.71756], [-122.02439, 37.71745], [-122.02463, 37.71737], [-122.02484, 37.71728], [-122.02503, 37.71717], [-122.02482, 37.71695], [-122.02504, 37.7168], [-122.02517, 37.71668], [-122.02554, 37.7163], [-122.0258, 37.71608], [-122.02603, 37.71595], [-122.02615, 37.71591], [-122.02674, 37.71691], [-122.02692, 37.71714]]]} | Open Access 1 | 24934 | Palomares Hills Park | 23366 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 6.072 | Palomares Hills Park | 0 | Local Park 2 | 4 | |
11574 | 11574 | 11573 | {"type": "Polygon", "coordinates": [[[-122.13867, 37.66915], [-122.13747, 37.66972], [-122.13761, 37.66993], [-122.13728, 37.66988], [-122.137, 37.66991], [-122.13688, 37.66873], [-122.13674, 37.66695], [-122.13846, 37.66685], [-122.13867, 37.66915]]]} | Open Access 1 | 23668 | Del Rey Park | 31452 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/Facilities/Facility/Details/Del-Rey-Park-42 | Alameda 17 | 11.244 | Del Rey Park | 0 | Local Park 2 | 4 |
11570 | 11570 | 11569 | {"type": "Polygon", "coordinates": [[[-122.06028, 37.72143], [-122.05949, 37.7214], [-122.05929, 37.72149], [-122.05929, 37.72141], [-122.05922, 37.72128], [-122.05923, 37.72117], [-122.05937, 37.72113], [-122.05955, 37.72111], [-122.06008, 37.72111], [-122.06028, 37.72109], [-122.06028, 37.72143]]]} | Open Access 1 | 23665 | Deerview Park | 18011 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.765 | Deerview Park | 0 | Local Park 2 | 4 | |
9863 | 9863 | 9862 | {"type": "MultiPolygon", "coordinates": [[[[-122.15302, 37.6263], [-122.15283, 37.62659], [-122.1515, 37.6266], [-122.14838, 37.62665], [-122.14826, 37.62667], [-122.14763, 37.62687], [-122.14728, 37.62691], [-122.14546, 37.62688], [-122.14478, 37.62685], [-122.14441, 37.62681], [-122.144, 37.6268], [-122.14248, 37.62687], [-122.14139, 37.62687], [-122.14047, 37.62683], [-122.14027, 37.6268], [-122.13998, 37.62671], [-122.13982, 37.62673], [-122.13956, 37.62689], [-122.13937, 37.62323], [-122.13707, 37.62323], [-122.13704, 37.6234], [-122.13625, 37.62359], [-122.13581, 37.62359], [-122.13521, 37.62378], [-122.13519, 37.62365], [-122.13545, 37.623], [-122.13965, 37.6221], [-122.14706, 37.62481], [-122.14837, 37.62508], [-122.14973, 37.62515], [-122.1508, 37.62499], [-122.15138, 37.62484], [-122.15259, 37.62462], [-122.15302, 37.6263]]], [[[-122.14879, 37.65606], [-122.14479, 37.65609], [-122.14396, 37.65627], [-122.14392, 37.65609], [-122.14392, 37.65591], [-122.14433, 37.64981], [-122.14879, 37.65606]]], [[[-122.16185, 37.6312], [-122.16174, 37.64456], [-122.16171, 37.65587], [-122.16161, 37.65596], [-122.15072, 37.65604], [-122.15069, 37.65593], [-122.15098, 37.65355], [-122.14947, 37.65148], [-122.15252, 37.65117], [-122.15483, 37.65108], [-122.15483, 37.65097], [-122.15538, 37.65153], [-122.15604, 37.65308], [-122.15606, 37.65308], [-122.15555, 37.65077], [-122.15547, 37.65072], [-122.15521, 37.64933], [-122.15539, 37.64918], [-122.15538, 37.64917], [-122.15521, 37.64913], [-122.15538, 37.64891], [-122.15541, 37.64883], [-122.15518, 37.64882], [-122.15504, 37.64871], [-122.15489, 37.64814], [-122.15466, 37.64699], [-122.15488, 37.6468], [-122.15488, 37.64676], [-122.15469, 37.64672], [-122.1544, 37.64599], [-122.15437, 37.64555], [-122.15426, 37.64537], [-122.15389, 37.64384], [-122.1538, 37.64376], [-122.15348, 37.6423], [-122.15368, 37.64213], [-122.15367, 37.64208], [-122.15349, 37.64195], [-122.15351, 37.64192], [-122.15381, 37.64187], [-122.1539, 37.64184], [-122.15408, 37.64173], [-122.15408, 37.64167], [-122.15511, 37.64162], [-122.15521, 37.63118], [-122.16185, 37.6312]]]]} | Open Access 1 | 16897 | Hayward Shoreline | 4363 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 595.87 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
9822 | 9822 | 9821 | {"type": "Polygon", "coordinates": [[[-122.04626, 37.71955], [-122.0462, 37.72191], [-122.0393, 37.71982], [-122.03924, 37.71959], [-122.03905, 37.71948], [-122.03897, 37.71939], [-122.03888, 37.71914], [-122.0387, 37.71893], [-122.03828, 37.71899], [-122.03802, 37.71831], [-122.038, 37.71809], [-122.03802, 37.71793], [-122.03811, 37.71769], [-122.03832, 37.71738], [-122.0384, 37.7174], [-122.0385, 37.71725], [-122.0389, 37.71735], [-122.03988, 37.71744], [-122.04163, 37.71802], [-122.04248, 37.71844], [-122.04626, 37.71955]]]} | Open Access 1 | 16780 | Greenridge Park | 19483 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 45.887 | Greenridge Park | 0 | Local Park 2 | 4 | |
9365 | 9365 | 9364 | {"type": "Polygon", "coordinates": [[[-122.01903, 37.65238], [-122.0182, 37.65246], [-122.01762, 37.65137], [-122.0177, 37.65132], [-122.01782, 37.65088], [-122.01797, 37.65081], [-122.01824, 37.65078], [-122.01828, 37.65093], [-122.01836, 37.65112], [-122.01892, 37.65202], [-122.01899, 37.65217], [-122.01903, 37.65238]]]} | Open Access 1 | 15642 | Jalquin Vista Park | 20339 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.154 | Jalquin Vista Park | 0 | Local Park 2 | 4 | |
9359 | 9359 | 9358 | {"type": "Polygon", "coordinates": [[[-122.04919, 37.62473], [-122.0482, 37.62471], [-122.04819, 37.62468], [-122.04791, 37.62468], [-122.04788, 37.62445], [-122.0478, 37.62426], [-122.04767, 37.62406], [-122.04748, 37.62389], [-122.04746, 37.62381], [-122.04768, 37.62358], [-122.04775, 37.62353], [-122.04789, 37.62346], [-122.04801, 37.62343], [-122.04807, 37.62336], [-122.04842, 37.62324], [-122.04874, 37.62365], [-122.04836, 37.62365], [-122.04835, 37.62367], [-122.04919, 37.62473]]]} | Open Access 1 | 15635 | Twin Bridges Park | 26610 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.296 | Twin Bridges Park | 0 | Local Park 2 | 4 | |
9357 | 9357 | 9356 | {"type": "Polygon", "coordinates": [[[-122.05144, 37.68537], [-122.05131, 37.68541], [-122.05103, 37.68483], [-122.05054, 37.68497], [-122.05009, 37.68402], [-122.04984, 37.68345], [-122.04983, 37.68337], [-122.04959, 37.68288], [-122.05066, 37.68269], [-122.05091, 37.68321], [-122.05088, 37.68323], [-122.05132, 37.6842], [-122.05094, 37.68432], [-122.05144, 37.68537]]]} | Open Access 1 | 15633 | Lakeridge Park | 20970 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.378 | Lakeridge Park | 0 | Local Park 2 | 4 | |
9356 | 9356 | 9355 | {"type": "Polygon", "coordinates": [[[-122.0973, 37.61101], [-122.09726, 37.61092], [-122.09716, 37.61088], [-122.09704, 37.61091], [-122.09652, 37.61092], [-122.09602, 37.61097], [-122.09595, 37.61094], [-122.09593, 37.61088], [-122.09592, 37.61088], [-122.09586, 37.61068], [-122.0958, 37.61058], [-122.09566, 37.61041], [-122.09563, 37.61034], [-122.09562, 37.61025], [-122.09565, 37.61011], [-122.09578, 37.60993], [-122.09582, 37.60984], [-122.09587, 37.60952], [-122.09592, 37.6095], [-122.09706, 37.60948], [-122.09712, 37.60944], [-122.09715, 37.60937], [-122.09712, 37.6093], [-122.09705, 37.60926], [-122.09699, 37.60925], [-122.09692, 37.60926], [-122.09687, 37.60929], [-122.09683, 37.60935], [-122.09677, 37.60937], [-122.09676, 37.60909], [-122.09728, 37.60909], [-122.0973, 37.61101]]]} | Open Access 1 | 15629 | Gordon E. Oliver Eden Shores Park | 19408 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.594 | Gordon E. Oliver Eden Shores Park | 0 | Local Park 2 | 4 | |
9355 | 9355 | 9354 | {"type": "Polygon", "coordinates": [[[-122.02752, 37.6138], [-122.02891, 37.61502], [-122.02891, 37.61505], [-122.02889, 37.61508], [-122.02832, 37.61549], [-122.02815, 37.61565], [-122.02808, 37.61564], [-122.02768, 37.6154], [-122.0275, 37.61532], [-122.02734, 37.61528], [-122.02669, 37.61518], [-122.0265, 37.6151], [-122.02633, 37.61497], [-122.02598, 37.61449], [-122.02752, 37.6138]]]} | Restricted Access 2 | 15628 | El Rancho Verde School Park | 31953 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 6.904 | El Rancho Verde School Park | 0 | Local Park 2 | 4 | |
9354 | 9354 | 9353 | {"type": "Polygon", "coordinates": [[[-122.11964, 37.68374], [-122.11922, 37.684], [-122.11911, 37.68404], [-122.1168, 37.6842], [-122.11595, 37.68321], [-122.11628, 37.683], [-122.11617, 37.68289], [-122.11753, 37.6819], [-122.11964, 37.68374]]]} | Restricted Access 2 | 15626 | Colonial Acres School Park | 31951 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 11.662 | Colonial Acres School Park | 0 | Local Park 2 | 4 | |
9350 | 9350 | 9349 | {"type": "Polygon", "coordinates": [[[-122.10242, 37.62927], [-122.10248, 37.6293], [-122.10346, 37.63089], [-122.10346, 37.63092], [-122.10342, 37.63095], [-122.10209, 37.63146], [-122.10118, 37.63149], [-122.10113, 37.62978], [-122.10242, 37.62927]]]} | Restricted Access 2 | 15620 | Brenkwitz School Park | 31949 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 8.677 | Brenkwitz School Park | 0 | Local Park 2 | 4 | |
9307 | 9307 | 9306 | {"type": "Polygon", "coordinates": [[[-122.12224, 37.67045], [-122.12184, 37.67061], [-122.12193, 37.67077], [-122.12152, 37.67079], [-122.12086, 37.66972], [-122.12161, 37.66942], [-122.12205, 37.67013], [-122.1221, 37.67012], [-122.12222, 37.67031], [-122.12217, 37.67034], [-122.12224, 37.67045]]]} | Open Access 1 | 15513 | Mc Conaghy Park | 21985 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.46 | Mc Conaghy Park | 0 | Local Park 2 | 4 | |
9305 | 9305 | 9304 | {"type": "Polygon", "coordinates": [[[-122.12445, 37.69399], [-122.12425, 37.69399], [-122.12416, 37.69402], [-122.12319, 37.69335], [-122.12328, 37.69327], [-122.12338, 37.69313], [-122.12363, 37.69319], [-122.12373, 37.69323], [-122.12373, 37.69341], [-122.12384, 37.69341], [-122.12385, 37.69364], [-122.12407, 37.69364], [-122.12415, 37.6937], [-122.12445, 37.69371], [-122.12445, 37.69399]]]} | Open Access 1 | 15510 | Hesperian Park | 19883 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.934 | Hesperian Park | 0 | Local Park 2 | 4 | |
9156 | 9156 | 9155 | {"type": "Polygon", "coordinates": [[[-122.12275, 37.71119], [-122.12138, 37.71191], [-122.12132, 37.71201], [-122.12132, 37.71212], [-122.12152, 37.71278], [-122.12137, 37.7128], [-122.12105, 37.71205], [-122.12101, 37.71185], [-122.12098, 37.71155], [-122.12107, 37.71113], [-122.12151, 37.71046], [-122.12275, 37.71119]]]} | Open Access 1 | 15194 | Hillcrest Knolls Park | 19966 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.813 | Hillcrest Knolls Park | 0 | Local Park 2 | 4 | |
9155 | 9155 | 9154 | {"type": "Polygon", "coordinates": [[[-122.11417, 37.70787], [-122.11417, 37.70787], [-122.11329, 37.70866], [-122.11332, 37.70842], [-122.11328, 37.70824], [-122.1132, 37.70811], [-122.11301, 37.70804], [-122.11304, 37.70766], [-122.11417, 37.70787]]]} | Open Access 1 | 15191 | Fairmont Terrace Park | 18809 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.269 | Fairmont Terrace Park | 0 | Local Park 2 | 4 | |
9154 | 9154 | 9153 | {"type": "Polygon", "coordinates": [[[-122.12555, 37.70411], [-122.12363, 37.70561], [-122.12383, 37.70583], [-122.12339, 37.70622], [-122.12336, 37.70621], [-122.12346, 37.7058], [-122.12372, 37.70537], [-122.12391, 37.70519], [-122.12547, 37.70402], [-122.12555, 37.70411]]]} | Open Access 1 | 15189 | Fairmont Linear Park | 18804 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.132 | Fairmont Linear Park | 0 | Local Park 2 | 4 | |
9145 | 9145 | 9144 | {"type": "Polygon", "coordinates": [[[-122.11882, 37.69374], [-122.1188, 37.69506], [-122.11701, 37.69506], [-122.117, 37.6955], [-122.11632, 37.69548], [-122.11631, 37.6952], [-122.11528, 37.69519], [-122.11529, 37.6942], [-122.11632, 37.69421], [-122.11633, 37.69398], [-122.11717, 37.69399], [-122.11718, 37.69373], [-122.11882, 37.69374]]]} | Open Access 1 | 15174 | Edendale Park | 18430 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 10.673 | Edendale Park | 0 | Local Park 2 | 4 | |
9143 | 9143 | 9142 | {"type": "Polygon", "coordinates": [[[-122.10782, 37.69342], [-122.10723, 37.69384], [-122.107, 37.69365], [-122.10684, 37.69376], [-122.1067, 37.69364], [-122.10697, 37.69343], [-122.10661, 37.69311], [-122.10689, 37.6929], [-122.10691, 37.69291], [-122.10694, 37.69288], [-122.10694, 37.69286], [-122.10699, 37.69283], [-122.10782, 37.69342]]]} | Open Access 1 | 15171 | Ashland Park | 15654 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 1.486 | Ashland Park | 0 | Local Park 2 | 4 | |
9140 | 9140 | 9139 | {"type": "Polygon", "coordinates": [[[-122.08616, 37.71826], [-122.08524, 37.71962], [-122.0845, 37.71944], [-122.0848, 37.71885], [-122.08526, 37.71821], [-122.08533, 37.718], [-122.08568, 37.71799], [-122.08581, 37.71803], [-122.08595, 37.7181], [-122.08616, 37.71826]]]} | Open Access 1 | 15168 | Parsons Park | 23483 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.279 | Parsons 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]);