-
Notifications
You must be signed in to change notification settings - Fork 15
Expand file tree
/
Copy pathcapital.sql
More file actions
85 lines (77 loc) · 6.15 KB
/
capital.sql
File metadata and controls
85 lines (77 loc) · 6.15 KB
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
/*
Navicat Premium Data Transfer
Source Server : PostgresSQL
Source Server Type : PostgreSQL
Source Server Version : 120011
Source Host : localhost:5432
Source Catalog : webgistest
Source Schema : public
Target Server Type : PostgreSQL
Target Server Version : 120011
File Encoding : 65001
Date: 06/11/2022 19:30:51
*/
-- ----------------------------
-- Table structure for capital
-- ----------------------------
DROP TABLE IF EXISTS "public"."capital";
CREATE TABLE "public"."capital" (
"gid" int4 NOT NULL,
"name" varchar(254) COLLATE "pg_catalog"."default",
"lat" float8,
"lon" float8,
"geom" "public"."geometry"
)
;
-- ----------------------------
-- Records of capital
-- ----------------------------
INSERT INTO "public"."capital" VALUES (1, '乌鲁木齐', 43.781766, 87.576106, '0101000020110F000001EA27F0379862411DE07BF26CB85441');
INSERT INTO "public"."capital" VALUES (2, '拉萨', 29.710353, 91.163128, '0101000020110F0000187EEA20315B6341036F5D3A42724A41');
INSERT INTO "public"."capital" VALUES (3, '西宁', 36.593385, 101.797123, '0101000020110F000003BFD77B349D65411BA8501EDDB75041');
INSERT INTO "public"."capital" VALUES (4, '兰州', 36.118845, 103.584065, '0101000020110F00002071D4AC55FE65413EB37BAACE775041');
INSERT INTO "public"."capital" VALUES (5, '成都', 30.714088, 104.035277, '0101000020110F000021915B43DC1666411AB5F8B9CC6E4B41');
INSERT INTO "public"."capital" VALUES (6, '重庆', 29.478873, 106.518819, '0101000020110F0000D13C3195DA9D664165F8FE1961384A41');
INSERT INTO "public"."capital" VALUES (7, '贵阳', 26.457344, 106.667779, '0101000020110F0000A142485BF3A566412BCDE40F6E504741');
INSERT INTO "public"."capital" VALUES (8, '昆明', 24.969452, 102.72659, '0101000020110F00006FB22FF7B9CF65414B928D7E5CE94541');
INSERT INTO "public"."capital" VALUES (9, '银川', 38.598221, 106.166906, '0101000020110F00006E2BE4BBB98A664185D49EA3F6CA5141');
INSERT INTO "public"."capital" VALUES (10, '西安', 34.275935, 108.966745, '0101000020110F000058CE8452E9226741592377E13C054F41');
INSERT INTO "public"."capital" VALUES (11, '南宁', 22.748435, 108.233607, '0101000020110F000026E5BEC00FFB664171F72B274CD94341');
INSERT INTO "public"."capital" VALUES (12, '海口', 19.97014, 110.345809, '0101000020110F0000A771A5E9DE6D674187D0D7F49A504141');
INSERT INTO "public"."capital" VALUES (13, '广州', 23.183209, 113.22623, '0101000020110F0000FEBC7FC86F0A684137DA5FE5F63F4441');
INSERT INTO "public"."capital" VALUES (14, '长沙', 28.169918, 112.947463, '0101000020110F0000AF5594C348FB674135BE24C786F34841');
INSERT INTO "public"."capital" VALUES (15, '南昌', 28.652363, 115.893171, '0101000020110F00002563B017669B6841679C95D2C86A4941');
INSERT INTO "public"."capital" VALUES (16, '福州', 26.070848, 119.246152, '0101000020110F00003179919CA6516941D5DFC035B9F24641');
INSERT INTO "public"."capital" VALUES (17, '台北', 25.008394, 121.502901, '0101000020110F000076EE352151CC6941999C6BDBB3F24541');
INSERT INTO "public"."capital" VALUES (18, '杭州', 30.33056, 120.182381, '0101000020110F000000630A2E8A846941B363B6ACFF0D4B41');
INSERT INTO "public"."capital" VALUES (19, '上海', 31.25332, 121.449003, '0101000020110F000054ED002463C969415D046DB18DF74B41');
INSERT INTO "public"."capital" VALUES (20, '武汉', 30.579195, 114.216087, '0101000020110F0000A6EF3C943D406841ADC4ABACB54C4B41');
INSERT INTO "public"."capital" VALUES (21, '合肥', 31.838275, 117.261703, '0101000020110F0000430EBA22C9E56841D655842DCA8C4C41');
INSERT INTO "public"."capital" VALUES (22, '南京', 32.084945, 118.805051, '0101000020110F00008C7E54B9AC39694158C5760F01CC4C41');
INSERT INTO "public"."capital" VALUES (23, '郑州', 34.746135, 113.650581, '0101000020110F00004EA0A09A80216841C1FC7B9C4D814F41');
INSERT INTO "public"."capital" VALUES (24, '济南', 36.608204, 117.047704, '0101000020110F000067B5A35927DA6841EDA280D2DEB95041');
INSERT INTO "public"."capital" VALUES (25, '石家庄', 38.03302, 114.47765, '0101000020110F000062C3DF37754E6841FD531CE3A67C5141');
INSERT INTO "public"."capital" VALUES (26, '太原', 37.798145, 112.482562, '0101000020110F0000AEDAA6AF03E267416A1B7367495C5141');
INSERT INTO "public"."capital" VALUES (27, '呼和浩特', 40.895407, 111.842298, '0101000020110F00004CA46D7536BF67414EAB719DCF0F5341');
INSERT INTO "public"."capital" VALUES (28, '天津', 38.925454, 117.350438, '0101000020110F0000BA0C83E09BEA6841A7DA33C995F85141');
INSERT INTO "public"."capital" VALUES (29, '沈阳', 41.801306, 123.295438, '0101000020110F0000F7F3092DC02D6A418E956195FF925341');
INSERT INTO "public"."capital" VALUES (30, '长春', 43.981648, 125.26047, '0101000020110F0000CC98AF788F986A413C947EA292D65441');
INSERT INTO "public"."capital" VALUES (31, '哈尔滨', 45.693444, 126.56612, '0101000020110F0000A9A24B7F87DF6A41D1FD6DB107DD5541');
INSERT INTO "public"."capital" VALUES (32, '北京', 39.891929, 116.067649, '0101000020110F00001A3ABCF2E1A46841C32DDC8492805241');
INSERT INTO "public"."capital" VALUES (33, '香港', 22.428014, 114.092645, '0101000020110F0000039BF2E287396841CC3182D3D78D4341');
INSERT INTO "public"."capital" VALUES (34, '澳门', 22.184662, 113.552025, '0101000020110F000080E47731251C684108DF0E48A7544341');
INSERT INTO "public"."capital" VALUES (40, '测试1', 39.09596293630548, 93.42773437499999, '0101000020110F0000348A21FA48D66341AD47AFB170105241');
INSERT INTO "public"."capital" VALUES (41, '测试1', 38.2036553180715, 93.51562499999999, '0101000020110F000038E932F80FDB63413EA1EBE33A945141');
INSERT INTO "public"."capital" VALUES (42, '测试1', 35.960222969296694, 92.81249999999997, '0101000020110F000017F1A707D8B4634138E0935F7B625041');
-- ----------------------------
-- Indexes structure for table capital
-- ----------------------------
CREATE INDEX "capital_geom_idx" ON "public"."capital" USING gist (
"geom" "public"."gist_geometry_ops_2d"
);
-- ----------------------------
-- Primary Key structure for table capital
-- ----------------------------
CREATE SEQUENCE IF NOT EXISTS capital_gid_seq;
ALTER TABLE "public"."capital" ALTER COLUMN "gid" SET DEFAULT nextval('capital_gid_seq');
ALTER TABLE "public"."capital" ADD CONSTRAINT "capital_pkey" PRIMARY KEY ("gid");