private void Form_Load(object sender, EventArgs e)
{
// It is important to set the map unit first to either feet, meters or decimal degrees.
mapView.MapUnit = GeographyUnit.Meter;
// Create the background world maps using vector tiles requested from the ThinkGeo Cloud Service and add it to the map.
ThinkGeoCloudVectorMapsOverlay thinkGeoCloudVectorMapsOverlay = new ThinkGeoCloudVectorMapsOverlay("itZGOI8oafZwmtxP-XGiMvfWJPPc-dX35DmESmLlQIU~", "bcaCzPpmOG6le2pUz5EAaEKYI-KSMny_WxEAe7gMNQgGeN9sqL12OA~~", ThinkGeoCloudVectorMapsMapType.Light);
mapView.Overlays.Add(thinkGeoCloudVectorMapsOverlay);
// Create a new overlay that will hold our new layer and add it to the map.
LayerOverlay coyoteSightingsOverlay = new LayerOverlay();
mapView.Overlays.Add(coyoteSightingsOverlay);
// Create the new layer and set the projection as the data is in srid 2276 as our background is srid 3857 (spherical mercator).
SqlServerFeatureLayer coyoteSightingsLayer = new SqlServerFeatureLayer("Server=sampledatabases.thinkgeo.com;Database=ThinkGeoSamples;User Id=thinkgeouser;Password=dkjGk$%*7kS82hks;", "frisco_coyote_sightings", "id");
coyoteSightingsLayer.FeatureSource.ProjectionConverter = new ProjectionConverter(2276, 3857);
// Add the layer to the overlay we created earlier.
coyoteSightingsOverlay.Layers.Add("Coyote Sightings", coyoteSightingsLayer);
// Set a point style to zoom level 1 and then apply it to all zoom levels up to 20.
coyoteSightingsLayer.ZoomLevelSet.ZoomLevel01.DefaultPointStyle = new PointStyle(PointSymbolType.Circle, 12, GeoBrushes.Black, new GeoPen(GeoColors.White, 1));
coyoteSightingsLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;
// Set the map view current extent to a bounding box that shows just a few sightings.
mapView.CurrentExtent = new RectangleShape(-10784283.099060204, 3918532.598821122, -10781699.527518518, 3916820.409397046);
// Refresh the map.
mapView.Refresh();
}
private void MapView_Loaded(object sender, RoutedEventArgs e)
{
mapView.MapUnit = GeographyUnit.DecimalDegree;
mapView.CurrentExtent = new RectangleShape(-126.4, 48.8, -67.0, 19.0);
string connectionString = "Server=54.177.171.109;Initial Catalog=spatialdatabase;User ID=sa;Password=akeypmon1!";
SqlServerFeatureLayer layer = new SqlServerFeatureLayer(connectionString, "COUNTRY02", "RECID");
layer.ZoomLevelSet.ZoomLevel01.DefaultAreaStyle = AreaStyle.CreateSimpleAreaStyle(GeoColors.Green, GeoColors.Red);
layer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;
LayerOverlay sql2008Overlay = new LayerOverlay();
sql2008Overlay.Layers.Add(new BackgroundLayer(new GeoSolidBrush(GeoColors.ShallowOcean)));
sql2008Overlay.Layers.Add(layer);
mapView.Overlays.Add(sql2008Overlay);
mapView.Refresh();
}
/// <summary>
/// Setup the map with the ThinkGeo Cloud Maps overlay. Also, add the SQLServer layer to the map
/// </summary>
protected override void OnAppearing()
{
base.OnAppearing();
// It is important to set the map unit first to either feet, meters or decimal degrees.
mapView.MapUnit = GeographyUnit.Meter;
// Create the background world maps using vector tiles requested from the ThinkGeo Cloud Service and add it to the map.
var thinkGeoCloudVectorMapsOverlay = new ThinkGeoCloudVectorMapsOverlay("9ap16imkD_V7fsvDW9I8r8ULxgAB50BX_BnafMEBcKg~", "vtVao9zAcOj00UlGcK7U-efLANfeJKzlPuDB9nw7Bp4K4UxU_PdRDg~~", ThinkGeoCloudVectorMapsMapType.Light);
thinkGeoCloudVectorMapsOverlay.VectorTileCache = new FileVectorTileCache(Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "cache"), "CloudMapsVector");
mapView.Overlays.Add(thinkGeoCloudVectorMapsOverlay);
// Create a new overlay that will hold our new layer and add it to the map.
LayerOverlay coyoteSightingsOverlay = new LayerOverlay();
mapView.Overlays.Add(coyoteSightingsOverlay);
// Create the new layer and set the projection as the data is in srid 2276 as our background is srid 3857 (spherical mercator).
SqlServerFeatureLayer coyoteSightingsLayer = new SqlServerFeatureLayer("Server=sampledatabases.thinkgeo.com;Database=ThinkGeoSamples;User Id=thinkgeouser;Password=dkjGk$%*7kS82hks;", "frisco_coyote_sightings", "id");
coyoteSightingsLayer.FeatureSource.ProjectionConverter = new ProjectionConverter(2276, 3857);
// Add the layer to the overlay we created earlier.
coyoteSightingsOverlay.Layers.Add("Coyote Sightings", coyoteSightingsLayer);
// Set a point style to zoom level 1 and then apply it to all zoom levels up to 20.
coyoteSightingsLayer.ZoomLevelSet.ZoomLevel01.DefaultPointStyle = new PointStyle(PointSymbolType.Circle, 12, GeoBrushes.Black, new GeoPen(GeoColors.White, 1));
coyoteSightingsLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;
// Set the map view current extent to a bounding box that shows just a few sightings.
mapView.CurrentExtent = new RectangleShape(-10784283.099060204, 3918532.598821122, -10781699.527518518, 3916820.409397046);
// Refresh the map.
mapView.Refresh();
#region Create Sample Data Code
// ========================================================
// Code for creating the sample data in SQL Server
// ========================================================
//Collection<FeatureSourceColumn> columns = new Collection<FeatureSourceColumn>();
//columns.Add(new FeatureSourceColumn("comment", "varchar", 255));
//SqlServerFeatureSource.CreateTable("Server=10.10.10.179;Database=ThinkGeoSamples;User Id={username};Password={password};", "frisco_coyote_sightings", MsSqlSpatialDataType.Geometry, columns);
//SqlServerFeatureSource target = new SqlServerFeatureSource("Server=10.10.10.179;Database=ThinkGeoSamples;User Id={username};Password={password};", "frisco_coyote_sightings", "id");
//target.Open();
//ShapeFileFeatureSource source = new ShapeFileFeatureSource(@"../../../data/Frisco_Coyote_Sightings.shp");
//source.Open();
//var sourceFeatures = source.GetAllFeatures(ReturningColumnsType.AllColumns);
//target.BeginTransaction();
//foreach (var feature in sourceFeatures)
//{
// var dict = new Dictionary<string, string>();
// dict.Add("comment", feature.ColumnValues["Comments"].ToString().Replace('"', ' ').Replace("'", ""));
// var newFeature = new Feature(feature.GetWellKnownBinary(), feature.ColumnValues["OBJECTID"], dict);
// target.AddFeature(newFeature);
//}
//var results = target.CommitTransaction();
//target.Close();
//target.Open();
//var features = target.GetAllFeatures(ReturningColumnsType.AllColumns);
//target.Close();
#endregion
}
