pgRouting Manual (2.0.0)

pgr_pointToId

«  pgr_isColumnInTable   ::   Contents   ::   pgr_quote_ident  »

pgr_pointToId

Name

pgr_pointToId — Inserts a point into a vertices table and returns the corresponig id.

Note

This function is intended for the developer’s aid. Use pgr_createTopology or pgr_createVerticesTable instead.

Synopsis

This function returns the id of the row in the vertices table that corresponds to the point geometry

bigint pgr_pointToId(geometry point, double precision tolerance,text vertname text,integer srid)

Description

point:geometry “POINT” geometry to be inserted.
tolerance:float8 Snapping tolerance of disconnected edges. (in projection unit)
vertname:text Vertices table name WITH schema included.
srid:integer SRID of the geometry point.

This function returns the id of the row that corresponds to the point geometry

  • When the point geometry already exists in the vertices table vertname, it returns the corresponing id.
  • When the point geometry is not found in the vertices table vertname, the funcion inserts the point and returns the corresponing id of the newly created vertex.

Warning

The function do not perform any checking of the parameters. Any validation has to be done before calling this function.

History

  • Renamed in version 2.0.0

See Also

«  pgr_isColumnInTable   ::   Contents   ::   pgr_quote_ident  »