[postgis-users] Generating PNGs from PostGIS

[Paragon Corporation]

Dylan,

I guess it depends on if you are looking for a command-line solution or not.
For non-commandline ad-hoc queries to png - my personal favorite is OpenJump
for general ad-hoc query and output to png/svg etc.  The only thing which is
not intuitively obvious from using the OpenJump ad-hoc query tool, is you
have to wrap your geometry around ST_AsBinary (or at least that is what I
have found I need to do)

E.g

SELECT ST_AsBinary(the_geom)
from sometable

But then once you've done that you can strikingly elaborate spatial queries
to your hearts content and see the visualization right there and then do a
file save as raster (png, jpg) or save as svg.

For commandline I guess you could use the ST_Assvg functions in postgis and
then use a svg to png tool such as ImageMagick to convert that to png.
Although that would require writing some code since the ST_AsSVG just
provides the path geometry stuff.
 
Hope that helps,
Regina
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
Leslie
Sent: Wednesday, September 03, 2008 1:01 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Generating PNGs from PostGIS

Dylan Lorimer wrote:
> Hi PostGIS Users,
>
> In your opinion, what do you think is the best way to build PNGs from 
> PostGIS queries? I see the shp2img tool but it looks like I'll have to 
> write a load of .map files. I'm hoping there's an easier tool I can 
> use to execute an ogr-driven PostGIS query and construct the PNG from 
> the results.
>
> Any ideas are greatly appreciated!
>
> Cheers,
> dylan
> ----------------------------------------------------------------------
> --
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   
Off the top of my head, I believe both uDig and QGIS are able to save out
PNG images, and both are capable of connecting to a PostGIS server. 
QGIS can even export those pesky .map configuration files for you.

--
Mark Leslie
Geospatial Software Architect
LISAsoft

-------------------------------------------------------------
Ph: +61 2 8570 5000 Fax: +61 2 8570 5099 Mob: +61 Suite 112, Jones Bay Wharf
19-21 Pirrama Rd Pyrmont NSW 2009
-------------------------------------------------------------

LISAsoft is part of the A2end Group of Companies http://www.ardec.com.au
http://www.lisasoft.com http://www.terrapages.com

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users