How to turn sqlite lat/lon columns to spatialite geometry?

Question

I have a sqlite database with a table that has a column for longitude and one for latitude. Is there a way to make this data base 'spatial'?

score 18 · Accepted Answer · answered Jan 15 '11 at 20:29

18

I've described the process of installing and spatially enabling an sqlite db here: SpatiaLite Quick Start. Basically, you need to get init_spatialite-2.3.sql and run it on your db.

You can then create point geometries using this function:

MakePoint( x Double precision , y Double precision , [ , SRID Integer] ) : Geometry

answered Jan 15 '11 at 20:29

underdark

84,148
21
231
413

thanks, that worked well in combination with Gene's suggestions. – johannes Jan 16 '11 at 15:41

score 9 · Answer 2 · answered Jan 16 '11 at 10:13

9

first, you need to enable spatialite in your sqlite database

sqlite> .load 'libspatialite.so,dll or dylib'

or

SELECT load_extension(libspatialite.so,dll ou dylib)

`

After that you need to initialize your database with init_spatialite-2.3.sql

sqlite> .read '~/init_spatialite-2.3.sql'

answered Jan 16 '11 at 10:13

2

Note that the init_spatialite-2.3.sql step is not applicable for spatialite 3.0 or later. – BradHards Aug 11 '12 at 04:12

How to turn sqlite lat/lon columns to spatialite geometry?

2 Answers2