0
votes
0answers
13 views

QT designer form default text ignored in QGIS when used with sqlite db

I'd like to populate a table with a custom form, for which I'd like some default text to be set when opening the dialog. I have two columns ('Name' and 'Description'), each with text that should be ...
1
vote
2answers
89 views

TatukGIS SQLite Spatial vs. Spatialite

I must apologize in advance, I'm just getting into GIS and trying to figure things out. I have an SQLite spatial database that I'm pretty sure was created in TatukGIS. I've tried to open it in QGIS ...
3
votes
2answers
140 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 ...
0
votes
0answers
25 views

Add Layer by attribut selection in QGIS SQLITE and make it viewable

I create a SQLite Database from an .osm.pbf and tried to create new layers from attribute selection using the QGIS DB-manager SQL-Window: `CREATE TABLE Siedlungen AS SELECT * FROM points WHERE (place ...
1
vote
1answer
40 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 ...
3
votes
0answers
71 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
248 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
55 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
1answer
76 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
93 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 ...
7
votes
2answers
366 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 ...
0
votes
1answer
246 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
0
votes
1answer
109 views

How to solve sqlite_rtree_geometry_callback error?

I have just installed qgis 1.8 and it show error message the procedure entry point sqlite3_rtree_geometry_callback could not be located in the dynamic link library sqlite3.dll How to fix ...
0
votes
1answer
243 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 ...
6
votes
1answer
605 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 ...
1
vote
1answer
108 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
3
votes
1answer
248 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
1answer
331 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 ...
1
vote
1answer
244 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 ...
2
votes
1answer
264 views

View HTML field data with QT4 browers as a QGIS Run Feature Action Tool

I've successfully populated a sqlite table with an HTML-encoded-table as a field attribute, and so there is literally a Table within a single field value in sqlite, for each record. This is going to ...
1
vote
1answer
299 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 ...
2
votes
1answer
126 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 ...
2
votes
1answer
713 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
3answers
1k views

How to read the GEOMETRY table inside a sqlite database

I'm working on an android app which should display some lineobjects stored in a sqlite database. This sqlite database is created through an export in QuantumGIS. My first question is it a real ...
2
votes
1answer
756 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, ...
4
votes
3answers
1k views

How do I add (and map) a non-spatial table to QGIS from SQLite?

I have an sqlite file from my Wigle Android app (wiglewifi.sqlite). It's not a spatial file, just tables with lat/lon and other data. I can add spatialite layers just fine, but cannot seem to find a ...