Name: Culvert Inspection

Display Field: PID

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PID ( type: esriFieldTypeInteger, alias: PID, editable: true, nullable: true, defaultValue: null, modelName: PID )
• IN_TREATMENT ( type: esriFieldTypeString, alias: INLET TREATMENT, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: IN_TREATMENT , Coded Values: [NONE: No Treatment] , [DI: Drop Inlet] , [FLARE: Flared] , ...9 more... )
• IN_TIE ( type: esriFieldTypeString, alias: INLET TIE-IN, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: IN_TIE , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• IN_EXTENSION ( type: esriFieldTypeString, alias: INLET EXTENSION, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: IN_EXTENSION , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• IN_MARKER_POST ( type: esriFieldTypeString, alias: INLET MARKER POST, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IN_MARKER_POST , Coded Values: [YES: YES] , [NO: NO] , [NA: NON-APPLICABLE] , ...1 more... )
• IN_SEPARATION ( type: esriFieldTypeString, alias: INLET SEPARATION, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: IN_SEPARATION , Coded Values: [NONE: NONE] , [MINOR: MINOR] , [MODERATE: MODERATE] , ...2 more... )
• IN_CONDITION ( type: esriFieldTypeString, alias: INLET CONDITION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: IN_CONDITION , Coded Values: [GOOD: GOOD] , [FAIR: FAIR] , [POOR: POOR] , ...2 more... )
• IN_SEDIMENT ( type: esriFieldTypeString, alias: INLET SEDIMENT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: IN_SEDIMENT , Coded Values: [NONE: NONE] , [LIGHT: LIGHT] , [MOD: MODERATE] , ...3 more... )
• IN_EROSION ( type: esriFieldTypeString, alias: INLET EROSION, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: IN_EROSION , Coded Values: [NONE: NONE] , [LIGHT: LIGHT] , [MOD: MODERATE] , ...2 more... )
• IN_PIPING ( type: esriFieldTypeString, alias: INLET PIPING, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: IN_PIPING , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• IN_COMMENT ( type: esriFieldTypeString, alias: INLET COMMENT, editable: true, nullable: true, length: 230, defaultValue: null, modelName: IN_COMMENT )
• DRAIN_TYPE ( type: esriFieldTypeString, alias: DRAIN TYPE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DRAIN_TYPE , Coded Values: [CROSS: Cross] , [LAT: Lateral] , [SLOPE: Slope] , ...8 more... )
• SYS_TYPE ( type: esriFieldTypeString, alias: SYSTEM TYPE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SYS_TYPE , Coded Values: [SINGL: Single Pipe] , [CLOSE: Closed System] )
• STRUC_TYPE ( type: esriFieldTypeString, alias: STRUCTURE TYPE, editable: true, nullable: true, length: 15, defaultValue: RND, modelName: STRUC_TYPE , Coded Values: [RND: Round] , [BOX: Box] , [SQUASH: Squashed] , ...3 more... )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MATERIAL , Coded Values: [STONE: Stone] , [HDPE: HDPE] , [PVC: PVC] , ...4 more... )
• SIZE ( type: esriFieldTypeSmallInteger, alias: SIZE, editable: true, nullable: true, defaultValue: null, modelName: SIZE , Coded Values: [12: 12] , [15: 15] , [18: 18] , ...11 more... )
• HEIGHT ( type: esriFieldTypeSmallInteger, alias: OTHER HEIGHT, editable: true, nullable: true, defaultValue: null, modelName: HEIGHT , Range: [-99, 100] )
• WIDTH ( type: esriFieldTypeSmallInteger, alias: OTHER WIDTH, editable: true, nullable: true, defaultValue: null, modelName: WIDTH , Range: [-99, 100] )
• FILL_DEPTH ( type: esriFieldTypeSmallInteger, alias: FILL DEPTH, editable: true, nullable: true, defaultValue: null, modelName: FILL_DEPTH )
• ELBOWS ( type: esriFieldTypeString, alias: ELBOWS, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: ELBOWS , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• MODS ( type: esriFieldTypeString, alias: MODIFICATIONS, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: MODS , Coded Values: [NONE: None] , [CIPP: Curred in Place Ln] , [SLEEVE: Sleeve] , ...4 more... )
• PIPE_SEPARATION ( type: esriFieldTypeString, alias: PIPE SEPARATION, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: PIPE_SEPARATION , Coded Values: [NONE: NONE] , [MINOR: MINOR] , [MODERATE: MODERATE] , ...2 more... )
• BARL_SEPARATION ( type: esriFieldTypeString, alias: BARREL SEPARATION, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: BARL_SEPARATION , Coded Values: [NONE: NONE] , [MINOR: MINOR] , [MODERATE: MODERATE] , ...2 more... )
• BARL_CONDITION ( type: esriFieldTypeString, alias: BARREL CONDITION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BARL_CONDITION , Coded Values: [GOOD: GOOD] , [FAIR: FAIR] , [POOR: POOR] , ...2 more... )
• BARL_SEDIMENT ( type: esriFieldTypeString, alias: BARREL SEDIMENT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BARL_SEDIMENT , Coded Values: [NONE: NONE] , [LIGHT: LIGHT] , [MOD: MODERATE] , ...3 more... )
• BARL_COMMENT ( type: esriFieldTypeString, alias: BARREL COMMENT, editable: true, nullable: true, length: 230, defaultValue: null, modelName: BARL_COMMENT )
• OUT_TREATMENT ( type: esriFieldTypeString, alias: OUTLET TREATMENT, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: OUT_TREATMENT , Coded Values: [NONE: No Treatment] , [DI: Drop Inlet] , [FLARE: Flared] , ...9 more... )
• OUT_EXTENSION ( type: esriFieldTypeString, alias: OUTLET EXTENSION, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: OUT_EXTENSION , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• OUT_TIE ( type: esriFieldTypeString, alias: OUTLET TIE-IN, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: OUT_TIE , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• OUT_MARKER_POST ( type: esriFieldTypeString, alias: OUTLET MARKER POST, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OUT_MARKER_POST , Coded Values: [YES: YES] , [NO: NO] , [NA: NON-APPLICABLE] , ...1 more... )
• OUT_SEPARATION ( type: esriFieldTypeString, alias: OUTLET SEPARATION, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: OUT_SEPARATION , Coded Values: [NONE: NONE] , [MINOR: MINOR] , [MODERATE: MODERATE] , ...2 more... )
• OUT_CONDITION ( type: esriFieldTypeString, alias: OUTLET CONDITION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OUT_CONDITION , Coded Values: [GOOD: GOOD] , [FAIR: FAIR] , [POOR: POOR] , ...2 more... )
• OUT_SEDIMENT ( type: esriFieldTypeString, alias: OUTLET SEDIMENT, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OUT_SEDIMENT , Coded Values: [NONE: NONE] , [LIGHT: LIGHT] , [MOD: MODERATE] , ...3 more... )
• OUT_EROSION ( type: esriFieldTypeString, alias: OUTLET EROSION, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: OUT_EROSION , Coded Values: [NONE: NONE] , [LIGHT: LIGHT] , [MOD: MODERATE] , ...2 more... )
• OUT_PIPING ( type: esriFieldTypeString, alias: OUTLET PIPING, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: OUT_PIPING , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• OUT_COMMENT ( type: esriFieldTypeString, alias: OUTLET COMMENT, editable: true, nullable: true, length: 230, defaultValue: null, modelName: OUT_COMMENT )
• PROJECTED_END ( type: esriFieldTypeString, alias: PROJECTED END, editable: true, nullable: true, length: 15, defaultValue: NO, modelName: PROJECTED_END , Coded Values: [YES: YES] , [NO: NO] , [UNKNW: UNKNOWN] )
• STONE_PAD ( type: esriFieldTypeString, alias: STONE PAD, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STONE_PAD , Coded Values: [YES: YES] , [NO: NO] , [NA: NON-APPLICABLE] , ...1 more... )
• ROAD_SETTLING ( type: esriFieldTypeString, alias: ROAD SETTLING, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: ROAD_SETTLING , Coded Values: [NONE: NONE] , [REPAIR: REPAIR] , [GRADE: GRADE CHANGE] )
• SINK_HOLES ( type: esriFieldTypeString, alias: SINK HOLES, editable: true, nullable: true, length: 15, defaultValue: NONE, modelName: SINK_HOLES , Coded Values: [NONE: NONE] , [MINOR: MINOR] , [MODERATE: MODERATE] , ...2 more... )
• GEN_COMMENT ( type: esriFieldTypeString, alias: GENERAL COMMENT, editable: true, nullable: true, length: 230, defaultValue: null, modelName: GEN_COMMENT )
• STRUCTURAL_RATING ( type: esriFieldTypeString, alias: STRUCTURAL RATING, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STRUCTURAL_RATING , Coded Values: [No Action Needed - GREEN: No Action Needed - GREEN] , [Monitor - YELLOW: Monitor - YELLOW] , [Action Needed - RED: Action Needed - RED] )
• FUNCTIONAL_RATING ( type: esriFieldTypeString, alias: FUNCTIONAL RATING, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FUNCTIONAL_RATING , Coded Values: [No Action Needed - GREEN: No Action Needed - GREEN] , [Monitor - YELLOW: Monitor - YELLOW] , [Action Needed - RED: Action Needed - RED] )
• FUNCTIONAL_STATUS ( type: esriFieldTypeString, alias: FUNCTIONAL STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FUNCTIONAL_STATUS , Coded Values: [ABANDONED: ABANDONED] , [DISCONTINUED: DISCONTINUED] , [FILLED: FILLED] , ...1 more... )
• NEW_DATA_TYPE ( type: esriFieldTypeString, alias: NEW DATA TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NEW_DATA_TYPE , Coded Values: [Replacement: Replacement] , [New Construction: New Construction] , [Discovered: Discovered] )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, editable: true, nullable: true, length: 30, defaultValue: null, modelName: INSPECTOR )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: INSPECTION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_INSPECTION_DATE )
• IN_PHOTO ( type: esriFieldTypeString, alias: IN_PHOTO, editable: true, nullable: true, length: 230, defaultValue: null, modelName: IN_PHOTO )
• OUT_PHOTO ( type: esriFieldTypeString, alias: OUT_PHOTO, editable: true, nullable: true, length: 230, defaultValue: null, modelName: OUT_PHOTO )
• SPEC_EQUIP ( type: esriFieldTypeString, alias: Special Equipment Used, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HIVE , Coded Values: [N: None] , [H: HIVE] , [C: Crawler Van] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Culvert Inspection
  Description:
  Prototype:
  OUT_PHOTO: null
  SPEC_EQUIP: null
  PID: null
  IN_TREATMENT: NONE
  IN_TIE: NO
  IN_EXTENSION: NO
  IN_MARKER_POST: null
  IN_SEPARATION: NONE
  IN_CONDITION: null
  IN_SEDIMENT: null
  IN_EROSION: NONE
  IN_PIPING: NO
  IN_COMMENT: null
  DRAIN_TYPE: null
  SYS_TYPE: null
  STRUC_TYPE: RND
  MATERIAL: null
  SIZE: null
  HEIGHT: null
  WIDTH: null
  FILL_DEPTH: null
  ELBOWS: NO
  MODS: NONE
  PIPE_SEPARATION: NONE
  BARL_SEPARATION: NONE
  BARL_CONDITION: null
  BARL_SEDIMENT: null
  BARL_COMMENT: null
  OUT_TREATMENT: NONE
  OUT_EXTENSION: NO
  OUT_TIE: NO
  OUT_MARKER_POST: null
  OUT_SEPARATION: NONE
  OUT_CONDITION: null
  OUT_SEDIMENT: null
  OUT_EROSION: NONE
  OUT_PIPING: NO
  OUT_COMMENT: null
  PROJECTED_END: NO
  STONE_PAD: null
  ROAD_SETTLING: NONE
  SINK_HOLES: NONE
  GEN_COMMENT: null
  STRUCTURAL_RATING: null
  FUNCTIONAL_RATING: null
  FUNCTIONAL_STATUS: null
  NEW_DATA_TYPE: null
  INSPECTOR: null
  INSPECTION_DATE: null
  IN_PHOTO: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Culvert (0) -- Related To: Small Culverts (0)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata