USFS Forest Activity Tracking System (FACTS)

Contents

root

README.md

Details

Visibility: Public
Owner: Carl Boettiger
Created: 25 Jul 2026
Last Updated: 25 Jul 2026

Analytics

Contents

Details

Analytics

USFS Forest Activity Tracking System (FACTS)

Contents

root

README.md

Details

Visibility: Public
Owner: Carl Boettiger
Created: 25 Jul 2026
Last Updated: 25 Jul 2026

Analytics

28 days

Downloads

620

Data served

57.4 GB

Countries

28-day downloads

11 Jul 2026

7 Aug 2026

Analytics

Object Preview

Name: README.md
Size: 5 KB
Content Type: text/markdown; charset=utf-8
Last Modified: 25 Jul 2026
Source URL: https://data.source.coop/cboettig/facts/README.md
Cloud URI: s3://us-west-2.opendata.source.coop/cboettig/facts/README.md

Download

Object Preview

USFS FACTS Common Attributes (National, 2026-06)

The Forest Service Activity Tracking System (FACTS) Common Attributes layer — the comprehensive record of planned, accomplished, and completed land-management activities (fire/fuels, silviculture, timber, range, invasive species, watershed, recreation, and more) on US National Forest System lands.

This is a single national dataset merged from all 9 USFS regions (01–06, 08, 09, 10; there is no Region 07), downloaded from the FS Enterprise Data Warehouse (EDW) on 2026-06-24.

Records: 7,324,720 activity records (6,057,664 with geometry; ~17 % are aspatial — see below)
Geometry: Polygon / MultiPolygon, EPSG:4326 (reprojected from source NAD83 / EPSG:4269)
Region field: ADMIN_REGION (values 01–10)
License: Public domain (US Government work)
Source: https://data.fs.usda.gov/geodata/edw/datasets.php?xmlKeyword=FACTS

Assets

Asset	URL
GeoParquet	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.parquet`
PMTiles	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.pmtiles`
H3 hex (res 10)	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06/hex/h0=*/data_0.parquet`
STAC	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06/stac-collection.json`

Important notes

Aspatial records: ~17 % of records (1,267,056) have NULL geometry — FACTS activities recorded without a mapped spatial unit. They are present in the GeoParquet but absent from the hex and PMTiles assets. Add WHERE geom IS NOT NULL to restrict to mapped features.
Hex aggregation: one hex row = one (feature, H3 cell) pair. Per-feature attributes (GIS_ACRES, NBR_UNITS_*, COST_PER_UNIT, …) are repeated on every cell a feature covers — never SUM them on the hex asset without first deduplicating on _cng_fid. Estimate area from hex with COUNT(DISTINCT h10) × cell_area_at_resolution_10.
Coded fields: ACTIVITY_CODE / METHOD_CODE / EQUIPMENT_CODE each have a paired human-readable column (ACTIVITY / METHOD / EQUIPMENT). See the STAC table:columns for value definitions of ADMIN_REGION, PURPOSE_CODE, UOM, FEATURE_TYPE, etc.
Upstream data quality: FACTS contains a few data-entry errors — ~35 features have coordinates outside the US, and ~1,271 records have implausible fiscal years (e.g. 1820, 2050). These are preserved as-is from the source.

MapLibre GL JS

The PMTiles source-layer is common-attributes-2026-06 (this is what MapLibre needs; it is the last path segment of the dataset name, not the source feature-class name).

Fields available in the tiles (for styling/filtering): ADMIN_REGION, ACTIVITY, METHOD, EQUIPMENT, NFPORS_CATEGORY, PURPOSE_CODE, FISCAL_YEAR_COMPLETED, GIS_ACRES, STATE_ABBR, COUNTY_NAME, NAME, TREATMENT_NAME, NEPA_PROJECT_NAME, _cng_fid (join key to the full 110-column GeoParquet). See the STAC PMTiles asset for the full list.

DuckDB

Processing

Generated with cng-datasets; pipeline manifests in boettiger-lab/data-workflows under catalog/facts/k8s/common-attributes-2026-06/. See issue #299.

USFS FACTS Common Attributes (National, 2026-06)

This is a single national dataset merged from all 9 USFS regions (01–06, 08, 09, 10; there is no Region 07), downloaded from the FS Enterprise Data Warehouse (EDW) on 2026-06-24.

Records: 7,324,720 activity records (6,057,664 with geometry; ~17 % are aspatial — see below)
Geometry: Polygon / MultiPolygon, EPSG:4326 (reprojected from source NAD83 / EPSG:4269)
Region field: ADMIN_REGION (values 01–10)
License: Public domain (US Government work)
Source: https://data.fs.usda.gov/geodata/edw/datasets.php?xmlKeyword=FACTS

Assets

Asset	URL
GeoParquet	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.parquet`
PMTiles	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.pmtiles`
H3 hex (res 10)	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06/hex/h0=*/data_0.parquet`
STAC	`https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06/stac-collection.json`

Important notes

Aspatial records: ~17 % of records (1,267,056) have NULL geometry — FACTS activities recorded without a mapped spatial unit. They are present in the GeoParquet but absent from the hex and PMTiles assets. Add WHERE geom IS NOT NULL to restrict to mapped features.
Hex aggregation: one hex row = one (feature, H3 cell) pair. Per-feature attributes (GIS_ACRES, NBR_UNITS_*, COST_PER_UNIT, …) are repeated on every cell a feature covers — never SUM them on the hex asset without first deduplicating on _cng_fid. Estimate area from hex with COUNT(DISTINCT h10) × cell_area_at_resolution_10.
Coded fields: ACTIVITY_CODE / METHOD_CODE / EQUIPMENT_CODE each have a paired human-readable column (ACTIVITY / METHOD / EQUIPMENT). See the STAC table:columns for value definitions of ADMIN_REGION, PURPOSE_CODE, UOM, FEATURE_TYPE, etc.
Upstream data quality: FACTS contains a few data-entry errors — ~35 features have coordinates outside the US, and ~1,271 records have implausible fiscal years (e.g. 1820, 2050). These are preserved as-is from the source.

MapLibre GL JS

The PMTiles source-layer is common-attributes-2026-06 (this is what MapLibre needs; it is the last path segment of the dataset name, not the source feature-class name).

DuckDB

Processing

Generated with cng-datasets; pipeline manifests in boettiger-lab/data-workflows under catalog/facts/k8s/common-attributes-2026-06/. See issue #299.

1INSTALL spatial; LOAD spatial;
2INSTALL httpfs; LOAD httpfs;
3
4-- Activities in Region 5 (Pacific Southwest) completed in FY2023, by activity type
5SELECT ACTIVITY, COUNT(*) AS n, ROUND(SUM(GIS_ACRES)) AS acres
6FROM read_parquet('https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.parquet')
7WHERE ADMIN_REGION = '05'
8  AND FISCAL_YEAR_COMPLETED = 2023
9  AND geom IS NOT NULL
10GROUP BY ACTIVITY
11ORDER BY n DESC
12LIMIT 20;

1INSTALL spatial; LOAD spatial;
2INSTALL httpfs; LOAD httpfs;
3
4-- Activities in Region 5 (Pacific Southwest) completed in FY2023, by activity type
5SELECT ACTIVITY, COUNT(*) AS n, ROUND(SUM(GIS_ACRES)) AS acres
6FROM read_parquet('https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.parquet')
7WHERE ADMIN_REGION = '05'
8  AND FISCAL_YEAR_COMPLETED = 2023
9  AND geom IS NOT NULL
10GROUP BY ACTIVITY
11ORDER BY n DESC
12LIMIT 20;

1-- Hex: area treated per H3 res-10 cell is NOT SUM(GIS_ACRES) (repeated per cell).
2-- Estimate treated area from distinct cells instead:
3SELECT ADMIN_REGION, COUNT(DISTINCT h10) AS res10_cells
4FROM read_parquet('https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06/hex/h0=*/data_0.parquet')
5GROUP BY ADMIN_REGION
6ORDER BY res10_cells DESC;

1-- Hex: area treated per H3 res-10 cell is NOT SUM(GIS_ACRES) (repeated per cell).
2-- Estimate treated area from distinct cells instead:
3SELECT ADMIN_REGION, COUNT(DISTINCT h10) AS res10_cells
4FROM read_parquet('https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06/hex/h0=*/data_0.parquet')
5GROUP BY ADMIN_REGION
6ORDER BY res10_cells DESC;

1<script src="https://unpkg.com/maplibre-gl/dist/maplibre-gl.js"></script>
2<script src="https://unpkg.com/pmtiles/dist/pmtiles.js"></script>
3<script>
4  const protocol = new pmtiles.Protocol();
5  maplibregl.addProtocol("pmtiles", protocol.tile);
6
7  const map = new maplibregl.Map({
8    container: "map",
9    style: "https://demotiles.maplibre.org/style.json",
10    center: [-113, 45],
11    zoom: 5,
12  });
13
14  map.on("load", () => {
15    map.addSource("facts", {
16      type: "vector",
17      url: "pmtiles://https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.pmtiles",
18    });
19    map.addLayer({
20      id: "facts-fill",
21      type: "fill",
22      source: "facts",
23      "source-layer": "common-attributes-2026-06",
24      paint: { "fill-color": "#2e7d32", "fill-opacity": 0.4, "fill-outline-color": "#1b5e20" },
25    });
26  });
27</script>

1<script src="https://unpkg.com/maplibre-gl/dist/maplibre-gl.js"></script>
2<script src="https://unpkg.com/pmtiles/dist/pmtiles.js"></script>
3<script>
4  const protocol = new pmtiles.Protocol();
5  maplibregl.addProtocol("pmtiles", protocol.tile);
6
7  const map = new maplibregl.Map({
8    container: "map",
9    style: "https://demotiles.maplibre.org/style.json",
10    center: [-113, 45],
11    zoom: 5,
12  });
13
14  map.on("load", () => {
15    map.addSource("facts", {
16      type: "vector",
17      url: "pmtiles://https://s3-west.nrp-nautilus.io/public-facts/common-attributes-2026-06.pmtiles",
18    });
19    map.addLayer({
20      id: "facts-fill",
21      type: "fill",
22      source: "facts",
23      "source-layer": "common-attributes-2026-06",
24      paint: { "fill-color": "#2e7d32", "fill-opacity": 0.4, "fill-outline-color": "#1b5e20" },
25    });
26  });
27</script>