[mapguide-users] OGR Provider w/ PostGIS Support

[Traian Stanev]

Hi Curtis,


2) I realize it will not validate in Studio, however you can ignore that
and save the layer anyway. The filters that validate in Studio are a
subset of the filters that work. 

As long as your timestamp can parse correctly in FDO and the attribute
name exists in your database, it should be fine. Filters are passed to
OGR unchanged, so *in theory* it should work as long as the filter is
both a valid SQL statement and a valid FDO filter string. In practice,
well... I've not tried it with Date/Time so you'll be first.

3) Are you previewing the layer or a map? If in doubt about the data, it
is always better to create a map, add the layer to the map, and set the
map extents to a known value (if they are not automatically set). Also,
what coordinate system is your data using?


Traian


-----Original Message-----
From: Curtis W. Ruck [mailto:ruckc at yahoo.com] 
Sent: Monday, June 26, 2006 12:48 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] OGR Provider w/ PostGIS Support

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

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