Name: CIP_PROJECTS_SMARTSHEET

Display Field: Project_Name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 7436baff872943a38690f25442460e43

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false
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:

Fields:

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

Templates:

• Name: CIP_PROJECTS_SMARTSHEET
  Description:
  Prototype:
  Latest_Comment: null
  F_: null
  Time: null
  Other: null
  Charter: null
  Project__: null
  Munis__: null
  Project_Name: null
  D_PM: null
  C_PM: null
  Project_Budget: null
  Project_Cost: null
  Prior_Years_Actuals: null
  FY19_20_Actuals: null
  FY21_Actuals: null
  FY22_Actuals: null
  Est__Substantial_Date: null
  Final_Date: null
  Procurement: null
  Department: null
  Council_Date: null
  Status: null
  Act__Design_Completion_date: null
  Act__Substantial_Date: null
  Fac_: null
  W_S: null
  Street: null
  HAS_PIO: null
  Active_Project: null
  Fy2021_Q1_Spend: null
  FY2021_Q1_Chargebacks: null
  Fy2021_Q2_Spend: null
  FY2021_Q2_Chargebacks: null
  FY2021_Q3_Spend: null
  Fy2021_Q3_Chargebacks: null
  Fy2021_Q4_Spend: null
  FY21_Q4_Chargebacks: null
  Total_Billable_FY21_Chargebacks: null
  Total_Actual_Fy21_Chargebacks: null
  FY22_Q1_Chargebacks: null
  FY22_Q1_Spend: null
  FY22_Total_Chargebacks: null
  Total_Invoices: null
  Budget_Status: null
  Billable_vs_Actual_Chargebacks: null
  Address_Start: null
  Address_End: null
  Citywide__Yes_No_: null
  FY23_Actuals: null
  Est__Charter_Design_Completion_: null
  Actual_Design_Start_Date__Kicko: null
  Contract_Design_Completion_Date: null
  Actual_Construction_Start_Date_: null
  FY22_Q2_Spend: null
  FY22Q2_Chargebacks: null
  FY22_Q3_Spend: null
  FY22_Q3_Chargeback: null
  FY22_Q4_Spend: null
  FY22_Q4_Chargeback: null
  Priority_Order: null
  WSD_Lead_Representative: null
  WSD_Reviewer: null
  Action_Items: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata