Vital Signs: Seaport Activity by Major Port (2022)

VITAL SIGNS INDICATOR

Seaport Activity (EC18)

FULL MEASURE NAME

Shipping containers moved (TEUs)

LAST UPDATED

July 2022

DESCRIPTION

Seaport activity refers to the quantity of goods moved into or out of the region through seaports. Seaport activity is measured at major ports by the number of shipping containers moved; these are known as twenty-foot equivalent units (TEUs).

DATA SOURCE

Port of Oakland - https://www.oaklandseaport.com/performance/facts-figures/

1998-2021

American Association of Port Authorities: Western Hemisphere Port TEU Container Volumes - http://aapa.files.cms-plus.com/CONTAINER%20TRAFFIC%20NORTH%20AMERICA%201980%20-%202018.xlsx

1990-2018

U.S. Department of Transportation, Bureau of Transportation Statistics: Monthly TEU Data - https://data.bts.gov/Maritime-and-Waterways/Monthly-TEU-Data/rd72-aq8r

2019-2021

Adapting to Rising Tides Program (ART) - https://www.adaptingtorisingtides.org/portfolio/seaport/

CONTACT INFORMATION

vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)

Container volumes include both empty and full containers that move through a given port; they include imports, exports and domestic freight flows.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/vital-signs-seaport-activity-by-major-port-2022-9aa2-i3xj\".\"vital_signs_seaport_activity_by_major_port_2022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.