California Fish Passage Assessment Database [ds69]
State of California
@usgov.ca_gov_california_fish_passage_assessment_database_ds69_89162
State of California
@usgov.ca_gov_california_fish_passage_assessment_database_ds69_89162
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"pad_id" BIGINT,
"passageid" BIGINT,
"streamname" VARCHAR,
"tributaryt" VARCHAR,
"sitename" VARCHAR,
"sitetype" VARCHAR,
"barstatus" VARCHAR,
"species" VARCHAR,
"lifestage" VARCHAR,
"direction" VARCHAR,
"spbarstatus" VARCHAR,
"spprotocol" VARCHAR,
"spassessedby" VARCHAR,
"numstructures" DOUBLE,
"protocol" VARCHAR,
"assessedby" VARCHAR,
"surveydate" VARCHAR,
"trtstatus" VARCHAR,
"yrtreated" DOUBLE,
"treatedby" VARCHAR,
"structowner" VARCHAR,
"landowner" VARCHAR,
"notes" VARCHAR,
"fishwaytype" VARCHAR,
"fishwaystatus" VARCHAR,
"trtneeded" VARCHAR,
"trtrecom" VARCHAR,
"watershed" VARCHAR,
"county" VARCHAR,
"calwathr" VARCHAR,
"calwathu" VARCHAR,
"calwatha" VARCHAR,
"calwathsa" VARCHAR,
"calwatno" DOUBLE,
"nhdcomid" DOUBLE,
"nhdcommeas" DOUBLE,
"llid" DOUBLE,
"begft" DOUBLE,
"route" VARCHAR,
"postmile" DOUBLE,
"divoper" VARCHAR,
"divmobile" VARCHAR,
"updated" TIMESTAMP,
"source" VARCHAR,
"weblegend" VARCHAR,
"point_x" DOUBLE,
"point_y" DOUBLE,
"photo" VARCHAR,
"miles_upst" DOUBLE,
"globalid" VARCHAR
);
Anyone who has the link will be able to view this.