1

I am completely new to Geometry datatype format of a Microsoft SQL Server database. DataType is Geometry. If not wrong, geographic data contains latitude and longitude of each point of that map, correct me If I am wrong. Now I have to add data of particular region from map in SQL table in Geometry dataType format. When I checked online, it is kind like this - 0x110F0000104... but I don't know how to get this.

I also got to know that there is special software like Atlas from one of my colleague, using this we are getting geometry info. I also got to know that there is polygon concept in achieving this. How can I extract geographical data from map or from other source in SQL Server in Geometry format? Are there any free software available in market to achieve this functionality? Provide me examples if any.

closed as too broad by Vince, Fran Raga, Jochen Schwarze, whyzar, Andre Silva May 28 at 18:42

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.

  • "SQL" is a language. "SQL Server" is a Microsoft database product. It's confusing to write just "Sql" when you mean "Microsoft SQL Server". – Vince May 24 at 14:51
  • 1
    I couldn't understand if what you are trying to accomplish is to input geographic data into a table in SQL Server or if you already have a SQL Server database with geographic data and are trying to retrieve information from it. – Carlos MSF May 24 at 15:43
  • @CarlosMSF - Once I input geographic data in SQL table and map each with unique Id column (e.g. Region/Borough Id) . I will then retrieve Area/Borough/Name using latitude and longitude but it is my next activity. I will have to put first geopraphic data in SQL table. Hope you have undestood. – SSD May 28 at 8:16
  • I don't know the Atlas software you mention, but you can easily load your geographic data into an SQL Server database using QGIS (free and opensource) – Carlos MSF May 28 at 10:17
  • Thanks @CarlosMSF . I will give definitely try on QGIS software. I solved my issue using free tool - Shape2SQL (sharpgis.net/page/Shape2SQL) and Google Earth. – SSD Jun 4 at 7:21