-
Notifications
You must be signed in to change notification settings - Fork 2
Home
mj10777 edited this page Oct 26, 2018
·
54 revisions
Welcome to the Spatialite-Tasks-with-Sql-Scripts wiki!
- Goals:
- Expand on the Sql-Syntax used with Spatialite
- specially with the 0-base and 1-based parameters
- Completion of specific Tasks using a combination of different commands
- Use of Sql-Scripts build Databases with Geometries
- Creation of Spatial-Views
- Expand on the Sql-Syntax used with Spatialite
Most of these sample are based on experiences during an ongoing project
- therefore will be updated often
-
Commands
:
-
Themes
:- 'cause(es) of a ST_Collect(LINESTRING) not creating a valid POLYGON?'
- 'difference in the usage of ST_Collect(LINESTRING) and ST_LineMerge(ST_Collect(LINESTRING))'
- 'using ST_LineMerge and ST_Intersection to rebuild 2 LINESTRINGs'
- 'using a
:memory:
db in sql scripts' -
'using ST_Line_Substring to retrieve center of a LINESTRING'
- with a sample for
MULTILINESTRING
s
- with a sample for
-
'using VirtualText to import csv files'
- with a sample for
MULTILINESTRING
s
- with a sample for
-
SpatialView Themes
: -
RasterLite2 Themes
: -
GeoPackage Themes (R10)
: -
Spatialite Network Tools
: -
Spatialite Importing Shapefiles
:
-
Database Designing Themes
:
-
geopaparazzi-specific
:- 'Changes in geopaparazzi spatialite support '
-
'Sql used to retrieve Spatialite Geometries'
- the sql shown can be used to test the validity of the Database that are to be used with
geopaparazzi
- these can be used in
spatialite_gui
- these can be used in
- 'Description of the record returned'
- the sql shown can be used to test the validity of the Database that are to be used with
2017-03-30: Mark Johnson, Berlin Germany