View In:   ArcGIS Online Map Viewer

Name: Infrastructure Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: b0f881adadad49a6bc5aa9fde489531e

Copyright Text: Esri

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

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.800002770279935E7
YMin: -1.2000120992079366E7
XMax: 1.800002770279935E7
YMax: 1.600032826754906E7
Spatial Reference: 102100  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: projphase
Field 2: N/A
Field 3: N/A
Field Delimiter: N/A
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: PreDesign
  Label: PreDesign
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 222, 62, 255]
  Outline:
  Style: esriSLSSolid
  Color: [255, 222, 62, 255]
  Width: 3
• Value: Design
  Label: Design
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [20, 158, 206, 255]
  Outline:
  Style: esriSLSSolid
  Color: [20, 158, 206, 128]
  Width: 3
• Value: Construction
  Label: Construction
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [252, 146, 31, 255]
  Outline:
  Style: esriSLSSolid
  Color: [252, 146, 31, 128]
  Width: 3
• Value: Closeout
  Label: Closeout
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [167, 198, 54, 255]
  Outline:
  Style: esriSLSSolid
  Color: [167, 198, 54, 128]
  Width: 3
• Value: Complete
  Label: Complete
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [158, 85, 156, 255]
  Outline:
  Style: esriSLSSolid
  Color: [158, 85, 156, 128]
  Width: 3
Transparency: 20
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• projid ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Project Identifier, type: esriFieldTypeString )
• projname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Name, type: esriFieldTypeString )
• projdesc ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Description, type: esriFieldTypeString )
• rationale ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Rationale, type: esriFieldTypeString )
• projtype ( nullable: false, editable: true, defaultValue: null, length: 50, alias: Project Type, type: esriFieldTypeString , Coded Values: [Facilities: Facilities] , [Parks: Parks] , [Sewer Collection: Sewer Collection] , ...4 more... )
• fiscalyr ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Fiscal Year, type: esriFieldTypeString )
• fundsource ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Funding Source, type: esriFieldTypeString , Coded Values: [Capital Fund: Capital Fund] , [Connection Fee: Connection Fee] , [General Fund: General Fund] , ...7 more... )
• planstart ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Planned Start Date, type: esriFieldTypeDate )
• planend ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Planned End Date, type: esriFieldTypeDate )
• estcost ( nullable: true, editable: true, defaultValue: null, alias: Estimated Cost, type: esriFieldTypeDouble )
• pocname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contact Name, type: esriFieldTypeString )
• pocphone ( nullable: true, editable: true, defaultValue: null, length: 12, alias: Contact Phone, type: esriFieldTypeString )
• pocemail ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contact Email, type: esriFieldTypeString )
• projstatus ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Project Status, type: esriFieldTypeString , Coded Values: [Project Initiation: Project Initiation] , [Analysis and Review: Analysis and Review] , [Executive Approval: Executive Approval] , ...1 more... )
• funded ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Funded Project, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• projphase ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Phase, type: esriFieldTypeString , Coded Values: [PreDesign: PreDesign] , [Design: Design] , [Construction: Construction] , ...2 more... )
• actstart ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Actual Start Date, type: esriFieldTypeDate )
• actend ( nullable: true, editable: true, defaultValue: null, length: 29, alias: Actual End Date, type: esriFieldTypeDate )
• actcost ( nullable: true, editable: true, defaultValue: null, alias: Actual Cost, type: esriFieldTypeDouble )
• status ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Status, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Types:

ID: Facilities
Name: Facilities
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• mandate:
  Inherited
• expand:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Facilities
  Description:
  Prototype:
  projid: null
  actcost: null
  pocname: null
  actend: null
  actstart: null
  pocphone: null
  fundsource: null
  rationale: null
  projstatus: null
  pocemail: null
  planstart: null
  fiscalyr: null
  projname: null
  projdesc: null
  funded: No
  projtype: Facilities
  estcost: null
  projphase: null
  planend: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Parks
Name: Parks
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• mandate:
  Inherited
• expand:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Parks
  Description:
  Prototype:
  projid: null
  actcost: null
  pocname: null
  actend: null
  actstart: null
  pocphone: null
  fundsource: null
  rationale: null
  projstatus: null
  pocemail: null
  planstart: null
  fiscalyr: null
  projname: null
  projdesc: null
  funded: No
  projtype: Parks
  estcost: null
  projphase: null
  planend: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Sewer Collection
Name: Sewer Collection
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• mandate:
  Inherited
• expand:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Sewer Collection
  Description:
  Prototype:
  projid: null
  actcost: null
  pocname: null
  actend: null
  actstart: null
  pocphone: null
  fundsource: null
  rationale: null
  projstatus: null
  pocemail: null
  planstart: null
  fiscalyr: null
  projname: null
  projdesc: null
  funded: No
  projtype: Sewer Collection
  estcost: null
  projphase: null
  planend: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Stormwater Drainage
Name: Stormwater Drainage
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• mandate:
  Inherited
• expand:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Stormwater Drainage
  Description:
  Prototype:
  projid: null
  actcost: null
  pocname: null
  actend: null
  actstart: null
  pocphone: null
  fundsource: null
  rationale: null
  projstatus: null
  pocemail: null
  planstart: null
  fiscalyr: null
  projname: null
  projdesc: null
  funded: No
  projtype: Stormwater Drainage
  estcost: null
  projphase: null
  planend: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Transportation
Name: Transportation
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• mandate:
  Inherited
• expand:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Transportation
  Description:
  Prototype:
  projid: null
  actcost: null
  pocname: null
  actend: null
  actstart: null
  pocphone: null
  fundsource: null
  rationale: null
  projstatus: null
  pocemail: null
  planstart: null
  fiscalyr: null
  projname: null
  projdesc: null
  funded: No
  projtype: Transportation
  estcost: null
  projphase: null
  planend: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Water Distribution
Name: Water Distribution
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• mandate:
  Inherited
• expand:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Water Distribution
  Description:
  Prototype:
  projid: null
  actcost: null
  pocname: null
  actend: null
  actstart: null
  pocphone: null
  fundsource: null
  rationale: null
  projstatus: null
  pocemail: null
  planstart: null
  fiscalyr: null
  projname: null
  projdesc: null
  funded: No
  projtype: Water Distribution
  estcost: null
  projphase: null
  planend: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Other
Name: Other
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• mandate:
  Inherited
• expand:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  projid: null
  actcost: null
  pocname: null
  actend: null
  actstart: null
  pocphone: null
  fundsource: null
  rationale: null
  projstatus: null
  pocemail: null
  planstart: null
  fiscalyr: null
  projname: null
  projdesc: null
  funded: No
  projtype: Other
  estcost: null
  projphase: null
  planend: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Relationships:

• (0) -- Related To: Project Comments (1)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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 Top Features   Query Related Records   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata