Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);
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