Skip to main content
v2026.11,986 entries · CC-BY 4.0

Macrostrat: Geological Database, API Architecture, and Stratigraphic Research Guide

Macrostrat is an open geological database integrating stratigraphic columns, surface maps, and APIs for deep-time Earth crust and stratigraphic research.

Written and maintained by CASRAI Editorial Board

Published

On this page

Macrostrat is an open-access relational geospatial database and cyberinfrastructure platform designed to integrate, standardize, and synthesize geological data describing the Earth’s upper crust across geographic space and deep time. Developed primarily at the University of Wisconsin–Madison with support from the National Science Foundation, Macrostrat organizes surface geologic maps, regional stratigraphic columns, lithological properties, and chronostratigraphic ages into a unified computational framework accessible through interactive web interfaces and public application programming interfaces (APIs). By bridging macroscopic spatial cartography with microscopic lithological attributes and temporal age models, the platform serves as an essential community data engine for stratigraphy, sedimentology, paleobiology, and basin analysis.

Definition and scope

Macrostrat is formally defined as a multi-scale relational database management system that structures the spatial and temporal distribution of sedimentary, igneous, and metamorphic rocks. Historically originating in the quantitative methodology of macrostratigraphy formulated by Shanan E. Peters at the University of Wisconsin–Madison, the platform began as a systematic digital compilation of regional stratigraphic correlation charts, including the Correlation of Stratigraphic Units of North America (COSUNA) project and the Decade of North American Geology (DNAG) series. Rather than treating geological information as disconnected flat map sheets or localized borehole descriptions, Macrostrat constructs an interconnected four-dimensional representation of Earth’s rock record.

The operational scope of Macrostrat spans four foundational domains: spatial mapping, vertical stratigraphy, controlled geological lexicons, and external database federations. Within the landscape of geological research and academic inquiry, geoscientists frequently encounter fragmented datasets where surface outcrop maps are isolated from subsurface well logs, and where regional formation names vary across geopolitical borders. Macrostrat overcomes this fragmentation by functioning as a discipline-specific repository and synthesis platform that links discrete physical rock units to geographic footprints, standardized lithological classifications, chronostratigraphic intervals, and external specimen archives.

Geographically, Macrostrat houses extensive compilations across continental cratons, passive margins, and oceanic basins. While North America represents the most densely parameterized continental compilation with more than 1,000 regional columns and tens of thousands of units, the system integrates comprehensive global datasets, including scientific ocean drilling sequences from the electronic Ocean Drilling Program (eODP), deep-sea sediment cores, and expanding regional compilations across New Zealand, the Caribbean, South America, and Indonesia. Temporally, the database encompasses the entirety of preserved geologic time, ranging from Archean crystalline basements and Proterozoic successions to Phanerozoic fossiliferous strata and Quaternary surficial deposits.

How it works or how it is used in practice

The operational architecture of Macrostrat relies on a hierarchical relational structure published by Peters, Husson, and Czaplewski (2018), expanded into a multi-scale digital crust infrastructure by Quinn, Idzikowski, and Peters (2023). Understanding this architecture is essential for researchers, laboratory scientists, and data managers who retrieve, model, or submit geological data.

The relational stratigraphic hierarchy

At the foundation of Macrostrat lies a structured hierarchy consisting of Projects, Columns, Packages, and Units:

  • Projects: The highest-level administrative grouping, demarcating major geographic sectors, geological environments, or specialized thematic initiatives (for example, Project 1: North America; Project 3: eODP; Project 5: New Zealand).
  • Columns: Discrete spatial polygons or geographic coordinate centroids that describe the vertical accumulation of rock within a defined region. Each column represents an integrated composite section summarizing local or basin-scale stratigraphy from the surface down to crystalline basement or maximum drill depth.
  • Packages: Chronostratigraphic intervals within a column bounded by major regional unconformities, hiatuses, or erosional surfaces. Packages are foundational for macrostratigraphic analysis because they quantify continuous episodes of sediment accumulation separated by periods of non-deposition or erosion.
  • Units: The fundamental rock-record entities within packages, corresponding to formal lithostratigraphic formations, members, groups, or informal lithodemic units. Every unit carries attributes describing minimum and maximum physical thickness, dominant lithologies, mineralogies, sedimentary structures, and depositional environments.

Chronostratigraphic age models and temporal integration

Macrostrat models geologic time through explicit numerical and interval-based frameworks. Each rock unit is constrained by top age (t_age) and bottom age (b_age) parameters calibrated in millions of years before present (Ma). These boundaries are dynamically linked to international chronostratigraphic standards, such as the International Commission on Stratigraphy (ICS) International Chronostratigraphic Chart. When international boundary dates are recalibrated through improved radiometric dating or astrochronology, Macrostrat updates the underlying timescale definitions, propagating revised numerical estimates across associated units without corrupting the original physical lithostratigraphic associations.

Surface geology and cartographic harmonization

In addition to 1D vertical columns, Macrostrat incorporates multi-scale digital bedrock geology through its Carto and Map subsystems. Geological map polygons (t_polys) gathered from state geological surveys, the United States Geological Survey (USGS), and national geological services are harmonized into standardized spatial layers. Polygons are categorized across spatial scale tiers (tiny, small, medium, and large) and linked to standardized lithology dictionaries and stratigraphic concept names. Through its map tile infrastructure (tiles.macrostrat.org), Macrostrat serves vector and raster tiles that render surface geology seamlessly across web browsers, desktop geographic information systems (GIS), and mobile platforms.

Cross-system federation and FAIR data integration

A defining operational strength of Macrostrat is its tight integration with external cyberinfrastructure platforms, demonstrating robust adherence to FAIR data principles (Findable, Accessible, Interoperable, Reusable). Macrostrat maintains direct foreign-key linkages with the Paleobiology Database (PBDB), allowing researchers to query fossil taxonomic occurrences directly in the context of their hosting lithostratigraphic units. Furthermore, the platform integrates with GeoDeepDive (now xDD), an automated text-mining cyberinfrastructure that scans published geological literature to discover, extract, and associate mentions of formations, stratigraphic names, and geochemical measurements directly to database entities.

Worked programmatic query walkthrough

Access to Macrostrat is enabled through its public REST API v2 (hosted at https://macrostrat.org/api/v2) and client software packages such as rmacrostrat for the R statistical programming environment (Jones et al., 2024). Researchers can query the system using geographic coordinates, stratigraphic unit identifiers, or controlled lithology terms.

Retrieving stratigraphic columns by coordinates

To discover what geological column covers a specific research site or field laboratory, a client submits an HTTP GET request with latitude and longitude parameters. For example, querying the vicinity of the Baraboo District in southern Wisconsin (latitude 43.07°N, longitude -89.40°W) uses the following API endpoint:

GET https://macrostrat.org/api/v2/columns?lat=43.07&lng=-89.4&format=json

The API responds with metadata detailing Column ID 187 (Baraboo District, Sauk County, Wisconsin), including its geographic bounding area, column group (‘Northern Mid-Continent’), project identifier (Project 1), and primary bibliographic references.

Inspecting units within a column

Once the Column ID is identified, an investigator can retrieve all cataloged rock units within that vertical succession:

GET https://macrostrat.org/api/v2/units?col_id=187&format=json

The response payload delivers structured records for 15 distinct lithostratigraphic units spanning the Cambrian through Ordovician successions. Each record provides precise physical and chronostratigraphic properties:

  • Unit Identification: Unit ID 6122 represents the St. Peter Sandstone Formation (unit_name: 'St Peter Fm', strat_name_id: 1985).
  • Chronostratigraphic Boundaries: Top age of 458.20 Ma and bottom age of 459.19 Ma, placing the depositional interval within the Sandbian Stage of the Upper Ordovician.
  • Thickness Constraints: Minimum thickness of 0 meters and maximum thickness of 35 meters, reflecting regional erosional topography and irregular paleokarst relief.
  • Outcrop Exposure: Labeled as both, confirming the unit is exposed at the surface in natural outcrops and accessible in subsurface drill cores.

Cross-referencing fossil collections

Researchers investigating biostratigraphy or paleoecology can query the integrated fossil occurrences associated with the same column:

GET https://macrostrat.org/api/v2/fossils?col_id=187&format=json

This request retrieves linked Paleobiology Database collections, such as macroinvertebrate occurrences in the underlying Oneota Formation (Unit ID 6124, 3 collections and 5 taxonomic occurrences), linking physical stratigraphy directly to macroevolutionary archives.

Macrostrat exists within a broader ecosystem of earth science databases and geological informatics platforms. Understanding how Macrostrat differs from and complements related systems ensures researchers select the appropriate repository for their specific research and data curation workflows.

The following sourced comparative analysis summarizes the primary differences between Macrostrat and adjacent geological and paleoenvironmental platforms:

Platform Governing Body / Institution Primary Architecture Spatial and Temporal Scale API and Programmatic Access Primary Research Application
Macrostrat University of Wisconsin–Madison (NSF) Relational 4D columns, packages, units, and harmonized map polygons Global marine and continental; Archean to Holocene REST API v2 (JSON, CSV, GeoJSON), tile server, rmacrostrat client Quantitative macrostratigraphy, crustal modeling, deep-time rock volume synthesis
USGS NGMDB United States Geological Survey and AASG Geologic map catalog, stratigraphic lexicon (Geolex), and mapping standards United States and territories; Proterozoic to Quaternary Web search catalogs, WMS services, downloadable GIS publications Official statutory map archiving, lithostratigraphic name validation, state survey mapping
PBDB International scientific consortium Taxonomic occurrences, collection localities, and biostratigraphic horizons Global terrestrial and marine fossil record; deep time REST API (JSON, CSV), R packages (paleobioDB) Macroevolutionary paleobiology, extinction dynamics, biodiversity curves
OneGeology International consortium of geological surveys (BGS, BRGM) Federated Web Map Services (WMS) and Web Feature Services (WFS) using GeoSciML Global surface bedrock and superficial geology OGC web services (WMS/WFS/WMTS), GeoSciML XML exchange Interoperable global geological cartography, national survey data federation
PANGAEA AWI Bremerhaven and MARUM Bremen Curated data publisher for earth and environmental science tabular datasets Global oceans, ice cores, terrestrial environments; Cenozoic to modern REST API, OAI-PMH metadata harvest, registered DOI datasets Archiving citable geochemical, oceanographic, and paleoclimate observational datasets

As summarized above, while repositories such as PANGAEA focus on archiving citable, tabular observational datasets from marine and terrestrial expeditions, and platforms like OneGeology federate cartographic services across national geological surveys, Macrostrat provides the quantitative relational framework that links physical rock bodies across time and space into computable crustal volumes.

Where it matters for labs, clinics or supply decisions

While Macrostrat is primarily an earth and environmental science cyberinfrastructure rather than a clinical medical system, it provides direct operational utility for analytical laboratories, research facility managers, field expedition planners, and research administration offices.

Analytical laboratories and specimen provenance

In analytical geochemistry, geochronology, and isotope laboratories, sample integrity depends upon precise provenance metadata. When rock samples, drill cores, or mineral separates are submitted for mass spectrometry (e.g., U-Pb zircon dating, strontium or neodymium isotope analysis), laboratories must anchor analytical results to unambiguous stratigraphic context. Macrostrat provides standardized identifiers for columns (col_id), stratigraphic units (unit_id), and stratigraphic names (strat_name_id). Integrating these identifiers into laboratory information management systems (LIMS) prevents errors where colloquial or obsolete formation names compromise geochemical databases.

Field expeditions and geological sampling planning

For field research teams and geological expeditions, Macrostrat serves as an essential pre-field planning and operational utility. Through its mobile application Rockd, researchers in the field can establish their geographic position via GPS and instantly retrieve the mapped bedrock unit, its constituent lithologies, expected age range, and previously cataloged fossil collections. This spatial context allows field teams to optimize consumable equipment (such as core drill bits, sample bags, and field reagents) by anticipating rock hardness, mineralogical abrasiveness, and stratigraphic boundaries before initiating sampling campaigns.

Macroevolutionary and paleoclimate sampling bias correction

In quantitative paleobiology and sedimentary basin research, a persistent scientific challenge is distinguishing genuine biological signals from geological preservation biases (the ‘common cause’ hypothesis). Sedimentary rock volume and preserved surface area fluctuate dramatically across deep time due to sea-level fluctuations and tectonic cycles. By utilizing Macrostrat’s measured package thicknesses and column areas, researchers can calculate total preserved sedimentary volume and surface area per geological interval. This volume baseline allows scientists to statistically normalize biodiversity curves, ensuring that perceived extinction or radiation events reflect true biological phenomena rather than fluctuations in rock availability.

Institutional data curation and FAIR compliance

Research institutions, university libraries, and funding compliance offices utilize Macrostrat’s open APIs and controlled vocabularies to satisfy federal data management sharing plans. Grant recipients working under National Science Foundation (NSF) Division of Earth Sciences awards can cross-link field specimens and published datasets to Macrostrat entities, guaranteeing long-term discoverability, interoperability, and compliance with FAIR research mandates.

Common misunderstandings

Several persistent misunderstandings surround Macrostrat’s structure, capabilities, and data representations:

  • Assuming Macrostrat is merely a digitized map library: A frequent misconception is treating Macrostrat as a standard GIS raster and vector repository. In reality, Macrostrat is a four-dimensional relational database. Its core power lies not in static map displays, but in the relational links connecting map polygons, vertical columns, gap-bound packages, lithological attributes, and chronostratigraphic age models.
  • Equating lithostratigraphic units with chronostratigraphic intervals: Users occasionally assume that rock units in Macrostrat represent fixed, globally synchronous time slices. In sedimentary geology, lithostratigraphic units (such as sandstones or shales) are inherently time-transgressive, meaning their age varies across their geographic extent. Macrostrat explicitly accounts for this by assigning distinct top and bottom ages to units across individual columns rather than enforcing a single global age.
  • Viewing unconformities as missing data errors: Researchers unfamiliar with macrostratigraphy sometimes mistake package hiatuses and missing intervals in columns as database omissions or gaps in record keeping. In geological reality, unconformities and hiatuses represent periods of non-deposition or tectonic erosion. In Macrostrat, these hiatuses are deliberate, load-bearing data entities that define package boundaries and record Earth’s erosional and sea-level history.
  • Assuming global data density is uniform: While Macrostrat’s interface renders a global map, the underlying column density varies significantly by project. Continental North America and scientific ocean drilling (eODP) contain dense, highly parameterized column coverage, whereas regions such as continental Africa and parts of Asia are currently represented by lower-density compilations undergoing active community expansion.
  • Believing age models are permanent and immutable: Numerical ages in Macrostrat are not hard-coded constants; they are dynamic calculations derived from defined chronostratigraphic boundaries. As the International Commission on Stratigraphy refines boundary chronologies, Macrostrat updates its interval definitions, allowing analytical age models to evolve without manual rewriting of individual rock records.

Frequently asked questions

What is the primary difference between a Macrostrat column and a stratigraphic unit?

A Macrostrat column represents a geographic location or region encompassing the complete vertical succession of rocks from the surface to the crystalline basement. A stratigraphic unit is an individual rock body within that column—such as a formal formation, member, or group—defined by distinct lithological characteristics, physical thickness, and chronostratigraphic age boundaries.

How does Macrostrat interface with the Paleobiology Database (PBDB)?

Macrostrat integrates with PBDB through direct foreign-key associations and dedicated API endpoints such as /fossils. When a fossil collection in PBDB is located within a geographic area and stratigraphic interval covered by Macrostrat, the records are linked, allowing researchers to contextualize fossil occurrences within standardized lithological and chronostratigraphic frameworks.

Which programming libraries support automated data extraction from Macrostrat?

The R programming environment features the official rmacrostrat package, published in Geosphere (Jones et al., 2024), which provides dedicated functions for querying columns, units, maps, and stratigraphic definitions. In Python, researchers interact directly with Macrostrat’s REST API v2 using standard HTTP and geospatial libraries such as requests, pandas, and geopandas.

Under what software license are Macrostrat data and APIs distributed?

Macrostrat provides its data and public REST API services under the Creative Commons Attribution 4.0 International license (CC-BY 4.0). This open-access license permits researchers, educators, and commercial developers to share, copy, and adapt the data, provided appropriate attribution is given to the Macrostrat project and its primary data sources.

How does Macrostrat address gaps, unconformities, and missing strata?

Macrostrat treats stratigraphic gaps and unconformities as primary data entities rather than missing values. The database defines packages as intervals of continuous rock accumulation separated by hiatuses. By tracking the duration and spatial extent of these non-depositional and erosional hiatuses, Macrostrat enables quantitative macrostratigraphic modeling of Earth’s sedimentary dynamics.

Can researchers contribute new stratigraphic columns or mapping data to Macrostrat?

Yes. Following the multi-scale, collaborative digital crust framework outlined by Quinn, Idzikowski, and Peters (2023), Macrostrat provides web-based tools and project workflows that enable geoscientists to contribute regional columns, submit local geological map quadrangles, and calibrate stratigraphic names in collaboration with the Macrostrat curation team.

The quantitative data table below summarizes the distribution of stratigraphic columns, packages, rock units, linked paleobiological collections, and geochemical measurements across all major regional projects in the Macrostrat database.

Sources

  • Jones, L. A., Dean, C. D., Gearty, W., and Allen, B. J. (2024). rmacrostrat: An R package for accessing and retrieving data from the Macrostrat geological database. Geosphere, 20(6), 1456–1467. https://doi.org/10.1130/GES02815.1 (Accessed 2026-11-15).
  • Macrostrat Project. (2026). Macrostrat REST API v2 and Data Services Documentation. Department of Geoscience, University of Wisconsin–Madison. https://macrostrat.org/api/v2 (Accessed 2026-11-15).
  • National Science Foundation (NSF). (2018). Collaborative Research: EarthCube Integration: Cyberinfrastructure for Deep-Time Geoscience: Macrostrat. Award Abstract #1830023. https://www.nsf.gov/awardsearch/showAward?AWD_ID=1830023 (Accessed 2026-11-15).
  • Peters, S. E. (2006). Macrostratigraphy of North America. The Journal of Geology, 114(4), 391–412. https://doi.org/10.1086/504176 (Accessed 2026-11-15).
  • Peters, S. E., Husson, J. M., and Czaplewski, J. (2018). Macrostrat: A Platform for Geological Data Integration and Deep-Time Earth Crust Research. Geochemistry, Geophysics, Geosystems, 19(4), 1393–1409. https://doi.org/10.1029/2018GC007467 (Accessed 2026-11-15).
  • Quinn, D. P., Idzikowski, C. R., and Peters, S. E. (2023). Building a multi-scale, collaborative, and time-integrated digital crust: The next stage of the Macrostrat data system. Geoscience Data Journal, 11(1), 11–26. https://doi.org/10.1002/gdj3.189 (Accessed 2026-11-15).

Data: Macrostrat Regional Projects and Crustal Data Compilation

Comprehensive quantitative compilation of regional projects cataloged in the Macrostrat geological database, detailing counts of composite stratigraphic columns, chronostratigraphic packages, rock units, linked Paleobiology Database (PBDB) collections, and geochemical measurement records. Compiled from the official Macrostrat REST API v2 statistics endpoints and foundational project publications.

Period covered: Archean to Holocene (4000 Ma to present). Coverage: Global (North America, New Zealand, Caribbean, South America, Global Oceans).

Macrostrat Regional Projects and Crustal Data Compilation
Regional ProjectStratigraphic Columns (columns)Packages (packages)Lithostratigraphic Units (units)Linked PBDB Collections (collections)Geochemical Measurements (records)
North America1076820827034492661222193
eODP171020299245100
Deep Sea133389735600
New Zealand58710962871328921
Australia143200
Caribbean6424379889711832
South America614691238010699
Africa2114100
North American Ediacaran2186481372011044
North American Cretaceous121300
Indonesia256421200

Sources

Compiled by CASRAI from the sources above. Free to reuse under CC BY 4.0 with attribution.

Follow CASRAI

Research-administration guidance, standards updates and independent tool reviews.

Ask CASRAI · full access

Ask about Macrostrat: Geological Database, API Architecture, and Stratigraphic Research Guide

Full access: large monthly usage, up to 10 source passages behind each answer, and MCP and API access for Claude Code, Codex and other CLIs. Cancel any time.

An AI assistant for research: funder rules, compliance, methods and publishing. It links the sources behind its answers and labels answers that come from a web search.

Answers draw on CASRAI's guides and dictionary plus the federal and funder documents we index: Federal Register, Grants.gov, Regulations.gov and UKRI.

Works on this site and inside Claude, Cursor and the AI tools you already use.

Everything CASRAI publishes — this page, the dictionary, the guides and the news — stays open to read, with no account and no card.

Referenced across the research world

University of Cambridge logoColumbia University logoCrossref logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logoUniversity of Cambridge logoColumbia University logoCrossref logoUniversity of Edinburgh logoHarvard University logoUniversity of Oxford logoPrinceton University logoStanford School of Medicine logoUniversity College London logoORCID logo
  • University of Cambridge logo
  • Columbia University logo
  • Crossref logo
  • University of Edinburgh logo
  • Harvard University logo
  • University of Oxford logo
  • Princeton University logo
  • Stanford School of Medicine logo
  • University College London logo
  • ORCID logo

View CASRAI adoption →