Skip to main content
Question

Extracting WKB geometry from JDBC Redshift table

  • June 4, 2026
  • 2 replies
  • 11 views
lorinda
Contributor
Forum|alt.badge.img+6

Hi all,

I have a table in Redshift that is JDBC (not the spatial version of Redshift); it has a column that is in WKB.  I need to extract this and create points in Lat Long.  I’ve tried the geometry extractor but getting nowhere fast.  Have also tried sql executer to use the ST_geometry to get the coords, nowhere again.  When I tried to use the Redshift connections, the username/pwd and related connection data did not connect.  It is only with JDBC that I can create the connection.

Anyone had any experience with this?

Thanks,

Lorinda

    2 replies

    ebygomm
    Evangelist
    Forum|alt.badge.img+49
    • ebygommEvangelist
    • Evangelist
    • June 4, 2026

    If you have a column that is WKB you should be able to convert that to a geom with the GeometryReplacer

      lorinda
      Contributor
      Forum|alt.badge.img+6
      • lorindaContributor
      • Author
      • Contributor
      • June 4, 2026

      Was able to do that and then reproject to our projection.  Now just working on getting it to write to my SDE, it’s being finicky.  Had to use Hex Encoded OGC Well Known Binary rather than straight WKB.

      Community Stats

      32,620
      Posts
      123,803
      Replies
      40,977
      Members
      Terms & ConditionsAccessibility statement
      A product of
      Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.