About this Dataset

Leaking Underground Storage Tanks

Underground Storage Tank (UST) locations. The dataset contains locations and attributes of Underground Storage Tanks, created as part of the DC Geographic Information System (DC GIS) for the D.C. Office of the Chief Technology Officer (OCTO) and participating D.C. government agencies. A database provided by the Environmental Health Administration - DC Underground Storage Tanks Management identified Underground Storage Tank locations. The Underground Storage Tank (UST) branch’s services protects human health and the environment from the adverse effects of petroleum, petroleum-related products and hazardous materials from USTs in the District of Columbia. This branch is organized into two programs: Underground Storage Tanks (UST) and Leaking Underground Storage Tanks (LUST). For additional information including laws, regulation and other documents visit: https://doee.dc.gov/service/underground-storage-tank-program
Organization: District of Columbia
Last updated: 2024-04-30T17:44:50.529459
Tags: d-c, dc, dc-gis, dcgis, dec2015, district-of-columbia, doee, environment, facility, regulation, society, storage-tanks, tank, underground, utilitiescommunication, washington, washington-dc

Tables

Table 1

@usgov.district_of_columbia_leaking_underground_storage_tanks_6b76a.table_1

299.06 kB
1,699 rows
31 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "facility_id" BIGINT,
  "case_num" BIGINT,
  "company_name" VARCHAR,
  "facility_type" VARCHAR,
  "site_address" VARCHAR,
  "quadrant" VARCHAR,
  "zipcode" BIGINT,
  "ward" BIGINT,
  "active" VARCHAR,
  "status" VARCHAR,
  "entry_date" TIMESTAMP,
  "event_date" TIMESTAMP,
  "notified_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "regulator" VARCHAR,
  "product" VARCHAR,
  "receptor" VARCHAR,
  "vrap_num" VARCHAR,
  "media_of_contamination" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mar_id" BIGINT,
  "gis_id" VARCHAR,
  "created" TIMESTAMP,
  "edited" TIMESTAMP,
  "globalid" VARCHAR,
  "objectid" BIGINT
);