Layers:

Layer: SPU CIP Workorders (1)


Name: SPU CIP Workorders

Display Field: DOTMAP_PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

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: 1250203.42929931
YMin: 186571.635184377
XMax: 1292527.4768689
YMax: 271222.663060471
Spatial Reference: 2926 (2926)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"PROJECT_STATUS_CODE","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,168,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.97999999999999987}},"value":"ACTIVE","label":"ACTIVE"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,141,98,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.6}},"value":"COMPLETE","label":"COMPLETE"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,201,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Merged","label":"Merged"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,230,252,255],"toColor":[179,230,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,250,179,255],"toColor":[252,250,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,230,255],"toColor":[252,182,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,221,215,255],"toColor":[252,221,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,215,255],"toColor":[187,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,190,252,255],"toColor":[182,190,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,180,255],"toColor":[252,179,180,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[234,212,252,255],"toColor":[234,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[190,252,182,255],"toColor":[190,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,246,255],"toColor":[207,252,246,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,252,215,255],"toColor":[252,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,222,255],"toColor":[252,199,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,227,179,255],"toColor":[252,227,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

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

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AGENCY_UNIT_CODE (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PROJECT_STATUS_CODE (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• PROJECT_TYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• DOTMAP_PROJECT_ID (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• DOTMAP_PROJECT_NAME (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• DOTMAP_PROJECT_DESC (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• PROJECT_MANAGER_NAME (type: esriFieldTypeString, alias: Project Manager, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROJECT_MANAGER_PHONE (type: esriFieldTypeString, alias: Project Manager Phone Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PROJECT_MANAGER_EMAIL (type: esriFieldTypeString, alias: Project Manager Email Address, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• AGENCY_REFERENCE_ID (type: esriFieldTypeString, alias: Agency Reference, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• BUDGET_ID (type: esriFieldTypeString, alias: Budget ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FUNDED_FLAG (type: esriFieldTypeString, alias: Project Funded, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CONSTRUCTION_START_DATE (type: esriFieldTypeDate, alias: Construction Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONSTRUCTION_END_DATE (type: esriFieldTypeDate, alias: Construction End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMPKEY (type: esriFieldTypeInteger, alias: SDOT Street Compkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CP_PURPOSE_TEXT (type: esriFieldTypeString, alias: CIP Purpose, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

ID: ACTIVE
Name: ACTIVE
Domains:

Templates:

Name: ACTIVE
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PROJECT_STATUS_CODE: ACTIVE

---

ID: COMPLETE
Name: COMPLETE
Domains:

Templates:

Name: COMPLETE
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PROJECT_STATUS_CODE: COMPLETE

---

ID: Merged
Name: Merged
Domains:

Templates:

Name: Merged
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PROJECT_STATUS_CODE: Merged

---


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 12:28:51 PM

Schema Last Edit Date: 7/22/2025 12:27:18 PM

Data Last Edit Date: 7/22/2025 12:27:18 PM

Layer: CIP Project Boundaries (2)


Name: CIP Project Boundaries

Display Field: CP_PRJCT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

This layer shows the SPU Capital Improvement Project (CIP) locations and associated project data from the Enterprise Project Management System (EPMS). The locations may change shape as the project progresses through the stage gate process.



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: 1249021.11582609
YMin: 138774.582156628
XMax: 1431068.07905222
YMax: 286652.881215721
Spatial Reference: 2926 (2926)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"CP_STATUS_TEXT","uniqueValueInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[56,168,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":2.5}},"value":"Active","label":"Active"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[141,160,203,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[141,160,203,255],"width":2.5}},"value":"On Hold","label":"On Hold"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,141,98,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[252,141,98,255],"width":2.5}},"value":"Substantially Completed","label":"Closed/Substantially Completed"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,141,98,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[252,141,98,255],"width":2.5}},"value":"Closed","label":"Closed/Substantially Completed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[29,107,140,255],"toColor":[29,107,140,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[171,101,36,255],"toColor":[171,101,36,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[48,36,173,255],"toColor":[48,36,173,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[54,161,42,255],"toColor":[54,161,42,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[173,45,114,255],"toColor":[173,45,114,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[64,153,122,255],"toColor":[64,153,122,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[154,158,74,255],"toColor":[154,158,74,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[133,48,52,255],"toColor":[133,48,52,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[104,52,130,255],"toColor":[104,52,130,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[31,71,140,255],"toColor":[31,71,140,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[137,37,176,255],"toColor":[137,37,176,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[133,91,52,255],"toColor":[133,91,52,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[54,59,158,255],"toColor":[54,59,158,255]}]}}},"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: CP_STATUS_TEXT

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CP_KEY (type: esriFieldTypeInteger, alias: CP_KEY, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CP_ACTVTY_ID (type: esriFieldTypeString, alias: Activity Id, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CP_PROGRAM_NAME (type: esriFieldTypeString, alias: Program Name, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
• CP_PROGRAM_ID (type: esriFieldTypeString, alias: Program ID, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• CP_STATUS_TEXT (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• CP_START_DATE (type: esriFieldTypeDate, alias: Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CP_EXPCTD_CNST_DATE (type: esriFieldTypeDate, alias: Expected Construction Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CP_CMPLT_CNST_DATE (type: esriFieldTypeDate, alias: Construction Complete Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CP_LD_AGNCY_CODE (type: esriFieldTypeString, alias: Lead Agency ID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CP_PRJCT_CST_NBR (type: esriFieldTypeInteger, alias: Estimated Total Project Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CP_FUND_NAME (type: esriFieldTypeString, alias: Project Fund, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• CP_LOB_TEXT (type: esriFieldTypeString, alias: Line of Business LOB/LOS, SQL Type: sqlTypeOther, length: 210, nullable: true, editable: true)
• CP_PM_NAME (type: esriFieldTypeString, alias: Project Manager Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CP_PM_EML_TEXT (type: esriFieldTypeString, alias: Project Manager Email, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• CP_PM_PHN_NUM (type: esriFieldTypeString, alias: Project Manager Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CP_AGENCY_ID (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CP_FUNDED_FLAG (type: esriFieldTypeString, alias: Funded, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CP_MLTCMPMT_KEY (type: esriFieldTypeInteger, alias: Multicomponent Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CP_CMNCTN_NAME (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
• CP_CMNCTN_DESC (type: esriFieldTypeString, alias: Project Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CP_PURPOSE_TEXT (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• CP_PRD_DVLP_PHASE_TEXT (type: esriFieldTypeString, alias: Product Development Phase, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CP_PRJ_WEB_LINK_TEXT (type: esriFieldTypeString, alias: Project Web Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

ID: Active
Name: Active
Domains:

Templates:

Name: Active
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• CP_KEY: 0
• CP_STATUS_TEXT: Active

---

ID: On Hold
Name: On Hold
Domains:

Templates:

Name: On Hold
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• CP_KEY: 0
• CP_STATUS_TEXT: On Hold

---

ID: Substantially Completed
Name: Closed/Substantially Completed
Domains:

Templates:

Name: Closed/Substantially Completed
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• CP_KEY: 0
• CP_STATUS_TEXT: Substantially Completed

---

ID: Closed
Name: Closed/Substantially Completed
Domains:

Templates:

Name: Closed/Substantially Completed (1)
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• CP_KEY: 0
• CP_STATUS_TEXT: Closed

---


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/22/2025 12:28:51 PM

Schema Last Edit Date: 7/22/2025 12:28:51 PM

Data Last Edit Date: 7/22/2025 12:28:51 PM