asterix-app/src/test/resources/runtimets/queries/spatial/point-in-polygon.aql

drop dataverse test if exists;
create dataverse test;
use dataverse test;

create type MyRecord as open {
  id: int32,
  point: point,
  kwds: string
}

create external dataset MyData(MyRecord)
using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
(("path"="nc1://data/spatial/spatialData.json"),("format"="adm"));

write output to nc1:"rttest/spatial_point-in-polygon.adm";

for $o in dataset('MyData')
where spatial-intersect($o.point, $o.poly1)
order by $o.id
return {"id":$o.id}