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_SMARTSHEE ( type: esriFieldTypeString, alias: Project__, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSH_1 ( type: esriFieldTypeString, alias: Munis_no, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSH_2 ( type: esriFieldTypeSmallInteger, alias: Fiscal_Year )
• GISADMIN_CIP_PROJECTS_SMARTSH_3 ( type: esriFieldTypeString, alias: CITY_WIDE, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSH_4 ( type: esriFieldTypeString, alias: created_user, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSH_5 ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSH_6 ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTSH_7 ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTSH_8 ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GISADMIN_CIP_PROJECTS_SMARTSH_9 ( type: esriFieldTypeInteger, alias: OBJECTID )
• GISADMIN_CIP_PROJECTS_SMARTS_10 ( type: esriFieldTypeString, alias: $, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_11 ( type: esriFieldTypeString, alias: Time, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_12 ( type: esriFieldTypeSmallInteger, alias: Other )
• GISADMIN_CIP_PROJECTS_SMARTS_13 ( type: esriFieldTypeSmallInteger, alias: Charter )
• GISADMIN_CIP_PROJECTS_SMARTS_14 ( type: esriFieldTypeString, alias: Project #, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_15 ( type: esriFieldTypeString, alias: Project Name, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_16 ( type: esriFieldTypeString, alias: Status, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_17 ( type: esriFieldTypeString, alias: Address Start, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_18 ( type: esriFieldTypeString, alias: Address End, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_19 ( type: esriFieldTypeString, alias: Citywide (Yes/No), length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_20 ( type: esriFieldTypeString, alias: Munis #, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_21 ( type: esriFieldTypeString, alias: D-PM, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_22 ( type: esriFieldTypeString, alias: C-PM, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_23 ( type: esriFieldTypeString, alias: Project Budget, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_24 ( type: esriFieldTypeDouble, alias: Project Cost )
• GISADMIN_CIP_PROJECTS_SMARTS_25 ( type: esriFieldTypeDouble, alias: FY23 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTS_26 ( type: esriFieldTypeDouble, alias: FY22 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTS_27 ( type: esriFieldTypeDate, alias: Est. Charter Design Completion Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTS_28 ( type: esriFieldTypeString, alias: Actual Design Start Date (Kickoff Date), length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_29 ( type: esriFieldTypeDate, alias: Contract Design Completion Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTS_30 ( type: esriFieldTypeString, alias: Act. Design Completion date, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_31 ( type: esriFieldTypeString, alias: Est. Substantial Date, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_32 ( type: esriFieldTypeString, alias: Actual Construction Start Date (NTP Date), length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_33 ( type: esriFieldTypeDate, alias: Act. Substantial Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTS_34 ( type: esriFieldTypeDate, alias: Final Date, length: 8 )
• GISADMIN_CIP_PROJECTS_SMARTS_35 ( type: esriFieldTypeString, alias: Procurement, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_36 ( type: esriFieldTypeString, alias: Department, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_37 ( type: esriFieldTypeString, alias: Council Date, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_38 ( type: esriFieldTypeString, alias: Prior Years Actuals, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_39 ( type: esriFieldTypeDouble, alias: FY19-20 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTS_40 ( type: esriFieldTypeDouble, alias: FY21 Actuals )
• GISADMIN_CIP_PROJECTS_SMARTS_41 ( type: esriFieldTypeSmallInteger, alias: Fac. )
• GISADMIN_CIP_PROJECTS_SMARTS_42 ( type: esriFieldTypeSmallInteger, alias: W/S )
• GISADMIN_CIP_PROJECTS_SMARTS_43 ( type: esriFieldTypeSmallInteger, alias: Street )
• GISADMIN_CIP_PROJECTS_SMARTS_44 ( type: esriFieldTypeSmallInteger, alias: HAS PIO )
• GISADMIN_CIP_PROJECTS_SMARTS_45 ( type: esriFieldTypeString, alias: Active Project, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_46 ( type: esriFieldTypeDouble, alias: FY22 Q1 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_47 ( type: esriFieldTypeDouble, alias: FY22 Q1 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_48 ( type: esriFieldTypeDouble, alias: FY22 Q2 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_49 ( type: esriFieldTypeDouble, alias: FY22Q2 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_50 ( type: esriFieldTypeDouble, alias: FY22 Q3 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_51 ( type: esriFieldTypeDouble, alias: FY22 Q3 Chargeback )
• GISADMIN_CIP_PROJECTS_SMARTS_52 ( type: esriFieldTypeDouble, alias: FY22 Q4 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_53 ( type: esriFieldTypeString, alias: FY22 Q4 Chargeback, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_54 ( type: esriFieldTypeDouble, alias: FY22 Total Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_55 ( type: esriFieldTypeDouble, alias: Fy2021 Q1 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_56 ( type: esriFieldTypeDouble, alias: FY2021 Q1 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_57 ( type: esriFieldTypeDouble, alias: Fy2021 Q2 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_58 ( type: esriFieldTypeDouble, alias: FY2021 Q2 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_59 ( type: esriFieldTypeDouble, alias: FY2021 Q3 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_60 ( type: esriFieldTypeDouble, alias: Fy2021 Q3 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_61 ( type: esriFieldTypeDouble, alias: Fy2021 Q4 Spend )
• GISADMIN_CIP_PROJECTS_SMARTS_62 ( type: esriFieldTypeDouble, alias: FY21 Q4 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_63 ( type: esriFieldTypeDouble, alias: Total Billable FY21 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_64 ( type: esriFieldTypeDouble, alias: Total Actual Fy21 Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_65 ( type: esriFieldTypeDouble, alias: Total Invoices )
• GISADMIN_CIP_PROJECTS_SMARTS_66 ( type: esriFieldTypeString, alias: Budget Status, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_67 ( type: esriFieldTypeDouble, alias: Billable vs Actual Chargebacks )
• GISADMIN_CIP_PROJECTS_SMARTS_68 ( type: esriFieldTypeDouble, alias: Priority Order )
• GISADMIN_CIP_PROJECTS_SMARTS_69 ( type: esriFieldTypeString, alias: WSD Lead Representative, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_70 ( type: esriFieldTypeString, alias: WSD Reviewer, length: 255 )
• GISADMIN_CIP_PROJECTS_SMARTS_71 ( type: esriFieldTypeString, alias: Latest Comment, length: 360 )
• GISADMIN_CIP_PROJECTS_SMARTS_72 ( 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