Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sqlite
Search options answers only
not deleted
user 93656
A self-contained SQL database engine.
11
votes
Accepted
CREATE TABLE AS with geometry in SpatiaLite
SpatiaLite requires you to explicitly register geometry columns in its ecosystem (updating metadata, adding triggers) using the provided management functions; SQLite does not support automatic detection …
- 30.9k
1
vote
Creating geodatabase using QGIS
countless specialized ST functions ('Spatial Type')
but you will need to invest in setup, maintenance and, most of all, knowledge (about plenty of other things than the actual GIS parts)
A Geopackage is a SQLite … have access to most ST functions to process it
but the underlying DB has performance limits for very large datasets
Consider PostgreSQL/PostGIS as (part of) a backend architecture, and Geopackage/SQLite …
- 30.9k
4
votes
Accepted
Virtual-Layer/SQL-View: SQL to get list of all values in a group (SpatiaLite/GeoPackage)
Note:
With SQLite and GROUP_CONCAT, you have to use a sub-query if you also specify a custom_delimiter, as with DISTINCT it will fail with
DISTINCT aggregates must have exactly one argument …
- 30.9k
2
votes
Accepted
How to export geometry as a table in QGIS
It´s a bit puzzling to me why any software would require a fixed space delimited format as input...but anyway, AFAIK within QGIS your options are limited since both 'Save as...' -> CSV and the MMQGIS …
- 30.9k
3
votes
Better control cascading triggers in SQLite
Do not allow duplicates on the main table ESPECES_PT in the first place; just add a BEFORE INSERT trigger.
Not sure, but it sounds like with better sanitizing there is a chance that you may be able t …
- 30.9k