Name: System Conditions - Bridges

Display Field: BRIDGE_NUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a point displayed dataset of in-service bridge locations throughout Minnesota. Data is gathered from bridge construction plans, inspection reports, load ratings and clearance forms prepared by all Minnesota agencies that own and maintain structures. This data is exported daily from the Structure Information Management System (SIMS) and included in the feature class attribute table. The Data is maintained by the Bridge Inventory Management Unit located at the MnDOT Bridge Office. The attribute table currently contains the following data:Bridge Number, Latitude/Longitude, UTM X/Y, Location Description, MnDOT District, County, Service Description, Year Built, Owner, On/Under Information, AADT/HCAADT, Bridge Type, Bridge Length, Bridge Width, Open/Posted/Closed Status, Load Postings, NBI Ratings/Overall Condition Rating, Scour Code, and Bridge Clearances.

Copyright Text: Minnesota Deaprtment of Transportation, Bridge Inventory Management Unit

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: -10590549.8379717
YMin: 5615736.33177768
XMax: -10413898.4199316
YMax: 5752587.17409487
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Bridge_Score","defaultSymbol":{"type":"esriSMS","style":"esriSMSSquare","color":[230,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"defaultLabel":"N/A","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[212,185,218,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"2","label":"Good (2 pts)"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[201,148,199,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"3","label":"Fair (3 pts)"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[223,101,176,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"4","label":"Satisfactory (4 pts)"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[221,28,119,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"5","label":"Poor (5 pts)"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,237,245,255],"toColor":[240,237,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[216,182,217,255],"toColor":[216,182,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[222,100,175,255],"toColor":[222,100,175,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,19,88,255],"toColor":[207,19,88,255]}]}}},"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: Bridge_Score

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• BRIDGE_NUMBER (type: esriFieldTypeString, alias: BRIDGE_NUMBER, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeString, alias: LATITUDE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeString, alias: LONGITUDE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• UTM_X (type: esriFieldTypeDouble, alias: UTM_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UTM_Y (type: esriFieldTypeDouble, alias: UTM_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCATION_DESC (type: esriFieldTypeString, alias: LOCATION_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MNDOT_DISTRICT (type: esriFieldTypeString, alias: MNDOT_DISTRICT, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• COUNTY_CODE (type: esriFieldTypeDouble, alias: COUNTY_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COUNTY_DESC (type: esriFieldTypeString, alias: COUNTY_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SERVICE_CODE (type: esriFieldTypeString, alias: SERVICE_CODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SERVICE_DESC (type: esriFieldTypeString, alias: SERVICE_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• YEAR_BUILT (type: esriFieldTypeSmallInteger, alias: YEAR_BUILT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OWNER_CODE (type: esriFieldTypeDouble, alias: OWNER_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OWNER_DESC (type: esriFieldTypeString, alias: OWNER_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ON_UNDER_CODE (type: esriFieldTypeString, alias: ON_UNDER_CODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ON_UNDER_DESC (type: esriFieldTypeString, alias: ON_UNDER_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• AADT (type: esriFieldTypeDouble, alias: AADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HCAADT (type: esriFieldTypeDouble, alias: HCAADT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AADT_YEAR (type: esriFieldTypeSmallInteger, alias: AADT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BRIDGE_TYPE_CODE (type: esriFieldTypeString, alias: BRIDGE_TYPE_CODE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• BRIDGE_TYPE_DESC (type: esriFieldTypeString, alias: BRIDGE_TYPE_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LENGTH_FEET (type: esriFieldTypeString, alias: LENGTH_FEET, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• WIDTH_FEET (type: esriFieldTypeString, alias: WIDTH_FEET, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• STATUS_CODE (type: esriFieldTypeString, alias: STATUS_CODE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STATUS_DESC (type: esriFieldTypeString, alias: STATUS_DESC, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• INVENTORY_RATING (type: esriFieldTypeString, alias: INVENTORY_RATING, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• VEHICLE_POSTED_CAPACITY (type: esriFieldTypeString, alias: VEHICLE_POSTED_CAPACITY, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• SEMI_POSTED_CAPACITY (type: esriFieldTypeString, alias: SEMI_POSTED_CAPACITY, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• DOUBLE_POSTED_CAPACITY (type: esriFieldTypeString, alias: DOUBLE_POSTED_CAPACITY, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• MNDOT_PERMIT_CODE_ABC (type: esriFieldTypeString, alias: MNDOT_PERMIT_CODE_ABC, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• DECK_RATING (type: esriFieldTypeString, alias: DECK_RATING, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SUPERSTRUCTURE_RATING (type: esriFieldTypeString, alias: SUPERSTRUCTURE_RATING, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SUBSTRUCTURE_RATING (type: esriFieldTypeString, alias: SUBSTRUCTURE_RATING, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CULVERT_RATING (type: esriFieldTypeString, alias: CULVERT_RATING, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MN_SCOUR_CODE (type: esriFieldTypeString, alias: MN_SCOUR_CODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• VERTICAL_CLR_RD1_FEET (type: esriFieldTypeString, alias: VERTICAL_CLR_RD1_FEET, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• VERTICAL_CLR_RD2_FEET (type: esriFieldTypeString, alias: VERTICAL_CLR_RD2_FEET, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• HORIZONTAL_CLR_RD1_FEET (type: esriFieldTypeString, alias: HORIZONTAL_CLR_RD1_FEET, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• HORIZONTAL_CLR_RD2_FEET (type: esriFieldTypeString, alias: HORIZONTAL_CLR_RD2_FEET, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• Fed_Aid (type: esriFieldTypeString, alias: Fed_Aid, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RATING_SUMMARY (type: esriFieldTypeString, alias: RATING_SUMMARY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Bridge_Score (type: esriFieldTypeInteger, alias: Bridge Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Display (type: esriFieldTypeInteger, alias: Display, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: 2
Name: Good (2 pts)
Domains:

Templates:

Name: 2
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Bridge_Score: 2

---

ID: 3
Name: Fair (3 pts)
Domains:

Templates:

Name: 3
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Bridge_Score: 3

---

ID: 4
Name: Satisfactory (4 pts)
Domains:

Templates:

Name: 4
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Bridge_Score: 4

---

ID: 5
Name: Poor (5 pts)
Domains:

Templates:

Name: 5
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Bridge_Score: 5

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/11/2022 8:53:13 PM

Schema Last Edit Date: 5/11/2022 8:53:13 PM

Data Last Edit Date: 5/11/2022 8:53:13 PM

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