{
"layers": [
{
"currentVersion": 11.4,
"cimVersion": "3.4.0",
"id": 0,
"name": "CIP Projects",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 2223,
"latestWkid": 2223,
"xyTolerance": 0.0032808398950131233,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -17746700,
"falseY": -44067300,
"xyUnits": 3048,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
196,
252,
212,
0
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
255,
0,
0,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -112.53707500232605,
"ymin": 33.50479588347223,
"xmax": -112.1510030173766,
"ymax": 33.764552819559384,
"spatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 9.999999999999999E8,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "Project__",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
},
{
"name": "Project__",
"type": "esriFieldTypeString",
"alias": "Project__",
"length": 255,
"domain": null
},
{
"name": "Munis_no",
"type": "esriFieldTypeString",
"alias": "Munis_no",
"length": 255,
"domain": null
},
{
"name": "Fiscal_Year",
"type": "esriFieldTypeSmallInteger",
"alias": "Fiscal_Year",
"domain": null
},
{
"name": "CITY_WIDE",
"type": "esriFieldTypeString",
"alias": "CITY_WIDE",
"length": 255,
"domain": {
"type": "codedValue",
"name": "Yes_No",
"description": "Has a value of Yes or No",
"codedValues": [
{
"name": "Yes",
"code": "Y"
},
{
"name": "No",
"code": "N"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
}
},
{
"name": "Shape.STArea()",
"type": "esriFieldTypeDouble",
"alias": "Shape.STArea()",
"domain": null
},
{
"name": "Shape.STLength()",
"type": "esriFieldTypeDouble",
"alias": "Shape.STLength()",
"domain": null
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255,
"domain": null
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8,
"domain": null
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255,
"domain": null
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8,
"domain": null
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "R3117_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_3117",
"fields": "GlobalID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S2117_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"maxSelectionCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"preferredTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"datesInUnknownTimezone": false,
"hasGeometryProperties": true,
"geometryProperties": {
"shapeAreaFieldName": "Shape.STArea()",
"shapeLengthFieldName": "Shape.STLength()",
"units": "esriFeet",
"mapUnits": {"uwkid": 9002}
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true,
"serviceItemId": "36d2fc39d3ad4891bf98f91930a2ee25"
},
{
"currentVersion": 11.4,
"cimVersion": "3.4.0",
"id": 1,
"name": "CIP_PROJECTS_SMARTSHEET_Pv2_dashboard",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 2223,
"latestWkid": 2223,
"xyTolerance": 0.0032808398950131233,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -17746700,
"falseY": -44067300,
"xyUnits": 3048,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
209,
207,
252,
255
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
110,
110,
110,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": -112.43991822125072,
"ymin": 33.50524102819698,
"xmax": -112.1510030173766,
"ymax": 33.7407557217596,
"spatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 9.999999999999999E8,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "GISADMIN_CIP_PROJECTS_SMARTSHEE",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSHEE",
"type": "esriFieldTypeString",
"alias": "Project__",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_1",
"type": "esriFieldTypeString",
"alias": "Munis_no",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_2",
"type": "esriFieldTypeSmallInteger",
"alias": "Fiscal_Year",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_3",
"type": "esriFieldTypeString",
"alias": "CITY_WIDE",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_4",
"type": "esriFieldTypeString",
"alias": "created_user",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_5",
"type": "esriFieldTypeDate",
"alias": "created_date",
"length": 8,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_6",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_7",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"length": 8,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_8",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"length": 38,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTSH_9",
"type": "esriFieldTypeInteger",
"alias": "OBJECTID",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_10",
"type": "esriFieldTypeString",
"alias": "$",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_11",
"type": "esriFieldTypeString",
"alias": "Time",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_12",
"type": "esriFieldTypeSmallInteger",
"alias": "Other",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_13",
"type": "esriFieldTypeSmallInteger",
"alias": "Charter",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_14",
"type": "esriFieldTypeString",
"alias": "Project #",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_15",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_16",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_17",
"type": "esriFieldTypeString",
"alias": "Address Start",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_18",
"type": "esriFieldTypeString",
"alias": "Address End",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_19",
"type": "esriFieldTypeString",
"alias": "Citywide (Yes/No)",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_20",
"type": "esriFieldTypeString",
"alias": "Munis #",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_21",
"type": "esriFieldTypeString",
"alias": "D-PM",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_22",
"type": "esriFieldTypeString",
"alias": "C-PM",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_23",
"type": "esriFieldTypeString",
"alias": "Project Budget",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_24",
"type": "esriFieldTypeDouble",
"alias": "Project Cost",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_25",
"type": "esriFieldTypeDouble",
"alias": "FY23 Actuals",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_26",
"type": "esriFieldTypeDouble",
"alias": "FY22 Actuals",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_27",
"type": "esriFieldTypeDate",
"alias": "Est. Charter Design Completion Date",
"length": 8,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_28",
"type": "esriFieldTypeString",
"alias": "Actual Design Start Date (Kickoff Date)",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_29",
"type": "esriFieldTypeDate",
"alias": "Contract Design Completion Date",
"length": 8,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_30",
"type": "esriFieldTypeString",
"alias": "Act. Design Completion date",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_31",
"type": "esriFieldTypeString",
"alias": "Est. Substantial Date",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_32",
"type": "esriFieldTypeString",
"alias": "Actual Construction Start Date (NTP Date)",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_33",
"type": "esriFieldTypeDate",
"alias": "Act. Substantial Date",
"length": 8,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_34",
"type": "esriFieldTypeDate",
"alias": "Final Date",
"length": 8,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_35",
"type": "esriFieldTypeString",
"alias": "Procurement",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_36",
"type": "esriFieldTypeString",
"alias": "Department",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_37",
"type": "esriFieldTypeString",
"alias": "Council Date",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_38",
"type": "esriFieldTypeString",
"alias": "Prior Years Actuals",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_39",
"type": "esriFieldTypeDouble",
"alias": "FY19-20 Actuals",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_40",
"type": "esriFieldTypeDouble",
"alias": "FY21 Actuals",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_41",
"type": "esriFieldTypeSmallInteger",
"alias": "Fac.",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_42",
"type": "esriFieldTypeSmallInteger",
"alias": "W/S",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_43",
"type": "esriFieldTypeSmallInteger",
"alias": "Street",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_44",
"type": "esriFieldTypeSmallInteger",
"alias": "HAS PIO",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_45",
"type": "esriFieldTypeString",
"alias": "Active Project",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_46",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q1 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_47",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q1 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_48",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q2 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_49",
"type": "esriFieldTypeDouble",
"alias": "FY22Q2 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_50",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q3 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_51",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q3 Chargeback",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_52",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q4 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_53",
"type": "esriFieldTypeString",
"alias": "FY22 Q4 Chargeback",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_54",
"type": "esriFieldTypeDouble",
"alias": "FY22 Total Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_55",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q1 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_56",
"type": "esriFieldTypeDouble",
"alias": "FY2021 Q1 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_57",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q2 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_58",
"type": "esriFieldTypeDouble",
"alias": "FY2021 Q2 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_59",
"type": "esriFieldTypeDouble",
"alias": "FY2021 Q3 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_60",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q3 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_61",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q4 Spend",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_62",
"type": "esriFieldTypeDouble",
"alias": "FY21 Q4 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_63",
"type": "esriFieldTypeDouble",
"alias": "Total Billable FY21 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_64",
"type": "esriFieldTypeDouble",
"alias": "Total Actual Fy21 Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_65",
"type": "esriFieldTypeDouble",
"alias": "Total Invoices",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_66",
"type": "esriFieldTypeString",
"alias": "Budget Status",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_67",
"type": "esriFieldTypeDouble",
"alias": "Billable vs Actual Chargebacks",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_68",
"type": "esriFieldTypeDouble",
"alias": "Priority Order",
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_69",
"type": "esriFieldTypeString",
"alias": "WSD Lead Representative",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_70",
"type": "esriFieldTypeString",
"alias": "WSD Reviewer",
"length": 255,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_71",
"type": "esriFieldTypeString",
"alias": "Latest Comment",
"length": 360,
"domain": null
},
{
"name": "GISADMIN_CIP_PROJECTS_SMARTS_72",
"type": "esriFieldTypeString",
"alias": "Action Items",
"length": 255,
"domain": null
},
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
},
{
"name": "Shape.STArea()",
"type": "esriFieldTypeDouble",
"alias": "Shape.STArea()",
"domain": null
},
{
"name": "Shape.STLength()",
"type": "esriFieldTypeDouble",
"alias": "Shape.STLength()",
"domain": null
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "R5043_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_5043",
"fields": "GISADMIN_CIP_PROJECTS_SMARTSH_8",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S3906_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"maxSelectionCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"preferredTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"datesInUnknownTimezone": false,
"hasGeometryProperties": true,
"geometryProperties": {
"shapeAreaFieldName": "Shape.STArea()",
"shapeLengthFieldName": "Shape.STLength()",
"units": "esriFeet",
"mapUnits": {"uwkid": 9002}
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true,
"serviceItemId": "36d2fc39d3ad4891bf98f91930a2ee25"
},
{
"currentVersion": 11.4,
"cimVersion": "3.4.0",
"id": 2,
"name": "CIP_PROJECTS_MUNIS_POLYS_for_Dashboard",
"type": "Feature Layer",
"description": "",
"geometryType": "esriGeometryPolygon",
"sourceSpatialReference": {
"wkid": 2223,
"latestWkid": 2223,
"xyTolerance": 0.00328083989501312,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -17746700,
"falseY": -44067300,
"xyUnits": 3048,
"falseZ": 0,
"zUnits": 1,
"falseM": 0,
"mUnits": 1
},
"copyrightText": "",
"parentLayer": null,
"subLayers": [],
"minScale": 0,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSFS",
"style": "esriSFSSolid",
"color": [
0,
112,
255,
0
],
"outline": {
"type": "esriSLS",
"style": "esriSLSSolid",
"color": [
110,
110,
110,
255
],
"width": 0.7
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": true,
"extent": {
"xmin": -112.43991822125072,
"ymin": 33.50524102819698,
"xmax": -112.1510030173766,
"ymax": 33.7407557217596,
"spatialReference": {
"wkid": 4326,
"latestWkid": 4326,
"xyTolerance": 8.983152841195215E-9,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -400,
"falseY": -400,
"xyUnits": 9.999999999999999E8,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "Project__",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "Project__",
"type": "esriFieldTypeString",
"alias": "Project__",
"length": 255,
"domain": null
},
{
"name": "Munis_no",
"type": "esriFieldTypeString",
"alias": "Munis_no",
"length": 255,
"domain": null
},
{
"name": "Fiscal_Year",
"type": "esriFieldTypeSmallInteger",
"alias": "Fiscal_Year",
"domain": null
},
{
"name": "CITY_WIDE",
"type": "esriFieldTypeString",
"alias": "CITY_WIDE",
"length": 255,
"domain": null
},
{
"name": "a_project",
"type": "esriFieldTypeString",
"alias": "a_project",
"length": 10,
"domain": null
},
{
"name": "ma_project_title",
"type": "esriFieldTypeString",
"alias": "ma_project_title",
"length": 35,
"domain": null
},
{
"name": "ma_description",
"type": "esriFieldTypeString",
"alias": "ma_description",
"length": 1073741822,
"domain": null
},
{
"name": "ma_justification",
"type": "esriFieldTypeString",
"alias": "ma_justification",
"length": 1073741822,
"domain": null
},
{
"name": "padt_pkg_no",
"type": "esriFieldTypeString",
"alias": "padt_pkg_no",
"length": 10,
"domain": null
},
{
"name": "padt_seg3",
"type": "esriFieldTypeString",
"alias": "padt_seg3",
"length": 10,
"domain": null
},
{
"name": "padt_year",
"type": "esriFieldTypeSmallInteger",
"alias": "padt_year",
"domain": null
},
{
"name": "padt_unit_cost",
"type": "esriFieldTypeDouble",
"alias": "padt_unit_cost",
"domain": null
},
{
"name": "LongDescription",
"type": "esriFieldTypeString",
"alias": "LongDescription",
"length": 30,
"domain": null
},
{
"name": "OrgLongDescription",
"type": "esriFieldTypeString",
"alias": "OrgLongDescription",
"length": 30,
"domain": null
},
{
"name": "ObjLongDescription",
"type": "esriFieldTypeString",
"alias": "ObjLongDescription",
"length": 30,
"domain": null
},
{
"name": "SegmentOneDescription",
"type": "esriFieldTypeString",
"alias": "SegmentOneDescription",
"length": 30,
"domain": null
},
{
"name": "SegmentTwoDescription",
"type": "esriFieldTypeString",
"alias": "SegmentTwoDescription",
"length": 30,
"domain": null
},
{
"name": "SegmentThreeDescription",
"type": "esriFieldTypeString",
"alias": "SegmentThreeDescription",
"length": 30,
"domain": null
},
{
"name": "ProjTypeDesc",
"type": "esriFieldTypeString",
"alias": "ProjTypeDesc",
"length": 22,
"domain": null
},
{
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape",
"domain": null
},
{
"name": "Shape.STArea()",
"type": "esriFieldTypeDouble",
"alias": "Shape.STArea()",
"domain": null
},
{
"name": "Shape.STLength()",
"type": "esriFieldTypeDouble",
"alias": "Shape.STLength()",
"domain": null
}
],
"geometryField": {
"name": "Shape",
"type": "esriFieldTypeGeometry",
"alias": "Shape"
},
"indexes": [
{
"name": "R4405_pk",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "S3273_idx",
"fields": "Shape",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"maxSelectionCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"preferredTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"datesInUnknownTimezone": false,
"hasGeometryProperties": true,
"geometryProperties": {
"shapeAreaFieldName": "Shape.STArea()",
"shapeLengthFieldName": "Shape.STLength()",
"units": "esriFeet",
"mapUnits": {"uwkid": 9002}
},
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true,
"serviceItemId": "36d2fc39d3ad4891bf98f91930a2ee25"
}
],
"tables": [
{
"currentVersion": 11.4,
"cimVersion": "3.4.0",
"id": 3,
"name": "CIP_PROJECTS_SMARTSHEET",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "Project_Name",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "F_",
"type": "esriFieldTypeString",
"alias": "$",
"length": 255,
"domain": null
},
{
"name": "Time",
"type": "esriFieldTypeString",
"alias": "Time",
"length": 255,
"domain": null
},
{
"name": "Other",
"type": "esriFieldTypeSmallInteger",
"alias": "Other",
"domain": null
},
{
"name": "Charter",
"type": "esriFieldTypeSmallInteger",
"alias": "Charter",
"domain": null
},
{
"name": "Project__",
"type": "esriFieldTypeString",
"alias": "Project #",
"length": 255,
"domain": null
},
{
"name": "Munis__",
"type": "esriFieldTypeString",
"alias": "Munis #",
"length": 255,
"domain": null
},
{
"name": "Project_Name",
"type": "esriFieldTypeString",
"alias": "Project Name",
"length": 255,
"domain": null
},
{
"name": "D_PM",
"type": "esriFieldTypeString",
"alias": "D-PM",
"length": 255,
"domain": null
},
{
"name": "C_PM",
"type": "esriFieldTypeString",
"alias": "C-PM",
"length": 255,
"domain": null
},
{
"name": "Project_Budget",
"type": "esriFieldTypeString",
"alias": "Project Budget",
"length": 255,
"domain": null
},
{
"name": "Project_Cost",
"type": "esriFieldTypeDouble",
"alias": "Project Cost",
"domain": null
},
{
"name": "Prior_Years_Actuals",
"type": "esriFieldTypeString",
"alias": "Prior Years Actuals",
"length": 255,
"domain": null
},
{
"name": "FY19_20_Actuals",
"type": "esriFieldTypeDouble",
"alias": "FY19-20 Actuals",
"domain": null
},
{
"name": "FY21_Actuals",
"type": "esriFieldTypeDouble",
"alias": "FY21 Actuals",
"domain": null
},
{
"name": "FY22_Actuals",
"type": "esriFieldTypeDouble",
"alias": "FY22 Actuals",
"domain": null
},
{
"name": "Est__Substantial_Date",
"type": "esriFieldTypeString",
"alias": "Est. Substantial Date",
"length": 255,
"domain": null
},
{
"name": "Final_Date",
"type": "esriFieldTypeDate",
"alias": "Final Date",
"length": 8,
"domain": null
},
{
"name": "Procurement",
"type": "esriFieldTypeString",
"alias": "Procurement",
"length": 255,
"domain": null
},
{
"name": "Department",
"type": "esriFieldTypeString",
"alias": "Department",
"length": 255,
"domain": null
},
{
"name": "Council_Date",
"type": "esriFieldTypeString",
"alias": "Council Date",
"length": 255,
"domain": null
},
{
"name": "Status",
"type": "esriFieldTypeString",
"alias": "Status",
"length": 255,
"domain": null
},
{
"name": "Act__Design_Completion_date",
"type": "esriFieldTypeString",
"alias": "Act. Design Completion date",
"length": 255,
"domain": null
},
{
"name": "Act__Substantial_Date",
"type": "esriFieldTypeDate",
"alias": "Act. Substantial Date",
"length": 8,
"domain": null
},
{
"name": "Fac_",
"type": "esriFieldTypeSmallInteger",
"alias": "Fac.",
"domain": null
},
{
"name": "W_S",
"type": "esriFieldTypeSmallInteger",
"alias": "W/S",
"domain": null
},
{
"name": "Street",
"type": "esriFieldTypeSmallInteger",
"alias": "Street",
"domain": null
},
{
"name": "HAS_PIO",
"type": "esriFieldTypeSmallInteger",
"alias": "HAS PIO",
"domain": null
},
{
"name": "Active_Project",
"type": "esriFieldTypeString",
"alias": "Active Project",
"length": 255,
"domain": null
},
{
"name": "Fy2021_Q1_Spend",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q1 Spend",
"domain": null
},
{
"name": "FY2021_Q1_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "FY2021 Q1 Chargebacks",
"domain": null
},
{
"name": "Fy2021_Q2_Spend",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q2 Spend",
"domain": null
},
{
"name": "FY2021_Q2_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "FY2021 Q2 Chargebacks",
"domain": null
},
{
"name": "FY2021_Q3_Spend",
"type": "esriFieldTypeDouble",
"alias": "FY2021 Q3 Spend",
"domain": null
},
{
"name": "Fy2021_Q3_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q3 Chargebacks",
"domain": null
},
{
"name": "Fy2021_Q4_Spend",
"type": "esriFieldTypeDouble",
"alias": "Fy2021 Q4 Spend",
"domain": null
},
{
"name": "FY21_Q4_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "FY21 Q4 Chargebacks",
"domain": null
},
{
"name": "Total_Billable_FY21_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "Total Billable FY21 Chargebacks",
"domain": null
},
{
"name": "Total_Actual_Fy21_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "Total Actual Fy21 Chargebacks",
"domain": null
},
{
"name": "FY22_Q1_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q1 Chargebacks",
"domain": null
},
{
"name": "FY22_Q1_Spend",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q1 Spend",
"domain": null
},
{
"name": "FY22_Total_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "Fy22 Total Chargebacks",
"domain": null
},
{
"name": "Total_Invoices",
"type": "esriFieldTypeDouble",
"alias": "Total Invoices",
"domain": null
},
{
"name": "Budget_Status",
"type": "esriFieldTypeString",
"alias": "Budget Status",
"length": 255,
"domain": null
},
{
"name": "Billable_vs_Actual_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "Billable vs Actual Chargebacks",
"domain": null
},
{
"name": "Address_Start",
"type": "esriFieldTypeString",
"alias": "Address Start",
"length": 255,
"domain": null
},
{
"name": "Address_End",
"type": "esriFieldTypeString",
"alias": "Address End",
"length": 255,
"domain": null
},
{
"name": "Citywide__Yes_No_",
"type": "esriFieldTypeString",
"alias": "Citywide (Yes/No)",
"length": 255,
"domain": null
},
{
"name": "FY23_Actuals",
"type": "esriFieldTypeDouble",
"alias": "FY23 Actuals",
"domain": null
},
{
"name": "Est__Charter_Design_Completion_",
"type": "esriFieldTypeDate",
"alias": "Est. Charter Design Completion Date",
"length": 8,
"domain": null
},
{
"name": "Actual_Design_Start_Date__Kicko",
"type": "esriFieldTypeString",
"alias": "Actual Design Start Date (Kickoff Date)",
"length": 255,
"domain": null
},
{
"name": "Contract_Design_Completion_Date",
"type": "esriFieldTypeDate",
"alias": "Contract Design Completion Date",
"length": 8,
"domain": null
},
{
"name": "Actual_Construction_Start_Date_",
"type": "esriFieldTypeString",
"alias": "Actual Construction Start Date (NTP Date)",
"length": 255,
"domain": null
},
{
"name": "FY22_Q2_Spend",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q2 Spend",
"domain": null
},
{
"name": "FY22Q2_Chargebacks",
"type": "esriFieldTypeDouble",
"alias": "FY22Q2 Chargebacks",
"domain": null
},
{
"name": "FY22_Q3_Spend",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q3 Spend",
"domain": null
},
{
"name": "FY22_Q3_Chargeback",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q3 Chargeback",
"domain": null
},
{
"name": "FY22_Q4_Spend",
"type": "esriFieldTypeDouble",
"alias": "FY22 Q4 Spend",
"domain": null
},
{
"name": "FY22_Q4_Chargeback",
"type": "esriFieldTypeString",
"alias": "FY22 Q4 Chargeback",
"length": 255,
"domain": null
},
{
"name": "Priority_Order",
"type": "esriFieldTypeDouble",
"alias": "Priority Order",
"domain": null
},
{
"name": "WSD_Lead_Representative",
"type": "esriFieldTypeString",
"alias": "WSD Lead Representative",
"length": 255,
"domain": null
},
{
"name": "WSD_Reviewer",
"type": "esriFieldTypeString",
"alias": "WSD Reviewer",
"length": 255,
"domain": null
},
{
"name": "Latest_Comment",
"type": "esriFieldTypeString",
"alias": "Latest Comment",
"length": 360,
"domain": null
},
{
"name": "Action_Items",
"type": "esriFieldTypeString",
"alias": "Action Items",
"length": 255,
"domain": null
}
],
"indexes": [
{
"name": "R4401_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": false,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"preferredTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"serviceItemId": "36d2fc39d3ad4891bf98f91930a2ee25"
},
{
"currentVersion": 11.4,
"cimVersion": "3.4.0",
"id": 4,
"name": "CIP_PROJECTS_MUNIS",
"type": "Table",
"description": null,
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "a_project",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
},
{
"name": "a_project",
"type": "esriFieldTypeString",
"alias": "a_project",
"length": 1073741822,
"domain": null
},
{
"name": "ma_project_type",
"type": "esriFieldTypeString",
"alias": "ma_project_type",
"length": 1073741822,
"domain": null
},
{
"name": "ma_project_title",
"type": "esriFieldTypeString",
"alias": "ma_project_title",
"length": 1073741822,
"domain": null
},
{
"name": "ma_major_project",
"type": "esriFieldTypeString",
"alias": "ma_major_project",
"length": 1073741822,
"domain": null
},
{
"name": "ma_stateid_number",
"type": "esriFieldTypeString",
"alias": "ma_stateid_number",
"length": 1073741822,
"domain": null
},
{
"name": "ma_cfda_number",
"type": "esriFieldTypeString",
"alias": "ma_cfda_number",
"length": 1073741822,
"domain": null
},
{
"name": "ma_proj_department",
"type": "esriFieldTypeInteger",
"alias": "ma_proj_department",
"domain": null
},
{
"name": "ma_proj_comment",
"type": "esriFieldTypeString",
"alias": "ma_proj_comment",
"length": 1073741822,
"domain": null
},
{
"name": "ma_project_status",
"type": "esriFieldTypeString",
"alias": "ma_project_status",
"length": 1073741822,
"domain": null
},
{
"name": "ma_draw",
"type": "esriFieldTypeString",
"alias": "ma_draw",
"length": 1073741822,
"domain": null
},
{
"name": "ma_use_pa_gl",
"type": "esriFieldTypeString",
"alias": "ma_use_pa_gl",
"length": 1073741822,
"domain": null
},
{
"name": "ma_carry_fwrd_cd",
"type": "esriFieldTypeInteger",
"alias": "ma_carry_fwrd_cd",
"domain": null
},
{
"name": "ma_fa_flag",
"type": "esriFieldTypeString",
"alias": "ma_fa_flag",
"length": 1073741822,
"domain": null
},
{
"name": "ma_start_year",
"type": "esriFieldTypeInteger",
"alias": "ma_start_year",
"domain": null
},
{
"name": "ma_start_period",
"type": "esriFieldTypeInteger",
"alias": "ma_start_period",
"domain": null
},
{
"name": "ma_start_month",
"type": "esriFieldTypeInteger",
"alias": "ma_start_month",
"domain": null
},
{
"name": "ma_start_day",
"type": "esriFieldTypeInteger",
"alias": "ma_start_day",
"domain": null
},
{
"name": "ma_end_month",
"type": "esriFieldTypeInteger",
"alias": "ma_end_month",
"domain": null
},
{
"name": "ma_end_day",
"type": "esriFieldTypeInteger",
"alias": "ma_end_day",
"domain": null
},
{
"name": "ma_projected_sdate",
"type": "esriFieldTypeString",
"alias": "ma_projected_sdate",
"length": 1073741822,
"domain": null
},
{
"name": "ma_projected_edate",
"type": "esriFieldTypeString",
"alias": "ma_projected_edate",
"length": 1073741822,
"domain": null
},
{
"name": "ma_orig_days",
"type": "esriFieldTypeInteger",
"alias": "ma_orig_days",
"domain": null
},
{
"name": "ma_revised_days",
"type": "esriFieldTypeInteger",
"alias": "ma_revised_days",
"domain": null
},
{
"name": "ma_expense_req_lvl",
"type": "esriFieldTypeInteger",
"alias": "ma_expense_req_lvl",
"domain": null
},
{
"name": "ma_funding_req_lvl",
"type": "esriFieldTypeInteger",
"alias": "ma_funding_req_lvl",
"domain": null
},
{
"name": "ma_expense_bud_lvl",
"type": "esriFieldTypeInteger",
"alias": "ma_expense_bud_lvl",
"domain": null
},
{
"name": "ma_funding_bud_lvl",
"type": "esriFieldTypeInteger",
"alias": "ma_funding_bud_lvl",
"domain": null
},
{
"name": "ma_admin_ovr_rt",
"type": "esriFieldTypeDouble",
"alias": "ma_admin_ovr_rt",
"domain": null
},
{
"name": "ma_actual_ovr_rt",
"type": "esriFieldTypeDouble",
"alias": "ma_actual_ovr_rt",
"domain": null
},
{
"name": "ma_pct_comp",
"type": "esriFieldTypeInteger",
"alias": "ma_pct_comp",
"domain": null
},
{
"name": "ma_description",
"type": "esriFieldTypeString",
"alias": "ma_description",
"length": 1073741822,
"domain": null
},
{
"name": "ma_justification",
"type": "esriFieldTypeString",
"alias": "ma_justification",
"length": 1073741822,
"domain": null
},
{
"name": "ma_workflow_status",
"type": "esriFieldTypeString",
"alias": "ma_workflow_status",
"length": 1073741822,
"domain": null
},
{
"name": "ma_est_to_comp",
"type": "esriFieldTypeDouble",
"alias": "ma_est_to_comp",
"domain": null
},
{
"name": "padt_pkg_no",
"type": "esriFieldTypeString",
"alias": "padt_pkg_no",
"length": 1073741822,
"domain": null
},
{
"name": "padt_seg1",
"type": "esriFieldTypeString",
"alias": "padt_seg1",
"length": 1073741822,
"domain": null
},
{
"name": "padt_seg2",
"type": "esriFieldTypeInteger",
"alias": "padt_seg2",
"domain": null
},
{
"name": "padt_seg3",
"type": "esriFieldTypeString",
"alias": "padt_seg3",
"length": 1073741822,
"domain": null
},
{
"name": "padt_seg4",
"type": "esriFieldTypeString",
"alias": "padt_seg4",
"length": 1073741822,
"domain": null
},
{
"name": "padt_type",
"type": "esriFieldTypeString",
"alias": "padt_type",
"length": 1073741822,
"domain": null
},
{
"name": "padt_seq",
"type": "esriFieldTypeInteger",
"alias": "padt_seq",
"domain": null
},
{
"name": "padt_year",
"type": "esriFieldTypeInteger",
"alias": "padt_year",
"domain": null
},
{
"name": "padt_qty",
"type": "esriFieldTypeDouble",
"alias": "padt_qty",
"domain": null
},
{
"name": "padt_unit_cost",
"type": "esriFieldTypeDouble",
"alias": "padt_unit_cost",
"domain": null
},
{
"name": "padt_desc1",
"type": "esriFieldTypeString",
"alias": "padt_desc1",
"length": 1073741822,
"domain": null
},
{
"name": "padt_desc2",
"type": "esriFieldTypeString",
"alias": "padt_desc2",
"length": 1073741822,
"domain": null
},
{
"name": "padt_gl_org",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_org",
"domain": null
},
{
"name": "padt_gl_obj",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_obj",
"domain": null
},
{
"name": "padt_gl_proj",
"type": "esriFieldTypeString",
"alias": "padt_gl_proj",
"length": 1073741822,
"domain": null
},
{
"name": "padt_gl_seg1",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_seg1",
"domain": null
},
{
"name": "padt_gl_seg2",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_seg2",
"domain": null
},
{
"name": "padt_gl_seg3",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_seg3",
"domain": null
},
{
"name": "padt_gl_seg4",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_seg4",
"domain": null
},
{
"name": "padt_gl_seg5",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_seg5",
"domain": null
},
{
"name": "padt_gl_seg6",
"type": "esriFieldTypeInteger",
"alias": "padt_gl_seg6",
"domain": null
},
{
"name": "AccountId",
"type": "esriFieldTypeInteger",
"alias": "AccountId",
"domain": null
},
{
"name": "LongDescription",
"type": "esriFieldTypeString",
"alias": "LongDescription",
"length": 1073741822,
"domain": null
},
{
"name": "ShortDescription",
"type": "esriFieldTypeString",
"alias": "ShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "OrganizationCode",
"type": "esriFieldTypeInteger",
"alias": "OrganizationCode",
"domain": null
},
{
"name": "OrgLongDescription",
"type": "esriFieldTypeString",
"alias": "OrgLongDescription",
"length": 1073741822,
"domain": null
},
{
"name": "OrgShortDescription",
"type": "esriFieldTypeString",
"alias": "OrgShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "ObjectCode",
"type": "esriFieldTypeInteger",
"alias": "ObjectCode",
"domain": null
},
{
"name": "ObjLongDescription",
"type": "esriFieldTypeString",
"alias": "ObjLongDescription",
"length": 1073741822,
"domain": null
},
{
"name": "ObjShortDescription",
"type": "esriFieldTypeString",
"alias": "ObjShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "ProjectCode",
"type": "esriFieldTypeString",
"alias": "ProjectCode",
"length": 1073741822,
"domain": null
},
{
"name": "ProjectTitle",
"type": "esriFieldTypeString",
"alias": "ProjectTitle",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentOne",
"type": "esriFieldTypeInteger",
"alias": "SegmentOne",
"domain": null
},
{
"name": "SegmentOneDescription",
"type": "esriFieldTypeString",
"alias": "SegmentOneDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentOneShortDescription",
"type": "esriFieldTypeString",
"alias": "SegmentOneShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentTwo",
"type": "esriFieldTypeInteger",
"alias": "SegmentTwo",
"domain": null
},
{
"name": "SegmentTwoDescription",
"type": "esriFieldTypeString",
"alias": "SegmentTwoDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentTwoShortDescription",
"type": "esriFieldTypeString",
"alias": "SegmentTwoShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentThree",
"type": "esriFieldTypeInteger",
"alias": "SegmentThree",
"domain": null
},
{
"name": "SegmentThreeDescription",
"type": "esriFieldTypeString",
"alias": "SegmentThreeDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentThreeShortDescription",
"type": "esriFieldTypeString",
"alias": "SegmentThreeShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentFour",
"type": "esriFieldTypeInteger",
"alias": "SegmentFour",
"domain": null
},
{
"name": "SegmentFourDescription",
"type": "esriFieldTypeString",
"alias": "SegmentFourDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentFourShortDescription",
"type": "esriFieldTypeString",
"alias": "SegmentFourShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentFive",
"type": "esriFieldTypeInteger",
"alias": "SegmentFive",
"domain": null
},
{
"name": "SegmentFiveDescription",
"type": "esriFieldTypeString",
"alias": "SegmentFiveDescription",
"length": 1073741822,
"domain": null
},
{
"name": "SegmentFiveShortDescription",
"type": "esriFieldTypeString",
"alias": "SegmentFiveShortDescription",
"length": 1073741822,
"domain": null
},
{
"name": "ProjType",
"type": "esriFieldTypeString",
"alias": "ProjType",
"length": 1073741822,
"domain": null
},
{
"name": "ProjTypeDesc",
"type": "esriFieldTypeString",
"alias": "ProjTypeDesc",
"length": 1073741822,
"domain": null
}
],
"indexes": [
{
"name": "R4404_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [],
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": false,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"preferredTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"serviceItemId": "36d2fc39d3ad4891bf98f91930a2ee25"
},
{
"currentVersion": 11.4,
"cimVersion": "3.4.0",
"id": 5,
"name": "CIP_PROJECTS_MUNIS_NOT_IN_SMARTSHEET",
"type": "Table",
"description": "CIP_PROJECTS_MUNIS_NOT_IN_SMARTSHEET",
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"displayField": "a_project",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "a_project",
"type": "esriFieldTypeString",
"alias": "a_project",
"length": 10,
"domain": null
},
{
"name": "ma_project_title",
"type": "esriFieldTypeString",
"alias": "ma_project_title",
"length": 35,
"domain": null
},
{
"name": "ma_description",
"type": "esriFieldTypeString",
"alias": "ma_description",
"length": 1073741822,
"domain": null
},
{
"name": "ESRI_OID",
"type": "esriFieldTypeOID",
"alias": "ESRI_OID",
"domain": null
}
],
"indexes": null,
"subtypes": [],
"relationships": [],
"capabilities": "Map,Query,Data",
"maxRecordCount": 2000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"supportedQueryFormats": "JSON, PBF",
"isDataVersioned": false,
"useStandardizedQueries": true,
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsPagination": true,
"supportsTrueCurve": false,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"preferredTimeReference": {
"timeZone": "US Mountain Standard Time",
"timeZoneIANA": "Etc/GMT+7",
"respectsDaylightSaving": false
},
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"uniqueIdInfo": {
"type": "simple",
"fields": [
"ma_description"
],
"OIDFieldContainsHashValue": true
},
"maxUniqueIDCount": 100000,
"serviceItemId": "36d2fc39d3ad4891bf98f91930a2ee25"
}
]
}