[pgrouting-users] pointsOfInterest table

Dave Potts mrdapotts at gmail.com
Thu Oct 19 19:16:23 PDT 2017


Can anybody confirm that the  in the table are as follows
CREATE TABLE pointsOfInterest( pid BIGSERIAL,
 x FLOAT,
y FLOAT,
 edge_id BIGINT,
side CHAR,
fraction FLOAT,
 the_geom geometry,
 newPoint geometry );
pid primary key the table
x/y   coordinates of teh point of interest
edge_id   the nearest edge id to this point of interest
has a value of l r b  ?
fraction ?
the_geom the geometry of the point
newPoint  the nearest point on the edge that is closest to this point

Any suggestions welcome

Dave.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20171020/c3422288/attachment.html>


More information about the Pgrouting-users mailing list