Name: CIP Projects Table

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: f338008b31d24692a4cc9a36e6455ba3

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

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

  Iteminfo   Thumbnail   Metadata