Name: Lakewood Road

Display Field: lgRd_STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: eafd5a083c2a4674aa2768d1b341df81

Copyright Text: City of Lakewood, Colorado

Default Visibility: true

MaxRecordCount: 1000

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: 3085500.1096414775
YMin: 1650334.40975748
XMax: 3125763.079640299
YMax: 1702652.7185064703
Spatial Reference: 2877  (2877)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PaveOpts2023
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Asphalt Resurfacing or Overlay
  Label: Asphalt Resurfacing or Overlay
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 3
• Value: Concrete Repair and Asphalt Overlay
  Label: Concrete Repair and Asphalt Overlay
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [85, 255, 0, 255]
  Width: 3
• Value: Concrete Repair
  Label: Concrete Repair
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 3
• Value: Sealcoating
  Label: Sealcoating
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 3
• Value: Rejuvenation
  Label: Rejuvenation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 115, 223, 255]
  Width: 3
• Value: Not Scheduled For Maintenance
  Label: Not Scheduled For Maintenance
  Description: N/A
  Symbol:
  Style: esriSLSNull
  Color: [240, 240, 240, 0]
  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_Neighborhood_fk ( type: esriFieldTypeString, alias: cg_Neighborhood_fk, length: 50 )
• cg_Length ( type: esriFieldTypeDouble, alias: cgLength )
• gisURL ( type: esriFieldTypeString, alias: gisURL, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• 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... )
• cg_StreetSweepingZone ( type: esriFieldTypeString, alias: cg_StreetSweepingZone, length: 255 )

Relationships:

• Neighborhood (0) -- Related To: Neighborhood (1)

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

  Iteminfo   Thumbnail   Metadata