{ "currentVersion" : 12, "id" : 2, "name" : "All Assets.csv", "type" : "Table", "serviceItemId" : "5736c6acbbc74369a51c8a17e68b8dbd", "cacheMaxAge" : 30, "displayField" : "District_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1778011176434, "schemaLastEditDate" : 1778011176434, "dataLastEditDate" : 1778011176434 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Project", "type" : "esriFieldTypeString", "alias" : "Project", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Planning_Status", "type" : "esriFieldTypeString", "alias" : "Planning_Status", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Asset_ID", "type" : "esriFieldTypeString", "alias" : "Asset_ID", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Operating_Condition", "type" : "esriFieldTypeString", "alias" : "Operating_Condition", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Quality_Status", "type" : "esriFieldTypeString", "alias" : "Quality_Status", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Audit_Status", "type" : "esriFieldTypeString", "alias" : "Audit_Status", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dalkia_Contract", "type" : "esriFieldTypeString", "alias" : "Dalkia_Contract", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dalkia_Project", "type" : "esriFieldTypeString", "alias" : "Dalkia_Project", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Job", "type" : "esriFieldTypeString", "alias" : "Job", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Work_Order", "type" : "esriFieldTypeString", "alias" : "Work_Order", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Asset_Label", "type" : "esriFieldTypeString", "alias" : "Solar_Asset_Label", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Permit", "type" : "esriFieldTypeString", "alias" : "Solar_Permit", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Work_Order", "type" : "esriFieldTypeString", "alias" : "Solar_Work_Order", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assigned_Staker", "type" : "esriFieldTypeString", "alias" : "Assigned_Staker", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assigned_Contractor", "type" : "esriFieldTypeString", "alias" : "Assigned_Contractor", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assigned_Rock_Dig_Contractor", "type" : "esriFieldTypeString", "alias" : "Assigned_Rock_Dig_Contractor", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assigned_Crew", "type" : "esriFieldTypeString", "alias" : "Assigned_Crew", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Assigned_Field_Data_Verification_User", "type" : "esriFieldTypeString", "alias" : "Assigned_Field_Data_Verification_User", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address", "type" : "esriFieldTypeString", "alias" : "Address", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "New_Feasible_Address", "type" : "esriFieldTypeString", "alias" : "New_Feasible_Address", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Planned_Type", "type" : "esriFieldTypeString", "alias" : "Planned_Type", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Planned_Feed", "type" : "esriFieldTypeString", "alias" : "Planned_Feed", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Eligible", "type" : "esriFieldTypeString", "alias" : "Solar_Eligible", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Last_Verified_By", "type" : "esriFieldTypeString", "alias" : "Last_Verified_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Last_Verified_Date_Time", "type" : "esriFieldTypeString", "alias" : "Last_Verified_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Staking_Comments", "type" : "esriFieldTypeString", "alias" : "Staking_Comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "On_Hold_Reason", "type" : "esriFieldTypeString", "alias" : "On_Hold_Reason", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cancellation_Reason", "type" : "esriFieldTypeString", "alias" : "Cancellation_Reason", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Staked_By", "type" : "esriFieldTypeString", "alias" : "Staked_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Staked_Date_Time", "type" : "esriFieldTypeString", "alias" : "Staked_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Staking_Photos", "type" : "esriFieldTypeString", "alias" : "Staking_Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Locates_Verified_By", "type" : "esriFieldTypeString", "alias" : "Locates_Verified_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Locates_Verified_Date_Time", "type" : "esriFieldTypeString", "alias" : "Locates_Verified_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dig_Notes", "type" : "esriFieldTypeString", "alias" : "Dig_Notes", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dig_Completed_By", "type" : "esriFieldTypeString", "alias" : "Dig_Completed_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dig_Comments", "type" : "esriFieldTypeString", "alias" : "Dig_Comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dig_Start_Time", "type" : "esriFieldTypeString", "alias" : "Dig_Start_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dig_Completed_Date_Time", "type" : "esriFieldTypeString", "alias" : "Dig_Completed_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dig_Total_Time", "type" : "esriFieldTypeString", "alias" : "Dig_Total_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Dig_Photos", "type" : "esriFieldTypeString", "alias" : "Dig_Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Encountered_During_Dig", "type" : "esriFieldTypeString", "alias" : "Rock_Encountered_During_Dig", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Dig_Needed_", "type" : "esriFieldTypeString", "alias" : "Rock_Dig_Needed_", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Dig_Completed_By", "type" : "esriFieldTypeString", "alias" : "Rock_Dig_Completed_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Dig_Comments", "type" : "esriFieldTypeString", "alias" : "Rock_Dig_Comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Dig_Start_Time", "type" : "esriFieldTypeString", "alias" : "Rock_Dig_Start_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Dig_Completed_Date_Time", "type" : "esriFieldTypeString", "alias" : "Rock_Dig_Completed_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Dig_Total_Time", "type" : "esriFieldTypeString", "alias" : "Rock_Dig_Total_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Rock_Dig_Photos", "type" : "esriFieldTypeString", "alias" : "Rock_Dig_Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hole_Filed_By", "type" : "esriFieldTypeString", "alias" : "Hole_Filed_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hole_Fill_Start_Time", "type" : "esriFieldTypeString", "alias" : "Hole_Fill_Start_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hole_Fill_Completed_Date_Time", "type" : "esriFieldTypeString", "alias" : "Hole_Fill_Completed_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hole_Fill_Total_Time", "type" : "esriFieldTypeString", "alias" : "Hole_Fill_Total_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Hole_Fill_Photos", "type" : "esriFieldTypeString", "alias" : "Hole_Fill_Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installed_By", "type" : "esriFieldTypeString", "alias" : "Installed_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installation_Start_Date_Time", "type" : "esriFieldTypeString", "alias" : "Installation_Start_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installation_Completion_Date_Time", "type" : "esriFieldTypeString", "alias" : "Installation_Completion_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installation_Materials_Used", "type" : "esriFieldTypeString", "alias" : "Installation_Materials_Used", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Kit", "type" : "esriFieldTypeString", "alias" : "Kit", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Total_Install_Time", "type" : "esriFieldTypeString", "alias" : "Total_Install_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installation_Photos", "type" : "esriFieldTypeString", "alias" : "Installation_Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Last_Predictive_Maintenance_Date_Time", "type" : "esriFieldTypeString", "alias" : "Last_Predictive_Maintenance_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Origin_Record_No", "type" : "esriFieldTypeString", "alias" : "Origin_Record_No", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "District", "type" : "esriFieldTypeString", "alias" : "District", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "District_Name", "type" : "esriFieldTypeString", "alias" : "District_Name", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NC_Pole_Installation_Type", "type" : "esriFieldTypeString", "alias" : "NC_Pole_Installation_Type", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Id", "type" : "esriFieldTypeString", "alias" : "Id", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Created_By", "type" : "esriFieldTypeString", "alias" : "Created_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Created_Date_Time", "type" : "esriFieldTypeDate", "alias" : "Created_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Last_Modified_By", "type" : "esriFieldTypeString", "alias" : "Last_Modified_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Last_Patrolled_Date_Time", "type" : "esriFieldTypeString", "alias" : "Last_Patrolled_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Last_Patrolled_By", "type" : "esriFieldTypeString", "alias" : "Last_Patrolled_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Poles", "type" : "esriFieldTypeString", "alias" : "Poles", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Fixtures", "type" : "esriFieldTypeString", "alias" : "Fixtures", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Photos", "type" : "esriFieldTypeString", "alias" : "Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Incidents", "type" : "esriFieldTypeString", "alias" : "Incidents", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Route", "type" : "esriFieldTypeString", "alias" : "Route", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tasks", "type" : "esriFieldTypeString", "alias" : "Tasks", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Easements", "type" : "esriFieldTypeString", "alias" : "Easements", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BlueForms", "type" : "esriFieldTypeString", "alias" : "BlueForms", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Easement_Lines", "type" : "esriFieldTypeString", "alias" : "Easement_Lines", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Repairs", "type" : "esriFieldTypeString", "alias" : "Repairs", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Last_JSA_Completion_Date", "type" : "esriFieldTypeString", "alias" : "Last_JSA_Completion_Date", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Last_Jsa_Completed_By", "type" : "esriFieldTypeString", "alias" : "Last_Jsa_Completed_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "QualityChecks", "type" : "esriFieldTypeString", "alias" : "QualityChecks", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Audits", "type" : "esriFieldTypeString", "alias" : "Audits", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Audit_Photos", "type" : "esriFieldTypeString", "alias" : "Audit_Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Other_Audit_Comments", "type" : "esriFieldTypeString", "alias" : "Other_Audit_Comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "General_Audit_Comments", "type" : "esriFieldTypeString", "alias" : "General_Audit_Comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Previous_Planning_Status", "type" : "esriFieldTypeString", "alias" : "Previous_Planning_Status", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "As_Builts", "type" : "esriFieldTypeString", "alias" : "As_Builts", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pole_Base_Type", "type" : "esriFieldTypeString", "alias" : "Pole_Base_Type", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "New_Asset_Workflow", "type" : "esriFieldTypeString", "alias" : "New_Asset_Workflow", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CustomerInteractions", "type" : "esriFieldTypeString", "alias" : "CustomerInteractions", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Replaced_Planned_Asset", "type" : "esriFieldTypeString", "alias" : "Replaced_Planned_Asset", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Replaced_Planned_Assets", "type" : "esriFieldTypeString", "alias" : "Replaced_Planned_Assets", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Replaced_As_Built", "type" : "esriFieldTypeString", "alias" : "Replaced_As_Built", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Removal_Date_Time", "type" : "esriFieldTypeString", "alias" : "Removal_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Removed_By", "type" : "esriFieldTypeString", "alias" : "Removed_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shield_Installed", "type" : "esriFieldTypeString", "alias" : "Shield_Installed", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installation_Actions", "type" : "esriFieldTypeString", "alias" : "Installation_Actions", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cycle_Time", "type" : "esriFieldTypeString", "alias" : "Cycle_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Staking_Cycle_Time", "type" : "esriFieldTypeString", "alias" : "Staking_Cycle_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Digging_Cycle_Time", "type" : "esriFieldTypeString", "alias" : "Digging_Cycle_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installation_Cycle_Time", "type" : "esriFieldTypeString", "alias" : "Installation_Cycle_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Controllers", "type" : "esriFieldTypeString", "alias" : "Controllers", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Lights", "type" : "esriFieldTypeString", "alias" : "Solar_Lights", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tree_Root_or_Canopy_Close", "type" : "esriFieldTypeString", "alias" : "Tree_Root_or_Canopy_Close", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tree_Trimming_Required", "type" : "esriFieldTypeString", "alias" : "Tree_Trimming_Required", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Tree_Removal_Required", "type" : "esriFieldTypeString", "alias" : "Tree_Removal_Required", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EPIC_Sheet", "type" : "esriFieldTypeString", "alias" : "EPIC_Sheet", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Used_Materials", "type" : "esriFieldTypeString", "alias" : "Used_Materials", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Installed_Activities", "type" : "esriFieldTypeString", "alias" : "Installed_Activities", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "On_Site_Crew_Members", "type" : "esriFieldTypeString", "alias" : "On_Site_Crew_Members", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Supervised_Date_Time", "type" : "esriFieldTypeString", "alias" : "Supervised_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Supervision_Photos", "type" : "esriFieldTypeString", "alias" : "Supervision_Photos", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Supervision_Comments", "type" : "esriFieldTypeString", "alias" : "Supervision_Comments", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Supervised_By", "type" : "esriFieldTypeString", "alias" : "Supervised_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Pre_EV_Scope", "type" : "esriFieldTypeString", "alias" : "Pre_EV_Scope", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cancellation_Date", "type" : "esriFieldTypeString", "alias" : "Cancellation_Date", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Cancelled_By", "type" : "esriFieldTypeString", "alias" : "Cancelled_By", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Environmental_Complete_Date_Time", "type" : "esriFieldTypeString", "alias" : "Solar_Environmental_Complete_Date_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Planning_Time", "type" : "esriFieldTypeString", "alias" : "Solar_Planning_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Environmental_Time", "type" : "esriFieldTypeString", "alias" : "Solar_Environmental_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Solar_Construction_Time", "type" : "esriFieldTypeString", "alias" : "Solar_Construction_Time", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Problematic_Location", "type" : "esriFieldTypeString", "alias" : "Problematic_Location", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__INTERACT__F4B70D85877FD27C", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "All Assets.csv", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Solar_Construction_Time" : null, "Problematic_Location" : null, "Project" : null, "Planning_Status" : null, "Asset_ID" : null, "Operating_Condition" : null, "Quality_Status" : null, "Audit_Status" : null, "Dalkia_Contract" : null, "Dalkia_Project" : null, "Job" : null, "Work_Order" : null, "Solar_Asset_Label" : null, "Solar_Permit" : null, "Solar_Work_Order" : null, "Assigned_Staker" : null, "Assigned_Contractor" : null, "Assigned_Rock_Dig_Contractor" : null, "Assigned_Crew" : null, "Assigned_Field_Data_Verification_User" : null, "Address" : null, "New_Feasible_Address" : null, "Planned_Type" : null, "Planned_Feed" : null, "Solar_Eligible" : null, "Last_Verified_By" : null, "Last_Verified_Date_Time" : null, "Staking_Comments" : null, "On_Hold_Reason" : null, "Cancellation_Reason" : null, "Staked_By" : null, "Staked_Date_Time" : null, "Staking_Photos" : null, "Locates_Verified_By" : null, "Locates_Verified_Date_Time" : null, "Dig_Notes" : null, "Dig_Completed_By" : null, "Dig_Comments" : null, "Dig_Start_Time" : null, "Dig_Completed_Date_Time" : null, "Dig_Total_Time" : null, "Dig_Photos" : null, "Rock_Encountered_During_Dig" : null, "Rock_Dig_Needed_" : null, "Rock_Dig_Completed_By" : null, "Rock_Dig_Comments" : null, "Rock_Dig_Start_Time" : null, "Rock_Dig_Completed_Date_Time" : null, "Rock_Dig_Total_Time" : null, "Rock_Dig_Photos" : null, "Hole_Filed_By" : null, "Hole_Fill_Start_Time" : null, "Hole_Fill_Completed_Date_Time" : null, "Hole_Fill_Total_Time" : null, "Hole_Fill_Photos" : null, "Installed_By" : null, "Installation_Start_Date_Time" : null, "Installation_Completion_Date_Time" : null, "Installation_Materials_Used" : null, "Kit" : null, "Total_Install_Time" : null, "Installation_Photos" : null, "Last_Predictive_Maintenance_Date_Time" : null, "Origin_Record_No" : null, "District" : null, "District_Name" : null, "NC_Pole_Installation_Type" : null, "Id" : null, "Created_By" : null, "Created_Date_Time" : null, "Last_Modified_By" : null, "Last_Patrolled_Date_Time" : null, "Last_Patrolled_By" : null, "Latitude" : null, "Longitude" : null, "Poles" : null, "Fixtures" : null, "Photos" : null, "Incidents" : null, "Notes" : null, "Route" : null, "Tasks" : null, "Easements" : null, "BlueForms" : null, "Easement_Lines" : null, "Repairs" : null, "Last_JSA_Completion_Date" : null, "Last_Jsa_Completed_By" : null, "QualityChecks" : null, "Audits" : null, "Audit_Photos" : null, "Other_Audit_Comments" : null, "General_Audit_Comments" : null, "Previous_Planning_Status" : null, "As_Builts" : null, "Pole_Base_Type" : null, "New_Asset_Workflow" : null, "CustomerInteractions" : null, "Replaced_Planned_Asset" : null, "Replaced_Planned_Assets" : null, "Replaced_As_Built" : null, "Removal_Date_Time" : null, "Removed_By" : null, "Shield_Installed" : null, "Installation_Actions" : null, "Cycle_Time" : null, "Staking_Cycle_Time" : null, "Digging_Cycle_Time" : null, "Installation_Cycle_Time" : null, "Controllers" : null, "Solar_Lights" : null, "Tree_Root_or_Canopy_Close" : null, "Tree_Trimming_Required" : null, "Tree_Removal_Required" : null, "EPIC_Sheet" : null, "Used_Materials" : null, "Installed_Activities" : null, "On_Site_Crew_Members" : null, "Supervised_Date_Time" : null, "Supervision_Photos" : null, "Supervision_Comments" : null, "Supervised_By" : null, "Pre_EV_Scope" : null, "Cancellation_Date" : null, "Cancelled_By" : null, "Solar_Environmental_Complete_Date_Time" : null, "Solar_Planning_Time" : null, "Solar_Environmental_Time" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }