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: https://wolfr.am/RDlive. Subscribe to @WolframRD on YouTube for more livestreams, exclusive VODs, creator presentations, behind-the-scenes insider videos, and so much more.
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...
-- 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!