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