View In:   ArcGIS Online Map Viewer

Name: Accounts

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

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.

Service Item Id: db86f85ba1ed4c119f512497ad6a8c49

Copyright Text: Creation of this dataset utilized source data from the City of Longview.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 150000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -1.0558328425646696E7
YMin: 3820649.939218826
XMax: -1.0538857823916906E7
YMax: 3841097.729249565
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ASSISTED_PICKUP
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Y
  Label: YES
  Description:
  Symbol:
  
• Value: N
  Label: NO
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [56, 168, 0, 255]
  Size: 7.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSISTED_PICKUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSETID )
• ACCOUNT_NUMBER ( type: esriFieldTypeDouble, alias: ACCOUNT NUMBER, editable: true, nullable: true, defaultValue: null, modelName: ACCOUNT_NUMBER )
• OCCUPANT_CODE ( type: esriFieldTypeDouble, alias: OCCUPANT CODE, editable: true, nullable: true, defaultValue: null, modelName: MAX_occupant_code )
• ACCOUNT_OCCUPANT ( type: esriFieldTypeString, alias: ACCOUNT AND OCCUPANT, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LAST_ACCOUNT_OCCUPANT )
• RECYCLING ( type: esriFieldTypeString, alias: RECYCLING, editable: true, nullable: true, length: 15, defaultValue: null, modelName: RECYCLING , Coded Values: [BIN: BIN] , [008: 1 CART] , [008-02: 2 CARTS] , ...6 more... )
• RECYCLE_CARTS ( type: esriFieldTypeSmallInteger, alias: RECYCLE CARTS, editable: true, nullable: true, defaultValue: null, modelName: RECYCLE_CARTS )
• TRASH_CARTS ( type: esriFieldTypeSmallInteger, alias: TRASH CARTS, editable: true, nullable: true, defaultValue: null, modelName: TRASH_CARTS )
• ASSISTED_PICKUP ( type: esriFieldTypeString, alias: ASSISTED PICKUP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ASSISTED_PICKUP , Coded Values: [Y: YES] , [N: NO] , [0: 0] , ...1 more... )
• ASSISTED_COMMENTS ( type: esriFieldTypeString, alias: ASSISTED COMMENTS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ASSISTED_COMMENTS )
• STOP ( type: esriFieldTypeString, alias: STOP, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STOP )
• SITE_ADDRESS_ASSETID ( type: esriFieldTypeString, alias: SITE ADDRESS ASSETID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITE_ADDRESS_ASSETID )
• FULL_ADDRESS ( type: esriFieldTypeString, alias: FULL ADDRESS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FULL_ADDRESS )
• ADDRESS_UNIT ( type: esriFieldTypeString, alias: ADDRESS UNIT, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Address_Unit )
• BILL_CODE ( type: esriFieldTypeString, alias: BILL CODE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: bill_code , Coded Values: [000: NO CHARGE] , [001: 5/8" METER] , [002: 1" METER] , ...44 more... )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, editable: true, nullable: true, length: 2, defaultValue: null, modelName: category , Coded Values: [12: CITY SPRINKLER/JOBS] , [10: CONTRACTS] , [13: FIRE HYDRANT METERS] , ...13 more... )
• START_DATE ( type: esriFieldTypeDate, alias: START DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: start_date )
• END_DATE ( type: esriFieldTypeDate, alias: END DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: end_date )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: name )
• SERV_STREET_NO ( type: esriFieldTypeDouble, alias: SERVICE HOUSE NUMBER, editable: true, nullable: true, defaultValue: null, modelName: serv_street_no )
• SERV_STREET_MOD ( type: esriFieldTypeString, alias: SERVICE STREET DIRECTION, editable: true, nullable: true, length: 1, defaultValue: null, modelName: serv_street_mod )
• SERV_STREET ( type: esriFieldTypeString, alias: SERVICE STREET, editable: true, nullable: true, length: 20, defaultValue: null, modelName: serv_street )
• SERV_UNIT ( type: esriFieldTypeString, alias: SERVICE UNIT NUMBER, editable: true, nullable: true, length: 5, defaultValue: null, modelName: serv_unit )
• SERV_REGION ( type: esriFieldTypeString, alias: SERVICE REGION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: serv_region )
• SERV_CITY ( type: esriFieldTypeString, alias: SERVICE CITY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: serv_city )
• SERV_PROVINCE ( type: esriFieldTypeString, alias: SERVICE PROVINCE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: serv_province )
• SERV_POSTAL_CODE ( type: esriFieldTypeString, alias: SERVICE ZIP, editable: true, nullable: true, length: 12, defaultValue: null, modelName: serv_postal_zip )
• LOT_NO ( type: esriFieldTypeString, alias: LOT NUMBER, editable: true, nullable: true, length: 4, defaultValue: null, modelName: lot_no )
• PLAN_NO ( type: esriFieldTypeString, alias: PLAN NUMBER, editable: true, nullable: true, length: 8, defaultValue: null, modelName: plan_no )
• MAIL_ADDR1 ( type: esriFieldTypeString, alias: MAIL ADDRESS LINE 1, editable: true, nullable: true, length: 60, defaultValue: null, modelName: mail_addr1 )
• MAIL_ADDR2 ( type: esriFieldTypeString, alias: MAIL ADDRESS LINE 2, editable: true, nullable: true, length: 30, defaultValue: null, modelName: mail_addr2 )
• MAIL_CITY ( type: esriFieldTypeString, alias: MAIL CITY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: mail_city )
• MAIL_PROVINCE ( type: esriFieldTypeString, alias: MAIL PROVINCE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: mail_province )
• MAIL_POSTAL_ZIP ( type: esriFieldTypeString, alias: MAIL POSTAL ZIP, editable: true, nullable: true, length: 12, defaultValue: null, modelName: mail_postal_zip )
• MAIL_POSTAL_MODE ( type: esriFieldTypeString, alias: MAIL POSTAL MODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: mail_postal_mode )
• HOME_PHONE ( type: esriFieldTypeString, alias: HOME PHONE, editable: true, nullable: true, length: 13, defaultValue: null, modelName: home_phone )
• BUSINESS_PHONE ( type: esriFieldTypeString, alias: BUSINESS PHONE, editable: true, nullable: true, length: 13, defaultValue: null, modelName: business_phone )
• TENANT_OWNER ( type: esriFieldTypeString, alias: TENANT OR OWNER, editable: true, nullable: true, length: 1, defaultValue: null, modelName: tenant_owner )
• FREQUENCY ( type: esriFieldTypeInteger, alias: FREQUENCY, editable: true, nullable: true, defaultValue: null, modelName: FREQUENCY )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ACCOUNT_NUMBER_4CYCLE ( type: esriFieldTypeDouble, alias: ACCOUNT NUMBER 4CYCLE, editable: true, nullable: true, defaultValue: null, modelName: ACCOUNT_NUMBER_4CYCLE )
• OCCUPANT_CODE_4CYCLE ( type: esriFieldTypeDouble, alias: OCCUPANT CODE 4CYCLE, editable: true, nullable: true, defaultValue: null, modelName: OCCUPANT_CODE_4CYCLE )
• ACCOUNT_OCCUPANT_4CYCLE ( type: esriFieldTypeString, alias: ACCOUNT OCCUPANT 4CYCLE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ACCOUNT_OCCUPANT_4CYCLE )
• WATER_SERVICE ( type: esriFieldTypeString, alias: WATER_SERVICE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: WATER_SERVICE , Coded Values: [Yes: YES] , [No: NO] )
• SEWER_SERVICE ( type: esriFieldTypeString, alias: SEWER_SERVICE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SEWER_SERVICE , Coded Values: [Yes: YES] , [No: NO] )
• GARBAGE_SERVICE ( type: esriFieldTypeString, alias: GARBAGE_SERVICE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: GARBAGE_SERVICE , Coded Values: [Yes: YES] , [No: NO] )
• FREE_PICKUPS_LINK ( type: esriFieldTypeString, alias: FREE PICKUPS LINK, editable: true, nullable: true, length: 80, defaultValue: null, modelName: FREE_PIICKUPS_LINK )
• TRASH_ROUTE ( type: esriFieldTypeString, alias: TRASH_ROUTE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TRASH_ROUTE )
• RECYCLE_ROUTE ( type: esriFieldTypeString, alias: RECYCLE_ROUTE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: RECYCLE_ROUTE )

Types:

ID: Y
Name: Y
Domains:
• RECYCLING:
  Inherited
• ASSISTED_PICKUP:
  Inherited
• BILL_CODE:
  Inherited
• CATEGORY:
  Inherited
• WATER_SERVICE:
  Inherited
• SEWER_SERVICE:
  Inherited
• GARBAGE_SERVICE:
  Inherited
Templates:
• Name: YES
  Description:
  Prototype:
  TRASH_CARTS: null
  TRASH_ROUTE: null
  ASSETID: null
  ACCOUNT_NUMBER: null
  OCCUPANT_CODE: null
  ACCOUNT_OCCUPANT: null
  RECYCLING: null
  RECYCLE_CARTS: null
  ASSISTED_PICKUP: Y
  ASSISTED_COMMENTS: null
  STOP: null
  SITE_ADDRESS_ASSETID: null
  FULL_ADDRESS: null
  ADDRESS_UNIT: null
  BILL_CODE: null
  CATEGORY: null
  START_DATE: null
  END_DATE: null
  NAME: null
  SERV_STREET_NO: null
  SERV_STREET_MOD: null
  SERV_STREET: null
  SERV_UNIT: null
  SERV_REGION: null
  SERV_CITY: null
  SERV_PROVINCE: null
  SERV_POSTAL_CODE: null
  LOT_NO: null
  PLAN_NO: null
  MAIL_ADDR1: null
  MAIL_ADDR2: null
  MAIL_CITY: null
  MAIL_PROVINCE: null
  MAIL_POSTAL_ZIP: null
  MAIL_POSTAL_MODE: null
  HOME_PHONE: null
  BUSINESS_PHONE: null
  TENANT_OWNER: null
  FREQUENCY: null
  FREE_PICKUPS_LINK: null
  GARBAGE_SERVICE: null
  SEWER_SERVICE: null
  WATER_SERVICE: null
  RECYCLE_ROUTE: null
  ACCOUNT_NUMBER_4CYCLE: null
  OCCUPANT_CODE_4CYCLE: null
  ACCOUNT_OCCUPANT_4CYCLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: N
Name: N
Domains:
• RECYCLING:
  Inherited
• ASSISTED_PICKUP:
  Inherited
• BILL_CODE:
  Inherited
• CATEGORY:
  Inherited
• WATER_SERVICE:
  Inherited
• SEWER_SERVICE:
  Inherited
• GARBAGE_SERVICE:
  Inherited
Templates:
• Name: NO
  Description:
  Prototype:
  TRASH_CARTS: null
  TRASH_ROUTE: null
  ASSETID: null
  ACCOUNT_NUMBER: null
  OCCUPANT_CODE: null
  ACCOUNT_OCCUPANT: null
  RECYCLING: null
  RECYCLE_CARTS: null
  ASSISTED_PICKUP: N
  ASSISTED_COMMENTS: null
  STOP: null
  SITE_ADDRESS_ASSETID: null
  FULL_ADDRESS: null
  ADDRESS_UNIT: null
  BILL_CODE: null
  CATEGORY: null
  START_DATE: null
  END_DATE: null
  NAME: null
  SERV_STREET_NO: null
  SERV_STREET_MOD: null
  SERV_STREET: null
  SERV_UNIT: null
  SERV_REGION: null
  SERV_CITY: null
  SERV_PROVINCE: null
  SERV_POSTAL_CODE: null
  LOT_NO: null
  PLAN_NO: null
  MAIL_ADDR1: null
  MAIL_ADDR2: null
  MAIL_CITY: null
  MAIL_PROVINCE: null
  MAIL_POSTAL_ZIP: null
  MAIL_POSTAL_MODE: null
  HOME_PHONE: null
  BUSINESS_PHONE: null
  TENANT_OWNER: null
  FREQUENCY: null
  FREE_PICKUPS_LINK: null
  GARBAGE_SERVICE: null
  SEWER_SERVICE: null
  WATER_SERVICE: null
  RECYCLE_ROUTE: null
  ACCOUNT_NUMBER_4CYCLE: null
  OCCUPANT_CODE_4CYCLE: null
  ACCOUNT_OCCUPANT_4CYCLE: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata