MapGuide and SQL Server 2008
Recently Ive been struggling to get MapGuide and Sql server to work together. After posting to the forums I got a reply: http://www.mail-archive.com/mapguide-users@lists.osgeo.org/msg11760.html. Very nice and to further explain here is a quick overview of what I did:
Step 1
Import your shape files into Sql Server I’ve used Shape2Sql available from www.sharpgis.net
Step 2
Run this query in sql to remove SRID from your features
update dbo.NAN_PARCELS set GEOM.STSrid = 0; Like described here.
Step 3
In my site I’ve used the Maestro API to load and filter my layers dynamically. This is my code behind in my default.aspx page.
//First we connect to the MapGuide server
string username = "Anonymous";
string password = "";
string layout = "Library://MyFeat/Layout/Layout.WebLayout";
String configPath = @"C:\Program Files\OSGeo\MapGuide\Web\www\webconfig.ini";
MapGuideApi.MgInitializeWebTier(configPath);
Uri host = new Uri("http://localhost/mapguide/mapagent/mapagent.fcgi");
conn = new HttpServerConnection(host, username, password, "en", true);
MgUserInformation userInfo = new MgUserInformation(conn.SessionID);
MgSiteConnection siteConnection = new MgSiteConnection();
siteConnection.Open(userInfo);
//Now I get the origanal layout that I created in the Maestro Application
//Get the original layout
WebLayout weblayout = conn.GetWebLayout(layout);
//Get the mapDefinition
MapDefinition mapDef = conn.GetMapDefinition(weblayout.Map.ResourceId);
//get the feature source
FeatureSource feaSource = conn.GetFeatureSource("Library://MyFeat/Data/SQL.FeatureSource");
//Generate a temporary feature source
string tempFeaDef = new ResourceIdentifier("SQL1", ResourceTypes.FeatureSource, conn.SessionID);
//Save the modified FeatureSource at its new temporary location
conn.SaveResourceAs(feaSource, tempFeaDef);
LayerDefinition layerFeatDefinition = conn.GetLayerDefinition("Library://MyFeat/Layer/Feat.LayerDefinition");
VectorLayerDefinitionType vectorLayerFeatDefinition = layerFeatDefinition.Item as VectorLayerDefinitionType;
vectorLayerFeatDefinition.ResourceId = tempFeaDef;
//Now we filter on the user name
vectorLayerFeatDefinition.Filter = "User_ID = '" + User.Identity.Name + "'";
//Save a copy of the layer, temporary
string tempLayerFeatDef = new ResourceIdentifier("MyFeatLayer", ResourceTypes.LayerDefiniton, conn.SessionID);
conn.SaveResourceAs(layerFeatDefinition, tempLayerFeatDef);
//Create a new MapLayer object
MapLayerType Featlayer = new MapLayerType();
//Absolute minimum properties
Featlayer.Visible = true;
Featlayer.ResourceId = tempLayerFeatDef;
//Extra properties
Featlayer.Selectable = true;
Featlayer.ExpandInLegend = true;
Featlayer.ShowInLegend = true;
Featlayer.LegendLabel = "Feats";
Featlayer.Name = "Feat";
//Now we add these layers to the Map
List<MapLayerType> maplayers = new List<MapLayerType>();
maplayers.Insert(0, layerLande);
maplayers.Insert(1, Featlayer);
mapDef.Layers = new MapLayerTypeCollection();
foreach (MapLayerType mlt in maplayers)
{
mapDef.Layers.Add(mlt);
}
MgFeatureService featureService = (MgFeatureService)siteConnection.CreateService(MgServiceType.FeatureService);
MgResourceIdentifier resId = new MgResourceIdentifier("Library://MyFeat/Data/SQL.FeatureSource");
String schema = featureService.DescribeSchemaAsXml(resId, "");
OSGeo.MapGuide.MaestroAPI.LayerDefinition ldef = conn.GetLayerDefinition(tempLayerFeatDef);
Topology.Geometries.IEnvelope env = null;
//To show the correct extend filter again (Very Important)
env = ldef.GetSpatialExtent("User_ID = '" + User.Identity.Name + "'");
mapDef.Extents.MinX = env.MinX;
mapDef.Extents.MinY = env.MinY;
mapDef.Extents.MaxX = env.MaxX;
mapDef.Extents.MaxY = env.MaxY;
//create a temp map
string tempMapDef = new ResourceIdentifier("MyMap", ResourceTypes.MapDefinition, conn.SessionID);
//Save the modified map at its new temporary location
conn.SaveResourceAs(mapDef, tempMapDef);
//Generate a temporary WebLayout id
tempWebLayout = new ResourceIdentifier("MyMap", ResourceTypes.WebLayout, conn.SessionID);
//Update the WebLayout to point at the modified MapDefinition
weblayout.Map.ResourceId = tempMapDef;
//Save the modified layout at its new temporary location
conn.SaveResourceAs(weblayout, tempWebLayout);
Step 4
My main problem was finding the correct extends of the selected geometry using the layers filters, and to load it after the filter was processed otherwise all the data in my database would be loaded, and will filter after the load which will really impact the performance. Please write a comment if you know of a better way of doing this.