Layers:

Layer: Culvert Work Rec (13)

Name: Culvert Work Rec

Display Field: fc_fs_recm_typ_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.70284597700004
XMax: -71.05827446099994
YMax: 47.479681293000056
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: 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 )
• InspGUID ( type: esriFieldTypeGUID, alias: InspGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: InspGUID )
• fc_fs_recm_typ_cd ( type: esriFieldTypeSmallInteger, alias: Culvert Work Recommendation Type, editable: true, nullable: true, defaultValue: null, modelName: fc_fs_recm_typ_cd , Coded Values: [1: Channel – Install/Repair Scour Countermeasures (Rock, CF)] , [2: Channel - Monitor Scour] , [3: Substructure - Repair Abutment / Wings / Headwall (Concrete, CF)] , ...13 more... )
• work_recm_type_other ( type: esriFieldTypeString, alias: If other, please describe. , editable: true, nullable: true, length: 255, defaultValue: null, modelName: work_recm_type_other )
• fc_fs_recm_comm ( type: esriFieldTypeString, alias: Work Recommendation Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: fc_fs_recm_comm )
• insptype ( type: esriFieldTypeSmallInteger, alias: Inspection Type, editable: true, nullable: true, defaultValue: null, modelName: insptype , Coded Values: [1: Routine] , [2: Damage] , [3: New Construction] , ...4 more... )
• work_rec_stat_cd ( type: esriFieldTypeSmallInteger, alias: Work Recommendation Status, editable: true, nullable: true, defaultValue: null, modelName: work_rec_stat_cd , Coded Values: [0: Open] , [10: Assigned] , [20: Complete] )
• work_rect_cmpt_date ( type: esriFieldTypeDate, alias: Work Recommendation Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: work_rect_cmpt_date )
• qty_matl ( type: esriFieldTypeDouble, alias: Estimated Quantity of Primary Material Needed for Work Rec, editable: true, nullable: true, defaultValue: null, modelName: qty_matl )
• 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_qc_stat_cd ( type: esriFieldTypeSmallInteger, alias: Inspection QC Status, editable: true, nullable: true, defaultValue: null, modelName: insp_qc_stat_cd , Coded Values: [0: QC Not Started] , [1: QC Rejected - Issues to Address] , [2: QC Complete - Accepted] , ...4 more... )
• insp_qa_stat_cd ( type: esriFieldTypeSmallInteger, alias: Inspection QA Status, editable: true, nullable: true, defaultValue: null, modelName: insp_qa_stat_cd , Coded Values: [0: QA Not Started] , [4: QA Rejected - Issues to Address] , [5: QA Complete - Accepted] , ...1 more... )
• 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 )
• mdot_regn_cd ( type: esriFieldTypeSmallInteger, alias: MDOT Region, editable: true, nullable: true, defaultValue: null, modelName: mdot_regn_cd , Coded Values: [1: Superior] , [2: North] , [3: Grand] , ...4 more... )
• mdot_tsc_cd ( type: esriFieldTypeInteger, alias: TSC, editable: true, nullable: true, defaultValue: null, modelName: mdot_tsc_cd , Coded Values: [22: Newberry] , [19: Marshall] , [1: Alpena] , ...19 more... )
Templates:
• Name: Culvert Work Rec
  Description:
  Prototype:
  mdot_regn_cd: null
  mdot_tsc_cd: null
  AssetGUID: null
  InspGUID: null
  fc_fs_recm_typ_cd: null
  work_recm_type_other: null
  fc_fs_recm_comm: null
  insptype: null
  work_rec_stat_cd: null
  work_rect_cmpt_date: null
  qty_matl: null
  insp_cmpy_cd: null
  insp_qc_stat_cd: null
  insp_qa_stat_cd: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (0) -- Related To: Culvert Inventory (11)

Layer: Culvert RFA (12)

Name: Culvert RFA

Display Field: insp_name

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: -89.93646880599994
YMin: 41.739949445000036
XMax: -82.53193682199998
YMax: 47.47914603600003
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSSquare
Color: [0, 255, 197, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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_name ( type: esriFieldTypeString, alias: Inspector Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: insp_name )
• insp_cmpy_cd ( type: esriFieldTypeSmallInteger, alias: Inspector Company, editable: true, nullable: true, defaultValue: null, modelName: insp_cmpy_cd , Coded Values: [1: MDOT] , [2: HNTB] , [3: Collins] , ...6 more... )
• insp_date ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: insp_date )
• issue_desc ( type: esriFieldTypeString, alias: Problems/Comments/Explanation, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: issue_desc )
• imd_actn_req_type_cd ( type: esriFieldTypeSmallInteger, alias: Immediate Action Requested, editable: true, nullable: true, defaultValue: null, modelName: imd_actn_req_type_cd , Coded Values: [1: Close Lane(s)] , [2: Close Shoulder] , [3: Repair Culvert/Embankment] , ...3 more... )
• imd_actn_oth_desc ( type: esriFieldTypeString, alias: Immediate Action Request - If Other, describe:, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: imd_actn_oth_desc )
• imd_actn_assign_cd ( type: esriFieldTypeSmallInteger, alias: Immediate Action Requested By Assignee, editable: true, nullable: true, defaultValue: null, modelName: imd_actn_assign_cd , Coded Values: [1: Concrete Crew] , [2: Steel Crew] )
• imd_actn_rqstr ( type: esriFieldTypeString, alias: Immediate Action Requested By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: imd_actn_rqstr )
• imd_actn_rqst_date ( type: esriFieldTypeDate, alias: Immediate Action Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: imd_actn_rqst_date )
• imd_actn_req_comm ( type: esriFieldTypeString, alias: Immediate Action Request Comments, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: imd_actn_req_comm )
• imd_actn_cmptr ( type: esriFieldTypeString, alias: Immediate Action Completed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: imd_actn_cmptr )
• imd_actn_cmpt_date ( type: esriFieldTypeDate, alias: Immediate Action Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: imd_actn_cmpt_date )
• imd_actn_cmpt_comm ( type: esriFieldTypeString, alias: Immediate Action Completion Comments, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: imd_actn_cmpt_comm )
• imd_actn_clos_date ( type: esriFieldTypeDate, alias: Immediate Action Closure Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: imd_actn_clos_date )
• imd_actn_open_date ( type: esriFieldTypeDate, alias: Immediate Action Open Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: imd_actn_open_date )
• prmy_intrmd_actn_rqst_type_cd ( type: esriFieldTypeSmallInteger, alias: First Intermediate Action Requested, editable: true, nullable: true, defaultValue: null, modelName: prmy_intrmd_actn_rqst_type_cd , Coded Values: [1: Detailed Inspection] , [2: Damage Inspection] , [3: Repair Culvert/Embankment] , ...12 more... )
• prmy_intrmd_actn_oth_desc ( type: esriFieldTypeString, alias: First Intermediate Action - If Other, describe:, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: prmy_intrmd_actn_oth_desc )
• prmy_intrmd_actn_assign_cd ( type: esriFieldTypeSmallInteger, alias: First Intermediate Action Requested By Assignee, editable: true, nullable: true, defaultValue: null, modelName: prmy_intrmd_actn_assign_cd , Coded Values: [1: Concrete Crew] , [2: Steel Crew] )
• prmy_intrmd_actn_rqstr ( type: esriFieldTypeString, alias: First Intermediate Action Requested By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: prmy_intrmd_actn_rqstr )
• prmy_intrmd_actn_rqst_date ( type: esriFieldTypeDate, alias: First Intermediate Action Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: prmy_intrmd_actn_rqst_date )
• prmy_intrmd_actn_cntc_cd ( type: esriFieldTypeSmallInteger, alias: First Intermediate Action Contact, editable: true, nullable: true, defaultValue: null, modelName: prmy_intrmd_actn_cntc_cd , Coded Values: [1: BOBS - Culvert Specialist] , [2: BOBS - Geotechnical] , [3: TSC - Operations] , ...1 more... )
• prmy_intrmd_actn_cntc_comm ( type: esriFieldTypeString, alias: First Intermediate Action Contact Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: prmy_intrmd_actn_cntc_comm )
• prmy_intrmd_actn_cmptr ( type: esriFieldTypeString, alias: First Intermediate Action Completed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: prmy_intrmd_actn_cmptr )
• prmy_intrmd_actn_cmpt_date ( type: esriFieldTypeDate, alias: First Intermediate Action Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: prmy_intrmd_actn_cmpt_date )
• prmy_intrmd_actn_comments ( type: esriFieldTypeString, alias: First Intermediate Action Completion Comments, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: prmy_intrmd_actn_comments )
• secd_intrmd_actn_rqst_type_cd ( type: esriFieldTypeSmallInteger, alias: Second Intermediate Action Requested, editable: true, nullable: true, defaultValue: null, modelName: secd_intrmd_actn_rqst_type_cd , Coded Values: [1: Detailed Inspection] , [2: Damage Inspection] , [3: Repair Culvert/Embankment] , ...12 more... )
• secd_intrmd_actn_oth_desc ( type: esriFieldTypeString, alias: Second Intermediate Action - If Other, describe:, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: secd_intrmd_actn_oth_desc )
• secd_intrmd_actn_assign_cd ( type: esriFieldTypeSmallInteger, alias: Second Intermediate Action Requested By Assignee, editable: true, nullable: true, defaultValue: null, modelName: secd_intrmd_actn_assign_cd , Coded Values: [1: Concrete Crew] , [2: Steel Crew] )
• secd_intrmd_actn_rqstr ( type: esriFieldTypeString, alias: Second Intermediate Action Requested By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: secd_intrmd_actn_rqstr )
• secd_intrmd_actn_rqst_date ( type: esriFieldTypeDate, alias: Second Intermediate Action Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: secd_intrmd_actn_rqst_date )
• secd_intrmd_actn_cntc_cd ( type: esriFieldTypeSmallInteger, alias: Second Intermediate Action Contact, editable: true, nullable: true, defaultValue: null, modelName: secd_intrmd_actn_cntc_cd , Coded Values: [1: BOBS - Culvert Specialist] , [2: BOBS - Geotechnical] , [3: TSC - Operations] , ...1 more... )
• secd_intrmd_actn_cntc_comm ( type: esriFieldTypeString, alias: Second Intermediate Action Contact Comment, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: secd_intrmd_actn_cntc_comm )
• secd_intrmd_actn_cmptr ( type: esriFieldTypeString, alias: Second Intermediate Action Completed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: secd_intrmd_actn_cmptr )
• secd_intrmd_actn_cmpt_date ( type: esriFieldTypeDate, alias: Second Intermediate Action Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: secd_intrmd_actn_cmpt_date )
• secd_intrmd_actn_comments ( type: esriFieldTypeString, alias: Second Intermediate Action Completion Comments, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: secd_intrmd_actn_comments )
• fnl_actn_rqst_type ( type: esriFieldTypeString, alias: Final Action Requested, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: fnl_actn_rqst_type )
• fnl_actn_oth_desc ( type: esriFieldTypeString, alias: Final Action - If Other, describe:, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: fnl_actn_oth_desc )
• fnl_actn_assign_cd ( type: esriFieldTypeSmallInteger, alias: Final Action Requested By Assignee, editable: true, nullable: true, defaultValue: null, modelName: fnl_actn_assign_cd , Coded Values: [1: Concrete Crew] , [2: Steel Crew] )
• fnl_actn_rqstr ( type: esriFieldTypeString, alias: Final Action Requested By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fnl_actn_rqstr )
• fnl_actn_rqst_date ( type: esriFieldTypeDate, alias: Final Action Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: fnl_actn_rqst_date )
• fnl_actn_cmptr ( type: esriFieldTypeString, alias: Final Action Completed By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: fnl_actn_cmptr )
• fnl_actn_cmpt_date ( type: esriFieldTypeDate, alias: Final Action Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: fnl_actn_cmpt_date )
• fnl_actn_comm ( type: esriFieldTypeString, alias: Final Action Completion Comments, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: fnl_actn_comm )
• rfa_stat_cd ( type: esriFieldTypeSmallInteger, alias: RFA Status, editable: true, nullable: true, defaultValue: null, modelName: rfa_stat_cd , Coded Values: [1: Open] , [2: Open Reviewed/Confirmed RFA (by RFA Committee)] , [3: Project Created/Assigned] , ...2 more... )
• rfa_id ( type: esriFieldTypeString, alias: RFA ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: rfa_id )
• rfa_prty_cd ( type: esriFieldTypeSmallInteger, alias: RFA Priority, editable: true, nullable: true, defaultValue: null, modelName: rfa_prty_cd , Coded Values: [0: Undetermined] , [1: Priority Level 1] , [2: Priority Level 2] , ...1 more... )
• mdot_regn_cd ( type: esriFieldTypeSmallInteger, alias: MDOT Region, editable: true, nullable: true, defaultValue: null, modelName: mdot_regn_cd , Coded Values: [1: Superior] , [2: North] , [3: Grand] , ...4 more... )
• mdot_tsc_cd ( type: esriFieldTypeInteger, alias: TSC, editable: true, nullable: true, defaultValue: null, modelName: mdot_tsc_cd , Coded Values: [22: Newberry] , [19: Marshall] , [1: Alpena] , ...19 more... )
• 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 RFA
  Description:
  Prototype:
  mdot_tsc_cd: null
  mdot_regn_cd: null
  AssetGUID: null
  insp_name: null
  insp_cmpy_cd: null
  insp_date: null
  issue_desc: null
  imd_actn_req_type_cd: null
  imd_actn_oth_desc: null
  imd_actn_assign_cd: null
  imd_actn_rqstr: null
  imd_actn_rqst_date: null
  imd_actn_req_comm: null
  imd_actn_cmptr: null
  imd_actn_cmpt_date: null
  imd_actn_cmpt_comm: null
  imd_actn_clos_date: null
  imd_actn_open_date: null
  prmy_intrmd_actn_rqst_type_cd: null
  prmy_intrmd_actn_oth_desc: null
  prmy_intrmd_actn_assign_cd: null
  prmy_intrmd_actn_rqstr: null
  prmy_intrmd_actn_rqst_date: null
  prmy_intrmd_actn_cntc_cd: null
  prmy_intrmd_actn_cntc_comm: null
  prmy_intrmd_actn_cmptr: null
  prmy_intrmd_actn_cmpt_date: null
  prmy_intrmd_actn_comments: null
  secd_intrmd_actn_rqst_type_cd: null
  secd_intrmd_actn_oth_desc: null
  secd_intrmd_actn_assign_cd: null
  secd_intrmd_actn_rqstr: null
  secd_intrmd_actn_rqst_date: null
  secd_intrmd_actn_cntc_cd: null
  secd_intrmd_actn_cntc_comm: null
  secd_intrmd_actn_cmptr: null
  secd_intrmd_actn_cmpt_date: null
  secd_intrmd_actn_comments: null
  fnl_actn_rqst_type: null
  fnl_actn_oth_desc: null
  fnl_actn_assign_cd: null
  fnl_actn_rqstr: null
  fnl_actn_rqst_date: null
  fnl_actn_cmptr: null
  fnl_actn_cmpt_date: null
  fnl_actn_comm: null
  rfa_stat_cd: null
  rfa_id: null
  rfa_prty_cd: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (1) -- Related To: Culvert Inventory (11)

Layer: Culvert Inspection (9)

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)

Layer: Culvert Inventory (11)

Name: Culvert Inventory

Display Field: strucname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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.19062411899995
YMin: 41.70284597700004
XMax: -82.42450370199998
YMax: 47.479681293000056
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 4
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 )
• strc_num ( type: esriFieldTypeString, alias: Structure Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: strc_num )
• strc_num_seq ( type: esriFieldTypeInteger, alias: Structure Number Sequence, editable: true, nullable: true, defaultValue: null, modelName: strc_num_seq )
• strc_type_cd ( type: esriFieldTypeSmallInteger, alias: Structure Type, editable: true, nullable: true, defaultValue: null, modelName: strc_type_cd , Coded Values: [1: Sign Cantilever] , [2: Sign Truss] , [3: Culvert less than 10 feet] , ...2 more... )
• CulvertMaterial ( type: esriFieldTypeString, alias: Culvert Type/Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CulvertMaterial , Coded Values: [Masonry: Masonry] , [Aluminum: Aluminum] , [Steel: Steel] , ...9 more... )
• Culv_dsgn_type_cd ( type: esriFieldTypeString, alias: Culvert Design Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Culv_dsgn_type_cd , Coded Values: [Corrugated: Corrugated] , [Non-corrugated: Non-corrugated] , [Reinforced Concrete: Reinforced Concrete] , ...3 more... )
• ServiceStatus ( type: esriFieldTypeSmallInteger, alias: Service Status, editable: true, nullable: true, defaultValue: null, modelName: ServiceStatus , Coded Values: [1: Abandoned] , [2: Active] , [3: Proposed] , ...1 more... )
• strucname ( type: esriFieldTypeString, alias: Structure Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: strucname )
• invt_field_vrfy_date ( type: esriFieldTypeDate, alias: Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: invt_field_vrfy_date )
• invt_field_vrfy_user ( type: esriFieldTypeString, alias: Inventory Field Verification User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: invt_field_vrfy_user )
• invt_field_vrfy_cmpy_cd ( type: esriFieldTypeSmallInteger, alias: Field Verification Company, editable: true, nullable: true, defaultValue: null, modelName: invt_field_vrfy_cmpy_cd , Coded Values: [1: MDOT] , [2: HNTB] , [3: Collins] , ...6 more... )
• invt_field_comm ( type: esriFieldTypeString, alias: Field Verification Comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: invt_field_comm )
• next_insp_freq ( type: esriFieldTypeDouble, alias: Next Inspection Frequency, editable: true, nullable: true, defaultValue: null, modelName: next_insp_freq )
• antcp_insp_date ( type: esriFieldTypeDate, alias: Anticipated Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: antcp_insp_date )
• aadt ( type: esriFieldTypeInteger, alias: AADT, editable: true, nullable: true, defaultValue: null, modelName: aadt )
• aadt_yr ( type: esriFieldTypeSmallInteger, alias: AADT Year, editable: true, nullable: true, defaultValue: null, modelName: aadt_yr )
• owner_cd ( type: esriFieldTypeSmallInteger, alias: Structure Owner, editable: true, nullable: true, defaultValue: null, modelName: owner_cd , Coded Values: [1: State Highway Agency] , [2: County Highway Agency] , [3: Town or Township Highway Agency] , ...26 more... )
• owner_name_cd ( type: esriFieldTypeSmallInteger, alias: Structure Owner Type, editable: true, nullable: true, defaultValue: null, modelName: owner_name_cd , Coded Values: [1: MDOT] , [99: Other] )
• custodian_name_cd ( type: esriFieldTypeSmallInteger, alias: Structure Maintainer, editable: true, nullable: true, defaultValue: null, modelName: custodian_name_cd , Coded Values: [1: MDOT] , [99: Other] )
• acs_cd ( type: esriFieldTypeSmallInteger, alias: Access Requirements, editable: true, nullable: true, defaultValue: null, modelName: acs_cd , Coded Values: [1: Secure fencing] , [2: Keyed gate] , [3: Access to Railroad Right-of-way] , ...3 more... )
• acs_note ( type: esriFieldTypeString, alias: Access Requirements Note, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: acs_note )
• trfc_ctrl_cd ( type: esriFieldTypeSmallInteger, alias: Traffic Control Needs, editable: true, nullable: true, defaultValue: null, modelName: trfc_ctrl_cd , Coded Values: [1: Shoulder closure] , [2: Single lane closure] , [3: Full road closure] , ...2 more... )
• trfc_ctrl_note ( type: esriFieldTypeString, alias: Traffic Control Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: trfc_ctrl_note )
• rail_coord_cd ( type: esriFieldTypeSmallInteger, alias: Railroad Coordination Required?, editable: true, nullable: true, defaultValue: null, modelName: rail_coord_cd , Coded Values: [1: Yes] , [2: No] )
• rail_name_cd ( type: esriFieldTypeSmallInteger, alias: Railroad Name, editable: true, nullable: true, defaultValue: null, modelName: rail_name_cd , Coded Values: [1: Canadian National Railway] , [2: Lake Superior & Ishpeming Rail] , [3: Lake State Railway] , ...5 more... )
• rail_phne_num_cd ( type: esriFieldTypeSmallInteger, alias: Railroad Phone Number, editable: true, nullable: true, defaultValue: null, modelName: rail_phne_num_cd , Coded Values: [1: 555-555-5555 (RR Name1)] )
• JobNumber ( type: esriFieldTypeString, alias: Job Number Installed or Refurb, editable: true, nullable: true, length: 12, defaultValue: null, modelName: JobNumber )
• prmy_xstr ( type: esriFieldTypeString, alias: Primary Cross Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: prmy_xstr )
• location ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: location )
• legal_cd ( type: esriFieldTypeSmallInteger, alias: MDOT Legal System, editable: true, nullable: true, defaultValue: null, modelName: legal_cd , Coded Values: [1: MDOT] , [2: County Primary] , [3: County Local] , ...3 more... )
• nrst_rte_drtn_cd ( type: esriFieldTypeSmallInteger, alias: Route Travel Direction, editable: true, nullable: true, defaultValue: null, modelName: nrst_rte_drtn_cd , Coded Values: [1: NB] , [2: SB] , [3: WB] , ...1 more... )
• mile_mrkr ( type: esriFieldTypeDouble, alias: Mile Marker, editable: true, nullable: true, defaultValue: null, modelName: mile_mrkr )
• PR ( type: esriFieldTypeString, alias: Physical Reference ID number, editable: true, nullable: true, length: 14, defaultValue: null, modelName: PR )
• PRMP ( type: esriFieldTypeDouble, alias: PR Milepoint, editable: true, nullable: true, defaultValue: null, modelName: PRMP )
• cs ( type: esriFieldTypeInteger, alias: CS Control Section, editable: true, nullable: true, defaultValue: null, modelName: cs )
• cs_mp ( type: esriFieldTypeDouble, alias: CS Milepoint, editable: true, nullable: true, defaultValue: null, modelName: cs_mp )
• placecode_cd ( type: esriFieldTypeInteger, alias: City, editable: true, nullable: true, defaultValue: null, modelName: placecode_cd , Coded Values: [200: Acme Township] , [240: Ada Township] , [280: Adams Township] , ...1517 more... )
• mdot_regn_cd ( type: esriFieldTypeSmallInteger, alias: MDOT Region, editable: true, nullable: true, defaultValue: null, modelName: mdot_regn_cd , Coded Values: [1: Superior] , [2: North] , [3: Grand] , ...4 more... )
• mdotcnty_cd ( type: esriFieldTypeInteger, alias: MDOT County, editable: true, nullable: true, defaultValue: null, modelName: mdotcnty_cd , Coded Values: [1: Alcona] , [3: Alger] , [5: Allegan] , ...80 more... )
• mdot_tsc_cd ( type: esriFieldTypeInteger, alias: TSC, editable: true, nullable: true, defaultValue: null, modelName: mdot_tsc_cd , Coded Values: [22: Newberry] , [19: Marshall] , [1: Alpena] , ...19 more... )
• grg_cd ( type: esriFieldTypeSmallInteger, alias: Garage, editable: true, nullable: true, defaultValue: null, modelName: grg_cd , Coded Values: [1: Garage] )
• precise_lat_barrel_start ( type: esriFieldTypeDouble, alias: Start Latitude, editable: true, nullable: true, defaultValue: null, modelName: precise_lat_barrel_start )
• precise_lon_barrel_start ( type: esriFieldTypeDouble, alias: Start Longitude, editable: true, nullable: true, defaultValue: null, modelName: precise_lon_barrel_start )
• precise_lat_barrel_end ( type: esriFieldTypeDouble, alias: End Latitude, editable: true, nullable: true, defaultValue: null, modelName: precise_lat_barrel_end )
• precise_lon_barrel_end ( type: esriFieldTypeDouble, alias: End Longitude, editable: true, nullable: true, defaultValue: null, modelName: precise_lon_barrel_end )
• SpatialQualityIndex ( type: esriFieldTypeString, alias: Spatial Quality Index, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SpatialQualityIndex , Coded Values: [A: Survey Grade-3D] , [B: Survey Grade-2D] , [C: Mapping Grade] , ...2 more... )
• Beneath ( type: esriFieldTypeSmallInteger, alias: Beneath, editable: true, nullable: true, defaultValue: null, modelName: Beneath , Coded Values: [1: Mainline] , [2: Ramp] , [3: Service Drive] , ...6 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: Comments )
• CulvertHeight ( type: esriFieldTypeDouble, alias: Culvert Height, editable: true, nullable: true, defaultValue: null, modelName: CulvertHeight )
• CulvertShape ( type: esriFieldTypeSmallInteger, alias: Culvert Shape, editable: true, nullable: true, defaultValue: null, modelName: CulvertShape , Coded Values: [1: Circular] , [2: Horizontal Elliptical] , [3: Vertical Elliptical] , ...10 more... )
• CulvertWidth ( type: esriFieldTypeDouble, alias: Culvert Width (inches), editable: true, nullable: true, defaultValue: null, modelName: CulvertWidth )
• culv_span ( type: esriFieldTypeString, alias: Culvert Span, editable: true, nullable: true, length: 255, defaultValue: null, modelName: culv_span )
• depth_cover_feet ( type: esriFieldTypeDouble, alias: Depth of Cover (ft), editable: true, nullable: true, defaultValue: null, modelName: depth_cover_feet )
• DitchVegetation ( type: esriFieldTypeSmallInteger, alias: Ditch Vegetation, editable: true, nullable: true, defaultValue: null, modelName: DitchVegetation , Coded Values: [1: None] , [2: Partial] , [3: Full] )
• InspectionDate ( type: esriFieldTypeDate, alias: Last Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• Liner ( type: esriFieldTypeSmallInteger, alias: Liner, editable: true, nullable: true, defaultValue: null, modelName: Liner , Coded Values: [1: Yes] , [2: No] )
• LinerDiameter ( type: esriFieldTypeDouble, alias: Liner Diameter, editable: true, nullable: true, defaultValue: null, modelName: LinerDiameter )
• LinerMaterial ( type: esriFieldTypeSmallInteger, alias: Liner Material, editable: true, nullable: true, defaultValue: null, modelName: LinerMaterial , Coded Values: [1: Plastic-Smooth] , [2: Plastic-Corrugated] , [3: CIPP] , ...4 more... )
• Route ( type: esriFieldTypeInteger, alias: Route, editable: true, nullable: true, defaultValue: null, modelName: Route , Coded Values: [1: I-69] , [2: I-75] , [3: I-94] , ...270 more... )
• StreamSubstrate ( type: esriFieldTypeSmallInteger, alias: Stream Substrate, editable: true, nullable: true, defaultValue: null, modelName: StreamSubstrate , Coded Values: [1: Cobble] , [2: Gravel] , [3: Sand] , ...4 more... )
• Surface ( type: esriFieldTypeSmallInteger, alias: Roadway Surface, editable: true, nullable: true, defaultValue: null, modelName: Surface , Coded Values: [1: No Deficiency] , [2: Cracked] , [3: Pothole(s)] , ...4 more... )
• rdwy_surf_cd ( type: esriFieldTypeString, alias: Roadway Surface Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: rdwy_surf_cd , Coded Values: [Asphalt: Asphalt] , [Brick: Brick] , [Concrete: Concrete] , ...3 more... )
• flow_dir_cd ( type: esriFieldTypeSmallInteger, alias: Flow Direction, editable: true, nullable: true, defaultValue: null, modelName: flow_dir_cd , Coded Values: [1: N] , [2: NE] , [3: E] , ...5 more... )
• NumberofBarrelsCells ( type: esriFieldTypeSmallInteger, alias: Number of Barrels Cells, editable: true, nullable: true, defaultValue: null, modelName: NumberofBarrelsCells )
• CulvertLengthCalculated ( type: esriFieldTypeDouble, alias: Culvert Length Calculated, editable: true, nullable: true, defaultValue: null, modelName: CulvertLengthCalculated )
• skew_ang ( type: esriFieldTypeDouble, alias: Skew Angle, editable: true, nullable: true, defaultValue: null, modelName: skew_ang )
• NumberofLanes ( type: esriFieldTypeSmallInteger, alias: Number of Lanes, editable: true, nullable: true, defaultValue: null, modelName: NumberofLanes )
• DesignDischargeCFS ( type: esriFieldTypeDouble, alias: Design Discharge (CFS), editable: true, nullable: true, defaultValue: null, modelName: DesignDischargeCFS )
• DrainageAreaAcres ( type: esriFieldTypeDouble, alias: Drainage Area Acres, editable: true, nullable: true, defaultValue: null, modelName: DrainageAreaAcres )
• InletProtection ( type: esriFieldTypeSmallInteger, alias: Inlet Protection, editable: true, nullable: true, defaultValue: null, modelName: InletProtection , Coded Values: [1: Yes] , [2: No] )
• OutletProtection ( type: esriFieldTypeSmallInteger, alias: Outlet Protection, editable: true, nullable: true, defaultValue: null, modelName: OutletProtection , Coded Values: [1: Yes] , [2: No] )
• perch_outlet_cd ( type: esriFieldTypeSmallInteger, alias: Perched outlet present?, editable: true, nullable: true, defaultValue: null, modelName: perch_outlet_cd , Coded Values: [1: Yes] , [2: No] )
• last_insp_date ( type: esriFieldTypeDate, alias: Last Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_insp_date )
• last_cpnt_rating_cd ( type: esriFieldTypeSmallInteger, alias: Last Component Rating, editable: true, nullable: true, defaultValue: null, modelName: last_cpnt_rating_cd , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• last_insp_qc_stat_cd ( type: esriFieldTypeSmallInteger, alias: Last Inspection QC Status, editable: true, nullable: true, defaultValue: null, modelName: last_insp_qc_stat_cd , Coded Values: [0: QC Not Started] , [1: QC Rejected - Issues to Address] , [2: QC Complete - Accepted] , ...4 more... )
• last_insp_qa_stat_cd ( type: esriFieldTypeSmallInteger, alias: Last Inspection QA Status, editable: true, nullable: true, defaultValue: null, modelName: last_insp_qa_stat_cd , Coded Values: [0: QA Not Started] , [4: QA Rejected - Issues to Address] , [5: QA Complete - Accepted] , ...1 more... )
• rr_op_name ( type: esriFieldTypeString, alias: Railroad Operator Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: rr_op_name )
• rr_div ( type: esriFieldTypeString, alias: Railroad Division, editable: true, nullable: true, length: 50, defaultValue: null, modelName: rr_div )
• rr_mp ( type: esriFieldTypeDouble, alias: Railroad Milepost, editable: true, nullable: true, defaultValue: null, modelName: rr_mp )
• rr_xstr ( type: esriFieldTypeString, alias: Nearest cross-roads, editable: true, nullable: true, length: 50, defaultValue: null, modelName: rr_xstr )
• rr_num_trck_cross ( type: esriFieldTypeSmallInteger, alias: Number of tracks crossed, editable: true, nullable: true, defaultValue: null, modelName: rr_num_trck_cross )
• 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 )
• yearbuilt ( type: esriFieldTypeSmallInteger, alias: Year Built, editable: true, nullable: true, defaultValue: null, modelName: yearbuilt )
• owner_specialty_area_cd ( type: esriFieldTypeString, alias: Owner Specialty Area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: owner_specialty_area_cd , Coded Values: [1: Ancillary Structures] , [2: ITS] , [3: Structures] )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Templates:
• Name: Culvert Inventory
  Description:
  Prototype:
  owner_specialty_area_cd: null
  yearbuilt: null
  strc_num: null
  strc_num_seq: null
  strc_type_cd: null
  CulvertMaterial: null
  Culv_dsgn_type_cd: null
  ServiceStatus: null
  strucname: null
  invt_field_vrfy_date: null
  invt_field_vrfy_user: null
  invt_field_vrfy_cmpy_cd: null
  invt_field_comm: null
  next_insp_freq: null
  antcp_insp_date: null
  aadt: null
  aadt_yr: null
  owner_cd: null
  owner_name_cd: null
  custodian_name_cd: null
  acs_cd: null
  acs_note: null
  trfc_ctrl_cd: null
  trfc_ctrl_note: null
  rail_coord_cd: null
  rail_name_cd: null
  rail_phne_num_cd: null
  JobNumber: null
  prmy_xstr: null
  location: null
  legal_cd: null
  nrst_rte_drtn_cd: null
  mile_mrkr: null
  PR: null
  PRMP: null
  cs: null
  cs_mp: null
  placecode_cd: null
  mdot_regn_cd: null
  mdotcnty_cd: null
  mdot_tsc_cd: null
  grg_cd: null
  precise_lat_barrel_start: null
  precise_lon_barrel_start: null
  precise_lat_barrel_end: null
  precise_lon_barrel_end: null
  SpatialQualityIndex: null
  Beneath: null
  Comments: null
  CulvertHeight: null
  CulvertShape: null
  CulvertWidth: null
  culv_span: null
  depth_cover_feet: null
  DitchVegetation: null
  InspectionDate: null
  Liner: null
  LinerDiameter: null
  LinerMaterial: null
  Route: null
  StreamSubstrate: null
  Surface: null
  rdwy_surf_cd: null
  flow_dir_cd: null
  NumberofBarrelsCells: null
  CulvertLengthCalculated: null
  skew_ang: null
  NumberofLanes: null
  DesignDischargeCFS: null
  DrainageAreaAcres: null
  InletProtection: null
  OutletProtection: null
  perch_outlet_cd: null
  last_insp_date: null
  last_cpnt_rating_cd: null
  last_insp_qc_stat_cd: null
  last_insp_qa_stat_cd: null
  rr_op_name: null
  rr_div: null
  rr_mp: null
  rr_xstr: null
  rr_num_trck_cross: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertWorkRecommendation (0) -- Related To: Culvert Work Rec (13)
• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertRfa (1) -- Related To: Culvert RFA (12)
• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspection (3) -- Related To: Culvert Inspection (9)
• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertEndInventory (4) -- Related To: Culvert End Inventory (8)

Tables:

Table: Culvert End Inventory (8)

Name: Culvert End Inventory

Display Field: Bound

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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:
• 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 )
• Bound ( type: esriFieldTypeSmallInteger, alias: Bound, editable: true, nullable: true, defaultValue: null, modelName: Bound , Coded Values: [1: NB] , [2: SB] , [3: WB] , ...1 more... )
• ConditionIndex ( type: esriFieldTypeSmallInteger, alias: Condition Index, editable: true, nullable: true, defaultValue: null, modelName: ConditionIndex , Coded Values: [0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical] , ...8 more... )
• CulvertEndID ( type: esriFieldTypeGUID, alias: CulvertEndID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CulvertEndID )
• CulvertID ( type: esriFieldTypeGUID, alias: CulvertID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CulvertID )
• EmbankmentCondition ( type: esriFieldTypeSmallInteger, alias: Embankment Condition, editable: true, nullable: true, defaultValue: null, modelName: EmbankmentCondition )
• EndExtension ( type: esriFieldTypeSmallInteger, alias: End Extension, editable: true, nullable: true, defaultValue: null, modelName: EndExtension , Coded Values: [1: Yes] , [2: No] )
• EndLocation ( type: esriFieldTypeSmallInteger, alias: End Location, editable: true, nullable: true, defaultValue: null, modelName: EndLocation , Coded Values: [1: North] , [2: South] , [3: East] , ...1 more... )
• EndSection ( type: esriFieldTypeSmallInteger, alias: End Section, editable: true, nullable: true, defaultValue: null, modelName: EndSection , Coded Values: [1: None] , [2: Headwall] , [3: Headwall W/ Wingwalls] , ...5 more... )
• EndSectionDetached ( type: esriFieldTypeSmallInteger, alias: End Section Detached, editable: true, nullable: true, defaultValue: null, modelName: EndSectionDetached , Coded Values: [1: Yes] , [2: No] )
• EndSectionMaterial ( type: esriFieldTypeSmallInteger, alias: End Section Material, editable: true, nullable: true, defaultValue: null, modelName: EndSectionMaterial , Coded Values: [1: Metal] , [2: Concrete] , [3: Clay] , ...2 more... )
• ExtensionDimeSameAsCulvert ( type: esriFieldTypeSmallInteger, alias: Extension Dime Same As Culvert, editable: true, nullable: true, defaultValue: null, modelName: ExtensionDimeSameAsCulvert , Coded Values: [1: Yes] , [2: No] )
• ExtensionMaterialSameAsCulvert ( type: esriFieldTypeSmallInteger, alias: Extension Material Same As Culvert, editable: true, nullable: true, defaultValue: null, modelName: ExtensionMaterialSameAsCulvert , Coded Values: [1: Yes] , [2: No] )
• ExtensionShapeSameAsCulvert ( type: esriFieldTypeSmallInteger, alias: Extension Shape Same As Culvert, editable: true, nullable: true, defaultValue: null, modelName: ExtensionShapeSameAsCulvert , Coded Values: [1: Yes] , [2: No] )
• FootingExposed ( type: esriFieldTypeSmallInteger, alias: Footing Exposed, editable: true, nullable: true, defaultValue: null, modelName: FootingExposed , Coded Values: [1: Yes] , [2: No] )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: Install Year, editable: true, nullable: true, defaultValue: null, modelName: InstallYear )
• InvertAboveChannelBottom ( type: esriFieldTypeSmallInteger, alias: Invert Above Channel Bottom, editable: true, nullable: true, defaultValue: null, modelName: InvertAboveChannelBottom , Coded Values: [1: Yes] , [2: No] )
• scour_prot_type_cd ( type: esriFieldTypeSmallInteger, alias: Scour Protection Type, editable: true, nullable: true, defaultValue: null, modelName: scour_prot_type_cd , Coded Values: [1: Plain Riprap] , [2: Heavy Riprap] , [3: Field Stone] , ...7 more... )
• Riprap ( type: esriFieldTypeSmallInteger, alias: Riprap, editable: true, nullable: true, defaultValue: null, modelName: Riprap , Coded Values: [1: Yes] , [2: No] )
• RiprapCondition ( type: esriFieldTypeSmallInteger, alias: Riprap Condition, editable: true, nullable: true, defaultValue: null, modelName: RiprapCondition )
• SafetyGrate ( type: esriFieldTypeSmallInteger, alias: Safety Grate, editable: true, nullable: true, defaultValue: null, modelName: SafetyGrate , Coded Values: [1: Yes] , [2: No] )
• ScourPresent ( type: esriFieldTypeSmallInteger, alias: Scour Present, editable: true, nullable: true, defaultValue: null, modelName: ScourPresent , Coded Values: [1: Yes] , [2: No] )
• SedimentDepthGreater20 ( type: esriFieldTypeSmallInteger, alias: Sediment Depth Greater 20, editable: true, nullable: true, defaultValue: null, modelName: SedimentDepthGreater20 , Coded Values: [1: Yes] , [2: No] )
• EndSectionExtLength_ft ( type: esriFieldTypeDouble, alias: End Section Extension Length (ft), editable: true, nullable: true, defaultValue: null, modelName: EndSectionExtLength_ft )
• EndSectionRemarks ( type: esriFieldTypeString, alias: End Section Remarks, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: EndSectionRemarks )
• invt_field_vrfy_date ( type: esriFieldTypeDate, alias: Field Verification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: invt_field_vrfy_date )
• invt_field_vrfy_user ( type: esriFieldTypeString, alias: Inventory Field Verification User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: invt_field_vrfy_user )
• invt_field_vrfy_cmpy_cd ( type: esriFieldTypeSmallInteger, alias: Field Verification Company, editable: true, nullable: true, defaultValue: null, modelName: invt_field_vrfy_cmpy_cd , Coded Values: [1: MDOT] , [2: HNTB] , [3: Collins] , ...6 more... )
• UserCreate ( type: esriFieldTypeString, alias: User Create, editable: false, nullable: true, length: 255, defaultValue: null, modelName: UserCreate )
• SystemCreateDate ( type: esriFieldTypeDate, alias: System Create Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: SystemCreateDate )
• UserModified ( type: esriFieldTypeString, alias: User Modified, editable: false, nullable: true, length: 255, defaultValue: null, modelName: UserModified )
• SystemModifiedDate ( type: esriFieldTypeDate, alias: System Modified Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: SystemModifiedDate )
Templates:
• Name: Culvert End Inventory
  Description:
  Prototype:
  invt_field_vrfy_cmpy_cd: null
  invt_field_vrfy_user: null
  Bound: null
  ConditionIndex: null
  CulvertEndID: null
  CulvertID: null
  EmbankmentCondition: null
  EndExtension: null
  EndLocation: null
  EndSection: null
  EndSectionDetached: null
  EndSectionMaterial: null
  ExtensionDimeSameAsCulvert: null
  ExtensionMaterialSameAsCulvert: null
  ExtensionShapeSameAsCulvert: null
  FootingExposed: null
  InstallYear: null
  InvertAboveChannelBottom: null
  scour_prot_type_cd: null
  Riprap: null
  RiprapCondition: null
  SafetyGrate: null
  ScourPresent: null
  SedimentDepthGreater20: null
  EndSectionExtLength_ft: null
  EndSectionRemarks: null
  invt_field_vrfy_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (4) -- Related To: Culvert Inventory (11)

Table: Culvert Inspection QA/QC (10)

Name: Culvert Inspection QA/QC

Display Field: revw_name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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:
• 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 )
• revw_name ( type: esriFieldTypeString, alias: Name of Reviewer/Updater, editable: true, nullable: true, length: 255, defaultValue: null, modelName: revw_name )
• revw_cmpy_cd ( type: esriFieldTypeSmallInteger, alias: Company of Reviewer, editable: true, nullable: true, defaultValue: null, modelName: revw_cmpy_cd , Coded Values: [1: MDOT] , [2: HNTB] , [3: Collins] , ...6 more... )
• revw_date ( type: esriFieldTypeDate, alias: Review Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: revw_date )
• revw_type_cd ( type: esriFieldTypeSmallInteger, alias: Quality Review Type, editable: true, nullable: true, defaultValue: null, modelName: revw_type_cd , Coded Values: [1: QC Reviewer - Initial Review] , [2: Inspector - QC Comment Resolution] , [3: QC Reviewer - QC Comment Verification] , ...3 more... )
• revw_comm ( type: esriFieldTypeString, alias: Quality Review Comments, editable: true, nullable: true, length: 3999, defaultValue: null, modelName: revw_comm )
• revw_stat_cd ( type: esriFieldTypeSmallInteger, alias: Quality Status After Review Complete, editable: true, nullable: true, defaultValue: null, modelName: revw_stat_cd , Coded Values: [0: Not Started] , [1: QC Rejected – Issues to Address] , [2: QC Complete – Accepted] , ...1 more... )
• InspGUID ( type: esriFieldTypeGUID, alias: Inspection GUID (Foreign key for the Inspection Table), editable: true, nullable: true, length: 38, defaultValue: null, modelName: InspGUID )
• qa_stat_cd ( type: esriFieldTypeSmallInteger, alias: QA Status After Review Complete, 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... )
• 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 QA/QC
  Description:
  Prototype:
  qa_stat_cd: null
  InspGUID: null
  revw_name: null
  revw_cmpy_cd: null
  revw_date: null
  revw_type_cd: null
  revw_comm: null
  revw_stat_cd: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspection (2) -- Related To: Culvert Inspection (9)