span8
span4
Downloads
The publicart.xlsx file lists public art locations in the City of Vancouver.
Introduction
In this tutorial,我们将执行一个非常常见的转换:在Excel文件(*.xlsx)中获取非空间数据,并将其转换为ESRI形状文件(*.shp)。The Excel file contains x_coordinate and y_coordinate values for each row which will be converted to points as the data is read.We will also merge data from multiple sheets,or feature types,into our output ESRI Shape file.
Step-by-Step Instructions
To complete the process described in the video,您需要执行以下步骤。
1)启动FME工作台
In Windows this is found under Start > All Programs > FME Desktop > FME Workbench
2)选择新工作区
Select a New workspace in the Create Workspace window.
3)拖放源(读卡器)数据集
Navigate to the publicart.xlsx file in Windows Explorer,and drag and drop it onto the canvas.
4) Verify the input Parameters
In the Add Reader dialog window,click on parameters to see how FME Workbench will read this data;notice that by default it reads all of the sheets in the Excel file.
属性部分确认FME选择了正确的列名称,并正确地将经度标识为“x_坐标”类型,纬度标识为“y_坐标”类型;this means that when the data is read,the points will automatically be created.Click OK to dismiss the parameters,and the add reader dialog windows.The six sheets from the source feature type have now been placed on the canvas.
5) Set the output (Writer) format to ESRI Shape file
Select ESRI Shape for the format;do this by typing the name into the field until it appears within the dropdown list.
6) Set the output (Writer) dataset location
在视频中,it is set to C:\FMEData2016\Output.然而,您可以将输出位置设置为最适合您的目录结构的位置。单击“确定”将新的编写器添加到画布。
7) Set the output (Writer) Shape File Definition
By default,the Shape File Definition will be copied from one of the reader feature types.Stick with the default "copy from reader" for the shape file definition.
8) Confirm the Select Feature Type Dialog Window
The select feature type dialog window is asking us which source feature type to retrieve attribute definitions from to copy to our writer.It doesn't matter which one we choose since they all have the same definition.
9)修改输出(编写器)功能类型属性
Open the destination feature type properties:
10) Connect the input (Reader) and output (Writer) Feature Type
11) Change Coordinate System for output (Writer) Feature Type
Using the Navigator pane (top-left),expand the shape writer parameters.The first parameter that appears is the coordinate system,and we will make our changes here.输入“ll84”将坐标系设置为经纬度
12) Click the Run button on the toolbar
Run the workspace by clicking on the green play button.This carries out the translation.
13)在FME数据检查员中查看形状文件
Once complete,we can use FME Data Inspector to view the data and see that we have merged the data from multiple sheets into our output ESRI Shape file.
Data Attribution
此处使用的数据源于温哥华市,British Columbia.It contains information licensed under the Open Government License - Vancouver.
How to Convert CSV to Shapefile (Non-spatial to Spatial)
How to convert SHP to TAB (Esri Shapefile to MapInfo)
如何将esri shapefile转换为geodatabase
How to Convert MapInfo TAB to Esri Shape
How to Convert DGN to Shape (CAD Levels to GIS Attributes)
Build Road Lines from GPS Points (CSV to Shape)
How to convert MapInfo to Shapefile (MIF/MID to SHP)
How to convert Esri Shapefile to PostGIS
© 2019 亚搏在线Safe Software Inc |Legal