<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=380303411-06072007><FONT face=Arial
color=#0000ff size=2>I actually got your last message fine with the attachment
and was able to unzip it so maybe it varies depending on what mailservers people
are using or the mail client.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=380303411-06072007></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>H<SPAN class=380303411-06072007>ope that
helps,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT color=#0000ff><FONT size=2><SPAN
class=380303411-06072007></SPAN></FONT></FONT></FONT><SPAN
class=380303411-06072007></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>R<SPAN
class=380303411-06072007>egina</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Chetan Tiwari<BR><B>Sent:</B> Thursday, July 05, 2007 6:21 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] insert
interactively asc or text files<BR></FONT><BR></DIV>
<DIV></DIV>Hi All
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>It seems like my previous message (see below) was deleted because of the
attachment. Sorry for this off topic question, but is it possible to send
attachments to this list? </DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>- Chetan <BR>
<DIV><BR>
<DIV><SPAN class=gmail_quote>On 7/5/07, <B class=gmail_sendername>Chetan
Tiwari</B> <<A href="mailto:chetan.tiwari@gmail.com">chetan.tiwari@gmail.com
</A>> wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>Hi Pere</DIV>
<DIV> </DIV>
<DIV>I am attaching a zip file with the perl script, an example html form, a
test dataset and setup instructions. I am assuming that your data has the
following columns: id, longitude, latitude, species, genus, family. You can
change this in the script if I got it wrong. It should work fine with large
datasets (30,000 records should not be a problem at all). The script is
configured to work on a windows machine, although with some minor changes to
pathnames, it should work in linux/unix environments as well. Please let me
know if you have any questions or have trouble getting it to work. I've never
sent attachments on this list, so if the zipfile does not come through please
let me know and I'll send it to you directly. </DIV>
<DIV> </DIV>
<DIV>- Chetan</DIV>
<DIV> </DIV>
<DIV>PS This version simply uploads the file to a temp location and then loads
it into postgresql/postgis. I still need to look into Stephen's
suggestion.<BR><BR> </DIV>
<DIV><SPAN class=e id=q_113986fef7ff0172_1>
<DIV><SPAN class=gmail_quote>On 7/5/07, <B class=gmail_sendername>pere
roca</B> <<A onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:peroc79@gmail.com" target=_blank>peroc79@gmail.com</A>> wrote:
</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><BR><BR>Hi
Chetan and Stephen ,<BR>many thanks for your offer! I must definitely update
about scripting (and <BR>never used perl) along with psql, so I think your
perl script will help me<BR>in learning too.<BR>Shortly, what I want is to
let users see his point data (species<BR>occurences) in my web application
(for that I must update a PostGIS table) ; <BR>when session finishes, data
should disappear.<BR>I was thinking to restrict the data to insert (X,Y and
species, genus,<BR>family for example) and to have a pre-constructed table
in PostGIS with<BR>these columns. I suppose it should minimize much more the
work and time to <BR>insert data and should also make much easier the
scripting. Chetan, does<BR>your script work fine and quickly for huge data
(about... 30.000 records) ?<BR><BR>Thanks also Stephen for your
collaboration! I will inform you about my <BR>progress [ or problems ;.)
]<BR><BR></BLOCKQUOTE></DIV></SPAN></DIV><BR
clear=all></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>Chetan Tiwari, Ph.D.
(ABD)<BR>Dept. of Geography, The Univ. of Iowa<BR>316 Jessup Hall, Iowa City, IA
52242<BR>Ph. (319) 335-0165 Fax (319) 335-2725 </DIV></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>