View In:   ArcGIS Online Map Viewer

Name: Projects

Display Field: PROJNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 6cd1e65eec3b4f03a00b07618f95cbb8

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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: 410677.052677989
YMin: 182767.30793081224
XMax: 428308.9777159095
YMax: 202598.36374107003
Spatial Reference: 103782  (103782)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PROJTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Street Reconstruction
  Label: Street Reconstruction
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 0, 51]
  Outline:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: Street & Utility
  Label: Street & Utility
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [0, 4, 255, 51]
  Outline:
  Style: esriSLSSolid
  Color: [0, 4, 255, 255]
  Width: 2
• Value: Street Maintenance
  Label: Street Maintenance
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 132, 51]
  Outline:
  Style: esriSLSSolid
  Color: [255, 0, 132, 255]
  Width: 2
• Value: Street Maintenance Alternatives
  Label: Street Maintenance Alternatives
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 132, 51]
  Outline:
  Style: esriSLSSolid
  Color: [166, 23, 102, 255]
  Width: 2
• Value: CIP Overlay
  Label: CIP Overlay
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 119, 0, 51]
  Outline:
  Style: esriSLSSolid
  Color: [255, 119, 0, 255]
  Width: 2
• Value: Street Dept Overlay
  Label: Street Dept Overlay
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 192, 138, 51]
  Outline:
  Style: esriSLSSolid
  Color: [255, 192, 138, 255]
  Width: 2
• Value: Sewer Cured in Place Pipe Lining
  Label: Sewer Cured in Place Pipe Lining
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [26, 255, 0, 51]
  Outline:
  Style: esriSLSSolid
  Color: [26, 255, 0, 255]
  Width: 2
• Value: Trail Extension
  Label: Trail Extension
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [246, 255, 0, 51]
  Outline:
  Style: esriSLSSolid
  Color: [246, 255, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: true
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: 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 )
• PROJNAME ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJNAME )
• TOTCOST ( type: esriFieldTypeDouble, alias: Total Cost, editable: true, nullable: true, defaultValue: null, modelName: TOTCOST )
• TOTLEN ( type: esriFieldTypeDouble, alias: Total Length, editable: true, nullable: true, defaultValue: null, modelName: TOTLEN )
• TOTAREA ( type: esriFieldTypeDouble, alias: Total Area, editable: true, nullable: true, defaultValue: null, modelName: TOTAREA )
• TOTPNT ( type: esriFieldTypeDouble, alias: Point Count, editable: true, nullable: true, defaultValue: null, modelName: TOTPNT )
• DATESTART ( type: esriFieldTypeDate, alias: Expected Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTART )
• DATECOMP ( type: esriFieldTypeDate, alias: Date Completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECOMP )
• CIPSTAT ( type: esriFieldTypeString, alias: CIP Status, editable: true, nullable: true, length: 50, defaultValue: Proposed, modelName: CIPSTAT , Coded Values: [Proposed: Proposed] , [Completed: Completed] , [Approved: Approved] , ...3 more... )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NOTES )
• PRJMAN ( type: esriFieldTypeString, alias: Project Manager, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PRJMAN , Coded Values: [Other: Other] , [Unknown: Unknown] , [City Engineer: City Engineer] , ...2 more... )
• CREATNAM ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATNAM )
• CREATDAT ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATDAT )
• LINK ( type: esriFieldTypeString, alias: Link to Report, editable: true, nullable: true, length: 175, defaultValue: null, modelName: LINK )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• PROJTYPE ( type: esriFieldTypeString, alias: Project Type, editable: true, nullable: true, length: 80, defaultValue: null, modelName: PROJTYPE , Coded Values: [Street Reconstruction: Street Reconstruction] , [Street Overlay: Street Overlay] , [Street Rehabilitation: Street Rehabilitation] , ...7 more... )
• FUNDSOUR ( type: esriFieldTypeString, alias: Funding Source, editable: true, nullable: true, length: 80, defaultValue: null, modelName: FUNDSOUR , Coded Values: [Unknown: Unknown] , [General Revenue: General Revenue] , [Revenue Bonds: Revenue Bonds] , ...3 more... )
• MANPHONE ( type: esriFieldTypeString, alias: Contact Phone, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MANPHONE )
• MANEMAIL ( type: esriFieldTypeString, alias: Contact Email, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MANEMAIL )
• Shape__Area ( type: esriFieldTypeDouble, alias: SHAPE.STArea(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STArea(), required: true )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PROJNUM ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: 00000, modelName: PROJNUM )
• PROJYEAR ( type: esriFieldTypeInteger, alias: Project Year, editable: true, nullable: true, defaultValue: null, modelName: PROJYEAR , Range: [1900, 2099] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: Street Reconstruction
Name: Street Reconstruction
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: Street Reconstruction
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: Street Reconstruction
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Street & Utility
Name: Street & Utility
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: Street & Utility
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: Street & Utility
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Street Maintenance
Name: Street Maintenance
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: Street Maintenance
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: Street Maintenance
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Street Maintenance Alternatives
Name: Street Maintenance Alternatives
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: Street Maintenance Alternatives
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: Street Maintenance Alternatives
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: CIP Overlay
Name: CIP Overlay
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: CIP Overlay
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: CIP Overlay
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Street Dept Overlay
Name: Street Dept Overlay
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: Street Dept Overlay
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: Street Dept Overlay
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Sewer Cured in Place Pipe Lining
Name: Sewer Cured in Place Pipe Lining
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: Sewer Cured in Place Pipe Lining
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: Sewer Cured in Place Pipe Lining
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Trail Extension
Name: Trail Extension
Domains:
• CIPSTAT:
  Inherited
• PRJMAN:
  Inherited
• PROJTYPE:
  Inherited
• FUNDSOUR:
  Inherited
• PROJYEAR:
  Inherited
Templates:
• Name: Trail Extension
  Description:
  Prototype:
  PROJYEAR: null
  PROJNUM: 00000
  PROJNAME: null
  TOTCOST: null
  TOTLEN: null
  TOTAREA: null
  TOTPNT: null
  DATESTART: null
  DATECOMP: null
  CIPSTAT: Proposed
  NOTES: null
  PRJMAN: null
  CREATNAM: null
  CREATDAT: null
  LINK: null
  LASTEDITOR: null
  LASTUPDATE: null
  PROJTYPE: Trail Extension
  FUNDSOUR: null
  MANPHONE: null
  MANEMAIL: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Relationships:

• CIPPoints (1) -- Related To: Project Point (1)
• CIPProjectsLocations (0) -- Related To: Project Locations (0)
• CIPPolylines (2) -- Related To: Project Lines (2)
• CIPPolygons (3) -- Related To: Project Polygons (3)
• CIPProjectsOverview (4) -- Related To: Project Overviews (5)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata