Name: Capital Projects - GO Bond Projects

Display Field: PROJECTNAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

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: 2725665.30022511
YMin: 969454.130095653
XMax: 2821212.31680433
YMax: 1160774.76320165
Spatial Reference: 102698 (102698)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[221,252,209,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"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:

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, Coded Values: [Active: Active], [Hold: Hold], [Completed: Completed])
• 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, Coded Values: [Airport: Airport], [Aquatic Facility: Aquatic Facility], [Athletic Court/Course/Field: Athletic Court/Course/Field], ... 25 more ...)
• CURRENTPHASE (type: esriFieldTypeString, alias: Current Phase, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Construction: Construction], [Design: Design], [Closeout: Closeout], ... 1 more ...)
• DEPARTMENT (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Parks & Recreation: Parks & Recreation], [Public Works: Public Works], [Smart Sewer Program: Smart Sewer Program], ... 1 more ...)
• 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, Coded Values: [Missouri: Missouri], [Kansas: Kansas])
• COUNCILDISTRICT (type: esriFieldTypeString, alias: Council District(s) Project is In, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DISPLAYONWEBSITE (type: esriFieldTypeString, alias: Display in Online Map (T/F), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [True: True], [False: False])
• 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)

Templates:

Name: Capital Projects - GO Bond Projects
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

• DEPARTMENT: Public Works
• PROJECTCITY: Kansas City
• PROJECTSTATE: Missouri
• DISPLAYONWEBSITE: False

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/23/2024 9:55:39 PM

Schema Last Edit Date: 2/23/2024 9:55:39 PM

Data Last Edit Date: 2/23/2024 9:55:39 PM

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