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

[Nicolas Ribot]

Hi,

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),
4326)

Nicolas


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>