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],...]]]]
The following error occurred:
Connector reply error: grpc::StatusCode::INVALID_ARGUMENT: 'GEOOPS-401: The dataset Polygon does not contain any geometries.'
The error occurred here:
[WithinResultTable]:
Load *
Extension GeoOperations.ScriptEval('
SELECT
enclosed_enclosing_RelationId,
enclosed.bird_id,
enclosing.bird_id,
enclosing.TravelArea,
enclosed.locker_point2
FROM
Within()
DATASOURCE Data INTABLE keyField="bird_id", crs="auto", pointField="locker_point2"
DATASOURCE Polygon INTABLE keyField="bird_id", crs="auto", namedAreaField="TravelArea" ',
Data)
================Script below==============
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);
Thx,
Sorin
