spatial database architecture: designing your spatial ... database architecture: designing your...
TRANSCRIPT
![Page 1: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/1.jpg)
Spatial Database Architecture: Designing your SpatialDatabase for Flexibility
Jerry Mohnhaupt GISP
ARCADIS
Boulder, CO
![Page 2: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/2.jpg)
Or The Eternal Battle:
Structure Stability versus
Change Management
![Page 3: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/3.jpg)
Geodatabase Structures
![Page 4: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/4.jpg)
SQL Server Structures
![Page 5: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/5.jpg)
Leverage Data Base Security
Manage in ArcCatalog
![Page 6: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/6.jpg)
Spatial Database:Publishing Environment
![Page 7: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/7.jpg)
Spatial Database:Publishing Environment
Thematic Users:ADDRESSING
CONTROLELEVATIN
HYDROGRAPHYLAND
PARKRECPLANNINGPOLITICAL
SEWERSTORM
TRANSPORTATIONUTILITIESWATER
![Page 8: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/8.jpg)
Spatial Database:Publishing Environment
Stabilize Data Structures
`
![Page 9: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/9.jpg)
Spatial Database:Editing Environments
Isolation vs. Integration
![Page 10: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/10.jpg)
Spatial Database:Editing Environments
Most Likely to Change Over Time
![Page 11: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/11.jpg)
Automation Environments
Providing the Flexibility
![Page 12: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/12.jpg)
Automation Environments:Simple Publish Model
![Page 13: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/13.jpg)
Automation Environments: Linear Referencing Publish Model
![Page 14: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/14.jpg)
Automation Environments:Server Side Automation
Geoprocessing Export to Scripts
![Page 15: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/15.jpg)
Automation Environments:Server Side Automation
Task Manager
![Page 16: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/16.jpg)
Automation Environments:Server Side Automation
Logs
![Page 17: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/17.jpg)
One Editing Environment Shared Across Organization
Spatial Database Management:Impacts of Enterprise Linear Referencing
![Page 18: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/18.jpg)
Complex publishing and
data integration
requirements
Impacts of Enterprise Linear Referencing
![Page 19: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/19.jpg)
Support legacy data structures
Impacts of Enterprise Linear Referencing
![Page 20: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/20.jpg)
Maintain Separation Between Linear Referencing Editing and Publishing/Analysis
Impacts of Enterprise Linear Referencing
![Page 21: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/21.jpg)
Plan on longer learning curves for staff
Impacts of Enterprise Linear Referencing
![Page 22: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/22.jpg)
Multiple Departments/Consultants Sharing One Editing Environment?
Impacts of Enterprise Linear Referencing
![Page 23: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/23.jpg)
•All third party applications able to create and maintain related events from their platforms
•Support workflows inside and between departments
•Seamless field data collection integration
•Automated maintenance of Legacy Data Structures
•All from one shared editing environment
Planning For
![Page 24: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/24.jpg)
Are you prepared to put all your eggs in one basket?
Impacts of Enterprise Linear Referencing
![Page 25: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/25.jpg)
Integrate event editing workflows in phases
Impacts of Enterprise Linear Referencing
![Page 26: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/26.jpg)
Planning for the spatial database management requirements will help you sleep at night
Impacts of Enterprise Linear Referencing
![Page 28: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/28.jpg)
![Page 29: Spatial Database Architecture: Designing your Spatial ... Database Architecture: Designing your Spatial Database for Flexibility Jerry Mohnhaupt GISP ARCADIS Boulder, CO](https://reader034.vdocuments.us/reader034/viewer/2022051602/5ae86f217f8b9ae157907bb2/html5/thumbnails/29.jpg)