[postgis-users] Display & Print Methods For PostGIS

[Andreas Neumann]

Hi,

there are a lot of different options available.

Many GIS offer Postgis connectors and are scriptable (GRASS, QGIS 
Server, GeoServer).

I personally would also experiment with SVG output. The AsSVG() output 
allows you to convert Postgis geometry to SVG. You'd have to build the 
SVG structure and styling around (using your preferred scripting or 
programming language), but this is very easy. Once you have SVG you can 
either display it directly in the Webbrowser (as SVG) or convert it to 
PDF using tools like a XSL-FO converter, Apache Batik or Inkscape. The 
SVG option is very flexible and gives you complete control over 
everything. It may not be the easiest/fastest route, but it is also not 
very complex and it is very flexible.

Andreas

adam at spatialsystems.org wrote:
> I have about 3,000,000 data points in a PostGIS DB that have speed
> measurements associated.  The measurements were taken every second and I
> bin the measurements by snapping to a several hundred meter grid to
> limit the number of data points.
>
> My question is:  What method would I use to create a PDF map from
> PostGIS?  I'll likely get the roads out of PostGIS from a stored
> shapefile.
>
> How I bin....
> SELECT
> X(binned_speed_data.grid) AS x,
> Y(binned_speed_data.grid) AS y,
> max(binned_speed_data.speed::double precision ) as max_speed,
> avg(binned_speed_data.speed::double precision ) AS avg_speed,
> min(binned_speed_data.speed::double precision ) AS min_speed,
> count(binned_speed_data.speed) AS speed_count
> FROM
> (
> SELECT
> SnapToGrid(speed_data.location, 0.001) AS grid,
> speed_data.speed as speed
> FROM
> speed_data
> WHERE
> speed_data.id = 3
> ) AS binned_speed_data
> GROUP BY
> x,
> y
>
>
>  
>  
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>