{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1595, "name": "Spry_Data25", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "GIS_PROD.GDB_ADMIN.Meters", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "premise_number", "composite": false }, { "id": 1, "name": "GIS_PROD.GDB_ADMIN.Meters", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "premise_number", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "customer_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "premise_number", "type": "esriFieldTypeString", "alias": "premise_number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "premise_number" }, { "name": "Tap_Number", "type": "esriFieldTypeString", "alias": "Tap_Number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Tap_Number" }, { "name": "Meter__Location", "type": "esriFieldTypeString", "alias": "Meter__Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Meter__Location" }, { "name": "Stop__Box", "type": "esriFieldTypeString", "alias": "Stop__Box", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Stop__Box" }, { "name": "Hazard__Message", "type": "esriFieldTypeString", "alias": "Hazard__Message", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Hazard__Message" }, { "name": "Main_Measure", "type": "esriFieldTypeString", "alias": "Main_Measure", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Main_Measure" }, { "name": "meter_number", "type": "esriFieldTypeString", "alias": "meter_number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "meter_number" }, { "name": "meter_size", "type": "esriFieldTypeString", "alias": "meter_size", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "meter_size" }, { "name": "address", "type": "esriFieldTypeString", "alias": "address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "address" }, { "name": "meter_id", "type": "esriFieldTypeString", "alias": "meter_id", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "meter_id" }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "latitude" }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "longitude" }, { "name": "old_account_number", "type": "esriFieldTypeString", "alias": "old_account_number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "old_account_number" }, { "name": "account_number", "type": "esriFieldTypeString", "alias": "account_number", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "account_number" }, { "name": "customer_name", "type": "esriFieldTypeString", "alias": "customer_name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "customer_name" }, { "name": "meter_brand", "type": "esriFieldTypeString", "alias": "meter_brand", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "meter_brand" }, { "name": "endpointid", "type": "esriFieldTypeString", "alias": "endpointid", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "endpointid" }, { "name": "pressure_zone", "type": "esriFieldTypeString", "alias": "pressure_zone", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "pressure_zone" }, { "name": "premise_type", "type": "esriFieldTypeString", "alias": "premise_type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "premise_type" }, { "name": "premise_status", "type": "esriFieldTypeString", "alias": "premise_status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "premise_status" }, { "name": "number_of_shares", "type": "esriFieldTypeDouble", "alias": "number_of_shares", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "number_of_shares" }, { "name": "meter_type", "type": "esriFieldTypeString", "alias": "meter_type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "meter_type" }, { "name": "meter_status", "type": "esriFieldTypeString", "alias": "meter_status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "meter_status" } ], "indexes": [ { "name": "R515_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_8040_premise", "fields": "premise_number", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Spry_Data25", "description": "", "prototype": { "attributes": { "meter_type": null, "meter_status": null, "premise_number": null, "Tap_Number": null, "Meter__Location": null, "Stop__Box": null, "Hazard__Message": null, "Main_Measure": null, "meter_number": null, "meter_size": null, "address": null, "meter_id": null, "latitude": null, "longitude": null, "old_account_number": null, "account_number": null, "customer_name": null, "meter_brand": null, "endpointid": null, "pressure_zone": null, "premise_type": null, "premise_status": null, "number_of_shares": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 25000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 25000, "maxRecordCountFactor": 1 }