Vector Data Processing - Open Source Geospatial Tools: Applications in Earth Observation - page 47

This allows you to access any specific FDO-OGR Geometry as if it
where native SpatiaLite ones in a completely transparent way
=========================================================

Enter ".help" for instructions
spatialite>

To list the tables (including geometric tables), it suffices to type .tables (n.b.
you must start with the period):

spatialite> .tables

fdo_forest_select forest_select

→ spatial_ref_sys
fdo_subset_ile_de_france geometry_columns

→

subset_ile_de_france

To get a full list of columns in a table and their respective data types, you can use
the following command:

PRAGMA table_info(subset_ile_de_france)

0|OGC_FID|INTEGER|0||1
1|GEOMETRY|BLOB|0||0
2|osm_id|VARCHAR(80)|0||0
3|osm_way_id|VARCHAR(80)|0||0
4|name|VARCHAR(80)|0||0
5|type|VARCHAR(80)|0||0
6|aeroway|VARCHAR(80)|0||0
7|amenity|VARCHAR(80)|0||0
8|admin_leve|VARCHAR(80)|0||0

It is beyond the scope of this topic to provide a detailed explanation of SQLite and
Spatialite, as a thorough discussion of the topic wouldmerit a book in itself. However,
we feel that it is worthwhile to briefly outline some of the main functionalities that are
provided by Spatialite, which can be carried out directly using the Spatialite command
line. In addition to the standard SQL queries that can be performed on the database
based on the SQL92 Standard, from a geospatial perspective the real advantage of
Spatialite is the ability to use spatial functions. Some brief examples are presented
next, with a more in-depth look at these functions in the case study (Chap. 16 ) . For
example, if we want to initially return some basic information regarding the layers,
we can issue the following command:

spatialite> SELECT * FROM geometry_columns;
f_tale_name | f_geometry_column | geometry_type | coor_dimension
→ | srid | geometry_format
subset_ile_de_france|GEOMETRY|3|2|4326|WKB
forest_select|GEOMETRY|3|2|4326|WKB