Using transformers to modify data.
Recently active
I am trying to create depth zones (polygons) from a set of depth curves (polylines). I would like to create one polygon that covers the area between the 0m and 3m curves, one that covers the area between 3m and 6m, and so on. There are also shallows and deeps that need to be taken into consideration. What would be the best practise to do this? I have experimented with Testfilter » Areabuilder » Disolver » Clipper. But that quickly gets very convoluted... I am guessing that I could use one of the donut transformers to manage the shallows and deeps?
I'm using the following flow and getting two different results:The flow uses a cutting line and gives back the original (un)cut results. The polygon for this example is:POLYGON((145055.748 479705.959,145059.802 479704.301,145060.003 479704.791,145061.669 479704.11,145061.468 479703.619,145079.166 479696.383,145084.101 479708.452,145066.422 479715.682,145066.222 479715.191,145064.556 479715.872,145064.756 479716.363,145047.05 479723.604,145046.285 479721.734,145043.203 479722.994,145042.471 479721.338,145039.139 479722.701,145038.458 479721.035,145035.116 479722.401,145034.481 479720.846,145014.358 479729.074,145012.216 479723.836,145013.891 479723.15,145012.653 479720.124,145008.46 479721.838,145002.488 479719.333,144994.651 479700.17,144989.025 479702.474,144968.486 479652.247,144971.54 479650.998,145020.56 479630.952,145021.696 479633.729,145039.976 479626.254,145038.841 479623.477,145046.477 479620.354,145072.687 479684.501,145050.657 479693.509,145052.257 479697.422,145055.748 4797
When creating a label with the Labeller or LabelPointReplacer, a labelpoint is made at the asked position. However, the label itself is always placed on the right above position from the labelpoint.I need the label to be placed on the left above position from the labelpoint (thus having the point at the end of the labeltext instead of the beginning), in order to garentee a good label fit in the end result. How would this be possible?
The new DatetimeConverter works well for the gtfs stop times which are stored as only a time string field. But it rejects (naturally) any times greater or equal to 24:00:00. The gtfs convention is to roll over midnight for bus routes that do not finish before midnight. How might that be handled?I am trying to calculate the total time of a route using Arrival_Time - Departure_Time. I cannot just replace the 24 with 00 because I have to add up two intervals. I can see a clumsy three part conversion. There are 1.4M records so elegance and speed would be welcome.
Hi,Does anyone know how to get rid of/remove the KML warning when you add a overlay to the KML?KML: Raster feature has no fme_basename attribute; destination filename will be based on the feature idThanks!
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