FME Form

FME Desktop - How to Read Non-Spatial Oracle Update Trigger to Update a Spatial SQL Feature Class

hello everyone I got a 3d shapefile of buildings and I want to convert it to a citygml fine with LoD1 what is the workflow that I should do and here is my shapefile? thank you

I am currently working with about 60 towns (folders) on AGOL which all contain 10+ feature layers. The data is read from all these layer (reader per layer), compared with data in my db, then the data is updated/inserted/deleted in our db.  After this, let's say some work is done on the db data . I then have another workspace which is writing the updates back up to AGOL for the same town. I currently have 2 workspaces per town which take care of all the reading/writing/processing for all the layers. This has resulted in 120 workbenches which, when an update has to be made to the way data is processed, I have to go back and update all of those workspaces. Also more towns are being added every week so the number of workbenches is increasing.  The screenshot below is taken from one layer where data is read from both AGOL and the db, compared and then written out. I have a section like this for every layer where the processing is largely the

I would like to extract things like concrete driveways, road surfaces, any other hard surfaces, to calculate areas. The Rasters I have, are taken several years apart and would like to calculate the change in surface areas.

I'm trying to get the last 8 Job ID workspace details and I'm using an HTTP caller and string searcher. Can anyone tell me where I'm going wrong? Httpcaller Setting String Searcher

Hi All,I have a polygon that I want to split by a line feature. I'm rather surprised to find out that there don't seem to be any tools that do this, or at least, none I've found yet. There are a lot of questions about this, but no consistent answers, or simple way of doing it.Clipper - The Clipper feature needs to be an Area. Mine is a line.LineOnAreaOverlayer - splits the line, not the area. :-/Intersector - output is lines that don't reflect input areas nicely.So, have I missed something? Is there a transformer for doing this? This is GIS 101 level geometry handling, so I'd be surprised if there isn't, but where is it hiding?Thanks

Hi, I have a geodatabase with some feature classes. I would like to convert the attributes of each feature class into excel. How can I do that>

Hello. You don't know which transformer to use. I tried testfilter, but there you can't combine two lines and featuremerger, it's also not quite ideal. I need to filter data in a database with a condition:- all data with the same uuid- a point that has the same value of validfrom and validtovalidto changes to a value of -1 second downThe result should be validfrom 20220908000000 and validto 20221005235959 in the first lineIn the second line validfrom 20221006000000 and validto 99991231235959Thank you very much.

I have a pretty basic workbench with a HTTP Caller which processes the downloaded data to insert. When I open the Workbench it works perfectly. I preset all the input parameters so I do not need to pass them into the model. However when I try and run the workspace from command line, specifically in Jenkins, I use the following command:"C:\\Program Files\\FME\\fme.exe" "\\\\xxx\\xxxx\\MY_MODEL.fmw"  I get the following error: HTTPCaller_4_<Rejected>: Termination Message: 'HTTPCaller_4 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''Program Terminating Any idea what would cause the http caller to fail only when run from command line?  Any help would be greatly appreciated!

The workbench below is incomplete. It aims at checking schema of a requested GeoJON before writting data to GDB.I would like the writer to proceed only if 'Updated', 'Inserted' and 'Deteled' ports of ChangeDetector does not output anything. In other words, I would like the workbench to terminate before writing if those ports are not empty.How could I achieve that please ?

Is there a possibilty to directly read the "styling" properties of a DWG layer in FME? By styling properties I mean e.g. the color, linetype, and lineweight. I know that with the FeatureReader transformer, I can read the so-called "Schema Features". These Schema Features correspond to the layers in the DWG file (also see accepted solution at https://community.safe.com/s/question/0D5Dm000006a48rKAA/read-all-layer-names-from-dwg-files). Unfortunately, at least with standard reader options, these Schema Features do not have any styling properties associated with them: As a workaround, I could read the Data Features of the DWG file with e.g. a standard Rea

Hi;I have FME Desktop 2023.0 BETA (FME(R) 2023.0.0.0 (20230130 - Build 23226 - WIN64))The FME workbench consists of Sql reader, Geometry Replacer, and Dwg Writer.Sql reader reads a simple view from the database. Among others, the field 'autocad_entity' with the value 'autocad_insert' and the field 'autocad_block_name' with the value 'kc'. (I use those fields or fme attributes to create blocks through dwg writer). Reader reads everything correctly. After the reader comes the Geometry Replacer, which works correctly. However, after the Geometry Replacer, the 'autocad_entity' attribute has the value 'missing'. All other attributes are ok. Attributes are read from the database as varchar datatype.Thanks;

 I got the mean and standard deviation of all dataset ( mean: 0.12, sd: 2.84). And also, I got mean and standard deviation of ten sample (mean: 0.10, sd: 0.10)

Is going to be a FME Desktop 2023 version for Ubuntu 22.04? Thanks

I am trying to install the FME Desktop on my Ubuntu 20.04.1 laptop, but it doesn't work. Could you please help me to solve this problem? Thanks!

Hi,I have hourly rainfall data (observed and forecast) and i'd like to calculate a 7 day preceding rainfall total for EACH HOUR. My first thought is to use AttributeManager and adjacent features to sum the preceding 166 features (hourly rainfall totals), but it only allows up to 100 adjacent features. Any help would be greatly appreciated!Thanks.

Hi i would like to cut the data (polygone) outside the perimeter that could be line ot polygone, and keeping those inside.

Hi,  Doing an overlaps removal on polygons but I have multiple polygons that are identical shapes layered on top of each other. does anyone have any solutions for this as I cant seem to find a way to select and remove all but one of the stack, over the whole layer. unfortunately the polygons don't have any data to match them on so its all spatial. Thanks in advance.

Surface Model could not find 3 non NAN seed points I am trying to convert a .Tiff DEM to Minecraft format. Once it reaches the Surface Draper transformers the translation fails and I get the above error message.

Hello. Does anyone know how to use a transformer to change the time? I originally solved it by parsing the data via a string searcher, creating attributes and then compiling. This solution worked. It does not work for this date 20221201000000 (year, month, day, time 2022/12/01/000000 ), where I set the desired -1 second. I get 20221200999999 (2022/12/00/999999) in the output, but it should be 20221130235959 (2022/11/30/235959 ). I need a transformer that doesn't stupidly subtract -1 unit, but works with data like time. Thank you

Hi All,I need to identify exact attribute values changes when comparing two sets of data. The datasets have the same attributes but some attribute values are updated overtime and I need to identify which ones. I have been trying workflows with feature joiner and ChangeDetector, but I have to compare the datasets several times, discard attributes that remain the same until I identify which attribute value changed. I would like to find a more efficient way to identify the updates, any suggestion? Thank you

Hi everyone,  I am using FME 2013 for comparing geometry and attribute changes between two Shape files, one being more recent than the other. The two Shape files have exactly the same type of geometry and schema (same attributes names and definitions). They also have a lot of attributes (more than 50 I think). I have set up a logic for reporting significant differences in geometry as well as records having at least one attribute value not matching with the corresponding one in the other set. The attribute matching part can be achieved rather easily with a ChangeDetector, Matcher or CRCCalculator. These transformers will report features containing at least one attribute change among those that have been selected in the transformer properties. Given the great number of attributes I would like to to identify which specific attribute(s) has(have) indeed been modified between the two sets. I don't see an option using the standard transformers mentioned above. I did

In a FME workspace I have a SQLExecutor-transformer, which uses different database connections. I use one PostGIS-database per year called db2020, db2021, db2022, db2023.When the user needs data e.g. for 2021 a sting is generated, which contains the name of the database, in this case "db2021". This string is called "connection" and is referenced with @Value(connection) in the connection field of the SQLExecutor-transformer. This works locally in FME desktop. Alle connections are present both on FME desktop and on FME server. When I try to upload the workspace to FME server I get a error message saying "@Value(connection) is either missing or unsupported by this version of FME Server." Any suggestions or workarounds would be appreciated.

Hi pls help me with this. I just want to know which direction building is facing. I have thousands of building and i want that at once all buildings front direction should come out. The data i have are building foot print(.shp), 3d model (citygml) and road center line(.shp)

I have an attribute that contains location information (text-based) but it will say something like “Lake View, Chicago, USA”. I want to create a column that just tells me “USA”. Note, the data isn’t regular, sometimes there are many locality details, sometimes just a country, and sometimes no country. How do I just pull out the countries?