units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 1984
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1423 | 1423 | 1422 | {"type": "MultiPolygon", "coordinates": [[[[-121.78009, 37.31127], [-121.77989, 37.31137], [-121.77994, 37.31162], [-121.77991, 37.31167], [-121.77993, 37.31173], [-121.77978, 37.31181], [-121.78003, 37.31291], [-121.77984, 37.31293], [-121.7796, 37.31189], [-121.77937, 37.31162], [-121.77968, 37.31144], [-121.78008, 37.31124], [-121.78009, 37.31127]]], [[[-121.78054, 37.31411], [-121.77993, 37.31421], [-121.77983, 37.31377], [-121.78044, 37.31368], [-121.78054, 37.31411]]], [[[-121.7802, 37.31358], [-121.78, 37.31361], [-121.7799, 37.31318], [-121.7801, 37.31315], [-121.7802, 37.31358]]], [[[-121.78046, 37.31471], [-121.78026, 37.31474], [-121.78016, 37.3143], [-121.78036, 37.31427], [-121.78046, 37.31471]]]]} | Open Access 1 | 9205 | Tapestry Park | 26184 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.08 | Tapestry Park | 1984 | Local Park 2 | 4 | |
1546 | 1546 | 1545 | {"type": "Polygon", "coordinates": [[[-121.94629, 37.55413], [-121.94553, 37.55481], [-121.94613, 37.55522], [-121.94594, 37.55538], [-121.94582, 37.55544], [-121.94486, 37.55627], [-121.9447, 37.55637], [-121.94463, 37.55636], [-121.94461, 37.55634], [-121.94456, 37.55617], [-121.94449, 37.55605], [-121.94437, 37.55591], [-121.94414, 37.55573], [-121.94412, 37.55571], [-121.94413, 37.55567], [-121.94596, 37.55405], [-121.94603, 37.55402], [-121.9461, 37.55402], [-121.94629, 37.55413]]]} | Open Access 1 | 12987 | Buena Vista Park | 16491 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 4.54 | Buena Vista Park | 1984 | Local Park 2 | 4 | |
1733 | 1733 | 1732 | {"type": "Polygon", "coordinates": [[[-121.923, 37.48603], [-121.92178, 37.48647], [-121.92177, 37.48649], [-121.92182, 37.48658], [-121.92114, 37.48684], [-121.9199, 37.48473], [-121.9219, 37.48403], [-121.92244, 37.48494], [-121.92239, 37.48497], [-121.923, 37.48603]]]} | Open Access 1 | 12934 | Warm Springs Park | 27260 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 11.662 | Warm Springs Park | 1984 | Local Park 2 | 4 | |
2019 | 2019 | 2018 | {"type": "Polygon", "coordinates": [[[-122.21778, 37.48305], [-122.21644, 37.48394], [-122.21344, 37.48339], [-122.21436, 37.48199], [-122.21537, 37.48239], [-122.21599, 37.4823], [-122.21778, 37.48305]]]} | Open Access 1 | 16988 | Hoover Park | 20081 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 11.512 | Hoover Park | 1984 | Local Park 2 | 4 | |
3177 | 3177 | 3176 | {"type": "Polygon", "coordinates": [[[-121.85221, 37.26366], [-121.85167, 37.2637], [-121.85132, 37.26394], [-121.85132, 37.26373], [-121.8511, 37.26358], [-121.85036, 37.26427], [-121.84899, 37.26287], [-121.84939, 37.26237], [-121.84996, 37.26184], [-121.85001, 37.26183], [-121.85049, 37.26213], [-121.85077, 37.26228], [-121.85097, 37.26241], [-121.85184, 37.26308], [-121.85201, 37.26325], [-121.85208, 37.26334], [-121.85216, 37.2635], [-121.85221, 37.26366]]]} | Open Access 1 | 1912 | Vista Park | 27185 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 9.593 | Vista Park | 1984 | Local Park 2 | 4 | |
5090 | 5090 | 5089 | {"type": "Polygon", "coordinates": [[[-122.23169, 37.54244], [-122.23158, 37.54252], [-122.23125, 37.5428], [-122.23064, 37.54236], [-122.2304, 37.54226], [-122.23016, 37.5422], [-122.22984, 37.54218], [-122.22954, 37.54221], [-122.22927, 37.5423], [-122.22901, 37.54244], [-122.22963, 37.54196], [-122.23157, 37.54247], [-122.23163, 37.54247], [-122.23169, 37.54244]]]} | Open Access 1 | 13959 | Shores Dog Park | 25429 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 1.086 | Shores Dog Park | 1984 | Local Park 2 | 4 | |
5286 | 5286 | 5285 | {"type": "Polygon", "coordinates": [[[-122.08326, 37.37172], [-122.08271, 37.37173], [-122.0827, 37.37347], [-122.07912, 37.3734], [-122.07913, 37.37216], [-122.07878, 37.37215], [-122.07877, 37.37167], [-122.07799, 37.37167], [-122.07799, 37.37091], [-122.08326, 37.37097], [-122.08326, 37.37172]]]} | Open Access 1 | 15119 | Cuesta Park | 17850 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 25.194 | Cuesta Park | 1984 | Local Park 2 | 4 | |
5475 | 5475 | 5474 | {"type": "Polygon", "coordinates": [[[-121.83923, 37.359], [-121.83914, 37.35909], [-121.83875, 37.35927], [-121.83871, 37.35928], [-121.83867, 37.35926], [-121.83633, 37.35687], [-121.83565, 37.35587], [-121.83599, 37.35588], [-121.83666, 37.35661], [-121.83681, 37.35652], [-121.83923, 37.359]]]} | Open Access 1 | 17405 | Lo Bue Park | 21390 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.833 | Lo Bue Park | 1984 | Local Park 2 | 4 | |
6077 | 6077 | 6076 | {"type": "Polygon", "coordinates": [[[-121.8399, 37.21622], [-121.83961, 37.2161], [-121.83965, 37.21605], [-121.83964, 37.21604], [-121.83923, 37.21594], [-121.83739, 37.21489], [-121.8362, 37.2147], [-121.83507, 37.21412], [-121.83433, 37.21407], [-121.83417, 37.21402], [-121.83305, 37.2138], [-121.83255, 37.21372], [-121.83138, 37.2133], [-121.82978, 37.2127], [-121.82883, 37.21165], [-121.82736, 37.2108], [-121.82611, 37.20976], [-121.8254, 37.2092], [-121.82373, 37.20715], [-121.82398, 37.20696], [-121.82419, 37.20722], [-121.82437, 37.20754], [-121.82451, 37.20773], [-121.82494, 37.20819], [-121.82558, 37.20884], [-121.82608, 37.20927], [-121.82631, 37.20944], [-121.82672, 37.2098], [-121.82767, 37.21065], [-121.82801, 37.21094], [-121.82817, 37.21104], [-121.82868, 37.21128], [-121.82899, 37.21148], [-121.82918, 37.21165], [-121.82933, 37.21183], [-121.82946, 37.21201], [-121.82962, 37.21219], [-121.82977, 37.21233], [-121.83008, 37.21252], [-121.83038, 37.21265], [-121.83067, 37.21273], [-121.83097, 37.21279], [-121.83133, 37.2128], [-121.83159, 37.21279], [-121.8319, 37.21274], [-121.83377, 37.21223], [-121.83403, 37.21219], [-121.83436, 37.21218], [-121.83476, 37.21223], [-121.83528, 37.2124], [-121.8356, 37.21254], [-121.83579, 37.21265], [-121.8358, 37.21271], [-121.83708, 37.21396], [-121.83744, 37.21429], [-121.83795, 37.2146], [-121.8395, 37.21541], [-121.83982, 37.21556], [-121.8399, 37.21622]]]} | Open Access 1 | 860 | Singer Park | 25518 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 31.405 | Singer Park | 1984 | Local Park 2 | 4 | |
8297 | 8297 | 8296 | {"type": "Polygon", "coordinates": [[[-122.02239, 37.53645], [-122.02193, 37.53702], [-122.0216, 37.53688], [-122.0216, 37.53681], [-122.02155, 37.53674], [-122.02091, 37.5364], [-122.02082, 37.5363], [-122.02073, 37.53612], [-122.02064, 37.536], [-122.0205, 37.53588], [-122.0203, 37.53577], [-122.02028, 37.53573], [-122.02049, 37.53547], [-122.02239, 37.53645]]]} | Open Access 1 | 12790 | Byington Park | 16617 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 2.957 | Byington Park | 1984 | Local Park 2 | 4 | |
8313 | 8313 | 8312 | {"type": "Polygon", "coordinates": [[[-122.05539, 37.53459], [-122.05494, 37.53486], [-122.05338, 37.53409], [-122.05373, 37.53374], [-122.05382, 37.53347], [-122.05426, 37.53356], [-122.05443, 37.53361], [-122.05462, 37.53369], [-122.05477, 37.53378], [-122.05494, 37.53391], [-122.05514, 37.53414], [-122.05539, 37.53459]]]} | Open Access 1 | 12763 | Bridgepointe Park | 16377 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 3.527 | Bridgepointe Park | 1984 | Local Park 2 | 4 | |
8323 | 8323 | 8322 | {"type": "Polygon", "coordinates": [[[-122.01182, 37.51583], [-122.01166, 37.51629], [-122.01053, 37.51879], [-122.01011, 37.51977], [-122.00949, 37.51959], [-122.0089, 37.51936], [-122.00863, 37.51996], [-122.00771, 37.51964], [-122.00981, 37.51481], [-122.01051, 37.51513], [-122.01045, 37.51521], [-122.01046, 37.51523], [-122.01182, 37.51583]]]} | Open Access 1 | 12802 | Newark Sportsfield Park | 22713 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 25.97 | Newark Sportsfield Park | 1984 | Local Park 2 | 4 | |
8329 | 8329 | 8328 | {"type": "MultiPolygon", "coordinates": [[[[-121.91002, 37.46761], [-121.90977, 37.4677], [-121.90874, 37.46595], [-121.90901, 37.46587], [-121.91002, 37.46761]]], [[[-121.9104, 37.46826], [-121.91022, 37.46833], [-121.91016, 37.46837], [-121.90986, 37.46784], [-121.9101, 37.46776], [-121.9104, 37.46826]]], [[[-121.91157, 37.47029], [-121.91138, 37.47037], [-121.91134, 37.47036], [-121.9113, 37.47034], [-121.91026, 37.46854], [-121.91025, 37.4685], [-121.91028, 37.46846], [-121.91048, 37.46839], [-121.91157, 37.47029]]], [[[-121.91227, 37.4715], [-121.91208, 37.47158], [-121.91203, 37.47157], [-121.912, 37.47155], [-121.91143, 37.47057], [-121.91143, 37.47054], [-121.91145, 37.47051], [-121.91165, 37.47043], [-121.91227, 37.4715]]]]} | Open Access 1 | 12816 | Plomosa Park | 23812 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 3.848 | Plomosa Park | 1984 | Local Park 2 | 4 | |
8410 | 8410 | 8409 | {"type": "Polygon", "coordinates": [[[-121.93952, 37.54652], [-121.93642, 37.5475], [-121.93634, 37.54757], [-121.93601, 37.54739], [-121.93593, 37.54741], [-121.93544, 37.54713], [-121.93594, 37.54656], [-121.93702, 37.54623], [-121.93777, 37.54539], [-121.93841, 37.54539], [-121.93841, 37.54585], [-121.93928, 37.54636], [-121.93952, 37.54652]]]} | Open Access 1 | 13027 | Mission San Jose Community Park | 22310 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 9.578 | Mission San Jose Community Park | 1984 | Local Park 2 | 4 | |
8414 | 8414 | 8413 | {"type": "Polygon", "coordinates": [[[-121.92796, 37.5226], [-121.92787, 37.52269], [-121.92771, 37.52293], [-121.92771, 37.52297], [-121.92773, 37.52305], [-121.92758, 37.52326], [-121.92747, 37.52349], [-121.92705, 37.52345], [-121.92659, 37.52335], [-121.9262, 37.52319], [-121.92571, 37.52289], [-121.92557, 37.52283], [-121.92533, 37.52276], [-121.92494, 37.52273], [-121.92454, 37.52275], [-121.92429, 37.52279], [-121.92409, 37.52284], [-121.92385, 37.52293], [-121.92364, 37.52303], [-121.9235, 37.52312], [-121.92328, 37.52328], [-121.92319, 37.52329], [-121.92315, 37.52328], [-121.92297, 37.52311], [-121.92273, 37.52296], [-121.92265, 37.52288], [-121.92257, 37.52277], [-121.92252, 37.52263], [-121.92238, 37.52166], [-121.92232, 37.52148], [-121.92219, 37.52124], [-121.92219, 37.52121], [-121.92223, 37.52116], [-121.92312, 37.52085], [-121.92328, 37.52081], [-121.92348, 37.52079], [-121.92406, 37.52084], [-121.92432, 37.52083], [-121.92462, 37.52078], [-121.92494, 37.52067], [-121.92502, 37.52066], [-121.92506, 37.52068], [-121.92529, 37.52097], [-121.92552, 37.52121], [-121.92573, 37.52139], [-121.92596, 37.52155], [-121.92634, 37.52177], [-121.92772, 37.52242], [-121.92796, 37.5226]]]} | Open Access 1 | 13041 | Old Mission Park | 23094 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 22.896 | Old Mission Park | 1984 | Local Park 2 | 4 | |
8590 | 8590 | 8589 | {"type": "Polygon", "coordinates": [[[-121.79518, 37.23742], [-121.79515, 37.23746], [-121.79513, 37.23751], [-121.79514, 37.2387], [-121.79513, 37.23879], [-121.7951, 37.23884], [-121.79504, 37.23888], [-121.79496, 37.23889], [-121.79468, 37.23884], [-121.79447, 37.23881], [-121.79399, 37.2388], [-121.79393, 37.23878], [-121.79391, 37.23873], [-121.79387, 37.23693], [-121.79388, 37.2369], [-121.79394, 37.23688], [-121.79461, 37.23701], [-121.79518, 37.23708], [-121.79518, 37.23742]]]} | Open Access 1 | 13660 | George Page Park | 19272 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.628 | George Page Park | 1984 | Local Park 2 | 4 | |
8705 | 8705 | 8704 | {"type": "Polygon", "coordinates": [[[-121.96284, 37.40502], [-121.9613, 37.40567], [-121.96112, 37.40543], [-121.96115, 37.40536], [-121.96112, 37.40529], [-121.96107, 37.40526], [-121.96094, 37.40524], [-121.96086, 37.40521], [-121.96077, 37.40514], [-121.9607, 37.40506], [-121.96066, 37.40497], [-121.96065, 37.40481], [-121.96058, 37.40461], [-121.96062, 37.40457], [-121.96163, 37.40414], [-121.96205, 37.40477], [-121.96284, 37.40502]]]} | Open Access 1 | 14124 | Fairway Glen Park | 18822 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 4.07 | Fairway Glen Park | 1984 | Local Park 2 | 4 | |
8707 | 8707 | 8706 | {"type": "Polygon", "coordinates": [[[-121.96563, 37.39796], [-121.96499, 37.39824], [-121.96491, 37.39816], [-121.96458, 37.39769], [-121.96438, 37.39777], [-121.96431, 37.39773], [-121.96432, 37.39768], [-121.96448, 37.3976], [-121.9642, 37.39717], [-121.96427, 37.39718], [-121.96433, 37.39715], [-121.9644, 37.39704], [-121.96447, 37.39699], [-121.9648, 37.39685], [-121.96488, 37.39686], [-121.96563, 37.39796]]]} | Open Access 1 | 14128 | Fuller Street Park | 19142 | 1318 | Santa Clara, City of 401 | City 2 | City Agency 2 | http://santaclaraca.gov/index.aspx?page=123 | City 2 | 1318 | Santa Clara, City of 395 | City 2 | City Agency 2 | Santa Clara 19 | 2.43 | Fuller Street Park | 1984 | Local Park 2 | 4 | |
9073 | 9073 | 9072 | {"type": "Polygon", "coordinates": [[[-122.06486, 37.38113], [-122.06466, 37.38108], [-122.06444, 37.38119], [-122.06416, 37.38201], [-122.06399, 37.38227], [-122.06422, 37.38247], [-122.06408, 37.38256], [-122.06391, 37.38263], [-122.06372, 37.38267], [-122.06364, 37.38242], [-122.06333, 37.38238], [-122.06305, 37.38233], [-122.06295, 37.3826], [-122.06236, 37.38246], [-122.062, 37.3823], [-122.06174, 37.38223], [-122.06171, 37.38218], [-122.06209, 37.38103], [-122.06283, 37.38118], [-122.06287, 37.38104], [-122.06285, 37.38085], [-122.063, 37.38081], [-122.06307, 37.38076], [-122.06312, 37.38069], [-122.06336, 37.38077], [-122.06423, 37.38097], [-122.06446, 37.38085], [-122.06452, 37.38069], [-122.06489, 37.38078], [-122.06495, 37.38081], [-122.06495, 37.38086], [-122.06486, 37.38113]]]} | Open Access 1 | 15018 | Sylvan Park | 26150 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 9.261 | Sylvan Park | 1984 | Local Park 2 | 4 | |
9093 | 9093 | 9092 | {"type": "Polygon", "coordinates": [[[-122.0192, 37.34862], [-122.01805, 37.34863], [-122.01804, 37.34683], [-122.01919, 37.34683], [-122.0192, 37.34862]]]} | Open Access 1 | 15070 | Panama Park | 23385 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 5.019 | Panama Park | 1984 | 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]);