*******************************************************************************

9/22/05

TASK: Create final overlay land use/cover/ownership

FINAL COVER: lc_esu_landuse

FINAL ITEM: FINAL_DES

BASE LAYERS:

Public Ownership

(from the state GIS service center)

USGS landcover

(base grid from: http://landcover.usgs.gov/prodescription.asp)

ZONING

(from the state GIS service center)

*****************************************************************************

NOTE: All coverages were first clipped to the Lower Columbia Recovery Domain area

OWNERSHIP: STEP 1 RECLASS

RECLASSED AS:

USFS 1

BLM 2

Other Federal 3

State 4

Private 5

Tribal 6

Other 7

OWN_CODE OWN_DES Dissolve to:

1 Bonneville Power Administration 3

2 Bureau of Indian Affairs 6

3 Bureau of Land Management 2

4 Bureau of Reclamation 3

5 Department of Defense 3

6 Federal Aviation Administration 3

7 Federal Energy Regulatory Commission 3

8 General Services Administration 3

9 Indian Allotment Fee 6

10 Indian Allotment Trust 6

11 Local Government 7

12 National Park Service 3

13 Oregon Department of Fish and Wildlife 4

14 Oregon Department of Forestry 4

15 Oregon Division of State Lands 4

16 Oregon Parks and Recreation Department 4

17 Private 5

18 State 4

19 Undetermined 7

20 United States Coast Guard 3

21 United States Corps of Engineers 3

22 United States Department of Agriculture(non usfs) 3

23 United States Fish and Wildlife Service 3

24 United States Forest Service 1

OWNERSHIP: STEP 2 RECLASS

CLASSED AS:

Federal 1

State 2

Private 3

Other 4

GEN_OWN_DES DISSOLVE

BLM 1

USFS 1

STATE 2

TRIBAL 4

OTHER FEDERAL 1

PRIVATE 3

OTHER 4

*****************************************************************************

*****************************************************************************

USGS Landcover

CLASSED AS:

ag 1

urban 2

forest 3

other 4

wetlands 5

mining 6

shrubland 7

Original USGS Class: DISSOLVE to:

water

11 open water 4

12 perennial ice/snow 4

developed

21 low intensity residential 2

22 high intensity residential 2

23 commercial/industrial/transportion 2

barren

31 bare rock/sand/clay 4

32 quarries/strip mines/gravel pits 6

33 transitional 3

forested upland

41 deciduous forest 3

42 evergreen forest 3

43 mixed forest 3

shrubland

51 shrubland 7

non-natural woody

61 orchards/vineyards/other 1

herbaceous upland

71 grasslands/herbaceous 1

herbaceous planted/cultivated

81 pasture/hay 1

82 row crops 1

83 small grains 1

84 fallow 1

85 urban/recreational grasses 2

wetlands

91 woody wetlands 5

92 emergent herbaceous wetlands 5

NOTE: The original USGS data was a 30m grid. The grid was converted to a polygon coverage and then reclassed (see above). *****************************************************************************

*****************************************************************************

Zoning

Classed as:

AG 1

URBAN 2

OTHER 3

LAND_USE Description DISSOLVE

Urban 2

Rural Industrial 2

Rural Commercial 2

Rural Residential 2

Rural Service Center 2

Public Facility 2

Non Resource 3

Mixed Ag and RR 1

Agriculture 1

Forestry 3

Natural Resource 3

Park and Recreation 3

Indian Reservation 3

Water 3

Coastal 3

******************************

STEP 1 ... Combine the data:

UNION the OWNERSHIP, ZONING, and USGS layers

ELIMINATE OWNER_CODE, ZONE_CODE, and USGS_CODE equal to zero, using the default settings

Create COMBO_CODE = OWNER_CODE * 100 + ZONE_CODE * 10 + USGS_CODE

STEP 2 ... Reclass the data:

COMBO_CODE OWNER_CODE ZONE_CODE USGS_CODE FINAL_DES

111 fed ag ag Agriculture

112 fed ag urban Agriculture

113 fed ag forest Agriculture

114 fed ag other Agriculture

115 fed ag wetlands Agriculture

116 fed ag quarries Agriculture

117 fed ag shrubland Agriculture

121 fed urb ag Urban

122 fed urb urban Urban

123 fed urb forest Urban

124 fed urb other Urban

125 fed urb wetlands Urban

127 fed urb shrublands Urban

131 fed other ag Agriculture

132 fed other urban Urban

133 fed other forest Federal Forest

134 fed other other Other

135 fed other wetlands Other

136 fed other quarries Other

137 fed other shrubland Federal Forest

211 state ag ag Agriculture

212 state ag urban Agriculture

213 state ag forest Agriculture

214 state ag other Agriculture

215 state ag wetlands Agriculture

217 state ag shrubland Agriculture

221 state urb ag Urban

222 state urb urban Urban

223 state urb forest Urban

224 state urb other Urban

225 state urb wetlands Urban

231 state other ag Agriculture

232 state other urban Urban

233 state other forest State Forest

234 state other other Other

235 state other wetlands Other

237 state other shrublands State Forest

311 private ag ag Agriculture

312 private ag urban Agriculture

313 private ag forest Agriculture

314 private ag other Agriculture

315 private ag wetlands Agriculture

316 private ag quarries Agriculture

317 private ag shrubland Agriculture

321 private urb ag Urban

322 private urb urban Urban

323 private urb forest Urban

324 private urb other Urban

325 private urb wetlands Urban

326 private urb quarries Urban

327 private urb shrubland Urban

331 private other ag Agriculture

332 private other urban Urban

333 private other forest Private Forest

334 private other other Other

335 private other wetlands Other

336 private other quarries Other

337 private other shrubland Private Forest

411 other ag ag Agriculture

412 other ag urban Agriculture

413 other ag forest Agriculture

414 other ag other Agriculture

421 other urb ag Urban

422 other urb urban Urban

423 other urb forest Urban

424 other urb other Urban

427 other urb shrubland Urban

431 other other ag Agriculture

432 other other urban Urban

433 other other forest Other

434 other other other Other

435 other other wetlands Other

437 other other shrubland Other

STEP 3... Final Dissolve

DISSOLVE based on FINAL_DES attribute

ELIMINATE polygons with area less than 10,000 sq feet (~900 sq meters) using default settings

*******************************************************************************