{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [], "indexes": [{ "name": "R1317_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 2, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithDistance": true, "supportsQueryWithCacheHint": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "f338008b31d24692a4cc9a36e6455ba3", "capabilities": "Map,Query,Data", "hasLastEditTime": false, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "CIP Projects Table", "displayField": "Project_Name", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "Dept", "length": 255, "alias": "Dept", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Munis_Numbers", "length": 255, "alias": "Munis_Numbers", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Project_Name", "length": 255, "alias": "Project_Name", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Project_Phase", "length": 255, "alias": "Project_Phase", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Project_Description", "length": 1052, "alias": "Project_Description", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ProjectStatus", "length": 255, "alias": "ProjectStatus", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ProjectNotesUpcomingMilestone", "length": 526, "alias": "ProjectNotesUpcomingMilestone", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Upcoming_Milestones", "length": 255, "alias": "Upcoming_Milestones", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Project_Address_1", "length": 255, "alias": "Project_Address_1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Project_Address_2", "length": 255, "alias": "Project_Address_2", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PM_ON_PROJECT", "length": 255, "alias": "PM_ON_PROJECT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Current_Contract_End_Date", "length": 8, "alias": "Current_Contract_End_Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "Days_to_Contract_Completion", "alias": "Days_to_Contract_Completion", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "Project_Completion_Season", "length": 255, "alias": "Project_Completion_Season", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Project_Completion_Year", "alias": "Project_Completion_Year", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_Adopted_Spend_Cash_Flow_", "alias": "FY2022_Adopted_Spend_Cash_Flow_City", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_A_1", "alias": "FY2022_Adopted_Spend_Cash_Flow_Grant", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FY2022_A_2", "alias": "FY2022_Adopted_Spend_Cash_Flow_LoCIP", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_A_3", "alias": "FY2022_Adopted_Spend_Cash_Flow_Total_Preliminary_Adopted", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_ExpendedJULY_City_PR", "alias": "FY2022_YTD_ExpendedJULY_City_PROJECTED", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_ExpendedJULY_Grant_P", "alias": "FY2022 YTD ExpendedJULY Grant PROJECTED", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_Expended_JULY_LoCIP_", "alias": "FY2022_YTD_Expended_JULY_LoCIP_PROJECTED", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Total_PROJECTED", "alias": "Total_PROJECTED", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_Expended_August_City", "alias": "FY2022_YTD_Expended_August_City_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_Expended_August_Gran", "alias": "FY2022_YTD_Expended_August_Grant_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_Expended_August_LoCI", "alias": "FY2022_YTD_Expended_August_LoCIP_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "Total_YTD_Expended_ACTUAL", "alias": "Total_YTD_Expended_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_Encumbered_August_Ci", "alias": "FY2022_YTD_Encumbered_August_City_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_Encumbered_August_Gr", "alias": "FY2022_YTD_Encumbered_August_Grant_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_YTD_Encumbered_August_Lo", "alias": "FY2022_YTD_Encumbered_August_LoCIP_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "Total_YTD_Encumbered_ACTUAL", "alias": "Total_YTD_Encumbered_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "S_W_FY2022_YTD_Expended_Encumbe", "alias": "S_W_FY2022_YTD_Expended_Encumbered_City_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "T_Z_FY2022_YTD_Expended_Encumbe", "alias": "T_Z_FY2022_YTD_Expended_Encumbered_Grant_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "V_Y_FY2022_YTD_Expended_Encumbe", "alias": "V_Y_FY2022_YTD_Expended_Encumbered_LoCIP_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "Total_Expended_Encumbered_YTD", "alias": "Total_Expended_Encumbered_YTD", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "K_S_W_FY2022_Budget_Percent_Rem", "alias": "K_S_W_FY2022_Budget_Percent_Remaining_City_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "L_T_X_FY2022_Budget_Percent_Rem", "alias": "L_T_X_FY2022_Budget_Percent_Remaining_Grant_ACTUAL", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "M_U_Y_FY2022_Budget_Percent_Rem", "alias": "M_U_Y_FY2022_Budget_Percent_Remaining_LoCIP_ACTUAL", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "N_V_Z_Total_YTD", "alias": "N_V_Z_Total_YTD", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FY2023_REQ_From_FY2022_Budget_R", "alias": "FY2023_REQ_From_FY2022_Budget_Request_Form", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "From_FY2022_Budget_Request_Form", "alias": "From_FY2022_Budget_Request_Form_FY2024_REQ", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "From_FY2_1", "alias": "From_FY2022_Budget_Request_Form_FY2025_REQ", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "From_FY2_2", "alias": "From_FY2022_Budget_Request_Form_FY2026_REQ", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2027_TO_COMPLETION", "alias": "FY2027_TO_COMPLETION", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "FY2022_FY2026_TOTAL_REQUESTED", "alias": "FY2022_FY2026_TOTAL_REQUESTED", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "PROJECT_FY22_Life_of_Project_TO", "alias": "PROJECT_FY22_Life_of_Project_TOTAL_REQUESTED", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "NOTES_1", "length": 255, "alias": "NOTES 1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LocationID", "alias": "LocationID", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "PM_Contact_Number", "length": 255, "alias": "PM_Contact_Number", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PM_Email_Address", "length": 255, "alias": "PM_Email_Address", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LocationIDTxt", "length": 10, "alias": "LocationIDTxt", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": null }