Re: Cayenne geospacial features

2019-02-24 Thread Nikita Timofeev
Hi Andrus, > > 1. Custom functions (already on master - [1]) > 2. Joins that are not equi-joins (spatial joins [2] in our case - > ST_Intersects/ST_Contains/etc). > > @Nikita - anything else I might have missed? Essentially that's it for now. Here are links to related JIRA tasks:

Re: Cayenne geospacial features

2019-02-23 Thread Andrus Adamchik
Hi Tore, Thanks for sharing your solutions. > Next up is PostGIS queries. PostGIS queries are very powerful, but the syntax > can be quite strange. SQLTemplate or something similar should work fine. I > have some simple application specific java abstraction to the most common > stuff like

Re: Cayenne geospacial features

2019-02-23 Thread Mike Kienenberger
On Sat, Feb 23, 2019 at 4:40 AM Tore Halset wrote: > A long time ago, I wrote about this over at > http://objectstyle.org/confluence/display/CAY/Mapping+JTS+Geometries , > but that website does not exist anymore. > A google search turned out a mangled version here:

Re: Cayenne geospacial features

2019-02-23 Thread Tore Halset
Hello. With Cayenne, you can easily create a ExtendedType that convert JTS geometries on the java side to Well-Known Binary on the database side. I did create a similar ExtendedType to create JTS geometries to Well-Known Text for storing JTS geometries as text (se below). We have used this in

Re: Cayenne geospacial features

2019-01-22 Thread Andrus Adamchik
I recall Tore had a suite of GIS software written in Cayenne. But this was years ago. Andrus > On Jan 21, 2019, at 2:11 AM, Nikita Timofeev > wrote: > > Hi All, > > I had an interesting discussion with my colleagues who use PostGIS and > they are really interested in better support from