postgresql中geom处理

SELECT
    st_x ( geom ) AS lon,
    st_y ( geom ) AS lat
FROM
    表名

SELECT
  st_x ( ST_PointOnSurface(geom) ) AS lon,
  st_y ( ST_PointOnSurface(geom) ) AS lat
FROM
  表名;

SELECT ST_PointOnSurface(geom) FROM 表名 ;

SELECT
    ST_asText ( geom ) 
FROM
    表名

SELECT st_srid(geom) FROM 表名;

SELECT st_astext(
st_transform(
ST_GeomFromText('POINT(521519.84150795196  3070180.2299377914)', 4549 ), 4326) )

SELECT  st_transform(geom,4549) FROM 表名 LIMIT 9;

SELECT ST_Intersects(geom1, geom2);