units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where DES_TP = 2, LAYER = 2 and MNG_AGENCY = 429
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 20
MNG_AGENCY 1
- Foster City, City of · 20 ✖
DES_TP 1
- Local Park · 20 ✖
ACCESS_TYP 1
- Open Access 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1861 | 1861 | 1860 | {"type": "Polygon", "coordinates": [[[-122.26088, 37.56684], [-122.26085, 37.5669], [-122.26054, 37.56681], [-122.26027, 37.56733], [-122.26011, 37.56728], [-122.25951, 37.56706], [-122.25907, 37.56688], [-122.2594, 37.5664], [-122.2591, 37.56626], [-122.25914, 37.56621], [-122.25944, 37.56634], [-122.25968, 37.566], [-122.26038, 37.56628], [-122.26074, 37.5664], [-122.26056, 37.56675], [-122.26088, 37.56684]]]} | Open Access 1 | 14244 | Gull Park | 19566 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 3.159 | Gull Park | 1960 | Local Park 2 | 4 | |
1864 | 1864 | 1863 | {"type": "Polygon", "coordinates": [[[-122.25871, 37.55141], [-122.25744, 37.55142], [-122.25742, 37.5509], [-122.25749, 37.55086], [-122.2587, 37.55088], [-122.25871, 37.55141]]]} | Open Access 1 | 14263 | Ketch Park | 20636 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 1.671 | Ketch Park | 1960 | Local Park 2 | 4 | |
2186 | 2186 | 2185 | {"type": "Polygon", "coordinates": [[[-122.26756, 37.54579], [-122.26754, 37.54605], [-122.26759, 37.54627], [-122.26767, 37.54645], [-122.26789, 37.54678], [-122.26789, 37.54681], [-122.26787, 37.54685], [-122.26762, 37.54698], [-122.26738, 37.54713], [-122.26735, 37.5469], [-122.26726, 37.54673], [-122.26715, 37.54675], [-122.26697, 37.5469], [-122.26693, 37.54688], [-122.26703, 37.5467], [-122.267, 37.54658], [-122.26669, 37.54662], [-122.26656, 37.54672], [-122.2663, 37.54698], [-122.26624, 37.54693], [-122.26625, 37.54663], [-122.26622, 37.54633], [-122.26588, 37.54635], [-122.26587, 37.54632], [-122.26622, 37.54629], [-122.26612, 37.5457], [-122.26616, 37.54559], [-122.2663, 37.54563], [-122.26642, 37.54575], [-122.26659, 37.54581], [-122.26677, 37.54577], [-122.2667, 37.54553], [-122.26673, 37.54553], [-122.26685, 37.54576], [-122.26712, 37.54568], [-122.26724, 37.54575], [-122.26756, 37.54579]]]} | Open Access 1 | 16368 | Farragut Park | 18849 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 3.884 | Farragut Park | 1960 | Local Park 2 | 4 | |
2435 | 2435 | 2434 | {"type": "Polygon", "coordinates": [[[-122.27629, 37.5549], [-122.27232, 37.55743], [-122.27207, 37.55762], [-122.27184, 37.55782], [-122.27157, 37.55808], [-122.27139, 37.5583], [-122.27135, 37.55833], [-122.27129, 37.55831], [-122.26823, 37.5567], [-122.26734, 37.55628], [-122.26822, 37.55528], [-122.27045, 37.55653], [-122.27036, 37.55664], [-122.27051, 37.55672], [-122.27071, 37.55679], [-122.27091, 37.55684], [-122.27113, 37.55686], [-122.27154, 37.55682], [-122.27217, 37.55671], [-122.27277, 37.55653], [-122.27334, 37.5563], [-122.27388, 37.55601], [-122.27451, 37.55557], [-122.27464, 37.55546], [-122.27479, 37.5553], [-122.27492, 37.55512], [-122.275, 37.55495], [-122.27507, 37.55479], [-122.27511, 37.55463], [-122.27513, 37.55443], [-122.27511, 37.55418], [-122.27506, 37.55399], [-122.27497, 37.55377], [-122.27508, 37.55371], [-122.27629, 37.5549]]]} | Open Access 1 | 17338 | Leo J. Ryan Park | 21167 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 20.78 | Leo J. Ryan Park | 1960 | Local Park 2 | 4 | |
5362 | 5362 | 5361 | {"type": "Polygon", "coordinates": [[[-122.26667, 37.55339], [-122.26613, 37.55359], [-122.26589, 37.55364], [-122.2657, 37.55364], [-122.26551, 37.55361], [-122.26533, 37.55357], [-122.26465, 37.55326], [-122.26445, 37.55324], [-122.26427, 37.55327], [-122.26418, 37.55308], [-122.26394, 37.55276], [-122.26379, 37.55232], [-122.26385, 37.55227], [-122.26441, 37.55222], [-122.26469, 37.55224], [-122.26492, 37.55231], [-122.26512, 37.55239], [-122.26557, 37.55267], [-122.26592, 37.55283], [-122.26626, 37.55293], [-122.26664, 37.55294], [-122.26667, 37.55339]]]} | Open Access 1 | 9157 | Catamaran Park | 16970 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 5.812 | Catamaran Park | 1960 | Local Park 2 | 4 | |
5995 | 5995 | 5994 | {"type": "Polygon", "coordinates": [[[-122.26014, 37.54346], [-122.26, 37.54363], [-122.25989, 37.54381], [-122.2598, 37.54401], [-122.25974, 37.54419], [-122.2597, 37.54439], [-122.25969, 37.54459], [-122.2597, 37.54476], [-122.25974, 37.54503], [-122.25647, 37.54529], [-122.25623, 37.54536], [-122.25612, 37.54542], [-122.256, 37.54551], [-122.25586, 37.54569], [-122.25579, 37.54589], [-122.25438, 37.54592], [-122.25438, 37.54587], [-122.25416, 37.54548], [-122.25403, 37.54468], [-122.25357, 37.54315], [-122.2529, 37.54271], [-122.25251, 37.54214], [-122.25255, 37.5419], [-122.25271, 37.54167], [-122.25296, 37.54153], [-122.25331, 37.54146], [-122.2541, 37.5416], [-122.25625, 37.5417], [-122.25741, 37.5436], [-122.25775, 37.54348], [-122.2581, 37.54339], [-122.25837, 37.54334], [-122.25876, 37.54331], [-122.25937, 37.5433], [-122.25979, 37.54332], [-122.25996, 37.54335], [-122.26014, 37.54346]]]} | Open Access 1 | 606 | Sea Cloud Park | 25233 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 45.319 | Sea Cloud Park | 1960 | Local Park 2 | 4 | |
6443 | 6443 | 6442 | {"type": "Polygon", "coordinates": [[[-122.26129, 37.53945], [-122.26074, 37.54033], [-122.26064, 37.54054], [-122.26054, 37.54086], [-122.26051, 37.54088], [-122.26046, 37.54087], [-122.26047, 37.54051], [-122.26022, 37.54044], [-122.26036, 37.54028], [-122.26047, 37.54011], [-122.26069, 37.53988], [-122.26071, 37.53935], [-122.26089, 37.53935], [-122.26095, 37.53933], [-122.26107, 37.53938], [-122.26112, 37.53937], [-122.26129, 37.53945]]]} | Open Access 1 | 48899 | Gateshead Park | 33616 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | https://www.fostercity.org/parksrec/page/gateshead-park | San Mateo 15 | 1.305 | Gateshead Park | 0 | Local Park 2 | 4 |
6726 | 6726 | 6725 | {"type": "Polygon", "coordinates": [[[-122.2744, 37.53882], [-122.27429, 37.53922], [-122.27394, 37.5396], [-122.27371, 37.53981], [-122.27344, 37.54002], [-122.27319, 37.5402], [-122.27289, 37.54033], [-122.27256, 37.54041], [-122.27215, 37.54042], [-122.27189, 37.54045], [-122.27175, 37.53971], [-122.27211, 37.53956], [-122.2723, 37.53911], [-122.27226, 37.53891], [-122.27198, 37.53865], [-122.27178, 37.5385], [-122.27191, 37.53831], [-122.27335, 37.53804], [-122.27363, 37.5385], [-122.2738, 37.53869], [-122.27405, 37.53881], [-122.2744, 37.53882]]]} | Open Access 1 | 5048 | Boothbay Park | 33374 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 9.682 | Boothbay Park | 1960 | Local Park 2 | 4 | |
8761 | 8761 | 8760 | {"type": "Polygon", "coordinates": [[[-122.26189, 37.56921], [-122.26184, 37.56924], [-122.26163, 37.56906], [-122.26128, 37.56917], [-122.26111, 37.56919], [-122.2607, 37.56905], [-122.26001, 37.56867], [-122.25979, 37.5687], [-122.25973, 37.56867], [-122.25954, 37.56889], [-122.25947, 37.56886], [-122.25966, 37.56863], [-122.2587, 37.56809], [-122.25877, 37.56798], [-122.25943, 37.56823], [-122.26014, 37.56846], [-122.26026, 37.56821], [-122.26036, 37.56823], [-122.26025, 37.56849], [-122.26101, 37.56868], [-122.26174, 37.5689], [-122.26165, 37.56901], [-122.26189, 37.56921]]]} | Open Access 1 | 14242 | Killdeer Park | 20641 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 2.463 | Killdeer Park | 1960 | Local Park 2 | 4 | |
8762 | 8762 | 8761 | {"type": "Polygon", "coordinates": [[[-122.26128, 37.56309], [-122.26073, 37.56389], [-122.26066, 37.56358], [-122.2605, 37.5634], [-122.26023, 37.56327], [-122.26007, 37.56325], [-122.2598, 37.56326], [-122.25977, 37.56332], [-122.25965, 37.56326], [-122.2605, 37.56261], [-122.26128, 37.56309]]]} | Open Access 1 | 14246 | Erckenbrack Park | 18693 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 1.996 | Erckenbrack Park | 1960 | Local Park 2 | 4 | |
8763 | 8763 | 8762 | {"type": "Polygon", "coordinates": [[[-122.25619, 37.56663], [-122.25615, 37.56668], [-122.25493, 37.566], [-122.25472, 37.56621], [-122.25467, 37.56618], [-122.25486, 37.56596], [-122.25438, 37.56569], [-122.25405, 37.56523], [-122.25431, 37.56511], [-122.25416, 37.56488], [-122.25422, 37.56486], [-122.25457, 37.56536], [-122.25508, 37.56571], [-122.25535, 37.56554], [-122.25539, 37.56558], [-122.25515, 37.56574], [-122.25515, 37.56576], [-122.25559, 37.56623], [-122.25588, 37.56645], [-122.25619, 37.56663]]]} | Open Access 1 | 14248 | Turnstone Park | 26586 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 1.577 | Turnstone Park | 1960 | Local Park 2 | 4 | |
8764 | 8764 | 8763 | {"type": "Polygon", "coordinates": [[[-122.25288, 37.56293], [-122.25282, 37.56295], [-122.25268, 37.56272], [-122.25195, 37.56191], [-122.25172, 37.56183], [-122.25164, 37.5617], [-122.25133, 37.56181], [-122.2513, 37.56176], [-122.2516, 37.56164], [-122.25153, 37.56151], [-122.25159, 37.5613], [-122.25124, 37.56071], [-122.25154, 37.56068], [-122.25151, 37.56043], [-122.25158, 37.56042], [-122.25162, 37.56068], [-122.2518, 37.56066], [-122.25194, 37.56117], [-122.2523, 37.56141], [-122.25264, 37.56135], [-122.25266, 37.56142], [-122.25233, 37.56147], [-122.25218, 37.56196], [-122.25274, 37.56269], [-122.25288, 37.56293]]]} | Open Access 1 | 14250 | Shad Park | 25334 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 2.146 | Shad Park | 1960 | Local Park 2 | 4 | |
8765 | 8765 | 8764 | {"type": "Polygon", "coordinates": [[[-122.2547, 37.55831], [-122.25465, 37.55877], [-122.25463, 37.55924], [-122.25416, 37.55924], [-122.25416, 37.55951], [-122.25409, 37.55951], [-122.25408, 37.55924], [-122.25337, 37.55923], [-122.25339, 37.55871], [-122.25344, 37.55819], [-122.25417, 37.55826], [-122.2542, 37.55807], [-122.25427, 37.55807], [-122.25425, 37.55827], [-122.2547, 37.55831]]]} | Open Access 1 | 14251 | Marlin Park | 21879 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 3.114 | Marlin Park | 0 | Local Park 2 | 4 | |
8768 | 8768 | 8767 | {"type": "Polygon", "coordinates": [[[-122.25276, 37.55669], [-122.25273, 37.55678], [-122.25207, 37.55644], [-122.25185, 37.5564], [-122.25178, 37.55664], [-122.2517, 37.55663], [-122.25174, 37.55639], [-122.25126, 37.5563], [-122.25133, 37.55601], [-122.25093, 37.55594], [-122.25095, 37.55587], [-122.25134, 37.55594], [-122.25138, 37.5558], [-122.25173, 37.55554], [-122.25191, 37.5553], [-122.25215, 37.55538], [-122.25229, 37.55515], [-122.25237, 37.55517], [-122.25223, 37.55541], [-122.2524, 37.55547], [-122.25215, 37.55621], [-122.25276, 37.55669]]]} | Open Access 1 | 14258 | Sunfish Park | 25991 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 2.426 | Sunfish Park | 0 | Local Park 2 | 4 | |
8769 | 8769 | 8768 | {"type": "Polygon", "coordinates": [[[-122.25234, 37.55901], [-122.25233, 37.55918], [-122.25149, 37.5593], [-122.25149, 37.55887], [-122.25234, 37.55901]]]} | Open Access 1 | 14260 | Pompano Park | 23882 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 0.614 | Pompano Park | 1960 | Local Park 2 | 4 | |
8770 | 8770 | 8769 | {"type": "Polygon", "coordinates": [[[-122.27718, 37.54734], [-122.2769, 37.54751], [-122.27701, 37.54762], [-122.27708, 37.54794], [-122.27676, 37.54799], [-122.2767, 37.54795], [-122.27663, 37.54795], [-122.2766, 37.54792], [-122.27652, 37.54781], [-122.27647, 37.54767], [-122.27615, 37.54769], [-122.27614, 37.54764], [-122.27646, 37.54762], [-122.27649, 37.54748], [-122.27657, 37.54734], [-122.27685, 37.54746], [-122.2771, 37.54731], [-122.27718, 37.54734]]]} | Open Access 1 | 14262 | Arcturus Park | 15575 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 0.745 | Arcturus Park | 1960 | Local Park 2 | 4 | |
8771 | 8771 | 8770 | {"type": "Polygon", "coordinates": [[[-122.26755, 37.53599], [-122.26749, 37.53604], [-122.26705, 37.53603], [-122.26663, 37.53611], [-122.26658, 37.53606], [-122.2667, 37.53594], [-122.26627, 37.5355], [-122.26591, 37.53526], [-122.26573, 37.53511], [-122.26562, 37.53495], [-122.26563, 37.53488], [-122.26603, 37.53456], [-122.2662, 37.53446], [-122.26654, 37.53444], [-122.26694, 37.5351], [-122.26755, 37.53599]]]} | Open Access 1 | 14265 | Port Royal Park | 23897 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 3.691 | Port Royal Park | 1960 | Local Park 2 | 4 | |
8772 | 8772 | 8771 | {"type": "Polygon", "coordinates": [[[-122.26116, 37.55597], [-122.26076, 37.55641], [-122.26065, 37.55645], [-122.26056, 37.55642], [-122.25942, 37.55578], [-122.26003, 37.55516], [-122.26043, 37.55543], [-122.26037, 37.5555], [-122.26037, 37.55551], [-122.26116, 37.55597]]]} | Open Access 1 | 14267 | Boat Park | 16205 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 2.547 | Boat Park | 1960 | Local Park 2 | 4 | |
8773 | 8773 | 8772 | {"type": "Polygon", "coordinates": [[[-122.28012, 37.55211], [-122.27989, 37.5524], [-122.27968, 37.55259], [-122.27958, 37.55252], [-122.27975, 37.5524], [-122.28, 37.55204], [-122.28012, 37.55211]]]} | Open Access 1 | 14269 | Leo Park | 21169 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 0.189 | Leo Park | 1960 | Local Park 2 | 4 | |
9490 | 9490 | 9489 | {"type": "Polygon", "coordinates": [[[-122.27653, 37.54926], [-122.27598, 37.5498], [-122.27574, 37.54998], [-122.27544, 37.55014], [-122.27559, 37.55037], [-122.27533, 37.55047], [-122.27506, 37.55054], [-122.27479, 37.55059], [-122.27475, 37.55059], [-122.27471, 37.55057], [-122.27469, 37.55038], [-122.27467, 37.55013], [-122.2747, 37.5497], [-122.27469, 37.54944], [-122.27465, 37.54912], [-122.27457, 37.54884], [-122.27538, 37.54842], [-122.27555, 37.54861], [-122.27572, 37.54875], [-122.27653, 37.54926]]]} | Open Access 1 | 15895 | Edgewater Park | 18437 | 1110 | Foster City, City of 435 | City 2 | City Agency 2 | http://www.fostercity.org/parksandrecreation/index.cfm | City 2 | 1110 | Foster City, City of 429 | City 2 | City Agency 2 | San Mateo 15 | 5.904 | Edgewater Park | 1960 | 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]);