👨‍⚕️ 主页： gis分享者
👨‍⚕️ 感谢各位大佬 点赞👍 收藏⭐ 留言📝 加关注✅!
👨‍⚕️ 收录于专栏：gis工程师

一、🌎前言

本文讲解基于postgis创建的空间库表，如何获取geojson格式数据的方法。希望能帮助到您。

二、🌎空间表转geojson实现方法

sql查询语句：

WITH feature AS (
    SELECT
        'Feature' AS "type",
        st_asgeojson ( hn.geom ) :: json AS "geometry",
            row_to_json (
            hnn) AS "properties"
    FROM
        tablename AS hn,
        (select gid, name from tablename) as hnn
        where hn.gid = hnn.gid
    ),
    features AS (
    SELECT
        'FeatureCollection' AS "type",
        array_to_json ( ARRAY_AGG ( feature.* ) ) AS "features"
    FROM
        feature) SELECT
        row_to_json ( features.* )
FROM
    features

效果如下图：