How to get the spatial results, and how to export it to a Mapinfo Table?

Question

Hi all,

I made a view in SQL Server, and got about 6000 items in the result. Now I am trying to get the spatial results and then I want to export it to a Mapinfo Table. Will you pls tell me what I should do?

 

Thanks a lot

Answer 1

Do you have spacial data for these records?

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 2

Hi Lydia,

Could you please provide the sechema of the view & table Mapinfo and some sample data?

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 3

SQL Server has no inbuilt ability to export spatial data in any format other than WKT, WKB, or GML, so you'll need to use a third party tool.

Safe FME (commercial) and OGR2OGR (open source) can both export from SQL Server to MapInfo format.

---

twitter: @alastaira blog: http://alastaira.wordpress.com/

Answer 4

Do you have spacial data for these records?

---

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Hi Jeff,

Yes, I have the spatial data as Column "Shape" for all the records.

---

Lydia Cheng

Answer 5

SQL Server has no inbuilt ability to export spatial data in any format other than WKT, WKB, or GML, so you'll need to use a third party tool.

Safe FME (commercial) and OGR2OGR (open source) can both export from SQL Server to MapInfo format.

---

twitter: @alastaira blog: http://alastaira.wordpress.com/

Actually I believe it does have the ability, and I saw someone do it before.

---

Lydia Cheng

Answer 6

Hi Lydia,

Could you please provide the sechema of the view & table Mapinfo and some sample data?

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi Peja,

 

I have Column "Shape" "MI_PRINX" "#_Place" in the View. And I want to get the spatial results, then export it to Mapinfo Table, TXS.

---

Lydia Cheng