MODERATOR NOTE: This is the notebook used in the livestream “Relational Databases in the Wolfram Language” on Wednesday, April 5 – a part of Wolfram R&D livestream series announced and scheduled here: ⭐ [R&DL] Wolfram R&D Developers on LIVE Stream - Staff Picks - WOLFRAM COMMUNITY. Subscribe to [@WolframRD] (https://wolfr.am/1eatWLcDA) on YouTube for more livestreams, exclusive VODs, creator presentations, behind-the-scenes insider videos, and so much more.
5 Likes
– you have earned Featured Contributor Badge 
Your exceptional post has been selected for our editorial column Staff Picks http://wolfr.am/StaffPicks and Your Profile is now distinguished by a Featured Contributor Badge and is displayed on the Featured Contributor Board. Thank you!
How could I deal with PostGIS geometry object? I would like to map it to GeoPosition or Polygon entity.
You can use EmbeddedSQLExpression in an EntityFunction to use PostGIS functionality in a query.
The main problem is that we don’t natively support transforming the output into GeoPosition or Polygon, you’d have to map transformation functions manually on columns. The transformation function is probably hidden away somewhere in the GIS` context…