Transcript PipeView SDE

2001 ESRI Petroleum User Group
PipeViewSDE
Delivering ESRI Data to the
Enterprise in a CAD World
M.J. Harden Associates Inc.
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
Introduction and Outline
•
•
•
•
•
•
•
•
M.J. Harden Associates Inc.
PipeView and PipeViewSDE
SDE and CadClient
File-based PipeView Architecture
SDE-based PipeView Architecture
PipeViewSDE and the Enterprise
CadClient and MJH Loader
Summary
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
M.J. Harden Associates Inc.
• Founded in 1956
• M.J. Harden specializes in:
• Data Conversion, Photogrammetry, Software Applications
• GIS Transmission Pipeline Implementations
• 100,000+ miles of pipeline implemented in ISAT by 2002
• Implementing Pipeline GIS since 1987
• M.J. Harden develops software products for the Pipeline Industry:
• PipeView, Sheetgen, Risk Assessment and Pipe Access Web
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeView (Standard)
• 32-bit Windows COM application written in Microsoft C++
• Maintenance and management tool
• Uses the GRI ISAT database model
• ISAT used to manage pipeline hierarchy and facility attributes
• ODBC connection to ISAT  Oracle or Microsoft SQL Server
• Allows CAD-based editing of geographic features using AutoCad,
AutoCadMap and Microstation as CAD Engines
• Links viewable external documents such as:
• reports, schematic drawings, images and ortho-photos
• SheetGen tool for Alignment Sheet Generation
• PipeAccess Web  displaying facilities and ISAT attributes to web
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
What is SDE?
• Set of middleware, algorithms, asynchronous client/server processes
and data structures for managing spatial features in RDBMS
• Adds spatial data storage to normal RDBMS database tables
• Backbone of the ESRI ArcGIS Architecture
• SDE is an solution for delivering spatial data across the enterprise
• Top twelve reasons for using SDE …
• FAST! (needles in haystacks, not buckets of needles!), RDBMS security, multi-user,
seamless spatial data, scalable technology, standard data format,
wide variety of clients, transaction-based processing and
advanced data structures (GeoDatabase), standard TCP/IP
networking, spatial search operators, projection engine and robust
API for access with industry-standard development tools.
• SDE 8.1 Beta 1, CadClient 8.1 Pre-release ++, AutoCadMap2000,
Microsoft SQL Server 7.0 (sp2)
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
What is CadClient?
•
•
•
•
EXTENSION to Bentley Microstation and Autodesk AutoCAD
Provides gateway from CAD environment to SDE
Simple to use
Provides the power of CAD tools for data maintenance and the
enterprise data management capability of SDE
• Connect, disconnect from RDBMS/SDE-enabled database
• Test connection to RDBMS/SDE-enabled database
• Store, retrieve, edit, analyze CAD and SDE data
• Extendable and customizable with simple API (ActiveX, C, ARX, LISP)
• Stores data as ESRI ShapeFile and CAD format plus attributes
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeView: File-based Architecture
ISAT
RDBMS
Geobase
Routing
Ext_Doc
Facility
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeView: File-based Architecture
• Limitations of Cad-based environment for data storage
• Flat files used to store data
•
•
•
•
•
Large files require very fast machines – long load times
Single user access – no security, corruption
No transaction based processing
Can break files into geographic districts – requires management
Limitations of CAD data structures and application functionality
• Requirements of the enterprise
•
•
•
•
View the data on the web
View and analyze the data across the enterprise with thin clients
Keep data secure
Provide long transactions
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeViewSDE: SDE Architecture
ISAT - RDBMS
Geobase
Routing
Ext_Doc
SDE
PipeViewSDE: Delivering CAD to the Enterprise
Facility
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeViewSDE: Architecture
ISAT
RDBMS
Instance
Host
RDBMS
Instance
External
Applications
MSLINK
to attributes
LAYERS
SDE
B
F
B
 ISAT Rules!
F
B
F
S
S
S
ESRI CAD Client
Shape Column
MSLINK
Column
MSLINK
to attributes
MSLINK
Extended
Entity
Information
CAD TOOL
CAD
Elements in DWG
CAD Column
PipeView
PipeViewSDE: Delivering CAD to the Enterprise
MSLINK
Column
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeViewSDE and the Enterprise
Host
RDBMS
CAD in and CAD out + MSLINK
CAD TOOL
ESRI CAD Client
Spatial Database
Engine (SDE)
External
RDBMS
MSLINK
to attributes
CAD Elements
in DWG
B
WEB
ArcInfo/ArcView
MapObjects
F
Shape Column
CAD Column
ArcIMS
Element
Description
+ MSLINK
LAYER
S
SHAPE Out
ESRI
Internet
&/or
Desktop
Clients
ArCexplorer
PipeViewSDE: Delivering CAD to the Enterprise
LAYERS
B
F
B
F
B
F
S
S
S
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeViewsde – what the user sees …
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeViewsde – what the user sees …
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
PipeViewsde – what the user sees …
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
CadClient and MJH Loader
• What worked and what did not work with CadClient
• Edit Shape lose CAD
• Un-uniform extended entity data handling
• Object Data, Block Data, DB Links, Extended Entity Data
• No user-control over suppressing CadClient Dialog Boxes
• Awesome API especially with ActiveX
• MJH Loader
• Post process Object ARX
entity information
• Double loading times
• Requires heavy-duty
client machine
• Written in VB/AutoCad VBA
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.
2001 ESRI Petroleum User Group
Summary
•
•
•
•
•
PipeView
SDE and CadClient
File-based versus SDE-based PipeView
PipeViewSDE and the Enterprise
CadClientMJH PipeViewsde - Architecture
PipeViewSDE: Delivering CAD to the Enterprise
M.J. Harden Associates Inc.