Groups
Groups
Sign in
Groups
Groups
SpatiaLite Users
Conversations
About
Send feedback
Help
SpatiaLite Users
1–30 of 2531
Mark all as read
Report group
0 selected
ckgoo...@gmail.com
,
a.fu...@lqt.it
10
Aug 22
Starting with topologies
On Fri, 22 Aug 2025 19:06:42 +0100, ckgoo...@gmail.com wrote: > Hi Sandro, > I am not a
unread,
Starting with topologies
On Fri, 22 Aug 2025 19:06:42 +0100, ckgoo...@gmail.com wrote: > Hi Sandro, > I am not a
Aug 22
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Aug 20
ST_Distance taking a long time
Hi Sandro Thanks for all your thoughts here. Using the third parameter set to 0 takes the runtime
unread,
ST_Distance taking a long time
Hi Sandro Thanks for all your thoughts here. Using the third parameter set to 0 takes the runtime
Aug 20
Totò Fiandaca
, …
a.fu...@lqt.it
10
Aug 17
Enhancement of Row Count Indicator in Status Bar
Dear Alessandro, I sincerely apologize if my emails seemed aggressive with the excessive use of
unread,
Enhancement of Row Count Indicator in Status Bar
Dear Alessandro, I sincerely apologize if my emails seemed aggressive with the excessive use of
Aug 17
Bas Couwenberg
,
a.fu...@lqt.it
4
Aug 17
libxml2 2.15 will drop HTTP & LZMA support
Hi Bas, > The libxml2 maintainer suggests users who need this to implement > their own >
unread,
libxml2 2.15 will drop HTTP & LZMA support
Hi Bas, > The libxml2 maintainer suggests users who need this to implement > their own >
Aug 17
Shun Wang
,
a.fu...@lqt.it
6
Aug 15
FreeXL: bugs in FreeXL-2.0.0 cannot open multiple columns data files
Hi Sandro, I don't know if you have time to look at this question;-) would be grateful for your
unread,
FreeXL: bugs in FreeXL-2.0.0 cannot open multiple columns data files
Hi Sandro, I don't know if you have time to look at this question;-) would be grateful for your
Aug 15
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
Jul 23
Intersects query takes long time to run
Hi Sandro, Gemini suggested a double spatial index query for my problem. INSERT INTO
unread,
Intersects query takes long time to run
Hi Sandro, Gemini suggested a double spatial index query for my problem. INSERT INTO
Jul 23
Hernán De Angelis
,
a.fu...@lqt.it
2
Jun 9
libspatialite test fail with GEOS dev
Hi Herman, all software is an evolving thing that changes over time. A release is nothing more than a
unread,
libspatialite test fail with GEOS dev
Hi Herman, all software is an evolving thing that changes over time. A release is nothing more than a
Jun 9
Tobias Schula
,
a.fu...@lqt.it
5
Mar 20
Options for odbc.ini: load 'mod_spatialite'
On Wed, 19 Mar 2025 23:03:41 +0100, Tobias Schula wrote: > On Wednesday, 19 March 2025, 23:00:26
unread,
Options for odbc.ini: load 'mod_spatialite'
On Wed, 19 Mar 2025 23:03:41 +0100, Tobias Schula wrote: > On Wednesday, 19 March 2025, 23:00:26
Mar 20
Antonio Valanzano
,
a.fu...@lqt.it
3
Feb 25
Spatial VIEW creation error
Dear Sandro, thanks for your quick response. I didn't want to create a writable view using only
unread,
Spatial VIEW creation error
Dear Sandro, thanks for your quick response. I didn't want to create a writable view using only
Feb 25
Tobias Schula
,
a.fu...@lqt.it
5
Feb 23
Compiling spatialite-gui: problems with libpq-fe.h
Hi Sandro! Am 23.02.25 um 19:53 schrieb a.fu...@lqt.it: >> However, I now get this warning:
unread,
Compiling spatialite-gui: problems with libpq-fe.h
Hi Sandro! Am 23.02.25 um 19:53 schrieb a.fu...@lqt.it: >> However, I now get this warning:
Feb 23
Antonio Valanzano
, …
a.fu...@lqt.it
5
Feb 23
ST_Azimuth() results
On Sun, 23 Feb 2025 18:01:31 +0100, Antonio Valanzano wrote: > However there is a lack of
unread,
ST_Azimuth() results
On Sun, 23 Feb 2025 18:01:31 +0100, Antonio Valanzano wrote: > However there is a lack of
Feb 23
Jim
,
a.fu...@lqt.it
6
Feb 14
Best way to find a row based on my location
To close out the item. Your solution, while a bit slower (0.1 sec), was far more precise and gives me
unread,
Best way to find a row based on my location
To close out the item. Your solution, while a bit slower (0.1 sec), was far more precise and gives me
Feb 14
Antonio Valanzano
, …
a.fu...@lqt.it
6
Jan 25
invalid geometries - ST_MakeValid() vs GeosMakeValid()
Sandro, thanks for adding some more specific information about the change of geometry type eventually
unread,
invalid geometries - ST_MakeValid() vs GeosMakeValid()
Sandro, thanks for adding some more specific information about the change of geometry type eventually
Jan 25
Elijah Massey
, …
a.fu...@lqt.it
6
Jan 13
3D Geometry Support in knn2 and SpatialIndex, and Best SRID for Minecraft Worlds
Hi List, I'm happy to announce a new open source initiative that may be of interest to some of
unread,
3D Geometry Support in knn2 and SpatialIndex, and Best SRID for Minecraft Worlds
Hi List, I'm happy to announce a new open source initiative that may be of interest to some of
Jan 13
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Jan 5
Updating table with prepared statement and bindings
Hi Sandro, Thanks for your tip of expanding the SQL. It was really useful and let me see where I'
unread,
Updating table with prepared statement and bindings
Hi Sandro, Thanks for your tip of expanding the SQL. It was really useful and let me see where I'
Jan 5
Shijie li
,
a.fu...@lqt.it
4
12/30/24
ST_Covers gives incorrect result with geometry collection.
One last question worthy of some clarification. SpatiaLite entirely delegates all the functions of
unread,
ST_Covers gives incorrect result with geometry collection.
One last question worthy of some clarification. SpatiaLite entirely delegates all the functions of
12/30/24
Shijie li
,
a.fu...@lqt.it
3
12/25/24
ST_Overlaps gives unexpected result
Thanks for your professional answer. Wishing you a Merry Christmas too! 在2024年12月25日星期三 UTC+8 19:00:
unread,
ST_Overlaps gives unexpected result
Thanks for your professional answer. Wishing you a Merry Christmas too! 在2024年12月25日星期三 UTC+8 19:00:
12/25/24
Shijie li
,
a.fu...@lqt.it
3
12/25/24
GEOSConcaveHull returns null with MultiPolygon
Sorry, I ran this query correctly on spatialite. The incorrect result was caused by my improper
unread,
GEOSConcaveHull returns null with MultiPolygon
Sorry, I ran this query correctly on spatialite. The incorrect result was caused by my improper
12/25/24
a.fu...@lqt.it
,
Shijie li
2
12/25/24
Re: [SpatiaLite-Users] ST_ConcaveHull gives unexpected result
Sorry, I misread it 在2024年12月25日星期三 UTC+8 14:53:45<a.fu...@lqt.it> 写道: On Tue, 24 Dec 2024 18:
unread,
Re: [SpatiaLite-Users] ST_ConcaveHull gives unexpected result
Sorry, I misread it 在2024年12月25日星期三 UTC+8 14:53:45<a.fu...@lqt.it> 写道: On Tue, 24 Dec 2024 18:
12/25/24
Antonio Valanzano
, …
Maurizio Trevisani
3
12/24/24
multiple overlaps (>2) between polygons
The problem is not only the multiple overlaps, where you could decide to eliminate those arcs which
unread,
multiple overlaps (>2) between polygons
The problem is not only the multiple overlaps, where you could decide to eliminate those arcs which
12/24/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
11/22/24
Spatial query on table with two spatial indexes
Thank you. That is perfect. Best, Chris -----Original Message----- From: spatialite-users@
unread,
Spatial query on table with two spatial indexes
Thank you. That is perfect. Best, Chris -----Original Message----- From: spatialite-users@
11/22/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
11/4/24
Speed of knn2
Hi Sandro, Thanks for your reply. You are right. What I wanted to do was simply too computationally
unread,
Speed of knn2
Hi Sandro, Thanks for your reply. You are right. What I wanted to do was simply too computationally
11/4/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
10/27/24
Invalid args using ElementaryGeometries
Thanks, that did the trick. I had previously been just using Polygon GEOMETRY In my CREATE TABLE
unread,
Invalid args using ElementaryGeometries
Thanks, that did the trick. I had previously been just using Polygon GEOMETRY In my CREATE TABLE
10/27/24
ckgoo...@gmail.com
, …
Pieter Roggemans
6
10/24/24
Hunting down source of geometry violation
Thanks. That's also a section of the functions table I haven't explored before. Lots of new
unread,
Hunting down source of geometry violation
Thanks. That's also a section of the functions table I haven't explored before. Lots of new
10/24/24
Mike Castle
,
a.fu...@lqt.it
3
10/22/24
Finding rows with points that make up a convex hull
> I imagine this is not a concern unique to spatialite, but it happens > to be the only
unread,
Finding rows with points that make up a convex hull
> I imagine this is not a concern unique to spatialite, but it happens > to be the only
10/22/24
Augustin Trancart
, …
Even Rouault
4
10/18/24
Strategy regarding dropping of http support in libxml2
Hi, Thanks both of you for your answers. Apparently it does not create memory leak (the author of
unread,
Strategy regarding dropping of http support in libxml2
Hi, Thanks both of you for your answers. Apparently it does not create memory leak (the author of
10/18/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
10/17/24
No such column ROWID in my spatial index query
Hi, Success! I just had to write "WHERE l.ROWID" to qualify it. The use of an attached
unread,
No such column ROWID in my spatial index query
Hi, Success! I just had to write "WHERE l.ROWID" to qualify it. The use of an attached
10/17/24
ckgoo...@gmail.com
, …
a.fu...@lqt.it
7
10/17/24
Trimming polygons that extend into the sea
On Thu, 17 Oct 2024 07:25:18 +0100, ckgoo...@gmail.com wrote: > I wrote: > > There are
unread,
Trimming polygons that extend into the sea
On Thu, 17 Oct 2024 07:25:18 +0100, ckgoo...@gmail.com wrote: > I wrote: > > There are
10/17/24
Vedran Stojnović
, …
a.fu...@lqt.it
7
10/16/24
Incorrect parsing of FGF geometry
On Wed, 16 Oct 2024 00:31:50 -0700 (PDT), James McGuiness wrote: > Hi all, > > I'm
unread,
Incorrect parsing of FGF geometry
On Wed, 16 Oct 2024 00:31:50 -0700 (PDT), James McGuiness wrote: > Hi all, > > I'm
10/16/24
ckgoo...@gmail.com
,
Jukka Rahkonen
3
10/6/24
Direction to nearest point of a polygon
Hi Jukka, Thanks. I didn't see that one. Looks just the thing I needed. Many thanks, Chris From:
unread,
Direction to nearest point of a polygon
Hi Jukka, Thanks. I didn't see that one. Looks just the thing I needed. Many thanks, Chris From:
10/6/24