[postgis-users] again try to draw points

[PINKTOMATE]

Thanks but I used ogr2ogr but only works with shapefiles, it's unable to
take only the dbf file and transform it in sql, could you be more
explicit thanks


El vie, 06-08-2004 a las 09:46, Wood Brent escribió:
> > If I have a TAB DELIMITED TEXT or a excel file of a set of points
with
> > coordinates, how can I map this points with postgis to convert it in
> > shapefile, where I can find the way to do it, thanks
> 
> Firstly, you don't need PostGIS to do this.
> 
> If you do use POstGIS, you'll need some sort of program, generally
Perl or
> shell script, to reformat the file into a WKT file, or some other form
of file
> which can be read into a PostGIS table. You'll then need to use
pgsql2shp to
> create the shape file. 
> 
> If all you want is the shape file, the installing & configuring of
> Postgres/PostGIS and setting up the geometry table is probably
overkill, and
> programs like GDAL/OGR & shapelib are possibly easier. THese are able
to read &
> write shapefiles from a variety of other formats. You would still need
to
> reformat your text file into one of the appropriate formats, but
overall, I
> believe the operation is simpler.
> 
> If you want to manage & query your data, as well as convert it to
shapefile
> format then PostGIS is certainly a more appropriate approach.  
> 
> 
> Brent Wood