From the Traditional Data Model to the GIS Data Model

1
From the Traditional Data Model to the GIS Data
Model

• Carl Livingood

2
Future of Data Distribution
Outage Mgmt.
Work Mgmt.
GIS
Tabular and Spatial Data (RDBMS/ODBMS)
Asset Mgmt.
Accounting
Network Analysis
3
Transforming to the GIS Model

• Same concerns as discussed for database
  application development
• Denormalize for performance, ease of application
  programming
• Reduce for scope consistency
• Simplify for data maintenance realities

4
Normalized Facility Model
Electric_Component
Facility_Xref
facility-key phase
component_key(FK) fac_key(FK)
Conventional_Xfmr
Step_Xfmr
xfmr_key kva nameplate_pri_voltage nameplate_sec_v
oltage
step_xfmr_key highside_voltage lowside_voltage
5
Denormalized Facility Model
Conventional_Xfmr
Step_Xfmr
xfmr_key phase kva nameplate_pri_voltage nameplate
_sec_voltage
step_xfmr_key phase highside_voltage lowsize_volta
ge
6
More Transforming to the GIS Model

• Concerns unique to GIS technology
• Fit the model to the architecture of the selected
  GIS
• Anticipate GIS-unique application requirements
• Consider geometry definition for facilities
• Review existing mapping standards for aesthetic
  consistency
• Optimize for symbology/rendering

7
Adding Children - Real WorldModeling
Xfmr_installation
xfmr_installation_key phase voltage location
(point geometry)
Xfmr
xfmr_key phase kva nameplate_pri_voltage nameplate
_sec_voltage xfmr_installation_key (FK)
8
Network Connectivity

• Functionality supplied by the GIS Vendor
• Allows for the tracing of the network
• Requires Definition of rules for facility
  interaction
• In some cases, requires geometry attribute review
  for point coincidence
• Requires review of stop points within the network

9
Achieving Coincidence for Connectivity
location
10
Achieving Coincidence for Connectivity
Xfmr_installation
xfmr_installation_key phase voltage location
(point) physical_location (point)
Xfmr
xfmr_key phase nameplate_pri_voltage nameplate_sec
_voltage xfmr_installation_key (FK)
New geometry
11
Achieving Coincidence for Connectivity
physical_location
location
12
Multiple Connectivity
Structure
Connection points
13
Multiple Connectivity
Pole
pole_key height class location (point)
Connection_point
connection_point_key location (point) pole_key
(FK)
14
Food for Thought

• Datamodels and applications usually evolve after
  they go into production
• Knowledgeable resources should be available
  during development
• Keep future extension in mind when designing the
  model and the application
• Choose one or two applications for initial
  datamodel design