-
Notifications
You must be signed in to change notification settings - Fork 3.3k
GIS examples
DBeaverDevOps edited this page Jun 19, 2024
·
6 revisions
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))');
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 |
-
Views
-
Search
-
Data management
-
Usability enhancements
-
Security
-
Projects
- Sample Database
-
Database Connections
- Edit Connection
- Invalidate/Reconnect to Database
- Disconnect from Database
- Change current user password
- Advanced settings
- Cloud configuration settings
- Local Client Configuration
- Connection Types
- Configure Connection Initialization Settings
-
Tableau integration
- Transactions
- Drivers
- Tasks
-
Cloud Explorer
-
Cloud Storage
- Classic
- Cloud
- Changing interface language
- DBeaver extensions - Office, Debugger, SVG
- Installing extensions - Themes, version control, etc
- User Interface Themes
- Command Line
- Reset UI settings
- Reset workspace
- Troubleshooting system issues
- Posting issues
- Log files
- JDBC trace
- Thread dump
- Managing connections
- Managing variables
- Managing drivers
- Managing preferences
- Managing restrictions
- Windows Silent Install
- Snap installation