Data Structure, Fields, and Collection

Overview

The Wastewater Infrastructure Mapping project involves the systematic collection and organization of data related to wastewater systems across towns in Vermont. This section provides detailed information about the data structure, the fields included, and the methods used for data collection.

Data Structure

The data is organized in a structured format to ensure consistency, ease of access, and usability. The primary data structure used is a relational database, which allows for efficient querying and management of the data.

Sewer Service Area

• System_Name - SystemName: Wastewater system name
• System_Owner - SystemOwner: Wastewater system owner
• TownID - TownID: Town identifier
• Treatment_Facility - Treatment Facility: Treatment Facility name
• GIS_Notes - GISNotes: Notes about data
• GIS_Date - GISDate: When the GIS data was originally created
• GIS_Update - GISUpdate: When the data was last updated
• Creator - Creator: Default to VTANR, change to VERSO if we create new data

Wastewater Infrastructure (Linear Features)

• Type - Type: Stormline, sanitary, combined sewer, etc
• Status - Status: Existing, Proposed, Abandoned
• Comment - Comment: Comment on the data
• Source - Source: Where data was obtained from
• MapDate - Map Date: Date of map where data originates
• Audience - Audience: Public, private
• SystemType - SystemType: Type of water system
• Creator - Creator: Default to VTANR, change to VERSO if we create new data

Wastewater Infrastructure (Point Features)

• Type - Type: Sanitary Manhole, Stormwater Manhole, Combined Sewer Manhole, CSO Outflow, etc
• Status - Status: Existing, Proposed, Abandoned
• Comment - Comment: Comment on the data
• Source - Source: Where data was obtained from
• MapDate - Map Date: Date of map where data originates
• SystemType - SystemType: Type of water system
• Creator - Creator: Default to VTANR, change to VERSO if we create new data

Wastewater Facilities

• FacilityName - Facility Name: Name of facility
• DesignHydraulicCapacityInMGD - Design Hydraulic Capacity In MGD: Amount of water the facility can process in a year
• SeptageReceivedAtThisFacility - Septage Received At This Facility: Does this facility receive septage? (Yes or no)
• PermitID - PermitID
• PermitRecordID - Permit Record ID
• PermitteeName - Permittee Name: Name of town served
• ProgramCategory - Program Category: Municipal, industrial, or pretreatment
• NPDESPermitNumber - NPDES Permit Number
• PermitLink - Permit Link: Link to permit

Town Boundary

• GEOID - GEOID
• NAME - Name: Name of town
• NAMELSAD - Name LSAD
• LSAD - LSAD
• MunicipalWastewater - Municipal Wastewater: Does the town have a municipal wastewater system? (Yes, No, or In Progress)

Onsite Sewage Disposal Soil Ratings

• Rating - Rating: Well Suited, Moderately Suited, Marginally Suited, Not Suited, Not Rated