units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 396 and MNG_AG_TYP = 2 sorted by rowid 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17039 | 17039 | 17038 | {"type": "Polygon", "coordinates": [[[-121.29458, 37.95402], [-121.29455, 37.95407], [-121.29456, 37.95412], [-121.29396, 37.95531], [-121.29388, 37.95538], [-121.29374, 37.95544], [-121.29362, 37.95545], [-121.29271, 37.9554], [-121.2927, 37.95548], [-121.2927, 37.95549], [-121.29374, 37.95554], [-121.29215, 37.95577], [-121.29166, 37.95409], [-121.29334, 37.9539], [-121.2945, 37.95393], [-121.29454, 37.95394], [-121.29458, 37.95402]]]} | Open Access 1 | 29645 | Weber Point Event Center | 27326 | 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.256 | Weber Point Event Ctr. | 0 | Local Recreation Area 3 | 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 | |
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 | ||
14819 | 14819 | 14818 | {"type": "Polygon", "coordinates": [[[-121.29389, 37.95337], [-121.29284, 37.95343], [-121.29154, 37.95366], [-121.29152, 37.95359], [-121.29384, 37.9532], [-121.29389, 37.95337]]]} | Open Access 1 | 47253 | South Seawall Park | 30964 | 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.536 | South Seawall Park | 0 | Local Park 2 | 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 | |
14407 | 14407 | 14406 | {"type": "MultiPolygon", "coordinates": [[[[-121.24276, 37.94494], [-121.24241, 37.94502], [-121.2421, 37.94427], [-121.24212, 37.94424], [-121.24242, 37.94415], [-121.24276, 37.94494]]], [[[-121.24417, 37.94457], [-121.24348, 37.94475], [-121.24316, 37.94397], [-121.24386, 37.94379], [-121.24417, 37.94457]]]]} | Open Access 1 | 44520 | Missassi Park | 22291 | 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.166 | Missassi Park | 0 | Local Park 2 | 4 | |
14382 | 14382 | 14381 | {"type": "Polygon", "coordinates": [[[-121.29836, 37.95423], [-121.29765, 37.95435], [-121.29745, 37.95427], [-121.29721, 37.95431], [-121.29711, 37.95444], [-121.29674, 37.9545], [-121.29678, 37.95444], [-121.29671, 37.9544], [-121.2965, 37.95444], [-121.29635, 37.95436], [-121.29585, 37.95445], [-121.29569, 37.95464], [-121.29559, 37.95466], [-121.2956, 37.95476], [-121.29554, 37.95483], [-121.29543, 37.95486], [-121.29531, 37.95484], [-121.29515, 37.95515], [-121.29519, 37.95522], [-121.2951, 37.95538], [-121.29501, 37.95541], [-121.29489, 37.95563], [-121.29482, 37.95566], [-121.29491, 37.95601], [-121.29449, 37.95608], [-121.29341, 37.9568], [-121.29338, 37.9567], [-121.29346, 37.9567], [-121.29454, 37.95597], [-121.29454, 37.95595], [-121.29472, 37.95561], [-121.2948, 37.95558], [-121.29499, 37.95534], [-121.29518, 37.955], [-121.29518, 37.95492], [-121.29532, 37.95469], [-121.29538, 37.95461], [-121.29544, 37.95461], [-121.29564, 37.95457], [-121.29579, 37.95439], [-121.29636, 37.95429], [-121.29651, 37.95436], [-121.29671, 37.95433], [-121.29676, 37.95435], [-121.29713, 37.95428], [-121.29716, 37.95426], [-121.29722, 37.95425], [-121.29724, 37.95423], [-121.29745, 37.9542], [-121.29762, 37.95426], [-121.29834, 37.95414], [-121.29836, 37.95423]]]} | Open Access 1 | 44481 | North Seawall Park | 22858 | 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.457 | North Seawall Park | 0 | Local Park 2 | 4 | |
14380 | 14380 | 14379 | {"type": "Polygon", "coordinates": [[[-121.32358, 38.0547], [-121.32333, 38.05496], [-121.3228, 38.05477], [-121.32161, 38.05457], [-121.32162, 38.05455], [-121.32168, 38.05455], [-121.32174, 38.05453], [-121.32179, 38.0545], [-121.32182, 38.05445], [-121.32182, 38.0544], [-121.3218, 38.05435], [-121.32176, 38.05431], [-121.3217, 38.05429], [-121.3216, 38.05429], [-121.32148, 38.05435], [-121.32139, 38.05437], [-121.32061, 38.05424], [-121.32001, 38.05422], [-121.32003, 38.05355], [-121.32033, 38.05349], [-121.32063, 38.05341], [-121.3217, 38.05304], [-121.32192, 38.053], [-121.322, 38.05294], [-121.3225, 38.05277], [-121.32358, 38.0547]]]} | Open Access 1 | 44473 | Dortha May Pitts Park | 18224 | 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.994 | Dortha May Pitts 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 | |
14373 | 14373 | 14372 | {"type": "Polygon", "coordinates": [[[-121.32721, 37.92871], [-121.32679, 37.92881], [-121.32637, 37.92852], [-121.32606, 37.92838], [-121.3258, 37.92829], [-121.32509, 37.92854], [-121.32503, 37.92834], [-121.32491, 37.92816], [-121.32475, 37.92804], [-121.3245, 37.92792], [-121.32447, 37.92788], [-121.32449, 37.92773], [-121.32449, 37.92713], [-121.3245, 37.92708], [-121.32456, 37.92701], [-121.32456, 37.92696], [-121.32455, 37.92691], [-121.32451, 37.92688], [-121.3244, 37.92684], [-121.32435, 37.92671], [-121.32435, 37.92662], [-121.3248, 37.92662], [-121.32518, 37.92716], [-121.32556, 37.92764], [-121.32591, 37.92788], [-121.32594, 37.92792], [-121.32624, 37.92803], [-121.32693, 37.92837], [-121.32704, 37.92844], [-121.32721, 37.92871]]]} | Open Access 1 | 44477 | Peri Park | 23610 | 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.057 | Peri Park | 0 | Local Park 2 | 4 | |
14365 | 14365 | 14364 | {"type": "Polygon", "coordinates": [[[-121.26468, 38.04968], [-121.26465, 38.04973], [-121.26465, 38.04998], [-121.26374, 38.04998], [-121.26363, 38.0485], [-121.26402, 38.04848], [-121.26403, 38.04863], [-121.26402, 38.04882], [-121.26405, 38.04889], [-121.26411, 38.04893], [-121.26421, 38.04896], [-121.26447, 38.04893], [-121.26459, 38.04893], [-121.26461, 38.04895], [-121.26461, 38.04935], [-121.26458, 38.04955], [-121.26461, 38.04963], [-121.26468, 38.04968]]]} | Open Access 1 | 44479 | Future Stockton City Park 2 | 19163 | 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.713 | Future Stockton City Park 2 | None 1217 | |||
14341 | 14341 | 14340 | {"type": "Polygon", "coordinates": [[[-121.27479, 38.0433], [-121.27478, 38.04383], [-121.27472, 38.04441], [-121.27212, 38.04445], [-121.27204, 38.04335], [-121.27211, 38.04329], [-121.27476, 38.04327], [-121.27479, 38.0433]]]} | Open Access 1 | 44475 | Future Stockton City Park | 19162 | 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 | 7.464 | Future Stockton City 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 | |
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 | |
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 | |
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 | |
13703 | 13703 | 13702 | {"type": "Polygon", "coordinates": [[[-121.2634, 38.04678], [-121.25918, 38.04681], [-121.25898, 38.04416], [-121.25901, 38.04388], [-121.2591, 38.04355], [-121.25911, 38.04302], [-121.26311, 38.04296], [-121.2634, 38.04678]]]} | Open Access 1 | 36079 | Detention Basin Soccer Complex | 18118 | 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 | 38.293 | Detention Basin Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
13675 | 13675 | 13674 | {"type": "Polygon", "coordinates": [[[-121.26768, 37.93402], [-121.2646, 37.9347], [-121.2642, 37.9336], [-121.26728, 37.9329], [-121.26768, 37.93402]]]} | Open Access 1 | 36049 | Williams Brotherhood Park | 27561 | 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 | 8.873 | Williams Brotherhood Park | 0 | Local Park 2 | 4 | |
13674 | 13674 | 13673 | {"type": "Polygon", "coordinates": [[[-121.28708, 37.99348], [-121.28675, 37.99352], [-121.28606, 37.99371], [-121.28533, 37.99376], [-121.28547, 37.99414], [-121.28515, 37.99423], [-121.28504, 37.99413], [-121.28495, 37.99411], [-121.28488, 37.99411], [-121.28464, 37.99419], [-121.28354, 37.99448], [-121.28329, 37.99451], [-121.28319, 37.99457], [-121.28291, 37.99438], [-121.28261, 37.99453], [-121.28239, 37.99399], [-121.28292, 37.99369], [-121.28409, 37.9933], [-121.28514, 37.99319], [-121.28651, 37.99308], [-121.28687, 37.99299], [-121.28704, 37.99345], [-121.28707, 37.99345], [-121.28708, 37.99348]]]} | Open Access 1 | 36047 | Arnold Rue Park | 15604 | 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 | 8.526 | Arnold Rue 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]);