Pipe

Alias: pipe | API: feature_types/90

Tube for transporting liquids, gases, or finely divided solids. Typically used for natural gas, oil, drinking water and wastewater.

Properties

Alias	Name	Type	Unit	Description
id	ID	serial_pk		Primary key
dc_id	DC ID	int4		ID of dataconnection that manages the basic properties (label, geometry) of a particular feature
id_src	ID SRC	text		Feature type identifier in source dataset
category	Category	propchoice_fk		Subtype of a feature
system	System	propchoice_fk
start_node	Start node	int8
end_node	End node	int8
construction_year	Construction year	int2		Year in which this feature was built
material	Material	propchoice_fk
intended_use	Intended use	propchoice_fk		Intended use of an object as legally defined by the government.
flow_direction	Flow direction	propchoice_fk
shape	Shape	propchoice_fk
width	Width	float8	m
length	Length	float8	m
diameter	Diameter	float4	mm
height	Height	float8	m	Length of an object from top to bottom along its vertical axis (difference between height_top and height_bottom).
wall_thickness	Wall thickness	float8	mm
joint	Joint	propchoice_fk
status	Status	propchoice_fk		Situation of an object at a particular time during a process
construction_date	Construction date	date		Date at which this feature was built
start_date	Start date	date		Date since which this object exists
end_date	End date	date		Date till which this object existed
invert_level_start	Invert level start	float8	m+MSL	Invert level at starting point
invert_level_end	Invert level end	float8	m+MSL	Invert level at end point
last_cleaned	Last cleaned	timestamptz
last_inspected	Last inspected	timestamptz
nominal_pressure	Nominal pressure	float4	bar	The pressure value used to classify and designate components and systems. It serves as a reference for design and standardization.
details	Details	jsonb		Field for country- or dataset specific info that is not used for visualization or calculation purposes
centerline	Centerline	geometry
obvert_level_end	Obvert level end	float8	m+MSL	Obvert level at end point
obvert_level_start	Obvert level start	float8	m+MSL	Obvert level at start point
crown_level_end	Crown level end	float8	m+MSL	Crown level (outside) at end point
crown_level_start	Crown level start	float8	m+MSL	Crown level (outside) at start point
centroid	Centroid	geometry
polygon	Polygon	geometry
operator	Operator	text		A person or organization responsible for the operation, management, and maintenance of a system, service, or infrastructure. The operator ensures that the system or network functions properly, addresses issues, and performs any required administrative or technical tasks

Choices for category

Alias	Name	Unit	Description
transport	Transport
distribution	Distribution
service	Service

Choices for system

Alias	Name	Unit	Description
wastewater_collection	Wastewater collection
drinking_water_distribution	Drinking water distribution
gas_distribution	Gas distribution
power_distribution	Power distribution

Choices for material

Alias	Name	Unit	Description
pvc	PVC
concrete	Concrete
reinforced_concrete	Reinforced concrete
ductile_cast_iron	Ductile cast iron
steel	Steel
other	Other
gray_cast_iron	Gray cast iron
pe	PE
asbestos_cement	Asbestos cement
pvc_impact_resistant	PVC (impact resistant)
copper	Copper
pe_and_copper	PE and copper
unknown	Unknown
multilayer	Multilayer

Choices for intended_use

Alias	Name	Unit	Description
drinking_water	Drinking water
sanitary_sewage	Sanitary sewage
surface_water	Surface water
combined_sewage	Combined sewage
natural_gas	Natural gas
other	Other

Choices for shape

Alias	Name	Unit	Description
egg	Egg
circular	Circular
rectangular	Rectangular
other	Other

Choices for joint

Alias	Name	Unit	Description
spigot_socket	Spigot-socket
other	Other

Choices for status

Alias	Name	Unit	Description
in_use	In use
abandoned	Abandoned
established	Established
unknown	Unknown