5

Can anyone suggest good map rendering engines for MS SQL Server Spatial types (SqlGeometry/SqlGeography)? By rendering, I mean plot the geometries to a common image format such as png or jpeg with very simple symbology.

The 2 I have experimented with thus far are: 1. SharpMap 2. MapServer with the MSSql plugin

I just want to see if there is anything else out there that I might have missed.

1
  • 1
    +1, I'm curious how sharpmap and mapserver compare for rendering. (sample image results would be nice). – Kirk Kuykendall Dec 21 '10 at 17:33
3

MapGuide OS has the ability to serve MSSQL Server 2008 data.

4

GeoServer? http://docs.geoserver.org/stable/en/user/data/sqlserver.html

2

There is a built in renderer in Management Studio.
I missed it for a while.

/Nicklas

3
  • Thanks for the comment. But I don't believe you can save images from the viewer or control symbology, can you? – user890 Dec 20 '10 at 20:38
  • no, I think you are right. just a renderer. – Nicklas Avén Dec 20 '10 at 21:25
  • I found, to get the "Spatial results" tab to show up next to Results and Messages, the result set had to be just the geography column, then it worked great. Also, make sure your polygons are defined in counter-clockwise order, else they won't show. – Eliot Gillum Jun 22 '18 at 7:26
1

FME has the capability too

http://www.fmepedia.com/index.php/Creating_a_Web_Map_Tile_Cache_in_SQL_Server

1

Manifolds MapServer object can render images from SqlServer geometry (or any other spatial format that it can handle).

It is generally used IMS applications, but can just as easily be used for just image rendering.

http://www.manifold.net/doc/hid_scriptitem_mapserver.htm

1

Mapnik could possibly connect to MS SQL Server spatial geometries, it uses the well known GDAL/OGR lib.

2
  • Laurent - do you know of a link to any documentation or tutorials that show Mapnik and SQL Server working together? While I agree that it should be possible via OGR (either directly or perhaps via a virtual layer interface), in practice I've never got this to work. – Alastair Aitchison Jun 18 '11 at 8:33
  • Sorry no, i presumed too quickly, it seems. – Laurent Jégou Jun 22 '11 at 11:08
0

Mapnik is the best option, it renders the most beautiful maps this time

0
0

MapSurfer.NET is an advanced cartographic framework for producing beautiful and readable maps. It supports both Microsoft SQL Server 2008 and 2012.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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