Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I would like to know a basic method for 'exporting' SqlGeometry data from SQL Server 2008 to a Tile Server / PNG File generator. I already have a Silverlight Map application which uses a Custom Tile layer to view Tiles. I would like to add another (this generated tiles) transparent layer of PNG files on top of my base layer.

The 'Spatial Results' in SQL Server Management Studio 'picture' needs to be converted to 256x256 tiles made up of PNG files, with a quadkey so it knows where to place it on the map.

Is there a basic 'quick and easy' way to do this? And, as data gets updated in SQL, the tiles needs to be re-generated.

Thanks a lot.

Cheerio

share|improve this question

1 Answer 1

The easiest way to do it would be to use Geoserver/GeoWebCache with MS SQL Server extension. Unfortunately, you will not get PNG files with quadkey as you aspect, but you get a service that can server tiles as a WMS-C/TMS standard which shouldn't be to difficult to implement into your application. Also it has possibility to re-render particular tiles as you requested. Also, if you a doing an overlay with another layer, they have to be in the same coordinate system and projection, it is not just a question of location of the tiles.

As a starting point go here:

Introduction to an Open Source Geostack

GeoServer

GeoWebCache

You said that you are using Silverlight for you application, have a look at one project, BruTile, that also uses Silverlight for mapping, maybe it can help you.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.