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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

• NLFID ( type: esriFieldTypeString, alias: NLFID, length: 14 , Coded Values: [SADASR00032**C: SADASR00032**C] , [SADASR00032**N: SADASR00032**N] , [SADASR00041**C: SADASR00041**C] , ...7323 more... )
• CRS ( type: esriFieldTypeString, alias: CRS, length: 17 )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT District, length: 2 )
• COUNTY ( type: esriFieldTypeString, alias: County, length: 10 )
• COUNTY_CD ( type: esriFieldTypeString, alias: County CD, length: 3 )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: Route Type, length: 2 , Coded Values: [IR: Interstate] , [US: United States Route] , [SR: State Route] , ...18 more... )
• ROUTE_NBR ( type: esriFieldTypeString, alias: Route Number, length: 5 )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: Route Suffix, length: 1 )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL Begin Number )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Latitude DD Begin )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Longitude DD Begin )
• PERP_DATE ( type: esriFieldTypeDate, alias: Perp Date, length: 8 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 1 , Coded Values: [A: Active] , [R: Retired] , [P: Proposed] , ...1 more... )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• SPECIAL_DESIGNATION ( type: esriFieldTypeString, alias: R-Special Designation (Formerly Road ID), length: 20 , 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) )
• OLD_CULVERT_FILE_NBR ( type: esriFieldTypeString, alias: Old Culvert File Number, length: 10 )
• CULVERT_OWNER ( type: esriFieldTypeString, alias: R-Culvert Owner, length: 1 , 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, length: 1 , 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, length: 1 , 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, length: 250 )
• NUMBER_OF_CELLS ( type: esriFieldTypeInteger, alias: R-Number of Cells , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• BROKEN_BACK ( type: esriFieldTypeString, alias: R-Broken Back, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• CULVERT_SHAPE ( type: esriFieldTypeString, alias: R-Culvert Shape, length: 27 , Coded Values: [Circular: Circular] , [Elliptical - Horizontal: Elliptical - Horizontal] , [Elliptical - Vertical: Elliptical - Vertical] , ...6 more... )
• MATERIAL ( type: esriFieldTypeString, alias: R-Culvert Material, length: 60 , 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) , Range: [12, 119] )
• RISE_INCHES ( type: esriFieldTypeInteger, alias: R-Rise (Inches) (Leave blank if Shape is Circular) , Range: [12, 300] )
• LENGTH_FEET ( type: esriFieldTypeInteger, alias: R-Length (Feet) (Include extensions) , Range: [1, 9999] )
• METAL_GAGE_THICKNESS_1 ( type: esriFieldTypeString, alias: O-Metal Gage Thickness 1, length: 33 , 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, length: 33 , 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) , Range: [0.1, 50] )
• SKEW_DEGREES ( type: esriFieldTypeInteger, alias: R-Skew (Degrees) , Range: [0, 89] )
• CENTERLINE_SPAN ( type: esriFieldTypeInteger, alias: Centerline Span )
• INLET_END_TREATMENT ( type: esriFieldTypeString, alias: R-Inlet End Treatment, length: 30 , 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, length: 30 , 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, length: 1 )
• MAX_HEIGHT_COVER_FT ( type: esriFieldTypeInteger, alias: R-Maximum Height of Cover (Feet) , Range: [1, 300] )
• HEADWALL_HEIGHT_INLET ( type: esriFieldTypeInteger, alias: O-Height of Inlet Headwall (Feet) , Range: [1, 999] )
• HEADWALL_EP_INLET_DISTANCE ( type: esriFieldTypeInteger, alias: O-Inlet Headwall to Edge Pavement Distance (Feet) , Range: [1, 999] )
• HEADWALL_HEIGHT_OUTLET ( type: esriFieldTypeInteger, alias: O-Height of Outlet Headwall (Feet) , Range: [1, 999] )
• HEADWALL_EP_OUTLET_DISTANCE ( type: esriFieldTypeInteger, alias: O-Outlet Headwall to Edge Pavement Distance (Feet) , Range: [1, 999] )
• DRAINAGE_AREA_ACRES ( type: esriFieldTypeInteger, alias: O-Drainage Area (Acres) , Range: [1, 9999] )
• DRAINAGE_DISCHARGE_CFS ( type: esriFieldTypeInteger, alias: O-Drainage Discharge (CFS) , Range: [1, 9999] )
• ABRASION_LEVEL ( type: esriFieldTypeInteger, alias: R-Abrasion Level (Set to 1 for Nonabrasive) , Coded Values: [1: Level 1] , [2: Level 2] , [3: Level 3] , ...3 more... )
• PH ( type: esriFieldTypeDouble, alias: O-pH , Range: [1, 14] )
• COMMENT ( type: esriFieldTypeString, alias: O-Inventory Comments, length: 2500 )
• PID ( type: esriFieldTypeInteger, alias: PID )
• LATEST_GA ( type: esriFieldTypeInteger, alias: Latest GA )
• LATEST_INSPECTION_DATE ( type: esriFieldTypeDate, alias: Latest Inspection Date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: Let Plans URL, length: 150 )
• REPLACING_CONDUIT ( type: esriFieldTypeString, alias: Replacing Conduit, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• REPLACED_CFN ( type: esriFieldTypeInteger, alias: CFN of Replaced Conduit )
• SCOUR_CRITICAL ( type: esriFieldTypeString, alias: R-Scour Critical, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• HEADWALL_CRITICAL ( type: esriFieldTypeString, alias: Headwall Critical, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• ATMOSPHERIC_PHYSICAL_HAZARD ( type: esriFieldTypeString, alias: R-Atmospheric or Physical Hazard, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• CONDUIT_MEDIA ( type: esriFieldTypeString, alias: Conduit Media, length: 2500 )
• MODIFICATION_TYPE ( type: esriFieldTypeString, alias: O-Modification Type, length: 25 , 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 , Range: [1900, 2050] )
• MODIFICATION_COMMENTS ( type: esriFieldTypeString, alias: O-Modification Comments, length: 2500 )
• CAPITAL_FY ( type: esriFieldTypeInteger, alias: Capital FY )
• LAST_INSPECTION_YEAR ( type: esriFieldTypeInteger, alias: Year of Last Inspection )
• FREQUENCY_YEAR ( type: esriFieldTypeInteger, alias: Frequency Year )
• LATEST_LEVEL_OF_INSP ( type: esriFieldTypeString, alias: Latest Level of Inspection, length: 50 , 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, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• INSPECTION_DUE ( type: esriFieldTypeString, alias: Inspection Due, length: 34 , 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, length: 150 )
• PASS_GA_QC ( type: esriFieldTypeString, alias: Pass GA QC, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata