SQL Server 2008 Spatial Data Application Series 11: Extracting spatial data solutions from MapInfo map data

Original: SQL Server 2008 Spatial Data Application Series 11: Extracting spatial data solutions from MapInfo map data

tips, the prerequisites for reading this blog post are as follows:

1. This sample is based on Microsoft SQL Server R2 Commissioning.

2. Experience in Transact-SQL programming and use of Management Studio.

3. Be familiar with or understand the spatial data types in Microsoft SQL Server 2008.

4, with corresponding (such as OGC Specification, KML specification) of the GIS professional theory knowledge.

5, understand MapInfo map data, ArcGIS SHP map data format.

6. Learn about the SQL Space tool (Sqlspatialtools).

first, analyze the case: if the product is to be implemented in a Silverlight-developed map application to mark the provinces, cities, and counties, by analyzing only the spatial data for provinces, cities, and counties, and then dynamically drawing layers in the map application superimposed on the map layer. One of the key points to drawing your own layer overlays is to obtain spatial data for provinces, cities, and counties, and it is wise to export this data from existing map data. This article, combined with the author's experience, introduces a scheme for quickly extracting spatial data from MapInfo map data files for your reference.

First, prepare the environment

1, install MapInfo Professional 8.0/8.5, this article is based on MapInfo Professional 8.0 software platform.

2. Download the SQL Space Tool (Sqlspatialtools).

3. Install Microsoft SQL Server R2.

Second, using MapInfo Professional to convert the map data format

MapInfo Professional provides the map data format conversion tool, which opens the map format Conversion panel via the menu "Tools->universal tanslator->universal tanslator", such as:

　　　　　　　

Use the above steps to convert the. tab map data to. shp format map data, while the resulting files have. shp,. Shx,. dbf, and. prj Four extension files, specifically what the role is not described here, mainly using. SHP, other files are auxiliary data files.

Third, import shpfile map spatial data to SQL Server 2008

　This is not a detailed introduction and it is unclear how to import data using spatial tools to import ESRI format map data.

Iv. previewing spatial data in SQL Server Management Studio

SQL Server Management Studio supports two ways to view spatial data, both in table mode and in spatial result mode, in two ways.

V. Spatial query Results

In SSMs, you can use SQL built-in functions to convert spatial data into a collection of graphical coordinate points by querying a spatial data table. Such as:

　　　　　　　　

The above operation extracts the coordinate point collection, can directly save the query results as a TXT file, can directly copy the use of the inside of the geographical coordinates data.

Vi. Related Information

[1], SQL Server 2008 Spatial Data Application series nine: Using spatial tools to import ESRI format map data

[2], spatial tools: http://www.sharpgis.net/page/SQL-Server-2008-Spatial-Tools.aspx

Copyright notice

This article is an original article, welcome to reprint and note the source of the article, its copyright belongs to the author and the blog Garden altogether. In order to preserve the author's passion for creation, please mark the source of this article in the obvious place after reprint.

Author: Beniao

Article Source:

http://beniao.cnblogs.com/or http://www.cnblogs.com/

SQL Server 2008 Spatial Data Application Series 11: Extracting spatial data solutions from MapInfo map data