Opened 6 years ago

Closed 5 years ago

#3151 closed defect (invalid)

Function ST_InterpolatePoint doesn't work with LINESTRINGM

Reported by: mayonesa Owned by: pramsey
Priority: low Milestone: PostGIS 2.1.9
Component: postgis Version: 2.1.x
Keywords: ST_InterpolatePoint LINESTRINGM MULTILINESTRINGM Cc:

Description

Hi to all,

If I execute this query

 SELECT ST_InterpolatePoint(geom,ST_Transform(ST_SetSRID(ST_MakePoint(-3.17287857984195,40.7322588249179),4326),3042))
 FROM roads as rc
 WHERE idvia = '666XX';

The result is

ERROR:  ST_InterpolatePoint: 1st argument isn't a line


********** Error **********

ERROR: ST_InterpolatePoint: 1st argument isn't a line
SQL state: XX000

Is there a way to workaround and transform MULTILINESTRINGM to LINESTRINGM without loosing the measure?

Thanks a lot

Change History (3)

comment:1 Changed 5 years ago by pramsey

Milestone: PostGIS 2.1.8PostGIS 2.1.9

comment:2 Changed 5 years ago by robe

Summary: Function ST_InterpolatePoint only works with LINESTRINGMFunction ST_InterpolatePoint doesn't work with LINESTRINGM

comment:3 Changed 5 years ago by pramsey

Resolution: invalid
Status: newclosed

Sure, ST_Dump should convert multis to singletons w/o dropping dimensions.

Note: See TracTickets for help on using tickets.