zion: elena robisch @ nps.gov ncpn: aneth wight @nps.gov 20080401 contractors: getting the cleanest...
TRANSCRIPT
![Page 1: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/1.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Contractors: Getting the CleanestGeospatial Data Possible
Urgent News from FoxNewsNetwork
E.O. 12907, signed by President Bush onMarch 31, 2008, states:
“Beginning April 15, 2008, all federal geodatabases are required to have FGDC metadata for:
each feature class, each feature data set, and the geodatabase….”
![Page 2: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/2.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Contractors: Getting the CleanestGeospatial Data Possible
The Goal:
Deliverables that I don’t have to edit
That upload into Park’s Geospatial Library
That upload to NPS Data Store
![Page 3: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/3.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• Background Example
• The Issues
• The Solutions
• The Tools
• The Results
Summary
![Page 4: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/4.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• No Involvement by Park with Contract
• Multi-Year Project, Same Contractor
• Many Field Data Collectors
• Miscommunication of Requirements
Background Project Example
![Page 5: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/5.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Too Many Shape Files with Attribute Errors
Too Many Metadata Records by Contractor
Approx. 2 weeks Park spent editing data
Example Results:
![Page 6: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/6.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• Background Example
• The Issues
• The Solutions
• The Tools
• The Results
Summary
![Page 7: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/7.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Different Data Dictionaries
Inconsistent Field Values/Attributes
Misspelled Attributes
Unnecessary Data
Multi-Year Project Problems
The Issues
![Page 8: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/8.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Leading Space(s)
Capital “O” for Zero
One too many digits in date field
How was data created?
Spelling Errors
Missing Values
Issues: Common Results
![Page 9: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/9.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• Background Example
• The Issues
• The Solutions
• The Tools
• The Results
Summary
![Page 10: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/10.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
NPS National Standards &
Park-Specific Standards
Trimble Export Routine (if applicable)
Ask for Documentation of Protocols before contract signed
******************************************* “No Good Data, No Good Pay”
The Solution: Written Contract
![Page 11: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/11.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Provide Supporting Park Data & Metadata to Contractor
Set the Example
Assist w/ GPS Data Dictionaries
Provide Data Schemae.g., List of Required Fields
The Solution: Assistance
![Page 12: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/12.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Provide Example DeliverablesGeodatabase, Metadata Record
Review Data periodically before end of project (write into contract)
The Solution: Assistance
![Page 13: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/13.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Define Your Preferred Data Format:
File GeodatabasePersonal Geodatabase
Shape FileCoverages
Projection/Datum
Solution: Preferred Data Format
![Page 14: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/14.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
ALL CAPS/Initial Caps/Does It Matter?
Solution: Define Field Value Rules
![Page 15: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/15.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Ex: “Surveyor” Format:
Solution: Define Field Value Rules
![Page 16: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/16.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Ex: Date Format: YYYYMMDD
Date or String or Numeric?
Solution: Define Field Value Rules
![Page 17: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/17.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Solution: Define Field Value Rules
Ex: Date in MetadataDate Format: YYYMMDD
![Page 18: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/18.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Did you know that “Process Step”
is not an FGDC Requirement?
Therefore, do you know how
the data was created then?
Solution
![Page 19: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/19.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
The Solution: Process Step
Require “Process Step” (Metadata) in the Contract:Data Quality Process Description/Software_Version/Date/Contact
![Page 20: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/20.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• Separate or Combined Data?Who will do that
• Same Data Dictionary? What IF it changes How will it append/merge
Contract needs written instructions addressing multi-year project
Solution: Multi-Year Project
![Page 21: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/21.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• Background Example
• The Issues
• The Solutions
• The Tools
• The Results
Summary
![Page 22: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/22.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Review with Contractors:
• Contract Standards
• Define/Provide Data Dictionary
• Data Schema:Values/Attributes Format
Domains/Ranges
Provide The Tools
![Page 23: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/23.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Review with Contractors:
• ArcToolBox Frequency Tool: unique ID spelling inconsistenciesmissing valuesleading spaces, etc. other ways?
(Access, Excel, SQL, Oracle, scripts?)
Provide The Tools
![Page 24: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/24.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
NPS Metadata Tools & Editor
Provide Tools Linkhttp://science.nature.nps.gov/nrdata/tools/index.cfm
Review with Contractor: Spell Check MetadataParse MetaFind and Replace, etc.
Provide the Tools
![Page 25: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/25.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Solution & Tools Summary
• Get it In the Contract
• Write the GPS Data Dictionary
• Define the Schema
• Provide the Tools
• Work w/ During Project
• Review the Data Before You Pay
![Page 26: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/26.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• Have a Party!
• Present to Park Management/Employees
• Thank them officially for a job well done
End of Project
![Page 27: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/27.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
• Background Example
• The Issues
• The Solutions
• The Tools
• The Results
Summary
![Page 28: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/28.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Contractors: Getting the CleanestGeospatial Data Possible
The Results:
Deliverables that I don’t have to edit
That upload into Park’s Geospatial Library
That upload to NPS Data Store
![Page 29: ZION: Elena Robisch @ nps.gov NCPN: Aneth Wight @nps.gov 20080401 Contractors: Getting the Cleanest Geospatial Data Possible Urgent News from FoxNewsNetwork](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f385503460f94c54a38/html5/thumbnails/29.jpg)
20080401 ZION: Elena Robisch @ nps.govNCPN: Aneth Wight @nps.gov
Discussion/Questions?
Elena RobischGIS Program ManagerZion National Park435-772-0213
Aneth WightGIS SpecialistNCPN435-719-2348