![Page 1: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/1.jpg)
1
GEOG 475/575: Digital GEOG 475/575: Digital Compilation and Database Compilation and Database
DesignDesign
Geodatabase for Pacific North West National Geodatabase for Pacific North West National Fire Plan WildlandFire Plan Wildland--Urban Interface Urban Interface Community Assistance ProgramCommunity Assistance Program
Todd GilmoreTodd GilmoreKurt HellmanKurt Hellman
Erick StemmermanErick Stemmerman
Outline
• Introduction & Background• Design Objectives• Data Layer Specifications and Geographic
Extents• Methods and Techniques• Intended Application & Demonstration
Application• Limitations and Quality Statements• References
![Page 2: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/2.jpg)
2
The Wildland-Urban Interface
![Page 3: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/3.jpg)
3
The Raw Data
![Page 4: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/4.jpg)
4
![Page 5: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/5.jpg)
5
Data Layer Specifications and Geographic Extents
• Region 6 for the U.S. Forest Service and the Bureau of Land Management
• Washington and Oregon.
![Page 6: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/6.jpg)
6
Spatial Data
Source Original Data Layer Method Used To Extract
Selected Data Layers Selected Data Layer(s)
ESRI U.S. States Select by attributes WA State; OR State
ESRI U.S. Zip Codes Select by attributes WA Zip Codes; OR Zip Codes
ESRI U.S. Counties Select by attributes WA State Counties; OR State Counties
ESRI U.S. Federal Lands Select by attributes WA State Federal Lands; OR State Federal Lands
ESRI U.S. Congressional Districts Select by attributes
WA State Congressional Districts; OR State Congressional Districts
ESRI U.S. Hydro Select by attributes WA State Hydro; OR State Hydro
WA State Data ExtractionWA State Data Extraction
Select by Attributes
U.S.States
U.S. FederalLands
U.S. Congressional
Districts
U.S. Counties
U.S. ZIP Codes
U.S. Hydro
WA State
WA FederalLands
WACongressional
Districts
WA Counties
WA ZIP Codes
WA Hydro
![Page 7: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/7.jpg)
7
OR State Data Extraction
Select by Attributes
U.S. States
U.S. FederalLands
U.S. Congressional
Districts
U.S. Counties
U.S. ZIP Codes
U.S. Hydro
OR State
OR FederalLands
ORCongressional
Districts
ORCounties
OR ZIP Codes
ORHydro
Data Reprojection
![Page 8: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/8.jpg)
8
Geodatabase Spatial Reference
Design Objectives
• Transfer the information currently in the Access database into a geodatabase.
• Combine this with associated land cover and jurisdictional map features.
• Finally display attribute and spatial data
![Page 9: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/9.jpg)
9
Feature Class Templates
WUI CAP GEODATABASE
Raster Datasets
Feature Datasets
Tables Grant Proposals
Land Cover OR and WA
OR_WA Data
Query Outputs
GEODATA BASE STRUCTURE 2 raster
Layers
Many GIS layers
Feature Classes Created By Quires
2001-2006 Grant Proposals
Empty Tables To Append into
Feature Datasets and Attributes
![Page 10: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/10.jpg)
10
Feature Datasets and Attributes
Raster Datasets
![Page 11: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/11.jpg)
11
Raster Datasets
Tabular Data
![Page 12: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/12.jpg)
12
Metadata
Methods and Techniques
• ArcCatalog• Microsoft Access• Lots of Coffee
![Page 13: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/13.jpg)
13
Normalization/Standardization
DATA BASE E-R CONNECTIONSApplicants
State, County, Zip, Congressional District
Grant Projects
ID Number
![Page 14: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/14.jpg)
14
Access view of Tables
Queries in Access
![Page 15: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/15.jpg)
15
PROSCESS
Grant Proposals Tables
Output of Query
New Feature Class
Query in Access
Append Query Into Blank Table
Query for State and Funded
![Page 16: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/16.jpg)
16
SQL for State and Funded • SELECT tbl2003GrantProposals.GrantID,
tbl2003GrantProposals.Application_Type, tbl2003GrantProposals.TotalProjCost, tbl2003GrantProposals.AmtRequested, tbl2003GrantProposals.TotalFunded, tbl2003GrantProposals.State, tbl2003GrantProposals.AmtFundedFS, tbl2003GrantProposals.AmtFundedBLM, tbl2003GrantProposals.AmtFundedFWS, tbl2003GrantProposals.AmtFundedBIA, tbl2003GrantProposals.AmtFundedFSWUI, tbl2003GrantProposals.CongressionalID, tbl2003GrantProposals.County, tbl2003GrantProposals.City, tbl2003GrantProposals.ZipCode, tbl2003GrantProposals.Lat, tbl2003GrantProposals.Long
• FROM tbl2003GrantProposals• WHERE (((tbl2003GrantProposals.TotalFunded)>0) AND
((tbl2003GrantProposals.State)="or"));
Query for Counties
![Page 17: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/17.jpg)
17
SQL for Counties• SELECT OR_CNTY.Shape, qry2003_OR_Fund.GrantID,
qry2003_OR_Fund.Application_Type, qry2003_OR_Fund.TotalProjCost,qry2003_OR_Fund.AmtRequested, qry2003_OR_Fund.TotalFunded, qry2003_OR_Fund.AmtFundedFSWUI, qry2003_OR_Fund.AmtFundedFWS, qry2003_OR_Fund.AmtFundedBIA, qry2003_OR_Fund.AmtFundedBLM, qry2003_OR_Fund.AmtFundedFS, OR_CNTY.NAME, OR_CNTY.STATE_NAME, OR_CNTY.STATE_FIPS, OR_CNTY.CNTY_FIPS, OR_CNTY.FIPS, OR_CNTY.SQMI, OR_CNTY.Shape_Length, OR_CNTY.Shape_Area
• FROM (OR_CNTY INNER JOIN OR_CNTY_Shape_Index ON OR_CNTY.OBJECTID_1 = OR_CNTY_Shape_Index.IndexedObjectId) INNER JOIN qry2003_OR_Fund ON OR_CNTY.NAME = qry2003_OR_Fund.County;
Query Output
![Page 18: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/18.jpg)
18
Append Query
SQL• INSERT INTO orcnty03 ( FIELD NAME, )
Append Query
![Page 19: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/19.jpg)
19
Append Query
Query Append Output
![Page 20: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/20.jpg)
20
PROSCESS
Grant Proposals Tables
Output of Query
New Feature Class
Query in Access
Append Query Into Blank Table
Feature Class from Append
![Page 21: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/21.jpg)
21
Intended Application & Demonstration Application
• To assist federal and state land mangers in making decisions for the allocation of grant funds in support of the National Fire Plan
Demonstration Application ProcessGrant
Proposals Tables
Output of
Query
New Feature Dataset
Query in Access
Append Query Into Blank Table
A Useful Map
Display and Classify in ArcMap
![Page 22: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/22.jpg)
22
Demonstration of the utility of the Database
A few hypothetical questions and answers
• What counties are did we award grants to in Oregon in 2003?
• In 2006 which Congressional Districts in both Oregon and Washington didn’t get awarded any grant money?
• Where did we award money in Washington in 2005 and 2006 and is it near federal lands and where fires have happened?
• Can we use grant point data for 2003 to show if awards were near fire disturbances?
Total amount of grant funding by county 2003
0 – 50,00050,001 – 100,000100,001 – 150,000150,001 – 200,000200,001 – 250,000Over 250,000
Total funding (in dollars)
![Page 23: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/23.jpg)
23
In 2006 which Congressional Districts in both Oregon and Washington didn’t get awarded any grant money?
Districts with no funding
Congressional Districts not funded in 2006
![Page 24: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/24.jpg)
24
Where did we award money in Washington in 2005 and 2006 and is it near Federal Lands
and where fires have happened?
0 – 15,000
15,001 – 50,000
50,001 – 100,000
100,001 – 200,000
Over 200,000
Total of Funded Grants (in dollars)
2005
![Page 25: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/25.jpg)
25
0 – 15,000
15,001 – 50,000
50,001 – 100,000
100,001 – 200,000
Over 200,000
Total of Funded Grants (in dollars)
2005 & 2006
0 – 15,000
15,001 – 50,000
50,001 – 100,000
100,001 – 200,000
Over 200,000
Total of Funded Grants (in dollars)
Federal Lands
![Page 26: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/26.jpg)
26
0 – 15,000
15,001 – 50,000
50,001 – 100,000
100,001 – 200,000
Over 200,000
Total of Funded Grants (in dollars)
Fire Locations
Can we use grant point data for 2003 to show if awards
were near fire disturbances?
![Page 27: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/27.jpg)
27
Grant Proposals 2003
Limitations and Quality Statements
• There are many limitations to the current Geodatabase
• New layers should be defined and added• Continue to improve past data accuracy
and future data capture from applicants• It is a vast improvement over previous
methods of display and analysis
![Page 28: Geog575 Final Presentation Gilmore-Hellman-Stemmermanweb.pdx.edu/~jduh/courses/Archive/geog475f05/... · Selected Data Layers Selected Data Layer(s) ESRI U.S. States Select by attributes](https://reader033.vdocuments.us/reader033/viewer/2022042314/5f02918a7e708231d404e972/html5/thumbnails/28.jpg)
28
References• BLM. (2005a). Community Assistance Grants Background
Information. Retrieved Oct. 22, 2005, from http://www.nwfireplan.gov/Documents/Background.pdf
• BLM. (2005b). National Fire Plan - Pacific Northwest - Interagency Grant Opportunities. Retrieved Oct. 22, 2005, from http://www.nwfireplan.gov/Documents/Grants%20Summary.pdf
• BLM. (2005c). Program Fact Sheet: National Fire Plan, Wildland-Urban Inerface Community Assistance Projects. Retrieved Oct. 22, 2005, from http://www.nwfireplan.gov/Documents/Program%20Fact%20Sheet.pdf
• ESRI Data• Wood, B. (2005). Pacific Northwest Wildfire Coordinating Group.
Retrieved Oct. 22, 2005, from http://www.nwfireplan.gov/Documents/PNWCG%20Call%20for%20Applications.pdf