A self-contained SQL database engine.

learn more… | top users | synonyms

1
vote
1answer
568 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
1k 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: ...
2
votes
1answer
524 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
664 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
96 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 ...
3
votes
3answers
2k views

Why are ogr2ogr SQLite geometry functions not available in command line?

I believe title is all clear.I'm using Ogr2ogr utilities & binaries to read geometry. I used something like this: ogr2ogr -f "SQLite" test2.sqlite test.sqlite -sql "SELECT ...
3
votes
1answer
126 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
427 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
65 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 ...
0
votes
3answers
3k 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)) ...
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". ...
4
votes
1answer
227 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
213 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
1k 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 ...
1
vote
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, ...
9
votes
2answers
2k views

Processing SQLite files using ArcGIS Desktop?

I'm using qgis and grass for my work. I've produced a shapefile which is over 100mbs (s a result of some statistical analysis). If i convert it to sqlite format (spatially enabled) the data shrinks ...
3
votes
2answers
2k 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 ...
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: $ ...
4
votes
3answers
3k 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
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, ...
6
votes
4answers
2k 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 ...
3
votes
1answer
1k 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 ...
1
vote
0answers
205 views

How to retrieve the value of a cell in RasterLite?

Just wanting to know the SQL statement needed to find out the pixel value for a location, when the raster is loaded into SpatialLite as a Raster? I loaded the Raster using rasterlite_load -d ...
2
votes
2answers
1k views

How to combine MapInfo tab files into one spatialite DB?

I have many folders, each with a collection of MapInfo tab files (each folder has the same table names). For each folder I want to merge the tab files into one spatialite DB. My current method is to ...
2
votes
1answer
982 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 ...
2
votes
1answer
1k views

Queries on virtual network in Spatialite only make errors

I've installed Spatialite 2.4 in Ubuntu. I try to convert an osm file into a roads network using this tutorial and make searches on it, but the queries only produce "no column" errors. $ ...
9
votes
5answers
3k views

How do I serve data in a sqlite database on a shared web host, like GoDaddy, onto a GIS web map?

I am new to the web mapping arena. I currently am managing a website and would like to add a mapping portion to it, mostly for some simple viewing and querying of a small number of layers. For ...
15
votes
2answers
3k views

How to turn sqlite lat/lon columns to spatialite geometry?

I have a sqlite database with a table that has a column for longitude and one for latitude. Is there a way to make this data base 'spatial'?
2
votes
2answers
569 views

ArcObjects table views or SQLite3 in Python?

Given a larger csv (1000+ points) with attributes, I need to do both attribute and spatial queries on the data. Would it be faster to read the points into an xy feature class, and do the spatial and ...