{ "currentVersion": 10.91, "id": 20, "name": "Water.GIS.umMeters", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "umLocationID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "umLocationID", "type": "esriFieldTypeString", "alias": "umLocationID", "length": 50, "domain": null }, { "name": "umConnectSeq", "type": "esriFieldTypeSmallInteger", "alias": "umConnectSeq", "domain": null }, { "name": "umServiceType", "type": "esriFieldTypeString", "alias": "umServiceType", "length": 15, "domain": null }, { "name": "umServiceCategory", "type": "esriFieldTypeSmallInteger", "alias": "umServiceCategory", "domain": null }, { "name": "UMMETGRPID", "type": "esriFieldTypeString", "alias": "UMMETGRPID", "length": 15, "domain": null }, { "name": "UMMULTGRPID", "type": "esriFieldTypeString", "alias": "UMMULTGRPID", "length": 15, "domain": null }, { "name": "umRouteID", "type": "esriFieldTypeString", "alias": "umRouteID", "length": 15, "domain": null }, { "name": "umConnectStatus", "type": "esriFieldTypeSmallInteger", "alias": "umConnectStatus", "domain": null }, { "name": "umTariffID", "type": "esriFieldTypeString", "alias": "umTariffID", "length": 15, "domain": null }, { "name": "umConnectionDate", "type": "esriFieldTypeDate", "alias": "umConnectionDate", "length": 8, "domain": null }, { "name": "umDisconnectionDate", "type": "esriFieldTypeDate", "alias": "umDisconnectionDate", "length": 8, "domain": null }, { "name": "UMCONNMULT", "type": "esriFieldTypeDouble", "alias": "UMCONNMULT", "domain": null }, { "name": "UMMULTTYPE", "type": "esriFieldTypeSmallInteger", "alias": "UMMULTTYPE", "domain": null }, { "name": "umEquipmentID", "type": "esriFieldTypeString", "alias": "umEquipmentID", "length": 15, "domain": null }, { "name": "umUseAltMeter", "type": "esriFieldTypeSmallInteger", "alias": "umUseAltMeter", "domain": null }, { "name": "UMSEQNUM", "type": "esriFieldTypeDouble", "alias": "UMSEQNUM", "domain": null }, { "name": "UMFIXEDMULT", "type": "esriFieldTypeDouble", "alias": "UMFIXEDMULT", "domain": null }, { "name": "umConsumptMult", "type": "esriFieldTypeDouble", "alias": "umConsumptMult", "domain": null }, { "name": "UMLOSSMULT", "type": "esriFieldTypeDouble", "alias": "UMLOSSMULT", "domain": null }, { "name": "UMRNGMINMULT", "type": "esriFieldTypeDouble", "alias": "UMRNGMINMULT", "domain": null }, { "name": "UMEQUCLSS", "type": "esriFieldTypeString", "alias": "UMEQUCLSS", "length": 15, "domain": null }, { "name": "UMEQUMULT", "type": "esriFieldTypeDouble", "alias": "UMEQUMULT", "domain": null }, { "name": "UMINSTALLSTAT", "type": "esriFieldTypeSmallInteger", "alias": "UMINSTALLSTAT", "domain": null }, { "name": "umInstallationDate", "type": "esriFieldTypeDate", "alias": "umInstallationDate", "length": 8, "domain": null }, { "name": "umEquipLot", "type": "esriFieldTypeString", "alias": "umEquipLot", "length": 21, "domain": null }, { "name": "umSerialNumber", "type": "esriFieldTypeString", "alias": "umSerialNumber", "length": 31, "domain": null }, { "name": "umRemovalDate", "type": "esriFieldTypeDate", "alias": "umRemovalDate", "length": 8, "domain": null }, { "name": "umDateCreated", "type": "esriFieldTypeDate", "alias": "umDateCreated", "length": 8, "domain": null }, { "name": "umDateModified", "type": "esriFieldTypeDate", "alias": "umDateModified", "length": 8, "domain": null }, { "name": "umManufacturer", "type": "esriFieldTypeString", "alias": "umManufacturer", "length": 31, "domain": null }, { "name": "umDiameterd", "type": "esriFieldTypeDouble", "alias": "umDiameterd", "domain": null }, { "name": "umNumWires", "type": "esriFieldTypeSmallInteger", "alias": "umNumWires", "domain": null }, { "name": "umVoltage", "type": "esriFieldTypeDouble", "alias": "umVoltage", "domain": null }, { "name": "umAmps", "type": "esriFieldTypeDouble", "alias": "umAmps", "domain": null }, { "name": "UMTOTCONSUMP", "type": "esriFieldTypeSmallInteger", "alias": "UMTOTCONSUMP", "domain": null }, { "name": "UMTOTKW", "type": "esriFieldTypeSmallInteger", "alias": "UMTOTKW", "domain": null }, { "name": "UMTOTKVA", "type": "esriFieldTypeSmallInteger", "alias": "UMTOTKVA", "domain": null }, { "name": "umPhysicalLocation", "type": "esriFieldTypeString", "alias": "umPhysicalLocation", "length": 65, "domain": null }, { "name": "umLocator", "type": "esriFieldTypeString", "alias": "umLocator", "length": 21, "domain": null }, { "name": "umGISIdentifier", "type": "esriFieldTypeString", "alias": "umGISIdentifier", "length": 21, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "R180_SDE_ROWID_UK", "fields": "ESRI_OID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_205_umLocati", "fields": "umLocationID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Water.GIS.wMeter", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "umLocationID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 30000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }