span8
斯潘4
Previous: Correcting Topological Errors
In this exercise,您将学习如何将数据导入数据库,以及如何使用FME从数据库中导出数据。It's a simple drag and drop process that supports over 400 data types;然而,本教程仅提供从3个类别导入/导出数据的示例:数据库表,raster data,和矢量数据。
Note: Since you are使用面向公共的数据库,有时可以覆盖和/或修改表。如果你的翻译产生了意想不到的结果,see the重置PostGIS培训数据库article.Alternatively,您可以下载提供的文件,并用适当格式的读卡器替换PostGIS读卡器。
在这种情况下,您将学习如何创建现有数据库表的副本。
Alternatively,如果要将表导出为csv,将Postgis编写器换成CSV编写器。这将导致您的postgis表被导出为csv格式。同样地,if you have a CSV file that you want to be created as a table in your PostGIS database,replace the PostGIS Reader with a CSV Reader.This would result in your CSV file being imported into PostGIS as a new table.
在这种情况下,将光栅图像和属性数据从数据库导出到geotiff。
FME allows you to generate both World and TAB files when writing to the GeoTIFF format.世界文件(.tfw)非常重要,因为它们存储有关光栅图像(即起源,间距,以及光栅图像的旋转)。Additionally,TAB files (.tab) are important because they allow you to export the user-defined attributes of the raster image,这意味着关联数据库表中的所有属性都将与geotiff一起导出。有关使用geotiff reader的更多技术信息,see theDocumentation.
You have successfully exported Raster data from your database.您可以通过选择编写器功能类型并单击其上方快捷菜单中的“FME数据检查器”徽标来查看输出。
在这种情况下,您将导入光栅图像及其属性到数据库中。
You have successfully imported a GeoTIFF into your database.You can view the output by selecting the writer and clicking the FME Data Inspector logo in the shortcut menu that appears.
在这种情况下,要导出当前存储在数据库中的一些矢量数据的副本。
下一步,open the Reader Parameters and select the VanBlocks table from the Table List.
形状文件功能由几何图形和一组用户定义的属性组成。在这种情况下,您正在从PostGIS数据库中读取三维多边形数据,因为Z值(0)已附加到要素坐标。
Note: since there is a Z coordinate specified in the coordinate dimensions the Shapefile Writer will assume the output is intended to be 3D if you use the default output dimension "Dimension from the first feature".
您已成功将数据库中的多边形功能导出为shapefile格式。You can view the output by selecting the writer and clicking the FME Data Inspector logo in the shortcut menu that appears.
在这种情况下,您将从shapefile导入多边形功能到数据库中。
Data used in this tutorial originates from open data made available by the温哥华市,British Columbia.It contains information licensed under the Open Government License - Vancouver.
?2019安全亚搏在线软件公司|合法的