{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "premnum", "role": "esriRelRoleDestination", "composite": false, "name": "Premise", "relatedTableId": 37, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 29, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wtrSAPMeter", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "devicecat": null, "installtype": null, "receiveddt": null, "mtrmanuf": null, "equipnum": null, "mtrlat": null, "warrntydt": null, "med": null, "manufdate": null, "installdt": null, "high": null, "low": null, "mtrlong": null, "premnum": null, "mtrsize": null, "last_edited_date": null, "installnum": null, "mtrstatus": null, "created_user": null, "ratecat": null, "mtrservid": null, "mtrserial": null, "pipematcs": null, "last_edited_user": null, "mtrmodel": null, "stkrmloca": null, "created_date": null, "objectid": 0 } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid_1", "supportsQuantizationEditMode": true, "name": "wtrSAPMeter", "displayField": "mtrserial", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeInteger" }, { "modelName": "devicecat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "devicecat", "length": 24, "alias": "DeviceCat", "type": "esriFieldTypeString" }, { "modelName": "equipnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipnum", "length": 15, "alias": "Unique Identifier", "type": "esriFieldTypeString" }, { "modelName": "created_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_user", "length": 12, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 12, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID_1", "domain": null, "name": "objectid_1", "alias": "OBJECTID_1" }, { "modelName": "mtrserial", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrserial", "length": 15, "alias": "MtrSerial", "type": "esriFieldTypeString" }, { "modelName": "premnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "premnum", "length": 15, "alias": "PremNum", "type": "esriFieldTypeString" }, { "modelName": "mtrservid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrservid", "length": 16, "alias": "MtrServID", "type": "esriFieldTypeString" }, { "modelName": "MtrManuf", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrMeterManuf", "description": "", "type": "codedValue", "codedValues": [ { "code": "A_American", "name": "A_American" }, { "code": "B_Badger", "name": "B_Badger" }, { "code": "C_Carlon", "name": "C_Carlon" }, { "code": "D_Keystone", "name": "D_Keystone" }, { "code": "E_ELSTER", "name": "E_ELSTER" }, { "code": "H_Hersey", "name": "H_Hersey" }, { "code": "K_Kent", "name": "K_Kent" }, { "code": "M_Master Meter Co", "name": "M_Master Meter Co" }, { "code": "M_Metron", "name": "M_Metron" }, { "code": "N_Neptune", "name": "N_Neptune" }, { "code": "P_Pittsburg", "name": "P_Pittsburg" }, { "code": "R_Rockwell", "name": "R_Rockwell" }, { "code": "S_Sensus", "name": "S_Sensus" }, { "code": "S_Sewer", "name": "S_Sewer" }, { "code": "T_Trident", "name": "T_Trident" }, { "code": "W_Worth", "name": "W_Worth" }, { "code": "O_Other", "name": "O_Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mtrmanuf", "length": 25, "alias": "MtrManuf", "type": "esriFieldTypeString" }, { "modelName": "mtrmodel", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrmodel", "length": 25, "alias": "MtrModel", "type": "esriFieldTypeString" }, { "modelName": "MtrSize", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrMeterSize", "description": "", "type": "codedValue", "codedValues": [ { "code": "3/4\"", "name": "3/4\"" }, { "code": "5/8\"", "name": "5/8\"" }, { "code": "1\"", "name": "1\"" }, { "code": "1 1/2\"", "name": "1 1/2\"" }, { "code": "2\"", "name": "2\"" }, { "code": "3\"", "name": "3\"" }, { "code": "4\"", "name": "4\"" }, { "code": "6\"", "name": "6\"" }, { "code": "8\"", "name": "8\"" }, { "code": "10\"", "name": "10\"" }, { "code": "12\"", "name": "12\"" }, { "code": "16\"", "name": "16\"" }, { "code": "20\"", "name": "20\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mtrsize", "length": 6, "alias": "MtrSize", "type": "esriFieldTypeString" }, { "modelName": "MtrStatus", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrMeterStat", "description": "", "type": "codedValue", "codedValues": [ { "code": "AVLB", "name": "AVLB" }, { "code": "DLFL", "name": "DLFL" }, { "code": "ESTO", "name": "ESTO" }, { "code": "INST", "name": "INST" }, { "code": "RETD", "name": "RETD" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mtrstatus", "length": 4, "alias": "MtrStatus", "type": "esriFieldTypeString" }, { "modelName": "stkrmloca", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stkrmloca", "length": 25, "alias": "StkRmLoca", "type": "esriFieldTypeString" }, { "modelName": "low", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "low", "alias": "Low", "type": "esriFieldTypeDouble" }, { "modelName": "med", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "med", "alias": "Med", "type": "esriFieldTypeDouble" }, { "modelName": "high", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "high", "alias": "High", "type": "esriFieldTypeDouble" }, { "modelName": "pipematcs", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipematcs", "alias": "PipeMatCS", "type": "esriFieldTypeInteger" }, { "modelName": "mtrlat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrlat", "alias": "MtrLat", "type": "esriFieldTypeDouble" }, { "modelName": "mtrlong", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrlong", "alias": "MtrLong", "type": "esriFieldTypeDouble" }, { "modelName": "manufdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manufdate", "length": 29, "alias": "ManufDate", "type": "esriFieldTypeDate" }, { "modelName": "receiveddt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "receiveddt", "length": 29, "alias": "ReceivedDt", "type": "esriFieldTypeDate" }, { "modelName": "installdt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installdt", "length": 29, "alias": "InstallDt", "type": "esriFieldTypeDate" }, { "modelName": "warrntydt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "warrntydt", "length": 29, "alias": "WarrntyDt", "type": "esriFieldTypeDate" }, { "modelName": "InstallNum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installnum", "length": 20, "alias": "InstallNum", "type": "esriFieldTypeString" }, { "modelName": "installtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installtype", "length": 20, "alias": "InstallType", "type": "esriFieldTypeString" }, { "modelName": "ratecat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ratecat", "length": 10, "alias": "RateCat", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g1365premnum", "isUnique": false, "description": "", "fields": "premnum", "isAscending": true }, { "name": "i1365objectid", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "r425_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_1", "isAscending": true }, { "name": "uuid_425", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "eef310124b8f4299aae27a1d5f4bcb8d", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Uploads,Query,Update,Delete", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }