Name: WORKING_CIP_Projects

Display Field: projname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -115211411.338416
YMin: -93821070.4960547
XMax: 128334744.67175
YMax: 76478306.0228868
Spatial Reference: 102642 (2226)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"projtype","defaultSymbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":2}},"defaultLabel":"TBD","uniqueValueGroups":[{"heading":"Project Type","classes":[{"label":"City Buildings","description":"City Buildings","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,0,255],"width":2}},"values":[["City Buildings"]]},{"label":"Parks and Recreation","description":"Parks and Recreation","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":2}},"values":[["Parks and Recreation"]]},{"label":"Transportation","description":"Transportation","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,230,0,255],"width":2}},"values":[["Transportation"]]},{"label":"Sewer","description":"Sewer","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":2}},"values":[["Sewer"]]},{"label":"Flood/Drainage","description":"Flood/Drainage","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2}},"values":[["Flood/Drainage"]]},{"label":"Water","description":"Water","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2}},"values":[["Water"]]},{"label":"Port of West Sacramento","description":"Port of West Sacramento","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":2}},"values":[["Port of West Sacramento"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,0,255],"width":2}},"value":"City Buildings","label":"City Buildings"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":2}},"value":"Parks and Recreation","label":"Parks and Recreation"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,230,0,255],"width":2}},"value":"Transportation","label":"Transportation"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":2}},"value":"Sewer","label":"Sewer"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2}},"value":"Flood/Drainage","label":"Flood/Drainage"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":2}},"value":"Water","label":"Water"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,0],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":2}},"value":"Port of West Sacramento","label":"Port of West Sacramento"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,207,255],"toColor":[252,212,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,182,255],"toColor":[184,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,184,252,255],"toColor":[179,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,248,252,255],"toColor":[184,248,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,223,255],"toColor":[252,179,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,250,189,255],"toColor":[252,250,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,218,252,255],"toColor":[182,218,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,179,252,255],"toColor":[233,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[229,207,252,255],"toColor":[229,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,221,255],"toColor":[207,252,221,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,232,199,255],"toColor":[252,232,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,191,255],"toColor":[252,179,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,234,255],"toColor":[252,207,234,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: projtype

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CIP (type: esriFieldTypeString, alias: CIP#*, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• projname (type: esriFieldTypeString, alias: Project Name*, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projtype (type: esriFieldTypeString, alias: Project Type*, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City Buildings: City Buildings], [Flood/Drainage: Flood/Drainage], [Parks and Recreation: Parks and Recreation], ... 4 more ...)
• projdesc (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Primary_PM (type: esriFieldTypeString, alias: Primary Project Manager*, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Ariana Adame: Ariana Adame], [Amber Saiyasit: Amber Saiyasit], [Amber Wallace: Amber Wallace], ... 50 more ...)
• Secondary_PM (type: esriFieldTypeString, alias: Secondary Project Manager, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Amber Saiyasit: Amber Saiyasit], [Amber Wallace: Amber Wallace], [Bernard Corrales: Bernard Corrales], ... 50 more ...)
• Tertiary_PM (type: esriFieldTypeString, alias: Tertiary Project Manager, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Amber Saiyasit: Amber Saiyasit], [Amber Wallace: Amber Wallace], [Bernard Corrales: Bernard Corrales], ... 50 more ...)
• PM_Dept (type: esriFieldTypeString, alias: Managing Department*, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Capital Projects: Capital Projects], [City Manager's Office: City Manager's Office], [Community Development: Community Development], ... 3 more ...)
• pocphone (type: esriFieldTypeString, alias: Contact Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• pocemail (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• estcost (type: esriFieldTypeDouble, alias: Estimated Cost*, SQL Type: sqlTypeOther, nullable: true, editable: true)
• actcost (type: esriFieldTypeDouble, alias: Actual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• projphase (type: esriFieldTypeString, alias: Project Phase*, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Study: Study], [PreDesign: PreDesign], [Design (PA&ED): Design (PA&ED)], ... 6 more ...)
• planstart (type: esriFieldTypeDate, alias: Planned Start Date*, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• actstart (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• planend (type: esriFieldTypeDate, alias: Planned End Date*, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• actend (type: esriFieldTypeDate, alias: Actual End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• docpath (type: esriFieldTypeString, alias: Document Path, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Shape__Area (type: esriFieldTypeDouble, alias: SHAPE__Area, SQL Type: sqlTypeDouble, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: SHAPE__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
• Completion_Status (type: esriFieldTypeString, alias: Completion Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Not Started: Not Started], [In Progress - Missing Project Limits: In Progress - Missing Project Limits], [In Progress - Missing Attributes: In Progress - Missing Attributes], ... 6 more ...)
• PrimaryPM_Email (type: esriFieldTypeString, alias: Primary PM Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Attachments_count (type: esriFieldTypeString, alias: Attachments Count, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Citywide (type: esriFieldTypeString, alias: Citywide, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BridgeDistrict (type: esriFieldTypeString, alias: BridgeDistrict, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)

Types:

ID: City Buildings
Name: City Buildings
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: Primary_PM
  Inherited
  
• Field Name: Secondary_PM
  Inherited
  
• Field Name: Tertiary_PM
  Inherited
  
• Field Name: PM_Dept
  Inherited
  
Templates:

Name: City Buildings
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: City Buildings

---

ID: Parks and Recreation
Name: Parks and Recreation
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: Primary_PM
  Inherited
  
• Field Name: Secondary_PM
  Inherited
  
• Field Name: Tertiary_PM
  Inherited
  
• Field Name: PM_Dept
  Inherited
  
Templates:

Name: Parks and Recreation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Parks and Recreation

---

ID: Transportation
Name: Transportation
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: Primary_PM
  Inherited
  
• Field Name: Secondary_PM
  Inherited
  
• Field Name: Tertiary_PM
  Inherited
  
• Field Name: PM_Dept
  Inherited
  
Templates:

Name: Transportation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Transportation

---

ID: Sewer
Name: Sewer
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: Primary_PM
  Inherited
  
• Field Name: Secondary_PM
  Inherited
  
• Field Name: Tertiary_PM
  Inherited
  
• Field Name: PM_Dept
  Inherited
  
Templates:

Name: Sewer
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Sewer

---

ID: Flood/Drainage
Name: Flood/Drainage
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: Primary_PM
  Inherited
  
• Field Name: Secondary_PM
  Inherited
  
• Field Name: Tertiary_PM
  Inherited
  
• Field Name: PM_Dept
  Inherited
  
Templates:

Name: Flood/Drainage
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Flood/Drainage

---

ID: Water
Name: Water
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: Primary_PM
  Inherited
  
• Field Name: Secondary_PM
  Inherited
  
• Field Name: Tertiary_PM
  Inherited
  
• Field Name: PM_Dept
  Inherited
  
Templates:

Name: Water
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Water

---

ID: Port of West Sacramento
Name: Port of West Sacramento
Domains:

• Field Name: projtype
  Inherited
  
• Field Name: Primary_PM
  Inherited
  
• Field Name: Secondary_PM
  Inherited
  
• Field Name: Tertiary_PM
  Inherited
  
• Field Name: PM_Dept
  Inherited
  
Templates:

Name: Port of West Sacramento
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• projtype: Port of West Sacramento

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/13/2025 9:19:36 PM

Schema Last Edit Date: 11/13/2025 9:19:36 PM

Data Last Edit Date: 11/13/2025 9:19:36 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat