1INSTALL httpfs; LOAD httpfs;
2INSTALL spatial; LOAD spatial;
3
4-- Count features by wetland type in California
5SELECT WETLAND_TYPE, COUNT(*) AS n
6FROM read_parquet('https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2.parquet')
7WHERE state_code = 'CA'
8GROUP BY 1 ORDER BY 2 DESC;
9
10-- Total wetland area (acres) per state — IMPORTANT: dedupe by _cng_fid first when
11-- working with the hex asset, because each feature is repeated on every cell it covers.
12SELECT state_code, SUM(ACRES) AS total_acres
13FROM read_parquet('https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2.parquet')
14GROUP BY 1 ORDER BY 2 DESC;

1INSTALL httpfs; LOAD httpfs;
2INSTALL spatial; LOAD spatial;
3
4-- Count features by wetland type in California
5SELECT WETLAND_TYPE, COUNT(*) AS n
6FROM read_parquet('https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2.parquet')
7WHERE state_code = 'CA'
8GROUP BY 1 ORDER BY 2 DESC;
9
10-- Total wetland area (acres) per state — IMPORTANT: dedupe by _cng_fid first when
11-- working with the hex asset, because each feature is repeated on every cell it covers.
12SELECT state_code, SUM(ACRES) AS total_acres
13FROM read_parquet('https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2.parquet')
14GROUP BY 1 ORDER BY 2 DESC;

1-- Wetland coverage by H3 cell — area in m² approximated from cell count at res 10
2-- (cell area at res 10 ≈ 15047 m²; see mcp-data-server/h3-guide.md for constants)
3SELECT
4  h0,
5  COUNT(DISTINCT h10) AS n_cells,
6  COUNT(DISTINCT h10) * 15047 AS approx_wetland_m2
7FROM read_parquet('https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2/hex/h0=*/data_0.parquet')
8GROUP BY h0
9ORDER BY n_cells DESC;

1-- Wetland coverage by H3 cell — area in m² approximated from cell count at res 10
2-- (cell area at res 10 ≈ 15047 m²; see mcp-data-server/h3-guide.md for constants)
3SELECT
4  h0,
5  COUNT(DISTINCT h10) AS n_cells,
6  COUNT(DISTINCT h10) * 15047 AS approx_wetland_m2
7FROM read_parquet('https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2/hex/h0=*/data_0.parquet')
8GROUP BY h0
9ORDER BY n_cells DESC;

1map.addSource('nwi', {
2  type: 'vector',
3  url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2.pmtiles'
4});
5
6map.addLayer({
7  id: 'nwi-fill',
8  type: 'fill',
9  source: 'nwi',
10  'source-layer': 'nwi-v2',
11  paint: {
12    'fill-color': [
13      'match', ['get', 'WETLAND_TYPE'],
14      'Freshwater Emergent Wetland', '#7fbf7b',
15      'Freshwater Forested/Shrub Wetland', '#1b7837',
16      'Freshwater Pond', '#5aae61',
17      'Lake', '#2166ac',
18      'Riverine', '#4393c3',
19      'Estuarine and Marine Wetland', '#fdb863',
20      'Estuarine and Marine Deepwater', '#e08214',
21      '#bababa'  // Other
22    ],
23    'fill-opacity': 0.6,
24    'fill-outline-color': '#333'
25  }
26});

1map.addSource('nwi', {
2  type: 'vector',
3  url: 'pmtiles://https://s3-west.nrp-nautilus.io/public-wetlands/nwi-v2.pmtiles'
4});
5
6map.addLayer({
7  id: 'nwi-fill',
8  type: 'fill',
9  source: 'nwi',
10  'source-layer': 'nwi-v2',
11  paint: {
12    'fill-color': [
13      'match', ['get', 'WETLAND_TYPE'],
14      'Freshwater Emergent Wetland', '#7fbf7b',
15      'Freshwater Forested/Shrub Wetland', '#1b7837',
16      'Freshwater Pond', '#5aae61',
17      'Lake', '#2166ac',
18      'Riverine', '#4393c3',
19      'Estuarine and Marine Wetland', '#fdb863',
20      'Estuarine and Marine Deepwater', '#e08214',
21      '#bababa'  // Other
22    ],
23    'fill-opacity': 0.6,
24    'fill-outline-color': '#333'
25  }
26});