Tygron Query Language: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 55: Line 55:
| N/A
| N/A
|}
|}
===Grids===
{| class="wikitable"
|-
! Clause
! As a polygon
! As an item
|-
| GRID
| It must fall within this grid.
| It must be data of this [[grid overlay]] specifically.
|-
| GRIDTYPE
|
| It must be data of this type of grid, not a specific "instance" of this grid.
|-
| MAXGRIDVALUE
|
|
|-
| MINGRIDVALUE
|
|
|}
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, but a query of, for example, SELECT_LANDSIZE_WHERE_GRID_IS_2 is functionally the same as _SELECT_LANDSIZE.

Revision as of 12:58, 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
AREA The requested data must intersect with this area. It must be data of this area specifically.
NEIGHBORHOOD The requested data must intersect with this neighborhood. It must be data of this neighborhood specifically.
ZONE The requested data must intersect with this zone. It must be data of this zone specifically.
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.

Unspecific polygons

Clause As a polygon As an item
AREA_WITH_ATTRIBUTE The requested data must intersect with at least one area with this attribute. N/A
NEIGHBORHOOD_WITH_ATTRIBUTE The requested data must intersect with at least one neighborhood with this attribute. N/A
ZONE_WITH_ATTRIBUTE The requested data must intersect with at least one zone with this attribute. N/A
TERRAIN_WITH_ATTRIBUTE The requested data must intersect with terrain with this attribute. N/A

Grids

Clause As a polygon As an item
GRID It must fall within this grid. It must be data of this grid overlay specifically.
GRIDTYPE It must be data of this type of grid, not a specific "instance" of this grid.
MAXGRIDVALUE
MINGRIDVALUE

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, but a query of, for example, SELECT_LANDSIZE_WHERE_GRID_IS_2 is functionally the same as _SELECT_LANDSIZE.