postgis查询数据为geojson

最新推荐文章于 2024-07-16 13:43:39 发布

ylfmsn

最新推荐文章于 2024-07-16 13:43:39 发布

阅读量824

点赞数

分类专栏： postgresql

本文链接：https://blog.csdn.net/ylfmsn/article/details/107841862

版权

postgresql 专栏收录该内容

6 篇文章 1 订阅

订阅专栏

	/**
     * 数据库直接查询geojson
     * @param tblName
     * @param properties
     * @param uniquevalue
     * @param epsg
     * @return
     */
    @Select("SELECT" +
            "row_to_json ( fc )" +
            "FROM" +
            "(" +
            "    SELECT" +
            "           'FeatureCollection' AS TYPE," +
            "           array_to_json (ARRAY_AGG ( f )) AS features" +
            "    FROM" +
            "(" +
            "        SELECT" +
            "            geometrytype(the_geom) AS TYPE," +
            "            ST_AsGeoJSON (st_transform(the_geom, ${epsg})) :: json AS geometry," +
            "            ( SELECT row_to_json ( PROPERT ) FROM ( SELECT ${properties} ) AS PROPERT ) AS properties," +
            "            (" +
            "                SELECT" +
            "                    row_to_json ( EPSGT )" +
            "                FROM" +
            "                (" +
            "                    select" +
            "                        'name' as type," +
            "                        (select concat('EPSG:', cast(st_srid(st_transform(the_geom, ${epsg})) as varchar)) as properties" +
            "                    from ${tblName} where bdcdyh = \'${uniquevalue}\')" +
            "                ) as EPSGT" +
            "            ) as CRS" +
            "        FROM ${tblName} where bdcdyh = \'${uniquevalue}\'" +
            "    ) AS f" +
            ") AS fc;")
    JSONObject selectGEOJSONByUnicode(String tblName, String properties, String uniquevalue, int epsg);