Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All, especialy @Patric_Nordstrom 🙂
In am getting the following error from the script below. In the DATA table the point is in this format [lon,lat] and in the Polygon Table the TravelArea is like this [[[[lon,lat],[lon,lat],...]]]]
Data:
LOAD
bird_id,
// "Delivery metode",
locker_point2
FROM [lib://GeoTables:DataFiles/withdelivery.xlsx]
(ooxml, embedded labels, table is Sheet1)
;
Join
Polygon:
LOAD
bird_id,
// locker_point2,
TravelArea
FROM [lib://GeoTables:DataFiles/travelarea.xlsx]
(ooxml, embedded labels, table is Sheet1);
[WithinResultTable]:
Load * Extension GeoOperations.ScriptEval('
SELECT
enclosed_enclosing_RelationId,
enclosed.bird_id,
enclosing.bird_id,
enclosing.TravelArea,
enclosed.locker_point2
FROM
Within()
DATASOURCE enclosed INTABLE keyField="bird_id", crs="auto", pointField="locker_point2"
DATASOURCE enclosing INTABLE keyField="bird_id", crs="auto", namedAreaField="TravelArea"
', Data);
nobody? 🙂 any feedback