View In:   ArcGIS Online Map Viewer

Name: PavementOptsRestriction

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

Copyright Text: City of Lakewood, Colorado

Default Visibility: true

MaxRecordCount: 1000

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

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [245, 225, 203, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
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: 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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• cg_CartegraphID ( type: esriFieldTypeInteger, alias: cgCartegraphID, editable: true, nullable: true, defaultValue: null, modelName: cgCartegraphID )
• 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_Width ( type: esriFieldTypeDouble, alias: cgWidth, editable: true, nullable: true, defaultValue: null, modelName: cgWidth )
• lgRd_FULLNAME ( type: esriFieldTypeString, alias: lgRd_FULLNAME, editable: true, nullable: true, length: 80, defaultValue: null, modelName: FULLNAME )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• 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... )
• Activity ( type: esriFieldTypeString, alias: Activity, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Activity )
• Actual_Start_Date ( type: esriFieldTypeDate, alias: Actual Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Actual_Start_Date )
• Actual_Stop_Date ( type: esriFieldTypeDate, alias: Actual Stop Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Actual_Stop_Date )
• PavementOptsFlag ( type: esriFieldTypeString, alias: PavementOptsFlag, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PavementOptsFlag )
• DataDownloadedFromCg ( type: esriFieldTypeDate, alias: DataDownloadedFromCg, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DataDownloadedFromCg )
• BUFF_DIST ( type: esriFieldTypeDouble, alias: BUFF_DIST, editable: true, nullable: true, defaultValue: null, modelName: BUFF_DIST )
• ORIG_FID ( type: esriFieldTypeInteger, alias: ORIG_FID, editable: true, nullable: true, defaultValue: null, modelName: ORIG_FID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PavOptsAdditionalNotes ( type: esriFieldTypeString, alias: PavOptsAdditionalNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PavOptsAdditionalNotes )
• Shape__Area ( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STArea() )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )

Templates:

• Name: PavementOptsRestriction
  Description:
  Prototype:
  ORIG_FID: null
  PavOptsAdditionalNotes: null
  cg_CartegraphID: null
  cg_Description: null
  cg_Street: null
  cg_FromStreet: null
  cg_ToStreet: null
  cg_FunctionalClassification: null
  cg_PavementClassification: null
  cg_Neighborhood_fk: null
  cg_Width: null
  lgRd_FULLNAME: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  PaveOpts2020: null
  PaveOpts2021: null
  PaveOpts2022: null
  PaveOpts2023: null
  PaveOpts2024: null
  PaveOpts2025: null
  Activity: null
  Actual_Start_Date: null
  Actual_Stop_Date: null
  PavementOptsFlag: null
  DataDownloadedFromCg: null
  BUFF_DIST: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata