Contents

Details

Analytics

Home

All Products

Docs

Source Cooperative is a Radiant Earth project

California Dept of Fish and Wildlife · Carl Boettiger · Source Cooperative | Source Cooperative

California Dept of Fish and Wildlife

Name: California Dept of Fish and Wildlife
Creator: Carl Boettiger

Cloud-optimized mirrors of various public data sets prepared by CDFW

Contents

root

Details

Visibility: Public
Owner: Carl Boettiger
Created: 12 Oct 2026
Last Updated: 12 Oct 2026

Analytics

28 days

Downloads

220

Data served

96 MB

Countries

28-day downloads

6 Oct 2026

2 Nov 2026

Analytics

README

California Department of Fish and Wildlife (CDFW) Datasets — `public-cdfw`

Cloud-native mirrors of California Department of Fish and Wildlife (CDFW) conservation and biodiversity data products, published from the CDFW BIOS portal. Datasets are provided as GeoParquet + PMTiles + H3-indexed parquet.

STAC catalog: https://s3-west.nrp-nautilus.io/public-cdfw/stac-collection.json

Areas of Conservation Emphasis (ACE) v3.0 — Terrestrial Biodiversity Summary (`ds2739`)

A statewide ~2.5 mi² hexagon grid (63,890 hexagons) summarizing terrestrial biodiversity value: composite biological-value, rare-richness, native-richness, and Rarity-Weighted-Index ranks/scores (statewide- and ecoregion-normalized) plus per-taxon richness counts (native / rare / endemic for amphibians, reptiles, birds, mammals, plants).

Program version: 3.0 (released Feb 2018); this layer last revised 2024-07-08.
License: CC-BY-4.0 — attribution required.
Source: CDFW ACE, BIOS layer ds2739 (biosds2739_fpu). Program page: https://wildlife.ca.gov/Data/Analysis/ACE.
Caveat: ACE is a coarse-scale decision-support product. Values describe broad landscape patterns and should not be interpreted at the individual-hexagon level or used in place of site-specific evaluation.

Attribution / citation: ACE 3 Working Group and ACE 3 Development Team, California Department of Fish and Wildlife. Using the recommended BIOS citation satisfies the CC-BY-4.0 attribution requirement.

Assets

Format	URL
GeoParquet	`https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.parquet`
PMTiles	`https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.pmtiles`
H3 hex	`https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary/hex/h0=*/data_0.parquet`

MapLibre GL JS

The PMTiles source-layer is terrestrial-biodiversity-summary (the last segment of the dataset path — not the BIOS layer name).

DuckDB

H3 hex — read the aggregation caveat

One hex row = one (ACE-hexagon, H3-cell) pair. Every attribute is a per-hexagon value repeated on each of the ~9 resolution-8 cells a hexagon covers.

Native H3 resolution 8; parent resolution 0 (the partition key). The geometry column is present only on the GeoParquet asset, not on the hex parquet.

README

California Department of Fish and Wildlife (CDFW) Datasets — `public-cdfw`

STAC catalog: https://s3-west.nrp-nautilus.io/public-cdfw/stac-collection.json

Areas of Conservation Emphasis (ACE) v3.0 — Terrestrial Biodiversity Summary (`ds2739`)

Program version: 3.0 (released Feb 2018); this layer last revised 2024-07-08.
License: CC-BY-4.0 — attribution required.
Source: CDFW ACE, BIOS layer ds2739 (biosds2739_fpu). Program page: https://wildlife.ca.gov/Data/Analysis/ACE.
Caveat: ACE is a coarse-scale decision-support product. Values describe broad landscape patterns and should not be interpreted at the individual-hexagon level or used in place of site-specific evaluation.

Assets

Format	URL
GeoParquet	`https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.parquet`
PMTiles	`https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.pmtiles`
H3 hex	`https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary/hex/h0=*/data_0.parquet`

MapLibre GL JS

The PMTiles source-layer is terrestrial-biodiversity-summary (the last segment of the dataset path — not the BIOS layer name).

DuckDB

H3 hex — read the aggregation caveat

One hex row = one (ACE-hexagon, H3-cell) pair. Every attribute is a per-hexagon value repeated on each of the ~9 resolution-8 cells a hexagon covers.

Native H3 resolution 8; parent resolution 0 (the partition key). The geometry column is present only on the GeoParquet asset, not on the hex parquet.

1// import { Protocol } from "pmtiles"; maplibregl.addProtocol("pmtiles", new Protocol().tile);
2map.addSource("ace-terr", {
3  type: "vector",
4  url: "pmtiles://https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.pmtiles"
5});
6
7map.addLayer({
8  id: "ace-biorank-sw",
9  type: "fill",
10  source: "ace-terr",
11  "source-layer": "terrestrial-biodiversity-summary",   // <-- required
12  paint: {
13    "fill-color": [
14      "match", ["get", "BioRankSW"],
15      5, "#006837", 4, "#31a354", 3, "#78c679", 2, "#c2e699", 1, "#ffffcc",
16      "#cccccc"   // 0 / excluded
17    ],
18    "fill-opacity": 0.8
19  }
20});

1// import { Protocol } from "pmtiles"; maplibregl.addProtocol("pmtiles", new Protocol().tile);
2map.addSource("ace-terr", {
3  type: "vector",
4  url: "pmtiles://https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.pmtiles"
5});
6
7map.addLayer({
8  id: "ace-biorank-sw",
9  type: "fill",
10  source: "ace-terr",
11  "source-layer": "terrestrial-biodiversity-summary",   // <-- required
12  paint: {
13    "fill-color": [
14      "match", ["get", "BioRankSW"],
15      5, "#006837", 4, "#31a354", 3, "#78c679", 2, "#c2e699", 1, "#ffffcc",
16      "#cccccc"   // 0 / excluded
17    ],
18    "fill-opacity": 0.8
19  }
20});

1INSTALL spatial; LOAD spatial;
2INSTALL httpfs;  LOAD httpfs;
3
4-- Statewide GeoParquet (one row per ACE hexagon)
5SELECT Hex_ID, County, BioRankSW, RareCount, NtvBird, geom
6FROM read_parquet('https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.parquet')
7WHERE County = 'SAN DIEGO'
8LIMIT 10;
9
10-- Distribution of statewide BioRank
11SELECT BioRankSW, COUNT(*) AS hexes
12FROM read_parquet('https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.parquet')
13GROUP BY 1 ORDER BY 1;

1INSTALL spatial; LOAD spatial;
2INSTALL httpfs;  LOAD httpfs;
3
4-- Statewide GeoParquet (one row per ACE hexagon)
5SELECT Hex_ID, County, BioRankSW, RareCount, NtvBird, geom
6FROM read_parquet('https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.parquet')
7WHERE County = 'SAN DIEGO'
8LIMIT 10;
9
10-- Distribution of statewide BioRank
11SELECT BioRankSW, COUNT(*) AS hexes
12FROM read_parquet('https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary.parquet')
13GROUP BY 1 ORDER BY 1;

1-- ✅ Dedup by Hex_ID before aggregating any count / rank / score
2SELECT BioRankSW, COUNT(*) AS hexes FROM (
3  SELECT DISTINCT Hex_ID, BioRankSW
4  FROM read_parquet('https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary/hex/h0=*/data_0.parquet')
5) GROUP BY 1 ORDER BY 1;
6
7-- ❌ Never SUM Shape__Are (or any count) across hex rows — it multiplies by ~9.
8-- For area use: COUNT(DISTINCT h8) × cell_area_at_resolution_8.

1-- ✅ Dedup by Hex_ID before aggregating any count / rank / score
2SELECT BioRankSW, COUNT(*) AS hexes FROM (
3  SELECT DISTINCT Hex_ID, BioRankSW
4  FROM read_parquet('https://s3-west.nrp-nautilus.io/public-cdfw/ace/terrestrial-biodiversity-summary/hex/h0=*/data_0.parquet')
5) GROUP BY 1 ORDER BY 1;
6
7-- ❌ Never SUM Shape__Are (or any count) across hex rows — it multiplies by ~9.
8-- For area use: COUNT(DISTINCT h8) × cell_area_at_resolution_8.

California Dept of Fish and Wildlife

California Dept of Fish and Wildlife

California Department of Fish and Wildlife (CDFW) Datasets — public-cdfw

Areas of Conservation Emphasis (ACE) v3.0 — Terrestrial Biodiversity Summary (ds2739)

Assets

MapLibre GL JS

DuckDB

H3 hex — read the aggregation caveat

California Department of Fish and Wildlife (CDFW) Datasets — public-cdfw

Areas of Conservation Emphasis (ACE) v3.0 — Terrestrial Biodiversity Summary (ds2739)

Assets

MapLibre GL JS

DuckDB

H3 hex — read the aggregation caveat

California Department of Fish and Wildlife (CDFW) Datasets — `public-cdfw`

Areas of Conservation Emphasis (ACE) v3.0 — Terrestrial Biodiversity Summary (`ds2739`)

California Department of Fish and Wildlife (CDFW) Datasets — `public-cdfw`

Areas of Conservation Emphasis (ACE) v3.0 — Terrestrial Biodiversity Summary (`ds2739`)