|
|
| Line 277: |
Line 277: |
| |} | | |} |
|
| |
|
| | | ===Terms=== |
| | | {| class="wikitable" |
| | |- |
| | ! Clause |
| | ! As a polygon |
| | ! As an item |
| | ! Type |
| | |- |
| | | STATE |
| | | N/A |
| | | It must be related to this specific text (or "term") used by the Engine. |
| | | Technical name indicating a term. |
| | |} |
|
| |
|
| ==Data manipulation clauses== | | ==Data manipulation clauses== |
Revision as of 12:40, 27 July 2017
Queries
Clauses
The following groups of clauses exist:
Specific polygons
| Clause
|
As a polygon
|
As an item
|
Type
|
| AREA
|
It must intersect with this area.
|
It must be data of this area specifically.
|
ID indicating a specific area.
|
| NEIGHBORHOOD
|
It must intersect with this neighborhood.
|
It must be data of this neighborhood specifically.
|
ID indicating a specific neighborhood.
|
| ZONE
|
It must intersect with this zone.
|
It must be data of this zone specifically.
|
ID indicating a specific zone.
|
| TERRAIN
|
It must intersect with this terrain type.
|
It must be data of this type of terrain. There are no specific "instances" of terrain.
|
ID indicating a type of terrain.
|
Unspecific polygons
| Clause
|
As a polygon
|
As an item
|
Type
|
| AREA_WITH_ATTRIBUTE
|
It must intersect with at least one area with this attribute.
|
N/A
|
Attribute name of one or more areas.
|
| NEIGHBORHOOD_WITH_ATTRIBUTE
|
It must intersect with at least one neighborhood with this attribute.
|
N/A
|
Attribute name of one or more neighborhoods.
|
| ZONE_WITH_ATTRIBUTE
|
It must intersect with at least one zone with this attribute.
|
N/A
|
Attribute name of one or more zones.
|
| TERRAIN_WITH_ATTRIBUTE
|
It must intersect with terrain with this attribute.
|
N/A
|
Attribute name of one or more terrains.
|
Grids
| Clause
|
As a polygon
|
As an item
|
Type
|
| MAXGRIDVALUE
|
It must intersect with at least this value on a grid overlay.
|
N/A
|
Decimal number.
|
| MINGRIDVALUE
|
It must intersect with at most this value on a grid overlay.
|
N/A
|
Decimal number.
|
| GRID
|
It must fall within this grid.
|
It must be data of this grid overlay specifically.
|
ID indicating a specific zone.
|
| GRIDTYPE
|
It must fall within this type of grid.
|
It must be data of this type of grid, not a specific "instance" of this grid.
|
Technical name indicating a type of grid overlay.
|
Note that each grid automatically covers the entire map, unless a minimum gridvalue or maximum gridvalue is defined. For queries such as GRIDAVG, this can be acceptable. However, for example, a query of SELECT_LANDSIZE_WHERE_GRID_IS_2 is functionally the same as SELECT_LANDSIZE.
Also note that when a GRIDTYPE is selected but multiple overlays of that type exist in the project, there are no guarantees on which overlay is used specifically.
Constructions
| Clause
|
As a polygon
|
As an item
|
Type
|
| BUILDING
|
It must intersect with this construction.
|
It must be data of this construction specifically.
|
ID indicating a specific construction.
|
| NET_LOAD
|
It must intersect with the building of this net load.
|
It must be data of this net load specifically.
|
ID indicating a specific net load.
|
| NET_CLUSTER
|
It must intersect with buildings of net loads of this net cluster.
|
It must be data of this net cluster specifically.
|
ID indicating a specific net cluster.
|
| FUNCTION
|
It must intersect with constructions of this function.
|
It must be data related to this function type.
|
ID indicating a specific function.
|
Dikes
| Clause
|
As a polygon
|
As an item
|
Type
|
| DIKE
|
It must intersect with this dike.
|
It must be data of this dike specifically.
|
ID indicating a specific dike.
|
Attributes
| Clause
|
As a polygon
|
As an item
|
Type
|
| ATTRIBUTE_MAX
|
It must intersect with at least this value of an attribute.
|
N/A
|
Decimal number.
|
| ATTRIBUTE_MIN
|
It must intersect with at most this value of an attribute.
|
N/A
|
Decimal number.
|
| ATTRIBUTE
|
The attribute of which to test the value.
|
N/A
|
Attribute name of any polygonal item.
|
When neither a maximum or minimum value is specified, or when no attribute is specified, everything is considered
Net line
| Clause
|
As a polygon
|
As an item
|
Type
|
| NET_LINE
|
N/A
|
It must be data of this net line specifically.
|
ID indicating a specific net line.
|
| NET_LINE_DEFINITION
|
N/A
|
It must be data of net lines of this definition.
|
ID indicating a line definition.
|
| NET_TYPE
|
N/A
|
It must be data of net lines of this type of network.
|
ID indicating the type of network.
|
Stakeholder
| Clause
|
As a polygon
|
As an item
|
Type
|
| STAKEHOLDER
|
The land must be owned by this specific stakeholder.
|
It must be data of this stakeholder specifically.
|
ID indicating a specific stakeholder.
|
| STAKEHOLDERTYPE
|
The land must be owned by this type of stakeholder.
|
N/A
|
Technical name indicating a type of stakeholder.
|
Interface
| Clause
|
As a polygon
|
As an item
|
Type
|
| INDICATOR
|
N/A
|
It must be data of this indicator specifically.
|
ID indicating a specific indicator.
|
| OVERLAY
|
N/A
|
It must be data of this overlay specifically.
|
ID indicating a specific overlay.
|
| PANEL
|
N/A
|
It must be data of this panel specifically.
|
ID indicating a specific panel.
|
Variables
| Clause
|
As a polygon
|
As an item
|
Type
|
| NAME
|
N/A
|
The data requested must have this name.
|
The name which identifies the requested data.
|
Building categories
| Clause
|
As a polygon
|
As an item
|
Type
|
| CATEGORY
|
It must intersect with constructions of this category.
|
It must be related to this specific category.
|
Technical name indicating a category.
|
Timestates
| Clause
|
As a polygon
|
As an item
|
Type
|
| STATE
|
It must intersect with buildings or other spatial actions, which are currently in this timestate.
|
It must be related to this specific timestate
|
Technical name indicating a timestate.
|
Terms
| Clause
|
As a polygon
|
As an item
|
Type
|
| STATE
|
N/A
|
It must be related to this specific text (or "term") used by the Engine.
|
Technical name indicating a term.
|
Data manipulation clauses
Map type
| Clause
|
As a polygon
|
As an item
|
Type
|
| MAP
|
It must be data from this moment of time in a session.
|
It must be data from this moment of time in a session.
|
Technical name of the original/current state or the planned/maquette state.
|
The precise terms vary based on the simulation type, but the terms which appear in the query are CURRENT and MAQUETTE.
Layer type
| Clause
|
As a polygon
|
As an item
|
Type
|
| LAYERTYPE
|
It must be data from this layer of the 3D world.
|
N/A
|
Technical name of the surface or underground layers of the 3D world.
|
The precise terms are SURFACE and UNDERGROUND.
Multipliers
| Clause
|
As a polygon
|
As an item
|
Type
|
| ATTRIBUTE_MULT
|
Multiply the result by the (spatial) value of an attribute.
|
N/A
|
Attribute name of any polygonal item.
|
| FUNCTIONMULT
|
Multiply the result by the (spatial) value of an attribute.
|
N/A
|
The name of a function value.
|
| CATEGORYMULT
|
Multiply the result by the (spatial) value of an attribute.
|
N/A
|
The name of a category value.
|
Relations
| Clause
|
As a polygon
|
As an item
|
Type
|
| RELATION
|
N/A
|
Rather than data of the specified item, use the item which has this relation to it.
|
Technical name indicating a type of relation.
|
