Not logged in. Log in.
Go back to PPDM StandardsSpatial Downloads
Reference Guides
Spatial 2002 Reference Guide (PDF; 576K)
Spatial 2003 Reference Guide (PDF; 1.3MB)
High Level Data Model
PPDM Spatial 2002 focussed on spatially enabling well header and well test information. The following images show how to relate from a spatial feature to PPDM and how the data within the PPDM well test module is related.
Spatial Well Diagram (PNG; 9K)
Well Test Diagram (PNG; 23K)
Presentations
Presentations from the workgroup and other selected public meetings are included
ESRI PUG Conference Feb. 24, 2004 (PDF, 1.8 MB)
Technical Presentation Jul 23, 2003 (PDF, 1.6MB)
ESRI User Conference July 8 2003 (PDF, 552K)
2003 Spring Conference Presentation June 2, 2003 (PDF, 1.62 MB)
Technical Presentation March 6, 2003 and March 12, 2003 (PDF, 262K)
ESRI PUG Conference March 11, 2003 (PDF, 589K)
Fall Conference Workgroup Presentation 23 October 2002 (PDF; 2 MB)
Spatial Project Update, October 21, 2002 (PDF; 1.24 MB)
Workgroup Presentation 03 October 2002 (PDF; 3.28 MB)
ESRI User Conference 10 July 2002 (PDF; 2.46 MB)
Workgroup Presentation 31 May 2002 (PDF; 1.90 MB)
Documents
Project Charters
Spatial Enabling 2003 Project Charter (PDF; 557K)
Spatial Enabling 2004 Project Charter (PDF; 114K)
Architectural Principles
PPDM Lite - Architectural Principles Draft (PDF; 624K)
Member Downloads
Oracle Spatial Simple Feature Database
This file was created from an Oracle 8.1.7 database. It contains the full PPDM schema and spatial layers with the geometry information stored in Oracle Spatial storage format.
Spatial 2003 Oracle Spatial Dump (ZIP, 2.14 MB)
Java Code for geometry generation
The code is used to generate the geometry information in Oracle Spatial format and populate the relational tables in PPDM.
PPDM Spatial 2 Code (ZIP, 36K)
Simple Feature Database Geometry creation (ZIP, 20K)
Simple Feature Database Geometry extraction (ZIP, 18K)
SQL Code for business view creation
A series of views based on a PPDM database have been created to present data in a more "user-friendly" manner. Where necessary these views contain spatial information, other views are normal database views.
Data Management
The following scripts show that it is possible to use traditional database procedures and scripts to maintain data integrity within a spatially enabled database.
Simple Feature Database Trigger (ZIP, 2K)
Object Behaviour
The following script shows how to capture object behaviour and validate
that a land mineral right exists inside the spatial extent of another
object
Simple Feature Object Behaviour (ZIP, 5K)
ESRI PUG Member and PPDM Member Downloads
These downloads are available to all members of the PPDM Association.
Detailed UML
UML is available in two formats: as a Visio diagram that was created as part of the Spatial Project in 2002 and as XMI that was created as part of the Spatial Project in 2003.
Visio 2000 Enterprise (VSD, 672K)
The following download contains an XMI file that ArcCatalog can import to create a Geodatabase. It also contains a DTD file that allows the XMI file to be viewed using Internet Explorer (version 5.0 or greater). Finally, the download also contains a Microsoft Visio Pro 2002 file for the well header and well test module in PPDM.
UML Download (ZIP, 525K)
Personal Geodatabase
The Personal Geodatabase contains the spatial and attribute information for the well header and the attribute information for the well test module of a PPDM database.
Spatial 2003 Personal Geodatabase (ZIP, 4.61MB)
MS Access Repository
The respository is created as an export from Visio 2000 Enterprise. It is used to create a database schema in ArcCatalog. Full details on how to import the schema are given in the Reference Guide
Sample ArcMap Document
The ArcMap document uses data stored in the Personal Geodatabase. In order to function correctly both the Personal Geodatabase and the ArcMap document need to be in the same directory (folder).
The map shows spatially enabled wells and well tests displayed as a route event
Oracle Enterprise Geodatabase
These files were created from an Oracle 8.1.7 database. They contain the full PPDM schema and the spatial extensions to store all the data created in Geodatabase format for the PPDM Spatial 2003 project
Oracle Enterprise Geodatabase (ZIP, 5.24 MB)
Geodatabase Geometry Creation Scripts
The following scripts are used to create SDE Binary geometry feature classes from object classes in a PPDM compliant Geodatabase.
Geodatabase geometry creation (ZIP, 20K)
Geodatabase geometry extraction (ZIP, 28K)
More Geodatabase geometry creation (ZIP, 27K)
More Geodatabase geometry extraction (ZIP, 38K)
Raster Data Integration
The following scripts use ArcObjects code to extract elevation values from a Digital Elevation Model (DEM) and then update the relational tables.
Raster Integration (ZIP, 7K)
Data Management
The following scripts show how it is possible to maintain consistency between a source (relational) database and a Geodatabase.
Geodatabase Trigger (ZIP, 10K)
Geodatabase Stored Procedure (ZIP, 8K)