ArcGIS REST Services Directory
Login
Home
>
services
>
Planning
>
CIP_PROJECTS_SMARTSHEET_Pv2 (MapServer)
>
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:
36d2fc39d3ad4891bf98f91930a2ee25
Copyright Text:
Default Visibility: false
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.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: 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 )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Project__
( type: esriFieldTypeString, alias: Project__, length: 255 )
Munis_no
( type: esriFieldTypeString, alias: Munis_no, length: 255 )
Fiscal_Year
( type: esriFieldTypeSmallInteger, alias: Fiscal_Year )
CITY_WIDE
( type: esriFieldTypeString, alias: CITY_WIDE, length: 255 ,
Coded Values:
[Y: Yes] , [N: No] )
Shape.STArea()
( type: esriFieldTypeDouble, alias: Shape.STArea() )
Shape.STLength()
( type: esriFieldTypeDouble, alias: Shape.STLength() )
created_user
( type: esriFieldTypeString, alias: created_user, length: 255 )
created_date
( type: esriFieldTypeDate, alias: created_date, length: 8 )
last_edited_user
( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
last_edited_date
( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
GlobalID
( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
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:
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() )
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:
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:
[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: 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 )
Project__
( type: esriFieldTypeString, alias: Project__, length: 255 )
Munis_no
( type: esriFieldTypeString, alias: Munis_no, length: 255 )
Fiscal_Year
( type: esriFieldTypeSmallInteger, alias: Fiscal_Year )
CITY_WIDE
( type: esriFieldTypeString, alias: CITY_WIDE, length: 255 )
a_project
( type: esriFieldTypeString, alias: a_project, length: 10 )
ma_project_title
( type: esriFieldTypeString, alias: ma_project_title, length: 35 )
ma_description
( type: esriFieldTypeString, alias: ma_description, length: 1073741822 )
ma_justification
( type: esriFieldTypeString, alias: ma_justification, length: 1073741822 )
padt_pkg_no
( type: esriFieldTypeString, alias: padt_pkg_no, length: 10 )
padt_seg3
( type: esriFieldTypeString, alias: padt_seg3, length: 10 )
padt_year
( type: esriFieldTypeSmallInteger, alias: padt_year )
padt_unit_cost
( type: esriFieldTypeDouble, alias: padt_unit_cost )
LongDescription
( type: esriFieldTypeString, alias: LongDescription, length: 30 )
OrgLongDescription
( type: esriFieldTypeString, alias: OrgLongDescription, length: 30 )
ObjLongDescription
( type: esriFieldTypeString, alias: ObjLongDescription, length: 30 )
SegmentOneDescription
( type: esriFieldTypeString, alias: SegmentOneDescription, length: 30 )
SegmentTwoDescription
( type: esriFieldTypeString, alias: SegmentTwoDescription, length: 30 )
SegmentThreeDescription
( type: esriFieldTypeString, alias: SegmentThreeDescription, length: 30 )
ProjTypeDesc
( type: esriFieldTypeString, alias: ProjTypeDesc, length: 22 )
Shape
( type: esriFieldTypeGeometry, alias: Shape )
Shape.STArea()
( type: esriFieldTypeDouble, alias: Shape.STArea() )
Shape.STLength()
( type: esriFieldTypeDouble, alias: Shape.STLength() )
Tables:
Table:
CIP_PROJECTS_SMARTSHEET
(3)
Name:
CIP_PROJECTS_SMARTSHEET
Display Field:
Project_Name
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
36d2fc39d3ad4891bf98f91930a2ee25
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
F_
( type: esriFieldTypeString, alias: $, length: 255 )
Time
( type: esriFieldTypeString, alias: Time, length: 255 )
Other
( type: esriFieldTypeSmallInteger, alias: Other )
Charter
( type: esriFieldTypeSmallInteger, alias: Charter )
Project__
( type: esriFieldTypeString, alias: Project #, length: 255 )
Munis__
( type: esriFieldTypeString, alias: Munis #, length: 255 )
Project_Name
( type: esriFieldTypeString, alias: Project Name, length: 255 )
D_PM
( type: esriFieldTypeString, alias: D-PM, length: 255 )
C_PM
( type: esriFieldTypeString, alias: C-PM, length: 255 )
Project_Budget
( type: esriFieldTypeString, alias: Project Budget, length: 255 )
Project_Cost
( type: esriFieldTypeDouble, alias: Project Cost )
Prior_Years_Actuals
( type: esriFieldTypeString, alias: Prior Years Actuals, length: 255 )
FY19_20_Actuals
( type: esriFieldTypeDouble, alias: FY19-20 Actuals )
FY21_Actuals
( type: esriFieldTypeDouble, alias: FY21 Actuals )
FY22_Actuals
( type: esriFieldTypeDouble, alias: FY22 Actuals )
Est__Substantial_Date
( type: esriFieldTypeString, alias: Est. Substantial Date, length: 255 )
Final_Date
( type: esriFieldTypeDate, alias: Final Date, length: 8 )
Procurement
( type: esriFieldTypeString, alias: Procurement, length: 255 )
Department
( type: esriFieldTypeString, alias: Department, length: 255 )
Council_Date
( type: esriFieldTypeString, alias: Council Date, length: 255 )
Status
( type: esriFieldTypeString, alias: Status, length: 255 )
Act__Design_Completion_date
( type: esriFieldTypeString, alias: Act. Design Completion date, length: 255 )
Act__Substantial_Date
( type: esriFieldTypeDate, alias: Act. Substantial Date, length: 8 )
Fac_
( type: esriFieldTypeSmallInteger, alias: Fac. )
W_S
( type: esriFieldTypeSmallInteger, alias: W/S )
Street
( type: esriFieldTypeSmallInteger, alias: Street )
HAS_PIO
( type: esriFieldTypeSmallInteger, alias: HAS PIO )
Active_Project
( type: esriFieldTypeString, alias: Active Project, length: 255 )
Fy2021_Q1_Spend
( type: esriFieldTypeDouble, alias: Fy2021 Q1 Spend )
FY2021_Q1_Chargebacks
( type: esriFieldTypeDouble, alias: FY2021 Q1 Chargebacks )
Fy2021_Q2_Spend
( type: esriFieldTypeDouble, alias: Fy2021 Q2 Spend )
FY2021_Q2_Chargebacks
( type: esriFieldTypeDouble, alias: FY2021 Q2 Chargebacks )
FY2021_Q3_Spend
( type: esriFieldTypeDouble, alias: FY2021 Q3 Spend )
Fy2021_Q3_Chargebacks
( type: esriFieldTypeDouble, alias: Fy2021 Q3 Chargebacks )
Fy2021_Q4_Spend
( type: esriFieldTypeDouble, alias: Fy2021 Q4 Spend )
FY21_Q4_Chargebacks
( type: esriFieldTypeDouble, alias: FY21 Q4 Chargebacks )
Total_Billable_FY21_Chargebacks
( type: esriFieldTypeDouble, alias: Total Billable FY21 Chargebacks )
Total_Actual_Fy21_Chargebacks
( type: esriFieldTypeDouble, alias: Total Actual Fy21 Chargebacks )
FY22_Q1_Chargebacks
( type: esriFieldTypeDouble, alias: FY22 Q1 Chargebacks )
FY22_Q1_Spend
( type: esriFieldTypeDouble, alias: FY22 Q1 Spend )
FY22_Total_Chargebacks
( type: esriFieldTypeDouble, alias: Fy22 Total Chargebacks )
Total_Invoices
( type: esriFieldTypeDouble, alias: Total Invoices )
Budget_Status
( type: esriFieldTypeString, alias: Budget Status, length: 255 )
Billable_vs_Actual_Chargebacks
( type: esriFieldTypeDouble, alias: Billable vs Actual Chargebacks )
Address_Start
( type: esriFieldTypeString, alias: Address Start, length: 255 )
Address_End
( type: esriFieldTypeString, alias: Address End, length: 255 )
Citywide__Yes_No_
( type: esriFieldTypeString, alias: Citywide (Yes/No), length: 255 )
FY23_Actuals
( type: esriFieldTypeDouble, alias: FY23 Actuals )
Est__Charter_Design_Completion_
( type: esriFieldTypeDate, alias: Est. Charter Design Completion Date, length: 8 )
Actual_Design_Start_Date__Kicko
( type: esriFieldTypeString, alias: Actual Design Start Date (Kickoff Date), length: 255 )
Contract_Design_Completion_Date
( type: esriFieldTypeDate, alias: Contract Design Completion Date, length: 8 )
Actual_Construction_Start_Date_
( type: esriFieldTypeString, alias: Actual Construction Start Date (NTP Date), length: 255 )
FY22_Q2_Spend
( type: esriFieldTypeDouble, alias: FY22 Q2 Spend )
FY22Q2_Chargebacks
( type: esriFieldTypeDouble, alias: FY22Q2 Chargebacks )
FY22_Q3_Spend
( type: esriFieldTypeDouble, alias: FY22 Q3 Spend )
FY22_Q3_Chargeback
( type: esriFieldTypeDouble, alias: FY22 Q3 Chargeback )
FY22_Q4_Spend
( type: esriFieldTypeDouble, alias: FY22 Q4 Spend )
FY22_Q4_Chargeback
( type: esriFieldTypeString, alias: FY22 Q4 Chargeback, length: 255 )
Priority_Order
( type: esriFieldTypeDouble, alias: Priority Order )
WSD_Lead_Representative
( type: esriFieldTypeString, alias: WSD Lead Representative, length: 255 )
WSD_Reviewer
( type: esriFieldTypeString, alias: WSD Reviewer, length: 255 )
Latest_Comment
( type: esriFieldTypeString, alias: Latest Comment, length: 360 )
Action_Items
( type: esriFieldTypeString, alias: Action Items, length: 255 )
Table:
CIP_PROJECTS_MUNIS
(4)
Name:
CIP_PROJECTS_MUNIS
Display Field:
a_project
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
36d2fc39d3ad4891bf98f91930a2ee25
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
a_project
( type: esriFieldTypeString, alias: a_project, length: 1073741822 )
ma_project_type
( type: esriFieldTypeString, alias: ma_project_type, length: 1073741822 )
ma_project_title
( type: esriFieldTypeString, alias: ma_project_title, length: 1073741822 )
ma_major_project
( type: esriFieldTypeString, alias: ma_major_project, length: 1073741822 )
ma_stateid_number
( type: esriFieldTypeString, alias: ma_stateid_number, length: 1073741822 )
ma_cfda_number
( type: esriFieldTypeString, alias: ma_cfda_number, length: 1073741822 )
ma_proj_department
( type: esriFieldTypeInteger, alias: ma_proj_department )
ma_proj_comment
( type: esriFieldTypeString, alias: ma_proj_comment, length: 1073741822 )
ma_project_status
( type: esriFieldTypeString, alias: ma_project_status, length: 1073741822 )
ma_draw
( type: esriFieldTypeString, alias: ma_draw, length: 1073741822 )
ma_use_pa_gl
( type: esriFieldTypeString, alias: ma_use_pa_gl, length: 1073741822 )
ma_carry_fwrd_cd
( type: esriFieldTypeInteger, alias: ma_carry_fwrd_cd )
ma_fa_flag
( type: esriFieldTypeString, alias: ma_fa_flag, length: 1073741822 )
ma_start_year
( type: esriFieldTypeInteger, alias: ma_start_year )
ma_start_period
( type: esriFieldTypeInteger, alias: ma_start_period )
ma_start_month
( type: esriFieldTypeInteger, alias: ma_start_month )
ma_start_day
( type: esriFieldTypeInteger, alias: ma_start_day )
ma_end_month
( type: esriFieldTypeInteger, alias: ma_end_month )
ma_end_day
( type: esriFieldTypeInteger, alias: ma_end_day )
ma_projected_sdate
( type: esriFieldTypeString, alias: ma_projected_sdate, length: 1073741822 )
ma_projected_edate
( type: esriFieldTypeString, alias: ma_projected_edate, length: 1073741822 )
ma_orig_days
( type: esriFieldTypeInteger, alias: ma_orig_days )
ma_revised_days
( type: esriFieldTypeInteger, alias: ma_revised_days )
ma_expense_req_lvl
( type: esriFieldTypeInteger, alias: ma_expense_req_lvl )
ma_funding_req_lvl
( type: esriFieldTypeInteger, alias: ma_funding_req_lvl )
ma_expense_bud_lvl
( type: esriFieldTypeInteger, alias: ma_expense_bud_lvl )
ma_funding_bud_lvl
( type: esriFieldTypeInteger, alias: ma_funding_bud_lvl )
ma_admin_ovr_rt
( type: esriFieldTypeDouble, alias: ma_admin_ovr_rt )
ma_actual_ovr_rt
( type: esriFieldTypeDouble, alias: ma_actual_ovr_rt )
ma_pct_comp
( type: esriFieldTypeInteger, alias: ma_pct_comp )
ma_description
( type: esriFieldTypeString, alias: ma_description, length: 1073741822 )
ma_justification
( type: esriFieldTypeString, alias: ma_justification, length: 1073741822 )
ma_workflow_status
( type: esriFieldTypeString, alias: ma_workflow_status, length: 1073741822 )
ma_est_to_comp
( type: esriFieldTypeDouble, alias: ma_est_to_comp )
padt_pkg_no
( type: esriFieldTypeString, alias: padt_pkg_no, length: 1073741822 )
padt_seg1
( type: esriFieldTypeString, alias: padt_seg1, length: 1073741822 )
padt_seg2
( type: esriFieldTypeInteger, alias: padt_seg2 )
padt_seg3
( type: esriFieldTypeString, alias: padt_seg3, length: 1073741822 )
padt_seg4
( type: esriFieldTypeString, alias: padt_seg4, length: 1073741822 )
padt_type
( type: esriFieldTypeString, alias: padt_type, length: 1073741822 )
padt_seq
( type: esriFieldTypeInteger, alias: padt_seq )
padt_year
( type: esriFieldTypeInteger, alias: padt_year )
padt_qty
( type: esriFieldTypeDouble, alias: padt_qty )
padt_unit_cost
( type: esriFieldTypeDouble, alias: padt_unit_cost )
padt_desc1
( type: esriFieldTypeString, alias: padt_desc1, length: 1073741822 )
padt_desc2
( type: esriFieldTypeString, alias: padt_desc2, length: 1073741822 )
padt_gl_org
( type: esriFieldTypeInteger, alias: padt_gl_org )
padt_gl_obj
( type: esriFieldTypeInteger, alias: padt_gl_obj )
padt_gl_proj
( type: esriFieldTypeString, alias: padt_gl_proj, length: 1073741822 )
padt_gl_seg1
( type: esriFieldTypeInteger, alias: padt_gl_seg1 )
padt_gl_seg2
( type: esriFieldTypeInteger, alias: padt_gl_seg2 )
padt_gl_seg3
( type: esriFieldTypeInteger, alias: padt_gl_seg3 )
padt_gl_seg4
( type: esriFieldTypeInteger, alias: padt_gl_seg4 )
padt_gl_seg5
( type: esriFieldTypeInteger, alias: padt_gl_seg5 )
padt_gl_seg6
( type: esriFieldTypeInteger, alias: padt_gl_seg6 )
AccountId
( type: esriFieldTypeInteger, alias: AccountId )
LongDescription
( type: esriFieldTypeString, alias: LongDescription, length: 1073741822 )
ShortDescription
( type: esriFieldTypeString, alias: ShortDescription, length: 1073741822 )
OrganizationCode
( type: esriFieldTypeInteger, alias: OrganizationCode )
OrgLongDescription
( type: esriFieldTypeString, alias: OrgLongDescription, length: 1073741822 )
OrgShortDescription
( type: esriFieldTypeString, alias: OrgShortDescription, length: 1073741822 )
ObjectCode
( type: esriFieldTypeInteger, alias: ObjectCode )
ObjLongDescription
( type: esriFieldTypeString, alias: ObjLongDescription, length: 1073741822 )
ObjShortDescription
( type: esriFieldTypeString, alias: ObjShortDescription, length: 1073741822 )
ProjectCode
( type: esriFieldTypeString, alias: ProjectCode, length: 1073741822 )
ProjectTitle
( type: esriFieldTypeString, alias: ProjectTitle, length: 1073741822 )
SegmentOne
( type: esriFieldTypeInteger, alias: SegmentOne )
SegmentOneDescription
( type: esriFieldTypeString, alias: SegmentOneDescription, length: 1073741822 )
SegmentOneShortDescription
( type: esriFieldTypeString, alias: SegmentOneShortDescription, length: 1073741822 )
SegmentTwo
( type: esriFieldTypeInteger, alias: SegmentTwo )
SegmentTwoDescription
( type: esriFieldTypeString, alias: SegmentTwoDescription, length: 1073741822 )
SegmentTwoShortDescription
( type: esriFieldTypeString, alias: SegmentTwoShortDescription, length: 1073741822 )
SegmentThree
( type: esriFieldTypeInteger, alias: SegmentThree )
SegmentThreeDescription
( type: esriFieldTypeString, alias: SegmentThreeDescription, length: 1073741822 )
SegmentThreeShortDescription
( type: esriFieldTypeString, alias: SegmentThreeShortDescription, length: 1073741822 )
SegmentFour
( type: esriFieldTypeInteger, alias: SegmentFour )
SegmentFourDescription
( type: esriFieldTypeString, alias: SegmentFourDescription, length: 1073741822 )
SegmentFourShortDescription
( type: esriFieldTypeString, alias: SegmentFourShortDescription, length: 1073741822 )
SegmentFive
( type: esriFieldTypeInteger, alias: SegmentFive )
SegmentFiveDescription
( type: esriFieldTypeString, alias: SegmentFiveDescription, length: 1073741822 )
SegmentFiveShortDescription
( type: esriFieldTypeString, alias: SegmentFiveShortDescription, length: 1073741822 )
ProjType
( type: esriFieldTypeString, alias: ProjType, length: 1073741822 )
ProjTypeDesc
( type: esriFieldTypeString, alias: ProjTypeDesc, length: 1073741822 )
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:
36d2fc39d3ad4891bf98f91930a2ee25
Copyright Text:
N/A
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Unique Id Infos:
Type: simple
Fields: ["ma_description"]
OID Field Contains Hash Value: true
Extent:
Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
a_project
( type: esriFieldTypeString, alias: a_project, length: 10 )
ma_project_title
( type: esriFieldTypeString, alias: ma_project_title, length: 35 )
ma_description
( type: esriFieldTypeString, alias: ma_description, length: 1073741822 )
ESRI_OID
( type: esriFieldTypeOID, alias: ESRI_OID )