[postgis-users] A couple questions

[Stephen Crawford]

All,

I have a postgis dataset in srid=4269, which is a coordinate system, not a
projection.  I plan on projecting these data for display, with a mix of wms
and wfs.  I'll be using geoserver, and I know I can reproject the wms 'on
the fly'.  However, for the wfs I need to have the data in postgis already
projected.  So the big question is can I just reproject into a new table (or
view)?  And how would I do that?  I also wish to generalize the data for
display, for which it seems I should use simplify().  So I guess I need to
use the units of the projection for the tolerance arg in simplify()?

Thanks,
Steve

Stephen Crawford
Center for Environmental Informatics
GeoVISTA Center
The Pennsylvania State University
814.865.9905
src176 at psu.edu