Name: CIP_PROJECTS_SMARTSHEET_Pv2_dashboard

Display Field: GISADMIN_CIP_PROJECTS_SMARTSHEE

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 36d2fc39d3ad4891bf98f91930a2ee25

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -112.43991822125072
YMin: 33.50524102819698
XMax: -112.1510030173766
YMax: 33.7407557217596
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [209, 207, 252, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_Project__ ( type: esriFieldTypeString, alias: Project__, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_Munis_no ( type: esriFieldTypeString, alias: Munis_no, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_Fiscal_Year ( type: esriFieldTypeSmallInteger, alias: Fiscal_Year )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_CITY_WIDE ( type: esriFieldTypeString, alias: CITY_WIDE, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Pv2_GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_F_ ( type: esriFieldTypeString, alias: $, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Time ( type: esriFieldTypeString, alias: Time, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Other ( type: esriFieldTypeSmallInteger, alias: Other )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Charter ( type: esriFieldTypeSmallInteger, alias: Charter )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Project__ ( type: esriFieldTypeString, alias: Project #, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Project_Name ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Address_Start ( type: esriFieldTypeString, alias: Address Start, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Address_End ( type: esriFieldTypeString, alias: Address End, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Citywide__Yes_No_ ( type: esriFieldTypeString, alias: Citywide (Yes/No), length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Munis__ ( type: esriFieldTypeString, alias: Munis #, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_D_PM ( type: esriFieldTypeString, alias: D-PM, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_C_PM ( type: esriFieldTypeString, alias: C-PM, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Project_Budget ( type: esriFieldTypeString, alias: Project Budget, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Project_Cost ( type: esriFieldTypeDouble, alias: Project Cost )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY23_Actuals ( type: esriFieldTypeDouble, alias: FY23 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Actuals ( type: esriFieldTypeDouble, alias: FY22 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Est__Charter_Design_Completion_ ( type: esriFieldTypeDate, alias: Est. Charter Design Completion Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Actual_Design_Start_Date__Kicko ( type: esriFieldTypeString, alias: Actual Design Start Date (Kickoff Date), length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Contract_Design_Completion_Date ( type: esriFieldTypeDate, alias: Contract Design Completion Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Act__Design_Completion_date ( type: esriFieldTypeString, alias: Act. Design Completion date, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Est__Substantial_Date ( type: esriFieldTypeString, alias: Est. Substantial Date, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Actual_Construction_Start_Date_ ( type: esriFieldTypeString, alias: Actual Construction Start Date (NTP Date), length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Act__Substantial_Date ( type: esriFieldTypeDate, alias: Act. Substantial Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Final_Date ( type: esriFieldTypeDate, alias: Final Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Procurement ( type: esriFieldTypeString, alias: Procurement, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Department ( type: esriFieldTypeString, alias: Department, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Council_Date ( type: esriFieldTypeString, alias: Council Date, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Prior_Years_Actuals ( type: esriFieldTypeString, alias: Prior Years Actuals, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY19_20_Actuals ( type: esriFieldTypeDouble, alias: FY19-20 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY21_Actuals ( type: esriFieldTypeDouble, alias: FY21 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Fac_ ( type: esriFieldTypeSmallInteger, alias: Fac. )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_W_S ( type: esriFieldTypeSmallInteger, alias: W/S )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Street ( type: esriFieldTypeSmallInteger, alias: Street )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_HAS_PIO ( type: esriFieldTypeSmallInteger, alias: HAS PIO )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Active_Project ( type: esriFieldTypeString, alias: Active Project, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Q1_Spend ( type: esriFieldTypeDouble, alias: FY22 Q1 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Q1_Chargebacks ( type: esriFieldTypeDouble, alias: FY22 Q1 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Q2_Spend ( type: esriFieldTypeDouble, alias: FY22 Q2 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22Q2_Chargebacks ( type: esriFieldTypeDouble, alias: FY22Q2 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Q3_Spend ( type: esriFieldTypeDouble, alias: FY22 Q3 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Q3_Chargeback ( type: esriFieldTypeDouble, alias: FY22 Q3 Chargeback )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Q4_Spend ( type: esriFieldTypeDouble, alias: FY22 Q4 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Q4_Chargeback ( type: esriFieldTypeString, alias: FY22 Q4 Chargeback, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY22_Total_Chargebacks ( type: esriFieldTypeDouble, alias: FY22 Total Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Fy2021_Q1_Spend ( type: esriFieldTypeDouble, alias: Fy2021 Q1 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY2021_Q1_Chargebacks ( type: esriFieldTypeDouble, alias: FY2021 Q1 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Fy2021_Q2_Spend ( type: esriFieldTypeDouble, alias: Fy2021 Q2 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY2021_Q2_Chargebacks ( type: esriFieldTypeDouble, alias: FY2021 Q2 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY2021_Q3_Spend ( type: esriFieldTypeDouble, alias: FY2021 Q3 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Fy2021_Q3_Chargebacks ( type: esriFieldTypeDouble, alias: Fy2021 Q3 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Fy2021_Q4_Spend ( type: esriFieldTypeDouble, alias: Fy2021 Q4 Spend )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_FY21_Q4_Chargebacks ( type: esriFieldTypeDouble, alias: FY21 Q4 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Total_Billable_FY21_Chargebacks ( type: esriFieldTypeDouble, alias: Total Billable FY21 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Total_Actual_Fy21_Chargebacks ( type: esriFieldTypeDouble, alias: Total Actual Fy21 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Total_Invoices ( type: esriFieldTypeDouble, alias: Total Invoices )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Budget_Status ( type: esriFieldTypeString, alias: Budget Status, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Billable_vs_Actual_Chargebacks ( type: esriFieldTypeDouble, alias: Billable vs Actual Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Priority_Order ( type: esriFieldTypeDouble, alias: Priority Order )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_WSD_Lead_Representative ( type: esriFieldTypeString, alias: WSD Lead Representative, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_WSD_Reviewer ( type: esriFieldTypeString, alias: WSD Reviewer, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Latest_Comment ( type: esriFieldTypeString, alias: Latest Comment, length: 360 )
• GISADMIN_CIP_PROJECTS_SMARTSHEET_Action_Items ( type: esriFieldTypeString, alias: Action Items, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• Shape.STArea() ( type: esriFieldTypeDouble, alias: Shape.STArea() )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

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

  Iteminfo   Thumbnail   Metadata