[mapguide-internals] ogr postgis layer problems

[Traian Stanev]

Hi Paul.

I checked on this and to fix selection highlighting, you need to set the
PGSQL_OGR_FID configuration variable to equal the name of the ID column
of your data. This is documented in the OGR Postgres page (see
http://www.gdal.org/ogr/drv_pg.html).


Traian
 

-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org
[mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Paul
Spencer (External)
Sent: Thursday, February 01, 2007 7:12 AM
To: MapGuide Internals Mail List
Subject: Re: [mapguide-internals] ogr postgis layer problems

Thanks Traian, that fixed the problems.  There is one small remaining
issue that is not critical - the selected features (postgis again) don't
seem to highlight in the ajax viewer.

Cheers

Paul

On 31-Jan-07, at 4:49 PM, Traian Stanev wrote:

>
>
> Hi again.
>
> I've fixed both issues in the OGR provider. Selection now works fine, 
> including multi-select, when tested on SHP files. There was a problem 
> with intersection queries (the problem was they weren't implemented, 
> heh). I also fixes the problem of the features disappearing after 
> selection -- I had forgotten to reset the filters on the OGRLayer in 
> between Selects. I also fixed a small problem in OGR, which was making

> FID filters fail. I'll have Tom post a new Win32 DLL to the provider 
> download location.
>
> FYI, I recompiled against the following versions of the dependent
> libraries: GDAL 1.4.0 (plus my fix), PostgreSQL 8.2.1, Proj 4.5.0, 
> Geos 2.2.3, plus unknown versions of Oracle OCI and ODBC.
>
>
> Traian
>
>
>
>
> -----Original Message-----
> From: Traian Stanev
> Sent: Wednesday, January 31, 2007 3:33 PM
> To: 'MapGuide Internals Mail List'
> Subject: RE: [mapguide-internals] ogr postgis layer problems
>
>
> Hi Paul.
>
> I tried it against an SHP file and selection is definitely not working

> right. :) To avoid the disappearing map problem, you can disable 
> connection pooling for the OGR provider in the serverconfig.ini file.
> This will prevent the map from disappearing (since the connection is 
> not reused after it breaks during selection), but it will not make 
> selection work. I will see what can be done about fixing this and let 
> you know.
>
> Traian
>
>
> -----Original Message-----
> From: mapguide-internals-bounces at lists.osgeo.org
> [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Paul 
> Spencer (External)
> Sent: Tuesday, January 30, 2007 9:18 PM
> To: MapGuide Internals Mail List
> Subject: [mapguide-internals] ogr postgis layer problems
>
> Hi all,
>
> I am looking into an issue regarding postgis layers loaded via the OGR

> provider for a client.  The postgis layer is functioning normally when

> the map loads (it is initially off but it can be toggled on/off no 
> problem).  It can be queried using the select.  However, when the 
> layer has had features selected on it, the next action causes the 
> layer to be turned off and the layer cannot be turned back on without 
> restarting the service and web browser.
>
> Any ideas what might be going on?  Bug in the OGR provider?  AJAX 
> Viewer?  Bad data?
>
> Cheers
>
> Paul
>
> +-----------------------------------------------------------------+
> |Paul Spencer                          pspencer at dmsolutions.ca    |
> +-----------------------------------------------------------------+
> |Chief Technology Officer                                         |
> |DM Solutions Group Inc                http://www.dmsolutions.ca/ |
> +-----------------------------------------------------------------+
>
>
>
>
> _______________________________________________
> mapguide-internals mailing list
> mapguide-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-internals
>
>
> _______________________________________________
> mapguide-internals mailing list
> mapguide-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-internals

+-----------------------------------------------------------------+
|Paul Spencer                          pspencer at dmsolutions.ca    |
+-----------------------------------------------------------------+
|Chief Technology Officer                                         |
|DM Solutions Group Inc                http://www.dmsolutions.ca/ |
+-----------------------------------------------------------------+




_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals