{ "currentVersion": 10.81, "id": 4, "name": "WMWD_DATA_WORK.DATAOWNER.Meter", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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": "StreetName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MeterId", "type": "esriFieldTypeInteger", "alias": "Meter Id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "MeterId" }, { "name": "LocationId", "type": "esriFieldTypeInteger", "alias": "Location Id", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "LocationId" }, { "name": "PadElevation", "type": "esriFieldTypeString", "alias": "Pad Elevation", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PadElevation" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "MeterType", "description": "Meter type", "codedValues": [ { "name": "Irrigation", "code": "Irrigation" }, { "name": "Fire Service", "code": "Fire Service" }, { "name": "Domestic", "code": "Domestic" }, { "name": "Landscape", "code": "Landscape" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Type" }, { "name": "SewerEDU", "type": "esriFieldTypeDouble", "alias": "Sewer EDU", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SewerEDU" }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "domain": { "type": "codedValue", "name": "MeterSize", "description": "Meter Size", "codedValues": [ { "name": "3/4", "code": "3/4" }, { "name": "1", "code": "1" }, { "name": "1.5", "code": "1.5" }, { "name": "2", "code": "2" }, { "name": "2.5", "code": "2.5" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "6", "code": "6" }, { "name": "8", "code": "8" }, { "name": "10", "code": "10" }, { "name": "12", "code": "12" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Size" }, { "name": "InstallType", "type": "esriFieldTypeString", "alias": "Installation Type", "domain": { "type": "codedValue", "name": "InstallType", "description": "Installation Type", "codedValues": [ { "name": "Hot Tap", "code": "Hot Tap" }, { "name": "Drop In", "code": "Drop In" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "InstallType" }, { "name": "GridNo", "type": "esriFieldTypeInteger", "alias": "Grid", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Grid" }, { "name": "SewerRate", "type": "esriFieldTypeString", "alias": "Sewer Rate", "domain": { "type": "codedValue", "name": "SewerRate", "description": "Sewer Rate", "codedValues": [ { "name": "SWR", "code": "SWR" }, { "name": "SRC", "code": "SRC" }, { "name": "SOC", "code": "SOC" }, { "name": "SER", "code": "SER" }, { "name": "SUR", "code": "SUR" }, { "name": "SMR", "code": "SMR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SewerRate" }, { "name": "CityTax", "type": "esriFieldTypeString", "alias": "City Tax", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "CityTax" }, { "name": "BackFlow", "type": "esriFieldTypeString", "alias": "Back Flow", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "BackFlow" }, { "name": "Account", "type": "esriFieldTypeString", "alias": "Account", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Account" }, { "name": "WorkOrder", "type": "esriFieldTypeInteger", "alias": "Work Order", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkOrder" }, { "name": "Phase", "type": "esriFieldTypeInteger", "alias": "Phase", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "UserCode", "type": "esriFieldTypeSmallInteger", "alias": "User Code", "domain": { "type": "codedValue", "name": "UserCode", "description": "User code", "codedValues": [ { "name": "Single Family Residential", "code": 101 }, { "name": "Multiple Family Residential", "code": 102 }, { "name": "Domestic Non Potable", "code": 110 }, { "name": "Commercial", "code": 211 }, { "name": "Manufacturing", "code": 303 }, { "name": "Restaurants", "code": 404 }, { "name": "WMWD Accounts", "code": 500 }, { "name": "Schools (Nursery)", "code": 501 }, { "name": "Membership Organizations", "code": 502 }, { "name": "Park Restrooms", "code": 505 }, { "name": "Religous Organization", "code": 506 }, { "name": "WMWD Production Meters", "code": 550 }, { "name": "Sewer Only", "code": 701 }, { "name": "Schools", "code": 801 }, { "name": "Fire Protection", "code": 900 }, { "name": "Wholesale Water", "code": 902 }, { "name": "Hydrants", "code": 905 }, { "name": "IAWP AG Potable", "code": 909 }, { "name": "IAWP AG Non Potable", "code": 910 }, { "name": "Non-IAWP AG Potable", "code": 919 }, { "name": "Non-IAWP Non-Potable", "code": 920 }, { "name": "AG Compulsory Opt Out Potable", "code": 929 }, { "name": "AG Compulsory Opt Out Non-Potable", "code": 930 }, { "name": "Landscape-Irrigation Non-Potable", "code": 998 }, { "name": "Landscape-Irrigation Potable", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UserCode" }, { "name": "LateralSize", "type": "esriFieldTypeDouble", "alias": "Lateral Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LateralSize" }, { "name": "MeterCode", "type": "esriFieldTypeString", "alias": "Meter Code", "domain": { "type": "codedValue", "name": "MeterCode", "description": "Meter Code", "codedValues": [ { "name": "0", "code": "0" }, { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "H", "code": "H" }, { "name": "5", "code": "5" }, { "name": "6", "code": "6" }, { "name": "7", "code": "7" }, { "name": "8", "code": "8" }, { "name": "9", "code": "9" }, { "name": "A", "code": "A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "MeterCode" }, { "name": "WaterBillCode", "type": "esriFieldTypeString", "alias": "Water Bill Code", "domain": { "type": "codedValue", "name": "WaterBillCode", "description": "Water Bill Code", "codedValues": [ { "name": "Riverside treated", "code": "RT" }, { "name": "Riverside untreated", "code": "NU" }, { "name": "Riverside temporary connection treated", "code": "RB" }, { "name": "Riverside key meters treated", "code": "RK" }, { "name": "March treated", "code": "MT" }, { "name": "Murrieta treated", "code": "UT" }, { "name": "Rainbow treated", "code": "RL" }, { "name": "Riverside untreated", "code": "NL" }, { "name": "March treated", "code": "ML" }, { "name": "Murrieta treated", "code": "UL" }, { "name": "Rainbow treated", "code": "AL" }, { "name": "Rock Mountain treated", "code": "CL" }, { "name": "Riverside treated", "code": "FR" }, { "name": "March treated", "code": "FM" }, { "name": "Murrieta treated 5/8 DC", "code": "FU" }, { "name": "Murrieta treated 3/4 DC; other", "code": "FW" }, { "name": "Rainbow treated", "code": "FA" }, { "name": "Rainbow treated", "code": "AT" }, { "name": "Rock Mountain treated", "code": "CT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "WaterBillCode" }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "domain": { "type": "codedValue", "name": "MeterFeeCostCenter", "description": "CostCneterMeter", "codedValues": [ { "name": "200 - Riverside Treated Water", "code": "200" }, { "name": "210 - Riverside Untreated Water", "code": "210" }, { "name": "220 - March East Water", "code": "220" }, { "name": "230 - Murrieta Treated Water", "code": "230" }, { "name": "240 - Rainbow / Rock Mtn Water", "code": "240" }, { "name": "310 - WRCRWA Wastewater", "code": "310" }, { "name": "320 - WWRF Treatment Plant", "code": "320" }, { "name": "330 - WWRF Conveyance East", "code": "330" }, { "name": "340 - WWRF Conveyance West", "code": "340" }, { "name": "350 - Murrieta Wastewater", "code": "350" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CostCenter" }, { "name": "HouseNumber", "type": "esriFieldTypeString", "alias": "House Number", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "HouseNumber" }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "Street Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StreetName" }, { "name": "StreetSuffix", "type": "esriFieldTypeString", "alias": "Street Suffix", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "StreetSuffix" }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "City" }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "State" }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Zip" }, { "name": "ExtensionNo", "type": "esriFieldTypeString", "alias": "ExtensionNo", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ExtensionNo" }, { "name": "WaterOrSewer", "type": "esriFieldTypeSmallInteger", "alias": "WaterOrSewer", "domain": { "type": "codedValue", "name": "WaterOrSewer", "description": "Water or Sewer", "codedValues": [ { "name": "Water", "code": 1 }, { "name": "Sewer", "code": 2 }, { "name": "Both", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WaterOrSewer" }, { "name": "Grid", "type": "esriFieldTypeString", "alias": "Grid", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "Grid" }, { "name": "MeterName", "type": "esriFieldTypeString", "alias": "Meter Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MeterName" }, { "name": "AccountTypeCode", "type": "esriFieldTypeString", "alias": "AccountTypeCode", "domain": { "type": "codedValue", "name": "AccountTypes", "description": "Account types", "codedValues": [ { "name": "Commercial", "code": "CO" }, { "name": "Wholesale", "code": "WO" }, { "name": "Multi Family", "code": "MF" }, { "name": "Single Family", "code": "RE" }, { "name": "Industrial", "code": "WN" }, { "name": "Hydrant Meter", "code": "HY" }, { "name": "Sewer Only", "code": "SO" }, { "name": "Military", "code": "ML" }, { "name": "AFVW", "code": "AF" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AccountTypeCode" }, { "name": "ServiceBillCode", "type": "esriFieldTypeSmallInteger", "alias": "ServiceBillCode", "domain": { "type": "codedValue", "name": "ServiceCodes", "description": "Service codes", "codedValues": [ { "name": "Domestic", "code": 30 }, { "name": "Landscape", "code": 31 }, { "name": "Fireline", "code": 32 }, { "name": "Wastewater", "code": 40 }, { "name": "Temporary", "code": 33 }, { "name": "Agricultural", "code": 34 }, { "name": "WholeSale", "code": 35 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ServiceBillCode" }, { "name": "ServiceArea", "type": "esriFieldTypeString", "alias": "ServiceArea", "domain": { "type": "codedValue", "name": "ServiceAreaMFA", "description": "", "codedValues": [ { "name": "Riverside", "code": "Riverside" }, { "name": "Murrieta", "code": "Murrieta" }, { "name": "MARB", "code": "MARB" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ServiceArea" }, { "name": "RouteNumber", "type": "esriFieldTypeString", "alias": "RouteNumber", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "RouteNumber" } ], "indexes": [ { "name": "R365_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "WMWD_DATA_WORK.DATAOWNER.Meter", "description": "", "prototype": { "attributes": { "ServiceArea": null, "RouteNumber": null, "MeterId": 0, "LocationId": 0, "PadElevation": null, "Type": null, "SewerEDU": null, "Size": null, "InstallType": null, "GridNo": null, "SewerRate": null, "CityTax": null, "BackFlow": null, "Account": null, "WorkOrder": null, "Phase": null, "UserCode": null, "LateralSize": null, "MeterCode": null, "WaterBillCode": null, "CostCenter": null, "HouseNumber": null, "StreetName": null, "StreetSuffix": null, "City": null, "State": null, "Zip": null, "ExtensionNo": null, "WaterOrSewer": null, "Grid": null, "MeterName": null, "AccountTypeCode": null, "ServiceBillCode": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "f8268af4ae014d26a686bab9f356444b" }