FACT Sea and Inland Water Ports
Sea and inland waters ports location and tonnage in Europe and US.
Use
Connect to the GitLab container registry with privileges for the FACT group:
docker login -u FACT_token -p glpat-1zG-TQx___xLsPjj2vsG registry.git.nilu.no
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 2022.
All spatial objects are converted to EPSG:4326
Notes
Europe Ports, worldwide but US not well covered. https://ec.europa.eu/eurostat/web/gisco/geodata/reference-data/transport-networks Use field PORT_ID for identification.
Tonnage (in thousand tonnes, quarterly, total values) https://ec.europa.eu/eurostat/databrowser/view/mar_go_qm/default/table?lang=en
US Principal Ports, 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
Authors
Riccardo Boero - ribo@nilu.no