Surface Water - Water Quality Regulated Facility Information

CREATE TABLE wastewater_facilities_inspection_records_1987_through_2021 (
  "region" VARCHAR,
  "inspected_facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "agency_name" VARCHAR,
  "place_type" VARCHAR,
  "place_subtype" VARCHAR,
  "agency_type" VARCHAR,
  "place_address" VARCHAR,
  "place_city" VARCHAR,
  "place_zip" VARCHAR,
  "place_county" VARCHAR,
  "place_latitude" DOUBLE,
  "place_longitude" DOUBLE,
  "wdid" VARCHAR,
  "reg_measure_id" DOUBLE,
  "reg_measure_type" VARCHAR,
  "inspection_id" BIGINT,
  "inspection_type" VARCHAR,
  "inspection_date_actual_start" TIMESTAMP,
  "inpection_program" VARCHAR,
  "inpection_program_category" VARCHAR,
  "summary" VARCHAR
);

CREATE TABLE wastewater_facilities_permits_orders (
  "reg_measure_id" DOUBLE,
  "reg_measure_type" VARCHAR,
  "order_number" VARCHAR,
  "npdes_number_ca_number" VARCHAR,
  "program_category" VARCHAR,
  "wdid" VARCHAR,
  "major_minor" VARCHAR,
  "status" VARCHAR,
  "effective_date" TIMESTAMP,
  "expiration_review_date" VARCHAR,
  "termination_date" VARCHAR,
  "adoption_date" TIMESTAMP,
  "wdr_review_amend" TIMESTAMP,
  "wdr_review_revise_renew" TIMESTAMP,
  "wdr_review_rescind" TIMESTAMP,
  "wdr_review_no_action_required" TIMESTAMP,
  "wdr_review_pending" TIMESTAMP,
  "wdr_review_planned" TIMESTAMP,
  "status_enrollee" VARCHAR,
  "individual_general" VARCHAR,
  "fee_code" VARCHAR,
  "design_flow" VARCHAR,
  "threat_to_water_quality" VARCHAR,
  "complexity" VARCHAR,
  "pretreatment" VARCHAR,
  "population_ms4_acres" VARCHAR,
  "reclamation" VARCHAR,
  "facility_waste_type" VARCHAR,
  "facility_waste_type_2" VARCHAR,
  "number_of_amendments" BIGINT,
  "facility_id" VARCHAR,
  "facility_region" VARCHAR,
  "facility_name" VARCHAR,
  "place_type" VARCHAR,
  "place_address" VARCHAR,
  "place_city" VARCHAR,
  "place_zip" VARCHAR,
  "place_county" VARCHAR,
  "latitude_decimal_degrees" VARCHAR,
  "longitude_decimal_degrees" VARCHAR
);

CREATE TABLE data_dictionary_wastewater_facilities_permits_orders (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE wastewater_enforcement_actions (
  "region" VARCHAR,
  "facility_id" DOUBLE,
  "facility_name" VARCHAR,
  "agency_name" VARCHAR,
  "place_type" VARCHAR,
  "place_subtype" VARCHAR,
  "place_latitude" DOUBLE,
  "place_longitude" DOUBLE,
  "wdid" VARCHAR,
  "reg_measure_id" DOUBLE,
  "reg_measure_type" VARCHAR,
  "enforcement_id_eid" BIGINT,
  "order_resolution_number" VARCHAR,
  "enforcement_action_type" VARCHAR,
  "effective_date" VARCHAR,
  "adoption_issuance_date" VARCHAR,
  "termination_date" VARCHAR,
  "acl_issuance_date" TIMESTAMP,
  "epl_issuance_date" VARCHAR,
  "status" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "program" VARCHAR,
  "program_category" VARCHAR,
  "total_assessment_amount" DOUBLE,
  "initial_assessed_amount" DOUBLE,
  "liability_amount" DOUBLE,
  "project_amount" DOUBLE,
  "liability_paid" DOUBLE,
  "project_completed" BIGINT,
  "total_paid_completed_amount" DOUBLE,
  "location_1" VARCHAR
);

CREATE TABLE inspections_performance_measures (
  "program" VARCHAR,
  "facilities" BIGINT,
  "inspections" BIGINT,
  "facilities_inspected" BIGINT,
  "percentage_of_facilities_inspected" VARCHAR
);

CREATE TABLE confined_animal_facilities_regulated_by_the_water_boards (
  "reg_measure_id" BIGINT,
  "reg_measure_type" VARCHAR,
  "reg_measure_title" VARCHAR,
  "reg_measure_description" VARCHAR,
  "order_number" VARCHAR,
  "npdes_number_ca_number" VARCHAR,
  "program" VARCHAR,
  "program_category" VARCHAR,
  "wdid" VARCHAR,
  "region" VARCHAR,
  "status" VARCHAR,
  "effective_date" TIMESTAMP,
  "expiration_review_date" TIMESTAMP,
  "termination_date" TIMESTAMP,
  "adoption_date" TIMESTAMP,
  "individual_general" VARCHAR,
  "fee_code" VARCHAR,
  "facility_waste_type" VARCHAR,
  "facility_waste_type_2" VARCHAR,
  "number_of_amendments" BIGINT,
  "most_recent_amendment_number" VARCHAR,
  "most_recent_amendment_date" VARCHAR,
  "most_recent_amendment_comments" VARCHAR,
  "rescission_number" VARCHAR,
  "rescission_date" TIMESTAMP,
  "rescission_comments" VARCHAR,
  "facility_id" VARCHAR,
  "facility_region" VARCHAR,
  "facility_name" VARCHAR,
  "place_type" VARCHAR,
  "place_address" VARCHAR,
  "place_city" VARCHAR,
  "place_zip" VARCHAR,
  "place_county" VARCHAR,
  "latitude_decimal_degrees" VARCHAR,
  "longitude_decimal_degrees" VARCHAR,
  "approved_cnty_reg_prog" VARCHAR,
  "cafo_subtype" VARCHAR,
  "cafo_type" VARCHAR,
  "onsite" VARCHAR,
  "cafo_population" VARCHAR,
  "quality_assurance" VARCHAR,
  "sic_code_1" VARCHAR,
  "sic_desc_1" VARCHAR,
  "animal_equivalent_units_aeu" VARCHAR,
  "agency_name" VARCHAR,
  "agency_type" VARCHAR
);

CREATE TABLE n__dictionary_confined_animal_facilities_regulated_by__de63cf4f (
  "column" VARCHAR,
  "type" VARCHAR,
  "label" VARCHAR,
  "description" VARCHAR
);