Layer: CIP_Project_Task_Request_Summary

View In: Map Viewer

Name: CIP_Project_Task_Request_Summary_(GISrm)

Display Field: pocname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

actid (type: esriFieldTypeString, alias: Activity ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
actcategory (type: esriFieldTypeString, alias: Activity Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
acttype (type: esriFieldTypeString, alias: Activity Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
details (type: esriFieldTypeString, alias: Details, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
urgent (type: esriFieldTypeString, alias: Urgent, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
businessunit (type: esriFieldTypeString, alias: Business Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pocname (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pocemail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
requestdt (type: esriFieldTypeDate, alias: Requested By, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
assignedto (type: esriFieldTypeString, alias: Assigned To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
plannedstartdt (type: esriFieldTypeDate, alias: Planned Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
plannedenddt (type: esriFieldTypeDate, alias: Planned End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
plannedeffort (type: esriFieldTypeDouble, alias: Planned Effort, SQL Type: sqlTypeOther, nullable: true, editable: true)
actualenddt (type: esriFieldTypeDate, alias: Resolution Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
orggoal (type: esriFieldTypeString, alias: Organizational Goal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
prggoal (type: esriFieldTypeString, alias: GIS Program Goal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
capabilities (type: esriFieldTypeString, alias: ArcGIS Capabilities, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: Submitted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: Submitted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
division (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
cip (type: esriFieldTypeString, alias: CIP Project, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
prgstrategy (type: esriFieldTypeString, alias: GIS Goal Strategy, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
billable (type: esriFieldTypeString, alias: Billable, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
workordernum (type: esriFieldTypeString, alias: New CIP/Work Order Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
title (type: esriFieldTypeString, alias: Descriptive Title, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
url (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
important (type: esriFieldTypeString, alias: Important, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
justification_imp (type: esriFieldTypeString, alias: Importance Justification, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
priority (type: esriFieldTypeString, alias: Priority Level, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_mobilityconnectivity (type: esriFieldTypeString, alias: Mobility & Connectivity - Provide convenient and sustainable choices for people to get where they are going., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_parksopenspace (type: esriFieldTypeString, alias: Parks & Open Space - Provide diverse outdoor options for recreation and community with nature at any age., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_inclusivediverse (type: esriFieldTypeString, alias: Inclusive & Diverse - Effectuate equitable investment and social/environmental justice in the city and cultivate an organization that reflects our city's diversity., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_coreservicesinfrastru (type: esriFieldTypeString, alias: Core Services & Infrastructure - Sustain a financially sound city in which everyone feels safe and secure, with quality services and well-maintained infrastructure., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_localeconomicdev (type: esriFieldTypeString, alias: Local Economic Development - Catalyze development in riverfront and downtown areas and attract and retain businesses to maintain strong and diverse local economy., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_housinghomelessness (type: esriFieldTypeString, alias: Housing & Homelessness - Provide housing options for everyone and services for the most vulnerable members of society., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_engagelearn (type: esriFieldTypeString, alias: Engage & Learn - Leverage existing and new programming to support a sense of community and lifelong learning., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
orggoal_climateenergyres (type: esriFieldTypeString, alias: Climate & Energy Resiliency - Reduce climage impact, protect our environment and energy and improve reliability., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_grantfunding (type: esriFieldTypeString, alias: Grant & Funding Opportunity – Align initiatives with available grants or funding sources to secure external resources and reduce reliance on local budgets., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_legalcompliance (type: esriFieldTypeString, alias: Legal & Compliance – Ensure adherence to laws, regulations, and policies to mitigate risk and maintain operational integrity., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_communitypolitical (type: esriFieldTypeString, alias: Community & Political Relevance – Address initiatives with high visibility, public interest, or political significance that influence city leadership and public trust., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_techmodernization (type: esriFieldTypeString, alias: Technology & Modernization – Implement technological advancements that enhance digital services, cybersecurity, and smart city infrastructure., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_safetyemergency (type: esriFieldTypeString, alias: Public Safety & Emergency Response – Enhance the ability to prevent, respond to, and recover from emergencies while ensuring the safety of residents and infrastructure., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_operationaleff (type: esriFieldTypeString, alias: Operational Efficiency – Streamline internal workflows, reduce redundancies, and improve service delivery through innovation and resource optimization., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_financialsteward (type: esriFieldTypeString, alias: Financial Stewardship – Maximize budget efficiency, leverage funding opportunities, and ensure fiscal responsibility to sustain long-term city operations., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_interdeptregional (type: esriFieldTypeString, alias: Interdepartmental & Regional Impact – Foster collaboration across departments or jurisdictions to achieve shared goals and maximize citywide and regional benefits., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
impact_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
impact_orggoal (type: esriFieldTypeString, alias: Organization Strategic Goal - Aligns directly with one or more of this year’s strategic goals set by City Council., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
billing_notes (type: esriFieldTypeString, alias: Billing Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
proj_type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
cip_unlisted (type: esriFieldTypeString, alias: Unlisted CIP number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
workordername (type: esriFieldTypeString, alias: WO Project Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
projid (type: esriFieldTypeString, alias: Project CIP Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
projname (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
projdesc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
rationale (type: esriFieldTypeString, alias: Rationale, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
projtype (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [Facilities: Facilities], [Parks & Recreation: Parks & Recreation], [Transportation: Transportation], ... 6 more ...)
priority_1746479887911 (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [Priority 1: Priority 1 - Addresses Health & Safety, legal and regulatory requirements, or a top City Council Priority], [Priority 2: Priority 2 - Necessary, but if deferred there could be consequences], [Priority 3: Priority 3 - Nice to do and would contribute to the quality of life, but not essential], ... 1 more ...)
planalignment (type: esriFieldTypeString, alias: Plan, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [City Facilities & Infrastructure Financing Strategy: City Facilities & Infrastructure Financing Strategy], [City Facilities, Equipment and Vehicles Master Plan: City Facilities, Equipment and Vehicles Master Plan], [Climate Action Plan: Climate Action Plan], ... 23 more ...)
planstart (type: esriFieldTypeDate, alias: Planned 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)
estcost (type: esriFieldTypeDouble, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
contingency (type: esriFieldTypeDouble, alias: Contingency, SQL Type: sqlTypeOther, nullable: true, editable: true)
pocname_1746479887911 (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pocphone (type: esriFieldTypeString, alias: Contact Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
pocemail_1746479887911 (type: esriFieldTypeString, alias: Contact Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
agency (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [City of West Sacramento - General (Fund 400): City of West Sacramento - General (Fund 400)], [City of West Sacramento - Bridge District (Fund 405): City of West Sacramento - Bridge District (Fund 405)], [City of West Sacramento - Sewer (Fund 502): City of West Sacramento - Sewer (Fund 502)], ... 3 more ...)
department (type: esriFieldTypeString, alias: Department Responsible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Capital Projects: Capital Projects], [Parks & Recreation: Parks & Recreation], [Public Works: Public Works], ... 6 more ...)
projphase (type: esriFieldTypeString, alias: Project Phase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: PreDesign], [2: Design (PA&ED)], [3: Final Design (PS&E)], ... 5 more ...)
actstart (type: esriFieldTypeDate, alias: Actual Start 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)
actcost (type: esriFieldTypeDouble, alias: Actual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
docpath (type: esriFieldTypeString, alias: Document Path, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
publicview (type: esriFieldTypeString, alias: Public View, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
funding (type: esriFieldTypeDouble, alias: Funding, SQL Type: sqlTypeOther, nullable: true, editable: true)
fundingsources (type: esriFieldTypeString, alias: Funding Sources, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
fiscalyears (type: esriFieldTypeString, alias: Total Fiscal Years, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
projrank (type: esriFieldTypeDouble, alias: Supporting Drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
cip_1746479887911 (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [N/A: N/A], [Prior to 2019: Prior to 2019], [2019-2020: 2019-2020], ... 8 more ...)
externalproject (type: esriFieldTypeString, alias: External Project, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
driver1 (type: esriFieldTypeString, alias: De-industrialization, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver2 (type: esriFieldTypeString, alias: Modification/Rehabilitation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver3 (type: esriFieldTypeString, alias: New Construction, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver4 (type: esriFieldTypeString, alias: PA&ED/Design Only, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver5 (type: esriFieldTypeString, alias: Pre-Construction Activities, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver6 (type: esriFieldTypeString, alias: Pre-Development Activities, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver7 (type: esriFieldTypeString, alias: PS&E/Final Design Only, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver8 (type: esriFieldTypeString, alias: Replacement, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver9 (type: esriFieldTypeString, alias: ROW Acquisition Only, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
driver10 (type: esriFieldTypeString, alias: Study/Pre-Design Only, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
internalprojectreview (type: esriFieldTypeString, alias: Internal Project Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
externalprojectreview (type: esriFieldTypeString, alias: External Project Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
roadreview (type: esriFieldTypeString, alias: Road Review, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
conflictexception (type: esriFieldTypeString, alias: Conflict Exception, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
globalid_1746479887911 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user_1746479887911 (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date_1746479887911 (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user_1746479887911 (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date_1746479887911 (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeOther, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
Status_1746479887911 (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [In Development: In Development], [Council Approved: Council Approved], [Cap Projects Review: Cap Projects Review])
exclude (type: esriFieldTypeString, alias: Exclude, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
pmname (type: esriFieldTypeString, alias: Project Manager Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
pmphone (type: esriFieldTypeString, alias: Project Manager Phone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
pmemail (type: esriFieldTypeString, alias: Project Manager Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Citywide (type: esriFieldTypeString, alias: Citywide, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
locdesc (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
city_wide (type: esriFieldTypeDouble, alias: Citywide, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/20/2026 10:16:45 PM

Schema Last Edit Date: 5/5/2025 6:26:16 PM

Data Last Edit Date: 5/5/2025 6:26:16 PM

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

Layer: CIP_Project_Task_Request_Summary_(GISrm) (ID:0)