Search
Clear search
Close search
Main menu
Google apps
Groups
Sign in
Groups
SpatiaLite Users
Conversations
About
Send feedback
Help
Sort By Relevance
Sort By Date
1–30 of many
Tobias Schula
,
a.fu...@lqt.it
5
Mar 20
Options for odbc.ini: load 'mod_spatialite'
Hi at all! Does anyone here have experience using SpatiaLite through ODBC? How can I load the '
unread,
Options for odbc.ini: load 'mod_spatialite'
Hi at all! Does anyone here have experience using SpatiaLite through ODBC? How can I load the '
Mar 20
Shun Wang
,
a.fu...@lqt.it
5
Mar 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
Mar 23
Antonio Valanzano
,
a.fu...@lqt.it
3
Feb 25
Spatial VIEW creation error
Does someone know what is wrong with the following SQL code ? -- step 1 CREATE TABLE st_g AS SELECT
unread,
Spatial VIEW creation error
Does someone know what is wrong with the following SQL code ? -- step 1 CREATE TABLE st_g AS SELECT
Feb 25
Tobias Schula
,
a.fu...@lqt.it
5
Feb 23
Compiling spatialite-gui: problems with libpq-fe.h
Hi everyone, I'm trying to compile spatialite-gui on an up-to-date Tumbleweed installation.
unread,
Compiling spatialite-gui: problems with libpq-fe.h
Hi everyone, I'm trying to compile spatialite-gui on an up-to-date Tumbleweed installation.
Feb 23
Antonio Valanzano
, …
a.fu...@lqt.it
5
Feb 23
ST_Azimuth() results
Can someone tell me why Spatialite is giving results different from PostGIS for the following SELECT
unread,
ST_Azimuth() results
Can someone tell me why Spatialite is giving results different from PostGIS for the following SELECT
Feb 23
Jim
,
a.fu...@lqt.it
6
Feb 14
Best way to find a row based on my location
I have a 7 million row table that contains a geometry of a POINT. The table also has a spatial index
unread,
Best way to find a row based on my location
I have a 7 million row table that contains a geometry of a POINT. The table also has a spatial index
Feb 14
Antonio Valanzano
, …
a.fu...@lqt.it
6
Jan 25
invalid geometries - ST_MakeValid() vs GeosMakeValid()
I have a table with polygons and one of this is invalid. The return string of ST_IsValidReason is:
unread,
invalid geometries - ST_MakeValid() vs GeosMakeValid()
I have a table with polygons and one of this is invalid. The return string of ST_IsValidReason is:
Jan 25
Elijah Massey
, …
a.fu...@lqt.it
6
Jan 13
3D Geometry Support in knn2 and SpatialIndex, and Best SRID for Minecraft Worlds
Hello, I am working on a Minecraft mod to keep track of POIs in the world and announce them as the
unread,
3D Geometry Support in knn2 and SpatialIndex, and Best SRID for Minecraft Worlds
Hello, I am working on a Minecraft mod to keep track of POIs in the world and announce them as the
Jan 13
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
Jan 5
Updating table with prepared statement and bindings
Hello. This is almost certainly an SQLite3 question rather than Spatialite but I hope someone can
unread,
Updating table with prepared statement and bindings
Hello. This is almost certainly an SQLite3 question rather than Spatialite but I hope someone can
Jan 5
Shijie li
,
a.fu...@lqt.it
4
12/30/24
ST_Covers gives incorrect result with geometry collection.
Considering following queries: DROP table if EXISTS t1; DROP table if EXISTS t2; CREATE TABLE t1(geom
unread,
ST_Covers gives incorrect result with geometry collection.
Considering following queries: DROP table if EXISTS t1; DROP table if EXISTS t2; CREATE TABLE t1(geom
12/30/24
Shijie li
,
a.fu...@lqt.it
3
12/25/24
ST_Overlaps gives unexpected result
Defination of ST_Overlaps :TRUE if the intersection of g1 and g2 results in a value of the same
unread,
ST_Overlaps gives unexpected result
Defination of ST_Overlaps :TRUE if the intersection of g1 and g2 results in a value of the same
12/25/24
Shijie li
,
a.fu...@lqt.it
3
12/25/24
GEOSConcaveHull returns null with MultiPolygon
I want to try using the GeosConcaveHull function to calculate the concave hull of a polygon, so I
unread,
GEOSConcaveHull returns null with MultiPolygon
I want to try using the GeosConcaveHull function to calculate the concave hull of a polygon, so I
12/25/24
a.fu...@lqt.it
,
Shijie li
2
12/25/24
Re: [SpatiaLite-Users] ST_ConcaveHull gives unexpected result
On Tue, 24 Dec 2024 18:45:21 -0800 (PST), Shijie li wrote: > Considering following query: >
unread,
Re: [SpatiaLite-Users] ST_ConcaveHull gives unexpected result
On Tue, 24 Dec 2024 18:45:21 -0800 (PST), Shijie li wrote: > Considering following query: >
12/25/24
Antonio Valanzano
, …
Maurizio Trevisani
3
12/24/24
multiple overlaps (>2) between polygons
Hi members, I have the problem of cleaning some polygon data . They present several overlaps and I
unread,
multiple overlaps (>2) between polygons
Hi members, I have the problem of cleaning some polygon data . They present several overlaps and I
12/24/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
11/22/24
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
11/22/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
11/4/24
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
11/4/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
10/27/24
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
10/27/24
ckgoo...@gmail.com
, …
Pieter Roggemans
6
10/24/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
10/24/24
Mike Castle
,
a.fu...@lqt.it
3
10/22/24
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
10/22/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
10/17/24
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
10/17/24
ckgoo...@gmail.com
, …
a.fu...@lqt.it
7
10/17/24
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
10/17/24
Vedran Stojnović
, …
a.fu...@lqt.it
7
10/16/24
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
10/16/24
Augustin Trancart
, …
Even Rouault
4
10/18/24
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
10/18/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
5
9/29/24
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
9/29/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
4
9/1/24
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
9/1/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
8/10/24
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
8/10/24
ckgoo...@gmail.com
, …
a.fu...@lqt.it
7
8/10/24
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
8/10/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
8/8/24
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
8/8/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
3
8/7/24
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
8/7/24
ckgoo...@gmail.com
,
a.fu...@lqt.it
2
8/5/24
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
8/5/24