Name: Pavement Operations

Display Field: lgRd_FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: PavementLine is a polyline feature class. Pavement records orginiated from the prod geodatabase and underwent editing to represent pavement records according to a PWs legacy spreadsheet. The geometry came from prod.GIS.Roads for all records before any manipulation. The spreadsheet determined the functional classification (collector, arterial, local) of each street segment. Collectors and arterials were merged into one single feature depending on the start and stop location of the spreadsheet, while local streets represent pavement segments between each intersection. After determining the spatial extent of each feature, the PWs legacy spreadsheet with maintanance history (overlay, reclamite, crackseal, and concrete dates) was joined based on the GIS LINK in the spreadsheet and LgRd_ASSET_ID in GIS. The ouput feature class was a layer with the correct spatial extent and maintanace history for each pavement segment. Following, a model built in GIS determined the cg_ToStreet and cg_FromStreet for each record.PavementLine records which have a functional classification of "Local" are associated to a neighorhood for PW to be able to preform work on all pavement segments in one neighorhood at a given time. Additioanlly, "Collectors" and "Arterials" under functional classificaiton do not have a neighborhood association as the entire line segment will be completed as repairs become due. As area is an important attribute for the PW STM division to report, it was calculated using the following equation:cg_AreaSqFt = cg_LengthFt* LgSs_AVG_WIDTH_FTThe cg_AreaSqFt was then divided by 9 to calculate cg_AreaSqYd.

Service Item Id: 77206d82ab664d1e8d300939ba6c3b0d

Copyright Text: City of Lakewood, Colorado

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: 3085450.1097415835
YMin: 1650284.4098575562
XMax: 3125813.0795404166
YMax: 1702702.7147976458
Spatial Reference: 2877  (2877)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PavementOptsFlag
Field 2: N/A
Field 3: N/A
Field Delimiter: ;
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: No cutting into pavement. Slurry Seal Completed 2023
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement area. Mill, Patch, Overlay Completed 2020
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement area. Mill, Patch, Overlay Completed 2021
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement area. Mill, Patch, Overlay Completed 2022
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement area. Mill, Patch, Overlay Completed 2023
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement. Mill, Patch, Overlay Completed 2020
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement. Mill, Patch, Overlay Completed 2021
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement. Mill, Patch, Overlay Completed 2022
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement. Mill, Patch, Overlay Completed 2023
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement. Mill, Patch, Overlay Planned 2024
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
• Value: No cutting into pavement. Slurry Seal Completed 2022
  Label: No cutting into pavement
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 25, 28, 255]
  Outline:
  Style: esriSLSSolid
  Color: [215, 25, 28, 255]
  Width: 0
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• cg_CartegraphID ( type: esriFieldTypeInteger, alias: cgCartegraphID )
• cg_Description ( type: esriFieldTypeString, alias: cgDescription, length: 254 )
• cg_Street ( type: esriFieldTypeString, alias: cgStreet, length: 255 )
• cg_FromStreet ( type: esriFieldTypeString, alias: cgFromStreet, length: 50 )
• cg_ToStreet ( type: esriFieldTypeString, alias: cg_ToStreet, length: 50 )
• cg_FunctionalClassification ( type: esriFieldTypeString, alias: cgFunctionalClassification, length: 50 , Coded Values: [ALLEY: ALLEY] , [COLLECTOR: COLLECTOR] , [LOCAL: LOCAL] , ...3 more... )
• cg_PavementClassification ( type: esriFieldTypeString, alias: cgPavementClassification, length: 50 )
• cg_Neighborhood_fk ( type: esriFieldTypeString, alias: cg_Neighborhood_fk, length: 50 )
• cg_Width ( type: esriFieldTypeDouble, alias: cgWidth )
• lgRd_FULLNAME ( type: esriFieldTypeString, alias: lgRd_FULLNAME, length: 80 )
• 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 )
• PaveOpts2020 ( type: esriFieldTypeString, alias: 2020 Paving Operations, length: 50 , Coded Values: [Sealcoating: Sealcoating] , [Concrete Repair: Concrete Repair] , [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay] , ...3 more... )
• PaveOpts2021 ( type: esriFieldTypeString, alias: 2021 Paving Operations, length: 50 , Coded Values: [Sealcoating: Sealcoating] , [Concrete Repair: Concrete Repair] , [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay] , ...3 more... )
• PaveOpts2022 ( type: esriFieldTypeString, alias: 2022 Paving Operations, length: 50 , Coded Values: [Sealcoating: Sealcoating] , [Concrete Repair: Concrete Repair] , [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay] , ...3 more... )
• PaveOpts2023 ( type: esriFieldTypeString, alias: 2023 Paving Operations, length: 50 , Coded Values: [Sealcoating: Sealcoating] , [Concrete Repair: Concrete Repair] , [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay] , ...3 more... )
• PaveOpts2024 ( type: esriFieldTypeString, alias: 2024 Paving Operations, length: 50 , Coded Values: [Sealcoating: Sealcoating] , [Concrete Repair: Concrete Repair] , [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay] , ...3 more... )
• PaveOpts2025 ( type: esriFieldTypeString, alias: 2025 Paving Operations, length: 50 , Coded Values: [Sealcoating: Sealcoating] , [Concrete Repair: Concrete Repair] , [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay] , ...3 more... )
• Activity ( type: esriFieldTypeString, alias: Activity, length: 1073741822 )
• Actual_Start_Date ( type: esriFieldTypeDate, alias: Actual Start Date, length: 8 )
• Actual_Stop_Date ( type: esriFieldTypeDate, alias: Actual Stop Date, length: 8 )
• PavementOptsFlag ( type: esriFieldTypeString, alias: PavementOptsFlag, length: 255 )
• DataDownloadedFromCg ( type: esriFieldTypeDate, alias: DataDownloadedFromCg, length: 8 )
• BUFF_DIST ( type: esriFieldTypeDouble, alias: BUFF_DIST )
• ORIG_FID ( type: esriFieldTypeInteger, alias: ORIG_FID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• PavOptsAdditionalNotes ( type: esriFieldTypeString, alias: PavOptsAdditionalNotes, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata