Hello.
I have calibrated route in file geodatabase (ArcGIS). I have line coordinate (kilometre) in the start and the end point. I try export this route with M-value to PostGIS in FME. But in result I have line without M-value. Do you know how it works?
If i created MULTILINESTRING M in postgis directly sql it work. So metadata field geom support M-value
PS GeometryExtractor have field with M-value
+47Check out this question - looks to be answered
https://community.safe.com/s/question/0D54Q000080hTKQSA2/how-to-write-line-with-measure-to-postgis
Check out this question - looks to be answered
https://community.safe.com/s/question/0D54Q000080hTKQSA2/how-to-write-line-with-measure-to-postgis
Yes, I seen this answered. But it is not my case. I have measure yet and I do not need in generate.
But if I try repeat this case in result i do not have measure in postgis.
Did you manage to use this method? It's work?
+47Yes, I seen this answered. But it is not my case. I have measure yet and I do not need in generate.
But if I try repeat this case in result i do not have measure in postgis.
Did you manage to use this method? It's work?
Have you tried Using FME to create a new table where the first features contains measures? If the table has already been created and contains measures then it's possible FME is doing something silly and dropping the measures when writing to the database.
You shouldn't need to use a GeometryExtractor. FME should handele the geometries automatically with PostGIS. Just write out the data.
Yes, I seen this answered. But it is not my case. I have measure yet and I do not need in generate.
But if I try repeat this case in result i do not have measure in postgis.
Did you manage to use this method? It's work?
I think you are right that FME dropping the measure. Yes I have the table and scheme in postgis and I try insert data in db.
PS If I create new table by FME, measure are save.
So, I serche constraint in field geom in current scheme...
may be it 2d...
Yes, I seen this answered. But it is not my case. I have measure yet and I do not need in generate.
But if I try repeat this case in result i do not have measure in postgis.
Did you manage to use this method? It's work?
Ok.
Answer is:
Change type of table_name in geometry_columns on GEOMETRY M instead GEOMETRY
