1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95
| -- Table: cad_2015.edi_parc
-- DROP TABLE cad_2015.edi_parc;
CREATE TABLE cad_2015.edi_parc
(
gid integer,
objectid numeric(10,0),
codlot character varying(254),
id_parc character varying(15),
numero numeric(10,0),
codcomm character varying(6),
codsec character varying(12),
codsubsec character varying(20),
figplan character varying(254),
codarpent character varying(254),
codmodif character varying(254),
supf numeric,
shape_leng numeric,
shape_area numeric,
geom geometry(MultiPolygon,2154),
code_insee character(5),
jannatmin integer,
idparref character varying(15),
jannatmin_lots integer,
nb_locaux integer,
local_maisapp_hab integer,
local_mais_hab integer,
local_app_hab integer,
local_maisapp_hab_lots integer,
local_mais_hab_lots integer,
local_app_hab_lots integer,
nb_logts integer,
nb_proprios_diff_logts integer,
nb_proprios_occ integer,
local_copros integer,
dcntsol integer,
surf_bati_dur integer,
surf_bati_leger integer,
surf_bati_total integer,
surf_resultante_tt_bati integer,
surf_bati_dur_cad11 integer,
surf_phab integer,
surf_phab_dep integer,
surf_pprof integer,
type_prop character varying(60),
nom_prop_desti_av_imp character varying(60),
the_geom_centr geometry,
the_geom_centr_batis geometry(Point,2154),
id_uf character(60),
pgc character varying(1),
code_epci character varying(9),
id_zone_plu_12_2014 character(3)
)
WITH (
OIDS=FALSE
);
ALTER TABLE cad_2015.edi_parc
OWNER TO postgres;
-- Index: cad_2015.edi_parc_geom_gist
-- DROP INDEX cad_2015.edi_parc_geom_gist;
CREATE INDEX edi_parc_geom_gist
ON cad_2015.edi_parc
USING gist
(geom);
-- Index: cad_2015.edi_parc_id_parc
-- DROP INDEX cad_2015.edi_parc_id_parc;
CREATE INDEX edi_parc_id_parc
ON cad_2015.edi_parc
USING btree
(id_parc COLLATE pg_catalog."default");
-- Index: cad_2015.edi_parc_the_geom_centr_batis_gist
-- DROP INDEX cad_2015.edi_parc_the_geom_centr_batis_gist;
CREATE INDEX edi_parc_the_geom_centr_batis_gist
ON cad_2015.edi_parc
USING gist
(the_geom_centr_batis);
-- Index: cad_2015.edi_parc_the_geom_centr_gist
-- DROP INDEX cad_2015.edi_parc_the_geom_centr_gist;
CREATE INDEX edi_parc_the_geom_centr_gist
ON cad_2015.edi_parc
USING gist
(the_geom_centr); |
Partager