postgreSql使用postgis实现空间聚簇

最新推荐文章于 2024-05-26 15:07:40 发布
最新推荐文章于 2024-05-26 15:07:40 发布
阅读量860 收藏 5
点赞数
文章标签： postgresql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dg88534187/article/details/131209244
版权

postgreSql使用postgis实现空间聚簇

一.如何获取聚簇

/* 
使用ST_ClusterDBSCAN函数,ST_ClusterDBSCAN是窗口函数用来对数据进行聚簇
第一个参数是字段,第二个参数是距离,他是用的是度,这里写0.000179大约就是20米,minpoints表示多少个聚合才算是一个簇,比如两台车就算是聚集,那就设置为2
*/
CREATE TEMP TABLE temp_vehicleGatherInfoByAreNumber as
 SELECT *, ST_ClusterDBSCAN(pt, eps := 0.000179, minpoints := 2) OVER () AS cluster_id FROM vehicle_last_location

在这里插入图片描述

二.如何获取聚簇中心点

/*ST_Centroid(ST_Collect(pt))*/
SELECT cluster_id,ST_Centroid(ST_Collect(pt)) as center_point,
    st_x(ST_Centroid(ST_Collect(pt))) as clusterCentLng,st_y(ST_Centroid(ST_Collect(pt))) as clusterCentLat FROM temp_vehicleGatherInfoByAreNumber GROUP BY cluster_id

三.如何获取一个包裹某个聚簇下的的最小多边形

/*ST_ConvexHull(ST_Collect(pt))*/
SELECT  ST_AsText(ST_ConvexHull(ST_Collect(pt))) AS cluster_pt, cluster_id,COUNT(1) FROM  temp_vehicleGatherInfoByAreNumber16867070588788
WHERE cluster_id is not null
GROUP BY cluster_id

效果在这里插入图片描述

四.测试数据与表

建表sql

CREATE TABLE "public"."vehicle_last_location" (
  "id" int4 NOT NULL DEFAULT nextval('vehicle_last_location_id_seq'::regclass),
  "vehid" int4 NOT NULL,
  "pt" geometry(POINT, 4326),
  "pt_time" timestamp(0) NOT NULL,
  "speed" int2,
  "direction" int2,
  "biz_status" int2,
  "acc_on" int2,
  "create_on" timestamp(0),
  "are_number" varchar(32) COLLATE "pg_catalog"."default",
  CONSTRAINT "vehicle_last_location_pkey" PRIMARY KEY ("id"),
  CONSTRAINT "vehicle_last_location_vehid_unique" UNIQUE ("vehid")
)
;

ALTER TABLE "public"."vehicle_last_location" 
  OWNER TO "gis";

COMMENT ON COLUMN "public"."vehicle_last_location"."id" IS '主键';

COMMENT ON COLUMN "public"."vehicle_last_location"."vehid" IS '车辆id';

COMMENT ON COLUMN "public"."vehicle_last_location"."pt" IS '定位';

COMMENT ON COLUMN "public"."vehicle_last_location"."pt_time" IS '定位时间';

COMMENT ON COLUMN "public"."vehicle_last_location"."speed" IS '速度';

COMMENT ON COLUMN "public"."vehicle_last_location"."direction" IS '方向';

COMMENT ON COLUMN "public"."vehicle_last_location"."biz_status" IS '营运状态。1. 载客 2.接单 3.空驶 4.停运';

COMMENT ON COLUMN "public"."vehicle_last_location"."are_number" IS '行政区划代码';

INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (182342, 3382, '0101000020E6100000E0254BC0C2135B40CD58349D9DC43640', '2023-06-14 15:19:06', 0, 128, 3, 1, '2023-06-14 15:20:39', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (182702, 4767, '0101000020E6100000D86CD25ABE135B406AFB57569AC43640', '2023-06-14 15:19:20', 0, 136, 3, 0, '2023-06-14 15:20:41', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (182422, 4051, '0101000020E61000004E9CDCEF50175B4011018750A5CE3640', '2023-06-14 15:19:20', 0, 220, 3, 0, '2023-06-14 15:20:39', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186056, 236, '0101000020E6100000F8215CEEB9145B4072F1CA0882CE3640', '2023-06-14 15:20:30', 0, 92, 3, 1, '2023-06-14 15:21:14', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186293, 3737, '0101000020E61000008990CD68BE135B401E40AC249FC43640', '2023-06-14 15:20:14', 0, 0, 3, 0, '2023-06-14 15:21:15', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181810, 3771, '0101000020E6100000A30E1811B2145B40D66B8D1B91CE3640', '2023-06-14 15:19:49', 0, 128, 3, 1, '2023-06-14 15:21:36', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181314, 2235, '0101000020E610000052448655BC135B406E61F043B8C43640', '2023-06-14 15:20:33', 0, 146, 3, 0, '2023-06-14 15:21:34', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184881, 7278, '0101000020E61000007586BCF8B5145B403779B79F79CE3640', '2023-06-14 15:20:35', 0, 100, 1, 1, '2023-06-14 15:21:01', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184890, 7101, '0101000020E610000007E3BA3CB0145B4070DBE4DD7ECE3640', '2023-06-14 15:20:25', 13, 114, 3, 0, '2023-06-14 15:21:01', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181988, 1517, '0101000020E61000000E9905EDE8195B40F508480EEBD83640', '2023-06-14 15:20:27', 0, 162, 3, 1, '2023-06-14 15:21:37', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186052, 2590, '0101000020E6100000867AE73DBB135B40F8AA9509BFC43640', '2023-06-14 15:20:27', 0, 264, 3, 0, '2023-06-14 15:21:14', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184927, 7148, '0101000020E6100000A110018750175B40E1D90BF2A0CE3640', '2023-06-14 15:20:27', 0, 50, 3, 0, '2023-06-14 15:21:02', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (185000, 7238, '0101000020E610000052448655BC145B408A7615527ECE3640', '2023-06-14 15:20:27', 0, 184, 3, 1, '2023-06-14 15:21:02', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (182384, 4257, '0101000020E610000063A404EABA135B4052CDBF70C1C43640', '2023-06-14 15:19:14', 0, 176, 3, 1, '2023-06-14 15:20:39', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (183017, 4937, '0101000020E6100000350708E6E8195B4037C30DF8FCD83640', '2023-06-14 15:19:18', 0, 10, 3, 1, '2023-06-14 15:20:42', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186326, 2721, '0101000020E6100000F3127664BF135B40993FB980AAC43640', '2023-06-14 15:20:36', 0, 0, 3, 1, '2023-06-14 15:21:15', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186214, 2301, '0101000020E61000001B6CD771E9195B40130A117008D93640', '2023-06-14 15:20:41', 0, 358, 3, 1, '2023-06-14 15:21:15', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186301, 1754, '0101000020E610000039B4C876BE135B40AEAE1D9FA3C43640', '2023-06-14 15:19:47', 0, 0, 3, 0, '2023-06-14 15:21:15', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186396, 1696, '0101000020E61000000A01E647E9195B401D45C34F09D93640', '2023-06-14 15:20:38', 0, 2, 3, 1, '2023-06-14 15:21:16', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186389, 2829, '0101000020E610000000DBD453BE135B402056924FA2C43640', '2023-06-14 15:20:35', 0, 234, 3, 0, '2023-06-14 15:21:16', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186400, 2264, '0101000020E6100000249C16BCE8195B4058662455EED83640', '2023-06-14 15:20:38', 0, 356, 3, 1, '2023-06-14 15:21:16', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186418, 2832, '0101000020E6100000D027F224E9195B4091C85193F3D83640', '2023-06-14 15:20:35', 0, 320, 3, 1, '2023-06-14 15:21:16', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (183065, 12477, '0101000020E61000007725DC3EBE135B40715AF0A2AFC43640', '2023-06-14 15:19:14', 0, 302, 3, 0, '2023-06-14 15:20:42', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186376, 2437, '0101000020E610000017E958B8BF135B404B345B8C94C43640', '2023-06-14 15:20:33', 0, 204, 3, 1, '2023-06-14 15:21:16', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (183181, 877, '0101000020E6100000D3AC5954B1145B4093B1C7317FCE3640', '2023-06-14 15:19:20', 0, 312, 3, 0, '2023-06-14 15:20:43', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186173, 3257, '0101000020E6100000DD0F6595BF135B4046425BCEA5C43640', '2023-06-14 15:05:40', 0, 0, 3, 1, '2023-06-14 15:06:18', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (185957, 78, '0101000020E61000002004F716E9195B40D93A4BA3DCD83640', '2023-06-14 15:20:30', 0, 252, 3, 1, '2023-06-14 15:21:13', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186002, 2004, '0101000020E6100000673C248FBA135B4099966BE4CDC43640', '2023-06-14 15:20:14', 0, 120, 3, 0, '2023-06-14 15:21:13', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186100, 705, '0101000020E610000099D36531B1145B4040B4697F7ACE3640', '2023-06-14 15:20:38', 0, 0, 3, 1, '2023-06-14 15:21:14', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (186285, 3483, '0101000020E6100000867AE73DBB145B406BAF188878CE3640', '2023-06-14 15:20:27', 0, 0, 3, 1, '2023-06-14 15:21:15', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181329, 1912, '0101000020E6100000E292E34EE9195B405B5F24B4E5D83640', '2023-06-14 15:20:33', 0, 114, 3, 1, '2023-06-14 15:21:34', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181406, 7, '0101000020E610000050C24CDBBF135B40599BD9C19BC43640', '2023-06-14 15:20:05', 0, 0, 3, 0, '2023-06-14 15:21:34', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181415, 3186, '0101000020E61000008C08D98CE6195B408A869F12EAD83640', '2023-06-14 15:20:19', 0, 4, 3, 1, '2023-06-14 15:21:34', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181561, 3176, '0101000020E61000000A70674CAE145B40BEAC763A7DCE3640', '2023-06-14 15:20:30', 8, 110, 3, 1, '2023-06-14 15:21:35', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181605, 3203, '0101000020E610000062105839B4145B4069B6182981CE3640', '2023-06-14 15:19:58', 0, 0, 3, 0, '2023-06-14 15:21:35', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181606, 3204, '0101000020E6100000E6B66AC4B9135B4060343EA6C8C43640', '2023-06-14 15:20:36', 1, 28, 3, 1, '2023-06-14 15:21:35', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181675, 1881, '0101000020E6100000D4BF11CAE8195B40D874173BF4D83640', '2023-06-14 15:20:14', 0, 338, 3, 1, '2023-06-14 15:21:36', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (181817, 3780, '0101000020E61000000E9905EDE8195B40D189171E0ED93640', '2023-06-14 15:20:33', 0, 358, 3, 1, '2023-06-14 15:21:36', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (182076, 3453, '0101000020E6100000A32BFEDCBD135B400B0414FDB4C43640', '2023-06-14 15:20:36', 0, 170, 3, 0, '2023-06-14 15:21:38', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (182162, 430, '0101000020E6100000F37EC9B3B8145B40242039AC83CE3640', '2023-06-14 15:20:33', 0, 0, 3, 1, '2023-06-14 15:21:39', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (182226, 2328, '0101000020E610000009168733BF135B409E4E9F0AA5C43640', '2023-06-14 15:20:33', 0, 262, 3, 0, '2023-06-14 15:21:40', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184145, 224, '0101000020E6100000D4D4B2B5BE135B40849688CA99C43640', '2023-06-14 15:20:38', 0, 140, 3, 0, '2023-06-14 15:20:57', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184304, 2139, '0101000020E6100000F168E388B5145B4072D4E43C76CE3640', '2023-06-14 15:20:29', 0, 88, 3, 0, '2023-06-14 15:20:58', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184353, 1655, '0101000020E6100000F594AFDEBB135B40EC76E3CAC6C43640', '2023-06-14 15:20:41', 0, 140, 3, 0, '2023-06-14 15:20:58', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184376, 5151, '0101000020E610000052448655BC145B40FE168A6174CE3640', '2023-06-14 15:20:29', 0, 278, 3, 0, '2023-06-14 15:20:58', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184383, 3221, '0101000020E61000000C864D77B1145B40CAFD0E4581CE3640', '2023-06-14 15:20:38', 24, 104, 1, 1, '2023-06-14 15:20:58', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184526, 2819, '0101000020E6100000AF5FB01BB6145B40D847A7AE7CCE3640', '2023-06-14 15:20:35', 0, 190, 3, 1, '2023-06-14 15:20:59', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184589, 448, '0101000020E610000065263E64B7145B403779B79F79CE3640', '2023-06-14 15:20:22', 5, 102, 3, 1, '2023-06-14 15:21:00', '450100');
        INSERT INTO "vehicle_last_location" ("id", "vehid", "pt", "pt_time", "speed", "direction", "biz_status", "acc_on", "create_on", "are_number") VALUES (184790, 4891, '0101000020E61000007BA01518B2145B40FE5056F98BCE3640', '2023-06-14 15:20:33', 0, 140, 3, 1, '2023-06-14 15:21:01', '450100');
小圆MC
关注
  • 0
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
PostgreSQL实战之PostGIS
Auspicious航的博客
05-15 931
空间数据是一类重要的数据，地图导航、打车软件、餐厅推荐、外卖快递这些我们日常生活中用到的软件，背后都与空间数据息息相关。空间数据通常结构复杂，数据量大，对于空间数据的分析查询，其模式也迥异于普通的数据，一般的DBMS难以满足要求。PostgreSQL已经内置了很多空间特性:几何数据类型、几何类型函数与运算符、空间数据索引。但对于现实世界的复杂需求仍力有不逮:有很多辅路支路的道路，需要用多条折线来表示;行政区域的飞地，需要用多个多边形的集合来表示;
PostGIS-入门实例
孙霸天的专栏
03-03 2290
PostgreSQL已经内置了很多空间特性：几何数据类型、几何类型函数与运算符、空间数据索引但对于现实世界的复杂需求仍力有不逮：有很多辅路支路的道路，需要用多条折线来表示；行政区域的飞地，需要用多个多边形的集合来表示;高效判断点是否在多边形内、两条折线是否有交点，两个区域相离、相邻、重叠还是包含。好在PostgreSQL强大 的扩展机制为解决问题留下了一个窗口，PostGIS 为此而生，它已经成为GIS行业的事实标准。
PostGIS空间数据库之空间数据融合实践
夜郎King的博客
02-01 4594
本文采用实例的方式进行讲解，将ST_Union()和ST_Collect()这两个函数进行空间融合实战，我们通过实际的两个面的函数操作和实际场景融合，希望通过实战的方式让你了解两者的区别，在具体使用空间函数的时候给予充分的评估和参考。
Postgis实现聚类分析
xifenglie123321的博客
03-27 595
- 该函数是窗口函数，主要是用K-means(K均值聚类)算法进行聚类，算法原理比较简单，容易实现，主要适用于点样本数据，如果是多边形则用多边形的中心点计算，只有一个参数K簇，就是事先明确了要把这一堆样本数据聚成K个类，然后去计算一个目标函数达到最优解，因此K值对结果影响比较大，不太好选取，而且该算法而且适合凸的数据集，这也算法容易收敛；都是根据要素的自身属性，可能是空间的或者非空间的，利用数学方法按照某种相似性或差异性的指标，定量的确定各个要素之间的亲疏关系，然后按照这种亲疏关系的程度对要素进行聚类。
在PostgreSQL中安装和使用PostGIS进行空间数据处理的详细教程
最新发布
优秀码农的博客
05-26 585
PostGIS是一个开源的地理空间扩展，为PostgreSQL数据库提供了丰富的地理信息系统（GIS）功能。通过在数据库中安装PostGIS，您可以进行空间数据处理、空间查询和地理信息分析等操作。给数据库安装拓展：连接到您的数据库，并运行以下命令以在数据库中安装PostGIS相关拓展：(给单个数据库创建拓展非全局)这将返回与给定点在半径为1.0的距离内的空间数据记录。如果成功安装，将显示PostGIS的版本信息。
PostGIS - ST_ClusterDBSCAN聚类算法
研究与专注
01-27 4424
目录 DBSCAN是什么？ PostGIS中实现的一个聚类算法，可根据密度对要素进行聚类，该方法使用的是“DBSCAN”算法。 DBSCAN是什么？ “DBSCSN”并不是扫描数据库（scan database），而是“Density-based spatial clustering of applications with noise”的缩写，基于密度的空间聚类算法，适用于含有噪声数据的...
PostGIS实现聚类分析-ST_ClusterDBSCAN
Gerry-wu
02-13 2608
简要介绍了聚类的一些概念原理，介绍了Postgis相关聚类函数，详细介绍了ST_ClusterDBSCAN的使用，并以河南省POI数据为例做了相关实验分析。详细内容参见公众号
PGSQL安装PostGIS扩展模块
Charge8的博客
01-19 4026
PGSQL安装PostGIS扩展模块
PostgreSql+PostGis创建空间数据库
05-03
本文将指导您如何使用PostgreSql 和PostGis 创建一个空间数据库。 一、准备安装包 在开始安装 PostgreSql 和PostGis 之前，需要下载相关的安装包。PostgreSql 的安装包可以从官方网站下载，PostGis 的安装包可以从...
centos操作系统安装postgresql+postgis部署配置
03-03
基于pg库进行地理空间数据存储的开源数据库技术方案，只有正确安装改库才能继续后续空间数据正常管理、空间数据很好的分析，从而实现系统中正常运行，postgresql与postgis对应版本问题或升级也可参考类似方法进行...
详解Linux中PostgreSQL和PostGIS的安装和使用
09-09
在Linux环境中，PostgreSQL是一种强大的开源关系型数据库管理系统，而PostGIS则是其扩展，提供了空间数据存储和地理处理功能。本文将详细介绍如何在Linux上安装和使用这两个组件，以及一些关键注意事项。 首先，...
postgis:使用PostgreSQL和PostGIS https进行空间数据管理
04-05
邮政使用PostgreSQL和PostGIS进行空间数据管理样本数据集 有用的资源SQL教程变更栏位类型ALTER TABLE citiesALTER COLUMN population TYPE INTUSING population::integer非空间数据SQL查询以下示例使用样本数据集 ...
PostGIS教程一：PostGIS介绍
挣钱花388的博客
08-11 2081
"这个问题，对多边形进行计算，计算量非常大而且难以计算，但在计算矩形的情况下，计算比较容易，而且速度非常快。PostGIS 0.1的开发花费了不到一个月的时间，但做一个“MyGIS" 0.1可能需要更长的时间，可能永远也不会成功。而构建的专有的、独立的系统，即应用程序和平面文件之间的耦合性非常高，平面文件里的空间数据没有数据独立性。在PostGIS 1.0中，这种新的、更快的、轻量级的数据表示成为了默认的数据表示。时，PostGIS团队查看了它们的代码，这坚定了最初使用PostgreSQL的决定。
Postgresql - Cluster
chuckchen1222的博客
01-02 3625
CLUSTER — cluster a table according to an index 根据索引对表进行聚类   cluster指示postgresql根据index_name指定的索引对table_name指定的表进行集群。表上必须已经有索引。 当表被cluster时，它将根据索引信息进行物理重新排序。cluster是一次性操作：当表随后被更新时，更新不会被cluster。也就是...
Linux在线安装部署postgresql12+postgis3，2024年最新看完这篇
sffhhr的博客
04-15 1117
(img-lLmCO8Yz-1713152371109)]修改 postgresql.conf，将监听修改为监听所有主机的请求。为CentOS7/RHEL7安装EPEL 仓库（repo）修改pg_hba.conf配置文件，添加允许其他机器访问。注意：扩展的postgis依赖只对当前数据库有效。搜索配置位置 :/listen，添加以下代码。查看密码（已经过MD5加密）yum在线安装postgis。三、添加postgis依赖。二、配置pgsql12。命令行登录pgsql。
postgres postgis 基本使用
偶是一只小小鸟~
11-17 731
postgis 范围搜索 创建扩展 CREATE EXTENSION IF NOT EXISTS postgis SCHEMA public; 设置给系统的schema ALTER EXTENSION postgis SET SCHEMA pg_catalog; geo 表 CREATE TABLE device_geo ( id BIGSERIAL, ...
PostgreSQL Cluster系列教程
xabc3000的专栏
08-22 8819
本教程是PostgreSQL Cluster系列教程的一部分，该系列包括： PostgreSQL9.1 PITR示例  （该教程主要阐述DBA如何基于WAL日志做备份恢复）PostgreSQL9.1 Warm-Standby ---之基于拷贝WAL文件的方法 (file-based log shipping)PostgreSQL9.1 Warm-Standby ---之基于流复制的方法 (
聚类算法：DBScan算法
热门推荐
行者小朱的博客
01-12 1万+
对算法的用例是在Spark平台对学生上网记录处理的一个实例，参考地址见DBScan算法运用实例 一、问题提出 先考虑一个问题，对下图1中的数据集合怎么聚类？对图2的无规则的数据集合又该如何聚类？ 二、概念介绍 邻域半径(radius)：以当前对象为核心确定密度区域范围时引用的长度，二维平面中就指以当前对象为圆心确定圆时引用所用的半径。如下图中的Eps即为领域半径。 密度域值(
在ArcGIS Pro中使用密度聚类算法DBSCAN
qq_912917507的博客
03-16 6550
点击分析——工具箱 搜索 聚类 cluster，找到Density-based Clustering（DBSCAN） 聚类方法有三种：DBSCAN，HDNSCAN，OPTICS，它们的具体差别，可以看大神的博客 聚类算法之DBSCAN算法 聚类算法之OPTICS算法 按照工具箱的要求就可以操作了 ArcGIS Pro帮助中的介绍如下：取聚类，并标识所有周围噪点。存在...
搭建postgresql + postgis空间数据引擎
09-03
要搭建PostgreSQL PostGIS空间数据引擎，需按照以下步骤进行操作。 首先，确保已经安装了PostgreSQL数据库服务器。可以从官方网站上下载并安装最新版本的PostgreSQL。 完成安装后，打开命令行终端并切换到PostgreSQL的安装目录下的bin文件夹。在命令行中输入以下命令来启动PostgreSQL： ``` pg_ctl -D 数据库存储路径 start ``` 数据库存储路径是指定数据库文件将保存的目录路径。将其替换为你想要使用的路径。 启动后，会在命令行中显示一些数据库连接信息，包括端口号和数据库用户名等。 接下来，需要创建一个新的数据库。在命令行中输入以下命令： ``` createdb -U 数据库用户名 -h localhost -p 端口号 新数据库名称 ``` 将数据库用户名、端口号和新数据库名称替换为真实值。 创建数据库后，需要在其中安装PostGIS扩展。在命令行中输入以下命令来连接到新数据库： ``` psql -U 数据库用户名 -h localhost -p 端口号 新数据库名称 ``` 进入数据库后，运行以下命令来创建PostGIS扩展： ``` CREATE EXTENSION postgis; ``` 该命令将在数据库中创建PostGIS所需的表和函数。安装完成后，就可以在数据库中存储和查询空间数据了。 最后，可以使用数据库管理工具，如pgAdmin等，连接到数据库进行操作和管理。可以使用这些工具来创建数据表、导入和导出空间数据，以及执行空间查询等操作。 总结一下，搭建PostgreSQL PostGIS空间数据引擎的主要步骤是：安装PostgreSQL，启动数据库服务器，创建新数据库，安装PostGIS扩展，然后使用数据库管理工具进行操作和管理。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值