Data

I have several county-wide 4 band GeoTiff imagery datasets that I need to review. Sometimes I identify the exact same image in two different tiles. I would like to automate a method for identifying this error. Does anyone have a workflow for identifying this or have any ideas on moving forward?

I'm on Windows 7 and I have a workspace (FME Desktop 2017.1.0.0, build 17539) that connects to a SQL Server enterprise gdb to export a handful of feature classes to a file gdb. The enterprise gdb is not versioned and is located on a server within my network, though not in my office, and I'm exporting to a file gdb on my machine. It's been working fine up until about a month ago, when I started getting errors. This is the error I get when running the workspace: "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216100'. The error message from ArcObjects is: {FDO error: -2147216100} Please ensure the connection parameters are correct (server=`server_name', instance=`instance_name', user=`username', password=`***', database=`database', version=`SDE.DEFAULT')"I can use the same parameters and connect to the gdb in ArcCatalog and ArcMap and can view feature classes within it. I've tried using

Hi All, I am using a reader that is connecting to Microsoft SQL Server Spatial if I connect an Inspector and run in the workbench, I get the following error on some (not all) of the data. Can anyone shed some light why this might be happening? As far as I can tell the spatial data is fine and the missing data does show in other applications such as CAD and ArcGIS (using a view) and in SQL Server Management Studio itself.     MS SQL Server (Spatial) Reader: Failed to write to the database because it could not be converted from Well Known Binary format to geometry MS SQL Server (Spatial) Reader: Failed to deserialize SQL Server geography binary: `0xBB100000020411000000D91B626FD3E43AC0D0F4B58B2AD062405D25081ED0E43AC03F9DA6BD2AD06240C0AC0D81CEE43AC0CCD91FF92AD06240CCB6CE8ACEE43AC03318DE472BD062409A332FC4D9E43AC0DFD2A9FD2ED06240147DD465DEE43AC0D7CD11A52FD0624066497962E5E43AC084BC4EA62FD06240AAFAF5E1F8E43AC04A1CD2802ED06240B0122D36FBE43AC067BC3B812ED06240931464C1FCE43AC0691909B92ED062

Hi,  I use FME 2014, and tried with quick translator to migrate popular AdventureWorks MS database to PostgreSQl server.  First I created PG database:  CREATE DATABASE adventure_works_2012   WITH OWNER = postgres        ENCODING = 'UTF8'        TABLESPACE = pg_default        LC_COLLATE = 'C'        LC_CTYPE = 'C'        CONNECTION LIMIT = -1; Then I added neccessary schemas, to allow FME Quick Translator do it's job.  However I get this error:  Bulk copy failed on table 'Production.Product' using delimiter ':'. Error was 'ERROR:  invalid input syntax for type numeric: "2,24" CONTEXT:  COPY Product, line 210, column weight: "2,24" ' and I don't know where could this come from. Looking inside database in SSMS I don't see such separot on the field, it's "2.24", and my regional setting also doesn't provide comma as decimal separator, so I don't know where does FME pulls this value and makes process fail.  Thanks   

Converting from SQL to AutoCAD Map 2018 with the OD writer. I've exposed both the autocad_map_odtable and autocad_layer format attribute then created the correct values. Everything looks good as far as primary OD Table Name and Layer Names. Except that I get the OD Table Name set through the exposed format attribute in addition to a OD Table Name for each of the new layers defined. My understanding was that by exposing setting both the layer and OD Table format attributes that the writer would suppress or only create on OD Table name?

I am trying to write out some “UK Flood Security” polygons obtained from an API to my ArcGIS Online account as a new Feature Service. I keep getting an error that the “Geometry Type: Unknown (0) and “No geometry mapping entry found for 'esriFieldTypeString(200)' in metafile 'C:\\Program Files\\FME\\metafile\\ARCGISONLINEFEATURES.fmf'. A fatal error has occurred. Check the logfile above for details.”The FME ArcGIS Online Writer has geometry set to Polygons. That is the data type I see coming from the API.

Hi, i want to delete a shape file after publishing it to a feature service on ArcGIS portal? would appreciate if anyone could help.So before that i have converted an excel to a shape, then a shape to a feature service but i want to delete that shape after

I have created a custom reprojection to reproject from ETRS89 to London Survey Grid. However this currently only takes care of the x y coordinates. I would like to create a grd file of the ellipsoid to orthometric height adjustments. I have created a grid of points with the height adjustment values but don't know how to get that into a format that CSMapReprojector can use. Alternatively, does someone already have a grd file for ETRS89 to OSGB?

Hi, I have a dataset with features containing three attributes. Each feature contains a text string such as SAINT PATRICK'S CLOSE (see below)or 'stacked' text, which contains carriage return and line feeds such as Saint Patrick's Cathedral (see below).Using the complex example provided by Safe i've created Tags for each attribute. Basically I need to retain the GUID, FORM_ID and FUNC_ID values on each feature in the DGN. When I write out the DGN file, all works perfectly with the liner text string. It retains the GUID etc tags and values. See below.The feature with the stacked text string gets split into five elements - one of each line of text and one for each carriage return/line feed.This would be ok, but none of the five output elements have any tags. I assumed each element would have retained their GUI, FORM_ID and FUNC_ID tags when written, but it seems all tags have been stripped instead. Is there any way to retain the required tags even though my feature get

By clicking "Download List" button, a CSV file can be downloaded from a web portal. I tried to extract the data by using HTTPCaller. However, the url is not in the html and the CSV is generated with JavaScript. Does anyone know how to extract data? Thanks!

I'm trying to visualize a scene using the FME Augmented Reality (AR) writer.As an Input I have a point cloud, and have shifted the origin with Offsetter. I used a PointCloudSurfaceBuilder to get a 3d object in the scene.The resulting model is full of holes, and the color attribute is not preservered, and although crude the model is with holes.I would like to know if some have had more succes and have been able to add the color information to the model?

I have a csv file that is used as configuration for various database schema attributes. Against each layer name there are a a set of fields and a set of values that are valid for the field.I have a workspace that can check if the database contains values that are outside the permissible range:However, this only works for a single row. What I need to do is to loop through the csv file processing each row individually like a recordset.Is this sort of behaviour possible in FME? I have seen some posts on looping but nothing that really fits what I am trying to do.

Hi! I am converting GIS data to GeoJSON files. Currently the GeoJSON files are within the JSON file. Is it possible to separate the JSON file so I can see the GeoJSON files along with the JSON file. Essentially, it would look like the image attached. Thank you for any help!David

I have backup copies of layers in an ArcSDE database, using two digits for the month (01, 02, 03, etc), in order to detect change from the updated versions. Is there a way to have the reader switch to the next month's backup by checking the system date so I only have to press play and not change anything other settings?

Is it possible to create a 3D model from a PDF?

Hello,I am trying to convert a DWG file with 12 separate solids to OBJ or DAE. The conversion is perfect, but the output is 12 separate files - is there a way to convert it into one OBJ file?I have just found another problem I can't resolve - in AutoCAD I have 6 layers, 2 solids in each layer. would it be possible to export each element as a separate object? (they are grouped) I would be grateful for some help ;)best regards

Hi experts,I had went through all the log files generated by the FME server but could not locate a log file that I could identify the following:1. Which user had logged on and hopefully include the duration.2. What had the user done in the server.Are there ways for me to obtain such information?Thanks.

Hi all,I am a FME begginer trying to load data into a Vertica DB.I am using the JDBC Writer to create table and load data. Table creation works perfectly, but then data are not loading, :JDBC Writer: Connected to 'Vertica Database' version '08.01.0001' using driver 'vertica.jar' version '08.01.0107' built against JDBC version '4.0'JDBC Writer: Connection class 'com.vertica.jdbc.VerticaJdbc4ConnectionImpl' is being loaded from '/C:/Program Files/FME/jre/lib/ext/vertica-jdbc-8.1.1-7.jar'JDBC Writer: Committing feature 0JDBC Writer: Creating table using SQL: CREATE TABLE "bi_core_staging"."events" ("Geometry_AreaInSquareMeters" double precision, "SeasonFieldId" integer, "Source_CallerLineNumber" integer, "Context_User__id" integer, "DateTime" timestamp, "EventType_ProtocolVersion" integer, "FieldExtIds__" date, "FieldId" inte

Does anyone have experience modifying a replica or version of a ArcSDE geodatabase in FME? After I make the necessary edits in FME, and write out to a new file geodatabase, Arc no longer recognizes that the newly created geodatabase is a replica to synchronize and reconcile with the original SDE.

Hi, we searching for a way to read or write .vwx VectorWorks Project Files. Is there a way with FME?

I'm trying to join a Shapefile to another table, but it fails.The joining attribute(encoded: utf-8) has value "41400562015" but during the prozessing it becomes "41400562015????????????????????????"I tried to change the attributetype of both fields into different types, including integer or varchar (12) - but the resulting string is still longer than 12 digits?... I also tried to calculate the string (left 12) into a new attribut or to use the trim-funktion. Nothing works?not to be misleading: the original connection attribute on both sides is a textstring like "BT-4209-0001-2018". No blancs.But the joining failed and i detected something like "BT-4209-0001-2018 ___________ " with empty spaces at the endBecause the connection with strings did not work, i changed it into numbers, so joining in FeatureMerger or InlineJoiner should be . (I have done the same connections thousands of times, thes

Hi, I'm wondering if there is a way to reconnect to a (sql server) DB if a connection problem has occurred. Here's our situation: Sometimes, very rarely, we are unable to connect to our SQL Server DB. It may work for 10 days straight, and then it fails one single time and will work again for a unknown timespan. The error message looks like the SQL Server is down (or the connection attempt is corrupted on it's way through our network):2018-03-21 07:01:18| 1.2| 0.0|ERROR |Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155559'. The error message from ArcObjects is: {Failure to access the DBMS server} 2018-03-21 07:01:18| 1.2| 0.0|ERROR |Please ensure the connection parameters are correct (server=`......) 2018-03-21 07:01:18| 1.2| 0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsWe've created a test environment where we run a FME job, which starts and connects to the DB, every single minute and

I have an autocad file with blocks that have rotation angles (flow arrows for example). I need to translate to igds and retatin the angle.

I am looking to use FME to load some data from a file geodatabase into an existing ArcSDE geodatabase feature class. I had done this in an older version of Desktop but can't figure out how to point the writer at an existing featureclass.

I am trying to access the GEOM column from a MSSQL 2012 Database using FME 2017. I have tried with the ADO, JDBC_Nonspatial und Spatial drivers. In table-view the column GEOM is never exposed. Do I have to manually expose the geometry column? If so, how?