Skip to main content
Solved

Can't correctly recognize the Geometry column


Forum|alt.badge.img

Hi

When I created my Reader, I can read all my data and especially my geometry column but this column doesn't display . I try different coordinate system but it does not match. Same issue.

What's wrong with this Reader ?

Thanks

Best answer by nielsgerrits

I think you read a PostGIS table with a PostgreSQL reader?

View original
Did this help you find an answer to your question?

11 replies

nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • September 3, 2019

I think you read a PostGIS table with a PostgreSQL reader?


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • September 3, 2019

yeah, looks like wrong reader(?)

You could of course use geometryreplacer on the string.


Forum|alt.badge.img
  • Author
  • September 3, 2019

@gio : No I didn't try the geometryreplacer Transformer.

@nielsgerrits : yes you're right. (I read a PosGIS column type from a PostgreSQL reader. My data are in Psotgresql database )


nielsgerrits
VIP
Forum|alt.badge.img+54
jerome wrote:

@gio : No I didn't try the geometryreplacer Transformer. 

@nielsgerrits : yes you're right. (I read a PosGIS column type from a PostgreSQL reader. My data are in Psotgresql database )

@jerome "PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects." - https://postgis.net/docs/manual-2.5/ 

PostgreSQL non spatial --> PostgreSQL reader

PostgreSQL spatial --> PostGIS reader

@gio What settings do you need to get the GeometryReplacer to work with the geometry column? When I read a 3D point (0.5,0.5,0.5) with the PostgreSQL reader the geometry value is:

0101000080000000000000E03F000000000000E03F000000000000E03F

Using the GeometryReplacer with WKB I get:

2019-09-04 06:50:08|   0.5|  0.0|WARN  |Invalid WKB encountered.

This is in 2019.1.1.0


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • September 4, 2019
nielsgerrits wrote:

@jerome "PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects." - https://postgis.net/docs/manual-2.5/ 

PostgreSQL non spatial --> PostgreSQL reader

PostgreSQL spatial --> PostGIS reader

@gio What settings do you need to get the GeometryReplacer to work with the geometry column? When I read a 3D point (0.5,0.5,0.5) with the PostgreSQL reader the geometry value is:

0101000080000000000000E03F000000000000E03F000000000000E03F

Using the GeometryReplacer with WKB I get:

2019-09-04 06:50:08|   0.5|  0.0|WARN  |Invalid WKB encountered.

This is in 2019.1.1.0

@nielsgerrits I belive you need to set it to OGC Well Known Binary (not tested)


nielsgerrits
VIP
Forum|alt.badge.img+54
itay wrote:

@nielsgerrits I belive you need to set it to OGC Well Known Binary (not tested)

@itay Yeah thats what I thought but this gave me the "Invalid WKB encountered." warning.


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • September 4, 2019
nielsgerrits wrote:

@itay Yeah thats what I thought but this gave me the "Invalid WKB encountered." warning.

oops...I see that now...


Forum|alt.badge.img
  • Author
  • September 4, 2019
jerome wrote:

@gio : No I didn't try the geometryreplacer Transformer.

@nielsgerrits : yes you're right. (I read a PosGIS column type from a PostgreSQL reader. My data are in Psotgresql database )

@nielsgerrits: I had installed the posgis extension with Postgresql and it worked well. But I didn't think it was necessary to change the type of Reader. I didn't know OGC WKB.

 


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • September 4, 2019

@jerome

 

 

Hi,

Geometryreplacer: Hex Encoded OGC Well Known Binary

 

(The letters in the string indicate it is hexadecimal.)

 

Greets


Forum|alt.badge.img
  • Author
  • September 4, 2019

You're right . I used the wrong reader: my data was in a Posgresql database format but my column was in Postgis. So with the Postgis format I can now read my geometry data.

Thanks.


nielsgerrits
VIP
Forum|alt.badge.img+54
gio wrote:

@jerome

 

 

Hi,

Geometryreplacer: Hex Encoded OGC Well Known Binary

 

(The letters in the string indicate it is hexadecimal.)

 

Greets

Learned something today, thanks!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings