Interoperability of GIS and Microstation

1
Interoperability of GISand Microstation
Presented by City of Lincoln Public Works
Utilities Department Watershed Management
Division JEO Consulting Group, Inc.
March 8th, 2006
Nebraska Microstation Users Group 2006 Spring
Conference
2
Watershed Management GIS Program Priorities

• Integration of existing CAD data into a GIS
• Stormwater system assessment prioritization
• Development of a comprehensive WSM Spatial
  Database to house data from all aspects of WSM
  System

Nebraska Microstation Users Group 2006 Spring
Conference
3
Watershed Management GIS Program Priorities

• CAD ? GIS ? GEOPAK ? GIS

Database Skeleton
Modeling Data Enhancement
Final Db Schema
Dumb Lines
Nebraska Microstation Users Group 2006 Spring
Conference
4
Integration of Existing CAD Data

• Wealth of information in the current CAD system.
• Current format does not allow for easy
  implementation into any H H modeling programs.
• Dumb Lines with text annotation.
• Some data voids in the CAD data.
• Conversion of Microstion DGN data to ArcGIS
  format Automated procedure (with manual QA/QC)
  in ArcINFO will be implemented for completion of
  data conversion.
• 13 Square Miles have been manually converted to
  facilitate 3 phases of the Urban Drainage project.

Nebraska Microstation Users Group 2006 Spring
Conference
5
Integration of Existing CAD Data into GIS

• CAD text annotation to feature linked GIS
  attributes.

Nebraska Microstation Users Group 2006 Spring
Conference
6
Integration of Existing CAD Data into GIS

• GIS attribute export
• X,Y,Z
• Material, Size,
• Other necessary data

Nebraska Microstation Users Group 2006 Spring
Conference
7
GIS Data Import into GEOPAK Drainage
GIS Attribute Export
Custom VBA Application created in Microstation to
import data into an empty GEOPAK Drainage Model
Maintains size, location, type of structure, etc.
Nebraska Microstation Users Group 2006 Spring
Conference
8
Modeling Using GEOPAK Drainage
Basic Model has been created
Nebraska Microstation Users Group 2006 Spring
Conference
9
Modeling Using GEOPAK Drainage

• Information on all elements
• maintained through data import
• Location
• Size
• Type of Structure
• Etc
• GIS Attributes become GEOPAK Drainage Parameters

Nebraska Microstation Users Group 2006 Spring
Conference
10
Output Data from GEOPAK Drainage
Customized reports created for each element type
that include relevant information
Nebraska Microstation Users Group 2006 Spring
Conference
11
GIS Data Generation

• Text Files of object coordinates

Macro Conversion
Import into GIS for data creation
Stormwater GIS Database
Nebraska Microstation Users Group 2006 Spring
Conference
12
Data Integration
GEOPAK reports provide element attributes for GIS
database
Nebraska Microstation Users Group 2006 Spring
Conference
13
Data Integration
Nebraska Microstation Users Group 2006 Spring
Conference
14
Stormwater System Deficiencies

• Illustration of Analysis Results
• Thematic Mapping

Nebraska Microstation Users Group 2006 Spring
Conference
15
Conceptual Project Development
Conceptual Projects Developed Based on Stormwater
System Deficiencies using GIS
Nebraska Microstation Users Group 2006 Spring
Conference
16
Incorporation with City Database

• Provides Virtually Limitless Data Management
  Opportunities

• Pipe Type, Material and Slope
• Pipes smaller than City standard minimum
• Sump locations, sag inlets with ponded depth gt
  0.5 ft
• Drainage Sub-areas and Composite Runoff
  Coefficient
• Manholes with Large Junction Losses
• Pipes with HGL Above Ground, Potential Blowout

Nebraska Microstation Users Group 2006 Spring
Conference
17
Incorporation with City Database

• Provides Virtually Limitless Data Management
  Opportunities

• Geographic Dispersion of Conceptual Projects
• Proximity of Projects to Critical Facilities
• Priority Ranking and Cost of Conceptual Projects
• City Project Numbers and Construction Dates
• Cross-Reference with Other Utility Projects
• Stormwater, Sanitary Sewer, Water, Roads, Other

? Aid in Budgeting, Planning and Coordination of
Utility Projects
Nebraska Microstation Users Group 2006 Spring
Conference
18
Best of Both Worlds
ArcView GIS
Microstation / GEOPAK Drainage
H H Modeling Capabilities Existing City of
Lincoln Basemaps Preferred City of Lincoln Design
Software
Geographic Analysis Capabilities Asset
Management Single Database
Nebraska Microstation Users Group 2006 Spring
Conference
19
Watershed Management Goals
Seamless GIS-Microstation/GEOAPAK Infrastructure
Export for Designing Improvements
GIS Database
Microstation / GEOPAK Drainage
Construct Improvements Create As-Built/Record
Drawings
Nebraska Microstation Users Group 2006 Spring
Conference
20
Questions?
Nebraska Microstation Users Group 2006 Spring
Conference