Stack Overflow
Stack Overflow

Questions tagged [spatialite]

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.

236 questions
0
votes
0 answers

How to explode geometries in Spatialite, eg convert every MultiLineString feature into several LineString features

I'm using sqlite with the Spatialite extension to query a geopackage file. Consider the following test table where each row have geometry type either LineString or MultiLineString. sqlite>load_extension('mod_spatialite'); sqlite>select…
Mads Skjern
  • 5,648
  • 6
  • 36
  • 40
0
votes
1 answer

How to work with a value modified in a spatialite trigger

I am have two tables one for the user to work with "arbres" and one is a record of what happened in the table "archive_arbres" insert. When a line is inserted in "arbres i want to calculate the value of the field age and the add the line with the…
Adikte
  • 27
  • 7
0
votes
0 answers

PHP convert WKB to WKT

I have been trying to figure this out for days. We have a spatialite database that is read by php and data is returned in a json feed. I do not have access to spatialite addon to sqlite in my hosting plan. We are initially trying to find a…
James
  • 702
  • 2
  • 15
  • 39
0
votes
0 answers

Query Spatialite for all features that pass in over or through an extent

I have a Spatialite Database created with QGIS which contains 200000+ multipolygons with more points that I care to count. I am looking to only load the polygons that are needed for the current viewport extent. I have the xmin, xmax, ymin, ymax but…
James
  • 702
  • 2
  • 15
  • 39
0
votes
0 answers

Openlayers cant recognize WKB type 168

I am attempting to use a spatialite database generated by QGIS in openlayers. I receive the following error Uncaught Error: Unsupported WKB geometry type 168 is found The code below uses a sample of one of my WKB entries. It is a MULTIPOLYGON…
James
  • 702
  • 2
  • 15
  • 39
0
votes
0 answers

How to enable GEOS in Spatialite on Windows 10?

I am installing Spatialite for use in GeoDjango on a Windwos 10 64 bit system. I have already installed GEOS, PROJ, and GDAL from source in my command prompt. As spatialite requires using nmake on windows, I am using the Visual Studio 2017 command…
Arham
  • 83
  • 2
  • 7
0
votes
0 answers

"django.db.utils.OperationalError: no such function: lwgeom_version" Django Version 3.2.16, Spatialite Version 4.2.0 on Windows 10

I have a Django application that uses some geographic information. I have installed GDAL and installed Spatialite by downloading the windows binaries and placing them in my python directory (conda environment in my case) as detailed in this post.…
Arham
  • 83
  • 2
  • 7
0
votes
2 answers

How to edit a big shapefile online?

I have a big shape file (about 1GB) and I need to display and update data from this file with an online map (mapbox). As I understand I need to convert this shapefile into some DB (Spatialite? PostGIS) and then query it by map BBOX to display by…
SERG
  • 3,907
  • 8
  • 44
  • 89
0
votes
0 answers

Error running migration after changing to spatialite db

I want to use geographical point in my django app therefor i changed the database engine to spatialite settings.py """ Django settings for server project. Generated by 'django-admin startproject' using Django 4.1.2. For more information on this…
M.Davari
  • 43
  • 6
0
votes
1 answer

How do I turn an SQLite table into a SpatiaLite table?

I've got a Pandas table in an SQLite database with 40 odd columns all of which might need to be interrogated in QGIS. The table contains XY data and a previous Python code captured the EPSG code needed to create the points. How do I transform my…
Nick_Jo
  • 101
  • 9
0
votes
1 answer

Spatialite: insert polygons into multipolygon geometry column?

I am using Spatialite (coming with QGIS 3.16). I have a query that collects records to insert them into a table I created for this purpose. I set the geometry type of the geometry column to MULTIPOLYGON : CREATE TABLE parkings_combinés_lycées ( …
Darth Kangooroo
  • 372
  • 1
  • 3
  • 18
0
votes
0 answers

How to set audio listener orientation in JavaScript?

Web audio spatialization basics With the documentation I linked above, I found out how to create audio listeners and audio sources to play sounds I a 2D room. That way you can also set the direction the listener is facing by applying values to…
Therminact
  • 11
0
votes
0 answers

How to properly do spatially SQL-queries with GIS with Python

I have need your help with an spatially SQL-query with spatialite. I would like to extract points from an sql database geospatially based on another polygon shape (only these points within the polygon box). I have found some approaches but the…
dafra
  • 1
  • 1
0
votes
1 answer

Spatialite in Cygwin

Using the latest setup-x86_64_2.919 to install Cygwin, I just noticed that Spatialite is not there. So, I installed it from the source code (libspatialite-5.0.1.tar.gz) and I re-installed gdal-3.5.1 from the setup file. It seems that gdal has not…
Gery
  • 8,390
  • 3
  • 22
  • 39
0
votes
1 answer

How to insert GeoDataFrame into SQLite

Trying to insert a GeoDataFrame with geometry variables to SQLite, I get the following error: in enable_spatialite_extension raise LoadExtensionError(msg) from error spatialite.connection.LoadExtensionError: Failed to load Spatialite extension.…
Enrique Ortiz de Zárate
  • 3
  • 3
1 2 3
…
15 16