{ "currentVersion": 10.91, "id": 0, "name": "Accounts", "type": "Feature Layer", "description": "The accounts are points initially geocoded from active accounts maintained in the utility billing database. Scripts run against copies of utility billing tables every week to remove inactive accounts and update Sanitation Account attributes in the production geodatabase.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276 }, "copyrightText": "Creation of this dataset utilized source data from the City of Longview.", "parentLayer": null, "subLayers": [], "minScale": 150000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "ASSISTED_PICKUP", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "1ef840480f58a96819738322b8e81718", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAUtJREFUKJGVkTFrwlAYRU9CnGqXlykWLIpb6RCSvX9AwRAqjk7pUjp07aIQ1/4Aty7iIlTdnBw6OOgidinOBhweCHEQtOnwGrClS+/24Nzv3cs1+KeM00fiCyfRdxWNfRlwgCjRGB0NWpku6x+Gz1sq8UEOpxuYRNBeQV1geQWCWpEg8YWr9eXcSC/HBzl8+YD7d7h8gNI5jJfQG8BiC6EtZ4kvXGXQd5XpRsFXz5DNqV/Na4hvoP0I1Ty4pmwaABr78iRSl1M4VTYHVgNe38A1cdIOTnulYvylswvVKbSxUkNUF1jjpYrxW3IJdaE41UFj5BUIegOV+TRWvAY5AM9RnAFwNGjVigSLrSpoNVQMuVTwUwlqRSKOomMAZLqsE1+4oS1n1bwq+L0DnqPgBO70dAcArS/niS9c15RN18QJbax0aY6io/flHOAL5Xx8LFYKGA0AAAAASUVORK5CYII=", "contentType": "image/png", "width": 9, "height": 9, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Y", "label": "YES", "description": "" }, { "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 56, 168, 0, 255 ], "size": 7, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "N", "label": "NO", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -1.0558328425646696E7, "ymin": 3820649.939218826, "xmax": -1.0538857823916906E7, "ymax": 3841097.729249565, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "ACCOUNT_NUMBER", "type": "esriFieldTypeDouble", "alias": "ACCOUNT NUMBER", "domain": null }, { "name": "OCCUPANT_CODE", "type": "esriFieldTypeDouble", "alias": "OCCUPANT CODE", "domain": null }, { "name": "ACCOUNT_OCCUPANT", "type": "esriFieldTypeString", "alias": "ACCOUNT AND OCCUPANT", "length": 25, "domain": null }, { "name": "RECYCLING", "type": "esriFieldTypeString", "alias": "RECYCLING", "length": 15, "domain": { "type": "codedValue", "name": "Recycling", "description": "", "codedValues": [ { "name": "BIN", "code": "BIN" }, { "name": "1 CART", "code": "008" }, { "name": "2 CARTS", "code": "008-02" }, { "name": "3 CARTS", "code": "008-03" }, { "name": "4 CARTS", "code": "008-04" }, { "name": "1 COMMERCIAL CART", "code": "007" }, { "name": "2 COMMERCIAL CARTS", "code": "007-02" }, { "name": "3 COMMERCIAL CARTS", "code": "007-03" }, { "name": "4 COMMERCIAL CARTS", "code": "007-04" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RECYCLE_CARTS", "type": "esriFieldTypeSmallInteger", "alias": "RECYCLE CARTS", "domain": null }, { "name": "TRASH_CARTS", "type": "esriFieldTypeSmallInteger", "alias": "TRASH CARTS", "domain": null }, { "name": "ASSISTED_PICKUP", "type": "esriFieldTypeString", "alias": "ASSISTED PICKUP", "length": 5, "domain": { "type": "codedValue", "name": "YesNo_Text", "description": "", "codedValues": [ { "name": "YES", "code": "Y" }, { "name": "NO", "code": "N" }, { "name": "0", "code": "0" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSISTED_COMMENTS", "type": "esriFieldTypeString", "alias": "ASSISTED COMMENTS", "length": 254, "domain": null }, { "name": "STOP", "type": "esriFieldTypeString", "alias": "STOP", "length": 25, "domain": null }, { "name": "SITE_ADDRESS_ASSETID", "type": "esriFieldTypeString", "alias": "SITE ADDRESS ASSETID", "length": 20, "domain": null }, { "name": "FULL_ADDRESS", "type": "esriFieldTypeString", "alias": "FULL ADDRESS", "length": 150, "domain": null }, { "name": "ADDRESS_UNIT", "type": "esriFieldTypeString", "alias": "ADDRESS UNIT", "length": 150, "domain": null }, { "name": "BILL_CODE", "type": "esriFieldTypeString", "alias": "BILL CODE", "length": 6, "domain": { "type": "codedValue", "name": "Billing_Code", "description": "Utility Billing Codes", "codedValues": [ { "name": "NO CHARGE", "code": "000" }, { "name": "5/8\" METER", "code": "001" }, { "name": "1\" METER", "code": "002" }, { "name": "1 1/2\" METER", "code": "003" }, { "name": "2\" METER", "code": "004" }, { "name": "3\" METER", "code": "005" }, { "name": "4\" METER", "code": "006" }, { "name": "6\" METER", "code": "007" }, { "name": "8\" METER", "code": "008" }, { "name": "10\" METER", "code": "009" }, { "name": "FIRE DETECTOR", "code": "010" }, { "name": "5/8\" METER OUTSIDE CITY LIMITS", "code": "011" }, { "name": "HALLSVILLE (CONTRACT)", "code": "012" }, { "name": "MULTI UNIT", "code": "014" }, { "name": "RESISTOL HAT COMPANY", "code": "015" }, { "name": "CITY ACCOUNT", "code": "016" }, { "name": "WHITE OAK (CONTRACT)", "code": "017" }, { "name": "WATER ONLY COMPOUND METERS", "code": "018" }, { "name": "1\" METER OUTSIDE CITY LIMITS", "code": "022" }, { "name": "ELDERVILLE (CONTRACT)", "code": "025" }, { "name": "GUM SPRINGS (CONTRACT)", "code": "026" }, { "name": "1\" SPRINKLER", "code": "027" }, { "name": "1 1/2\" SPRINKLER", "code": "028" }, { "name": "2\" SPRINKLER", "code": "029" }, { "name": "EASTMAN RAW WATER (CONTRACT)", "code": "030" }, { "name": "4\" SPRINKLER", "code": "031" }, { "name": "5/8\" SPRINKLER", "code": "032" }, { "name": "1 1/2\" METER OUTSIDE CITY LIMITS", "code": "033" }, { "name": "3\" SPRINKLER", "code": "035" }, { "name": "6\" SPRINKLER", "code": "037" }, { "name": "EASTMAN RAW WATER (QUARTERLY)", "code": "040" }, { "name": "2\" METER OUTSIDE CITY LIMITS", "code": "044" }, { "name": "3\" METER OUTSIDE CITY LIMITS", "code": "055" }, { "name": "4\" METER OUTSIDE CITY LIMITS", "code": "066" }, { "name": "6\" METER OUTSIDE CITY LIMITS", "code": "077" }, { "name": "8\" METER OUTSIDE CITY LIMITS", "code": "088" }, { "name": "10\" METER OUTSIDE CITY LIMITS", "code": "099" }, { "name": "TRYON ROAD (CONTRACT)", "code": "108" }, { "name": "MULTI UNIT OUTSIDE CITY LIMITS", "code": "114" }, { "name": "1\" SPRINKLER METER OUTSIDE CITY LIMITS", "code": "127" }, { "name": "1 1/2\" SPRINKLER METER OUTSIDE CITY LIMITS", "code": "128" }, { "name": "2\" SPRINKLER METER OUTSIDE CITY LIMITS", "code": "129" }, { "name": "4\" SPRINKLER METER OUTSIDE CITY LIMITS", "code": "131" }, { "name": "5/8\" SPRINKLER METER OUTSIDE CITY LIMITS", "code": "132" }, { "name": "3\" SPRINKLER METER OUTSIDE CITY LIMITS", "code": "135" }, { "name": "6\" SPRINKLER METER OUTSIDE CITY LIMITS", "code": "137" }, { "name": "NO BILL", "code": "NOBILL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "CATEGORY", "length": 2, "domain": { "type": "codedValue", "name": "Billing_Category", "description": "Utility Billing Categories", "codedValues": [ { "name": "CITY SPRINKLER/JOBS", "code": "12" }, { "name": "CONTRACTS", "code": "10" }, { "name": "FIRE HYDRANT METERS", "code": "13" }, { "name": "CITY", "code": "11" }, { "name": "RAW WATER", "code": "08" }, { "name": "APT HOUSES", "code": "07" }, { "name": "HOTEL/MOTEL", "code": "06" }, { "name": "INDUSTRIAL", "code": "05" }, { "name": "SPRINKLER WATER", "code": "04" }, { "name": "COMMERCIAL", "code": "03" }, { "name": "RESIDENTIAL", "code": "01" }, { "name": "MULTI-DWELLING", "code": "02" }, { "name": "FIRE DETECTOR METER", "code": "14" }, { "name": "WASTEHAULER-WWTP", "code": "15" }, { "name": "GREGG INSIDE TAX", "code": "17" }, { "name": "HARRISON OUTSIDE TAX", "code": "16" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "START_DATE", "type": "esriFieldTypeDate", "alias": "START DATE", "length": 8, "domain": null }, { "name": "END_DATE", "type": "esriFieldTypeDate", "alias": "END DATE", "length": 8, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 30, "domain": null }, { "name": "SERV_STREET_NO", "type": "esriFieldTypeDouble", "alias": "SERVICE HOUSE NUMBER", "domain": null }, { "name": "SERV_STREET_MOD", "type": "esriFieldTypeString", "alias": "SERVICE STREET DIRECTION", "length": 1, "domain": null }, { "name": "SERV_STREET", "type": "esriFieldTypeString", "alias": "SERVICE STREET", "length": 20, "domain": null }, { "name": "SERV_UNIT", "type": "esriFieldTypeString", "alias": "SERVICE UNIT NUMBER", "length": 5, "domain": null }, { "name": "SERV_REGION", "type": "esriFieldTypeString", "alias": "SERVICE REGION", "length": 15, "domain": null }, { "name": "SERV_CITY", "type": "esriFieldTypeString", "alias": "SERVICE CITY", "length": 20, "domain": null }, { "name": "SERV_PROVINCE", "type": "esriFieldTypeString", "alias": "SERVICE PROVINCE", "length": 5, "domain": null }, { "name": "SERV_POSTAL_CODE", "type": "esriFieldTypeString", "alias": "SERVICE ZIP", "length": 12, "domain": null }, { "name": "LOT_NO", "type": "esriFieldTypeString", "alias": "LOT NUMBER", "length": 4, "domain": null }, { "name": "PLAN_NO", "type": "esriFieldTypeString", "alias": "PLAN NUMBER", "length": 8, "domain": null }, { "name": "MAIL_ADDR1", "type": "esriFieldTypeString", "alias": "MAIL ADDRESS LINE 1", "length": 60, "domain": null }, { "name": "MAIL_ADDR2", "type": "esriFieldTypeString", "alias": "MAIL ADDRESS LINE 2", "length": 30, "domain": null }, { "name": "MAIL_CITY", "type": "esriFieldTypeString", "alias": "MAIL CITY", "length": 20, "domain": null }, { "name": "MAIL_PROVINCE", "type": "esriFieldTypeString", "alias": "MAIL PROVINCE", "length": 5, "domain": null }, { "name": "MAIL_POSTAL_ZIP", "type": "esriFieldTypeString", "alias": "MAIL POSTAL ZIP", "length": 12, "domain": null }, { "name": "MAIL_POSTAL_MODE", "type": "esriFieldTypeString", "alias": "MAIL POSTAL MODE", "length": 5, "domain": null }, { "name": "HOME_PHONE", "type": "esriFieldTypeString", "alias": "HOME PHONE", "length": 13, "domain": null }, { "name": "BUSINESS_PHONE", "type": "esriFieldTypeString", "alias": "BUSINESS PHONE", "length": 13, "domain": null }, { "name": "TENANT_OWNER", "type": "esriFieldTypeString", "alias": "TENANT OR OWNER", "length": 1, "domain": null }, { "name": "FREQUENCY", "type": "esriFieldTypeInteger", "alias": "FREQUENCY", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "ACCOUNT_NUMBER_4CYCLE", "type": "esriFieldTypeDouble", "alias": "ACCOUNT NUMBER 4CYCLE", "domain": null }, { "name": "OCCUPANT_CODE_4CYCLE", "type": "esriFieldTypeDouble", "alias": "OCCUPANT CODE 4CYCLE", "domain": null }, { "name": "ACCOUNT_OCCUPANT_4CYCLE", "type": "esriFieldTypeString", "alias": "ACCOUNT OCCUPANT 4CYCLE", "length": 25, "domain": null }, { "name": "WATER_SERVICE", "type": "esriFieldTypeString", "alias": "WATER_SERVICE", "length": 3, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "Yes" }, { "name": "NO", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SEWER_SERVICE", "type": "esriFieldTypeString", "alias": "SEWER_SERVICE", "length": 3, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "Yes" }, { "name": "NO", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GARBAGE_SERVICE", "type": "esriFieldTypeString", "alias": "GARBAGE_SERVICE", "length": 3, "domain": { "type": "codedValue", "name": "YesNo_1", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "Yes" }, { "name": "NO", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FREE_PICKUPS_LINK", "type": "esriFieldTypeString", "alias": "FREE PICKUPS LINK", "length": 80, "domain": null }, { "name": "TRASH_ROUTE", "type": "esriFieldTypeString", "alias": "TRASH_ROUTE", "length": 30, "domain": null }, { "name": "RECYCLE_ROUTE", "type": "esriFieldTypeString", "alias": "RECYCLE_ROUTE", "length": 30, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R2089_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2089", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I6189ACCOUNT_NUM", "fields": "ACCOUNT_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I6189OCCUPANT_CO", "fields": "OCCUPANT_CODE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I6189ACCOUNT_OCC", "fields": "ACCOUNT_OCCUPANT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_2089", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S1650_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": true, "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": "20e1beadfe2949f284eebe625acfc9a1" }