units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 8,056
- Recreation/Parks District 1,003
- State Agency 998
- County Agency 978
- Non Profit - Land Trust 509
- Federal Agency 419
- Open Space District 391
- County Agency - Parks 207
- Water District 207
- Home Owners Association 184
- Community Services District 176
- Non Profit - Conservation 133
- Flood District 96
- Non Profit - Other 41
- Irrigation District 38
- School District 35
- Cemetery District 33
- County Agency - Other 27
- Port/Harbor District 27
- Special District - Other 15
- Commercial 14
- Joint Powers Authority 7
- Sanitation District 6
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 414
- California Department of Fish and Wildlife 385
- Los Angeles, City of 379
- California Department of Parks and Recreation 332
- Mountains Recreation and Conservation Authority 319
- San Jose, City of 191
- Sacramento, City of 190
- San Francisco, City and County of 161
- East Bay Regional Park District 158
- Los Angeles, County of 138
- Ventura, City of 131
- Long Beach, City of 122
- Roseville, City of 120
- San Diego, County of 101
- Oakland, City of 96
- United States Bureau of Land Management 95
- Santa Barbara, County of 95
- Consumnes Community Services District 93
- United States Forest Service 88
- Napa, City of 80
- Orange, County of 77
- California State Lands Commission 76
- United States Fish and Wildlife Service 75
- United States National Park Service 72
- Irvine, City of 70
- Hayward Area Recreation and Park District 68
- Valley-Wide Recreation and Park District 64
- Tracy, City of 63
- Poway, City of 61
- Davis, City of 61
- …
DES_TP >30
- Local Park 6,976
- Local Recreation Area 1,708
- Local Other or Unknown 1,145
- Private Conservation 533
- Local Conservation Area 419
- State Conservation Area 341
- Private Recreation or Education 238
- State Park 182
- State Resource Management Area 135
- State Recreation Area 125
- National Forest 75
- Local Historic or Cultural Area 70
- National Wildlife Refuge 68
- State Other or Unknown 66
- State Historic or Cultural Area 58
- National Public Lands 53
- Recreation Management Area 51
- Private Other or Unknown 51
- National Monument or Landmark 36
- National Recreation Area 34
- National Park 22
- Local Resource Management Area 20
- Resource Management Area 19
- Federal Other or Unknown 18
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 11,372
- Restricted Access 1,058
- No Public Access 837
- Unknown Access 366
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3436 | 3436 | 3435 | {"type": "Polygon", "coordinates": [[[-121.076, 38.88682], [-121.07557, 38.88683], [-121.07504, 38.88688], [-121.07451, 38.88696], [-121.07409, 38.88705], [-121.07249, 38.88759], [-121.07175, 38.88795], [-121.07161, 38.8875], [-121.07166, 38.88748], [-121.07166, 38.88711], [-121.07176, 38.88677], [-121.07185, 38.88667], [-121.07219, 38.88647], [-121.07232, 38.88631], [-121.07265, 38.88601], [-121.07292, 38.88593], [-121.07309, 38.88592], [-121.07325, 38.88593], [-121.0738, 38.88606], [-121.07413, 38.8861], [-121.07443, 38.88607], [-121.07496, 38.88595], [-121.07513, 38.88597], [-121.07535, 38.88594], [-121.07538, 38.88637], [-121.07595, 38.88636], [-121.076, 38.88682]]]} | Open Access 1 | 48745 | Railhead Park | 33471 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_railhead.php | Placer 35 | 10.958 | Railhead Park | 0 | Local Park 2 | 4 |
3437 | 3437 | 3436 | {"type": "Polygon", "coordinates": [[[-122.4138, 38.46446], [-122.41344, 38.465], [-122.41272, 38.46514], [-122.41239, 38.46481], [-122.41285, 38.46468], [-122.41297, 38.46463], [-122.41332, 38.46455], [-122.41347, 38.4645], [-122.41361, 38.46442], [-122.41379, 38.46439], [-122.4138, 38.46446]]]} | Open Access 1 | 25245 | Rutherford Crossroad | 32278 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Napa 11 | 1.213 | Rutherford Crossroad | 0 | State Resource Management Area 55 | 3 | |
3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | 35476 | Yuba County Water Agency 3 | 27818 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.144 | Yuba County Water Agency 3 | 0 | Local Other or Unknown 14 | 4 | |
3439 | 3439 | 3438 | {"type": "Polygon", "coordinates": [[[-116.69795, 34.67637], [-116.68049, 34.67634], [-116.68049, 34.67369], [-116.69794, 34.67376], [-116.69795, 34.67637]]]} | No Public Access 3 | 25252 | Ord Rodman | 32252 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 115.534 | Ord Rodman | 0 | State Resource Management Area 55 | 3 | |
3440 | 3440 | 3439 | {"type": "Polygon", "coordinates": [[[-115.48246, 32.68055], [-115.48244, 32.68268], [-115.48183, 32.68268], [-115.4818, 32.68052], [-115.48243, 32.68051], [-115.48246, 32.68055]]]} | Open Access 1 | 48748 | Meadows Park | 33474 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 3.51 | Meadows Park | 0 | Local Park 2 | 4 | |
3441 | 3441 | 3440 | {"type": "Polygon", "coordinates": [[[-120.25813, 38.62982], [-120.25788, 38.63346], [-120.25343, 38.63333], [-120.25308, 38.63683], [-120.24397, 38.63654], [-120.2445, 38.63308], [-120.24896, 38.63318], [-120.2494, 38.62968], [-120.25813, 38.62982]]]} | No Public Access 3 | 25249 | Leek Springs Ecological Reserve | 32201 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | El Dorado 34 | 151.078 | Leek Springs ER | 0 | State Conservation Area 8 | 2 | |
3442 | 3442 | 3441 | {"type": "Polygon", "coordinates": [[[-123.96676, 41.87177], [-123.95707, 41.87178], [-123.95706, 41.86815], [-123.96193, 41.86808], [-123.96197, 41.86444], [-123.96673, 41.86439], [-123.96667, 41.86953], [-123.96676, 41.87177]]]} | No Public Access 3 | 25256 | Stoney Creek | 32321 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Del Norte 50 | 120.393 | Stoney Creek | 0 | State Resource Management Area 55 | 3 | |
3443 | 3443 | 3442 | {"type": "Polygon", "coordinates": [[[-122.27607, 38.12156], [-122.27576, 38.12178], [-122.2757, 38.12104], [-122.27592, 38.12097], [-122.27607, 38.12156]]]} | Open Access 1 | 25259 | Vallejo Fishing Pier | 32344 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Solano 26 | 0.461 | Vallejo Fishing Pier | 0 | State Recreation Area 39 | 4 | |
3444 | 3444 | 3443 | {"type": "Polygon", "coordinates": [[[-115.49283, 32.68887], [-115.49278, 32.68897], [-115.49196, 32.68892], [-115.49199, 32.68869], [-115.49221, 32.68849], [-115.49283, 32.68887]]]} | Open Access 1 | 48749 | Robert F. Kennedy Park | 33475 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 0.625 | Robert F. Kennedy Park | 0 | Local Park 2 | 4 | |
3445 | 3445 | 3444 | {"type": "Polygon", "coordinates": [[[-115.49103, 32.68828], [-115.49059, 32.68816], [-115.48997, 32.68793], [-115.48965, 32.68785], [-115.48947, 32.68784], [-115.48945, 32.68778], [-115.48946, 32.68677], [-115.49041, 32.68677], [-115.49042, 32.6874], [-115.49103, 32.6874], [-115.49103, 32.68828]]]} | Open Access 1 | 48750 | Kennedy Gardens Large | 33476 | 1451 | Calexico, City of 607 | City 2 | City Agency 2 | http://www.calexicorecreation.org/parks | City 2 | 1451 | Calexico, City of 596 | City 2 | City Agency 2 | Imperial 20 | 4.152 | Kennedy Gardens Large | None 281 | |||
3446 | 3446 | 3445 | {"type": "Polygon", "coordinates": [[[-117.11824, 32.76258], [-117.11824, 32.76322], [-117.11738, 32.76321], [-117.11734, 32.76285], [-117.11736, 32.76257], [-117.11824, 32.76258]]]} | Open Access 1 | 25268 | Adams Avenue Community Park | 30043 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.46 | Adams Avenue Community Park | 0 | Local Park 2 | 4 | |
3447 | 3447 | 3446 | {"type": "Polygon", "coordinates": [[[-117.93509, 33.80131], [-117.93497, 33.80155], [-117.93486, 33.80182], [-117.93485, 33.80146], [-117.93281, 33.80149], [-117.93277, 33.79962], [-117.9344, 33.7996], [-117.93441, 33.79927], [-117.93463, 33.79924], [-117.93474, 33.79916], [-117.93476, 33.7992], [-117.93482, 33.79925], [-117.93494, 33.79927], [-117.93468, 33.79958], [-117.93481, 33.79959], [-117.93485, 33.80119], [-117.93509, 33.80131]]]} | Open Access 1 | 25269 | Stoddard Park | 25863 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 10.242 | Stoddard Park | 0 | Local Park 2 | 4 | |
3448 | 3448 | 3447 | {"type": "Polygon", "coordinates": [[[-122.37728, 37.8995], [-122.37687, 37.90346], [-122.35981, 37.90125], [-122.3598, 37.90126], [-122.35981, 37.9018], [-122.35775, 37.90181], [-122.35773, 37.90092], [-122.35788, 37.90109], [-122.35803, 37.90098], [-122.35781, 37.9007], [-122.3576, 37.90062], [-122.3574, 37.8997], [-122.3572, 37.89911], [-122.35737, 37.89887], [-122.35772, 37.89812], [-122.35749, 37.89767], [-122.35716, 37.89727], [-122.35737, 37.89693], [-122.35721, 37.89654], [-122.3575, 37.89591], [-122.35742, 37.89558], [-122.35717, 37.89509], [-122.35687, 37.8949], [-122.3566, 37.89494], [-122.3563, 37.89461], [-122.35471, 37.89435], [-122.35458, 37.89471], [-122.35306, 37.89475], [-122.35246, 37.8945], [-122.35191, 37.89435], [-122.3514, 37.89407], [-122.35136, 37.8937], [-122.35107, 37.89356], [-122.35082, 37.89383], [-122.35146, 37.89463], [-122.35148, 37.89464], [-122.35174, 37.89554], [-122.352, 37.89603], [-122.35227, 37.89631], [-122.35261, 37.89649], [-122.35277, 37.8969], [-122.35282, 37.89693], [-122.35286, 37.89882], [-122.34909, 37.89467], [-122.34902, 37.8918], [-122.35677, 37.89326], [-122.35962, 37.89378], [-122.35969, 37.89617], [-122.37728, 37.8995]]]} | Restricted Access 2 | 25298 | Brooks Island | 16426 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | Contra Costa 12 | 289.362 | Brooks Island | None 282 | |||
3449 | 3449 | 3448 | {"type": "Polygon", "coordinates": [[[-122.10288, 37.98676], [-122.10284, 37.98741], [-122.0973, 37.9875], [-122.09724, 37.98631], [-122.09749, 37.98606], [-122.09779, 37.98587], [-122.0981, 37.98575], [-122.09846, 37.98558], [-122.09872, 37.98543], [-122.09892, 37.98521], [-122.09945, 37.98532], [-122.10123, 37.98528], [-122.10169, 37.98536], [-122.10203, 37.98589], [-122.10241, 37.98638], [-122.1027, 37.98663], [-122.10288, 37.98676]]]} | Restricted Access 2 | 25304 | Martinez | 21925 | 1198 | Martinez, City of 355 | City 2 | City Agency 2 | http://www.cityofmartinez.org/depts/recreation/parks/default.asp | City 2 | 1198 | Martinez, City of 352 | City 2 | City Agency 2 | Contra Costa 12 | 24.888 | Martinez | None 283 | |||
3450 | 3450 | 3449 | {"type": "Polygon", "coordinates": [[[-122.19466, 37.15793], [-122.19268, 37.15833], [-122.19133, 37.15817], [-122.1914, 37.15754], [-122.19169, 37.15748], [-122.19213, 37.15729], [-122.19248, 37.15727], [-122.19291, 37.15713], [-122.19325, 37.15713], [-122.19388, 37.15727], [-122.19424, 37.15748], [-122.19448, 37.15752], [-122.19466, 37.15793]]]} | Restricted Access 2 | 25308 | Griffith | 19515 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 6.861 | Griffith | 0 | Private Conservation 16 | 2 | |
3451 | 3451 | 3450 | {"type": "Polygon", "coordinates": [[[-122.05152, 37.12104], [-122.0515, 37.1215], [-122.05057, 37.12154], [-122.05058, 37.1218], [-122.0491, 37.12186], [-122.04919, 37.12379], [-122.04898, 37.12381], [-122.04901, 37.1246], [-122.04883, 37.12461], [-122.04884, 37.12487], [-122.04845, 37.12489], [-122.04848, 37.12545], [-122.04984, 37.12541], [-122.04985, 37.12539], [-122.04982, 37.12537], [-122.05014, 37.12515], [-122.05031, 37.1248], [-122.05052, 37.12456], [-122.05067, 37.12436], [-122.05102, 37.12436], [-122.05097, 37.12503], [-122.0507, 37.12554], [-122.05058, 37.12595], [-122.05079, 37.12617], [-122.05061, 37.12666], [-122.05069, 37.12687], [-122.04892, 37.12795], [-122.04839, 37.12795], [-122.04716, 37.12854], [-122.0472, 37.13152], [-122.04443, 37.13154], [-122.04443, 37.13491], [-122.03037, 37.13484], [-122.03039, 37.12776], [-122.04031, 37.12786], [-122.04035, 37.12388], [-122.04487, 37.12392], [-122.04468, 37.11638], [-122.04681, 37.11647], [-122.0468, 37.11741], [-122.04673, 37.12022], [-122.05113, 37.12033], [-122.05127, 37.12076], [-122.05152, 37.12098], [-122.05152, 37.12104]]]} | Restricted Access 2 | 25311 | Lompico | 21417 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 425.126 | Lompico | 0 | Private Conservation 16 | 2 | |
3452 | 3452 | 3451 | {"type": "MultiPolygon", "coordinates": [[[[-122.10049, 37.07295], [-122.09985, 37.0722], [-122.09934, 37.07207], [-122.09895, 37.07175], [-122.09865, 37.0716], [-122.09803, 37.07107], [-122.09755, 37.0709], [-122.09716, 37.07068], [-122.09696, 37.07041], [-122.09697, 37.07011], [-122.09653, 37.06891], [-122.10038, 37.06883], [-122.10049, 37.07295]]], [[[-122.10529, 37.0809], [-122.10419, 37.08125], [-122.10419, 37.07993], [-122.10379, 37.07917], [-122.1036, 37.07849], [-122.1032, 37.0781], [-122.10321, 37.07642], [-122.10523, 37.07636], [-122.10529, 37.0809]]]]} | Restricted Access 2 | 25312 | Fall Creek | 18831 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 42.071 | Fall Creek | 0 | Private Conservation 16 | 2 | |
3453 | 3453 | 3452 | {"type": "Polygon", "coordinates": [[[-118.3784, 33.80865], [-118.37822, 33.80858], [-118.3782, 33.80855], [-118.37821, 33.80851], [-118.37825, 33.80849], [-118.37843, 33.80846], [-118.37849, 33.80847], [-118.37851, 33.80851], [-118.37849, 33.80863], [-118.37845, 33.80865], [-118.3784, 33.80865]]]} | Open Access 1 | 35560 | Grass Median Calle Miramar and Calle Aragon | 29164 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.108 | Grass Median Calle Miramar and Calle Aragon | None 284 | |||
3454 | 3454 | 3453 | {"type": "Polygon", "coordinates": [[[-118.63309, 34.12589], [-118.63308, 34.12624], [-118.63243, 34.12624], [-118.63244, 34.12598], [-118.63309, 34.12589]]]} | Open Access 1 | 35562 | Los Angeles holding 5 | 21492 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.502 | Los Angeles holding 5 | 0 | Local Other or Unknown 14 | 4 | |
3455 | 3455 | 3454 | {"type": "Polygon", "coordinates": [[[-118.37003, 33.80894], [-118.36954, 33.8099], [-118.36765, 33.8085], [-118.36743, 33.8087], [-118.36706, 33.80844], [-118.36605, 33.80806], [-118.36594, 33.808], [-118.36527, 33.8074], [-118.36503, 33.80742], [-118.36472, 33.80731], [-118.36486, 33.80704], [-118.36484, 33.80699], [-118.36492, 33.80694], [-118.36495, 33.80685], [-118.36494, 33.8068], [-118.36491, 33.80676], [-118.36471, 33.80663], [-118.36482, 33.80641], [-118.36514, 33.80657], [-118.36525, 33.80649], [-118.3653, 33.80593], [-118.36552, 33.8061], [-118.3655, 33.80627], [-118.36542, 33.80635], [-118.3654, 33.80639], [-118.3654, 33.80644], [-118.36542, 33.80648], [-118.36546, 33.80652], [-118.36553, 33.80654], [-118.3656, 33.80653], [-118.36565, 33.8065], [-118.36617, 33.8068], [-118.36613, 33.80682], [-118.36614, 33.80686], [-118.36596, 33.80689], [-118.36595, 33.8069], [-118.36646, 33.80748], [-118.3679, 33.80801], [-118.37003, 33.80894]]]} | No Public Access 3 | 35563 | Slope-Via Corona | 29195 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 11.822 | Slope-Via Corona | None 285 |
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]);