ArcGIS REST Services Directory
Login
Home
>
services
>
Planning
>
CIP_PROJECTS_SMARTSHEET_Pv2 (FeatureServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (Planning/CIP_PROJECTS_SMARTSHEET_Pv2)
Layers:
Layer:
CIP Projects
(0)
Name:
CIP Projects
Display Field:
Project__
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
7436baff872943a38690f25442460e43
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
true
Supports Datum Transformation:
true
Extent:
XMin: -112.53707500232605
YMin: 33.50479588347223
XMax: -112.1510030173766
YMax: 33.764552819559384
Spatial Reference: 4326 (4326) LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style:
esriSFSSolid
Color:
[196, 252, 212, 0]
Outline:
Style:
esriSLSSolid
Color:
[255, 0, 0, 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: true
Supports Returning Geometry Centroid: true
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:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Project__
( type: esriFieldTypeString, alias: Project__, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project__ )
Munis_no
( type: esriFieldTypeString, alias: Munis_no, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Munis_no )
Fiscal_Year
( type: esriFieldTypeSmallInteger, alias: Fiscal_Year, editable: true, nullable: true, defaultValue: null, modelName: Fiscal_Year )
CITY_WIDE
( type: esriFieldTypeString, alias: CITY_WIDE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CITY_WIDE ,
Coded Values:
[Y: Yes] , [N: No] )
Shape__Area
( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
Shape__Length
( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
created_user
( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
created_date
( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
Name: CIP Projects
Description:
Prototype:
CITY_WIDE:
null
Project__:
null
Munis_no:
null
Fiscal_Year:
null
Drawing Tool: esriFeatureEditToolPolygon
Layer:
CIP_PROJECTS_SMARTSHEET_Pv2_dashboard
(1)
Name:
CIP_PROJECTS_SMARTSHEET_Pv2_dashboard
Display Field:
GISADMIN_CIP_PROJECTS_SMARTSHEE
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
7436baff872943a38690f25442460e43
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
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: true
Supports Returning Geometry Centroid: true
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:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
GISADMIN_CIP_PROJECTS_SMARTSHEE
( type: esriFieldTypeString, alias: Project__, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSHEE )
GISADMIN_CIP_PROJECTS_SMARTSH_1
( type: esriFieldTypeString, alias: Munis_no, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_1 )
GISADMIN_CIP_PROJECTS_SMARTSH_2
( type: esriFieldTypeSmallInteger, alias: Fiscal_Year, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_2 )
GISADMIN_CIP_PROJECTS_SMARTSH_3
( type: esriFieldTypeString, alias: CITY_WIDE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_3 )
GISADMIN_CIP_PROJECTS_SMARTSH_4
( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_4 )
GISADMIN_CIP_PROJECTS_SMARTSH_5
( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_5 )
GISADMIN_CIP_PROJECTS_SMARTSH_6
( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_6 )
GISADMIN_CIP_PROJECTS_SMARTSH_7
( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_7 )
GISADMIN_CIP_PROJECTS_SMARTSH_8
( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_8 )
GISADMIN_CIP_PROJECTS_SMARTSH_9
( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTSH_9 )
GISADMIN_CIP_PROJECTS_SMARTS_10
( type: esriFieldTypeString, alias: $, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_10 )
GISADMIN_CIP_PROJECTS_SMARTS_11
( type: esriFieldTypeString, alias: Time, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_11 )
GISADMIN_CIP_PROJECTS_SMARTS_12
( type: esriFieldTypeSmallInteger, alias: Other, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_12 )
GISADMIN_CIP_PROJECTS_SMARTS_13
( type: esriFieldTypeSmallInteger, alias: Charter, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_13 )
GISADMIN_CIP_PROJECTS_SMARTS_14
( type: esriFieldTypeString, alias: Project #, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_14 )
GISADMIN_CIP_PROJECTS_SMARTS_15
( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_15 )
GISADMIN_CIP_PROJECTS_SMARTS_16
( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_16 )
GISADMIN_CIP_PROJECTS_SMARTS_17
( type: esriFieldTypeString, alias: Address Start, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_17 )
GISADMIN_CIP_PROJECTS_SMARTS_18
( type: esriFieldTypeString, alias: Address End, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_18 )
GISADMIN_CIP_PROJECTS_SMARTS_19
( type: esriFieldTypeString, alias: Citywide (Yes/No), editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_19 )
GISADMIN_CIP_PROJECTS_SMARTS_20
( type: esriFieldTypeString, alias: Munis #, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_20 )
GISADMIN_CIP_PROJECTS_SMARTS_21
( type: esriFieldTypeString, alias: D-PM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_21 )
GISADMIN_CIP_PROJECTS_SMARTS_22
( type: esriFieldTypeString, alias: C-PM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_22 )
GISADMIN_CIP_PROJECTS_SMARTS_23
( type: esriFieldTypeString, alias: Project Budget, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_23 )
GISADMIN_CIP_PROJECTS_SMARTS_24
( type: esriFieldTypeDouble, alias: Project Cost, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_24 )
GISADMIN_CIP_PROJECTS_SMARTS_25
( type: esriFieldTypeDouble, alias: FY23 Actuals, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_25 )
GISADMIN_CIP_PROJECTS_SMARTS_26
( type: esriFieldTypeDouble, alias: FY22 Actuals, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_26 )
GISADMIN_CIP_PROJECTS_SMARTS_27
( type: esriFieldTypeDate, alias: Est. Charter Design Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_27 )
GISADMIN_CIP_PROJECTS_SMARTS_28
( type: esriFieldTypeString, alias: Actual Design Start Date (Kickoff Date), editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_28 )
GISADMIN_CIP_PROJECTS_SMARTS_29
( type: esriFieldTypeDate, alias: Contract Design Completion Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_29 )
GISADMIN_CIP_PROJECTS_SMARTS_30
( type: esriFieldTypeString, alias: Act. Design Completion date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_30 )
GISADMIN_CIP_PROJECTS_SMARTS_31
( type: esriFieldTypeString, alias: Est. Substantial Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_31 )
GISADMIN_CIP_PROJECTS_SMARTS_32
( type: esriFieldTypeString, alias: Actual Construction Start Date (NTP Date), editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_32 )
GISADMIN_CIP_PROJECTS_SMARTS_33
( type: esriFieldTypeDate, alias: Act. Substantial Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_33 )
GISADMIN_CIP_PROJECTS_SMARTS_34
( type: esriFieldTypeDate, alias: Final Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_34 )
GISADMIN_CIP_PROJECTS_SMARTS_35
( type: esriFieldTypeString, alias: Procurement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_35 )
GISADMIN_CIP_PROJECTS_SMARTS_36
( type: esriFieldTypeString, alias: Department, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_36 )
GISADMIN_CIP_PROJECTS_SMARTS_37
( type: esriFieldTypeString, alias: Council Date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_37 )
GISADMIN_CIP_PROJECTS_SMARTS_38
( type: esriFieldTypeString, alias: Prior Years Actuals, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_38 )
GISADMIN_CIP_PROJECTS_SMARTS_39
( type: esriFieldTypeDouble, alias: FY19-20 Actuals, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_39 )
GISADMIN_CIP_PROJECTS_SMARTS_40
( type: esriFieldTypeDouble, alias: FY21 Actuals, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_40 )
GISADMIN_CIP_PROJECTS_SMARTS_41
( type: esriFieldTypeSmallInteger, alias: Fac., editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_41 )
GISADMIN_CIP_PROJECTS_SMARTS_42
( type: esriFieldTypeSmallInteger, alias: W/S, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_42 )
GISADMIN_CIP_PROJECTS_SMARTS_43
( type: esriFieldTypeSmallInteger, alias: Street, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_43 )
GISADMIN_CIP_PROJECTS_SMARTS_44
( type: esriFieldTypeSmallInteger, alias: HAS PIO, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_44 )
GISADMIN_CIP_PROJECTS_SMARTS_45
( type: esriFieldTypeString, alias: Active Project, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_45 )
GISADMIN_CIP_PROJECTS_SMARTS_46
( type: esriFieldTypeDouble, alias: FY22 Q1 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_46 )
GISADMIN_CIP_PROJECTS_SMARTS_47
( type: esriFieldTypeDouble, alias: FY22 Q1 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_47 )
GISADMIN_CIP_PROJECTS_SMARTS_48
( type: esriFieldTypeDouble, alias: FY22 Q2 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_48 )
GISADMIN_CIP_PROJECTS_SMARTS_49
( type: esriFieldTypeDouble, alias: FY22Q2 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_49 )
GISADMIN_CIP_PROJECTS_SMARTS_50
( type: esriFieldTypeDouble, alias: FY22 Q3 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_50 )
GISADMIN_CIP_PROJECTS_SMARTS_51
( type: esriFieldTypeDouble, alias: FY22 Q3 Chargeback, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_51 )
GISADMIN_CIP_PROJECTS_SMARTS_52
( type: esriFieldTypeDouble, alias: FY22 Q4 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_52 )
GISADMIN_CIP_PROJECTS_SMARTS_53
( type: esriFieldTypeString, alias: FY22 Q4 Chargeback, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_53 )
GISADMIN_CIP_PROJECTS_SMARTS_54
( type: esriFieldTypeDouble, alias: FY22 Total Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_54 )
GISADMIN_CIP_PROJECTS_SMARTS_55
( type: esriFieldTypeDouble, alias: Fy2021 Q1 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_55 )
GISADMIN_CIP_PROJECTS_SMARTS_56
( type: esriFieldTypeDouble, alias: FY2021 Q1 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_56 )
GISADMIN_CIP_PROJECTS_SMARTS_57
( type: esriFieldTypeDouble, alias: Fy2021 Q2 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_57 )
GISADMIN_CIP_PROJECTS_SMARTS_58
( type: esriFieldTypeDouble, alias: FY2021 Q2 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_58 )
GISADMIN_CIP_PROJECTS_SMARTS_59
( type: esriFieldTypeDouble, alias: FY2021 Q3 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_59 )
GISADMIN_CIP_PROJECTS_SMARTS_60
( type: esriFieldTypeDouble, alias: Fy2021 Q3 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_60 )
GISADMIN_CIP_PROJECTS_SMARTS_61
( type: esriFieldTypeDouble, alias: Fy2021 Q4 Spend, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_61 )
GISADMIN_CIP_PROJECTS_SMARTS_62
( type: esriFieldTypeDouble, alias: FY21 Q4 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_62 )
GISADMIN_CIP_PROJECTS_SMARTS_63
( type: esriFieldTypeDouble, alias: Total Billable FY21 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_63 )
GISADMIN_CIP_PROJECTS_SMARTS_64
( type: esriFieldTypeDouble, alias: Total Actual Fy21 Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_64 )
GISADMIN_CIP_PROJECTS_SMARTS_65
( type: esriFieldTypeDouble, alias: Total Invoices, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_65 )
GISADMIN_CIP_PROJECTS_SMARTS_66
( type: esriFieldTypeString, alias: Budget Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_66 )
GISADMIN_CIP_PROJECTS_SMARTS_67
( type: esriFieldTypeDouble, alias: Billable vs Actual Chargebacks, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_67 )
GISADMIN_CIP_PROJECTS_SMARTS_68
( type: esriFieldTypeDouble, alias: Priority Order, editable: true, nullable: true, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_68 )
GISADMIN_CIP_PROJECTS_SMARTS_69
( type: esriFieldTypeString, alias: WSD Lead Representative, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_69 )
GISADMIN_CIP_PROJECTS_SMARTS_70
( type: esriFieldTypeString, alias: WSD Reviewer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_70 )
GISADMIN_CIP_PROJECTS_SMARTS_71
( type: esriFieldTypeString, alias: Latest Comment, editable: true, nullable: true, length: 360, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_71 )
GISADMIN_CIP_PROJECTS_SMARTS_72
( type: esriFieldTypeString, alias: Action Items, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GISADMIN_CIP_PROJECTS_SMARTS_72 )
Shape__Area
( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
Shape__Length
( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Templates:
Name: CIP_PROJECTS_SMARTSHEET_Pv2_dashboard
Description:
Prototype:
GISADMIN_CIP_PROJECTS_SMARTS_71:
null
GISADMIN_CIP_PROJECTS_SMARTS_72:
null
GISADMIN_CIP_PROJECTS_SMARTSHEE:
null
GISADMIN_CIP_PROJECTS_SMARTSH_1:
null
GISADMIN_CIP_PROJECTS_SMARTSH_2:
null
GISADMIN_CIP_PROJECTS_SMARTSH_3:
null
GISADMIN_CIP_PROJECTS_SMARTSH_4:
null
GISADMIN_CIP_PROJECTS_SMARTSH_5:
null
GISADMIN_CIP_PROJECTS_SMARTSH_6:
null
GISADMIN_CIP_PROJECTS_SMARTSH_7:
null
GISADMIN_CIP_PROJECTS_SMARTS_70:
null
GISADMIN_CIP_PROJECTS_SMARTSH_9:
null
GISADMIN_CIP_PROJECTS_SMARTS_10:
null
GISADMIN_CIP_PROJECTS_SMARTS_11:
null
GISADMIN_CIP_PROJECTS_SMARTS_12:
null
GISADMIN_CIP_PROJECTS_SMARTS_13:
null
GISADMIN_CIP_PROJECTS_SMARTS_14:
null
GISADMIN_CIP_PROJECTS_SMARTS_15:
null
GISADMIN_CIP_PROJECTS_SMARTS_16:
null
GISADMIN_CIP_PROJECTS_SMARTS_17:
null
GISADMIN_CIP_PROJECTS_SMARTS_18:
null
GISADMIN_CIP_PROJECTS_SMARTS_19:
null
GISADMIN_CIP_PROJECTS_SMARTS_20:
null
GISADMIN_CIP_PROJECTS_SMARTS_21:
null
GISADMIN_CIP_PROJECTS_SMARTS_22:
null
GISADMIN_CIP_PROJECTS_SMARTS_23:
null
GISADMIN_CIP_PROJECTS_SMARTS_24:
null
GISADMIN_CIP_PROJECTS_SMARTS_25:
null
GISADMIN_CIP_PROJECTS_SMARTS_26:
null
GISADMIN_CIP_PROJECTS_SMARTS_27:
null
GISADMIN_CIP_PROJECTS_SMARTS_28:
null
GISADMIN_CIP_PROJECTS_SMARTS_29:
null
GISADMIN_CIP_PROJECTS_SMARTS_30:
null
GISADMIN_CIP_PROJECTS_SMARTS_31:
null
GISADMIN_CIP_PROJECTS_SMARTS_32:
null
GISADMIN_CIP_PROJECTS_SMARTS_33:
null
GISADMIN_CIP_PROJECTS_SMARTS_34:
null
GISADMIN_CIP_PROJECTS_SMARTS_35:
null
GISADMIN_CIP_PROJECTS_SMARTS_36:
null
GISADMIN_CIP_PROJECTS_SMARTS_37:
null
GISADMIN_CIP_PROJECTS_SMARTS_38:
null
GISADMIN_CIP_PROJECTS_SMARTS_39:
null
GISADMIN_CIP_PROJECTS_SMARTS_40:
null
GISADMIN_CIP_PROJECTS_SMARTS_41:
null
GISADMIN_CIP_PROJECTS_SMARTS_42:
null
GISADMIN_CIP_PROJECTS_SMARTS_43:
null
GISADMIN_CIP_PROJECTS_SMARTS_44:
null
GISADMIN_CIP_PROJECTS_SMARTS_45:
null
GISADMIN_CIP_PROJECTS_SMARTS_46:
null
GISADMIN_CIP_PROJECTS_SMARTS_47:
null
GISADMIN_CIP_PROJECTS_SMARTS_48:
null
GISADMIN_CIP_PROJECTS_SMARTS_49:
null
GISADMIN_CIP_PROJECTS_SMARTS_50:
null
GISADMIN_CIP_PROJECTS_SMARTS_51:
null
GISADMIN_CIP_PROJECTS_SMARTS_52:
null
GISADMIN_CIP_PROJECTS_SMARTS_53:
null
GISADMIN_CIP_PROJECTS_SMARTS_54:
null
GISADMIN_CIP_PROJECTS_SMARTS_55:
null
GISADMIN_CIP_PROJECTS_SMARTS_56:
null
GISADMIN_CIP_PROJECTS_SMARTS_57:
null
GISADMIN_CIP_PROJECTS_SMARTS_58:
null
GISADMIN_CIP_PROJECTS_SMARTS_59:
null
GISADMIN_CIP_PROJECTS_SMARTS_60:
null
GISADMIN_CIP_PROJECTS_SMARTS_61:
null
GISADMIN_CIP_PROJECTS_SMARTS_62:
null
GISADMIN_CIP_PROJECTS_SMARTS_63:
null
GISADMIN_CIP_PROJECTS_SMARTS_64:
null
GISADMIN_CIP_PROJECTS_SMARTS_65:
null
GISADMIN_CIP_PROJECTS_SMARTS_66:
null
GISADMIN_CIP_PROJECTS_SMARTS_67:
null
GISADMIN_CIP_PROJECTS_SMARTS_68:
null
GISADMIN_CIP_PROJECTS_SMARTS_69:
null
Drawing Tool: esriFeatureEditToolPolygon
Layer:
CIP_PROJECTS_MUNIS_POLYS_for_Dashboard
(2)
Name:
CIP_PROJECTS_MUNIS_POLYS_for_Dashboard
Display Field:
Project__
Type:
Feature Layer
Geometry Type:
esriGeometryPolygon
Description:
Service Item Id:
7436baff872943a38690f25442460e43
Copyright Text:
Default Visibility: true
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Min Scale:
0.0
Max Scale:
0.0
Supports Advanced Queries:
true
Supports Statistics:
true
Can Scale Symbols:
false
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
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:
[0, 112, 255, 0]
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: true
Supports Returning Geometry Centroid: true
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:
esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Project__
( type: esriFieldTypeString, alias: Project__, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Project__ )
Munis_no
( type: esriFieldTypeString, alias: Munis_no, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Munis_no )
Fiscal_Year
( type: esriFieldTypeSmallInteger, alias: Fiscal_Year, editable: true, nullable: true, defaultValue: null, modelName: Fiscal_Year )
CITY_WIDE
( type: esriFieldTypeString, alias: CITY_WIDE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CITY_WIDE )
a_project
( type: esriFieldTypeString, alias: a_project, editable: true, nullable: true, length: 10, defaultValue: null, modelName: a_project )
ma_project_title
( type: esriFieldTypeString, alias: ma_project_title, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ma_project_title )
ma_description
( type: esriFieldTypeString, alias: ma_description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_description )
ma_justification
( type: esriFieldTypeString, alias: ma_justification, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_justification )
padt_pkg_no
( type: esriFieldTypeString, alias: padt_pkg_no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: padt_pkg_no )
padt_seg3
( type: esriFieldTypeString, alias: padt_seg3, editable: true, nullable: true, length: 10, defaultValue: null, modelName: padt_seg3 )
padt_year
( type: esriFieldTypeSmallInteger, alias: padt_year, editable: true, nullable: true, defaultValue: null, modelName: padt_year )
padt_unit_cost
( type: esriFieldTypeDouble, alias: padt_unit_cost, editable: true, nullable: true, defaultValue: null, modelName: padt_unit_cost )
LongDescription
( type: esriFieldTypeString, alias: LongDescription, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LongDescription )
OrgLongDescription
( type: esriFieldTypeString, alias: OrgLongDescription, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OrgLongDescription )
ObjLongDescription
( type: esriFieldTypeString, alias: ObjLongDescription, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ObjLongDescription )
SegmentOneDescription
( type: esriFieldTypeString, alias: SegmentOneDescription, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SegmentOneDescription )
SegmentTwoDescription
( type: esriFieldTypeString, alias: SegmentTwoDescription, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SegmentTwoDescription )
SegmentThreeDescription
( type: esriFieldTypeString, alias: SegmentThreeDescription, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SegmentThreeDescription )
ProjTypeDesc
( type: esriFieldTypeString, alias: ProjTypeDesc, editable: true, nullable: true, length: 22, defaultValue: null, modelName: ProjTypeDesc )
Shape__Area
( type: esriFieldTypeDouble, alias: Shape.STArea(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STArea(), required: true )
Shape__Length
( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
Templates:
Name: CIP_PROJECTS_MUNIS_POLYS_for_Dashboard
Description:
Prototype:
ProjTypeDesc:
null
Project__:
null
Munis_no:
null
Fiscal_Year:
null
CITY_WIDE:
null
a_project:
null
ma_project_title:
null
ma_description:
null
ma_justification:
null
padt_pkg_no:
null
padt_seg3:
null
padt_year:
null
padt_unit_cost:
null
LongDescription:
null
OrgLongDescription:
null
ObjLongDescription:
null
SegmentOneDescription:
null
SegmentTwoDescription:
null
SegmentThreeDescription:
null
Drawing Tool: esriFeatureEditToolPolygon
Tables:
Table:
CIP_PROJECTS_SMARTSHEET
(3)
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
Table:
CIP_PROJECTS_MUNIS
(4)
Name:
CIP_PROJECTS_MUNIS
Display Field:
a_project
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 )
a_project
( type: esriFieldTypeString, alias: a_project, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: a_project )
ma_project_type
( type: esriFieldTypeString, alias: ma_project_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_project_type )
ma_project_title
( type: esriFieldTypeString, alias: ma_project_title, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_project_title )
ma_major_project
( type: esriFieldTypeString, alias: ma_major_project, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_major_project )
ma_stateid_number
( type: esriFieldTypeString, alias: ma_stateid_number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_stateid_number )
ma_cfda_number
( type: esriFieldTypeString, alias: ma_cfda_number, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_cfda_number )
ma_proj_department
( type: esriFieldTypeInteger, alias: ma_proj_department, editable: true, nullable: true, defaultValue: null, modelName: ma_proj_department )
ma_proj_comment
( type: esriFieldTypeString, alias: ma_proj_comment, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_proj_comment )
ma_project_status
( type: esriFieldTypeString, alias: ma_project_status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_project_status )
ma_draw
( type: esriFieldTypeString, alias: ma_draw, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_draw )
ma_use_pa_gl
( type: esriFieldTypeString, alias: ma_use_pa_gl, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_use_pa_gl )
ma_carry_fwrd_cd
( type: esriFieldTypeInteger, alias: ma_carry_fwrd_cd, editable: true, nullable: true, defaultValue: null, modelName: ma_carry_fwrd_cd )
ma_fa_flag
( type: esriFieldTypeString, alias: ma_fa_flag, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_fa_flag )
ma_start_year
( type: esriFieldTypeInteger, alias: ma_start_year, editable: true, nullable: true, defaultValue: null, modelName: ma_start_year )
ma_start_period
( type: esriFieldTypeInteger, alias: ma_start_period, editable: true, nullable: true, defaultValue: null, modelName: ma_start_period )
ma_start_month
( type: esriFieldTypeInteger, alias: ma_start_month, editable: true, nullable: true, defaultValue: null, modelName: ma_start_month )
ma_start_day
( type: esriFieldTypeInteger, alias: ma_start_day, editable: true, nullable: true, defaultValue: null, modelName: ma_start_day )
ma_end_month
( type: esriFieldTypeInteger, alias: ma_end_month, editable: true, nullable: true, defaultValue: null, modelName: ma_end_month )
ma_end_day
( type: esriFieldTypeInteger, alias: ma_end_day, editable: true, nullable: true, defaultValue: null, modelName: ma_end_day )
ma_projected_sdate
( type: esriFieldTypeString, alias: ma_projected_sdate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_projected_sdate )
ma_projected_edate
( type: esriFieldTypeString, alias: ma_projected_edate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_projected_edate )
ma_orig_days
( type: esriFieldTypeInteger, alias: ma_orig_days, editable: true, nullable: true, defaultValue: null, modelName: ma_orig_days )
ma_revised_days
( type: esriFieldTypeInteger, alias: ma_revised_days, editable: true, nullable: true, defaultValue: null, modelName: ma_revised_days )
ma_expense_req_lvl
( type: esriFieldTypeInteger, alias: ma_expense_req_lvl, editable: true, nullable: true, defaultValue: null, modelName: ma_expense_req_lvl )
ma_funding_req_lvl
( type: esriFieldTypeInteger, alias: ma_funding_req_lvl, editable: true, nullable: true, defaultValue: null, modelName: ma_funding_req_lvl )
ma_expense_bud_lvl
( type: esriFieldTypeInteger, alias: ma_expense_bud_lvl, editable: true, nullable: true, defaultValue: null, modelName: ma_expense_bud_lvl )
ma_funding_bud_lvl
( type: esriFieldTypeInteger, alias: ma_funding_bud_lvl, editable: true, nullable: true, defaultValue: null, modelName: ma_funding_bud_lvl )
ma_admin_ovr_rt
( type: esriFieldTypeDouble, alias: ma_admin_ovr_rt, editable: true, nullable: true, defaultValue: null, modelName: ma_admin_ovr_rt )
ma_actual_ovr_rt
( type: esriFieldTypeDouble, alias: ma_actual_ovr_rt, editable: true, nullable: true, defaultValue: null, modelName: ma_actual_ovr_rt )
ma_pct_comp
( type: esriFieldTypeInteger, alias: ma_pct_comp, editable: true, nullable: true, defaultValue: null, modelName: ma_pct_comp )
ma_description
( type: esriFieldTypeString, alias: ma_description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_description )
ma_justification
( type: esriFieldTypeString, alias: ma_justification, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_justification )
ma_workflow_status
( type: esriFieldTypeString, alias: ma_workflow_status, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_workflow_status )
ma_est_to_comp
( type: esriFieldTypeDouble, alias: ma_est_to_comp, editable: true, nullable: true, defaultValue: null, modelName: ma_est_to_comp )
padt_pkg_no
( type: esriFieldTypeString, alias: padt_pkg_no, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_pkg_no )
padt_seg1
( type: esriFieldTypeString, alias: padt_seg1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_seg1 )
padt_seg2
( type: esriFieldTypeInteger, alias: padt_seg2, editable: true, nullable: true, defaultValue: null, modelName: padt_seg2 )
padt_seg3
( type: esriFieldTypeString, alias: padt_seg3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_seg3 )
padt_seg4
( type: esriFieldTypeString, alias: padt_seg4, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_seg4 )
padt_type
( type: esriFieldTypeString, alias: padt_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_type )
padt_seq
( type: esriFieldTypeInteger, alias: padt_seq, editable: true, nullable: true, defaultValue: null, modelName: padt_seq )
padt_year
( type: esriFieldTypeInteger, alias: padt_year, editable: true, nullable: true, defaultValue: null, modelName: padt_year )
padt_qty
( type: esriFieldTypeDouble, alias: padt_qty, editable: true, nullable: true, defaultValue: null, modelName: padt_qty )
padt_unit_cost
( type: esriFieldTypeDouble, alias: padt_unit_cost, editable: true, nullable: true, defaultValue: null, modelName: padt_unit_cost )
padt_desc1
( type: esriFieldTypeString, alias: padt_desc1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_desc1 )
padt_desc2
( type: esriFieldTypeString, alias: padt_desc2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_desc2 )
padt_gl_org
( type: esriFieldTypeInteger, alias: padt_gl_org, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_org )
padt_gl_obj
( type: esriFieldTypeInteger, alias: padt_gl_obj, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_obj )
padt_gl_proj
( type: esriFieldTypeString, alias: padt_gl_proj, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: padt_gl_proj )
padt_gl_seg1
( type: esriFieldTypeInteger, alias: padt_gl_seg1, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_seg1 )
padt_gl_seg2
( type: esriFieldTypeInteger, alias: padt_gl_seg2, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_seg2 )
padt_gl_seg3
( type: esriFieldTypeInteger, alias: padt_gl_seg3, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_seg3 )
padt_gl_seg4
( type: esriFieldTypeInteger, alias: padt_gl_seg4, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_seg4 )
padt_gl_seg5
( type: esriFieldTypeInteger, alias: padt_gl_seg5, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_seg5 )
padt_gl_seg6
( type: esriFieldTypeInteger, alias: padt_gl_seg6, editable: true, nullable: true, defaultValue: null, modelName: padt_gl_seg6 )
AccountId
( type: esriFieldTypeInteger, alias: AccountId, editable: true, nullable: true, defaultValue: null, modelName: AccountId )
LongDescription
( type: esriFieldTypeString, alias: LongDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LongDescription )
ShortDescription
( type: esriFieldTypeString, alias: ShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ShortDescription )
OrganizationCode
( type: esriFieldTypeInteger, alias: OrganizationCode, editable: true, nullable: true, defaultValue: null, modelName: OrganizationCode )
OrgLongDescription
( type: esriFieldTypeString, alias: OrgLongDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OrgLongDescription )
OrgShortDescription
( type: esriFieldTypeString, alias: OrgShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OrgShortDescription )
ObjectCode
( type: esriFieldTypeInteger, alias: ObjectCode, editable: true, nullable: true, defaultValue: null, modelName: ObjectCode )
ObjLongDescription
( type: esriFieldTypeString, alias: ObjLongDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ObjLongDescription )
ObjShortDescription
( type: esriFieldTypeString, alias: ObjShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ObjShortDescription )
ProjectCode
( type: esriFieldTypeString, alias: ProjectCode, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProjectCode )
ProjectTitle
( type: esriFieldTypeString, alias: ProjectTitle, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProjectTitle )
SegmentOne
( type: esriFieldTypeInteger, alias: SegmentOne, editable: true, nullable: true, defaultValue: null, modelName: SegmentOne )
SegmentOneDescription
( type: esriFieldTypeString, alias: SegmentOneDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentOneDescription )
SegmentOneShortDescription
( type: esriFieldTypeString, alias: SegmentOneShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentOneShortDescription )
SegmentTwo
( type: esriFieldTypeInteger, alias: SegmentTwo, editable: true, nullable: true, defaultValue: null, modelName: SegmentTwo )
SegmentTwoDescription
( type: esriFieldTypeString, alias: SegmentTwoDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentTwoDescription )
SegmentTwoShortDescription
( type: esriFieldTypeString, alias: SegmentTwoShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentTwoShortDescription )
SegmentThree
( type: esriFieldTypeInteger, alias: SegmentThree, editable: true, nullable: true, defaultValue: null, modelName: SegmentThree )
SegmentThreeDescription
( type: esriFieldTypeString, alias: SegmentThreeDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentThreeDescription )
SegmentThreeShortDescription
( type: esriFieldTypeString, alias: SegmentThreeShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentThreeShortDescription )
SegmentFour
( type: esriFieldTypeInteger, alias: SegmentFour, editable: true, nullable: true, defaultValue: null, modelName: SegmentFour )
SegmentFourDescription
( type: esriFieldTypeString, alias: SegmentFourDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentFourDescription )
SegmentFourShortDescription
( type: esriFieldTypeString, alias: SegmentFourShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentFourShortDescription )
SegmentFive
( type: esriFieldTypeInteger, alias: SegmentFive, editable: true, nullable: true, defaultValue: null, modelName: SegmentFive )
SegmentFiveDescription
( type: esriFieldTypeString, alias: SegmentFiveDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentFiveDescription )
SegmentFiveShortDescription
( type: esriFieldTypeString, alias: SegmentFiveShortDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SegmentFiveShortDescription )
ProjType
( type: esriFieldTypeString, alias: ProjType, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProjType )
ProjTypeDesc
( type: esriFieldTypeString, alias: ProjTypeDesc, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ProjTypeDesc )
Templates:
Name: CIP_PROJECTS_MUNIS
Description:
Prototype:
ProjType:
null
ProjTypeDesc:
null
a_project:
null
ma_project_type:
null
ma_project_title:
null
ma_major_project:
null
ma_stateid_number:
null
ma_cfda_number:
null
ma_proj_department:
null
ma_proj_comment:
null
ma_project_status:
null
ma_draw:
null
ma_use_pa_gl:
null
ma_carry_fwrd_cd:
null
ma_fa_flag:
null
ma_start_year:
null
ma_start_period:
null
ma_start_month:
null
ma_start_day:
null
ma_end_month:
null
ma_end_day:
null
ma_projected_sdate:
null
ma_projected_edate:
null
ma_orig_days:
null
ma_revised_days:
null
ma_expense_req_lvl:
null
ma_funding_req_lvl:
null
ma_expense_bud_lvl:
null
ma_funding_bud_lvl:
null
ma_admin_ovr_rt:
null
ma_actual_ovr_rt:
null
ma_pct_comp:
null
ma_description:
null
ma_justification:
null
ma_workflow_status:
null
ma_est_to_comp:
null
padt_pkg_no:
null
padt_seg1:
null
padt_seg2:
null
padt_seg3:
null
padt_seg4:
null
padt_type:
null
padt_seq:
null
padt_year:
null
padt_qty:
null
padt_unit_cost:
null
padt_desc1:
null
padt_desc2:
null
padt_gl_org:
null
padt_gl_obj:
null
padt_gl_proj:
null
padt_gl_seg1:
null
padt_gl_seg2:
null
padt_gl_seg3:
null
padt_gl_seg4:
null
padt_gl_seg5:
null
padt_gl_seg6:
null
AccountId:
null
LongDescription:
null
ShortDescription:
null
OrganizationCode:
null
OrgLongDescription:
null
OrgShortDescription:
null
ObjectCode:
null
ObjLongDescription:
null
ObjShortDescription:
null
ProjectCode:
null
ProjectTitle:
null
SegmentOne:
null
SegmentOneDescription:
null
SegmentOneShortDescription:
null
SegmentTwo:
null
SegmentTwoDescription:
null
SegmentTwoShortDescription:
null
SegmentThree:
null
SegmentThreeDescription:
null
SegmentThreeShortDescription:
null
SegmentFour:
null
SegmentFourDescription:
null
SegmentFourShortDescription:
null
SegmentFive:
null
SegmentFiveDescription:
null
SegmentFiveShortDescription:
null
Drawing Tool: esriFeatureEditToolNone
Table:
CIP_PROJECTS_MUNIS_NOT_IN_SMARTSHEET
(5)
Name:
CIP_PROJECTS_MUNIS_NOT_IN_SMARTSHEET
Display Field:
a_project
Type:
Table
Geometry Type:
N/A
Description:
CIP_PROJECTS_MUNIS_NOT_IN_SMARTSHEET
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:
false
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:
a_project
( type: esriFieldTypeString, alias: a_project, editable: true, nullable: true, length: 10, defaultValue: null, modelName: a_project )
ma_project_title
( type: esriFieldTypeString, alias: ma_project_title, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ma_project_title )
ma_description
( type: esriFieldTypeString, alias: ma_description, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ma_description )
ESRI_OID
( type: esriFieldTypeOID, alias: ESRI_OID, editable: false, nullable: false, defaultValue: null, modelName: ESRI_OID )
Templates:
Name: CIP_PROJECTS_MUNIS_NOT_IN_SMARTSHEET
Description:
Prototype:
ma_project_title:
null
a_project:
null
ma_description:
null
Drawing Tool: esriFeatureEditToolNone