View In:   ArcGIS Online Map Viewer

Name: Infrastructure Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 2b74750daeeb4131b32c9d1e7ddf56bf

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:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [25, 135, 187, 255]
Outline:
Style: esriSLSSolid
Color: [9, 48, 66, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 35
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... )
• safety ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Health and Safety, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• mandate ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Mandate, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• repair ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Repair or Maintenance, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• replace ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Replacement, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• expand ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Expansion, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• efficient ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Efficiency, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• docpath ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Document Path, type: esriFieldTypeString )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• 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
• expand:
  Inherited
• mandate:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Facilities
  Description:
  Prototype:
  repair: null
  mandate: null
  pocname: null
  actstart: null
  replace: null
  pocphone: null
  projstatus: null
  pocemail: null
  fiscalyr: null
  projname: null
  safety: null
  projdesc: null
  funded: No
  projtype: Facilities
  planend: null
  docpath: null
  projid: null
  actcost: null
  efficient: null
  actend: null
  fundsource: null
  rationale: null
  expand: null
  planstart: null
  estcost: null
  projphase: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

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

---

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

---

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

---

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

---

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

---

ID: Other
Name: Other
Domains:
• projstatus:
  Inherited
• repair:
  Inherited
• expand:
  Inherited
• mandate:
  Inherited
• efficient:
  Inherited
• safety:
  Inherited
• funded:
  Inherited
• projtype:
  Inherited
• replace:
  Inherited
• projphase:
  Inherited
• fundsource:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  repair: null
  mandate: null
  pocname: null
  actstart: null
  replace: null
  pocphone: null
  projstatus: null
  pocemail: null
  fiscalyr: null
  projname: null
  safety: null
  projdesc: null
  funded: No
  projtype: Other
  planend: null
  docpath: null
  projid: null
  actcost: null
  efficient: null
  actend: null
  fundsource: null
  rationale: null
  expand: null
  planstart: null
  estcost: null
  projphase: 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