# NOAA National Estuarine Research Reserves

The 30 reserves of the National Estuarine Research Reserve System (NERRS), a NOAA-state partnership; `sitecode` is the reserve's three-letter code, `leadagency` the managing state agency or university.

- **Collection**: `noaa_nerrs` v1.0.1, 30 features, GeoParquet 1.1 (`places.parquet`) and PMTiles (`places.pmtiles`, layer `noaa_nerrs`)
- **Licence**: CC-PDDC - U.S. federal government work (NOAA); the AGOL item carries NOAA's 17 U.S.C. 403 notice (material 'not subject to copyright protection within the United States'; foreign copyrights may apply). Credit NOAA, do not imply endorsement. https://www.copyright.gov/title17/92chap1.html#105
- **Attribution**: National Oceanic and Atmospheric Administration (NOAA), Office for Coastal Management (OCM), via MarineCadastre.gov. Public domain. Processed by Ocean Metrics.
- **Refresh**: monthly, by `.github/workflows/sync.yml` (re-fetched only when the source's `editingInfo.dataLastEditDate` or record count changed)

## Sources and provenance

| Component | Source | Item | Data last edit | Retrieved | Records | Checksum (sha-256 of payload) |
|---|---|---|---|---|---|---|
| - | https://coast.noaa.gov/arcgis/rest/services/Hosted/NationalEstuarineResearchReserveSystem/FeatureServer/0 | c3984675bafb4a4b9bb2b10e045fd76f | not served | 2026-10-08T17:03:45Z | 30 | `0f8db9ea76a3ae3b...` |

Machine-readable copy: [`provenance.json`](./provenance.json) (also in `collection.json` and the Parquet footer).

## Schema

| Column | Type | Description |
|---|---|---|
| place_id | string | prefixed, unique id (e.g. BOEM:OCS-P 0561, BOEM:PA:SOC, AOA:N1-A) |
| authority | string | organisation that publishes the boundary (BOEM, AOA = NOAA Aquaculture Opportunity Areas) |
| source_id | string | the source layer's own identifier for the feature (lease number, planning-area code, OBJECTID, AOA code) |
| name | string | human-readable name |
| place_type | string | kind of place: lease, planning_area or aoa |
| geom_type | string | geometry type (MultiPolygon) |
| status | string | lifecycle status (e.g. active, cancelled, relinquished, settlement_pending, rescinded, draft_proposed, identified) |
| status_source | string | URL that documents the status |
| status_date | string | ISO date (or year) the status took effect or was last confirmed; may be empty |
| source_url | string | the service endpoint or download the boundary was fetched from |
| source_date | date32[day] | date of the source's last data edit (retrieval date when the source serves none) |
| retrieved | timestamp[ms, tz=UTC] | UTC time the boundary was fetched |
| version | string | collection release version this row was built for |
| license | string | SPDX identifier of the licence (CC-PDDC = public-domain U.S. government work) |
| attribution | string | credit line to show with the data |
| objectid | int64 | native attribute of the source layer (objectid) |
| sitecode | string | native attribute of the source layer (sitecode) |
| sitename | string | native attribute of the source layer (sitename) |
| yeardesignated | int64 | native attribute of the source layer (yeardesignated) |
| leadagency | string | native attribute of the source layer (leadagency) |
| acreprotected | int64 | native attribute of the source layer (acreprotected) |
| biogeographicregion | string | native attribute of the source layer (biogeographicregion) |
| siteurl | string | native attribute of the source layer (siteurl) |
| SHAPE__Length | double | native attribute of the source layer (SHAPE__Length) |
| SHAPE__Area | double | native attribute of the source layer (SHAPE__Area) |
| bbox | struct<xmin: double, ymin: double, xmax: double, ymax: double> | GeoParquet bbox-covering column (xmin, ymin, xmax, ymax) |
| geometry | binary | MULTIPOLYGON, EPSG:4326, split at +/-180 antimeridian |

Native attributes keep the source layer's names; a native name equal to a gazetteer column ignoring case
(`NAME` vs `name`) is suffixed `_src`.

## Files

| File | Size | Checksum |
|---|---|---|
| places | 2.1 MB | `1220132e5fc4e783...` |
| places-tiles | 517 kB | `12201a430dbf05d9...` |
| styles/default | 1 kB | `122068a5677f7824...` |
| provenance | 1 kB | `1220732dd604be10...` |
| documentation | 0 kB | `1220e3b0c44298fc...` |

## Quick start

```sql
SELECT place_id, name, status, status_date
FROM read_parquet('https://storage.oceanmetrics.io/gazetteer/noaa_nerrs/places.parquet')
ORDER BY place_id;
```

## Changes

- **1.0.1**: first release.
