Source Cooperative is a Radiant Earth project

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

README

Designated Wild and Scenic Rivers

All river segments formally designated under the Wild and Scenic Rivers Act and subsequent legislation.

1,052 segments | LineString | National (including Alaska, Hawaii, Puerto Rico)

Source: American Rivers / rivers.gov

Files

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

PMTiles source-layer name: wild-scenic-designated

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-- Designated rivers by agency and classification
7SELECT AGENCY, CLASSIFICA, COUNT(*) AS segments, SUM(TRY_CAST(SEGMENT_MI AS DOUBLE)) AS miles
8FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-designated.parquet')
9GROUP BY AGENCY, CLASSIFICA ORDER BY miles DESC NULLS LAST LIMIT 15;
10
11-- Wild segments managed by USFS
12SELECT WSR_RIVER_, STATE, SEGMENT_MI, ORV_LIST
13FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-designated.parquet')
14WHERE CLASSIFICA = 'Wild' AND AGENCY ILIKE '%USFS%'
15ORDER BY TRY_CAST(SEGMENT_MI AS DOUBLE) DESC NULLS LAST LIMIT 10;

1INSTALL httpfs; LOAD httpfs;
2SET s3_endpoint='s3-west.nrp-nautilus.io';
3SET s3_url_style='path';
4SET s3_use_ssl=false;
5
6-- Designated rivers by agency and classification
7SELECT AGENCY, CLASSIFICA, COUNT(*) AS segments, SUM(TRY_CAST(SEGMENT_MI AS DOUBLE)) AS miles
8FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-designated.parquet')
9GROUP BY AGENCY, CLASSIFICA ORDER BY miles DESC NULLS LAST LIMIT 15;
10
11-- Wild segments managed by USFS
12SELECT WSR_RIVER_, STATE, SEGMENT_MI, ORV_LIST
13FROM read_parquet('s3://public-rivers/american-rivers/wild-scenic-designated.parquet')
14WHERE CLASSIFICA = 'Wild' AND AGENCY ILIKE '%USFS%'
15ORDER BY TRY_CAST(SEGMENT_MI AS DOUBLE) DESC NULLS LAST LIMIT 10;

1map.addSource('wild-scenic-designated', {
2  type: 'vector',
3  url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-rivers/american-rivers/wild-scenic-designated.pmtiles'
4});
5
6map.addLayer({
7  id: 'wsd-lines',
8  type: 'line',
9  source: 'wild-scenic-designated',
10  'source-layer': 'wild-scenic-designated',
11  paint: {
12    'line-color': [
13      'match', ['get', 'CLASSIFICA'],
14      'Wild', '#1a6b3c',
15      'Scenic', '#2196F3',
16      'Recreational', '#FF9800',
17      '#9C27B0'
18    ],
19    'line-width': 2.5,
20    'line-opacity': 0.9
21  }
22});

1map.addSource('wild-scenic-designated', {
2  type: 'vector',
3  url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-rivers/american-rivers/wild-scenic-designated.pmtiles'
4});
5
6map.addLayer({
7  id: 'wsd-lines',
8  type: 'line',
9  source: 'wild-scenic-designated',
10  'source-layer': 'wild-scenic-designated',
11  paint: {
12    'line-color': [
13      'match', ['get', 'CLASSIFICA'],
14      'Wild', '#1a6b3c',
15      'Scenic', '#2196F3',
16      'Recreational', '#FF9800',
17      '#9C27B0'
18    ],
19    'line-width': 2.5,
20    'line-opacity': 0.9
21  }
22});