Transformers

Can we do location search based on lat/long in data inspector.I'm trying to locate few points on the polygons.

I have a csv file looking as below ATT1 ATT2 ATT3 New Attribute Fri Jun 24 08:01:00 2016 1.46676E+12 A Sat Jun 25 08:01:00 2016 1.46684E+12 A Thu Jul 07 08:01:00 2016 1.46788E+12 A Fri Jul 08 08:01:00 2016 1.46796E+12 A Sat Jul 09 08:01:00 2016 1.46805E+12 A Sun Jul 10 08:01:00 2016 1.46814E+12 B   Mon Jul 11 08:01:00 2016 1.46822E+12 B   Sat Sep 24 08:01:00 2016 1.4747E+12 B  Sun Sep 25 08:01:00 2016 1.47479E+12 B  I want to set the "New Attribute" to 'Yes' based on the "ATT3" value of the last row. Or i want to filter the records based on the ATT3 value of the last row.

<?xml version="1.0" encoding="utf-8"?><SDDOT>  <item>...</item>  <item>    <id>497751</id>    <status>active</status>    <categories>      <category>        <name>conditions</name>      </category>    </categories>    <descriptions>      <description>        <phrase>dry</phrase>      </description>    </descriptions>    <locations>      <location>        <route>US-212</route>        <direction>Both Directions</direction>        <start>          <lat>45.0056</lat>          <lon>-102.8765</lon>          <milepost>71.713</milepost>          <landmark>            <place>Mud Butte</place>          </landmark>        </start>        <end>          <lat>45.0231</lat>          <lon>-102.0451</lon>          <milepost>112.715</

For any users who aren't on Twitter, we are on the lookout for any users who have used FME to create maps, or prep data for maps. This is for an upcoming webinar, so we're looking for customer examples and experiences to share.  If you've used FME to create some PNG or PDF outputs or used it to prepare data for a map we want to know what your workflow looked like. What transformers did you use? Did you face any challenges?  If you've got something you're interested in sharing, let me know below!

Can somebody please help me understand how to use the python caller? I have looked at tutorials, older code and even help for the error i get which is - Python Exception <NameError>: global name '_file_contents' is not definedI am unable to resolve this. I need to match the coordinates in my shapefile to the coordinates in my point cloud file and extract the point cloud classification data. I have a number of unresolved issues with my logic but my important question is the followingHow do I import and manipulate attribute values in a python caller in fme?In my workspace, I have a shapefile with 12 points. I am extracting the coordinates of it and storing it as a string in the _file_contents variable [in format (x,y),(x,y), ]. I need to perform a lot of manipulations on this but to understand if I am using the transformer correctly, I am performing this first basic function of removing the last comma from my string. However, I keep getting the error I have posted above.I h

Hi FME'ers,It's that time to celebrate the top reputation-winning knowledgebase member for October.This - you'll remember - is the person who earned most reputation during a calendar month (and you had to be in the top ten with at least 100 points, and haven't won this before!)The winner for October is @cartoscro with a score of 410 reputation. It wasn't a high-scoring month, but he scored enough points to achieve the top-ten in most months so far. He joins the list of previous winners:@takashi@david_r@jeroenstiers@jdh@itay@gisinnovations@erik_jan@redgeographics@danilo_inovacaoThe top ten for October:david_r: 2153takashi: 1755erik_jan: 1195redgeographics: 955danilo_inovacao: 572cartoscro: 410jdh: 330larry: 310sander: 3051spatialdave: 288Congratulations to you all, but particularly to @cartoscro, and to @david_r and @takashi for being top of the list again and for so many months in a row. I know everyone here appreciates all your efforts highly.Mark

I have a dataset with a name field and an index field which is in order. I want to output a shapefile that orders the FID numbers like so in order but I can't figure out how to output the file without it randomnly assigning any number as the FID. It needs to be ordered correctly so any help with this one would be appreciated.FID Id Name0 1 Northland1 2 Auckland

I am having issues dissolving large sets of data, the Dissolver works fine and achieves the results I would expect but when I increase the number of data going in the process becomes painfully slow and often results in a crash because of memory.

Why can't ListExploder see result{} from a reader that reads json with the output of result type array?? I have tried jsonFragmenter but listExploder still does not see result{}.

Hi,I've tried to facilitate using the SpatialRelator with the "Input Ordered" set to "By group". And set the "Group By" value to a common attribute.I sorted both my Requester and Supplier inputs by the same value. But even though the log file shows the expected groups, all groups have no matches (typically "0 BASE(s)").Please advise as to how this functionality is supposed to work.I got the process running by setting "Input Ordered" to "no" (keeping the "Group By"), but I think that this is not as efficient.Cheers.

I tried looking for similar queries but I need some help with this asap. To explain my question further, I have a point cloud with x, y, z and the fourth column is a componentID (after having done connected components) I have a text file which consists of a string of component ID values.I am trying to filter the point cloud based on the number of component ID values in my text file. So, I have a couple of questions.1. I am trying the basic method by filtering the point cloud based on the value of the component but I keep getting the following error PointCloudFilter(PointCloudEvaluationFactory): Attribute 'C1' is specified in an expression but is not present on the feature. Please ensure the feature has all referenced attributesI am not really sure how to solve this. Because if I use an attribute creator to assign values to C1 independent of the values from text file, it works fine. But when I integrate it with text file it goes into error.2. My text file will not always contai

I have HTTPCaller connect to JSONFragmenter connected to JSONExtractor. Are these list that have to be converted?

Hi,I wonder how can I call @Http function with the FunctionCaller transformer?The reason is that HTTPCaller does not support specifying proxy server directly, but the @Http function seems like it supports custom proxy setting.Thanks,

Is there a way to tell an SDE reader to forget the spatial? I can read as SQL Server Non Spatial, but I lose the SDE ST.Area attribute, which I need. However, I don't need the actual geometry and reading it wastes 30 minutes.---- Hoping for an "opposite of Geometry Only".Thanks,Jake

Hi,Faced with having to handle multiple large datasets (5M+ features), I'm looking into whether I can improve performance. I just had one of these dataset crash after 12 hours !The task is matching any source data set (only) spatially with a data set of buffered municipalities, and so there are no common attributes. I.e., no possible values for "Group By". Any source feature could possibly end of in any number of municipalities.Is it possible to get a performance boost under these circumstances ? And if so, how ?Cheers

When using the GridInquest11Reprojector to project data from irish grid to ETRS89 Geodetic the following fatal error occurs "Source coordinate system 'Irish Grid' cannot reproject to destination coordinate system 'ETRS89 Geodetic', either 'Out of Area' coordinates or invalid coordinate system parameters Reprojector: Reprojection failed" This doesn't happen when reprojecting the same data set using the GridInquestReprojector. Only the first pair of co-ordinates appears to be projected when using the GridInquest11Reprojector as per the extract from the error log below.Geometry Type: IFMELine Number of Coordinates: 78 -- Coordinate Dimension: 2 (-6.5027536642668426,53.275450616997503)(299914.2325,226047.6043)(299912.3574,226060.10490000062)(299909.2323,226072.6055)(299909.8573,226083.8561) (299911.1074,226098.23169999942)(299920.4828,226106.9821000006)(300232.9973,226190.1109)(300303.6255,226166.9849)(300321.7513,226161.9846) ...Skipping coor

Hi there,I've searched a few threads on here about calculating percentages, but nothing seems to quite summarize what I'm looking for.I have several polygons, each containing an attribute of "TotalKm" and "MinorKm"The "MinorKm" represents roads inside that are of a lower class or quality.I simply want to calculate the percentage based on the "TotalKm", like this example:MinorKmTotalKmPercentageKm156025%15020075%I tried playing around with the ExpressionEvaluator to do this, but I could't quite create the correct expression for this.Thanks in advance,

Most of our ArcGIS projects are in a custom projection based on NAD83 2011. I cannot find a transformation for converting the data to EPSG4326 (WGS84) for export to kml files. I added the custom projection to the MyCoordSysDefs.fme file and it is reading the parameters. Anyone else working in the 2011 datum trying to export to KMLs? We are seeing a shift using the older NAD83 to WGS84 transformation, how do you work around that problem? Did you have to create a custom transformation?It doesn't help that ESRI refers to the datum as GCS_NAD_1983_2011 and FME has it as NSRS2011. It appears not able to translate those two.

Hello everyone,I'm stuck on something in FME and looking to you all for assistance.Little background for the following example is I work for a Large Utility Company and working with data in an electrical system which is Points and Lines:Here is the the basic description of my problem and what I am looking to achieve and I have the workbench built (or did until I ripped it apart trying to solve this).I have a LINE object (Primary Conductor) being filtered by an Attribute (Circuit) and have multiple different features (all points, representing the different electrical devices) which have a Circuit field but in some TiePoint cases the Circuit field could be different.Therefore I am running a SpatialFilter on those points that touch the conductors and after it runs through the rest of the workbench produces an object named by circuit and the type of device it is.My workbench accomplishes everything I need it to EXCEPT the points that join between two different circuits (Lines with diff

Hi,I’m trying to transpose the following table from SQL Server:KriterieTestparameterVerdi 1Verdi 2Verdi 31UNIKEnToTre2STADNasjonal5PROD123Into this table (first row as column name):TestparameterUNIKSTADPRODVerdi 1En1Verdi 2To2Verdi 3TreNasjonal3Kriterie125Using this article, I’m able to transpose the table into (column name like A-G): https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.htmlBut for further use the column name must be the first row, not A-G.How can I set first row as column name? I’ve tried using the AttributeCreator with values from a second list, and exposing the dynamic attributes afterword’s, but I can’t get it to work.. Attribute name from list example: New Attribute = @Value(_testpara_attri{0}._testpara_value)Attribute value = attrs{0}._attr_valueWhere _testpara_attri{} is the list with column names, and attrs{} is the list from the transpose routine. Workspace:

Hi, I want to do a point on polygon analysis and list all the records under each polygon without merging duplicate properties.I’m using Spatial Filter to find the properties within a given area. It’s giving the correct output if I send one record at a time. But when I send all the area records to Spatial Filter it merge duplicate properties (candidates) to a one record.I’ve change parameters on the Spatial filter but failed to get the expected output. Can someone please help me? Area record and relevant properties Area ID Property 1 A 1 B 1 C Area ID Property 2 C 2 D 2 E Expected Output Area ID Property 1 A 1 B 1 C 2 C 2 D 2 E Expecting 6 properties, not 5 properties after merging the duplicated property C.Thank you.

Hi,I have what I think is a fairly simple question. I just want to calculate the average of all the cells in one band on a raster. I am using FME2017.0.Is there a simple way to do this without having to convert the rasters to vectors (points) and then using StatisticsCalculatorThanks

Is there a way in FME to detect if there has been a change in the attributes name or if there has been a new added attribute to a source file how it can be synchonised in writer