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 tablevertname
, it returns the corresponingid
.- When the
point
geometry is not found in the vertices tablevertname
, the funcion inserts thepoint
and returns the corresponingid
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.