Urgent News from FoxNewsNetwork

1. Urgent News from FoxNewsNetwork Contractors: Getting the Cleanest Geospatial Data Possible E.O. 12907, signed by President Bush on March 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….”

2. Contractors: Getting the Cleanest Geospatial 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

3. Summary Background Example The Issues The Solutions The Tools The Results

4. Background Project Example • No Involvement by Park with Contract • Multi-Year Project, Same Contractor • Many Field Data Collectors • Miscommunication of Requirements

5. Example Results: Too Many Shape Files with Attribute Errors Too Many Metadata Records by Contractor Approx. 2 weeks Park spent editing data

6. Summary Background Example The Issues The Solutions The Tools The Results

7. The Issues Different Data Dictionaries Inconsistent Field Values/Attributes Misspelled Attributes Unnecessary Data Multi-Year Project Problems

8. Issues: Common Results Leading Space(s) Capital “O” for Zero One too many digits in date field How was data created? Spelling Errors Missing Values

9. Summary Background Example The Issues The Solutions The Tools The Results

10. The Solution: Written Contract 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”

11. The Solution: Assistance Provide Supporting Park Data & Metadata to Contractor Set the Example Assist w/ GPS Data Dictionaries Provide Data Schema e.g., List of Required Fields

12. The Solution: Assistance Provide Example Deliverables Geodatabase, Metadata Record Review Data periodically before end of project (write into contract)

13. Solution: Preferred Data Format Define Your Preferred Data Format: File Geodatabase Personal Geodatabase Shape File Coverages Projection/Datum

14. Solution: Define Field Value Rules ALL CAPS/Initial Caps/Does It Matter?

15. Solution: Define Field Value Rules Ex: “Surveyor” Format:

16. Solution: Define Field Value Rules Ex: Date Format: YYYYMMDD Date or String or Numeric?

17. Solution: Define Field Value Rules Ex: Date in Metadata Date Format: YYYMMDD

18. Solution Did you know that “Process Step” is not an FGDC Requirement? Therefore, do you know how the data was created then?

19. The Solution: Process Step Require “Process Step” (Metadata) in the Contract: Data Quality Process Description/Software_Version/Date/Contact

20. Solution: Multi-YearProject • 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

21. Summary Background Example The Issues The Solutions The Tools The Results

22. Provide The Tools Review with Contractors: • Contract Standards • Define/Provide Data Dictionary • Data Schema: Values/Attributes Format Domains/Ranges

23. Provide The Tools Review with Contractors: • ArcToolBox Frequency Tool: unique ID spelling inconsistencies missing values leading spaces, etc. other ways? (Access, Excel, SQL, Oracle, scripts?)

24. Provide the Tools NPS Metadata Tools & Editor Provide Tools Link http://science.nature.nps.gov/nrdata/tools/index.cfm Review with Contractor: Spell Check Metadata Parse Meta Find and Replace, etc.

25. 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

26. End of Project • Have a Party! • Present to Park Management/ Employees • Thank them officially for a job well done

27. Summary Background Example The Issues The Solutions The Tools The Results

28. Contractors: Getting the Cleanest Geospatial 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

29. Discussion/Questions? Elena Robisch GIS Program Manager Zion National Park 435-772-0213 Aneth Wight GIS Specialist NCPN 435-719-2348