In a GIS, a data model is an abstract representation of geographic data. The model itself is platform independent, while specific implementations of a model are not. The models provided on this site are specific to ESRI software. For additional information about data modeling, read ESRI's "Data Models Introduction."
Publishing Oakland County's version of these data models provides the GIS community with a starting point for the modeling process, and promotes the development and utilization of federal and local standards.
The data models are available in multiple formats: PDF poster, Visio diagram, and Geodatabase Schema. Though the Oakland County Enterprise GIS is publishing these models, please note that they are a living document, and may change as needs and technology develop.
Available Data Models:
Facilities Data Model
This is the Facilities data model, which contains 3 feature datasets that include Communications, Facilities & Structures and Hazardous Sites. Educational and industrial features as well as tornado sirens, hospitals, golf courses, and leaking underground storage tanks are an example of the feature classes contained within. Each feature class in the model is point geometry except WANFiber, which is line geometry. There are no topology rules established within this model. Domains are used for many of the attributes. Metadata is available for most feature classes.
Hydrography Data Model
The Hydrography data model includes design concepts from ESRI's ArcHydro data model and the National Hydrography Dataset (NHD) known as NHDinGEO. The model contains point, line, and polygon geometry as well as a geometric network and two relationship classes. Also included in the model are tables that manage unique IDs across the entire Hydrography dataset. These IDs are helpful when using the ESRI ArcHydro tools, which model hydrologic flow for water resource management. This data model does not currently contain metadata.
Land Management Data Model
The Land Management data model incorporates roads, parcels, the Public Land Survey System (PLSS) framework, and administrative areas such as municipal boundaries and legislative districts. The model includes topology rules for each feature dataset along with related domain value tables. The purpose behind this design was to help users manage these complicated, interdependent datasets in one cohesive model using core ArcGIS functionality.
Expected enhancements to this data model will include site and mailing addressing; parcel value; and assessment. In addition, methodology necessary to maintain the complex topological relationship between municipal district boundaries (and dependent datasets); and the road centerlines and parcel boundaries are being developed.
Parks and Recreation Data Model
The Parks and Recreation data model incorporates all parks, trails, facilities, and various site amenities within the Oakland County Parks system. This was initially developed as part of the Collaborated Asset Management System (CAMS) and to assist the parks department with preventative maintenance and effective life cycle planning. The model includes all point, line, and polygon features for each feature dataset along with metadata and related domain value tables. The purpose behind this design was to help users manage these complicated, interdependent datasets in one cohesive model using core ArcGIS functionality.
(Note about the data model formats)
The data models are available in multiple formats:
- Data Model Poster - A PDF of the model poster, which can be viewed on screen using Acrobat Reader, or can be plotted.
- Data Model Diagram - A Visio diagram of the model, which can be viewed on screen using Microsoft Visio™ 2000 or can be plotted.
- Database Schema - An empty personal geodatabase schema, which can be used to create a new personal geodatabase using ESRI’s ArcCatalog 8.3.
The spatial reference of the database schema is specific to Oakland County and may need to be altered. Because of the advanced geodatabase functionality incorporated into the database schema model, an ArcInfo license is required to load data.