My nephew, Julian Padilla, is working as an unpaid intern at KSN. His first project is to help me build a functional GIS for one of the small sanitary districts my company works for.
As part of this work I’ve been designing and documenting a GIS data model for a sanitary sewer network. My nephew will be implementing the data model. This work us being done under the umbrella of the CCVGPG Utility Infrastructure Working Group. All of the data model diagrams are being created in Inkscape. The diagrams and other documentation for the data model will be shared under a Creative Commons License and will be released through Redefined Horizons and the CCVGPG.
So far, I’ve completed Simple Feature Attribute Diagrams for the two (2) main features in the data model, sanitary sewer pipes and sanitary sewer manholes. I’ve also completed Simple Feature – Feature Level Metadata Diagrams for these two feature types. I’ll be working on templates for both types of diagrams soon. After that, I’ll move on to a general entity relationships diagram, and then a diagrams for the topology tables.
Please contact me if you are interested in learning about the data model or participating in its design and documentation.
The Sunburned Surveyor