Transformers

Hello, I have multiple exifs which I have extracted information from. Then I have performed calculations based on pixels and orientation which has produced 4 new points with coordinates for each exif raster extraction. I have from this extracted X and Y coordinates as attributes for each point in a total of 8 attributes.I now want to georefence these images which I read in as Tiffs by these coordinates for each raster.I then seem to have stumbled upon two problems:1. I can't seem to get the raster georefencer to fetch information from attributes which I feed in at the different spots. It works fine if I physically write the postions on each slot, however as soon as I allocate the attributes it fails to retrieve the coordinates. I know that the coordinates work, they georefence one image if I take the coordinates from the attributes and write them in.2. I can't seem to feed the raster georefencer from two different paths, it just takes the raster and stops the process with an er

I am trying to extract features based on near-infrared light reflectance

Dear FME Forum,I am relatively new to the Software, and just wondered if it is possible to count "Null" or "Missing" values with the Statistical Calculator? With the statistical calculator it is possible to count the Total amount of Values for an attribute but not how many that are empty. The Null Mapper or Tester is great, but I am looking for a Transformer for the whole range of attributes. Should I use a Python Caller for this or is there an existing transformer? My Question stems from PowerQueryIn Microsoft`s PowerQuery it is possible to get an overview of how complete your data is, I am looking for the same result (please see Screenshot below) Here is a link to the PowerQuery Table Profile:https://docs.microsoft.com/en-us/powerquery-m/table-profile  Thanks in advance Fred

Hi, I am new to FME. I plan to get a FME Desktop license but I want to know if any users can share their experiences of the following: 1. Can FME command line tool create vector data to Esri Shapefile, Bentley v8 and AutoCAD dxf file? What is the quality of the output files?2. Can FME command line utility produce good quality PDF file from Esri shapefile, Bentley v8 file and AutoCAD file?

Hi, I have imported an Excel spreadsheet into FME, one of the columns contains data similar to the below, I am looking to filter the records between the PTO On and PTO Off values, anything else I wish to remove.Is there a way to do this using FME transformers? Many thanks for any help in advance. Ignition OnJourney StartIdle StartGPS PeriodicGPS PeriodicGPS PeriodicDigital Input 0 HighPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicDigital input 0 LowPTO OffGPS PeriodicGPS PeriodicIdle EndGPS PeriodicGPS PeriodicDigital Input 0 HighGPS PeriodicPTO OnGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicGPS PeriodicIdle StartGPS PeriodicDigital input 0 LowPTO Off Thanks,Charlie

I use the ZipExtractor and ZipArchiver custom transformers by @takashi from the Hub on FME Server 2016 for multiple processes. Now we are migrating to FME Server 2019 and these are not sustainable because of Python incompatibility. I found the FileCopyWriter can work as an alternative for the ZipArchiver. Does an alternative for the ZipExtractor exist?The alternative is I try to upgrade the ZipExtractor to Python to 3.x but as my Python-fu is not amazing... I know Readers can read directly from Zip but my current proces unzips the entire Zipfile and then processes the different unzipped files.

Intersecting some points with polygon features, there are multiple points per polygon. The trouble I'm having is I'd like to have a delimiter separated summary of an attribute from the joined points. As an example, three points might intersect one polygon (they have ID values 1,2 and 3). The desired output would be polygon geometry with a field called Summary ID and a value of "1;2;3" for that polygon. Does anyone know of a transformer that might handle this attribute merge?  

Hi there,I'd like to know how I can detect scenarios where polyline features cross each other without the presence of any vertices. See my awful paint work as example:So in this scenario, both the red and blue line has no vertices where they cross. These kinds of situations, as well as one where just one or the other has no vertex, is what I'm trying to identify. Meaning, in all cases in my data, both edges need to each have a vertex wherever lines cross. Thank you in advance!

I want to categorize all properties across BC based on the federal electoral districts. I have the Esri Geodatabase file format for the federal electoral districts and have all the properties with their latitude and longitude information stored in a table. what will be the best approach to resolve this ?

Hi everyone,For each record in the CSV file, I want to find the closest point to it from a SpatiaLite database using SQLExecutor. What's the most efficient query that I can use to tackle this task because my SpatialLite DB contains over 35 mil points? Thanks in advance! 

Hi, I am trying to pull some content from XML and making a mess of it.I use the XMLFragmenter extract from this:<?xml version="1.0" encoding="UTF-8"?><wfs:FeatureCollection xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:wfs="http://www.opengis.net/wfs" xmlns:gml="http://www.opengis.net/gml" xmlns:workspace_wfs="workspace_wfs" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" numberOfFeatures="5" timeStamp="2019-10-11T13:52:44.446Z" xsi:schemaLocation="http://www.opengis.net/wfs https://geoserver.xxx.com/geoserver-cluster/schemas/wfs/1.1.0/wfs.xsd workspace_wfs https://geoserver.xxx.com/geoserver-cluster/wfs?service=WFS&version=1.1.0&request=DescribeFeatureType&typeName=workspace_wfs%3Abasin_models"><gml:featureMembers><workspace_wfs:basin_models gml:id="basin_models.48"><workspace_wfs:changedetect_date>2019-09-11T09:33:46Z</workspace_wfs:changedetect_date><workspace_wfs:changedetect_uuid>46af9f38-5edd-4b33-8f15-6c

I need to join fields from one table to the another. Because of the nature of the join, I only want one match per record. If there is more than one match, that is redundant data. It looks as though the FJ is adding records when there is more than one match.Can I tell it to take the first match, so that my output has no more records than the input - "Left" table? Thank you, Randy McGregor

Using FME2019.1 I get some unexpected behaviour of SpatialRelator3.Instead of 'merging' values from SpatialRelator & SpatialRelator_2, FME seems to copy attribute values from one attribute to another. (see screenshot).'grafnummer' & 'bloknummer' should have different attribute values but FME seems to 'copy' values for both attributes. This behaviour does not occur when running the workspace in 2018. 

I had a BulkAttributeRenamer with the following parameters:  To remove all attributes that have names with invalid characters. But this setting holds the entire process without error. No features going in. If there is a blocking transformer before the BulkAttributeRenamer you will see log Messages going out of the last transformer before the blocking transformer. But nothing after that. First i thought that the blocking transformer would be the bug. But changing the settings of the BulkAttributeRenamer to Text to Find: [ \\\\] fixes the process.The bug is in:2019 beta2019.0.0.1 The bug is not in:2018.1.1.2     

How can I write the selected attributes to CSV from AttributePivoter?I don't know the names in advance it's a dynamic list of attributes.

I'm migrating a project from FME Server 2018 to FME Server 2019.0.0.1 (build 19246) and am seeing this error when running a workspace on server 2019 that used to work on server 2018.50InlineQuerier (InlineQueryFactory): An error occurred while creating the table 'features'51InlineQuerier (InlineQueryFactory): Database was unable to define table 'features'.52A fatal error has occurred. Check the logfile above for details When I run the workspace locally in FME Desktop 2019.0.0.1, I don't get the error. Here's a mini workspace that has the same issue: What can I do to get my workspace running on server 2019? 

Hi all, I am trying to calculate the surface area of different LULC classes. I have to do this for very many different polygon areas, using the Rastertopolygoncoercer takes too much time, so I do this by counting the pixels of specific values, and then calculating the surface area based on the pixel size of my raster. Ordinarily I would do this with the ArcGIS Zonal Statistics function for rasters with the "count" functionality and be done with it. This does not seem to exist in FME, the RasterStatisticsCalculator misses this feature (and only that feature, strangely). So what I do instead is per class, replacing the cell values with 1 (and all others 0), and then calculating the "SUM" with FME's RasterStatisticsCalculator. It gives me the result I want (in a cumbersome roundabout way) but then, I want to save the attribute table separately from the raster. Because when I do a rasterstatistics of the individual rasters (which are clipped with the polygons, and t

Hello everybody,I just have one tricky issue - how can FME detect attribute value, which is composed strictly by white spaces, e.g. ? Its not empty value in DB view, but it is hardly detected. Any idea please?It doesnt matter on count of white spaces.Thank You so much!Lubo

As question title mention it, I would like to split an Access table's fields to be able to connect transformers on several fields in order to achieve date formating.I've been able to connect one field (DConseil) but I wonder how to connect specific transformers on the others date fields and let them work simultaneously, if it's possible.I've tried several times to redirect features through spliting, filtering, testing, and so on but I'm certainly thinking the wrong way.To keep it simple : how can I achieve a "routing" before adding transformers on each ports.Sorry for any duplicate but I didn't find any valuable answer to my problem for now.Thanks in advance for any help.Pierre.

Hi everyone, I have a geometry question.As you can you in the following image, I have three different circles that overlap. How do I extract the red lines?

Hi All,Thanks to all the experts for providing solution to my transposed doubt sometime back.Here is an another challenge that i faced with now. I now have multiple columns instead of two.where [A-R] are the required column names and the data from column 2 to last column should be the rows. Now i want two solutions:1) Transpose only the given data in pic (must need)2) The set of required columns (A-R) will repeat for the next file(when reading batch files) and needs to be given a common id and the entire data transposed. (optional) Kindly help. Thanks

Hi All,It seemed a bit easy but i am stuck with it now. Can someone please help?My input is somewhat like this: and my desired output is like this:The 6 values (Acquisition date, Analysis Date, System, Method, Sample ID and Data filename) are repeating three times in first column and have different values. I have attached the excel file for your reference.

Need a outputOutput from JoinerMy linked xcel file

Hi, I have observed that the pixel values of sentinelhub data and S3 bucket data are different. I have tested by downloading same date tiles from sentinel hub and FME S3 Bucket. Do anyone know why the values are different? or which data to use is preferable like is the error is in sentinel hub or S3 bucket or FME extraction.

Hello,I'm trying to figure out a way how to do a data profile, similiar to skim in R.Something like this:But idealy without having to use the Python, or R caller...The statistics calculator does count, min, max, etc, that helps. But I need unique, missing and nulls as well.Is there a simple way how to do this in FME?