View In:   ArcGIS Online Map Viewer

Name: Construction Projects

Display Field: PrjName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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, Engineering Department

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: 2906931.6551412977
YMin: 295163.1475728005
XMax: 2950015.062733423
YMax: 323716.4116633907
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, 2017
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 169, 230, 255]
  Width: 2
• Value: Survey,2017
  Label: Survey, 2017
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 85, 0, 255]
  Width: 2
• Value: Transportation,2017
  Label: Transportation, 2017
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 2
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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: SanitaryStorm
Name: Sanitary/Stormwater, 2017
Domains:
• ProjType:
  Inherited
• PrjSubType:
  Inherited
• PrjStat:
  Inherited
• EngFunSr1:
  Inherited
• EngFunSr2:
  Inherited
• EngPO:
  Inherited
• CounDist:
  Inherited
Templates:
• Name: SanitaryStorm, 2017
  Description:
  Prototype:
  Manager_phone: null
  Manager_email: 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
  EngPrjEnd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Survey
Name: Survey, 2017
Domains:
• ProjType:
  Inherited
• PrjSubType:
  Inherited
• PrjStat:
  Inherited
• EngFunSr1:
  Inherited
• EngFunSr2:
  Inherited
• EngPO:
  Inherited
• CounDist:
  Inherited
Templates:
• Name: Survey, 2017
  Description:
  Prototype:
  Manager_phone: null
  Manager_email: null
  PrjName: null
  ProjType: Survey
  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
  EngPrjEnd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Transportation
Name: Transportation, 2017
Domains:
• ProjType:
  Inherited
• PrjSubType:
  Inherited
• PrjStat:
  Inherited
• EngFunSr1:
  Inherited
• EngFunSr2:
  Inherited
• EngPO:
  Inherited
• CounDist:
  Inherited
Templates:
• Name: Transportation, 2017
  Description:
  Prototype:
  Manager_phone: null
  Manager_email: 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
  EngPrjEnd: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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