Solved

Invalid WKT encountered: LINESTRINGZ

ponceta
Badge

Hi,

I've encountered a problem when using a GeometryReplacer With LineStringZ

Invalid WKT encountered: LINESTRINGZ(541502.5560000000 152585.6960000000 583.544, 541502.4660000000 152585.4560000000 583.775, 541501.2901908699 152581.1464218800 0.0)

I do assume that LinestringZ is not an OGC WKT recognized format yet, although it is recognized as a valid OGC WKB format.

http://portal.opengeospatial.org/files/?artifact_id=25355

My goal is to check the geometry validity from my linestringz features before sending these to my postgis database.

SELECT ST_ISVALID(ST_GeomFromText('LINESTRINGZ(541502.5560000000 152585.6960000000 583.544, 541502.4660000000 152585.4560000000 583.775, 541501.2901908699 152581.1464218800 0.0)'))

Any idea how I could deal with this on FME 2018?

icon

Best answer by takashi 5 April 2018, 00:19

View original

3 replies

david_r
Rank
Userlevel 4

It seems FME doesn't like the "LINESTRINGZ" moniker. You can use a StringReplacer to replace it with simply "LINESTRING" and it'll work.

takashi
Rank
Userlevel 2
Badge +17

Or, "LINESTRING Z" (insert a space before 'Z') should work. See the section 7.2.3 BNF Productions for Three-Dimension Geometry WKT, page LV in the specification you have linked.

lifalin2016
Rank
Userlevel 1
Badge +22

Or, "LINESTRING Z" (insert a space before 'Z') should work. See the section 7.2.3 BNF Productions for Three-Dimension Geometry WKT, page LV in the specification you have linked.

Funny how all the odd numbered pages seem to be numbered using Roman numerals :-)

 

 

-- Cheers, Lars I.

Reply


Community Stats

28,707
Posts
109,470
Replies
36,549
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.