ERMN Benthic Macroinvertebrate Monitoring Data

CREATE TABLE equis_edd_ermn_2022_bmi_20221208_results (
  "n__org_code" VARCHAR,
  "activity_id" VARCHAR,
  "characteristic_name" VARCHAR,
  "method_speciation" VARCHAR,
  "filtered_fraction" VARCHAR,
  "result_detection_condition" VARCHAR,
  "result_text" DOUBLE,
  "result_unit" VARCHAR,
  "result_qualifier" VARCHAR,
  "result_status" VARCHAR,
  "result_type" VARCHAR,
  "result_comment" VARCHAR,
  "method_detection_limit" VARCHAR,
  "lower_quantification_limit" VARCHAR,
  "upper_quantification_limit" VARCHAR,
  "limit_comment" VARCHAR,
  "temperature_basis" VARCHAR,
  "statistical_basis" VARCHAR,
  "time_basis" VARCHAR,
  "weight_basis" VARCHAR,
  "particle_size_basis" VARCHAR,
  "precision" VARCHAR,
  "bias" VARCHAR,
  "confidence_interval" VARCHAR,
  "upper_confidence_limit" VARCHAR,
  "lower_confidence_limit" VARCHAR,
  "result_sampling_point_name" VARCHAR,
  "result_depth_height_measure" VARCHAR,
  "result_depth_height_measure_unit" VARCHAR,
  "result_depth_altitude_reference_point" VARCHAR,
  "analytical_method_id" VARCHAR,
  "analytical_remark" VARCHAR,
  "lab_id" VARCHAR,
  "lab_remark_code" VARCHAR,
  "analysis_start_date" TIMESTAMP,
  "analysis_start_time" VARCHAR,
  "analysis_start_time_zone" VARCHAR,
  "lab_accreditation_indicator" VARCHAR,
  "lab_accreditation_authority_name" VARCHAR,
  "lab_batch_id" VARCHAR,
  "lab_sample_preparation_id" VARCHAR,
  "lab_sample_preparation_start_date" VARCHAR,
  "lab_sample_preparation_start_time" VARCHAR,
  "lab_sample_preparation_start_time_zone" VARCHAR,
  "dilution_factor" VARCHAR,
  "num_of_replicates" VARCHAR,
  "data_logger_line_name" VARCHAR,
  "biological_intent" VARCHAR,
  "biological_individual_id" VARCHAR,
  "subject_taxon" VARCHAR,
  "unidentified_species_id" VARCHAR,
  "tissue_anatomy" VARCHAR,
  "group_summary_count_or_weight" VARCHAR,
  "group_summary_count_or_weight_unit" VARCHAR,
  "cell_form" VARCHAR,
  "cell_shape" VARCHAR,
  "habit_name_1" VARCHAR,
  "habit_name_2" VARCHAR,
  "habit_name_3" VARCHAR,
  "voltinism" VARCHAR,
  "pollution_tolerance" VARCHAR,
  "pollution_tolerance_scale" VARCHAR,
  "trophic_level" VARCHAR,
  "functional_feeding_group_1" VARCHAR,
  "functional_feeding_group_2" VARCHAR,
  "functional_feeding_group_3" VARCHAR,
  "file_name_or_resource_id" VARCHAR,
  "resource_date" VARCHAR,
  "resource_title_name" VARCHAR,
  "resource_creator_name" VARCHAR,
  "resource_publisher_name" VARCHAR,
  "resource_publication_year" VARCHAR,
  "resource_volume_pages" VARCHAR,
  "resource_subject_text" VARCHAR,
  "frequency_class_descriptor_1" VARCHAR,
  "frequency_class_bounds_unit_1" VARCHAR,
  "frequency_class_lower_bound_1" VARCHAR,
  "frequency_class_upper_bound_1" VARCHAR,
  "frequency_class_descriptor_2" VARCHAR,
  "frequency_class_bounds_unit_2" VARCHAR,
  "frequency_class_lower_bound_2" VARCHAR,
  "frequency_class_upper_bound_2" VARCHAR,
  "frequency_class_descriptor_3" VARCHAR,
  "frequency_class_bounds_unit_3" VARCHAR,
  "frequency_class_lower_bound_3" VARCHAR,
  "frequency_class_upper_bound_3" VARCHAR,
  "taxonomist_accreditation_indicator" VARCHAR,
  "taxonomist_accreditation_authority_name" VARCHAR,
  "result_file_name" VARCHAR,
  "lab_reported_result" VARCHAR,
  "reportable_result" VARCHAR,
  "source_flags" VARCHAR
);

CREATE TABLE equis_edd_ermn_2022_bmi_20221208_info (
  "column_legend" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR
);

CREATE TABLE equis_edd_ermn_2022_bmi_20221208_locations (
  "n__org_code" VARCHAR,
  "park_code" VARCHAR,
  "location_id" VARCHAR,
  "location_name" VARCHAR,
  "location_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lat_lon_method" VARCHAR,
  "lat_lon_datum" VARCHAR,
  "source_map_scale_numeric" VARCHAR,
  "lat_lon_accuracy" VARCHAR,
  "lat_lon_accuracy_unit" VARCHAR,
  "location_description" VARCHAR,
  "travel_directions" VARCHAR,
  "location_purpose" VARCHAR,
  "establishment_date" VARCHAR,
  "huc8_code" VARCHAR,
  "huc12_code" VARCHAR,
  "alternate_location_id" VARCHAR,
  "alternate_location_id_context" VARCHAR,
  "elevation" VARCHAR,
  "elevation_unit" VARCHAR,
  "elevation_method" VARCHAR,
  "elevation_datum" VARCHAR,
  "elevation_accuracy" VARCHAR,
  "elevation_accuracy_unit" VARCHAR,
  "country_code" VARCHAR,
  "state_code" VARCHAR,
  "county_code" VARCHAR,
  "drainage_area" VARCHAR,
  "drainage_area_unit" VARCHAR,
  "contributing_area" VARCHAR,
  "contributing_area_unit" VARCHAR,
  "tribal_land_indicator" VARCHAR,
  "tribal_land_name" VARCHAR,
  "well_id" VARCHAR,
  "well_type" VARCHAR,
  "aquifer_name" VARCHAR,
  "formation_type" VARCHAR,
  "well_hole_depth" VARCHAR,
  "well_hole_depth_unit" VARCHAR,
  "well_status" VARCHAR,
  "public_latitude" VARCHAR,
  "public_longitude" VARCHAR
);

CREATE TABLE equis_edd_ermn_2022_bmi_20221208_projects (
  "n__org_code" VARCHAR,
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "project_description" VARCHAR,
  "project_start_date" VARCHAR,
  "project_duration" VARCHAR,
  "project_type" VARCHAR,
  "qapp_summary" VARCHAR,
  "qapp_approved_indicator" VARCHAR,
  "qapp_approval_agency_name" VARCHAR,
  "study_area_description" VARCHAR,
  "design_sampling_summary" VARCHAR,
  "measurement_quality_objectives" VARCHAR,
  "contact" VARCHAR
);

CREATE TABLE equis_edd_ermn_2022_bmi_20221208_activities (
  "n__org_code" VARCHAR,
  "project_id" VARCHAR,
  "location_id" VARCHAR,
  "activity_id" VARCHAR,
  "activity_type" VARCHAR,
  "medium" VARCHAR,
  "medium_subdivision" VARCHAR,
  "assemblage_sampled_name" VARCHAR,
  "activity_start_date" TIMESTAMP,
  "activity_start_time" VARCHAR,
  "activity_start_time_zone" VARCHAR,
  "activity_end_date" VARCHAR,
  "activity_end_time" VARCHAR,
  "activity_end_time_zone" VARCHAR,
  "activity_relative_depth" VARCHAR,
  "activity_depth" VARCHAR,
  "activity_depth_unit" VARCHAR,
  "activity_upper_depth" VARCHAR,
  "activity_lower_depth" VARCHAR,
  "activity_depth_reference" VARCHAR,
  "additional_location_info" VARCHAR,
  "activity_sampler" VARCHAR,
  "activity_recorder" VARCHAR,
  "custody_id" VARCHAR,
  "activity_conducting_organization" VARCHAR,
  "station_visit_comment" VARCHAR,
  "activity_comment" VARCHAR,
  "collection_method_id" VARCHAR,
  "collection_equipment_name" VARCHAR,
  "collection_equipment_description" VARCHAR,
  "gear_deployment" VARCHAR,
  "container_type" VARCHAR,
  "container_color" VARCHAR,
  "container_size" VARCHAR,
  "container_size_unit" VARCHAR,
  "preparation_method_id" VARCHAR,
  "chemical_preservative" VARCHAR,
  "thermal_preservative" VARCHAR,
  "transport_storage_description" VARCHAR,
  "activity_group_id" VARCHAR,
  "activity_group_name" VARCHAR,
  "activity_group_type" VARCHAR,
  "collection_duration" VARCHAR,
  "collection_duration_unit" VARCHAR,
  "sampling_component_name" VARCHAR,
  "sampling_component_place_in_series" VARCHAR,
  "reach_length" VARCHAR,
  "reach_length_unit" VARCHAR,
  "reach_width" VARCHAR,
  "reach_width_unit" VARCHAR,
  "pass_count" VARCHAR,
  "net_type" VARCHAR,
  "net_surface_area" VARCHAR,
  "net_surface_area_unit" VARCHAR,
  "net_mesh_size" VARCHAR,
  "net_mesh_size_unit" VARCHAR,
  "boat_speed" VARCHAR,
  "boat_speed_unit" VARCHAR,
  "current_speed" VARCHAR,
  "current_speed_unit" VARCHAR,
  "toxicity_test_type" VARCHAR,
  "collection_effort" VARCHAR,
  "collection_effort_gear_type" VARCHAR
);