Spatialite is a library extending the basic SQLite core in order to get a full fledged Spatial DBMS.
Spatialite is a library extending the basic SQLite core in order to get a full fledged Spatial DBMS.
Questions tagged [spatialite]
236 questions
1
vote
1 answer
How to fix 'sqlite-3.7.2-sqlitejdbc.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform'
I want to load sqlite spatialfunction ,so I execute
stmt.execute("SELECT load_extension('mod_spatialite')");
then I get the error:
java.lang.UnsatisfiedLinkError: C:\Users\17222\AppData\Local\Temp\sqlite-3.7.2-sqlitejdbc.dll: Can't load IA 32-bit…
leomessi
- 69
- 6
1
vote
0 answers
How to create table with geometry column in GPKG with spatialite?
I want to create a vectorial GPKG with spatialite.
With the help of the documenation (here: http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.3.0.html#p16gpkg ), I've created a sql script that look like this:
SELECT EnableGpkgMode();
SELECT…
Djabx
- 635
- 1
- 8
- 16
1
vote
1 answer
Loading spatialite with python3's module under Windows
I installed spatialite's Python module using pip:
pip install spatialite
I copied the mod_spatialite.dll found on https://www.gaia-gis.it/gaia-sins/index.html into my windows/system32 folder (I have Python 3 32bits)
I have the error…
jokoon
- 6,207
- 11
- 48
- 85
1
vote
2 answers
How to improve sqlite query speed
I am working in the spatialite-gui with a sqlite db. I have a large table (80,000,000 records) and I want to make a table that includes a code from another table, which has about 48,000 records.
I wrote the following code and tested it on the first…
EnKay
- 48
- 6
1
vote
0 answers
How to use Spatialite with c#?
I tried to select geometry field from sqlite db.
Tried this guide https://gist.github.com/lydonchandra/5023e1076c338748b5c8
static bool is64bitProcess()
{
return (IntPtr.Size == 8);
}
static bool is32bitProcess()
{
…
Kliver Max
- 5,107
- 22
- 95
- 148
1
vote
1 answer
How to merge from SpatialLite to PostGIS?
How can I merge a SpatiaLite database to a PostGIS database?
I tried to use pgloader with the following command:
pgloader db.sqlite3 postgresql:///mydb
But it is not working. (I guess it is not supported). Please see the error output:
KABOOM!
FATAL…
Philipp S.
- 827
- 17
- 41
1
vote
1 answer
Spatialite extension not found when running go binary in docker container
I am setting up a Spatialite database (SQLite + Spatialite extension) and an associated Go program running in a docker container that queries the database and returns data.
Go-spatialite, in my understanding will dynamically load the spatialite…
mich
- 347
- 3
- 10
1
vote
0 answers
Spatialite Database library imported but init() error
I imported the Spatialite Library from here
And I am just trying to execute very simple queries but as soon as I am creating Database object, Its crashing by giving me this error
No implementation found for void jsqlite.Database.internal_init()…
GeekWithGlasses
- 572
- 2
- 12
- 30
1
vote
1 answer
How to get export shapefile from spatialite database in android
I'm working on a Mobile GIS android app. I want to get export ESRI Shapefiles from my Spatialite database when the user is offline. how can i do this? Is there any library which can help me?
Mahdi Nazari Ashani
- 372
- 1
- 5
- 22
1
vote
1 answer
Cannot install libspatilite on macOS
I'm trying to install the spatialite on macOS to query a sqlite db with geocordinates.
There is a brew formula that ships that lib and tools
brew install libspatialite
brew install spatialite-tools
I installed those but when I try to load the…
Jan
- 7,444
- 9
- 50
- 74
1
vote
1 answer
"[geom-type or SRID not allowed]" only after first call to `AddGeometryColumn`
I'm getting an error that "[geom-type or SRID not allowed]" for a geometry column, but I'm confident that the value I'm inserting is valid for the type and SR. I noticed that if I drop the table and recreate it again with the same value SQL, I no…
cwa
- 1,092
- 9
- 12
1
vote
2 answers
Does spatialite/mysql support 3D point?
Recently, I was studying spatialite.I can write 2D data(like this:POINT(1 1)) into the spatial data table,but I can't write 3D data(like this:POINT(1 1 1) ) into the spatial data table.
Who can tell me spatialite whether support 3D? If support ,how…
firewang
- 11
- 2
1
vote
0 answers
libspatialite.so for 64 Bit Linux
Hi I am using spatialite extension functions for one of my select Query as below.
con.enable_load_extension(True)
con.execute('SELECT load_extension("libspatialite")')
........
con.enable_load_extension(False)
I am enocuntering error as…
Balaji Kulkarni
- 145
- 2
- 2
- 9
1
vote
1 answer
Spatialite SQL query to find the nearest node for the given lat/lon
I want to find the nearest node to a given coordinate. I checked this https://gis.stackexchange.com/questions/186783/how-to-get-the-long-lat-information-from-a-nodeid-and-vice-versa
But, his answer doesn't work.
My query:
SELECT PID,
min…
kevin
- 309
- 2
- 12
1
vote
0 answers
spatialite NodeJS module seems too slow
I'm developing an electron app that uses spatialite.
I did a simple test on a spatialite table with about 52000 polygons. (can't tell how many vertices...)
Running the following query in spatialite_gui takes about 0.5 seconds.
Running the same query…
Marco Afonso
- 316
- 2
- 11