Tygron Query Language: Difference between revisions
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.