Re: [postgis-users] Generating PNGs from PostGIS

2008-09-05 Thread Paul Ramsey
Dylan, Mapserver with variable substitution will do what you want. Define a layer with a DATA string like DATA "the_geom from (%sql%) using unique gid using srid=4326" Then, on the CGI URL line, add a sql= parameter. You'll have to add a DATAPATTERN regex to allow this for securitiy reasons. Ne

Re: [postgis-users] Generating PNGs from PostGIS

2008-09-05 Thread Dane Springmeyer
Hi Dylan, Comments/questions inline... On Sep 5, 2008, at 12:11 PM, Dylan Lorimer wrote: Thanks everyone for the awesome suggestions! Given that I need this to be command line driven, Mapnik looks to be the best option. Well, do you need it to be command line in the sense that you need to

Re: [postgis-users] Generating PNGs from PostGIS

2008-09-05 Thread pcreso
/6/08, Dylan Lorimer <[EMAIL PROTECTED]> wrote: > From: Dylan Lorimer <[EMAIL PROTECTED]> > Subject: [postgis-users] Generating PNGs from PostGIS > To: postgis-users@postgis.refractions.net > Date: Saturday, September 6, 2008, 7:11 AM > Thanks everyone for the awesome sugg

[postgis-users] Generating PNGs from PostGIS

2008-09-05 Thread Dylan Lorimer
Thanks everyone for the awesome suggestions! Given that I need this to be command line driven, Mapnik looks to be the best option. Though the fact that QGIS builds the .map files is tempting as well. In any event, thanks again for the suggestions. I'll report back on how successful I am with Mapnik

Re: [postgis-users] Generating PNGs from PostGIS

2008-09-02 Thread Dane Springmeyer
Dylan, +1 on Webb's suggestion, as Mapnik is a great tool for rendering PNG's from postgis data. Like Regina said, if you are looking for a Graphical tool, OpenJump, QGIS, and uDig are great solutions. But if you are looking for a commandline or scriptable solution and you are into pyth

Re: [postgis-users] Generating PNGs from PostGIS

2008-09-02 Thread Webb Sprague
> > In your opinion, what do you think is the best way to build PNGs from > PostGIS queries? I don't know if it is the best, but "mapnik" and "openstreetmap" might have some utilities you would find useful. -W ___ postgis-users mailing list postgis-user

RE: [postgis-users] Generating PNGs from PostGIS

2008-09-02 Thread Paragon Corporation
path geometry stuff. Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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:

Re: [postgis-users] Generating PNGs from PostGIS

2008-09-02 Thread Mark Leslie
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 qu

[postgis-users] Generating PNGs from PostGIS

2008-09-02 Thread Dylan Lorimer
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 t