View In:   ArcGIS Online Map Viewer

Name: Construction Projects

Display Field: PrjName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class keeps track of all of the Department of Public Services engineering projects. The information is currently being updated via the Engineering Projects spreadsheet that is housed in the engineering department. The purpose of this feature class is to show graphically where current, past and future projects are located.

Service Item Id: 33eacfd32add480299c877d5d54e9edd

Copyright Text: City of Portland, DPS

Default Visibility: false

MaxRecordCount: 10000

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: 2906753.7266611345
YMin: 294528.5989962071
XMax: 2944453.4654802456
YMax: 322857.21940658987
Spatial Reference: 26856  (26856)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ProjType
Field 2: YearSched
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: SanitaryStorm,2017
  Label: Sanitary/Stormwater
  Description: N/A
  Symbol:
  
• Value: Survey,2015
  Label: Survey
  Description: N/A
  Symbol:
  
• Value: Transportation,2017
  Label: Transportation
  Description: N/A
  Symbol:
  
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: ProjType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• PrjName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrjName )
• ProjType ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ProjType , Coded Values: [PrkOpenSpace: Parks and Open Space] , [Sanitary: Sanitary] , [SanitaryStorm: Sanitary/Stormwater] , ...5 more... )
• PrjSubType ( type: esriFieldTypeString, alias: Project Subtype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrjSubType , Coded Values: [BikePed: Bike/Ped] , [Crack Sealing: Crack Sealing] , [CSO: CSO] , ...39 more... )
• ProjDesc ( type: esriFieldTypeString, alias: Project Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ProjDesc )
• PrjStat ( type: esriFieldTypeString, alias: Project Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PrjStat , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [Bid: Bid] , ...10 more... )
• EngFunSr1 ( type: esriFieldTypeString, alias: Primary Funding Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EngFunSr1 , Coded Values: [CDBG: CDBG] , [CIP: CIP] , [FED: FED] , ...7 more... )
• EngFunSr2 ( type: esriFieldTypeString, alias: Secondary Funding Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EngFunSr2 , Coded Values: [CDBG: CDBG] , [CIP: CIP] , [FED: FED] , ...7 more... )
• EngPM ( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EngPM )
• EngPI ( type: esriFieldTypeString, alias: Project Inspector, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EngPI )
• EngPO ( type: esriFieldTypeString, alias: Project Owner, editable: true, nullable: true, length: 30, defaultValue: null, modelName: EngPO , Coded Values: [City: City] , [Electric: CMP] , [Gas: Unitil] , ...3 more... )
• YearSched ( type: esriFieldTypeDouble, alias: YearSched, editable: true, nullable: true, defaultValue: null, modelName: YearSched )
• Season ( type: esriFieldTypeString, alias: Season, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Season )
• EngPrjStrt ( type: esriFieldTypeDate, alias: Date Project Started, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EngPrjStrt )
• TIF_Dist ( type: esriFieldTypeString, alias: TIF District, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TIF_Dist )
• CounDist ( type: esriFieldTypeSmallInteger, alias: Council District, editable: true, nullable: true, defaultValue: null, modelName: CounDist , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• FinalCosts ( type: esriFieldTypeDouble, alias: FinalCosts, editable: true, nullable: true, defaultValue: null, modelName: FinalCosts )
• TotalValue ( type: esriFieldTypeDouble, alias: Total Value, editable: true, nullable: true, defaultValue: null, modelName: TotalValue )
• YearComp ( type: esriFieldTypeString, alias: Year Completed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YearComp )
• ProjectID ( type: esriFieldTypeString, alias: Project ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ProjectID )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• Checked ( type: esriFieldTypeDate, alias: Checked, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Checked )
• CIP_Num ( type: esriFieldTypeString, alias: CIP ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CIP_Num )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• EngPrjEnd ( type: esriFieldTypeDate, alias: Date Project Ends, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EngPrjEnd )
• Manager_email ( type: esriFieldTypeString, alias: Manager Email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manager_email )
• Manager_phone ( type: esriFieldTypeString, alias: Manager Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manager_phone )

Types:

ID: SanitaryStorm
Name: Sanitary/Stormwater
Domains:
• ProjType:
  Inherited
• PrjSubType:
  Inherited
• PrjStat:
  Inherited
• EngFunSr1:
  Inherited
• EngFunSr2:
  Inherited
• EngPO:
  Inherited
• CounDist:
  Inherited
Templates:
• Name: SanitaryStorm, 2017
  Description:
  Prototype:
  Manager_email: null
  EngPrjEnd: null
  PrjName: null
  ProjType: SanitaryStorm
  PrjSubType: null
  ProjDesc: null
  PrjStat: null
  EngFunSr1: null
  EngFunSr2: null
  EngPM: null
  EngPI: null
  EngPO: null
  YearSched: 2017
  Season: null
  EngPrjStrt: null
  TIF_Dist: null
  CounDist: null
  FinalCosts: null
  TotalValue: null
  YearComp: null
  ProjectID: null
  Comments: null
  Checked: null
  CIP_Num: null
  Manager_phone: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Survey
Name: Survey
Domains:
• ProjType:
  Inherited
• PrjSubType:
  Inherited
• PrjStat:
  Inherited
• EngFunSr1:
  Inherited
• EngFunSr2:
  Inherited
• EngPO:
  Inherited
• CounDist:
  Inherited
Templates:
• Name: Survey, 2015
  Description:
  Prototype:
  Manager_email: null
  EngPrjEnd: null
  PrjName: null
  ProjType: Survey
  PrjSubType: null
  ProjDesc: null
  PrjStat: null
  EngFunSr1: null
  EngFunSr2: null
  EngPM: null
  EngPI: null
  EngPO: null
  YearSched: 2015
  Season: null
  EngPrjStrt: null
  TIF_Dist: null
  CounDist: null
  FinalCosts: null
  TotalValue: null
  YearComp: null
  ProjectID: null
  Comments: null
  Checked: null
  CIP_Num: null
  Manager_phone: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Transportation
Name: Transportation
Domains:
• ProjType:
  Inherited
• PrjSubType:
  Inherited
• PrjStat:
  Inherited
• EngFunSr1:
  Inherited
• EngFunSr2:
  Inherited
• EngPO:
  Inherited
• CounDist:
  Inherited
Templates:
• Name: Transportation, 2017
  Description:
  Prototype:
  Manager_email: null
  EngPrjEnd: null
  PrjName: null
  ProjType: Transportation
  PrjSubType: null
  ProjDesc: null
  PrjStat: null
  EngFunSr1: null
  EngFunSr2: null
  EngPM: null
  EngPI: null
  EngPO: null
  YearSched: 2017
  Season: null
  EngPrjStrt: null
  TIF_Dist: null
  CounDist: null
  FinalCosts: null
  TotalValue: null
  YearComp: null
  ProjectID: null
  Comments: null
  Checked: null
  CIP_Num: null
  Manager_phone: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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