Waterway Locks
Federal Geographic Data Committee
@usgov.fgdc_gov_waterway_locks_ddc5f
Federal Geographic Data Committee
@usgov.fgdc_gov_waterway_locks_ddc5f
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"objectid" BIGINT,
"id" BIGINT,
"ndccode" VARCHAR,
"region" VARCHAR,
"rivercd" VARCHAR,
"lockcd" VARCHAR,
"chmbcd" VARCHAR,
"nochmb" BIGINT,
"pmsdata" VARCHAR,
"navstr" VARCHAR,
"chambn" VARCHAR,
"chb1" VARCHAR,
"str1" VARCHAR,
"pmsname" VARCHAR,
"status" BIGINT,
"river" VARCHAR,
"rivermi" DOUBLE,
"bank" VARCHAR,
"lift" BIGINT,
"length" BIGINT,
"chmbul" BIGINT,
"width" BIGINT,
"chmbuw" BIGINT,
"audpa" BIGINT,
"audpb" BIGINT,
"updpthms" BIGINT,
"lwdpthms" BIGINT,
"yearopen" BIGINT,
"gatetype" VARCHAR,
"gate" VARCHAR,
"chnlgth" BIGINT,
"chndptha" BIGINT,
"chndpthb" BIGINT,
"chnwdtha" BIGINT,
"chnwdthb" BIGINT,
"wwprjct" VARCHAR,
"mooring" VARCHAR,
"multi" VARCHAR,
"division" VARCHAR,
"district" VARCHAR,
"state" VARCHAR,
"maint1" VARCHAR,
"oper1" BIGINT,
"owner1" BIGINT,
"town" VARCHAR,
"county1" VARCHAR,
"mooring_r" VARCHAR,
"se_anno_cad_data" VARCHAR
);
Anyone who has the link will be able to view this.