postgis——Geometries

最新推荐文章于 2025-04-12 09:42:48 发布

renshenguo123

最新推荐文章于 2025-04-12 09:42:48 发布

阅读量303

点赞数

分类专栏： postgis sql 文章标签： postGIS sql geometry

本文链接：https://blog.youkuaiyun.com/renshenguo123/article/details/104015601

版权

postgis 同时被 2 个专栏收录

3 篇文章

订阅专栏

sql

2 篇文章

订阅专栏

前提：假设已经拥有了一个空间数据库nyc

CREATE TABLE geometries (name varchar, geom geometry);  

INSERT INTO geometries VALUES
  ('Point', 'POINT(0 0)'),
  ('Linestring', 'LINESTRING(0 0, 1 1, 2 1, 2 2)'),
  ('Polygon', 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'),
  ('PolygonWithHole', 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(1 1, 1 2, 2 2, 2 1, 1 1))'),
  ('Collection', 'GEOMETRYCOLLECTION(POINT(2 0),POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)))');

SELECT name, ST_AsText(geom) FROM geometries;

The above example CREATEs a table (geometries) then INSERTs five geometries: a point, a line, a polygon, a polygon with a hole, and a collection. Finally, the inserted rows are SELECTed and displayed in the Output pane.

参考