Dear list members, I am trying to understand the different behaviour of the above functions. I have a

Hello, I have C++ code to create a Spatialite database but it takes a long time to execute compared

Hello everyone, I am currently facing a memory leak issue when performing continuous queries on a

Hi, I've been using Spatialite for a while now to implement my atlas application for visually

Hi all, the query below takes around 15 seconds to run. When I comment out the ST_Distance function

libxml2 2.15 will drop support for HTTP & LZMA [0], this will break the spatialite build when

Current Issue Description In the current version of SpatiaLite GUI, when executing a query that

Hi, I have a query which takes a very long time to run so would like to know if I'm approaching

Hi Running "make check" on libspatialite-5.1.0 built using a developing (latest master

Hi at all! Does anyone here have experience using SpatiaLite through ODBC? How can I load the '

Hi, thanks for your work! I cannot open the big .xlsx files with multiple columns(more than 725 I

Does someone know what is wrong with the following SQL code ? -- step 1 CREATE TABLE st_g AS SELECT

Hi everyone, I'm trying to compile spatialite-gui on an up-to-date Tumbleweed installation.

Can someone tell me why Spatialite is giving results different from PostGIS for the following SELECT

I have a 7 million row table that contains a geometry of a POINT. The table also has a spatial index

I have a table with polygons and one of this is invalid. The return string of ST_IsValidReason is:

Hello, I am working on a Minecraft mod to keep track of POIs in the world and announce them as the

Hello. This is almost certainly an SQLite3 question rather than Spatialite but I hope someone can

Considering following queries: DROP table if EXISTS t1; DROP table if EXISTS t2; CREATE TABLE t1(geom

Defination of ST_Overlaps :TRUE if the intersection of g1 and g2 results in a value of the same

I want to try using the GeosConcaveHull function to calculate the concave hull of a polygon, so I

On Tue, 24 Dec 2024 18:45:21 -0800 (PST), Shijie li wrote: > Considering following query: >

Hi members, I have the problem of cleaning some polygon data . They present several overlaps and I

Hello. I have a query on my table which uses a spatial index to include only polygons that contain a

Hi, I am using the knn2 algorithm as below and I am finding it is taking around 0.5 seconds to return

Hello. I have a table spt_Intersections with a geometry column called polygon that has just one row

Hi, I am getting a violation of geometry constraint error when running a query which is inserting

I have a simple table, poi, with two columns: guid, ST_POINT I can get the convex hull of all points

Hi, I have a select statement that uses a spatial index that works okay but when I then expand the

Hello. I think this question is really just a general 'how to write an update query' question