Adapting the ArcHydro Water Resource Data Model to NY State ...

Design and Implementation of a Geodatabase for New York State Canal Inspection Data Ruth Ann Trudell NY State GIS Users Conference Lake Placid, NY

October, 2009 Topics Project Canal Objective

History Inspection Methods, Data Storage and Need for modernization

Database Lessons Development Learned

Project Objective Provide a single storage location for all spatial and tabular data pertinent to Canal Inspections. Canal History

Travelway for Commerce Current Canal System Canal Management

Operated and maintained by the Canal Corporation, New York State Thruway Authority

Inventory performed by NYS DOT through MOU Canals managed primarily for recreational purposes and historic

values Canal Construction Parts of canal are embedded in the landscape; parts raised above.

Portions are raised above the surrounding landscape with the use of levees or embankments.

Typical High Embankment Embankment Failure Inspection Process Inspect every 5 years. Inspection segments delineated on paper

maps. Embankment conditions documented in field. Pictures taken at points of interest. Segments are ranked and rated. Miles of segments summarized by rating. Report written summarizing findings.

Inspection Segment Map Current Data Storage Paper maps, inspection forms and reports.

Disparate spatial files stored on CC and DOT servers. Solution? A Database! Database Development

Database Development Steps Determine Business Needs/Database Structure

Decide upon Database Elements Populate Database

Test by Querying Database 2009 Business Needs Meeting

Validate data input and output needs (business functions) Discuss Database Considerations

Spatial representations- feature classes vs. linear referencing Appropriate route Aggregation/disaggregation of data Image hyperlinks Database Structure

Personnel GDB File GDB Access DB Access based, user

familiarity Queries and data input done within ArcGIS environment User familiarity

Spatial data storage, Limited storage capacity Spatial data storage

Large storage capacity No spatial data storage; User develops relates in ArcMap

GPS check-in/checkout GPS check-in/checkout Topology stored

Topology stored Terrain storage capability File Geodatabase! Database Elements

Element 1- The Value of Terrains Element 2- Linear Representation; Events or Features Two Critical Questions: Use linear events or line features to

represent inspection segments? If events are to be used, which route is appropriate? which measure? Events vs. Feature Another Example

Selection of Linear Route Canals Corporation routed lines (measure in meters)

Canal Corporation lines calibrated to stationing in feet.

National Hydrography Dataset (NHD)- National Standard Elements 3-5 Features, Data Tables, Relationship Classes Event

Feature Element 6- Domains Element 7- Metadata And YES, of course a Data Dictionary!

Database Maintenance Complexities of Routes Requires for both Events and Feature Classes 1. Linear referencing requires event tables with measures, WHILE:

2. Field data collection using GPS and mapping query results both require features classes Tabular Data Input-Existing Feature Testing and Data Reporting

Extracting DataMaking Query Table Example: SQL Expression Segment2009.SegID = Inspection.SegID AND Inspection.AdjTerrain = DevRes

Segment2009.SegID = Inspection.SegID AND Inspection.InspectionID = OtbdChar.InspectionID AND OtbdChar.DrainStrID = DrainStruct.DrainStrID AND DrainStruct.StructCondition = Good Lessons Learned

Relationship classes in GDB depend on exact match of field names in feature attribute and data tables.

Use descriptive codes for coded domains. Exported tables contain codes, not descriptions! Ensure topology of routes is uni-directional and calibration point measures increase sequentially in

up route direction. Take advantage of NY State GIS Help Desk; They are an excellent resource!

Final Result Successful development of a database that addresses data storage, data retrieval and data display needs! Credits Dr. Patrick Kennelly, Graduate Advisor

Assist. Professor, Long Island University, and Penn State University Jamie DeLuca, NY State Canal Corporation Steve Heiser, Department of Transportation Ricardo Lopez and Tim Daly, Department of Environmental Conservation

END Hydraulic Modeling with NHD Spatial Placement, Canal Prism vs NHD Route Event Table, cont.

Example of Implementation Data Input- New Segments 1. Ensure database contains empty (temporary) segment feature related to inspection table (required to GPS new features),

2. Check out DB to GPS, 3. Collect data - database tables will be updated through relates, 4. Check in DB, 5. Use Locate Features along Routes to obtain

measures and RID, Data Input- New Segments (cont) 6. Rename Segment ID with measure info., 7. Append this attribute table to event table, 8. Recreate permanent feature class, 9. Empty contents of the temporary feature

class for future use with GPS.

Recently Viewed Presentations

  • CEO Council Meeting

    CEO Council Meeting

    Investment in next generation networks A competitive approach to stimulating Europe's broadband future - CEPS 22 February 2007
  • CS122B: Projects in Databases and Web Applications Winter 2018

    CS122B: Projects in Databases and Web Applications Winter 2018

    Document presentation format: On-screen Show (4:3) Other titles: Lucida Sans MS Pゴシック Arial Arial Unicode MS Wingdings Tahoma Comic Sans MS Times New Roman Default Design 1_Default Design CS122B: Projects in Databases and Web Applications Winter 2018 Purpose Example: edit...
  • Protocols


    Layering of network management protocol . Network Management Protocol Layers. NM Protocol: Transport. A L4/7 protocol for end-to-end communication. In fact, it is a separated independent protocol . However, NM protocols impose restrictions on transport protocols.
  • Rahab -

    Rahab -

    Jericho just 10 acers in size. The first archaeological excavations of Tell-es-Sultan (ancient fortified city of Jericho) were made by Charles Warren in 1868.Ernst Sellin and Carl Watzinger excavated between 1907-1909 and in 1911. John Garstang excavated between 1930 and...
  • Convection Forcée Le Long D'Une Plaque Plane

    Convection Forcée Le Long D'Une Plaque Plane

    Le gradient thermique engendre une distribution non uniforme de la densité, qui génère à son tour un mouvement convectif sous l'effet de la gravité. Types de convection. La convection forcée : ... flux de chaleur en convection.
  • PowerPoint Presentation

    PowerPoint Presentation

    Ocean Topography: Basins, Plains, Shelves, Ridges and …Oh My! The Motion in the Ocean. ... When the moon and Sun are in alignment (during a new or full moon), their combined gravitational forces result in a Spring Tide. When Spring...
  • Trigonometry: - Variation Theory

    Trigonometry: - Variation Theory

    @fortyninecubed. ?=63.4° ?=45° ?=78.7° ?=11.3° ?=0° This triangle is impossible - why?
  • Unpaid Vacation, Sick & Leave Codes and Additional

    Unpaid Vacation, Sick & Leave Codes and Additional

    Unpaid Vacation, Sick and Leave Codes. Purpose. To ensure an accurate accounting of an employee's time off - paid or unpaid. The potential overpayment of salaried employees due to unpaid vacation, sick and leave will be eliminated.