pgRouting Manual (2.3)

pgr_pointToId - Deprecated Function

«  pgr_isColumnInTable - Deprecated Function   ::   Contents   ::   pgr_quote_ident - Deprecated Function  »

pgr_pointToId - Deprecated Function

Warning

This function is deprecated!!!

  • Is no longer supported.
  • May be removed from future versions.
  • There is no replacement.

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.

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 corresponding id.
  • When the point geometry is not found in the vertices table vertname, the function inserts the point and returns the corresponding 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 - Deprecated Function   ::   Contents   ::   pgr_quote_ident - Deprecated Function  »