Advertisements

SpatiaLite GeomFromText() for Points

Assuming you already have a table containing x and y coordinates (WGS84) as integers:

spatialite> SELECT AddGeometryColumn('tablename','Geometry',4326,'POINT',2);
spatialite> UPDATE tablename SET Geometry = GeomFromText('POINT('||x||' '||y||')',4326);

Advertisements
%d bloggers like this: