<div dir="ltr">Thanks I will try and figure it out tomorrow.<div>an </div><div>I am currently having fun with the flow stuff</div><div><br></div><div>I think one of the issues is that this methods can generate a result, but you need to know what the result means!</div><div><br></div><div>Dave.<br><div class="gmail_extra"><br><div class="gmail_quote">On 21 October 2017 at 14:49, Vicky Vergara <span dir="ltr"><<a href="mailto:vicky@georepublic.de" target="_blank">vicky@georepublic.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div style="font-family:arial,helvetica,sans-serif">Hi Dave</div><div style="font-family:arial,helvetica,sans-serif"><br></div><div style="font-family:arial,helvetica,sans-serif">Sorry I didnt make documentation about the new table,</div><div style="font-family:arial,helvetica,sans-serif">I am on a trip, so for the moment I can tell you based on this code<br></div><div style="font-family:arial,helvetica,sans-serif"><a href="https://github.com/pgRouting/osm2pgrouting/blob/master/src/database/pois_config.cpp#L49" target="_blank">https://github.com/pgRouting/<wbr>osm2pgrouting/blob/master/src/<wbr>database/pois_config.cpp#L49</a></div><div style="font-family:arial,helvetica,sans-serif"><br></div><div style="font-family:arial,helvetica,sans-serif">There is no X / Y columns</div><div style="font-family:arial,helvetica,sans-serif">fraction is the fraction of the edge<br></div><div style="font-family:arial,helvetica,sans-serif">because 0 and 1 are whole numbers vertex_id would be the corresponding vertex of the point of interest</div><div style="font-family:arial,helvetica,sans-serif">there is a column new_geom which would have the new geometry if a point was found in the topology (aka was not too far)</div><div style="font-family:arial,helvetica,sans-serif"><br></div><div style="font-family:arial,helvetica,sans-serif">When I have time I will try to elaborate the documentation of this table,</div><div style="font-family:arial,helvetica,sans-serif"><br></div><div style="font-family:arial,helvetica,sans-serif"><br></div><div style="font-family:arial,helvetica,sans-serif">Vicky<br></div><div style="font-family:arial,helvetica,sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Thu, Oct 19, 2017 at 9:16 PM, Dave Potts <span dir="ltr"><<a href="mailto:mrdapotts@gmail.com" target="_blank">mrdapotts@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Can anybody confirm that the in the table are as follows<div>CREATE TABLE pointsOfInterest(
pid BIGSERIAL,</div><div> x FLOAT, </div><div>y FLOAT,</div><div> edge_id BIGINT, </div><div>side CHAR, </div><div>fraction FLOAT,</div><div> the_geom geometry,</div><div> newPoint geometry
);<br></div><div>pid primary key the table</div><div>x/y coordinates of teh point of interest</div><div>edge_id the nearest edge id to this point of interest</div><div>has a value of l r b ?</div><div>fraction ?</div><div>the_geom the geometry of the point</div><div>newPoint the nearest point on the edge that is closest to this point</div><div><br></div><div>Any suggestions welcome</div><span class="m_-7131206144200001799HOEnZb"><font color="#888888"><div><br></div><div>Dave.</div></font></span></div>
<br></div></div>______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.or<wbr>g</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/pgrouting-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div class="m_-7131206144200001799gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre>Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany
Vicky Vergara
Operations Research
eMail: vicky@<a href="http://georepublic.de" target="_blank">georepublic.de</a>
Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a>
Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9
Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
<span></span></pre></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>
<br>______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.<wbr>org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/pgrouting-<wbr>users</a><br></blockquote></div><br></div></div></div>