Name: CIP Projects Table

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description: N/A

Service Item Id: f338008b31d24692a4cc9a36e6455ba3

Copyright Text: N/A

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: N/A

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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 Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• Dept ( nullable: true, length: 255, alias: Dept, type: esriFieldTypeString )
• Munis_Numbers ( nullable: true, length: 255, alias: Munis_Numbers, type: esriFieldTypeString )
• Project_Name ( nullable: true, length: 255, alias: Project_Name, type: esriFieldTypeString )
• Project_Phase ( nullable: true, length: 255, alias: Project_Phase, type: esriFieldTypeString )
• Project_Description ( nullable: true, length: 1052, alias: Project_Description, type: esriFieldTypeString )
• ProjectStatus ( nullable: true, length: 255, alias: ProjectStatus, type: esriFieldTypeString )
• ProjectNotesUpcomingMilestone ( nullable: true, length: 526, alias: ProjectNotesUpcomingMilestone, type: esriFieldTypeString )
• Upcoming_Milestones ( nullable: true, length: 255, alias: Upcoming_Milestones, type: esriFieldTypeString )
• Project_Address_1 ( nullable: true, length: 255, alias: Project_Address_1, type: esriFieldTypeString )
• Project_Address_2 ( nullable: true, length: 255, alias: Project_Address_2, type: esriFieldTypeString )
• PM_ON_PROJECT ( nullable: true, length: 255, alias: PM_ON_PROJECT, type: esriFieldTypeString )
• Current_Contract_End_Date ( nullable: true, length: 8, alias: Current_Contract_End_Date, type: esriFieldTypeDate )
• Days_to_Contract_Completion ( nullable: true, alias: Days_to_Contract_Completion, type: esriFieldTypeInteger )
• Project_Completion_Season ( nullable: true, length: 255, alias: Project_Completion_Season, type: esriFieldTypeString )
• Project_Completion_Year ( nullable: true, alias: Project_Completion_Year, type: esriFieldTypeInteger )
• FY2022_Adopted_Spend_Cash_Flow_ ( nullable: true, alias: FY2022_Adopted_Spend_Cash_Flow_City, type: esriFieldTypeInteger )
• FY2022_A_1 ( nullable: true, alias: FY2022_Adopted_Spend_Cash_Flow_Grant, type: esriFieldTypeDouble )
• FY2022_A_2 ( nullable: true, alias: FY2022_Adopted_Spend_Cash_Flow_LoCIP, type: esriFieldTypeInteger )
• FY2022_A_3 ( nullable: true, alias: FY2022_Adopted_Spend_Cash_Flow_Total_Preliminary_Adopted, type: esriFieldTypeDouble )
• FY2022_YTD_ExpendedJULY_City_PR ( nullable: true, alias: FY2022_YTD_ExpendedJULY_City_PROJECTED, type: esriFieldTypeDouble )
• FY2022_YTD_ExpendedJULY_Grant_P ( nullable: true, alias: FY2022 YTD ExpendedJULY Grant PROJECTED, type: esriFieldTypeDouble )
• FY2022_YTD_Expended_JULY_LoCIP_ ( nullable: true, alias: FY2022_YTD_Expended_JULY_LoCIP_PROJECTED, type: esriFieldTypeDouble )
• Total_PROJECTED ( nullable: true, alias: Total_PROJECTED, type: esriFieldTypeDouble )
• FY2022_YTD_Expended_August_City ( nullable: true, alias: FY2022_YTD_Expended_August_City_ACTUAL, type: esriFieldTypeInteger )
• FY2022_YTD_Expended_August_Gran ( nullable: true, alias: FY2022_YTD_Expended_August_Grant_ACTUAL, type: esriFieldTypeInteger )
• FY2022_YTD_Expended_August_LoCI ( nullable: true, alias: FY2022_YTD_Expended_August_LoCIP_ACTUAL, type: esriFieldTypeInteger )
• Total_YTD_Expended_ACTUAL ( nullable: true, alias: Total_YTD_Expended_ACTUAL, type: esriFieldTypeInteger )
• FY2022_YTD_Encumbered_August_Ci ( nullable: true, alias: FY2022_YTD_Encumbered_August_City_ACTUAL, type: esriFieldTypeInteger )
• FY2022_YTD_Encumbered_August_Gr ( nullable: true, alias: FY2022_YTD_Encumbered_August_Grant_ACTUAL, type: esriFieldTypeInteger )
• FY2022_YTD_Encumbered_August_Lo ( nullable: true, alias: FY2022_YTD_Encumbered_August_LoCIP_ACTUAL, type: esriFieldTypeInteger )
• Total_YTD_Encumbered_ACTUAL ( nullable: true, alias: Total_YTD_Encumbered_ACTUAL, type: esriFieldTypeInteger )
• S_W_FY2022_YTD_Expended_Encumbe ( nullable: true, alias: S_W_FY2022_YTD_Expended_Encumbered_City_ACTUAL, type: esriFieldTypeInteger )
• T_Z_FY2022_YTD_Expended_Encumbe ( nullable: true, alias: T_Z_FY2022_YTD_Expended_Encumbered_Grant_ACTUAL, type: esriFieldTypeInteger )
• V_Y_FY2022_YTD_Expended_Encumbe ( nullable: true, alias: V_Y_FY2022_YTD_Expended_Encumbered_LoCIP_ACTUAL, type: esriFieldTypeInteger )
• Total_Expended_Encumbered_YTD ( nullable: true, alias: Total_Expended_Encumbered_YTD, type: esriFieldTypeInteger )
• K_S_W_FY2022_Budget_Percent_Rem ( nullable: true, alias: K_S_W_FY2022_Budget_Percent_Remaining_City_ACTUAL, type: esriFieldTypeInteger )
• L_T_X_FY2022_Budget_Percent_Rem ( nullable: true, alias: L_T_X_FY2022_Budget_Percent_Remaining_Grant_ACTUAL, type: esriFieldTypeDouble )
• M_U_Y_FY2022_Budget_Percent_Rem ( nullable: true, alias: M_U_Y_FY2022_Budget_Percent_Remaining_LoCIP_ACTUAL, type: esriFieldTypeInteger )
• N_V_Z_Total_YTD ( nullable: true, alias: N_V_Z_Total_YTD, type: esriFieldTypeDouble )
• FY2023_REQ_From_FY2022_Budget_R ( nullable: true, alias: FY2023_REQ_From_FY2022_Budget_Request_Form, type: esriFieldTypeDouble )
• From_FY2022_Budget_Request_Form ( nullable: true, alias: From_FY2022_Budget_Request_Form_FY2024_REQ, type: esriFieldTypeInteger )
• From_FY2_1 ( nullable: true, alias: From_FY2022_Budget_Request_Form_FY2025_REQ, type: esriFieldTypeInteger )
• From_FY2_2 ( nullable: true, alias: From_FY2022_Budget_Request_Form_FY2026_REQ, type: esriFieldTypeInteger )
• FY2027_TO_COMPLETION ( nullable: true, alias: FY2027_TO_COMPLETION, type: esriFieldTypeInteger )
• FY2022_FY2026_TOTAL_REQUESTED ( nullable: true, alias: FY2022_FY2026_TOTAL_REQUESTED, type: esriFieldTypeDouble )
• PROJECT_FY22_Life_of_Project_TO ( nullable: true, alias: PROJECT_FY22_Life_of_Project_TOTAL_REQUESTED, type: esriFieldTypeDouble )
• NOTES_1 ( nullable: true, length: 255, alias: NOTES 1, type: esriFieldTypeString )
• LocationID ( nullable: true, alias: LocationID, type: esriFieldTypeInteger )
• PM_Contact_Number ( nullable: true, length: 255, alias: PM_Contact_Number, type: esriFieldTypeString )
• PM_Email_Address ( nullable: true, length: 255, alias: PM_Email_Address, type: esriFieldTypeString )
• LocationIDTxt ( nullable: true, length: 10, alias: LocationIDTxt, type: esriFieldTypeString )

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

  Iteminfo   Thumbnail   Metadata