{ "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" }