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
|
CREATE TABLE "public"."gazetteer" (
"id" int8 DEFAULT nextval('gazetteer_id_seq'::regclass) NOT NULL,
"gn_id" int8 DEFAULT NULL,
"ascii_name" varchar(255) DEFAULT NULL::character varying,
"latitude" numeric DEFAULT NULL,
"longitude" numeric DEFAULT NULL,
"feature_class" varchar(1) DEFAULT NULL::character varying,
"feature_code" varchar(10) DEFAULT NULL::character varying,
"country_code" varchar(2) DEFAULT NULL::character varying,
"admin1_names" varchar(2000) DEFAULT NULL::character varying,
"admin1_code" varchar(255) DEFAULT NULL::character varying,
"admin2_names" varchar(2000) DEFAULT NULL::character varying,
"admin2_code" varchar(255) DEFAULT NULL::character varying,
"admin3_names" varchar(2000) DEFAULT NULL::character varying,
"admin3_code" varchar(255) DEFAULT NULL::character varying,
"admin4_names" varchar(2000) DEFAULT NULL::character varying,
"admin4_code" varchar(255) DEFAULT NULL::character varying,
"admin5_names" varchar(2000) DEFAULT NULL::character varying,
"admin5_code" varchar(255) DEFAULT NULL::character varying,
"admin6_names" varchar(2000) DEFAULT NULL::character varying,
"admin6_code" varchar(255) DEFAULT NULL::character varying,
"population" int8 DEFAULT NULL,
"country_names" varchar(6000) DEFAULT NULL::character varying,
"normalized_name" varchar(255) DEFAULT NULL::character varying,
"adm1_gn_id" int8 DEFAULT NULL,
"adm2_gn_id" int8 DEFAULT NULL,
"adm3_gn_id" int8 DEFAULT NULL,
"adm4_gn_id" int8 DEFAULT NULL,
"adm5_gn_id" int8 DEFAULT NULL,
"adm6_gn_id" int8 DEFAULT NULL,
"is_country" char(1) DEFAULT NULL,
"country_pop" int4 DEFAULT NULL,
CONSTRAINT "gazeteer_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE)
;
ALTER TABLE "public"."gazetteer" OWNER TO "postgres";
CREATE INDEX "gaz_adm1_indx" ON "public"."gazetteer" USING btree ("admin1_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_adm1cntry_indx" ON "public"."gazetteer" USING btree ("country_code", "admin1_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_adm2_indx" ON "public"."gazetteer" USING btree ("admin2_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_adm2cntry_indx" ON "public"."gazetteer" USING btree ("country_code", "admin1_code", "admin2_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_adm3_indx" ON "public"."gazetteer" USING btree ("admin3_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_adm3cntry_indx" ON "public"."gazetteer" USING btree ("country_code", "admin1_code", "admin2_code", "admin3_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_adm4_indx" ON "public"."gazetteer" USING btree ("admin4_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_adm4cntry_indx" ON "public"."gazetteer" USING btree ("country_code", "admin1_code", "admin2_code", "admin3_code", "admin4_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_cntrycode_indx" ON "public"."gazetteer" USING btree ("country_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_feat_indx" ON "public"."gazetteer" USING btree ("feature_code") WITH (fillfactor = -1);
CREATE INDEX "gaz_geoid_indx" ON "public"."gazetteer" USING btree ("gn_id") WITH (fillfactor = -1);
CREATE INDEX "gaz_id_indx" ON "public"."gazetteer" USING btree ("id") WITH (fillfactor = -1);
CREATE INDEX "gaz_normname_indx" ON "public"."gazetteer" USING btree ("normalized_name") WITH (fillfactor = -1); |
Partager