17 votes
Accepted

Filtering layers in QGIS atlas

You can use the tbl_metadata file as coverage layer in Atlas. Then use rule-based symbology with @layer_name = @atlas_pagename. I assume that your data looks like this (the attribute table is ...
Oto Kaláb's user avatar
  • 6,885
12 votes
Accepted

Spherical Mercator - World bounds

The bounds for EPSG 3857 are: xmin: -PI * 6378137, ymin: -PI * 6378137, xmax: PI * 6378137, ymax: PI * 6378137 which result in the following bounds: xmin: -20037508.3427892, ymin: -20037508....
Ralph Tee's user avatar
  • 1,702
11 votes
Accepted

Creating "oblique bounding box" with maximum width/height ratio?

This is probably overkill on the processing front and there is likely to be a better mathematical solution, but as an example of a way that it could be done rather simply as a query SELECT id, ...
MickyT's user avatar
  • 3,430
10 votes

In FME, is there a way to connect multiple input feature types from reader and route to single transformer?

I just came across this old question and wanted to update it with a new answer. My previous answer still stands (and is still useful in some cases), but a quicker way now (FME2016+) is to select all ...
Mark Ireland's user avatar
  • 13.1k
9 votes

Fast Select by location in FME?

Sounds like you're using a Reader followed by a SpatialFilter in FME. In that workflow we do have to read everything. Suggest instead you use a FeatureReader transformer to read the big feature ...
Dale Lutz's user avatar
  • 847
8 votes
Accepted

FME process first 100 features

In your Navigator Window where your Reader is shown scroll down to Parameters your will find Features to Read. Set Max Features to Read to 100.
Mapperz's user avatar
  • 49.7k
8 votes
Accepted

Drop decimal and decimal places without rounding in FME

Using your Example you can use the Attribute Rounder This example reads value from a field DP and takes the decimal out. Note there is an option in the Attribute Rounder to go to the nearest value ...
Mapperz's user avatar
  • 49.7k
8 votes
Accepted

How to automate writer output directory and filename in FME Desktop?

OK, this is quite simple - less than five minutes, which I know because I created a movie demonstrating it: https://www.screencast.com/t/zdnVYkVGnJEv To give the steps in more detail here... 1) The ...
Mark Ireland's user avatar
  • 13.1k
8 votes
Accepted

Controlling processing order in FME workspace?

Yes this is possible. You should chain the process instead of starting each subprocess with its own Creator. Use a FeatureWriter to write the results instead of a classic Writer. Because then you can ...
nielsgerrits's user avatar
  • 3,894
7 votes

How to transpose and summarise attributes in FME?

This was an interesting one and it isn't as straightforward as I had thought it would be. I created a CSV file that is identical to your screenshot. I created a new FME workbench with a CSV reader. ...
Fezter's user avatar
  • 21.8k
7 votes
Accepted

FME Use Output of reader in another reader

The FeatureReader transformer will do what you want. It behaves like a normal reader, but you can pass in other features/attributes which can go into your where clause. I suggest you get the ...
Fezter's user avatar
  • 21.8k
7 votes
Accepted

FME Desktop - Combining two weighted fields into one

In FME that process you are speaking of is actually easier to imagine in the sense of a conditional value rather than a weighted value. The easiest way to accomplish this is through the attribute ...
John's user avatar
  • 607
6 votes
Accepted

Conditional styling in FME ChartGenerator

Have you tried setting/creating an 'fme_color' attribute and setting the 'color scheme' option to use it as highlighted below? The following is taken from the offline ChartGenerator help files for ...
James's user avatar
  • 76
6 votes
Accepted

Reprojecting raster with FME?

Agree to the comment of @FelixIP, one possible solution is to first create a whole raster using RasterMosaicker transformer, then reproject and re-tile the Raster with RasterTiler transformer. This ...
Jochen Schwarze's user avatar
6 votes
Accepted

Using timestamp in text format published parameter of FME?

A TimeStamper will create an attribute with yyyymmdd. Next you can fanout on both filename and sheetname:
nielsgerrits's user avatar
  • 3,894
6 votes
Accepted

Batch Clipping of shapefiles in FME

Yep, you can do a dynamic reader and writer and clip them all at once, for sure. First, with your reader, make sure you use 'single merged feature type'. For your writer, make it 'dynamic' so that ...
Alex Leith's user avatar
  • 13.4k
6 votes

How to extract a small area from a big GTFS feed?

This should be possible in FME 2016. Because we can not write aggregates to GTFS a setting in the Clipper is needed "Create Aggregates" = "No" to prevent FME from creating aggregates when clipped ...
Ken Bragg's user avatar
  • 419
6 votes

How to convert CSV file with coordinates to rectangles (geometry) in FME

OK, I'm assuming your source CSV is a format like: x1,y1,x2,y2 0,0,10,10 15,15,20,25 So, here you'll use the CSV reader to read the data. The parameters dialog allows you to pick a column to use ...
Mark Ireland's user avatar
  • 13.1k
6 votes

Drop decimal and decimal places without rounding in FME

Should be fairly easy. My first thought is to treat it as a string and use a StringReplacer transformer. Set Mode to "Replace Regular Expression" and set Text to Replace to \..*$ ie remove content ...
Mark Ireland's user avatar
  • 13.1k
6 votes
Accepted

How do I stop FME from using the first row as the column name when reading XLS?

You will need to play with the Parameters of the XLS reader you can idicate that on the Field Names Row settings , if you set this attribute to 0 i suppose you will get what you looking for .
Jorge Vidinha's user avatar
6 votes
Accepted

How to delete a single Feature Class from a geodatabase using FME

Initially, I hadn't read the question properly, and answered with a python solution. However, I see now that you can't use python, so I have a different solution for you. It requires that you use the ...
Fezter's user avatar
  • 21.8k
6 votes

Creating "oblique bounding box" with maximum width/height ratio?

QGIS has a "minimum oriented bounding box" algorithm which does exactly this.
ndawson's user avatar
  • 27.6k
6 votes

How to create autoincrementing primary key with dynamic writer in FME

No experience with MSSQL but for PostgreSQL it works by selecting the datatype serial and the index PrimaryKey. See screenshot. I suspect the datatype should be identity with index PrimaryKey. See ...
nielsgerrits's user avatar
  • 3,894
6 votes
Accepted

Howto do not re-run already executed transformers in FME?

You can achieve it with FME 2018 version making use of run with feature cache. Enable feature cache and you will access to run from this , run to this and run just this. see pictures attached. Be ...
Jorge Vidinha's user avatar
6 votes

Determining if polygon not enclosed by other polygons

Assuming your polygons are topologically correct (no gaps, or overlaps), then a polygon A is enclosed by other polygons if its perimeter is equal to the sum of intersection length between its ...
dbaston's user avatar
  • 13k
6 votes
Accepted

Create geometry from WKT in FME

The GeometryReplacer transformer will do this for you. Set the geometry encoding parameter to: OGC Well Known Text (wkt) From the documentation: The OGC variants are useful if interaction with ...
nielsgerrits's user avatar
  • 3,894
6 votes
Accepted

Matching feature by ID from CSV

Several solutions possible. One is: Read the csv with the id's Then read the database with a FeatureReader. Fill the Where Clause to only read the matching features. (Otherwise you need to read ...
nielsgerrits's user avatar
  • 3,894
6 votes
Accepted

Getting FME to write features in order provided?

Use the Sorter transformer before the writer. It will output features in sorted order against the selected attribute(s).
JimT's user avatar
  • 2,373
6 votes
Accepted

FME dynamic filename

In the Navigator panel, find the Writer you want to change and edit the parameter "Destination Text File". Then you can edit the filename based on attribute value. Even better, stop using ...
nielsgerrits's user avatar
  • 3,894
6 votes

FME dynamic filename

As noted in the other answer, you can do this with a FeatureWriter transformer. But as an fyi, if you do want to do this in a standard writer, you would use the Fanout option. As you noted, you can't ...
Mark Ireland's user avatar
  • 13.1k

Only top scored, non community-wiki answers of a minimum length are eligible