spatialite Questions

4

Solved

I'm trying to run sqlite3 with spatialite but when i run $ python manage.py makemigrations im getting the error: django.core.exceptions.ImproperlyConfigured: Unable to load the SpatiaLite ...
Crus asked 19/7, 2018 at 14:56

2

Solved

I know that this has been asked in some similar ways before. However, all questions I found on this dealt with some very specific system setups which were not applicable for me (because so is mine)...
Seise asked 12/1, 2015 at 17:44

2

Solved

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.createSt...
Macias asked 25/5, 2020 at 4:13

1

I've implemented SupportSQLiteOpenHelper.Factory to open a spatialite database (sqlite with spatial functions). However when my queries use spatialite functions such as ST_AREA, Room complains that...
Thaddeusthaddus asked 22/10, 2018 at 15:29

2

Solved

I'm trying to get Spatialite to work with my django app, however, I've hit the following wall: raise ImproperlyConfigured('The pysqlite library does not support C extension loading. ' django.core...
Fillander asked 19/6, 2012 at 2:24

1

I installed spatialite for Django project but when I try to migrate it show me this error : File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/django/contrib/gis/d...
Kattie asked 3/12, 2019 at 12:45

4

Solved

I'm trying to open a .sqlite file on Windows, but I don't know how to. Do you know a good program for it? It contains data for statistical analysis, but I prefer having a .txt file. I also have a...
Gaal asked 24/9, 2014 at 11:24

3

I need to create and access a spatialite-extended SQLite database under x64 windows. I have downloaded the latest version 1.0.92.0 called sqlite-netFx45-static-binary-bundle-x64-2012-1.0.92.0.zip ...
Tradeswoman asked 26/3, 2014 at 16:56

1

I am attempting to use spatialite with both Python 2 and 3 on Windows 7. Rather than try to patch pyspatialite for Python 3, I decided to use the load_extension approach with sqlite3 Python built...
Ridotto asked 20/4, 2015 at 15:13

7

Solved

Has any of you had any experience with using NoSQL (non-relational) databases to store spatial data? Are there any potential benefits (speed, space, ...) of using such databases to hold data for, s...
Abaft asked 11/1, 2010 at 11:57

4

I am trying to use the Spatialite beta version 3.0 because I am using Windows 7 on a 64-bit machine. I consistently get the dreaded sqlite3.OperationalError: The specified module could not be foun...
Naranjo asked 21/12, 2011 at 13:31

1

Solved

I am creating a new table through a SQL query from a spatial table: CREATE TABLE SomeShapes AS SELECT ash.id, ash.Geometry FROM AllShapes ash WHERE ash.id = 30 However, this returns a "normal" ...
Calumniation asked 20/4, 2015 at 10:9

0

I have problems installing Spatialite tools on OS X Yosemite, first of all I have read Install Spatialite for python (GeoDjango) on OS X but it didn't help me to resolve the issue. Here I will pro...
Ezekielezell asked 17/3, 2015 at 21:16

3

Solved

I am tearing my hair out trying to install Spatialite for GeoDjango! I am already using Homebrew, it's generally easy and convenient so I initially tried to follow the Homebrew instructions for Ge...
Caprification asked 10/12, 2013 at 21:28

2

Solved

This one is related to spatilite also (not only SQLite) I have a file database (xyz.db) which I am using by SQLiteconnection (SQLiteconnection is extends to spatialite). I have so many records ne...
Durante asked 27/6, 2014 at 5:52

2

I'm very new with spatialite. I'm running on Max OS Mountain lion and I have installed SQLite version 3.7.17 and libspatialite 4.1.1 (using homebrew) I can load without error the extension libspat...
Jorum asked 20/7, 2013 at 10:9

1

Solved

I want to use Spatialite instead of plain SQLite with Xamarin on Android, to manage and display geographical data. Built-in SQLite does not allow to load extensions. How can I do it?
Morell asked 6/12, 2013 at 8:33

4

Solved

I am new here and this is my first topic. I am very new on iOS platform and i am trying to use spatialiate extension with sqlite3 but i couldn't do this. It is making me crazy. I don't know how and...
Jook asked 25/1, 2011 at 13:18

0

I'm following the GeoDjango Tutorial to set up a dev spatial DB for my project on my home machine, a Mac Mini running OSX 10.8.2. I installed the KyngChaos packages (UnixImageIO, PROJ, GEOS, SQLite...
Replenish asked 15/1, 2013 at 2:8

4

Solved

I'm attempting to build a copy of sqlite with spatialite extensions. I've seen the one or two related posts online related to this issue, but no one seems to have gone all the way. I've downloaded...
Debit asked 28/2, 2011 at 17:32

2

Solved

I'm trying to access a SpatiaLite from C# using System.Data.SQLite provider. When I try to load the SpatiaLite extension, I always get the System.Data.SQLite.SQLiteException: SQLite error The spe...
Architect asked 12/10, 2009 at 19:29

2

I continue to have problems setting up a GeoDjango installation that uses Spatialite as a backend on a Windows machine. I used the GeoDjango installer and downloaded the precompiled libraries from...
Dubai asked 25/11, 2009 at 23:11
1

© 2022 - 2024 — McMap. All rights reserved.