ST_BdPolyFromText
描述
基于给定的由WKT(Well-Known Text) MultiLineString表示的一条或多条封闭曲线为基础来构造一个Polygon。
函数声明geometry ST_BdPolyFromText(text WKT,integer srid);
ST_BdMPolyFromText
描述
基于给定的由WKT(Well-Known Text) MultiLineString表示的一条或多条封闭曲线为基础来构造一个MultiPolygon。
函数声明geometry ST_BdMPolyFromText(text WKT,integer srid);
ST_Box2dFromGeoHash
描述
返回与给定GeoHash字符串对应的Box2D对象。
函数声明box2d ST_Box2dFromGeoHash(text geohash,integer precision=full_precision_of_geohash);
使用示例SELECT ST_Box2dFromGeoHash('9qqj7nmxncgyy4d0dbxqz0');
st_geomfromgeohash
--------------------------------------------------
BOX(-115.17281636.114646,-115.17281636.114646)
SELECT ST_Box2dFromGeoHash('9qqj7nmxncgyy4d0dbxqz0',0);
st_box2dfromgeohash
----------------------
BOX(-180-90,18090)
SELECT ST_Box2dFromGeoHash('9qqj7nmxncgyy4d0dbxqz0',10);
st_box2dfromgeohash
---------------------------------------------------------------------------
BOX(-115.1728212833436.1146408319473,-115.17281055450436.1146461963654)
ST_GeogFromText
描述
返回与给定的WKT(Well-Known Text)或扩展WKT表示法相对应的地理对象。
函数声明geography ST_GeogFromText(text EWKT);
使用示例---converting lon lat coords to geography
ALTER TABLE sometable ADD COLUMN geog geography(POINT,4326);
UPDATE sometable SET geog=ST_GeogFromText('SRID=4326;POINT('||lon||' '||lat||')');
---specify a geography pointusingEPSG:4267,NAD27
SELECT ST_AsEWKT(ST_GeogFromText('SRID=4267;POINT(-77.0092 38.889588)'));
st_asewkt
-------------------------------------
SRID=4267;POINT(-77.009238.889588)
ST_GeographyFromText
描述
返回与给定的WKT或扩展WKT表示法相对应的地理对象。
函数声明geography ST_GeographyFromText(text EWKT);
使用示例SELECT ST_AsEWKT(ST_GeographyFromText('SRID=4267;POINT(-77.0092 38.889588)'));
st_asewkt
-------------------------------------
SRID=4267;POINT(-77.009238.889588)
ST_GeogFromWKB
描述
返回与给定的Well-Known Binary (WKB)或extended Well Known Binary (EWKB)表示法相对应的地理对象。
函数声明geography ST_GeogFromWKB(bytea wkb);
使用示例--Althoughbytea rep contains single \, these need to be escapedwheninsertingintoa table
SELECT ST_AsText(
ST_GeogFromWKB(E'\\001\\002\\000\\000\\000\\002\\000\\000\\000\\037\\205\\353Q\\270~\\\\\\300\\323Mb\\020X\\231C@\\020X9\\264\\310~\\\\\\300)\\\\\\217\\302\\365\\230C@')
);
st_astext
------------------------------------------------------
LINESTRING(-113.9839.198,-113.98139.195)
(1row)
ST_GeomFromTWKB
描述
返回一个与给定的TWKB(Tiny Well-Known Binary)表示法相对应的几何对象。
函数声明geometry ST_GeomFromTWKB(bytea twkb);
使用示例SELECT ST_AsText(ST_GeomFromTWKB(ST_AsTWKB('LINESTRING(126 34, 127 35)'::geometry)));
st_astext
-----------------------------
LINESTRING(12634,12735)
(1row)
SELECT ST_AsEWKT(
ST_GeomFromTWKB(E'\\x620002f7f40dbce4040105')
);
st_asewkt
------------------------------------------------------
LINESTRING(-113.9839.198,-113.98139.195)
(1row)
ST_GeomCollFromText
描述
以给定的WKT表示法和SRID构造相应的几何对象集合,如果未指定SRID,则其默认值为0。
函数声明geometry ST_GeomCollFromText(text WKT,integer srid);
geometry ST_GeomCollFromText(text WKT);
使用示例SELECT ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(1 2),LINESTRING(1 2, 3 4))');
ST_GeomFromEWKB
描述
返回一个与给定的Extended Well-Known Binary(EWKB)表示法相对应的几何对象。
函数声明geometry ST_GeomFromEWKB(bytea EWKB);
使用示例SELECT ST_GeomFromEWKB(E'\\001\\002\\000\\000 \\255\\020\\000\\000\\003\\000\\000\\000\\344J=
\\013B\\312Q\\300n\\303(\\010\\036!E@''\\277E''K
\\312Q\\300\\366{b\\235*!E@\\225|\\354.P\\312Q
\\300p\\231\\323e1!E@');
ST_GeomFromEWKT
描述
返回一个与给定的Extended Well-Known Text(EWKT)表示法相对应的几何对象。
函数声明geometry ST_GeomFromEWKT(text EWKT);
使用示例SELECT ST_GeomFromEWKT('SRID=4269;LINESTRING(-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932)');
SELECT ST_GeomFromEWKT('SRID=4269;MULTILINESTRING((-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932))');
SELECT ST_GeomFromEWKT('SRID=4269;POINT(-71.064544 42.28787)');
SELECT ST_GeomFromEWKT('SRID=4269;POLYGON((-71.1776585052917 42.3902909739571,-71.1776820268866 42.3903701743239,
-71.1776063012595 42.3903825660754,-71.1775826583081 42.3903033653531,-71.1776585052917 42.3902909739571))');
SELECT ST_GeomFromEWKT('SRID=4269;MULTIPOLYGON(((-71.1031880899493 42.3152774590236,
-71.1031627617667 42.3152960829043,-71.102923838298 42.3149156848307,
-71.1023097974109 42.3151969047397,-71.1019285062273 42.3147384934248,
-71.102505233663 42.3144722937587,-71.10277487471 42.3141658254797,
-71.103113945163 42.3142739188902,-71.10324876416 42.31402489987,
-71.1033002961013 42.3140393340215,-71.1033488797549 42.3139495090772,
-71.103396240451 42.3138632439557,-71.1041521907712 42.3141153348029,
-71.1041411411543 42.3141545014533,-71.1041287795912 42.3142114839058,
-71.1041188134329 42.3142693656241,-71.1041112482575 42.3143272556118,
-71.1041072845732 42.3143851580048,-71.1041057218871 42.3144430686681,
-71.1041065602059 42.3145009876017,-71.1041097995362 42.3145589148055,
-71.1041166403905 42.3146168544148,-71.1041258822717 42.3146748022936,
-71.1041375307579 42.3147318674446,-71.1041492906949 42.3147711126569,
-71.1041598612795 42.314808571739,-71.1042515013869 42.3151287620809,
-71.1041173835118 42.3150739481917,-71.1040809891419 42.3151344119048,
-71.1040438678912 42.3151191367447,-71.1040194562988 42.3151832057859,
-71.1038734225584 42.3151140942995,-71.1038446938243 42.3151006300338,
-71.1038315271889 42.315094347535,-71.1037393329282 42.315054824985,
-71.1035447555574 42.3152608696313,-71.1033436658644 42.3151648370544,
-71.1032580383161 42.3152269126061,-71.103223066939 42.3152517403219,
-71.1031880899493 42.3152774590236)),
((-71.1043632495873 42.315113108546,-71.1043583974082 42.3151211109857,
-71.1043443253471 42.3150676015829,-71.1043850704575 42.3150793250568,-71.1043632495873 42.315113108546)))');
ST_GeometryFromText
描述
返回一个与给定的Well-Known Text(WKT)表示法相对应的几何对象。与ST_GeomFromText 函数相同。
函数声明geometry ST_GeometryFromText(text WKT);
geometry ST_GeometryFromText(text WKT,integer srid);
使用示例参见ST_GeomFromText;
ST_GeomFromGeoHash
描述
返回一个与给定的GeoHash字符串相对应的几何对象。
函数声明geometry ST_GeomFromGeoHash(text geohash,integer precision=full_precision_of_geohash);
使用示例SELECT ST_AsText(ST_GeomFromGeoHash('9qqj7nmxncgyy4d0dbxqz0'));
st_astext
--------------------------------------------------------------------------------------------------------------------------
POLYGON((-115.17281636.114646,-115.17281636.114646,-115.17281636.114646,-115.17281636.114646,-115.17281636.114646))
SELECT ST_AsText(ST_GeomFromGeoHash('9qqj7nmxncgyy4d0dbxqz0',4));
st_astext
------------------------------------------------------------------------------------------------------------------------------
POLYGON((-115.312536.03515625,-115.312536.2109375,-114.960937536.2109375,-114.960937536.03515625,-115.312536.03515625))
SELECT ST_AsText(ST_GeomFromGeoHash('9qqj7nmxncgyy4d0dbxqz0',10));
st_astext
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
POLYGON((-115.1728212833436.1146408319473,-115.1728212833436.1146461963654,-115.17281055450436.1146461963654,-115.17281055450436.1146408319473,-115.1728212833436.1146408319473))
ST_GeomFromGML
描述
接受一个以GML表示的几何对象字符串为输入,输出一个几何对象。
函数声明geometry ST_GeomFromGML(text geomgml);
geometry ST_GeomFromGML(text geomgml,integer srid);
使用示例SELECT ST_GeomFromGML('
-71.16028,42.258729 -71.160837,42.259112 -71.161143,42.25932
');
ST_GeomFromGeoJSON
描述
接受一个以GeoJSON表示的几何对象为输入,输出一个几何对象。
函数声明geometry ST_GeomFromGeoJSON(text geomjson);
geometry ST_GeomFromGeoJSON(json geomjson);
geometry ST_GeomFromGeoJSON(jsonb geomjson);
使用示例SELECT ST_AsText(ST_GeomFromGeoJSON('{"type":"Point","coordinates":[-48.23456,20.12345]}'))Aswkt;
wkt
------
POINT(-48.2345620.12345)
ST_GeomFromKML
描述
接受一个以KML表示的几何对象字符串为输入,输出一个几何对象。
函数声明geometry ST_GeomFromKML(text geomkml);
使用示例SELECT ST_GeomFromKML('
-71.1663,42.2614
-71.1667,42.2616
');
ST_GMLToSQL
描述
接受一个以GML表示的几何对象字符串为输入,输出一个几何对象。等同于ST_GeomFromGML。
函数声明geometry ST_GMLToSQL(text geomgml);
geometry ST_GMLToSQL(text geomgml,integer srid);
使用示例None
ST_GeomFromText
描述
接受一个以Well-Known Text(WKT)表示的几何对象字符串为输入,输出一个几何对象。
函数声明geometry ST_GeomFromText(text WKT);
geometry ST_GeomFromText(text WKT,integer srid);
使用示例SELECT ST_GeomFromText('LINESTRING(-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932)');
SELECT ST_GeomFromText('LINESTRING(-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932)',4269);
SELECT ST_GeomFromText('MULTILINESTRING((-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932))');
SELECT ST_GeomFromText('POINT(-71.064544 42.28787)');
SELECT ST_GeomFromText('POLYGON((-71.1776585052917 42.3902909739571,-71.1776820268866 42.3903701743239,
-71.1776063012595 42.3903825660754,-71.1775826583081 42.3903033653531,-71.1776585052917 42.3902909739571))');
SELECT ST_GeomFromText('MULTIPOLYGON(((-71.1031880899493 42.3152774590236,
-71.1031627617667 42.3152960829043,-71.102923838298 42.3149156848307,
-71.1023097974109 42.3151969047397,-71.1019285062273 42.3147384934248,
-71.102505233663 42.3144722937587,-71.10277487471 42.3141658254797,
-71.103113945163 42.3142739188902,-71.10324876416 42.31402489987,
-71.1033002961013 42.3140393340215,-71.1033488797549 42.3139495090772,
-71.103396240451 42.3138632439557,-71.1041521907712 42.3141153348029,
-71.1041411411543 42.3141545014533,-71.1041287795912 42.3142114839058,
-71.1041188134329 42.3142693656241,-71.1041112482575 42.3143272556118,
-71.1041072845732 42.3143851580048,-71.1041057218871 42.3144430686681,
-71.1041065602059 42.3145009876017,-71.1041097995362 42.3145589148055,
-71.1041166403905 42.3146168544148,-71.1041258822717 42.3146748022936,
-71.1041375307579 42.3147318674446,-71.1041492906949 42.3147711126569,
-71.1041598612795 42.314808571739,-71.1042515013869 42.3151287620809,
-71.1041173835118 42.3150739481917,-71.1040809891419 42.3151344119048,
-71.1040438678912 42.3151191367447,-71.1040194562988 42.3151832057859,
-71.1038734225584 42.3151140942995,-71.1038446938243 42.3151006300338,
-71.1038315271889 42.315094347535,-71.1037393329282 42.315054824985,
-71.1035447555574 42.3152608696313,-71.1033436658644 42.3151648370544,
-71.1032580383161 42.3152269126061,-71.103223066939 42.3152517403219,
-71.1031880899493 42.3152774590236)),
((-71.1043632495873 42.315113108546,-71.1043583974082 42.3151211109857,
-71.1043443253471 42.3150676015829,-71.1043850704575 42.3150793250568,-71.1043632495873 42.315113108546)))',4326);
SELECT ST_GeomFromText('CIRCULARSTRING(220268 150415,220227 150505,220227 150406)');
ST_GeomFromWKB
描述
接受一个以Well-Known Binary(WKB)表示的几何对象字符串为输入,输出一个几何对象,参数SRID是可选的。
函数声明geometry ST_GeomFromWKB(bytea geom);
geometry ST_GeomFromWKB(bytea geom,integer srid);
使用示例--Althoughbytea rep contains single \, these need to be escapedwheninsertingintoa table
--unlessstandard_conforming_stringsissetto on.
SELECT ST_AsEWKT(
ST_GeomFromWKB(E'\\001\\002\\000\\000\\000\\002\\000\\000\\000\\037\\205\\353Q\\270~\\\\\\300\\323Mb\\020X\\231C@\\020X9\\264\\310~\\\\\\300)\\\\\\217\\302\\365\\230C@',4326)
);
st_asewkt
------------------------------------------------------
SRID=4326;LINESTRING(-113.9839.198,-113.98139.195)
(1row)
SELECT
ST_AsText(
ST_GeomFromWKB(
ST_AsEWKB('POINT(2 5)'::geometry)
)
);
st_astext
------------
POINT(25)
(1row)
ST_LineFromEncodedPolyline
描述
从给定的Polyline的编码构造一个LineString对象。
函数声明geometry ST_LineFromEncodedPolyline(text polyline,integer precision=5);
使用示例--Createa linestringfroma polyline
SELECT ST_AsEWKT(ST_LineFromEncodedPolyline('_p~iF~ps|U_ulLnnqC_mqNvxq`@'));
--result--
SRID=4326;LINESTRING(-120.238.5,-120.9540.7,-126.45343.252)
--Selectdifferent precision that was usedforpolyline encoding
SELECT ST_AsEWKT(ST_LineFromEncodedPolyline('_p~iF~ps|U_ulLnnqC_mqNvxq`@',6));
--result--
SRID=4326;LINESTRING(-12.023.85,-12.0954.07,-12.64534.3252)
ST_LineFromMultiPoint
描述
从一个MultiPoint几何对象构造一个LineString对象。
函数声明geometry ST_LineFromMultiPoint(geometry aMultiPoint);
使用示例--Createa3dlinestringfroma3dmultipoint
SELECT ST_AsEWKT(ST_LineFromMultiPoint(ST_GeomFromEWKT('MULTIPOINT(1 2 3, 4 5 6, 7 8 9)')));
--result--
LINESTRING(123,456,789)
ST_LineFromText
描述
从给定的WKT表示法和SRID构造一个几何对象,如果未指定SRID,则默认值为0。
函数声明geometry ST_LineFromText(text WKT);
geometry ST_LineFromText(text WKT,integer srid);
使用示例SELECT ST_LineFromText('LINESTRING(1 2, 3 4)')AS aline,ST_LineFromText('POINT(1 2)')AS null_return;
aline|null_return
------------------------------------------------
010200000002000000000000000000F...|t
ST_LineFromWKB
描述
从给定的WKB表示法和SRID构造一个几何对象。
函数声明geometry ST_LineFromWKB(bytea WKB);
geometry ST_LineFromWKB(bytea WKB,integer srid);
使用示例SELECT ST_LineFromWKB(ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 4)')))AS aline,
ST_LineFromWKB(ST_AsBinary(ST_GeomFromText('POINT(1 2)')))IS NULL AS null_return;
aline|null_return
------------------------------------------------
010200000002000000000000000000F...|t
ST_LinestringFromWKB
描述
从给定的WKB表示法和SRID构造一个几何对象。
函数声明geometry ST_LinestringFromWKB(bytea WKB);
geometry ST_LinestringFromWKB(bytea WKB,integer srid);
使用示例SELECT
ST_LineStringFromWKB(
ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 4)'))
)AS aline,
ST_LinestringFromWKB(
ST_AsBinary(ST_GeomFromText('POINT(1 2)'))
)IS NULL AS null_return;
aline|null_return
------------------------------------------------
010200000002000000000000000000F...|t
ST_MakeBox2D
描述
从给定的左下角和右上角两个点,构造一个Box2D几何对象。
函数声明box2d ST_MakeBox2D(geometry pointLowLeft,geometry pointUpRight);
使用示例--Returnall features that fall resideorpartly resideina US national atlas coordinate bounding box
--Itisassumed here that the geometries are storedwithSRID=2163(USNationalatlas equal area)
SELECT feature_id,feature_name,the_geom
FROM features
WHERE the_geom&&ST_SetSRID(ST_MakeBox2D(ST_Point(-989502.1875,528439.5625),
ST_Point(-987121.375,529933.1875)),2163)
ST_3DMakeBox
描述
从给定的两个对角点,构造一个Box3D对象。
函数声明box3d ST_3DMakeBox(geometry point3DLowLeftBottom,geometry point3DUpRightTop);
使用示例SELECT ST_3DMakeBox(ST_MakePoint(-989502.1875,528439.5625,10),
ST_MakePoint(-987121.375,529933.1875,10))Asabb3d
--bb3d--
--------
BOX3D(-989502.1875528439.562510,-987121.375529933.187510)
ST_MakeLine
描述
从Point、MultiPoint或者Line等几何对象,构造一个LineString几何对象。
函数声明geometry ST_MakeLine(geometrysetgeoms);
geometry ST_MakeLine(geometry geom1,geometry geom2);
geometry ST_MakeLine(geometry[]geoms_array);
使用示例SELECT gps.gps_track,ST_MakeLine(gps.the_geom)Asnewgeom
FROM(SELECT gps_track,gps_time,the_geom
FROM gps_points ORDER BY gps_track,gps_time)Asgps
GROUP BY gps.gps_track;
ST_MakeEnvelope
描述
从给定的最小值和最大值构造一个Polygon。输入值必须在给定的SRID的有效范围内。
函数声明geometry ST_MakeEnvelope(doubleprecision xmin,doubleprecision ymin,doubleprecision xmax,doubleprecision ymax,integer srid=unknown);
使用示例SELECT ST_AsText(ST_MakeEnvelope(10,10,11,11,4326));
st_asewkt
-----------
POLYGON((1010,1011,1111,1110,1010))
ST_MakePolygon
描述
从给定的边界构造一个Polygon对象。输入必须是一个封闭的LineString。
函数声明geometry ST_MakePolygon(geometry linestring);
使用示例--2dline
SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 29.5, 75.15 29.53)'));
--Iflinestringisnotclosed
--you can add the start point to close it
SELECT ST_MakePolygon(ST_AddPoint(foo.open_line,ST_StartPoint(foo.open_line)))
FROM(
SELECT ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 29.5)')Asopen_line)Asfoo;
--3dclosed line
SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53 1,77 29 1,77.6 29.5 1, 75.15 29.53 1)'));
st_asewkt
-----------
POLYGON((75.1529.531,77291,77.629.51,75.1529.531))
--measured line--
SELECT ST_MakePolygon(ST_GeomFromText('LINESTRINGM(75.15 29.53 1,77 29 1,77.6 29.5 2, 75.15 29.53 2)'));
st_asewkt
----------
POLYGONM((75.1529.531,77291,77.629.52,75.1529.532))
ST_MakePoint
描述
构造一个2D, 3DZ或者4D的点。
函数声明geometry ST_MakePoint(doubleprecision x,doubleprecision y);
使用示例--Returnpointwithunknown SRID
SELECT ST_MakePoint(-71.1043443253471,42.3150676015829);
--Returnpoint markedasWGS84longlat
SELECT ST_SetSRID(ST_MakePoint(-71.1043443253471,42.3150676015829),4326);
--Returna3Dpoint(e.g.has altitude)
SELECT ST_MakePoint(1,2,1.5);
--Getz of point
SELECT ST_Z(ST_MakePoint(1,2,1.5));
result
-------
1.5
ST_MakePointM
描述
给定x、y和m坐标值来构造一个PointM对象。
函数声明geometry ST_MakePointM(floatx,floaty,floatm);
使用示例--ReturnEWKT representation of pointwithunknown SRID
SELECT ST_AsEWKT(ST_MakePointM(-71.1043443253471,42.3150676015829,10));
--result
st_asewkt
-----------------------------------------------
POINTM(-71.104344325347142.315067601582910)
--ReturnEWKT representation of pointwithmeasure markedasWGS84longlat
SELECT ST_AsEWKT(ST_SetSRID(ST_MakePointM(-71.1043443253471,42.3150676015829,10),4326));
st_asewkt
---------------------------------------------------------
SRID=4326;POINTM(-71.104344325347142.315067601582910)
--Returna3dpoint(e.g.has altitude)
SELECT ST_MakePoint(1,2,1.5);
--Getm of point
SELECT ST_M(ST_MakePointM(-71.1043443253471,42.3150676015829,10));
result
-------
10
ST_MLineFromText
描述
从给定的WKT表示法字符串构造一个MultiLineString对象。
函数声明geometry ST_MLineFromText(text WKT,integer srid);
geometry ST_MLineFromText(text WKT);
使用示例SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))');
ST_MPointFromText
描述
从给定的WKT表示法字符串和SRID来构造一个MultiPoint几何对象,如果SRID未指定,则默认为0。
函数声明geometry ST_MPointFromText(text WKT,integer srid);
geometry ST_MPointFromText(text WKT);
使用示例SELECT ST_MPointFromText('MULTIPOINT(1 2, 3 4)');
SELECT ST_MPointFromText('MULTIPOINT(-70.9590 42.1180, -70.9611 42.1223)',4326);
ST_MPolyFromText
描述
从给定的WKT表示法字符串和SRID来构造一个MultiPolygon几何对象,如果SRID未指定,则默认为0。
函数声明geometry ST_MPolyFromText(text WKT,integer srid);
geometry ST_MPolyFromText(text WKT);
使用示例SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 1),(5 5 3,5 7 3,7 7 3,7 5 3,5 5 3)))');
SELECtST_MPolyFromText('MULTIPOLYGON(((-70.916 42.1002,-70.9468 42.0946,-70.9765 42.0872,-70.9754 42.0875,-70.9749 42.0879,-70.9752 42.0881,-70.9754 42.0891,-70.9758 42.0894,-70.9759 42.0897,-70.9759 42.0899,-70.9754 42.0902,-70.9756 42.0906,-70.9753 42.0907,-70.9753 42.0917,-70.9757 42.0924,-70.9755 42.0928,-70.9755 42.0942,-70.9751 42.0948,-70.9755 42.0953,-70.9751 42.0958,-70.9751 42.0962,-70.9759 42.0983,-70.9767 42.0987,-70.9768 42.0991,-70.9771 42.0997,-70.9771 42.1003,-70.9768 42.1005,-70.977 42.1011,-70.9766 42.1019,-70.9768 42.1026,-70.9769 42.1033,-70.9775 42.1042,-70.9773 42.1043,-70.9776 42.1043,-70.9778 42.1048,-70.9773 42.1058,-70.9774 42.1061,-70.9779 42.1065,-70.9782 42.1078,-70.9788 42.1085,-70.9798 42.1087,-70.9806 42.109,-70.9807 42.1093,-70.9806 42.1099,-70.9809 42.1109,-70.9808 42.1112,-70.9798 42.1116,-70.9792 42.1127,-70.979 42.1129,-70.9787 42.1134,-70.979 42.1139,-70.9791 42.1141,-70.9987 42.1116,-71.0022 42.1273,
-70.9408 42.1513,-70.9315 42.1165,-70.916 42.1002)))',4326);
ST_Point
描述
以给定的坐标值构造一个Point对象,是OGC标准中ST_MakePoint的别名。
函数声明geometry ST_Point(floatx_lon,floaty_lat);
使用示例SELECT ST_SetSRID(ST_Point(-71.1043443253471,42.3150676015829),4326)
ST_PointFromGeoHash
描述
从给定的GeoHash字符串中构造相应的Point对象。
函数声明point ST_PointFromGeoHash(text geohash,integer precision=full_precision_of_geohash);
使用示例SELECT ST_AsText(ST_PointFromGeoHash('9qqj7nmxncgyy4d0dbxqz0'));
st_astext
------------------------------
POINT(-115.17281636.114646)
SELECT ST_AsText(ST_PointFromGeoHash('9qqj7nmxncgyy4d0dbxqz0',4));
st_astext
-----------------------------------
POINT(-115.1367187536.123046875)
SELECT ST_AsText(ST_PointFromGeoHash('9qqj7nmxncgyy4d0dbxqz0',10));
st_astext
-------------------------------------------
POINT(-115.17281591892236.1146435141563)
ST_PointFromText
描述
从给定的WKT表示法字符串和SRID来构造一个Point几何对象,如果SRID未指定,则默认为0。
函数声明geometry ST_PointFromText(text WKT);
geometry ST_PointFromText(text WKT,integer srid);
使用示例SELECT ST_PointFromText('POINT(-71.064544 42.28787)');
SELECT ST_PointFromText('POINT(-71.064544 42.28787)',4326);
ST_PointFromWKB
描述
从给定的WKB表示法来构造一个Point几何对象。
函数声明geometry ST_GeomFromWKB(bytea geom);
geometry ST_GeomFromWKB(bytea geom,integer srid);
使用示例SELECT
ST_AsText(
ST_PointFromWKB(
ST_AsEWKB('POINT(2 5)'::geometry)
)
);
st_astext
------------
POINT(25)
(1row)
SELECT
ST_AsText(
ST_PointFromWKB(
ST_AsEWKB('LINESTRING(2 5, 2 6)'::geometry)
)
);
st_astext
-----------
(1row)
ST_Polygon
描述
从给定的LineString对象和SRID构造一个Polygon对象。
函数声明geometry ST_Polygon(geometry aLineString,integer srid);
使用示例--a2dpolygon
SELECT ST_Polygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 29.5, 75.15 29.53)'),4326);
--result--
POLYGON((75.1529.53,7729,77.629.5,75.1529.53))
--a3dpolygon
SELECT ST_AsEWKT(ST_Polygon(ST_GeomFromEWKT('LINESTRING(75.15 29.53 1,77 29 1,77.6 29.5 1, 75.15 29.53 1)'),4326));
result
------
SRID=4326;POLYGON((75.1529.531,77291,77.629.51,75.1529.531))
ST_PolygonFromText
描述
从给定的WKT表示法字符串和SRID来构造一个Polygon几何对象,如果SRID未指定,则默认为0。
函数声明geometry ST_PolygonFromText(text WKT);
geometry ST_PolygonFromText(text WKT,integer srid);
使用示例SELECT ST_PolygonFromText('POLYGON((-71.1776585052917 42.3902909739571,-71.1776820268866 42.3903701743239,
-71.1776063012595 42.3903825660754,-71.1775826583081 42.3903033653531,-71.1776585052917 42.3902909739571))');
st_polygonfromtext
------------------
010300000001000000050000006...
SELECT ST_PolygonFromText('POINT(1 2)')IS NULLaspoint_is_notpoly;
point_is_not_poly
----------
t
ST_WKBToSQL
描述
从给定的WKB表示法来构造一个几何对象。这是不带SRID参数的ST_GeomFromWKB函数的别名。
函数声明geometry ST_WKBToSQL(bytea WKB);
使用示例参见ST_GeomFromWKB
ST_WKTToSQL
描述
从给定的Well-Known Text(WKT)表示法字符串构造一个几何对象。这是函数ST_GeomFromText的别名。
函数声明geometry ST_WKTToSQL(text WKT);
使用示例参见ST_GeomFromText