units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Los Angeles, County of 155
- Santa Barbara, County of 117
- San Diego, County of 117
- Orange, County of 91
- Los Angeles - Department of Parks and Recreation, County of 60
- Lake, County of 56
- Sacramento, County of 55
- Butte, County of 53
- Santa Cruz, County of 51
- Kern, County of 47
- Monterey, County of 46
- El Dorado, County of 42
- Riverside, County of 38
- San Luis Obispo, County of 31
- Placer, County of 28
- Ventura, County of 24
- Stanislaus, County of 24
- San Joaquin, County of 21
- Yolo, County of 18
- Fresno, County of 17
- San Bernardino, County of 17
- Merced, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- …
DES_TP >30
- Local Park 687
- Local Other or Unknown 214
- Local Recreation Area 126
- Local Conservation Area 98
- Local Historic or Cultural Area 21
- National Forest 2
- National Monument or Landmark 2
- None 1
- State Conservation Area 1
- None 1
- National Recreation Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
- Open Access 1,135
- Restricted Access 63
- Unknown Access 36
- No Public Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15021 | 15021 | 15020 | {"type": "Polygon", "coordinates": [[[-121.02525, 39.27137], [-121.02458, 39.27178], [-121.02463, 39.2722], [-121.02458, 39.27234], [-121.02427, 39.27257], [-121.02436, 39.27291], [-121.02413, 39.27301], [-121.02351, 39.2731], [-121.02323, 39.2731], [-121.02296, 39.27305], [-121.02255, 39.27293], [-121.02227, 39.27278], [-121.02207, 39.27253], [-121.02238, 39.27212], [-121.02238, 39.27195], [-121.02298, 39.2717], [-121.02307, 39.27154], [-121.02315, 39.27146], [-121.02322, 39.2713], [-121.02336, 39.27113], [-121.02397, 39.27013], [-121.02405, 39.27005], [-121.02429, 39.27012], [-121.02424, 39.27023], [-121.02421, 39.27049], [-121.02429, 39.27056], [-121.02445, 39.27055], [-121.02472, 39.27038], [-121.02453, 39.27084], [-121.02463, 39.27121], [-121.02525, 39.27137]]]} | Open Access 1 | 45668 | Tobiassen Park | 28508 | 361 | Nevada, County of 1134 | County 3 | County Agency 3 | http://mynevadacounty.com/ | County 3 | 361 | Nevada, County of 1089 | County 3 | County Agency 3 | Nevada 30 | 10.972 | Tobiassen Park | 0 | Local Park 2 | 4 | |
14983 | 14983 | 14982 | {"type": "Polygon", "coordinates": [[[-120.70579, 38.3017], [-120.70573, 38.30198], [-120.70526, 38.30193], [-120.70527, 38.30181], [-120.70536, 38.30152], [-120.70544, 38.30153], [-120.70545, 38.30156], [-120.70552, 38.30157], [-120.70551, 38.30168], [-120.70579, 38.3017]]]} | Open Access 1 | 45612 | Shutter Tree Park | 28439 | 350 | Calaveras, County of 1131 | County 3 | County Agency 3 | http://co.calaveras.ca.us/ | County 3 | 350 | Calaveras, County of 1086 | County 3 | County Agency 3 | Calaveras 53 | 0.371 | Shutter Tree Park | 0 | Local Park 2 | 4 | |
15035 | 15035 | 15034 | {"type": "Polygon", "coordinates": [[[-120.34443, 38.26473], [-120.34436, 38.26898], [-120.34298, 38.26917], [-120.34042, 38.2728], [-120.33898, 38.27538], [-120.33742, 38.27467], [-120.33708, 38.27336], [-120.33764, 38.271], [-120.33958, 38.26716], [-120.33977, 38.26715], [-120.33976, 38.26654], [-120.3405, 38.26662], [-120.34091, 38.26612], [-120.34127, 38.26616], [-120.34133, 38.26589], [-120.34146, 38.26588], [-120.34157, 38.26581], [-120.34172, 38.26567], [-120.34196, 38.26552], [-120.34244, 38.26534], [-120.34271, 38.26528], [-120.34298, 38.26524], [-120.34341, 38.26524], [-120.34361, 38.2652], [-120.3438, 38.26512], [-120.34433, 38.26482], [-120.34443, 38.26473]]]} | Open Access 1 | 45688 | White Pines Park | 28500 | 350 | Calaveras, County of 1131 | County 3 | County Agency 3 | http://co.calaveras.ca.us/ | County 3 | 350 | Calaveras, County of 1086 | County 3 | County Agency 3 | Calaveras 53 | 89.744 | White Pines Park | 0 | Local Park 2 | 4 | |
14962 | 14962 | 14961 | {"type": "Polygon", "coordinates": [[[-121.63678, 39.14842], [-121.63578, 39.14842], [-121.63581, 39.14765], [-121.63579, 39.147], [-121.63636, 39.147], [-121.63677, 39.14682], [-121.63678, 39.14842]]]} | Open Access 1 | 45574 | Howard Harter Park | 28400 | 366 | Sutter, County of 1128 | County 3 | County Agency 3 | http://www.co.sutter.ca.us/ | County 3 | 366 | Sutter, County of 1083 | County 3 | County Agency 3 | Sutter 47 | 3.402 | Howard Harter Park | 0 | Local Park 2 | 4 | |
14981 | 14981 | 14980 | {"type": "Polygon", "coordinates": [[[-121.63358, 39.27281], [-121.63254, 39.27519], [-121.63254, 39.27536], [-121.6327, 39.27598], [-121.63105, 39.27599], [-121.63025, 39.27499], [-121.63004, 39.27326], [-121.63182, 39.27344], [-121.63195, 39.27327], [-121.63234, 39.27302], [-121.63264, 39.27265], [-121.63358, 39.27281]]]} | Open Access 1 | 45598 | Live Oak Park and Recreation Area | 28424 | 366 | Sutter, County of 1128 | County 3 | County Agency 3 | http://www.co.sutter.ca.us/ | County 3 | 366 | Sutter, County of 1083 | County 3 | County Agency 3 | https://www.co.sutter.ca.us/doc/living/entertainment/recreation/pw_live_oak_park | Sutter 47 | 17.329 | Live Oak Park and Rec. Area | 0 | Local Recreation Area 3 | 4 |
14921 | 14921 | 14920 | {"type": "Polygon", "coordinates": [[[-120.44035, 39.66542], [-120.43985, 39.66578], [-120.43938, 39.66545], [-120.43915, 39.66551], [-120.43881, 39.66573], [-120.43851, 39.66605], [-120.43835, 39.66605], [-120.43777, 39.6656], [-120.43785, 39.66553], [-120.43894, 39.66527], [-120.43961, 39.66496], [-120.44035, 39.66542]]]} | Open Access 1 | 45494 | Calpine Park | 28323 | 364 | Sierra, County of 1126 | County 3 | County Agency 3 | http://www.sierracounty.ca.gov/index.aspx?nid=289 | County 3 | 364 | Sierra, County of 1081 | County 3 | County Agency 3 | Sierra 58 | 2.651 | Calpine Park | 0 | Local Park 2 | 4 | |
14295 | 14295 | 14294 | {"type": "Polygon", "coordinates": [[[-121.61997, 37.90654], [-121.61837, 37.90657], [-121.61747, 37.90656], [-121.61748, 37.90592], [-121.61867, 37.90531], [-121.61898, 37.90506], [-121.61898, 37.90495], [-121.61947, 37.90532], [-121.61964, 37.90549], [-121.61976, 37.90565], [-121.61987, 37.90588], [-121.61992, 37.90603], [-121.61995, 37.90619], [-121.61997, 37.90654]]]} | Open Access 1 | 44229 | Slifer Park | 25558 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | Contra Costa 12 | 6.525 | Slifer Park | 0 | Local Park 2 | 4 | |
14953 | 14953 | 14952 | {"type": "Polygon", "coordinates": [[[-122.03078, 38.03015], [-122.03061, 38.03021], [-122.03036, 38.02969], [-122.03052, 38.02965], [-122.03078, 38.03015]]]} | Open Access 1 | 45559 | Big Oak Tree Park | 28387 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | http://www.contracosta.ca.gov/4398/Clyde | Contra Costa 12 | 0.241 | Big Oak Tree Park | 0 | Local Park 2 | 4 |
14961 | 14961 | 14960 | {"type": "Polygon", "coordinates": [[[-122.07002, 37.98678], [-122.06947, 37.98652], [-122.06924, 37.98637], [-122.06881, 37.98575], [-122.06874, 37.98561], [-122.06869, 37.98543], [-122.0683, 37.98352], [-122.06884, 37.98351], [-122.06919, 37.98462], [-122.06922, 37.98477], [-122.0692, 37.98517], [-122.06931, 37.98555], [-122.06955, 37.986], [-122.07001, 37.98661], [-122.07002, 37.98678]]]} | Open Access 1 | 45572 | Hayden Park | 28398 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | Contra Costa 12 | 4.478 | Hayden Park | 0 | Local Park 2 | 4 | |
13013 | 13013 | 13012 | {"type": "MultiPolygon", "coordinates": [[[[-121.91526, 38.26143], [-121.91525, 38.26144], [-121.91516, 38.26502], [-121.90682, 38.27189], [-121.89801, 38.2782], [-121.89805, 38.27195], [-121.89805, 38.26472], [-121.87929, 38.26469], [-121.87927, 38.27171], [-121.87387, 38.27167], [-121.87397, 38.27128], [-121.87929, 38.26469], [-121.89614, 38.24998], [-121.89617, 38.24991], [-121.89819, 38.24991], [-121.89826, 38.24289], [-121.91522, 38.24301], [-121.91521, 38.25733], [-121.91525, 38.26116], [-121.91523, 38.26117], [-121.91526, 38.26143]]], [[[-121.91491, 38.27353], [-121.91447, 38.28644], [-121.90677, 38.28644], [-121.89698, 38.28637], [-121.90575, 38.28009], [-121.90633, 38.27971], [-121.91491, 38.27353]]]]} | No Public Access 3 | 31205 | Wilcox Ranch | 27494 | 344 | Solano, County of 1037 | County 3 | County Agency 3 | http://www.co.solano.ca.us/depts/rm/countypark/homepage.asp | County 3 | 344 | Solano, County of 999 | County 3 | County Agency 3 | Solano 26 | 1870.595 | Wilcox Ranch | 0 | Local Other or Unknown 14 | 4 | |
12733 | 12733 | 12732 | {"type": "MultiPolygon", "coordinates": [[[[-122.50606, 38.01702], [-122.50538, 38.01773], [-122.50389, 38.0179], [-122.5039, 38.01851], [-122.4971, 38.01865], [-122.48, 38.02023], [-122.47926, 38.02067], [-122.47925, 38.02058], [-122.47924, 38.02057], [-122.46957, 38.02491], [-122.46829, 38.02814], [-122.46444, 38.03432], [-122.45826, 38.01394], [-122.45798, 38.00928], [-122.45797, 38.00928], [-122.45718, 38.01038], [-122.45356, 37.99846], [-122.46201, 38.00454], [-122.47026, 38.00744], [-122.47894, 38.01033], [-122.48622, 38.01267], [-122.48627, 38.01271], [-122.48923, 38.01368], [-122.49539, 38.01456], [-122.50181, 38.01539], [-122.50328, 38.01578], [-122.50332, 38.0158], [-122.50338, 38.01576], [-122.50344, 38.01707], [-122.50606, 38.01702]]], [[[-122.49754, 38.02919], [-122.49296, 38.02924], [-122.49287, 38.02566], [-122.49743, 38.02564], [-122.49754, 38.02919]]]]} | Open Access 1 | 29763 | Water Lots | 27293 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 353 | Marin, County of 996 | County 3 | County Agency 3 | Marin 23 | 1356.794 | Water Lots | 1976 | Local Other or Unknown 14 | 4 | |
14677 | 14677 | 14676 | {"type": "MultiPolygon", "coordinates": [[[[-122.49119, 37.8781], [-122.48776, 37.88368], [-122.48737, 37.88444], [-122.48336, 37.88288], [-122.48238, 37.8846], [-122.48632, 37.88604], [-122.4838, 37.89047], [-122.48247, 37.88939], [-122.48215, 37.88917], [-122.48181, 37.88898], [-122.48152, 37.88884], [-122.47989, 37.88823], [-122.47913, 37.88787], [-122.48029, 37.8859], [-122.48068, 37.88606], [-122.4814, 37.88629], [-122.48237, 37.8846], [-122.48122, 37.88414], [-122.48609, 37.87599], [-122.48677, 37.87623], [-122.49119, 37.8781]]], [[[-122.48654, 37.88697], [-122.49182, 37.87837], [-122.49434, 37.87888], [-122.49609, 37.88349], [-122.4939, 37.88719], [-122.49252, 37.88934], [-122.48979, 37.89388], [-122.48955, 37.89379], [-122.4886, 37.89402], [-122.48778, 37.89409], [-122.48771, 37.89414], [-122.4843, 37.8909], [-122.48654, 37.88697]]]]} | Restricted Access 2 | 44955 | Richardson Bay Audubon Center & Sanctuary | 24330 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 382.054 | Richardson Bay Audubon Ctr. & Sanctuary | 0 | None 1253 | ||
12385 | 12385 | 12384 | {"type": "Polygon", "coordinates": [[[-123.18991, 40.55307], [-123.18963, 40.55319], [-123.18939, 40.55326], [-123.18812, 40.55342], [-123.18776, 40.55156], [-123.18815, 40.55155], [-123.18812, 40.55113], [-123.18843, 40.55105], [-123.1891, 40.5508], [-123.18984, 40.55061], [-123.18985, 40.55094], [-123.18974, 40.55099], [-123.18968, 40.55105], [-123.18964, 40.55113], [-123.18963, 40.5512], [-123.18971, 40.55165], [-123.18987, 40.55166], [-123.18991, 40.55307]]]} | Open Access 1 | 26524 | Hayfork Park | 19757 | 349 | Trinity, County of 1022 | County 3 | County Agency 3 | http://www.trinitycounty.org/ | County 3 | 349 | Trinity, County of 984 | County 3 | County Agency 3 | Trinity 46 | 10.43 | Hayfork Park | 0 | Local Park 2 | 4 | |
13929 | 13929 | 13928 | {"type": "Polygon", "coordinates": [[[-123.04559, 40.72947], [-123.045, 40.72987], [-123.04219, 40.72785], [-123.04232, 40.72778], [-123.0429, 40.72771], [-123.04327, 40.72772], [-123.04361, 40.72778], [-123.04451, 40.7284], [-123.04485, 40.72886], [-123.04559, 40.72947]]]} | Open Access 1 | 36535 | Trinity holding 1 | 26540 | 349 | Trinity, County of 1022 | County 3 | County Agency 3 | http://www.trinitycounty.org/ | County 3 | 349 | Trinity, County of 984 | County 3 | County Agency 3 | Trinity 46 | 6.066 | Trinity holding 1 | 0 | Local Other or Unknown 14 | 4 | |
11735 | 11735 | 11734 | {"type": "Polygon", "coordinates": [[[-120.05325, 36.93233], [-120.05133, 36.93232], [-120.05132, 36.93211], [-120.05142, 36.9321], [-120.05141, 36.93204], [-120.05132, 36.93204], [-120.05131, 36.93136], [-120.05323, 36.93136], [-120.05325, 36.93233]]]} | Open Access 1 | 24541 | Parkwood Park | 23464 | 346 | Madera, County of 989 | County 3 | County Agency 3 | http://www.madera-county.com | County 3 | 346 | Madera, County of 953 | County 3 | County Agency 3 | Madera 48 | 4.523 | Parkwood Park | 0 | Local Park 2 | 4 | |
9975 | 9975 | 9974 | {"type": "Polygon", "coordinates": [[[-122.11034, 37.25814], [-122.1099, 37.25831], [-122.10963, 37.25848], [-122.10956, 37.25855], [-122.10952, 37.25863], [-122.10951, 37.25873], [-122.10953, 37.25882], [-122.10846, 37.25883], [-122.10844, 37.25755], [-122.11032, 37.25756], [-122.11034, 37.25814]]]} | No Public Access 3 | 47967 | Saratoga Gap Open Space Preserve | 31468 | 373 | Santa Clara, County of 941 | County 3 | County Agency 3 | http://www.sccgov.org/sites/scc/Pages/default.aspx | County 3 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 4.827 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
4385 | 4385 | 4384 | {"type": "Polygon", "coordinates": [[[-120.7612, 38.50487], [-120.76067, 38.50489], [-120.75991, 38.50481], [-120.75994, 38.50463], [-120.76073, 38.5047], [-120.76118, 38.50468], [-120.7612, 38.50487]]]} | Open Access 1 | 45570 | Fiddletown Park | 28396 | 372 | Amador, County of 755 | County 3 | County Agency 3 | http://www.co.amador.ca.us/ | County 3 | 372 | Amador, County of 741 | County 3 | County Agency 3 | http://www.touramador.com/parks | Amador 52 | 0.575 | Fiddletown Park | 0 | Local Park 2 | 4 |
14991 | 14991 | 14990 | {"type": "Polygon", "coordinates": [[[-120.74127, 38.54448], [-120.74125, 38.54475], [-120.74104, 38.54487], [-120.74089, 38.54509], [-120.74089, 38.54533], [-120.74091, 38.54553], [-120.74099, 38.54569], [-120.74082, 38.54569], [-120.74076, 38.54552], [-120.74073, 38.54533], [-120.74063, 38.5451], [-120.74034, 38.54496], [-120.74036, 38.54455], [-120.74062, 38.54449], [-120.74127, 38.54448]]]} | Open Access 1 | 45637 | River Pines Playground | 28454 | 372 | Amador, County of 755 | County 3 | County Agency 3 | http://www.co.amador.ca.us/ | County 3 | 372 | Amador, County of 741 | County 3 | County Agency 3 | http://www.touramador.com/parks | Amador 52 | 1.32 | River Pines Playground | 0 | Local Recreation Area 3 | 4 |
4342 | 4342 | 4341 | {"type": "Polygon", "coordinates": [[[-120.74524, 40.43205], [-120.7452, 40.43213], [-120.74515, 40.43217], [-120.74508, 40.43219], [-120.74501, 40.43218], [-120.74495, 40.43216], [-120.7449, 40.43211], [-120.74489, 40.43206], [-120.7449, 40.432], [-120.74494, 40.43195], [-120.745, 40.43192], [-120.74507, 40.43191], [-120.74514, 40.43193], [-120.7452, 40.43197], [-120.74524, 40.43205]]]} | Open Access 1 | 45592 | Lake Forest Park | 28418 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 0.17 | Lake Forest Park | 0 | Local Park 2 | 4 | |
12365 | 12365 | 12364 | {"type": "Polygon", "coordinates": [[[-121.13882, 41.1215], [-121.1388, 41.12256], [-121.13851, 41.12256], [-121.13851, 41.1227], [-121.13831, 41.1227], [-121.13798, 41.12334], [-121.13683, 41.12331], [-121.13678, 41.12411], [-121.13849, 41.12478], [-121.13372, 41.12466], [-121.13375, 41.12141], [-121.13483, 41.12142], [-121.1348, 41.12231], [-121.13481, 41.12232], [-121.13606, 41.12234], [-121.13611, 41.12143], [-121.13872, 41.12145], [-121.13882, 41.1215]]]} | Open Access 1 | 26506 | Clara Beiber Memorial Park | 17378 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 29.359 | Clara Beiber Memorial 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]);