Tygron Query Language: Difference between revisions

From Tygron Preview Support Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 14: Line 14:
! As a polygon
! As a polygon
! As an item
! As an item
! Type
|-
|-
| AREA
| AREA
| The requested data must intersect with this [[area]].
| The requested data must intersect with this [[area]].
| It must be data of this area specifically.
| It must be data of this area specifically.
| ID indicating a specific area.
|-
|-
| NEIGHBORHOOD
| NEIGHBORHOOD
| The requested data must intersect with this [[neighborhood]].
| The requested data must intersect with this [[neighborhood]].
| It must be data of this neighborhood specifically.
| It must be data of this neighborhood specifically.
| ID indicating a specific neighborhood.
|-
|-
| ZONE
| ZONE
| The requested data must intersect with this [[zone]].
| The requested data must intersect with this [[zone]].
| It must be data of this zone specifically.
| It must be data of this zone specifically.
| ID indicating a specific zone.
|-
|-
| TERRAIN
| TERRAIN
| The requested data must intersect with this [[terrain]] type.
| The requested data must intersect with this [[terrain]] type.
| It must be data of this type of terrain. There are no specific "instances" of terrain.
| It must be data of this type of terrain. There are no specific "instances" of terrain.
| ID indicating a type of terrain.
|}
|}


Line 38: Line 43:
! As a polygon
! As a polygon
! As an item
! As an item
! Type
|-
|-
| AREA_WITH_ATTRIBUTE
| AREA_WITH_ATTRIBUTE
| The requested data must intersect with at least one [[area]] with this attribute.
| The requested data must intersect with at least one [[area]] with this attribute.
| N/A
| N/A
| Attribute name of one or more areas.
|-
|-
| NEIGHBORHOOD_WITH_ATTRIBUTE
| NEIGHBORHOOD_WITH_ATTRIBUTE
| The requested data must intersect with at least one [[neighborhood]] with this attribute.
| The requested data must intersect with at least one [[neighborhood]] with this attribute.
| N/A
| N/A
| Attribute name of one or more neighborhoods.
|-
|-
| ZONE_WITH_ATTRIBUTE
| ZONE_WITH_ATTRIBUTE
| The requested data must intersect with at least one [[zone]] with this attribute.
| The requested data must intersect with at least one [[zone]] with this attribute.
| N/A
| N/A
| Attribute name of one or more zones.
|-
|-
| TERRAIN_WITH_ATTRIBUTE
| TERRAIN_WITH_ATTRIBUTE
| The requested data must intersect with [[terrain]] with this attribute.
| The requested data must intersect with [[terrain]] with this attribute.
| N/A
| N/A
| Attribute name of one or more terrains.
|}
|}


Line 62: Line 72:
! As a polygon
! As a polygon
! As an item
! As an item
! Type
|-
|-
| MAXGRIDVALUE
| MAXGRIDVALUE
| It must have at least this value on a [[grid overlay]].
| It must have at least this value on a [[grid overlay]].
| N/A
| N/A
| Decimal number.
|-
|-
| MINGRIDVALUE
| MINGRIDVALUE
| It must have at most this value on a grid overlay.
| It must have at most this value on a grid overlay.
| N/A
| N/A
| Decimal number.
|-
|-
| GRID
| GRID
| It must fall within this grid.
| It must fall within this grid.
| It must be data of this grid overlay specifically.
| It must be data of this grid overlay specifically.
| ID indicating a specific zone.
|-
|-
| GRIDTYPE
| GRIDTYPE
| It must fall within this type of grid. (If multiple grids of the same type exist this behavior is uncertain.)
| It must fall within this type of grid. (If multiple grids of the same type exist this behavior is uncertain.)
| It must be data of this type of grid, not a specific "instance" of this 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.
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.

Revision as of 13:52, 26 July 2017

This article is a stub.

Queries

Clauses

The following groups of clauses exist:

Specific polygons

Clause As a polygon As an item Type
AREA The requested data must intersect with this area. It must be data of this area specifically. ID indicating a specific area.
NEIGHBORHOOD The requested data must intersect with this neighborhood. It must be data of this neighborhood specifically. ID indicating a specific neighborhood.
ZONE The requested data must intersect with this zone. It must be data of this zone specifically. ID indicating a specific zone.
TERRAIN The requested data 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 The requested data must intersect with at least one area with this attribute. N/A Attribute name of one or more areas.
NEIGHBORHOOD_WITH_ATTRIBUTE The requested data must intersect with at least one neighborhood with this attribute. N/A Attribute name of one or more neighborhoods.
ZONE_WITH_ATTRIBUTE The requested data must intersect with at least one zone with this attribute. N/A Attribute name of one or more zones.
TERRAIN_WITH_ATTRIBUTE The requested data 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 have at least this value on a grid overlay. N/A Decimal number.
MINGRIDVALUE It must have 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. (If multiple grids of the same type exist this behavior is uncertain.) 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.