{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 40, "name": "GIS_EDIT.COTGIS.WTRSAPMETER", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Premise", "relatedTableId": 37, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PremNum", "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, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID_1", "globalIdField": "", "displayField": "MtrSerial", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID_1" }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MtrSerial", "type": "esriFieldTypeString", "alias": "MtrSerial", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MtrSerial" }, { "name": "PremNum", "type": "esriFieldTypeString", "alias": "PremNum", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PremNum" }, { "name": "MtrServID", "type": "esriFieldTypeString", "alias": "MtrServID", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "MtrServID" }, { "name": "DeviceCat", "type": "esriFieldTypeString", "alias": "DeviceCat", "domain": null, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "DeviceCat" }, { "name": "EquipNum", "type": "esriFieldTypeString", "alias": "EquipNum", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "EquipNum" }, { "name": "MtrManuf", "type": "esriFieldTypeString", "alias": "MtrManuf", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MtrManuf" }, { "name": "MtrModel", "type": "esriFieldTypeString", "alias": "MtrModel", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MtrModel" }, { "name": "MtrSize", "type": "esriFieldTypeString", "alias": "MtrSize", "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" }, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "MtrSize" }, { "name": "MtrStatus", "type": "esriFieldTypeString", "alias": "MtrStatus", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "MtrStatus" }, { "name": "StkRmLoca", "type": "esriFieldTypeString", "alias": "StkRmLoca", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "StkRmLoca" }, { "name": "Low", "type": "esriFieldTypeDouble", "alias": "Low", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Low" }, { "name": "Med", "type": "esriFieldTypeDouble", "alias": "Med", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Med" }, { "name": "High", "type": "esriFieldTypeDouble", "alias": "High", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "High" }, { "name": "PipeMatCS", "type": "esriFieldTypeInteger", "alias": "PipeMatCS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PipeMatCS" }, { "name": "MtrLat", "type": "esriFieldTypeDouble", "alias": "MtrLat", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MtrLat" }, { "name": "MtrLong", "type": "esriFieldTypeDouble", "alias": "MtrLong", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MtrLong" }, { "name": "ManufDate", "type": "esriFieldTypeDate", "alias": "ManufDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ManufDate" }, { "name": "ReceivedDt", "type": "esriFieldTypeDate", "alias": "ReceivedDt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ReceivedDt" }, { "name": "InstallDt", "type": "esriFieldTypeDate", "alias": "InstallDt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDt" }, { "name": "WarrntyDt", "type": "esriFieldTypeDate", "alias": "WarrntyDt", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrntyDt" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GIS_EDIT.COTGIS.WTRSAPMETER", "description": "", "prototype": { "attributes": { "last_edited_user": null, "last_edited_date": null, "OBJECTID": 0, "MtrSerial": null, "PremNum": null, "MtrServID": null, "DeviceCat": null, "EquipNum": null, "MtrManuf": null, "MtrModel": null, "MtrSize": null, "MtrStatus": null, "StkRmLoca": null, "Low": null, "Med": null, "High": null, "PipeMatCS": null, "MtrLat": null, "MtrLong": null, "ManufDate": null, "ReceivedDt": null, "InstallDt": null, "WarrntyDt": null, "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }