1 / 25

How does a community maintain a storm water infrastructure database in ArcGIS 9.3 using the ESRI Local Government Data

How does a community maintain a storm water infrastructure database in ArcGIS 9.3 using the ESRI Local Government Data Model?. Adam Pooler, GISP Senior GIS Analyst Stantec. Troy Sova GIS Analyst Stantec. 2013 Ohio GIS Conference

early
Download Presentation

How does a community maintain a storm water infrastructure database in ArcGIS 9.3 using the ESRI Local Government Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How does a community maintain a storm water infrastructure database in ArcGIS 9.3 using the ESRI Local Government Data Model? Adam Pooler, GISP Senior GIS Analyst Stantec Troy Sova GIS Analyst Stantec 2013 Ohio GIS Conference September 12, 2013 @ 1:00 pm | Columbus Marriott Northwest | Dublin, Ohio

  2. Outline • Project Area • Multi-Step Process – Data Collection • Integration into Data Model • Geometric Network and QA/QC • Conclusion • Questions

  3. City of Springdale (yellow outline)

  4. PROJECT AREA (red outline)

  5. Multiple Phases Stormwater 9.3 File Geodatabase • Phase 1 • Pre ESRI Data Model • Data Collection • Phase 2 • Data Collection • ESRI Data Model • Phase 3 • Data Collection • QA/QC • Geometric Network Local Gov. Data Model

  6. Multi-StepProcess • Step 1 • Scan Paper As-Built Drawings into digital TIF format using a Large Format Plotter/Scanner

  7. Step 2a • Geo-Reference TIF files using Imagery and Street Centerlines within ArcMap’sGeoreferencing Toolbar

  8. Step 2b • GeoreferenceTIF Files multiple times if drawing sheets have more than one plan layout.

  9. Step 3 • Digitize Storm Features (Catchbasins/Inlets, Outfalls, Gravity Mains, Underdrains, Manholes)

  10. Step 3 • Digitize Storm Features (Catchbasins/Inlets, Outfalls, Gravity Mains, Underdrains, Manholes) Manhole Gravity Main Inlet Outfall *Source – Google

  11. Step 4a • Collect any attributes associated with the Storm Features from the plan drawings (e.g. Pipe sizeand Type of Construction)

  12. Step 4a • Collect any attributes associated with the Storm Features from the plan drawings (e.g. Pipe size and Type of Construction) Pipe Size Type of Construction

  13. Step 4b • Collect any attributes from the profile drawings (e.g. Invert Elevations, Slope)

  14. Step 4b • Collect any attributes from the profile drawings (e.g. Invert Elevations, Slope) Pipe Size Slope Invert Elevations

  15. Step 5 • QA/QC attribute table for each storm feature class, checking for missing attributes or inconsistencies. • Check for large gaps or congested areas in the data • Missing subdivision as-built drawings • New Construction • Use model’s Domains to attribute featureswhere possible.

  16. ESRI’s Local Government Data Model • ArcGIS for Local Government • “ArcGIS for Local Government includes a series of maps and apps designed to work together across various departments.” Source: ESRI • Reduces the complexity of implementing and managing GIS in a local government setting. • Model supports multiple data schemas. Land Records Address Elections Planningand Development Local Government Data Model Facilities / Campus Public Safety Infrastructure Public Works

  17. Data Schema - Stormwater • http://help.arcgis.com/en/localgovernment/datadictionary.html

  18. Problem – Using a ArcGIS 10 Data Model within ArcGIS 9.3 Software • Data model contains relationships setup in 10.X, which do not communicate with 9.3. • Tools developed specifically for Data Model only accessible in 10.X • Attribute Assistant • Infrastructure Abandon Models • Infrastructure Desktop Construction Tools • Infrastructure Editing • Infrastructure Reporting

  19. Data Model Tools • Attribute Assistant – Advanced capabilities to calculate attribute data. • Four ArcMap Commands and one ArcMap Toolbar • Infrastructure Desktop Construction Tools • Four new point construction tools and one new line construction tool. • Infrastructure Desktop Toolbars • Infrastructure Editing • Infrastructure Reporting

  20. Setting Up a Geometric Network • Step 1a & b – Network Name, Snapping Tolerance & Features • Step 2a & b –Enable Values and Select Roles for each Feature Class

  21. Setting Up a Geometric Network Modify Sources & Sinks after Creation • Step 3 – Add Weights to Network • Step 4 – Review Results

  22. Quality Assurance/Quality Control • Setup a Geometric Network and Update Connectivity between Storm Features. • FYI – The Geometric Network Tool only works with an Editor or ArcInfo License • Compare features collected to As-Built drawings (features and attributes)

  23. Lessons Learned • Update Domains prior to data entry as much as possible. • Use an unmanaged Raster Catalog. • Start Project with Data Model and Geometric Network

  24. Conclusion • ESRI’s Local Government Model Schema works with older versions of ArcGIS without having to upgrade. • Converting As-Built Drawings to Digital Format takes time up front but is a more manageable system in the long run.

  25. Questions? Adam Pooler, GISP • Adam.Pooler@stantec.com Troy Sova • Troy.Sova@stantec.com

More Related