Loading in 2 Seconds...
Loading in 2 Seconds...
Add Spatial Data to Existing Business Data to Create a GIS System. Eric Abrams IT Division October 5 th 2006. Business Data. Business data is used to make day to day decisions Everyone has business data Excel File Access Database Oracle SQL Server Text File Paper Etc….
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.
Add Spatial Data to Existing Business Data to Create a GIS System Eric Abrams IT Division October 5th 2006
Business Data • Business data is used to make day to day decisions • Everyone has business data • Excel File • Access Database • Oracle • SQL Server • Text File • Paper • Etc…
Business Data • Where is you business data? • LAN Folder, Database • Is your business data maintained? • Regular update schedule • Data security • History • Can it be shared without duplication? • Example: Make a copy of an Excel file for someone to update then try to merge changes.
Business Data • Does you data have a spatial location • Address • Lat/Long • Reference Post • Literal Description • Boundary
Aviation • Need to locate Airports, Heliports and runways • Query aviation business data to display on map • Example: Show number of airports that have fuel XYZ over a certain capacity
Aviation • Existing Aviation Oracle database • Over 130 tables and views • Oracle Forms used to maintain business data • Web site constructed to display business data from Oracle ww.iawings.com • Use Google maps for aerial photography on web site
Aviation – Spatial Locations • Created a tables in existing database to store spatial locations • AIRPORTS_SO • RUNWAY_SO • HELIPORTS_SO • SDO_GEOMETRY field
Aviation - Issues • Office GIS knowledge • Keeping spatial data up to date
Five Year Program • Need to display planned projects and query business data to display on a map • Create maps quickly for commission meetings • On Demand requests from legislators • Maps easier to understand that tabular data
Five Year Program • Phase I – Add spatial data to existing business data • Business data resided in IDMS • Created Oracle database to store snap shot from IDMS • Created spatial tables to store geometry • Program Management digitize projects, time consuming to keep business data and spatial data synchronized.
Five Year Program • Phase II – Use LRS to create project locations • Take Route, begin milepost, end mile post and transform locations into geometries using LRS • Projects follow LRS line work • No need to maintain project geometries, they are derived from LRS
Five Year Program - Issues • Conversion process from Mainframe to Oracle • Notification of route issues
Geographical Information Management System (GIMS) • GIMS database contains all road centerlines, structures and rails crossing locations and associated business data • Transportation Data had the need to update road centerlines via GeoMedia. • GeoMedia access to GIMS data came through MGE files generated each evening.
Geographical Information Management System (GIMS) • GIMS had a spatial component UOR locations maintained from MicroStation Interface • Business Data maintained through MicroStation interface and Oracle Forms
Geographical Information Management System (GIMS) • Created a routine to transform UORs to SDO_GEOMETRY • Created database triggers to keep UORs and SDO_GEOMETRY synchronized • Added 3 spatial tables • ROAD_SO • RR_XING_SO • STRUC_SO
Geographical Information Management System (GIMS) • Can modify geometry in GeoMedia and Microstation • Less time spent on geometry updates • Data update “real time” for Transportation Data customers. No more nightly batch process
Facilities • Existing Data in IDMS • Moved to SQL server nightly • Spatial data stored in Oracle • Use GIS Software to link building information with spatial data • Build Web portal
Projects that use LRS • LRS V1 went into production summer 2006 • Ability for systems to do routing and location with LRS geometries
LRS and Snow runs • Ability to track snow runs for planning purposes • Garage supervisors create Excel spreadsheets • Spread sheets are loaded into an Oracle table and locations are derived from LRS
Stuff to Get! • http://www.gis.dot.state.ia.us/ • Intranet Site CTAMSWEB • http://www.iowadotmaps.com • http://ia.gisinventory.net/?set_group=cadastral • http://ortho.gis.iastate.edu/ • http://igic.gis.iastate.edu/resources/transport/