sudo -u postgres createdb dubrovnik
sudo -u postgres psql dubrovnik CREATE EXTENSION IF NOT EXISTS “postgis”; fuzzystrmatch plpgsql postgres_fdw postgis_topology postgis_tiger_geocoder pgrouting
osm2pgsql -s -c -W -d dubrovnik dubrovnik.osm
Layer -> Add Layer -> Add PostGIS Layer
Layer -> Create Layer -> New Temporary Scratch Layer
start clicking to draw the polygon. press backspace to undo a point. press escape to cancel and start over. right click to finish.
press the editing toggle (pencil button) again. choose save.
Vector -> Geoprocessing Tools -> Clip
<stuff about identifier>
Layer -> Filter
filter ferry and cruise. can also do “route is null”
coast line has place = ’peninsula’. filter on route is null and place is null
go to “Style”
change from Single Symbol to “Rule Based”