View In:   ArcGIS Online map viewer

Name: Pavement Projects

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 38460db4744840268d56de8479fb1970

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 6135649.807865381
YMin: 2183667.263559222
XMax: 6176918.353608966
YMax: 2205177.1313005537
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ProjectStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 5
Default Label:
UniqueValueInfos:
• Value: Bid
  Label: Bid
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [228, 26, 28, 255]
  Width: 5
• Value: Completed
  Label: Completed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [55, 126, 184, 255]
  Width: 5
• Value: Conceptual Plan
  Label: Conceptual Plan
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [77, 175, 74, 255]
  Width: 5
• Value: Construction
  Label: Construction
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [152, 78, 163, 255]
  Width: 5
• Value: Crack & Slurry Complete
  Label: Crack & Slurry Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 127, 0, 255]
  Width: 5
• Value: Crack Seal Complete
  Label: Crack Seal Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 51, 255]
  Width: 5
• Value: Design
  Label: Design
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [166, 86, 40, 255]
  Width: 5
• Value: Funded
  Label: Funded
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [247, 129, 191, 255]
  Width: 5
• Value: Proposal
  Label: Proposal
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [153, 153, 153, 255]
  Width: 5
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ProjectStatus

Fields:

• TrafficDirection ( type: esriFieldTypeString, alias: TrafficDirection, editable: true, nullable: true, length: 255, defaultValue: Both, modelName: TrafficDirection , Coded Values: [East: East] , [North: North] , [South: South] , ...10 more... )
• UniqueID ( type: esriFieldTypeString, alias: UniqueID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UniqueID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• StreetName ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetName )
• Limits ( type: esriFieldTypeString, alias: Limits, editable: true, nullable: true, length: 255, defaultValue: Entire Length, modelName: Limits , Coded Values: [Partial: Partial Length] , [Entire Length: Entire Length] )
• ProjectName ( type: esriFieldTypeString, alias: CIP Project, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectName )
• ProjectedFunding ( type: esriFieldTypeString, alias: Projected Funding, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectedFunding )
• FundingSource ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FundingSource )
• FiscalYear ( type: esriFieldTypeString, alias: Planned Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FiscalYear , Coded Values: [18/19: 18/19] , [19/20: 19/20] , [20/21: 20/21] , ...9 more... )
• PlannedYear ( type: esriFieldTypeDate, alias: Planned Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PlannedYear )
• CompletedYear ( type: esriFieldTypeDate, alias: Completed Year, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CompletedYear )
• RehabilitationMethod ( type: esriFieldTypeString, alias: Improvement Type, editable: true, nullable: true, length: 255, defaultValue: Not Applicable, modelName: RehabilitationMethod , Coded Values: [Mill & Overlay: Mill & Overlay] , [Full Depth Reclamation: Full Depth Reclamation] , [Mill & Inlay: Mill & Inlay] , ...6 more... )
• ConstructionYear ( type: esriFieldTypeInteger, alias: Construction Year, editable: true, nullable: true, defaultValue: null, modelName: ConstructionYear )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• ProjectOption ( type: esriFieldTypeSmallInteger, alias: Option Catagory, editable: true, nullable: true, defaultValue: null, modelName: ProjectOption )
• Contractor ( type: esriFieldTypeString, alias: Contracting Firm, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Contractor )
• ProjectManager ( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectManager )
• Thickness ( type: esriFieldTypeSmallInteger, alias: Thickness, editable: true, nullable: true, defaultValue: null, modelName: Thickness )
• ProjectStatus ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 255, defaultValue: Proposal, modelName: ProjectStatus , Coded Values: [Proposal: Proposal] , [Design: Design] , [Bid: Bid] , ...6 more... )
• EstimatedCost ( type: esriFieldTypeInteger, alias: Estimated Cost, editable: true, nullable: true, defaultValue: null, modelName: EstimatedCost )
• CurrentPCI ( type: esriFieldTypeInteger, alias: Current PCI, editable: true, nullable: true, defaultValue: null, modelName: CurrentPCI )
• NewPCI ( type: esriFieldTypeInteger, alias: New PCI, editable: true, nullable: true, defaultValue: null, modelName: NewPCI )
• ContractNumber ( type: esriFieldTypeInteger, alias: Contract No., editable: true, nullable: true, defaultValue: null, modelName: ContractNumber )
• FileLocation ( type: esriFieldTypeInteger, alias: FileLocation, editable: true, nullable: true, defaultValue: null, modelName: FileLocation )
• Department ( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: ENG, modelName: Department , Coded Values: [ENG: Engineering] , [PW: Public Works] , [Outside Agency: Outside Agency] , ...1 more... )
• TreatmentMethod ( type: esriFieldTypeString, alias: Treatment Method, editable: true, nullable: true, length: 255, defaultValue: Not Applicable, modelName: TreatmentMethod , Coded Values: [Cape Seal: Cape Seal] , [Chip Seal: Chip Seal] , [Crack Seal: Crack Seal] , ...8 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• URL ( type: esriFieldTypeString, alias: URL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: URL )
• ProjectID ( type: esriFieldTypeSmallInteger, alias: Project ID, editable: true, nullable: true, defaultValue: null, modelName: ProjectID )
• ContractID ( type: esriFieldTypeString, alias: Contract Identifier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractID )
• ProjectYear ( type: esriFieldTypeInteger, alias: Project Year, editable: true, nullable: true, defaultValue: null, modelName: ProjectYear )
• PavementZone ( type: esriFieldTypeSmallInteger, alias: PavementZone, editable: true, nullable: true, defaultValue: null, modelName: PavementZone )
• FullRoadName ( type: esriFieldTypeString, alias: FullRoadName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FullRoadName , Coded Values: [Abbott Ave: Abbott Ave] , [Acacia St: Acacia St] , [Ackerman Dr: Ackerman Dr] , ...944 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )

Types:

ID: Bid
Name: Bid
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Bid
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Bid
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Completed
Name: Completed
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Completed
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Completed
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Conceptual Plan
Name: Conceptual Plan
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Conceptual Plan
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Conceptual Plan
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Construction
Name: Construction
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Construction
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Construction
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Crack & Slurry Complete
Name: Crack & Slurry Complete
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Crack & Slurry Complete
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Crack & Slurry Complete
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Crack Seal Complete
Name: Crack Seal Complete
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Crack Seal Complete
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Crack Seal Complete
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Design
Name: Design
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Design
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Design
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Funded
Name: Funded
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Funded
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  PavementZone: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Funded
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  ProjectYear: null
  URL: null
  ProjectID: null
  ContractID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Proposal
Name: Proposal
Domains:
• TrafficDirection:
  Inherited
• Limits:
  Inherited
• FiscalYear:
  Inherited
• RehabilitationMethod:
  Inherited
• ProjectStatus:
  Inherited
• Department:
  Inherited
• TreatmentMethod:
  Inherited
• FullRoadName:
  Inherited
Templates:
• Name: Pavement Projects
  Description:
  Prototype:
  FullRoadName: null
  TrafficDirection: Both
  UniqueID: null
  StreetName: null
  Limits: Entire Length
  ProjectName: null
  ProjectedFunding: null
  FundingSource: null
  FiscalYear: null
  PlannedYear: null
  CompletedYear: null
  RehabilitationMethod: Not Applicable
  ConstructionYear: null
  Notes: null
  ProjectOption: null
  Contractor: null
  ProjectManager: null
  Thickness: null
  ProjectStatus: Proposal
  EstimatedCost: null
  CurrentPCI: null
  NewPCI: null
  ContractNumber: null
  FileLocation: null
  Department: ENG
  TreatmentMethod: Not Applicable
  PavementZone: null
  URL: null
  ProjectID: null
  ContractID: null
  ProjectYear: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• CIP.DBO.MaintenanceStrategy (0) -- Related To: Maintenance Strategy (2)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata