Zen

Source string Source string

58/10000 · 58

The string is read only.

English Actions
SpatiaLite Quickstart
SpatiaLite is an SQLite database engine with spatial functions added.
SQLite is a Database Management System (DBMS) which is simple, robust, easy to use and very lightweight. Each SQLite database is simply a file. You can freely copy it, compress it, and port it between Windows, Linux, MacOs etc.
This Quick Start describes how to open a spatialite database from both GUI applications and the command line. Some sample SQL queries are shown.
Contents
Start Spatialite and load a database
Spatialite-gui provides a visual interface for viewing and maintaining a spatialite database. You can easily see the structure of the tables and data contents using point and click functions, many of which construct common SQL queries, or craft your own SQL queries.
Open the Spatialite GUI by selecting |menu_spatialite-gui|
Select :menuselection:`File->Connecting an existing SQLite DB`
Browse to the :file:`/home/user/data/spatialite` directory and choose :file:`trento.sqlite`.
Right click on the MunicipalHallsView table and select "Show Columns"
You will notice the display broken into 3 areas:
The left panel displays the database hierarchy, such as a list of tables, and columns within the table. Right click on elements of the left panel to select from a list of common database actions.
The top right panel shows SQL for the action selected. You can enter your own customised SQL into this panel.
The bottom right panel shows the results of the SQL query.
Right Click on the MunicipalHalls table and select "Edit table rows". Notice the SQL query which has been created for you in the top right pane, and results in the bottom right.::
Run an SQL query
Now let's try tweaking this SQL statement to get NOME and (Lat,Long) for only the NOME_PROV fields include "BRESCIA", this time using the MunicipalHallsView. In the upper right SQL pane type::
Click the "Execute SQL" button at the right, and see the results in the bottom right pane.
Run spatialite from the command line
Users needing to script or automate queries will learn the advantages of working with a spatialite database from the command line interface. In this example, we will load a shapefile, and search for schools which are near highway 42.
Before working from the command line, we need to open a terminal window: :menuselection:`System Tools -> LXTerminal`.
In the terminal open a sample database with **spatialite** by typing::

Loading…

User avatar None

String updated in the repository

  1. OSGeoLive
  2. spatialite_quickstart
  3. English
Open the Spatialite GUI by selecting |menu_spatialite-gui|
Open the Spatialite GUI by selecting |menu_spatialite-gui|
a year ago
Browse all string changes

Things to check

Long untranslated

The string has not been translated for a long time

Reset

Multiple failing checks

Following checks are failing:
Mismatched full stop: German, Spanish, French, Japanese, Italian

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
Source string location
../../build/doc/quickstart/spatialite_quickstart.rst:46
String age
a year ago
Last updated
8 months ago
Source string age
a year ago
Translation file
locale/pot/quickstart/spatialite_quickstart.pot, string 8