{ "currentVersion": 10.91, "id": 20, "name": "umMeters", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "Electric.GIS.ElectricMeters", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "umLocationID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "umLocationID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "umLocationID", "type": "esriFieldTypeString", "alias": "umLocationID", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umLocationID" }, { "name": "umConnectSeq", "type": "esriFieldTypeSmallInteger", "alias": "umConnectSeq", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umConnectSeq" }, { "name": "umServiceType", "type": "esriFieldTypeString", "alias": "umServiceType", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umServiceType" }, { "name": "umServiceCategory", "type": "esriFieldTypeSmallInteger", "alias": "umServiceCategory", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umServiceCategory" }, { "name": "UMMETGRPID", "type": "esriFieldTypeString", "alias": "UMMETGRPID", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "UMMETGRPID" }, { "name": "UMMULTGRPID", "type": "esriFieldTypeString", "alias": "UMMULTGRPID", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "UMMULTGRPID" }, { "name": "umRouteID", "type": "esriFieldTypeString", "alias": "umRouteID", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umRouteID" }, { "name": "umConnectStatus", "type": "esriFieldTypeSmallInteger", "alias": "umConnectStatus", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umConnectStatus" }, { "name": "umTariffID", "type": "esriFieldTypeString", "alias": "umTariffID", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umTariffID" }, { "name": "umConnectionDate", "type": "esriFieldTypeDate", "alias": "umConnectionDate", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umConnectionDate" }, { "name": "umDisconnectionDate", "type": "esriFieldTypeDate", "alias": "umDisconnectionDate", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umDisconnectionDate" }, { "name": "UMCONNMULT", "type": "esriFieldTypeDouble", "alias": "UMCONNMULT", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMCONNMULT" }, { "name": "UMMULTTYPE", "type": "esriFieldTypeSmallInteger", "alias": "UMMULTTYPE", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMMULTTYPE" }, { "name": "umEquipmentID", "type": "esriFieldTypeString", "alias": "umEquipmentID", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umEquipmentID" }, { "name": "umUseAltMeter", "type": "esriFieldTypeSmallInteger", "alias": "umUseAltMeter", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umUseAltMeter" }, { "name": "UMSEQNUM", "type": "esriFieldTypeDouble", "alias": "UMSEQNUM", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMSEQNUM" }, { "name": "UMFIXEDMULT", "type": "esriFieldTypeDouble", "alias": "UMFIXEDMULT", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMFIXEDMULT" }, { "name": "umConsumptMult", "type": "esriFieldTypeDouble", "alias": "umConsumptMult", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umConsumptMult" }, { "name": "UMLOSSMULT", "type": "esriFieldTypeDouble", "alias": "UMLOSSMULT", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMLOSSMULT" }, { "name": "UMRNGMINMULT", "type": "esriFieldTypeDouble", "alias": "UMRNGMINMULT", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMRNGMINMULT" }, { "name": "UMEQUCLSS", "type": "esriFieldTypeString", "alias": "UMEQUCLSS", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "UMEQUCLSS" }, { "name": "UMEQUMULT", "type": "esriFieldTypeDouble", "alias": "UMEQUMULT", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMEQUMULT" }, { "name": "UMINSTALLSTAT", "type": "esriFieldTypeSmallInteger", "alias": "UMINSTALLSTAT", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMINSTALLSTAT" }, { "name": "umInstallationDate", "type": "esriFieldTypeDate", "alias": "umInstallationDate", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umInstallationDate" }, { "name": "umEquipLot", "type": "esriFieldTypeString", "alias": "umEquipLot", "domain": null, "editable": true, "nullable": false, "length": 21, "defaultValue": null, "modelName": "umEquipLot" }, { "name": "umSerialNumber", "type": "esriFieldTypeString", "alias": "umSerialNumber", "domain": null, "editable": true, "nullable": false, "length": 31, "defaultValue": null, "modelName": "umSerialNumber" }, { "name": "umRemovalDate", "type": "esriFieldTypeDate", "alias": "umRemovalDate", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umRemovalDate" }, { "name": "umDateCreated", "type": "esriFieldTypeDate", "alias": "umDateCreated", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umDateCreated" }, { "name": "umDateModified", "type": "esriFieldTypeDate", "alias": "umDateModified", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umDateModified" }, { "name": "umManufacturer", "type": "esriFieldTypeString", "alias": "umManufacturer", "domain": null, "editable": true, "nullable": false, "length": 31, "defaultValue": null, "modelName": "umManufacturer" }, { "name": "umDiameterd", "type": "esriFieldTypeDouble", "alias": "umDiameterd", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umDiameterd" }, { "name": "umNumWires", "type": "esriFieldTypeSmallInteger", "alias": "umNumWires", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umNumWires" }, { "name": "umVoltage", "type": "esriFieldTypeDouble", "alias": "umVoltage", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umVoltage" }, { "name": "umAmps", "type": "esriFieldTypeDouble", "alias": "umAmps", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umAmps" }, { "name": "UMTOTCONSUMP", "type": "esriFieldTypeSmallInteger", "alias": "UMTOTCONSUMP", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMTOTCONSUMP" }, { "name": "UMTOTKW", "type": "esriFieldTypeSmallInteger", "alias": "UMTOTKW", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMTOTKW" }, { "name": "UMTOTKVA", "type": "esriFieldTypeSmallInteger", "alias": "UMTOTKVA", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "UMTOTKVA" }, { "name": "umPhysicalLocation", "type": "esriFieldTypeString", "alias": "umPhysicalLocation", "domain": null, "editable": true, "nullable": false, "length": 65, "defaultValue": null, "modelName": "umPhysicalLocation" }, { "name": "umLocator", "type": "esriFieldTypeString", "alias": "umLocator", "domain": null, "editable": true, "nullable": false, "length": 21, "defaultValue": null, "modelName": "umLocator" }, { "name": "umGISIdentifier", "type": "esriFieldTypeString", "alias": "umGISIdentifier", "domain": null, "editable": true, "nullable": false, "length": 21, "defaultValue": null, "modelName": "umGISIdentifier" } ], "indexes": [ { "name": "R508_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "umMeters", "description": "", "prototype": { "attributes": { "umLocator": " ", "umGISIdentifier": " ", "umLocationID": " ", "umConnectSeq": 0, "umServiceType": " ", "umServiceCategory": 0, "UMMETGRPID": " ", "UMMULTGRPID": " ", "umRouteID": " ", "umConnectStatus": 0, "umTariffID": " ", "umConnectionDate": -2209161600000, "umDisconnectionDate": -2209161600000, "UMCONNMULT": 0, "UMMULTTYPE": 0, "umEquipmentID": " ", "umUseAltMeter": 0, "UMSEQNUM": 0, "UMFIXEDMULT": 0, "umConsumptMult": 0, "UMLOSSMULT": 0, "UMRNGMINMULT": 0, "UMEQUCLSS": " ", "UMEQUMULT": 0, "UMINSTALLSTAT": 0, "umInstallationDate": -2209161600000, "umEquipLot": " ", "umSerialNumber": " ", "umRemovalDate": -2209161600000, "umDateCreated": -2209161600000, "umDateModified": -2209161600000, "umManufacturer": " ", "umDiameterd": 0, "umNumWires": 0, "umVoltage": 0, "umAmps": 0, "UMTOTCONSUMP": 0, "UMTOTKW": 0, "UMTOTKVA": 0, "umPhysicalLocation": " " } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 30000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 30000, "maxRecordCountFactor": 1 }