How to match GeoPoints to areas that load with KML file

[shiryaev]

Could you help me to find the solution for the issue to fit set of geo points with another set of areas. So i have a clients data with geo coordinates and i have an area created from kml file but there is no any keys that could link this two sets of data, do you know any solution how to link them?

I'v find one way to match it using  java solution posted here

https://github.com/wuzhong-zhu/GeoCodeMerger---A-java-base-heat-map-polygon-map-helper

But this is a bit complicated to fit new points that adding every day.  May be there is some  Qlik ETL based solution.

Or it could be some new feature for the next version of QS.

[Michael_Tarallo]

@Patric_Nordstrom - can you assist Shiryaev?

[Patric_Nordstrom]

Check out the The GeoAnalytics operation "Within"

Doc:

https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoConnector/Content/connector/connector-geoanal...

Example:

https://help.qlik.com/en-US/geoanalytics/Content/Qlik_GeoAnalytics/GeoAnalytics-Connector/GeoAnalyti...

Thanks,

Patric

[morenoju]

Hi @Patric_Nordstrom ,

Is this "within" operation something to use in the load script? Or is it possible to find the points within an area "on the fly"?

I'm asking because I'd like to know the best approach to the problem of having areas (polygons) that change often, and millions of points that can't be processed every time these polygons change.

When I refer to "on the fly" I mean geonalaytics finding the points within a polygon once the user has selected an area. Without having to process all points to map in the data script.

Very curious about how to address this case.

Thanks much!

[morenoju]

Adding some more information to this:

If we configured this two layers on a map:

- One layer with the million of point locations (lat, long)

- One layer with the areas from the KML

If there was no table relating the points to the areas, would there still be a way to allow users to select an area and get the points layer automatically filtered on the fly, showing only those points within the area selected? 

[Patric_Nordstrom]

Currently "Within" is only supported in load time, also in GeoOperations.

https://help.qlik.com/en-US/geoanalytics/Content/Qlik_GeoAnalytics/GeoOperationsFunctions/GeoOperati...

Could be good to file it as an idea in:

https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Patric

[morenoju]

Thank you, Patric.

I've posted the idea here:

https://community.qlik.com/t5/Ideas/Point-filtering-by-area-quot-on-the-fly-quot/idi-p/1699480

Thanks,

Juan