Name: Pedestrian Bridges

Display Field: pedestrian_bridge_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

This inventory of Detroit pedestrian bridges and their condition assessments is derived from the Michigan Department of Transportation (MDOT) and includes pedestrian bridges that span State of Michigan roadways only.

Inspections of pedestrian bridges over State of Michigan routes are performed on a risk-based interval by MDOT, not to exceed 24 months. While not governed by the National Bridge Inspection Standards, these inspections are performed to maintain safety of the traveled way and to provide information needed for asset management. Routine Inspections of the entire structure may be supplemented by Special Inspections of Bridge Components that require more frequent monitoring.

Condition ratings for pedestrian bridges are evaluated following the National Bridge Inventory Condition Ratings in a similar manner to vehicle bridges. These ratings are based on a 0-9 scale, where 0 is "Failed condition" and 9, "Excellent condition". Condition ratings are assigned for the deck, superstructure and substructure of each bridge or for each culvert. A culvert is a structure that allows passage under a roadway and has a short span (less than 20 feet).

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.250966667
YMin: 42.3151111110001
XMax: -82.940147222
YMax: 42.4375416670001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[65,61,175,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• pedestrian_bridge_id (type: esriFieldTypeString, alias: Pedestrian Bridge ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• facility (type: esriFieldTypeString, alias: Facility, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• feature_intersection (type: esriFieldTypeString, alias: Feature Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• structure_number (type: esriFieldTypeInteger, alias: Structure Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• year_built (type: esriFieldTypeInteger, alias: Year Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• year_reconstructed (type: esriFieldTypeDouble, alias: Year Reconstructed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inspection_date (type: esriFieldTypeDateOnly, alias: Inspection Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• inspection_frequency (type: esriFieldTypeInteger, alias: Inspection Frequency, SQL Type: sqlTypeOther, nullable: true, editable: true)
• minimum_condition (type: esriFieldTypeInteger, alias: Minimum Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• operational_status_code (type: esriFieldTypeString, alias: Operational Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• structure_type_code (type: esriFieldTypeInteger, alias: Structure Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• structure_type_material_code (type: esriFieldTypeInteger, alias: Material Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• structure_type_design_code (type: esriFieldTypeInteger, alias: Design Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• service_type_on (type: esriFieldTypeInteger, alias: Service Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• temporary_structure_designation (type: esriFieldTypeString, alias: Temporary Structure, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• scour_critical_bridges_code (type: esriFieldTypeString, alias: Scour Critical, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• posted_loading_code (type: esriFieldTypeString, alias: Posted Loading, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• deck_condition_rating (type: esriFieldTypeString, alias: Deck Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• superstructure_condition_rating (type: esriFieldTypeString, alias: Superstructure Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• substructure_condition_rating (type: esriFieldTypeInteger, alias: Substructure Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• culvert_condition_rating (type: esriFieldTypeString, alias: Culvert Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• area (type: esriFieldTypeInteger, alias: Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: detroit_pedestrian_bridges
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/11/2025 12:21:15 PM

Schema Last Edit Date: 3/11/2025 12:21:15 PM

Data Last Edit Date: 3/6/2025 6:00:15 AM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat