{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "WMWD_DATA_WORK.DATAOWNER.Application", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolygon", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 100000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 244, 250, 202, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.30736828266E7, "ymin": 4007087.0978000015, "xmax": -1.30588056728E7, "ymax": 4019426.9004999995, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ApplicationId", "type": "esriFieldTypeString", "alias": "Application Id", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "Status", "description": "Application status", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Ordered", "code": "ORDERED" }, { "name": "In Progress", "code": "INPROGRESS" }, { "name": "Complete Waiting Approval", "code": "COMPLETEWAITINGAPPROVAL" }, { "name": "Complete Waiting Payment", "code": "COMPLETEWAITINGPAYMENT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CustomerType", "type": "esriFieldTypeString", "alias": "Customer Type", "length": 50, "domain": { "type": "codedValue", "name": "CustomerType", "description": "Customer type", "codedValues": [ { "name": "Owner", "code": "Owner" }, { "name": "Developer", "code": "Developer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FirstName", "type": "esriFieldTypeString", "alias": "First Name", "length": 100, "domain": null }, { "name": "LastName", "type": "esriFieldTypeString", "alias": "Last Name", "length": 100, "domain": null }, { "name": "ContactAddress", "type": "esriFieldTypeString", "alias": "Contact Address", "length": 255, "domain": null }, { "name": "ContactZip", "type": "esriFieldTypeString", "alias": "Contact Zip", "length": 25, "domain": null }, { "name": "ContactEmail", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 255, "domain": null }, { "name": "ContactHomePhone", "type": "esriFieldTypeString", "alias": "Contact Home Phone", "length": 25, "domain": null }, { "name": "ContactMobilePhone", "type": "esriFieldTypeString", "alias": "Contact Mobile Phone", "length": 25, "domain": null }, { "name": "ContactFax", "type": "esriFieldTypeString", "alias": "Contact Fax", "length": 25, "domain": null }, { "name": "PadElevation", "type": "esriFieldTypeDouble", "alias": "Pad Elevation", "domain": null }, { "name": "CompanyName", "type": "esriFieldTypeString", "alias": "Company Name", "length": 100, "domain": null }, { "name": "BusinessPhone", "type": "esriFieldTypeString", "alias": "Business Phone", "length": 25, "domain": null }, { "name": "SupFirstName", "type": "esriFieldTypeString", "alias": "Superintendent First Name", "length": 100, "domain": null }, { "name": "SupLastName", "type": "esriFieldTypeString", "alias": "Superintended Last Name", "length": 100, "domain": null }, { "name": "SupBusPhone", "type": "esriFieldTypeString", "alias": "Superintended Business Phone", "length": 25, "domain": null }, { "name": "SupMobilePhone", "type": "esriFieldTypeString", "alias": "Superintendent Mobile Phone", "length": 25, "domain": null }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "Project Name", "length": 255, "domain": null }, { "name": "DateRequested", "type": "esriFieldTypeDate", "alias": "Date Requested", "length": 8, "domain": null }, { "name": "LinkCode", "type": "esriFieldTypeString", "alias": "Link Code", "length": 255, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 1000, "domain": null }, { "name": "APN", "type": "esriFieldTypeString", "alias": "APN", "length": 1000, "domain": null }, { "name": "Tract", "type": "esriFieldTypeString", "alias": "Tract", "length": 1000, "domain": null }, { "name": "Other", "type": "esriFieldTypeString", "alias": "Other", "length": 1000, "domain": null }, { "name": "ApplicationType", "type": "esriFieldTypeString", "alias": "Application Type", "length": 50, "domain": { "type": "codedValue", "name": "ApplicationType", "description": "Application type", "codedValues": [ { "name": "Parcel", "code": "Parcel" }, { "name": "Tract", "code": "Tract" }, { "name": "Commercial Property", "code": "Commercial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "SericeArea", "type": "esriFieldTypeString", "alias": "SericeArea", "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": "SupEmail", "type": "esriFieldTypeString", "alias": "SupEmail", "length": 100, "domain": null }, { "name": "MeterInfo", "type": "esriFieldTypeString", "alias": "MeterInfo", "length": 300, "domain": null }, { "name": "Shape.STArea()", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R361_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S353_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true, "serviceItemId": "09d060e8f26747f6adc81966c703ebda" } ], "tables": [ { "currentVersion": 10.81, "id": 1, "name": "WMWD_DATA_WORK.DATAOWNER.WaterMeterGrid", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Grid", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ID", "domain": null }, { "name": "Grid", "type": "esriFieldTypeInteger", "alias": "Grid", "domain": null }, { "name": "LastAssigned", "type": "esriFieldTypeInteger", "alias": "Last Assigned", "domain": null } ], "indexes": [ { "name": "R384_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" }, { "currentVersion": 10.81, "id": 2, "name": "WMWD_DATA_WORK.DATAOWNER.Quote", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "QuoteId", "type": "esriFieldTypeInteger", "alias": "Quote Id", "domain": null }, { "name": "ApplicationId", "type": "esriFieldTypeString", "alias": "Application Id", "length": 255, "domain": null }, { "name": "MappingFee", "type": "esriFieldTypeDouble", "alias": "Mapping Fee", "domain": null }, { "name": "MWDProcessingFee", "type": "esriFieldTypeDouble", "alias": "MWD Processing Fee", "domain": null }, { "name": "InspectionFee", "type": "esriFieldTypeDouble", "alias": "Inspection Fee", "domain": null }, { "name": "WMWDProcessingFee", "type": "esriFieldTypeDouble", "alias": "WMWD Processing Fee", "domain": null }, { "name": "AnnexationFee", "type": "esriFieldTypeDouble", "alias": "Annexation Fee", "domain": null }, { "name": "MiscFee1", "type": "esriFieldTypeDouble", "alias": "Misc. Fee 1", "domain": null }, { "name": "MiscFee2", "type": "esriFieldTypeDouble", "alias": "Misc. Fee 2", "domain": null }, { "name": "MiscFee3", "type": "esriFieldTypeDouble", "alias": "Misc. Fee 3", "domain": null }, { "name": "CustomerType", "type": "esriFieldTypeString", "alias": "Customer Type", "length": 25, "domain": null }, { "name": "FirstName", "type": "esriFieldTypeString", "alias": "First Name", "length": 100, "domain": null }, { "name": "LastName", "type": "esriFieldTypeString", "alias": "Last Name", "length": 100, "domain": null }, { "name": "ContactAddress", "type": "esriFieldTypeString", "alias": "Contact Address", "length": 255, "domain": null }, { "name": "ContactZip", "type": "esriFieldTypeString", "alias": "Contact Zip", "length": 25, "domain": null }, { "name": "ContactEmail", "type": "esriFieldTypeString", "alias": "Contact Email", "length": 255, "domain": null }, { "name": "ContactHomePhone", "type": "esriFieldTypeString", "alias": "Contact Home Phone", "length": 25, "domain": null }, { "name": "ContactMobilePhone", "type": "esriFieldTypeString", "alias": "Contact Mobile Phone", "length": 25, "domain": null }, { "name": "ContactFax", "type": "esriFieldTypeString", "alias": "Contact Fax", "length": 25, "domain": null }, { "name": "CompanyName", "type": "esriFieldTypeString", "alias": "Company Name", "length": 100, "domain": null }, { "name": "BusinessPhone", "type": "esriFieldTypeString", "alias": "Business Phone", "length": 25, "domain": null }, { "name": "SupFirstName", "type": "esriFieldTypeString", "alias": "Superintendent First Name", "length": 100, "domain": null }, { "name": "SupLastName", "type": "esriFieldTypeString", "alias": "Superintendent Last Name", "length": 100, "domain": null }, { "name": "SupBusPhone", "type": "esriFieldTypeString", "alias": "Superintendent Business Phone", "length": 25, "domain": null }, { "name": "SupMobilePhone", "type": "esriFieldTypeString", "alias": "Superintendent Mobile Phone", "length": 25, "domain": null }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "Project Name", "length": 255, "domain": null }, { "name": "ApplicationType", "type": "esriFieldTypeString", "alias": "ApplicationType", "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": "PadElevation", "type": "esriFieldTypeDouble", "alias": "Pad Elevation", "domain": null }, { "name": "ExportDate", "type": "esriFieldTypeDate", "alias": "Export Date", "length": 8, "domain": null }, { "name": "SupEmail", "type": "esriFieldTypeString", "alias": "SupEmail", "length": 100, "domain": null }, { "name": "MeterInfo", "type": "esriFieldTypeString", "alias": "MeterInfo", "length": 200, "domain": null } ], "indexes": [ { "name": "R363_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 }, "dateFieldsTimeReference": null, "serviceItemId": "09d060e8f26747f6adc81966c703ebda" }, { "currentVersion": 10.81, "id": 3, "name": "WMWD_DATA_WORK.DATAOWNER.MeterFee", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MeterFeeId", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MeterFeeId", "type": "esriFieldTypeInteger", "alias": "Meter Fee Id", "domain": null }, { "name": "MeterId", "type": "esriFieldTypeInteger", "alias": "Meter Id", "domain": null }, { "name": "MeterFee", "type": "esriFieldTypeDouble", "alias": "Meter Fee", "domain": null }, { "name": "HotTap", "type": "esriFieldTypeDouble", "alias": "Hot Tap", "domain": null }, { "name": "MeterReloFee", "type": "esriFieldTypeDouble", "alias": "Meter Relocation Fee", "domain": null }, { "name": "AddedFacilityCharge", "type": "esriFieldTypeDouble", "alias": "Added Facility Charge", "domain": null }, { "name": "PlanCheck", "type": "esriFieldTypeDouble", "alias": "Plan Check", "domain": null }, { "name": "SewerCollection", "type": "esriFieldTypeDouble", "alias": "Sewer Collection", "domain": null }, { "name": "SewerTD", "type": "esriFieldTypeDouble", "alias": "Sewer T and D", "domain": null }, { "name": "StreetPavingFee", "type": "esriFieldTypeDouble", "alias": "Street Paving Fee", "domain": null }, { "name": "SewerConnectionFee", "type": "esriFieldTypeDouble", "alias": "Sewer Connection Fee", "domain": null }, { "name": "PWSA", "type": "esriFieldTypeDouble", "alias": "PWSA", "domain": null }, { "name": "BackflowTestFee", "type": "esriFieldTypeDouble", "alias": "Backflow Test Fee", "domain": null }, { "name": "ResourceMgmtFee", "type": "esriFieldTypeDouble", "alias": "Resource Management Fee", "domain": null }, { "name": "JumperFee", "type": "esriFieldTypeDouble", "alias": "Jumper Fee", "domain": null }, { "name": "MiscFee1", "type": "esriFieldTypeDouble", "alias": "Misc. Fee 1", "domain": null }, { "name": "MiscFee2", "type": "esriFieldTypeDouble", "alias": "Misc. Fee 2", "domain": null }, { "name": "MiscFee3", "type": "esriFieldTypeDouble", "alias": "Misc. Fee 3", "domain": null } ], "indexes": [ { "name": "R364_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" }, { "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" }, { "currentVersion": 10.81, "id": 5, "name": "WMWD_DATA_WORK.DATAOWNER.Location", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PowerZone", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LocationId", "type": "esriFieldTypeInteger", "alias": "Location Id", "domain": null }, { "name": "QuoteId", "type": "esriFieldTypeInteger", "alias": "Quote Id", "domain": null }, { "name": "APN", "type": "esriFieldTypeInteger", "alias": "APN", "domain": null }, { "name": "LocationArea", "type": "esriFieldTypeDouble", "alias": "Location Area", "domain": null }, { "name": "Township", "type": "esriFieldTypeSmallInteger", "alias": "Township", "domain": null }, { "name": "Range", "type": "esriFieldTypeSmallInteger", "alias": "Range", "domain": null }, { "name": "PowerZone", "type": "esriFieldTypeString", "alias": "Power Zone", "length": 50, "domain": null }, { "name": "WaterPressure", "type": "esriFieldTypeString", "alias": "Water Pressure", "length": 25, "domain": { "type": "codedValue", "name": "WaterPressure", "description": "Water pressure", "codedValues": [ { "name": "Low", "code": "Low" }, { "name": "Medium", "code": "Medium" }, { "name": "High", "code": "High" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Well", "type": "esriFieldTypeString", "alias": "Well", "length": 1, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "Route", "type": "esriFieldTypeString", "alias": "Route", "length": 50, "domain": null }, { "name": "Tract", "type": "esriFieldTypeString", "alias": "Tract", "length": 50, "domain": null }, { "name": "Lot", "type": "esriFieldTypeString", "alias": "Lot", "length": 50, "domain": null }, { "name": "PressureZone", "type": "esriFieldTypeSmallInteger", "alias": "Pressure Zone", "domain": { "type": "codedValue", "name": "PressureZone", "description": "Pressure zone", "codedValues": [ { "name": "Pressure Zone 1", "code": 1 }, { "name": "Pressure Zone 2", "code": 2 }, { "name": "Pressure Zone 3", "code": 3 }, { "name": "1515", "code": 1515 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Division", "type": "esriFieldTypeString", "alias": "Division", "length": 2, "domain": { "type": "codedValue", "name": "Division", "description": "Division", "codedValues": [ { "name": "01", "code": "01" }, { "name": "02", "code": "02" }, { "name": "03", "code": "03" }, { "name": "04", "code": "04" }, { "name": "05", "code": "05" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AFCArea", "type": "esriFieldTypeString", "alias": "AFC Area", "length": 25, "domain": { "type": "codedValue", "name": "AFCArea", "description": "AFC Area", "codedValues": [ { "name": "Riverside", "code": "Riverside" }, { "name": "Murrieta", "code": "Murrieta" }, { "name": "Other", "code": "Other" }, { "name": "MARB", "code": "MARB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ParticipationRefund", "type": "esriFieldTypeString", "alias": "Participation Refund", "length": 1, "domain": null }, { "name": "SFRIrrigatedArea", "type": "esriFieldTypeString", "alias": "SFR Irrigation Area", "length": 50, "domain": null }, { "name": "SquareFootage", "type": "esriFieldTypeSmallInteger", "alias": "Square Footage", "domain": null }, { "name": "Section", "type": "esriFieldTypeSmallInteger", "alias": "Section", "domain": null }, { "name": "Microzone", "type": "esriFieldTypeInteger", "alias": "Microzone", "domain": { "type": "codedValue", "name": "Microzone", "description": "Microzone", "codedValues": [ { "name": "Microzone 1", "code": 1 }, { "name": "Microzone 2", "code": 2 }, { "name": "Microzone 3", "code": 3 }, { "name": "10880759", "code": 10880759 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IdNo", "type": "esriFieldTypeString", "alias": "IdNo", "length": 50, "domain": null }, { "name": "OtherLocation", "type": "esriFieldTypeString", "alias": "OtherLocation", "length": 128, "domain": null } ], "indexes": [ { "name": "R366_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" }, { "currentVersion": 10.81, "id": 6, "name": "WMWD_DATA_WORK.DATAOWNER.IdGeneration", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ObjectType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Id", "type": "esriFieldTypeInteger", "alias": "Id", "domain": null }, { "name": "ObjectType", "type": "esriFieldTypeString", "alias": "ObjectType", "length": 25, "domain": null } ], "indexes": [ { "name": "R367_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" }, { "currentVersion": 10.81, "id": 7, "name": "WMWD_DATA_WORK.DATAOWNER.FeeLookup", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Fee", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FeeId", "type": "esriFieldTypeInteger", "alias": "Fee Id", "domain": null }, { "name": "Fee", "type": "esriFieldTypeString", "alias": "Fee", "length": 25, "domain": null }, { "name": "Amount", "type": "esriFieldTypeDouble", "alias": "Amount", "domain": null } ], "indexes": [ { "name": "R368_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": true, "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" } ] }