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
0
votes
0 answers
How to build android app with spatiallite in android studio?
I'm new in spatialite database in Android. I try to create an app that use spatialite for save and query spatial data. I tried several way, such as https://github.com/sevar83/android-spatialite, https://github.com/geopaparazzi/geopaparazzi/ and…
Ali Hosein pour
- 220
- 4
- 19
0
votes
1 answer
Is it possible to get multipolygon type data as string from spatialite?
sql.Register("sqlite3_with_extensions",
&sqlite3.SQLiteDriver{
Extensions: []string{
"mod_spatialite",
},
})
db, err := sql.Open("sqlite3_with_extensions", "./map.gpkg")
if err != nil {
…
madol
- 551
- 2
- 17
0
votes
1 answer
How do I drop geospatial metadata tables in SpatiaLite SQLite database?
SpatiaLite includes a function for standing up geospatial functionality in an existing SQLite database, namely, InitSpatialMetaData().
I'm seeking a similar method for tearing down geospatial metadata tables, and associated triggers and views,…
ryangooch
- 54
- 3
0
votes
0 answers
Populating Spatialite database with geojson strings
Not sure if I need to post this at Geo stack exchange or here. I am doing an api call with Python to a large database that has a column with + 1000 (single polygon) geojson strings. Each geojson looks like this:
{'type': 'FeatureCollection',…
GIStrees
- 1
- 1
- 1
0
votes
1 answer
Are Circular Arcs supported in ArcGIS Android API 10.X or 100.X?
I see that the class com.esri.arcgis.geometry.CircularArc is supported in ArcGIS Enterprise .NET API but it seems that a similar class isn't contained in com.esri.arcgisruntime.geometry.
I am developing an android application which contains trivial…
Sepideh Abadpour
- 2,550
- 10
- 52
- 88
0
votes
1 answer
How to use conditions with a RANK statement
The following piece of code does its job : it gives me the top 10 results for each category.
SELECT *
FROM (
SELECT *, RANK() OVER (PARTITION BY "pera_id" ORDER BY "surface" DESC) AS rnk
FROM "testBadaBing"
) AS x
WHERE rnk <= 10
Now I'd like to…
stanichou
- 3
- 1
0
votes
0 answers
Equal distance between points in spatial SQL query with limit
I have an application which displays POIs on a map. I have a database with all the POIs in it using Spatialite which I query to find POIs within the viewable map area.
Performance is fine with small-medium numbers of POIs (up to 1000 works…
old greg
- 799
- 8
- 19
0
votes
2 answers
asp.net core 3.1 sqlite The specified module could not be found
I'm having some troubles with loading the mod_spatialite extension in sqlite in an ASP.NET Core 3.1 application. When I run the code below I get the following error: "SQL logic error The specified module could not be found."
string dbFile =…
RogierBa
- 45
- 2
- 7
0
votes
0 answers
How to ST_contains two gis layers (lines and polygon) and updatelines with spatialite-gui
I'm a biginner of spatialite-gui.
I have 300,000 lines and one polygon, this polygon contains some of the lines.
So, I tried to use function (ST_contains) to add a flag (999) to the target lines and update them. But I can't do it well. I would be…
Yas
- 1
- 1
0
votes
0 answers
Building spatialite into Qt QSqlDatabase driver
I am building a cross platform application that includes a mapping element. I want to use sqlite3 + spatialite as the storage engine and access it via the QSqlDatabase driver
It needs to be distributable as a single package without any install…
CitizenFish
- 312
- 2
- 13
0
votes
0 answers
Can a "points inside single geometry" query be sped up using a spatial index?
I am using SpatiaLite (or rather, its WebAssembly port SpatiaSQL.js) in a web application.
A use-case in this application is that the user wants to query point geometries (>500k of them, anywhere in the world) against a single (multi-)polygon…
Sander Vocke
- 125
- 5
0
votes
1 answer
How to fix the GeoDjango Tutorial?
I'm trying to do the GeoDjango Tutorial using Sqlite as described here.
When I call the load.py script it stops showing the error:
Failed to save the feature (id: 206) into the model with the keyword arguments:
{'fips': 'UK', 'iso2': 'GB', 'iso3':…
Memória de Cálculo
- 198
- 1
- 7
0
votes
2 answers
Symmetricds support spatialite database?
How can I configure the symmetric db engine to replicate a SpatiaLite database ?
If there are no way what's the steps to add a new platform to symmetric db?
hnqoliveira
- 113
- 1
- 1
- 7
0
votes
0 answers
Using Spatialite library on Libgdx android project give "Couldn't load shared library 'gdx' for target: Linux, 32-bit" error
I've developed an application using Libgdx game engine to show features from a shapefile layer. In order to get the geometry of features, I've used Sevar83 a ported Spatilite database for Android which my shapefile inserted in it. The following is…
Nasser Tahani
- 725
- 12
- 33
0
votes
2 answers
SQL: simple summation query with join to 2 other tables
I have 3 tables in sqlite as follows:
Table 1
ID | x
1, 2.0
2, 3.0
3, 4.0
4, 3.0
Table 2
join_ID | x
1, 5.0
1, 6.0
2, 5.0
2, 2.0
3, 2.0
4, 2.0
Table 3
join_ID | x
4, 5.0
1, 6.0
3, 5.0
2, 2.0
2, 2.0
1, 2.0
I would like to obtain a table as…
user32882
- 5,094
- 5
- 43
- 82