[postgis-users] merging tables

[Emily Gouge]

Luca,

The transform function will convert from one projection to another.
See http://postgis.refractions.net/docs/ch06.html#id2793026.

In order to be able to use this function the projected and source SRIDs must exist in the 
spatial_ref_sys table.  If the geometries in your the source tables have not been assigned a SRID, 
the SetSRID(geometry, integer) function will allow you to assign the correct SRID.

To merge the two tables together you can create a new table with a geometry column in the required 
output projection.  You can then insert into this table the values from your two input tables 
projecting the geometries as necessary.

I hope this gets you started,
Emily


Luca Penasa wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users