Skip to main content

Example 2 - Geographic

This example demonstrates how to build the following query in the AQS Builder:

Fetch all bollards within this area, sorted by unit number

In full detail:

Fetch items of the Bollards design where their Geometry attribute is within a defined area, sorted by their Unit Number attribute in Ascending order

Configure the root node​

  1. Select the root node and set the following properties:

    • AQS Type - AQS Query
    • Design or interface - Bollards
    • Collection - Live
    • Sorting - Ascending
    • Sort attribute - Unit Number
    • Attributes - Title, Subtitle, Unit Number
alt text

Add a comparison node​

  1. Select and choose the Within node type from the list.
alt text
alt text
Note

The two other geographic comparison nodes are:

  • ​ Disjoint - is the first area completely outside the second area?
  • ​ Intersects - does the first area overlap the second area?

Fill the left segment​

  1. Select on the left and choose the Attribute node type from the list. The node will default to the first relevant attribute in the design/interface being queried. In this case, it's the standard Geometry attribute, which is what we want!
alt text
alt text

Fill the right segment​

  1. Select on the right, choose the GeoJson node type, and then No geometry.
alt text
alt text
  1. Select to open the Geometry Editor and use it to define an area. Alternatively, select Locations of interest to choose a predefined area. Select Save.
alt text
alt text

Finish​

  1. Select Done (bottom-left) to finish.
See JSON code

This code may reference designs, interfaces, attributes or items that don't exist in your Alloy database.

{
  "type": "Query",
  "properties": {
    "attributes": ["attributes_itemsTitle", "attributes_itemsSubtitle", "attributes_streetLightingUnitsUnitNumber"],
    "collectionCode": ["Live"],
    "dodiCode": "designs_bollards",
    "sortInfo": {
      "attributeCode": "attributes_streetLightingUnitsUnitNumber",
      "sortOrder": "Ascending"
    }
  },
  "children": [
    {
      "type": "GeomWithin",
      "children": [
        {
          "type": "Attribute",
          "properties": {
            "attributeCode": "attributes_itemsGeometry"
          }
        },
        {
          "type": "Geometry",
          "properties": {
            "value": {
              "type": "Polygon",
              "coordinates": [
                [
                  [-1.528451, 52.291276],
                  [-1.532371, 52.290544],
                  [-1.535095, 52.288647],
                  [-1.534088, 52.28752],
                  [-1.527428, 52.290062],
                  [-1.528451, 52.291276]
                ]
              ]
            }
          }
        }
      ]
    }
  ]
}