[mapguide-users] OGR Provider w/ PostGIS Support

[Curtis W. Ruck]

1) Ok, OGR doesn't support named views.... Argh!
 
2) Under advanced... when i type in the column name it tells me (when i click validate) that the named property is not available in this layer: <columnname>.  The column doesn't appear under the Property dropdown.
 
3) I have tried the DWF and AJAX viewers both don't display the OGR layer and it only crashes under the DWF viewer (sometimes).
 
4) Any suggested workarounds for the lack of named view support other than setting up a trigger to update various other tables that would "pretend" to be a view, and all the complexities involved?
 
5) Does the ODBC FDO support PostgreSQL?
 
6) also, i am subscribed to this list but i am not receiving emails even though i am setup to.  (i don't have the digest enabled)
 
Hi Curtis,

1) OGR does not support named views for PostGIS. Refer to
http://www.remotesensing.org/gdal/ogr/drv_pg.html
2) You should be able to use the "Advanced" view in the filter editor to
type in your filter.
3) 300,000 features should not crash it, but it may time out depending
on how fast it's reading them from the database. Are you using the AJAX
viewer or the DWF viewer? Is there an exception message, or a log
message? Also, since you have so many features, consider setting your
map extents to be something smaller than the bounds of all the data.

Traian
 
-----Original Message-----
From: Curtis W. Ruck [mailto:ruckc at yahoo.com] 
Sent: Monday, June 26, 2006 11:50 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] OGR Provider w/ PostGIS Support
Alright, 
 
I know the OGR Provider w/ PostGIS is kinda new.  Because I think the
mapguide set of tools has the best interface and ease of use I want to
see it survive.
 
I am currently having a few issues with this:
    1) When i setup the data layer in MapGuide Studio i can't choose a
view from postgres.  I can only choose a table.  As a workaround i
wanted to see if i could filter the data, which brings me to number 2
    2) I want to filter the data on a timestamp field.  In the MapGuide
Studio interface i can't select the timestamp field to do a filter with.
    3) Because i can't do the two top items, its crashing the mapguide
server because the table i am trying to draw on the screen has some odd
300,000 records all with a geometry column.  Other than that though it
looks good, just wish it would work.
 
Curtis
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org