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.

Hi Dave

Sorry I didnt make documentation about the new table,

I am on a trip, so for the moment I can tell you based on this code

https://github.com/pgRouting/osm2pgrouting/blob/master/src/database/pois_config.cpp#L49

There is no X / Y columns

fraction is the fraction of the edge

because 0 and 1 are whole numbers vertex_id would be the corresponding vertex of the point of interest

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)

When I have time I will try to elaborate the documentation of this table,

Vicky

## ···

On Thu, Oct 19, 2017 at 9:16 PM, Dave Potts <mrdapotts@gmail.com> wrote:

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.

Pgrouting-users mailing list

Pgrouting-users@lists.osgeo.org

https://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

```
Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany
Vicky Vergara
Operations Research
eMail: vicky@[georepublic.de](http://georepublic.de)
Web: [https://georepublic.info](https://georepublic.info)
Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9
Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
```

Thanks I will try and figure it out tomorrow.

an

I am currently having fun with the flow stuff

I think one of the issues is that this methods can generate a result, but you need to know what the result means!

Dave.

## ···

On 21 October 2017 at 14:49, Vicky Vergara <vicky@georepublic.de> wrote:

Hi Dave

Sorry I didnt make documentation about the new table,

I am on a trip, so for the moment I can tell you based on this code

https://github.com/pgRouting/osm2pgrouting/blob/master/src/database/pois_config.cpp#L49

There is no X / Y columns

fraction is the fraction of the edge

because 0 and 1 are whole numbers vertex_id would be the corresponding vertex of the point of interest

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)

When I have time I will try to elaborate the documentation of this table,

Vicky

Pgrouting-users mailing list

Pgrouting-users@lists.osgeo.org

https://lists.osgeo.org/mailman/listinfo/pgrouting-users

On Thu, Oct 19, 2017 at 9:16 PM, Dave Potts <mrdapotts@gmail.com> wrote:

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.

Pgrouting-users mailing list

Pgrouting-users@lists.osgeo.org

https://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

```
Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany
Vicky Vergara
Operations Research
eMail: vicky@[georepublic.de](http://georepublic.de)
Web: [https://georepublic.info](https://georepublic.info)
Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9
Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
```