{ "currentVersion" : 12, "id" : 21, "name" : "Services_On_Pole", "type" : "Table", "serviceItemId" : "1dc5e994cd084923927c99865ba7d89a", "cacheMaxAge" : 30, "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "Service_Name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : true, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : true, "allowAnonymousToDelete" : true }, "editFieldsInfo" : { "creationDateField" : "created_date", "creatorField" : "created_user", "editDateField" : "last_edited_date", "editorField" : "last_edited_user" }, "editingInfo" : { "lastEditDate" : 1753197405294, "schemaLastEditDate" : 1753197405294, "dataLastEditDate" : 1753197405294 }, "relationships" : [ { "id" : 4, "name" : "ElectricPoles", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "GlobalID_Pole", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : true, "supportsOBACForAnonymousUsers" : true, "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, "viewSourceHasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "Service_Type", "type" : "esriFieldTypeInteger", "alias" : "Service_Type", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ugvsoh", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "OverHead", "code" : 1 }, { "name" : "UnderGround", "code" : 2 }, { "name" : "UNK", "code" : 0 } ] }, "defaultValue" : null }, { "name" : "Service_WireSize", "type" : "esriFieldTypeInteger", "alias" : "Service_WireSize", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "RF_OHWireSize", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Rock Falls Requested Overhead Wire Size Values", "codedValues" : [ { "name" : "2 AWG", "code" : 1 }, { "name" : "4 AWG", "code" : 2 }, { "name" : "6 AWG", "code" : 3 }, { "name" : "1/0 AWG", "code" : 4 }, { "name" : "2/0 AWG", "code" : 5 }, { "name" : "3/0 AWG", "code" : 6 }, { "name" : "4/0 AWG", "code" : 7 }, { "name" : "396 MCM", "code" : 8 }, { "name" : "500 MCM", "code" : 9 }, { "name" : "350 MCM", "code" : 10 } ] }, "defaultValue" : null }, { "name" : "Service_Address", "type" : "esriFieldTypeString", "alias" : "Service_Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Service_Account", "type" : "esriFieldTypeString", "alias" : "Service_Account", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Service_Phone", "type" : "esriFieldTypeString", "alias" : "Service_Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Service_Name", "type" : "esriFieldTypeString", "alias" : "Service_Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PoleNumber", "type" : "esriFieldTypeString", "alias" : "PoleNumber", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Street_Number", "type" : "esriFieldTypeSmallInteger", "alias" : "Street_Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Street_Name", "type" : "esriFieldTypeString", "alias" : "Street_Name", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "road_names", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Description", "codedValues" : [ { "name" : "10TH", "code" : "10TH" }, { "name" : "11TH", "code" : "11TH" }, { "name" : "12TH", "code" : "12TH" }, { "name" : "13TH", "code" : "13TH" }, { "name" : "14TH", "code" : "14TH" }, { "name" : "15TH", "code" : "15TH" }, { "name" : "16TH", "code" : "16TH" }, { "name" : "17TH", "code" : "17TH" }, { "name" : "18TH", "code" : "18TH" }, { "name" : "19TH", "code" : "19TH" }, { "name" : "1ST", "code" : "1ST" }, { "name" : "20TH", "code" : "20TH" }, { "name" : "21ST", "code" : "21ST" }, { "name" : "23RD", "code" : "23RD" }, { "name" : "24TH", "code" : "24TH" }, { "name" : "2ND", "code" : "2ND" }, { "name" : "3RD", "code" : "3RD" }, { "name" : "4TH", "code" : "4TH" }, { "name" : "5TH", "code" : "5TH" }, { "name" : "6TH", "code" : "6TH" }, { "name" : "7TH", "code" : "7TH" }, { "name" : "8TH", "code" : "8TH" }, { "name" : "9TH", "code" : "9TH" }, { "name" : "ADA", "code" : "ADA" }, { "name" : "ALLEN", "code" : "ALLEN" }, { "name" : "ANTEC", "code" : "ANTEC" }, { "name" : "ARLAND", "code" : "ARLAND" }, { "name" : "AVENUE A", "code" : "AVENUE A" }, { "name" : "AVENUE B", "code" : "AVENUE B" }, { "name" : "AVENUE C", "code" : "AVENUE C" }, { "name" : "AVENUE D", "code" : "AVENUE D" }, { "name" : "AVENUE E", "code" : "AVENUE E" }, { "name" : "AVENUE F", "code" : "AVENUE F" }, { "name" : "BELTWAY", "code" : "BELTWAY" }, { "name" : "BENNETT", "code" : "BENNETT" }, { "name" : "BURLINGTON", "code" : "BURLINGTON" }, { "name" : "CANAL", "code" : "CANAL" }, { "name" : "CANARY", "code" : "CANARY" }, { "name" : "CARDINAL", "code" : "CARDINAL" }, { "name" : "CHARLES", "code" : "CHARLES" }, { "name" : "CIRCLE", "code" : "CIRCLE" }, { "name" : "CLEARWATER", "code" : "CLEARWATER" }, { "name" : "CULVER", "code" : "CULVER" }, { "name" : "DIXON", "code" : "DIXON" }, { "name" : "EMMONS", "code" : "EMMONS" }, { "name" : "FLOCK", "code" : "FLOCK" }, { "name" : "GALT", "code" : "GALT" }, { "name" : "GARDEN", "code" : "GARDEN" }, { "name" : "GARFIELD", "code" : "GARFIELD" }, { "name" : "GOODELL", "code" : "GOODELL" }, { "name" : "GRACE", "code" : "GRACE" }, { "name" : "HASKELL", "code" : "HASKELL" }, { "name" : "HEINZE", "code" : "HEINZE" }, { "name" : "HILLTOP", "code" : "HILLTOP" }, { "name" : "HUDSON", "code" : "HUDSON" }, { "name" : "KANE", "code" : "KANE" }, { "name" : "KEITH", "code" : "KEITH" }, { "name" : "LANCASTER", "code" : "LANCASTER" }, { "name" : "LEROY", "code" : "LEROY" }, { "name" : "LINCOLN", "code" : "LINCOLN" }, { "name" : "LINDY", "code" : "LINDY" }, { "name" : "LOUIS", "code" : "LOUIS" }, { "name" : "LUKE", "code" : "LUKE" }, { "name" : "MARK", "code" : "MARK" }, { "name" : "MARSHA", "code" : "MARSHA" }, { "name" : "MARTIN", "code" : "MARTIN" }, { "name" : "MARTY", "code" : "MARTY" }, { "name" : "MARY", "code" : "MARY" }, { "name" : "MASON", "code" : "MASON" }, { "name" : "MC NEIL", "code" : "MC NEIL" }, { "name" : "MINKEL", "code" : "MINKEL" }, { "name" : "PLEASANT", "code" : "PLEASANT" }, { "name" : "PROPHET", "code" : "PROPHET" }, { "name" : "QUAIL", "code" : "QUAIL" }, { "name" : "ROBERTS", "code" : "ROBERTS" }, { "name" : "ROCK FALLS", "code" : "ROCK FALLS" }, { "name" : "ROUTE 30", "code" : "ROUTE 30" }, { "name" : "SELMI", "code" : "SELMI" }, { "name" : "SMITH", "code" : "SMITH" }, { "name" : "STANLEY", "code" : "STANLEY" }, { "name" : "SUNSET", "code" : "SUNSET" }, { "name" : "SUZANNE", "code" : "SUZANNE" }, { "name" : "SWALLOW", "code" : "SWALLOW" }, { "name" : "THOMAS", "code" : "THOMAS" }, { "name" : "THOME", "code" : "THOME" }, { "name" : "VERIO", "code" : "VERIO" }, { "name" : "WIKE", "code" : "WIKE" }, { "name" : "WIKER", "code" : "WIKER" }, { "name" : "WILEY", "code" : "WILEY" }, { "name" : "WOLF CREEK", "code" : "WOLF CREEK" } ] }, "defaultValue" : null }, { "name" : "Service_Voltage", "type" : "esriFieldTypeInteger", "alias" : "WireType", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "RF_OHWireType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Rock Falls Requested Overhead Wire Type Values", "codedValues" : [ { "name" : "Open WIre", "code" : 1 }, { "name" : "Parlay", "code" : 2 }, { "name" : "Triplex", "code" : 3 }, { "name" : "Quad", "code" : 4 }, { "name" : "Duplex", "code" : 5 } ] }, "defaultValue" : null }, { "name" : "Comment", "type" : "esriFieldTypeString", "alias" : "Comment", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID_Pole", "type" : "esriFieldTypeGUID", "alias" : "GlobalID_Pole", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "created_user", "type" : "esriFieldTypeString", "alias" : "created_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "created_date", "type" : "esriFieldTypeDate", "alias" : "created_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_edited_user", "type" : "esriFieldTypeString", "alias" : "last_edited_user", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edited_date", "type" : "esriFieldTypeDate", "alias" : "last_edited_date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__RF_ELECT__F4B70D85739867B3", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G149GlobalID_Pol", "fields" : "GlobalID_Pole", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "created_dateIndex", "fields" : "created_date", "isAscending" : true, "isUnique" : false, "description" : "created_date Field index", "indexType" : "Attribute" }, { "name" : "created_userIndex", "fields" : "created_user", "isAscending" : false, "isUnique" : false, "description" : "created_user Field index", "indexType" : "Attribute" }, { "name" : "last_edited_dateIndex", "fields" : "last_edited_date", "isAscending" : true, "isUnique" : false, "description" : "last_edited_date Field index", "indexType" : "Attribute" }, { "name" : "last_edited_userIndex", "fields" : "last_edited_user", "isAscending" : false, "isUnique" : false, "description" : "last_edited_user Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Services_On_Pole", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Comment" : null, "GlobalID_Pole" : null, "Service_Type" : null, "Service_WireSize" : null, "Service_Address" : null, "Service_Account" : null, "Service_Phone" : null, "Service_Name" : null, "PoleNumber" : null, "Street_Number" : null, "Street_Name" : null, "Service_Voltage" : 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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 20000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }