View In:
ArcGIS Online Map Viewer
Name: 2026 Projected Pavement Opts
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: 646fefb975f9492cb5bc6428a80343fc
Copyright Text: City of Lakewood, Colorado
Default Visibility: true
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Supports Datum Transformation: true
Extent:
XMin: 3085500.1096414775
YMin: 1650334.40975748
XMax: 3125763.079640299
YMax: 1702652.7185064703
Spatial Reference: 2877
(2877)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: PaveOpts2026
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: N/A
UniqueValueInfos:
-
Value: Asphalt Resurfacing or Overlay
Label: Asphalt Resurfacing or Overlay
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [255, 255, 115, 255]
Width: 2
-
Value: Concrete Repair
Label: Concrete Repair
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 2
-
Value: Concrete Repair and Asphalt Overlay
Label: Concrete Repair and Asphalt Overlay
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [76, 230, 0, 255]
Width: 2
-
Value: Rejuvenation
Label: Rejuvenation
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [230, 0, 169, 255]
Width: 2
-
Value: Sealcoating
Label: Sealcoating
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [255, 170, 0, 255]
Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Tahoma
Font Style: normal
Font Weight: normal
Font Decoration: none
Min. Scale: 16177.0
Max. Scale: 0.0
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: true
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: PaveOpts2026
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
cg_Description
(
type: esriFieldTypeString, alias: cgDescription, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Description
)
-
cg_Street
(
type: esriFieldTypeString, alias: cgStreet, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cgStreet
)
-
cg_FromStreet
(
type: esriFieldTypeString, alias: cgFromStreet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cgFromStreet
)
-
cg_ToStreet
(
type: esriFieldTypeString, alias: cg_ToStreet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cgToStreet
)
-
cg_FunctionalClassification
(
type: esriFieldTypeString, alias: cgFunctionalClassification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cgFunctionalClassification
, Coded Values:
[ALLEY: ALLEY]
, [COLLECTOR: COLLECTOR]
, [LOCAL: LOCAL]
, ...3 more...
)
-
cg_PavementClassification
(
type: esriFieldTypeString, alias: cgPavementClassification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cgPavementClassification
)
-
cg_Neighborhood_fk
(
type: esriFieldTypeString, alias: cg_Neighborhood_fk, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cg_Neighborhood_fk
)
-
cg_Area
(
type: esriFieldTypeDouble, alias: cgArea, editable: true, nullable: true, defaultValue: null, modelName: cgArea
)
-
cg_Area_unit
(
type: esriFieldTypeString, alias: cgArea_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cgArea_unit
, Coded Values:
[SQ FEET: SQ FEET]
, [ACRES: ACRES]
, [SQ YARDS: SQ YARDS]
)
-
cg_Area_source
(
type: esriFieldTypeString, alias: cgArea_source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Area_source
, Coded Values:
[Legacy PW Spreadsheet: Legacy PW Spreadsheet]
, [DRCOG Planimetrics: DRCOG Planimetrics]
, [LGSSAvgWidth x GISLength: LGSSAvgWidth x GISLength]
)
-
cg_Width
(
type: esriFieldTypeDouble, alias: cgWidth, editable: true, nullable: true, defaultValue: null, modelName: cgWidth
)
-
cg_Width_unit
(
type: esriFieldTypeString, alias: cgWidth_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cgWidth_unit
, Coded Values:
[FEET: FEET]
)
-
cg_Width_source
(
type: esriFieldTypeString, alias: cgWidth_source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Width_source
, Coded Values:
[Legacy PW Spreadsheet: Legacy PW Spreadsheet]
)
-
cg_Length
(
type: esriFieldTypeDouble, alias: cgLength, editable: true, nullable: true, defaultValue: null, modelName: cgLength
)
-
cg_Length_unit
(
type: esriFieldTypeString, alias: cgLength_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cgLength_unit
, Coded Values:
[FEET: FEET]
)
-
cg_Length_source
(
type: esriFieldTypeString, alias: cgLength_source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Length_source
, Coded Values:
[Legacy PW Spreadsheet: Legacy PW Spreadsheet]
, [GIS LINE Shape_Length: GIS LINE Shape_Length]
)
-
cg_NumberofLanes
(
type: esriFieldTypeInteger, alias: cgNumberofLanes, editable: true, nullable: true, defaultValue: null, modelName: cgNumberofLanes
)
-
cg_Subdivision
(
type: esriFieldTypeString, alias: cgSubdivision, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cgSubdivision
)
-
PaveOpts2020
(
type: esriFieldTypeString, alias: 2020 Paving Operations, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaveOpts2020
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaveOpts2021
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaveOpts2022
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaveOpts2023
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaveOpts2024
, 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaveOpts2025
, Coded Values:
[Sealcoating: Sealcoating]
, [Concrete Repair: Concrete Repair]
, [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay]
, ...3 more...
)
-
Shape__Length
(
type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength()
)
-
cg_StreetSweepingZone
(
type: esriFieldTypeString, alias: cg_StreetSweepingZone, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cg_StreetSweepingZone
)
-
PaveOpts2026
(
type: esriFieldTypeString, alias: PaveOpts2026, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PaveOpts2026
, Coded Values:
[Sealcoating: Sealcoating]
, [Concrete Repair: Concrete Repair]
, [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay]
, ...3 more...
)
-
PaveOpts2027
(
type: esriFieldTypeString, alias: PaveOpts2027, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PaveOpts2027
, Coded Values:
[Sealcoating: Sealcoating]
, [Concrete Repair: Concrete Repair]
, [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay]
, ...3 more...
)
-
PaveOpts2028
(
type: esriFieldTypeString, alias: PaveOpts2028, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PaveOpts2028
, Coded Values:
[Sealcoating: Sealcoating]
, [Concrete Repair: Concrete Repair]
, [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay]
, ...3 more...
)
-
PaveOpts2029
(
type: esriFieldTypeString, alias: PaveOpts2029, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PaveOpts2029
, Coded Values:
[Sealcoating: Sealcoating]
, [Concrete Repair: Concrete Repair]
, [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay]
, ...3 more...
)
-
PaveOpts2030
(
type: esriFieldTypeString, alias: PaveOpts2030, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PaveOpts2030
, Coded Values:
[Sealcoating: Sealcoating]
, [Concrete Repair: Concrete Repair]
, [Concrete Repair and Asphalt Overlay: Concrete Repair and Asphalt Overlay]
, ...3 more...
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
Types:
ID: Asphalt Resurfacing or Overlay
Name: Asphalt Resurfacing or Overlay
Domains:
-
cg_FunctionalClassification:
Inherited
-
cg_Area_unit:
Inherited
-
cg_Area_source:
Inherited
-
cg_Width_unit:
Inherited
-
cg_Width_source:
Inherited
-
cg_Length_unit:
Inherited
-
cg_Length_source:
Inherited
-
PaveOpts2020:
Inherited
-
PaveOpts2021:
Inherited
-
PaveOpts2022:
Inherited
-
PaveOpts2023:
Inherited
-
PaveOpts2024:
Inherited
-
PaveOpts2025:
Inherited
-
PaveOpts2026:
Inherited
-
PaveOpts2027:
Inherited
-
PaveOpts2028:
Inherited
-
PaveOpts2029:
Inherited
-
PaveOpts2030:
Inherited
-
lgRd_PREFIX:
Inherited
-
lgRd_STREETTYPE:
Inherited
-
lgRd_CLASS:
Inherited
Templates:
-
Name: Asphalt Resurfacing or Overlay
Description:
Prototype:
cg_StreetSweepingZone: null
PaveOpts2030: null
cg_Description: null
cg_Street: null
cg_FromStreet: null
cg_ToStreet: null
cg_FunctionalClassification: null
cg_PavementClassification: null
cg_Neighborhood_fk: null
cg_Area: null
cg_Area_unit: null
cg_Area_source: null
cg_Width: null
cg_Width_unit: null
cg_Width_source: null
cg_Length: null
cg_Length_unit: null
cg_Length_source: null
cg_NumberofLanes: null
cg_Subdivision: null
PaveOpts2020: null
PaveOpts2021: null
PaveOpts2022: null
PaveOpts2023: null
PaveOpts2024: null
PaveOpts2025: null
PaveOpts2029: null
PaveOpts2026: Asphalt Resurfacing or Overlay
PaveOpts2027: null
PaveOpts2028: null
Drawing Tool: esriFeatureEditToolLine
ID: Concrete Repair
Name: Concrete Repair
Domains:
-
cg_FunctionalClassification:
Inherited
-
cg_Area_unit:
Inherited
-
cg_Area_source:
Inherited
-
cg_Width_unit:
Inherited
-
cg_Width_source:
Inherited
-
cg_Length_unit:
Inherited
-
cg_Length_source:
Inherited
-
PaveOpts2020:
Inherited
-
PaveOpts2021:
Inherited
-
PaveOpts2022:
Inherited
-
PaveOpts2023:
Inherited
-
PaveOpts2024:
Inherited
-
PaveOpts2025:
Inherited
-
PaveOpts2026:
Inherited
-
PaveOpts2027:
Inherited
-
PaveOpts2028:
Inherited
-
PaveOpts2029:
Inherited
-
PaveOpts2030:
Inherited
-
lgRd_PREFIX:
Inherited
-
lgRd_STREETTYPE:
Inherited
-
lgRd_CLASS:
Inherited
Templates:
-
Name: Concrete Repair
Description:
Prototype:
cg_StreetSweepingZone: null
PaveOpts2030: null
cg_Description: null
cg_Street: null
cg_FromStreet: null
cg_ToStreet: null
cg_FunctionalClassification: null
cg_PavementClassification: null
cg_Neighborhood_fk: null
cg_Area: null
cg_Area_unit: null
cg_Area_source: null
cg_Width: null
cg_Width_unit: null
cg_Width_source: null
cg_Length: null
cg_Length_unit: null
cg_Length_source: null
cg_NumberofLanes: null
cg_Subdivision: null
PaveOpts2020: null
PaveOpts2021: null
PaveOpts2022: null
PaveOpts2023: null
PaveOpts2024: null
PaveOpts2025: null
PaveOpts2029: null
PaveOpts2026: Concrete Repair
PaveOpts2027: null
PaveOpts2028: null
Drawing Tool: esriFeatureEditToolLine
ID: Concrete Repair and Asphalt Overlay
Name: Concrete Repair and Asphalt Overlay
Domains:
-
cg_FunctionalClassification:
Inherited
-
cg_Area_unit:
Inherited
-
cg_Area_source:
Inherited
-
cg_Width_unit:
Inherited
-
cg_Width_source:
Inherited
-
cg_Length_unit:
Inherited
-
cg_Length_source:
Inherited
-
PaveOpts2020:
Inherited
-
PaveOpts2021:
Inherited
-
PaveOpts2022:
Inherited
-
PaveOpts2023:
Inherited
-
PaveOpts2024:
Inherited
-
PaveOpts2025:
Inherited
-
PaveOpts2026:
Inherited
-
PaveOpts2027:
Inherited
-
PaveOpts2028:
Inherited
-
PaveOpts2029:
Inherited
-
PaveOpts2030:
Inherited
-
lgRd_PREFIX:
Inherited
-
lgRd_STREETTYPE:
Inherited
-
lgRd_CLASS:
Inherited
Templates:
-
Name: Concrete Repair and Asphalt Overlay
Description:
Prototype:
cg_StreetSweepingZone: null
PaveOpts2030: null
cg_Description: null
cg_Street: null
cg_FromStreet: null
cg_ToStreet: null
cg_FunctionalClassification: null
cg_PavementClassification: null
cg_Neighborhood_fk: null
cg_Area: null
cg_Area_unit: null
cg_Area_source: null
cg_Width: null
cg_Width_unit: null
cg_Width_source: null
cg_Length: null
cg_Length_unit: null
cg_Length_source: null
cg_NumberofLanes: null
cg_Subdivision: null
PaveOpts2020: null
PaveOpts2021: null
PaveOpts2022: null
PaveOpts2023: null
PaveOpts2024: null
PaveOpts2025: null
PaveOpts2029: null
PaveOpts2026: Concrete Repair and Asphalt Overlay
PaveOpts2027: null
PaveOpts2028: null
Drawing Tool: esriFeatureEditToolLine
ID: Rejuvenation
Name: Rejuvenation
Domains:
-
cg_FunctionalClassification:
Inherited
-
cg_Area_unit:
Inherited
-
cg_Area_source:
Inherited
-
cg_Width_unit:
Inherited
-
cg_Width_source:
Inherited
-
cg_Length_unit:
Inherited
-
cg_Length_source:
Inherited
-
PaveOpts2020:
Inherited
-
PaveOpts2021:
Inherited
-
PaveOpts2022:
Inherited
-
PaveOpts2023:
Inherited
-
PaveOpts2024:
Inherited
-
PaveOpts2025:
Inherited
-
PaveOpts2026:
Inherited
-
PaveOpts2027:
Inherited
-
PaveOpts2028:
Inherited
-
PaveOpts2029:
Inherited
-
PaveOpts2030:
Inherited
-
lgRd_PREFIX:
Inherited
-
lgRd_STREETTYPE:
Inherited
-
lgRd_CLASS:
Inherited
Templates:
-
Name: Rejuvenation
Description:
Prototype:
cg_StreetSweepingZone: null
PaveOpts2030: null
cg_Description: null
cg_Street: null
cg_FromStreet: null
cg_ToStreet: null
cg_FunctionalClassification: null
cg_PavementClassification: null
cg_Neighborhood_fk: null
cg_Area: null
cg_Area_unit: null
cg_Area_source: null
cg_Width: null
cg_Width_unit: null
cg_Width_source: null
cg_Length: null
cg_Length_unit: null
cg_Length_source: null
cg_NumberofLanes: null
cg_Subdivision: null
PaveOpts2020: null
PaveOpts2021: null
PaveOpts2022: null
PaveOpts2023: null
PaveOpts2024: null
PaveOpts2025: null
PaveOpts2029: null
PaveOpts2026: Rejuvenation
PaveOpts2027: null
PaveOpts2028: null
Drawing Tool: esriFeatureEditToolLine
ID: Sealcoating
Name: Sealcoating
Domains:
-
cg_FunctionalClassification:
Inherited
-
cg_Area_unit:
Inherited
-
cg_Area_source:
Inherited
-
cg_Width_unit:
Inherited
-
cg_Width_source:
Inherited
-
cg_Length_unit:
Inherited
-
cg_Length_source:
Inherited
-
PaveOpts2020:
Inherited
-
PaveOpts2021:
Inherited
-
PaveOpts2022:
Inherited
-
PaveOpts2023:
Inherited
-
PaveOpts2024:
Inherited
-
PaveOpts2025:
Inherited
-
PaveOpts2026:
Inherited
-
PaveOpts2027:
Inherited
-
PaveOpts2028:
Inherited
-
PaveOpts2029:
Inherited
-
PaveOpts2030:
Inherited
-
lgRd_PREFIX:
Inherited
-
lgRd_STREETTYPE:
Inherited
-
lgRd_CLASS:
Inherited
Templates:
-
Name: Sealcoating
Description:
Prototype:
cg_StreetSweepingZone: null
PaveOpts2030: null
cg_Description: null
cg_Street: null
cg_FromStreet: null
cg_ToStreet: null
cg_FunctionalClassification: null
cg_PavementClassification: null
cg_Neighborhood_fk: null
cg_Area: null
cg_Area_unit: null
cg_Area_source: null
cg_Width: null
cg_Width_unit: null
cg_Width_source: null
cg_Length: null
cg_Length_unit: null
cg_Length_source: null
cg_NumberofLanes: null
cg_Subdivision: null
PaveOpts2020: null
PaveOpts2021: null
PaveOpts2022: null
PaveOpts2023: null
PaveOpts2024: null
PaveOpts2025: null
PaveOpts2029: null
PaveOpts2026: Sealcoating
PaveOpts2027: null
PaveOpts2028: null
Drawing Tool: esriFeatureEditToolLine
Relationships:
Capabilities: Query
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata