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: https://issues

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 ST_

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: https://grokbase.com/t/cayenn

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 p

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 Cay

Cayenne geospacial features

2019-01-20 Thread Nikita Timofeev
Hi All, I had an interesting discussion with my colleagues who use PostGIS and they are really interested in better support from Cayenne. Well, actually they can’t use Cayenne on that project, as it will be like using just raw SQL. So I was wondering if anyone else actively uses spacial features