Skip to content

Instantly share code, notes, and snippets.

Last active December 21, 2016 14:20
What would you like to do?
CREATE TABLE "pti_monumenti"
"pk_uid" integer PRIMARY KEY autoincrement NOT NULL,
"data_rilievo" date,
"nome_monumento" text,
"link_foto" text,
"note" text
-- aggiungo colonna geometrica
SELECT AddGeometryColumn ('pti_monumenti','geom',3004,'POINT','XY');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment