20251118
10524700
1.0
FALSE
MdotCulvertInventory
002
Geographic
GCS_WGS_1984
Angular Unit: Degree (0.017453)
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.8.0'><WKT>GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4326]]</WKT><XOrigin>-400</XOrigin><YOrigin>-400</YOrigin><XYScale>999999999.99999988</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>8.98315284119521e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4326</WKID><LatestWKID>4326</LatestWKID></GeographicCoordinateSystem>
20210921
10594200
20210921
10594200
Esri ArcGIS 12.8.0.29751
MdotCulvertInventory
Enterprise Geodatabase Feature Class
dataset
EPSG
6.2(3.0.1)
0
Simple
FALSE
0
TRUE
FALSE
MdotCulvertInventory
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
GlobalID
GlobalID
GlobalID
38
0
0
strc_num
Structure Number
String
20
0
0
strc_num_seq
Structure Number Sequence
Integer
4
10
0
strc_type_cd
Structure Type
SmallInteger
2
5
0
CulvertMaterial
Culvert Type/Material
String
50
0
0
Culv_dsgn_type_cd
Culvert Design Type
String
50
0
0
ServiceStatus
Service Status
SmallInteger
2
5
0
strucname
Structure Name
String
50
0
0
dsgn_std_cd
Structure Design Standard
SmallInteger
2
5
0
invt_field_vrfy_date
Field Verification Date
Date
8
0
0
invt_field_vrfy_user
Inventory Field Verification User
String
255
0
0
invt_field_vrfy_cmpy_cd
Field Verification Company
SmallInteger
2
5
0
invt_field_comm
Field Verification Comments
String
1000
0
0
next_insp_freq
Next Inspection Frequency
Double
8
38
8
insp_grp_cd
Inspection Group
SmallInteger
2
5
0
antcp_insp_date
Anticipated Inspection Date
Date
8
0
0
crewhrs
Flagger Hours
Double
8
38
8
aadt
AADT
Integer
4
10
0
aadt_yr
AADT Year
SmallInteger
2
5
0
owner_cd
Structure Owner
SmallInteger
2
5
0
owner_name_cd
Structure Owner Type
SmallInteger
2
5
0
custodian_cd
Custodian
SmallInteger
2
5
0
custodian_name_cd
Structure Maintainer
SmallInteger
2
5
0
acs_cd
Access Requirements
SmallInteger
2
5
0
acs_note
Access Requirements Note
String
1000
0
0
trfc_ctrl_cd
Traffic Control Needs
SmallInteger
2
5
0
trfc_ctrl_note
Traffic Control Notes
String
1000
0
0
rail_coord_cd
Railroad Coordination Required?
SmallInteger
2
5
0
rail_name_cd
Railroad Name
SmallInteger
2
5
0
rail_phne_num_cd
Railroad Phone Number
SmallInteger
2
5
0
JobNumber
Job Number Installed or Refurb
String
12
0
0
CulvertInstallationDate
Culvert Installation Date
Date
8
0
0
yearrecon
Year Reconstructed
SmallInteger
2
5
0
prmy_xstr
Primary Cross Street
String
50
0
0
location
Location Description
String
100
0
0
legal_cd
MDOT Legal System
SmallInteger
2
5
0
nrst_rte_drtn_cd
Route Travel Direction
SmallInteger
2
5
0
mile_mrkr
Mile Marker
Double
8
38
8
PR
Physical Reference ID number
String
14
0
0
PRMP
PR Milepoint
Double
8
38
8
cs
CS Control Section
Integer
4
10
0
cs_mp
CS Milepoint
Double
8
38
8
placecode_cd
City
Integer
4
10
0
mdot_regn_cd
MDOT Region
SmallInteger
2
5
0
mdotcnty_cd
MDOT County
Integer
4
10
0
mdot_tsc_cd
TSC
Integer
4
10
0
grg_cd
Garage
SmallInteger
2
5
0
precise_lat_barrel_start
Start Latitude
Double
8
38
8
precise_lon_barrel_start
Start Longitude
Double
8
38
8
precise_lat_barrel_end
End Latitude
Double
8
38
8
precise_lon_barrel_end
End Longitude
Double
8
38
8
lat_lon_src_cd
Lat Long Source
SmallInteger
2
5
0
SpatialQualityIndex
Spatial Quality Index
String
255
0
0
Beneath
Beneath
SmallInteger
2
5
0
Comments
Comments
String
4000
0
0
ConditionIndex
Condition Index
SmallInteger
2
5
0
CulvertGroupID
CulvertGroupID
String
255
0
0
CulvertHeight
Culvert Height
Double
8
38
8
CulvertShape
Culvert Shape
SmallInteger
2
5
0
CulvertWidth
Culvert Width (ft)
Double
8
38
8
culv_span
Culvert Span
String
255
0
0
DepthOfCover
Depth of Cover more than 5 feet?
SmallInteger
2
5
0
depth_cover_feet
Depth of Cover (ft)
Double
8
38
8
DitchVegetation
Ditch Vegetation
SmallInteger
2
5
0
UserEditedDate
Last Edited Date
Date
8
0
0
InspectionDate
Last Inspected Date
Date
8
0
0
Liner
Liner
SmallInteger
2
5
0
LinerDiameter
Liner Diameter
Double
8
38
8
LinerMaterial
Liner Material
SmallInteger
2
5
0
AssetCollectionDate
New Asset Collection Date
Date
8
0
0
Route
Route
Integer
4
10
0
StreamSubstrate
Stream Substrate
SmallInteger
2
5
0
Surface
Roadway Surface
SmallInteger
2
5
0
rdwy_surf_cd
Roadway Surface Type
String
50
0
0
WaterDepth
Water Depth
Double
8
38
8
flow_dir_cd
Flow Direction
SmallInteger
2
5
0
NumberofBarrelsCells
Number of Barrels Cells
SmallInteger
2
5
0
CulvertLengthCalculated
Culvert Length Calculated
Double
8
38
8
skew_ang
Skew Angle
Double
8
38
8
NumberofLanes
Number of Lanes
SmallInteger
2
5
0
DesignDischargeCFS
Design Discharge (CFS)
Double
8
38
8
DrainageAreaAcres
Drainage Area Acres
Double
8
38
8
InletProtection
Inlet Protection
SmallInteger
2
5
0
OutletProtection
Outlet Protection
SmallInteger
2
5
0
perch_outlet_cd
Perched outlet present?
SmallInteger
2
5
0
last_insp_date
Last Inspection Date
Date
8
0
0
last_insp_user_cd
Last Inspected User
String
255
0
0
last_cpnt_rating_cd
Last Component Rating
SmallInteger
2
5
0
last_insp_qc_stat_cd
Last Inspection QC Status
SmallInteger
2
5
0
last_insp_qa_stat_cd
Last Inspection QA Status
SmallInteger
2
5
0
num_work_rec_open
Number of Open Work Recs
SmallInteger
2
5
0
rfa_stat_cd
RFA Status
SmallInteger
2
5
0
rr_op_name
Railroad Operator Name
String
50
0
0
rr_div
Railroad Division
String
50
0
0
rr_mp
Railroad Milepost
Double
8
38
8
rr_xstr
Nearest cross-roads
String
50
0
0
rr_num_trck_cross
Number of tracks crossed
SmallInteger
2
5
0
created_user
created_user
String
255
0
0
created_date
created_date
Date
8
0
0
last_edited_user
last_edited_user
String
255
0
0
last_edited_date
last_edited_date
Date
8
0
0
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
Shape.STLength()
Shape.STLength()
Double
0
0
0
20210921