Re: [geomesa-users] Queries on multiple features

[Emilio Lahr-Vivaz <elahrvivaz@xxxxxxxx>]

I don't believe that there is a CQL method to join two schemas. As you mentioned, a spark join would probably be the best approach. Another option would be to do a two-part query, first against natural objects and then building up a filter against POI using the returned geometries. If you're using geoserver, you might look into 'application schema' and complex features, which let you merge two schemas into a single 'view' (it might be overly complex and also pretty slow though):

http://docs.geoserver.org/stable/en/user/data/app-schema/complex-features.html

Thanks,

Emilio

On 12/05/2016 07:02 AM, Andrey Morskoy wrote:

I have a common case, as it seems, but not sure, if I understand how to handle it correctly. 

First of all, I have 2 feature types stored in geomesa.example Accumulo catalog:

* Natural objects (polygons + suppose attribute "type"=water/forest)

* POI (points + suppose attribute "name")

What is the correct way to query "Give me list of POI within 1km to Natural objects of type=water"

It looks like a Spark RDD join - but in fact I am searching for native CQL query in this case.

Thanks

_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://www.locationtech.org/mailman/listinfo/geomesa-users