ArcGIS REST Services Directory
Login
|
Get Token
Home
>
services
>
MDOT
>
MdotCulvert (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (MDOT/MdotCulvert)
Layers:
Layer:
Work Rec
(4)
Name:
Work Rec
Display Field:
fc_fs_recm_typ_cd
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
24000.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 150956.19622559287
YMin: 128046.86206265818
XMax: 1741597.1558739506
YMax: 876763.7342823958
Spatial Reference: 0 (0) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[65, 149, 155, 255]
Size:
4.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: false
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: true
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:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
AssetGUID
( type: esriFieldTypeGUID, alias: AssetGUID, length: 38 )
InspGUID
( type: esriFieldTypeGUID, alias: InspGUID, length: 38 )
fc_fs_recm_typ_cd
( type: esriFieldTypeSmallInteger, alias: Culvert Work Recommendation Type ,
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. , length: 255 )
fc_fs_recm_comm
( type: esriFieldTypeString, alias: Work Recommendation Comment, length: 3999 )
insptype
( type: esriFieldTypeSmallInteger, alias: Inspection Type ,
Coded Values:
[1: Routine] , [2: Damage] , [3: New Construction]
, ...4 more...
)
work_rec_stat_cd
( type: esriFieldTypeSmallInteger, alias: Work Recommendation Status ,
Coded Values:
[0: Open] , [10: Assigned] , [20: Complete] )
work_rect_cmpt_date
( type: esriFieldTypeDate, alias: Work Recommendation Completion Date, length: 8 )
qty_matl
( type: esriFieldTypeDouble, alias: Estimated Quantity of Primary Material Needed for Work Rec )
insp_cmpy_cd
( type: esriFieldTypeSmallInteger, alias: Inspection Company ,
Coded Values:
[1: MDOT] , [2: HNTB] , [3: Collins]
, ...6 more...
)
insp_qc_stat_cd
( type: esriFieldTypeSmallInteger, alias: Inspection QC Status ,
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 ,
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, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
mdot_regn_cd
( type: esriFieldTypeSmallInteger, alias: MDOT Region ,
Coded Values:
[1: Superior] , [2: North] , [3: Grand]
, ...4 more...
)
mdot_tsc_cd
( type: esriFieldTypeInteger, alias: TSC ,
Coded Values:
[22: Newberry] , [19: Marshall] , [1: Alpena]
, ...19 more...
)
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Relationships:
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (0) --
Related To
:
Culvert Inventory
(0)
Layer:
RFA
(2)
Name:
RFA
Display Field:
insp_name
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
24000.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 172311.7061686637
YMin: 132167.49175177887
XMax: 788254.9429251323
YMax: 777156.9513713876
Spatial Reference: 0 (0) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[140, 147, 69, 255]
Size:
4.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: false
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: true
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:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
AssetGUID
( type: esriFieldTypeGUID, alias: AssetGUID, length: 38 )
insp_name
( type: esriFieldTypeString, alias: Inspector Name, length: 50 )
insp_cmpy_cd
( type: esriFieldTypeSmallInteger, alias: Inspector Company ,
Coded Values:
[1: MDOT] , [2: HNTB] , [3: Collins]
, ...6 more...
)
insp_date
( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
issue_desc
( type: esriFieldTypeString, alias: Problems/Comments/Explanation, length: 3999 )
imd_actn_req_type_cd
( type: esriFieldTypeSmallInteger, alias: Immediate Action Requested ,
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 Comments, length: 3999 )
imd_actn_assign_cd
( type: esriFieldTypeSmallInteger, alias: Immediate Action Requested By Assignee ,
Coded Values:
[1: Concrete Crew] , [2: Steel Crew] )
imd_actn_rqstr
( type: esriFieldTypeString, alias: imd_actn_rqstr, length: 255 )
imd_actn_rqst_date
( type: esriFieldTypeDate, alias: imd_actn_rqst_date, length: 8 )
imd_actn_req_comm
( type: esriFieldTypeString, alias: Immediate Action Request Comments, length: 3999 )
imd_actn_cmptr
( type: esriFieldTypeString, alias: Immediate Action Completed By, length: 50 )
imd_actn_cmpt_date
( type: esriFieldTypeDate, alias: Immediate Action Completion Date, length: 8 )
imd_actn_cmpt_comm
( type: esriFieldTypeString, alias: Immediate Action Completion Comments, length: 3999 )
imd_actn_clos_date
( type: esriFieldTypeDate, alias: Immediate Action Closure Date, length: 8 )
imd_actn_open_date
( type: esriFieldTypeDate, alias: Immediate Action Open Date, length: 8 )
prmy_intrmd_actn_rqst_type_cd
( type: esriFieldTypeSmallInteger, alias: First Intermediate Action Requested ,
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:, length: 3999 )
prmy_intrmd_actn_assign_cd
( type: esriFieldTypeSmallInteger, alias: First Intermediate Action Requested By Assignee ,
Coded Values:
[1: Concrete Crew] , [2: Steel Crew] )
prmy_intrmd_actn_rqstr
( type: esriFieldTypeString, alias: First Intermediate Action Requested By, length: 50 )
prmy_intrmd_actn_rqst_date
( type: esriFieldTypeDate, alias: First Intermediate Action Request Date, length: 8 )
prmy_intrmd_actn_cntc_cd
( type: esriFieldTypeSmallInteger, alias: First Intermediate Action Contact ,
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, length: 3999 )
prmy_intrmd_actn_cmptr
( type: esriFieldTypeString, alias: First Intermediate Action Completed By, length: 50 )
prmy_intrmd_actn_cmpt_date
( type: esriFieldTypeDate, alias: First Intermediate Action Completion Date, length: 8 )
prmy_intrmd_actn_comments
( type: esriFieldTypeString, alias: First Intermediate Action Completion Comments, length: 3999 )
secd_intrmd_actn_rqst_type_cd
( type: esriFieldTypeSmallInteger, alias: Second Intermediate Action Requested ,
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:, length: 3999 )
secd_intrmd_actn_assign_cd
( type: esriFieldTypeSmallInteger, alias: Second Intermediate Action Requested By Assignee ,
Coded Values:
[1: Concrete Crew] , [2: Steel Crew] )
secd_intrmd_actn_rqstr
( type: esriFieldTypeString, alias: Second Intermediate Action Requested By, length: 50 )
secd_intrmd_actn_rqst_date
( type: esriFieldTypeDate, alias: Second Intermediate Action Request Date, length: 8 )
secd_intrmd_actn_cntc_cd
( type: esriFieldTypeSmallInteger, alias: Second Intermediate Action Contact ,
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, length: 3999 )
secd_intrmd_actn_cmptr
( type: esriFieldTypeString, alias: Second Intermediate Action Completed By, length: 50 )
secd_intrmd_actn_cmpt_date
( type: esriFieldTypeDate, alias: Second Intermediate Action Completion Date, length: 8 )
secd_intrmd_actn_comments
( type: esriFieldTypeString, alias: Second Intermediate Action Completion Comments, length: 3999 )
fnl_actn_rqst_type
( type: esriFieldTypeString, alias: Final Action Requested, length: 3999 )
fnl_actn_oth_desc
( type: esriFieldTypeString, alias: Final Action - If Other, describe:, length: 3999 )
fnl_actn_assign_cd
( type: esriFieldTypeSmallInteger, alias: Final Action Requested By Assignee ,
Coded Values:
[1: Concrete Crew] , [2: Steel Crew] )
fnl_actn_rqstr
( type: esriFieldTypeString, alias: Final Action Requested By, length: 50 )
fnl_actn_rqst_date
( type: esriFieldTypeDate, alias: Final Action Request Date, length: 8 )
fnl_actn_cmptr
( type: esriFieldTypeString, alias: Final Action Completed By, length: 50 )
fnl_actn_cmpt_date
( type: esriFieldTypeDate, alias: Final Action Completion Date, length: 8 )
fnl_actn_comm
( type: esriFieldTypeString, alias: Final Action Completion Comments, length: 3999 )
rfa_stat_cd
( type: esriFieldTypeSmallInteger, alias: RFA Status ,
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, length: 50 )
rfa_prty_cd
( type: esriFieldTypeSmallInteger, alias: RFA Priority ,
Coded Values:
[0: Undetermined] , [1: Priority Level 1] , [2: Priority Level 2]
, ...1 more...
)
mdot_regn_cd
( type: esriFieldTypeSmallInteger, alias: MDOT Region ,
Coded Values:
[1: Superior] , [2: North] , [3: Grand]
, ...4 more...
)
mdot_tsc_cd
( type: esriFieldTypeInteger, alias: TSC ,
Coded Values:
[22: Newberry] , [19: Marshall] , [1: Alpena]
, ...19 more...
)
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Relationships:
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (1) --
Related To
:
Culvert Inventory
(0)
Layer:
Inspection
(1)
Name:
Inspection
Display Field:
insp_type_cd
Type:
Feature Layer
Geometry Type:
esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
24000.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 150956.2111490434
YMin: 128047.16535183508
XMax: 796005.6895068139
YMax: 778202.9650291717
Spatial Reference: 0 (0) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSMSCircle
Color:
[44, 96, 142, 255]
Size:
4.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: false
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: true
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:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
AssetGUID
( type: esriFieldTypeGUID, alias: AssetGUID, length: 38 )
insp_type_cd
( type: esriFieldTypeSmallInteger, alias: Inspection Type ,
Coded Values:
[1: Routine] , [2: Damage] , [3: New Construction]
, ...4 more...
)
insp_field_vrfy_date
( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
insp_user_cd
( type: esriFieldTypeString, alias: Inspection User, length: 255 )
insp_cmpy_cd
( type: esriFieldTypeSmallInteger, alias: Inspection Company ,
Coded Values:
[1: MDOT] , [2: HNTB] , [3: Collins]
, ...6 more...
)
insp_comm
( type: esriFieldTypeString, alias: Inspection Comments, length: 3999 )
insp_cret_uid
( type: esriFieldTypeString, alias: created_user, length: 255 )
insp_cret_tmsp
( type: esriFieldTypeDate, alias: created_date, length: 8 )
insp_updt_uid
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
insp_updt_tmsp
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
water_depth_inlet
( type: esriFieldTypeDouble, alias: Water Depth Inlet (inches) )
water_depth_outlet
( type: esriFieldTypeDouble, alias: Water Depth Outlet (inches) )
hdwl_elmt_rtg_status_cd
( type: esriFieldTypeSmallInteger, alias: Was the Headwall Element rated? ,
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, length: 255 )
hdwl_elmt_rtg_good
( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Good (Each) )
hdwl_elmt_rtg_fair
( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Fair (Each) )
hdwl_elmt_rtg_poor
( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Poor (Each) )
hdwl_elmt_rtg_severe
( type: esriFieldTypeSmallInteger, alias: Headwall Element Rated Severe (Each) )
wngwl_elmt_rtg_status_cd
( type: esriFieldTypeSmallInteger, alias: Was the Wingwall Element rated? ,
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, length: 3999 )
wngwl_elmt_rtg_good
( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Good (Each) )
wngwl_elmt_rtg_fair
( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Fair (Each) )
wngwl_elmt_rtg_poor
( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Poor (Each) )
wngwl_elmt_rtg_severe
( type: esriFieldTypeSmallInteger, alias: Wingwall Element Rated Severe (Each) )
scour_elmt_rtg_status_cd
( type: esriFieldTypeSmallInteger, alias: Was the Scour Element rated? ,
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, length: 3999 )
scour_elmt_rtg_good
( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Good (Each) )
scour_elmt_rtg_fair
( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Fair (Each) )
scour_elmt_rtg_poor
( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Poor (Each) )
scour_elmt_rtg_severe
( type: esriFieldTypeSmallInteger, alias: Scour Element Rated Severe (Each) )
joint_elmt_rtg_status_cd
( type: esriFieldTypeSmallInteger, alias: Was Joints Element Rated? ,
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, length: 3999 )
joint_elmt_rtg_good
( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Good (Length, feet) )
joint_elmt_rtg_fair
( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Fair (Length, feet) )
joint_elmt_rtg_poor
( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Poor (Length, feet) )
joint_elmt_rtg_severe
( type: esriFieldTypeSmallInteger, alias: Joints Element Rated Severe (Length, feet) )
barl_elmt_rtg_cd
( type: esriFieldTypeSmallInteger, alias: Was Barrel Element Rated? ,
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, length: 3999 )
barl_elmt_rtg_good
( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Good (Length, feet) )
barl_elmt_rtg_fair
( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Fair (Length, feet) )
barl_elmt_rtg_poor
( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Poor (Length, feet) )
barl_elmt_rtg_severe
( type: esriFieldTypeSmallInteger, alias: Barrel Element Rated Severe (Length, feet) )
culv_appr_cpnt_rtg_cd
( type: esriFieldTypeSmallInteger, alias: Culvert Approach Roadway and Embankment Component Rating ,
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, length: 3999 )
culv_chnl_cpnt_rtg_cd
( type: esriFieldTypeSmallInteger, alias: Culvert Channel Component Rating ,
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, length: 3999 )
culv_strc_cpnt_rtg_cd
( type: esriFieldTypeSmallInteger, alias: Culvert Structure Component Rating ,
Coded Values:
[0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical]
, ...8 more...
)
culv_strc_strc_comm
( type: esriFieldTypeString, alias: Culvert Structure Comment, length: 3999 )
culv_end_cpnt_rtg_cd
( type: esriFieldTypeSmallInteger, alias: Culvert End Treatment Component Rating ,
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, length: 3999 )
culv_cpnt_rtg_cd
( type: esriFieldTypeSmallInteger, alias: Culvert Component (Calculated Min) ,
Coded Values:
[0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical]
, ...8 more...
)
next_insp_freq
( type: esriFieldTypeDouble, alias: Next Inspection Frequency )
just_comm
( type: esriFieldTypeString, alias: Justification Comment for Next Inspection Frequency, length: 3999 )
qc_stat_cd
( type: esriFieldTypeSmallInteger, alias: QC Status (Calculated from QA/QC Related Table) ,
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) ,
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? ,
Coded Values:
[1: Yes] , [2: No] )
outlet_sfty_grate_cd
( type: esriFieldTypeSmallInteger, alias: Safety grate or trash rack present at outlet? ,
Coded Values:
[1: Yes] , [2: No] )
insp_complete_cd
( type: esriFieldTypeString, alias: Inspection Complete?, length: 255 ,
Coded Values:
[In Progress: In Progress] , [Ready for QC: Ready for QC] )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Relationships:
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspectionQAQC (2) --
Related To
:
Inspection QA/QC
(7)
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (3) --
Related To
:
Culvert Inventory
(0)
Layer:
Trunkline
(5)
Name:
Trunkline
Display Field:
PR_NAME
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
24000.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 178022.82109999936
YMin: 128362.74399999715
XMax: 791377.9613000015
YMax: 771646.5920999981
Spatial Reference: 0 (0) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[147, 175, 63, 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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: true
HasM: true
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
PR
( type: esriFieldTypeString, alias: PR, length: 7 )
PR_NUM
( type: esriFieldTypeInteger, alias: PR )
PR_NAME
( type: esriFieldTypeString, alias: PrRoadName, length: 50 )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Shape.STLength()
( type: esriFieldTypeDouble, alias: Shape.STLength() )
Relationships:
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (4) --
Related To
:
Culvert Inventory
(0)
Layer:
Culvert Inventory
(0)
Name:
Culvert Inventory
Display Field:
strucname
Type:
Feature Layer
Geometry Type:
esriGeometryPolyline
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
24000.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Has Labels:
false
Can Modify Layer:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports Datum Transformation:
true
Extent:
XMin: 150943.44927328778
YMin: 128046.86168908514
XMax: 797356.3800577784
YMax: 778215.3679124899
Spatial Reference: 0 (0) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSLSSolid
Color:
[28, 119, 135, 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: false
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: true
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:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
strc_num
( type: esriFieldTypeString, alias: Structure Number, length: 20 )
strc_num_seq
( type: esriFieldTypeInteger, alias: Structure Number Sequence )
strc_type_cd
( type: esriFieldTypeSmallInteger, alias: Structure Type ,
Coded Values:
[1: Sign Cantilever] , [2: Sign Truss] , [3: Culvert less than 10 feet]
, ...2 more...
)
CulvertMaterial
( type: esriFieldTypeString, alias: Culvert Type/Material, length: 50 ,
Coded Values:
[Masonry: Masonry] , [Aluminum: Aluminum] , [Steel: Steel]
, ...9 more...
)
Culv_dsgn_type_cd
( type: esriFieldTypeString, alias: Culvert Design Type, length: 50 ,
Coded Values:
[Corrugated: Corrugated] , [Non-corrugated: Non-corrugated] , [Reinforced Concrete: Reinforced Concrete]
, ...3 more...
)
ServiceStatus
( type: esriFieldTypeSmallInteger, alias: Service Status ,
Coded Values:
[1: Abandoned] , [2: Active] , [3: Proposed]
, ...1 more...
)
strucname
( type: esriFieldTypeString, alias: Structure Name, length: 50 )
invt_field_vrfy_date
( type: esriFieldTypeDate, alias: Field Verification Date, length: 8 )
invt_field_vrfy_user
( type: esriFieldTypeString, alias: Inventory Field Verification User, length: 255 )
invt_field_vrfy_cmpy_cd
( type: esriFieldTypeSmallInteger, alias: Field Verification Company ,
Coded Values:
[1: MDOT] , [2: HNTB] , [3: Collins]
, ...6 more...
)
invt_field_comm
( type: esriFieldTypeString, alias: Field Verification Comments, length: 1000 )
next_insp_freq
( type: esriFieldTypeDouble, alias: Next Inspection Frequency )
antcp_insp_date
( type: esriFieldTypeDate, alias: Anticipated Inspection Date, length: 8 )
aadt
( type: esriFieldTypeInteger, alias: AADT )
aadt_yr
( type: esriFieldTypeSmallInteger, alias: AADT Year )
owner_cd
( type: esriFieldTypeSmallInteger, alias: Structure Owner ,
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 ,
Coded Values:
[1: MDOT] , [99: Other] )
custodian_name_cd
( type: esriFieldTypeSmallInteger, alias: Structure Maintainer ,
Coded Values:
[1: MDOT] , [99: Other] )
acs_cd
( type: esriFieldTypeSmallInteger, alias: Access Requirements ,
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, length: 1000 )
trfc_ctrl_cd
( type: esriFieldTypeSmallInteger, alias: Traffic Control Needs ,
Coded Values:
[1: Shoulder closure] , [2: Single lane closure] , [3: Full road closure]
, ...2 more...
)
trfc_ctrl_note
( type: esriFieldTypeString, alias: Traffic Control Notes, length: 1000 )
rail_coord_cd
( type: esriFieldTypeSmallInteger, alias: Railroad Coordination Required? ,
Coded Values:
[1: Yes] , [2: No] )
rail_name_cd
( type: esriFieldTypeSmallInteger, alias: Railroad Name ,
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 ,
Coded Values:
[1: 555-555-5555 (RR Name1)] )
JobNumber
( type: esriFieldTypeString, alias: Job Number Installed or Refurb, length: 12 )
prmy_xstr
( type: esriFieldTypeString, alias: Primary Cross Street, length: 50 )
location
( type: esriFieldTypeString, alias: Location Description, length: 100 )
legal_cd
( type: esriFieldTypeSmallInteger, alias: MDOT Legal System ,
Coded Values:
[1: MDOT] , [2: County Primary] , [3: County Local]
, ...3 more...
)
nrst_rte_drtn_cd
( type: esriFieldTypeSmallInteger, alias: Route Travel Direction ,
Coded Values:
[1: NB] , [2: SB] , [3: WB]
, ...1 more...
)
mile_mrkr
( type: esriFieldTypeDouble, alias: Mile Marker )
PR
( type: esriFieldTypeString, alias: Physical Reference ID number, length: 14 )
PRMP
( type: esriFieldTypeDouble, alias: PR Milepoint )
cs
( type: esriFieldTypeInteger, alias: CS Control Section )
cs_mp
( type: esriFieldTypeDouble, alias: CS Milepoint )
placecode_cd
( type: esriFieldTypeInteger, alias: City ,
Coded Values:
[200: Acme Township] , [240: Ada Township] , [280: Adams Township]
, ...1517 more...
)
mdot_regn_cd
( type: esriFieldTypeSmallInteger, alias: MDOT Region ,
Coded Values:
[1: Superior] , [2: North] , [3: Grand]
, ...4 more...
)
mdotcnty_cd
( type: esriFieldTypeInteger, alias: MDOT County ,
Coded Values:
[1: Alcona] , [3: Alger] , [5: Allegan]
, ...80 more...
)
mdot_tsc_cd
( type: esriFieldTypeInteger, alias: TSC ,
Coded Values:
[22: Newberry] , [19: Marshall] , [1: Alpena]
, ...19 more...
)
grg_cd
( type: esriFieldTypeSmallInteger, alias: Garage ,
Coded Values:
[1: Garage] )
precise_lat_barrel_start
( type: esriFieldTypeDouble, alias: Start Latitude )
precise_lon_barrel_start
( type: esriFieldTypeDouble, alias: Start Longitude )
precise_lat_barrel_end
( type: esriFieldTypeDouble, alias: End Latitude )
precise_lon_barrel_end
( type: esriFieldTypeDouble, alias: End Longitude )
SpatialQualityIndex
( type: esriFieldTypeString, alias: Spatial Quality Index, length: 255 ,
Coded Values:
[A: Survey Grade-3D] , [B: Survey Grade-2D] , [C: Mapping Grade]
, ...2 more...
)
Beneath
( type: esriFieldTypeSmallInteger, alias: Beneath ,
Coded Values:
[1: Mainline] , [2: Ramp] , [3: Service Drive]
, ...6 more...
)
Comments
( type: esriFieldTypeString, alias: Comments, length: 4000 )
CulvertHeight
( type: esriFieldTypeDouble, alias: Culvert Height )
CulvertShape
( type: esriFieldTypeSmallInteger, alias: Culvert Shape ,
Coded Values:
[1: Circular] , [2: Horizontal Elliptical] , [3: Vertical Elliptical]
, ...10 more...
)
CulvertWidth
( type: esriFieldTypeDouble, alias: Culvert Width (inches) )
culv_span
( type: esriFieldTypeString, alias: Culvert Span, length: 255 )
depth_cover_feet
( type: esriFieldTypeDouble, alias: Depth of Cover (ft) )
DitchVegetation
( type: esriFieldTypeSmallInteger, alias: Ditch Vegetation ,
Coded Values:
[1: None] , [2: Partial] , [3: Full] )
InspectionDate
( type: esriFieldTypeDate, alias: Last Inspected Date, length: 8 )
Liner
( type: esriFieldTypeSmallInteger, alias: Liner ,
Coded Values:
[1: Yes] , [2: No] )
LinerDiameter
( type: esriFieldTypeDouble, alias: Liner Diameter )
LinerMaterial
( type: esriFieldTypeSmallInteger, alias: Liner Material ,
Coded Values:
[1: Plastic-Smooth] , [2: Plastic-Corrugated] , [3: CIPP]
, ...4 more...
)
Route
( type: esriFieldTypeInteger, alias: Route ,
Coded Values:
[1: I-69] , [2: I-75] , [3: I-94]
, ...270 more...
)
StreamSubstrate
( type: esriFieldTypeSmallInteger, alias: Stream Substrate ,
Coded Values:
[1: Cobble] , [2: Gravel] , [3: Sand]
, ...4 more...
)
Surface
( type: esriFieldTypeSmallInteger, alias: Roadway Surface ,
Coded Values:
[1: No Deficiency] , [2: Cracked] , [3: Pothole(s)]
, ...4 more...
)
rdwy_surf_cd
( type: esriFieldTypeString, alias: Roadway Surface Type, length: 50 ,
Coded Values:
[Asphalt: Asphalt] , [Brick: Brick] , [Concrete: Concrete]
, ...3 more...
)
flow_dir_cd
( type: esriFieldTypeSmallInteger, alias: Flow Direction ,
Coded Values:
[1: N] , [2: NE] , [3: E]
, ...5 more...
)
NumberofBarrelsCells
( type: esriFieldTypeSmallInteger, alias: Number of Barrels Cells )
CulvertLengthCalculated
( type: esriFieldTypeDouble, alias: Culvert Length Calculated )
skew_ang
( type: esriFieldTypeDouble, alias: Skew Angle )
NumberofLanes
( type: esriFieldTypeSmallInteger, alias: Number of Lanes )
DesignDischargeCFS
( type: esriFieldTypeDouble, alias: Design Discharge (CFS) )
DrainageAreaAcres
( type: esriFieldTypeDouble, alias: Drainage Area Acres )
InletProtection
( type: esriFieldTypeSmallInteger, alias: Inlet Protection ,
Coded Values:
[1: Yes] , [2: No] )
OutletProtection
( type: esriFieldTypeSmallInteger, alias: Outlet Protection ,
Coded Values:
[1: Yes] , [2: No] )
perch_outlet_cd
( type: esriFieldTypeSmallInteger, alias: Perched outlet present? ,
Coded Values:
[1: Yes] , [2: No] )
last_insp_date
( type: esriFieldTypeDate, alias: Last Inspection Date, length: 8 )
last_cpnt_rating_cd
( type: esriFieldTypeSmallInteger, alias: Last Component Rating ,
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 ,
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 ,
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, length: 50 )
rr_div
( type: esriFieldTypeString, alias: Railroad Division, length: 50 )
rr_mp
( type: esriFieldTypeDouble, alias: Railroad Milepost )
rr_xstr
( type: esriFieldTypeString, alias: Nearest cross-roads, length: 50 )
rr_num_trck_cross
( type: esriFieldTypeSmallInteger, alias: Number of tracks crossed )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
yearbuilt
( type: esriFieldTypeSmallInteger, alias: Year Built )
owner_specialty_area_cd
( type: esriFieldTypeString, alias: Owner Specialty Area, length: 255 ,
Coded Values:
[1: Ancillary Structures] , [2: ITS] , [3: Structures] )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Shape.STLength()
( type: esriFieldTypeDouble, alias: Shape.STLength() )
Relationships:
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertWorkRecommendation (0) --
Related To
:
Work Rec
(4)
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertRfa (1) --
Related To
:
RFA
(2)
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspection (3) --
Related To
:
Inspection
(1)
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertEndInventory (5) --
Related To
:
Culvert End
(6)
MDOT_SDE.MDOT_SDE_ADMIN.MdotLrsV21PrTrunkline (4) --
Related To
:
Trunkline
(5)
Tables:
Table:
Culvert End
(6)
Name:
Culvert End
Display Field:
Bound
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
Bound
( type: esriFieldTypeSmallInteger, alias: Bound ,
Coded Values:
[1: NB] , [2: SB] , [3: WB]
, ...1 more...
)
ConditionIndex
( type: esriFieldTypeSmallInteger, alias: Condition Index ,
Coded Values:
[0: 0 - Failed] , [1: 1 - Imminent Failure] , [2: 2 - Critical]
, ...8 more...
)
CulvertEndID
( type: esriFieldTypeGUID, alias: CulvertEndID, length: 38 )
CulvertID
( type: esriFieldTypeGUID, alias: CulvertID, length: 38 )
EmbankmentCondition
( type: esriFieldTypeSmallInteger, alias: Embankment Condition )
EndExtension
( type: esriFieldTypeSmallInteger, alias: End Extension ,
Coded Values:
[1: Yes] , [2: No] )
EndLocation
( type: esriFieldTypeSmallInteger, alias: End Location ,
Coded Values:
[1: North] , [2: South] , [3: East]
, ...1 more...
)
EndSection
( type: esriFieldTypeSmallInteger, alias: End Section ,
Coded Values:
[1: None] , [2: Headwall] , [3: Headwall W/ Wingwalls]
, ...5 more...
)
EndSectionDetached
( type: esriFieldTypeSmallInteger, alias: End Section Detached ,
Coded Values:
[1: Yes] , [2: No] )
EndSectionMaterial
( type: esriFieldTypeSmallInteger, alias: End Section Material ,
Coded Values:
[1: Metal] , [2: Concrete] , [3: Clay]
, ...2 more...
)
ExtensionDimeSameAsCulvert
( type: esriFieldTypeSmallInteger, alias: Extension Dime Same As Culvert ,
Coded Values:
[1: Yes] , [2: No] )
ExtensionMaterialSameAsCulvert
( type: esriFieldTypeSmallInteger, alias: Extension Material Same As Culvert ,
Coded Values:
[1: Yes] , [2: No] )
ExtensionShapeSameAsCulvert
( type: esriFieldTypeSmallInteger, alias: Extension Shape Same As Culvert ,
Coded Values:
[1: Yes] , [2: No] )
FootingExposed
( type: esriFieldTypeSmallInteger, alias: Footing Exposed ,
Coded Values:
[1: Yes] , [2: No] )
InstallYear
( type: esriFieldTypeSmallInteger, alias: Install Year )
InvertAboveChannelBottom
( type: esriFieldTypeSmallInteger, alias: Invert Above Channel Bottom ,
Coded Values:
[1: Yes] , [2: No] )
scour_prot_type_cd
( type: esriFieldTypeSmallInteger, alias: Scour Protection Type ,
Coded Values:
[1: Plain Riprap] , [2: Heavy Riprap] , [3: Field Stone]
, ...7 more...
)
Riprap
( type: esriFieldTypeSmallInteger, alias: Riprap ,
Coded Values:
[1: Yes] , [2: No] )
RiprapCondition
( type: esriFieldTypeSmallInteger, alias: Riprap Condition )
SafetyGrate
( type: esriFieldTypeSmallInteger, alias: Safety Grate ,
Coded Values:
[1: Yes] , [2: No] )
ScourPresent
( type: esriFieldTypeSmallInteger, alias: Scour Present ,
Coded Values:
[1: Yes] , [2: No] )
SedimentDepthGreater20
( type: esriFieldTypeSmallInteger, alias: Sediment Depth Greater 20 ,
Coded Values:
[1: Yes] , [2: No] )
EndSectionExtLength_ft
( type: esriFieldTypeDouble, alias: End Section Extension Length (ft) )
EndSectionRemarks
( type: esriFieldTypeString, alias: End Section Remarks, length: 1000 )
invt_field_vrfy_date
( type: esriFieldTypeDate, alias: Field Verification Date, length: 8 )
invt_field_vrfy_user
( type: esriFieldTypeString, alias: Inventory Field Verification User, length: 255 )
invt_field_vrfy_cmpy_cd
( type: esriFieldTypeSmallInteger, alias: Field Verification Company ,
Coded Values:
[1: MDOT] , [2: HNTB] , [3: Collins]
, ...6 more...
)
UserCreate
( type: esriFieldTypeString, alias: User Create, length: 255 )
SystemCreateDate
( type: esriFieldTypeDate, alias: System Create Date, length: 8 )
UserModified
( type: esriFieldTypeString, alias: User Modified, length: 255 )
SystemModifiedDate
( type: esriFieldTypeDate, alias: System Modified Date, length: 8 )
Relationships:
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInventory (5) --
Related To
:
Culvert Inventory
(0)
Table:
Inspection QA/QC
(7)
Name:
Inspection QA/QC
Display Field:
revw_name
Type:
Table
Geometry Type:
N/A
Description:
null
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
revw_name
( type: esriFieldTypeString, alias: Name of Reviewer/Updater, length: 255 )
revw_cmpy_cd
( type: esriFieldTypeSmallInteger, alias: Company of Reviewer ,
Coded Values:
[1: MDOT] , [2: HNTB] , [3: Collins]
, ...6 more...
)
revw_date
( type: esriFieldTypeDate, alias: Review Date, length: 8 )
revw_type_cd
( type: esriFieldTypeSmallInteger, alias: Quality Review Type ,
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, length: 3999 )
revw_stat_cd
( type: esriFieldTypeSmallInteger, alias: Quality Status After Review Complete ,
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), length: 38 )
qa_stat_cd
( type: esriFieldTypeSmallInteger, alias: QA Status After Review Complete ,
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, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
Relationships:
MDOT_SDE.MDOT_SDE_ADMIN.MdotCulvertInspection (2) --
Related To
:
Inspection
(1)