About this Dataset

Adopt A Block Cleanup Events

After a clean up event by our block adopters, event organizers record their clean up data. This includes items such as how many trash bags were used. The number of volunteers that joined. By sharing this information the Office of Clean city can better engage with all communities. This layer is used in the Group Spotlights section of the Adopt a Block hub site, https://adopt-a-block-dcgis.hub.arcgis.com/.
Organization: District of Columbia
Last updated: 2024-04-30T18:34:30.562318
Tags: adopt, adopt-a-block, clean-up, district-of-columbia, moca, occ, office-of-clean-city, roll-off-day, submission, trash, trashfreedc, volunteer

Tables

Table 1

@usgov.district_of_columbia_adopt_a_block_cleanup_events.table_1

61.78 kB
378 rows
26 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "name" VARCHAR,
  "group_type" VARCHAR,
  "other" VARCHAR,
  "hours_minutes" VARCHAR,
  "num_volunteers" BIGINT,
  "trash_condition" BIGINT,
  "explain_why" VARCHAR,
  "trash_bag_type_size" VARCHAR,
  "num_trash_bags" BIGINT,
  "num_recycle_bags" DOUBLE,
  "common_trash_1" VARCHAR,
  "common_trash_2" VARCHAR,
  "common_trash_3" VARCHAR,
  "num_tires" DOUBLE,
  "bulk_items" VARCHAR,
  "notes" VARCHAR,
  "created_date" TIMESTAMP,
  "edited_date" TIMESTAMP,
  "date_start" TIMESTAMP,
  "time_end" TIMESTAMP,
  "other_bulk" VARCHAR,
  "adopted_block" VARCHAR,
  "location" VARCHAR
);