« Return to Thread: insert interactively asc or text files

Re: insert interactively asc or text files

by pere roca :: Rate this Message:

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@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@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

« Return to Thread: insert interactively asc or text files