Name: Master_Waste_Management_Addresses

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13509509.7711353
YMin: 2019434.45977361
XMax: 46572642.2698052
YMax: 18653767.2725222
Spatial Reference: 102642 (2226)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[210,113,69,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• COLID (type: esriFieldTypeString, alias: COLID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Full_Street_Address (type: esriFieldTypeString, alias: Full Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StreetNum (type: esriFieldTypeInteger, alias: StreetNum, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 100000])
• StreetPreDir (type: esriFieldTypeString, alias: StreetPreDir, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [N: N], [E: E], [S: S], ... 1 more ...)
• StreetName (type: esriFieldTypeString, alias: StreetName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StreetType (type: esriFieldTypeString, alias: StreetType, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [AVENUE: AVENUE], [BOULEVARD: BOULEVARD], [CIRCLE: CIRCLE], ... 13 more ...)
• StreetPostDir (type: esriFieldTypeString, alias: StreetPostDir, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [N: N], [E: E], [S: S], ... 1 more ...)
• UnitApt (type: esriFieldTypeString, alias: UnitApt, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Res_GW_Allowed (type: esriFieldTypeSmallInteger, alias: Res_GW_Allowed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• CollectionDay (type: esriFieldTypeSmallInteger, alias: CollectionDay, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Monday], [2: Tuesday], [3: Wednesday], ... 4 more ...)
• RouteWeek (type: esriFieldTypeSmallInteger, alias: RouteWeek, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Blue], [2: Yellow])
• OrgCollectionDay (type: esriFieldTypeSmallInteger, alias: OrgCollectionDay, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Monday], [2: Tuesday], [3: Wednesday], ... 4 more ...)
• AddrsClass (type: esriFieldTypeString, alias: AddrsClass, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Situs: Situs], [Secondary: Secondary])
• TERRITORY (type: esriFieldTypeString, alias: TERRITORY, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• BusinessName (type: esriFieldTypeString, alias: BusinessName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bldg (type: esriFieldTypeString, alias: bldg, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SubAddrsType (type: esriFieldTypeString, alias: SubAddrsType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ADU: Accessory Dwelling Unit], [CUS: Commercial Unit/Suite], [FSS: Facility Support Structure], ... 18 more ...)
• AddressID (type: esriFieldTypeString, alias: AddressID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: Master_Waste_Management_Addresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• RSW_Route: 201
• RGW_Route: 201
• AccountStatus: 0
• WalkOut: 0
• Org_Route: 201
• HasWorkOrder: 0

Relationships:

• An_Address_Has_Commercial_Bins (3) -- Related To: Commercial_Bins_Unique (4)
• tbl_AddressPoint_LiSWA_Type (4) -- Related To: tbl_AddressPoint_LiSWA_Type (11)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/21/2026 6:05:58 PM

Schema Last Edit Date: 10/19/2026 12:37:16 PM

Data Last Edit Date: 10/21/2026 6:05:58 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat