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
3
votes
1 answer

Spatialite Android (Transform and Distance)

I am working with SpatiaLite for Android from Gaia-SINS using this tutorial. I managed to create spatial database and it works fine. But I have problem getting distance between points (or any other geometry) in meters. I was searching the web, and…
Boban S.
  • 1,662
  • 13
  • 16
3
votes
0 answers

Is there Delphi support for GIS specialized databases?

Such as PostGIS and SpatiaLite? I am using AnyDac, which does not provide support. Are there any other components which can make life easier for me when working with such GIS enabled databses in Delphi? [Update] If not an you want one, then please…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
3
votes
3 answers

Spatialite for Android NDK Build

I am having a little trouble with build an existing project at: http://code.google.com/p/spatialite-android/ I am using Win7 and Cygwin I get the source code by cloning using "GIT for Windows". Placing it into: C:\temp\ECLIPSE\workspace\SA1 I…
Hank
  • 2,456
  • 3
  • 35
  • 83
3
votes
2 answers

Installation of Pyspatialite on Windows

I'm using pyspatialite on ubuntu with no problem—it's perfect. But Windows is giving me a total headache. I've been trying to solve this issue for at least three days. I'm using Visual Studio 2010 express with mingw (gcc) as the compiler. I…
rodion raskolnikov
  • 59
  • 2
  • 4
2
votes
2 answers

What unit does Spatialite's Distance() function return?

Spatialite has a the ability to calculate the distance between 2 geometries with it's Distance() function. There are other functions that work on LINESTRINGs. However I can't find out what units it returns it in. Is it metres? If I have 2 points,…
Amandasaurus
  • 58,203
  • 71
  • 188
  • 248
2
votes
2 answers

Python: SpatiaLite table to numpy recarray with datetime format?

I posted this question at the QGIS-user forum but it might be too technical, thus I take a chance and try here as well. My plan is to have a QGIS plugin that reads and plots time series data corresponding to selected points in a vector layer(the…
joskal
  • 31
  • 3
2
votes
1 answer

How to copy a Azure blob file to Azure local storage

I have a WCF service hosted in Azure. I have a spatialite database file I'm going to keep in Azure blob storage (1.1G). Compressed it is 500K. I would like to copy it to local storage when my service starts, and then use spatialite to run various…
Brad Boyce
  • 1,248
  • 1
  • 17
  • 34
2
votes
0 answers

Problems with GDAL, Libspatialite, Rasterio and Sumo (ImportError, Symbol _GEOSArea not found, Referencing from libspatialite.7.dylib)

I'm new to using gdal/libspatialite/rasterio/sumo and all the family of library and packages that is related to geographical, time and space. But I was just wondering what's this error here? Does anyone have experience with this error before? Have…
M. Fire
  • 117
  • 2
  • 6
2
votes
1 answer

Can't configure spatialite because it can't detect PROJ (libproj)

I need to install spatialite on my system and i am installing it from source i Got the source code as : wget https://www.gaia-gis.it/gaia-sins/libspatialite-sources/libspatialite-5.0.1.tar.gz (I have PROJ installed) then i am inside the…
Apoorva Shridhar
  • 147
  • 14
2
votes
2 answers

how to Convert X and Y to lat and long

I have a table called IK_TEMP and it contains columns called data, range . String sql = "SELECT DATA, RANGE FROM IK_TEMP"; try (Connection conn = this.connect(); Statement stmt = conn.createStatement(); …
JavaDev
  • 79
  • 1
  • 8
2
votes
1 answer

Getting GeoDjango working on RHEL

I'm working through dependency problems while installing GeoDjango dependencies on RHEL. I would love step-by-step instructions from anyone who has done this before. I'm transferring a working app from my Ubuntu development machine (where everything…
limscoder
  • 3,037
  • 2
  • 23
  • 37
2
votes
0 answers

Making a docker image that contains ogr compiled with modern spatialite

I'm trying to run an ogr2ogr command that requires a version of GDAL that is built with new enough SpatiaLite to have the ST_MakeValid function---from discussion groups, this seem to be 4.0+ However, the version of gdal in ubuntugis has what looks…
Mittenchops
  • 18,633
  • 33
  • 128
  • 246
2
votes
2 answers

spatialite backend for geoalchemy2 in Python

I'm trying to SQLITE/spatialite with geoalchemy2. It seems to be possible according that link. My problem comes I think from the custom engine. What I have so far: from flask_sqlalchemy import SQLAlchemy from geoalchemy2 import Geometry #and other…
Laurent R
  • 783
  • 1
  • 6
  • 25
2
votes
0 answers

Django:how to install Spatialite for django on windows 10

I am using the spatial database spatialite for a django project for the first time, I followed the Django documentation, when I reach the step that says " run the configure script" I don't konow how to run that script, and witch script exactly, is…
khadija.EL
  • 307
  • 5
  • 17
2
votes
2 answers

SQLITE: import data from a CSV

I need to import in a SQLITE database a CSV file that use both numbers than strings: here you a sample .. col_1|col_2|col_3 10|text2|http://www.google.com For the import I use Spatialite GUI because I've to manage also spatial data: all works fine…
Cesare
  • 1,629
  • 9
  • 30
  • 72
1 2 3
…
15 16