[postgis-users] dbf, excel to sql
Tyler Mitchell
tjmitchell at riverside.bc.ca
Fri Aug 6 15:36:37 PDT 2004
Straightforward problem with no simple answer.
Here's what I would do, though I am very comfortable with these tools :)
-Save xls -> dbf using Excel's save as feature.
-Use ogr2ogr to convert dbf file -> PostGIS
-Calculate the wkb_geometry column (created by ogr2ogr) with an expression
such as:
>> update mypoints set wkb_geometry = 'SRID=1;POINT(' || xcoord || ' ' ||
ycoord || ')'
-Use ogr2ogr to convert PostGIS -> shape file.
Not the simplest solution, but it works without having to use Arcview :)
If you have a one-time conversion requirement, I'm sure someone on the
list with Arcview wouldn't mind helping you out (me for example).
Tyler
postgis-users-bounces at postgis.refractions.net wrote on 08/06/2004 10:14:49
AM:
> thanks for your time, excuse me, but the question is simple
>
> If I have a table in excel with name of point and coordinates x,y, I
> can convert it in .dbf right??, this is the format of data table in
> shapefile arcview, Only I need is to represent this points in a
> shapefile as the same form of command "add event theme" in arcview.
>
>
>
> , is possible by postgis, by shapetools, by what tool????
>
>
> thatÅ› the question
>
> Regards write soon your answer
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list