[mapguide-users] Best way to incorperate non-spatial data from a database?

[Martin Morrison]

>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-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of jamsea
Sent: Wednesday, June 01, 2011 8:56 AM
To: mapguide-users at 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 at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users