Parent Layer: SWM COLLECTIONS

Name: County

Display Field: FACILITY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The Bureau of Solid Waste Management’s inventory of collection units is maintained by Tony Gulati using Cass Works software. Collection data is updated in Cass Works at the time of the route audit. Once updated, the data is exported from Cass Works into an Excel spreadsheet for the given route. These spreadsheets serve as the master source data for this project. The source data was delivered on 08/01/2018, therefore any route audits performed after this date will require an update to the data. Supplemental data for this project also includes an Excel spreadsheet of addresses representing those collection units that are currently identified in the route books as ‘Apartments in Dwellings’. This categorization is not captured in the standard route book spreadsheets above but rather is maintained separately in the aforementioned spreadsheet. Other data leveraged in the creation process: FACILITIES.VW_ADDRESS feature class (maintained by OIT) FACILITIES.VW_ADDRESS_UNIT feature class (maintained by OIT) LANDUSE.SW_PitchInCans feature class (created by Solid Waste, not currently maintained) LANDUSE.SW_Dumpsters feature class (created by Solid Waste, not currently maintained)

Service Item Id: fbd79054433c4f88a00a4f2d0f88387c

Copyright Text: Baltimore County, DPW, Bureau of Solid Waste Management

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 24000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1344817.93725
YMin: 558195.513999999
XMax: 1499331.12800001
YMax: 748492.978
Spatial Reference: 2893  (2893)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ASSET_TYPE
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: DUMPSTER
  Label: Dumpster
  Description:
  Symbol:
  
• Value: PM DUMPSTER
  Label: Dumpster
  Description:
  Symbol:
  
• Value: PITCH-IN-CAN
  Label: Pitch-In-Can
  Description:
  Symbol:
  
• Value: TRASH BARREL
  Label: Trash Barrel
  Description:
  Symbol:
  
• Value:
  Label: Unknown
  Description:
  Symbol:
  
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: false
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• COLLECTION_POINT_ID ( type: esriFieldTypeString, alias: COLLECTION_POINT_ID, length: 15 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 105 )
• ST_NUMBER ( type: esriFieldTypeString, alias: ST_NUMBER, length: 10 )
• ST_NUMSUFFIX ( type: esriFieldTypeString, alias: ST_NUMSUFFIX, length: 10 )
• ST_PREMOD ( type: esriFieldTypeString, alias: ST_PREMOD, length: 3 )
• ST_PREFIXDIR ( type: esriFieldTypeString, alias: ST_PREFIXDIR, length: 1 )
• ST_PREFIXTYPE ( type: esriFieldTypeString, alias: ST_PREFIXTYPE, length: 12 )
• ST_NAME ( type: esriFieldTypeString, alias: ST_NAME, length: 30 )
• ST_TYPE ( type: esriFieldTypeString, alias: ST_TYPE, length: 4 )
• ST_SUFFIXDIR ( type: esriFieldTypeString, alias: ST_SUFFIXDIR, length: 2 )
• ST_POSTMOD ( type: esriFieldTypeString, alias: ST_POSTMOD, length: 8 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 50 )
• ZIP_CODE ( type: esriFieldTypeString, alias: ZIP_CODE, length: 5 )
• FACILITY_TYPE ( type: esriFieldTypeString, alias: FACILITY_TYPE, length: 35 , Coded Values: [APARTMENT IN DWELLING: APARTMENT IN DWELLING] , [CHURCH: CHURCH] , [COUNTY: COUNTY] , ...4 more... )
• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, length: 120 )
• ASSET_TYPE ( type: esriFieldTypeString, alias: ASSET_TYPE, length: 20 , Coded Values: [COLLECTION UNIT: COLLECTION UNIT] , [DUMPSTER: DUMPSTER] , [PITCH-IN-CAN: PITCH-IN-CAN] , ...3 more... )
• LIFECYCLE_STATUS ( type: esriFieldTypeString, alias: LIFECYCLE_STATUS, length: 25 , Coded Values: [ACTIVE: ACTIVE] , [PROPOSED: PROPOSED] , [UNDER CONSTRUCTION: UNDER CONSTRUCTION] , ...7 more... )
• ROUTE_ID ( type: esriFieldTypeString, alias: ROUTE_ID, length: 5 )
• SCHEDULE_ID ( type: esriFieldTypeString, alias: SCHEDULE_ID, length: 5 )
• SERVICE_TYPE ( type: esriFieldTypeString, alias: SERVICE_TYPE, length: 10 , Coded Values: [OO: ONE TRASH, ONE RECYCLE] , [SS: SINGLE STREAM] , [T: TRASH] , ...2 more... )
• SCHEDULE_DESCRIPTION ( type: esriFieldTypeString, alias: SCHEDULE_DESCRIPTION, length: 15 )
• PAY_UNITS ( type: esriFieldTypeDouble, alias: PAY_UNITS )
• TRASH_PICKUP_TYPE ( type: esriFieldTypeString, alias: TRASH_PICKUP_TYPE, length: 15 , Coded Values: [COMPACTOR: COMPACTOR] , [F/E DUMPSTER: F/E DUMPSTER] , [HAND PICKUP: HAND PICKUP] , ...3 more... )
• TRASH_PICKUP_LOCATION ( type: esriFieldTypeString, alias: TRASH_PICKUP_LOCATION, length: 15 , Coded Values: [ALLEY: ALLEY] , [CORRAL: CORRAL] , [FRONT STREET: FRONT STREET] , ...4 more... )
• RECYCLE_PICKUP_TYPE ( type: esriFieldTypeString, alias: RECYCLE_PICKUP_TYPE, length: 15 , Coded Values: [COMPACTOR: COMPACTOR] , [F/E DUMPSTER: F/E DUMPSTER] , [HAND PICKUP: HAND PICKUP] , ...3 more... )
• RECYCLE_PICKUP_LOCATION ( type: esriFieldTypeString, alias: RECYCLE_PICKUP_LOCATION, length: 15 , Coded Values: [ALLEY: ALLEY] , [CORRAL: CORRAL] , [FRONT STREET: FRONT STREET] , ...4 more... )
• HAULER_TYPE ( type: esriFieldTypeString, alias: HAULER_TYPE, length: 10 , Coded Values: [COUNTY: COUNTY] , [PRIVATE: PRIVATE] , [CITY: CITY] , ...4 more... )
• HAULER_COMPANY_NAME ( type: esriFieldTypeString, alias: HAULER_COMPANY_NAME, length: 50 , Coded Values: [ALEXANDER'S REFUSE INC: ALEXANDER'S REFUSE INC] , [ALVIN PARLETT & SON INC: ALVIN PARLETT & SON INC] , [BE GREAT HAULING INC: BE GREAT HAULING INC] , ...41 more... )
• HAULER_COLLECTOR_NAMES ( type: esriFieldTypeString, alias: HAULER_COLLECTOR_NAMES, length: 120 )
• HAULER_CONTACT_NAME ( type: esriFieldTypeString, alias: HAULER_CONTACT_NAME, length: 35 )
• HAULER_CONTACT_PHONE ( type: esriFieldTypeString, alias: HAULER_CONTACT_PHONE, length: 20 )
• ZONE_ID ( type: esriFieldTypeString, alias: ZONE_ID, length: 5 )
• ZONE_SUPERVISOR_NAME ( type: esriFieldTypeString, alias: ZONE_SUPERVISOR_NAME, length: 35 )
• ZONE_SUPERVISOR_PHONE ( type: esriFieldTypeString, alias: ZONE_SUPERVISOR_PHONE, length: 20 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 120 )
• MFG_SERIAL_NUMBER ( type: esriFieldTypeString, alias: MFG_SERIAL_NUMBER, length: 50 )
• MFG_MODEL_NUMBER ( type: esriFieldTypeString, alias: MFG_MODEL_NUMBER, length: 50 )
• DUMPSTER_CAPACITY ( type: esriFieldTypeString, alias: DUMPSTER_CAPACITY, length: 10 , Coded Values: [2 YD: 2 YD] , [3 YD: 3 YD] , [4 YD: 4 YD] , ...4 more... )
• DUMPSTER_COUNT ( type: esriFieldTypeSmallInteger, alias: DUMPSTER_COUNT )
• BARREL_COUNT ( type: esriFieldTypeSmallInteger, alias: BARREL_COUNT )
• MONDAY ( type: esriFieldTypeString, alias: MONDAY, length: 10 , Coded Values: [R: RECYCLE] , [R,Y: RECYCLE & YARD] , [T: TRASH] , ...6 more... )
• TUESDAY ( type: esriFieldTypeString, alias: TUESDAY, length: 10 , Coded Values: [R: RECYCLE] , [R,Y: RECYCLE & YARD] , [T: TRASH] , ...6 more... )
• WEDNESDAY ( type: esriFieldTypeString, alias: WEDNESDAY, length: 10 , Coded Values: [R: RECYCLE] , [R,Y: RECYCLE & YARD] , [T: TRASH] , ...6 more... )
• THURSDAY ( type: esriFieldTypeString, alias: THURSDAY, length: 10 , Coded Values: [R: RECYCLE] , [R,Y: RECYCLE & YARD] , [T: TRASH] , ...6 more... )
• FRIDAY ( type: esriFieldTypeString, alias: FRIDAY, length: 10 , Coded Values: [R: RECYCLE] , [R,Y: RECYCLE & YARD] , [T: TRASH] , ...6 more... )
• SATURDAY ( type: esriFieldTypeString, alias: SATURDAY, length: 10 , Coded Values: [R: RECYCLE] , [R,Y: RECYCLE & YARD] , [T: TRASH] , ...6 more... )
• SUNDAY ( type: esriFieldTypeString, alias: SUNDAY, length: 10 , Coded Values: [R: RECYCLE] , [R,Y: RECYCLE & YARD] , [T: TRASH] , ...6 more... )
• YARD_START_WEEK ( type: esriFieldTypeString, alias: YARD_START_WEEK, length: 10 , Coded Values: [1: 1] , [2: 2] , [OTHER: OTHER] , ...1 more... )
• ADA_SERVICE ( type: esriFieldTypeString, alias: ADA_SERVICE, length: 3 , Coded Values: [YES: YES] , [NO: NO] )
• FACILITY_ID ( type: esriFieldTypeInteger, alias: FACILITY_ID )
• ADDRESS_ID ( type: esriFieldTypeInteger, alias: ADDRESS_ID )
• UNIT_ID ( type: esriFieldTypeInteger, alias: UNIT_ID )
• COORDINATE_SOURCE ( type: esriFieldTypeString, alias: COORDINATE_SOURCE, length: 25 , Coded Values: [SURVEY GRADE: SURVEY GRADE] , [MAPPING GRADE - GPS: MAPPING GRADE - GPS] , [MOBILE GRADE - GPS: MOBILE GRADE - GPS] , ...6 more... )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, length: 255 )
• OWNED_BY ( type: esriFieldTypeString, alias: OWNED_BY, length: 10 , Coded Values: [COUNTY: COUNTY] , [PRIVATE: PRIVATE] , [CITY: CITY] , ...4 more... )
• MAINTAINED_BY ( type: esriFieldTypeString, alias: MAINTAINED_BY, length: 10 , Coded Values: [COUNTY: COUNTY] , [PRIVATE: PRIVATE] , [CITY: CITY] , ...4 more... )
• RESPONSIBLE_AGENCY ( type: esriFieldTypeString, alias: RESPONSIBLE_AGENCY, length: 75 , Coded Values: [DEPARTMENT OF RECREATION AND PARKS: DEPARTMENT OF RECREATION AND PARKS] , [DEPARTMENT OF ENVIRONMENT PROTECTION AND SUSTAINABILITY: DEPARTMENT OF ENVIRONMENT PROTECTION AND SUSTAINABILITY] , [OFFICE OF BUDGET AND FINANCE: OFFICE OF BUDGET AND FINANCE] , ...5 more... )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: CONDITION )
• CONDITION_DATE ( type: esriFieldTypeDate, alias: CONDITION_DATE, length: 8 )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, length: 8 )
• WARRANTY_DATE ( type: esriFieldTypeDate, alias: WARRANTY_DATE, length: 8 )
• REHABILATION_DATE ( type: esriFieldTypeDate, alias: REHABILATION_DATE, length: 8 )
• REHABILATION_TYPE ( type: esriFieldTypeString, alias: REHABILATION_TYPE, length: 120 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 255 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• BULK_ROUTE_ID ( type: esriFieldTypeString, alias: BULK_ROUTE_ID, length: 15 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata