March 2018
Beginner to intermediate
584 pages
14h 31m
English
book
PostGIS Cookbook - Second Edition
by Stephen Vincent Mather, Pedro Wightman, Bborie Park, Thomas Kraft, Mayra Zurbarán, Paolo Corti
Content preview from PostGIS Cookbook - Second Edition
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,
Start your free trial
Importing OpenStreetMap data with the osm2pgsql command
In this recipe, you will import OpenStreetMap (OSM) data to PostGIS using the osm2pgsql command.
You will first download a sample dataset from the OSM website, and then you will import it using the osm2pgsql command.
You will add the imported layers in GIS desktop software and generate a view to get subdatasets, using the hstore PostgreSQL additional module to extract features based on their tags.