[postgis-users] Some questions concerning postgis

Chris Hermansen chris.hermansen at timberline.ca
Tue Jan 27 08:07:10 PST 2009

By Gauss Krüger III do you mean zone 3?  That seems to be in 
spatial_ref_sys.  If so, certainly you can re-project your data.

With respect to reducing vertices, you might prefer 
st_simplifypreservetopology().  I've also had success with st_snaptogrid().

Torsten Lange wrote:
> st_simplify() might be a function to reduce the no of vertices. Maybe 
> also st_buffer(yourGeom, 0) could help to get valid polygons in 
> general keeping the geometry.
> Regards, Torsten
> Neil.Young schrieb:
>> Now, that I have valid data in my db, the following questions arise:
>> 1) The projection of the data is Gauss Krüger III. Possible to 
>> re-project to lets say EPSG 4326?
>> 2) The polygons contain too much vertices. I would like to reduce it, 
>> but keep the common borders valid. Does anybody know, how this could 
>> be achieved?
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


Chris Hermansen         mailto:chris.hermansen at timberline.ca
tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.232.0644
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue  · Vancouver BC · Canada · V5Z 1E5

More information about the postgis-users mailing list