There are a couple of alternative approaches to import a Comma Separated Values (CSV) file, which stores attributes and geometries in PostGIS. In this recipe, we will use the approach of importing such a file using the PostgreSQL
COPY command and a couple of PostGIS functions.
We will import the
firenews.csv file that stores a series of web news collected from the various RSS feeds related to forest fires in Europe in the context of the European Forest Fire Information System (EFFIS
), available at http://effis.jrc.ec.europa.eu/.
For each news feed, there are attributes like
size of the fire in hectares,
URL, and so on. Most importantly, there are the
x and ...