Skip to content

GIS examples

Jump to bottom
DBeaverDevOps edited this page Feb 9, 2024 · 1 revision

Table of contents

SQL Queries

PostgreSQL queries reading GIS data types: (can be executed in SQL editor)

SELECT ST_MakePoint(112.123,243.123);

SELECT GeomFromEWKT('SRID=4326;POINT(111.1111111 1.1111111)');

SELECT GeomFromEWKT('SRID=4326;POLYGON((0 0,0 1,1 1,1 0,0 0))');

Test databases

https://knowledge.safe.com/questions/70649/fme-basic-training-postgis-database-connection.html

Parameter Value
Host postgis.train.safe.com
Port 5432
Database fmedata
Username fmedata
Password fmedata

DBeaver - Universal Database Manager

DBeaver Desktop Documentation

General User Guide

Database Management

DBeaver PRO

Databases support

Customizing DBeaver

Troubleshooting

Admin Guide

License management

Tutorials

Development

Clone this wiki locally