units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 48
- Butte, County of 45
- Orange, County of 37
- Lake, County of 33
- San Diego, County of 30
- El Dorado, County of 30
- Los Angeles - Department of Parks and Recreation, County of 21
- Santa Barbara, County of 19
- Monterey, County of 17
- Placer, County of 9
- Fresno, County of 7
- Kern, County of 7
- San Joaquin, County of 6
- Humboldt, County of 6
- Riverside, County of 5
- Sacramento, County of 5
- Lassen, County of 5
- San Luis Obispo, County of 4
- San Bernardino, County of 4
- Ventura, County of 3
- Stanislaus, County of 3
- Mendocino, County of 3
- Contra Costa, County of 3
- Santa Cruz, County of 2
- Mountains Recreation and Conservation Authority 2
- Tulare, County of 2
- Merced, County of 2
- Yolo, County of 2
- Tehama, County of 2
- Trinity, County of 2
- …
DES_TP 24
- Local Park 172
- Local Other or Unknown 124
- Local Recreation Area 57
- Local Conservation Area 18
- Local Historic or Cultural Area 1
- National Monument or Landmark 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
- None 1
MNG_AG_TYP 10
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12250 | 12250 | 12249 | {"type": "Polygon", "coordinates": [[[-123.98647, 40.49898], [-123.98241, 40.49898], [-123.97733, 40.49932], [-123.9773, 40.4995], [-123.97607, 40.49958], [-123.97481, 40.49962], [-123.97472, 40.49964], [-123.97325, 40.4994], [-123.97166, 40.49876], [-123.97059, 40.49784], [-123.97027, 40.49748], [-123.96992, 40.49649], [-123.96947, 40.49486], [-123.96915, 40.49332], [-123.96936, 40.49281], [-123.96941, 40.49162], [-123.96928, 40.4893], [-123.96926, 40.48925], [-123.96865, 40.48863], [-123.9678, 40.48729], [-123.96424, 40.48356], [-123.9651, 40.48276], [-123.96537, 40.48234], [-123.96645, 40.48135], [-123.96749, 40.48067], [-123.96847, 40.4811], [-123.96835, 40.48206], [-123.96841, 40.48325], [-123.96842, 40.48452], [-123.96814, 40.48581], [-123.9682, 40.48695], [-123.96854, 40.48777], [-123.96878, 40.48789], [-123.97058, 40.48784], [-123.9724, 40.48728], [-123.97416, 40.48663], [-123.97595, 40.48657], [-123.97741, 40.48698], [-123.97872, 40.48785], [-123.97866, 40.48895], [-123.9771, 40.48895], [-123.97454, 40.48917], [-123.9726, 40.49005], [-123.97195, 40.49104], [-123.97175, 40.49173], [-123.97174, 40.49269], [-123.97193, 40.49387], [-123.9721, 40.49487], [-123.97299, 40.49584], [-123.974, 40.49668], [-123.97488, 40.49747], [-123.97611, 40.49812], [-123.97683, 40.4987], [-123.97767, 40.49848], [-123.97942, 40.49699], [-123.98167, 40.49559], [-123.98244, 40.49577], [-123.98336, 40.49653], [-123.98467, 40.49758], [-123.98544, 40.49776], [-123.98593, 40.49717], [-123.98641, 40.49678], [-123.98651, 40.49858], [-123.98647, 40.49898]]]} | Open Access 1 | 25767 | Van Duzen Park | 4515 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://www.humboldtgov.org/1592/County-Parks-Facilities | Humboldt 45 | 212.133 | Van Duzen Park | 0 | Local Park 2 | 4 |
12296 | 12296 | 12295 | {"type": "Polygon", "coordinates": [[[-119.50625, 36.72095], [-119.50623, 36.7228], [-119.50624, 36.72462], [-119.50195, 36.72458], [-119.50192, 36.72283], [-119.50197, 36.72277], [-119.50198, 36.7227], [-119.50194, 36.72262], [-119.50188, 36.72258], [-119.5018, 36.72256], [-119.50169, 36.72257], [-119.50161, 36.72263], [-119.50158, 36.72271], [-119.5016, 36.72279], [-119.50166, 36.72285], [-119.5017, 36.72766], [-119.50164, 36.72783], [-119.50148, 36.72797], [-119.50134, 36.72816], [-119.49746, 36.72813], [-119.49741, 36.72098], [-119.50625, 36.72095]]]} | Open Access 1 | 25952 | China Creek Park | 17202 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 113.797 | China Creek Park | 0 | Local Park 2 | 4 | |
12297 | 12297 | 12296 | {"type": "Polygon", "coordinates": [[[-119.36499, 36.82156], [-119.36484, 36.82167], [-119.36465, 36.82269], [-119.3645, 36.82277], [-119.36352, 36.82264], [-119.36305, 36.8226], [-119.36273, 36.82261], [-119.36239, 36.82267], [-119.36177, 36.82273], [-119.36155, 36.82272], [-119.36075, 36.8225], [-119.36008, 36.82242], [-119.35953, 36.82239], [-119.35875, 36.82224], [-119.35845, 36.82216], [-119.35795, 36.82194], [-119.35762, 36.82183], [-119.35627, 36.82122], [-119.35558, 36.82116], [-119.35494, 36.82132], [-119.35425, 36.82166], [-119.3521, 36.82457], [-119.35158, 36.82517], [-119.3513, 36.82527], [-119.3507, 36.82524], [-119.35047, 36.82532], [-119.35029, 36.82541], [-119.34938, 36.82674], [-119.3481, 36.82793], [-119.34605, 36.82777], [-119.34969, 36.8246], [-119.35288, 36.82118], [-119.35294, 36.8202], [-119.354, 36.81915], [-119.35626, 36.81834], [-119.35729, 36.81815], [-119.35755, 36.81813], [-119.36022, 36.81832], [-119.36486, 36.81775], [-119.36499, 36.82156]]]} | Open Access 1 | 25953 | Choinumni Park | 17214 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 140.591 | Choinumni Park | 0 | Local Park 2 | 4 | |
12299 | 12299 | 12298 | {"type": "Polygon", "coordinates": [[[-119.44789, 36.74967], [-119.44787, 36.75316], [-119.44786, 36.75324], [-119.44785, 36.75402], [-119.44543, 36.75484], [-119.44438, 36.75684], [-119.44384, 36.75753], [-119.44321, 36.75812], [-119.4432, 36.75928], [-119.44317, 36.76005], [-119.44202, 36.76162], [-119.44126, 36.76044], [-119.43947, 36.76041], [-119.43884, 36.75948], [-119.43886, 36.75681], [-119.43707, 36.75679], [-119.43755, 36.7563], [-119.43776, 36.7561], [-119.43831, 36.75579], [-119.43972, 36.75506], [-119.4399, 36.75496], [-119.44006, 36.75484], [-119.44026, 36.75466], [-119.44042, 36.75443], [-119.44053, 36.75416], [-119.4406, 36.75388], [-119.44062, 36.75264], [-119.44234, 36.75208], [-119.44351, 36.75166], [-119.44407, 36.75142], [-119.44732, 36.74965], [-119.44789, 36.74967]]]} | Open Access 1 | 25954 | Kings River Green Belt Park | 20662 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 136.461 | Kings River Green Belt Park | 0 | Local Park 2 | 4 | |
12304 | 12304 | 12303 | {"type": "Polygon", "coordinates": [[[-119.85082, 37.44887], [-119.85015, 37.4499], [-119.84984, 37.44973], [-119.84923, 37.44961], [-119.84861, 37.44946], [-119.84756, 37.44967], [-119.84741, 37.44969], [-119.84747, 37.44898], [-119.84763, 37.44739], [-119.84952, 37.44862], [-119.85082, 37.44887]]]} | Open Access 1 | 25960 | Woodland Park | 27721 | 307 | Mariposa, County of 110 | County 3 | County Agency 3 | https://www.mariposacounty.org/index.aspx?NID=207 | County 3 | 307 | Mariposa, County of 107 | County 3 | County Agency 3 | Mariposa 31 | 10.398 | Woodland Park | 0 | Local Park 2 | 4 | |
12322 | 12322 | 12321 | {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.4716, 36.73202], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} | Open Access 1 | 25985 | Kings river Access Park | 20661 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 7.286 | Kings river Access Park | 0 | Local Recreation Area 3 | 4 | |
12332 | 12332 | 12331 | {"type": "Polygon", "coordinates": [[[-121.09587, 38.20221], [-121.09573, 38.20244], [-121.09539, 38.20279], [-121.09495, 38.2033], [-121.09441, 38.20379], [-121.09392, 38.20414], [-121.09368, 38.20446], [-121.09316, 38.20486], [-121.09294, 38.20498], [-121.09139, 38.2034], [-121.09121, 38.20317], [-121.09066, 38.20236], [-121.09587, 38.20221]]]} | Open Access 1 | 26005 | Stillman Magee Park | 25851 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 18.43 | Stillman Magee Park | 0 | Local Park 2 | 4 | |
12333 | 12333 | 12332 | {"type": "Polygon", "coordinates": [[[-121.27031, 37.97923], [-121.26981, 37.97935], [-121.26951, 37.97862], [-121.27001, 37.9785], [-121.27031, 37.97923]]]} | Open Access 1 | 26006 | West Jackson Park | 27364 | 322 | San Joaquin, County of 479 | County 3 | County Agency 3 | http://www.sjparks.com/ | County 3 | 322 | San Joaquin, County of 471 | County 3 | County Agency 3 | San Joaquin 39 | 0.966 | West Jackson Park | 0 | Local Park 2 | 4 | |
12345 | 12345 | 12344 | {"type": "MultiPolygon", "coordinates": [[[[-116.36349, 32.9753], [-116.36347, 32.97586], [-116.34903, 32.97614], [-116.34864, 32.97612], [-116.34825, 32.97607], [-116.34782, 32.976], [-116.34743, 32.97589], [-116.34678, 32.97561], [-116.34632, 32.97535], [-116.34609, 32.97521], [-116.34606, 32.97518], [-116.3474, 32.97517], [-116.35338, 32.97521], [-116.36349, 32.9753]]], [[[-116.36369, 32.97613], [-116.36368, 32.97685], [-116.3475, 32.97688], [-116.34745, 32.97619], [-116.34765, 32.97624], [-116.34809, 32.97633], [-116.34847, 32.97638], [-116.34903, 32.97642], [-116.34934, 32.97642], [-116.36369, 32.97613]]]]} | Open Access 1 | 26037 | Vallecito County Park | 29260 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Vallecito.html | San Diego 4 | 57.618 | Vallecito County 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 | |
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 | |
12416 | 12416 | 12415 | {"type": "Polygon", "coordinates": [[[-121.08267, 38.93257], [-121.08255, 38.93257], [-121.08236, 38.93233], [-121.08197, 38.93233], [-121.08209, 38.93168], [-121.08212, 38.93165], [-121.08218, 38.93163], [-121.08245, 38.93166], [-121.08266, 38.93166], [-121.08267, 38.93257]]]} | Open Access 1 | 27022 | Springs Meadow Park | 25749 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 1.137 | Springs Meadow Park | 0 | Local Park 2 | 4 | |
12418 | 12418 | 12417 | {"type": "Polygon", "coordinates": [[[-120.99014, 38.99939], [-120.99012, 39.00034], [-120.98886, 38.99995], [-120.98888, 38.99938], [-120.99014, 38.99939]]]} | Open Access 1 | 27024 | Applegate Park | 15541 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 2.294 | Applegate Park | 0 | Local Park 2 | 4 | |
12423 | 12423 | 12422 | {"type": "Polygon", "coordinates": [[[-120.64814, 36.96769], [-120.64814, 36.96965], [-120.64544, 36.96964], [-120.64543, 36.9691], [-120.64485, 36.96909], [-120.64485, 36.96767], [-120.64814, 36.96769]]]} | Open Access 1 | 27028 | South Dos Palos Park | 25648 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 15.022 | South Dos Palos Park | 0 | Local Park 2 | 4 | |
12434 | 12434 | 12433 | {"type": "Polygon", "coordinates": [[[-119.70244, 36.73399], [-119.70282, 36.73399], [-119.70289, 36.73401], [-119.70294, 36.73405], [-119.7034, 36.73496], [-119.7034, 36.73503], [-119.70336, 36.73509], [-119.70325, 36.73514], [-119.70255, 36.73514], [-119.70247, 36.73512], [-119.70241, 36.73508], [-119.70238, 36.735], [-119.70237, 36.73404], [-119.70239, 36.734], [-119.70244, 36.73399]]]} | Open Access 1 | 48757 | Montecito | 33484 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 2.258 | Montecito | None 1079 | |||
12435 | 12435 | 12434 | {"type": "Polygon", "coordinates": [[[-121.86522, 39.77272], [-121.86522, 39.77272], [-121.86339, 39.77381], [-121.86334, 39.77367], [-121.86511, 39.77261], [-121.86522, 39.77272]]]} | Open Access 1 | 36273 | Butte holding 3 | 16574 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.736 | Butte holding 3 | 0 | Local Other or Unknown 14 | 4 | |
12496 | 12496 | 12495 | {"type": "Polygon", "coordinates": [[[-117.77687, 33.7649], [-117.77713, 33.76457], [-117.77646, 33.76411], [-117.77593, 33.76388], [-117.77537, 33.76368], [-117.77447, 33.76339], [-117.77528, 33.76258], [-117.77535, 33.76253], [-117.77543, 33.76254], [-117.77665, 33.76339], [-117.77667, 33.76338], [-117.77774, 33.76413], [-117.77775, 33.76416], [-117.77773, 33.7642], [-117.7774, 33.76452], [-117.77704, 33.76493], [-117.77697, 33.76495], [-117.77687, 33.7649]]]} | Open Access 1 | 36503 | Orange holding 19 | 23166 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 6.636 | Orange holding 19 | 0 | Local Other or Unknown 14 | 4 | |
12511 | 12511 | 12510 | {"type": "Polygon", "coordinates": [[[-122.88176, 39.1186], [-122.88175, 39.11912], [-122.87917, 39.11957], [-122.87867, 39.11973], [-122.87835, 39.11987], [-122.8781, 39.12], [-122.87511, 39.12088], [-122.87443, 39.11976], [-122.87471, 39.11976], [-122.87471, 39.11945], [-122.87507, 39.11939], [-122.87554, 39.11916], [-122.87568, 39.11893], [-122.87573, 39.11877], [-122.87571, 39.11844], [-122.87566, 39.11801], [-122.87569, 39.11746], [-122.87738, 39.11623], [-122.87753, 39.11618], [-122.87832, 39.11638], [-122.87874, 39.11687], [-122.87937, 39.11686], [-122.87941, 39.11692], [-122.87975, 39.1171], [-122.88022, 39.11721], [-122.88119, 39.1179], [-122.88155, 39.11829], [-122.88158, 39.11856], [-122.88166, 39.11861], [-122.88176, 39.1186]]]} | Open Access 1 | 28342 | Rodman Slough | 24551 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 43.698 | Rodman Slough | 0 | Local Conservation Area 4 | 2 | |
12519 | 12519 | 12518 | {"type": "Polygon", "coordinates": [[[-114.53743, 33.67682], [-114.53197, 33.67681], [-114.53248, 33.67467], [-114.53295, 33.67313], [-114.53327, 33.67189], [-114.53329, 33.67168], [-114.53329, 33.67139], [-114.53305, 33.66978], [-114.53407, 33.66976], [-114.53408, 33.66975], [-114.53406, 33.66967], [-114.5349, 33.66965], [-114.53487, 33.66951], [-114.53726, 33.66945], [-114.53743, 33.67682]]]} | Open Access 1 | 29002 | Mayflower Park | 21976 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 83.858 | Mayflower Park | 0 | Local Park 2 | 4 | |
12588 | 12588 | 12587 | {"type": "Polygon", "coordinates": [[[-123.99351, 40.88039], [-123.99291, 40.88117], [-123.99172, 40.88062], [-123.99228, 40.87997], [-123.99351, 40.88039]]]} | Open Access 1 | 29310 | Gymkhana Field | 19579 | 348 | Humboldt, County of 552 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | Humboldt 45 | 2.642 | Gymkhana Field | 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]);