{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 40, "name": "GIS_EDIT.COTGIS.WTRSAPMETER", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MtrSerial", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "MtrSerial", "type": "esriFieldTypeString", "alias": "MtrSerial", "length": 15, "domain": null }, { "name": "PremNum", "type": "esriFieldTypeString", "alias": "PremNum", "length": 15, "domain": null }, { "name": "MtrServID", "type": "esriFieldTypeString", "alias": "MtrServID", "length": 16, "domain": null }, { "name": "DeviceCat", "type": "esriFieldTypeString", "alias": "DeviceCat", "length": 24, "domain": null }, { "name": "EquipNum", "type": "esriFieldTypeString", "alias": "EquipNum", "length": 15, "domain": null }, { "name": "MtrManuf", "type": "esriFieldTypeString", "alias": "MtrManuf", "length": 25, "domain": { "type": "codedValue", "name": "WtrMeterManuf", "description": "", "codedValues": [ { "name": "A_American", "code": "A_American" }, { "name": "B_Badger", "code": "B_Badger" }, { "name": "C_Carlon", "code": "C_Carlon" }, { "name": "D_Keystone", "code": "D_Keystone" }, { "name": "E_ELSTER", "code": "E_ELSTER" }, { "name": "H_Hersey", "code": "H_Hersey" }, { "name": "K_Kent", "code": "K_Kent" }, { "name": "M_Master Meter Co", "code": "M_Master Meter Co" }, { "name": "M_Metron", "code": "M_Metron" }, { "name": "N_Neptune", "code": "N_Neptune" }, { "name": "P_Pittsburg", "code": "P_Pittsburg" }, { "name": "R_Rockwell", "code": "R_Rockwell" }, { "name": "S_Sensus", "code": "S_Sensus" }, { "name": "S_Sewer", "code": "S_Sewer" }, { "name": "T_Trident", "code": "T_Trident" }, { "name": "W_Worth", "code": "W_Worth" }, { "name": "O_Other", "code": "O_Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MtrModel", "type": "esriFieldTypeString", "alias": "MtrModel", "length": 25, "domain": null }, { "name": "MtrSize", "type": "esriFieldTypeString", "alias": "MtrSize", "length": 6, "domain": { "type": "codedValue", "name": "WtrMeterSize", "description": "", "codedValues": [ { "name": "3/4\"", "code": "3/4\"" }, { "name": "5/8\"", "code": "5/8\"" }, { "name": "1\"", "code": "1\"" }, { "name": "1 1/2\"", "code": "1 1/2\"" }, { "name": "2\"", "code": "2\"" }, { "name": "3\"", "code": "3\"" }, { "name": "4\"", "code": "4\"" }, { "name": "6\"", "code": "6\"" }, { "name": "8\"", "code": "8\"" }, { "name": "10\"", "code": "10\"" }, { "name": "12\"", "code": "12\"" }, { "name": "16\"", "code": "16\"" }, { "name": "20\"", "code": "20\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MtrStatus", "type": "esriFieldTypeString", "alias": "MtrStatus", "length": 4, "domain": { "type": "codedValue", "name": "WtrMeterStat", "description": "", "codedValues": [ { "name": "AVLB", "code": "AVLB" }, { "name": "DLFL", "code": "DLFL" }, { "name": "ESTO", "code": "ESTO" }, { "name": "INST", "code": "INST" }, { "name": "RETD", "code": "RETD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StkRmLoca", "type": "esriFieldTypeString", "alias": "StkRmLoca", "length": 25, "domain": null }, { "name": "Low", "type": "esriFieldTypeDouble", "alias": "Low", "domain": null }, { "name": "Med", "type": "esriFieldTypeDouble", "alias": "Med", "domain": null }, { "name": "High", "type": "esriFieldTypeDouble", "alias": "High", "domain": null }, { "name": "PipeMatCS", "type": "esriFieldTypeInteger", "alias": "PipeMatCS", "domain": null }, { "name": "MtrLat", "type": "esriFieldTypeDouble", "alias": "MtrLat", "domain": null }, { "name": "MtrLong", "type": "esriFieldTypeDouble", "alias": "MtrLong", "domain": null }, { "name": "ManufDate", "type": "esriFieldTypeDate", "alias": "ManufDate", "length": 8, "domain": null }, { "name": "ReceivedDt", "type": "esriFieldTypeDate", "alias": "ReceivedDt", "length": 8, "domain": null }, { "name": "InstallDt", "type": "esriFieldTypeDate", "alias": "InstallDt", "length": 8, "domain": null }, { "name": "WarrntyDt", "type": "esriFieldTypeDate", "alias": "WarrntyDt", "length": 8, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 12, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 12, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "PK_WTRSAPMETER", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R1592_SDE_ROWID_UK", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_30441_PremNu", "fields": "PremNum", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Premise", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PremNum", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }