MapWindow 4 - Desktop Application : MapWindow Discussion Forum
Attachments: MapwindowPostGISerror.bmp (381.7 KB)
Attachments: MWGIS with PostgreSQL.TIF (60.2 KB)
Attachments: 2008-11-21_mwGIS_postGIS_0.png (75.3 KB)
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?
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)
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.
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.
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?
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!
Please email me if you have any other suggestions on how to connect to Postgis with Mapwindows
geotech.sarel@gmail.com
Prost!
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.
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
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
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.
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.
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
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)
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.
"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)
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?
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?
Re: Problem loading PostGIS data
Posted by:
collin ()
Date: November 28, 2008 06:22AM
I mean pgsql2shp.exe ....
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]
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]
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?
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
Im beginning in mapwingis!
I have problem to connect mapwingis to postgis.
how can do this work?
Thnks alot
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
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
Sorry, only registered users may post in this forum.
