[postgis-users] Importing data in Lambert72 (Belgium)

Nicolas Ribot nicolas.ribot at gmail.com
Tue Nov 13 05:14:13 PST 2012


Use the  COPY command to load CSV to a table.

The rest depends if you want to display/use the geometry, or you're only
interested in the coordinates:
• Add a geometry column
• st_makePoint to build a point from coordinates
• A trigger to create the WGS84 point from coordinates with st_transform:
st_transform(st_setSRID(st_makePoint(coordinateX, coordinateY), 31300),


On 13 November 2012 13:54, Jo <winfixit at gmail.com> wrote:

> Hi,
> I've been reading docs, but I'm afraid I can't figure it out on my own.
> I have a csv-file:
> POI_ID;POI_name;coordinateX;coordinateY
> Where X and Y are in Lambert72.
> How can I get these in a table that includes 2 columns with those same
> coordinates in WGS84? Should I have a column with a geometry type and
> a point in it? Can I create a trigger function which updates the WGS84
> as the Lambert72 are inserted?
> Jo
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121113/44047d6f/attachment.html>

More information about the postgis-users mailing list