Using transformers to modify data.
Recently active
I've got thousands of thin polygon and their centreline. And I can calculate average width of each by using polygon area divide centreline length. I want to generate some random width number based on the average width and the numbers are between max and min width of the polygon.My first thought is to create points along the centreline with small interval like 1 meter, and create station lines based on the points. Then use polygon to clip these station lines, the shortest and longest length of station lines will be the max and min range. So I can generate random width numbers in excel.I've already got the interval points by using @takashi 's LineDivider, and some articles about calculate line angle and create bearing line. I just want to know if there's an easier way to do so, and only in FME. To get my thought work, I have to switch between FME and ArcGIS, and also some third party add-on in ArcGIS. It is too complicated for others to use it.
Hi, Im trying to split a large dataset of lines (~1.2m records) by an almost equally large dataset of polygon boudaries (~900k records). I have tried Line Over Area Overlay, but no luck there. I tried creating points at the intersections of the lines and polygons boundaries, and executing point on line overlay, but I came up empty there as well. Has any one run into this problem before, and what conclusion/solution did you come to?
Hi,Is there any way of reading AutoCAD dynamic block names/visibility states? Currently all I can seem to get is the anonymous '*U___' value in the 'autocad_block_name' field.I feel like there should be a way of reading the real block name somewhere, as it picks up the correct block names in the reader parameters under 'Explode Selected Blocks'. Any help would be appreciated!Thanks.
Comment effectuer une boucle sur les éléments d'une liste pour pouvoir créer autant d'attributs que de valeurs de la liste ?How to loop the elements of a list to be able to create as many attributes as values of the list?
Anyone able to help me with this?com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host DEV-TFS, named instance TRAVEL failed. Error: "java.net.UnknownHostException: DEV-DB". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.Working on FME Desktop but when I published the workspace to FME cloud this error comes up. I believe I already enabled inbound UDP traffic to pass through on port 1434 shown below. Any idea what else am I missing?Thanks in advance.
Hi,I use the StatisticsCalculator and group features by attributes. The result features do not have a geometry anymore.I cant see see why this happens - anyone having a tipp?Rob
Hi there,I'm completely baffled about how the "Apply to: Cell" function works in the ExcelStyler transformer.The explanation of how this works (at least to my untrained eye) seems pretty confusing:"Specifies which cells will be styled. This option allows selection of attributes, which correspond to columns in Excel, to style for each incoming feature, which each correspond to a row in Excel. The result is that the intersection of the columns and the rows are the cells that will be styled. Note that this can only be set when applying formatting to cells." I don't want to involve any attributes into the equation, but instead just want to always style "C7" in a specific way, for example. Is there any way I can do this? I have several cells to style individually, but how to set up these attributes to represent the rows and columns (I guess?) is blurry to me. There will be no dynamic values or anything, "C7" will be styled in one way and alway
Hi FME community.I am trying to color my 3D object based on its fme_color attribute but I don't know how to do it.Currently fme_color is set as cyan. So, if I can how this as 2D in the Inspector, it shows as cyan. However, if I switch to 3D, it becomes gray. I think this is a default color. I looked at the Front Appearance Reference and this setting is set as <inherited_or_default_appearance>.If I can set the Front Appearance Reference as same as fme_color, then this 3D object will be cyan color. I used AppearanceSetter to manually set the Front Appearance Reference but I don't know how to change it with transformers.If someone who knows how to do it, please share your knowledge.Thank you in advance.Hiroo
Hi,I am new to the appearance setter and while I having no trouble applying a colour using the appearancesetter, I am having trouble applying a texture. Can someone please me show me how?Attached is a FFS file with 9 roof geometries and 9 images, both having a _count attribute that references them to one another.Thanks is advance,Todd
My goal is to identify the dominant color in a JPG. For instance, your JPG is mostly 'green'; that is, most of the JPG pixels fall somewhere in the 'green' hue. I've looked into using a Python script, but unfortunately my Python skills are limited so that option has been troublesome. I've also tried the 'RasterCellNeighborSummer', custom transformer but I don't get any output. I've attached a basic workspace that just feeds in a test JPG to the 'RasterCellNeighborSummer' transformer.
Hello, I am creating a workspace that will export photo (.jpg) and video (.mov) attachments from a FGDB. The FGDB contains a related table holding the attachments in blob format. Per the suggestion found here https://knowledge.safe.com/questions/58775/exporting-geodatabase-attachments-to-jpeg.html , I was able to use a FeatureMerger, RasterReplacer, and a JPEG Writer to successfully pull the photos out. I have isolated the "video attachment" records after merging the data with the related table via a Tester, but I am unsure how to proceed. Is it possible to write .mov or other video files from FME? I have not seen a writer for video formats (similar to the JPEG writer used to write the photos to file). Thanks!
Folks, This should be simple but I'm just not finding the answer.Using an AttributeManager I want to add a value "0.09" to all the existing values in a column of data from a Mapinfo table during translation amongst other things.The Column is "Average" and is a defined Decimal type field.The syntax I'm using is clearly wrong.@Value(Average)+0.09 returns -9999.00 for all values.What am I doing wrong?Thanks in advanceAndrew
Hello,I am new and just starting out using FME. I have several .LAZ files and I need to get the coordinates and elevation out and into a .CSV file. I have tried to use the LAS reader >>> Point Cloud Coercer >>> CSV writer. All I get is a file filled with commas. Can someone walk me through what I need to do to get the x,y, and z data?Thanks
I am trying to calculate NDVI with a RasterBandSeparator, Test Filters and NDVI Calculator. Prior to running the RasterBandSeparator I am also using the RasterMosaicker and RasterTiler since I want to remove the overlapping edge effects of the imagery. I have added an image of the workbench so you can see where the error occurs. Looks like it's occurring once data for the next tile is being passed to the NDVI calculator. Any help in debugging his would be appreciated. I could re-tile the imagery first I suppose but then I'm reading the source data multiple times. t
Hi,My Workspace clip area but don´t preserve the attributes of the Clipee. What transformer I could use to clip area and preserve the Clippee attributes. I tried the Clipper but unsuccesfull.Thank´s
New user here - thanks in advance for the help! I'm trying to use Coordinate Extractor to populate XY from address but not having any luck. Any suggestions? Thanks in advance.
Hi,My Workspace run by command line...There is one Emailer transformer and other output shapefile. When I run by FME Desktop, the workspace run properly, but when I run by Task scheduler the log file show me TOTAL FEATURES WRITTEN 0, and the e-mail wasn´t sent. What I can do?Thank´s
I have a shape file with depth readings in various lakes and am trying to find the deapest value in each lake. In order to do this I first need to group the features by vicinity, so that each group represents a lake. Then I can move on to find the highest value in each. Below is a screen dump of my data. What I esentially want to do is to group each of the clusters below by vicinity and then attach a identifying attribute to each group.I have had a look at neigbourhoodfinder, clustermodeller and a few others, but have not found a way to get any of them to do what I want. To a human eye the groups in the image below are obvious, and it is sligthy soothing that we can beat the machines now and then, but this time I need the computer to do the work.
Howdy!I have a question about "Summary Annotation", when used with transformers like the AttributeManager or AttributeRenamer it does not expose all of the attributes. Example of the transformer issue: Using "Summary Annotation" with an AttributeManager transformer, the list/table of "Attribute Actions" that is shown is limited to 20 (seemingly random) attributes/rows. At the bottom of the annotation list/table it states "41 more row(s)". Is this just a default setting? Is there a way to get it to show me the other 41 rows? Compared with a Reader/Writer: However it appears that Summary Annotation exposes all of the data when used with Readers/Writers. I noticed that when I use Summary Annotation for a transformer like a SQL Writer, there seems to be no limit to how long the list/table of fields/attributes/rows that can be displayed. Any help understanding this limitation and/or a work around is appreciated.
Just report a small (but annoying) issue. I noticed that the XMLXQueryExploder on the Canvas exposes incorrect attribute names, which contain a leading or trailing " (double quotation). See the screenshot below.FME 2018.1, FME 2019.0 beta b19092
I have a bunch of images that I want to rotate on their self. Like this example.Do you know an API that I could use in FME or a transformer that could do the job?Thanks.
Hallo guys!I have again some problems which i hope anyone can help me. In the first picture i show my template where i try to get the points out of my lane. It works but i just want the points one by one (and not all as you can see on picture 2) and also that the template start new for every single point.The next problem is that i get the value "0" sometimes between my coordinates and i have no idea why. How can i change that ? (also visible on the second picture)
I have hundreds of html tables based upon a year/month selection. I have figured out out to generate the html files. The problem I am having is converting the html to a usable tabular format. Example url. http://bbnet.gein.noa.gr/alerts_manual/2006/01/manual_alerts_01_2006.htmlAny Ideas?Thanks Frank
Hi,I'm having problems using the Clipper transformer with 19 las point clouds as the input / clipee and a MapInfo tab file as the clipper, with the output being written as LAZ files. The workspace works fine if I just run it in isolation, as shown below:However, in addition to the output from the Inside port of the "OSTile_Clipper" being written as a series of LAZ files, I also want to put this output this through a 2nd clipper (ControlSurfaceClipper) as the Clippee and have it clipped against another MapInfo tab file.On enabling the ControlSurfaceClipper tranformer and it's associated Clipper input port, all outputs from the 1st transformer are now output via the "Outside" port and no data is output, as shown below:How do I get around this, so when all transformers & writers are enabled, the data from the 1st Clipper transformer is output via the Inside port?Below are the parameters for each clipper:Thanks in advance!
Hi, I am using FME Desktop 2016.1.3 on a Windows 8 computer with 12GB RAM. One of the readers I am using is the MSACCESS_JDBC reader. While initialising that reader (it seems even before starting any reading) FME throws the error "java.lang.OutOfMemoryError: Java heap space" and cancels the translation. How can I tell FME to give more memory to Java?Many thanks!!!