Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Sezgi
Contributor
Contributor

TravelAreas calculation problem with drift of coordinate

Hi all,

We have an issue with travel area calculations in the Qlik geoanalytics function. At some coordinates, it calculates the travel area away from the coordinate.
Instead of finding the travel area where the coordinates are, it assigns them to the nearest highway and calculates the travel area based on the newly assigned point.

I also attach the screenshot below. 

[TravelAreas]:
SQL SELECT [Travel_Area] as GRID_NAME, [Dataset_TravelArea], [Dataset_Origin], [Dataset_Cost], [Dataset_CostUnit], [Dataset_Status] FROM TravelAreas(costValue='5', costField='', costUnit='Kilometers', transportation='pedestrian', dataset='Dataset')
DATASOURCE Dataset INLINE tableName='GeoData', tableFields='Travel_Area,Travel_Area_X,Travel_Area_Y', geometryType='POINTLATLON', loadDistinct='YES', suffix='TR', crs='Auto' {$(DatasetInlineTable)}
;

Is there a way to calculate travel area exactly on the coordinate? 

 

Thanks inadvance

Labels (3)
3 Replies
Patric_Nordstrom
Employee
Employee

If this is GeoOperations and the coordinates are specified by Travel_Area_X,Travel_Area_Y the code is not correct. Specify the lat long fields like this:

See this example:

MyCities: LOAD * inline "
cid;lat;long
1;57.7;12
2;45.42;-75.70
" (delimiter is ';');
Load * Extension GeoOperations.ScriptEval(' TravelAreas(costValue="10",costUnit="minutes")
DATASOURCE cities INTABLE keyField="cid", latitudeField="lat", longitudeField="long"', MyCities);

Sezgi
Contributor
Contributor
Author

Hi Patric,

Thank you for quick response. I think I couldn't explain the problem very clearly. As you may see in the attachment, There is a gap between the coordinate that we want to calculate walking distance and calculated travel area. Why geoanalytics move the coordinate to highway and calculate travel area away from the coordinate? This also happens in Googlemaps and openstreemap . I also add googlemaps screenshots for the example coordinate. When I check exact place of the coordinate it shows right. But when I plot the walking distance it round it the nearest road. 

Code:

MyCities:

LOAD * inline "

cid;lat;long

1;39.40137;30.83692

" (delimiter is ';');

Load * Extension GeoOperations.ScriptEval(' TravelAreas(costValue="5",costUnit="kilometers",transportation="Pedestrian")

DATASOURCE cities INTABLE keyField="cid", latitudeField="lat", longitudeField="long"', MyCities);

Sezgi_1-1694065740186.png

 

Sezgi_0-1694065729589.png

 

Patric_Nordstrom
Employee
Employee

The TravelArea is dependent on the underlying road network to calculate. A coordinate far from a road or on a highway won't render any useful result for pedestrian travelarea.

Thanks,

Patric