问题描述
我已使用gis扩展工具将OpenstreetMap数据导入到Postgres中osm2pgsql(-s选项)
I have import OpenstreetMap data into Postgres with gis extension with toolosm2pgsql (-s option)
当然，我有以下表格
planet_osm_point
planet_osm_ways
....
planet_osm_ways中，我有一列名为way的类型为geometry(LineString，4326)的内容，如下所示:
Within planet_osm_ways I have a column called way, type geometry(LineString, 4326), content like following
"0102000020E6100000070000005E70BCF1A49F2540D3D226987B134840896764EB749F25403B5DCC858013484040D1860D609F2540C426327381134840CE50DCF1269F2540EF552B137E1348405AAB2CC02D9E2540F978324976134840D66F26A60B9D2540CE8877256E1348403CA81F2FFF9C2540BC1D86FB6D134840"
那是什么?我怎样才能得到所有积分呢?
What is that ? How could I get all points along this way ?
非常感谢
推荐答案
以十六进制编码的扩展得很好LINESTRING的已知二进制(EWKB).
有几种方法可以获取要点.要获取单个坐标作为点，请使用 ST_DumpPoints .或仅以其他人类可读格式(WKT，EWKT，GeoJSON，GML等)输出几何，请参见相关手册部分.
There are several methods to get the points along the way. To get individual coordinates as points, use ST_DumpPoints. Or to simply output the geometry in other human-readable formats (WKT, EWKT, GeoJSON, GML, etc.), see the relevant manual section.
这篇关于如何从(osm)PostGIS获得所有要点?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！