I have a table in which I store a geometry (point, polygon ect). I want to wrote a python program that "draw" those geometry.
I tried to use pgsql2shp and then gdal_rasterize, but the fact that I have mixed geometry types prevent me to progress any further. And when I try with only one geometry, gdal_raserize raise this error :
Attempt to create 0x0 datasete is illegal, size must be larger than zeo.
Those are the command I run :
pgsql2shp -f shapefile.shp -h localhost -u jenkins -P jenkins -p 5432 video "SELECT geom FROM state WHERE name LIKE \'A%\'" gdal_rasterize -b 1 -b 2 -b 3 -burn 255 -burn 0 -burn 0 -l shapefile shapefile.shp work.tif
The main objective, is to draw those geometry on a map.