Name: Capital Improvement Project List

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description: This is a comprehensive project list for all the active Capital Improvement Projects in the City of Charlotte's capital plan. This list is maintained by all departments in the City of Charlotte that manage Capital Improvement Projects. This data will be joined with GIS data and support a Captial Improvement Dashboard.

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• ObjectID ( type: esriFieldTypeOID, alias: OBJECTID )
• Project_Name ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• Location_Description ( type: esriFieldTypeString, alias: Location Description, length: 1073741822 )
• Public_Project_Description ( type: esriFieldTypeString, alias: Public Project Description, length: 1073741822 )
• Project_Type ( type: esriFieldTypeString, alias: Project Type, length: 255 )
• Project_Phase ( type: esriFieldTypeString, alias: Project Phase, length: 255 )
• Anticipated_Start_Date ( type: esriFieldTypeString, alias: Anticipated Start Date, length: 255 )
• Anticipated_Start_Date_Year ( type: esriFieldTypeString, alias: Anticipated Start Date Year, length: 255 )
• Anticipated_Compl_Date ( type: esriFieldTypeString, alias: Anticipated Compl Date, length: 255 )
• Anticipated_Compl_Date_Year ( type: esriFieldTypeString, alias: Anticipated Compl Date Year, length: 255 )
• Total_Project_Budget ( type: esriFieldTypeString, alias: Total Project Budget, length: 255 )
• Controlling_Entity ( type: esriFieldTypeString, alias: Controlling Entity, length: 255 )
• Project_Manager ( type: esriFieldTypeString, alias: Project Manager, length: 255 )
• Project_Manager_Email ( type: esriFieldTypeString, alias: Project Manager Email, length: 255 )
• Project_Manager_Phone ( type: esriFieldTypeString, alias: Project Manager Phone, length: 255 )
• City_Council_Priority_Area ( type: esriFieldTypeString, alias: City Council Priority Area, length: 255 )
• Project_Impact ( type: esriFieldTypeString, alias: Project Impact, length: 255 )
• Existing_URL ( type: esriFieldTypeString, alias: Existing URL, length: 255 )
• Image_URL ( type: esriFieldTypeString, alias: Image URL, length: 512 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• Icon_URL ( type: esriFieldTypeString, alias: Icon URL, length: 255 )
• Public_Facing ( type: esriFieldTypeSmallInteger, alias: Public_Facing )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata