Skip to Content
PostGIS Cookbook - Second Edition
book

PostGIS Cookbook - Second Edition

by Stephen Vincent Mather, Pedro Wightman, Bborie Park, Thomas Kraft, Mayra Zurbarán, Paolo Corti
March 2018
Beginner to intermediate content levelBeginner to intermediate
584 pages
14h 31m
English
Packt Publishing
Content preview from PostGIS Cookbook - Second Edition

Getting ready

  1. 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"
  1. 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
  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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

PostgreSQL 13 Cookbook

PostgreSQL 13 Cookbook

Vallarapu Naga Avinash Kumar
PostgreSQL High Performance Cookbook

PostgreSQL High Performance Cookbook

Dinesh Kumar, Chitij Chauhan
Mastering PostGIS

Mastering PostGIS

Dominik Mikiewicz, Michal Mackiewicz, Tomasz Nycz

Publisher Resources

ISBN: 9781788299329Supplemental Content