About this Dataset

Waterbody - Small Scale

The National Hydrography Dataset (NHD) is a feature-based database that interconnects and uniquely identifies the stream segments or reaches that make up the nation's surface water drainage system. NHD data was originally developed at 1:100,000 scale and exists at that scale for the whole country. High resolution NHD adds detail to the original 1:100,000-scale NHD. (Data for Alaska, Puerto Rico and the Virgin Islands was developed at high-resolution, not 1:100,000 scale.) Like the 1:100,000-scale NHD, high resolution NHD contains reach codes for networked features and isolated lakes, flow direction, names, stream level, and centerline representations for areal water bodies. Reaches are also defined to represent waterbodies and the approximate shorelines of the Great Lakes, the Atlantic and Pacific Oceans and the Gulf of Mexico. The NHD also incorporates the National Spatial Data Infrastructure framework criteria set out by the Federal Geographic Data Committee.
Organization: State of Oregon
Last updated: 2024-02-09T16:03:02.113646
Tags: environment, geoscientificinformation, hydrography, inlandwaters, us

Tables

Table 1

@usgov.state_of_oregon_waterbody_small_scale.table_1

18.65 MB
448512 rows
16 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fdate" TIMESTAMP,
  "gnis_id" VARCHAR,
  "gnis_name" VARCHAR,
  "areasqkm" DOUBLE,
  "elevation" DOUBLE,
  "reachcode" VARCHAR,
  "fcode" BIGINT,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE,
  "comid" BIGINT,
  "resolution" VARCHAR,
  "ftype" VARCHAR,
  "onoffnet" DOUBLE,
  "purpcode" VARCHAR,
  "purpdesc" VARCHAR
);