units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where AGNCY_TYP = 3 and MNG_AGENCY = 543 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11133 | 11133 | 11132 | {"type": "Polygon", "coordinates": [[[-121.51691, 38.25947], [-121.50965, 38.26426], [-121.5083, 38.26215], [-121.50771, 38.26135], [-121.5073, 38.26083], [-121.50498, 38.25966], [-121.50269, 38.25821], [-121.5029, 38.25787], [-121.50312, 38.25794], [-121.50676, 38.25202], [-121.50862, 38.25131], [-121.50878, 38.25131], [-121.50893, 38.25149], [-121.50982, 38.25136], [-121.5103, 38.25196], [-121.51058, 38.25188], [-121.51111, 38.25283], [-121.51144, 38.25331], [-121.5121, 38.2541], [-121.51264, 38.25478], [-121.51317, 38.25533], [-121.51401, 38.25612], [-121.51486, 38.25683], [-121.51562, 38.2574], [-121.51648, 38.25796], [-121.51562, 38.25854], [-121.51691, 38.25947]]]} | Restricted Access 2 | 21424 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 229.043 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2959 | 2959 | 2958 | {"type": "Polygon", "coordinates": [[[-121.49409, 38.57564], [-121.49312, 38.57765], [-121.48768, 38.57619], [-121.48856, 38.57417], [-121.49409, 38.57564]]]} | Open Access 1 | 20463 | Capitol Park | 16837 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 29.711 | Capitol Park | 0 | Local Park 2 | 4 | |
11202 | 11202 | 11201 | {"type": "Polygon", "coordinates": [[[-121.48774, 38.4088], [-121.48772, 38.40888], [-121.48765, 38.40901], [-121.48756, 38.4091], [-121.48745, 38.40917], [-121.48727, 38.40925], [-121.48678, 38.40939], [-121.48637, 38.40956], [-121.48599, 38.40978], [-121.48562, 38.41006], [-121.48533, 38.41036], [-121.48511, 38.41068], [-121.48492, 38.41107], [-121.48483, 38.4114], [-121.48435, 38.4089], [-121.48598, 38.40887], [-121.48656, 38.40882], [-121.48774, 38.4088]]]} | Restricted Access 2 | 21496 | Stone Lakes | 25873 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 7.901 | Stone Lakes | None 977 | |||
12721 | 12721 | 12720 | {"type": "Polygon", "coordinates": [[[-121.47555, 38.71878], [-121.47552, 38.72178], [-121.46828, 38.72174], [-121.46826, 38.72114], [-121.46717, 38.72113], [-121.46676, 38.72043], [-121.4667, 38.71688], [-121.46714, 38.71688], [-121.4703, 38.71814], [-121.47269, 38.71821], [-121.47338, 38.71804], [-121.47357, 38.71801], [-121.47382, 38.71806], [-121.47385, 38.71834], [-121.47392, 38.71846], [-121.47403, 38.71853], [-121.47462, 38.71871], [-121.47493, 38.71874], [-121.47515, 38.71868], [-121.47537, 38.71871], [-121.47555, 38.71878]]]} | Open Access 1 | 29740 | Ponderosa Farm Community Park | 23885 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 77.173 | Ponderosa Farm Community Park | 0 | Local Park 2 | 4 | |
11410 | 11410 | 11409 | {"type": "Polygon", "coordinates": [[[-121.45132, 38.38301], [-121.45064, 38.38333], [-121.45063, 38.38332], [-121.45032, 38.38293], [-121.44997, 38.38258], [-121.44967, 38.38233], [-121.44924, 38.38204], [-121.44983, 38.3814], [-121.45112, 38.3813], [-121.45132, 38.38301]]]} | Restricted Access 2 | 22247 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.273 | Kenneth Way Drainage | None 1008 | |||
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | 22246 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.025 | Hood-Franklin Drainage | None 266 | |||
3118 | 3118 | 3117 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44944, 38.40612], [-121.44612, 38.40611], [-121.44612, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | 21488 | Laguna Lake Drainage | 20858 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 15.913 | Laguna Lake Drainage | None 255 | |||
11411 | 11411 | 11410 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | 22248 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.291 | Lotus Pond Drainage | 0 | Local Other or Unknown 14 | 4 | |
11376 | 11376 | 11375 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71543], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | 22186 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.539 | Atreule Et Al Community Plan | None 1000 | |||
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.37929, 38.26206], [-121.37925, 38.26667], [-121.36993, 38.26662], [-121.36997, 38.26204], [-121.37929, 38.26206]]]} | Restricted Access 2 | 21423 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 102.78 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2871 | 2871 | 2870 | {"type": "Polygon", "coordinates": [[[-121.35463, 38.5704], [-121.35403, 38.57048], [-121.35403, 38.57049], [-121.35418, 38.57064], [-121.35335, 38.57103], [-121.35193, 38.56789], [-121.3508, 38.56544], [-121.35129, 38.5652], [-121.35141, 38.56534], [-121.35162, 38.56568], [-121.35254, 38.56755], [-121.35262, 38.56769], [-121.35291, 38.56809], [-121.35322, 38.56887], [-121.35369, 38.5699], [-121.35378, 38.57004], [-121.354, 38.57024], [-121.35417, 38.57033], [-121.3544, 38.5704], [-121.35463, 38.5704]]]} | Open Access 1 | 22213 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 10.921 | County Of Sacramento | None 239 | |||
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
11194 | 11194 | 11193 | {"type": "Polygon", "coordinates": [[[-121.35327, 38.45636], [-121.35322, 38.45992], [-121.35131, 38.45992], [-121.3513, 38.45977], [-121.35097, 38.45977], [-121.35102, 38.45972], [-121.35104, 38.45966], [-121.35101, 38.45955], [-121.35101, 38.45909], [-121.35105, 38.45881], [-121.35101, 38.45853], [-121.35101, 38.45828], [-121.35103, 38.45815], [-121.35115, 38.45772], [-121.35118, 38.45754], [-121.35122, 38.45751], [-121.35151, 38.45747], [-121.35171, 38.4574], [-121.3519, 38.45729], [-121.35207, 38.45714], [-121.35219, 38.45698], [-121.35227, 38.45677], [-121.35228, 38.45663], [-121.35226, 38.45636], [-121.35327, 38.45636]]]} | Restricted Access 2 | 21470 | D R Horton Inc Sacramento | 17889 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 15.774 | D R Horton Inc Sacramento | None 976 | |||
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.33438, 38.34361], [-121.33319, 38.34464], [-121.33304, 38.34475], [-121.33156, 38.34376], [-121.32059, 38.34373], [-121.31587, 38.3413], [-121.31593, 38.33691], [-121.31584, 38.33662], [-121.33219, 38.33672], [-121.33217, 38.33698], [-121.33427, 38.34166], [-121.33351, 38.34218], [-121.33376, 38.3427], [-121.33414, 38.34327], [-121.33438, 38.34361]]]} | Restricted Access 2 | 21422 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 286.086 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11140 | 11140 | 11139 | {"type": "Polygon", "coordinates": [[[-121.33145, 38.71873], [-121.33142, 38.71879], [-121.33142, 38.71883], [-121.33145, 38.71887], [-121.33142, 38.7189], [-121.3314, 38.71911], [-121.33136, 38.71934], [-121.33134, 38.71943], [-121.33129, 38.71946], [-121.33127, 38.71951], [-121.33129, 38.71958], [-121.33118, 38.71982], [-121.33113, 38.7199], [-121.3311, 38.71991], [-121.33097, 38.72016], [-121.33083, 38.72055], [-121.33067, 38.72078], [-121.33057, 38.72077], [-121.33048, 38.72082], [-121.33047, 38.72085], [-121.33047, 38.7209], [-121.33043, 38.72091], [-121.33017, 38.72138], [-121.33011, 38.72139], [-121.33005, 38.72143], [-121.33003, 38.72148], [-121.33005, 38.72154], [-121.32969, 38.72203], [-121.32962, 38.72204], [-121.32956, 38.72209], [-121.32955, 38.72216], [-121.3296, 38.72223], [-121.32938, 38.72244], [-121.32905, 38.72285], [-121.32891, 38.7229], [-121.32899, 38.72315], [-121.32859, 38.72322], [-121.3282, 38.72325], [-121.32775, 38.72325], [-121.32767, 38.72323], [-121.32765, 38.72319], [-121.32765, 38.72284], [-121.32812, 38.72284], [-121.32841, 38.72278], [-121.32864, 38.72258], [-121.32892, 38.72215], [-121.32891, 38.72212], [-121.32897, 38.72207], [-121.32899, 38.72201], [-121.32902, 38.72201], [-121.32939, 38.72153], [-121.32938, 38.7215], [-121.32945, 38.72145], [-121.32946, 38.72138], [-121.3295, 38.72137], [-121.32985, 38.72089], [-121.32984, 38.72086], [-121.32991, 38.72081], [-121.32992, 38.72074], [-121.32996, 38.72073], [-121.33032, 38.72021], [-121.33064, 38.7198], [-121.3308, 38.71951], [-121.33089, 38.7192], [-121.33091, 38.71901], [-121.33091, 38.71878], [-121.33095, 38.71869], [-121.33093, 38.71864], [-121.3309, 38.71859], [-121.33094, 38.71855], [-121.33094, 38.71809], [-121.33142, 38.71808], [-121.33142, 38.7187], [-121.33145, 38.71873]]]} | Open Access 1 | 21442 | Parkway Greens | 23460 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 8.032 | Parkway Greens | 0 | Local Park 2 | 4 | |
10591 | 10591 | 10590 | {"type": "Polygon", "coordinates": [[[-121.325, 38.58998], [-121.32489, 38.59], [-121.32456, 38.58892], [-121.32454, 38.58891], [-121.32255, 38.59098], [-121.32204, 38.59149], [-121.32194, 38.59124], [-121.32446, 38.58862], [-121.3242, 38.58776], [-121.32414, 38.58775], [-121.32412, 38.58766], [-121.32308, 38.58433], [-121.32305, 38.5841], [-121.32175, 38.57992], [-121.32185, 38.57986], [-121.325, 38.58998]]]} | Open Access 1 | 22215 | County Of Sacramento | 17713 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.396 | County Of Sacramento | None 933 | |||
11420 | 11420 | 11419 | {"type": "Polygon", "coordinates": [[[-121.32403, 38.45886], [-121.32211, 38.45886], [-121.32212, 38.45801], [-121.32285, 38.45764], [-121.3229, 38.45763], [-121.32403, 38.45886]]]} | Open Access 1 | 22238 | Silver Leaf Park | 25490 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.643 | Silver Leaf Park | 0 | Local Park 2 | 4 | |
4818 | 4818 | 4817 | {"type": "Polygon", "coordinates": [[[-121.29822, 38.56886], [-121.29831, 38.56987], [-121.29827, 38.56998], [-121.29811, 38.57016], [-121.29803, 38.57031], [-121.29801, 38.57042], [-121.29796, 38.57085], [-121.29785, 38.57059], [-121.29782, 38.57043], [-121.29777, 38.57032], [-121.29767, 38.57021], [-121.29744, 38.57006], [-121.29737, 38.56997], [-121.29734, 38.5699], [-121.29716, 38.5679], [-121.29813, 38.56784], [-121.29822, 38.56886]]]} | Open Access 1 | 48883 | Unknown park - Sacramento, County of | 33604 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.539 | 0 | Local Other or Unknown 14 | 4 | ||
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
11421 | 11421 | 11420 | {"type": "Polygon", "coordinates": [[[-121.28865, 38.49607], [-121.27955, 38.49606], [-121.27946, 38.48155], [-121.28863, 38.48158], [-121.28865, 38.49607]]]} | Restricted Access 2 | 22240 | Vernal Pool Prairie Preserve Area | 27000 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 317.004 | Vernal Pool Prairie Preserve Area | 0 | Local Conservation Area 4 | 2 |
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]);