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
1
vote
0 answers

read sqlite geographic blob without spatialite

I'm using sqlalchemy for a mostly non geographic database, queried and populated using a desktop program that knows nothing of geometries. I'm now slowly adding geographic awareness to it and I'm going to write a separate program, I'm not going to…
mariotomo
  • 9,438
  • 8
  • 47
  • 66
1
vote
1 answer

Insert geometry on spatialite always insert null C#

I'm trying to insert a geometry (POINT, LINE, POLYGON) into a table in a sqlite DB (spatialite), all the code run OK but at time to see the rows, the column of geometry always is NULL. The info in the DB after INSERT. How it should be: The…
RaZoDiuM
  • 203
  • 1
  • 10
1
vote
1 answer

GeoDjango distance query with srid 4326 returns 'SpatiaLite does not support distance queries on geometry fields with a geodetic coordinate system.'

I'm trying to fetch nearby kitchens, within 4 km radius from a given lat/long. My spatial backend is spatialite and settings are, INSTALLED_APPS = ( 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', …
Dev
  • 33
  • 1
  • 6
1
vote
1 answer

Creating a view for SpatiaLite in GeoServer

I can create SpatiaLite layers from SpatiaLite tables. However, I would like to create a layer based on a SpatiaLite view. I click on "Configure new Sql View" from the "New Layer" screen. Then I am able to create the sql view. However, after I…
Robert Smith
  • 779
  • 1
  • 10
  • 28
1
vote
1 answer

SpatiaLite: RTreeDistWithin for multidimensional data

RTreeDistWithin( x Double precision , y Double precision , radius Double precision ) This function retrieves from an R*Tree Spatial Index any entity whose MBR intersect the square circumscribed on the given circle. Is there any analog for 3 and…
MyName
  • 357
  • 2
  • 4
  • 15
1
vote
0 answers

Using st_geomfromtext in spatialite

I am using the command line of spatiallite.exe version 4.2.0 and have a datatable that I have imported with latitude and longitude in WGS84. The data are more or less the following: [Study_ID] [StationNumber] [Latitude] [Longitude] …
Sanjay Advani
  • 103
  • 1
  • 6
1
vote
1 answer

How to get the long/lat information from a NodeID and vice versa

In the SpatiaLite website they explain how to use .osm data to create a SpatiaLite database, that contains a single table, where each row is an arc of the road graph. Then, they explain the procedure of calculating the shortest path from A to B in…
dimitris93
  • 4,155
  • 11
  • 50
  • 86
1
vote
0 answers

greenDAO: abstracting out the database implementation

I want to use my own custom SQLiteDatabase implementation in greenDAO based on something very similar to sqlcipher. I've seen a newly committed branch "DbAbstraction" of greenDAO. This exactly what I need. I am asking the authors: Is there some plan…
WindRider
  • 11,958
  • 6
  • 50
  • 57
1
vote
1 answer

SQL/SpatiaLite: Combining two tables containing some identical rows and keeping some nonidentical ones

I need to combine two tables. Both of them have three column names that match and some other ones. The data doesn't match. I'm not trying to do a join on the values - the best I could describe this would be selective appending. I tried union but…
MapEngine
  • 553
  • 1
  • 9
  • 21
1
vote
0 answers

SQL (SpatiaLite) - Multiple multi-criteria left joins with data from a select query

What I want to do (see Image below for help): 1) create a list with unique keys from two lists 2) use that new list to select red sub-squares from the black area (think of the red square clusters as areas with their own area_key) 3) now join data…
MapEngine
  • 553
  • 1
  • 9
  • 21
1
vote
1 answer

Spatialite cocoapod doesn't install correclty

I've made new Xcode project with a template. I have a pod file that only asks for the 'spatialite/core' pod (which is dependent on the sqlite3 pod. I run 'pod install --verbose', and I get this: Analyzing dependencies Updating spec…
Tom Verbeure
  • 232
  • 2
  • 8
1
vote
0 answers

What replaces SQLServer SQLGeometryBuilder for Windows store apps

Porting Visual Studio 2008 C# application to Visual Studio 2013, Windows 8.1 store\phone app (need to include a DB with the application). What DB to use (coding in c#), to replace this code... private static double GetArea(SurveySegment[]…
Lou
  • 137
  • 2
  • 11
1
vote
1 answer

Django + SpatiaLite + srid + distance queries

I am trying to do simple geodjango app, which contains list of shops, and when you put an address in it it returns closest shops to your location. I am following tutorial which used PostgreSQL and Postgis, but I want to use SQLite and SpatiaLite (I…
ajgoralczyk
  • 35
  • 1
  • 10
1
vote
1 answer

Why is spatialite returning incorrect total_changes() - when I'm making NO row changes?

You can read about total_changes() here: https://www.sqlite.org/lang_corefunc.html I saw the issue while using a python interface to spatialite (pyspatialite) but can reproduce the issue with the windows spatialite.exe. Notice how spatialite.exe…
ab 16
  • 327
  • 2
  • 11
1
vote
0 answers

Spatialite for iOS

in a past few days, I've been trying to use Spatialite with iOS. I have tried many things, but none of them worked. I have made best progress with SpatialDBKit, but it always fails when I run the application (with example from SpatilDBKit webpage)…
Tomáš Černý
  • 41
  • 1
  • 3
1 2 3
…
15 16