Data Package Metadata   View Summary

LAGOS-US LOCUS v1.0: Data module of location, identifiers, and physical characteristics of lakes and their watersheds in the conterminous U.S.

General Information
Data Package:
Local Identifier:edi.233.2
Title:LAGOS-US LOCUS v1.0: Data module of location, identifiers, and physical characteristics of lakes and their watersheds in the conterminous U.S.
Alternate Identifier:DOI PLACE HOLDER
Abstract:

This data package, LAGOS-US LOCUS v1.0, is one of the core data modules of the LAGOS-US platform that provides an extensible research-ready platform to study the 479,950 lakes and reservoirs larger than or equal to 1 ha in the conterminous US (48 states plus the District of Columbia). This data module contains information on the location, identifiers, and physical characteristics of lakes and their watersheds. The characteristics in this module include: variables that can be obtained from GIS data such as location and geometry; variables that can be derived using GIS processing such as lake watersheds and their geometry, lake glaciation history, and lake connectivity; and commonly used identifiers from GIS and other data products useful for linking with LAGOS-US. LOCUS is based on a snapshot of the high-resolution National Hydrography Dataset product available at the initiation of the project that provided the basis for locating, identifying, and characterizing the geometry of all lakes in LAGOS-US. The database design that supports the LAGOS-US research platform was created based on several important design features. Lakes are the fundamental unit of consideration, all lakes in the spatial extent must be represented (above a minimum size) and most information is connected to individual lakes. The design is modular, interoperable (the modules can be used with each other), and extensible (future database modules can be developed and used in the LAGOS-US research platform by others). Users are encouraged to use the other 2 core data modules that are part of the LAGOS-US platform: GEO (which includes geospatial ecological context at multiple spatial and temporal scales for lakes and their watersheds) and LIMNO (in situ lake surface-water physical, chemical, and biological measurements through time) that are each found in their own data packages.

Publication Date:2021-06-10

People and Organizations
Contact:Cheruvelil, Kendra S (Michigan State University) [  email ]
Creator:Smith, Nicole J (Michigan State University)
Creator:Webster, Katherine E (Michigan State University)
Creator:Rodriguez, Lauren K (Michigan State University)
Creator:Cheruvelil, Kendra S (Michigan State University)
Creator:Soranno, Patricia A (Michigan State University)

Data Entities
Data Table Name:
lake_information.csv
Description:
A table that contains information on each LAGOS-US lake including lake-specific identifiers, zone identifiers for each spatial division containing the focal lake, and coordinate location. Observation-level flags provide additional information of value to users about focal lakes.
Data Table Name:
lake_characteristics.csv
Description:
Table of variables describing lake basin geometry, freshwater connectivity status, and glaciation history for each LAGOS-US lake.
Data Table Name:
lake_watersheds.csv
Description:
Table of variables describing identifiers for lake watersheds (WS) and network watersheds (NWS), as well as geometry metrics for these watersheds for LAGOS-US lakes. Observation-level flags provide additional information of value to users about these watersheds.
Data Table Name:
lake_link.csv
Description:
Table that links LAGOS-US lake identifiers to identifiers from other lake-focused datasets in order to facilitate combining lake-related data among multiple data products.
Other Name:
LOCUS_USER_GUIDE.pdf
Description:
The LAGOS-US LOCUS documentation guide provides an overview of the overall design of the LAGOS-US platform and a description of LAGOS-US LOCUS that includes the database design; data sources and variables; and detailed methods
Other Name:
gis_locus_v1.0_gpkg.zip
Description:
Supplemental file - GIS files containing the lake and watershed geometry as polygons or points in Geopackage format.
Other Name:
gis_locus_v1.0_gdb.zip
Description:
Supplemental file - GIS files containing the lake and watershed geometry as polygons or points in ESRI File Geodatabase format.
Other Name:
LAGOS_GIS_Toolbox-2.0-Beta.zip
Description:
Python/R scripts and accompanying ArcGIS Toolbox tools used to create LAGOS-US LOCUS.
Other Name:
data_dictionary_locus.csv
Description:
Metadata table describing information about each LAGOS-US LOCUS variable. It can be used to map a LAGOS-US variable to its LAGOS-US equivalent, understand the data provenance of each variable, automate data analysis by variable groupings, and control data import.
Other Name:
source_table_locus.csv
Description:
Metadata table used to describe data sources for LAGOS-US LOCUS. It can be used to learn more information about an input data source, including where to find and how to cite data sources summarized into LOCUS variables.
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/007ca4f5ec02bb5809fc661dcfa7a903
Name:lake_information.csv
Description:A table that contains information on each LAGOS-US lake including lake-specific identifiers, zone identifiers for each spatial division containing the focal lake, and coordinate location. Observation-level flags provide additional information of value to users about focal lakes.
Number of Records:479950
Number of Columns:34

Table Structure
Object Name:lake_information.csv
Size:128444012 bytes
Authentication:a9411a9422d320140517d1423be72e12 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 
Column Name:lagoslakeid  
lake_nhdid  
lake_nhdfcode  
lake_nhdftype  
lake_reachcode  
lake_namegnis  
lake_namelagos  
lake_onlandborder  
lake_ismultipart  
lake_missingws  
lake_shapeflag  
lake_lat_decdeg  
lake_lon_decdeg  
lake_elevation_m  
lake_centroidstate  
lake_states  
lake_county  
lake_countyfips  
lake_huc12  
buff100_zoneid  
buff500_zoneid  
ws_zoneid  
nws_zoneid  
hu12_zoneid  
hu8_zoneid  
hu4_zoneid  
county_zoneid  
state_zoneid  
epanutr_zoneid  
omernik3_zoneid  
wwf_zoneid  
mlra_zoneid  
bailey_zoneid  
neon_zoneid  
Definition:unique lake identifier developed by LAGOS-USthe unique Permanent_Identifier from the NHD for each LAGOS lakeNHD five-digit integer code with feature code plus additional characteristics or valuesNHD three-digit integer code providing a unique identifier of feature type for the waterbodyreach code assigned to the water feature by the NHDlake name from the GNIS databaselake name from a combination of data sources; examples are GNIS, WQP, etc.flag indicating lake polygon is adjacent to or crosses the border with Canada or Mexicoflag indicating that the focal lake polygon is multipartflag indicating that the WS for the lake was not delineatedflag indicating lake polygon shape is angular, either triangular or rectangular, or is elongate and very thin relative to length; respectively may indicate the lake is less likely to be natural in origin or is more riverinelatitude of central point inside the NHD lake polygon in decimal degrees; NAD83 projectionlongitude of central point inside the NHD lake polygon in decimal degrees; NAD83 projectionthe elevation of the lake polygon central point, in meters; referenced to the North American Vertical Datum of 1988 or NAVD88 and obtained from the National Elevation Datasettwo-letter postal abbreviation of the state containing the lake central pointtwo-letter postal abbreviations of all states intersecting the focal lake polygonname of county containing the focal lake polygon centroidFederal Information Processing Standard, FIPS, code for the county containing the focal lake polygon centroidthe NHD code for the HUC12 containing the lake centroidunique 100 m buffer identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeidunique 500 m buffer identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeidunique WS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeidunique NWS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeidunique identifier assigned by LAGOS-US for zones in the spatial division HU12unique identifier assigned by LAGOS-US for zones in the spatial division HU8unique identifier assigned by LAGOS-US for zones in the spatial division HU4unique identifier assigned by LAGOS-US for zones in the spatial division countyunique identifier assigned by LAGOS-US for zones in the spatial division stateunique identifier assigned by LAGOS-US for zones in the spatial division EPA Nutrient Ecoregionsunique identifier assigned by LAGOS-US for zones in the spatial division Omernik Level III Ecoregionsunique identifier assigned by LAGOS-US for zones in the spatial division World Wildlife Fund ecoregionsunique identifier assigned by LAGOS-US for zones in the spatial division Major Land Areasunique identifier assigned by LAGOS-US for zones in the spatial division Baileys Ecoregionsunique identifier assigned by LAGOS-US for zones in the spatial division National Ecological Observation Network
Storage Type:float  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
float  
float  
float  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
Measurement Type:rationominalnominalnominalnominalnominalnominalnominalnominalnominalnominalratioratiorationominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominalnominal
Measurement Values Domain:
Unitdimensionless
Typenatural
Min
Max483495 
Definitionthe unique Permanent_Identifier from the NHD for each LAGOS lake
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code39000
Definitionlake or pond--feature type only, no attributes
Source
Code Definition
Code39004
Definitionlake or pond--Hydrographic Category: perennial
Source
Code Definition
Code39009
Definitionlake or pond--Hydrographic Category: perennial, Stage: average water elevation
Source
Code Definition
Code39010
Definitionlake or pond--Hydrographic Category: perennial, Stage: normal pool
Source
Code Definition
Code39011
Definitionlake or pond--Hydrographic Category: perennial, Stage: date of photography
Source
Code Definition
Code39012
Definitionlake or pond--Hydrographic Category: perennial, Stage: spillway elevation
Source
Code Definition
Code43600
Definitionreservoir--feature type only, no attributes
Source
Code Definition
Code43613
Definitionreservoir--Reservoir Type: water storage, Construction Material: nonearthen
Source
Code Definition
Code43615
Definitionreservoir--Reservoir Type: water storage, Construction Material: nonearthen, Hydrog
Source
Code Definition
Code43617
Definitionreservoir--Reservoir Type: water storage
Source
Code Definition
Code43618
Definitionreservoir--Reservoir Type: unspecified, Construction Material: earthen
Source
Code Definition
Code43619
Definitionreservoir--Reservoir Type: unspecified, Construction Material: nonearthen
Source
Code Definition
Code43621
Definitionreservoir--Reservoir Type: water storage, Hydrographic Category: perennial
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code390
Definitionlake/pond
Source
Code Definition
Code436
Definitionreservoir
Source
Definitionreach code assigned to the water feature by the NHD
Definitionlake name from the GNIS database
Definitionlake name from a combination of data sources; examples are GNIS, WQP, etc.
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Codeangular
Definitionlake shape nearly conforms to a rectangle or has an angular shape with few vertices
Source
Code Definition
Codeelongate
Definitionlake shape exceedingly elongate and more riverine
Source
Code Definition
Codenoflag
Definitionlake shape does not meet criteria for angular or elongate
Source
Unitdegree
Typereal
Min24.9555753247 
Max49.3742274365 
Unitdegree
Typereal
Min-124.687754044 
Max-66.998474284 
Unitmeter
Typereal
Min-85.6999969482 
Max4095 
Definitiontwo-letter postal abbreviation of the state containing the lake central point
Definitiontwo-letter postal abbreviations of all states intersecting the focal lake polygon
Definitionname of county containing the focal lake polygon centroid
DefinitionFederal Information Processing Standard, FIPS, code for the county containing the focal lake polygon centroid
Definitionthe NHD code for the HUC12 containing the lake centroid
Definitionunique 100 m buffer identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeid
Definitionunique 500 m buffer identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeid
Definitionunique WS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeid
Definitionunique NWS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeid
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division HU12
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division HU8
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division HU4
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division county
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division state
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division EPA Nutrient Ecoregions
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division Omernik Level III Ecoregions
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division World Wildlife Fund ecoregions
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division Major Land Areas
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division Baileys Ecoregions
Definitionunique identifier assigned by LAGOS-US for zones in the spatial division National Ecological Observation Network
Missing Value Code:
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeY
Explmissing
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
Accuracy Report:                                                                    
Accuracy Assessment:                                                                    
Coverage:                                                                    
Methods:                                                                    

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/fd7fe936d290a12bc6dbf5c41047849e
Name:lake_characteristics.csv
Description:Table of variables describing lake basin geometry, freshwater connectivity status, and glaciation history for each LAGOS-US lake.
Number of Records:479950
Number of Columns:24

Table Structure
Object Name:lake_characteristics.csv
Size:100193818 bytes
Authentication:e3acbfe5dd9a4c67da785f975534801f Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 
Column Name:lagoslakeid  
lake_waterarea_ha  
lake_totalarea_ha  
lake_islandarea_ha  
lake_perimeter_m  
lake_islandperimeter_m  
lake_shorelinedevfactor  
lake_mbgconhull_length_m  
lake_mbgconhull_width_m  
lake_mbgconhull_orientation_deg  
lake_mbgrect_length_m  
lake_mbgrect_width_m  
lake_mbgrect_arearatio  
lake_meanwidth_m  
lake_connectivity_class  
lake_connectivity_fluctuates  
lake_connectivity_permanent  
lake_lakes4ha_upstream_ha  
lake_lakes4ha_upstream_n  
lake_lakes1ha_upstream_ha  
lake_lakes1ha_upstream_n  
lake_lakes10ha_upstream_n  
lake_lakes10ha_upstream_ha  
lake_glaciatedlatewisc  
Definition:unique lake identifier developed by LAGOS-USsurface area of lake waterbody polygon from NHD comprised of open water; islands are excludedtotal area of the lake waterbody polygon from the NHD; includes combined area of open water and any islands within the outer boundarysurface area of any islands contained within the outer boundary of the lake waterbody polygon from NHDperimeter of outer boundary of lake waterbody polygon from the NHD; excludes perimeter of any islandsperimeter of islands contained within the outer boundary of the lake waterbody polygon from the NHDshoreline development factor; calculated as lake_perimeter_m divided by the product of 2 times the square root of pi times lake_waterarea_hathe maximum possible distance between any two vertices of the minimum bounding geometry convex hull that encloses the lake polygonthe maximum width of the lake convex hull polygon along an axis perpendicular to the axis defined by the convex hull lengthorientation of the line defining the convex hull length; calculated as decimal degrees clockwise from northlength of the minimum bounding geometry rectangle by area enclosing the lake polygonwidth of the minimum bounding geometry rectangle by area enclosing the lake polygonratio between lake_waterarea_ha converted to meters squared and the product of lake_mbgrect_length_m and lake_mbgrect_width_m; values near 1 indicate rectangular lake shapemean width of the lake; calculated as lake_waterarea_ha converted to meters squared divided by lake_mbgconhull_length_mmaximum hydrologic connectivity class of the focal lake determined from the NHD network considering both permanent and intermittent-ephemeral flowindicates whether the lake connectivity classification depends on non-permanent flowhydrologic connectivity class of the focal lake determined from the NHD network considering only permanent flowtotal area of lakes greater than or equal to 4 ha upstream of the focal lake, connected via surface streamscount of lakes greater than or equal to 4 ha upstream of the focal lake, connected via surface streamstotal area of lakes greater than or equal to 1 ha upstream of the focal lake, connected via surface streamscount of lakes greater than or equal to 1 ha upstream of the focal lake, connected via surface streamscount of lakes greater than or equal to 10 ha upstream of the focal lake, connected via surface streamstotal area of lakes greater than or equal to 10 ha upstream of the focal lake, connected via surface streamsglaciation status during the Late Wisconsin glaciation; Glaciated status is assigned if any part of the lake polygon is inside the glacial extent
Storage Type:float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
string  
string  
string  
float  
float  
float  
float  
float  
float  
string  
Measurement Type:ratioratioratioratioratioratioratioratioratioratioratioratioratiorationominalnominalnominalratioratioratioratioratiorationominal
Measurement Values Domain:
Unitdimensionless
Typenatural
Min
Max483495 
Unithectare
Typereal
Min1.0000088117 
Max338950.21149 
Unithectare
Typereal
Min1.0000088117 
Max340677.265741 
Unithectare
Typereal
Min
Max34018.1870701 
Unitmeter
Typereal
Min358.293056488 
Max2361303.4668 
Unitmeter
Typereal
Min
Max1491922.24121 
Unitdimensionless
Typereal
Min0.9994750799 
Max42.0338884795 
Unitmeter
Typereal
Min115.417142513 
Max204207.358637 
Unitmeter
Typereal
Min12.5912115656 
Max72490.273117 
Unitdegree
Typereal
Min-0.0002545703 
Max179.999779931 
Unitmeter
Typereal
Min102.660710094 
Max202288.378436 
Unitmeter
Typereal
Min12.5912115656 
Max74691.8757214 
Unitdimensionless
Typereal
Min0.0058722486 
Max0.9999979954 
Unitmeter
Typereal
Min5.4299546448 
Max27998.7983949 
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDrainage
Definitionlake with inflowing streams that has no upstream lakes greater than or equal to 10 ha in surface area
Source
Code Definition
CodeDrainageLk
Definitionlake with inflowing streams that has upstream lakes greater than or equal to 10 ha in surface area
Source
Code Definition
CodeHeadwater
Definitionlake with an outlet but no inlets
Source
Code Definition
CodeIsolated
Definitionlake with no stream connections
Source
Code Definition
CodeTerminal
Definitionlake with inlets but no outlets
Source
Code Definition
CodeTerminalLk
Definitionlake with no outlet but has inflowing streams and has upstream lakes greater than or equal to 10 ha in surface area
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDrainage
Definitionlake with inflowing permanent streams that has no upstream lakes greater than or equal to 10 ha in surface area
Source
Code Definition
CodeDrainageLk
Definitionlake with inflowing permanent streams that has upstream lakes greater than or equal to 10 ha in surface area
Source
Code Definition
CodeHeadwater
Definitionlake with an outlet but no permanent stream inlets
Source
Code Definition
CodeIsolated
Definitionlake with no permanent stream connections
Source
Code Definition
CodeTerminal
Definitionlake with inlets but no outlets
Source
Code Definition
CodeTerminalLk
Definitionlake with no outlet but has inflowing streams and has upstream lakes greater than or equal to 10 ha in surface area
Source
Unithectare
Typereal
Min
Max977281.06157 
Unitnumber
Typewhole
Min
Max5497 
Unithectare
Typereal
Min
Max985988.003964 
Unitnumber
Typewhole
Min
Max9881 
Unitnumber
Typewhole
Min
Max3755 
Unithectare
Typereal
Min
Max966267.875853 
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeGlaciated
Definitionlake is located within the maximum extent of the Late Wisconsin glaciation
Source
Code Definition
CodeNot_Glaciated
Definitionlake is not located within the maximum extent of the Late Wisconsin glaciation
Source
Missing Value Code:
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeN
Explavailable
Accuracy Report:                                                
Accuracy Assessment:                                                
Coverage:                                                
Methods:                                                

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/8bd86b94234a21a74991eca7bd9ab883
Name:lake_watersheds.csv
Description:Table of variables describing identifiers for lake watersheds (WS) and network watersheds (NWS), as well as geometry metrics for these watersheds for LAGOS-US lakes. Observation-level flags provide additional information of value to users about these watersheds.
Number of Records:477965
Number of Columns:38

Table Structure
Object Name:lake_watersheds.csv
Size:92753934 bytes
Authentication:90968891ef470dede5f2b4555566f844 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 
Column Name:lagoslakeid  
ws_zoneid  
nws_zoneid  
ws_subtype  
ws_equalsnws  
ws_onlandborder  
ws_oncoast  
ws_inusa_pct  
ws_includeshu4inlet  
ws_ismultipart  
ws_sliverflag  
nws_onlandborder  
nws_oncoast  
nws_inusa_pct  
nws_includeshu4inlet  
nws_ismultipart  
ws_states  
ws_focallakewaterarea_ha  
ws_area_ha  
ws_perimeter_m  
ws_lake_arearatio  
ws_mbgconhull_length_m  
ws_mbgconhull_width_m  
ws_mbgconhull_orientation_deg  
ws_meanwidth_m  
ws_lat_decdeg  
ws_lon_decdeg  
nws_states  
nws_focallakewaterarea_ha  
nws_area_ha  
nws_perimeter_m  
nws_lake_arearatio  
nws_mbgconhull_length_m  
nws_mbgconhull_width_m  
nws_mbgconhull_orientation_deg  
nws_meanwidth_m  
nws_lat_decdeg  
nws_lon_decdeg  
Definition:unique lake identifier developed by LAGOS-USunique WS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeidunique NWS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeidwatershed subtype class for the watershed; LC equals local catchment, DWS equals drainage-watershed, IDWS equals inter-drainage-lake watershedflag indicating that the ws is equivalent to the nwsflag indicating zone is adjacent to or crosses the border with Canada or Mexicoflag indicating the zone is adjacent to an ocean or Great Lakes coastpercent of the zone polygon that is within the US borderflag indicating the WS extends beyond the focal HU4 and is connected via an inlet to an adjoining HU4flag indicating that the focal zone polygon is multipartflag indicating extreme cases where the watershed is comprised of slivers due to flat or constrained terrain that may not accurately reflect surface drainageflag indicating zone is adjacent to or crosses the border with Canada or Mexicoflag indicating the zone is adjacent to an ocean or Great Lakes coastpercent of the zone polygon that is within the US borderflag indicating the NWS extends beyond the focal HU4 and is connected via an inlet to an adjoining HU4flag indicating that the focal zone polygon is multiparttwo-letter postal abbreviations of all states intersecting the zone polygonsurface area of focal lake for which the WS is calculatedarea of zone polygonperimeter of zone polygon including perimeter of any internal holesratio between WS area and lake water areathe maximum possible distance between any two vertices of the minimum bounding geometry convex hull that encloses the WS polygonthe maximum width of the WS convex hull polygon along an axis perpendicular to the axis defined by the convex hull lengthorientation of the line defining the convex hull length; calculated as decimal degrees clockwise from northmean width of the WS polygon; calculated as ws_area_ha converted to hectares and divided by ws_mbgconhull_length_mlatitude of the focal lake central point in decimal degrees; NAD83 projectionlongitude of the focal lake central point in decimal degrees; NAD83 projectiontwo-letter postal abbreviations of all states intersecting the zone polygonsurface area of focal lake for which the NWS is calculatedarea of zone polygonperimeter of zone polygon including perimeters of any internal holesratio between NWS area and lake water areathe maximum possible distance between any two vertices of the minimum bounding geometry convex hull that encloses the NWS polygonthe maximum width of the NWS convex hull polygon along an axis perpendicular to the axis defined by the convex hull lengthorientation of the line defining the convex hull length; calculated as decimal degrees clockwise from northmean width of the NWS polygon; calculated as nws_area_ha converted to hectares and divided by nws_mbgconhull_length_mlatitude of the focal lake central point in decimal degrees; NAD83 projectionlongitude of the focal lake central point in decimal degrees; NAD83 projection
Storage Type:float  
string  
string  
string  
string  
string  
string  
float  
string  
string  
string  
string  
string  
float  
string  
string  
string  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
string  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
Measurement Type:rationominalnominalnominalnominalnominalnominalrationominalnominalnominalnominalnominalrationominalnominalnominalratioratioratioratioratioratioratioratioratiorationominalratioratioratioratioratioratioratioratioratioratio
Measurement Values Domain:
Unitdimensionless
Typenatural
Min
Max483495 
Definitionunique WS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeid
Definitionunique NWS watershed identifier assigned by LAGOS-US; identifier is equivalent to the focal lake lagoslakeid
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDWS
Definitionthe WS is equivalent to the drainage watershed, defined as the area of land that directly drains into the
Source
Code Definition
CodeIDWS
Definitionthe WS is equivalent to the inter-drainage-lake watershed, defined as the area of land that directly drai
Source
Code Definition
CodeLC
Definitionthe WS is equivalent to the local catchment, defined as the area of land that directly drains into the foc
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Unitpercent
Typereal
Min
Max100 
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Unitpercent
Typereal
Min
Max100 
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeY
Definitionyes
Source
Code Definition
CodeN
Definitionno
Source
Definitiontwo-letter postal abbreviations of all states intersecting the zone polygon
Unithectare
Typereal
Min1.000008812 
Max338950.2 
Unithectare
Typereal
Min0.003349037 
Max7732759 
Unitmeter
Typereal
Min23.44588 
Max8944894 
Unitdimensionless
Typereal
Min0.000187334 
Max2451950 
Unitmeter
Typereal
Min8.393114 
Max590490 
Unitmeter
Typereal
Min1.057385 
Max305138.5 
Unitdegree
Typereal
Min0.03865612 
Max179.9726 
Unitmeter
Typereal
Min0.3680541 
Max154560.7 
Unitdegree
Typereal
Min24.95558 
Max49.37423 
Unitdegree
Typereal
Min-124.6878 
Max-66.99847428 
Definitiontwo-letter postal abbreviations of all states intersecting the zone polygon
Unithectare
Typereal
Min1.000009 
Max338950.2 
Unithectare
Typereal
Min18.18116777 
Max11805730 
Unitmeter
Typereal
Min3275.692 
Max7553361 
Unitdimensionless
Typereal
Min0.244530966 
Max5758232.015 
Unitmeter
Typereal
Min745.1845873 
Max830023.5 
Unitmeter
Typereal
Min7.628065 
Max364801.7 
Unitdegree
Typereal
Min0.03865612 
Max179.962 
Unitmeter
Typereal
Min126.9265 
Max196953.3 
Unitdegree
Typereal
Min25.15014 
Max49.37423 
Unitdegree
Typereal
Min-124.6372 
Max-67.09087576 
Missing Value Code:
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
Accuracy Report:                                                                            
Accuracy Assessment:                                                                            
Coverage:                                                                            
Methods:                                                                            

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/5488e333ce818597fa3dbfc9b4e0c131
Name:lake_link.csv
Description:Table that links LAGOS-US lake identifiers to identifiers from other lake-focused datasets in order to facilitate combining lake-related data among multiple data products.
Number of Records:937677
Number of Columns:30

Table Structure
Object Name:lake_link.csv
Size:231810334 bytes
Authentication:f9356093d205fb35d64f509a82969c46 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 
Column Name:lagoslakeid  
lake_nhdid  
lake_reachcode  
lake_namegnis  
lake_namelagos  
lake_county  
lake_countyfips  
lake_lat_decdeg  
lake_lon_decdeg  
lake_centroidstate  
nhdhr_area_sqkm  
nhdhr_fdate  
nhdhr_gnisid  
lagosus_legacysiteid  
lagosus_legacysitelabel  
lagosus_legacyprogram  
wqp_monitoringlocationidentifier  
wqp_monitoringlocationname  
wqp_providername  
nhdplusv2_comid  
nhdplusv2_reachcode  
nhdplusv2_area_sqkm  
lagosne_lagoslakeid  
lagosne_legacysiteid  
nla2007_siteid  
nla2012_siteid  
nhdplusv2_lakes_n  
lagosne_lakes_n  
wqp_sites_n  
lagosus_legacyids_n  
Definition:unique lake identifier developed by LAGOS-USthe unique Permanent_Identifier from the NHD for each LAGOS lakereach code assigned to the water feature by the NHDlake name from the GNIS databaselake name from a combination of data sources; examples are GNIS, WQP, etc.name of county containing the focal lake polygon centroidFederal Information Processing Standard, FIPS, code for the county containing the focal lake polygon centroidlatitude of central point inside the NHD lake polygon in decimal degrees; NAD83 projectionlongitude of central point inside the NHD lake polygon in decimal degrees; NAD83 projectiontwo-letter postal abbreviation of the state containing the lake central pointarea of areal feature based on Albers Equal Area, as assigned in NHDdate of last feature modification in National Hydrography Datasetunique identifier assigned by GNISunique site or lake identifier from the original LAGOS-US water quality source dataset--this is not standardized and each source dataset has its own systemcolumn name or field name used by the source dataset to label the legacy lake identifierprogram name assigned in LAGOS-US to identify the source dataset providera designator used to describe the unique name, number, or code assigned to identify the monitoring locationthe designator specified by the sampling organization for the site at which sampling or other activities are conductedsource system that provided data to the Water Quality Portal; examples are NWIS, STORET, STEWARDS, etc.common identifier of the NHD Waterbody featureNHDplus v2 reach code assigned to the water feature.feature area in square kilometers, as assigned by NHDunique lake identifier developed for LAGOS-NEunique site/lake identifier from the original LAGOS-NE water quality source dataset--this is not standardized and each source dataset has its own systemlake site identifier from National Lakes Assessment 2007 surveylake site identifier from National Lakes Assessment 2012 surveycount of NHDPlusV2 polygons matching the LAGOS-US lagoslakeidcount of LAGOS-NE lagoslakeids matching the LAGOS-US lagoslakeidcount of WQP sites within the LAGOS-US lakecount of all LAGOS-US legacy ids linked to the lagoslakeid in this table; these ids include, for example, original sampling site identifiers
Storage Type:float  
string  
string  
string  
string  
string  
string  
float  
float  
string  
float  
string  
string  
string  
string  
string  
string  
string  
string  
string  
string  
float  
float  
string  
string  
string  
float  
float  
float  
float  
Measurement Type:rationominalnominalnominalnominalnominalnominalratiorationominalrationominalnominalnominalnominalnominalnominalnominalnominalnominalnominalratiorationominalnominalnominalratioratioratioratio
Measurement Values Domain:
Unitdimensionless
Typenatural
Min
Max483495 
Definitionthe unique Permanent_Identifier from the NHD for each LAGOS lake
Definitionreach code assigned to the water feature by the NHD
Definitionlake name from the GNIS database
Definitionlake name from a combination of data sources; examples are GNIS, WQP, etc.
Definitionname of county containing the focal lake polygon centroid
DefinitionFederal Information Processing Standard, FIPS, code for the county containing the focal lake polygon centroid
Unitdegree
Typereal
Min24.9555753246638 
Max49.3742274365049 
Unitdegree
Typereal
Min-124.687754043708 
Max-66.9984742839523 
Definitiontwo-letter postal abbreviation of the state containing the lake central point
UnitsquareKilometers
Typereal
Min0.01 
Max3389.50211575 
Definitiondate of last feature modification in National Hydrography Dataset
Definitionunique identifier assigned by GNIS
Definitionunique site or lake identifier from the original LAGOS-US water quality source dataset--this is not standardized and each source dataset has its own system
Definitioncolumn name or field name used by the source dataset to label the legacy lake identifier
Definitionprogram name assigned in LAGOS-US to identify the source dataset provider
Definitiona designator used to describe the unique name, number, or code assigned to identify the monitoring location
Definitionthe designator specified by the sampling organization for the site at which sampling or other activities are conducted
Definitionsource system that provided data to the Water Quality Portal; examples are NWIS, STORET, STEWARDS, etc.
Definitioncommon identifier of the NHD Waterbody feature
DefinitionNHDplus v2 reach code assigned to the water feature.
UnitsquareKilometers
Typereal
Min
Max4309.715 
Unitdimensionless
Typenatural
Min
Max141379 
Definitionunique site/lake identifier from the original LAGOS-NE water quality source dataset--this is not standardized and each source dataset has its own system
Definitionlake site identifier from National Lakes Assessment 2007 survey
Definitionlake site identifier from National Lakes Assessment 2012 survey
Unitnumber
Typewhole
Min
Max21 
Unitnumber
Typewhole
Min
Max
Unitnumber
Typewhole
Min
Max718 
Unitnumber
Typewhole
Min
Max411 
Missing Value Code:
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeY
Explmissing
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
CodeN
Explavailable
Accuracy Report:                                                            
Accuracy Assessment:                                                            
Coverage:                                                            
Methods:                                                            

Non-Categorized Data Resource

Name:LOCUS_USER_GUIDE.pdf
Entity Type:unknown
Description:The LAGOS-US LOCUS documentation guide provides an overview of the overall design of the LAGOS-US platform and a description of LAGOS-US LOCUS that includes the database design; data sources and variables; and detailed methods
Physical Structure Description:
Object Name:LOCUS_USER_GUIDE.pdf
Size:3498983 bytes
Authentication:27d405e9fc5722bb6986779194ec85e3 Calculated By MD5
Externally Defined Format:
Format Name:application/pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/7c6a7c7229ef72c766b5d66f031c934f

Non-Categorized Data Resource

Name:gis_locus_v1.0_gpkg.zip
Entity Type:unknown
Description:Supplemental file - GIS files containing the lake and watershed geometry as polygons or points in Geopackage format.
Physical Structure Description:
Object Name:gis_locus_v1.0_gpkg.zip
Size:4958214736 bytes
Authentication:a9cc4a0a4db96e4bcbac03f266a802be Calculated By MD5
Externally Defined Format:
Format Name:application/zip
Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/fd70ea9852cda4caa7eb44c0c7348630

Non-Categorized Data Resource

Name:gis_locus_v1.0_gdb.zip
Entity Type:unknown
Description:Supplemental file - GIS files containing the lake and watershed geometry as polygons or points in ESRI File Geodatabase format.
Physical Structure Description:
Object Name:gis_locus_v1.0_gdb.zip
Size:2307923333 bytes
Authentication:0a37f0e60fc97963d6043634eb07925e Calculated By MD5
Externally Defined Format:
Format Name:application/zip
Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/32bfdc6928819f453bfe02589d11890a

Non-Categorized Data Resource

Name:LAGOS_GIS_Toolbox-2.0-Beta.zip
Entity Type:unknown
Description:Python/R scripts and accompanying ArcGIS Toolbox tools used to create LAGOS-US LOCUS.
Physical Structure Description:
Object Name:LAGOS_GIS_Toolbox-2.0-Beta.zip
Size:32044612 bytes
Authentication:8544782c36fe889914942a7ffa756fe5 Calculated By MD5
Externally Defined Format:
Format Name:application/zip
Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/1ea370875d9f93c7dd051731d263461f

Non-Categorized Data Resource

Name:data_dictionary_locus.csv
Entity Type:unknown
Description:Metadata table describing information about each LAGOS-US LOCUS variable. It can be used to map a LAGOS-US variable to its LAGOS-US equivalent, understand the data provenance of each variable, automate data analysis by variable groupings, and control data import.
Physical Structure Description:
Object Name:data_dictionary_locus.csv
Size:40439 bytes
Authentication:db3839c2513e98b045911dff43cf9f8b Calculated By MD5
Externally Defined Format:
Format Name:text/csv
Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/3b8797b29046fbfc97699d1c2d954108

Non-Categorized Data Resource

Name:source_table_locus.csv
Entity Type:unknown
Description:Metadata table used to describe data sources for LAGOS-US LOCUS. It can be used to learn more information about an input data source, including where to find and how to cite data sources summarized into LOCUS variables.
Physical Structure Description:
Object Name:source_table_locus.csv
Size:9042 bytes
Authentication:ec0b1fa7e1bde4f23347b2524162008f Calculated By MD5
Externally Defined Format:
Format Name:text/csv
Data:https://pasta-s.lternet.edu/package/data/eml/edi/233/2/90c9d0d853bad0560587ef9d81a6e447

Data Package Usage Rights

This information is released under the Creative Commons license - Attribution - CC BY (https://creativecommons.org/licenses/by/4.0/). The consumer of these data ("Data User" herein) is required to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. Thank you.

Keywords

By Thesaurus:
LTER Controlled Vocabularylakes, ponds, watersheds, freshwater, limnology, geographic information systems, hydrography

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package
Description:

This section provides a conceptual summary of the methods used to define the lake population,delineate the lake watersheds, and calculate all variables in the LAGOS-US LOCUS data tables. For further technical detail or to attempt to reproduce methods described in this section, users can consult the scripts themselves, published on the EDI repository as LAGOS GIS Toolbox (for convenience, a copy is also available at https://github.com/cont-limno/LAGOS_GIS_Toolbox). The metadata tabledata_dictionary_locus contains a column, methods_tool, that can be used to identify the script (or ArcPy tool name) used to create the variable of interest, if one is available. (Methods implemented manually with no reproducible script are assigned the value “hand” in this table.) For example, if you are interested in the variable lake_onlandborder, the methods_tool value “lagosGIS.lake_processing” indicates to look for the function named lake_processing within the lagosGIS Python module for more information. Source datasets used with the methods can also be identified using the two metadata tables provided in the LOCUS module. The source_code of the associated source datasets are provided in data_dictionary_locus using the columns variable_source_code1 and variable_source_code2 (variables may have one or two source datasets). The short code (nhdhr, ned, tigerbound, etc.) provided here can be linked to a description and citation of the associated source dataset listed in source_table_locus by using a table join or by manually cross-referencing values. Detailed methods for the four data tables lake_information.csv, lake_link.csv, lake_characteristics.csv, and lake_watersheds.csv are found in the LAGOS-US LOCUS documentation guide: Smith, N.J., K.E. Webster, L. Rodriguez, K.S . Cheruvelil, and P.A. Soranno. 2020.LAGOS-US LOCUS v1.0: Module of location, identifiers, and physical characteristics of lakes and their watersheds in the conterminous U.S. Environmental Data Initiative. https://doi.org/XXXXXX.

People and Organizations

Publishers:
Organization:Environmental Data Initiative
Email Address:
info@environmentaldatainitiative.org
Web Address:
https://environmentaldatainitiative.org
Creators:
Individual: Nicole J Smith
Organization:Michigan State University
Email Address:
smithn78@msu.edu
Id:https://orcid.org/0000-0003-2598-7115
Individual: Katherine E Webster
Organization:Michigan State University
Email Address:
katherine.e.webster@gmail.com
Id:https://orcid.org/0000-0002-6009-0146
Individual: Lauren K Rodriguez
Organization:Michigan State University
Email Address:
rodi683@msu.edu
Individual: Kendra S Cheruvelil
Organization:Michigan State University
Email Address:
ksc@msu.edu
Id:https://orcid.org/0000-0003-1880-2880
Individual: Patricia A Soranno
Organization:Michigan State University
Email Address:
soranno@msu.edu
Id:https://orcid.org/0000-0003-1668-9271
Contacts:
Individual: Kendra S Cheruvelil
Organization:Michigan State University
Email Address:
ksc@msu.edu
Id:https://orcid.org/0000-0003-1880-2880

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:
Geographic Region:
Description:conterminous U.S. (lower 48 states and the District of Columbia)
Bounding Coordinates:
Northern:  49Southern:  25
Western:  -125Eastern:  -67

Project

Parent Project Information:

Title:A macrosystems ecology framework for continental-scale prediction and understanding of lakes
Personnel:
Individual: Kendra S Cheruvelil
Organization:Michigan State University
Email Address:
ksc@msu.edu
Id:https://orcid.org/0000-0003-1880-2880
Role:Principal Investigator
Funding: US National Science Foundation US NSF Macrosystems Biology Program grants, DEB‐1638679; DEB‐1638550, DEB‐1638539, DEB‐1638554,USDA National Institute of Food and Agriculture Hatch Project, Grant Number:176820

Maintenance

Maintenance:
Description:completed
Frequency:
Other Metadata

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

UNM logo UW-M logo