Layer: SPU CIP Workorders (ID:1)

View In: Map Viewer

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

Sources

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:

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:

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:

PROJECT_STATUS_CODE: ACTIVE

PROJECT_STATUS_CODE: COMPLETE

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:27:18 PM

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

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

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