Wetlands Ecological Integrity Human And Natural Disturbance Index Data Package For 2007-2022 At Great Sand Dunes National Park And Preserve

CREATE TABLE nps_imd_romn_wei_hdni_2299406 (
  "id" BIGINT,
  "sitename" VARCHAR,
  "eventname" VARCHAR,
  "dataprocessinglevel" VARCHAR,
  "qc_status" BIGINT,
  "qc_flag" VARCHAR,
  "qc_note" VARCHAR,
  "eventnamehndi" VARCHAR,
  "qc_landscape" BIGINT,
  "qc_flag_landscape" VARCHAR,
  "qc_landscape_comments" VARCHAR,
  "alterations_buffers_landscape_context" BIGINT,
  "l_average_buffer_width" BIGINT,
  "l_land_use_in_100_m_buffer" BIGINT,
  "l_percentage_of_unfragmented_landscape_within_1_km" BIGINT,
  "l_riparian_corridor_continuity_r" BIGINT,
  "l_onsite_land_use" BIGINT,
  "qc_hydrology" DOUBLE,
  "qc_flag_hydrology" VARCHAR,
  "qc_hydrology_comments" VARCHAR,
  "hydrologic_alterations" DOUBLE,
  "hydrologic_alterationspre2021" BIGINT,
  "h_floodplain_interaction_r" DOUBLE,
  "h_upstream_surface_water_retention_gis_r" BIGINT,
  "h_onsite_water_diversions_gis_r" BIGINT,
  "h_hydrological_alterations" BIGINT,
  "qc_physicalchemical" BIGINT,
  "qc_flag_physicalchemical" VARCHAR,
  "qc_physicalchemical_comments" VARCHAR,
  "physicalchemical_disturbance" BIGINT,
  "p_bank_stability_r" DOUBLE,
  "p_substrate_soil_disturbance" BIGINT,
  "p_algal_blooms" BIGINT,
  "p_sediment_turbidity" BIGINT,
  "p_toxics_heavy_metals" BIGINT,
  "p_invasive_dominance" DOUBLE,
  "p_onsite_land_use" DOUBLE,
  "hdi_romn" DOUBLE,
  "hdi_romnpre2021" DOUBLE,
  "qc_beaver" BIGINT,
  "qc_flag_beaver" VARCHAR,
  "qc_beaver_comments" VARCHAR,
  "beaveractivity" BIGINT,
  "beaveractivity_plot" DOUBLE,
  "beaveractivity_complex" BIGINT,
  "beavercurrentlyactive" BIGINT,
  "beavercurrentlyactive_plot" DOUBLE,
  "beavercurrentlyactive_complex" BIGINT,
  "beaverviablehabitat" VARCHAR,
  "beaverhabitatpotential" BIGINT,
  "beaverhabitatpotential_plot" BIGINT,
  "beaverhabitatpotential_complex" BIGINT,
  "beaverhabitathistoric" VARCHAR,
  "beaveractivityhistoricrelevant" BIGINT,
  "beaveractivityhistoricrelevant_plot" BIGINT,
  "beaveractivityhistoricrelevant_complex" BIGINT,
  "beaveractivityhistoricnotrelevant" VARCHAR,
  "qc_ungulate" BIGINT,
  "qc_flag_ungulate" VARCHAR,
  "qc_ungulate_comments" VARCHAR,
  "ungulateactivity" BIGINT,
  "ungulateactivity_plot" DOUBLE,
  "ungulateactivity_complex" BIGINT,
  "roadstreamcrossings" BIGINT,
  "neardist" BIGINT,
  "percentanthro100m" DOUBLE,
  "percentanthro1km" DOUBLE,
  "percentupstream" DOUBLE,
  "catchmentdiversions" BIGINT,
  "wetlandvegdiversions" BIGINT,
  "sumweighted_complex" DOUBLE,
  "qc_sumweighted_complex" BIGINT,
  "qc_flag_sumweighted_complex" VARCHAR,
  "qc_sumweighted_complex_notes" VARCHAR,
  "paved_perccomplex" DOUBLE,
  "developed_perccomplex" DOUBLE,
  "unpaved_perccomplex" DOUBLE,
  "mining_perccomplex" DOUBLE,
  "ag_perccomplex" DOUBLE,
  "heavygraz_perccomplex" DOUBLE,
  "medgraz_perccomplex" DOUBLE,
  "lightgraz_perccomplex" DOUBLE,
  "haying_perccomplex" DOUBLE,
  "exlog_perccomplex" DOUBLE,
  "sellog_perccomplex" DOUBLE,
  "intenserecreat_perccomplex" DOUBLE,
  "modrecreat_perccomplex" DOUBLE,
  "lightrecret_perccomplex" DOUBLE,
  "nouse10yrs_perccomplex" DOUBLE,
  "pristine_perccomplex" DOUBLE,
  "other_perccomplex" DOUBLE,
  "grsa_elk_perccomplex" DOUBLE,
  "landuse_complex_sum" DOUBLE,
  "bison_index_complex" DOUBLE,
  "bison_index_complex_norm" DOUBLE,
  "sumweighted_buffer" DOUBLE,
  "qc_sumweighted_buffer" BIGINT,
  "qc_flag_sumweighted_buffer" VARCHAR,
  "qc_sumweighted_buffer_notes" VARCHAR,
  "paved_percbuffer" DOUBLE
);