[postgis-users] again try to draw points

Dylan Keon keon at nacse.org
Fri Aug 6 15:00:21 PDT 2004


As others have stated, it's probably best to first create a shapefile 
using the shapelib tools.  Or if you have MapServer installed and 
configured with Perl/PHP/Python and dbf tools (e.g., configure PHP with 
DBF support), you can use MapScript to do the same thing.

One way to do it:

1) export your Excel table as a delimited text file
2) use shapelib (or MapScript) to parse the file and create a shapefile
3) import shapefile into PostgreSQL/PostGIS using shp2pgsql

--Dylan



On 08/06/2004 02:09 PM, 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



More information about the postgis-users mailing list