SPAN8.
SPAN4.
The intention of this article is to show the user how they can create additional metadata with FME so that GeoMedia can interact with the nativeSQL Server Spatial.tables.
This works with SQL Server 2012 and higher.
A note from Chuck at Intergraph:建议不要混合Moomedia 2015和早期版本相同的本机空间数据。Geomedia 2015使用不同的二进制格式,而不是2014年及更早版本,它基于Microsoft为SQL Server 2012或更高版本的二进制文件。2015年编辑了一个要素类后,您无法在Geomedia 2014等早期版本的Geomedia中使用它。
Using "GeoMedia SQL Server Warehouse“FME的作家:
当FME创建新表时SQL Server.数据库FME能够生成必要的Geomedia元数据,使新表读/写入从Geomedia应用程序启用。
Using "Microsoft SQL Server Spatial“FME:作家写SQL Server本地年代patial table, FME creates the spatial table but does not generated the necessary metadata for GeoMedia as this format is native to Microsoft SQL Server Spatial Database.
In order for GeoMedia to have read/write capabilities it is necessary to add additional metadata to the GeoMedia Metadata tables (GFeatures etc). FME does not do this by default.
SQL Server Spatial.- Native Spatial Data Type
If you have recently moved to SQL Server Spatial or are thinking about it and plan to use the native Spatial data with GeoMedia you will need to be aware of a few additional steps.
You may notice when you try to add the GeoMedia Metadata for the newSQL Server.Native Spatialtable that theDatabase Utilities不会在对话框中显示几何标签。基本上Database Utilities不知道几何类型并忽略它。您仍然可以将表添加到元数据表,但Geomedia不会从表中显示地理数据,因为它不知道存储与表中存储的几何数据。您将能够在表格视图中查看表格,在Geomedia中使用“新数据窗口”,而其他第三方应用程序可能会识别空间表并按预期显示。
This is an indication that the spatial table is missing an additionalvarbinary.
column (required by GeoMedia). This is a unique requirement to GeoMedia.
FME created new tables but I can't see them in GeoMedia
FME.SQL Server Spatial.Writer doesn't have the ability to create the
使Geomedia意识到任何几何所需的步骤SQL Server Spatial.table.
回顾“GeoMedia SQL Server Spatial User Guide" that comes with the2014年Geomedia的SQL Server Spatial Addon。It contains a section called "Using Existing Native Spatial Data“涵盖所需的步骤。这是以下说明来自的地方,我将向您推荐给该文件以获取更多信息。
1) GeoMedia requires a column to be added to the new table...
从MS SQL Server Studio中运行以下脚本(请编辑表名称和列以匹配您的表名和列名称)EX:注意:以下脚本假定本机SQL Server空间几何列称为Geom和Geomedia Geometry列称为GeoM_gdo,[ID]列是指表的标识列。
更改表[架构]。[TableName]添加Geom_gdo varbinary(max);去Then further, 2 new triggers to be created on this table... ex:
CREATE TRIGGER [tablename_INS] ON [schema].[tablename] AFTER INSERT AS BEGIN SET NOCOUNT ON; IF EXISTS (SELECT NULL FROM INSERTED WHERE INSERTED.[GEOM] IS NULL AND INSERTED.[GEOM_GDO] IS NOT NULL) BEGIN RAISERROR ('Unsupported. Cannot specify value for GDO column only, native column value must also be provided.', 0, 1) ROLLBACK TRANSACTION END; END; GO CREATE TRIGGER [tablename_UPG] ON [schema].[tablename] AFTER UPDATE AS BEGIN SET NOCOUNT ON; IF UPDATE([GEOM]) BEGIN IF NOT UPDATE([GEOM_GDO]) BEGIN UPDATE [schema].[tablename] SET [GEOM_GDO] = NULL WHERE EXISTS (SELECT NULL FROM INSERTED WHERE INSERTED.[ID] = [tablename].[ID] END END ELSE IF UPDATE() BEGIN RAISERROR ('Unsupported. Cannot specify value for GDO column only, native column value must also be provided.', 0, 1) ROLLBACK TRANSACTION END END; GO
如下所示用户指南fromIntergraph- - - - - -一旦你y列和触发器ou can then run theDatabase Utilities加载Geomedia的元数据。您需要确保您运行Database Utilitiesfrom a system where both GeoMedia and theSQL Server Spatial.Software AddOnfrom Intergraph has been installed.
这已通过SQL Server 2008,Geomedia 2014和FME 2015进行了测试。
我们将工作空间放在一起(附件 -geom-gdoforgeomedia.zip) that will assist you in updating existing SQL Server Spatial tables. This workspace will add the necessaryvarbinary.
column and the 2 required triggers to native spatial table. The workspace reads a CSV file that contains a list of existing tables and columns.
关于CSV文件:The CSV file can be created in the same FME workspace (using a Text Line Writer) that created the new spatial tables and then used in a second workspace (like the one attached) to alter the spatial tables. Alternatively if you are dealing with existing tables it would be possible to use SQL to return a listing of spatial tables that can then be saved to a text file and used in this workspace.
Unfortunately it is still necessary to use
Database Utilities将表添加到Geomedia的元数据表以与元数据交互。
Intergraph now has somePL/SQL可以帮助自动化和添加必要元数据以允许Geomedia交互的工具(之后varbinary.
column and triggers have been added to the table - see above).
This is supported on SQL Server 2008 and above.
"GMP Spatial Utilities - Stored Procedures for use with GeoMedia's SQL Server Native Spatial Data Server"可以从Intergraph下载Hexagon Support。The download contains database packages.
这些数据库包需要安装在存储本机空间表的SQL Server数据库中。
*At time of posting the link is working. If the link is broken let us know using the comments section below.
或者,访问六角形支持并搜索标题“GMP空间实用程序 - 存储过程与Geomedia的SQL Server本机空间数据服务器一起使用”。
安装包后,可以让您的FME工作区调用gmpsetmetadatafor.
package and populate the necessary metadata for interaction with GeoMedia.
如果您有任何困难,请告诉我们。
希望这有助于某人!快乐的fmeing。
FME Server appears to hold connections open or licenses checked out for longer than expected.
3.Machine Distributed Installation
Ports and Executables and Firewall Exceptions for FME Server
FME引擎未开始使用慢速FME服务器核心启动(2014和以前)
Assigning jobs to a subset of available FME Engines (2012 and previous)
©2019 S亚搏在线afe Software Inc |法律