About this Dataset

Oil Spill Incident Tracking [ds394]

The Office of Spill Prevention and Response (OSPR) Incident Tracking Database is a statewide oil spill tracking information system. The data are collected by OSPR Field Response Team members for Marine oil spills and by OSPR Inland Pollution Coordinators and Wardens for Inland incidents.
Organization: State of California
Last updated: 2025-07-23T22:13:42.049126
Tags: auth_cdfw, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, ds0394_20090730_wm, incidents, spill-response, spills

Tables

Table 1

@usgov.ca_gov_oil_spill_incident_tracking_ds394_7a622.table_1

230.19 kB
3,237 rows
15 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "dfgcontrol" VARCHAR,
  "oesnumber" VARCHAR,
  "dateofinci" TIMESTAMP,
  "timeofinci" VARCHAR,
  "inlandmari" VARCHAR,
  "specificlo" VARCHAR,
  "water" VARCHAR,
  "waterway" VARCHAR,
  "localecity" VARCHAR,
  "localecoun" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);