units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where DES_TP = 14 and MNG_AGENCY = 533
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 26
MNG_AGENCY 1
- Roseville, City of · 26 ✖
DES_TP 1
- Local Other or Unknown · 26 ✖
ACCESS_TYP 1
- Open Access 26
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13839 | 13839 | 13838 | {"type": "Polygon", "coordinates": [[[-121.24156, 38.73934], [-121.24125, 38.73946], [-121.24051, 38.73948], [-121.23986, 38.73945], [-121.2389, 38.7392], [-121.23841, 38.73917], [-121.23818, 38.73912], [-121.23784, 38.73924], [-121.23757, 38.73919], [-121.23748, 38.73911], [-121.23722, 38.73929], [-121.23715, 38.73925], [-121.23711, 38.73918], [-121.23683, 38.73919], [-121.23671, 38.73931], [-121.2367, 38.73946], [-121.23634, 38.7397], [-121.23614, 38.74011], [-121.23586, 38.74029], [-121.2358, 38.74004], [-121.23578, 38.73942], [-121.23583, 38.73941], [-121.23581, 38.73859], [-121.23594, 38.73848], [-121.23736, 38.73854], [-121.23819, 38.73859], [-121.23827, 38.73864], [-121.23838, 38.73864], [-121.23862, 38.73869], [-121.2387, 38.73882], [-121.23882, 38.73891], [-121.23891, 38.73892], [-121.23896, 38.73896], [-121.23928, 38.73901], [-121.23969, 38.73912], [-121.23979, 38.73911], [-121.2399, 38.73916], [-121.24007, 38.73913], [-121.24012, 38.7391], [-121.24017, 38.73912], [-121.24022, 38.73912], [-121.24029, 38.73908], [-121.24043, 38.73913], [-121.24063, 38.73914], [-121.24065, 38.73915], [-121.24122, 38.73912], [-121.24156, 38.73934]]]} | Open Access 1 | 36430 | Roseville holding 36 | 24656 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 7.922 | Roseville holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13841 | 13841 | 13840 | {"type": "Polygon", "coordinates": [[[-121.25572, 38.72971], [-121.25572, 38.73032], [-121.2557, 38.73046], [-121.25562, 38.73062], [-121.25555, 38.73072], [-121.25548, 38.7307], [-121.25502, 38.73118], [-121.25487, 38.73128], [-121.25469, 38.73134], [-121.25452, 38.73102], [-121.25441, 38.73102], [-121.25442, 38.731], [-121.25449, 38.73098], [-121.25448, 38.7306], [-121.25445, 38.73046], [-121.25435, 38.73028], [-121.25413, 38.73021], [-121.25399, 38.73019], [-121.25392, 38.73021], [-121.25391, 38.73008], [-121.25343, 38.73003], [-121.25286, 38.73006], [-121.25286, 38.72987], [-121.25391, 38.72987], [-121.25391, 38.72967], [-121.25567, 38.72967], [-121.25572, 38.72971]]]} | Open Access 1 | 36432 | Roseville holding 38 | 24658 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 5.217 | Roseville holding 38 | 0 | Local Other or Unknown 14 | 4 | |
13846 | 13846 | 13845 | {"type": "Polygon", "coordinates": [[[-121.24296, 38.71911], [-121.24239, 38.71886], [-121.2423, 38.71857], [-121.2423, 38.71852], [-121.24233, 38.71848], [-121.24273, 38.71815], [-121.24269, 38.71824], [-121.24268, 38.71838], [-121.24271, 38.71863], [-121.24281, 38.71889], [-121.24296, 38.71911]]]} | Open Access 1 | 36435 | Roseville holding 37 | 24657 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.609 | Roseville holding 37 | 0 | Local Other or Unknown 14 | 4 | |
13851 | 13851 | 13850 | {"type": "Polygon", "coordinates": [[[-121.32215, 38.76468], [-121.32215, 38.76468], [-121.32201, 38.76495], [-121.32198, 38.76464], [-121.32215, 38.76468]]]} | Open Access 1 | 36440 | Roseville holding 41 | 24662 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.06 | Roseville holding 41 | 0 | Local Other or Unknown 14 | 4 | |
13852 | 13852 | 13851 | {"type": "Polygon", "coordinates": [[[-121.33024, 38.76448], [-121.33023, 38.7647], [-121.32995, 38.7647], [-121.32996, 38.76448], [-121.33024, 38.76448]]]} | Open Access 1 | 36441 | Roseville holding 39 | 24659 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.146 | Roseville holding 39 | 0 | Local Other or Unknown 14 | 4 | |
13853 | 13853 | 13852 | {"type": "Polygon", "coordinates": [[[-121.33095, 38.77505], [-121.3309, 38.77508], [-121.33064, 38.77475], [-121.33058, 38.77475], [-121.33055, 38.77471], [-121.33059, 38.77467], [-121.33037, 38.77434], [-121.33022, 38.77406], [-121.33005, 38.77369], [-121.32995, 38.77341], [-121.32979, 38.77341], [-121.32965, 38.77334], [-121.32966, 38.77266], [-121.32976, 38.77265], [-121.32982, 38.77269], [-121.32991, 38.77309], [-121.32999, 38.77336], [-121.3301, 38.77364], [-121.33022, 38.77392], [-121.33036, 38.7742], [-121.33057, 38.77455], [-121.33095, 38.77505]]]} | Open Access 1 | 36442 | Roseville holding 40 | 24661 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.731 | Roseville holding 40 | 0 | Local Other or Unknown 14 | 4 | |
13856 | 13856 | 13855 | {"type": "Polygon", "coordinates": [[[-121.32457, 38.76049], [-121.32457, 38.76049], [-121.32436, 38.76079], [-121.32439, 38.7605], [-121.32457, 38.76049]]]} | Open Access 1 | 36447 | Roseville holding 7 | 24667 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.06 | Roseville holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13857 | 13857 | 13856 | {"type": "Polygon", "coordinates": [[[-121.29997, 38.7584], [-121.29997, 38.7584], [-121.29997, 38.75871], [-121.29978, 38.75851], [-121.29978, 38.75839], [-121.29997, 38.7584]]]} | Open Access 1 | 36448 | Roseville holding 8 | 24668 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.096 | Roseville holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13858 | 13858 | 13857 | {"type": "Polygon", "coordinates": [[[-121.31745, 38.76323], [-121.31744, 38.76338], [-121.31446, 38.76336], [-121.31446, 38.76316], [-121.31737, 38.76318], [-121.31742, 38.7632], [-121.31745, 38.76323]]]} | Open Access 1 | 36449 | Roseville holding 6 | 24666 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.418 | Roseville holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13859 | 13859 | 13858 | {"type": "Polygon", "coordinates": [[[-121.31794, 38.76388], [-121.31789, 38.76403], [-121.31784, 38.76406], [-121.31764, 38.76402], [-121.31755, 38.76399], [-121.31753, 38.76397], [-121.31752, 38.76394], [-121.3176, 38.7635], [-121.31761, 38.76338], [-121.31777, 38.76339], [-121.31791, 38.76343], [-121.31778, 38.76341], [-121.31767, 38.76341], [-121.31767, 38.76352], [-121.31762, 38.7638], [-121.31794, 38.76388]]]} | Open Access 1 | 36450 | Roseville holding 5 | 24665 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.263 | Roseville holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13860 | 13860 | 13859 | {"type": "Polygon", "coordinates": [[[-121.25834, 38.73133], [-121.25794, 38.73149], [-121.25793, 38.73087], [-121.25833, 38.73087], [-121.25834, 38.73133]]]} | Open Access 1 | 36451 | Roseville holding 10 | 24628 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.514 | Roseville holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13861 | 13861 | 13860 | {"type": "Polygon", "coordinates": [[[-121.33947, 38.77588], [-121.33947, 38.77588], [-121.33905, 38.77566], [-121.33934, 38.77566], [-121.33947, 38.77588]]]} | Open Access 1 | 36452 | Roseville holding 9 | 24669 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.076 | Roseville holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13862 | 13862 | 13861 | {"type": "Polygon", "coordinates": [[[-121.30877, 38.73764], [-121.30787, 38.73762], [-121.30771, 38.73765], [-121.30725, 38.73783], [-121.30706, 38.73799], [-121.30698, 38.73822], [-121.30677, 38.73808], [-121.30682, 38.73794], [-121.30676, 38.7379], [-121.30653, 38.738], [-121.30648, 38.73795], [-121.30646, 38.73789], [-121.30648, 38.73782], [-121.3067, 38.73757], [-121.30677, 38.73745], [-121.30717, 38.73751], [-121.30758, 38.73729], [-121.30827, 38.73728], [-121.30855, 38.73732], [-121.30877, 38.73732], [-121.30877, 38.73764]]]} | Open Access 1 | 36453 | Roseville holding 11 | 24629 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.129 | Roseville holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13863 | 13863 | 13862 | {"type": "Polygon", "coordinates": [[[-121.30589, 38.73764], [-121.3056, 38.73748], [-121.30557, 38.73749], [-121.30532, 38.73734], [-121.3056, 38.73713], [-121.30595, 38.73672], [-121.30599, 38.7367], [-121.30605, 38.7367], [-121.30638, 38.73688], [-121.3065, 38.73698], [-121.30655, 38.73705], [-121.30659, 38.73715], [-121.3066, 38.73731], [-121.30657, 38.73739], [-121.30652, 38.73748], [-121.30642, 38.7376], [-121.30633, 38.73765], [-121.30622, 38.73769], [-121.30611, 38.7377], [-121.30599, 38.73768], [-121.30589, 38.73764]]]} | Open Access 1 | 36454 | Roseville holding 2 | 24638 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.865 | Roseville holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13864 | 13864 | 13863 | {"type": "Polygon", "coordinates": [[[-121.29641, 38.73769], [-121.29608, 38.7377], [-121.29606, 38.73671], [-121.29639, 38.7367], [-121.29641, 38.73769]]]} | Open Access 1 | 36455 | Roseville holding 3 | 24649 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.764 | Roseville holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13865 | 13865 | 13864 | {"type": "Polygon", "coordinates": [[[-121.2971, 38.73345], [-121.2966, 38.73345], [-121.29659, 38.73255], [-121.297, 38.73265], [-121.29693, 38.73288], [-121.29693, 38.73301], [-121.2969, 38.73305], [-121.29698, 38.73309], [-121.29695, 38.73311], [-121.29697, 38.73321], [-121.29706, 38.73322], [-121.29707, 38.73327], [-121.29709, 38.73331], [-121.2971, 38.73345]]]} | Open Access 1 | 36456 | Roseville holding 15 | 24633 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.801 | Roseville holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13866 | 13866 | 13865 | {"type": "Polygon", "coordinates": [[[-121.29545, 38.73776], [-121.2948, 38.73776], [-121.29479, 38.73737], [-121.29512, 38.73737], [-121.29511, 38.73671], [-121.29543, 38.73671], [-121.29545, 38.73776]]]} | Open Access 1 | 36457 | Roseville holding 4 | 24660 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.115 | Roseville holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13867 | 13867 | 13866 | {"type": "Polygon", "coordinates": [[[-121.27246, 38.72252], [-121.27226, 38.72252], [-121.2722, 38.72249], [-121.27218, 38.72246], [-121.27217, 38.72221], [-121.27246, 38.72221], [-121.27246, 38.72252]]]} | Open Access 1 | 36458 | Roseville holding 17 | 24635 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.204 | Roseville holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13868 | 13868 | 13867 | {"type": "Polygon", "coordinates": [[[-121.25119, 38.76227], [-121.25118, 38.76283], [-121.2511, 38.76282], [-121.25103, 38.76312], [-121.25079, 38.7631], [-121.25076, 38.76321], [-121.25066, 38.76323], [-121.25051, 38.76323], [-121.25048, 38.7634], [-121.25038, 38.76345], [-121.25014, 38.76348], [-121.25016, 38.76361], [-121.25006, 38.76369], [-121.24974, 38.76379], [-121.24939, 38.76382], [-121.24918, 38.76394], [-121.24886, 38.76392], [-121.24872, 38.76407], [-121.24858, 38.76412], [-121.24851, 38.76423], [-121.24826, 38.76432], [-121.24834, 38.76444], [-121.2483, 38.76454], [-121.24817, 38.76459], [-121.2481, 38.76466], [-121.24802, 38.76467], [-121.24783, 38.76464], [-121.24778, 38.76447], [-121.2475, 38.76446], [-121.2474, 38.76452], [-121.24729, 38.76448], [-121.24719, 38.76453], [-121.24699, 38.76451], [-121.24686, 38.76442], [-121.24659, 38.76445], [-121.24649, 38.76427], [-121.24634, 38.76433], [-121.246, 38.76432], [-121.24588, 38.76427], [-121.24584, 38.76423], [-121.24585, 38.76419], [-121.24589, 38.76416], [-121.24618, 38.7642], [-121.24654, 38.76409], [-121.24674, 38.76424], [-121.24693, 38.76415], [-121.2472, 38.76415], [-121.24724, 38.76406], [-121.24738, 38.76404], [-121.24771, 38.76423], [-121.24794, 38.7639], [-121.24792, 38.76371], [-121.24802, 38.76359], [-121.24826, 38.76352], [-121.24827, 38.76329], [-121.24881, 38.76292], [-121.24897, 38.7627], [-121.24922, 38.76266], [-121.24933, 38.76223], [-121.24988, 38.76224], [-121.24989, 38.76222], [-121.25095, 38.76223], [-121.25096, 38.76227], [-121.25119, 38.76227]]]} | Open Access 1 | 36459 | Roseville holding 16 | 24634 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 10.651 | Roseville holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13869 | 13869 | 13868 | {"type": "MultiPolygon", "coordinates": [[[[-121.26734, 38.7323], [-121.26626, 38.7326], [-121.26625, 38.73285], [-121.26643, 38.73321], [-121.26695, 38.7334], [-121.26695, 38.73389], [-121.26687, 38.73422], [-121.26683, 38.73463], [-121.26662, 38.73479], [-121.26642, 38.73489], [-121.2661, 38.73498], [-121.26588, 38.735], [-121.2656, 38.73506], [-121.26536, 38.73519], [-121.26518, 38.73538], [-121.26504, 38.7356], [-121.26456, 38.73555], [-121.26417, 38.73571], [-121.2637, 38.73577], [-121.26275, 38.73606], [-121.26275, 38.7363], [-121.26205, 38.73631], [-121.26201, 38.73654], [-121.26195, 38.73667], [-121.26189, 38.73678], [-121.26155, 38.73663], [-121.26131, 38.73684], [-121.26071, 38.73684], [-121.26006, 38.7365], [-121.26008, 38.73647], [-121.26008, 38.73646], [-121.25969, 38.73628], [-121.25954, 38.73614], [-121.25938, 38.73601], [-121.25921, 38.73594], [-121.25879, 38.73604], [-121.2587, 38.73599], [-121.25866, 38.736], [-121.2586, 38.73321], [-121.25835, 38.73203], [-121.25829, 38.73203], [-121.25828, 38.73172], [-121.25832, 38.73171], [-121.2584, 38.73192], [-121.25855, 38.73214], [-121.25874, 38.73236], [-121.25952, 38.73293], [-121.25993, 38.73321], [-121.26032, 38.73321], [-121.26032, 38.73389], [-121.26149, 38.73473], [-121.2641, 38.73471], [-121.26476, 38.73468], [-121.26522, 38.73462], [-121.26573, 38.73442], [-121.26609, 38.73404], [-121.26621, 38.73359], [-121.26577, 38.73271], [-121.26574, 38.7325], [-121.26587, 38.73238], [-121.26653, 38.73211], [-121.26708, 38.73196], [-121.26734, 38.73194], [-121.26734, 38.7323]]], [[[-121.2719, 38.73376], [-121.2719, 38.73406], [-121.27145, 38.73404], [-121.27076, 38.73392], [-121.27048, 38.73382], [-121.27028, 38.7338], [-121.27019, 38.73376], [-121.27008, 38.73362], [-121.27001, 38.73356], [-121.26982, 38.73349], [-121.2697, 38.7334], [-121.2697, 38.73335], [-121.26936, 38.73299], [-121.2688, 38.73266], [-121.26767, 38.73227], [-121.26751, 38.73229], [-121.2675, 38.73197], [-121.26792, 38.73205], [-121.26829, 38.73216], [-121.26864, 38.73226], [-121.26942, 38.73267], [-121.26975, 38.73293], [-121.26994, 38.73315], [-121.27049, 38.73359], [-121.27092, 38.73362], [-121.27126, 38.7335], [-121.27152, 38.73374], [-121.2719, 38.73376]]]]} | Open Access 1 | 36460 | Roseville holding 19 | 24637 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 42.189 | Roseville holding 19 | 0 | Local Other or Unknown 14 | 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]);