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)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata