Port Authority Governance schema

​

Covered ports

​

Tables

​

Port authorities (dimension)

​

Meetings

​

Agenda items

​

Claims

​

Facts

​

Minutes

​

Tariffs

​

Tariff items

​

Tariff version tracking

• The old item gets effective_to set to the new version’s effective date
• superseded_by links to the replacement item’s record_id
• modified_at is refreshed

SELECT schedule_no, item_no, description, rate, unit
FROM port_authority_tariff_items
WHERE port_slug = 'jacksonville'
  AND effective_from <= '2025-11-01'
  AND (effective_to IS NULL OR effective_to > '2025-11-01');

​

Claim and fact separation

​

Enum values

​

Governance model

​

Meeting type slugs

​

Passed flag values

​

Cross-dataset joins

​

To AIS Maritime Positions

• Port-level: join port_authorities.unlocode to vessel port-call attribution in AIS Maritime. For example, UNLOCODE USJAX maps to all vessel calls at Jacksonville.
• Terminal-level: join port_authority_terminals.h3_r9 to ais_positions.h3_index at H3 resolution 9. A vessel’s position within a terminal’s H3 cell during a port call attributes the call to that terminal, which joins to lease records for “which lessee was operating that terminal at port-call time.”

​

To Civic Intelligence

​

To Events Timeline

​

Join keys

​

Example queries

SELECT
  f.record_id,
  f.occurred_at,
  c.title,
  c.matter_type,
  c.counterparty_urn,
  f.passed_flag,
  f.vote_tally
FROM port_authority_facts f
JOIN port_authority_claims c
  ON c.port_slug = f.port_slug
  AND c.event_id = f.event_id
  AND c.item_id = f.item_id
WHERE f.port_slug = 'oakland'
  AND c.matter_type ILIKE '%lease%'
  AND f.passed_flag = true
ORDER BY f.occurred_at DESC;

SELECT
  port_slug,
  body_name,
  event_date,
  agenda_file_url,
  minutes_file_url
FROM port_authority_meetings
WHERE minutes_status = 'published'
ORDER BY event_date DESC
LIMIT 25;

SELECT
  old_item.schedule_no,
  old_item.item_no,
  old_item.description,
  old_item.rate AS old_rate,
  new_item.rate AS new_rate,
  old_item.effective_date AS old_effective,
  new_item.effective_date AS new_effective
FROM port_authority_tariff_items old_item
JOIN port_authority_tariff_items new_item
  ON new_item.record_id = old_item.superseded_by
WHERE old_item.port_slug = 'jacksonville'
ORDER BY old_item.schedule_no, old_item.item_no;

SELECT schedule_no, item_no, description, rate, unit
FROM port_authority_tariff_items
WHERE port_slug = 'jacksonville'
  AND effective_from <= '2025-11-01'
  AND (effective_to IS NULL OR effective_to > '2025-11-01');

​

Known limitations

• Fact coverage is port-dependent. Only the Oakland Legistar adapter currently emits fact records with vote tallies and pass/fail outcomes. Other ports will gain fact emission as minutes-PDF extraction is added.
• Tariff items cover JAXPORT only. The tariff parser is currently JAXPORT-shaped. PANYNJ uses a different table layout that requires a separate parser. Other ports (POLA, POLB, Oakland) negotiate pricing via leases rather than publishing item-level tariff schedules.
• Lease and capital project tables are scaffolds. These tables exist in the schema but are not yet populated. Records will appear once the resolution-PDF extractor ships.
• Counterparty resolution is deferred. counterparty_urn on claims and leases stays null until the corporate-registry entity resolution pipeline is available. Lessee names are stored as raw strings in the meantime.
• Meeting dates may be missing. The NY & NJ adapter does not currently parse event dates from document metadata, so event_date is null for PANYNJ meetings.
• Adapter coverage varies. Not all adapters surface the same fields. Granicus and HTML adapters do not provide roll_call or vote_tally data.
• Tariff items are text-based. The rate field is stored as text to accommodate varied formats (ranges, multi-part rates, conditional pricing). Parse with care when doing numeric comparisons.
• Historical depth varies by port. The initial backfill covers approximately one year of meetings. Older records may be added in future collection runs.
• Undated tariff versions. Some earlier JAXPORT tariff versions lack effective_from. The superseded_by chain is still correct, but absolute point-in-time queries against undated periods are imprecise. Use the parent tariff’s tariff_year as a fallback.