Skip to content

Instantly share code, notes, and snippets.

@jgomezdans

jgomezdans/add_spatial.sql

Created December 15, 2009 19:56
Show Gist options
  • Save jgomezdans/257240 to your computer and use it in GitHub Desktop.
Save jgomezdans/257240 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
add_spatial.sql
.read init_spatialite-2.3.sql utf-8
.loadshp <path> <table> <utf-8> <srid> <column_name>
SELECT AddGeometryColumn('<my_table>', 'geom', 4326, 'POLYGON', 2);
UPDATE my_table SET geom=( SELECT g.geom FROM my_table d, my_shape g WHERE d.grid_id=g.id) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment