Layers:

Layer: CulvertGroup (0)

Name: CulvertGroup

Display Field: HwyNbr

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9d1245fb8e0941acb6508ae15532b6c7

Copyright Text:

Default Visibility: true

MaxRecordCount: 9000

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: -104.05491280609817
YMin: 42.49789910504204
XMax: -96.45197593399996
YMax: 45.944713334894324
Spatial Reference: 4326  (4326)  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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• CulvertNbr ( type: esriFieldTypeInteger, alias: Culvert, editable: true, nullable: true, defaultValue: null, modelName: CulvertNbr )
• HwyNbr ( type: esriFieldTypeString, alias: Highway, editable: true, nullable: true, length: 6, defaultValue: null, modelName: HwyNbr )
• MRMNbr ( type: esriFieldTypeDouble, alias: MRM, editable: true, nullable: true, defaultValue: null, modelName: MRMNbr )
• DispLen ( type: esriFieldTypeDouble, alias: Displacement, editable: true, nullable: true, defaultValue: null, modelName: DispLen )
• StationingDesc ( type: esriFieldTypeString, alias: Stationing, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StationingDesc )
• RepairByMaintCrewCode ( type: esriFieldTypeInteger, alias: Maintenance Crew Will Perform Repairs, editable: true, nullable: true, defaultValue: null, modelName: RepairByMaintCrewCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• WorkCompletedDesc ( type: esriFieldTypeString, alias: Maintenance Work to be Completed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkCompletedDesc )
• OverallConditionCode ( type: esriFieldTypeInteger, alias: Overall Condition, editable: true, nullable: true, defaultValue: null, modelName: OverallConditionCode , Coded Values: [1: Critical] , [2: Poor] , [3: Fair] , ...1 more... )
• MainlineLocInd ( type: esriFieldTypeSmallInteger, alias: Mainline Location, editable: true, nullable: true, defaultValue: null, modelName: MainlineLocInd , Coded Values: [0: No] , [1: Yes] )
• ApproachLocInd ( type: esriFieldTypeSmallInteger, alias: Approach Location, editable: true, nullable: true, defaultValue: null, modelName: ApproachLocInd , Coded Values: [0: No] , [1: Yes] )
• RampLocInd ( type: esriFieldTypeSmallInteger, alias: Ramp Location, editable: true, nullable: true, defaultValue: null, modelName: RampLocInd , Coded Values: [0: No] , [1: Yes] )
• FrontageLocInd ( type: esriFieldTypeSmallInteger, alias: Frontage Location, editable: true, nullable: true, defaultValue: null, modelName: FrontageLocInd , Coded Values: [0: No] , [1: Yes] )
• OtherLocInd ( type: esriFieldTypeSmallInteger, alias: Other Location, editable: true, nullable: true, defaultValue: null, modelName: OtherLocInd , Coded Values: [0: No] , [1: Yes] )
• PurposeCode ( type: esriFieldTypeInteger, alias: Purpose, editable: true, nullable: true, defaultValue: null, modelName: PurposeCode , Coded Values: [1: Drainage] , [2: Railroad] , [3: Livestock] , ...5 more... )
• MaxCoverHeightCode ( type: esriFieldTypeInteger, alias: Max Cover Height, editable: true, nullable: true, defaultValue: null, modelName: MaxCoverHeightCode , Coded Values: [1: Less than 2'] , [2: 2' to 5'] , [3: 5' to 10'] , ...3 more... )
• WaterOvertopCode ( type: esriFieldTypeInteger, alias: Water Overtop, editable: true, nullable: true, defaultValue: null, modelName: WaterOvertopCode , Coded Values: [0: Unknown] , [1: Once] , [2: Multiple Times a Year] , ...6 more... )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• FurtherInspectionNeedInd ( type: esriFieldTypeSmallInteger, alias: Further Inspection Needed, editable: true, nullable: true, defaultValue: null, modelName: FurtherInspectionNeedInd , Coded Values: [0: No] , [1: Yes] )
• FurtherInspectionReason ( type: esriFieldTypeString, alias: Further Inspection Reason, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FurtherInspectionReason )
• AbandonedCode ( type: esriFieldTypeInteger, alias: Abandoned, editable: true, nullable: true, defaultValue: null, modelName: AbandonedCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• DesignNaturalStreambedCode ( type: esriFieldTypeInteger, alias: Countersunk, editable: true, nullable: true, defaultValue: null, modelName: DesignNaturalStreambedCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• RepairRcmndDesc ( type: esriFieldTypeString, alias: Repair Recommendation, editable: true, nullable: true, length: 600, defaultValue: null, modelName: RepairRcmndDesc )
• RepairRcmndDate ( type: esriFieldTypeDate, alias: Repair Recommendation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RepairRcmndDate )
• AddlInfoDesc ( type: esriFieldTypeString, alias: Additional Info, editable: true, nullable: true, length: 500, defaultValue: null, modelName: AddlInfoDesc )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• LastUpdateUser ( type: esriFieldTypeString, alias: LastUpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdateUser )
• GroupGUID ( type: esriFieldTypeGUID, alias: GroupGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroupGUID )
• 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 )
Templates:
• Name: CulvertGroup
  Description:
  Prototype:
  GroupGUID: null
  CulvertNbr: null
  HwyNbr: null
  MRMNbr: null
  DispLen: null
  StationingDesc: null
  RepairByMaintCrewCode: null
  WorkCompletedDesc: null
  OverallConditionCode: null
  MainlineLocInd: null
  ApproachLocInd: null
  RampLocInd: null
  FrontageLocInd: null
  OtherLocInd: null
  PurposeCode: null
  MaxCoverHeightCode: null
  WaterOvertopCode: null
  InstallDate: null
  FurtherInspectionNeedInd: null
  FurtherInspectionReason: null
  AbandonedCode: null
  DesignNaturalStreambedCode: null
  RepairRcmndDesc: null
  RepairRcmndDate: null
  AddlInfoDesc: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• CulvertHasEnd (0) -- Related To: CulvertEnd (1)
• GroupHasInspection (1) -- Related To: GroupInspection (5)
• CulvertHasTube (2) -- Related To: CulvertTube (2)

Layer: CulvertEnd (1)

Name: CulvertEnd

Display Field: CommentDesc

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 9d1245fb8e0941acb6508ae15532b6c7

Copyright Text:

Default Visibility: true

MaxRecordCount: 9000

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: -104.05500996010012
YMin: 42.49779572604411
XMax: -96.45197200399997
YMax: 45.94488000189763
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: InletOutletCode
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Inlet
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Outlet
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Unknown
  Description: N/A
  Symbol:
  
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: InletOutletCode

Fields:
• EndTypeCode ( type: esriFieldTypeInteger, alias: End Type, editable: true, nullable: true, defaultValue: null, modelName: EndTypeCode , Coded Values: [0: Pipe] , [1: Box Culvert] , [2: Cattle Pass] , ...7 more... )
• SubEndTypeCode ( type: esriFieldTypeInteger, alias: End Sub Type, editable: true, nullable: true, defaultValue: null, modelName: SubEndTypeCode , Coded Values: [1: Pipe - Safety End w/Bars] , [2: Pipe - Safety End w/o Bars] , [3: Pipe - Sloped End] , ...24 more... )
• EndShapeCode ( type: esriFieldTypeInteger, alias: End Shape, editable: true, nullable: true, defaultValue: null, modelName: EndShapeCode , Coded Values: [1: Round] , [2: Arch] , [3: Elliptical] , ...3 more... )
• EndInchHgt ( type: esriFieldTypeDouble, alias: End Height (Inches), editable: true, nullable: true, defaultValue: null, modelName: EndInchHgt )
• WidthDiameterInchLen ( type: esriFieldTypeDouble, alias: Width Diameter (Inches), editable: true, nullable: true, defaultValue: null, modelName: WidthDiameterInchLen )
• MaterialCode ( type: esriFieldTypeInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: MaterialCode , Coded Values: [1: Concrete] , [2: Galv Steel] , [3: Alum Steel] , ...12 more... )
• InletOutletCode ( type: esriFieldTypeInteger, alias: Inlet/Outlet, editable: true, nullable: true, defaultValue: null, modelName: InletOutletCode , Coded Values: [0: Inlet] , [1: Outlet] , [2: Unknown] )
• EstDistToEdgeLineCode ( type: esriFieldTypeInteger, alias: Estimated Distance to Edge Line, editable: true, nullable: true, defaultValue: null, modelName: EstDistToEdgeLineCode , Coded Values: [1: <10'] , [2: 10'-15'] , [3: 15'-20'] , ...3 more... )
• InsideROWCode ( type: esriFieldTypeInteger, alias: Inside ROW, editable: true, nullable: true, defaultValue: null, modelName: InsideROWCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• SlopeOfInslope ( type: esriFieldTypeDouble, alias: Slope of Inslope (%), editable: true, nullable: true, defaultValue: null, modelName: SlopeOfInslope )
• EndTreatmentTypeCode ( type: esriFieldTypeInteger, alias: Erosion Control Type, editable: true, nullable: true, defaultValue: null, modelName: EndTreatmentTypeCode , Coded Values: [1: Rip Rap] , [2: Gabion Baskets] , [3: Lined Channel] , ...5 more... )
• EndTreatmentInsideROWCode ( type: esriFieldTypeInteger, alias: Erosion Control Completely Inside ROW, editable: true, nullable: true, defaultValue: null, modelName: EndTreatmentInsideROWCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] , ...1 more... )
• CommentDesc ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CommentDesc )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• LastUpdateUser ( type: esriFieldTypeString, alias: LastUpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdateUser )
• EndGUID ( type: esriFieldTypeGUID, alias: EndGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: EndGUID )
• GroupGUID ( type: esriFieldTypeGUID, alias: GroupGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroupGUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GroupGlobalID ( type: esriFieldTypeGUID, alias: GroupGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroupGlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Types:
ID: 0
Name: Inlet
Domains:
• EndTypeCode:
  Inherited
• SubEndTypeCode:
  Inherited
• EndShapeCode:
  Inherited
• MaterialCode:
  Inherited
• InletOutletCode:
  Inherited
• EstDistToEdgeLineCode:
  Inherited
• InsideROWCode:
  Inherited
• EndTreatmentTypeCode:
  Inherited
• EndTreatmentInsideROWCode:
  Inherited
Templates:
• Name: Inlet
  Description:
  Prototype:
  MaterialCode: null
  GroupGlobalID: null
  EndTypeCode: null
  SubEndTypeCode: null
  EndShapeCode: null
  EndInchHgt: null
  WidthDiameterInchLen: null
  InletOutletCode: 0
  EstDistToEdgeLineCode: null
  InsideROWCode: null
  SlopeOfInslope: null
  EndTreatmentTypeCode: null
  EndTreatmentInsideROWCode: null
  CommentDesc: null
  GroupGUID: null
  EndGUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Outlet
Domains:
• EndTypeCode:
  Inherited
• SubEndTypeCode:
  Inherited
• EndShapeCode:
  Inherited
• MaterialCode:
  Inherited
• InletOutletCode:
  Inherited
• EstDistToEdgeLineCode:
  Inherited
• InsideROWCode:
  Inherited
• EndTreatmentTypeCode:
  Inherited
• EndTreatmentInsideROWCode:
  Inherited
Templates:
• Name: Outlet
  Description:
  Prototype:
  MaterialCode: null
  GroupGlobalID: null
  EndTypeCode: null
  SubEndTypeCode: null
  EndShapeCode: null
  EndInchHgt: null
  WidthDiameterInchLen: null
  InletOutletCode: 1
  EstDistToEdgeLineCode: null
  InsideROWCode: null
  SlopeOfInslope: null
  EndTreatmentTypeCode: null
  EndTreatmentInsideROWCode: null
  CommentDesc: null
  GroupGUID: null
  EndGUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Unknown
Domains:
• EndTypeCode:
  Inherited
• SubEndTypeCode:
  Inherited
• EndShapeCode:
  Inherited
• MaterialCode:
  Inherited
• InletOutletCode:
  Inherited
• EstDistToEdgeLineCode:
  Inherited
• InsideROWCode:
  Inherited
• EndTreatmentTypeCode:
  Inherited
• EndTreatmentInsideROWCode:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  MaterialCode: null
  GroupGlobalID: null
  EndTypeCode: null
  SubEndTypeCode: null
  EndShapeCode: null
  EndInchHgt: null
  WidthDiameterInchLen: null
  InletOutletCode: 2
  EstDistToEdgeLineCode: null
  InsideROWCode: null
  SlopeOfInslope: null
  EndTreatmentTypeCode: null
  EndTreatmentInsideROWCode: null
  CommentDesc: null
  GroupGUID: null
  EndGUID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• EndHasCondition (3) -- Related To: EndCondition (3)
• EndBelongsToGroup (0) -- Related To: CulvertGroup (0)

Layer: CulvertTube (2)

Name: CulvertTube

Display Field: CreateUser

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 9d1245fb8e0941acb6508ae15532b6c7

Copyright Text:

Default Visibility: true

MaxRecordCount: 9000

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: -104.05500787899996
YMin: 42.49779657600004
XMax: -96.45197178099994
YMax: 45.944879083000046
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 197, 255, 255]
Width: 2
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:
• TubeTypeCode ( type: esriFieldTypeInteger, alias: Tube Type, editable: true, nullable: true, defaultValue: null, modelName: TubeTypeCode , Coded Values: [1: Pipe] , [2: Box Culvert] , [3: Cattle Pass] , ...1 more... )
• TubeShapeCode ( type: esriFieldTypeInteger, alias: Tube Shape, editable: true, nullable: true, defaultValue: null, modelName: TubeShapeCode , Coded Values: [1: Round] , [2: Arch] , [3: Elliptical] , ...3 more... )
• CellCnt ( type: esriFieldTypeSmallInteger, alias: Cell Count, editable: true, nullable: true, defaultValue: null, modelName: CellCnt )
• TubeInchHgt ( type: esriFieldTypeDouble, alias: Tube Height (Inches), editable: true, nullable: true, defaultValue: null, modelName: TubeInchHgt )
• WidthDiameterInchLen ( type: esriFieldTypeDouble, alias: Width Diameter (Inches), editable: true, nullable: true, defaultValue: null, modelName: WidthDiameterInchLen )
• TubeFeetLen ( type: esriFieldTypeDouble, alias: Tube Length (Feet), editable: true, nullable: true, defaultValue: null, modelName: TubeFeetLen )
• MaterialCode ( type: esriFieldTypeInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: MaterialCode , Coded Values: [1: Concrete] , [2: Galv Steel] , [3: Alum Steel] , ...12 more... )
• TubeGuid ( type: esriFieldTypeGUID, alias: TubeGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TubeGuid )
• GroupGuid ( type: esriFieldTypeGUID, alias: GroupGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroupGuid )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• LastUpdateUser ( type: esriFieldTypeString, alias: LastUpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdateUser )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GroupGlobalID ( type: esriFieldTypeGUID, alias: GroupGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroupGlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
Templates:
• Name: CulvertTube
  Description:
  Prototype:
  GroupGlobalID: null
  TubeTypeCode: null
  TubeShapeCode: null
  CellCnt: null
  TubeInchHgt: null
  WidthDiameterInchLen: null
  TubeFeetLen: null
  MaterialCode: null
  TubeGuid: null
  GroupGuid: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• TubeHasCondition (4) -- Related To: TubeCondition (4)
• TubeBelongsToGroup (2) -- Related To: CulvertGroup (0)

Tables:

Table: EndCondition (3)

Name: EndCondition

Display Field: EndSeparatedDesc

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9d1245fb8e0941acb6508ae15532b6c7

Copyright Text:

Default Visibility: false

MaxRecordCount: 9000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• ErosionCode ( type: esriFieldTypeInteger, alias: Erosion, editable: true, nullable: true, defaultValue: null, modelName: ErosionCode , Coded Values: [1: None] , [2: Mild Inside ROW] , [3: Mild Outside ROW] , ...5 more... )
• PluggedCode ( type: esriFieldTypeInteger, alias: Plugged, editable: true, nullable: true, defaultValue: null, modelName: PluggedCode , Coded Values: [0: None] , [1: Less than 25%] , [2: 25-50%] , ...4 more... )
• InslopeCavityCode ( type: esriFieldTypeInteger, alias: Inslope Cavity, editable: true, nullable: true, defaultValue: null, modelName: InslopeCavityCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• InslopeCavityFeetLen ( type: esriFieldTypeDouble, alias: Inslope Cavity Distance from Fog Line (ft), editable: true, nullable: true, defaultValue: null, modelName: InslopeCavityFeetLen )
• EndSeparatedCode ( type: esriFieldTypeInteger, alias: Joint Separated Severity, editable: true, nullable: true, defaultValue: null, modelName: EndSeparatedCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• EndSeparatedDesc ( type: esriFieldTypeString, alias: # of Joints Separated, editable: true, nullable: true, length: 30, defaultValue: null, modelName: EndSeparatedDesc )
• PipingCode ( type: esriFieldTypeInteger, alias: Piping, editable: true, nullable: true, defaultValue: null, modelName: PipingCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• MaterialDistressCode ( type: esriFieldTypeInteger, alias: Material Distress, editable: true, nullable: true, defaultValue: null, modelName: MaterialDistressCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• WaterLevelCode ( type: esriFieldTypeInteger, alias: Water Level, editable: true, nullable: true, defaultValue: null, modelName: WaterLevelCode , Coded Values: [0: None] , [1: Below Culvert] , [2: Culvert Partly Filled] , ...2 more... )
• ChannelCleanoutDesc ( type: esriFieldTypeString, alias: Channel Cleanout Needed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ChannelCleanoutDesc )
• PerchedCode ( type: esriFieldTypeInteger, alias: Perched, editable: true, nullable: true, defaultValue: null, modelName: PerchedCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• DamageCode ( type: esriFieldTypeInteger, alias: Damaged, editable: true, nullable: true, defaultValue: null, modelName: DamageCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• CommentDesc ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CommentDesc )
• EndGuid ( type: esriFieldTypeGUID, alias: EndGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: EndGuid )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• LastUpdateUser ( type: esriFieldTypeString, alias: LastUpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdateUser )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• EndGlobalID ( type: esriFieldTypeGUID, alias: EndGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: EndGlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Templates:
• Name: EndCondition
  Description:
  Prototype:
  EndGlobalID: null
  ErosionCode: null
  PluggedCode: null
  InslopeCavityCode: null
  InslopeCavityFeetLen: null
  EndSeparatedCode: null
  EndSeparatedDesc: null
  PipingCode: null
  MaterialDistressCode: null
  WaterLevelCode: null
  ChannelCleanoutDesc: null
  PerchedCode: null
  DamageCode: null
  CommentDesc: null
  EndGuid: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ConditionBelongsToEnd (3) -- Related To: CulvertEnd (1)

Table: TubeCondition (4)

Name: TubeCondition

Display Field: InfiltrationDesc

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9d1245fb8e0941acb6508ae15532b6c7

Copyright Text:

Default Visibility: false

MaxRecordCount: 9000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• DamageCode ( type: esriFieldTypeInteger, alias: Damage, editable: true, nullable: true, defaultValue: null, modelName: DamageCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• CrushedCode ( type: esriFieldTypeInteger, alias: Crushed, editable: true, nullable: true, defaultValue: null, modelName: CrushedCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• PluggedCode ( type: esriFieldTypeInteger, alias: Plugged, editable: true, nullable: true, defaultValue: null, modelName: PluggedCode , Coded Values: [0: None] , [1: Less than 25%] , [2: 25-50%] , ...4 more... )
• InfiltrationDesc ( type: esriFieldTypeString, alias: Infiltration Description, editable: true, nullable: true, length: 30, defaultValue: null, modelName: InfiltrationDesc )
• TubeSeparatedCode ( type: esriFieldTypeInteger, alias: Joint Separated Severity, editable: true, nullable: true, defaultValue: null, modelName: TubeSeparatedCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• TubeSeparatedDesc ( type: esriFieldTypeString, alias: Joint Separated Location, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TubeSeparatedDesc )
• RoadwayStressCode ( type: esriFieldTypeInteger, alias: Roadway Stress, editable: true, nullable: true, defaultValue: null, modelName: RoadwayStressCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• RoadwayVoidCode ( type: esriFieldTypeInteger, alias: Roadway Void, editable: true, nullable: true, defaultValue: null, modelName: RoadwayVoidCode , Coded Values: [0: No] , [1: Yes] , [2: Unknown] )
• MisalignmentCode ( type: esriFieldTypeInteger, alias: Misalignment, editable: true, nullable: true, defaultValue: null, modelName: MisalignmentCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• PipingCode ( type: esriFieldTypeInteger, alias: Piping, editable: true, nullable: true, defaultValue: null, modelName: PipingCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• MaterialDistressCode ( type: esriFieldTypeInteger, alias: Material Distress, editable: true, nullable: true, defaultValue: null, modelName: MaterialDistressCode , Coded Values: [0: None] , [1: Mild] , [2: Moderate] , ...2 more... )
• WaterLevelCode ( type: esriFieldTypeInteger, alias: Water Level, editable: true, nullable: true, defaultValue: null, modelName: WaterLevelCode , Coded Values: [0: None] , [1: Below Culvert] , [2: Culvert Partly Filled] , ...2 more... )
• CommentDesc ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CommentDesc )
• TubeGuid ( type: esriFieldTypeGUID, alias: TubeGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TubeGuid )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• LastUpdateUser ( type: esriFieldTypeString, alias: LastUpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdateUser )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• TubeGlobalID ( type: esriFieldTypeGUID, alias: TubeGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: TubeGlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Templates:
• Name: TubeCondition
  Description:
  Prototype:
  TubeGlobalID: null
  DamageCode: null
  CrushedCode: null
  PluggedCode: null
  InfiltrationDesc: null
  TubeSeparatedCode: null
  TubeSeparatedDesc: null
  RoadwayStressCode: null
  RoadwayVoidCode: null
  MisalignmentCode: null
  PipingCode: null
  MaterialDistressCode: null
  WaterLevelCode: null
  CommentDesc: null
  TubeGuid: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ConditionBelongsToTube (4) -- Related To: CulvertTube (2)

Table: GroupInspection (5)

Name: GroupInspection

Display Field: ProjectDesc

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9d1245fb8e0941acb6508ae15532b6c7

Copyright Text:

Default Visibility: false

MaxRecordCount: 9000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• InspectionTypeCode ( type: esriFieldTypeInteger, alias: Inspection Type, editable: true, nullable: true, defaultValue: null, modelName: InspectionTypeCode , Coded Values: [1: Scheduled] , [2: Special] , [3: Work Completion] , ...2 more... )
• ProjectDesc ( type: esriFieldTypeString, alias: PCN, Contract Number, or Maintenance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectDesc )
• WorkDesc ( type: esriFieldTypeString, alias: Work Completed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkDesc )
• InspectionGUID ( type: esriFieldTypeGUID, alias: InspectionGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: InspectionGUID )
• GroupGUID ( type: esriFieldTypeGUID, alias: GroupGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroupGUID )
• CreateDate ( type: esriFieldTypeDate, alias: CreateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• CreateUser ( type: esriFieldTypeString, alias: CreateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreateUser )
• LastUpdateDate ( type: esriFieldTypeDate, alias: LastUpdateDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdateDate )
• LastUpdateUser ( type: esriFieldTypeString, alias: LastUpdateUser, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastUpdateUser )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• GroupGlobalID ( type: esriFieldTypeGUID, alias: GroupGlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GroupGlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Templates:
• Name: GroupInspection
  Description:
  Prototype:
  GroupGlobalID: null
  InspectionDate: null
  InspectionTypeCode: null
  ProjectDesc: null
  WorkDesc: null
  InspectionGUID: null
  GroupGUID: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• InspectionBelongsToGroup (1) -- Related To: CulvertGroup (0)