automating arcsde geodatabase maintenance
Download
Skip this Video
Download Presentation
Automating ArcSDE Geodatabase Maintenance

Loading in 2 Seconds...

play fullscreen
1 / 31

Automating ArcSDE Geodatabase Maintenance - PowerPoint PPT Presentation


  • 99 Views
  • Uploaded on

Automating ArcSDE Geodatabase Maintenance. 2011 IGIC Conference Muncie, Indiana Presenter: Trent Pell, GISP. History. MCCOG is a Metropolitan Planning Organization(MPO) MCCOG provides GIS and Planning support to Madison County Approximately 130,000 in population

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Automating ArcSDE Geodatabase Maintenance' - sade-jordan


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
automating arcsde geodatabase maintenance

Automating ArcSDEGeodatabaseMaintenance

2011 IGIC Conference

Muncie, Indiana

Presenter: Trent Pell, GISP

history
History
  • MCCOG is a Metropolitan Planning Organization(MPO)
  • MCCOG provides GIS and Planning support to Madison County
  • Approximately 130,000 in population
  • Approximately 86,000 land parcels
  • Approximately 450 sqaure miles
  • County/Community in transition
  • Largest City: Anderson
gis overview
GIS Overview
  • Automation on a single SDE Geodatabase
  • Versioned w/global ID’s
  • Multiple Editors
  • RDMS is SQL Server 2008 R2 (processor license)
  • Windows 7 & Server 2008 R2 – 64 bit
  • ArcGIS Server 10sp1 Standard Enterprise Edition
why automate
Why Automate?
  • Performance
  • Streamlines process
  • After hours
  • Why not!
what should be automated
What Should be Automated?
  • Rebuild Database Statistics
  • Compress Database
  • Reconcile & Post database versions
  • Delete & Re-create Versions
  • Sync Database changes to Web Geodatabase
process
Process
  • Rebuild Statistics
  • Compress Database
  • Reconcile & Post versions to Default
  • Kill all connections to Database
  • Stop Web Services
  • Delete all versions
  • Compress Database
  • Rebuild Statistics
  • Re-create Versions
rebuild statistics
Rebuild Statistics
  • Analyze Tool
    • Updates database statistics of business tables, feature tables, and delta(adds & deletes) tables
  • Create model & export as python script
  • Run on client machine
compress database
Compress Database
  • SDE command line
    • Sdeversion –o compress –u sde –p password –i ServiceName -N
  • Batch file on server
compress database1
Compress Database

Uncompressed State Tree

Compressed State Tree

reconcile post versions to default
Reconcile & Post Versions to Default
  • Reconcile Tool
  • Create model & export as python script
  • Run on client machine
kill connections to database
Kill Connections to Database
  • SDE command line
    • sdemon -o kill -t all -p password -N -i Madison_Managed
    • Batch file on server
  • Stop WebServices accessing database
    • AGSSOM arcscript command
    • Batch file on server
    • cd C:\Users\tpell\Desktop\AGSSOMv10.0

AGSSOM.exe -x WebServiceName

delete versions
Delete Versions
  • SDE command line
    • Sdeversion –o delete –V VersionName –N –u VersionOwnerName –p VersionOwnerPassword –i ServiceName
  • Batch file on server
  • Delete your QA version LAST!
cleanup
Cleanup!
  • Compress database again
  • Re-run Analyze/Re-build Statistics
  • Re-Create Versions
    • SDE command line
    • Batch file on server
automation
Automation
  • Utilize Windows Task Scheduler on both client and server
  • Allow ample time for each task to complete
automation time line
Automation Time-Line
  • 1am - Rebuild Statistics
  • 1:30am - Compress Database
  • 1:45am - Reconcile & Post versions to Default
  • 2am - Kill all connections to Database
  • 2:15am - Stop Webservices
  • 2:30am - Delete all versions
  • 2:45am - Compress Database
  • 3am - Rebuild Statistics
  • 3:30am - Re-create Versions
automation actions
Automation – Actions
  • Browse to necessary program or file
  • For python scripts browse to the python.exe
  • Python scripts require arguments
  • Argument is just the

python file

  • For batch files just browse

to the .bat file

one step further
One Step Further
  • Automate changes to Web based applications
getting changes to the web
Getting changes to the Web
  • Each dataset needs to be versioned with Global IDs
  • One way synchronization between internal Geodatabase and ‘Web’ Geodatabase
to the web
To the Web!
  • Stop all web services – AGSSOM batch file on server
  • Export, Compare & Import Schema Changes between Managed & Web Geodatabase – python script
  • Sync changes between Geodatabases – python script
  • Start Webservices – AGSSOM batch file on server
automation time line1
Automation Time-Line
  • 1am - Rebuild Statistics
  • 1:30am - Compress Database
  • 1:45am - Reconcile & Post versions to Default
  • 2am - Kill all connections to Database
  • 2:15am - Stop Webservices
  • 2:30am - Delete all versions
  • 2:45am - Compress Database
  • 3am - Rebuild Statistics
  • 3:30am - Re-create Versions
  • 3:45am - Export Replica Schema
  • 4:15am - Compare & Import Replica Schema
  • 4:45am - Sync Managed & Web Geodatabases
  • 5:15am – Start Webservices
useful tools
Useful Tools
  • PythonWin
  • ArcScript AGSSOM tool
  • Geodatabase Toolset or GDBT
  • SDE command line is your friend
lessons learned
Lessons Learned
  • Communicate
  • TEST!
  • Make Backups
  • Local security settings
    • Ensure user on server has Log as a Batch Job privleges under Local Security Policy>User Rights Assignment
  • Be flexible with your time-line and implementation
thank you

Thank You!

Trent Pell, GISP

GIS Coordinator

Madison County Council of Governments

[email protected]

765-641-9695

ad