Groups
Conversations
All groups and messages
Send feedback to Google
Help
Training
Sign in
Groups
SpatiaLite Users
Conversations
About
SpatiaLite Users
Contact owners and managers
1–30 of 2512
Mark all as read
Report group
0 selected
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Nov 22
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@
Nov 22
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Nov 4
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
Nov 4
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Oct 27
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
Oct 27
ckgoo...@gmail.com
, …
Pieter Roggemans
6
Oct 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
Oct 24
Mike Castle
,
a.fu...@lqt.it
3
Oct 22
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
Oct 22
Augustin Trancart
, …
Even Rouault
4
Oct 18
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
Oct 18
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
Oct 17
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
Oct 17
ckgoo...@gmail.com
, …
a.fu...@lqt.it
7
Oct 17
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
Oct 17
Vedran Stojnović
, …
a.fu...@lqt.it
7
Oct 16
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
Oct 16
ckgoo...@gmail.com
,
Jukka Rahkonen
3
Oct 6
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:
Oct 6
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
Sep 29
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
Sep 29
ckgoo...@gmail.com
Sep 22
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++
Sep 22
Jimmy
, …
Vladyslav Shkodych
7
Sep 20
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
Sep 20
bo yang
Sep 14
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)
Sep 14
ckgoo...@gmail.com
,
a.fu...@lqt.it
4
Sep 1
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
Sep 1
Even Rouault
Aug 30
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.
Aug 30
Shun Wang
Aug 23
FreeXL: bugs in FreeXL-2.0.0 cannot open multiple columns data files
Hi, thanks for your work! I cannot open the big .xlsx files with multiple columns(more than 725 I
unread,
FreeXL: bugs in FreeXL-2.0.0 cannot open multiple columns data files
Hi, thanks for your work! I cannot open the big .xlsx files with multiple columns(more than 725 I
Aug 23
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
Aug 10
Filtering OSM data
On Sat, 10 Aug 2024 09:40:41 +0100, ckgoo...@gmail.com wrote: > Hi. I've downloaded data
unread,
Filtering OSM data
On Sat, 10 Aug 2024 09:40:41 +0100, ckgoo...@gmail.com wrote: > Hi. I've downloaded data
Aug 10
ckgoo...@gmail.com
, …
a.fu...@lqt.it
7
Aug 10
A polygon crossing the international date line
On Sat, 10 Aug 2024 08:30:39 +0100, ckgoo...@gmail.com wrote: > Next stop is spatialite_osm_map
unread,
A polygon crossing the international date line
On Sat, 10 Aug 2024 08:30:39 +0100, ckgoo...@gmail.com wrote: > Next stop is spatialite_osm_map
Aug 10
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
Aug 8
Success with testing point in the sea
On Wed, 7 Aug 2024 20:48:59 +0100, ckgoo...@gmail.com wrote: > Based on OpenStreetMap coastline
unread,
Success with testing point in the sea
On Wed, 7 Aug 2024 20:48:59 +0100, ckgoo...@gmail.com wrote: > Based on OpenStreetMap coastline
Aug 8
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Aug 7
Downloading Spatialite Tools binaries for Windows
Hello Sandro, many thanks. I've now downloaded the binaries and made good use of them. To explain
unread,
Downloading Spatialite Tools binaries for Windows
Hello Sandro, many thanks. I've now downloaded the binaries and made good use of them. To explain
Aug 7
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
Aug 5
My first spatial index query
Hello Chris, congratulations: you've finally found the right path. Now making your query
unread,
My first spatial index query
Hello Chris, congratulations: you've finally found the right path. Now making your query
Aug 5
ckgoo...@gmail.com
,
a.fu...@lqt.it
4
Aug 5
Using RTreeIntersects - not a function
On Mon, 5 Aug 2024 07:14:45 +0100, ckgoo...@gmail.com wrote: > Doing a another google though
unread,
Using RTreeIntersects - not a function
On Mon, 5 Aug 2024 07:14:45 +0100, ckgoo...@gmail.com wrote: > Doing a another google though
Aug 5
ckgoo...@gmail.com
, …
Mike Castle
28
Aug 4
Select poinnts based on distance
Hi Sandro, Mike. Think I have engaged my brain now. So a circle created with MakeCircle of radius 5
unread,
Select poinnts based on distance
Hi Sandro, Mike. Think I have engaged my brain now. So a circle created with MakeCircle of radius 5
Aug 4
ckgoo...@gmail.com
, …
a.fu...@lqt.it
12
Jul 29
Using Spatialite within C++ - locating .lib and .h files
On Sun, 28 Jul 2024 21:30:17 +0100, ckgoo...@gmail.com wrote: > Thanks Sandro. I'll stick
unread,
Using Spatialite within C++ - locating .lib and .h files
On Sun, 28 Jul 2024 21:30:17 +0100, ckgoo...@gmail.com wrote: > Thanks Sandro. I'll stick
Jul 29
Muhammad Rowaha
,
a.fu...@lqt.it
2
Jul 16
no such function 'geomfromtext'
On Mon, 15 Jul 2024 22:46:20 -0700 (PDT), Muhammad Rowaha wrote: > I am working on porting
unread,
no such function 'geomfromtext'
On Mon, 15 Jul 2024 22:46:20 -0700 (PDT), Muhammad Rowaha wrote: > I am working on porting
Jul 16
Thomas Larsen Wessel
,
a.fu...@lqt.it
3
Jul 14
How to change spatialite version of build?
That worked :) Thanks. (I did not know of the autoreconf command) On Fri, Jul 12, 2024 at 6:36 AM
unread,
How to change spatialite version of build?
That worked :) Thanks. (I did not know of the autoreconf command) On Fri, Jul 12, 2024 at 6:36 AM
Jul 14
Antonio Valanzano
Jul 10
bulk nearest neighbor - slow process
I have 2 tables: buildings (5000 polygons) sensors (110000 points) and I would like to find for each
unread,
bulk nearest neighbor - slow process
I have 2 tables: buildings (5000 polygons) sensors (110000 points) and I would like to find for each
Jul 10
Brent Wood
,
a.fu...@lqt.it
2
Jul 4
generating a linestring from a set of points
On Thu, 4 Jul 2024 03:24:06 +0000 (UTC), 'Brent Wood' via SpatiaLite Users wrote: > Hi,
unread,
generating a linestring from a set of points
On Thu, 4 Jul 2024 03:24:06 +0000 (UTC), 'Brent Wood' via SpatiaLite Users wrote: > Hi,
Jul 4
A A
,
a.fu...@lqt.it
4
Jul 3
.mode column results in strange output with spatialite
Nevermind, I have successfully loaded the extension by downloading the binaries from The Gaia-SINS
unread,
.mode column results in strange output with spatialite
Nevermind, I have successfully loaded the extension by downloading the binaries from The Gaia-SINS
Jul 3