GovernmentDataResourceCenter/scripts/0.0.12/emergency_material_statistics.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 10.8.30.160
 Source Server Type    : PostgreSQL
 Source Server Version : 120001
 Source Host           : 10.8.30.160:30432
 Source Catalog        : jilin
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 120001
 File Encoding         : 65001

 Date: 16/08/2023 11:31:33
*/


-- ----------------------------
-- Table structure for emergency_material_statistics
-- ----------------------------
DROP TABLE IF EXISTS "public"."emergency_material_statistics";
CREATE TABLE "public"."emergency_material_statistics" (
  "id" serial PRIMARY KEY,
  "organization" varchar(255) COLLATE "pg_catalog"."default",
  "city" varchar(255) COLLATE "pg_catalog"."default",
  "county" varchar(255) COLLATE "pg_catalog"."default",
  "street" varchar(255) COLLATE "pg_catalog"."default",
  "location" varchar(255) COLLATE "pg_catalog"."default",
  "longitude" float8,
  "latitude" float8,
  "responsible_person" varchar(255) COLLATE "pg_catalog"."default",
  "phone" varchar(20) COLLATE "pg_catalog"."default",
  "area" float8,
  "material_description" text COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."emergency_material_statistics"."id" IS '序号';
COMMENT ON COLUMN "public"."emergency_material_statistics"."organization" IS '管理机构';
COMMENT ON COLUMN "public"."emergency_material_statistics"."city" IS '市';
COMMENT ON COLUMN "public"."emergency_material_statistics"."county" IS '区县';
COMMENT ON COLUMN "public"."emergency_material_statistics"."street" IS '乡镇街道';
COMMENT ON COLUMN "public"."emergency_material_statistics"."location" IS '仓库详细地址';
COMMENT ON COLUMN "public"."emergency_material_statistics"."longitude" IS '经度';
COMMENT ON COLUMN "public"."emergency_material_statistics"."latitude" IS '纬度';
COMMENT ON COLUMN "public"."emergency_material_statistics"."responsible_person" IS '仓库联系人';
COMMENT ON COLUMN "public"."emergency_material_statistics"."phone" IS '联系电话';
COMMENT ON COLUMN "public"."emergency_material_statistics"."area" IS '仓储点面积';
COMMENT ON COLUMN "public"."emergency_material_statistics"."material_description" IS '储备物资及数量(棉被、毛毯、毛巾被、帐篷、折叠床、凉席、冬装)';

-- ----------------------------
-- Records of emergency_material_statistics
-- ----------------------------
INSERT INTO "public"."emergency_material_statistics" VALUES (1, '县应急管理局', '南昌市', '南昌县', '莲塘镇', '莲塘镇政府', 115.934005, 28.542549, '黄家磊', '17879559466', 80, '棉被20床、毛毯20床、毛巾被100床、折叠床20张');
INSERT INTO "public"."emergency_material_statistics" VALUES (2, '县应急管理局', '南昌市', '南昌县', '八月湖街道', '昌南体育中心防灾减灾馆', 115.884817, 28.591357, '邓芬芬', '13576958052', 20, '棉被20床');
INSERT INTO "public"."emergency_material_statistics" VALUES (3, '县应急管理局', '南昌市', '南昌县', '泾口乡', '泾口乡武装部', 120.77224, 30.005408, '舒双凤', '13307009875', 50, '棉被20床、帐篷5顶、折叠床10张、凉席10床');
INSERT INTO "public"."emergency_material_statistics" VALUES (4, '县应急管理局', '南昌市', '南昌县', '向塘镇', '向塘镇人民政府', 115.966156, 28.453829, '宋春丽', '13677096615', 60, '棉被30床、折叠床20床');
INSERT INTO "public"."emergency_material_statistics" VALUES (5, '县应急管理局', '南昌市', '南昌县', '冈上镇', '冈上镇人民政府', 115.867904, 28.415851, '辜承晋', '18979126988', 25, '棉被34条');
INSERT INTO "public"."emergency_material_statistics" VALUES (6, '县应急管理局', '南昌市', '南昌县', '东新乡', '东新乡人民政府', 115.846667, 28.601297, '邓保根', '17379136555', 50, '棉被10床、毛毯10床、毛巾被50床、折叠床10张');
INSERT INTO "public"."emergency_material_statistics" VALUES (7, '县应急管理局', '南昌市', '南昌县', '塔城乡', '塔城乡人民政府', 116.095003, 28.506438, '蔡林', '13970003698', 30, '棉被30床、帐篷2顶、折叠床10张、冬装30件（套）');
INSERT INTO "public"."emergency_material_statistics" VALUES (8, '县应急管理局', '南昌市', '南昌县', '广福镇', '广福镇人民政府', 115.918078, 28.370138, '李文姣', '19100293093', 35, '棉被10床、毛毯10床、毛巾被30床、折叠床10张');
INSERT INTO "public"."emergency_material_statistics" VALUES (9, '县应急管理局', '南昌市', '南昌县', '幽兰镇', '幽兰水管站仓库', 116.151329, 28.58028, '万义军', '13607915898', 200, '无');
INSERT INTO "public"."emergency_material_statistics" VALUES (10, '县应急管理局', '南昌市', '南昌县', '三江镇', '三江镇人民政府', 116.0031642, 28.2954574, '欧阳浩', '18270812730', 36, '棉被30条 ');
INSERT INTO "public"."emergency_material_statistics" VALUES (11, '县应急管理局', '南昌市', '南昌县', '南新乡', '南新乡人民政府', 116.032889, 28.806928, '徐梦婷', '13732945381', 22, '棉被60床、毛毯60床');
INSERT INTO "public"."emergency_material_statistics" VALUES (12, '县应急管理局', '南昌市', '南昌县', '银三角管委会', '南昌县银河学校对面（文晖路33号）', 115.86459, 28.68946, '胡来水', '13870666535', 55, '棉被30床、毛巾被50条、折叠床10张');
INSERT INTO "public"."emergency_material_statistics" VALUES (13, '县应急管理局', '南昌市', '南昌县', '蒋巷镇', '蒋巷镇政府六楼民兵仓库', 116.025325, 28.770744, '黄金标', '13870669266', 120, '棉被100床、毛毯100床、毛巾被100床、帐篷6顶、折叠床10张');
INSERT INTO "public"."emergency_material_statistics" VALUES (14, '县应急管理局', '南昌市', '南昌县', '蒋巷镇', '蒋巷镇后河排灌站仓库', 116.034125, 28.775473, '黄金标', '13870669266', 300, '棉被100床、毛毯100床、毛巾被100床、帐篷6顶、折叠床10张');
INSERT INTO "public"."emergency_material_statistics" VALUES (15, '县应急管理局', '南昌市', '南昌县', '蒋巷镇', '蒋巷镇西舍仓库', 116.17189, 28.856826, '黄金标', '13870669266', 200, '棉被100床、毛毯100床、毛巾被100床、帐篷6顶、折叠床10张');
INSERT INTO "public"."emergency_material_statistics" VALUES (16, '县应急管理局', '南昌市', '南昌县', '黄马乡', '黄马乡人民政府', 116.021013, 28.338848, '罗柏林', '18702570270', 36, '无');
INSERT INTO "public"."emergency_material_statistics" VALUES (17, '县应急管理局', '南昌市', '南昌县', '富山乡', '富山乡人民政府', 115.854744, 28.520864, '喻跃华', '13870903419', 40, '棉被30、折叠床6');
INSERT INTO "public"."emergency_material_statistics" VALUES (18, '县应急管理局', '南昌市', '南昌县', '塘南镇', '塘南镇人民政府', 116.14349, 28.654787, '倪志超', '13026203979', 30, '棉被30');
INSERT INTO "public"."emergency_material_statistics" VALUES (19, '县应急管理局', '南昌市', '南昌县', '八一乡', '老八一排渍道电排站', 115.970601, 28.567239, '郑必兴', '18970851286', 300, '无');
INSERT INTO "public"."emergency_material_statistics" VALUES (20, '县应急管理局', '南昌市', '南昌县', '八一乡', '叶家棚', 115.960657, 28.556042, '郑必兴', '18970851286', 200, '无');
INSERT INTO "public"."emergency_material_statistics" VALUES (21, '县应急管理局', '南昌市', '南昌县', '武阳镇', '武阳镇人民政府', 116.019749, 28.517266, '徐勇', '15170066968', 45, '棉被60');
INSERT INTO "public"."emergency_material_statistics" VALUES (22, '县应急管理局', '南昌市', '南昌县', '银湖管理处', '小蓝经开区银湖管理处', 115.907692856, 28.570128845, '陈志涛', '17779105591', 30, '棉被32床、毛毯30床、毛巾被60床、折叠床10张');
INSERT INTO "public"."emergency_material_statistics" VALUES (23, '县应急管理局', '南昌市', '南昌县', '金湖管理处', '小蓝经开区金湖管理处', 115.863867297, 28.540310433, '袁梦桐', '18970806148', 30, '棉被30床、折叠床20张');
INSERT INTO "public"."emergency_material_statistics" VALUES (24, '县应急管理局', '南昌市', '南昌县', '南昌县应急救灾物资储备库', '南昌县莲塘南大道1115号', 115.95298, 28.52405, '', '', 0, '棉被3570床、毛毯3500床、毛巾被3570床、帐篷584床、折叠床3500张');