2014-08-22

Calculate Time Difference between Two Features

Another solution for this question.
Community: Calculate the time difference between two features in a non-spatial dataset










Table columns definition in the InlineQuerier:












SQL query statement is:
-----
select a.SiteName, a.SampleDateTime,
case
    when b._count is null then null
    else round((a._epochtime - b._epochtime)/3600.0, 1)
end as TimeSinceLast
from Source as a left outer join Source as b
    on b.SiteName = a.SiteName and b._count = a._count - 1
-----

Result:














btw, why there is not datetime type for setting input table columns in the InlineQuerier?
FME 2014 SP3 build 14389
=====
Dale@Safe replied to my question. See his comment. Thanks, Dale!

2014-08-21

Take a look at FME 2015 beta

I tried FME 2015 beta build 15158.

Don and Dale introduced this new feature at the UC. That was very impressive.
I like this :-)





And, welcome the grid coming back with further enhancements!












Of course there are many enhancements and improvements internally.
I look forward to the release.

2014-08-09

Split Solid or Complex Surface into Individual Faces

The GeometryCoercer (Geometry Type: fme_composite_surface) and the Deaggregator (Split Composites: Yes) can split a single Solid or a complex Surface (e.g. TIN surface) into individual Faces.
Community > Trying to extract faces from a solid

2014-08-03

Custom Transformers for FME Store

still busy...

I uploaded these custom transformers to the FME Store (Category: Pragmatica).
-----
DateTimeCaluculator
JpStdGridAccumulator
ListMerger
ListSampler
ListSlicer
ListStatisticsCalculator
RadiateLineGenerator
RegxAttributeSplitter
-----

Please evaluate them ;)