Layers:

Layer: CIP_Project_Task_Request_Summary_(GISrm) (0)


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

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:

XMin: -13539344.3872225
YMin: -2385.02424770035
XMax: 1526.08353052325
YMax: 4669379.98908116
Spatial Reference: 102100 (3857)


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:

Name : ObjectId

IsSystemMaintained : True


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:

Name: GIS_Activities
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


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