MODERATE Staging Environment

This repository contains configuration files and tasks for the MODERATE Staging Environment - a dedicated instance for deploying and testing MODERATE tools and services before they are stable enough for integration into the main Kubernetes cluster.

Solar Cadastre Post-Deployment Configuration

Running the deployment task available here for the Solar Cadastre is not enough to finalize configuration. The following steps need to be performed:

1. Download the v3 database archive and GeoServer raster from the public Solar Cadastre dataset release. V2 is available for older deployments.

   Dataset	Download
   PostGIS seed v3 (default, exported 2026-04-09)	solar-cadaster-postgis-seed-v3.dump
   PostGIS seed v2 (older version, exported 2025-05-08)	solar-cadaster-postgis-seed-v2.dump
   GeoServer PV generation raster	solar-cadaster-pv-generation-cells.tif

   Check the downloads against the SHA-256 checksums in the release notes.

2. Restore the archive into an empty PostgreSQL database with PostGIS and PostGIS Raster available. Both archives use PostgreSQL's custom format and were exported with PostgreSQL 14.15. Restore v3 with:

   pg_restore --no-owner --no-acl --exit-on-error \
     --dbname=YOUR_DATABASE solar-cadaster-postgis-seed-v3.dump

   Replace YOUR_DATABASE with your database name. Set the host, port, user, and authentication through PostgreSQL connection options or environment variables.

3. Follow the Solar Cadastre GeoServer guide to publish the restored database and raster layers. Create a workspace named GeoModerate to match the application's layer references. Use the .tif downloaded above when the guide asks for the raster file.

4. In .env.config, set SOLAR_CADASTRE_GEOSERVER_SCHEME_HOST to the scheme and hostname of your GeoServer instance. Set SOLAR_CADASTRE_GEOSERVER_PATH to /geoserver/GeoModerate/ows for the GeoModerate workspace.