是否有 PostGIS IDE 来执行 postgres gis 空间功能?
是否有 PostGIS IDE 来执行 postgres gis 空间功能?
示例 SQL
SELECT ST_Distance(gg1, gg2) As spheroid_dist, ST_Distance(gg1, gg2, false) As sphere_dist
FROM (SELECT
ST_GeographyFromText('SRID=4326;POINT(-72.1235 42.3521)') As gg1,
ST_GeographyFromText('SRID=4326;LINESTRING(-72.1260 42.45, -72.123 42.1546)') As gg2
) As foo ;
Is there a PostGIS IDE to execute postgres gis spatial functions?
samples sql
SELECT ST_Distance(gg1, gg2) As spheroid_dist, ST_Distance(gg1, gg2, false) As sphere_dist
FROM (SELECT
ST_GeographyFromText('SRID=4326;POINT(-72.1235 42.3521)') As gg1,
ST_GeographyFromText('SRID=4326;LINESTRING(-72.1260 42.45, -72.123 42.1546)') As gg2
) As foo ;
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
![扫码二维码加入Web技术交流群](/public/img/jiaqun_03.jpg)
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
并不是真正的 IDE,但您可以尝试将 QGIS 与 PostGIS 插件之一一起使用:
另外,您可能想要查看通过 PostGIS 高效使用 QGIS 演示文稿FOSS4G2011。
Not really an IDE but you could try using QGIS with one of PostGIS plugins:
Also, you might want to have a look at Efficiently using QGIS with PostGIS presentation from FOSS4G2011.
您可以将WKB 十六进制输出直接复制/粘贴到JTS TestBuilder (Java Topology Suite 的一部分)以获得可视化效果。
请参阅此相关答案。
You can copy/paste the WKB hex output directly into JTS TestBuilder (part of Java Topology Suite) to get a visualization.
See this related answer.