SELECT ST_X(geom), ST_Y(geom) FROM geometries WHERE name = 'Point'; 1. 2. 3. 纽约市地铁站(nyc_subway_stations)表是一个以点表示的数据集。以下SQL查询将返回一个点图形数据(在ST_AsText列中): SELECT name, ST_AsText(geom) FROM nyc_subway_stations LIMIT 1; 1. 2. 3. 3.2、线串(Lin...
ST_AsBinary(geometry)returns WKB bytea ST_AsEWKB(geometry)returns EWKB bytea ST_GeomFromGML(text)returns geometry ST_AsGML(geometry)returns GML text ST_GeomFromKML(text)returns geometry ST_AsKML(geometry)returns KML ...
4490)) = 't' #删除表 drop table abcde; #查空间面积 SELECT st_area(st_transform(st_geometryfromtext(wkt,4490),4527)) area #查相交面积并排序 select mj, ST_AsText (geom), st_area(st_transform(geom,3857)), st_AsText
// ST_AsText 函数输出结果格式:POINT(115.780783680223 33.8766619946554)selectST_AsText(geom)coordFROMPUBLIC.dm
ST_ASTEXT_FUNCTION:Oracle 函数用于将 ST_Geometry 值转换为 WKT 格式。默认值:ST_ASTEXT,例如对于 ArcSDE,应将其设置为 sde.st_astext。 添加INSERT_ON_CONFLICT配置指令。启用后,此指示 Ora2Pg 将子句添加ON CONFLICT DO NOTHING到为此类型的数据导出生成的所有 INSERT 语句中。
update qiye_zdsys set geom = st_geomfromtext(ST_AsText(geom),4326) where st_srid(geom)=0; //查询在多边形区域内的数据,t2.geom是MULTIPLOYGON格式的多边形,t1.geom是坐标点 select t1.id from temp_gaoxin_qiye_address_location t1 LEFT JOIN cyyq_pq t2 on st_contains(t2.geom, t1.geom) ...
text WKT = ST_AsText(geometry); geometry = ST_GeomFromWKB(bytea WKB, SRID); geometry = ST_GeometryFromText(text WKT, SRID); 示例 SELECT (ST_GeomFromText('POINT(-126.4 45.32)', 312), 'A Place'); 输出如下: (0101000020380100009A99999999995FC0295C8FC2F5A84640,"A Place") ...
_st_intersects(st_transform(ST_MakeEnvelope(" + leftTopX + "," + leftTopY + "," + rightBottomX + "," + rightBottomY + ",4326" + "),4326),geom) 4、多边形查询 SELECT gid,year,cc,gb,ec,name,type,cc,gb,ec,name,type,st_astext(geom) wkt FROM V_ARCP where ST_Intersects(st_...
SELECT ST_AsText(geom) FROM spatial_table; SELECT ST_Area(geom) FROM spatial_table; SELECT ST_Length(geom) FROM spatial_table; 以上示例展示了一些常见的查询语法,如选择所有的geometry数据、选择部分字段、使用条件过滤查询结果以及执行空间操作和分析。 此外,还可以通过结合其他PostgreSQL的查询功能来进一步优...
ST_ AddPoint ST_Angle ST_Area ST_ AsBinary ST_AsEWKB ST_AsEWKT ST_JSON AsGeo ST_WKB AsHex ST_ EWKB AsHex ST_ AsText ST_Azimuth ST_Boundary ST_Buffer ST_Centroid ST_Collect ST_Contains ST_ ContainsProperly ST_ ConvexHull ST_ CoveredBy ST_Covers ST_Crosses ST_Dimension ST_Disjoint ...