Visualize a picture in SQL server 2012 spatial data based on geometry

In order to display a vector picture I need to retrieve X, Y coordinate (cartesian coordinate system) and display it in the SQL server spatial data.

I'm looking for a tool that can draw vector graphic. Every object of line, point or zone you make, you shall enable to retrieve X and Y coordination from the start to the end of the object. For instance line object has start point (0,0) and end point (5,3).

The reason why I need this X,Y data is to use them in SQL server to visualize a vector picture.

What tool do I need to use?

Other Important Info:

  • Please take account that I do not want to use geography data because the x-and y-coordinate data that are not defined in relation to any particular model of the Earth, it's using the geometry datatype with SRID = 0

  • The X and Y data retrieve from the special application shall be enable to use in SQL server. In other word, same cartesian coordinate system without measurement of unit.

  • It's important that this application can apply gif or jpeg picture to act as a background and om top on it, you draw a vector geometry data.

  • This application should also take account to Well-known text to be customized with SQL server and its spatial data. In other word, take account to OGC standard

  • The picture from a paper map or jpeg will be a subway map that is a linear cartogram linear cartogram

closed as too broad by PolyGeo Oct 1 '15 at 7:06

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


If you are not afraid to write some code, R is an excellent tool to perform this kind of tasks. A graphics package like ggplot2 would be suitable for a task like this, it simply draws what you specify and is not particularly meant for geographic data. R can connect to any kind of database you want, e.g. see RODBC, so getting the data into R is possible.

R may have a relatively steep learning curve, but once you are up-to-speed you have a very flexible and powerful tool in your arsenal.


You could probably use MapInfo Professional.

With MI Pro 11.5 you can connect to SQL Server 2012, open a table with spatial data and display it in a map window. You can also add new vector objects and save these back to the database.

You can download a 30 day evaluation version of MapInfo Professional here: MI Pro 30 day trial

I did a presentation on how to use MapInfo Professional with a spatial database (SQL Server 2008) at the MapInfo User Group for UK and Ireland in January last year. You can find my presentation on slideshare

  • This application is very interesting. I will contact you by e-mail. – What'sUP Feb 6 '13 at 22:22

I think you can use lates QGIS (its OO), it has MSSQL Spatial support, just dont define SRID. Use geometry data type.

  • OO? What do you mean? If I understand correctly, you can geometry data type without measurement of unit? – What'sUP Feb 6 '13 at 11:44
  • Usually it uses srid's units when you use st_distance or similiar functions. But i dont understand what measurement of unit has to do with it. from 0 0 to 0 1 is allways 1 long , what that 1 means its up to you. – simplexio Feb 6 '13 at 12:31
  • Unit of measurement is like pixel, centimeter, inches etc. – What'sUP Feb 6 '13 at 13:07

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