pggeodb.nancy.inrae.fr/db_arboretum |
|
View: edge
pggeodb.nancy.inrae.fr/db_arboretum |
|
View: edge
Schema
Owner
albenard
Descriptions
Contains edge topology primitives
Columns
Name | Data type | Description |
|---|---|---|
edge_id |
integer |
Unique identifier of the edge |
start_node |
integer |
Unique identifier of the node at the start of the edge |
end_node |
integer |
Unique identifier of the node at the end of the edge |
next_left_edge |
integer |
Unique identifier of the next edge of the face on the left (when looking in the direction from START_NODE to END_NODE), moving counterclockwise around the face boundary |
next_right_edge |
integer |
Unique identifier of the next edge of the face on the right (when looking in the direction from START_NODE to END_NODE), moving counterclockwise around the face boundary |
left_face |
integer |
Unique identifier of the face on the left side of the edge when looking in the direction from START_NODE to END_NODE |
right_face |
integer |
Unique identifier of the face on the right side of the edge when looking in the direction from START_NODE to END_NODE |
geom |
public.geometry |
The geometry of the edge |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
INSERT |
|
|
|
Indices
There are no indices for table edge
Definition
edge_id,
start_node,
end_node,
next_left_edge,
next_right_edge,
left_face,
right_face,
geom)
AS
SELECT edge_data.edge_id,
edge_data.start_node,
edge_data.end_node,
edge_data.next_left_edge,
edge_data.next_right_edge,
edge_data.left_face,
edge_data.right_face,
edge_data.geom
FROM placeautopo.edge_data;
CREATE RULE edge_insert_rule AS ON INSERT TO placeautopo.edge
DO INSTEAD (
INSERT INTO placeautopo.edge_data (edge_id, start_node, end_node, next_left_edge, abs_next_left_edge, next_right_edge, abs_next_right_edge, left_face, right_face, geom)
VALUES (new.edge_id, new.start_node, new.end_node, new.next_left_edge, abs(new.next_left_edge), new.next_right_edge, abs(new.next_right_edge), new.left_face, new.right_face, new.geom);
);
COMMENT ON VIEW placeautopo.edge
IS 'Contains edge topology primitives';
COMMENT ON COLUMN placeautopo.edge.edge_id
IS 'Unique identifier of the edge';
COMMENT ON COLUMN placeautopo.edge.start_node
IS 'Unique identifier of the node at the start of the edge';
COMMENT ON COLUMN placeautopo.edge.end_node
IS 'Unique identifier of the node at the end of the edge';
COMMENT ON COLUMN placeautopo.edge.next_left_edge
IS 'Unique identifier of the next edge of the face on the left (when looking in the direction from START_NODE to END_NODE), moving counterclockwise around the face boundary';
COMMENT ON COLUMN placeautopo.edge.next_right_edge
IS 'Unique identifier of the next edge of the face on the right (when looking in the direction from START_NODE to END_NODE), moving counterclockwise around the face boundary';
COMMENT ON COLUMN placeautopo.edge.left_face
IS 'Unique identifier of the face on the left side of the edge when looking in the direction from START_NODE to END_NODE';
COMMENT ON COLUMN placeautopo.edge.right_face
IS 'Unique identifier of the face on the right side of the edge when looking in the direction from START_NODE to END_NODE';
COMMENT ON COLUMN placeautopo.edge.geom
IS 'The geometry of the edge';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |
|