FACT Sea and Inland Water Ports

Sea and inland waters ports location and tonnage in Europe and US.

Use

1. Pull the image:

docker pull registry.git.nilu.no/fact/data/fact_ports:latest

2. Run this data service:

docker run -t -i --name fact_ports -e MARIADB_DATABASE=FACT_ports -e MYSQL_ROOT_PASSWORD=devops -p 3312:3306 -d registry.git.nilu.no/fact/data/fact_ports:0.1

The container makes available a MariaDB instance with the full database on sea and inland waters ports FACT_ports. It is reachable on port 3312 of the localhost and the root password is 'devops'.

Specifications

Table            |Size (MB)|Rows (#)|
-----------------+---------+--------+
eu_ports_2009_geo|     0.30|    2201|
eu_ports_2013_geo|     0.34|    2440|
eu_tonnage       |     0.58|   10675|
geometry_columns |     0.02|       3|
spatial_ref_sys  |     0.02|       2|
us_ports_geo     |     0.05|     150|

Column Year in eu_ports is from 1997 to 2023.

All spatial objects are converted to EPSG:4326

Notes

Europe Ports, worldwide but US not well covered (use field PORT_ID for identification):

• https://ec.europa.eu/eurostat/web/gisco/geodata/reference-data/transport-networks

Tonnage (in thousand tonnes, quarterly, total values)

• DOI: 10.2908/MAR_GO_QM

US The Principal Port dataset contains port codes, port names, geographic locations (longitude, latitude), and commodity tonnage summaries (total tons, domestic, foreign, imports and exports):

• https://geodata.bts.gov/datasets/usdot::principal-ports/about

Author

Riccardo Boero - ribo@nilu.no

Licenses

All the code and the resulting docker images in this project are subject to:

• GNU Generla Public License v2.

The data is released under:

• CC BY 4.0 license.

The input data is licensed as:

• Eurostat data
• US BTS data - CC BY 4.0 License

Citation

• Boero, Riccardo. 2024. “FACT Data: Sea and Inland Waters.” OSF. doi:10.17605/OSF.IO/4PJDM.

Part of the Fine scAle eConomic daTa - FACT project:

• Boero, Riccardo. 2024. “Fine scAle eConomic daTa - FACT.” OSF. doi:10.17605/OSF.IO/PV4ZW.