The open source database SQLite/SpatiaLite has been widely used for presenting geospatial data in geographic information systems (GISs), especially those run on mobile devices. A SpatiaLite database defines tables with geometry column for layers, and spatial indices for speeding up spatial queries. However, one of the issues remained to be resolved is how to define a framework symbolizing the portable SpatiaLite data efficiently. For this reason, we developed an open data schema “WalkLite” by inheriting the Walk spatial data specification (the data specification is currently used in surveying and land use planning in China). WalkLite schema provides an extension to SpatiaLite in the following aspects: 1. Four meta-data tables complying with the Walk spatial data specification: WalkLayers, SymbolFactory, MetaData, and MetaDataDef. 2. Corresponding the Walk spatial database, each WalkLite layer contains three tables: two SpatiaLite layer tables (one for features, the other for annotations) and one symbol table. 3. The feature layer table contains OGC SRS geometry and style ID. 4. The annotation layer table contains OGC SRS geometry (a point for the location of annotation, or a polygon for the location of image), annotation (text that stores the content of annotation or the file path of image) and style ID. 5. The symbol table defines styles indexed with style IDs referred by the feature layer table and annotation layer table. WalkLite schema was typically implemented on a SpatiaLite database, though it can also be adapted to other geospatial data formats supported by GDAL/OGR library. In this sense, the spatial data following the schema can be shared with other GIS software and used on cross-platform applications. In this presentation, we will introduce the Walk Schema and demonstrate a WalkLite-based mobile GIS App that is widely used for land investigation, cadastral inventory and decision analysis in a number of Chinese provinces. |