1 / 15

All in a day’s work on the Arapaho Roosevelt National Forest…

All in a day’s work on the Arapaho Roosevelt National Forest…. Background. The Arapaho-Roosevelt National Forest were using a geospatial photo archive (gpa) tool, developed onsite Database was Microsoft Access, viewable in ArcMap with a point layer shapefile for photo GPS locations

Mercy
Download Presentation

All in a day’s work on the Arapaho Roosevelt National Forest…

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. All in a day’s work on the Arapaho Roosevelt National Forest…

  2. Background • The Arapaho-Roosevelt National Forest were using a geospatial photo archive (gpa) tool, developed onsite • Database was Microsoft Access, viewable in ArcMap with a point layer shapefile for photo GPS locations • This tool had some inherent instabilities and limitations

  3. Background, continued Initial tool characteristics requested: - Easy to use (for seasonal & temporary employees) - Database link in ArcMap - Ability to track photos in one location with multiple dates - Multiple users at same time - Stable platform

  4. New Application • Interface developed using Visual Basic • Photos stored at forest • Point data stored in SDE • Meets all requirements • Can be easily enhanced • Currently deployed on individual desktops • Will deploy with Citrix through Data Center • Two options for users – viewing or editing • A few extras added for enhanced functionality • User instructions and developer notes are available

  5. New Application, continued

  6. What is Versioning? • Allows Multiple Editors on same dataset at the same time. • Does not maintain multiple copies of the database. • Changes are tracked in Delta Tables (Adds Table and Deletes Table).

  7. What is Versioning? • Every time you add a feature to the database, a record gets added to the “Adds Table”. • Every time you delete a feature, a record gets added to the “Deletes Table”.

  8. State ID • The State ID is a snapshot of the database at any one time. • The State ID starts at State ID “0”, and increases by 1 with each change to the database.

  9. Compress • Helps maintain database performance by removing unused data. • Reduces amount of data the database searches through when executing queries. • Compress often!!

  10. Statistics • Optimizes query performance. • Should be run before and after compress.

  11. Default Version • Default is the most current and up to date version, and usually the one the end user sees. • Each editor will reconcile and post their changes. • The reconcile process will detect conflicts between versions.

  12. Default Version • If two editors have edited the same feature, you will be given the choice of which is more accurate to keep. • The Post process will save edits to the parent version. • SDE user is only one who can post to Default.

  13. Best Practices • Reconcile versions to the SDE.DEFAULT version as soon as you can. • Delete versions when they are no longer needed. • Avoid creating versions that will never be reconciled with SDE.DEFAULT.

  14. Current Status • Tool is being used at the field location with positive results! • This project was completed on time and is being closed out (great job, Paul!) • Next steps include initiating a new project activity to convert code to DLL and deploy at Data Center with Citrix

  15. Demo

More Related