the best approach when working with a database (as opposed to shp,sdf etc) is to create a view which combines the tables and presents the data as you require it.
I haven't done this myself with postgis, but with oracle, once the view is created, you need to define the primary key and create an entry in the SDO_GEOM_METADATA tables, that way you satisfy the FDO requirement of a primary key and a spatial column z On Wed, Aug 1, 2012 at 10:56 PM, nandankishorks <[email protected]> wrote: > I'm working on project, for that i have already added a spatial > table(District info: gid, dist_code, district_name, area, perimeter, > the_geom) of polygon shapefile into MapGuide. > Also, I have a couple of tables in Postgres datbase that have typical > population info: id, dist_code, population, male_population, > female_population, literacy, male_literacy, female_literacy etc. > Now I have to link the Non-Spatial table to the district_info layer. > Anyone have any experience with this sort of project and can point me to > examples or suggestions I should be looking at? > > I am using MapGuide 2.4. MapGuide Maestro 5.0b2 and FDO 1.0.0 > > > > > > > ----- > -Nandan > -- > View this message in context: > http://osgeo-org.1560.n6.nabble.com/How-to-connect-the-Postgres-database-table-to-MapGuide-tp4992126p4992409.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
