Keep it simple
You will need docker and docker-compose installed in your system, in order to run this infrastructure.
Type:
docker compose up
Or, if you want to run it in the background
docker compose up -d
This compositions read secrets from an environment file on this folder: .env.
Create this file with the following format, replacing "POSTGRES_PASSWORD=postgres" by a reasonable value.
HOST_URL=http://localhost
POSTGRES_DB="geodb"
POSTGRES_USER="postgres"
POSTGRES_PASSWORD="postgres"
LOCAL_DATABASE_URL=postgresql://postgres:postgres@postgis:5432/geodb
REMOTE_CAOP_HOST="caop.host.db"
REMOTE_CAOP_PORT="5433"
REMOTE_CAOP_DB="dgt_local"
REMOTE_CAOP_USER="caop_user"
REMOTE_CAOP_PASSWORD="caop_password"
REMOTE_CAOP_URL=postgresql://caop_user:caop_password@caop.host.db:5433/dgt_local
REMOTE_INSPIRE_HOST="inspire.host.db"
REMOTE_INSPIRE_PORT="5434"
REMOTE_INSPIRE_DB="dgt_local"
REMOTE_INSPIRE_USER="inspire_user"
REMOTE_INSPIRE_PASSWORD="inspire_password"
REMOTE_INSPIRE_URL=postgresql://inspire_user:inspire_password@inspire.host.db:5434/dgt_local
For Matomo we need also:
MYSQL_PASSWORD=matomo
MYSQL_DATABASE=matomo
MYSQL_USER=matomo
MARIADB_ROOT_PASSWORD=matomo
MATOMO_DATABASE_ADAPTER=mysql
MATOMO_DATABASE_TABLES_PREFIX=matomo_
MATOMO_DATABASE_USERNAME=matomo
MATOMO_DATABASE_PASSWORD=matomo
MATOMO_DATABASE_DBNAME=matomo
MARIADB_AUTO_UPGRADE=1
MARIADB_INITDB_SKIP_TZINFO=1
Connect to DB:
psql -h localhost -U [USERNAME] -W
Donwload Shapefile from here.
Insert data:
docker run --network=ogcapi-simple_bridge1 -v "${PWD}/data:/mnt" ghcr.io/osgeo/gdal:ubuntu-full-3.8.4 \
ogr2ogr -a_srs "EPSG:3763" -t_srs "EPSG:4326" -f "PostgreSQL" PG:"dbname='geodb' user='postgres'
host='postgis'" /mnt/CRUS+_31_mar_2025.shp -lco GEOMETRY_NAME=geom -lco FID=OBJECTID -lco precision=NO -lco SPATIAL_INDEX=GIST \
-nlt PROMOTE_TO_MULTI -nln crus -overwrite
Create materialised view:
docker compose exec postgis psql -U postgres -d geodb -f /tmp/create-views.sql
Generate MBTiles (but first, uncomment this line on docker compose):
docker compose exec tiles \
martin-cp --output-file /data/crus_31_julho2024.mbtiles \
--mbtiles-type normalized \
"--bbox=-9.52657060387,36.838268541,-6.3890876937,42.280468655" \
--min-zoom 0 \
--max-zoom 10 \
--source crus_31_julho2024 \
--save-config /data/config.yaml \
postgresql://postgres@postgis:5432/geodb
Remove the containers, uncomment line 77 and start the composition again.
docker run -it --rm -v $(pwd)/data:/data emotionalcities/tippecanoe \
tippecanoe -r1 -pk -pf --output-to-directory=/data/tiles/ --force --maximum-zoom=14 \
--extend-zooms-if-still-dropping --no-tile-compression /data/crus_31_julho2024.geojson
Go to http:localhost:8081 and follow the wizard. Confirm everything until you initialized the DB.
In the Superuser section please use
username: user
password: matomo
(Otherwise you have to change this manually in ./matomo/refresh_logs.sh command)
In the Set up a Website section please use http://localhost as Website URL.
Confirm all the next steps until you arrive to the end of the wizard (login screen).
The stats from the logs are refreshed every minute. So wait a minute before logging in.
When the containers are running, run this one-time configuration command:
docker compose exec matomo bash -c 'echo "proxy_uri_header = 1" >> /var/www/html/config/config.ini.php'
If GHC cannot reach to https://ogcapi.dgterritorio.gov.pt/, it is most likely a network problem, as all the containers are in the same composition.
These steps would solve the problem:
- Enter the ghc_web container:
docker exec -it ghc_web bash - Install ping (iputils-ping) and nano
- Ping the apache container and get its internal IP address
- Add this IP address on /etc/hosts and make it point ogcapi.dgterritorio.gov.pt
- It should work now, no need for restart!
This project is released under an MIT License
