[postgis-devel] [PostGIS] #1242: Document bug or regression bug - ST_Line_Locate_Point for multilinestring

PostGIS trac at osgeo.org
Fri Oct 14 02:07:00 PDT 2011

#1242: Document bug or regression bug -  ST_Line_Locate_Point for multilinestring
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.5.4
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
 I thought Paul had revised this function in 1.5.1 to work with

 If I take the example and change it to:


 SELECT ST_AsText(house_loc) As as_text_house_loc,
         startstreet_num +
                 CAST( (endstreet_num - startstreet_num)
                         * ST_Line_Locate_Point(street_line, house_loc) As
 integer) As street_num
 (SELECT ST_Multi(ST_GeomFromText('LINESTRING(1 2, 3 4)')) As street_line,
         ST_MakePoint(x*1.01,y*1.03) As house_loc, 10 As startstreet_num,
                 20 As endstreet_num
 FROM generate_series(1,3) x CROSS JOIN generate_series(2,4) As y)
 As foo
 WHERE ST_DWithin(street_line, house_loc, 0.2);

 It gives a

 ERROR:  line_locate_point: 1st arg isnt a line


 on both my 1.5.3 and 2.0 installs

Ticket URL: <http://trac.osgeo.org/postgis/ticket/1242>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.

More information about the postgis-devel mailing list