# pgRouting Manual (2.1.0)

## 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.

Warning

This function is deprecated in 2.1

## 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

- Developer’s Guide for the tree layout of the project.
- pgr_createVerticesTable to create a topology based on the geometry.
- pgr_createTopology to create a topology based on the geometry.