# Danger zones and restricted areas (USACE)

Danger zones, restricted areas and similar regulated water areas in coastal and marine waters (422 polygons) from 33 CFR part 334 and the raster navigational charts; `agencyofuse` is the using agency (mostly U.S. Navy and Army). A regulation may have several polygons: the id is state + CFR section, and repeats get ':part' suffixes in OBJECTID order.

- **Collection**: `usace_danger_zones` v1.0.2, 422 features, GeoParquet 1.1 (`places.parquet`) and PMTiles (`places.pmtiles`, layer `usace_danger_zones`)
- **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**: U.S. Army Corps of Engineers (USACE), 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/DangerZonesRestrictedAreas/FeatureServer/0 | 6aa6d02b340d4494b2e18bb388cff786 | not served | 2026-10-16T10:54:37Z | 422 | `1578b876792483db...` |

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 |
| status_upstream | string | the source's own status code, verbatim (e.g. BOEM LEASE_STATUS_CD, AREA_STATUS); null when the source has none. may disagree with `status` |
| status_history | string | JSON array of dated status events [{date, value, source, note}], ascending; null when none is logged |
| 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) |
| boundaryname | string | native attribute of the source layer (boundaryname) |
| state | string | native attribute of the source layer (state) |
| boundarytype | string | native attribute of the source layer (boundarytype) |
| boundaryidentifier | string | native attribute of the source layer (boundaryidentifier) |
| instancecode | string | native attribute of the source layer (instancecode) |
| agencyofuse | string | native attribute of the source layer (agencyofuse) |
| effectivedate | timestamp[ms, tz=UTC] | native attribute of the source layer (effectivedate) |
| 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 | 1.9 MB | `1220812e1156ad1b...` |
| places-tiles | 1.0 MB | `12202ad47ea6e54d...` |
| styles/default | 1 kB | `12203266318e20db...` |
| provenance | 1 kB | `1220bfa96970e21c...` |
| documentation | 0 kB | `1220e3b0c44298fc...` |

## Quick start

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

## Changes

- **1.0.2**: first release.