View In:   ArcGIS Online Map Viewer

Name: Culvert Inventory

Display Field: CRS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This point feature class has 2 related tables; Collector.Collector.Culvert_Inspection and Collector.Collector.Culvert_Inventory_Modification. You can add many records to the related tables that are associated with a single Culvert Inventory (one-to-many relationship).

Copyright Text: ODOT - Office of Technical Services ODOT - Office of Hydraulic Engineering

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -9442128.1146
YMin: 4637244.158500001
XMax: -8963275.7819
YMax: 5231576.018700004
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• NLFID ( type: esriFieldTypeString, alias: NLFID, editable: true, nullable: true, length: 14, defaultValue: null, modelName: NLFID , Coded Values: [SADASR00032**C: SADASR00032**C] , [SADASR00032**N: SADASR00032**N] , [SADASR00041**C: SADASR00041**C] , ...7323 more... )
• CRS ( type: esriFieldTypeString, alias: CRS, editable: true, nullable: true, length: 17, defaultValue: null, modelName: CRS_DESC )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT District, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ODOT_DISTRICT )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COUNTY )
• COUNTY_CD ( type: esriFieldTypeString, alias: County CD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: COUNTY_CD )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: Route Type, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ROUTE_TYPE , Coded Values: [IR: Interstate] , [US: United States Route] , [SR: State Route] , ...18 more... )
• ROUTE_NBR ( type: esriFieldTypeString, alias: Route Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ROUTE_NBR )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: Route Suffix, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ROUTE_SUFFIX )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: CTL_BEGIN_NBR )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number, editable: true, nullable: true, defaultValue: null, modelName: STL_BEGIN_NBR )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Latitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE_DD_BEGIN )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Longitude DD Begin, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE_DD_BEGIN )
• PERP_DATE ( type: esriFieldTypeDate, alias: Perp Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PERP_DATE )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 1, defaultValue: A, modelName: STATUS , Coded Values: [A: Active] , [R: Retired] , [P: Proposed] , ...1 more... )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATION_DATE )
• SPECIAL_DESIGNATION ( type: esriFieldTypeString, alias: R-Special Designation (Formerly Road ID), editable: true, nullable: true, length: 20, defaultValue: Mainline, modelName: SPECIAL_DESIGNATION , Coded Values: [Mainline: Mainline] , [Side Road Left: Side Road Left] , [Side Road Right: Side Road Right] , ...2 more... )
• CULVERT_FILE_NUMBER ( type: esriFieldTypeInteger, alias: Culvert File Number (CFN), editable: true, nullable: true, defaultValue: null, modelName: CULVERT_FILE_NUMBER )
• OLD_CULVERT_FILE_NBR ( type: esriFieldTypeString, alias: Old Culvert File Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OLD_CULVERT_FILE_NBR )
• CULVERT_OWNER ( type: esriFieldTypeString, alias: R-Culvert Owner, editable: true, nullable: true, length: 1, defaultValue: S, modelName: CULVERT_OWNER , Coded Values: [S: S - State Department of Transportation] , [C: C - County Agency] , [M: M - City] , ...4 more... )
• MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: R-Maintenance Responsibility, editable: true, nullable: true, length: 1, defaultValue: S, modelName: MAINTAIN_RESPONSIBLE , Coded Values: [S: S - State Department of Transportation] , [D: D - Split Responsibility] , [C: C - County Agency] , ...5 more... )
• ENTRY_CLASS ( type: esriFieldTypeString, alias: R-Entry Class, editable: true, nullable: true, length: 1, defaultValue: A, modelName: ENTRY_CLASS , Coded Values: [A: Class A (Non-Entry Inspection)] , [B: Class B (Non-Permit Required Entry)] , [C: Class C (Alternate Entry Permit Required)] , ...1 more... )
• FEATURE_INTERSECTED ( type: esriFieldTypeString, alias: O-Feature Intersected, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FEATURE_INTERSECTED )
• NUMBER_OF_CELLS ( type: esriFieldTypeInteger, alias: R-Number of Cells, editable: true, nullable: true, defaultValue: 1, modelName: NUMBER_OF_CELLS , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• BROKEN_BACK ( type: esriFieldTypeString, alias: R-Broken Back, editable: true, nullable: true, length: 1, defaultValue: N, modelName: BROKEN_BACK , Coded Values: [Y: Yes] , [N: No] )
• CULVERT_SHAPE ( type: esriFieldTypeString, alias: R-Culvert Shape, editable: true, nullable: true, length: 27, defaultValue: Circular, modelName: CULVERT_SHAPE , Coded Values: [Circular: Circular] , [Elliptical - Horizontal: Elliptical - Horizontal] , [Elliptical - Vertical: Elliptical - Vertical] , ...6 more... )
• MATERIAL ( type: esriFieldTypeString, alias: R-Culvert Material, editable: true, nullable: true, length: 60, defaultValue: Plain or Reinforced Concrete, modelName: MATERIAL , Coded Values: [Plain or Reinforced Concrete: Plain or Reinforced Concrete] , [Corrugated Metal - Pipe: Corrugated Metal - Pipe] , [Corrugated Metal - Non-Sectional Plate: Corrugated Metal - Non-Sectional Plate] , ...19 more... )
• SPAN_INCHES ( type: esriFieldTypeInteger, alias: R-Span (Inches), editable: true, nullable: true, defaultValue: null, modelName: SPAN_INCHES , Range: [12, 119] )
• RISE_INCHES ( type: esriFieldTypeInteger, alias: R-Rise (Inches) (Leave blank if Shape is Circular), editable: true, nullable: true, defaultValue: null, modelName: RISE_INCHES , Range: [12, 300] )
• LENGTH_FEET ( type: esriFieldTypeInteger, alias: R-Length (Feet) (Include extensions), editable: true, nullable: true, defaultValue: null, modelName: LENGTH_FEET , Range: [1, 9999] )
• METAL_GAGE_THICKNESS_1 ( type: esriFieldTypeString, alias: O-Metal Gage Thickness 1, editable: true, nullable: true, length: 33, defaultValue: null, modelName: METAL_GAGE_THICKNESS_1 , Coded Values: [16 Gauge - 0.064 Inch or 1.63 mm: 16 Gauge - 0.064 Inch or 1.63 mm] , [14 Gauge - 0.079 Inch or 2.01 mm: 14 Gauge - 0.079 Inch or 2.01 mm] , [12 Gauge - 0.109 Inch or 2.77 mm: 12 Gauge - 0.109 Inch or 2.77 mm] , ...6 more... )
• TYPE_OF_PIPE_PROTECTION ( type: esriFieldTypeString, alias: O-Type of Pipe Protection, editable: true, nullable: true, length: 33, defaultValue: null, modelName: TYPE_OF_PIPE_PROTECTION , Coded Values: [Unprotected: Unprotected] , [Galvanized: Galvanized] , [Half Bituminous Coated: Half Bituminous Coated] , ...12 more... )
• SLOPE_OF_PIPE ( type: esriFieldTypeDouble, alias: O-Slope of Pipe (Percent), editable: true, nullable: true, defaultValue: null, modelName: SLOPE_OF_PIPE , Range: [0.1, 50] )
• SKEW_DEGREES ( type: esriFieldTypeInteger, alias: R-Skew (Degrees), editable: true, nullable: true, defaultValue: 0, modelName: SKEW_DEGREES , Range: [0, 89] )
• CENTERLINE_SPAN ( type: esriFieldTypeInteger, alias: Centerline Span, editable: true, nullable: true, defaultValue: null, modelName: CENTERLINE_SPAN )
• INLET_END_TREATMENT ( type: esriFieldTypeString, alias: R-Inlet End Treatment, editable: true, nullable: true, length: 30, defaultValue: Half Height Concrete Headwall, modelName: INLET_END_TREATMENT , Coded Values: [Full Height Concrete Headwall: Full Height Concrete Headwall] , [Half Height Concrete Headwall: Half Height Concrete Headwall] , [Third Height Concrete Headwall: Third Height Concrete Headwall] , ...10 more... )
• OUTLET_END_TREATMENT ( type: esriFieldTypeString, alias: R-Outlet End Treatment, editable: true, nullable: true, length: 30, defaultValue: Half Height Concrete Headwall, modelName: OUTLET_END_TREATMENT , Coded Values: [Full Height Concrete Headwall: Full Height Concrete Headwall] , [Half Height Concrete Headwall: Half Height Concrete Headwall] , [Third Height Concrete Headwall: Third Height Concrete Headwall] , ...10 more... )
• CLOSED_SYSTEM ( type: esriFieldTypeString, alias: Closed System, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CLOSED_SYSTEM )
• MAX_HEIGHT_COVER_FT ( type: esriFieldTypeInteger, alias: R-Maximum Height of Cover (Feet), editable: true, nullable: true, defaultValue: null, modelName: MAX_HEIGHT_COVER_FT , Range: [1, 300] )
• HEADWALL_HEIGHT_INLET ( type: esriFieldTypeInteger, alias: O-Height of Inlet Headwall (Feet), editable: true, nullable: true, defaultValue: null, modelName: HEADWALL_HEIGHT_INLET , Range: [1, 999] )
• HEADWALL_EP_INLET_DISTANCE ( type: esriFieldTypeInteger, alias: O-Inlet Headwall to Edge Pavement Distance (Feet), editable: true, nullable: true, defaultValue: null, modelName: HEADWALL_EP_INLET_DISTANCE , Range: [1, 999] )
• HEADWALL_HEIGHT_OUTLET ( type: esriFieldTypeInteger, alias: O-Height of Outlet Headwall (Feet), editable: true, nullable: true, defaultValue: null, modelName: HEADWALL_HEIGHT_OUTLET , Range: [1, 999] )
• HEADWALL_EP_OUTLET_DISTANCE ( type: esriFieldTypeInteger, alias: O-Outlet Headwall to Edge Pavement Distance (Feet), editable: true, nullable: true, defaultValue: null, modelName: HEADWALL_EP_OUTLET_DISTANCE , Range: [1, 999] )
• DRAINAGE_AREA_ACRES ( type: esriFieldTypeInteger, alias: O-Drainage Area (Acres), editable: true, nullable: true, defaultValue: null, modelName: DRAINAGE_AREA_ACRES , Range: [1, 9999] )
• DRAINAGE_DISCHARGE_CFS ( type: esriFieldTypeInteger, alias: O-Drainage Discharge (CFS), editable: true, nullable: true, defaultValue: null, modelName: DRAINAGE_DISCHARGE_CFS , Range: [1, 9999] )
• ABRASION_LEVEL ( type: esriFieldTypeInteger, alias: R-Abrasion Level (Set to 1 for Nonabrasive), editable: true, nullable: true, defaultValue: null, modelName: ABRASION_LEVEL , Coded Values: [1: Level 1] , [2: Level 2] , [3: Level 3] , ...3 more... )
• PH ( type: esriFieldTypeDouble, alias: O-pH, editable: true, nullable: true, defaultValue: null, modelName: PH , Range: [1, 14] )
• COMMENT ( type: esriFieldTypeString, alias: O-Inventory Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: COMMENT )
• PID ( type: esriFieldTypeInteger, alias: PID, editable: true, nullable: true, defaultValue: null, modelName: PID )
• LATEST_GA ( type: esriFieldTypeInteger, alias: Latest GA, editable: true, nullable: true, defaultValue: null, modelName: LATEST_GA )
• LATEST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Latest Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LATEST_INSPECTION_DATE )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: Let Plans URL, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LET_PLANS_URL )
• REPLACING_CONDUIT ( type: esriFieldTypeString, alias: Replacing Conduit, editable: true, nullable: true, length: 1, defaultValue: N, modelName: REPLACING_CONDUIT , Coded Values: [Y: Yes] , [N: No] )
• REPLACED_CFN ( type: esriFieldTypeInteger, alias: CFN of Replaced Conduit, editable: true, nullable: true, defaultValue: null, modelName: REPLACED_CFN )
• SCOUR_CRITICAL ( type: esriFieldTypeString, alias: R-Scour Critical, editable: true, nullable: true, length: 1, defaultValue: N, modelName: SCOUR_CRITICAL , Coded Values: [Y: Yes] , [N: No] )
• HEADWALL_CRITICAL ( type: esriFieldTypeString, alias: Headwall Critical, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HEADWALL_CRITICAL , Coded Values: [Y: Yes] , [N: No] )
• ATMOSPHERIC_PHYSICAL_HAZARD ( type: esriFieldTypeString, alias: R-Atmospheric or Physical Hazard, editable: true, nullable: true, length: 1, defaultValue: N, modelName: ATMOSPHERIC_PHYSICAL_HAZARD , Coded Values: [Y: Yes] , [N: No] )
• CONDUIT_MEDIA ( type: esriFieldTypeString, alias: Conduit Media, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: CONDUIT_MEDIA )
• MODIFICATION_TYPE ( type: esriFieldTypeString, alias: O-Modification Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MODIFICATION_TYPE , Coded Values: [Field Paving: Field Paving] , [Section Repair: Section Repair] , [Internal Bands: Internal Band(s)] , ...4 more... )
• YEAR_MODIFIED ( type: esriFieldTypeInteger, alias: O-Year Modified, editable: true, nullable: true, defaultValue: null, modelName: YEAR_MODIFIED , Range: [1900, 2050] )
• MODIFICATION_COMMENTS ( type: esriFieldTypeString, alias: O-Modification Comments, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: MODIFICATION_COMMENTS )
• CAPITAL_FY ( type: esriFieldTypeInteger, alias: Capital FY, editable: true, nullable: true, defaultValue: null, modelName: CAPITAL_FY )
• LAST_INSPECTION_YEAR ( type: esriFieldTypeInteger, alias: Year of Last Inspection, editable: true, nullable: true, defaultValue: null, modelName: LAST_INSPECTION_YEAR )
• FREQUENCY_YEAR ( type: esriFieldTypeInteger, alias: Frequency Year, editable: true, nullable: true, defaultValue: null, modelName: FREQUENCY_YEAR )
• LATEST_LEVEL_OF_INSP ( type: esriFieldTypeString, alias: Latest Level of Inspection, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LATEST_LEVEL_OF_INSP , Coded Values: [Inspection from ends of conduit: Inspection from ends of conduit (Non-entry)] , [Manned entry inspection: Manned entry inspection] , [Remote inspection: Remote inspection] , ...2 more... )
• PARTIAL_INSP_IND ( type: esriFieldTypeString, alias: Partial Inspection Indicator, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PARTIAL_INSP_IND , Coded Values: [Y: Yes] , [N: No] )
• INSPECTION_DUE ( type: esriFieldTypeString, alias: Inspection Due, editable: true, nullable: true, length: 34, defaultValue: null, modelName: INSPECTION_DUE , Coded Values: [Needs Inspected this CY: Needs Inspected this Calender Year] , [Needs Inspected next CY: Needs Inspected next Calender Year] )
• INVPHOTOS ( type: esriFieldTypeString, alias: InvPhotos, editable: true, nullable: true, length: 150, defaultValue: null, modelName: INVPHOTOS )
• PASS_GA_QC ( type: esriFieldTypeString, alias: Pass GA QC, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PASS_GA_QC , Coded Values: [Y: Yes] , [N: No] )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: sys_updated_date )

Templates:

• Name: Culvert Inventory
  Description:
  Prototype:
  PERP_DATE: null
  PID: null
  PASS_GA_QC: null
  NLFID: null
  CRS: null
  ODOT_DISTRICT: null
  COUNTY: null
  COUNTY_CD: null
  ROUTE_TYPE: null
  ROUTE_NBR: null
  ROUTE_SUFFIX: null
  CTL_BEGIN_NBR: null
  STL_BEGIN_NBR: null
  LATITUDE_DD_BEGIN: null
  LONGITUDE_DD_BEGIN: null
  STATUS: A
  INSTALLATION_DATE: null
  SPECIAL_DESIGNATION: Mainline
  CULVERT_FILE_NUMBER: null
  OLD_CULVERT_FILE_NBR: null
  CULVERT_OWNER: S
  MAINTAIN_RESPONSIBLE: S
  ENTRY_CLASS: A
  FEATURE_INTERSECTED: null
  NUMBER_OF_CELLS: 1
  BROKEN_BACK: N
  CULVERT_SHAPE: Circular
  MATERIAL: Plain or Reinforced Concrete
  SPAN_INCHES: null
  RISE_INCHES: null
  LENGTH_FEET: null
  METAL_GAGE_THICKNESS_1: null
  TYPE_OF_PIPE_PROTECTION: null
  SLOPE_OF_PIPE: null
  SKEW_DEGREES: 0
  CENTERLINE_SPAN: null
  INLET_END_TREATMENT: Half Height Concrete Headwall
  OUTLET_END_TREATMENT: Half Height Concrete Headwall
  CLOSED_SYSTEM: null
  MAX_HEIGHT_COVER_FT: null
  HEADWALL_HEIGHT_INLET: null
  HEADWALL_EP_INLET_DISTANCE: null
  HEADWALL_HEIGHT_OUTLET: null
  HEADWALL_EP_OUTLET_DISTANCE: null
  DRAINAGE_AREA_ACRES: null
  DRAINAGE_DISCHARGE_CFS: null
  ABRASION_LEVEL: null
  PH: null
  COMMENT: null
  LATEST_GA: null
  LATEST_INSPECTION_DATE: null
  INVPHOTOS: null
  INSPECTION_DUE: null
  PARTIAL_INSP_IND: null
  LATEST_LEVEL_OF_INSP: null
  sys_updated_date: null
  LET_PLANS_URL: null
  REPLACING_CONDUIT: N
  REPLACED_CFN: null
  SCOUR_CRITICAL: N
  HEADWALL_CRITICAL: null
  ATMOSPHERIC_PHYSICAL_HAZARD: N
  CONDUIT_MEDIA: null
  MODIFICATION_TYPE: null
  YEAR_MODIFIED: null
  MODIFICATION_COMMENTS: null
  CAPITAL_FY: null
  LAST_INSPECTION_YEAR: null
  FREQUENCY_YEAR: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata