[mapguide-users] Accessing to non-geographic data

Zac Spitzer zac.spitzer at gmail.com
Thu Mar 12 20:46:10 EDT 2009


I think it only exposes spatial data, that said adding a dummy empty spatial
column is a potential work around...

your lucky your using the postGIS FDO provider, it's has the nicest semantics
when it comes to the fdo class naming conventions

I blogged about this a while ago... basically some FDO providers aren't
transparent and introduce quirky naming conventions

http://zacster.blogspot.com/2008/08/some-ponderings-on-fdo-schemas.html



On Wed, Mar 11, 2009 at 4:59 AM, Traian Stanev
<traian.stanev at autodesk.com> wrote:
>
> According to the OGR documentation (http://www.gdal.org/ogr/drv_pg.html), if spatial tables exist in your database (i.e. the geometry_columns table exists), it will only list these as OGR layers, and not the other tables.
>
> You can try using the PostGIS provider, but I don't know how it treats non-spatial tables.
>
> Traian
>
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Rui Daniro
> Sent: Tuesday, March 10, 2009 7:49 AM
> To: mapguide-users at lists.osgeo.org
> Subject: [mapguide-users] Accessing to non-geographic data
>
>
> Hi All,
>
> I am using Mapguide Studio 2009 and Postgres database. I can connect to my
> database using OGR and I can see the tables with geographic data, but not
> the ones with non-geographic data. Can anyone help with this and sort me
> out? I want to concanate the non-gepgraphic tables with the ones with
> geographic data. That is the reason I want to see my non-geographic tables.
>
> I am much apreciated to any help that you could provide.
>
> Best Regards
>
> Rui
> --
> View this message in context: http://n2.nabble.com/Accessing-to-non-geographic-data-tp2454711p2454711.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Zac Spitzer -
http://zacster.blogspot.com
+61 405 847 168


More information about the mapguide-users mailing list