View In:   ArcGIS Online Map Viewer

Name: Culvert Inspection

Display Field: insp_type_cd

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3000000.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: -90.19047115099994
YMin: 41.70284871000007
XMax: -82.44074895899996
YMax: 47.47957516900004
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 170, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AssetGUID ( type: esriFieldTypeGUID, alias: AssetGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: AssetGUID )
• insp_type_cd ( type: esriFieldTypeSmallInteger, alias: Inspection Type, editable: true, nullable: true, defaultValue: null, modelName: insp_type_cd , Coded Values: [1: Routine] , [2: Damage] , [3: New Construction] , ...4 more... )
• insp_field_vrfy_date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_field_vrfy_date )
• insp_user_cd ( type: esriFieldTypeString, alias: Inspection User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: insp_user_cd )
• insp_cmpy_cd ( type: esriFieldTypeSmallInteger, alias: Inspection Company, editable: true, nullable: true, defaultValue: null, modelName: insp_cmpy_cd , Coded Values: [1: MDOT] , [2: HNTB] , [3: Collins] , ...6 more... )
• insp_comm ( type: esriFieldTypeString, alias: Inspection Comments, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: insp_comm )
• insp_cret_uid ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: insp_cret_uid )
• insp_cret_tmsp ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_cret_tmsp )
• insp_updt_uid ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: insp_updt_uid )
• insp_updt_tmsp ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_updt_tmsp )
• water_depth_inlet ( type: esriFieldTypeDouble, alias: Water Depth Inlet (inches), editable: true, nullable: true, defaultValue: null, modelName: water_depth_inlet )
• water_depth_outlet ( type: esriFieldTypeDouble, alias: Water Depth Outlet (inches), editable: true, nullable: true, defaultValue: null, modelName: water_depth_outlet )
• hdwl_elmt_rtg_status_cd ( type: esriFieldTypeSmallInteger, alias: Was the Headwall Element rated?, editable: true, nullable: true, defaultValue: null, modelName: hdwl_elmt_rtg_status_cd , Coded Values: [1: N/R - Not Applicable] , [2: N/R - Not Accessible] , [3: Rating Conducted] , ...1 more... )
• hdwl_elmt_rtg_comm ( type: esriFieldTypeString, alias: Headwall Element Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: hdwl_elmt_rtg_comm )
• hdwl_elmt_rtg_good ( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Good (Each), editable: true, nullable: true, defaultValue: null, modelName: hdwl_elmt_rtg_good )
• hdwl_elmt_rtg_fair ( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Fair (Each), editable: true, nullable: true, defaultValue: null, modelName: hdwl_elmt_rtg_fair )
• hdwl_elmt_rtg_poor ( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Poor (Each), editable: true, nullable: true, defaultValue: null, modelName: hdwl_elmt_rtg_poor )
• hdwl_elmt_rtg_severe ( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Severe (Each), editable: true, nullable: true, defaultValue: null, modelName: hdwl_elmt_rtg_severe )
• wngwl_elmt_rtg_status_cd ( type: esriFieldTypeSmallInteger, alias: Was the Wingwall Element rated?, editable: true, nullable: true, defaultValue: null, modelName: wngwl_elmt_rtg_status_cd , Coded Values: [1: N/R - Not Applicable] , [2: N/R - Not Accessible] , [3: Rating Conducted] , ...1 more... )
• wngwl_elmt_rtg_comm ( type: esriFieldTypeString, alias: Wingwall Element Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: wngwl_elmt_rtg_comm )
• wngwl_elmt_rtg_good ( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Good (Each), editable: true, nullable: true, defaultValue: null, modelName: wngwl_elmt_rtg_good )
• wngwl_elmt_rtg_fair ( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Fair (Each), editable: true, nullable: true, defaultValue: null, modelName: wngwl_elmt_rtg_fair )
• wngwl_elmt_rtg_poor ( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Poor (Each), editable: true, nullable: true, defaultValue: null, modelName: wngwl_elmt_rtg_poor )
• wngwl_elmt_rtg_severe ( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Severe (Each), editable: true, nullable: true, defaultValue: null, modelName: wngwl_elmt_rtg_severe )
• scour_elmt_rtg_status_cd ( type: esriFieldTypeSmallInteger, alias: Was the Scour Element rated?, editable: true, nullable: true, defaultValue: null, modelName: scour_elmt_rtg_status_cd , Coded Values: [1: N/R - Not Applicable] , [2: N/R - Not Accessible] , [3: Rating Conducted] , ...1 more... )
• scour_elmt_rtg_comm ( type: esriFieldTypeString, alias: Scour Element Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: scour_elmt_rtg_comm )
• scour_elmt_rtg_good ( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Good (Each), editable: true, nullable: true, defaultValue: null, modelName: scour_elmt_rtg_good )
• scour_elmt_rtg_fair ( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Fair (Each), editable: true, nullable: true, defaultValue: null, modelName: scour_elmt_rtg_fair )
• scour_elmt_rtg_poor ( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Poor (Each), editable: true, nullable: true, defaultValue: null, modelName: scour_elmt_rtg_poor )
• scour_elmt_rtg_severe ( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Severe (Each), editable: true, nullable: true, defaultValue: null, modelName: scour_elmt_rtg_severe )
• joint_elmt_rtg_status_cd ( type: esriFieldTypeSmallInteger, alias: Was Joints Element Rated?, editable: true, nullable: true, defaultValue: null, modelName: joint_elmt_rtg_status_cd , Coded Values: [1: N/R - Not Applicable] , [2: N/R - Not Accessible] , [3: Rating Conducted] , ...1 more... )
• joint_elmt_rtg_comm ( type: esriFieldTypeString, alias: Joints Element Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: joint_elmt_rtg_comm )
• joint_elmt_rtg_good ( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Good (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: joint_elmt_rtg_good )
• joint_elmt_rtg_fair ( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Fair (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: joint_elmt_rtg_fair )
• joint_elmt_rtg_poor ( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Poor (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: joint_elmt_rtg_poor )
• joint_elmt_rtg_severe ( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Severe (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: joint_elmt_rtg_severe )
• barl_elmt_rtg_cd ( type: esriFieldTypeSmallInteger, alias: Was Barrel Element Rated?, editable: true, nullable: true, defaultValue: null, modelName: barl_elmt_rtg_cd , Coded Values: [1: N/R - Not Applicable] , [2: N/R - Not Accessible] , [3: Rating Conducted] , ...1 more... )
• barl_elmt_rtg_comm ( type: esriFieldTypeString, alias: Barrel Element Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: barl_elmt_rtg_comm )
• barl_elmt_rtg_good ( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Good (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: barl_elmt_rtg_good )
• barl_elmt_rtg_fair ( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Fair (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: barl_elmt_rtg_fair )
• barl_elmt_rtg_poor ( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Poor (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: barl_elmt_rtg_poor )
• barl_elmt_rtg_severe ( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Severe (Length, feet), editable: true, nullable: true, defaultValue: null, modelName: barl_elmt_rtg_severe )
• culv_appr_cpnt_rtg_cd ( type: esriFieldTypeSmallInteger, alias: Culvert Approach Roadway and Embankment Component Rating, editable: true, nullable: true, defaultValue: null, modelName: culv_appr_cpnt_rtg_cd , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• culv_appr_cpnt_comm ( type: esriFieldTypeString, alias: Culvert Approach Roadway and Embankment Component Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: culv_appr_cpnt_comm )
• culv_chnl_cpnt_rtg_cd ( type: esriFieldTypeSmallInteger, alias: Culvert Channel Component Rating, editable: true, nullable: true, defaultValue: null, modelName: culv_chnl_cpnt_rtg_cd , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• culv_chnl_chnl_comm ( type: esriFieldTypeString, alias: Culvert Channel Component Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: culv_chnl_chnl_comm )
• culv_strc_cpnt_rtg_cd ( type: esriFieldTypeSmallInteger, alias: Culvert Structure Component Rating, editable: true, nullable: true, defaultValue: null, modelName: culv_strc_cpnt_rtg_cd , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• culv_strc_strc_comm ( type: esriFieldTypeString, alias: Culvert Structure Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: culv_strc_strc_comm )
• culv_end_cpnt_rtg_cd ( type: esriFieldTypeSmallInteger, alias: Culvert End Treatment Component Rating, editable: true, nullable: true, defaultValue: null, modelName: culv_end_cpnt_rtg_cd , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• culv_end_cpnt_comm ( type: esriFieldTypeString, alias: Culvert End Treatment Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: culv_end_cpnt_comm )
• culv_cpnt_rtg_cd ( type: esriFieldTypeSmallInteger, alias: Culvert Component (Calculated Min), editable: true, nullable: true, defaultValue: null, modelName: culv_cpnt_rtg_cd , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• next_insp_freq ( type: esriFieldTypeDouble, alias: Next Inspection Frequency, editable: true, nullable: true, defaultValue: null, modelName: next_insp_freq )
• just_comm ( type: esriFieldTypeString, alias: Justification Comment for Next Inspection Frequency, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: just_comm )
• qc_stat_cd ( type: esriFieldTypeSmallInteger, alias: QC Status (Calculated from QA/QC Related Table), editable: true, nullable: true, defaultValue: null, modelName: qc_stat_cd , Coded Values: [0: QC Not Started] , [1: QC Rejected - Issues to Address] , [2: QC Complete - Accepted] , ...4 more... )
• qa_stat_cd ( type: esriFieldTypeSmallInteger, alias: QA Status (Calculated from QA/QC Related Table), editable: true, nullable: true, defaultValue: null, modelName: qa_stat_cd , Coded Values: [0: QA Not Started] , [4: QA Rejected - Issues to Address] , [5: QA Complete - Accepted] , ...1 more... )
• inlet_sfty_grate_cd ( type: esriFieldTypeSmallInteger, alias: Safety grate or trash rack present at inlet?, editable: true, nullable: true, defaultValue: null, modelName: inlet_sfty_grate_cd , Coded Values: [1: Yes] , [2: No] )
• outlet_sfty_grate_cd ( type: esriFieldTypeSmallInteger, alias: Safety grate or trash rack present at outlet?, editable: true, nullable: true, defaultValue: null, modelName: outlet_sfty_grate_cd , Coded Values: [1: Yes] , [2: No] )
• insp_complete_cd ( type: esriFieldTypeString, alias: Inspection Complete?, editable: true, nullable: true, length: 255, defaultValue: In Progress, modelName: insp_complete_cd , Coded Values: [In Progress: In Progress] , [Ready for QC: Ready for QC] )
• 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 )

Templates:

• Name: Culvert Inspection
  Description:
  Prototype:
  insp_complete_cd: In Progress
  outlet_sfty_grate_cd: null
  AssetGUID: null
  insp_type_cd: null
  insp_field_vrfy_date: null
  insp_user_cd: null
  insp_cmpy_cd: null
  insp_comm: null
  insp_cret_uid: null
  insp_cret_tmsp: null
  insp_updt_uid: null
  insp_updt_tmsp: null
  water_depth_inlet: null
  water_depth_outlet: null
  hdwl_elmt_rtg_status_cd: null
  hdwl_elmt_rtg_comm: null
  hdwl_elmt_rtg_good: null
  hdwl_elmt_rtg_fair: null
  hdwl_elmt_rtg_poor: null
  hdwl_elmt_rtg_severe: null
  wngwl_elmt_rtg_status_cd: null
  wngwl_elmt_rtg_comm: null
  wngwl_elmt_rtg_good: null
  wngwl_elmt_rtg_fair: null
  wngwl_elmt_rtg_poor: null
  wngwl_elmt_rtg_severe: null
  scour_elmt_rtg_status_cd: null
  scour_elmt_rtg_comm: null
  scour_elmt_rtg_good: null
  scour_elmt_rtg_fair: null
  scour_elmt_rtg_poor: null
  scour_elmt_rtg_severe: null
  joint_elmt_rtg_status_cd: null
  joint_elmt_rtg_comm: null
  joint_elmt_rtg_good: null
  joint_elmt_rtg_fair: null
  joint_elmt_rtg_poor: null
  joint_elmt_rtg_severe: null
  barl_elmt_rtg_cd: null
  barl_elmt_rtg_comm: null
  barl_elmt_rtg_good: null
  barl_elmt_rtg_fair: null
  barl_elmt_rtg_poor: null
  barl_elmt_rtg_severe: null
  culv_appr_cpnt_rtg_cd: null
  culv_appr_cpnt_comm: null
  culv_chnl_cpnt_rtg_cd: null
  culv_chnl_chnl_comm: null
  culv_strc_cpnt_rtg_cd: null
  culv_strc_strc_comm: null
  culv_end_cpnt_rtg_cd: null
  culv_end_cpnt_comm: null
  culv_cpnt_rtg_cd: null
  next_insp_freq: null
  just_comm: null
  qc_stat_cd: null
  qa_stat_cd: null
  inlet_sfty_grate_cd: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspectionQAQC (2) -- Related To: Culvert Inspection QA/QC (10)
• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (3) -- Related To: Culvert Inventory (11)

Capabilities: Query

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

Child Resources:   Field Groups   Contingent Values

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