[OSGeo Africa] Importing Data into Postgresql

[Tim Sutton]

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 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 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
==============================================
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://lists.osgeo.org/pipermail/africa/attachments/20081216/13b1e0b6/attachment.bin