Two Wrongs

Creatng a Custom Map in QGIS with PostGIS and OpenStreetMap

Creatng a Custom Map in QGIS with PostGIS and OpenStreetMap

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

New connection

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

doubleclick layer

go to “Style”

change from Single Symbol to “Rule Based”

#efebb0

#ddbdaa

#db838a