SpatiaLite Cookbook : Spatialite Tools

general: (overview)

• spatialite : a complete CLI front-end, more or less equivalent to the well known sqlite3 front-end, but fully supporting SpatiaLite
• spatialite_tool : a tool supporting import/export of Shapefiles and DBF-files
• shp_doctor : a diagnostic tool to check anomalous shapefiles
• spatialite_dxf : a tool importing DXF files
• spatialite_gml : a tool importing GML files
• exif_loader : an import tool for EXIF or EXIF-GPS (JPEG) pictures

Spatiallite Convert (since Spatialite 4.0.0)

For a general introduction of this tool, visit the main Wiki-Pages:
  The spatialite_convert CLI tool

a tool converting DB-files from different versions of SpatiaLite

Spatiallite DEM: (since Spatialite 5.0.0)

Topics of the main Wiki-Pages: spatialite_dem - Introduction

• Create a Dem-Database from 1 or more xyz-files
• Query of Dem-Database (-fetch_yx)
• Configuration of default Dem-Database to use and default srid for queries
• Updating a Database SpatialTables with Z-Values from Dem-Database (-updatez)
• Sample Photos
• Sample Points
• Sql used to create the sample points
• Screenshot showing the test points (Scale 1:15)
• Screenshot showing the test points (Scale 1:100)
• Determin if DEM-Points reflect the heights of buildings or ground level
• spatialite_dem --save_conf
• spatialite_dem --help

OMS tools: (overview)

The main Wiki-Pages: OMS tools Few basics you must absolutely know about OSM datasets

• spatialite_osm_map : To parse a whole OSM dataset, to create a corresponding SpatiaLite's DB-file.
• spatialite_osm_raw : To parse a whole OSM dataset, to create a corresponding SpatiaLite's DB-file, fully preserving the original OSM data model.
• spatialite_osm_filter : Create a OSM dataset, from a corresponding SpatiaLite's DB-file, created from spatialite_osm_raw
• spatialite_osm_net : To parse a whole OSM dataset, to create a corresponding SpatiaLite's DB-file, producing only valid graph in order to support the SpatiaLite's own Routing module (VirtualNetwork)
    For a more details, read OSM Networks and graphs
• spatialite_osm_overpass : Create a corresponding SpatiaLite's DB-file, using a remote server supporting the OSM Overpass API.

XML tools: (tools supporting XML files processing)
  spatialite_xml_load, spatialite_xml2utf8,
  spatialite_xml_collapse, spatialite_xml_print, spatialite_xml_validator :

---

A generaloverview of these tools, visit the main Wiki-Pages:
  XML processing tools introduced with Spatialite 4.2.0

• spatialite_xml_collapse: Simplify the current DB-file (created with spatialite_xml_load)
• spatialite_xml_print: Export the current DB-file content to a a single XML file
• spatialite_xml_validator: Validate the current DB-file (created with spatialite_xml_load)

XML Tools Tutorial: how to process a Simple GML dataset

XML Tools Tutorial: how to process a Complex GML-Topology dataset

  Using:

• spatialite_xml_load

XML Tools Tutorial: converting non-UTF8 to UTF8

  Using:

• spatialite_xml2utf8