Contents
How to run a SQL script in SpatiaLite?
Launch the GUI. From menu choose –> files -> Create a new SQLiteDb. Call the file boston.sqlite. Choose the little icon with tooltip “Execute SQL Script” and choose init_spatialite-2.2.sql. Choose Latin if prompted for encoding. Right mouse-click on the database and hit refresh and you should see three tables.
How to create a shape file in SpatiaLite?
From the SpatiaLite gui –> File -> Load Shape file and browse for TOWNS_POLY.shp and type in 26986 for SRID. Type in the_geom for field name. Windows Latin1 is selected by default and is fine for Massachusetts data and most data sources.
How to create a SpatiaLite engine in PostGIS?
It’s based on the ORM Tutorial, which you may want to read first. Just like when using PostGIS connecting to a SpatiaLite database requires an Engine. This is how you create one for SpatiaLite: The call to create_engine creates an engine bound to the database file gis.db. After that a connect listener is registered on the engine.
How to create a lake table in SpatiaLite?
Setting management to True indicates that the AddGeometryColumn and DiscardGeometryColumn management functions will be used for the creation and removal of the geometry column. This is required with SpatiaLite. We can now create the lake table in the gis.db database:
What do you need to know about SpatiaLite?
SpatiaLite sweetens this little database by allowing you to store geometries and query them with spatial functions similar to what you would find in PostgreSQL/PostGIS, Microsoft SQL Server 2008, MySQL, IBM DBII, Oracle Locator/Spatial.
Is there a same license for SpatiaLite as SQLite?
Spatial Transformation support using Proj.4 that hmm even SQL Server 2008 lacks As far as licensing goes, SpatiaLite does not have the same License as SQLite. It is under 3 licenses Mozilla Public and GPLv3 In this little exercise, we shall get you up and running quickly with this cute cute database engine.
Which is the latest version of SpatiaLite for Windows?
You can also use the latest Spatialite-gis minimalist, which has viewer and shapefile importer packaged in. Latest version is 1.0 Alpha and binaries available for Windows, Linux, and Mac OSX. SpatiaLite provider code for sharmap version 0.9 written by Bill Dollins.