>From below " 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?"
Yes, you should do this. Look at a tool called Shp2SQL from SharpGIS. http://sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx Martin Morrison Application Engineer Engineering Design Systems, Inc. 3780 Peters Creek Rd Ext SW Roanoke, VA 24018 540.345.1410 gis.edsi.com -----Original Message----- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of jamsea Sent: Wednesday, June 01, 2011 8:56 AM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] Best way to incorperate non-spatial data from a database? 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 mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
