Name: Capital Improvement Project List

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 750

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 )
• Munis_Project_Number ( type: esriFieldTypeString, alias: Munis_Project_Number, length: 255 )
• Project_ID ( type: esriFieldTypeString, alias: Project_ID, length: 255 )
• Council_District ( type: esriFieldTypeString, alias: Council_District, length: 255 )
• Location_Description ( type: esriFieldTypeString, alias: Location_Description, length: 1073741822 )
• PM_Project_Description ( type: esriFieldTypeString, alias: PM_Project_Description, length: 1073741822 )
• Public_Project_Description ( type: esriFieldTypeString, alias: Public_Project_Description, length: 1073741822 )
• Project_Type ( type: esriFieldTypeString, alias: Project_Type, length: 255 )
• Associated_Program ( type: esriFieldTypeString, alias: Associated_Program, length: 255 )
• Project_Phase ( type: esriFieldTypeString, alias: Project_Phase, length: 255 )
• Phase_Description ( type: esriFieldTypeString, alias: Phase_Description, 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 )
• Actual_Start_Date ( type: esriFieldTypeString, alias: Actual_Start_Date, 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 )
• Actual_End_Date ( type: esriFieldTypeString, alias: Actual_End_Date, length: 255 )
• On_Schedule ( type: esriFieldTypeString, alias: On_Schedule, length: 255 )
• Total_Project_Budget ( type: esriFieldTypeString, alias: Total_Project_Budget, length: 255 )
• Funding_1 ( type: esriFieldTypeString, alias: Funding_1, length: 255 )
• Funding_2 ( type: esriFieldTypeString, alias: Funding_2, length: 255 )
• Funding_Amount_1 ( type: esriFieldTypeString, alias: Funding_Amount_1, length: 255 )
• Funding_Amount_2 ( type: esriFieldTypeString, alias: Funding_Amount_2, length: 255 )
• On_Budget ( type: esriFieldTypeString, alias: On_Budget, length: 255 )
• Controlling_Entity ( type: esriFieldTypeString, alias: Controlling_Entity, length: 255 )
• Originating_Department ( type: esriFieldTypeString, alias: Originating_Department, length: 255 )
• Managing_Department ( type: esriFieldTypeString, alias: Managing_Department, 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 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• Status_Date ( type: esriFieldTypeString, alias: Status_Date, length: 255 )
• Approved ( type: esriFieldTypeInteger, alias: Approved )
• Workflow_Status ( type: esriFieldTypeString, alias: Workflow_Status, length: 255 )
• Image_URL ( type: esriFieldTypeString, alias: Image_URL, length: 512 )
• PermMask ( type: esriFieldTypeString, alias: PermMask, length: 512 )
• Icon_URL ( type: esriFieldTypeString, alias: Icon_URL, length: 255 )
• Public_Facing ( type: esriFieldTypeSmallInteger, alias: Public_Facing )
• ID ( type: esriFieldTypeInteger, alias: ID )
• Modified ( type: esriFieldTypeDate, alias: Modified, length: 8 )
• Created ( type: esriFieldTypeDate, alias: Created, length: 8 )
• Author ( type: esriFieldTypeString, alias: Author, length: 128 )
• Editor ( type: esriFieldTypeString, alias: Editor, length: 128 )

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

  Iteminfo   Thumbnail   Metadata