Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Geo function usage is not consistent with geo index Legacy mode #19100

Open
thomashassan35 opened this issue May 25, 2023 · 2 comments
Open

Geo function usage is not consistent with geo index Legacy mode #19100

thomashassan35 opened this issue May 25, 2023 · 2 comments
Labels
1 Question 3 AQL Query language related 3 Geo Waiting User Reply

Comments

@thomashassan35
Copy link

thomashassan35 commented May 25, 2023 •
edited by Simran-B
Loading

My Environment

  • ArangoDB Version: 3.10.5
  • Deployment Mode: Single Server
  • Deployment Strategy: ArangoDB Starter in Docker
  • Configuration: base configuration
  • Infrastructure: Local
  • Operating System: Windows 10 - WSL
  • Total RAM in your machine: 16Gb
  • Disks in use: SSD
  • Used Package: Docker

Component, Query & Data

Affected feature:
AQL query - GEO functions

AQL query (if applicable):

 FOR alias_arbre IN avatar
  FILTER alias_arbre.iri == "http://www.example.com/rennes/polygon/tree_17683" 
 
 FOR a IN avatar FILTER GEO_DISTANCE(alias_arbre.cG9z_geom_point,a.cG9seWdvbg_geom_polygon)<1000
 FILTER a.domain == "http://www.example.com/rennes/polygon/" 
 
 FILTER a.cG9seWdvbg_geom_polygon != null  
 
 RETURN  [GEO_DISTANCE(alias_arbre.cG9z_geom_point,a.cG9seWdvbg_geom_polygon),a]

AQL explain and/or profile (if applicable):

Query String (394 chars, cacheable: true):
  FOR alias_arbre IN avatar  FILTER alias_arbre.iri == 
 "http://www.example.com/rennes/polygon/tree_17683" 
  
  FOR a IN avatar FILTER GEO_DISTANCE(alias_arbre.cG9z_geom_point,a.cG9seWdvbg_geom_polygon)<1000 
 FILTER a.domain == "http://www.example.com/rennes/polygon/" 
  
  FILTER a.cG9seWdvbg_geom_polygon != null  
  
  RETURN  [GEO_DISTANCE(alias_arbre.cG9z_geom_point,a.cG9seWdvbg_geom_polygon),a]

Execution plan:
 Id   NodeType          Est.   Comment
  1   SingletonNode        1   * ROOT
 15   IndexNode            1     - FOR alias_arbre IN avatar   /* persistent index scan, index scan + document lookup (projections: `cG9z_geom_point`) */    
 14   IndexNode           25       - FOR a IN avatar   /* geo index scan, index scan + document lookup */    FILTER (a.`domain` == "http://www.example.com/rennes/polygon/")   /* early pruning */   
 12   CalculationNode     25         - LET #10 = [ GEO_DISTANCE(alias_arbre.`cG9z_geom_point`, a.`cG9seWdvbg_geom_polygon`), a ]   /* simple expression */   /* collections used: alias_arbre : avatar, a : avatar */
 13   ReturnNode          25         - RETURN #10

Indexes used:
 By   Name                            Type         Collection   Unique   Sparse   Cache   Selectivity   Fields                          Stored values   Ranges
 15   avatar_iri_index                persistent   avatar       false    false    false       99.69 %   [ `iri` ]                       [  ]            (alias_arbre.`iri` == "http://www.example.com/rennes/polygon/tree_17683")
 14   cG9seWdvbg_geom_polygon_index   geo          avatar       false    true     false           n/a   [ `cG9seWdvbg_geom_polygon` ]   [  ]            (GEO_DISTANCE(alias_arbre.`cG9z_geom_point`, a.`cG9seWdvbg_geom_polygon`) < 1000)

Functions used:
 Name           Deterministic   Cacheable   Uses V8
 GEO_DISTANCE   true            true        false  

Optimization rules applied:
 Id   RuleName
  1   move-calculations-up
  2   move-filters-up
  3   move-calculations-up-2
  4   move-filters-up-2
  5   geo-index-optimizer
  6   use-indexes
  7   remove-filter-covered-by-index
  8   remove-unnecessary-calculations-2
  9   move-filters-into-enumerate
 10   reduce-extraction-to-projection

43 rule(s) executed, 1 plan(s) created, peak mem [b]: 0, exec time [s]: 0.00055
Dataset: 
[
{
    "_key": "e51e49d6-8428-50e9-885f-eb92af1f70cd",
    "_id": "avatar/e51e49d6-8428-50e9-885f-eb92af1f70cd",
    "_rev": "_gCzCVoK---",
    "owner": "admin",
    "iri": "http://www.example.com/rennes/polygon/nsq_100",
    "last_updated": 1684923506561,
    "static": false,
    "visibility": 255,
    "cG9z_geom_point": {
      "type": "Point",
      "coordinates": [
        -1.6591001232727307,
        48.127740725148556
      ]
    },
    "classes": [
      "http://www.livewiredg.myby.co.uk/rdf/geo-layers/context/road.owl#A-Road"
    ],
    "http://www.opengis.net/gml/pos": "{\"type\": \"Point\", \"coordinates\": [-1.6591001232727307, 48.127740725148556] }",
    "source": "91dbe7e5-0565-41a6-8cb7-bff33ee62801",
    "creationDate": 1684923506561,
    "uuid": "e51e49d6-8428-50e9-885f-eb92af1f70cd",
    "http://schema.org/name": "Maurepas",
    "http://www.opengis.net/gml/pos/polygon": "{\"type\": \"Polygon\", \"coordinates\": [[[-1.656487992167294,48.13228564984487],[-1.655901160911369,48.1322975763691],[-1.655612888937673,48.132302576144056],[-1.655584431115057,48.13230306743954],[-1.655357382707621,48.13230698711024],[-1.655127593947627,48.132310953255654],[-1.65499901227696,48.13231277776495],[-1.654747020393441,48.13231635224493],[-1.654426369120708,48.13232156900213],[-1.65419958658813,48.132325257570436],[-1.654109402207202,48.13232674392193],[-1.653941279727201,48.13232943449821],[-1.65387727831915,48.13233045874264],[-1.653500991673835,48.13233712184984],[-1.653413258045143,48.13233844003047],[-1.653047456530393,48.13234393502008],[-1.652616882892012,48.132349028359876],[-1.652302857190617,48.13235274216895],[-1.65219737923772,48.13235398955246],[-1.652040525743177,48.13235623240531],[-1.652031440693677,48.13225556481871],[-1.652034260416904,48.13216749095112],[-1.652022332290554,48.131820785234126],[-1.652019885153629,48.131749640686564],[-1.652007394195009,48.13138655404583],[-1.652054051445725,48.13046577362013],[-1.652092371922883,48.129524027409715],[-1.652102766658808,48.12930531970807],[-1.652100157967832,48.12889063266031],[-1.652095363477787,48.12873527958165],[-1.652069981500506,48.12860174468913],[-1.65206042373263,48.12839676863186],[-1.652058456227546,48.12817208139792],[-1.652060028127017,48.12793463805806],[-1.652059855610809,48.12776653192743],[-1.65202089797711,48.12740080223082],[-1.652391770715659,48.127249050381685],[-1.654696634272774,48.1260090248277],[-1.655087299012127,48.12579245875014],[-1.655394521369016,48.12563107940283],[-1.655647497903013,48.12551136122741],[-1.655806451418253,48.12543842893578],[-1.656693906766353,48.12507487688939],[-1.657030318635844,48.1249178974965],[-1.657633969403017,48.12462637985442],[-1.657955645370152,48.12447170627534],[-1.658048094958785,48.12442543212431],[-1.658131132607848,48.12438521575367],[-1.658842441535739,48.12404013307053],[-1.658946378793119,48.12397951648469],[-1.659618005711701,48.123524574953535],[-1.659982415743143,48.12326958784834],[-1.661257972186606,48.12251498002277],[-1.661748991191531,48.122273236754076],[-1.662340402271697,48.12198984709796],[-1.662658362221943,48.1218375623597],[-1.662726277900814,48.121787953636],[-1.663565799868884,48.122370060093],[-1.664074060043935,48.12271771328413],[-1.664577881405443,48.12307572652729],[-1.664955694444373,48.12333504648533],[-1.66557988111916,48.123779721622306],[-1.665847664151516,48.123968371801986],[-1.667114260895566,48.12486064739777],[-1.666746433089863,48.125150487607954],[-1.666112000217933,48.125595132876676],[-1.665953376112146,48.12576375953953],[-1.665759177365523,48.126021142110744],[-1.66543761547919,48.1265234634689],[-1.665011518274481,48.12719140382446],[-1.664864651282578,48.12742758194089],[-1.664237345613475,48.12842088419879],[-1.664195345969566,48.12848095720348],[-1.664145490363711,48.12855226601302],[-1.663893075771877,48.12886495510921],[-1.663697574382537,48.12910713640272],[-1.663634964332569,48.12919468919059],[-1.663416568371625,48.129504492881765],[-1.663304493984375,48.129663474005646],[-1.663128369425709,48.12995840770492],[-1.662916866567808,48.13031258094507],[-1.662816636621425,48.13048041897027],[-1.662744968433463,48.13059293545416],[-1.662729342652277,48.130623870622436],[-1.662574755760847,48.130929906083615],[-1.662565117301547,48.13094898656353],[-1.662403814783091,48.13119700073891],[-1.662299931100461,48.13135672802866],[-1.662095168000935,48.13167155967703],[-1.661862289432283,48.132029614274714],[-1.661731468743644,48.132025892845384],[-1.661680327104876,48.13202658590377],[-1.661457163836315,48.13202961143851],[-1.660364385655543,48.13204441915916],[-1.659280893849587,48.132059090834304],[-1.659138569209064,48.132061521709225],[-1.659120804209621,48.13206183308013],[-1.658624796656237,48.13207052648565],[-1.657945449122931,48.13208235924262],[-1.657677067552307,48.13208755898108],[-1.657305456681358,48.13209475711723],[-1.656800952340713,48.13210879112275],[-1.656753344167392,48.1321299424808],[-1.656683510614108,48.132212812111526],[-1.656676195587089,48.132220984368395],[-1.656647573838568,48.132253200624504],[-1.656615460679217,48.132273111929024],[-1.656600109655024,48.13227642481689],[-1.656555340071562,48.132288547029454],[-1.656487992167294,48.13228564984487]]] }",
    "domain": "http://www.example.com/rennes/polygon/",
    "cG9seWdvbg_geom_polygon": {
      "type": "Polygon",
      "coordinates": [
        [
          [
            -1.656487992167294,
            48.13228564984487
          ],
          [
            -1.655901160911369,
            48.1322975763691
          ],
          [
            -1.655612888937673,
            48.132302576144056
          ],
          [
            -1.655584431115057,
            48.13230306743954
          ],
          [
            -1.655357382707621,
            48.13230698711024
          ],
          [
            -1.655127593947627,
            48.132310953255654
          ],
          [
            -1.65499901227696,
            48.13231277776495
          ],
          [
            -1.654747020393441,
            48.13231635224493
          ],
          [
            -1.654426369120708,
            48.13232156900213
          ],
          [
            -1.65419958658813,
            48.132325257570436
          ],
          [
            -1.654109402207202,
            48.13232674392193
          ],
          [
            -1.653941279727201,
            48.13232943449821
          ],
          [
            -1.65387727831915,
            48.13233045874264
          ],
          [
            -1.653500991673835,
            48.13233712184984
          ],
          [
            -1.653413258045143,
            48.13233844003047
          ],
          [
            -1.653047456530393,
            48.13234393502008
          ],
          [
            -1.652616882892012,
            48.132349028359876
          ],
          [
            -1.652302857190617,
            48.13235274216895
          ],
          [
            -1.65219737923772,
            48.13235398955246
          ],
          [
            -1.652040525743177,
            48.13235623240531
          ],
          [
            -1.652031440693677,
            48.13225556481871
          ],
          [
            -1.652034260416904,
            48.13216749095112
          ],
          [
            -1.652022332290554,
            48.131820785234126
          ],
          [
            -1.652019885153629,
            48.131749640686564
          ],
          [
            -1.652007394195009,
            48.13138655404583
          ],
          [
            -1.652054051445725,
            48.13046577362013
          ],
          [
            -1.652092371922883,
            48.129524027409715
          ],
          [
            -1.652102766658808,
            48.12930531970807
          ],
          [
            -1.652100157967832,
            48.12889063266031
          ],
          [
            -1.652095363477787,
            48.12873527958165
          ],
          [
            -1.652069981500506,
            48.12860174468913
          ],
          [
            -1.65206042373263,
            48.12839676863186
          ],
          [
            -1.652058456227546,
            48.12817208139792
          ],
          [
            -1.652060028127017,
            48.12793463805806
          ],
          [
            -1.652059855610809,
            48.12776653192743
          ],
          [
            -1.65202089797711,
            48.12740080223082
          ],
          [
            -1.652391770715659,
            48.127249050381685
          ],
          [
            -1.654696634272774,
            48.1260090248277
          ],
          [
            -1.655087299012127,
            48.12579245875014
          ],
          [
            -1.655394521369016,
            48.12563107940283
          ],
          [
            -1.655647497903013,
            48.12551136122741
          ],
          [
            -1.655806451418253,
            48.12543842893578
          ],
          [
            -1.656693906766353,
            48.12507487688939
          ],
          [
            -1.657030318635844,
            48.1249178974965
          ],
          [
            -1.657633969403017,
            48.12462637985442
          ],
          [
            -1.657955645370152,
            48.12447170627534
          ],
          [
            -1.658048094958785,
            48.12442543212431
          ],
          [
            -1.658131132607848,
            48.12438521575367
          ],
          [
            -1.658842441535739,
            48.12404013307053
          ],
          [
            -1.658946378793119,
            48.12397951648469
          ],
          [
            -1.659618005711701,
            48.123524574953535
          ],
          [
            -1.659982415743143,
            48.12326958784834
          ],
          [
            -1.661257972186606,
            48.12251498002277
          ],
          [
            -1.661748991191531,
            48.122273236754076
          ],
          [
            -1.662340402271697,
            48.12198984709796
          ],
          [
            -1.662658362221943,
            48.1218375623597
          ],
          [
            -1.662726277900814,
            48.121787953636
          ],
          [
            -1.663565799868884,
            48.122370060093
          ],
          [
            -1.664074060043935,
            48.12271771328413
          ],
          [
            -1.664577881405443,
            48.12307572652729
          ],
          [
            -1.664955694444373,
            48.12333504648533
          ],
          [
            -1.66557988111916,
            48.123779721622306
          ],
          [
            -1.665847664151516,
            48.123968371801986
          ],
          [
            -1.667114260895566,
            48.12486064739777
          ],
          [
            -1.666746433089863,
            48.125150487607954
          ],
          [
            -1.666112000217933,
            48.125595132876676
          ],
          [
            -1.665953376112146,
            48.12576375953953
          ],
          [
            -1.665759177365523,
            48.126021142110744
          ],
          [
            -1.66543761547919,
            48.1265234634689
          ],
          [
            -1.665011518274481,
            48.12719140382446
          ],
          [
            -1.664864651282578,
            48.12742758194089
          ],
          [
            -1.664237345613475,
            48.12842088419879
          ],
          [
            -1.664195345969566,
            48.12848095720348
          ],
          [
            -1.664145490363711,
            48.12855226601302
          ],
          [
            -1.663893075771877,
            48.12886495510921
          ],
          [
            -1.663697574382537,
            48.12910713640272
          ],
          [
            -1.663634964332569,
            48.12919468919059
          ],
          [
            -1.663416568371625,
            48.129504492881765
          ],
          [
            -1.663304493984375,
            48.129663474005646
          ],
          [
            -1.663128369425709,
            48.12995840770492
          ],
          [
            -1.662916866567808,
            48.13031258094507
          ],
          [
            -1.662816636621425,
            48.13048041897027
          ],
          [
            -1.662744968433463,
            48.13059293545416
          ],
          [
            -1.662729342652277,
            48.130623870622436
          ],
          [
            -1.662574755760847,
            48.130929906083615
          ],
          [
            -1.662565117301547,
            48.13094898656353
          ],
          [
            -1.662403814783091,
            48.13119700073891
          ],
          [
            -1.662299931100461,
            48.13135672802866
          ],
          [
            -1.662095168000935,
            48.13167155967703
          ],
          [
            -1.661862289432283,
            48.132029614274714
          ],
          [
            -1.661731468743644,
            48.132025892845384
          ],
          [
            -1.661680327104876,
            48.13202658590377
          ],
          [
            -1.661457163836315,
            48.13202961143851
          ],
          [
            -1.660364385655543,
            48.13204441915916
          ],
          [
            -1.659280893849587,
            48.132059090834304
          ],
          [
            -1.659138569209064,
            48.132061521709225
          ],
          [
            -1.659120804209621,
            48.13206183308013
          ],
          [
            -1.658624796656237,
            48.13207052648565
          ],
          [
            -1.657945449122931,
            48.13208235924262
          ],
          [
            -1.657677067552307,
            48.13208755898108
          ],
          [
            -1.657305456681358,
            48.13209475711723
          ],
          [
            -1.656800952340713,
            48.13210879112275
          ],
          [
            -1.656753344167392,
            48.1321299424808
          ],
          [
            -1.656683510614108,
            48.132212812111526
          ],
          [
            -1.656676195587089,
            48.132220984368395
          ],
          [
            -1.656647573838568,
            48.132253200624504
          ],
          [
            -1.656615460679217,
            48.132273111929024
          ],
          [
            -1.656600109655024,
            48.13227642481689
          ],
          [
            -1.656555340071562,
            48.132288547029454
          ],
          [
            -1.656487992167294,
            48.13228564984487
          ]
        ]
      ]
    }
  },
  {
    "_key": "22c5c850-8983-51df-8aa3-069fed5b2364",
    "_id": "avatar/22c5c850-8983-51df-8aa3-069fed5b2364",
    "_rev": "_gCzCVpC---",
    "owner": "admin",
    "iri": "http://www.example.com/rennes/polygon/tree_17683",
    "last_updated": 1684923506561,
    "static": false,
    "visibility": 255,
    "cG9z_geom_point": {
      "type": "Point",
      "coordinates": [
        -1.65726142149323,
        48.12712758509411
      ]
    },
    "classes": [
      "http://www.livewiredg.myby.co.uk/rdf/geo-layers/context/road.owl#A-Road"
    ],
    "http://www.opengis.net/gml/pos": "{\"type\": \"Point\", \"coordinates\": [-1.65726142149323, 48.12712758509411 ]}",
    "source": "91dbe7e5-0565-41a6-8cb7-bff33ee62801",
    "creationDate": 1684923506561,
    "uuid": "22c5c850-8983-51df-8aa3-069fed5b2364",
    "domain": "http://www.example.com/rennes/polygon/"
  }
]

Size of your Dataset on disk:
N/A

Steps to reproduce

  1. create appropriate collection 'avatar' with geo indexes in legacy mode in fields cG9seWdvbg_geom_polygon and cG9z_geom_point
  2. put the 2 documents above in the 'avatar' collection
  3. run the above query

Problem & Expected result:
This test case is using old polygons which do not comply with the new GeoJson standard. We activate the legacy mode on the geo indexes to get the same behaviour as previous versions of arangoDB (3.9 and below).

The returned resultset should contain the objects with a polygon property in a 1km radius.
The query does make use of the geo index, and returns the expected object, however, the GEO_DISTANCE expression is not consistent when evaluated outside of the use of the geo index. Here the resulting GEO_DISTANCE value is 20014934.236066904, as in the resultset below. This value doesn't make sense as the query should then have filtered it out (GEO_DISTANCE > 1000).

Assumption: the legacy mode is taken into account by the index but not in any other geo function evaluation.

Result: 
[
  [
    20014934.236066904,
    {
      "_key": "e51e49d6-8428-50e9-885f-eb92af1f70cd",
      "_id": "avatar/e51e49d6-8428-50e9-885f-eb92af1f70cd",
      "_rev": "_gCzCVoK---",
      "owner": "admin",
      "iri": "http://www.example.com/rennes/polygon/nsq_100",
      "last_updated": 1684923506561,
      "static": false,
      "visibility": 255,
      "cG9z_geom_point": {
        "type": "Point",
        "coordinates": [
          -1.6591001232727307,
          48.127740725148556
        ]
      },
      "classes": [
        "http://www.livewiredg.myby.co.uk/rdf/geo-layers/context/road.owl#A-Road"
      ],
      "http://www.opengis.net/gml/pos": "{\"type\": \"Point\", \"coordinates\": [-1.6591001232727307, 48.127740725148556] }",
      "source": "91dbe7e5-0565-41a6-8cb7-bff33ee62801",
      "creationDate": 1684923506561,
      "uuid": "e51e49d6-8428-50e9-885f-eb92af1f70cd",
      "equivalent_classes": [
        "http://www.livewiredg.myby.co.uk/rdf/geo-layers/context/road.owl#A-Road"
      ],
      "specs": {
        "http://schema.org/name": "string",
        "http://www.opengis.net/gml/pos/polygon": "string",
        "http://www.opengis.net/gml/pos": "string"
      },
      "http://schema.org/name": "Maurepas",
      "http://www.opengis.net/gml/pos/polygon": "{\"type\": \"Polygon\", \"coordinates\": [[[-1.656487992167294,48.13228564984487],[-1.655901160911369,48.1322975763691],[-1.655612888937673,48.132302576144056],[-1.655584431115057,48.13230306743954],[-1.655357382707621,48.13230698711024],[-1.655127593947627,48.132310953255654],[-1.65499901227696,48.13231277776495],[-1.654747020393441,48.13231635224493],[-1.654426369120708,48.13232156900213],[-1.65419958658813,48.132325257570436],[-1.654109402207202,48.13232674392193],[-1.653941279727201,48.13232943449821],[-1.65387727831915,48.13233045874264],[-1.653500991673835,48.13233712184984],[-1.653413258045143,48.13233844003047],[-1.653047456530393,48.13234393502008],[-1.652616882892012,48.132349028359876],[-1.652302857190617,48.13235274216895],[-1.65219737923772,48.13235398955246],[-1.652040525743177,48.13235623240531],[-1.652031440693677,48.13225556481871],[-1.652034260416904,48.13216749095112],[-1.652022332290554,48.131820785234126],[-1.652019885153629,48.131749640686564],[-1.652007394195009,48.13138655404583],[-1.652054051445725,48.13046577362013],[-1.652092371922883,48.129524027409715],[-1.652102766658808,48.12930531970807],[-1.652100157967832,48.12889063266031],[-1.652095363477787,48.12873527958165],[-1.652069981500506,48.12860174468913],[-1.65206042373263,48.12839676863186],[-1.652058456227546,48.12817208139792],[-1.652060028127017,48.12793463805806],[-1.652059855610809,48.12776653192743],[-1.65202089797711,48.12740080223082],[-1.652391770715659,48.127249050381685],[-1.654696634272774,48.1260090248277],[-1.655087299012127,48.12579245875014],[-1.655394521369016,48.12563107940283],[-1.655647497903013,48.12551136122741],[-1.655806451418253,48.12543842893578],[-1.656693906766353,48.12507487688939],[-1.657030318635844,48.1249178974965],[-1.657633969403017,48.12462637985442],[-1.657955645370152,48.12447170627534],[-1.658048094958785,48.12442543212431],[-1.658131132607848,48.12438521575367],[-1.658842441535739,48.12404013307053],[-1.658946378793119,48.12397951648469],[-1.659618005711701,48.123524574953535],[-1.659982415743143,48.12326958784834],[-1.661257972186606,48.12251498002277],[-1.661748991191531,48.122273236754076],[-1.662340402271697,48.12198984709796],[-1.662658362221943,48.1218375623597],[-1.662726277900814,48.121787953636],[-1.663565799868884,48.122370060093],[-1.664074060043935,48.12271771328413],[-1.664577881405443,48.12307572652729],[-1.664955694444373,48.12333504648533],[-1.66557988111916,48.123779721622306],[-1.665847664151516,48.123968371801986],[-1.667114260895566,48.12486064739777],[-1.666746433089863,48.125150487607954],[-1.666112000217933,48.125595132876676],[-1.665953376112146,48.12576375953953],[-1.665759177365523,48.126021142110744],[-1.66543761547919,48.1265234634689],[-1.665011518274481,48.12719140382446],[-1.664864651282578,48.12742758194089],[-1.664237345613475,48.12842088419879],[-1.664195345969566,48.12848095720348],[-1.664145490363711,48.12855226601302],[-1.663893075771877,48.12886495510921],[-1.663697574382537,48.12910713640272],[-1.663634964332569,48.12919468919059],[-1.663416568371625,48.129504492881765],[-1.663304493984375,48.129663474005646],[-1.663128369425709,48.12995840770492],[-1.662916866567808,48.13031258094507],[-1.662816636621425,48.13048041897027],[-1.662744968433463,48.13059293545416],[-1.662729342652277,48.130623870622436],[-1.662574755760847,48.130929906083615],[-1.662565117301547,48.13094898656353],[-1.662403814783091,48.13119700073891],[-1.662299931100461,48.13135672802866],[-1.662095168000935,48.13167155967703],[-1.661862289432283,48.132029614274714],[-1.661731468743644,48.132025892845384],[-1.661680327104876,48.13202658590377],[-1.661457163836315,48.13202961143851],[-1.660364385655543,48.13204441915916],[-1.659280893849587,48.132059090834304],[-1.659138569209064,48.132061521709225],[-1.659120804209621,48.13206183308013],[-1.658624796656237,48.13207052648565],[-1.657945449122931,48.13208235924262],[-1.657677067552307,48.13208755898108],[-1.657305456681358,48.13209475711723],[-1.656800952340713,48.13210879112275],[-1.656753344167392,48.1321299424808],[-1.656683510614108,48.132212812111526],[-1.656676195587089,48.132220984368395],[-1.656647573838568,48.132253200624504],[-1.656615460679217,48.132273111929024],[-1.656600109655024,48.13227642481689],[-1.656555340071562,48.132288547029454],[-1.656487992167294,48.13228564984487]]] }",
      "domain": "http://www.example.com/rennes/polygon/",
      "inherited_classes": [
        "http://www.livewiredg.myby.co.uk/rdf/geo-layers/context/road.owl#A-Road",
        "http://www.livewiredg.myby.co.uk/rdf/geo-layers/context/road.owl#Highway"
      ],
      "cG9seWdvbg_geom_polygon": {
        "type": "Polygon",
        "coordinates": [
          [
            [
              -1.656487992167294,
              48.13228564984487
            ],
            [
              -1.655901160911369,
              48.1322975763691
            ],
            [
              -1.655612888937673,
              48.132302576144056
            ],
            [
              -1.655584431115057,
              48.13230306743954
            ],
            [
              -1.655357382707621,
              48.13230698711024
            ],
            [
              -1.655127593947627,
              48.132310953255654
            ],
            [
              -1.65499901227696,
              48.13231277776495
            ],
            [
              -1.654747020393441,
              48.13231635224493
            ],
            [
              -1.654426369120708,
              48.13232156900213
            ],
            [
              -1.65419958658813,
              48.132325257570436
            ],
            [
              -1.654109402207202,
              48.13232674392193
            ],
            [
              -1.653941279727201,
              48.13232943449821
            ],
            [
              -1.65387727831915,
              48.13233045874264
            ],
            [
              -1.653500991673835,
              48.13233712184984
            ],
            [
              -1.653413258045143,
              48.13233844003047
            ],
            [
              -1.653047456530393,
              48.13234393502008
            ],
            [
              -1.652616882892012,
              48.132349028359876
            ],
            [
              -1.652302857190617,
              48.13235274216895
            ],
            [
              -1.65219737923772,
              48.13235398955246
            ],
            [
              -1.652040525743177,
              48.13235623240531
            ],
            [
              -1.652031440693677,
              48.13225556481871
            ],
            [
              -1.652034260416904,
              48.13216749095112
            ],
            [
              -1.652022332290554,
              48.131820785234126
            ],
            [
              -1.652019885153629,
              48.131749640686564
            ],
            [
              -1.652007394195009,
              48.13138655404583
            ],
            [
              -1.652054051445725,
              48.13046577362013
            ],
            [
              -1.652092371922883,
              48.129524027409715
            ],
            [
              -1.652102766658808,
              48.12930531970807
            ],
            [
              -1.652100157967832,
              48.12889063266031
            ],
            [
              -1.652095363477787,
              48.12873527958165
            ],
            [
              -1.652069981500506,
              48.12860174468913
            ],
            [
              -1.65206042373263,
              48.12839676863186
            ],
            [
              -1.652058456227546,
              48.12817208139792
            ],
            [
              -1.652060028127017,
              48.12793463805806
            ],
            [
              -1.652059855610809,
              48.12776653192743
            ],
            [
              -1.65202089797711,
              48.12740080223082
            ],
            [
              -1.652391770715659,
              48.127249050381685
            ],
            [
              -1.654696634272774,
              48.1260090248277
            ],
            [
              -1.655087299012127,
              48.12579245875014
            ],
            [
              -1.655394521369016,
              48.12563107940283
            ],
            [
              -1.655647497903013,
              48.12551136122741
            ],
            [
              -1.655806451418253,
              48.12543842893578
            ],
            [
              -1.656693906766353,
              48.12507487688939
            ],
            [
              -1.657030318635844,
              48.1249178974965
            ],
            [
              -1.657633969403017,
              48.12462637985442
            ],
            [
              -1.657955645370152,
              48.12447170627534
            ],
            [
              -1.658048094958785,
              48.12442543212431
            ],
            [
              -1.658131132607848,
              48.12438521575367
            ],
            [
              -1.658842441535739,
              48.12404013307053
            ],
            [
              -1.658946378793119,
              48.12397951648469
            ],
            [
              -1.659618005711701,
              48.123524574953535
            ],
            [
              -1.659982415743143,
              48.12326958784834
            ],
            [
              -1.661257972186606,
              48.12251498002277
            ],
            [
              -1.661748991191531,
              48.122273236754076
            ],
            [
              -1.662340402271697,
              48.12198984709796
            ],
            [
              -1.662658362221943,
              48.1218375623597
            ],
            [
              -1.662726277900814,
              48.121787953636
            ],
            [
              -1.663565799868884,
              48.122370060093
            ],
            [
              -1.664074060043935,
              48.12271771328413
            ],
            [
              -1.664577881405443,
              48.12307572652729
            ],
            [
              -1.664955694444373,
              48.12333504648533
            ],
            [
              -1.66557988111916,
              48.123779721622306
            ],
            [
              -1.665847664151516,
              48.123968371801986
            ],
            [
              -1.667114260895566,
              48.12486064739777
            ],
            [
              -1.666746433089863,
              48.125150487607954
            ],
            [
              -1.666112000217933,
              48.125595132876676
            ],
            [
              -1.665953376112146,
              48.12576375953953
            ],
            [
              -1.665759177365523,
              48.126021142110744
            ],
            [
              -1.66543761547919,
              48.1265234634689
            ],
            [
              -1.665011518274481,
              48.12719140382446
            ],
            [
              -1.664864651282578,
              48.12742758194089
            ],
            [
              -1.664237345613475,
              48.12842088419879
            ],
            [
              -1.664195345969566,
              48.12848095720348
            ],
            [
              -1.664145490363711,
              48.12855226601302
            ],
            [
              -1.663893075771877,
              48.12886495510921
            ],
            [
              -1.663697574382537,
              48.12910713640272
            ],
            [
              -1.663634964332569,
              48.12919468919059
            ],
            [
              -1.663416568371625,
              48.129504492881765
            ],
            [
              -1.663304493984375,
              48.129663474005646
            ],
            [
              -1.663128369425709,
              48.12995840770492
            ],
            [
              -1.662916866567808,
              48.13031258094507
            ],
            [
              -1.662816636621425,
              48.13048041897027
            ],
            [
              -1.662744968433463,
              48.13059293545416
            ],
            [
              -1.662729342652277,
              48.130623870622436
            ],
            [
              -1.662574755760847,
              48.130929906083615
            ],
            [
              -1.662565117301547,
              48.13094898656353
            ],
            [
              -1.662403814783091,
              48.13119700073891
            ],
            [
              -1.662299931100461,
              48.13135672802866
            ],
            [
              -1.662095168000935,
              48.13167155967703
            ],
            [
              -1.661862289432283,
              48.132029614274714
            ],
            [
              -1.661731468743644,
              48.132025892845384
            ],
            [
              -1.661680327104876,
              48.13202658590377
            ],
            [
              -1.661457163836315,
              48.13202961143851
            ],
            [
              -1.660364385655543,
              48.13204441915916
            ],
            [
              -1.659280893849587,
              48.132059090834304
            ],
            [
              -1.659138569209064,
              48.132061521709225
            ],
            [
              -1.659120804209621,
              48.13206183308013
            ],
            [
              -1.658624796656237,
              48.13207052648565
            ],
            [
              -1.657945449122931,
              48.13208235924262
            ],
            [
              -1.657677067552307,
              48.13208755898108
            ],
            [
              -1.657305456681358,
              48.13209475711723
            ],
            [
              -1.656800952340713,
              48.13210879112275
            ],
            [
              -1.656753344167392,
              48.1321299424808
            ],
            [
              -1.656683510614108,
              48.132212812111526
            ],
            [
              -1.656676195587089,
              48.132220984368395
            ],
            [
              -1.656647573838568,
              48.132253200624504
            ],
            [
              -1.656615460679217,
              48.132273111929024
            ],
            [
              -1.656600109655024,
              48.13227642481689
            ],
            [
              -1.656555340071562,
              48.132288547029454
            ],
            [
              -1.656487992167294,
              48.13228564984487
            ]
          ]
        ]
      }
    }
  ]
]
@MBkkt
Copy link
Contributor

MBkkt commented Jun 5, 2023

aql geo functions don't have legacy mode.
Legacy mode exists only for geo index and geojson analyzer

@thomashassan35
Copy link
Author

In the current state since using the same function twice in one query is not consistent, I would argue the legacy mode is too restrictive in its usage.
On our side we will just move on to the new version and ignore the legacy mode.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
1 Question 3 AQL Query language related 3 Geo Waiting User Reply
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@Simran-B @MBkkt @thomashassan35