[postgis-users] Help with wkt and pgsql2shp

[Robert W. Burgholzer]

Basically, if I understand your question you need to:

1. create a table in postgresql to house your data (any table will do)
2. use the command addGeometryColumn() to the table that you just created: 
(http://postgis.refractions.net/docs/x321.html#AEN391)
3. Use the command GeometryFromText(varchar, integer) to insert your WKT 
data into the table: ( http://postgis.refractions.net/docs/c673.html )
4. Export the resulting data using pgsql2shp



At 10:40 AM 8/6/2004 +0200, you wrote:
>I have a string containng the WKT representation of an area. I need to
>convert it into a shape file. I wanted to use pgsql2shp because i also need
>to store this string. The problem is I need to know how to build a table in
>order to be able to run pgsql2shp on it.
>Could someone explain me the structure of a table as expected by pgsql2shp
>or at least point me to some documentation about it?
>Thx a lot and excuse me if my question is trivial.
>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>Ing. Simone Giannecchini
>NATO Undersea Research Centre
>Viale S. Bartolomeo 400
>19138 La Spezia, Italy
>Tel: 390187527441
>Cell: 3480064736
>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>
>
>
>***PRIVILEGED AND CONFIDENTIAL***
>The information contained in this e-mail message (including any attached 
>files) is intended for the use of the addressee(s) only and is privileged 
>information. The information should neither be posted to the Internet, nor 
>published in any other public domain, without the express permission of 
>the sender. If you are not the intended recipient(s) or the recipient's 
>representative, you are hereby notified that any use, disclosure, copying 
>or distribution of this communication is prohibited. If you have received 
>this communication in error please notify us immediately at 
>postmaster at saclantc.nato.int, and remove this message from your system.
>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users

Robert Burgholzer
Environmental Engineer
MapTech Inc.
http://www.maptech-inc.com/