Name: ROWM_PROJECTS

Display Field: project_name_full

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 1155582

Max. Scale: 1128

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 6626022.63357864
YMin: 1850035.1266914
XMax: 6798455.27329272
YMax: 2131262.30111256
Spatial Reference: 102642 (2226)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"department","uniqueValueInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[230,0,0,43],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,0,255],"width":2.25}},"value":"Comcast - Sacramento","label":"Comcast - Sacramento"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[85,255,0,36],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[85,255,0,255],"width":2.25}},"value":"Development","label":"Development"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,170,0,53],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2.25}},"value":"PG&E - Sacramento","label":"PG&E - Sacramento"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,0,197,31],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,197,255],"width":2.25}},"value":"PW - Capital Improvement","label":"PW - Capital Improvement"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[71,71,71,39],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[71,71,71,255],"width":2.25}},"value":"PW - Maintenance","label":"PW - Maintenance"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[168,168,0,43],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[168,168,0,255],"width":2.25}},"value":"PW - Resurfacing","label":"PW - Resurfacing"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,85,0,31],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,85,0,255],"width":2.25}},"value":"PW - Transportation Programming","label":"PW - Transportation Programming"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,168,132,41],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,168,132,255],"width":2.25}},"value":"Permits","label":"Permits"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[230,76,0,36],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[230,76,0,255],"width":2.25}},"value":"SMUD - Sacramento","label":"SMUD - Sacramento"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[56,168,0,39],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":2.25}},"value":"Special Events","label":"Special Events"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,197,255,39],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2.25}},"value":"Utility - Capital Improvement","label":"Utility - Capital Improvement"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,76,115,41],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,76,115,255],"width":2.25}},"value":"Utility - Maintenance","label":"Utility - Maintenance"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,0,0,57],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":2.25}},"value":"Verizon - Sacramento","label":"Verizon - Sacramento"}],"fieldDelimiter":","},"scaleSymbols":true,"transparency":20,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

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: department

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• project_id (type: esriFieldTypeString, alias: Project Id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• project_name_full (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_type (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Electric: Electric], [Gas: Gas], [Land: Land], ... 7 more ...)
• project_url (type: esriFieldTypeString, alias: Project URL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• moratoriums_opportunities (type: esriFieldTypeString, alias: Paving Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [N/A (No Resurfacing): N/A (No Resurfacing)], [Overlay Moratorium: Overlay Moratorium], [Slurry Seal Moratorium: Slurry Seal Moratorium])
• contact_email (type: esriFieldTypeString, alias: Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [abanwait@cityofsacramento.org: Avtar Banwait], [acastle-keane@cityofsacramento.org: Amber Castle-Keane], [alau@cityofsacramento.org: Adam Lau], ... 95 more ...)
• globalid (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• start_date (type: esriFieldTypeDate, alias: Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• end_date (type: esriFieldTypeDate, alias: End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ProjectPhase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Planning: Planning], [Preliminary Engineering: Preliminary Engineering], [Final Design: Final Design], ... 2 more ...)
• ProjectYear (type: esriFieldTypeInteger, alias: Project Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• description_full (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)

Types:

ID: Comcast - Sacramento
Name: Comcast - Sacramento
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: Comcast - Sacramento
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: Comcast - Sacramento
• ProjectPhase: Pre-Design

---

ID: Development
Name: Development
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: Development
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: Development
• ProjectPhase: Pre-Design

---

ID: PG&E - Sacramento
Name: PG&E - Sacramento
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: PG&E - Sacramento
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: PG&E - Sacramento
• ProjectPhase: Pre-Design

---

ID: PW - Capital Improvement
Name: PW - Capital Improvement
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: PW - Capital Improvement
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: PW - Capital Improvement
• ProjectPhase: Pre-Design

---

ID: PW - Maintenance
Name: PW - Maintenance
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: PW - Maintenance
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: PW - Maintenance
• ProjectPhase: Pre-Design

---

ID: PW - Resurfacing
Name: PW - Resurfacing
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: PW - Resurfacing
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: PW - Resurfacing
• ProjectPhase: Pre-Design

---

ID: PW - Transportation Programming
Name: PW - Transportation Programming
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: PW - Transportation Programming
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: PW - Transportation Programming
• ProjectPhase: Pre-Design

---

ID: Permits
Name: Permits
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: Permits
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: Permits
• ProjectPhase: Pre-Design

---

ID: SMUD - Sacramento
Name: SMUD - Sacramento
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: SMUD - Sacramento
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: SMUD - Sacramento
• ProjectPhase: Pre-Design

---

ID: Special Events
Name: Special Events
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: Special Events
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: Special Events
• ProjectPhase: Pre-Design

---

ID: Utility - Capital Improvement
Name: Utility - Capital Improvement
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: Utility - Capital Improvement
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: Utility - Capital Improvement
• ProjectPhase: Pre-Design

---

ID: Utility - Maintenance
Name: Utility - Maintenance
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: Utility - Maintenance
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: Utility - Maintenance
• ProjectPhase: Pre-Design

---

ID: Verizon - Sacramento
Name: Verizon - Sacramento
Domains:

• Field Name: department
  Inherited
  
• Field Name: facility_type
  Inherited
  
• Field Name: moratoriums_opportunities
  Inherited
  
• Field Name: project_status
  Inherited
  
• Field Name: contact_email
  Inherited
  
Templates:

Name: Verizon - Sacramento
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• department: Verizon - Sacramento
• ProjectPhase: Pre-Design

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/24/2026 6:30:28 PM

Schema Last Edit Date: 4/24/2026 6:30:28 PM

Data Last Edit Date: 1/15/2026 11:10:36 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat