Layer: Middleton_Centerlines_PavementRating

View In: Map Viewer

Name: Middleton_Centerlines_PavementRating_FINAL

Display Field: fullStreetName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

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:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"PASER_Rating_2023","defaultSymbol":null,"uniqueValueInfos":[{"value":"1","symbol":{"color":[237,81,81,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"1 - Resurfacing"},{"value":"2","symbol":{"color":[237,81,81,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"2 - Resurfacing"},{"value":"3","symbol":{"color":[237,81,81,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"3 - Resurfacing"},{"value":"4","symbol":{"color":[237,81,81,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"4 - Resurfacing"},{"value":"5","symbol":{"color":[237,81,81,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"5 - Resurfacing"},{"value":"6","symbol":{"color":[255,255,0,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"6 - Chip Seal"},{"value":"7","symbol":{"color":[255,255,0,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"7 - Crack Fill"},{"value":"8","symbol":{"color":[56,168,0,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"8 - Crack Fill"},{"value":"9","symbol":{"color":[56,168,0,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"9 - No Action"},{"value":"10","symbol":{"color":[56,168,0,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"10 - No Action"},{"value":"-1","symbol":{"color":[194,194,194,255],"width":3,"type":"esriSLS","style":"esriSLSSolid"},"label":"Non-City Roads"}]},"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: PASER_Rating_2023

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
StreetSegmentID_Numerical (type: esriFieldTypeInteger, alias: StreetSegmentID Numerical, SQL Type: sqlTypeOther, nullable: true, editable: true)
StreetSegmentID_Text (type: esriFieldTypeString, alias: Street Segment ID Text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fullStreetName (type: esriFieldTypeString, alias: Full Street Name, SQL Type: sqlTypeOther, length: 406, nullable: true, editable: true, Coded Values: [Adler Circle: Adler Circle], [Airport Road: Airport Road], [Airport Road EB US Highway 12 EB On: Airport Road EB US Highway 12 EB On], ... 365 more ...)
abvStreetName (type: esriFieldTypeString, alias: abv Street Name, SQL Type: sqlTypeOther, length: 262, nullable: true, editable: true, Coded Values: [Adler Cir: Adler Cir], [Airport Rd: Airport Rd], [Airport Rd EB USH 12 EB On: Airport Rd EB USH 12 EB On], ... 366 more ...)
RdCode (type: esriFieldTypeString, alias: Road Classification, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [County Highway: County Highway], [Local Road: Local Road], [Named Private Road: Named Private Road], ... 2 more ...)
abvPreDirectional (type: esriFieldTypeString, alias: abvPreDirectional, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
abvPreType (type: esriFieldTypeString, alias: abvPreType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
abvPostType (type: esriFieldTypeString, alias: abvPostType, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
abvPostDirectional (type: esriFieldTypeString, alias: abvPostDirectional, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
FromName (type: esriFieldTypeString, alias: From Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [Adler Cir: Adler Cir], [Airport Rd: Airport Rd], [Airport Rd EB USH 12 EB On: Airport Rd EB USH 12 EB On], ... 347 more ...)
ToName (type: esriFieldTypeString, alias: To Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [Adler Cir: Adler Cir], [Airport Rd: Airport Rd], [Airport Rd EB USH 12 EB On: Airport Rd EB USH 12 EB On], ... 343 more ...)
MaintainedBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CITY OF MADISON: CITY OF MADISON], [CITY OF MIDDLETON: CITY OF MIDDLETON], [DANE COUNTY: DANE COUNTY], ... 8 more ...)
OLD_ID (type: esriFieldTypeInteger, alias: OLD ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OLD_StreetName_Full (type: esriFieldTypeString, alias: OLD StreetName Full, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AADT (type: esriFieldTypeDouble, alias: ADT (our counts), SQL Type: sqlTypeOther, nullable: true, editable: true)
AADT_Year (type: esriFieldTypeDouble, alias: ADT Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
TrafficDir (type: esriFieldTypeString, alias: Traffic Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [North Bound: North Bound], [South Bound: South Bound], [East Bound: East Bound], ... 3 more ...)
AverageSpeed_85p (type: esriFieldTypeString, alias: Average Speed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SpeedDir (type: esriFieldTypeString, alias: Speed Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [North Bound: North Bound], [South Bound: South Bound], [East Bound: East Bound], ... 3 more ...)
YearSpeedCount (type: esriFieldTypeString, alias: Speed Month-Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [County: County], [City: City], [State: State])
Class_MPO_20150304 (type: esriFieldTypeString, alias: Class MPO 20150304, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Local: Local], [Minor Arterial: Minor Arterial], [Arterial: Arterial], ... 1 more ...)
Length_ft (type: esriFieldTypeDouble, alias: Length ft., SQL Type: sqlTypeOther, nullable: true, editable: true)
Length_miles (type: esriFieldTypeDouble, alias: Length Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
With_EE_ft (type: esriFieldTypeDouble, alias: Width E-E ft., SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [12: 12], [16: 16], [18: 18], ... 31 more ...)
Depth_in (type: esriFieldTypeDouble, alias: Depth in., SQL Type: sqlTypeOther, nullable: true, editable: true)
Culdesac_Radius (type: esriFieldTypeString, alias: Culdesac Radius, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Median: Median], [Island: Island], ... 1 more ...)
BaseMaterial_in (type: esriFieldTypeDouble, alias: Base Material in., SQL Type: sqlTypeOther, nullable: true, editable: true)
SurfaceMaterial (type: esriFieldTypeString, alias: Surface Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Concrete: Concrete], [Gravel: Gravel])
CG_Width_ft_Even (type: esriFieldTypeDouble, alias: CG Width ft. Even, SQL Type: sqlTypeOther, nullable: true, editable: true)
CG_Width_ft_Odd (type: esriFieldTypeDouble, alias: CG Width ft. Odd, SQL Type: sqlTypeOther, nullable: true, editable: true)
CG_Type_Even (type: esriFieldTypeString, alias: CG Type Even, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Barrier: Barrier], [Ribbon: Ribbon], [Both: Both], ... 1 more ...)
CG_Type_Odd (type: esriFieldTypeString, alias: CG Type Odd, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Barrier: Barrier], [Ribbon: Ribbon], [Both: Both], ... 1 more ...)
T_Width_ft_Even (type: esriFieldTypeDouble, alias: Terrace Width ft. Even, SQL Type: sqlTypeOther, nullable: true, editable: true)
T_Width_ft_Odd (type: esriFieldTypeDouble, alias: Terrace Width ft. Odd, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROW_ft (type: esriFieldTypeDouble, alias: ROW ft., SQL Type: sqlTypeOther, nullable: true, editable: true)
Sidewalk_Location (type: esriFieldTypeString, alias: Sidewalk Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [1 Side: 1 Side], [2 Sides: 2 Sides], ... 1 more ...)
Sidewalk_Width_ft (type: esriFieldTypeDouble, alias: Sidewalk Width ft., SQL Type: sqlTypeOther, nullable: true, editable: true)
YearCompleted (type: esriFieldTypeDouble, alias: Project Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
ProjectNumber (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ProjectName (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DeveloperName (type: esriFieldTypeString, alias: Developer Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PASER_Rating_2005 (type: esriFieldTypeDouble, alias: PASER Rating 2005, SQL Type: sqlTypeOther, nullable: true, editable: true)
PASER_Date_2005 (type: esriFieldTypeDate, alias: PASER Date 2005, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PASER_Rating_2009 (type: esriFieldTypeDouble, alias: PASER Rating 2009, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)
PASER_Date_2009 (type: esriFieldTypeDate, alias: PASER Date 2009, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PASER_Rating_2011 (type: esriFieldTypeDouble, alias: PASER Rating 2011, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)
PASER_Date_2011 (type: esriFieldTypeDate, alias: PASER Date 2011, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PASER_Rating_2013 (type: esriFieldTypeDouble, alias: PASER Rating 2013, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)
PASER_Date_2013 (type: esriFieldTypeDate, alias: PASER Date 2013, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PASER_Rating_2015 (type: esriFieldTypeDouble, alias: PASER Rating 2015, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)
PASER_Date_2015 (type: esriFieldTypeDate, alias: PASER Date 2015, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PASER_Rating_2017 (type: esriFieldTypeDouble, alias: PASER Rating 2017, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)
PASER_Date_2017 (type: esriFieldTypeDate, alias: PASER Date 2017, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PASER_Rating_2019 (type: esriFieldTypeDouble, alias: PASER Rating 2019, SQL Type: sqlTypeOther, nullable: true, editable: true)
PASER_Date_2019 (type: esriFieldTypeDate, alias: PASER Date 2019, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PASER_Rating_2021 (type: esriFieldTypeDouble, alias: PASER Rating 2021, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)
PASER_Date_2021 (type: esriFieldTypeDate, alias: PASER Date 2021, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
preType (type: esriFieldTypeString, alias: preType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
BaseName (type: esriFieldTypeString, alias: BaseName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
postType (type: esriFieldTypeString, alias: postType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
postDirectional (type: esriFieldTypeString, alias: postDirectional, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Circle_YN (type: esriFieldTypeString, alias: Circle YN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
ADTMonthYear (type: esriFieldTypeString, alias: ADT Month-Year, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
LengthMiles (type: esriFieldTypeDouble, alias: GIS Length Miles, SQL Type: sqlTypeOther, nullable: true, editable: true)
PASER_2019_Label (type: esriFieldTypeDouble, alias: Pavement Rating, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [10: 10 - No Action], [9: 9 - No Action], [8: 8 - Crack Fill], ... 7 more ...)
Utilities (type: esriFieldTypeString, alias: Utilities, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Underground: Underground], [No Underground: No Underground])
ActionType (type: esriFieldTypeString, alias: Action Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Reconstruction: Reconstruction], [Full Depth Resurfacing: Resurfacing], [Chip Seal: Chip Seal], ... 1 more ...)
PriorityRating (type: esriFieldTypeDouble, alias: Priority Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
CostEstimate (type: esriFieldTypeDouble, alias: Cost Estimate, SQL Type: sqlTypeOther, nullable: true, editable: true)
TIF (type: esriFieldTypeString, alias: TIF?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Reconstruction (type: esriFieldTypeString, alias: Reconstruction, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Water and/or Sanitary: Water and/or Sanitary], [Storm/Curb/Base: Storm/Curb/Base])
RoadPlanDashRoadLabel (type: esriFieldTypeString, alias: Road Planning Dashboard Road Name County Relabel, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
PASER_Rating_2023 (type: esriFieldTypeDouble, alias: PASER Rating 2023, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)
PlannedYear (type: esriFieldTypeString, alias: Planned Action Year, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [2026: 2026], [2027: 2027], [2028: 2028], ... 4 more ...)
SqYards (type: esriFieldTypeDouble, alias: Area (sq. yd.), SQL Type: sqlTypeOther, nullable: true, editable: true)
ActualCost (type: esriFieldTypeDouble, alias: Official Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
PASER_Rating_2025 (type: esriFieldTypeDouble, alias: PASER Rating 2025, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 8 more ...)

Types:

TIF: No
PASER_Rating_2023: 1

TIF: No
PASER_Rating_2023: 2

TIF: No
PASER_Rating_2023: 3

TIF: No
PASER_Rating_2023: 4

TIF: No
PASER_Rating_2023: 5

TIF: No
PASER_Rating_2023: 6

TIF: No
PASER_Rating_2023: 7

TIF: No
PASER_Rating_2023: 8

TIF: No
PASER_Rating_2023: 9

TIF: No
PASER_Rating_2023: 10

TIF: No
PASER_Rating_2023: -1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/6/2026 3:30:22 PM

Schema Last Edit Date: 7/20/2026 6:48:18 PM

Data Last Edit Date: 8/6/2026 3:30:22 PM

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

Layer: Middleton_Centerlines_PavementRating_FINAL (ID:0)