Layer: AGS_MAINT_PARKS.PARKS_ADMIN.parks_bridges_pdx

View In: Map Viewer

Name: AGS_MAINT_PARKS.PARKS_ADMIN.parks_bridges_pdx_2021

Display Field: Trail_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Condition assessment of PP&R bridges including data on materials, individual component conditions, and functionality. Data collection began in July 2021 and is currently ongoing.

Copyright Text: Portland Parks & Recreation

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","valueExpression":"var ColumnWeight = 0.14\nvar ColumnRate = $feature[\"Pier_Bents_Column_Condition\"]\n\nvar GirderWeight = 0.14\nvar GirderRate = $feature[\"Girder_Condition\"]\n\nvar FoundationWeight = 0.13\nvar FoundationRate = $feature[\"Foundation_Condition\"]\n\nvar BeamWeight = 0.14\nvar BeamRate = $feature[\"Beams_Condition\"]\n\nvar BearingWeight = 0.09\nvar BearingRate = $feature[\"Bearing_Condition\"]\n\nvar DeckingWeight = 0.08\nvar DeckingRate = $feature[\"Deck_Condition\"]\n\nvar ConnectionWeight = 0.09\nvar ConnectionRate = $feature[\"Connection_Condition\"]\n\nvar StringersWeight = 0.07\nvar StringersRate = $feature[\"Stringers_Condition\"]\n\nvar HandrailWeight = 0.05\nvar HandrailRate = $feature[\"Handrail_Condition\"]\n\nvar Abutment_and_Wall_Weight = 0.07\nvar Abutment_and_Wall_Rate = $feature[\"Abutment_and_Wall_Condition\"]\n\n\n\nvar Column = IIf(ColumnRate!=0, ColumnWeight, 0)\nvar Girder = IIf(GirderRate!=0, GirderWeight, 0)\nvar Foundation = IIf(FoundationRate!=0, FoundationWeight, 0)\nvar Beam = IIf(BeamRate!=0, BeamWeight, 0)\nvar Bearing1 = IIf(BearingRate!=0, BearingWeight, 0)\nvar Decking = IIf(DeckingRate!=0, DeckingWeight, 0)\nvar Connection = IIf(ConnectionRate!=0, ConnectionWeight, 0)\nvar Stringers = IIf(StringersRate!=0, StringersWeight, 0)\nvar Handrail = IIf(HandrailRate!=0, HandrailWeight, 0)\nvar Abutment_and_Wall = IIf(Abutment_and_Wall_Rate!=0, Abutment_and_Wall_Weight, 0)\n\nvar MagnificationFactor = 1/(Column+Girder+Foundation+Beam+Bearing1+Decking+Connection+Stringers+Handrail+Abutment_and_Wall)\n\nvar Non5Ratings = (ColumnWeight*ColumnRate+\nGirderWeight*GirderRate+\nFoundationWeight*FoundationRate+\nBeamWeight*BeamRate+\nBearingWeight*BearingRate+\nDeckingWeight*DeckingRate+\nConnectionWeight*ConnectionRate+\nStringersWeight*StringersRate+\nHandrailWeight*HandrailRate+\nAbutment_and_Wall_Weight*Abutment_and_Wall_Rate)*MagnificationFactor\n\nvar RawEQ = IIf(When(ColumnRate==5, True, GirderRate==5, True, BeamRate==5, True, False), 5, Non5Ratings)\nvar RoundedEQ = Round(RawEQ, 0)\n\nreturn RoundedEQ\n","valueExpressionTitle":"OverallBridgeRating","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[178,178,178,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"0","label":"0"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[38,115,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"1","label":"1"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[112,168,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"2","label":"2"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[230,230,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"3","label":"3"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[230,152,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"4","label":"4"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[168,0,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"5","label":"5"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,252,255],"toColor":[212,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,252,255],"toColor":[252,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,195,179,255],"toColor":[252,195,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,179,255],"toColor":[179,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,208,252,255],"toColor":[204,208,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,252,189,255],"toColor":[252,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,197,227,255],"toColor":[252,197,227,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,214,255],"toColor":[212,252,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[196,179,252,255],"toColor":[196,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,230,199,255],"toColor":[252,230,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,230,252,255],"toColor":[212,230,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[236,202,252,255],"toColor":[236,202,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[213,252,179,255],"toColor":[213,252,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
PropertyID (type: esriFieldTypeInteger, alias: PropertyID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Property (type: esriFieldTypeString, alias: Property, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
Date_Assessed (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Trail_Name (type: esriFieldTypeString, alias: Trail Name, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
Landmarks (type: esriFieldTypeString, alias: Nearby Landmarks, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Length (type: esriFieldTypeDouble, alias: Length (decimal feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
Width (type: esriFieldTypeDouble, alias: Width (Decimal Feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
Station (type: esriFieldTypeString, alias: Station (or milepost), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
Foundation_Material (type: esriFieldTypeString, alias: Foundation Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Foundation_Other (type: esriFieldTypeString, alias: Foundation Material (If Other), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Pier_Bents_Column_Material (type: esriFieldTypeString, alias: Pier / Bents / Column Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Pier_Bents_Column_Other (type: esriFieldTypeString, alias: Pier / Bents / Column Material (If Other), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Decking_Materials (type: esriFieldTypeString, alias: Decking_Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Decking_Other (type: esriFieldTypeString, alias: Decking (If Other), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Bridge_Signage (type: esriFieldTypeString, alias: Signage On Bridge, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
Bridge_Signage_Desc (type: esriFieldTypeString, alias: Bridge Signage Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Decking_ADA (type: esriFieldTypeString, alias: Decking ADA Compliant, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
Fall_Hazard (type: esriFieldTypeString, alias: Fall Hazard, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [1 ft. to 3 ft.: 1 ft. to 3 ft.], [3 ft. to 6 ft.: 3 ft. to 6 ft.], [More than 6 ft.: More than 6 ft.])
Specialty_Inspection (type: esriFieldTypeString, alias: Specialty Inspection Needed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true, Coded Values: [Active: Active], [Closed: Closed], [Demolished: Demolished])
UniqueID_from_OID (type: esriFieldTypeInteger, alias: UniqueID, SQL Type: sqlTypeOther, nullable: true, editable: true)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
BridgeID (type: esriFieldTypeInteger, alias: Bridge ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Classification (type: esriFieldTypeString, alias: Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Complex: Complex], [Major: Major], [Minor: Minor], ... 1 more ...)
Design_Capacity (type: esriFieldTypeInteger, alias: Design Capacity (Tons), SQL Type: sqlTypeOther, nullable: true, editable: true)
Span_count (type: esriFieldTypeSmallInteger, alias: Span (count), SQL Type: sqlTypeOther, nullable: true, editable: true)
Foundation_Condition (type: esriFieldTypeInteger, alias: Foundation Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Pier_Bents_Column_Condition (type: esriFieldTypeInteger, alias: Pier Bents Column Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Girder_Materials (type: esriFieldTypeString, alias: Girder Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Girder_Materials_Other (type: esriFieldTypeString, alias: Girder Material (If Other), SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
Girder_Condition (type: esriFieldTypeInteger, alias: Girder Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Bearing_Material (type: esriFieldTypeString, alias: Bearing Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Bearing_Condition (type: esriFieldTypeInteger, alias: Bearing Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Deck_Condition (type: esriFieldTypeInteger, alias: Deck Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Connection_Material (type: esriFieldTypeString, alias: Connection Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Connection_Condition (type: esriFieldTypeInteger, alias: Connection Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Beams_Material (type: esriFieldTypeString, alias: Beams Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Beams_Condition (type: esriFieldTypeInteger, alias: Beams Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Stringers_Material (type: esriFieldTypeString, alias: Stringers Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Stringers_Condition (type: esriFieldTypeInteger, alias: Stringers Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Handrail_Material (type: esriFieldTypeString, alias: Handrail Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Handrail_Condition (type: esriFieldTypeInteger, alias: Handrail Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Kick_Rail_Material (type: esriFieldTypeString, alias: Kick Rail Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Kick_Rail_Condition (type: esriFieldTypeInteger, alias: Kick_Rail_Condition (0-5), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Drainage_Issue (type: esriFieldTypeString, alias: Is There A Drainage Issue?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
Drainage_Issue_Desc (type: esriFieldTypeString, alias: Drainage Issue Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
General_Notes (type: esriFieldTypeString, alias: General Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
Magnification_Factor (type: esriFieldTypeDouble, alias: Magnification Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
Weighted_Overall_Condition (type: esriFieldTypeInteger, alias: Weighted Overall Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
Abutment_and_Wall_Material (type: esriFieldTypeString, alias: Abutment And Wall Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Bark ADA: Bark ADA], [Barkchip: Barkchip], ... 23 more ...)
Abutment_and_Wall_Condition (type: esriFieldTypeInteger, alias: Abutment And Wall Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 5])
Erosion_effect (type: esriFieldTypeString, alias: Erosion Effect, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: N/A])
Assessment_Complete (type: esriFieldTypeString, alias: Assessment Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [pending: pending])
BridgeID_text (type: esriFieldTypeString, alias: Bridge ID text, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/13/2025 4:17:24 PM

Schema Last Edit Date: 3/13/2025 4:17:24 PM

Data Last Edit Date: 3/13/2025 4:14:29 PM

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

Layer: AGS_MAINT_PARKS.PARKS_ADMIN.parks_bridges_pdx_2021 (ID:0)