Name: KCIA_Databook_CapitalProjects_Sept2024

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2722914.23945075
YMin: 1124271.56061766
XMax: 2760236.19892741
YMax: 1160736.76721466
Spatial Reference: 102698 (102698)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"DEPARTMENT","defaultSymbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,130,130,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"Department","classes":[{"label":"Parks & Recreation","description":"Parks & Recreation","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[212,252,204,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"values":[["Parks & Recreation"]]},{"label":"Public Works","description":"Public Works","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[212,179,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"values":[["Public Works"]]},{"label":"Smart Sewer Program","description":"Smart Sewer Program","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,183,179,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"values":[["Smart Sewer Program"]]},{"label":"Water Services","description":"Water Services","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[187,229,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"values":[["Water Services"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[212,252,204,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"value":"Parks & Recreation","label":"Parks & Recreation"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[212,179,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"value":"Public Works","label":"Public Works"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,183,179,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"value":"Smart Sewer Program","label":"Smart Sewer Program"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[187,229,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}},"value":"Water Services","label":"Water Services"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,250,210,255],"toColor":[252,250,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,251,255],"toColor":[252,179,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,222,252,255],"toColor":[179,222,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,200,255],"toColor":[252,189,200,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,252,235,255],"toColor":[184,252,235,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,252,179,255],"toColor":[194,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,179,252,255],"toColor":[179,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[240,210,252,255],"toColor":[240,210,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,221,212,255],"toColor":[252,221,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[239,252,179,255],"toColor":[239,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,246,252,255],"toColor":[215,246,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,223,255],"toColor":[252,184,223,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,252,215,255],"toColor":[220,252,215,255]}]}}},"scaleSymbols":true,"transparency":0,"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:

Type ID Field: DEPARTMENT

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PROJECTID (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CITYCONTRACTNUMBER (type: esriFieldTypeString, alias: City Contract Number, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• PROJECTNAME (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• PROJECTSTATUS (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BUDGETSOURCE (type: esriFieldTypeString, alias: Budget Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECTSCOPE (type: esriFieldTypeString, alias: Project Scope, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• TOTALBUDGET (type: esriFieldTypeInteger, alias: Total Budget, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJECTTYPE (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CURRENTPHASE (type: esriFieldTypeString, alias: Current Phase, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DEPARTMENT (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECTCONTACTNAME (type: esriFieldTypeString, alias: Project Contact Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROJECTCONTACTEMAIL (type: esriFieldTypeString, alias: Project Contact Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROJECTCONTACTPHONENUMBER (type: esriFieldTypeString, alias: Project Contact Phone Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECTSTARTDATE (type: esriFieldTypeDate, alias: Date Project Starts, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROJECTENDDATE (type: esriFieldTypeDate, alias: Date Project Is Projected to End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONSTRUCTIONSTARTDATE (type: esriFieldTypeDate, alias: Date Construction Begins, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CONSTRUCTIONENDDATE (type: esriFieldTypeDate, alias: Date Construction is Projected To End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PROJECTLOCATION (type: esriFieldTypeString, alias: Project Location, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• PROJECTCITY (type: esriFieldTypeString, alias: Project City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECTSTATE (type: esriFieldTypeString, alias: Project State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COUNCILDISTRICT (type: esriFieldTypeString, alias: Council District(s) Project is In, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECTLINK (type: esriFieldTypeString, alias: Project Link, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• PROJECTCONTACTNAME2 (type: esriFieldTypeString, alias: Secondary Project Contact Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROJECTCONTACTEMAIL2 (type: esriFieldTypeString, alias: Secondary Project Contact Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PROJECTCONTACTPHONENUMBER2 (type: esriFieldTypeString, alias: Secondary Project Contact PhoneNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RESIDENTPROJECTREPNAME (type: esriFieldTypeString, alias: Resident Project Rep Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• RESIDENTPROJECTREPEMAIL (type: esriFieldTypeString, alias: Resident Project Rep Email, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• RESIDENTPROJECTREPPHONE (type: esriFieldTypeString, alias: Resident Project Rep Phone Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PIACNUMBER (type: esriFieldTypeString, alias: PIAC Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PORTALID (type: esriFieldTypeString, alias: PORTALID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: Parks & Recreation
Name: Parks & Recreation
Domains:

Templates:

Name: Parks & Recreation
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• DEPARTMENT: Parks & Recreation

---

ID: Public Works
Name: Public Works
Domains:

Templates:

Name: Public Works
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• DEPARTMENT: Public Works

---

ID: Smart Sewer Program
Name: Smart Sewer Program
Domains:

Templates:

Name: Smart Sewer Program
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• DEPARTMENT: Smart Sewer Program

---

ID: Water Services
Name: Water Services
Domains:

Templates:

Name: Water Services
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• DEPARTMENT: Water Services

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/27/2024 8:20:49 PM

Schema Last Edit Date: 9/27/2024 8:20:49 PM

Data Last Edit Date: 9/27/2024 8:20:49 PM

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