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.

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

share|improve this question

4 Answers 4

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.

share|improve this answer

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

share|improve this answer
This application is very interesting. I will contact you by e-mail. –  Gamer 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.

share|improve this answer
OO? What do you mean? If I understand correctly, you can geometry data type without measurement of unit? –  Gamer 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. –  Gamer Feb 6 '13 at 13:07

Use AutoCad, it supports cartesian coord. system.

share|improve this answer

Your Answer


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.