Source Cooperative is a Radiant Earth project

American Rivers Datasets · Carl Boettiger · Source Cooperative | Source Cooperative

README

Eligible and Suitable Wild and Scenic Rivers

River segments formally assessed for Wild and Scenic River eligibility and suitability by federal land management agencies.

5,357 segments | LineString | National (including Alaska, Hawaii, territories)

Source: American Rivers / federal land management agencies

Files

Format	URL
GeoParquet	`https://s3-west.nrp-nautilus.io/public-rivers/american-rivers/wild-scenic-eligible.parquet`
PMTiles	`https://s3-west.nrp-nautilus.io/public-rivers/american-rivers/wild-scenic-eligible.pmtiles`
H3 hex (res 8)	`https://s3-west.nrp-nautilus.io/public-rivers/american-rivers/wild-scenic-eligible/hex/h0=*/data_0.parquet`

PMTiles source-layer name: wild-scenic-eligible

Line features were hexed to H3 resolution 8 by buffering each segment by the H3 cell circumradius before polyfill.

DuckDB Example

MapLibre GL JS Example

1INSTALL httpfs; LOAD httpfs;
2SET s3_endpoint='s3-west.nrp-nautilus.io';
3SET s3_url_style='path';
4SET s3_use_ssl=false;
5
6-- Suitable segments ready for Congressional designation
7SELECT RIVER_NAME, STATE1, SEGMENT_CL, MILES, ORV
8FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-eligible.parquet')
9WHERE SUITABLE = 'Yes'
10ORDER BY MILES DESC LIMIT 20;
11
12-- Summary by status
13SELECT STATUS, SEGMENT_CL, COUNT(*) AS n
14FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-eligible.parquet')
15GROUP BY STATUS, SEGMENT_CL ORDER BY n DESC;

1INSTALL httpfs; LOAD httpfs;
2SET s3_endpoint='s3-west.nrp-nautilus.io';
3SET s3_url_style='path';
4SET s3_use_ssl=false;
5
6-- Suitable segments ready for Congressional designation
7SELECT RIVER_NAME, STATE1, SEGMENT_CL, MILES, ORV
8FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-eligible.parquet')
9WHERE SUITABLE = 'Yes'
10ORDER BY MILES DESC LIMIT 20;
11
12-- Summary by status
13SELECT STATUS, SEGMENT_CL, COUNT(*) AS n
14FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-eligible.parquet')
15GROUP BY STATUS, SEGMENT_CL ORDER BY n DESC;

1map.addSource('wild-scenic-eligible', {
2  type: 'vector',
3  url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-rivers/american-rivers/wild-scenic-eligible.pmtiles'
4});
5
6map.addLayer({
7  id: 'wse-lines',
8  type: 'line',
9  source: 'wild-scenic-eligible',
10  'source-layer': 'wild-scenic-eligible',
11  paint: {
12    'line-color': [
13      'match', ['get', 'STATUS'],
14      'Suitable', '#1a6b3c',
15      'Eligible', '#2196F3',
16      'Eligible and Not Suitable', '#9E9E9E',
17      '#ccc'
18    ],
19    'line-width': 2
20  }
21});

1map.addSource('wild-scenic-eligible', {
2  type: 'vector',
3  url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-rivers/american-rivers/wild-scenic-eligible.pmtiles'
4});
5
6map.addLayer({
7  id: 'wse-lines',
8  type: 'line',
9  source: 'wild-scenic-eligible',
10  'source-layer': 'wild-scenic-eligible',
11  paint: {
12    'line-color': [
13      'match', ['get', 'STATUS'],
14      'Suitable', '#1a6b3c',
15      'Eligible', '#2196F3',
16      'Eligible and Not Suitable', '#9E9E9E',
17      '#ccc'
18    ],
19    'line-width': 2
20  }
21});