Groups
Conversations
All groups and messages
Send feedback to Google
Help
Training
Sign in
Groups
SpatiaLite Users
Conversations
About
Groups keyboard shortcuts have been updated
Dismiss
See shortcuts
SpatiaLite Users
Contact owners and managers
1–30 of 2525
Mark all as read
Report group
0 selected
Tobias Schula
,
a.fu...@lqt.it
5
4:02 AM
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
4:02 AM
Shun Wang
,
a.fu...@lqt.it
4
Mar 15
FreeXL: bugs in FreeXL-2.0.0 cannot open multiple columns data files
Hi Sandro, Sure, here is the .xlsx file with multiple columns more than 700+. see: https://drive.
unread,
FreeXL: bugs in FreeXL-2.0.0 cannot open multiple columns data files
Hi Sandro, Sure, here is the .xlsx file with multiple columns more than 700+. see: https://drive.
Mar 15
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
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
9/29/24
Error when doing distance calculation
Hi, I understand. It works from the Spatialite command line because proj.db is in the same folder as
unread,
Error when doing distance calculation
Hi, I understand. It works from the Spatialite command line because proj.db is in the same folder as
9/29/24
ckgoo...@gmail.com
9/22/24
Re: Inserting a polygon geometry from C++
I wrote: > Hi, I am having trouble inserting a polygon geometry into a table from within a C++
unread,
Re: Inserting a polygon geometry from C++
I wrote: > Hi, I am having trouble inserting a polygon geometry into a table from within a C++
9/22/24
Jimmy
, …
Vladyslav Shkodych
7
9/20/24
Spatialite for iOS : Functions in modules other than base doesn't work
It took some time to find a solution, but it was worth it. I wrote an article with explanations to
unread,
Spatialite for iOS : Functions in modules other than base doesn't work
It took some time to find a solution, but it was worth it. I wrote an article with explanations to
9/20/24
bo yang
9/14/24
bug report: vspidx_check_rtree and vspidx_find_rtree will be into dead loop when sqlite3_step return error
while (1) { /* scrolling the result set rows */ ret = sqlite3_step (stmt); if (ret == SQLITE_DONE)
unread,
bug report: vspidx_check_rtree and vspidx_find_rtree will be into dead loop when sqlite3_step return error
while (1) { /* scrolling the result set rows */ ret = sqlite3_step (stmt); if (ret == SQLITE_DONE)
9/14/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
4
9/1/24
Polygons have self-crossings
Hi, Turns out it was sort of my algorithm. More of a coding problem. I was using a C++ stringstream
unread,
Polygons have self-crossings
Hi, Turns out it was sort of my algorithm. More of a coding problem. I was using a C++ stringstream
9/1/24
Even Rouault
8/30/24
spatialite_cleanup_ex() is not re-entrant due to xmlCleanupParser()
Hi, below a bug raised against GDAL but I believe it is fundamentally a Spatialite bug.
unread,
spatialite_cleanup_ex() is not re-entrant due to xmlCleanupParser()
Hi, below a bug raised against GDAL but I believe it is fundamentally a Spatialite bug.
8/30/24