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);
- Download Berlin shp shape file from: https://download.geofabrik.de/europe/germany/berlin-latest-free.shp.zip
- Run
shp2pgsql gis_osm_pois_free_1.shp public.berlin-pois > berlin-pois.sql
to convert theshp
file tosql
so that it can be imported into PostgreSQL.