[postgis-users] again try to draw points

[Jaime Mejía]

sorry, i poor english.
Your problem is same....

Re: [postgis-users] Help with wkt and pgsql2shp

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
> @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>





PINKTOMATE wrote:

>No, I need to do it in postgis or postgresql not in arcview
>
>
>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
>>>      
>>>
>
>El vie, 06-08-2004 a las 15:41, Randy James escribió:
>  
>
>>Hi
>>
>>If you have it open in arcview just go to [theme] and [convert to shapefile]
>>
>>
>>--- PINKTOMATE <pinktomate at spymac.com> wrote:
>>
>>    
>>
>>>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
>>>
>>>      
>>>
>>
>>		
>>__________________________________
>>Do you Yahoo!?
>>Read only the mail you want - Yahoo! Mail SpamGuard.
>>http://promotions.yahoo.com/new_mail
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>    
>>
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>  
>