About this Dataset

Rodent Control By Citywide Contractor

A. SUMMARY This database lists records of rodent treatments primarily in the City's combined sewer system. The data is collected and submitted by the current holder of the Citywide Integrated Pest Management contract. Rodent treatments are listed by location and by number of products used. These data will be linked with other public data to provide informational tools in support of the City's Integrated Pest Management (IPM) Program and Vector Control Program, administered by the Department of the Environment and Department of Public Health, respectively. Providing public access to such data is in keeping with the record-keeping and transparency requirements of the IPM Ordinance, Environment Code, Chapt. 3.

For more information on San Francisco's IPM program, see https://www.sfenvironment.org/what-integrated-pest-management-ipm
For information on the City's Vector Control Program, see https://www.sf.gov/get-help-vermin-your-building
For more information on data set data custodian, see https://www.civichub.us/ca/sf/open-data B. HOW THE DATASET IS CREATED The data is collected and submitted by the current holder of the Citywide Integrated Pest Management contract. Data is collected by the field technicians and added to a service database from there the data is being published to the SF Open Data portal. C. UPDATE PROCESS This feed is updated daily and reflects service and product application from the previous calendar day.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:49.462898

Tables

Table 1

@usgov.city_of_san_francisco_rodent_control_by_citywide_contractor.table_1

180.92 KB
24536 rows
9 columns


CREATE TABLE table_1 (
  "cnn" BIGINT,
  "node_id" BIGINT,
  "bait_applied" VARCHAR,
  "blocks_applied" DOUBLE,
  "blocks_consumed" DOUBLE,
  "serviced_date" TIMESTAMP,
  "point" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);