MapWindow 4 - Desktop Application : MapWindow Discussion Forum
Hi I'm using MapWindow version 4.5.5020.1040 and trying to load data from a PostGIS database. I connect successfully to my database, see and select the different layers. When I click OK, the attached error message appear... Can anyone please help?
Problem loading PostGIS data
Posted by: nicoelema ()
Date: July 25, 2008 07:21AM

Hi
I'm using MapWindow version 4.5.5020.1040 and trying to load data from a PostGIS database.
I connect successfully to my database, see and select the different layers.
When I click OK, the attached error message appear...

Can anyone please help?

Attachments: MapwindowPostGISerror.bmp (381.7 KB)  
Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: stefan0n ()
Date: September 12, 2008 07:24AM

same problem here... exactly same Mapwindow version, same error messages when try to load PostGIS data... is there anyone doing this successfully?

thanks

p.s. tryed to use the new 4.6 ver. with same results...



Edited 1 time(s). Last edit at 09/12/2008 08:05AM by stefan0n.

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: stefan0n ()
Date: September 22, 2008 09:26AM

really, no one is using Postgis data in MapWindow or no one has troubles?

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: cmonsta ()
Date: September 22, 2008 02:21PM

I encountered nearly the same problem, I got connected to the postgis database, get to select a layer but the layer doesn't appear in the map window. I guess each app has it's strengths. Quantum GIS has amazing Postgis connecting capabilities but Map Windows has better printing capabilities.

Please email me if you have any other suggestions on how to connect to Postgis with Mapwindows

geotech.sarel@gmail.com

Prost!

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: CraigN ()
Date: November 14, 2008 08:03AM

I saw in another post that its looking for the PGSQL2SHP.EXE file in the system path. Simply add your local installation of PostgreSQL or copy the binary and any dependancies to the MapWindow directory or a directory on your system path.

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: nicoelema ()
Date: November 14, 2008 08:54AM

Perfect! Thanks Craig.

I copied the PostgreSQL folder (and all sub folders) which is under C:\Program Files\PostgreSQL to C:\Program Files\MapWindow (thus C:\Program Files\MapWindow\PostgreSQL) and now it works!

Regards
Nico

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: cmonsta ()
Date: November 16, 2008 11:25PM

Surely this is a temp solution as you can't have two "installations" of PortGreSQL on your system. As for the systems path, I cant see that there is a problem because mine is directed to the databasePlugin.

I get a dialog box asking me to select a layer. No layers appear, somewere their is no SQL statement firing asking to view the "geometry_columns" table

I am on version 4.6.602

Which versions have succesfully viewed postgis layers?

Thanks for the help this far, its amazing.

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: nicoelema ()
Date: November 17, 2008 12:06AM

I am also using MapWindow version 4.6.602 with PostGreSQL version 8.2.
I've also attached an image as example where I've been able to link my PostGreSQL data with MapWindow GIS

All the best
Nico

------------------------
Nico Elema
www.globalimage.co.za

Attachments: MWGIS with PostgreSQL.TIF (60.2 KB)  
Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: larso ()
Date: November 21, 2008 02:53PM

TWO THINGS..

"Simply add your local installation of PostgreSQL or copy the binary and any dependancies to the MapWindow directory or a directory on your system path."

"I copied the PostgreSQL folder (and all sub folders) which is under C:\Program Files\PostgreSQL to C:\Program Files\MapWindow (thus C:\Program Files\MapWindow\PostgreSQL) and now it works!"

1)I followed the steps above but am still getting the same error msg that was in the initial post of this thread.

2)I am also wondering why I have more available layers (even though I cannot add them because of #1) when trying to add through MapWindow than I do in pgAdminIII [see attachment].

* * EDIT * * I just resorted to using QGIS, not like that's a lesser alternative or anything .. I even did it from my USB stick via [www.archaeogeek.com]



Edited 1 time(s). Last edit at 11/21/2008 03:21PM by larso.

Attachments: 2008-11-21_mwGIS_postGIS_0.png (75.3 KB)  
Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: collin ()
Date: November 28, 2008 06:20AM

Having the same problems as above.
I added the postgres-bin-folder to the systempath of the enviroment variables.
Now the previous mentioned error doesn't appear, but still no luck.
The shp2pgsql.exe crashes!

Does anyone have a clue?

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: collin ()
Date: November 28, 2008 06:22AM

I mean pgsql2shp.exe ....

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: cmonsta ()
Date: November 28, 2008 07:03AM

Hi there

I doesn't make sense to me that you have to move your whole bin folder to a specific file-folder in the mapwindows project.If you have Postgis loaded then Mapwindows should be able to call the pgsql2shp.exe from a normal cli or cmd because the postgis variable path is already inplace and that bin contains the required .exe

So the function within Mapwindows is not calling the correct .exe.
A long way around is to do what I did and get the entire source code and re-code this function. Your command doesn't have to point to a specific file/folder, you can run it directly from windows "run" cli/cmd.

Regards
Sarel
[sarelgis.blogspot.com]

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: colkassad ()
Date: February 01, 2009 09:03PM

Wait a minute...I have Ubuntu on my box in the other room running Postgresql with PostGIS. What am I supposed to do about getting pgsql2shp on that box to work?

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: ehangis ()
Date: July 26, 2010 02:46AM

Hi
Im beginning in mapwingis!
I have problem to connect mapwingis to postgis.
how can do this work?

Thnks alot

Options: ReplyQuote
Re: Problem loading PostGIS data
Posted by: pmeems ()
Date: August 03, 2010 06:43AM

PostGIS is currently no longer supported by MapWindow.

You can use this plug-in that was created by a user:
[www.mapwindow.org]

Currently 2 students are working on implementing SQLite and PostGIS support in the OCX.
That will take a few more months. If you are in no hurry you can wait for that as well.

--
Paul

--
Don't forget to read the new documentation: www.mapwindow.org/documentation/mapwingis4.8
Join us Google+: MapWindow GIS Google+ Community
Join the MapWindow Group on LinkedIn! LinkedIn - MapWindow Group

Download the latest beta installer at:
tinyurl.com/mwMonthly 32-Bit
tinyurl.com/mwMonthlyx64 64-Bit
Follow me on Twitter MapWindow_nl to read when a new installer is published.

---
Paul Meems
The Netherlands
[www.bontepaarden.nl]
Release manager, configuration manager and
forum moderator of MapWindow GIS

Owner of MapWindow.nl - Support for
Dutch speaking users: www.mapwindow.nl

*******
Everything I say or write is my personal opinion and
not the opinion of the company I work for.
*******
View my profile on LinkedIn

Options: ReplyQuote


Sorry, only registered users may post in this forum.





Banner Exchange




GISCP.com




Send us your banner logo (160x120) for the space above, and add this MapWindow banner ad to your site:

Just paste this text in your page: