PostGIS 提供了非常多的函數(shù)可以直接實(shí)現(xiàn)空間操作及轉(zhuǎn)換，下面用SQL語(yǔ)句查詢空間表的數(shù)據(jù)并轉(zhuǎn)成GeoJSON：

   SELECT
    row_to_json(fc)
FROM (
    SELECT
        'FeatureCollection' AS type
        , array_to_json(array_agg(f)) AS features
    FROM (
        SELECT
            'feature' AS type
            , ST_AsGeoJSON(geom)::json as geometry  --geom表中的空間字段
            , (
                SELECT
                    row_to_json(t)
                FROM (
                    SELECT
                       id, user,content
                    ) AS t
                ) AS properties
        FROM test_table 
    ) AS f
) AS fc

查詢結(jié)果如下:

{
    "type": "FeatureCollection",
    "features": [
        {
            "type": "feature",
            "geometry": {
                "type": "Point",
                "coordinates": [
                    87.6416250523,
                    43.6650995192
                ]
            },
            "properties": {
                "id": "6500000182",
                "user": "王曉波",
                "content": "溫性荒漠草原-小蓬"
            }
        },
        {
            "type": "feature",
            "geometry": {
                "type": "Point",
                "coordinates": [
                    87.766879,
                    43.790263
                ]
            },
            "properties": {
                "id": "6500000197",
                "user": "王曉波",
                "content": "溫性草原-禾草，錦雞兒"
            }
        }
    ]
}