You Want to Edit My Data?

1. You Want to Edit My Data? HagTag Distributed Maintenance of E911 Address Data You Want to Edit My Data?

2. The Usual Suspects • Mike Cranfill (cranfillm@fishers.in.us) GIS Coordinator, Town of Fishers • Brooke Gajownik (bmg@co.hamilton.in.us) 911 Address Coordinator, Hamilton County Sheriff’s Office • Terry Krueskamp (tkrueskamp@carmel.in.gov) GIS Coordinator, City of Carmel • Brent Harding (bharding@carmel.in.gov) GIS Technician, City of Carmel • Larry Stout (lcs@co.hamilton.in.us) GIS Manager, Hamilton County You Want to Edit My Data?

3. Brief History of HagTag • Started as an occasional lunch • Formalized in 2004 • Includes: • Hamilton County • Carmel • Fishers • Noblesville • Westfield • Clay Township Regional Waste District You Want to Edit My Data?

4. Mission Statement HagTag is an informal group of GIS leaders from local government units in Hamilton County who strive to enhance the value of geographic information in Hamilton County by developing methods, procedures, and workflows to share, maintain, and use the geographic information in more efficient and mutually beneficial ways… You Want to Edit My Data?

5. HagTag Accomplishments • Pictometry implementation • Digital Submittal Standard • Cost sharing for 2005 ortho buy-up • Distributed maintenance of E-911 addresses • Outfall mapping standards • Cost sharing for the 2006 orthos • Mapping Parks & Trails You Want to Edit My Data?

6. Dreaming of Distributed Maintenance June 13, 2005 – HagTag Meeting • What if we could all edit the same dataset? • What if we had all the technology we needed? • What if there were no political or administrative constraints? You Want to Edit My Data?

7. Dreaming of Distributed Maintenance Potential Benefits: • More timely updates (plats) • More timely updates (road projects) • More accurate street names • Eliminate duplication • Triplication? • Quadruplication? • Quintuplication? You Want to Edit My Data?

8. Dreaming of Distributed Maintenance Technical Requirements • High speed wide area network (fiber) • Secure access to the Hamilton County GIS server running Oracle and ArcSDE • Oracle user accounts for designated employees in Carmel, Fishers, Noblesville, & Westfield • ArcEditor or ArcInfo software license for each editor You Want to Edit My Data?

9. Dreaming of Distributed Maintenance Administrative Requirements • Wide area network access for non Hamilton County employees • Database accounts on a Hamilton County server for non Hamilton County employees • Software clients purchased by cities & towns editing data on a Hamilton County server • Training You Want to Edit My Data?

10. Details of the Dream • One or more user accounts for each community (one per user) • Hamilton County GIS Manager will manage Oracle user accounts • E-911 Address Coordinator will accept or reject all edits, deletes, and inserts You Want to Edit My Data?

11. Workflow • Originator creates a new protected ArcSDE version in the geodatabase • Originator makes edits, deletes, inserts in new version of the geodatabase • Originator sends email to Coordinator with brief description of changes • Coordinator accepts (posts) or rejects changes and notifies Originator • Originator deletes or corrects ArcSDE version You Want to Edit My Data?

12. How the Dream Became Reality You Want to Edit My Data?

13. Key Dates • June 13, 2005 – HagTag Meeting • It was a cloudy day • I wore a light jacket • October 28, 2005 - IT Directors Meeting • June 6, 2006 – Connectivity to Fishers • July 21, 2006 – First test edit by Fishers • August 1 – First real edits by Carmel You Want to Edit My Data?

14. Speaking of Dates… You Want to Edit My Data?

15. Carmel Needs to Make an Edit You Want to Edit My Data?

16. Create a New Version You Want to Edit My Data?

17. Version Manager You Want to Edit My Data?

18. Change to New Version You Want to Edit My Data?

19. Start Editing You Want to Edit My Data?

20. Modify Geometry You Want to Edit My Data?

21. Modify Attribute Data You Want to Edit My Data?

22. Save Edits You Want to Edit My Data?

23. Stop Editing You Want to Edit My Data?

24. Send Brooke an Email You Want to Edit My Data?

25. Brooke Checks the Edits You Want to Edit My Data?

26. Version Report – Parent/Child You Want to Edit My Data?

27. Version Report - Differences You Want to Edit My Data?

28. Zoom to Change You Want to Edit My Data?

29. Here it is… You Want to Edit My Data?

30. Look at the Attributes You Want to Edit My Data?

31. Oops… You Want to Edit My Data?

32. Let’s Assume it Was Okay… You Want to Edit My Data?

33. Create a Reconcile Version You Want to Edit My Data?

34. Start Editing & Reconcile You Want to Edit My Data?

35. Reconcile to SHERIFF.QC & Post You Want to Edit My Data?

36. Change to SHERIFF.QC Version You Want to Edit My Data?

37. The Change has been Posted You Want to Edit My Data?

38. Delete Private Reconcile Version You Want to Edit My Data?

39. Email to Carmel You Want to Edit My Data?

40. QC Versions Posted to SDE.DEFAULT You Want to Edit My Data?

41. Conclusion • Technically, It Works • Really Fast • Very Few Problems • Politically, It Works • No Problems So Far • Other Kinds of Data • City & Town View Access to Other Data You Want to Edit My Data?

42. How the Dream Became Reality • Vision • Plan • Sell • Implement • Cooperate • Negotiate • Mitigate You Want to Edit My Data?

43. What Would We Improve? • Surrogate Users (SHERIFF) • Who am I, Really? • Hung Connections • Broader Use You Want to Edit My Data?

44. You Want to Edit My Data?