| Johannes 的个人资料Hannes's Virtual Earth B...日志列表SkyDrive | 帮助 |
|
3月2日 Virtual Earth & SQL Server 2008 - Part 2: Spatial Data Management in SQL Server 2008 (2/3)Loading and Extracting Data in SQLThere are a number of methods which allow us to load data into SQL Server 2008. We can load data from
Of course there are similar methods to retrieve the data again:
Loading and Extracting Data with Safe FMEThe above mentioned methods are all very good if we have just a few data to insert or retrieve but for bulk loading there are better tools – specialized spatial ETL-tools – such as Safe Software’s Feature Manipulation Engine (FME 2008 Beta). Let’s see how we can leverage the power of FME. Loading Data into SQL Server 2008After starting the FME Workbench we can use the workspace wizard which guides us through the complete process. In the 1st step we select the input-format FME supports a huge variety of spatial data formats. In this example we are going to import spatial data from the Ordnance Survey Great Britain’s (OS GB) MasterMap. The file will be formatted in the Geographic Markup Language (GML) and the coordinate system will be the OSGB36 (Ordnance Survey Great Britain 1936) a.k.a. British National Grid (BNG). Once we determined the input format we can select the file in our file-system. We repeat the procedure for the destination format but this time we select ‘Microsoft SQL Server (Spatial)’. This is the writer we need for our SQL Server 2008. Next we specify the server, the database and the type of authentication. We can skip the next dialogue… …and have FME create the workspace. You can optionally determine which features you want to import. FME will now prepare the workspace. Now we can specify various translation parameters either on workspace-level… ...or for individual tables. In these cases we want to make sure that the data is inserted as geography data type. We also specify the coordinate system for our destination data. In this case we want to convert from OSGB36 into WGS84. All of the below will do for us but since we would like to use a consistent Spatial Reference System (SRS) Identifier (ID) it is a good idea to use ID 4326 as specified by the European Petroleum Survey Group (EPSG). Once we are happy with the settings we can start the process of transformation and loading. FME will give as a summary of what it did. Extracting Data from SQL Server 2008A simple way to review the result of the data load is to use the FME Universal Viewer. You can easily connect to the various data sources and have a look at the results. You can pan and zoom the maps and you can also select a feature and have a closer look at its metadata. Of course you can also convert the data from SQL Server 2008 formats into all the other formats which are supported by FME. One of these new formats is the ‘Virtual Earth Tile Layer’. And we will have a closer look at this when we come to Virtual Earth itself. Technorati Tags: Virtual Earth,SQL Server 2008 引用通告此日志的引用通告 URL 是: http://johanneskebeck.spaces.live.com/blog/cns!42E1F70205EC8A96!3574.trak 引用此项的网络日志
|
|
|