[mapguide-users] Display Historival value assigned to a polygon

[Martin Morrison]

Why not do the join in a database view?  Then let Mapguide use the view for display?

Martin Morrison     
Infrastructure Application Engineer/Systems Analyst
 Engineering Design Systems, Inc.
540.345.1410
martin.morrison at edsi.com

 
www.edsi.com

-----Original Message-----
From: mapguide-users [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Liglio
Sent: Wednesday, January 3, 2018 6:39 PM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Display Historival value assigned to a polygon

I am trying to display historical info about States of a Country. I have two
tables: State (State ID, State Name, Geometry) and State Power Load (State ID, Date/Time, Power Observed, Power Predicted). To show a State color themed layer based on the deviation of Observed and Predicted, I need to join these two tables in a single one table (State ID, State Name, Date/Time, Power Observed, Power Predicted, Geometry). This solution will lead to a large table due to the geometry of the State to be in each row (so, I don't like it). Another solution is to join two tables using mapguide, but I already tried some years ago and it did not work (Postgresql database).

What is the best approach to solve this problem ? 




--
Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapguide-users