A self-contained SQL database engine.

learn more… | top users | synonyms

2
votes
1answer
938 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
0answers
28 views

Shapes & categories

I am very new to this so please only smile if a dumb question. I have divided the oceans into 31 regions. Each region has various sub regions, example I have region 08; of which it is further broken ...
2
votes
0answers
981 views

Sqlite insert java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: SRID)

I'm trying to connect to two DBs and then copy tables by inserting rows from one table to another through java using JDBC. I'm using sqlite-jdbc-3.7.2.jar plugin.The setup is in Eclipse Luna. I'm ...
2
votes
0answers
361 views

Performance issue with SQLite + Spatialite + C#

I am having a performance issue with SQLite database (.db) which extends to SPATIALITE I am trying to update Geometry of 1,00,000 records in database (.db) which taking around 50 minutes. Too much ...
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". ...
1
vote
1answer
759 views

Problem loading spatialite extension with sqlite3 Python connector

I am trying to load the Spaltialite extension using SQLite3 python module. I am getting the following error when I run my script. EOFError: [Errno 10054] An existing connection was forcibly closed ...
1
vote
2answers
314 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 ...
1
vote
1answer
116 views

spatialite : spatial index on geometries

I'm currently learning to use spatial access methods for query optimization. I'm going through the examples in spatialite cookbook and got stuck in here ...
1
vote
1answer
94 views

SQLite db with FDO geometries: how to assign ID of point in layer A to closest point in Layer B with SpatiaLite?

How can I assign ID of point in layer A to closest point in Layer B with SpatiaLite (find nearest neighbors for each point in A)? For each point stored in table fdo_fc1 I would like to select one, ...
1
vote
1answer
163 views

How to create temporary tables in spatialite?

How do you create a temporary table with geometry column in spatialite? I have tried: CREATE TEMP TABLE rivers (code INTEGER, id INTEGER, name TEXT); Followed by: SELECT ...
1
vote
1answer
98 views

SQLite database to Feature class

I am somewhat new to programming and the SQLite world. I am looking for a way to take data from and SQLite DB and populate feature classes. The feature classes are all polygons and the intent is to ...
1
vote
1answer
252 views

SQLite instead of gdb

I use ArcGIS and Qgis and I want to have common protocol and format of my files. To use a separate file for each program is not the best way, I don’t want to make a mess of data. I would ask if SQLite ...
1
vote
2answers
76 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
112 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 ...
1
vote
1answer
110 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
551 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, ...
1
vote
1answer
528 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 ...
1
vote
1answer
385 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 ...
1
vote
1answer
43 views

Compare and modify changes amongst GIS and MIS data

import arcpy import sqlite3 # the column names columnNames = ["ASSETNUM", "DESCRIPTIO", "INSERVICE", "ENGINEID"] data = [] with arcpy.da.SearchCursor(r'E:\mypathtoshp\Fire_Hydrants.shp', ...
1
vote
1answer
50 views

Export/Import Shp file records to sqlite table

I am new to python and ArcPy. I need to transfer all the records of a single shapefile to a table created in sqlite3 without the geometry. So far I was only able to retrieve the records using ...
1
vote
1answer
82 views

Get DE-9IM matrix in spatialite?

Is there a way to get the DE-9IM matrix between two geometries in a Spatialite function, analogous to the st_relate() function in PostGIS? (I find it very helpful to spatially join using intersect() ...
1
vote
2answers
168 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
2answers
285 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
3answers
398 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
110 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 ...
1
vote
1answer
236 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
1answer
776 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
549 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
515 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 ...
1
vote
1answer
630 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
95 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 ...
1
vote
0answers
34 views

Extract raster values to multipoint shapefile and write to new field using gdal/python [duplicate]

I have a raster with one band and I would like to query a set of overlying points (.shp) to determine how many points as well as which points points fall under a range of certain pixel values ...
1
vote
2answers
100 views

Registering a database on Arcgis with operating system authentication

I have a ArcGIS server and ArcMap on the same machine. I have a sql database that I have been using on ArcMap that I would like to register with the server for the purpose of publishing services. ...
1
vote
2answers
62 views

ogr2ogr unreadable dbf file header

I'm trying to convert Mapinfo tab file to ESRI shapefile using ogr2ogr either with sqlite dialect or without. When using sqlite dialect, ogr2ogr -overwrite -f "ESRI Shapefile" -dialect sqlite -sql ...
1
vote
0answers
92 views

Geoserver MBTiles plugins performance issues

I am using the latest stable 2.7.2 version of GeoServer and I am trying to play with the MBTiles plugin, I have installed also WPS plugin that is needed by the MBTiles one (otherwise I got error when ...
1
vote
0answers
112 views

Loading SQLite extensions in QGIS

I have an extension which can be loaded in SQLite using the load_extension function. It would be useful for me if I could load it in QGIS to use in queries made via Database Manager. The Python ...
1
vote
1answer
165 views

What is format of Natural Earth SQLite database GEOMETRY column?

I need to extract coordinates of polygon boundary points in order to draw a map in my application. Does anyone know what is format of "GEOMETRY" column in this database? It doesn't look like .SHP ...
1
vote
1answer
462 views

Looking for RMaps SQLite format details

Locus Maps and Rmaps Android maps support an offline sqlite Format called Rmaps. I am trying to find the format details and how its organized. I couldn't, is there any dependable documentation online? ...
1
vote
1answer
411 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 ...
1
vote
0answers
108 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
0answers
254 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
0answers
201 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 ...
0
votes
1answer
54 views

QGIS - what is the core database system? [closed]

What is the core database system used by QGIS? When you launch an existing project that has multiple .shp files (with associated .dbf tables), is the core db system used to convert that data to its ...
0
votes
1answer
201 views

ST_Intersect with ogr2ogr and Spatialite

I am trying to intersect Spatialite datasets with ogr2ogr, the OGR Virtual Format and SQL Syntax. I can't seem to locate whether the error is in my SQL query or my VRT file. Data ...
0
votes
1answer
189 views

PtDistWithin() with Geometry from query

I'm trying to run two Spatialite queries in Python — the first one picks a single point from a table, and the second tries to find all points that are within a given distance of it. So my queries look ...
0
votes
1answer
640 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.
0
votes
1answer
513 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
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)) ...
0
votes
1answer
81 views

Qgis 2.10 unable to add a new feature in spatialite via sql function “GeomFromText”

Using Python code in my plugin the function in sql language "GeomFromText(POINT(X Y))" gives the following error: "OperationalError: no such function: GeomFromText" Plugin functions in previous ...
0
votes
1answer
35 views

Pycsw Harvest SOS Error Exception

when I used the Harvest operation by the pycsw, and there was a Exception as the following picture: Picture 1: The Response of Harvest Operation Picture 2: The document default.cfg setting so how ...