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

[Liglio]

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