Oracle Spatial Team
Download
Report
Transcript Oracle Spatial Team
Technical Committee Update
PODS Technical Committee
Steering Committee (Ron Brush, Dan Palazzolo)
Data Modeling Team Update (Bryan Ferguson)
R&D Team Update (Michael Ray)
Admin. Team Update (Michael Emanuel)
GeoDatabase Update (Luke Hutmacher)
Oracle Spatial Update (Sue Whiting)
Technical Committee Steering Committee
Board Directives (7-1-2010)
ESRI Geodatabase release
Sample Domains
Documentation
PODS 5.1
PODS Web Site
Improved enhancement tracking
Modularize data model
Technical Committee Steering Committee
All TC Meeting tomorrow
Suggestions, ideas, feedback
Opportunities to Participate on TC
Join the TC
SME review – data model and documentation
Working groups
DATA MODELING TEAM
Bryan Ferguson
Data Modeling Team
Team Members
Bryan Ferguson
Rod Burden
Kirk Cameron
Aruna Gubba
Christopher Moravec
Douglas Thorpe
Tim Willms
Teresa Young
Data Modeling Team
Accomplishments for 2010
Completed OneCall and Damage Prevention sub
model
Minor Database Updates
Data Modeling Team
Plans for 2011
Complete issue task list
• Minor Spelling corrections
• Additional attributes to tables
• Changing or modifying data types
Complete External Corrosion Direct Assessment
(ECDA) sub model
If you have a simple request, send it in!
R&D TEAM
Michael Ray
R&D Team
Team Members
Michael Ray
Dion Duran
Yan Wang
Rodger Weller
R&D Team
PODS Domain Values
Sample Database
API Development
Team
Responsibilites
2010 Accomplishments
PODS Domain Values for Core
2010 Accomplishments
PODS Domain Values
Line_Type_CL
Line_System_Type_CL
Hierarchy_Level_CL
Route_Type_CL
Station_Point_Type_CL
Positioning_Type_CL
Source_GCL
Feature_Table
Feature_Category_CL
Gap_Rule_CL
Overlap_Rule_CL
History_Type_GCL
Feature_Status_GCL
History_Location_CL
2010 Accomplishments
PODS Domain Values
The sample domain values were compiled from data submitted by several
PODS members:
Enterprise Products
Texas Gas
Boardwalk Pipelines
Williams
New Century Software
Eagle Information Mapping
GeoFields
Domains compiled into single database
Domain values reviewed
Common domains reviewed, submitted
as PODS Domain Samples
2010 Accomplishments
PODS Domain Values
Sample domain values are only samples
Data is not intended to be viewed as a standard
Data is not linked to any level of “PODS Compliance”
Domains are only intended as a sample of what other operators and
vendors are using as domains
Domains will be available as an Access database, packaged with future
PODS releases
Domains were compiled on a PODS 5.x database
Domains are available on Wiki-PODS
Domains webinar is also available for download
2011 Goals
PODS Sample Database
Working, sample database
Sample database would include several small routes with several
attribute tables populated
Will give new members a reference to how PODS is implemented
Will be available as an Access download from Wiki-PODS
ADMIN TEAM
Admin Team
Team Members
Michael Emanuel
John Chioles
Mikel Collins
Janice Fisher
Gary Hoover
Olga Ingerman
Admin. Team
Goal 4
PODS Documentation
Goal 3
Data Dictionary
Goal 2
Website/Portal/Tools
Goal 1
Update Current Documents
Update Current Documentation
Define the Core Concepts
Recommended Implementation
Glossary of Terms
Updated
Implementation
Guide
Version 1.0
Updated Website/Portal
PODS.org
Current/Updated Content
Data
Dictionary
Wiki
Document
Model
Data Dictionary Documentation
Group 2
Pipe Facilities
Group 3
Cathodic
Protection
Group 4
Inspections/
Reporting
Group 1
Core
Group 5
Offline/
Compression
PODS Documentation
Implementation
Guide
For the Members
Operating
Guidelines
Bylaws
For our Volunteers
For our Organization
GEODATABASE TEAM
Luke Hutmacher
ESRI Geodatabase Team
Team Members
Luke Hutmacher
Pete Veenstra
ORACLE SPATIAL TEAM
Sue Whiting
Oracle Spatial Team
Team Members
Sue Whiting
Oracle Spatial Team
Team Overview
Oracle spatial extensions to PODS
Primary goals
• Minimal impact to PODS data model
• Optional extension to PODS
• Vendor neutral
Who are we?
We = me
Siva Ravada –Director of Development with Oracle
Spatial
Oracle Spatial Team
Accomplishments in 2010
Submitted Spatial Implementation for Member Review
Feedback Reviewed
Extensions (pending review and documentation)
• Implementation of Spatial in the offline tables
• Upgrade of Spatial to PODS 5.0
Oracle Spatial Team
Upcoming plans/goals for 2011
Meet with TIGF for an in-depth review of their PODS
spatial implementation.
Submit Spatial PODS 5.x for member review.
Finalize and release?
Feedback/Questions?
THANK YOU!
TECHNICAL COMMITTEE
TECHNICAL COMMITTEE
QUESTIONS?
Technical Committee Update