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
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 )
+66@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
+19- Supporter
@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)
+66@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.
+19- Supporter
@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
@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.
+66@jerome
Hi,
Geometryreplacer: Hex Encoded OGC Well Known Binary
(The letters in the string indicate it is hexadecimal.)
Greets
Learned something today, thanks!
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.