units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where DES_TP = 2 and MNG_AGENCY = 569 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 36
MNG_AGENCY 1
- Rocklin, City of · 36 ✖
DES_TP 1
- Local Park · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14285 | 14285 | 14284 | {"type": "Polygon", "coordinates": [[[-121.28249, 38.80049], [-121.28043, 38.80049], [-121.28023, 38.80035], [-121.27984, 38.80004], [-121.28143, 38.79878], [-121.28166, 38.7989], [-121.28191, 38.79899], [-121.28217, 38.79906], [-121.28246, 38.79911], [-121.2825, 38.79914], [-121.2825, 38.80031], [-121.28248, 38.80043], [-121.28249, 38.80049]]]} | Open Access 1 | 44217 | Sonora Park | 25620 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.604 | Sonora Park | 0 | Local Park 2 | 4 | |
14255 | 14255 | 14254 | {"type": "Polygon", "coordinates": [[[-121.28229, 38.80549], [-121.27957, 38.80433], [-121.27949, 38.80428], [-121.27949, 38.80423], [-121.2796, 38.80409], [-121.27968, 38.80394], [-121.28009, 38.80255], [-121.28007, 38.80266], [-121.2801, 38.80277], [-121.28019, 38.80292], [-121.2803, 38.803], [-121.28042, 38.80305], [-121.28063, 38.80308], [-121.28033, 38.80369], [-121.28037, 38.80393], [-121.2815, 38.8045], [-121.28229, 38.80549]]]} | Open Access 1 | 44174 | Ruhkala Park | 24728 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 5.041 | Ruhkala Park | 0 | Local Park 2 | 4 | |
12677 | 12677 | 12676 | {"type": "Polygon", "coordinates": [[[-121.24701, 38.83755], [-121.24602, 38.83754], [-121.24544, 38.83782], [-121.24435, 38.83815], [-121.24373, 38.83828], [-121.2426, 38.83894], [-121.24222, 38.83885], [-121.24232, 38.83861], [-121.24243, 38.83863], [-121.24249, 38.83862], [-121.24255, 38.83859], [-121.24259, 38.83853], [-121.2426, 38.83846], [-121.24262, 38.83843], [-121.24315, 38.83801], [-121.24327, 38.83787], [-121.24347, 38.8376], [-121.24359, 38.83749], [-121.24373, 38.83739], [-121.24405, 38.83723], [-121.24435, 38.83714], [-121.24466, 38.83712], [-121.24517, 38.83714], [-121.24541, 38.83711], [-121.24556, 38.83705], [-121.24569, 38.83698], [-121.24585, 38.83685], [-121.24613, 38.8364], [-121.24621, 38.8363], [-121.24638, 38.83618], [-121.24651, 38.83613], [-121.24667, 38.83611], [-121.24671, 38.83615], [-121.24684, 38.83617], [-121.24692, 38.83625], [-121.24701, 38.8368], [-121.24701, 38.83755]]]} | Open Access 1 | 29575 | Pleasant Valley Creek Park | 33738 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 9.791 | Pleasant Valley Creek Park | 0 | Local Park 2 | 4 | |
12676 | 12676 | 12675 | {"type": "Polygon", "coordinates": [[[-121.27698, 38.82744], [-121.27696, 38.82745], [-121.27693, 38.82751], [-121.27651, 38.82772], [-121.27619, 38.82793], [-121.27561, 38.8274], [-121.27582, 38.82706], [-121.2758, 38.82685], [-121.2759, 38.82669], [-121.27619, 38.82637], [-121.27646, 38.82631], [-121.27679, 38.82713], [-121.27698, 38.82744]]]} | Open Access 1 | 29573 | Bolton Park | 16250 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.008 | Bolton Park | 0 | Local Park 2 | 4 | |
12668 | 12668 | 12667 | {"type": "Polygon", "coordinates": [[[-121.27081, 38.81864], [-121.27019, 38.81882], [-121.27015, 38.81878], [-121.27008, 38.81875], [-121.26983, 38.81879], [-121.26933, 38.81872], [-121.269, 38.81865], [-121.26869, 38.81854], [-121.26866, 38.81849], [-121.26878, 38.81818], [-121.26882, 38.818], [-121.26882, 38.81782], [-121.26878, 38.81758], [-121.26864, 38.81718], [-121.2689, 38.81708], [-121.26915, 38.81696], [-121.26938, 38.81682], [-121.2697, 38.81651], [-121.27047, 38.81701], [-121.27047, 38.81716], [-121.27035, 38.8181], [-121.27081, 38.81864]]]} | No Public Access 3 | 29634 | Wesley Park | 27349 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.832 | Wesley Park | 0 | Local Park 2 | 4 | |
12660 | 12660 | 12659 | {"type": "Polygon", "coordinates": [[[-121.28715, 38.82119], [-121.28691, 38.82204], [-121.28636, 38.82241], [-121.2852, 38.82134], [-121.2836, 38.82285], [-121.28314, 38.823], [-121.28295, 38.82262], [-121.2826, 38.82184], [-121.28328, 38.82172], [-121.2833, 38.82005], [-121.28426, 38.8194], [-121.28696, 38.81941], [-121.28686, 38.82106], [-121.28715, 38.82119]]]} | Open Access 1 | 29537 | Margaret Azavedo Park | 21801 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 24.123 | Margaret Azavedo Park | 0 | Local Park 2 | 4 | |
12656 | 12656 | 12655 | {"type": "Polygon", "coordinates": [[[-121.21492, 38.78493], [-121.21492, 38.78686], [-121.2123, 38.78695], [-121.21229, 38.78497], [-121.21492, 38.78493]]]} | Open Access 1 | 29508 | Monte Verde Park | 22393 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 12.255 | Monte Verde Park | 0 | Local Park 2 | 4 | |
12655 | 12655 | 12654 | {"type": "Polygon", "coordinates": [[[-121.29272, 38.80693], [-121.29258, 38.8075], [-121.29252, 38.80788], [-121.2925, 38.80826], [-121.29249, 38.80896], [-121.29163, 38.80896], [-121.29108, 38.80939], [-121.29107, 38.81002], [-121.28931, 38.81005], [-121.28718, 38.81006], [-121.28717, 38.80949], [-121.28658, 38.80949], [-121.287, 38.80895], [-121.28937, 38.80728], [-121.29038, 38.80701], [-121.29272, 38.80693]]]} | Open Access 1 | 29505 | Kathy Lund Community Park | 33732 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 30.262 | Kathy Lund Community Park | 0 | Local Park 2 | 4 | |
12654 | 12654 | 12653 | {"type": "Polygon", "coordinates": [[[-121.2623, 38.78409], [-121.26167, 38.78534], [-121.26162, 38.78548], [-121.2616, 38.78562], [-121.2616, 38.78577], [-121.26165, 38.78597], [-121.2617, 38.78603], [-121.26138, 38.78633], [-121.26087, 38.78606], [-121.26088, 38.786], [-121.26084, 38.78593], [-121.26075, 38.7859], [-121.26041, 38.78567], [-121.26047, 38.78561], [-121.26074, 38.78524], [-121.26093, 38.78484], [-121.26103, 38.78442], [-121.26103, 38.78397], [-121.26094, 38.78358], [-121.26123, 38.78357], [-121.26182, 38.7837], [-121.26188, 38.78396], [-121.2623, 38.78409]]]} | Open Access 1 | 29502 | Vista Grande Park | 27174 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 6.16 | Vista Grande Park | 0 | Local Park 2 | 4 | |
12653 | 12653 | 12652 | {"type": "Polygon", "coordinates": [[[-121.21328, 38.78029], [-121.21327, 38.78079], [-121.21324, 38.78083], [-121.21206, 38.78087], [-121.21202, 38.78086], [-121.212, 38.78083], [-121.21198, 38.78064], [-121.212, 38.78052], [-121.21203, 38.78041], [-121.2121, 38.7803], [-121.21328, 38.78029]]]} | Open Access 1 | 29500 | Sasaki Park | 25163 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.67 | Sasaki Park | 0 | Local Park 2 | 4 | |
12652 | 12652 | 12651 | {"type": "Polygon", "coordinates": [[[-121.22788, 38.80669], [-121.22749, 38.80797], [-121.22717, 38.80791], [-121.22719, 38.80786], [-121.22718, 38.8078], [-121.22715, 38.80777], [-121.22709, 38.80774], [-121.22698, 38.80775], [-121.22687, 38.80783], [-121.22679, 38.80782], [-121.22678, 38.80778], [-121.22678, 38.80717], [-121.2267, 38.80681], [-121.2267, 38.80668], [-121.22788, 38.80669]]]} | Open Access 1 | 29499 | Gayaldo Park | 19244 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.626 | Gayaldo Park | 0 | Local Park 2 | 4 | |
12651 | 12651 | 12650 | {"type": "Polygon", "coordinates": [[[-121.28015, 38.83781], [-121.28015, 38.83843], [-121.27996, 38.83843], [-121.27885, 38.83889], [-121.2786, 38.83882], [-121.27847, 38.83858], [-121.27813, 38.83849], [-121.27865, 38.83818], [-121.27857, 38.838], [-121.27853, 38.83798], [-121.2789, 38.83759], [-121.27921, 38.83773], [-121.27944, 38.83779], [-121.27979, 38.83783], [-121.28015, 38.83781]]]} | Open Access 1 | 29493 | Brigham & Hawes Park | 16391 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.582 | Brigham & Hawes Park | 0 | Local Park 2 | 4 | |
12645 | 12645 | 12644 | {"type": "Polygon", "coordinates": [[[-121.23155, 38.77166], [-121.23143, 38.77235], [-121.23137, 38.77242], [-121.23108, 38.7723], [-121.23087, 38.77225], [-121.23066, 38.77222], [-121.23015, 38.77223], [-121.22978, 38.7723], [-121.22973, 38.77227], [-121.22965, 38.77205], [-121.22965, 38.77182], [-121.22971, 38.77162], [-121.22977, 38.7715], [-121.22999, 38.77123], [-121.23008, 38.77107], [-121.23027, 38.77115], [-121.23083, 38.77166], [-121.23155, 38.77166]]]} | Open Access 1 | 29480 | Joe Hernandez Park | 20420 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.527 | Joe Hernandez Park | 0 | Local Park 2 | 4 | |
10909 | 10909 | 10908 | {"type": "Polygon", "coordinates": [[[-121.25393, 38.78071], [-121.25378, 38.78075], [-121.25354, 38.7812], [-121.25332, 38.78152], [-121.25253, 38.78125], [-121.25248, 38.78099], [-121.2523, 38.78062], [-121.25194, 38.78034], [-121.25182, 38.77988], [-121.25143, 38.77943], [-121.25156, 38.77935], [-121.25167, 38.77925], [-121.2519, 38.77938], [-121.2524, 38.77939], [-121.25269, 38.77907], [-121.25253, 38.77872], [-121.25246, 38.77866], [-121.25303, 38.77856], [-121.25315, 38.77891], [-121.25284, 38.77967], [-121.25335, 38.78053], [-121.25363, 38.78053], [-121.25393, 38.78071]]]} | Open Access 1 | 20897 | Sunset East Park | 33740 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 6.944 | Sunset East Park | 0 | Local Park 2 | 4 | |
10896 | 10896 | 10895 | {"type": "Polygon", "coordinates": [[[-121.26656, 38.80341], [-121.26584, 38.80386], [-121.26423, 38.80405], [-121.26401, 38.80357], [-121.26389, 38.80342], [-121.26375, 38.8033], [-121.26583, 38.80296], [-121.26616, 38.80286], [-121.26633, 38.80314], [-121.26656, 38.80341]]]} | Open Access 1 | 20850 | Pebble Creek Park | 23553 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 4.68 | Pebble Creek Park | 0 | Local Park 2 | 4 | |
10895 | 10895 | 10894 | {"type": "Polygon", "coordinates": [[[-121.26504, 38.81124], [-121.26473, 38.81127], [-121.2645, 38.81149], [-121.2637, 38.81155], [-121.26227, 38.81134], [-121.26097, 38.81209], [-121.25895, 38.81171], [-121.25897, 38.81164], [-121.25894, 38.81164], [-121.25889, 38.81157], [-121.25903, 38.81127], [-121.25922, 38.81099], [-121.25945, 38.81072], [-121.25976, 38.81045], [-121.26223, 38.80884], [-121.26232, 38.80884], [-121.26234, 38.80886], [-121.26247, 38.80878], [-121.26245, 38.80873], [-121.26298, 38.80838], [-121.26312, 38.80825], [-121.26387, 38.80779], [-121.26418, 38.8081], [-121.26422, 38.80819], [-121.26434, 38.80826], [-121.2648, 38.80873], [-121.26339, 38.80968], [-121.26504, 38.81124]]]} | Open Access 1 | 20849 | Twin Oaks Park | 33733 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 30.273 | Twin Oaks Park | 0 | Local Park 2 | 4 | |
10894 | 10894 | 10893 | {"type": "Polygon", "coordinates": [[[-121.25907, 38.81949], [-121.25836, 38.81993], [-121.25829, 38.81993], [-121.25793, 38.81966], [-121.25761, 38.81946], [-121.25661, 38.81896], [-121.25867, 38.81786], [-121.25886, 38.81924], [-121.25907, 38.81949]]]} | Open Access 1 | 20846 | Breen Park | 16345 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 5.897 | Breen Park | 0 | Local Park 2 | 4 | |
10893 | 10893 | 10892 | {"type": "Polygon", "coordinates": [[[-121.24829, 38.82446], [-121.24818, 38.82451], [-121.24812, 38.82496], [-121.24734, 38.82533], [-121.24665, 38.82556], [-121.24639, 38.82547], [-121.24622, 38.82516], [-121.24625, 38.82514], [-121.24578, 38.8243], [-121.24783, 38.8236], [-121.24788, 38.82361], [-121.24791, 38.82364], [-121.24826, 38.8243], [-121.24827, 38.8244], [-121.24829, 38.82446]]]} | Open Access 1 | 20843 | Monument Park | 22446 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.262 | Monument Park | 0 | Local Park 2 | 4 | |
10892 | 10892 | 10891 | {"type": "Polygon", "coordinates": [[[-121.25141, 38.78795], [-121.25144, 38.78819], [-121.25137, 38.7884], [-121.25046, 38.79038], [-121.25037, 38.79061], [-121.25018, 38.7913], [-121.24906, 38.79117], [-121.24881, 38.79116], [-121.24856, 38.79119], [-121.24821, 38.79126], [-121.24793, 38.79138], [-121.24766, 38.79153], [-121.24744, 38.79172], [-121.24745, 38.79199], [-121.24768, 38.79175], [-121.24791, 38.79159], [-121.2482, 38.79145], [-121.2485, 38.79136], [-121.24876, 38.79133], [-121.24901, 38.79133], [-121.25014, 38.79146], [-121.25007, 38.79169], [-121.2497, 38.79372], [-121.24994, 38.79465], [-121.25014, 38.79526], [-121.24892, 38.79477], [-121.24789, 38.79543], [-121.24727, 38.79541], [-121.2465, 38.79517], [-121.24634, 38.79473], [-121.24602, 38.79445], [-121.24482, 38.79531], [-121.24183, 38.79406], [-121.24217, 38.79358], [-121.24208, 38.79343], [-121.24142, 38.79314], [-121.24145, 38.79309], [-121.24244, 38.79351], [-121.24318, 38.79245], [-121.24221, 38.79203], [-121.24474, 38.78846], [-121.24474, 38.78828], [-121.24465, 38.78813], [-121.24449, 38.78801], [-121.24425, 38.78789], [-121.24698, 38.78582], [-121.24742, 38.78608], [-121.24743, 38.78728], [-121.24745, 38.78752], [-121.24854, 38.78775], [-121.24852, 38.78767], [-121.2488, 38.78691], [-121.24932, 38.78625], [-121.2506, 38.78684], [-121.2506, 38.78687], [-121.25099, 38.78706], [-121.2513, 38.78777], [-121.25099, 38.78776], [-121.25061, 38.7878], [-121.25054, 38.7875], [-121.25033, 38.7872], [-121.25008, 38.787], [-121.24982, 38.78694], [-121.24954, 38.78704], [-121.24939, 38.78742], [-121.2494, 38.78761], [-121.24968, 38.78788], [-121.24972, 38.78825], [-121.24968, 38.7885], [-121.25003, 38.78879], [-121.25054, 38.78873], [-121.25076, 38.78842], [-121.25065, 38.78795], [-121.25101, 38.78791], [-121.25121, 38.78792], [-121.25141, 38.78795]]]} | Open Access 1 | 20839 | Johnson-Springview Community Park | 20475 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 133.0 | Johnson-Springview Community Park | 0 | Local Park 2 | 4 | |
10886 | 10886 | 10885 | {"type": "Polygon", "coordinates": [[[-121.24285, 38.7747], [-121.24256, 38.77498], [-121.24217, 38.77545], [-121.242, 38.77559], [-121.24188, 38.77564], [-121.24183, 38.77573], [-121.24146, 38.77569], [-121.24119, 38.77586], [-121.24113, 38.77582], [-121.24105, 38.77582], [-121.24102, 38.77557], [-121.24076, 38.77531], [-121.24238, 38.77431], [-121.24285, 38.7747]]]} | Open Access 1 | 20835 | Woodside Park | 33744 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.563 | Woodside 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]);