170 likes | 183 Views
Flexible Geodatabase Design Approaches. Joe Guzi GIS Programmer Stark County Auditor’s GIS Department. 2014 Ohio GIS Conference September 22 - 24, 2014 | Hyatt Regency Columbus| Columbus, Ohio. Geo Data Base. Engineer-- Roads. Auditor -- Parcels. Sanitary -- Sewer. Geo Data Base.
E N D
Flexible Geodatabase Design Approaches Joe Guzi GIS Programmer Stark County Auditor’s GIS Department 2014 Ohio GIS Conference September 22 - 24, 2014 | Hyatt Regency Columbus| Columbus, Ohio
Geo Data Base
Engineer-- Roads Auditor -- Parcels Sanitary -- Sewer Geo Data Base Addresses Zoning Crime Data
Geodatabase Design Auditor -- Parcels Engineer-- Roads Geodatabase Sanitary -- Sewer Addresses Crime Data Zoning
Embracing ArcGIS for Local Government Rob Parsons, Matt Bryant, and Anna Sokol Tuesday September 23rd 4:20 – 4:50 Franklin Room 3 2014 Ohio GIS Conference September 22 - 24, 2014 | Hyatt Regency Columbus| Columbus, Ohio
Editing Privileges Planning Dept. Auditor’s Dept. PublicSafety Dept. Auditor’s Dept. Auditor’s Dept. Sanitary Engineer’s Dept. Planning Dept. Engineer’s Dept. Planning Dept. Sanitary Engineer’s Dept. Engineer’s Dept. PublicSafety Dept. PublicSafety Dept. Engineer’s Dept. Engineer’s Dept. PublicSafety Dept. PublicSafety Dept. Planning Dept. Planning Dept. PublicSafety Dept. Auditor’s Dept. Auditor’s Dept.
1 Geodatabase ApproachPros and Cons Kirks Kahns Kirks Kahns Pros: • 1 centralized GDB • Maintenance • Recommended by most GIS Publications Cons: • Updating • Schema Locks • If FDS/FCS has same you must rename • Difficult when multiple departments are separated geographically
Flexible Design • See Prezi
Flexible Geodatabase Design ApproachKirks and Kahns Kirks: • Departments are not really affecting other departments • 1 Centralized data store with the flexibility of many geodatabases. • Scalable Kahns: • Complicated • If FDS/FCS has same you must rename
Final Thoughts • This approach has opened the doors to collaboration for different GIS departments within the county.