Skip to content

Instantly share code, notes, and snippets.

@cybernar

cybernar/postgis.sql

Created November 3, 2016 10:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cybernar/c78bfe5261bcce97a2e1283951e86df5 to your computer and use it in GitHub Desktop.
Save cybernar/c78bfe5261bcce97a2e1283951e86df5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgis.sql
CREATE TABLE carto.parcelles
(
num_fiche serial NOT NULL,
date_debut date,
date_fin date,
surface numeric(10, 2),
personnes text,
code_dept character(10),
laboratoire text,
utilisation text,
type_utilisation text,
util_maintenant boolean DEFAULT true,
evenements text,
geom_wgs84 geometry(Polygon,4326),
CONSTRAINT pk_nparcelles PRIMARY KEY (num_fiche)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment