A self-contained SQL database engine.
0
votes
1answer
11 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 ...
0
votes
1answer
21 views
Can't build x64 SQLite with spatiaLite
I need a spatial-enabled SQLite solution for a x64 Windows application I am developing.
I have examined and downloaded and attempted to compile the SQLite amalgamation package; I've looked at the ...
3
votes
0answers
30 views
Why does the QgsVectorFileWriter have probelms creating vector files?
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 ...
0
votes
0answers
7 views
How to upgrade php version for mapguide server
I am using mapguide server 2.0 . It has PHP version 5.0.I want to use sqlite database3 but it doesn't support sqlite3. Does any one know how to upgarde php version manually? or way to convert sqlite3 ...
2
votes
2answers
187 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
37 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 ...
1
vote
1answer
43 views
Create Buffer in meters Spatialite query
I am new to Spatialite. I have following query:
select A.*
from linka as A, pointa as B
where Contains(Buffer(B.Geometry, 100), A.Geometry)
Here,
A.Geometry = LINESTRING(23.2161 69.95237, ...
0
votes
0answers
40 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")
...
3
votes
2answers
163 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 ...
4
votes
1answer
133 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 ...
0
votes
1answer
64 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.
1
vote
1answer
80 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 ...
1
vote
2answers
56 views
How to update polygon longitude if negative?
I have a polygon, with longitude in [-180, 180], with 2 parts around the dateline.
I want to make a map centered on the date line.
My plane is to:
1./ update the longitude, so that if lon < 0 , ...
1
vote
1answer
149 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
83 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 ...
0
votes
0answers
114 views
Compiling MySQL and Sqlite drivers for GDAL/OGR 1.10.1
IF YOU WANT SHORT QUESTION GOTO QUESTION SECTION
I have builded GDAL 1.10.1 with the instructions in BuildingOnWindow. By the default OGR drivers dont support MySQL, PostgreSQL/PostGIS, Sqlite, ESRI ...
7
votes
2answers
236 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
1answer
68 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
0answers
69 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 ...
1
vote
1answer
179 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
3answers
152 views
How to create efficient database for routing?
I created a database of many important features and locations of my city, and I want to find shortest/fastest path between two locations. Now, I'm calculating the route by using A* algorithm in Java ...
1
vote
1answer
163 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 ...
0
votes
0answers
71 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 ...
4
votes
3answers
353 views
How to merge close points into polygon?
I have a set of coordinates (points & no overlaps) in a single table,each containing attribute number fields,like in the following image.
I want to merge these points into smallest polygons by ...
1
vote
1answer
62 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 ...
0
votes
1answer
153 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
8
votes
1answer
447 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
1answer
87 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
159 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 ...
0
votes
1answer
204 views
SQL Data: How to draw circles with a radius based on lat/long data in DB
I have a . sqlite file with many columns, two of those columns being lat and long.
I've been searching around for a bit now (don't think I want to be using BuildCircleMbr from spatialite?) but I'm ...
5
votes
1answer
452 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
94 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
60 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 ...
1
vote
1answer
341 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 ...
3
votes
1answer
179 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
109 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
301 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 ...
0
votes
1answer
364 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' ...
1
vote
1answer
209 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
418 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
214 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
240 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
74 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 ...
2
votes
3answers
489 views
Ogr2Ogr SQLite Geometry Functions
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
103 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
112 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
49 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
747 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))
...
4
votes
2answers
247 views
How to remove redundant points
We basically have points table including vehicle routes.In huge traffic conditions,devices collecting data on route may output redundant points where at any coordinate same points may repeat.We can ...
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".
...
