View In:   ArcGIS Online Map Viewer

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)

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