wellknownarea

This is used to give names to locations where only a latitude and longitude are known. Areas must currently be circular, and the definitions are only approximate. Where two areas overlap, if a point is in both areas, then it will be ascribed the name of the smaller area, or if the areas are the same, the one whose centre is closest.

Syntax:

[ DynamicComponentDependency ] wellknownarea WellKnownAreaName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) A unique id for an area

Optional columns

Column Name Data Type Description Default Value
latitude Double The latitude of the centre point of a circular area
longitude Double The longitude of the centre point of a circular area
name String(256) The name of the area.
radius_km Double The approximate radius (in kilometres) of the circular area 


            wellknownarea WellKnownArea {{SelectName}} {
               SELECT
                     ..                  id,
                  -- optional columns
                     ..                  latitude,
                     ..                  longitude,
                     ..                  name_,
                     ..                  radius_km
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling WellKnownArea.

WellKnownAreaName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.