docker-compose up -d
Note: The PostgreSQL container will bind to port 5433 as defined in the docker-compose.yml
npx prisma migrate deploy --early-access-feature
psql postgresql://test-user:test-password@localhost:5433/interest-points -f berlin-pois.sql
CREATE EXTENSION postgis;
ALTER TABLE "Events" ADD COLUMN "location" GEOGRAPHY(POINT,4326);
shp2pgsql gis_osm_pois_free_1.shp public.berlin-pois > berlin-pois.sql
to convert the shp
file to sql
so that it can be imported into PostgreSQL.