[mapguide-users] How to connect the Postgres database table to MapGuide?

[Zac Spitzer]

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
<nandakishorks2010 at gmail.com> 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
> mapguide-users at lists.osgeo.org
> 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