State Environmental Policy Act (SEPA) Register by US Government | Environmental and Climate Sciences

About this Dataset

State Environmental Policy Act (SEPA) Register

This dataset contains a list of SEPA and NEPA records posted by the Department of Ecology since 2000.
Organization: State of Washington
Last updated: 2024-09-20T19:44:19.699524
Tags: ecology, sea, sepa, state-environmental-policy-act

Tables

Table 1

@usgov.state_of_washington_state_environmental_policy_act_sep_ffa84c29.table_1

39.63 MB
184391 rows
31 columns


CREATE TABLE table_1 (
  "separegisterid" BIGINT,
  "sepanumber" BIGINT,
  "proposalname" VARCHAR,
  "proposaltypename" VARCHAR,
  "proposaldescription" VARCHAR,
  "leadagencyname" VARCHAR,
  "leadagencyfilenumber" VARCHAR,
  "leadagencycontactname" VARCHAR,
  "leadagencycontactemail" VARCHAR,
  "leadagencycontactphonenumber" VARCHAR,
  "leadagencycontactextensionnumber" VARCHAR,
  "leadagencyissuedate" VARCHAR,
  "siteline1address" VARCHAR,
  "siteline2address" VARCHAR,
  "sitecityname" VARCHAR,
  "sitezipcode" VARCHAR,
  "siteparcelnumber" VARCHAR,
  "sitesectiontownrange" VARCHAR,
  "sitelatitudedecimal" DOUBLE,
  "sitelongitudedecimal" DOUBLE,
  "applicantname" VARCHAR,
  "documenttypecode" VARCHAR,
  "documentsubtypecode" VARCHAR,
  "documentsubsubtypecode" VARCHAR,
  "countyname" VARCHAR,
  "regionname" VARCHAR,
  "commentsduedate" VARCHAR,
  "relatedrecordsdescription" VARCHAR,
  "applicantcontactinfo" VARCHAR,
  "publisheddate" VARCHAR,
  "separegisterlink" VARCHAR
);