Traditional Ecological Knowledge Of Keystone Marine Species And Ecosystems, California North Coast MPA Baseline Study, 2014 To 2015
State of California
@usgov.ca_gov_traditional_ecological_knowledge_of_keystone_ma_e1e08dd9
State of California
@usgov.ca_gov_traditional_ecological_knowledge_of_keystone_ma_e1e08dd9
CREATE TABLE mpa_baseline_program_information_north_coast (
"nc_project_short_code" VARCHAR,
"nc_project_title" VARCHAR,
"consumptive" BIGINT,
"nonconsumptive" BIGINT,
"deep" BIGINT,
"estuarinewetland" BIGINT,
"kelpshallowrock" BIGINT,
"middepthrock" BIGINT,
"nearshorepelagic" BIGINT,
"rockyintertidal" BIGINT,
"softintertidal" BIGINT,
"softsubtidal" BIGINT,
"contextual" BIGINT,
"sc_project_description" VARCHAR
);
CREATE TABLE mpa_baseline_program_information_north_coast_metadata (
"nc_mpa_baselineprograminformation_lookuptable_csv" VARCHAR,
"lookup_containing_a_list_of_north_coast_sc_marine_prot_f4f7dfc5" VARCHAR
);
CREATE TABLE mpa_boundary_details_north_coast (
"mpa_name" VARCHAR,
"mpa_designation" VARCHAR,
"mpa_study_region" VARCHAR,
"subsection" BIGINT,
"pretext" VARCHAR,
"coordinate" VARCHAR,
"posttext" VARCHAR,
"lat" DOUBLE,
"long" DOUBLE,
"latddm" VARCHAR,
"longddm" VARCHAR,
"sortorder" BIGINT,
"positionid" VARCHAR
);
CREATE TABLE mpa_boundary_details_north_coast_metadata (
"mpa_name" VARCHAR,
"the_name_of_the_california_marine_protected_area_descr_043f4de7" VARCHAR
);
Anyone who has the link will be able to view this.