Last active
July 6, 2020 08:07
-
-
Save soiqualang/30dab4877c78e8564b8441fed8dbe503 to your computer and use it in GitHub Desktop.
Make and Update SEQUENCE in PostgreSQL - GeoServer WMST with Image mosaicking plugin
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Adminer 4.6.3 PostgreSQL dump | |
DROP TABLE IF EXISTS "img_lst"; | |
DROP SEQUENCE IF EXISTS raster.img_lst_fid_seq; | |
CREATE SEQUENCE raster.img_lst_fid_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1; | |
CREATE TABLE "raster"."img_lst" ( | |
"fid" integer DEFAULT nextval('raster.img_lst_fid_seq') NOT NULL, | |
"the_geom" public.geometry(Polygon,32648), | |
"location" character varying(255), | |
"ingestion" timestamp, | |
"elevation" integer, | |
"nguon" character varying, | |
CONSTRAINT "img_lst_pkey" PRIMARY KEY ("fid") | |
) WITH (oids = false); | |
CREATE INDEX "spatial_img_lst_the_geom" ON "raster"."img_lst" USING btree ("the_geom"); | |
COMMENT ON TABLE "raster"."img_lst" IS 'Danh sách ảnh Nhiệt độ bề mặt (LST)'; | |
COMMENT ON COLUMN "raster"."img_lst"."fid" IS '{"label": "FID","isshow": 1,"isnull": 0,"type": "text"}'; | |
COMMENT ON COLUMN "raster"."img_lst"."the_geom" IS '{"label": "Geometry","isshow": 0,"isnull": 0,"type": "text"}'; | |
COMMENT ON COLUMN "raster"."img_lst"."location" IS '{"label": "Tên ảnh","isshow": 1,"isnull": 0,"type": "text"}'; | |
COMMENT ON COLUMN "raster"."img_lst"."ingestion" IS '{"label": "Thời gian","isshow": 1,"isnull": 0,"type": "date"}'; | |
COMMENT ON COLUMN "raster"."img_lst"."nguon" IS '{"label": "Nguồn","isshow": 1,"isnull": 0,"type": "text"}'; | |
INSERT INTO "img_lst" ("fid", "the_geom", "location", "ingestion", "elevation", "nguon") VALUES | |
(5, '0103000020887F000001000000050000000000000042C8234100000000118331410000000042C823410000000055D43241000000008A0526410000000055D43241000000008A05264100000000118331410000000042C823410000000011833141', 'HoChiMinhIMAGES_20180217_BLST.TIF', '2018-02-17 07:00:00', NULL, NULL), | |
(1, '0103000020887F000001000000050000000000000042C8234100000000118331410000000042C823410000000055D43241000000008A0526410000000055D43241000000008A05264100000000118331410000000042C823410000000011833141', 'HoChiMinhIMAGES_20140326_BLST.TIF', '2014-03-26 07:00:00', NULL, 'Trung tâm Vũ trụ Việt Nam'), | |
(2, '0103000020887F000001000000050000000000000042C8234100000000118331410000000042C823410000000055D43241000000008A0526410000000055D43241000000008A05264100000000118331410000000042C823410000000011833141', 'HoChiMinhIMAGES_20150209_BLST.TIF', '2015-02-09 07:00:00', NULL, 'Trung tâm Vũ trụ Việt Nam'), | |
(3, '0103000020887F000001000000050000000000000042C8234100000000118331410000000042C823410000000055D43241000000008A0526410000000055D43241000000008A05264100000000118331410000000042C823410000000011833141', 'HoChiMinhIMAGES_20160228_BLST.TIF', '2016-02-28 07:00:00', NULL, 'Trung tâm Vũ trụ Việt Nam'), | |
(4, '0103000020887F000001000000050000000000000042C8234100000000118331410000000042C823410000000055D43241000000008A0526410000000055D43241000000008A05264100000000118331410000000042C823410000000011833141', 'HoChiMinhIMAGES_20170214_BLST.TIF', '2017-02-14 07:00:00', NULL, 'Trung tâm Vũ trụ Việt Nam'), | |
(6, '0103000020887F000001000000050000000000000042C8234100000000118331410000000042C823410000000055D43241000000008A0526410000000055D43241000000008A05264100000000118331410000000042C823410000000011833141', 'HoChiMinhIMAGES_20190220_BLST.TIF', '2019-02-20 07:00:00', NULL, 'Trung tâm Vũ trụ Việt Nam'); | |
-- 2019-11-05 09:31:02.852158+07 | |
SELECT setval('raster.img_lst_fid_seq', max(fid)) FROM raster.img_lst; |
COMMENT ON TABLE "raster"."img_ndvi" IS 'Danh sách ảnh Chỉ số thực vật (NDVI)';
Update schema
ALTER TABLE diadanh_point
SET SCHEMA bentre;
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
COMMENT ON TABLE "raster"."img_lst" IS 'Danh sách ảnh Nhiệt độ bề mặt (LST)';