Waste Management and Equipment Rental Activity Data – Servicing construction sites

Founded in 1998, BPES, based outside Philadelphia, is a leading company in the waste management and equipment rental markets across the US and Canada. The organization works with a network of haulers and equipment rental providers and sits on a rich corpus of ever-changing data associated with its transactions across over 20,000 customers annually, including contractors, builders, roofers, multi-store chain restaurants, food services, supermarkets, solar installers, manufacturers, diverse retailers, apartment complexes, health care facilities and others.

This data share includes 2 tables with Roll Offs and Works data sets. These tables represent activity at construction sites with Roll Offs being primarily dumpsters and site equipment rentals (port-a-potty). The Works tables contains information on tool rentals for constructions sites. Data can be used to understand trends across relevant businesses.

BPES Data is managed by Alesco Data in the Snowflake platform.

Sample Tables:

- Daily Past (historical) constructions waste management data from 9/2018-present
- Roll Offs
- Works

Fields For Roll Offs Include:<br/>-Customer Environment_Customer_ID<br/>-BP PO Number<br/>-Date For Action<br/>-Created<br/>-Flat Rate - BP<br/>-BP Haul<br/>-BP Tonnage<br/>-Vendor Monthly Rental<br/>-Billing Status<br/>-Action Time<br/>-Dump Under BP Acct.<br/>-Quantity<br/>-Unit of Measure<br/>-Ticket Status<br/>-Ticket Display<br/>-Product Description - RollOff_List of Product Description - RollOff_ID<br/>-Product Desc<br/>-Movement Type<br/>-Job Site Environment_Job Site_ID<br/>-Job Site Display<br/>-Job Type Desc<br/>-Job Number<br/>-Job Site Name<br/>-Job Site Address<br/>-Job Site City<br/>-Job Site State<br/>-Job Site Zip<br/>-Job Site County<br/>-Job Site Map<br/>-Customer Name<br/>-Customer No.<br/>-Customer City<br/>-Customer Zip<br/>-Vendor Name

Fields For Works Include:<br/>-Customer Works_Customer_ID<br/>-BP PO Number<br/>-Rental Start Date<br/>-Call Off Date<br/>-Created<br/>-Daily Rate - Vendor<br/>-Weekly Rate - Vendor<br/>-Monthly Rate - Vendor<br/>-Ticket Works Display<br/>-Product Description - Works_List of Product Description - Works_ID<br/>-Product Desc<br/>-Rental Frequency<br/>-Pickup - Vendor<br/>-Delivery - Vendor<br/>-Delivery Date<br/>-Delivery Time<br/>-Pass Fuel

-Works Status<br/>-Job Site Display<br/>-Job Type Desc<br/>-Job Number<br/>-Job Site Name<br/>-Job Site Address<br/>-Job Site City<br/>-Job Site State<br/>-Job Site Zip<br/>-Job Site County<br/>-Job Site Map<br/>-Customer Name<br/>-Customer No.<br/>-Customer City<br/>-Customer Zip<br/>-Vendor Name