units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13974 | 13974 | 13973 | {"type": "Polygon", "coordinates": [[[-121.39101, 38.04978], [-121.39099, 38.0498], [-121.3903, 38.04991], [-121.39027, 38.04989], [-121.39015, 38.04943], [-121.39083, 38.04932], [-121.39101, 38.04978]]]} | Open Access 1 | 36641 | Stockton holding 2 | 25859 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 0.86 | Stockton holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13672 | 13672 | 13671 | {"type": "Polygon", "coordinates": [[[-121.39013, 38.05312], [-121.39003, 38.05313], [-121.39003, 38.05438], [-121.38907, 38.05438], [-121.38864, 38.05441], [-121.38817, 38.0545], [-121.38749, 38.05468], [-121.38748, 38.05466], [-121.38829, 38.054], [-121.38859, 38.05372], [-121.38955, 38.05242], [-121.38953, 38.05235], [-121.38981, 38.05231], [-121.38993, 38.05279], [-121.38994, 38.05301], [-121.39002, 38.05309], [-121.39013, 38.05312]]]} | Open Access 1 | 36040 | Iloilo Park | 20177 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 6.105 | Iloilo Park | 0 | Local Park 2 | 4 | |
13977 | 13977 | 13976 | {"type": "Polygon", "coordinates": [[[-121.38992, 38.04625], [-121.3899, 38.04627], [-121.38944, 38.04634], [-121.38941, 38.04632], [-121.38933, 38.04599], [-121.38933, 38.04586], [-121.38935, 38.04585], [-121.38971, 38.04588], [-121.38992, 38.04625]]]} | Open Access 1 | 36644 | Stockton holding 4 | 25861 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 0.498 | Stockton holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13976 | 13976 | 13975 | {"type": "Polygon", "coordinates": [[[-121.38323, 38.04933], [-121.38318, 38.0494], [-121.3823, 38.04957], [-121.38221, 38.04953], [-121.382, 38.04884], [-121.38205, 38.04877], [-121.38293, 38.0486], [-121.38301, 38.04864], [-121.38323, 38.04933]]]} | Open Access 1 | 36643 | Stockton holding 5 | 25862 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.047 | Stockton holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13973 | 13973 | 13972 | {"type": "Polygon", "coordinates": [[[-121.38181, 38.05445], [-121.38174, 38.05451], [-121.38084, 38.05451], [-121.38077, 38.05445], [-121.38077, 38.05333], [-121.38083, 38.05327], [-121.38174, 38.05327], [-121.38181, 38.05333], [-121.38181, 38.05445]]]} | Open Access 1 | 36640 | Stockton holding 1 | 25858 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 3.08 | Stockton holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13975 | 13975 | 13974 | {"type": "Polygon", "coordinates": [[[-121.3818, 38.05196], [-121.38173, 38.05202], [-121.38083, 38.05202], [-121.38076, 38.05197], [-121.38075, 38.05126], [-121.38082, 38.0512], [-121.38173, 38.0512], [-121.3818, 38.05125], [-121.3818, 38.05196]]]} | Open Access 1 | 36642 | Stockton holding 3 | 25860 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.046 | Stockton holding 3 | 0 | Local Other or Unknown 14 | 4 | |
2556 | 2556 | 2555 | {"type": "Polygon", "coordinates": [[[-121.37991, 37.97763], [-121.37336, 37.9769], [-121.37042, 37.97837], [-121.37205, 37.97398], [-121.37356, 37.9716], [-121.37991, 37.97763]]]} | Open Access 1 | 17820 | Buckley Cove Park | 16475 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 63.792 | Buckley Cove Park | 0 | Local Park 2 | 4 | |
13671 | 13671 | 13670 | {"type": "Polygon", "coordinates": [[[-121.37976, 38.04623], [-121.37927, 38.0471], [-121.37933, 38.04716], [-121.37939, 38.04725], [-121.37957, 38.04735], [-121.37973, 38.04748], [-121.37974, 38.04756], [-121.37952, 38.04779], [-121.37928, 38.04813], [-121.37905, 38.04855], [-121.37897, 38.04882], [-121.37889, 38.04886], [-121.37778, 38.04873], [-121.3771, 38.0486], [-121.37638, 38.04842], [-121.37674, 38.04714], [-121.37655, 38.04645], [-121.37782, 38.04624], [-121.37796, 38.04625], [-121.37833, 38.04621], [-121.3784, 38.04658], [-121.37905, 38.04651], [-121.3792, 38.04625], [-121.37918, 38.04612], [-121.3797, 38.04606], [-121.37976, 38.04623]]]} | Open Access 1 | 36039 | Faklis Community Park | 18828 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 16.18 | Faklis Community Park | 0 | Local Park 2 | 4 | |
12058 | 12058 | 12057 | {"type": "Polygon", "coordinates": [[[-121.36682, 38.04354], [-121.36682, 38.0438], [-121.3667, 38.04389], [-121.36664, 38.04386], [-121.36503, 38.04499], [-121.36481, 38.04467], [-121.36459, 38.04445], [-121.36429, 38.04425], [-121.36396, 38.04409], [-121.36424, 38.04362], [-121.36459, 38.04358], [-121.36682, 38.04354]]]} | Open Access 1 | 24752 | Garrigan Park | 19224 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 5.518 | Garrigan Park | 0 | Local Park 2 | 4 | |
3402 | 3402 | 3401 | {"type": "Polygon", "coordinates": [[[-121.36136, 37.98621], [-121.36133, 37.98643], [-121.36097, 37.98725], [-121.36089, 37.98729], [-121.36082, 37.98736], [-121.36083, 37.98748], [-121.36095, 37.9875], [-121.36103, 37.9875], [-121.36116, 37.98745], [-121.36116, 37.98823], [-121.35912, 37.98821], [-121.35913, 37.98797], [-121.3591, 37.98777], [-121.35898, 37.98745], [-121.35879, 37.98715], [-121.35854, 37.98689], [-121.35808, 37.98654], [-121.35827, 37.98636], [-121.35862, 37.98624], [-121.36004, 37.98613], [-121.36036, 37.98613], [-121.36136, 37.98621]]]} | Open Access 1 | 24755 | Nelson Park | 22697 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 11.879 | Nelson Park | 0 | Local Park 2 | 4 | |
12055 | 12055 | 12054 | {"type": "Polygon", "coordinates": [[[-121.35774, 38.04766], [-121.35702, 38.04778], [-121.35683, 38.04716], [-121.35755, 38.04706], [-121.35774, 38.04766]]]} | Open Access 1 | 24749 | Corren Park | 17656 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 1.098 | Corren Park | 0 | Local Park 2 | 4 | |
10216 | 10216 | 10215 | {"type": "Polygon", "coordinates": [[[-121.35707, 37.99503], [-121.35688, 37.99516], [-121.35675, 37.9953], [-121.35667, 37.99546], [-121.35663, 37.99566], [-121.35666, 37.99829], [-121.35669, 37.99847], [-121.35675, 37.99863], [-121.35687, 37.99882], [-121.35699, 37.99895], [-121.35699, 37.99899], [-121.35697, 37.99901], [-121.35657, 37.99928], [-121.35642, 37.99934], [-121.35625, 37.99938], [-121.35597, 37.99941], [-121.35493, 37.99941], [-121.35488, 37.99936], [-121.35488, 37.99911], [-121.35495, 37.99883], [-121.35503, 37.99882], [-121.355, 37.99595], [-121.35498, 37.99583], [-121.35494, 37.99572], [-121.35493, 37.99454], [-121.3566, 37.99445], [-121.35707, 37.99503]]]} | Open Access 1 | 17864 | Fritz Grupe Park | 19128 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 20.415 | Fritz Grupe Park | 0 | Local Park 2 | 4 | |
10230 | 10230 | 10229 | {"type": "Polygon", "coordinates": [[[-121.35335, 37.95744], [-121.35337, 37.95751], [-121.35333, 37.95762], [-121.3532, 37.95766], [-121.35303, 37.95763], [-121.35206, 37.95732], [-121.35197, 37.95727], [-121.35133, 37.957], [-121.35082, 37.95683], [-121.35037, 37.95666], [-121.34986, 37.95654], [-121.34942, 37.95637], [-121.34846, 37.95608], [-121.34776, 37.95584], [-121.3473, 37.95576], [-121.34699, 37.95577], [-121.34689, 37.95581], [-121.34682, 37.95586], [-121.3468, 37.95591], [-121.34683, 37.95598], [-121.34749, 37.95638], [-121.34789, 37.95665], [-121.34802, 37.95676], [-121.34806, 37.95681], [-121.34805, 37.95687], [-121.34765, 37.95709], [-121.3471, 37.95733], [-121.34682, 37.95752], [-121.34663, 37.95761], [-121.34604, 37.95764], [-121.34597, 37.95779], [-121.34378, 37.95719], [-121.3439, 37.95681], [-121.34391, 37.95665], [-121.34384, 37.95655], [-121.34379, 37.95652], [-121.34357, 37.9565], [-121.34345, 37.95654], [-121.34321, 37.95678], [-121.34318, 37.95688], [-121.34301, 37.95719], [-121.34295, 37.95735], [-121.34296, 37.95756], [-121.34298, 37.95774], [-121.34303, 37.95789], [-121.34308, 37.95799], [-121.34307, 37.95811], [-121.34309, 37.95819], [-121.34314, 37.95834], [-121.34318, 37.9584], [-121.34327, 37.95843], [-121.34331, 37.95847], [-121.34331, 37.95855], [-121.34326, 37.95858], [-121.34286, 37.95864], [-121.34079, 37.95921], [-121.33981, 37.95547], [-121.34402, 37.95477], [-121.34397, 37.95458], [-121.34452, 37.95473], [-121.34538, 37.95518], [-121.34578, 37.95536], [-121.34604, 37.95553], [-121.34696, 37.9555], [-121.35169, 37.95684], [-121.35298, 37.95725], [-121.35335, 37.95744]]]} | Open Access 1 | 17899 | Louis Park | 21548 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 52.026 | Louis Park | 0 | Local Park 2 | 4 | |
10224 | 10224 | 10223 | {"type": "Polygon", "coordinates": [[[-121.35181, 38.0412], [-121.3518, 38.04233], [-121.35177, 38.04239], [-121.3517, 38.04246], [-121.35168, 38.04251], [-121.35171, 38.04259], [-121.35178, 38.04264], [-121.35076, 38.04263], [-121.35031, 38.04265], [-121.35031, 38.04117], [-121.35179, 38.04118], [-121.35181, 38.0412]]]} | Open Access 1 | 17883 | Laughlin Park | 21085 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 5.196 | Laughlin Park | 0 | Local Park 2 | 4 | |
10241 | 10241 | 10240 | {"type": "Polygon", "coordinates": [[[-121.35015, 38.02981], [-121.35013, 38.02981], [-121.35007, 38.02977], [-121.35001, 38.02976], [-121.34983, 38.02982], [-121.34566, 38.02985], [-121.34562, 38.02842], [-121.35009, 38.02841], [-121.35015, 38.02981]]]} | Open Access 1 | 17921 | Sandman Park | 25019 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 15.281 | Sandman Park | 0 | Local Park 2 | 4 | |
15726 | 15726 | 15725 | {"type": "Polygon", "coordinates": [[[-121.35011, 38.00588], [-121.35004, 38.01275], [-121.34999, 38.01357], [-121.34999, 38.0139], [-121.34458, 38.01387], [-121.34456, 38.01382], [-121.3444, 38.01383], [-121.34423, 38.01388], [-121.34401, 38.01385], [-121.34353, 38.01386], [-121.34194, 38.01385], [-121.34193, 38.01343], [-121.34157, 38.01321], [-121.34097, 38.01292], [-121.34055, 38.01281], [-121.3402, 38.01281], [-121.33982, 38.01299], [-121.3398, 38.01271], [-121.3399, 38.01222], [-121.3399, 38.01198], [-121.33979, 38.01131], [-121.33974, 38.01117], [-121.33959, 38.01089], [-121.33949, 38.01042], [-121.33946, 38.01024], [-121.33946, 38.00978], [-121.33943, 38.00953], [-121.339, 38.00759], [-121.33895, 38.00678], [-121.33893, 38.00624], [-121.33893, 38.00616], [-121.33883, 38.00582], [-121.33885, 38.00578], [-121.33931, 38.0056], [-121.33958, 38.00551], [-121.33977, 38.00587], [-121.34029, 38.0058], [-121.34097, 38.00576], [-121.34363, 38.00548], [-121.34361, 38.00516], [-121.34536, 38.00526], [-121.34662, 38.00515], [-121.34957, 38.00503], [-121.34961, 38.00504], [-121.34964, 38.00507], [-121.34967, 38.00531], [-121.34978, 38.00555], [-121.3499, 38.00571], [-121.35011, 38.00588]], [[-121.34012, 38.00965], [-121.34012, 38.0096], [-121.34008, 38.0096], [-121.34008, 38.00965], [-121.34012, 38.00965]]]} | Restricted Access 2 | 44950 | Swenson Park Golf Course | 33122 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 213.574 | Swenson Park GC | 0 | Local Recreation Area 3 | 4 | |
14408 | 14408 | 14407 | {"type": "Polygon", "coordinates": [[[-121.34974, 37.99512], [-121.34936, 37.99513], [-121.34921, 37.99498], [-121.34905, 37.99488], [-121.34854, 37.99465], [-121.34831, 37.99453], [-121.34808, 37.99433], [-121.34972, 37.99431], [-121.34974, 37.99512]]]} | Open Access 1 | 44521 | Barkleyville Dog Park | 15818 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 1.985 | Barkleyville Dog Park | 0 | Local Park 2 | 4 | |
15165 | 15165 | 15164 | {"type": "Polygon", "coordinates": [[[-121.34597, 37.95779], [-121.34588, 37.95797], [-121.34548, 37.95813], [-121.34457, 37.95838], [-121.34326, 37.95858], [-121.34331, 37.95855], [-121.34331, 37.95847], [-121.34327, 37.95843], [-121.34318, 37.95841], [-121.34314, 37.95834], [-121.34307, 37.95812], [-121.34308, 37.95799], [-121.34298, 37.95774], [-121.34296, 37.95756], [-121.34295, 37.95735], [-121.34301, 37.95719], [-121.34318, 37.95688], [-121.34321, 37.95678], [-121.34333, 37.95665], [-121.34346, 37.95654], [-121.34358, 37.9565], [-121.34379, 37.95652], [-121.34384, 37.95655], [-121.34391, 37.95665], [-121.3439, 37.95681], [-121.34379, 37.95719], [-121.34597, 37.95779]]]} | Restricted Access 2 | 46016 | Pixie Woods | 29339 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/government/departments/communityServices/attPixWood.html | San Joaquin 39 | 7.563 | Pixie Woods | None 1322 | ||
3527 | 3527 | 3526 | {"type": "Polygon", "coordinates": [[[-121.34589, 38.0487], [-121.34578, 38.04902], [-121.3457, 38.04939], [-121.34566, 38.04976], [-121.34565, 38.0503], [-121.34558, 38.05035], [-121.3447, 38.05035], [-121.34443, 38.05038], [-121.34418, 38.05044], [-121.34393, 38.05052], [-121.34367, 38.05063], [-121.3434, 38.0508], [-121.34319, 38.05098], [-121.34309, 38.051], [-121.34245, 38.05072], [-121.34236, 38.0507], [-121.34188, 38.05044], [-121.34185, 38.05006], [-121.34456, 38.05007], [-121.34459, 38.04833], [-121.34587, 38.04866], [-121.34589, 38.0487]]]} | Open Access 1 | 28069 | Baxter Park | 15869 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 9.101 | Baxter Park | 0 | Local Park 2 | 4 | |
14379 | 14379 | 14378 | {"type": "Polygon", "coordinates": [[[-121.34316, 37.94914], [-121.34325, 37.94926], [-121.34326, 37.94932], [-121.34324, 37.94938], [-121.34313, 37.94957], [-121.34173, 37.95234], [-121.3416, 37.95228], [-121.34148, 37.95221], [-121.341, 37.95207], [-121.34081, 37.95199], [-121.34051, 37.95191], [-121.34013, 37.95182], [-121.33985, 37.95179], [-121.33969, 37.95173], [-121.33942, 37.95168], [-121.33918, 37.95161], [-121.33824, 37.95147], [-121.33732, 37.95115], [-121.3371, 37.95109], [-121.33674, 37.95076], [-121.33654, 37.95056], [-121.33643, 37.95034], [-121.33631, 37.95005], [-121.33633, 37.94978], [-121.33644, 37.94953], [-121.33674, 37.94895], [-121.33698, 37.94858], [-121.33734, 37.94815], [-121.33747, 37.94788], [-121.33766, 37.94759], [-121.33778, 37.94745], [-121.33789, 37.94737], [-121.33809, 37.9473], [-121.33818, 37.9473], [-121.33854, 37.94714], [-121.33886, 37.94774], [-121.339, 37.94794], [-121.33917, 37.94814], [-121.33935, 37.94831], [-121.33965, 37.94854], [-121.33997, 37.94874], [-121.34022, 37.94886], [-121.34048, 37.94896], [-121.3408, 37.94906], [-121.34114, 37.94914], [-121.34137, 37.94917], [-121.34148, 37.94918], [-121.34149, 37.94912], [-121.34316, 37.94914]]]} | Restricted Access 2 | 44469 | Lyons Golf Course | 33104 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 47.107 | Lyons GC | 0 | Local Recreation Area 3 | 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]);