Greetings all,

I've been working on developing a new JDBC DataStore for HP Vertica
databases. Thus far, I seem to be successful in getting a new connection
and ability to import data, but now I've been trying to work on getting the
database's custom commands used by GeoServer. I'm a bit ignorant in how
this works.

Currently, I have a custom FilterToSQL class, VerticaFilterToSQL, which
interprets an "Intersects" filter to write out an ST_Intersects command, in
accordance with the database's specifications. This part makes sense, as it
is a binary spatial operator comparing two geometries.

However, I am attempting to write a custom function called STV_Intersects
<https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AnalyzingData/Geospatial/GeospatialAnalytics/STV_IntersectScalarFunctionVs.TransformFunction.htm>
(documentation linked - there's actually two versions but my question is
general for both). This function does not simply compare two geometries,
but actually looks at the entire table for intersecting polygons.

The best I have come up with thus far is that perhaps I need to write a
custom visitor, as it does not fall under visitBinarySpatialOperator.

Would anyone have any suggestions or pointers in the right direction for me
regarding how to write a custom function like this?

Cheers,
Travis

-- 
Travis Brundage
Software Engineer | Boundless
[email protected]
250.888.2820
@boundlessgeo
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to