Spatialite examples

Page copy protected against web site content

        infringement by Copyscape

The example that we'll use is the query from the Joining tables in databases recipe  This is a real world example dealing with real world issues: we use real data usual Windows way to confer GPKG / SQLite / SpatiaLite capability to our system. Apr 15, 2008 Slashgeo pointed me to a very interesting set of projects - SpatiaLite and For example, lets say you have a shapefile of US counties and the  Jun 17, 2012 So lets look at an example. Creating or updating a spatialite database requires explicit linking against SpatiaLite library (version >= 2. WebConcepts 3,570,633 views. Spatialite access is available through OGR. It adds support for geographic objects allowing location queries to be run in SQL. Q What is the relationship between GeoPackage and SpatiaLite? A SpatiaLite was a major influence on the vector portions of GeoPackage but after extensive discussions, the working group chose to diverge from the SpatiaLite format in a few subtle ways. 0. SpatiaLite --version 1. Given a latitude and longitude, how can we tell what time zone that point lies within? Here’s how I built a simple JSON API to answer that question, using a combination of data from OpenStreetMap, the SpatiaLite extension for SQLite and my Datasette API tool This SQLite tutorial explains how to use the SQLite ATTACH DATABASE command with syntax and examples. the examples were tested using Spatialite-GUI with an associated . SpatiaLite execute SQL ¶ Allows a SQL database query to be performed on a SpatiaLite database connected to QGIS. They are open source and lightweight with the ability to hold spatial and non-spatial files in a single file container. But SpatiaLite extends SQLite by giving it spatial capabilities. SpatiaLite Datasette Demo. When you connect to a database, its name is main regardless of the database file name. The problem is that those solutions were private and I could not deploy them to others in my organization without leading them through the The json1 extension uses the sqlite3_value_subtype() and sqlite3_result_subtype() interfaces that were introduced with SQLite version 3. Shapefile is a bad format. mockito android 20-spatialite-test] Automatic Target Mode: I can preview these new shapes in Spatialite (Map Preview, Check Geometries), but they're not showing up as 'geometry' tables, with the little world icon, and I can't view them in QGIS. WebConcepts 3,399,844 views. Examples: Introduction. 2. Create, edit, visualise, analyse and publish geospatial information on Windows, Mac, Linux, BSD (Android coming soon) For your desktop, server, in your web browser and as developer libraries All examples in the reference below are given for geometry fields and inputs, but the lookups can be used the same way with rasters on both sides. 0 or later. Checking a GeoPackage Version I came across this post by underdark about how to select a random sample from a table in PostgreSQL. Jump to: navigation, search. Sebastian, I have been trying to use your Spatialite 4 for Android in a straight Eclipse built Android app without success. SpatiaLite Quickstart ¶. I would need to run some initialization SQL to create all the required Spatialite tables, triggers, etc. SQLiteConnection. column-name" and "OLD. Robert still has commit privileges on this repository but is no longer an active contributor. UpdateCursor but the da. For example, on Debian-based distributions, try to install the spatialite-bin package. Luckily, there are planty of free data sources available, here we will take the  For an example of an INSTEAD OF trigger, consider the following schema: CREATE TABLE customer( cust_id INTEGER PRIMARY KEY, cust_name TEXT,   For this recipe, you'll need a query that returns results containing a geometry. Development and maintenance work is now mostly performed by the SQLite Development Team. The post also provides information on how to add the SpatiaLite extension to enable further spatial analysis in SQLite. 10 SPATIALITE DECLARE int insert epsg srid ( sqlite3 ∗ sqlite, int srid ). Oct 23, 2017 Fortunately, both SpatiaLite and PostGIS implement the Open . This script builds a SpatiaLite database from scratch containing two tables: . SpatiaLite Manager connected to example database (additional data from Natural Earth). The good thing about this library is, it’s build for . We'll cover spatialite-gis graphical tool in the next tutorial. Hey Jim, I've added examples for both Windows and Android in the examples folders - both for Spatialite and for SQLite. 3. jar in your class path, or you can use it along with -classpath option as explained in the following examples. If you show columns on the tables, you will notice they have a Geometry column. To remove a table in a database, you use SQLite DROP TABLE statement. Fire up the GUI, and load the sample database. Contents. e. OGR2OGR examples for Spatialite, PostGIS, Shapefiles “Here are some examples (…) used in doing some batch conversions here and there between PostGIS, Spatialite and Shapefiles”. Jul 30, 2012 In the example below, the table I am working with is 'labels'. exe (command line) or spatialite-gui. Learn Spatialite! Prerequisites. You can rate examples to help us improve the quality of examples. I've seen examples that say I need to use something like this: SELECT AddGeometryColumn('test_geom', 'the_geom', 4326, 'POINT', 'XY'); This SQLite tutorial explains how to use the SQLite CREATE TABLE AS statement with syntax and examples. Tags; Docs Stand-alone test project for a library project on Android . Packages are also available for macOS and Ubuntu. Only 255 attributes. 4 and GEOS included. An introductory workshop on Spatial SQL using SpatiaLite. Inserts some inlined EPSG definition into  Oct 27, 2015 Afterwards the styles included in the SpatiaLite database are displayed For this example we will use an example SpatiaLite database  Jan 15, 2017 Data. geom, t2. You can think of it as a spatial extender for SQLite database engine which is similar in concept to what PostGIS does for the PostgreSQL Object-Relational Database. See the OGR driver page for specific driver information. The way that Spatialite handles spatial indexes has changed since the cookbook was written (it's now a few years old), and instead of R-Tree it uses the virtual spatial index. The simplest way to get to grips with SpatiaLite is to use SpatiaLite GUI, which for Windows can downloaded as an executable here. When I worked with the 3. org was not worked in my system may be in yours too. Example 3. Each successive level further decomposes the level above it, so each upper-level cell Creating SQLite databases from R 1. 7. 1). 0 (2015-10-14) The json1 extension will not work in earlier versions of SQLite. ) with a lowercase character and only use lowercase characters, numbers 0-9, and underscores (_). A basic design is provided in generic SQL along with the implementation explained in MS Access and SQLITE. Here’s the Github source code for reference. 1. For example you could use AsGeoJSON(GEOMETRY, 5) to limit the  This script builds a SpatiaLite database from scratch containing two tables: states with columns name, source, g; mtbmbr with columnr name (just a placeholder),  Oct 31, 2017 But fear not - despite plenty of examples to the contrary, powerful all the spatial functionality of our GeoPackage or SpatiaLite databases, we  Export to PostgreSQL; Export to SpatiaLite; Package layers; PostgreSQL execute and load . 15. WKBElement . For this, a number of spatial metadata tables must be created in the database before any spatial query is performed against it. Create a Spatialite database and Layer. For a detailed description and examples of spatial features introduced in SQL Server 2012 (11. SpatiaLite/Examples. Points to Lines. You can think of it  Some sample SQL queries are shown. The SpatiaLite driver is identified by the name spatialite. Section 9: Spatial Joins¶ Spatial joins are the bread-and-butter of spatial databases. Data. 9. This makes is much easier to move it around instead of a bunch of shapefiles. These are the top rated real world C# (CSharp) examples of System. SpatiaLite is an SQLite database engine with spatial functions added. SQL functions for constructing a geometric object given its Well-known Text Representation spatialite> the AsText() function is a SpatiaLite one, and returns the Well Known Text - WKT representation for a GEOMETRY column value. Queries using Spatial indexing on Geopackages use older Rtree syntax instead of new Spatialite SpatialIndex syntax There are some advanced functions such as An archive of the CodePlex open source hosting site. Messtischblätter map series. column-name", where column-name is the name of a column from the table that the trigger is associated with. Although the Spatialite and Geopackage formats support raster files (images, Grids, digital models, among others) that can be displayed in QGIS 3, currently the Database Manager can only handle vector formats, in future versions it is expected to improve the support to other types of data. Whenever a lookup doesn’t support raster input, the input is automatically converted to a geometry where necessary using the ST_Polygon function. SpatiaLite adds spatial support to SQLite, turning it into a full-featured spatial database. To get started with SpatiaLite GUI, we will need a study area, and some spatial data to work with. However, I've never  Posts about SpatiaLite written by underdark. While the Spatialite database can be created using the SQLite wrapper and the Spatialite module extension, the newly created database lacks all the Spatialite tables, triggers etc. test-2. Allows you to save numerous vantage points or filters of a layer without duplicating (or multiplying) the data used. I am following tutorial which used PostgreSQL and Spatialite access is available through OGR. Following section assumes you have little knowledge about Java JDBC concepts. . SpatiaLite SQL functions reference list back to main page. . Expected Learning Outcomes. Spatialite is an open database format similar to ESRI’s geodatabase format. I found these ok, but I wasn’t thrilled. PostGIS is a spatial database extender for PostgreSQL object-relational database. The notes outline two way in which R can communicate with SQLite databases: using the RSQLite package and using the sqldf package. This should generate you working C# API to bundled SQLite, together with Spatialite, Proj. But GeoAlchemy 2 also supports SpatiaLite, the spatial extension to SQLite. com. SpatiaLite give similar functionality to geodatabases and are the rough equivalence to PostgreSQL + PostGIS. SQLite is a Database Management System (DBMS) which is simple, robust, easy to use and very lightweight. Databases store geographic data as a structured set of data/information. Use the password property to set the encryption key. Sebastian, I am having a problem determining how to set up an Eclipse project to use your Adndorid-Spatialite-4 support. The current implementation of this JSON library uses a recursive descent parser. The driver is available in GDAL/OGR version 1. I'm assuming you are a great web developer and if that is the case then no doubt, you would be well aware of SQL Note that GeoPackage database files created by org2ogr (and Fulcrum) are raw GeoPackages, with the geometry stored in a slightly different binary format than SpatiaLite, but starting with version 4. Spatialite views examples. necessary for proper functioning of the Spatialite database. exe (GUI), and the sample database of Italian towns and highways – all of which you can download from the spatialite website. These layers are called virtual layers: they do not carry data by themselves and can be seen as views to other layers. You have data that tracks a person heading to Recurse Center in the morning. You can connect to the following spatial file types: Shapefiles, MapInfo tables, KML (Keyhole Markup Language) files, GeoJSON files, TopoJSON files, and zipped Esri File Geodatabases. DotSpatial is an open source project focused on developing a core set of GIS and mapping libraries. Just like when using PostGIS connecting to a SpatiaLite database requires an Engine . Part 1: Getting Started with SpatiaLite: An almost Idiot's Guide Printer Friendly What is SpatiaLite? SpatiaLite is an SQLite database engine with Spatial functions added. SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality. IntroductionThese notes show how to create an SQLite database from within R. Convert foreign geometry object to an sfc object System. Would be great to have some examples of trigger functions which can automate processes. A special kind of vector layer allows you to define a layer as the result of an advanced query, using the SQL language on any number of other vector layers that QGIS is able to open. Support for SQLite encryption. “Microsoft. Mapping SurveySheets to FederalState names; Oracle Spatial and Graph provides examples that you can use to reinforce your learning and to create models for coding certain operations. The queries below demonstrate the power of spatial SQL functions that can be used to generate new geometries based off of existing features. Skip navigation Sign in. The SpatiaLite MakeLine function is the same as the PostGIS ST_MakeLine function, which is documented here. SQLite. SpatiaLite Quickstart. I quickly realized that while using indexes benefitted the queries, the questions were too easy and the queries were finishing very quickly regardless of using indexes or not (nice problem to have). In our case, we would use the following query to build lines Building a location to time zone API with SpatiaLite, OpenStreetMap and Datasette. Ok, but now what? As there’s no real python examples, you need to follow the raw spatialite examples. Welcome to Django-environ’s documentation!¶ Django-environ allows you to utilize 12factor inspired environment variables to configure your Django application. It comes with wrappers for OGR and GDAL. First, check if you can install SpatiaLite from system packages or binaries. I am trying to do simple geodjango app, which contains list of shops, and when you put an address in it it returns closest shops to your location. 10 SpatiaLite, the Shapefile of the future? Spatial SQL examples SELECT t2. FOSS4G Barcelona 9. SpatiaLite Queries. Download either spatialite. This service was created to help programmers find real examples of using classes and methods as well as documentation. Come realizzare una tassellazione dello spazio tramite QGIS e i virtual layer e le funzioni di spatialite REST API concepts and examples - Duration: 8:53. To import Spatialite-data into a PostGIS database ogr2ogr is a nice command-line tool: Sep 2, 2015 Hi there, I'm hoping to use spatialite on android for a school project. Aug 7, 2014 Example 1: From Spatialite to PostGIS. The formats were originally defined by the Open Geospatial Consortium (OGC) and described in their Simple Feature Access. If you feel it would be helpful in your career, you are welcome to use SpatiaLite in your term project. SpatiaLite now supports GeoPackage as of version 4. CartoDruid is a GIS application developed by Instituto Tecnológico Agrario de Castilla y León (ITACyL) thought as a tool to support the fieldwork aiming to solve the problem of disconnected editing of georeferenced information. -dsco SPATIALITE=yes says the input is in Spatialite format in the end all the Spatialite tables will be exported to individual shapefiles (name = tableName) into the folder "shp" the folder name can of course be whatever, where ever you want it on your machine. In Datasette ClusterMap Plugin – Querying UK Food Standards Agency (FSA) Food Hygiene Ratings Open Data I showed how the datasette cluster map plugin could be used to display a map with clustered markers showing the location of results on an interactive map from a datasette query that returned latitude and longitude columns. geonames. If you choose to do this, I ask you to first get the project working with file-based data. REST API concepts and examples - Duration: 8:53. NET provider for SQLite. This notebook provides a quick walkthrough of getting started with a SpatiaLite geo-database and using it with Datasette. Spatialite database is contained within a single file on your hard drive and can contain diferent types of spatial (point, line, polygon) as well as non-spatial layers. Use the function Load Shapefile of spatialite-gui to load the roads, for example. org/ have made some available. Creating a Spatial Database for SpatiaLite¶ After the SpatiaLite library and tools have been installed, it is now possible to create a spatial database for use with GeoDjango. wordpress. The SpatiaLite database can be used to store, index and perform various geo-related query operations on various geographical objects including points and shapefiles. c. Spatialite GUI; Previous experience with SQLite, and SQL in general. This tutorial describes Connect to the DB¶. table with latitude and longitude coordinates in your SQLite / Spatialite database. SpatiaLite Manager is a  Nov 25, 2012 Examples: demo5. Any programming language of choice (to query DB, and format/save GeoJSON). Sqlite“, is an open source library and is also available as NuGet package. Goals. The SQLite ATTACH DATABASE command is used to attach another SQLite database file to your current database connection. See following examples To check versions of the modules: Both the WHEN clause and the trigger actions may access elements of the row being inserted, deleted or updated using references of the form "NEW. Name, t2. SpatiaLite is not as mature as PostGIS, but it is growing in popularity, and you will see a button in QGIS called Add SpatiaLite Layer. See Spatialite. We use geographic databases because it’s a way to put all data in a single container. If the database file does not exist, it will be created when the command is run. Some implementations may allow you to have multiple connections open, so you may invoke this function repeatedly assigning its output to different objects. Most spatial databases allow the representation of simple geometric objects such as points, lines and polygons. Our system automatically searches, retrieves and ranks examples of source code from more than 1 million opensource projects. IO. I have some experience developing android apps. geom) AS Distance FROM Towns AS t1, Towns AS t2 Add downloaded jar file sqlite-jdbc-(VERSION). You want to map that data with an animated marker, and include This post is part of a series , , , Tonight I continued dabbling with my little project and experimenting with spatial indexes in Spatialite. VIEWS! – glorified query, a read-only table, has no data of its own. So, let’s use Prince Edward County, Ontario (PEC) as a study -dsco SPATIALITE=yes says the input is in Spatialite format in the end all the Spatialite tables will be exported to individual shapefiles (name = tableName) into the folder "shp" the folder name can of course be whatever, where ever you want it on your machine. For example, if a customer has a fax number with a NULL value, it means we don' t have information about the fax number of the customer or the customer may  This SQLite tutorial explains how to use the SQLite substr function with syntax and examples. A dump of that database is downloadable from my blo g: artlembo. A spatial database is a database that is optimized for storing and querying data that represents objects defined in a geometric space. You will also learn how to create and modify tables and how to execute SQL queries on the database and how to read the returned results. I thought I would share that experience by posting a simple C# wrapper for reading a Microstation DGN file (version 7) as SharpMap geometries. gaia-gis. LoadExtension - 2 examples found. For example:. If you installed the demo files from the Oracle Database Examples media (see Oracle Database Examples Installation Guide), several examples are provided in the following directory: spatialite-tutorial. The DBF file does not allow you to store more then 255 attribute fields. So, here’s a couple of examples that actually use python, and some notes I found awkward. sqlite a sample preloaded database [as used within tutorial], test-2. This workshop is intended to give you an introduction to spatial SQL through working with a graphical user interface (GUI) with some examples of common analysis processes as well as present you with resources for continued learning. Today we will learn about Django Database API. Just use Arcpy! You can connect to a spatialite database just like any other database. Introduction to the SQLite ATTACH DATABASE statement. zip 4 MB. Miscellaneous Tutorials/Cheatsheets/Examples What is SpatiaLite? SpatiaLite is an SQLite database engine with Spatial functions added. Introduction to SQLite DROP TABLE statement. I recently had to work with DGN files. You had: Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. 5. The Web SQL Database API isn't actually part of the HTML5 specification but it is a separate specification which introduces a set of APIs to manipulate client-side databases using SQL. SQLite SQLiteConnection. Well-known text (WKT) is a text markup language for representing vector geometry objects on a map. 1 support from Andrea Antonelo, I had to place the ' jsqlite' source directory in the 'src' directory of my project and I had to build a libs directory containing the 3 hardware dependent libraries (armeabi, etc). From OpenStreetMap Wiki < SpatiaLite. Why Spatialite table over a Shapefile? •From 3+ files to JUST ONE •VIEWS! –glorified query, a read-only table, has no data of its own • Allows you to save numerous vantage points or filters of a layer without duplicating (or multiplying) the data used •TRIGGERS! –triggers a series of tasks/operations upon the execution of a command Intro. Please contact its maintainers for support. There is a bug in the da. 8:53. The SQLite CREATE TABLE AS statement is used to create a table from an existing table by copying the existing table's columns. Peoples, ST_Distance(t1. Too much time spent with WKB and hex dumps of geometry and explaining sql. OLD and NEW references may only be used in triggers on events for which For some SQL query examples see PostGIS SQL Query Examples. SQLite is an ADO. I have been using it for several years with the extension dll provided on the Spatialite site The Gaia-SINS federated project home-page. NET Core, meaning you can develop and run applications on Windows and non-Windows platform (Mac, Linux) supporting . A common query used with spatial data is the Nearest Neighbor query. This article is to use your SQLite Database with entity framework, I am writing this article because i was unable to use SQLite's Entity framework tools i. states with columns name, source, g; mtbmbr with columnr name (just a placeholder), nr, g; It was build with the goal in mind to determine which federal state territory is covered by which survey map sheet(s) of the TK 25 or resp. Note: For maximum interoperability, start your database identifiers (table names, column names, etc. For example, Esri geodatabases, geopackages and SpatiaLite are the most common types of geographic databases. Explicit linking against SpatiaLite library also provides access to functions provided by this library, such as spatial indexes, spatial functions, etc A few examples : This tutorial will teach you how to create and connect to an SQLite database in C#. OGR uses the names of spatial tables within the SpatiaLite database (tables with a geometry column that are registered in the geometry_columns table) as layers. A Nearest Neighbor Summary: in this tutorial, you will learn how to attach additional databases to the current database connection using the SQLite ATTACH DATABASE statement. Why SpatiaLite? I spent this weekend getting the SpatiaLite GUI installed, with help from SpatiaLite Users Google Group. I looked at the samples you provides and for the Android example don't understand how to setup the libs directory and, more importantly, how to access the Sqlite and Spatialite functions from my code. Entity Framework tool from sqlite. A binary equivalent, known as well-known binary (WKB), is used to transfer and store the same information on databases. WKT is a standard notation conformant to OpenGIS specification. Summary: in this tutorial, you will learn how to remove a table from the database using SQLite DROP TABLE statement. Why is Shapefile so bad? Here are several reasons why the Shapefile is a bad format and you should avoid its usage: No coordinate reference system definition. Using spatialite-gui; Running spatialite from the command line; Things to Try; What Next ? Open http://www. For some SQL query examples see PostGIS SQL Query Examples. Hi. See also the introduction to raster lookups. Driver Capabilities ¶ The following table summarizes the native capabilities of the SpatiaLite driver. It is similar to PostGIS, Oracle Spatial, and SQL Server with spatial extensions, although SQLite/SpatiaLite aren't based on client-server architecture: they adopt a simpler personal architecture. I agree that the Spatialite extension is the more mature of the three. System. Attribute names are limited to 10 characters. To load some data into SpatiaLite, first of all you need them. C# (CSharp) System. x), including features that affect spatial indexes, download the white paper, New Spatial Features in SQL Server 2012. i. GitHub Gist: instantly share code, notes, and snippets. The purpose of geographic databases is to house vectors and rasters. SearchCursors work with the geometry as if it was a filegeodatabase. InserCursor and da. This is a tutorial on how to design a basic drillhole database using simplified SQL language. SpatiaLite is an open source source geodatabase built on top of SQLite, itself an open source database. The NuGet Team does not provide support for this client. SQLite was started by Robert Simpson. The jsqlite DB API itself is different from other C# SQLite APIs, you need to use callback classes. For example a store locater for a Web site often must find the closest store locations to a customer location. The SQLite driver can read and write SpatiaLite databases. In recent FPC versions (implemented March 2012), SQLDB included support for some extended versions of SQLite3 which encrypt the SQLite database file using the AES algorithm. 0, SpatiaLite supports working with the GeoPackage format. It's a multifile format. You can achieve the same (selecting 1000 random features from a table) in SQLite using something like below: Great to use with a Spatialite database to select random points from your point data layer or to… paket add NetTopologySuite. We'll need some data, and the wonderful people at / http://www. Why Spatialite table over a Shapefile? From 3+ files to JUST ONE. The best thing is Django Database API is you do not need to write SQL statements, Django will do it for you. Hello friends, in last Django tutorial we learnt about Handling HTML Forms in Django. A spatial join is an operation used to combine two or more datasets with respect to a spatial relationship. Data SpatiaLite is a spatial extension to SQLite, providing vector geodatabase functionality. Alternatively, you can have a look here for SQLite<[link]>and here for Spatialite <[link]>. Connect to a DBMS going through the appropriate authorization procedure. LoadExtension extracted from open source projects. TRIGGERS! – triggers a series of tasks/operations upon the execution of a command/event SPATIALITE VS GEOPACKAGE Geopackage is a new OGC standard Spatialite has been around for many years Spatialite natively support Geopackage data with numerous functions. Nearest Neighbor queries are used to find the closest spatial objects to a specific spatial object. Do you have some examples for trigger functions? I believe that SpatiaLite database can be very good alternative (to some degree obviously) for PoatgreSQL/PostGIS databases as it can be taken as a separate file on memory stick for example and used in an ‘on-site’ situation, it does store styles, etc. SharpMap is an easy to use library for working with GIS data. NET Core Runtime. Get the Data. The SQLite team is committed to supporting System. Code Examples. The SQLite substr function allows you to extract a substring from a   Nov 10, 2016 I guess the sqlite session needs to be loaded with the spatialite I tried to >> adapt the postgis example of the st_write_db function but I get the  Dec 12, 2017 Some examples: SpatiaLite is a powerful open source extension for SQLite, which adds a brew install spatialite-tools $ brew install gdal. It is similar to PostGIS, Oracle Spatial, and SQL Server with spatial  A quick tutorial to SpatiaLite - a Spatial extension for SQLite For the sake of simplicity all the following examples supposes you are doing the tests using a  Please go to the current home page of the SpatiaLite project. Spatial SQL with SpatiaLite. it/spatialite/, download spatialite-gui GUI and unzip it. sqlite database. Your revised statement was close to being correct, but you didn't indicate the distance in which you wanted to select the points. Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. This section will provide an initial introduction to the relation operators available and some common usage examples. SQL and the SQL/MM Spatial extension, moreso than other programming languages, are widely adopted standards, and the use of any particular implementation will introduce skills that will be directly portable to other implementations, including Oracle, SQL Server, and SpatiaLite/SQLite. the whole SQL engine is directly embedded within the application itself: a complete database simply is an Note you can use spatialite-gis to view and import tables, but the spatialite-gui gives you ability to do free SQL queries, but not as good viewing features, while the spatialite-gis can create a new database, import and can show you a whole map, but has limited filtering. spatialite examples

kn, u4, yz, 5t, 1s, ak, zp, bb, 9b, tg, wo, 9s, 1j, 8a, bi, jd, re, uc, gg, ad, iv, bn, e7, tm, tk, jk, cr, bc, cz, ov, y8,