[OSGeo Africa] Importing Data into Postgresql

Heidi Van Deventer HvDeventer at csir.co.za
Mon Dec 22 01:28:59 EST 2008


Dear Gavin, Tim or to whom ever this apply:

I would like to point out that I have received confirmation of my removal of this distribution list, yet till receives e-mails from them, as seen in the messages below.

Is there another magic trick to this or should I simply block the list.osgeo?

Perhaps I can herewith proof why so many others keep on asking via e-mail to be removed, and not order pizza...

Heidi



>>> <africa-request at lists.osgeo.org> 17/12/2008 08:11 >>>
Mailing list removal confirmation notice for mailing list Africa

We have received a request for the removal of your email address,
"HvDeventer at csir.co.za" from the africa at lists.osgeo.org mailing list.
To confirm that you want to be removed from this mailing list, simply
reply to this message, keeping the Subject: header intact.  Or visit
this web page:

    http://lists.osgeo.org/mailman/confirm/africa/9e13812a997202a570e80fe3606dc67a2d54b6f8 


Or include the following line -- and only the following line -- in a
message to africa-request at lists.osgeo.org: 

    confirm 9e13812a997202a570e80fe3606dc67a2d54b6f8

Note that simply sending a `reply' to this message should work from
most mail readers, since that usually leaves the Subject: line in the
right form (additional "Re:" text in the Subject: is okay).

If you do not wish to be removed from this list, please simply
disregard this message.  If you think you are being maliciously
removed from the list, or have any other questions, send them to
africa-owner at lists.osgeo.org.



>>> 
From: Tim Sutton <tim at linfiniti.com>
To:Sarel Coetzer <geotech.sarel at gmail.com>
Date: 20/12/2008 19:46
Subject: Re: [OSGeo Africa] Importing Data into Postgresql
CC:Africa local chapter discussions <africa at lists.osgeo.org>, Martin Dobias <wonder.sk at gmail.com>
Hi Sarel

On Wed, 2008-12-17 at 07:45 +0200, Sarel Coetzer wrote:
> Tim
> 
> It is a stand alone application just for doing dirty little jobs, such
> as conversion and import/exports.
> I wrote it in VB, and version 0.01 is out,can be downloaded from:
> My Blog just follow the opensource links.
> 

Unfortunately (well fortunately really :-) I'm a Linux user so I wont be
able to test it - I look forward to your java version, or if you decide
to go pythonistic, see some collaboration with Martin - its always good
to build on the work of others rather than reinventing the wheel your
self!

Have a great Christmas!

Regards

Tim

> Later version should see the importing/exporting functions and batch
> file processing and then a planned JAVA version. 
> 
> Thanks for showing interest, nice motivation as all this is done in my
> spare time.
> 
> 
> Regards
> Sarel
> 
> 
> 
> On Tue, Dec 16, 2008 at 10:34 AM, Tim Sutton <tim at linfiniti.com>
> wrote:
>         Hi Sarel
>         
>         Let us know when you have something out. Would be great to
>         know some
>         details too - what language / platform are you targeting? One
>         of the
>         QGIS developers, Martin Dobias, has written a Postgis Manager
>         plugin for
>         QGIS which gives a lot of neat functions for working with
>         PostGIS from
>         within QGIS:
>         
>         http://mapserver.sk/~wonder/qgis/plugins-sandbox.xml 
>         
>         If you are working in python, it might be nice to consider
>         collaborating
>         with him.
>         
>         Regards
>         
>         Tim
>         
>         
>         
>         On Mon, 2008-12-15 at 07:48 +0200, Sarel Coetzer wrote:
>         > Hi
>         >
>         > I know this might sound premature but I am about to release
>         an
>         > application that will allow you to import any type of
>         spatail data
>         > into PostGIS, .kml, .tab, gml, .gpx. I just fininshed a
>         particular
>         > section on Friday and am working on the connection and
>         importing to
>         > PostGIS this week.
>         >
>         > So please watch my blog http://sarelgis.blogspot.com/ under
>         the open
>         > source link for release. This would be my first release and
>         am
>         > planning for more.
>         >
>         > Regards
>         > Sarel
>         >
>         >
>         >
>         >
>         > On Sat, Dec 13, 2008 at 11:21 AM, Tim Sutton
>         <tim at linfiniti.com>
>         > wrote:
>         >         Hi
>         >
>         >         In addition to the other replies given to this
>         thread you can
>         >         also try:
>         >
>         >         - use the 'SPIT' plugin in QGIS to bring your data
>         into
>         >         PostgreSQL
>         >         - use the command line e.g.
>         >
>         >         shp2pgsql -s 4326 -t tdwg_world_boundaries
>         level4.dbf | psql
>         >         gis
>         >
>         >         However the second option above may not work well on
>         windows
>         >         where they
>         >         only give you a broken cmd.exe shell environment.
>         >
>         >         If you and others need more help, I'd be happy to
>         run a 'bring
>         >         your own
>         >         machine' type workshop focussed on getting to grips
>         with
>         >         PostGIS a bit
>         >         more and helping you to load all your own data.
>         >
>         >         PostGIS really is the core of any FOSS based spatial
>         data
>         >         infrastructure
>         >         and is well worth getting to grips with.
>         >
>         >
>         >         Regards
>         >
>         >         Tim
>         >
>         >
>         >
>         >         On Thu, 2008-12-11 at 03:30 -0800, losso ekolo
>         wrote:
>         >         > Hi,
>         >         >      Good day. I can't import data into Postgresql
>         after
>         >         many
>         >         > attempts.
>         >         > I'm sure i'm missing something. I tried to follow
>         the steps
>         >         on wiki
>         >         > AfricaEvents29November2008 but to no avail.
>         >         > I'm using Windows Xp.
>         >         >
>         >         > Regards,
>         >         >
>         >         > Losso
>         >         >
>         >         > PS: I'm missed the first part of the Workshop.
>         >         >
>         >         >
>         >         >
>         >         >
>         >         >
>         >         >
>         >         >
>         >         >
>         >         >
>         >         >
>         >
>         ______________________________________________________________________
>         >         > Get your new Email address!
>         >         > Grab the Email name you've always wanted before
>         someone else
>         >         does!
>         >
>         >
>         >         > _______________________________________________
>         >         > Africa mailing list
>         >         > Africa at lists.osgeo.org 
>         >         > http://lists.osgeo.org/mailman/listinfo/africa 
>         >
>         >         --
>         >
>         >         Tim Sutton - QGIS Project Steering Committee Member
>         (Release
>         >          Manager)
>         >         ==============================================
>         >         Visit http://linfiniti.com ( http://linfiniti.com/ ) to find out about:
>         >          * QGIS programming services
>         >          * Mapserver and PostGIS based hosting plans
>         >          * FOSS Consulting & Support Services
>         >         Skype: timlinux Irc: timlinux on #qgis at
>         freenode.net
>         >         ==============================================
>         >
>         >         _______________________________________________
>         >         Africa mailing list
>         >         Africa at lists.osgeo.org 
>         >         http://lists.osgeo.org/mailman/listinfo/africa 
>         >
>         >
>         >
>         >
>         > --
>         > http://sarelgis.blogspot.com/ 
>         >
>         >
>         
>         
>         --
>         
>         Tim Sutton - QGIS Project Steering Committee Member (Release
>          Manager)
>         ==============================================
>         Visit http://linfiniti.com ( http://linfiniti.com/ ) to find out about:
>          * QGIS programming services
>          * Mapserver and PostGIS based hosting plans
>          * FOSS Consulting & Support Services
>         Skype: timlinux Irc: timlinux on #qgis at freenode.net
>         ==============================================
>         
> 
> 
> 
> -- 
> http://sarelgis.blogspot.com/ 
> 
> 

-- 
Tim Sutton - QGIS Project Steering Committee Member (Release  Manager)
==============================================
Visit http://linfiniti.com ( http://linfiniti.com/ ) to find out about:
* QGIS programming services
* Mapserver and PostGIS based hosting plans
* FOSS Consulting & Support Services
Skype: timlinux Irc: timlinux on #qgis at freenode.net
==============================================

-- 
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard. 
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner, 
and is believed to be clean.  MailScanner thanks Transtec Computers for their support.



More information about the Africa mailing list