1 / 40

Using Geodatabase Replication To Manage Distributed Data

Redwood National Park Pacific West Region. National Park Service U.S. Department of the Interior. Using Geodatabase Replication To Manage Distributed Data. David Best Redwood National Park Craig Dalby Pacific West Regional Office. 2008 GIS & Data Management Conference.

lottie
Télécharger la présentation

Using Geodatabase Replication To Manage Distributed Data

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. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Using Geodatabase Replication To Manage Distributed Data David BestRedwood National Park Craig Dalby Pacific West Regional Office 2008 GIS & Data Management Conference

  2. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior The “Problem” • A great challenge is how parks will obtain and edit national GIS datasets. • Options include moving data (and applications) to national servers, or… • Keeping data local, and pushing changes to national datasets 2008 GIS & Data Management Conference

  3. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Centralized Data • Field (remote) users give up local applications and local data in favor of Remote Desktop/Citrix, or… • Repeatedly download and upload data between local servers and national servers Few organizations have the network bandwidth to accommodate local applications directly editing remote data 2008 GIS & Data Management Conference

  4. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Typical NPS Environment • For most parks there is a dramatic performance improvement when working with local data. • Local data makes it easier to customize user interfaces, more efficiently access other data stored on park servers, and integrate data of park-only interest. 2008 GIS & Data Management Conference

  5. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Geodatabase Replication • It is inconvenient to move data back and forth from the edit (local server) and integrated (national server) environments. • ArcGIS 9.2 introduced new technology for this problem: Distributed Geodatabase. • Allows versioned SDE geodatabases to be deployed at multiple locations. • Changes are synchronized with replica versions using either one-way or two-way replication. 2008 GIS & Data Management Conference

  6. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Benefits • A park can house and maintain data for a specific geographic area, gaining the performance of “local” data. • Seamlessly, these data contribute to national datasets. • Changes made at either the parent (EGIS) or park (child) can be replicated to the other. • This allows parks and programs to retain stewardship responsibilities, while ensuring an authoritative national versions are maintained. 2008 GIS & Data Management Conference

  7. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Need to Evaluate • Geodatabase Replication is new – want to test stability and reliability • NPS computing environment is diverse – want to test suitability in small parks with no IT support and large parks with dedicated GIS specialists and servers 2008 GIS & Data Management Conference

  8. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior PWRO Project Funds • Participating Parks: Redwood Lassen Volcanic Lava Beds Oregon Caves Sequoia-Kings Pacific West RO • Had to overcome reluctance. Difficult for a park to see benefit. • Common question: what am I going to have to do? 2008 GIS & Data Management Conference

  9. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Objectives Can an out-of-the box standardized ArcSDE deployment be seamlessly and consistently deployed to park offices? • Collect and enter building footprints • Develop methods and procedures to install and configure two-way replication • Implement two-way replication and train park staff • Evaluate performance and make recommendations for EGIS use. 2008 GIS & Data Management Conference

  10. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior General Steps • Install SQL Server • Install SDE • Perform SDE post-install • Configure using Access Database • Create Replica on child • Schedule Synchronization 2008 GIS & Data Management Conference

  11. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Configure Two-way Replication • MS Access database with embedded VB code is used to automate: • Record information about location, IP addresses, server name, database locations • Create new Active Directory groups for administration, editing, and viewing park-based EGIS data • Create folders/shares for administrative files • Create SDE connection files • Enable SQL backup • Implement SQL database roles and AD security 2008 GIS & Data Management Conference

  12. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 2008 GIS & Data Management Conference

  13. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 1 2008 GIS & Data Management Conference

  14. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 2 2008 GIS & Data Management Conference

  15. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Database Produces Consistent Share Name with AD Security OTHER PARKS Lassen Volcanic Redwood PWRO EGIS Lava Beds

  16. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 3

  17. Create database EGIS (SDE created by SDE install) • Create logins for • Administrators • Editors • Viewers

  18. Set permissions • for SDE and EGIS databases • Create Database Roles: • Editors • Viewers

  19. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 4 Connects to parks version on the EGIS database as the LABE SDE user on the EGIS server EGIS EGIS Database Park Version as park SDE use PARK EGIS Database Default Version as park SDE user Connects to EGIS database as the LABE SDE user on the park’s SDE server

  20. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior SDE Connection Files Can Be Read By ArcCatalog 2008 GIS & Data Management Conference

  21. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Right-click to view“ConnectionProperties”

  22. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Connection Properties

  23. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 5

  24. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 6

  25. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 7

  26. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Automated Backup of SQL Databases Are Consistent Lassen Volcanic Lava Beds PWRO OTHER PARKS

  27. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior 8

  28. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Python Script for Synchronization 2008 GIS & Data Management Conference

  29. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Create Replica on Child • In most cases an EGIS responsibility • Data is mainly “pulled” instead of “pushed”. • No need to disclose EGIS security to parks. • ArcMap provides spatial filter to limit replica to park’s geographic area (not available in ArcCatalog) • Filters are great way to eliminate versions and posting 2008 GIS & Data Management Conference

  30. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Activate Distributed Geodatabase Toolbar

  31. Load data that will participate in replica into map

  32. Specify Type of Replica

  33. Specify Connection and Replica Name REPLICA OWNER PARENT CHILD

  34. Specify Spatial Extent Use to limit geographic area where synchronization occurs. Useful for avoiding SDE versions Use for trusted editors and offices with oversight responsibility

  35. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Managing Replication • Synchronization can be manual or automated. • Synchronization begins for each park as a separate task within “Schedule Tasks.” • Thetask is a batch (.bat) file that calls the python script created earlier. FROM “EGIS” TO: 2008 GIS & Data Management Conference

  36. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Monitoring Replication Right click SDE database  Distributed Geodatabase Manage Replicas 2008 GIS & Data Management Conference

  37. Replication Manager Replication Log Viewing the Replication Log

  38. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Results and Recommendations • Complete install about 3 hrs/server • Get Administrator access • Other Flavors of SQL/SDE probably not worth coast savings • SQL backup very easy and reliable • SDE Service needs monitoring • Two-way replication avoids permission management with versions • Replica design should be updatable • Infrastructure mostly adequate 2008 GIS & Data Management Conference

  39. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Results and Recommendations • Have not trained park users, but do not expect difficulties. • Unforeseen benefit may be rapid-deployment of region or network-based integrated datasets. • Datastore should consider one-way “data subscription” service for national datasets not edited by parks. • Annotation is an easy and very useful national test dataset. 2008 GIS & Data Management Conference

  40. Redwood National ParkPacific West Region National Park ServiceU.S. Department of the Interior Next Steps • Complete Klamath Network Parks. • Encourage frequent park editing. • Review by EGIS Team. • Add new theme. • Move parent to RIMD. • Work on VPN solution. • ELA for SQL Server. • New participants? 2008 GIS & Data Management Conference

More Related