[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