View In:   ArcGIS Online Map Viewer

Name: Culvert Inspections_ALL

Display Field: CulvertFileNumber

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 1474957.8604249954
YMin: 736711.2278749943
XMax: 1499266.884374991
YMax: 760487.610499993
Spatial Reference: 102723  (3735)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: InspectionStatus
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Complete
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [0, 197, 255, 255]
  Outline:
  Style: esriSLSNull
  Color: [110, 110, 110, 255]
  Width: 0
• Value: 2
  Label: Incomplete
  Description:
  Symbol:
  Style: esriSFSSolid
  Color: [255, 85, 0, 255]
  Outline:
  Style: esriSLSNull
  Color: [110, 110, 110, 255]
  Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerPolygonPlacementAlwaysHorizontal
Label Expression: [CulvertNumber]
Use Coded Values: true
Symbol:
Color: [255, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Century Gothic
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: InspectionStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CulvertFileNumber ( type: esriFieldTypeString, alias: Culvert File Number:, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CulvertFileNumber )
• CulvertNumber ( type: esriFieldTypeString, alias: Culvert Number:, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CulvertNumber )
• District ( type: esriFieldTypeSmallInteger, alias: District:, editable: true, nullable: true, defaultValue: null, modelName: District , Coded Values: [1: District 1] , [2: District 2] , [3: District 3] , ...9 more... )
• Span ( type: esriFieldTypeSmallInteger, alias: Span:, editable: true, nullable: true, defaultValue: null, modelName: Span )
• Material ( type: esriFieldTypeSmallInteger, alias: Material:, editable: true, nullable: true, defaultValue: null, modelName: Material , Coded Values: [1: Plain or Reinforced Concrete] , [2: Corrugated Metal Pipe] , [3: Corrugated Metal Non-Sectional Plate] , ...18 more... )
• Length ( type: esriFieldTypeSmallInteger, alias: Length:, editable: true, nullable: true, defaultValue: null, modelName: Length )
• RoadwayID ( type: esriFieldTypeString, alias: Roadway ID:, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoadwayID )
• EntryClass ( type: esriFieldTypeString, alias: Entry Class:, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EntryClass , Coded Values: [A: Class A (Non-Entry Inspection)] , [B: Class B (Non-Permit Required Entry)] , [C: Class C (Alternate Entry Permit Required)] , ...1 more... )
• NumberOfCells ( type: esriFieldTypeSmallInteger, alias: Number of Cells:, editable: true, nullable: true, defaultValue: null, modelName: NumberOfCells , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• X ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• FeatureIntersection ( type: esriFieldTypeString, alias: Feature Intersection:, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FeatureIntersection )
• General_ ( type: esriFieldTypeSmallInteger, alias: General:, editable: true, nullable: true, defaultValue: null, modelName: General_ , Coded Values: [1: Failure] , [2: Iminant Failure] , [3: Critical] , ...7 more... )
• CulvertAlignment ( type: esriFieldTypeSmallInteger, alias: Culvert Alignment:, editable: true, nullable: true, defaultValue: null, modelName: CulvertAlignment , Coded Values: [1: Failure] , [2: Iminant Failure] , [3: Critical] , ...7 more... )
• ShapeRating ( type: esriFieldTypeSmallInteger, alias: Shape Rating:, editable: true, nullable: true, defaultValue: null, modelName: ShapeRating , Coded Values: [1: Failure] , [2: Iminant Failure] , [3: Critical] , ...7 more... )
• SeamsJoints ( type: esriFieldTypeSmallInteger, alias: Seams or Joints:, editable: true, nullable: true, defaultValue: null, modelName: SeamsJoints , Coded Values: [1: Failure] , [2: Iminant Failure] , [3: Critical] , ...7 more... )
• Slab ( type: esriFieldTypeSmallInteger, alias: Slab:, editable: true, nullable: true, defaultValue: null, modelName: Slab , Coded Values: [1: Failed - Total failure of Slab] , [2: Imminent Failure - Slab partially collapsed or collapse is imminent.] , [3: Critical - Full depth holes; cracking and white efflorescence. Total delaminated, spalled, map cracking, and punky concrete areas are greater than 50% of surface area. Reinforcing steel bars have extensive section losses (greater than 30% of original diameter) for more than 10 adjacent bars. Additional dark and damp areas over at least 50% of deck.] , ...7 more... )
• Abutment ( type: esriFieldTypeSmallInteger, alias: Abutment:, editable: true, nullable: true, defaultValue: null, modelName: Abutment , Coded Values: [1: Failure] , [2: Iminant Failure] , [3: Critical] , ...7 more... )
• Headwalls ( type: esriFieldTypeSmallInteger, alias: Headwalls:, editable: true, nullable: true, defaultValue: null, modelName: Headwalls , Coded Values: [1: Failed - Total failure of headwall. Headwall collapsed-beyond corrective action.] , [2: Imminent Failure - Partially collapsed headwall. Major deterioration of headwall, conditions worse than the Critical rating above. Obvious vertical or horizontal movement affecting the stability of the headwall.] , [3: Critical - Cracking and white efflorescence; total delaminated, spalled, map cracking, and unsound concrete areas are greater than 50% of surface area. Reinforcing steel bars have extensive section losses (greater than 30% of original diameter) for more than 10 adjacent bars.] , ...7 more... )
• EndStructure ( type: esriFieldTypeSmallInteger, alias: End Structure:, editable: true, nullable: true, defaultValue: null, modelName: EndStructure , Coded Values: [1: Failed - Total failure of structure.] , [2: Imminent Failure - Partially collapsed structure.] , [3: Critical - Cracking and white efflorescence; total delaminated, spalled, map cracking, and unsound concrete areas are greater than 50% of surface area; masonry units missing and wall partially caved in; barrel separated from structure wall. Grate or casting more than 2 inch off from proper grade or crushed or broken in traffic area. Debris in basin and conduit not visible.] , ...7 more... )
• ChannelAlignment ( type: esriFieldTypeSmallInteger, alias: Channel Alignment:, editable: true, nullable: true, defaultValue: null, modelName: ChannelAlignment , Coded Values: [1: Failed - Total failure of pipe.] , [2: Imminent Failure - No flow enters culvert; all of the flow pipes around culvert barrel. Culvert closed because of channel failure.] , [3: Critical - Flow is piping around culvert; erosion to embankment is impacting the roadway. The waterway has changed to the extent the culvert is near a state of collapse.] , ...7 more... )
• Protection ( type: esriFieldTypeSmallInteger, alias: Protection:, editable: true, nullable: true, defaultValue: null, modelName: Protection , Coded Values: [1: Failed - Total failure of channel.] , [2: Imminent Failure - Culvert closed because of channel failure.] , [3: Critical - Channel protection has failed; channel flow is causing scour.] , ...7 more... )
• CulvertWaterwayBlockage ( type: esriFieldTypeSmallInteger, alias: Culvert Waterway Blockage:, editable: true, nullable: true, defaultValue: null, modelName: CulvertWaterwayBlockage , Coded Values: [1: Failed - Total Failure of pipe.] , [2: Imminent Failure - Culvert waterway completely blocked and causing water to pool. Road closed because of channel failure.] , [3: Critical - Culvert waterway blockage is 80% or greater; frequent overtopping of roadway with significant traffic delays.] , ...7 more... )
• Scour ( type: esriFieldTypeSmallInteger, alias: Scour:, editable: true, nullable: true, defaultValue: null, modelName: Scour , Coded Values: [1: Failed - Total failure of culvert because of channel failure.] , [2: Imminent Failure - Culvert closed because of channel failure.] , [3: Critical - Streambed degradation causing severe settlement.] , ...7 more... )
• Pavement ( type: esriFieldTypeSmallInteger, alias: Pavement:, editable: true, nullable: true, defaultValue: null, modelName: Pavement , Coded Values: [1: Failed - Road Closed; embankment and/or pavement failed, impassable] , [2: Imminent - Failure - Road Closed; impending pavement and/or embankment failure.] , [3: Critical - Significant pavement settlement/cracking. Embankment washed out next to pavement] , ...7 more... )
• Guardrail ( type: esriFieldTypeSmallInteger, alias: Guardrail:, editable: true, nullable: true, defaultValue: null, modelName: Guardrail , Coded Values: [1: Failed - Total failure of guardrail.] , [2: Imminent Failure - Guardrail partially collapsed.] , [3: Critical - Guardrail is no longer functioning due to severe settlement and misalignment.] , ...7 more... )
• Embankment ( type: esriFieldTypeSmallInteger, alias: Embankment:, editable: true, nullable: true, defaultValue: null, modelName: Embankment , Coded Values: [1: Failed - Embankment failed; road closed.] , [2: Imminent Failure - Embankment failure could allow loss of culvert] , [3: Critical - A lane of traffic is closed due to embankment failure; several guardrail posts are hanging due to major channel erosion.] , ...7 more... )
• LevelOfInspection ( type: esriFieldTypeString, alias: Level of Inspection:, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LevelOfInspection , Coded Values: [M: Manned Entry inspection] , [V: Video Inpsection] , [X: Inspection from ends of culvert. (Non-entry)] )
• GeneralAppraisal ( type: esriFieldTypeSmallInteger, alias: General Appraisal:, editable: true, nullable: true, defaultValue: null, modelName: GeneralAppraisal , Coded Values: [1: Failed condition - out of service - beyond corrective action] , [2: “Imminent” failure condition - major deterioration or section loss present on structural components. Culvert is closed to traffic.] , [3: Critical condition - advanced deterioration of primary structural elements. Culvert should be closed or closely monitored, until corrective action is taken] , ...7 more... )
• Comments ( type: esriFieldTypeString, alias: Comments:, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• InspectedBy ( type: esriFieldTypeString, alias: Inspected By:, editable: true, nullable: true, length: 25, defaultValue: null, modelName: InspectedBy , Coded Values: [Other: Other] , [NT: Neil Teaford] , [CW: Chris Weethee] , ...5 more... )
• ReviewedBy ( type: esriFieldTypeString, alias: Reviewed By:, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ReviewedBy , Coded Values: [Other: Other] , [JR: Jillian Rhoades] , [CB: Christie Butera] , ...2 more... )
• InspectionStatus ( type: esriFieldTypeSmallInteger, alias: Inspection Status:, editable: true, nullable: true, defaultValue: null, modelName: InspectionStatus , Coded Values: [1: Complete] , [2: Incomplete] )
• OperationalStatus ( type: esriFieldTypeString, alias: Operational Status:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OperationalStatus , Coded Values: [A: Open, no restriction.] , [B: Open, posting recommended but not legally implemented (all signs not in place).] , [C: Under construction, half of the existing culvert is open to traffic (half-width construction).] , ...7 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• Year ( type: esriFieldTypeDouble, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )

Types:

ID: 1
Name: 1
Domains:
• District:
  Inherited
• Material:
  Inherited
• EntryClass:
  Inherited
• NumberOfCells:
  Inherited
• General_:
  Inherited
• CulvertAlignment:
  Inherited
• ShapeRating:
  Inherited
• SeamsJoints:
  Inherited
• Slab:
  Inherited
• Abutment:
  Inherited
• Headwalls:
  Inherited
• EndStructure:
  Inherited
• ChannelAlignment:
  Inherited
• Protection:
  Inherited
• CulvertWaterwayBlockage:
  Inherited
• Scour:
  Inherited
• Pavement:
  Inherited
• Guardrail:
  Inherited
• Embankment:
  Inherited
• LevelOfInspection:
  Inherited
• GeneralAppraisal:
  Inherited
• InspectedBy:
  Inherited
• ReviewedBy:
  Inherited
• InspectionStatus:
  Inherited
• OperationalStatus:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  Year: null
  InspectionDate: null
  CulvertFileNumber: null
  CulvertNumber: null
  District: null
  Span: null
  Material: null
  Length: null
  RoadwayID: null
  EntryClass: null
  NumberOfCells: null
  X: null
  Y: null
  FeatureIntersection: null
  General_: null
  CulvertAlignment: null
  ShapeRating: null
  SeamsJoints: null
  Slab: null
  Abutment: null
  Headwalls: null
  EndStructure: null
  ChannelAlignment: null
  Protection: null
  CulvertWaterwayBlockage: null
  Scour: null
  Pavement: null
  Guardrail: null
  Embankment: null
  LevelOfInspection: null
  GeneralAppraisal: null
  Comments: null
  InspectedBy: null
  ReviewedBy: null
  InspectionStatus: 1
  OperationalStatus: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: 2
Name: 2
Domains:
• District:
  Inherited
• Material:
  Inherited
• EntryClass:
  Inherited
• NumberOfCells:
  Inherited
• General_:
  Inherited
• CulvertAlignment:
  Inherited
• ShapeRating:
  Inherited
• SeamsJoints:
  Inherited
• Slab:
  Inherited
• Abutment:
  Inherited
• Headwalls:
  Inherited
• EndStructure:
  Inherited
• ChannelAlignment:
  Inherited
• Protection:
  Inherited
• CulvertWaterwayBlockage:
  Inherited
• Scour:
  Inherited
• Pavement:
  Inherited
• Guardrail:
  Inherited
• Embankment:
  Inherited
• LevelOfInspection:
  Inherited
• GeneralAppraisal:
  Inherited
• InspectedBy:
  Inherited
• ReviewedBy:
  Inherited
• InspectionStatus:
  Inherited
• OperationalStatus:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  Year: null
  InspectionDate: null
  CulvertFileNumber: null
  CulvertNumber: null
  District: null
  Span: null
  Material: null
  Length: null
  RoadwayID: null
  EntryClass: null
  NumberOfCells: null
  X: null
  Y: null
  FeatureIntersection: null
  General_: null
  CulvertAlignment: null
  ShapeRating: null
  SeamsJoints: null
  Slab: null
  Abutment: null
  Headwalls: null
  EndStructure: null
  ChannelAlignment: null
  Protection: null
  CulvertWaterwayBlockage: null
  Scour: null
  Pavement: null
  Guardrail: null
  Embankment: null
  LevelOfInspection: null
  GeneralAppraisal: null
  Comments: null
  InspectedBy: null
  ReviewedBy: null
  InspectionStatus: 2
  OperationalStatus: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata