Times like this I miss being a part of SCADA, after all CAD is the center of
SCADA.
Murph
http://map3d.wordpress.com/
----- Original Message -----
From: "jamsea" <[email protected]>
To: <[email protected]>
Sent: Wednesday, June 01, 2011 7:55 AM
Subject: [Bulk] [mapguide-users] Best way to incorperate non-spatial data
from adatabase?
Right now I have two data sources. A static SHP Feature Source and ODBC
Feature Source connected to Microsoft SQL Server 2008 R2. The shape files
contain static meter locations, while the database will have hourly meter
load data that will be updated every hour.
I want the meter load data to appear on each meter in the map. The shape
file and the database both have a field called "MTR_NUM" that they can be
joined with. I can set up an ODBC Feature source and join it with the
shape
file resource seemingly just fine in Maestro 3.0, but when I try viewing
the
layer in the map mapguide freezes up and I need to restart my dev machine
to
try to get it to work again.
I am on the right track? Should I be trying integrate my shape file info
into the database and use a MS SQL Server Spatial feature source instead?
If
so, how would I do that?
Thanks for your time,
Jamie
--
View this message in context:
http://osgeo-org.1803224.n2.nabble.com/Best-way-to-incorperate-non-spatial-data-from-a-database-tp6426773p6426773.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
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
