"HydInfra2012 06FEB12", Dictionary, version, 5, "Ex = inspect existing  & T_ = create new"
"Basic Session", point, "One Basic Session per file", 5, seconds, 1, Code
   "Inspector initials", text, 30, required, "Who are you?", required, Label1
   "Inspector 2", text, 30, normal, "Who is second inspector", normal, Label2
   "Inspection Reason", menu, required, "Why are you inspecting today?", required
      "Scheduled Review", default
      "Programmed Project"
      "Complaint"
      "Post Event"
      "Other"
   "Low SP Number", numeric, 6, 1.000000, 10000.000000, 1111.990000, normal, "No Dash. Use decimal point instead.", normal

"ExPipeandInsp", point, "Exist HYDINFRA Pipe and Inspection", 1, seconds, 5, Code
   "HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Only use HYDINFRA ID from database", normal, Label1
   "Local ID", text, 30, normal, "Temporary field identifier", normal, Label2
   "Activity", menu, required, "Describes Activity", required
      "Liner"
      "Extension"
      "Verify"
      "Change"
      "Duplicate"
      "Abandon"
      "Clean"
      "Repair"
      "Clean/Repair"
      "Install"
      "Remove"
      "Other"
      "Video"
   "Material", menu, required, "Material pipe is made of.", required
      "Concrete"
      "Corg. Steel (CSP)"
      "Structural Plate"
      "Corg. Plastic (HDPE)"
      "PVC"
      "Liner PVC"
      "Liner HDPE"
      "Liner Cured in Place"
      "Liner Metal"
      "Liner Other"
      "Aluminized Steel"
      "Corg. Aluminum (CAP)"
      "Bituminous-Coated"
      "Polymeric-Coated"
      "Perforated Plastic"
      "Timber"
      "Other"
   "Width Qt.", numeric, 0, 1, 30480, 24, required, "Measure width of liner, extension or", required
   "Height Qt.", numeric, 0, 1, 30480, 24, required, "Measure ht of liner, extension or change", required
   "Dim. Units", menu, required, "Dimension Units", required
      "Inches", default
   "Pipe Shape", menu, required, "Culvert or Strm Drn Pipe x-section shape", required
      "Round", default
      "Strm Round"
      "Arch"
      "Strm Arch"
      "Box"
      "Slot Drain"
      "Elliptical"
      "Other"
   "Length", numeric, 0, 0, 1000, 0, required, "length of liner or extension or pipe ", required
   "Lgth Units", menu, required, "Length Units", required
      "Feet", default
   "Lngth Deter. Method", menu, required, "How was length determined?", required
      "Measured"
      "Estimated", default
      "Scaled"
      "Plan"
   "Class", menu, normal, "Pipe Class or Gage", normal
      "8 Gage"
      "10 Gage"
      "12 Gage"
      "14 Gage"
      "16 Gage"
      "18 Gage"
      "Class II"
      "Class III"
      "Class IV"
      "Class V"
      "Special Design"
      "Unknown", default
   "Visible Length", menu, required, "Can you see entire length of pipe?", required
      "Complete Visual"
      "Partial Visual", default
   "Visible Circum", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Overall Condition", menu, required, "Structural integrity of pipe. 0=unknown", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Needs Cleaning?", menu, normal, "Pipe's end is 1/3 full of sediment.", normal
      "Y"
      "N"
   "Needs Repair?", menu, normal, "Pipe needs to be fixed -- rate 3 or 4.", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Is water standing or backed up in pipe?", normal
      "Y"
      "N"
   "Silt present?", menu, normal, "Sediment deposited in pipe.", normal
      "Y"
      "N"
   "Plugged?", menu, normal, "Pipe end is mostly obstructed.", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "Piped is pitted or rusted", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls/CMP loose flakes", normal
      "Y"
      "N"
   "Cracks?", menu, normal, "Pipe has cracks", normal
      "Y"
      "N"
   "Holes?", menu, normal, "Hole goes through the pipe", normal
      "Y"
      "N"
   "Joints Separated?", menu, normal, "Joint is separated more than 1"", normal
      "Y"
      "N"
   "Misalignment?", menu, normal, "Pipe section offset laterally, has gap", normal
      "Y"
      "N"
   "Deformed Pipe?", menu, normal, "Pipe Distress - Pipe shape is distorted", normal
      "Y"
      "N"
   "Infiltration?", menu, normal, "Soil or water infiltration into pipe", normal
      "Y"
      "N"
   "Piping?", menu, normal, "Water runs along pipe exterior", normal
      "Y"
      "N"
   "Inslope Cavity?", menu, normal, "Holes in inslope around pipe", normal
      "Y"
      "N"
   "Road Distress?", menu, normal, "Road bump, dip, pvmt patch or cracks", normal
      "Y"
      "N"
   "Void in Road?", menu, normal, "Evidence of hole in road near pipe", normal
      "Y"
      "N"
   "Repair under Road?", menu, normal, "Is repair required inside shoulder PI?", normal
      "Y"
      "N"
   "Erosion?", menu, normal, "Erosion near pipe.", normal
      "Y"
      "N"
   "Marker Type?", menu, normal, "Marker Type?", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Comment", text, 100, normal, "Comment on extraordinary circumstances", normal
   "Sediment % Full", numeric, 0, 0, 100, 0, normal, "% of Pipe height filled by sediment", normal
   "# Joints Need Repair", numeric, 0, 0, 100, 0, normal, "DB field: HYPINS_IPCD_PER3_PC", normal
   "Max Joint Sep inches", numeric, 0, 0, 100, 0, normal, "DB field: HYPINS_IPCD_PER2_PC", normal
   "Recommend a Repair", menu, normal, "DB field: HYPSA_ASSIGNED_TO_TX", normal
      "Reset"
      "Slipline"
      "Cured inplace liner"
      "Joint Repair"
      "Paved Invert"
      "Trench"
      "Jack"
   "Describe Maint Done", text, 230, normal, "Describe cleaning and maintenance done", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal
   "Highway", text, 5, normal, "highway number HYDFAC_LOC_RTNUM_NM", normal
   "Ref Pt", numeric, 3, 0.000, 999.999, 0.000, normal, "Ref Pt", not_permitted
   "Offset R/L", menu, normal, "Distance left/right of centerline.", normal
      "R"
      "L"
   "Roadway Type", menu, normal, "Pipe is under this road type.", normal
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Last Inspection", date, auto, dmy, manual, not_permitted, "Last date HYDFAC_LAST_INSPECTION_DT", not_permitted
   "Year to Inspect", numeric, 0, 0, 2050, 0, normal, "Calc'd year when needs to be inspected", normal
   "Maint Responsibility", text, 30, normal, "DRSCMP_MAINT_RESPONSIBILITY_NM", normal, Maint Responsibility

"T_PipeandInsp", point, "Pipe new inventory and inspection", 1, seconds, 5, Code
   "Local ID", text, 20, normal, "Plan or Temporary Name or Number", normal, Label1
   "Activity", menu, required, "If lined pipe then say Liner.", required
      "Discover", default
      "Liner"
      "Extension"
      "Video"
   "Roadway Type", menu, required, "Pipe is under this road type.", required, Label2
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
      "Bridge"
   "Station ", text, 15, normal, "Station from project plan sheet.", normal
   "Station Units", menu, normal, "Stationing is English or Metric Units?", normal
      "Feet", default
      "Meters"
   "Station Offset R/L", menu, normal, "Distance left/right of centerline.", normal
      "R"
      "L"
   "Material", menu, required, "Material pipe is made of.", required
      "Concrete"
      "Corg. Steel (CSP)"
      "Structural Plate"
      "Corg. Plastic (HDPE)"
      "PVC"
      "Liner PVC"
      "Liner HDPE"
      "Liner Cured in Place"
      "Liner Metal"
      "Liner Other"
      "Aluminized Steel"
      "Corg. Aluminum (CAP)"
      "Bituminous-Coated"
      "Polymeric-Coated"
      "Perforated Plastic"
      "Timber"
      "Other"
   "Width Qt.", numeric, 0, 1, 30480, 24, required, "Measure Horizontal Inside Pipe", required
   "Height Qt.", numeric, 0, 1, 30480, 24, required, "Measure Vertical Inside Pipe", required
   "Dim. Units", menu, required, "Pipe Height, Width Dimension Units", required
      "Inches", default
   "Pipe Shape", menu, required, "Culvert or Strm Drn Pipe x-section shape", required
      "Round", default
      "Strm Round"
      "Arch"
      "Strm Arch"
      "Box"
      "Slot Drain"
      "Elliptical"
      "Other"
   "Length", numeric, 0, 0, 1000, 0, required, "Pipe length", required
   "Lgth Units", menu, required, "Pipe Length Units", required
      "Feet", default
   "Lngth Deter. Method", menu, required, "How was Length determined?", required
      "Measured"
      "Estimated", default
      "Scaled"
      "Plan"
   "Class", menu, normal, "Pipe Class, if known", normal
      "8 Gage"
      "10 Gage"
      "12 Gage"
      "14 Gage"
      "16 Gage"
      "18 Gage"
      "Class II"
      "Class III"
      "Class IV"
      "Class V"
      "Special Design"
      "Unknown", default
   "Joints Tied", menu, required, "Connection-Joints tied or adequate bands", required
      "Y"
      "N"
   "Cover", menu, required, "Estimate fill over top of pipe.", required
      "0 - 2 Feet"
      "2 - 6 Feet", default
      "6 - 10 Feet"
      "10 - 20 Feet"
      "Over 20 Feet"
   "Visible Length", menu, required, "Can you see entire length of pipe?", required
      "Complete Visual"
      "Partial Visual", default
   "Visible Circum", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Overall Condition", menu, required, "1 = like new, 4 = terrible, 0=unknown", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Needs Cleaning?", menu, normal, "Pipe's end is 1/3 full of sediment.", normal
      "Y"
      "N"
   "Needs Repair/Replac?", menu, normal, "Pipe needs fix or replace-- rate 3 or 4.", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Pipe has some still water inside it.", normal
      "Y"
      "N"
   "Silt present?", menu, normal, "Part of pipe invert is obscured by sed.", normal
      "Y"
      "N"
   "Plugged?", menu, normal, "Pipe end is mostly obstructed.", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "Surface of pipe has pits or rust.", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls. CMP has loose flakes.", normal
      "Y"
      "N"
   "Cracks?", menu, normal, "Visible cracks in pipe.", normal
      "Y"
      "N"
   "Holes?", menu, normal, "Hole goes through the pipe", normal
      "Y"
      "N"
   "Joints Separated?", menu, normal, "Joint is separated more than 1"", normal
      "Y"
      "N"
   "Misalignment?", menu, normal, "Pipe section offset laterally, has gap", normal
      "Y"
      "N"
   "Deformed Pipe?", menu, normal, "Pipe Distress - Pipe shape is distorted", normal
      "Y"
      "N"
   "Infiltration?", menu, normal, "Soil or water infiltration into pipe", normal
      "Y"
      "N"
   "Piping?", menu, normal, "Water runs along pipe exterior", normal
      "Y"
      "N"
   "Inslope Cavity?", menu, normal, "Holes in inslope around pipe", normal
      "Y"
      "N"
   "Road Distress?", menu, normal, "Road bump, dip, pvmt patch or cracks", normal
      "Y"
      "N"
   "Void in Road?", menu, normal, "Hole in road near pipe", normal
      "Y"
      "N"
   "Repair under Road?", menu, normal, "Is repair required inside shoulder PI?", normal
      "Y"
      "N"
   "Erosion?", menu, normal, "Soil erosion near pipe, usually outlet.", normal
      "Y"
      "N"
   "Marker Type?", menu, normal, "What kind of marker at pipe end?", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Comment", text, 100, normal, "Comment if extraordinary case.", normal
   "Sediment % Full", numeric, 0, 0, 100, 0, normal, "% of Pipe height filled by sediment", normal
   "# Joints Need Repair", numeric, 0, 0, 100, 0, normal, "DB field: HYPINS_IPCD_PER1_PC", normal
   "Max Joint Sep inches", numeric, 0, 0, 100, 0, normal, "DB field: HYPINS_IPCD_PER2_PC", normal
   "Recommend a Repair", menu, normal, "DB field: HYPSA_ASSIGNED_TO_TX", normal
      "Reset"
      "Slipline"
      "Cured inplace liner"
      "Joint Repair"
      "Paved Invert"
      "Trench"
      "Jack"
   "Describe Maint Done", text, 230, normal, "Describe cleaning and maintenance done", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal

"2_LineEndPoints", line, "Capture 2 end points for pipe location", 1, seconds, 1, Code
   "HydInfra ID", text, 10, normal, "use if ExPipeandInsp ", normal, Label1
   "Local Name ", text, 30, normal, "Identifer for New Pipe T_PipeandInsp", normal, Label2
   "Upstream ID", text, 30, normal, "Use for storm drain network", normal
   "Downstream ID", text, 30, normal, "Use for storm drain network", normal
   "Date", date, auto, dmy, manual, normal, "Date", normal
   "Time", time, auto, 24, manual, normal, "This field ends PF_UpdateXY record", normal

"ExSpStrucandInsp", point, "Exist SpecStruc with inspection", 1, seconds, 5, Code
   "HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Use only HYDINRA ID from database", normal, Label1
   "Local ID", text, 30, normal, "Temporary field identifier ", normal, Label2
   "Activity", menu, required, "Describes Activity", required
      "Liner"
      "Extension"
      "Verify"
      "Change"
      "Duplicate"
      "Abandon"
      "Clean"
      "Repair"
      "Clean/Repair"
      "Install"
      "Remove"
      "Other"
      "Video"
   "Sp Struc Type", menu, required, "Type of Special Structure", required
      "Flared Apron"
      "Mitered Safety Apron"
      "Box End Section"
      "Headwall"
      "Headwall Wingwall"
      "Slotted Drain"
      "Flume"
      "Expander"
      "Reducer"
      "Weir"
      "Floodgate"
      "Riprap"
      "Energy Dissipater"
      "Other"
      "Overflow"
   "Material", menu, required, "Primary material of Spec Structure", required
      "Metal"
      "Concrete", default
      "Plastic"
      "Other"
   "Grate Type", menu, required, "Safety holds cars, Trash  holds trash", required
      "None", default
      "Trash"
      "Safety"
      "Other"
   "Riprap/Other Class", menu, normal, "Riprap class or other type", normal
      "0", default
      "1"
      "2"
      "3"
      "4"
      "5"
      "Cable Concrete"
      "Articulated Block"
      "Gabions"
      "Other"
      "Riprap"
      "None"
   "Visible Inspect.", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Overall Condition", menu, required, "Condition Code", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Needs Cleaning?", menu, normal, "Cleanout needed?", normal
      "Y"
      "N"
   "Needs Repair?", menu, normal, "Repair needed?", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Standing or backed up water in sp struc", normal
      "Y"
      "N"
   "Deter. Ties?", menu, normal, "Pipe ties or connectors are inadequate.", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "Special Structure is pitted or rusted", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls/CMP loose flakes", normal
      "Y"
      "N"
   "Joints Separated?", menu, normal, "Joints Separated 1" or more", normal
      "Y"
      "N"
   "Deformation?", menu, normal, "Special Structure is misshapen", normal
      "Y"
      "N"
   "Sediment % Full", numeric, 0, 0, 100, 0, normal, "% of apron depth filled by sediment", normal
   "Marker Type", menu, normal, "What type marker if any?", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Comment", text, 100, normal, "Comment on extraordinary circumstance.", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal
   "Highway", text, 5, normal, "highway number HYDFAC_LOC_RTNUM_NM", normal
   "Ref Pt", numeric, 3, 0.000, 999.999, 0.000, normal, "Ref Pt", normal
   "Roadway Type", menu, required, "Pipe is under this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Station Offset R/L", menu, normal, "Spec Struct-left or right of centerline?", normal
      "R"
      "L"
   "Last Inspection", date, auto, dmy, manual, not_permitted, "Last date HYDFAC_LAST_INSPECTION_DT", not_permitted
   "Maint Responsibility", text, 30, normal, "DRSCMP_MAINT_RESPONSIBILITY_NM", normal, Maint Responsibility

"T_SpStrucandInsp", point, "Spec Structure Inventory and Inspection", 1, seconds, 5, Code
   "Local ID", text, 20, normal, "Plan or Temporary ID ", normal, Label1
   "Activity", menu, required, "Discover means initial Inventory.", required
      "Discover", default
      "Video"
   "Roadway Type", menu, required, "Pipe is at this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Station", text, 15, normal, "Station from Project Plan Sheet", normal
   "St Units", menu, normal, "Station Units are English or Metric?", normal
      "Feet", default
      "Meters"
   "Station Offset R/L", menu, normal, "Spec Struct-left or right of centerline?", normal, Label2
      "R"
      "L"
   "Sp Struc Type", menu, required, "Special Structure Type", required
      "Flared Apron", default
      "Mitered Safety Apron"
      "Box End Section"
      "Headwall"
      "Headwall Wingwall"
      "Slotted Drain"
      "Flume"
      "Expander"
      "Reducer"
      "Weir"
      "Floodgate"
      "Riprap"
      "Energy Dissipater"
      "Other"
      "Overflow"
      "Bend"
   "Material", menu, required, "Special Struc is made of this material.", required
      "Metal"
      "Concrete", default
      "Plastic"
      "Other"
   "Grate Type", menu, required, "Safety holds cars, Trash  holds trash", required
      "None", default
      "Trash"
      "Safety"
      "Other"
   "Riprap/Other Class", menu, normal, "Riprap Class, or Articulated Block or?", normal
      "0", default
      "1"
      "2"
      "3"
      "4"
      "5"
      "Cable Concrete"
      "Articulated Block"
      "Gabions"
      "Other"
      "Riprap"
      "None"
   "Visible Inspect.", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Overall Condition", menu, required, "Condition Code", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Needs Cleaning?", menu, normal, "Is special structure more than 1/3 full?", normal
      "Y"
      "N"
   "Needs Repair?", menu, normal, "Is repair required?", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Is water standing in special structure?", normal
      "Y"
      "N"
   "Deter. Ties?", menu, normal, "Are pipe ties or connectors failing?", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "Pits or Rust on special structure", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls/CMP loose flakes", normal
      "Y"
      "N"
   "Joints Separated?", menu, normal, "Joint separated at special structure", normal
      "Y"
      "N"
   "Deformation?", menu, normal, "Special Structure is misshapen.", normal
      "Y"
      "N"
   "Sediment % Full", numeric, 0, 0, 100, 0, normal, "% of apron depth filled by sediment", normal
   "Marker Type", menu, normal, "What type of marker at Special Structure", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Comment", text, 100, normal, "Comment on extraordinary circumstance.", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal

"ExStrucandInsp", point, "Existing HYDINFRA Structure and Inspect", 1, seconds, 5, Code
   "HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Only use HYDINRA ID", normal, Label1
   "Local ID", text, 30, normal, "Temporary field identifier", normal, Label2
   "Activity", menu, required, "Describes Activity", required
      "Liner"
      "Extension"
      "Verify"
      "Change"
      "Duplicate"
      "Abandon"
      "Clean"
      "Repair"
      "Clean/Repair"
      "Install"
      "Remove"
      "Other"
      "Video"
   "Sump", menu, normal, "Structure has depression X ft deep", normal
      "Y"
      "N", default
   "Material", menu, required, "Material Structure is primarily made of", required
      "Brick/Masonry"
      "Concrete"
      "Metal"
      "Plastic"
      "Other"
      "None"
      "Liner PVC"
   "Inlet Type", menu, required, "CB in pvmt, DI in grass, MH has cover", required
      "Catch Basin", default
      "Manhole"
      "Drop Inlet"
      "Deck Drain"
      "Buried"
   "Ring Material ", menu, normal, "Material of rings below casting", normal
      "Concrete", default
      "Plastic"
      "Metal"
      "None"
      "Other"
   "Connected Pipes", numeric, 0, 1, 99, 2, normal, "How many pipe ends show in structure?", normal
   "Structure Height", numeric, 2, 0.00, 99.00, 0.00, required, "Measure from bottom to top of casting", required
   "Height Units", menu, required, "Measurement Units", required
      "Feet", default
   "Visible Inspect.", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Overall Condition", menu, required, "Condition Code", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Needs Cleaning?", menu, normal, "Needs cleaning", normal
      "Y"
      "N"
   "Needs Repair?", menu, normal, "Needs repair", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Is water standing or backed up in struct", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "Pitted or Rusted?", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls/CMP loose flakes", normal
      "Y"
      "N"
   "Cracks?", menu, normal, "Structure has cracks", normal
      "Y"
      "N"
   "Holes?", menu, normal, "Holes through structure", normal
      "Y"
      "N"
   "Ring Deterioration?", menu, normal, "Rings are broken or have gaps", normal
      "Y"
      "N"
   "Infiltration?", menu, normal, "Soil or water infiltrate into structure", normal
      "Y"
      "N"
   "Void Near Struc?", menu, normal, "Evidence of void near structure", normal
      "Y"
      "N"
   "Road Deformation?", menu, normal, "Road bump, dip, pvmt patch or cracks", normal
      "Y"
      "N"
   "Replace Grate?", menu, normal, "Y if Grate is broken or damaged", normal
      "Y"
      "N"
   "Replace Frame?", menu, normal, "Y if frame is broken or damaged", normal
      "Y"
      "N"
   "Repair Invert?", menu, normal, "Structure bottom needs repair", normal
      "Y"
      "N"
   "Repair Depth", numeric, 1, 0.0, 99.0, 0.0, normal, "Meas from bottom of cast to bot repair", normal
   "Repair Depth Units", menu, normal, "Measurement units", normal
      "Feet", default
   "Marker Type", menu, normal, "What marks pipe end?", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Comment", text, 100, normal, "Comment on extraordinary circumstances", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal
   "Highway", text, 5, normal, "highway number HYDFAC_LOC_RTNUM_NM", normal
   "Ref Pt", numeric, 3, 0.000, 999.999, 0.000, normal, "Ref Pt", normal
   "Roadway Type", menu, required, "Pipe is under this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Last Inspection", date, auto, dmy, manual, not_permitted, "Last date HYDFAC_LAST_INSPECTION_DT", not_permitted
   "Maint Responsibility", text, 30, normal, "DRSCMP_MAINT_RESPONSIBILITY_NM", normal, Maint Responsibility

"T_StrucandInsp", point, "Structure Inventory and Inspection", 1, seconds, 5, Code
   "Local ID", text, 20, normal, "Plan or Temporary ID ", normal, Label1
   "Activity", menu, required, "Discover means initial Inventory.", required
      "Discover", default
      "Video"
   "Roadway Type", menu, required, "Pipe is on this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Station ", text, 15, normal, "Station from Plan Sheet", normal
   "St  Units", menu, normal, "Station Units are English or Metric? ", normal
      "Feet", default
      "Meters"
   "Station Offset R/L", menu, normal, "Structure is left or right of centerline", normal, Label2
      "R"
      "L"
   "Sump", menu, normal, "X ft. deep depression in struc bottom.", normal
      "Y"
      "N", default
   "Material", menu, required, "Material Structure is primarily made of", required
      "Brick/Masonry"
      "Concrete"
      "Metal"
      "Plastic"
      "Other"
      "None"
      "Liner PVC"
   "Inlet Type", menu, required, "CB in pvmt, DI in grass, MH has cover", required
      "Catch Basin", default
      "Manhole"
      "Drop Inlet"
      "Deck Drain"
      "Buried"
   "Ring Material ", menu, normal, "Rings below casting are made of?", normal
      "Concrete", default
      "Plastic"
      "Metal"
      "None"
      "Other"
   "Connected Pipes", numeric, 0, 1, 99, 2, required, "How many pipe ends show in structure?", required
   "Structure Height", numeric, 2, 0.00, 99.00, 0.00, required, "Height from invert to top of grate.", required
   "Height Units", menu, normal, "Height measurement units.", normal
      "Feet", default
   "Visible Inspect.", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Overall Condition", menu, required, "Condition Code", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Needs Cleaning?", menu, normal, "Does Structure need cleaning?", normal
      "Y"
      "N"
   "Needs Repair?", menu, normal, "Does Structure need repair?", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Is water backed up or standing?", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "Pits or Rust in Structure material", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls/CMP loose flakes", normal
      "Y"
      "N"
   "Cracks?", menu, normal, "Cracks in Structure Material", normal
      "Y"
      "N"
   "Holes?", menu, normal, "Holes through Structure Material.", normal
      "Y"
      "N"
   "Replace Rings?", menu, normal, "Broken Rings, gaps or deterioration?", normal
      "Y"
      "N"
   "Infiltration?", menu, normal, "Seepage or Soil infiltration into Struct", normal
      "Y"
      "N"
   "Void Near Struc?", menu, normal, "Evidence of soil loss near structure", normal
      "Y"
      "N"
   "Road Deformation?", menu, normal, "Road bump, dip, pvmt patch or cracks", normal
      "Y"
      "N"
   "Replace Grate?", menu, normal, "Grate is broken or needs replacement", normal
      "Y"
      "N"
   "Replace Frame?", menu, normal, "Frame is broken or needs replacement", normal
      "Y"
      "N"
   "Repair Invert?", menu, normal, "Structure invert needs repair?", normal
      "Y"
      "N"
   "Repair Depth", numeric, 1, 0.0, 99.0, 0.0, normal, "Measure down from bottom of casting.", normal
   "Repair Depth Units", menu, normal, "Measurement units.", normal
      "Feet", default
      "Meters"
   "Marker Type", menu, normal, "What kind of marker at structure?", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Comment", text, 100, normal, "Comment on extraordinary circumstance.", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal

"T_DitchandInsp", point, "Ditch Inventory and Inspection", 1, seconds, 5, Code
   "Local ID", text, 20, normal, "Plan or Temporary ID ", normal, Label1
   "Activity", menu, required, "Discover is the Activity for New Feature", required
      "Discover", default
   "Roadway Type", menu, required, "Ditch is by this road type.", required
      "Centerline"
      "Median"
      "Mainline", default
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Station ", text, 15, normal, "Station from Plan Sheet", normal
   "St Units", menu, normal, "Is Stationing in English or Metric?", normal
      "Feet", default
      "Meters"
   "Station Offset R/L", menu, normal, "Ditch is left or right of centerline?", normal, Label2
      "R"
      "L"
   "Total Ditch Length", numeric, 0, 0, 999999, 0, normal, "Ditch Length", normal
   "Length Unit ", menu, normal, "Measurement Units", normal
      "Feet", default
   "Riprap?", menu, normal, "Is there Riprap?", normal
      "Y"
      "N"
   "Geosynthetic Lining?", menu, normal, "Is there geosynthetic ditch lining?", normal
      "Y"
      "N"
   "Clay Lining?", menu, normal, "Has specially constructed clay liner?", normal
      "Y"
      "N"
   "Cable concrete?", menu, normal, "Is there Cable Concrete?", normal
      "Y"
      "N"
   "Special Vegetation?", menu, normal, "Is ther designed non-eroding vegetation?", normal
      "Y"
      "N"
   "Other Lining?", menu, normal, "Is there other specially placed lining?", normal
      "Y"
      "N"
   "Unknown Lining? ", menu, normal, "Don't know? -- say yes here.", normal
      "Y"
      "N"
   "Riprap/Other Class", menu, normal, "Riprap class or other type.", normal
      "0", default
      "1"
      "2"
      "3"
      "4"
      "5"
      "Cable Concrete"
      "Articulated Block"
      "Gabions"
      "Other"
      "None"
      "Riprap"
   "Infiltration Const?", menu, normal, "Infiltration ditch designed & constructd", normal
      "Y"
      "N", default
   "R_Dist. Centerline", numeric, 0, 0, 999, 0, normal, "Centerline to end of pipe for clearzone", normal
   "L_Dist. Centerline", numeric, 0, 0, 999, 0, normal, "Centerline to end of pipe for clearzone", normal
   "R_Backslope", menu, normal, "Rise/Run at right backslope", normal
      "1/1"
      "1/2"
      "1/3"
      "1/4"
      "1/5"
      "1/6"
      "1/7"
      "1/8"
      "1/9"
      "Flat"
      "Vertical"
   "L_Backslope", menu, normal, "Rise/Run at left backslope", normal
      "1/1"
      "1/2"
      "1/3"
      "1/4"
      "1/5"
      "1/6"
      "1/7"
      "1/8"
      "1/9"
      "Flat"
      "Flatter than 1/4"
      "Vertical"
   "R_Ditch Width", menu, normal, "Bottom width-ditch right of centerline", normal
      "2 - 6 Feet"
      "6 - 10 Feet"
      "10 - 14 Feet"
      "14 - 18 Feet"
      "18 - 22 Feet"
      "22 - 26 Feet"
      "26 - 30 Feet"
      "Over 30 Feet"
   "L_Ditch Width", menu, normal, "Bottom width-ditch left of centerline", normal
      "2 - 6 Feet"
      "6 - 10 Feet"
      "10 - 14 Feet"
      "14 - 18 Feet"
      "18 - 22 Feet"
      "22 - 26 Feet"
      "26 - 30 Feet"
      "Over 30 Feet"
   "R_R/W Width", numeric, 0, 0, 999, 0, normal, "Right of way width right of centerline", normal
   "L_R/W Width", numeric, 0, 0, 999, 0, normal, "Right of Way width left of centerline", normal
   "Room to Extend?", menu, normal, "Can pipe be extended within the limits?", normal
      "Y"
      "N"
   "Overall Condition", menu, required, "Condition Code", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Needs Cleaning?", menu, normal, "Ditch has filled so water flows outside ", normal
      "Y"
      "N"
   "Needs Repair?", menu, normal, "Ditch requires repair for erosion or?", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Ditch has standing water", normal
      "Y"
      "N"
   "Erosion?", menu, normal, "Ditch has erosion", normal
      "Y"
      "N"
   "Seepage?", menu, normal, "Groundwater seepage into ditch.", normal
      "Y"
      "N"
   "Marker Type?", menu, normal, "Any marker that identifies the ditch?", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Comment", text, 100, normal, "Comment for extraordinary circumstance.", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal

"ExPondInsp", point, "Existing Pond Inspection Only", 1, seconds, 5, Code
   "HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Only use HYDINRA ID from database", normal, Label1
   "Local ID", text, 30, normal, "Temporary field identifier", normal, Label2
   "Overall Condition", menu, normal, "Condition Code", normal
      "1"
      "2"
      "3"
      "4"
      "0"
   "Clean Sediment?", menu, normal, "Needs sediment removed", normal
      "Y"
      "N"
   "Clean Debris?", menu, normal, "Debris removal is needed", normal
      "Y"
      "N"
   "Repair Embankment?", menu, normal, "Embankment is compromised - fix it.", normal
      "Y"
      "N"
   "Repair Struct?", menu, normal, "Structure needs repair", normal
      "Y"
      "N"
   "Repair Erosion?", menu, normal, "Erosion needs repair", normal
      "Y"
      "N"
   "Restore Infilt?", menu, normal, "Restore infiltration capacity", normal
      "Y"
      "N"
   "Remove Weeds?", menu, normal, "Y if If noxious weeds or other hazard", normal
      "Y"
      "N"
   "Repair Lining?", menu, normal, "Pond lining material needs repair", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Water is standing in pond", normal
      "Y"
      "N"
   "Outfall functions?", menu, normal, "Outfall clear and functioning", normal
      "Y"
      "N"
   "Inflow functions?", menu, normal, "Inflow clear and functioning", normal
      "Y"
      "N"
   "WQ Pool Ctrls Func?", menu, normal, "Water Quality Pool Controls Functioning?", normal
      "Y"
      "N"
   "Emerg Overflow Func?", menu, normal, "Emerg overflow clear & functioning?", normal
      "Y"
      "N"
   "Marker Type?", menu, normal, "What if any marks pond", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Sediment % Full", numeric, 0, 0, 100, 0, normal, "% of pond filled by sediment", normal
   "Comment", text, 100, normal, "Comment on extraordinary circumstances", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal
   "Highway", text, 5, normal, "highway number HYDFAC_LOC_RTNUM_NM", normal
   "Ref Pt", numeric, 3, 0.000, 999.999, 0.000, normal, "Ref Pt", normal
   "Roadway Type", menu, required, "Pipe is under this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Last Inspection", date, auto, dmy, manual, not_permitted, "Last date HYDFAC_LAST_INSPECTION_DT", not_permitted
   "Year to Inspect", numeric, 0, 1990, 2050, 1990, normal, "Calc'd year when needs to be inspected", normal
   "Maint Responsibility", text, 30, normal, "DRSCMP_MAINT_RESPONSIBILITY_NM", normal, Maint Responsibility

"T_PondandInsp", point, "Pond Inventory and Inspection", 1, seconds, 5, Code
   "Activity", menu, required, "Discover is activity for new feature", required
      "Discover", default
   "Roadway Type", menu, required, "Pond is by this road type.", required, Label1
      "Centerline"
      "Median"
      "Mainline", default
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Station", text, 15, normal, "Station from Plan at center of pond", normal
   "St Units", menu, normal, "Station Units in English or Metric", normal
      "Feet", default
      "Meters"
   "Station Offset R/L", menu, normal, "Pond is right or left of centerline", normal
      "R"
      "L"
   "Pond Name", text, 20, normal, "Pond Name from Plan Sheet", normal
   "Lake Number", text, 20, normal, "DNR Lake Number", normal
   "Number of Cells", numeric, 0, 1, 10, 1, normal, "Number of separate (at surface) basins ", normal
   "Outlet Design", menu, normal, "Outlet type defines the water regime", normal
      "Unknown", default
      "Wet"
      "Dry"
      "Filter Infiltrate"
      "Infiltration"
   "Drainage easement", menu, normal, "Is there a recorded esmt for ponding?", normal
      "Y"
      "N", default
   "Wetland Credit", menu, normal, "Pond constructed as wetland by permit", normal
      "Y"
      "N", default
   "Sediment Treatment", menu, normal, "Pond treats for sediment.", normal
      "Y"
      "N"
   "Biological Treatment", menu, normal, "Pond has biological treatment capability", normal
      "Y"
      "N"
   "Chemical Treatment", menu, normal, "Pond uses chemical treatment.", normal
      "Y"
      "N"
   "Physical Diversion", menu, normal, "Flow diverted to reduce pollutant load", normal
      "Y"
      "N"
   "Volume Reduction ", menu, normal, "Outflow volume is reduced by pond.", normal
      "Y"
      "N"
   "Peak Flow Reduction", menu, normal, "Peak flow is reduced by pond.", normal
      "Y"
      "N"
   "Energy Dissipation", menu, normal, "Pond functions to dissipate energy.", normal
      "Y"
      "N"
   "Other", menu, normal, "Pond uses any other treatment method.", normal
      "Y"
      "N"
   "Pond Lining Type", menu, normal, "What covers pond bottom?", normal
      "Unknown", default
      "Clay"
      "Cable concrete"
      "Riprap"
      "Synthetic"
      "Sand"
      "Gravel"
      "Vegetation"
      "Native Vegetation"
      "None"
      "Other"
   "Normal Water Elev", numeric, 2, 0.00, 3000.00, 0.00, normal, "Plan Sheet - NWL", normal
   "Overflow Elevation", numeric, 2, 0.00, 3000.00, 0.00, normal, "Lowest berm outflow elevation", normal
   "Design Bottom Elev", numeric, 2, 0.00, 3000.00, 0.00, normal, "Plan sheet - Pond Bottom", normal
   "Design Highwater El", numeric, 2, 0.00, 3000.00, 0.00, normal, "Plan Sheet - HWL", normal
   "Design Elev Units", menu, normal, "Metric or English Units", normal
      "Feet", default
      "Meters"
   "Design Frequency", numeric, 0, 0, 999, 0, normal, "Pond design for rainfall event 1-100", normal
   "Design Datum", menu, normal, "Elev based on this datum", normal
      "NGVD 29"
      "NAVD 88"
      "Local"
      "Unknown", default
   "Design NWL Area", numeric, 0, 0, 99, 0, normal, "Surface Area at Normal Water Level", normal
   "Area Units", menu, normal, "Acres or Hectares", normal
      "Ac", default
   "Area Method", menu, normal, "How was area obtained?", normal
      "Plan Sheet", default
      "Survey"
      "Unknown"
      "High End RDGPS"
   "Obs Highwater Elev", numeric, 2, 0.00, 3000.00, 0.00, normal, "Highest Water level seen by someone", normal
   "HWL Units", menu, normal, "High Water Level Units of Measure", normal
      "Feet", default
      "Meters"
   "Datum", menu, normal, "HWL based on this datum", normal
      "NGVD 29"
      "NAVD 88"
      "Local"
      "Unknown", default
   "HWL Method", menu, normal, "How was HWL obtained?", normal
      "Survey"
      "Estimated", default
   "Estim Maint Freq Mos", numeric, 0, 0, 240, 60, normal, "Time between cleanings, start with 60", normal
   "Overall Condition", menu, normal, "Condition Code - does pond need repair?", normal
      "1"
      "2"
      "3"
      "4"
      "0"
   "Clean Sediment?", menu, normal, "Pond is half full of sediment or more.", normal
      "Y"
      "N"
   "Clean Debris?", menu, normal, "Yes if Debris threatens to clog outlet ", normal
      "Y"
      "N"
   "Repair Embankment?", menu, normal, "Repair the "dam" that holds back water", normal
      "Y"
      "N"
   "Repair Struct?", menu, normal, "Flag if structure needs repair", normal
      "Y"
      "N"
   "Repair Erosion?", menu, normal, "Repair general eroded areas", normal
      "Y"
      "N"
   "Restore Infilt?", menu, normal, "Y if Infiltration Pond doesn't infiltrat", normal
      "Y"
      "N"
   "Remove Weeds?", menu, normal, "Y if noxious weeds or create a hazard", normal
      "Y"
      "N"
   "Repair Lining?", menu, normal, "Y if lining damage creates a problem", normal
      "Y"
      "N"
   "Standing Water?", menu, normal, "Is there normally water in pond? ", normal
      "Y"
      "N"
   "Outfall Functions?", menu, normal, "Outfall is clear and functioning", normal
      "Y"
      "N"
   "Inflow functions?", menu, normal, "Inflows are clear and functioning", normal
      "Y"
      "N"
   "WQ Ctrls Func?", menu, normal, "Water Quality Controls are functioning", normal
      "Y"
      "N"
   "Emerg overflow func?", menu, normal, "Emergency overflow is functioning", normal
      "Y"
      "N"
   "Marker Type", menu, normal, "Marker that designates the pond only", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Sediment % Full", numeric, 0, 0, 100, 0, normal, "Wet volume of pond is X % full of sedim.", normal
   "Comment", text, 50, normal, "Comment for extraordinary circumstance.", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal

"ExSPCDInsp", point, "Existing SPCD Inspection Only", 1, seconds, 5, Code
   "HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Only use HYDINRA ID from database", normal, Label1
   "Local ID", text, 30, normal, "Temporary field identifier", normal
   "Overall Condition", menu, required, "Condition Code", required, Label2
      "1"
      "2"
      "3"
      "4"
      "0"
   "Visible Inspect.", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Clean Sediment?", menu, normal, "Sediment needs removal", normal
      "Y"
      "N"
   "Clean Debris?", menu, normal, "Debris needs removal", normal
      "Y"
      "N"
   "Remove Weeds?", menu, normal, "Y if Noxious Weeds or other hazard", normal
      "Y"
      "N"
   "Repair Structure?", menu, normal, "Structure needs repair", normal
      "Y"
      "N"
   "Replace Grate?", menu, normal, "Y if Grate is broken or damaged", normal
      "Y"
      "N"
   "Replace Frame?", menu, normal, "Y if frame is broken or damaged", normal
      "Y"
      "N"
   "Replace Rings?", menu, normal, "Y if rings are broken or have gaps", normal
      "Y"
      "N"
   "Outfall Functions?", menu, normal, "Outfall is clear and functioning", normal
      "Y"
      "N"
   "Inflow Functions?", menu, normal, "Inflow is clear and functioning", normal
      "Y"
      "N"
   "Infiltration?", menu, normal, "Soil or water infiltration into SPCD ", normal
      "Y"
      "N"
   "WQ Ctrls Function?", menu, normal, "Water Quality Controls functioning?", normal
      "Y"
      "N"
   "Holes?", menu, normal, "Holes through SPCD", normal
      "Y"
      "N"
   "Cracks?", menu, normal, "Cracks in SPCD", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls/CMP loose flakes", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "Pitted or rusted", normal
      "Y"
      "N"
   "Void Near Struc?", menu, normal, "Evidence of void near structure", normal
      "Y"
      "N"
   "Road Distress?", menu, normal, "Road bump, dip, pvmt patch or cracks", normal
      "Y"
      "N"
   "Marker Type?", menu, normal, "What marks SPCD if any", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Sediment % Full", numeric, 0, 0, 100, 0, normal, "% of SPCD filled by sediment", normal
   "Comment", text, 100, normal, "Comment on extraordinary circumstances", normal
   "Date", date, auto, dmy, auto, normal, "Date", normal
   "Time", time, auto, 24, auto, normal, "Time", normal
   "Highway", text, 5, normal, "highway number HYDFAC_LOC_RTNUM_NM", normal
   "Ref Pt", numeric, 3, 0.000, 999.999, 0.000, normal, "Ref Pt", normal
   "Roadway Type", menu, required, "Pipe is under this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Last Inspection", date, auto, dmy, manual, not_permitted, "Last date HYDFAC_LAST_INSPECTION_DT", not_permitted
   "Year to inspect", numeric, 0, 1990, 2050, 2050, not_permitted, "Calc'd year when needs to be inspected", not_permitted
   "Maint Responsibility", text, 30, normal, "DRSCMP_MAINT_RESPONSIBILITY_NM", normal, Maint Responsibility

"T_SPCDandInsp", point, "Structural Pollution Control Device ", 1, seconds, 5, Code
   "Local ID", text, 20, normal, "Plan or Temporary ID ", normal, Label1
   "Activity", menu, normal, "Discover is Activity for new features", normal
      "Discover", default
      "Video"
   "Roadway Type", menu, required, "SPCD is under this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Station ", text, 15, normal, "Station from Plan Sheet", normal
   "St  Units", menu, normal, "Station in English or Metric Units", normal
      "Feet", default
      "Meters"
   "Station Offset R/L", menu, normal, "SPCD is left or right of centerline", normal
      "R"
      "L"
   "Type", menu, normal, "SPCD functional category", normal, Label2
      "Skimmer"
      "Filter"
      "Separator"
      "Grit Chamber"
      "Infiltration Device"
      "Sump MH"
      "Other"
   "Maker", menu, normal, "Company Name of SPCD Manufacturer", normal
      "Vortech"
      "CDS"
      "Stormceptor"
      "Baysaver"
      "Downstream Defender"
      "Other"
      "NA"
   "Material", menu, normal, "Primary Material SPCD is made of", normal
      "Brick/Masonry"
      "Concrete", default
      "Metal"
      "Plastic"
      "Timber"
      "Other"
      "None"
   "Treats Sediment?", menu, normal, "Does it remove sediment from stormwater?", normal
      "Y"
      "N"
   "Treats Debris?", menu, normal, "Does it remove debris or trash?", normal
      "Y"
      "N"
   "Treats Petroleum?", menu, normal, "Does it remove oil or gas?", normal
      "Y"
      "N"
   "Sediment capacity", numeric, 0, 0, 99999999, 0, normal, "How much sediment can it hold?", normal
   "Capacity Units", menu, normal, "cubic yards, cubic feet or cubic meters", normal
      "CY", default
      "CF"
      "CM"
   "Design Flow", numeric, 2, 0.00, 999.00, 0.00, normal, "Rate of flow that SPCD was designed for", normal
   "Design Flow Units", menu, normal, "Cubic Feet/second or Cu Meters/sec", normal
      "CFS", default
      "CMS"
   "Design Frequency", numeric, 0, 0, 999, 0, normal, "X yr-24 hr storm)", normal
   "Expect Main Freq-Mo ", numeric, 0, 0, 240, 12, normal, "Expected Maint Frequency (months)", normal
   "Special Equipment", menu, normal, "Equip required for cleanout", normal
      "None", default
      "Vac Truck"
   "Overall Condition", menu, required, "Condition Code", required
      "1"
      "2"
      "3"
      "4"
      "0"
   "Visible Inspect.", menu, required, "How do you see circumference of pipe?", required
      "Complete Visual"
      "Partial Visual", default
      "DigiSewer Scan"
      "Pan Tilt Video"
      "Laser Profiler"
   "Clean Sediment?", menu, normal, "Needs sediment removed.", normal
      "Y"
      "N"
   "Clean Debris?", menu, normal, "Needs debris removed.", normal
      "Y"
      "N"
   "Remove Weeds?", menu, normal, "Noxious or clogging hazard weeds.", normal
      "Y"
      "N"
   "Repair Structure?", menu, normal, "Structure needs repair.", normal
      "Y"
      "N"
   "Replace Grate", menu, normal, "Grate is broken or damaged.", normal
      "Y"
      "N"
   "Replace Frame?", menu, normal, "Frame is broken or damaged.", normal
      "Y"
      "N"
   "Replace Rings?", menu, normal, "Rings are broken or have gaps.", normal
      "Y"
      "N"
   "Outfall Functions?", menu, normal, "Outfall is clear and functioning.", normal
      "Y"
      "N"
   "Inflow Functions?", menu, normal, "Inflow is clear and functioning.", normal
      "Y"
      "N"
   "Infiltration?", menu, normal, "Soil or water leaking in thru cracks etc", normal
      "Y"
      "N"
   "WQ Ctrls Function?", menu, normal, "Water Quality Controls functioning?", normal
      "Y"
      "N"
   "Holes?", menu, normal, "Holes thru structure material", normal
      "Y"
      "N"
   "Cracks?", menu, normal, "Cracks in structure material", normal
      "Y"
      "N"
   "Spalling/Flaking?", menu, normal, "Conc 1/4" spalls/CMP loose flakes", normal
      "Y"
      "N"
   "Pitting/Rusting?", menu, normal, "SPCD Material is pitted or rusted", normal
      "Y"
      "N"
   "Void Near Structure?", menu, normal, "Evidence of void in fill near SPCD", normal
      "Y"
      "N"
   "Roadway Distress?", menu, normal, "Road bump, dip, pvmt patch or cracks", normal
      "Y"
      "N"
   "Marker Type?", menu, normal, "Marker that designates the SPCD", normal
      "None", default
      "Guardpost"
      "Sign"
      "ID Post"
      "ID Tag"
   "Sediment % Full?", numeric, 0, 0, 100, 0, normal, "Estimated sediment capacity % full?", normal
   "Comment", text, 100, normal, "Comment on extraordinary circumstances", normal
   "Date", date, auto, dmy, manual, normal, "Date", normal
   "Time", time, auto, 24, manual, normal, "Time", normal

"T_Illicit_Discharge", point, "Illicit Discharge Inspection ", 1, seconds, 5, Code
   "Roadway Type", menu, required, "Illicit Discharge is by this road type.", required
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township  Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Linked Feature Type", menu, normal, "Use only HYDINFRA ID from database", normal
      "Pipe"
      "Special Structure"
      "Structure"
      "Ditch"
      "Pond"
      "SPCD"
   "Linked HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Only use HYDINRA ID from database", normal, Label2
   "Linked Local ID", text, 30, normal, "Temporary field identifier", normal, Label1
   "Inspector", text, 20, normal, "Inspector name", normal
   "Inspection reason", menu, normal, "What prompted this inspection?", normal
      "Complaint"
      "Observed"
      "Re-inspection"
      "Post Event"
      "Other"
   "Visible Flow?", menu, normal, "Illicit Discharge is flowing", normal
      "Y"
      "N"
   "Dry Weather Flow?", menu, normal, "Flow is during dry weather", normal
      "Y"
      "N"
   "Dumped?", menu, normal, "Illicit Discharge is dumped material", normal
      "Y"
      "N"
   "Odor?", menu, normal, "Smells like", normal
      "None"
      "Sewage"
      "Rotten Eggs"
      "Fishy"
      "Skunk"
      "Petroleum"
      "Soap/Scented"
      "Acrid"
      "Other"
   "Floatables/Solids", menu, normal, "Discharge contains non-liquid stuff", normal
      "Sewage (TP etc)"
      "Algae"
      "Dead Fish"
      "Vegetation"
      "Other"
   "Color?", menu, normal, "Predominant Color", normal
      "White"
      "Grey"
      "Black"
      "Brown"
      "Green"
      "Yellow"
      "Orange"
      "Red"
      "Other"
      "None"
   "Clear?", menu, normal, "Discharge is clear", normal
      "Y"
      "N"
   "Cloudy?", menu, normal, "DischargeSomewhat cloudy to fully opaque", normal
      "Y"
      "N"
   "Oily Sheen?", menu, normal, "Irridescent or oily looking", normal
      "Y"
      "N"
   "Suds?", menu, normal, "Like soapsuds", normal
      "Y"
      "N"
   "Sewage?", menu, normal, "Has suds or TP or ?", normal
      "Y"
      "N"
   "Chemical?", menu, normal, "Texture, color or viscosity is abnormal", normal
      "Y"
      "N"
   "Sediment?", menu, normal, "Suspended or deposited sediment", normal
      "Y"
      "N"
   "Other Appearance?", menu, normal, "Describe in comment", normal
      "Y"
      "N"
   "Veg  Appearance", menu, normal, "How are plants here fairing?", normal
      "Normal"
      "Excessive Growth"
      "Inhibited Growth"
      "Dead"
   "Unexpected Infall?", menu, normal, "Unexpected pipe connection or other?", normal
      "Y"
      "N"
   "Investigation Status", menu, normal, "This investigation is:", normal
      "Pending", default
      "Resolved"
      "Cancelled"
   "Comment", text, 100, required, "Short descriptive comments.", required
   "Date", date, auto, dmy, manual, normal, "Date", normal
   "Time", time, auto, 24, manual, normal, "Time", normal

"T_ExOutfall_Infall", point, "Outfall/Infall", 5, seconds, 1, Code
   "Linked Feature Type", menu, normal, "Linked to HYDINFRA feature type", normal, Label1
      "Pipe"
      "Special Structure"
      "Hydraulic Structure"
      "Ditch"
      "Pond"
      "SPCD"
   "Linked HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Only use HYDINRA ID from database", normal, Label2
   "Linked Local ID", text, 20, normal, "Plan or Temporary ID ", normal
   "Receiving water name", text, 100, required, "Name of water body outfall drains into", required
   "Rec water body type", menu, required, "Type of water body outfall drains too.", required
      "Lake"
      "River"
      "Wetland"
      "Pond"
      "Ditch"
      "Storm Drain"
      "Other"
   "Type", menu, required, "Outfall or Infall", required
      "Outfall", default
      "Infall"
      "Other"
   "Discharge (Q)", numeric, 0, 0, 999999, 0, normal, "Design flow", normal
   "Discharge Units", menu, normal, "Cubic feet/second or Cu Meters/second", normal
      "CFS"
      "CMS"
   "Discharge Veloc (V)", numeric, 0, 0, 999999, 0, normal, "Design discharge velocity", normal
   "Discharge Vel Units", menu, normal, "Ft/sec or M/sec", normal
      "FPS", default
      "MPS"
   "Discharge Freq (Yr)", numeric, 0, 0, 999999, 0, normal, "Design storm:  X yr - 24 hour", normal
   "MS4 Outfall?", menu, normal, "Outfall is in MS4 area?", normal
      "Y", default
      "N"
   "Receiving Water Code", text, 20, normal, "DNR Water Code ", normal
   "Receiving Local Gov", text, 20, normal, "Flow drains to this city or county etc", normal
   "Comments", text, 100, normal, "Comment on extraordinary circumstances", normal

"T_Environmental", point, "Soil chemistry conditons", 1, seconds, 5, Code
   "Roadway Type", menu, required, "Illicit Discharge is by this road type.", required, Label1
      "Centerline", default
      "Median"
      "Mainline"
      "Ramp/Loop"
      "Collector/Distribut"
      "Frontage"
      "County Road"
      "City Road"
      "Township  Road"
      "Entrance"
      "Farm Entrance"
      "Field Entrance"
      "Other"
   "Linked HYDINFRA ID", numeric, 0, 0, 1e+010, 0, normal, "Only use HYDINRA ID from database", normal, Label2
   "Linked Feature Type", menu, normal, "Linked to HYDINFRA feature type", normal
      "Pipe"
      "Special Structure"
      "Structure"
      "Ditch"
      "Pond"
      "SPCD"
   "Soil Con", numeric, 0, 0, 1990, 0, normal, "Soil Conductivity microsemen cm", normal
   "Soil Res", numeric, 3, 0.000, 5.000, 0.000, normal, "Soil Resistivity", normal
   "Soil pH", numeric, 1, 0.0, 14.0, 7.0, normal, "Soil pH", normal
   "Water Con", numeric, 0, 0, 1990, 0, normal, "Water Conductivity microsemen cm", normal
   "Water Res", numeric, 3, 0.000, 5.000, 0.000, normal, "Water Resistivity ", normal
   "Water pH", numeric, 1, 0.0, 14.0, 7.0, normal, "Water pH", normal
   "Stream Type", menu, normal, "Stream Type", normal
      "Ditch"
      "Drainage Area"
      "River Intermittent"
      "Wetland"
      "Lake"
      "Pond"
      "Storm Drain"
      "Other"
   "Comments", text, 100, normal, "Comments", normal
   "Date", date, auto, dmy, manual, normal, "Date", normal
   "Time", time, auto, 24, manual, normal, "Time", normal