Using transformers to modify data.
Recently active
I have a line feature class (with a field SURVEY), which I want to separate into 2 feature classes. In the first one I would have those features that have more than one feature with the same value in the field SURVEY - and in the other one - those features that have a single entry for a value in the field SURVEY.I believe I could explode the original Feature class by the value in the SURVEY field, then count features in each of them, then test for value "1" and merge if required. But I don't know how to create separate features based on the value in the field.Just to give you a context: For the first one I will later create convex hulls based on field SURVEY, but for the other one - buffers (as the convex hulls wouldn't look too good for a single lines). But this is not part of the question - as I know how to do it.Please advise.
I am attempting to develop a workflow that detaches a SQL Express database, downloads and copy an updated version of the database, and reattaches the database. I have the middle section working (FTPCaller and filecopy writer), but I'm struggling with the attach and detach. I keep thinking there might be a way to do this using a startup and shutdown script, but I'm not having much luck. Has anyone had any success doing something similar? Any suggestions are greatly appreciated. Thanks!
HelloI have some GPS data from a dashcam which contains a strange coordinate system which i have never sen before, I am guessing it is decimal degrees but can not be certain. Does anyone have any ideas as to what it is and more importantly how to convert it to British National Grid.Thanks in advanceAndy
I am trying to replicate what these two ArcGIS APIs below do in FME, between a polygon and a point, and a polygon and a polygon respectively. Which FME transformers can do best this? I tried SpatialRelator for the 1st, but it gives a lot less records than the arcpy. The arcpy adds a polygon for each point. For example, BHP_WELL_PATH_BUFF_FC has 28 polygon, there are 91 points that fall into those polygons, so WELLS_FRAC_HITS_TEMP_FC duplicated some of the polygons to be 91 polygons, one for each polygon. The SpatialRelator only gives 28 polygons. It does not have the "JOIN_ONE_TO_MANY" ,"KEEP_COMMON", and "KEEP_ALL" options.arcpy.SpatialJoin_analysis(BHP_WELL_PATH_BUFF_FC,THIRD_PARTY_FC,WELLS_FRAC_HITS_TEMP_FC,"JOIN_ONE_TO_MANY","KEEP_COMMON"..arcpy.SpatialJoin_analysis(WELLS_FRAC_HITS_TEMP_FC,PRODUCTION_UNIT_FC,WELLS_FRAC_HITS_PU,"JOIN_ONE_TO_MANY","KEEP_ALL"
Background: I am maping a system of marked trails in a national park. There are dedicated trails for hiking, short walks, skiing, cycling, snow mobiles, snow shoes and what have you. In short it looks like someone droped a bowl of noodles over the place. In many places there are many uses for the same trail section, and it is these overlaping sections that I am trying to clean up. Question:I have used LineOnLineOverlayer to find the overlaping sections and have created a List over the attributes that identify the type of trail, but from there I have not found the tools to move on. What I would like to do next is to break appart the overlaping sections from their original longer lines and apply a number of sorting rules to the List. Some examples: Where hiking and skiing overlap I would like to delete all but one polyline and give this a new code. If there is a Nature trail I would like to delete everything else but that. If there is a cycling trail I would like to keep that for later
Hi,I have Yellow lines with values ( attribute Value ) and i need to assign value to quotes ( red lines ), respecting the interval Value+1:My situation:What i want ( black numbers ):Attached my files.Thanks, - Danilo
Hi! My problem is that I have 2 readers combined, en excel sheet and a path folder with subfolders and documents inside. The inspector reads them without problem. At a certain point they go to a feature merger, from where I get an error report. The error reports shows that non of the documents from the folders are present. Does anybody know why that happens? The next screenshot shows how are they connected and what happens. Those 21 unmerged requestor documents should not go to the error report because they are present. Any help?? Thanks in advance. I am not very good at this but I try...
Just wondering if there is a way to transform a revit file from London Survey Grid into British Grid within FME?
Hello!I need som help with creating a outer boundary line with some other transformer than the "Hullaccumulator".The "HullAccumulator" (concave) in combination with "DonutHoleExtractor" works great and do what I wanted it to do but it cannot run Alpha value below about 0.5 because then my computer is chrashing! (out of virtual memory) And it have a fast i7 CPU and 32 GB RAM and a SSD drive but it does not helping me much...Is there a way to do this in an exact way and not rounding corners like in the "Hullaccumulator" with for example Alpha = 1 (that is meaning 1 meter radie in the corners and that is too much).I attache 3 Shape files that has totally 9 polygons that I want to be combined to only 1 outerline.Best regards,Jonas
I have a number of space delimited XYZ files (DTM data) and need to merge them and then split them into 1km x 1km tiles. The final dataset needs to be an .xml file that Civils 3D can use and produce a surface out of it.I've used the tiler transformer but i'm running into errors during/after the tiler processAny thoughts? Am i missing something in the process?
Greetings FME Community!I have a CityGML of buildings [1] and I want to attach new textures to the roof surfaces.The Appearance should be a texture based on a specific GeoTIFF that was generated for every buildings.Every GeoTIFF has the CityGML feature unique id as name. I don’t find a way to save every texture in the FMELibray and, mostly, retrieve the right Appearance for every feature of the CityGMLd to I think this should be related to the AppearanceSetter [2] settings or SharedItemRetriever [3], but I can't figure how to use them properly. Kind regards, [1] http://donnees.ville.montreal.qc.ca/dataset/maquette-numerique-plateau-mont-royal-batiments-lod2-avec-textures[2] https://docs.safe.com/fme/2017.1/html/FME_Desktop_Documentation/FME_Transformers/Transformers/appearancesetter.htm[3] https://docs.safe.com/fme/2017.1/html/FME_Desktop_Documentation/FME_Transformers/Transformers/shareditemretriever.htm
Road Number Runoff loss of control driver side Runoff loss of control passenger side off path Head on loss of control Head on overtaking Intersection Property access Other Fatals Serious CRA_ROUTE = 1 CRA_RUM_CO IN(72,73,82,83,84,85) CRA_RUM_CO IN(70,71,80,81,86,87 ) CRA_RUM_CO IN(74, 75, 79, 88, 89) CRA_RUM_CO = 20 CRA_RUM_CO = 50 CRA_RUM_CO IN(10,11,12,13,14,15) CRA_RUM_CO = 47 CRA_RUM_CO IN(30-39, 40-46, 48-49, 51-69, 90-99) CRA_DEG_1 = 1 CRA_DEG_1 = 2
In System Cleanup on FME Server UI you can set tasks do remove files (in Source Folder) older than some amount.Does it delete all subfolders in that given Source Folder?
Thanks all for attending and thanks to Mark for taking the time to run through things with us.We want these sessions to be driven by the people attending so that you find them useful. We originally came up with a set of topics to talk about the first of which were the general best practices for loading large datasets.The other topics are below but if you have other areas you think would be useful to cover then please let us know.I will propose another time in a couple of weeks for another session and I suggest maybe covering COU as that is something i think that could be a tricky area and is something we are looking at in ALT at the moment.Change only updatesAdditions, deletions and updatesTracking changesCreating history tablesCreating copies of updated features to use in comparison (COU Preview) Flattening/expanding of structureAddresses that have a master record and then multiple sub records Normalising/de-normalising data structures Differences between FME and data interoperabilit
For a customer I had to exchange the FME 2015 UpdateDetector in a workspace with the FME 2017 version of the same transformer.I have copied the same settings from the FME 2015 transformer and use the same dataset.The performance for the workspace went from 5 minutes to 50 minutes, and a lot more (75%) updates were detected.Has anybody the same experience with this custom transformer.Just wondering what could cause changes to be detected with the new transformer that were not detected with the older version.Any suggestions are appreciated.
SliverRemover remover has option Repair Method : (Priority Longest boundary) In my case shortest boundary option needed, I wander if someone knows how to realize this?
Hey there,I'm trying to write a v8 DesignFile with custom linestyles but I don't know which parameter to set for success.The line style is already copied into the referenced seedfile and I tried setting parameter igds_style to for example 'Line A' (which is name of the style), then I tried using DGNStyler transformer to set style, but non of that worked. According to documentation I'm not allowed to set the styles name with v8, I tried the internal style-ID but without success.Does the custom line styles have to be part of the attached resource-font-file or of the seedfile? And do I have to set igds_*-Parameters or use DGNStyler or is using both together breaking each other?(I'm using Desktop 2016.1 here)Thanks in advance,Maik
Hi I have two data sets:service stations, about 100 pointsroad networkI would like to create polygons for the service area for each point, much like image #3 here, https://www.zimmi.cz/posts/2017/routing-with-grass-gis-catchment-area-calculation/, but instead of dividing the network, I would like a polygon for each zone. I have been unable to find any FME examples for this task. Any recommendations on how to solve this? Regards, Magnus
I have an import from Revit to IFC and I can not find any property of the ifcSpace objects that show me which floor they are on.How to know to which level a ifcspace is?Thanks!!!
I am trying to transform a .ntx file into a custom coordinate system, when inspecting the data at the last step before the writer, coordinate system appears correctly. After exiting the writer and opening in Data Inspector, coordinate system appears as unknown.I have had success transforming shapefiles using the custom coordinate system so I do not believe it is the problem.I have also had success transforming the NTX file using built in coordinate systems.Any suggestions?
Hi,This issue have been revisited multiple times, and I've tried to browse these. But I can't seem to find out, whether the "FME_ENGINE_MEMORY_REDLINE" fix is only applicable to FME Server, or whether it (or something similar) also works with FME Desktop ?If it does work with desktop, where and how is it set ?Our FME license is running a small number of nightly jobs, but if I manually start an ad-hoc job before leaving for the day, having the job run all night, it hogs all resources, and all the nightly jobs fails. It would be beneficial to limit the ad-hoc job to use e.g. just half of the available memory.Cheers.
Hey everyone, I tried to find any suggestions how to deal with big Datasets. In Numbers: I have a Shape linedataset with 10 000 000 lines, the .shp has approx. 5gb the dbf file 7gb. Starting the reader took 3h+ then i stopped it manually. In Qgis it also takes some time, but lets say several minutes. Is there a more efficient format I should transform the Dataset before using FME?
Is there a way to prefix/concatenate the attribute name and a separator character to all of the values on that feature? For example, I have a feature with 60 attributes - can I retain the values of each cell, but have the attribute name appended to the values without having to manually create each attribute.Input:AttributeNameabcdefhijOutputAttributeNameAttributeName|abcAttributeName|defAttributeName|hij
Hey, I am very new to FME, I have a problem I thought I may can solve easy with FME, but I am stucked, so I hope someone can help me.I have a curb dataset and I need to cut it at every street intersection so that every street is feature. First I thought about calculating the angles between the lines with the Polyline Analyzer, so I have the Information where the line bends, and I can cut it at the node or delete all segements with those nodes. Unfortunately it only gives me the angles of segment nodes, not of all nodes. I tried to aggregate the Dataset, but then it would take hours, even for my test dataset with "only" 15000 nodes ( total dataset has app. 10 000 000 nodes). My second thought was to cut the lines at their max and min points wich should be possible to calculate somehow, but I did not find out how so far. Any suggestions?Another approach would be to sharpen the ends, so that they are no curves in the lines, then I guess it would be easier to cut the lines at the
When FME create an FFS for failed features is there a way to add the failure reason to the feature in the FFS?I was hoping for an easy way to have a table of features failed with teh fail reason that I can send to the vendorIn the logs I see this2017-11-16 11:09:13| 224.4| 1.7|ERROR |The invalid value ' . °' was supplied to the field 'lat_wgs84' for the table/feature class '####'but I don't see this information in the FFS or what feature this failure occurred on.Plus in the log file it often truncates repeated messages:2017-11-16 11:09:45| 239.1| 2.6|ERROR |... Last line repeated 2 times ...So then I don't have a complete list of failures from the log anyway.Currently these features are failing on the Geodatabase Writer. What I'm after is any failed feature in the workspace goes to FFS with the failed reason code (or a solution alike to this).