Are there any plans for vertica to support GIS objects (like WKB, WKT) ?

We are looking for GIS support, similar to that provided by POSTGIS for the Postgres database.
Are there any plans for vertica to support GIS or gis data types like polygon, linestring, point, etc?

Or are you aware of any packages that can be loaded into vertica that support this functionality?

Comments

  • Hello, I'm in the need to access Vertica from a geographical information system (GIS) like QGIS and POSTGIS. Vertica calculates measures related to geographical coordinates that need to be showed on the map.
    I'm trying to connect QGIS to Vertica via ODBC without success (can configure the connection but QGIS ends abnormally).

    Do you know how to do this with QGIS or could you advice me other GIS tool?

     

    Or in alternative:
    How to produce a shapefile from a Vertica table?

     

    Thanks in advance,

    Vivian Rossi.

  • Can you share more details about the ODBC error that you are getting with QGIS.

     

    Geometry can be exported by using ST_AsText function . For more details refer to https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/Place/Functions/ST_AsText.htm

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file