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
Solved
Can't correctly recognize the Geometry column
Best answer by nielsgerrits
I think you read a PostGIS table with a PostgreSQL reader?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
- 2252 replies
yeah, looks like wrong reader(?)
You could of course use geometryreplacer on the string.
@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 )
+60- 2939 replies
@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:
0101000080000000000000E03F000000000000E03F000000000000E03FUsing 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
+18- Supporter
- 1442 replies
@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:
0101000080000000000000E03F000000000000E03F000000000000E03FUsing 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)
+60- 2939 replies
@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.
+18- Supporter
- 1442 replies
@itay Yeah thats what I thought but this gave me the "Invalid WKB encountered." warning.
oops...I see that now...
@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.
+15- Contributor
- 2252 replies
@jerome
Hi,
Geometryreplacer: Hex Encoded OGC Well Known Binary
(The letters in the string indicate it is hexadecimal.)
Greets
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.
+60- 2939 replies
@jerome
Hi,
Geometryreplacer: Hex Encoded OGC Well Known Binary
(The letters in the string indicate it is hexadecimal.)
Greets
Learned something today, thanks!