SpatiaLite Users

Hi, cf https://www.gaia-gis.it/gaia-sins/spatialite-sql-5.1.0.html#p16 : "if the optional

Hi Sandro, Thank you very much for your reply! Your suggestions are extremely valuable to us. I will

On Fri, 22 Aug 2025 19:06:42 +0100, ckgoo...@gmail.com wrote: > Hi Sandro, > I am not a

Hi Sandro Thanks for all your thoughts here. Using the third parameter set to 0 takes the runtime

Dear Alessandro, I sincerely apologize if my emails seemed aggressive with the excessive use of

Hi Bas, > The libxml2 maintainer suggests users who need this to implement > their own >

Hi Sandro, I don't know if you have time to look at this question;-) would be grateful for your

Hi Sandro, Gemini suggested a double spatial index query for my problem. INSERT INTO

Hi Herman, all software is an evolving thing that changes over time. A release is nothing more than a

On Wed, 19 Mar 2025 23:03:41 +0100, Tobias Schula wrote: > On Wednesday, 19 March 2025, 23:00:26

Dear Sandro, thanks for your quick response. I didn't want to create a writable view using only

Hi Sandro! Am 23.02.25 um 19:53 schrieb a.fu...@lqt.it: >> However, I now get this warning:

On Sun, 23 Feb 2025 18:01:31 +0100, Antonio Valanzano wrote: > However there is a lack of

To close out the item. Your solution, while a bit slower (0.1 sec), was far more precise and gives me

Sandro, thanks for adding some more specific information about the change of geometry type eventually

Hi List, I'm happy to announce a new open source initiative that may be of interest to some of

Hi Sandro, Thanks for your tip of expanding the SQL. It was really useful and let me see where I'

One last question worthy of some clarification. SpatiaLite entirely delegates all the functions of

Thanks for your professional answer. Wishing you a Merry Christmas too! 在2024年12月25日星期三 UTC+8 19:00:

Sorry, I ran this query correctly on spatialite. The incorrect result was caused by my improper

Sorry, I misread it 在2024年12月25日星期三 UTC+8 14:53:45<a.fu...@lqt.it> 写道： On Tue, 24 Dec 2024 18:

The problem is not only the multiple overlaps, where you could decide to eliminate those arcs which

Thank you. That is perfect. Best, Chris -----Original Message----- From: spatialite-users@

Hi Sandro, Thanks for your reply. You are right. What I wanted to do was simply too computationally

Thanks, that did the trick. I had previously been just using Polygon GEOMETRY In my CREATE TABLE

Thanks. That's also a section of the functions table I haven't explored before. Lots of new

> I imagine this is not a concern unique to spatialite, but it happens > to be the only

Hi, Thanks both of you for your answers. Apparently it does not create memory leak (the author of

Hi, Success! I just had to write "WHERE l.ROWID" to qualify it. The use of an attached

On Thu, 17 Oct 2024 07:25:18 +0100, ckgoo...@gmail.com wrote: > I wrote: > > There are