{ "currentVersion": 10.81, "id": 4, "name": "WMWD_DATA_WORK.DATAOWNER.Meter", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MeterId", "type": "esriFieldTypeInteger", "alias": "Meter Id", "domain": null }, { "name": "LocationId", "type": "esriFieldTypeInteger", "alias": "Location Id", "domain": null }, { "name": "PadElevation", "type": "esriFieldTypeString", "alias": "Pad Elevation", "length": 25, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 25, "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" } }, { "name": "SewerEDU", "type": "esriFieldTypeDouble", "alias": "Sewer EDU", "domain": null }, { "name": "Size", "type": "esriFieldTypeString", "alias": "Size", "length": 10, "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" } }, { "name": "InstallType", "type": "esriFieldTypeString", "alias": "Installation Type", "length": 25, "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" } }, { "name": "GridNo", "type": "esriFieldTypeInteger", "alias": "Grid", "domain": null }, { "name": "SewerRate", "type": "esriFieldTypeString", "alias": "Sewer Rate", "length": 25, "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" } }, { "name": "CityTax", "type": "esriFieldTypeString", "alias": "City Tax", "length": 1, "domain": null }, { "name": "BackFlow", "type": "esriFieldTypeString", "alias": "Back Flow", "length": 1, "domain": null }, { "name": "Account", "type": "esriFieldTypeString", "alias": "Account", "length": 25, "domain": null }, { "name": "WorkOrder", "type": "esriFieldTypeInteger", "alias": "Work Order", "domain": null }, { "name": "Phase", "type": "esriFieldTypeInteger", "alias": "Phase", "domain": null }, { "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" } }, { "name": "LateralSize", "type": "esriFieldTypeDouble", "alias": "Lateral Size", "domain": null }, { "name": "MeterCode", "type": "esriFieldTypeString", "alias": "Meter Code", "length": 1, "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" } }, { "name": "WaterBillCode", "type": "esriFieldTypeString", "alias": "Water Bill Code", "length": 3, "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" } }, { "name": "CostCenter", "type": "esriFieldTypeString", "alias": "Cost Center", "length": 50, "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" } }, { "name": "HouseNumber", "type": "esriFieldTypeString", "alias": "House Number", "length": 10, "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "Street Name", "length": 50, "domain": null }, { "name": "StreetSuffix", "type": "esriFieldTypeString", "alias": "Street Suffix", "length": 25, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 50, "domain": null }, { "name": "Zip", "type": "esriFieldTypeString", "alias": "Zip", "length": 10, "domain": null }, { "name": "ExtensionNo", "type": "esriFieldTypeString", "alias": "ExtensionNo", "length": 50, "domain": null }, { "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" } }, { "name": "Grid", "type": "esriFieldTypeString", "alias": "Grid", "length": 75, "domain": null }, { "name": "MeterName", "type": "esriFieldTypeString", "alias": "Meter Name", "length": 50, "domain": null }, { "name": "AccountTypeCode", "type": "esriFieldTypeString", "alias": "AccountTypeCode", "length": 50, "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" } }, { "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" } }, { "name": "ServiceArea", "type": "esriFieldTypeString", "alias": "ServiceArea", "length": 50, "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" } }, { "name": "RouteNumber", "type": "esriFieldTypeString", "alias": "RouteNumber", "length": 30, "domain": null } ], "indexes": [ { "name": "R365_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }, "serviceItemId": "09d060e8f26747f6adc81966c703ebda" }