PostGIS Cookbook - Second Edition

How it works...

This Python script uses the requests and simplejson libraries to fetch data from the GeoNames wikipediaSearchJSON web service, and the GDAL/OGR library to store geographic information inside the PostGIS database.

First, you create a PostGIS point table to store the geographic data. This is made using the GDAL/OGR bindings. You need to instantiate an OGR PostGIS driver (http://www.gdal.org/drv_pg.html) from where it is possible to instantiate a dataset to connect to your postgis_cookbook database using a specified connection string.

The update parameter in the connection string specifies to the GDAL driver that you will open the dataset for updating.

From the PostGIS dataset, we created a PostGIS layer named wikiplaces that ...