Name: CIP_PROJECTS_SMARTSHEET

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 36d2fc39d3ad4891bf98f91930a2ee25

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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 )
• F_ ( type: esriFieldTypeString, alias: $, length: 255 )
• Time ( type: esriFieldTypeString, alias: Time, length: 255 )
• Other ( type: esriFieldTypeSmallInteger, alias: Other )
• Charter ( type: esriFieldTypeSmallInteger, alias: Charter )
• Project__ ( type: esriFieldTypeString, alias: Project #, length: 255 )
• Munis__ ( type: esriFieldTypeString, alias: Munis #, length: 255 )
• Project_Name ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• D_PM ( type: esriFieldTypeString, alias: D-PM, length: 255 )
• C_PM ( type: esriFieldTypeString, alias: C-PM, length: 255 )
• Project_Budget ( type: esriFieldTypeString, alias: Project Budget, length: 255 )
• Project_Cost ( type: esriFieldTypeDouble, alias: Project Cost )
• Prior_Years_Actuals ( type: esriFieldTypeString, alias: Prior Years Actuals, length: 255 )
• FY19_20_Actuals ( type: esriFieldTypeDouble, alias: FY19-20 Actuals )
• FY21_Actuals ( type: esriFieldTypeDouble, alias: FY21 Actuals )
• FY22_Actuals ( type: esriFieldTypeDouble, alias: FY22 Actuals )
• Est__Substantial_Date ( type: esriFieldTypeString, alias: Est. Substantial Date, length: 255 )
• Final_Date ( type: esriFieldTypeDate, alias: Final Date, length: 8 )
• Procurement ( type: esriFieldTypeString, alias: Procurement, length: 255 )
• Department ( type: esriFieldTypeString, alias: Department, length: 255 )
• Council_Date ( type: esriFieldTypeString, alias: Council Date, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• Act__Design_Completion_date ( type: esriFieldTypeString, alias: Act. Design Completion date, length: 255 )
• Act__Substantial_Date ( type: esriFieldTypeDate, alias: Act. Substantial Date, length: 8 )
• Fac_ ( type: esriFieldTypeSmallInteger, alias: Fac. )
• W_S ( type: esriFieldTypeSmallInteger, alias: W/S )
• Street ( type: esriFieldTypeSmallInteger, alias: Street )
• HAS_PIO ( type: esriFieldTypeSmallInteger, alias: HAS PIO )
• Active_Project ( type: esriFieldTypeString, alias: Active Project, length: 255 )
• Fy2021_Q1_Spend ( type: esriFieldTypeDouble, alias: Fy2021 Q1 Spend )
• FY2021_Q1_Chargebacks ( type: esriFieldTypeDouble, alias: FY2021 Q1 Chargebacks )
• Fy2021_Q2_Spend ( type: esriFieldTypeDouble, alias: Fy2021 Q2 Spend )
• FY2021_Q2_Chargebacks ( type: esriFieldTypeDouble, alias: FY2021 Q2 Chargebacks )
• FY2021_Q3_Spend ( type: esriFieldTypeDouble, alias: FY2021 Q3 Spend )
• Fy2021_Q3_Chargebacks ( type: esriFieldTypeDouble, alias: Fy2021 Q3 Chargebacks )
• Fy2021_Q4_Spend ( type: esriFieldTypeDouble, alias: Fy2021 Q4 Spend )
• FY21_Q4_Chargebacks ( type: esriFieldTypeDouble, alias: FY21 Q4 Chargebacks )
• Total_Billable_FY21_Chargebacks ( type: esriFieldTypeDouble, alias: Total Billable FY21 Chargebacks )
• Total_Actual_Fy21_Chargebacks ( type: esriFieldTypeDouble, alias: Total Actual Fy21 Chargebacks )
• FY22_Q1_Chargebacks ( type: esriFieldTypeDouble, alias: FY22 Q1 Chargebacks )
• FY22_Q1_Spend ( type: esriFieldTypeDouble, alias: FY22 Q1 Spend )
• FY22_Total_Chargebacks ( type: esriFieldTypeDouble, alias: Fy22 Total Chargebacks )
• Total_Invoices ( type: esriFieldTypeDouble, alias: Total Invoices )
• Budget_Status ( type: esriFieldTypeString, alias: Budget Status, length: 255 )
• Billable_vs_Actual_Chargebacks ( type: esriFieldTypeDouble, alias: Billable vs Actual Chargebacks )
• Address_Start ( type: esriFieldTypeString, alias: Address Start, length: 255 )
• Address_End ( type: esriFieldTypeString, alias: Address End, length: 255 )
• Citywide__Yes_No_ ( type: esriFieldTypeString, alias: Citywide (Yes/No), length: 255 )
• FY23_Actuals ( type: esriFieldTypeDouble, alias: FY23 Actuals )
• Est__Charter_Design_Completion_ ( type: esriFieldTypeDate, alias: Est. Charter Design Completion Date, length: 8 )
• Actual_Design_Start_Date__Kicko ( type: esriFieldTypeString, alias: Actual Design Start Date (Kickoff Date), length: 255 )
• Contract_Design_Completion_Date ( type: esriFieldTypeDate, alias: Contract Design Completion Date, length: 8 )
• Actual_Construction_Start_Date_ ( type: esriFieldTypeString, alias: Actual Construction Start Date (NTP Date), length: 255 )
• FY22_Q2_Spend ( type: esriFieldTypeDouble, alias: FY22 Q2 Spend )
• FY22Q2_Chargebacks ( type: esriFieldTypeDouble, alias: FY22Q2 Chargebacks )
• FY22_Q3_Spend ( type: esriFieldTypeDouble, alias: FY22 Q3 Spend )
• FY22_Q3_Chargeback ( type: esriFieldTypeDouble, alias: FY22 Q3 Chargeback )
• FY22_Q4_Spend ( type: esriFieldTypeDouble, alias: FY22 Q4 Spend )
• FY22_Q4_Chargeback ( type: esriFieldTypeString, alias: FY22 Q4 Chargeback, length: 255 )
• Priority_Order ( type: esriFieldTypeDouble, alias: Priority Order )
• WSD_Lead_Representative ( type: esriFieldTypeString, alias: WSD Lead Representative, length: 255 )
• WSD_Reviewer ( type: esriFieldTypeString, alias: WSD Reviewer, length: 255 )
• Latest_Comment ( type: esriFieldTypeString, alias: Latest Comment, length: 360 )
• Action_Items ( type: esriFieldTypeString, alias: Action Items, length: 255 )

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

  Iteminfo   Thumbnail   Metadata