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 ...
- 6,835
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....
- 1,682
11
votes
Accepted
When validating geometries, what are "Nested shells"?
A Nested Shell is a polygon on top of another polygon.
Image source
- 626
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, ...
- 3,410
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 ...
- 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 ...
- 847
8
votes
FME Timer function?
There is a Decelerator Transformer, but I'm unsure of the maximum amount of time you can pause a function--it is measured out in seconds.
If you are using the .bat code created in fme, you could ...
- 3,686
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.
- 49.6k
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 ...
- 49.6k
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 ...
- 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 ...
- 3,834
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. ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 14.6k
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:
- 3,834
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 .
- 1,507
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 ...
- 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.
- 27.4k
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 ...
- 3,834
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 ...
- 1,507
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 ...
- 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 ...
- 3,834
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 ...
- 3,834
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).
- 2,373
Only top scored, non community-wiki answers of a minimum length are eligible