Name: PW_Streets_Maintenance

Display Field: Roadway_Na

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: OverviewThis Feature Hosted Service provides detailed traffic-related data for the Columbia metropolitan area, focusing on roadway characteristics, traffic volume, and city boundary extents. It serves as a valuable resource for transportation planning, traffic safety analysis, and urban management.Feature LayersMedians Below 6 Feet: This layer depicts roadway medians that are less than six feet in width. It includes attributes such as median width, posted speed limits, traffic flow counts, and roadway status, useful for assessing roadway safety and traffic management features.Roadway Posted Speed Limit 35 mph: Represents road segments with a posted speed limit of 35 miles per hour. This layer includes roadway identification, status, and additional notes, helpful for speed limit enforcement and traffic control analyses.Roadway Average Daily Traffic Volume Over 15,000 Vehicles Per Day: Contains traffic volume data, including total and vehicle-type-specific counts for roads with high traffic volumes exceeding 15,000 vehicles per day. The data supports traffic load assessments and infrastructure planning.  

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 1645199.9999256618
YMin: 1073299.932208322
XMax: 1737437.8147934973
YMax: 1178300.0000949055
Spatial Reference: 102697  (102697)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [237, 21, 21, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• ALIAS ( type: esriFieldTypeString, alias: Road Alias (Highway designation), length: 12 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 9 )
• FRADDL ( type: esriFieldTypeDouble, alias: FRADDL )
• TOADDL ( type: esriFieldTypeDouble, alias: TOADDL )
• FRADDR ( type: esriFieldTypeDouble, alias: FRADDR )
• TOADDR ( type: esriFieldTypeDouble, alias: TOADDR )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 20 )
• EDIT_CODE ( type: esriFieldTypeString, alias: EDIT_CODE, length: 15 )
• SEGMENT_NUM ( type: esriFieldTypeInteger, alias: SEGMENT_NUM )
• CNTY_DIRP ( type: esriFieldTypeString, alias: CNTY_DIRP, length: 11 )
• CNTY_NAME ( type: esriFieldTypeString, alias: CNTY_NAME, length: 28 )
• CNTY_TYPE ( type: esriFieldTypeString, alias: CNTY_TYPE, length: 11 )
• CNTY_DIRS ( type: esriFieldTypeString, alias: CNTY_DIRS, length: 11 )
• SYMBOL ( type: esriFieldTypeString, alias: SYMBOL, length: 12 )
• DISPLAYNAM ( type: esriFieldTypeString, alias: DISPLAYNAM, length: 35 )
• OWNERSHIP ( type: esriFieldTypeString, alias: Segment Ownership, length: 24 , Coded Values: [Boone: Boone] , [Columbia: Columbia] , [MODOT: MODOT] , ...3 more... )
• CUSTODIAN ( type: esriFieldTypeString, alias: Segment Maintenance Entity, length: 24 , Coded Values: [Boone: Boone] , [Columbia: Columbia] , [MODOT: MODOT] , ...3 more... )
• CLASS ( type: esriFieldTypeString, alias: Functional Class, length: 24 , Coded Values: [Expressway: Expressway] , [Freeway: Freeway] , [Local Residential: Local Residential] , ...6 more... )
• YEAR ( type: esriFieldTypeInteger, alias: Year Built )
• ENTRY_TYPE ( type: esriFieldTypeString, alias: Road Segment Acceptance, length: 24 , Coded Values: [Accepted: Accepted] , [Constructed: Constructed] , [Annexation: Annexation] )
• PAVEMENT_TYPE ( type: esriFieldTypeString, alias: Pavement Type, length: 24 , Coded Values: [Asphalt: Asphalt] , [Porous Asphalt: Porous Asphalt Pavement] , [Brick: Brick] , ...18 more... )
• PAVEMENT_WEAR ( type: esriFieldTypeString, alias: Pavement Wearing Surface, length: 24 , Coded Values: [Asphalt: Asphalt] , [Porous Asphalt: Porous Asphalt Pavement] , [Brick: Brick] , ...18 more... )
• ACTIVITY ( type: esriFieldTypeString, alias: Last Maintenance Activity, length: 30 , Coded Values: [AH: AH (Asphalt Hauled)] , [AO: AO (Asphalt Overlay)] , [CHS: CHS (Chip Seal)] , ...12 more... )
• ACTIVITY_DATE ( type: esriFieldTypeDate, alias: Last Maintenance Activity Date, length: 8 )
• PAVEMENT_WIDTH ( type: esriFieldTypeDouble, alias: Segment Width )
• SQ_FOOT ( type: esriFieldTypeDouble, alias: Square Footage of Segment )
• FOOTAGE_MEASURED ( type: esriFieldTypeString, alias: Has Square Footage been Measured, length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• MEASURED_DATE ( type: esriFieldTypeDate, alias: Date Square Footage was Measured, length: 8 )
• STRIPED_LANES ( type: esriFieldTypeInteger, alias: Number of Stripped Lanes , Range: [1, 8] )
• BASE_DEPTH ( type: esriFieldTypeInteger, alias: Base Depth of Segment )
• BICYCLE ( type: esriFieldTypeString, alias: Bicycle Accessible, length: 24 , Coded Values: [No: No] , [Lane: Bicycle Lane] , [Route: Bicycle Route] , ...1 more... )
• OUTLET ( type: esriFieldTypeString, alias: Type of Street Outlet, length: 24 , Coded Values: [Yes: Yes] , [Dead End: Dead End] , [Cul-de-Sac: Cul-de-Sac] , ...3 more... )
• BRIDGE ( type: esriFieldTypeString, alias: Does segemnt have a bridge?, length: 12 , Coded Values: [Yes: Yes] , [No: No] )
• STW_CONVEYANCE ( type: esriFieldTypeString, alias: Type of Stormwater Conveyance, length: 24 , Coded Values: [Rollback: Rollback Curb/Gutter] , [Barrier: Barrier Curb/Gutter] , [Rain Garden: Rain Garden] , ...4 more... )
• IMPROVEMENT ( type: esriFieldTypeString, alias: Improvment, length: 35 , Coded Values: [Improved: Improved] , [Unimproved: Unimproved] , [Partial: Partial] )
• IMPROVMENT_DATE ( type: esriFieldTypeDate, alias: IMPROVMENT_DATE, length: 8 )
• WARRANTY ( type: esriFieldTypeString, alias: Segment has Warranty, length: 12 , Coded Values: [Yes: Yes] , [No: No] )
• WARRANTY_START ( type: esriFieldTypeDate, alias: Warranty Start Date, length: 8 )
• WARRANTY_END ( type: esriFieldTypeDate, alias: Warranty End Date, length: 8 )
• WARRANTY_Notes ( type: esriFieldTypeString, alias: Warranty Related Notes, length: 254 )
• SPEED_LIMIT ( type: esriFieldTypeInteger, alias: Speed Limit Restrictions , Coded Values: [15: 15] , [20: 20] , [25: 25] , ...9 more... )
• SPEED_LIMIT_Notes ( type: esriFieldTypeString, alias: Speed Limit Notes, length: 254 )
• SCHOOL_ZONE ( type: esriFieldTypeString, alias: Segment is in a School Zone, length: 12 , Coded Values: [Yes: Yes] , [No: No] )
• SNOW_ROUTE ( type: esriFieldTypeString, alias: Snow Route, length: 24 , Coded Values: [First: First Priority] , [Second: Second Priority] , [MODOT: MODOT] , ...10 more... )
• RIGHT_OF_WAY ( type: esriFieldTypeString, alias: Right-of-Way, length: 24 , Coded Values: [Private: Private alley] , [Public: Public alley] , [Unsure: Unsure] , ...1 more... )
• STREET_CREEP ( type: esriFieldTypeString, alias: Street Creep Eligibility, length: 24 , Coded Values: [Before: Before 1996] , [After: After 1996] , [Unsure: Unsure] )
• COST ( type: esriFieldTypeString, alias: Segment Cost, length: 24 )
• TRAFFIC_COUNT ( type: esriFieldTypeString, alias: Traffic Count, length: 24 )
• TRAFFIC_COUNT_DATE ( type: esriFieldTypeDate, alias: TRAFFIC_COUNT_DATE, length: 8 )
• AADT ( type: esriFieldTypeString, alias: Annual Average Daily Traffic Count Used for Traffic Planning and Analysis Purposes, length: 12 )
• AADT_DATE ( type: esriFieldTypeDate, alias: AADT_DATE, length: 8 )
• EDIT_CODE_MAINT ( type: esriFieldTypeString, alias: Edit Code, length: 15 )
• R_W_WIDTH ( type: esriFieldTypeDouble, alias: R_W_WIDTH )
• DEDICATED ( type: esriFieldTypeDate, alias: DEDICATED, length: 8 )
• PROPOSED_ACTIVITY ( type: esriFieldTypeString, alias: PROPOSED_ACTIVITY, length: 100 , Coded Values: [AH: AH (Asphalt Hauled)] , [AO: AO (Asphalt Overlay)] , [CHS: CHS (Chip Seal)] , ...12 more... )
• PROPOSED_ACTIVITY_DATE ( type: esriFieldTypeDate, alias: PROPOSED_ACTIVITY START DATE, length: 8 )
• CALMING_STATUS ( type: esriFieldTypeString, alias: CALMING_STATUS, length: 50 , Coded Values: [EXISTING: EXISTING TRAFFIC CALMING] , [STUDY_STARTED: STUDY STARTED] , [STUDY_NEEDED: NEED TO STUDY] , ...3 more... )
• CALMING_COMP_DATE ( type: esriFieldTypeDate, alias: CALMING_COMP_DATE, length: 8 )
• PASER ( type: esriFieldTypeDouble, alias: PASER , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...16 more... )
• PASER_DATE ( type: esriFieldTypeDate, alias: PASER_DATE, length: 8 )
• PASER_Notes ( type: esriFieldTypeString, alias: PASER_Notes, length: 255 )
• PCI ( type: esriFieldTypeDouble, alias: PCI )
• PCI_DATE ( type: esriFieldTypeDate, alias: PCI_DATE, length: 8 )
• PCI_Notes ( type: esriFieldTypeString, alias: PCI_Notes, length: 255 )
• UNIQUE_ID ( type: esriFieldTypeString, alias: UNIQUE_ID, length: 30 )
• Centerline_Type ( type: esriFieldTypeString, alias: Type of Road Centerline, length: 50 , Coded Values: [None: None - No centerline striping] , [Passing: Passing - Single dashed passing line] , [Skip: Skip - Two stripes, one passing and one solid] , ...4 more... )
• Edgeline_Type ( type: esriFieldTypeString, alias: Type of Road Edgeline, length: 50 , Coded Values: [None: None] , [Striped: Striped] , [Barrier: Barrier] )
• Getabout_Routes ( type: esriFieldTypeString, alias: Getabout color routes, length: 15 , Coded Values: [Green: Green] , [Yellow: Yellow] , [Red: Red] )
• Calculation ( type: esriFieldTypeString, alias: Field Used for Temporary Calculation and Attribution, length: 50 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Winter_Pretreat ( type: esriFieldTypeString, alias: Winter_Pretreat, length: 50 , Coded Values: [Bridge: Bridge] , [Street: Street] )
• 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 )
• HANSEN_SEG_NAME ( type: esriFieldTypeString, alias: HANSEN Segment Name, length: 50 )
• HANSEN_SEG_NUMBER ( type: esriFieldTypeInteger, alias: HANSEN Segment Number )
• Crack_Seal_Date ( type: esriFieldTypeDate, alias: Crack_Seal_Date, length: 8 )
• PASER_WO ( type: esriFieldTypeDouble, alias: HANSEN PASER WORK ORDER )
• PROPOSED_ACTIVITY_END_DATE ( type: esriFieldTypeDate, alias: PROPOSED_ACTIVITY_END_DATE, length: 8 )
• Gaurdrail_Present ( type: esriFieldTypeString, alias: Gaurdrail_Present, length: 10 , Coded Values: [North: North Side] , [South: South Side] , [East: East Side] , ...2 more... )
• Square_Footage ( type: esriFieldTypeDouble, alias: Square_Footage )
• MAINT_2015 ( type: esriFieldTypeString, alias: MAINT_2015, length: 30 )
• MAINT_2016 ( type: esriFieldTypeString, alias: MAINT_2016, length: 30 )
• MAINT_2017 ( type: esriFieldTypeString, alias: MAINT_2017, length: 30 )
• MAINT_2018 ( type: esriFieldTypeString, alias: MAINT_2018, length: 30 )
• MAINT_2019 ( type: esriFieldTypeString, alias: MAINT_2019, length: 30 )
• MAINT_2020 ( type: esriFieldTypeString, alias: MAINT_2020, length: 30 )
• MAINT_2021 ( type: esriFieldTypeString, alias: MAINT_2021, length: 30 )
• MAINT_2022 ( type: esriFieldTypeString, alias: MAINT_2022, length: 30 )
• MAINT_2023 ( type: esriFieldTypeString, alias: MAINT_2023, length: 30 )
• MAINT_2024 ( type: esriFieldTypeString, alias: MAINT_2024, length: 30 )
• MAINT_2025 ( type: esriFieldTypeString, alias: MAINT_2025, length: 30 )
• Shape_Length ( type: esriFieldTypeDouble, alias: Shape_Length )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata