[postgis-users] merging tables

Luca Penasa luca.penasa at email.it
Mon Feb 6 02:55:38 PST 2006


into 2 different databases i have 2 tables i need to merge. into the 
first one there are georeferenced data in gauss-boaga format (is the 
italian local implementation of kilometric coordinate system, just like 
UTM). Into the second one there are data in WGS84 format (where have i 
to look for the SRID? maybe in spatial_ref_sys table but how can i 
perform a search?). The tables have exactly the same column names. How 
can i merge the two spatial table into one formatted with gauss-boaga? 
need i to perform a changing of coordinate system?

Thanks
Luca
 
 
 --
 Email.it, the professional e-mail, gratis per te: http://www.email.it/f
 
 Sponsor:
 Suoneria gratuita su www.jamba.it 
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=4610&d=6-2



More information about the postgis-users mailing list