Appendix A _ GIS Conduit and Structure Data.xlsx

This is a GIS data specification document for the City of Sandy Springs, Georgia's Stormwater Asset Assessment contract opportunity, establishing standardized data attributes for conduit and structure inventories within the municipal stormwater system. The specification details comprehensive data collection requirements for enclosed gravity pipes, force mains, open channels, and various stormwater structures including manholes, catch basins, drop inlets, headwalls, and flared end sections. For conduits, the document prescribes 30 data attributes covering physical characteristics (type, shape, material, diameter/height, width), inspection information (date, inspector name and organization, condition ratings), and defect documentation (blockage percentage, water level, structural defects, erosion type, and repair priority codes). For structures, the specification requires 26 data attributes similarly addressing physical properties, material composition, operational status, and condition assessment parameters. Both conduit and corrective action coding systems are provided with standardized integer codes and descriptive text fields, enabling consistent documentation of system conditions ranging from "Very Good" to "Very Poor" and repair priorities from "Immediate" to "Beyond 2 Years."

The document establishes detailed GIS field naming conventions and data type requirements (long integer, short integer, text fields with character limits, and date fields) to ensure database compatibility and standardized reporting across the stormwater asset inventory. Additional mandatory fields include inspection notes (up to 256 characters), corrective action notes (up to 100 characters), and unknown reason documentation (up to 255 characters) for conditions preventing full assessment. The specification includes provisions for reporting failed or failing infrastructure to the City of Sandy Springs Stormwater division with documented notification dates and follow-up inspection recommendations. All data collection must identify the creator and editor of records with corresponding creation and edit date timestamps, establishing clear accountability and audit trails for the stormwater asset database.