[postgis-users] insert interactively asc or text files

[pere roca]

  Hi Chetan and Stephen ,
  many thanks for your offer! I must definitely update about scripting (and
never used perl) along with psql, so I think your perl script will help me
in learning too. 
  Shortly, what I want is to let users see his point data (species
occurences) in my web application (for that I must update a PostGIS table) ;
when session finishes, data should disappear.
  I was thinking to restrict the data to insert (X,Y and species, genus,
family for example) and to have a pre-constructed table in PostGIS with
these columns. I suppose it should minimize much more the work and time to
insert data and should also make much easier the scripting. Chetan, does
your script work fine and quickly for huge data (about... 30.000 records) ?

  Thanks also Stephen for your collaboration! I will inform you about my
progress [ or problems ;.) ]

 



Chetan Tiwari wrote:
> 
> Hi Pere
> I have a little perl script that reads CSV files uploaded via a browser
> and
> inserts the data into a table in postgres. I'll be happy to share that
> with
> you. It's setup to run with active perl and apache on windows, but it
> would
> be fairly easy to tweak it to your system setup.
> 
> - Chetan
> 
> On 7/4/07, pere roca <peroc79 at gmail.com> wrote:
>>
>>
>>   Hi everybody,
>>   I just was wondering if there is some tool to insert automatically data
>> from a .asc or .csv or text file (just X,Y and thematic data) to PostGIS
>> (something similar to shp2pgsql.exe).
>>
>>   What I want to do is that after a user inserts a file in our server,
>> automatically this file is inserted in someway to PostGIS. How would you
>> do
>> it?
>>
>>    Thanks!
>>    Pere
>> --
>> View this message in context: http://www.nabble.com/insert
>> -interactively-asc-or-text-files-tf4022887.html#a11426251
>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> 
> 
> 
> -- 
> Chetan Tiwari, Ph.D. (ABD)
> Dept. of Geography, The Univ. of Iowa
> 316 Jessup Hall, Iowa City, IA 52242
> Ph. (319) 335-0165 Fax (319) 335-2725
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://www.nabble.com/insert-interactively-asc-or-text-files-tf4022887.html#a11442341
Sent from the PostGIS - User mailing list archive at Nabble.com.