A self-contained SQL database engine.

learn more… | top users | synonyms

3
votes
2answers
216 views

Combining MS Office with GIS

I would like to incorporate MS Office into my GIS program. I have been using QGIS and was wondering if this would be possible? I am trying to create a one stop shop for my staff to be able to ...
5
votes
3answers
1k views

Sqlite, Python 2.7 and Spatialite

I am trying to spatially enable my sqlite database: import sqlite3 db = r'c:\temp\mydata.sqlite' conn = sqlite3.connect(db) conn.enable_load_extension(True) cur = conn.cursor() cur.execute(r"SELECT ...
1
vote
2answers
54 views

geos_ts_c.cpp + spatialite Error

select distance(T1.Geom,T2.Geom) as Distance, T1.POI_ID, T2.LINK_ID from temp1 as T1, temp2 as T2 where T1.POI_ID = T2.POI_ID AND Distance < 100 temp1 having point geometry temp2 having line ...
1
vote
1answer
91 views

Unable to select FLOAT precision when adding column

I'm trying to do the lessons in the training-manual at qgis.org. I,m having some problems with 3.3 Ratio Classification ...
0
votes
1answer
121 views

Can SpatiaLite Indexes be used from views?

I'm working with a large SpatiaLite database and trying to take advantage of some spatial indexes I have on my tables that I'm attempting to access through views. Essentially, I have a number of ...
3
votes
1answer
116 views

Field calculator uses wrong fields when working with joined data

I am having an issue in qgis table joins. i have a joined a csv file to a sqlite database and common id is used for join. the join is displays correctly in attribute table. the attributes in sqlite ...
4
votes
1answer
809 views

How to load Spatialite extension via SQLite3 ODBC Driver?

I am having trouble getting the Spatialite extension to load as part of the SQLite3 ODBC driver...[aka the joys of making software somewhat spatial when it tries so hard not to be]. What works ...
3
votes
0answers
382 views

Why does the QgsVectorFileWriter have probelms creating vector files? [closed]

I am using QGis 2.0.1 and have tried to create a new GIS feature file (SQLite, Spatialite, and Shapefile) of a subset of the data. I am then saving a copy of the style of this layer and applying it to ...
2
votes
2answers
670 views

Is there a way for multiple users to use an SQLite/SpatiaLite db simultaneously?

Is there a way that multiple users can use the SQLite / SpatiaLite database simultaneously? Thank you for your feedback.
1
vote
1answer
96 views

naturalearth sqlite db not loading into qgis 2.2 [duplicate]

I downloaded the naturalearthdatabase in sqlite-format (http://www.naturalearthdata.com/downloads/, the downloadlink goes to http://kelso.it/x/nesqlite), but qgis 2.2 (running under win 7 64bit) does ...
0
votes
0answers
134 views

Spatialite not available from qgis python console

I have a problem using pyspatialite from within the qgis python console. When I run the following code in ipython from pyspatialite import dbapi2 as sqlite conn=sqlite.connect("MyDB.sqlite") ...
0
votes
1answer
557 views

Need help installing QGIS 2.0 Need GDAL then SQLite3 3.7.16

OSX 10.7.5 I need help installing QGIS 2.0 It says I then need GDAL. When I try to install GDAL it says SQLite3 3.7.16 or newer framework is required. I can't find SQLite3 3.7.16.
3
votes
1answer
495 views

pyspatialite: Connot insert geometry

I'd like to insert a row with a point geometry with pyspatialite. The sql looks like this: insert into eqdata(origin_time, url, mag, lat, lon, depth, m_a, region, mt, the_geom) ...
2
votes
1answer
1k views

Trying to install SpatiaLite 4.3 with SQLite 3.8 on Windows 7

I'm new to the open-source GIS database world, and am trying to have SpatiaLite installed on my Windows 7 machine. I downloaded SQLite 3.8.2 and unpacked the 3 files in a newly created folder ...
1
vote
2answers
230 views

sqlite version error with ogr2ogr

I am trying to randomly select some points from a shape file using ogr2ogr and an SQL query via sqlite but it seems to baulk at the sqlite version: ogr2ogr -sql "SELECT * FROM probe_2004to2012 WHERE ...
1
vote
1answer
408 views

Multiple input shapefiles for ogr2ogr sqlite spatial operations

I'm running up against an issue doing a spatial operation requiring multiple input shapefiles using ogr2ogr and sqlite. I have: ogr2ogr -f "ESRI Shapefile" output.shp input.shp -dialect sqlite -sql ...
7
votes
2answers
752 views

How do I use the Natural Earth SQLite DB with QGIS?

I just downloaded the Natural Earth data in SQLite format from http://www.naturalearthdata.com/downloads/. I had assumed that this would be a SpatiaLite database, but it appears not to be! QGIS is ...
3
votes
0answers
154 views

What is a good way to retrieve geographic data along with imgs and mp3 files?

I'm working in the Django backend of an audio guide for tourism with mobile devices. Basically, the client (Phonegap app for Android and iOS) can follow a route over a map (Leaflet client) and see ...
4
votes
1answer
795 views

special python library needed for spatialite?

It appears that pyspatialite is very outdated. Do I need a special library like pyspatialite in order to use the spatial functions of spatialite? Or can I just connect to the database via the normal ...
1
vote
1answer
95 views

Saving a subset of a database

Here is a complete beginner´s question, maybe someone has time to help: I just downloaded the Corine land cover sqlite file, the whole database has 5.5 GB and takes forever to open. How can I save a ...
8
votes
1answer
1k views

Is SpatiaLite or SQLite Spatial an Accepted Standard?

The reason why I ask this is because I have been undertaking some testing and have found that there seems to be many implementation and not all of them are interchangeable. For example: FME can read ...
8
votes
1answer
1k views

Is Read Only nature of SQLite support in ArcGIS for Desktop 10.2 documented?

I've recently started creating SQLite geodatabases using ArcGIS for Desktop 10.2 with both ST_GEOMETRY and SPATIALITE storage data types and was impressed by how easy this was to do. I then tried to ...
0
votes
0answers
118 views

How to specify the version of output SQLite database in ogr2ogr?

I'm having issues with a .sqlite database that I generate from PostGIS using ogr2ogr. The data appears to export into SQLite properly, and it loads in TileMill fine, but when I try to add any of the ...
0
votes
1answer
477 views

What does Error [sqlite3_rtree_geometry_callback is not found] mean in qgis 1.8 with windows 7 64 bit? [closed]

qgis1.8 does not open. I get a message that sqlite3_rtree_geometry_callback is not found
2
votes
2answers
1k views

Export from PostGIS to SpatiaLite?

My PostGIS database contains OSM data from my country. For transportation reasons I want to export a spatial view I created from that data to a SpatiaLite database. Is there any way to directly ...
0
votes
1answer
547 views

Is it possible to override autoincrementing keys when QGIS inserts into SQLite?

I have a table, without any geometry, loaded in QGIS 1.8.0 (from OSGeo4W) via the Add Vector Layer option. The table resides in a SQLite/SpatiaLite database, and has a field named "id" that was ...
1
vote
1answer
651 views

Why doesn't SQL sum(dollar) work in SQLITE?

I've got a sqlite table with real numbers, two decimal place precision, in a mydollar_column. (There are no null values, but some of the values are negative numbers) For some reason, using sql on ...
1
vote
1answer
187 views

What does “Computed -srcwin falls outside raster size” mean when clipping?

What does this mean, when I try to clip and save the result as a sqlite or other format please? "Computed -srcwin falls outside raster size of 7807x4771" cheers, Bruce
1
vote
0answers
97 views

OGR Error : Silly size requested

I'm scripting OGR functionality in order to filter some mapinfo tables and convert them into sqlite files. ogr2ogr -f "SQLITE" newtest.sqlite test.tab -sql "SELECT cols FROM test WHERE .." where ...
3
votes
1answer
520 views

Why is Spatialite showing dates in MM-DD-YYYY format?

I have a table with a dates column that is formatted in MM-DD-YYYY format, as shown in SQL SELECT statements. I'm using Qspatilite (QGIS 1.8) and Spatialite GUI. When I ORDER BY the date column it ...
1
vote
0answers
233 views

Adding multiple layers to Tilemill from a single sqlite DB

This is a repost of a question I had over at the MapBox support board. Since I wasn't having much luck over there, I'm hoping I would have better success here. I'm having trouble adding more than a ...
1
vote
1answer
474 views

spatialite.dll with Python and QGIS - the specified module could not be found

I'm having a bit of a nightmare getting to the bottom of this DLL loading problem. The stand alone script works absolutely fine but the exact same code does not work within QGIS. import sys from ...
3
votes
1answer
122 views

python sqlite giving errors

I have python code that I am executing but it gives me following error: <sqlite3.Cursor object at 0x7f3c7666dc00> when I execute the cur.execute(statement). the code that is below the ...
1
vote
1answer
462 views

How to save a joined spatialite table when each table contains PKUID fields?

QGIS 1.8.0 -- QSpatialite 6.0.7 -- Windows XP I have spatialite tables joined together that I need to save as a single table, but an error-message says that QGIS can't save the table because there ...
0
votes
1answer
595 views

OGR OSM-driver unable to open datasource

I want to read an OSM file with OGR. I use Version GDAL 1.9.1, released 2012/05/15. To read a SQLITE file works fine: $ ogrinfo test.sqlite INFO: Open of `test.sqlite' using driver `SQLite' ...
2
votes
1answer
897 views

How to build Android spatialite?

I have been trying to build spatialite for Android for a few days now without success. I have even tried the recent documentation from the Google project page here: ...
1
vote
1answer
512 views

How can a HTML table be stored within a database field as a BLOB, text or other value?

My Spatialite database has several thousand spatial polygon records In QGIS, each with a couple dozen field values. I also have many thousands more of additional tabular data relevant to those ...
1
vote
1answer
91 views

MapInfo TEXT in SQLite

I´m trying to add a TAB-file containing text-objects to a SQLIte database. I´ve already added points, lines and polygons, but when I try to add texts I get an error - something about an erroneous ...
0
votes
3answers
2k views

Why is SQLite python command not working?

I am fairly new to python and am writing a code to read imagery and insert them into an SQLite database but I get the following error cur.execute(statement, (index,fullpath,filename)) ...
1
vote
1answer
319 views

sqlite replace values

i have a table with two columns: one named index and the other is called tilenumber and the tilenumber is populated from the index column except that there is _ which needs to be removed from the ...
0
votes
1answer
62 views

SQLite and joins [duplicate]

Possible Duplicate: sqlite replace values I have one table in sqlite called images and it contains a column named "index" and i have created another column which is empty and is named ...
2
votes
0answers
97 views

QGIS 1.8.0 does not launch [duplicate]

I Installed the 1.8.0v on Win7 profesional SP1 system (as administrator) and I take this message: "The procedure entry point sqlite3_open_v2 could not be lovated in the dynamic library sqlite3.dll". ...
2
votes
1answer
990 views

How to fix The procedure entry point squlites3_open_v2 could not be located in the dynamic link library squlite3.dll? [duplicate]

Possible Duplicate: How to fix QGIS error “Entry Point could not be located”? I downloaded QGIS to my laptop (Window 7 64b) yesterday but when I click on the desktop logo I get the ...
4
votes
1answer
164 views

Is it possible to have a single foreign key column referenced to two or more different tables?

In Spatialite (3.0.1), having a normal (non-spatial) table, I would like to relate it to two different spatial tables, with different geometries types (multipolygons and polylines), using the same ...
2
votes
1answer
195 views

Qspatialite plugin problems with queries using inner join

I'm trying to create a layer in QGIS from a sqlite database using a query from 2 tables: one has spatial data and the other doesn't. When I build the query using Qspatialite using the 'Advance SQL ...
0
votes
1answer
1k views

Finding nearest point in SpatiaLite without GEOS

I want to find the nearest point having latitude and longitude stored as Point in SpatiaLite. I read this and it has this example: SELECT feature_name, feature_class, ST_Distance(Geometry, ...
5
votes
1answer
2k views

Help importing osm data into spatialite

I am trying to import OSM data into Spatialite. The data is a query from overpass called features.osm I'm using spatialite 3.0, and following examples, I have created a new database with: $ ...
2
votes
1answer
1k views

How to use SQLite db with QGIS plugin?

Hi I would like to use SQLite for storing some information in my plugin for QGIS. I have a problem: if I put the db let say test.db among the resources as file, after compilied the resorce.qrc file, ...
3
votes
1answer
902 views

Interpolate undulations for given points using a geoid model

I have two databases, the first one (F.tsj) contains gps points: coordinates and ellipsoid heights and the second one is simply a geoid model where every line stores latitude, longitude, and ...
2
votes
1answer
873 views

integrating spatialite and php (sqlite3) on windows platform

anyone can give me an explanation about how to integrate spatialite with php(sqlite3)-windows platforms. I have tried to refer from this link ...