[mapguide-users] postgresql connection with ogr/odbc

[joanne cook]

We are just starting out with postgresql really. As part of a longterm project to streamline and open up the provision of GIS at Oxford Archaeology we are evaluating the likelihood of using postgresql/postgis as the backend in those situations where esri would like us to pay lots of money for arcsde. Currently, courtesy of some nice people on the postgis list we have the beginnings of a working connector from arcgis to postgresql, and now with Traian's work, we have a connector from mapguide open source as well.
 
We are hoping to have a website up fairly soon where we will report on these efforts...
 
Jo
 
-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------

________________________________

From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us]
Sent: Thu 22/06/2006 15:04
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc



Joanne:

Are you just started out using the Postgresql for your GIS data?  How is
it working out for you?   Just curious.

Juan Butler - Senior Programmer/Analyst
GIS Applications
Pinellas County Information Systems
jpbutler at pinellascounty.org


-----Original Message-----
From: joanne cook [mailto:j.cook at oxfordarch.co.uk]
Sent: Thursday, June 22, 2006 3:47 AM
To: Traian Stanev
Cc: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc

I look forward to it. We are very keen to use postgresql as a backend
for both our desktop and web-based gis so this is a real bonus.

Jo

-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------

________________________________

From: Traian Stanev [mailto:traian.stanev at autodesk.com]
Sent: Wed 21/06/2006 19:25
To: joanne cook
Cc: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc




Nice to get an independent confirmation that something works :)
One thing to watch out for that definitely does not work with the OGR
provider is selection of features if you are using the AJAX viewer. This
is because I haven't added support for Intersects queries yet. I hope to
have it soon.

Traian


-----Original Message-----
From: joanne cook [mailto:j.cook at oxfordarch.co.uk]
Sent: Wednesday, June 21, 2006 4:59 AM
To: Traian Stanev
Cc: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc

Hi Traian,

Many thanks for this- it works fine with a larger dataset. This is
great! For information- the connection string I needed to use was:
PG: host=hostname user=username dbname=dbname password=password

Thanks again

Jo


-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------

________________________________

From: Traian Stanev [mailto:traian.stanev at autodesk.com]
Sent: Tue 20/06/2006 18:02
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc




I posted a Win32 build of the OGR provider with PostGIS support over
here:

https://mapguide.osgeo.org/files/documents/12/184/OGRProvider_win32_pq.z
ip


It worked in MapGuide for my (small) test data set of 12 polygons :)
The needed OGR connection string is somewhat byzantine and has the form
described in the OGR documentation at:

http://www.remotesensing.org/gdal/ogr/drv_pg.html


Traian


-----Original Message-----
From: Traian Stanev
Sent: Tuesday, June 20, 2006 9:24 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] postgresql connection with ogr/odbc



Are you using the posted Windows DLL? The posted OGR provider binary is
compiled against a GDAL/OGR without Postgres support (since I didn't
have the required libraries for Pq). It would need to be recompiled with
an OGR that has Postgres support for it to have a chance of working.


Traian


-----Original Message-----
From: joanne cook [mailto:j.cook at oxfordarch.co.uk]
Sent: Tuesday, June 20, 2006 8:22 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] postgresql connection with ogr/odbc

Hi List,

Should I be able to connect to postgresql data sources with either the
ogr or odbc connectors? I have tried with both and got the same error
message when I try and test the connection:

System.Net.WebException: The remote server returned an error: (559)
MgFdoException.
   at
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.ExecutePendingGetReque
stToString(Operation operation)
   at
Autodesk.MapGuide.Studio.Site.Comm.RequestManager.TestConnection(String
resourceId, String provider, String connectionString)
   at Autodesk.MapGuide.Studio.Site.FeatureSourceInfo.TestConnection()
   at
Autodesk.MapGuide.Studio.UI.FeatureSourceEditors.TestConnectionControl.b
uttonTestConnection_Click(Object sender, EventArgs e)

Thanks

Jo

-------------------------------------------
Joanne Cook BSc MLitt AIFA
Information Systems Coordinator
Oxford Archaeology North
-------------------------------------------


This message has been scanned for viruses by BlackSpider MailControl -
www.blackspider.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org




---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org













---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org