[postgis-users] Importing data in Lambert72 (Belgium)
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:
> I've been reading docs, but I'm afraid I can't figure it out on my own.
> I have a csv-file:
> 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?
> postgis-users mailing list
> postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users