- For this recipe, make sure you have the latest GDAL, at least version 1.10, as you will use it with the ogr2ogr the OGR OSM driver (http://www.gdal.org/drv_osm.html):
$ ogrinfo --version GDAL 2.1.2, released 2016/10/24 $ ogrinfo --formats | grep -i osm -> "OSM -vector- (rov): OpenStreetMap XML and PBF"
- As you will use PostgreSQL trigrams, install the PostgreSQL contrib package (which includes pg_trgm). The Windows EDB installer should already include this. In an Ubuntu 12.4 box, the following command will help you to do it:
$ sudo apt-get install postgresql-contrib-9.1
- Make sure to add the pg_trgm extension to the database:
postgis_cookbook=# CREATE EXTENSION pg_trgm; CREATE EXTENSION
You will need to use some OSM ...