Goal:
Visualize a subway map in SQL server 2012 spatial data based on the map of the subway.
The map shall use geometry, traffic rail road as line object, station as point object and zon as polygon object.

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

The question is:
How should I get X and Y coordination in every object from the map when you have the map as a paperwork or gif picture?

I have a feeling that I need a special application having cartesian coordinate system for the map. In the application (maybe same application as CAD) you have the map as a background and then you use the cursor to retrieve X and Y coordinate for every object. Then you have the data so you can use SQL server to picturize a map with data.
Maybe you have another solution.

Other Info
*Please take account that I do not want to use geography data.

*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.

Are the unit vector lengths and the origin of the coordinate system arbitrary?
–
JakeFeb 4 '13 at 14:26

The X and Y will not be linked to spatial reference system because I be using a naturally cartesian in SQL server which means that it will not be linked to coordinate system like UTM, WSGR84 etc.
–
GamerFeb 4 '13 at 15:05

3 Answers
3

Why do you need to map this in a geographic information system, they aren't buit for this type of problem. Don't mistake this type of mapping for what GIS is. Adobe Illustrator or Inkscape (free) would be a better route, I think. You could georeference but the results would be mostly meaningless as what are the points that you need to match that match real world objects. What is the purpose here of storing in a sql interface with a lat lon that is not geographic?
You can backend both Illustrator and Inkscape with sql for specific purposes.
Here is a reference from a google search
"FormObject - Inkscape Wikiwiki.inkscape.org/wiki/index.php/FormObjectCached - Jun 24, 2004 – This should also be usable for implementing SQL tables for diagramming purposes."
http://wiki.inkscape.org/wiki/index.php/FormObject

Inkscape, and I assume Illustrator, have a cartesian cordinate system, use vectors and have vector and point tools, and do a good job of visual display and styling and are aften used by map makers and cartographers for the very purpose of making system maps.
–
lewisFeb 5 '13 at 14:42

In my experience this map would be extremely difficult to create an accurate georeferenced map from because it has been generalized. However, it might be possible to get the Lat/Long of the subway stations and match the map up that way. Check out this tutorial I made. It might help you figure out this process. You will definitely need some GIS software. If you don't have ArcGIS then QGIS is a more than capable alternative.