Using transformers to modify data.
Recently active
Hi, Im struggling a bit with finding nearby points to another point layer. I want the Neighborhoodfinder to find the two closest points within a distance. The output file only includes the nearest point even though I have set the neighbors to find parameter = 2. I want the output file to include the two closest points and their distance. Any suggestions?Thanks in advance!
I have a shapefile with numerous columns that I need to calculate a mean for on a row by row basis. Within the data there are a lot of values equal to 0 that are skewing the mean - how can I set up a calculation in the ExpressionEvaluator to remove the 0's from my calculation?
Hello everyone! I struggle with understanding how ArcByCentrepoint (and Circle) are implemented in AIXM 5.1/GML. I ingest exactly the same dataset in FME and QGIS. However, in FME everything looks correct whereas QGIS butchers the geometry. I tried this with class C airspaces around Munich and other airspaces. The system behavior is the same regardless of the airspace. These discrepancies are not just ugly, but they also lead to partially invalid geometries. I have attached example screenshots.In FME In QGISI believe that these discrepancies may occur due to each application utilizing a slightly different projection, e.g. UTM, AZMED, AZMEA, and other local coordinate reference systems are probably just part of a longer list. With each projection, the displayed geometries are slightly differently skewed in terms of distances and angles. So far, I have selected Lambert Azimuthal Equidistant Projection for my calculations/constructions, which originate at the circle’s midpoint. In my unde
Hello,I have a workbench that uses a tester to copy files into a folder and zip them based on the create date. This works fine however after I have the files in the new zip file I can't seem to figure out a good way to then use a FTP caller to upload the files since you can't do anything after you have used the filewriter. Looking for ideas of how to upload this zip file to an FTP in the same workbench?
I have tried using the combination of this transformers to discard or filter out compoundCurve geometry but the issue still persist I would like to find a way to discard these geometry ("CompoundCurve".) to avoid the WB stops when I am inserting data to postgis table. GeometryFilterGeometryValidatorArcStrokcerGeometryRefiner
I am trying to write a bunch of shape files to a geopackage but am getting a strange error. 'OGCGEOPACKAGE writer: sqlite3_exec(CREATE TABLE "table_name" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL' There seems to be a problem when the writer constructs the primary keys for the database, but I have no idea how to address this. There is no id attribute in the source data, I actually tried adding one and the writer handled this by changing the name of the primary key to id_0. Still got the same error though. I am using fme_feature_type to set the table names and schemas.
Has anyone got a method to rebuild a flattened json file using the dot notation? Essentially it would be the JSONAttributePacker but with a iterative approach?
I have upgrade from FME 2016 to FME 2021.2.When I am running the FME script, if I don't give source dataset in SCHEMA READER then I am facing "No Schema Dataset found" issue. But the same script runs fine on FME 2016. I think FME 2021.2 is not accepting empty string (i.e. no dataset) as input.Is there anything I can do to fix this issue ?
I have many vue 3D model, how to convert them to fbx, so i can use it to many applications.
I have a shapefile with 1000 polygon data and shapefile includes 50000 unique lines. I want to connect both lines that are inside the polygon. I used the spacialfilter but it couldn't detect properly endpoint of the lines which are inside of the polygon
Having issues with info being extracted into the CLOSED 45 DAY attribute-that is created with the ATTRIBUTE CREATOR. Thanks for all recommendations.
I need to create an RDF Turtle (ttl) file to CSV convertor for asset data structures. There seems no RDF reader in FME available. What would be the best approach to read RDF Turtle files into FME for further processing ?
Hi. I know it is a basic ask why FME Data Inspector is not opening. But, I have check for visual preview window, task manager for any FME Data Inspector open items, installed a fresh version of Desktop(2022.2.3) and also tried restating the machine. The last window displays 'initializing user interface', and nothing pops-up.Can someone suggest a quick solution to this?Thanks.
I would like to extract 'Orientation' >> Plz any idea what setting i use so that i could see those value in table in filter the data according.
HelloI want to transform with fme a shape file containing the sewer pipes into a file that can be integrated into the EPA SWMM application with .inp format (text file). Do you know any fmv schematics? THANKS
I have a situation where .dgn linework is being drawn with a custom line style (a treeline). I need to test whether the arcs of the treeline intersect with building edge linework. But when I load the .dgn into FME, the custom linestyle is not represented. It is still present, and (with the correct seed file and rsc and other tricks) I can write it out, but I need to work with the custom parts within FME. Is there any way to do that? A similar option to expanding cells, but for lines? Or some other approach that would work?
I am trying to convert an IFC TO CESIUM TILES 3D with FME 2022. The projection EPSG:3857I tried an d follow the explation here:https://community.safe.com/s/question/0D54Q00009TdMzbSAF/cannot-convert-ifc-file-to-3d-tiles But i got this has an error: The below feature caused the translation to be terminated GeometryPropertyExtractor_<Rejected> (TeeFactory): GeometryPropertyExtractor_<Rejected>: Termination Message: 'GeometryPropertyExtractor output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' I also tried to convert directly an i got this:CESIUM3DTILES writer: Unable to reproject the 'EPSG:3857' coordinate system REALLY NEED HELP PLEASE!
I have a csv to filter various activity codes. What would be the best way to go through this
Hi FME Community,I have an error when trying to replace some geometry from GML encoded geometry with the GeometryReplacer transformer :xml-donut Geometry Builder: unable to adopt the below geometry because construction for its own geometry has already been finalized+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `'Attribute(string: UTF-8): `fme_geometry' has value `fme_polygon'Attribute(string: UTF-8): `fme_type' has value `fme_area'Coordinate System: `'Geometry Type: IFMEPolygonName(UTF-16LE): `surfaceMembers'Boundary: Geometry Type: IFMELine Number of Coordinates: 5 -- Coordinate Dimension: 2 (1.2582468599656544,45.82094218175942)(1.2582468599656544,45.82094217549903)(1.2582638025631208,45.82094217549903)(1.2582638025631208,45.82094218175942)(1.2582468599656544,45.82094218175942)The cause seems to be multi-polygon geometries. However, the GML syntax seems correct (I can visualize it with Data Inspector tool) :<?xml version="1.0" encod
HelloSince I have been using FME Server 2022 my workbenchs updated from FME Desktop 2020 with Emailers no longer work. Indeed the workflow is in failure and what seems strange to me is that the workflow is looping (4 times) before being in failure. As soon as I delete the emailer transformer I have no more problems. Has anyone experienced this problem before?Thank you in advance and have a nice day, Emailer documentation http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/emailer-pkg.htm
How do I stop it changing the entries in those fields so I can create points in the correct location please?
I used Excel to convert from date and time to seconds using the formula datetime * 86400. For example, 24/04/2023 8:00 AM is converted to 3891484800. What would be the correct format to perform this calculation in my workspace? Thanks for the assistance.
FME Desktop 2021Data Source is in LL-27 I get a lines dataset in LL-27 and points dataset in LL-27. My objective is to shows these lines and points on a Map that is in Web Mercator, EPSG:3857. I currently use the CsmapReprojector and I have the following configuration: Source Coordinate System: LL-27Destination Coordinate System: EPSG: 3857Transformation: NAD27_to_WGS84 (Multistep) When I write the output for the lines and points to a Shapefile and place them in a Map in Web Mercator, the lines and points align and connect as expected, however, the problem is that their map positioning is slightly off from the actual Lat Long values that they should fall on. Is there another 'Transformation' I should be using to get them properly positioned on the map (map in Web Mercator)? Thanks for your time. Much appreciated.
Hi all, Im trying to automate a process done in mapinfo and requires a table update. The update in question-Hope this make sense with the censoring however this shouldn't effect the process. Ive tried a few different ways but i never get the outcome Im looking for. Thanks.
Hello i am reading many tables from oracle non spatial tables name Table_ATable_B Table_Ci have around 30 table and I would like to get the Output from all tables when Id= 45 i am not sure ,how to write the condition in where clause to test it in all tables and In case it did not find the id in any table so I will not get any output from this table .But in case also ,no id as attribute name in any table so I get nothing better than error ,if it is possible .Fme 2021