Groups
Sign in
Groups
SpatiaLite Users
Conversations
About
Send feedback
Help
Sort By Relevance
Sort By Date
1–30 of many
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Nov 22
Spatial query on table with two spatial indexes
Hello. I have a query on my table which uses a spatial index to include only polygons that contain a
unread,
Spatial query on table with two spatial indexes
Hello. I have a query on my table which uses a spatial index to include only polygons that contain a
Nov 22
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Nov 4
Speed of knn2
Hi, I am using the knn2 algorithm as below and I am finding it is taking around 0.5 seconds to return
unread,
Speed of knn2
Hi, I am using the knn2 algorithm as below and I am finding it is taking around 0.5 seconds to return
Nov 4
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Oct 27
Invalid args using ElementaryGeometries
Hello. I have a table spt_Intersections with a geometry column called polygon that has just one row
unread,
Invalid args using ElementaryGeometries
Hello. I have a table spt_Intersections with a geometry column called polygon that has just one row
Oct 27
ckgoo...@gmail.com
, …
Pieter Roggemans
6
Oct 24
Hunting down source of geometry violation
Hi, I am getting a violation of geometry constraint error when running a query which is inserting
unread,
Hunting down source of geometry violation
Hi, I am getting a violation of geometry constraint error when running a query which is inserting
Oct 24
Mike Castle
,
a.fu...@lqt.it
3
Oct 22
Finding rows with points that make up a convex hull
I have a simple table, poi, with two columns: guid, ST_POINT I can get the convex hull of all points
unread,
Finding rows with points that make up a convex hull
I have a simple table, poi, with two columns: guid, ST_POINT I can get the convex hull of all points
Oct 22
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
Oct 17
No such column ROWID in my spatial index query
Hi, I have a select statement that uses a spatial index that works okay but when I then expand the
unread,
No such column ROWID in my spatial index query
Hi, I have a select statement that uses a spatial index that works okay but when I then expand the
Oct 17
ckgoo...@gmail.com
, …
a.fu...@lqt.it
7
Oct 17
Trimming polygons that extend into the sea
Hello. I think this question is really just a general 'how to write an update query' question
unread,
Trimming polygons that extend into the sea
Hello. I think this question is really just a general 'how to write an update query' question
Oct 17
Vedran Stojnović
, …
a.fu...@lqt.it
7
Oct 16
Incorrect parsing of FGF geometry
Hi, I have problems with GeomFromFGF() function. I have exported geometries from AutoCAD Map to
unread,
Incorrect parsing of FGF geometry
Hi, I have problems with GeomFromFGF() function. I have exported geometries from AutoCAD Map to
Oct 16
Augustin Trancart
, …
Even Rouault
4
Oct 18
Strategy regarding dropping of http support in libxml2
Hi! libxml2 is dropping http support soon. I was wondering what is the strategy concerning
unread,
Strategy regarding dropping of http support in libxml2
Hi! libxml2 is dropping http support soon. I was wondering what is the strategy concerning
Oct 18
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
Sep 29
Error when doing distance calculation
Hi, in my C++ application I make many calls to my Spatialite database and then all work fine. I use
unread,
Error when doing distance calculation
Hi, in my C++ application I make many calls to my Spatialite database and then all work fine. I use
Sep 29
ckgoo...@gmail.com
,
a.fu...@lqt.it
4
Sep 1
Polygons have self-crossings
Hi, I am processing OSM data – it happens to be the admin_level 2 boundary relation for South Africa
unread,
Polygons have self-crossings
Hi, I am processing OSM data – it happens to be the admin_level 2 boundary relation for South Africa
Sep 1
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
Aug 10
Filtering OSM data
Hi. I've downloaded data from the Geofabrriq site for the UK. It contains all OSM data for this
unread,
Filtering OSM data
Hi. I've downloaded data from the Geofabrriq site for the UK. It contains all OSM data for this
Aug 10
ckgoo...@gmail.com
, …
a.fu...@lqt.it
7
Aug 10
A polygon crossing the international date line
Hello. I have imported sea polygons from shapefiles of seas and oceans into my database. These
unread,
A polygon crossing the international date line
Hello. I have imported sea polygons from shapefiles of seas and oceans into my database. These
Aug 10
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
Aug 8
Success with testing point in the sea
Hi all. Based on OpenStreetMap coastline data, there are water polygon shapefiles available at: https
unread,
Success with testing point in the sea
Hi all. Based on OpenStreetMap coastline data, there are water polygon shapefiles available at: https
Aug 8
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Aug 7
Downloading Spatialite Tools binaries for Windows
Hi, I feel real daft for asking this but I've been googling for 20 minutes or more with no
unread,
Downloading Spatialite Tools binaries for Windows
Hi, I feel real daft for asking this but I've been googling for 20 minutes or more with no
Aug 7
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
Aug 5
My first spatial index query
Hi all. I think I now have a successful spatial query. My database is quite simple with a single
unread,
My first spatial index query
Hi all. I think I now have a successful spatial query. My database is quite simple with a single
Aug 5
ckgoo...@gmail.com
,
a.fu...@lqt.it
4
Aug 5
Using RTreeIntersects - not a function
Hi. I use Spatialite from within an SQLite3 prompt on Windows. When I start a session I type: .load
unread,
Using RTreeIntersects - not a function
Hi. I use Spatialite from within an SQLite3 prompt on Windows. When I start a session I type: .load
Aug 5
ckgoo...@gmail.com
, …
Mike Castle
28
Aug 4
Select poinnts based on distance
Hi, I have a simple Spatialite database. One table called spt_cities with columns, id, name, country,
unread,
Select poinnts based on distance
Hi, I have a simple Spatialite database. One table called spt_cities with columns, id, name, country,
Aug 4
ckgoo...@gmail.com
, …
a.fu...@lqt.it
12
Jul 29
Using Spatialite within C++ - locating .lib and .h files
Hello all, I want to make use of Spatialite within my C++ application and normally I'd expect to
unread,
Using Spatialite within C++ - locating .lib and .h files
Hello all, I want to make use of Spatialite within my C++ application and normally I'd expect to
Jul 29
Muhammad Rowaha
,
a.fu...@lqt.it
2
Jul 16
no such function 'geomfromtext'
I am working on porting spatialite to android for a .NET MAUI app and I have managed to achieve the
unread,
no such function 'geomfromtext'
I am working on porting spatialite to android for a .NET MAUI app and I have managed to achieve the
Jul 16
Thomas Larsen Wessel
,
a.fu...@lqt.it
3
Jul 14
How to change spatialite version of build?
I downloaded source and made a few changes before building. I would like to be able to tell, at
unread,
How to change spatialite version of build?
I downloaded source and made a few changes before building. I would like to be able to tell, at
Jul 14
Brent Wood
,
a.fu...@lqt.it
2
Jul 4
generating a linestring from a set of points
Hi, I have ingested a log of GPS NMEA messages & generated a timestamped point for each RMC
unread,
generating a linestring from a set of points
Hi, I have ingested a log of GPS NMEA messages & generated a timestamped point for each RMC
Jul 4
A A
,
a.fu...@lqt.it
4
Jul 3
.mode column results in strange output with spatialite
Hello, new user here. I have already posted my question on StackExchange, but this might be a better
unread,
.mode column results in strange output with spatialite
Hello, new user here. I have already posted my question on StackExchange, but this might be a better
Jul 3
Ke Song
,
a.fu...@lqt.it
5
May 27
is it possible to store UAV images incrementally into Rasterlite2 in real-time and serve them through WMSLite for dynamic visualization
I want to implement a system that stores UAV (Unmanned Aerial Vehicle) images which was been
unread,
is it possible to store UAV images incrementally into Rasterlite2 in real-time and serve them through WMSLite for dynamic visualization
I want to implement a system that stores UAV (Unmanned Aerial Vehicle) images which was been
May 27
Elham Peiravian
,
a.fu...@lqt.it
2
May 15
Re-Generating ROWID
HI everyone, I needed to delete some rows in a table and then add some other rows to it. I noticed
unread,
Re-Generating ROWID
HI everyone, I needed to delete some rows in a table and then add some other rows to it. I noticed
May 15
Massimo Endrighi
,
a.fu...@lqt.it
5
May 14
error loading mod_spatialite with System.Data.SQLite connection
Hi Sandro I have a .net core 5.0 c# application that use a System.Data.SQLite.Core connection to open
unread,
error loading mod_spatialite with System.Data.SQLite connection
Hi Sandro I have a .net core 5.0 c# application that use a System.Data.SQLite.Core connection to open
May 14
f.lov...@gmail.com
,
a.fu...@lqt.it
3
May 14
Rasterlite2: Parse error: no such function: XB_LoadXML
Hi folks and Sandro I was playing with rasterlite2 tutorials to see how it woks under Debian trixie
unread,
Rasterlite2: Parse error: no such function: XB_LoadXML
Hi folks and Sandro I was playing with rasterlite2 tutorials to see how it woks under Debian trixie
May 14
Pieter Roggemans
, …
a.fu...@lqt.it
6
May 8
Issues working with multi-geometries in GeometryCollection
Hello! It seems that having multi-geometries in a GeometryCollection leads to some issues. These are
unread,
Issues working with multi-geometries in GeometryCollection
Hello! It seems that having multi-geometries in a GeometryCollection leads to some issues. These are
May 8
Jimmy
, …
Vladyslav Shkodych
7
Sep 20
Spatialite for iOS : Functions in modules other than base doesn't work
Hey, I am trying to run spatialite on iOS by using the following repo. https://github.com/gstf/
unread,
Spatialite for iOS : Functions in modules other than base doesn't work
Hey, I am trying to run spatialite on iOS by using the following repo. https://github.com/gstf/
Sep 20
Jim
,
a.fu...@lqt.it
2
Apr 9
ATTACH and spatialite_gui question
I ran the following query on the database 'us_uk_ca_shapes.db' and got the expected result: (
unread,
ATTACH and spatialite_gui question
I ran the following query on the database 'us_uk_ca_shapes.db' and got the expected result: (
Apr 9