vw_export_wastewater_structure

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
_bottom_label text 2147483647 null
_channel_function_hierarchic int4 10 null
_channel_usage_current int4 10 null
_cover_label text 2147483647 null
_depth numeric 6,3 null
_input_label text 2147483647 null
_label text 2147483647 null
_output_label text 2147483647 null
accessibility int4 10 null
co_brand text 2147483647 null
co_diameter int2 5 null
co_fastening int4 10 null
co_identifier text 2147483647 null
co_level numeric 7,3 null
co_material int4 10 null
co_obj_id varchar 16 null
co_positional_accuracy int4 10 null
co_remark text 2147483647 null
co_renovation_demand int4 10 null
co_shape int4 10 null
co_sludge_bucket int4 10 null
co_venting int4 10 null
condition_score numeric 3,2 null
contract_section text 2147483647 null
dp_highwater_level numeric 7,3 null
dp_relevance int4 10 null
dp_terrain_level numeric 7,3 null
dp_upper_elevation numeric 7,3 null
dp_water_course_number text 2147483647 null
dp_water_course_segment_canton text 2147483647 null
dp_waterlevel_hydraulic numeric 7,3 null
elevation_determination int4 10 null
financing int4 10 null
fk_dataowner varchar 16 null
fk_operator varchar 16 null
fk_owner varchar 16 null
fk_provider varchar 16 null
gross_costs numeric 10,2 null
identifier text 2147483647 null
ii_absorption_capacity numeric 9,3 null
ii_defects int4 10 null
ii_dimension1 int2 5 null
ii_dimension2 int2 5 null
ii_distance_to_aquifer numeric 7,2 null
ii_effective_area numeric 8,2 null
ii_emergency_overflow int4 10 null
ii_filling_material int4 10 null
ii_fk_dss15_aquifer varchar 16 null
ii_kind int4 10 null
ii_labeling int4 10 null
ii_seepage_utilization int4 10 null
ii_upper_elevation numeric 7,3 null
ii_vehicle_access int4 10 null
ii_watertightness int4 10 null
inspection_interval numeric 4,2 null
last_modification timestamp 29,6 null
location_name text 2147483647 null
ma_amphibian_exit int4 10 null
ma_dimension1 int2 5 null
ma_dimension2 int2 5 null
ma_function int4 10 null
ma_material int4 10 null
ma_orientation numeric 0 null
ma_possibility_intervention int4 10 null
ma_surface_inflow int4 10 null
obj_id varchar 16 null
records text 2147483647 null
remark text 2147483647 null
renovation_necessity int4 10 null
replacement_value numeric 10,2 null
rv_base_year int2 5 null
rv_construction_type int4 10 null
situation3d_geometry geometry 2147483647 null
ss_amphibian_exit int4 10 null
ss_bypass int4 10 null
ss_emergency_overflow int4 10 null
ss_function int4 10 null
ss_possibility_intervention int4 10 null
ss_stormwater_tank_arrangement int4 10 null
ss_upper_elevation numeric 7,3 null
status int4 10 null
status_survey_year int2 5 null
structure_condition int4 10 null
subsidies numeric 10,2 null
urgency_figure int2 5 null
wn_backflow_level_current numeric 7,3 null
wn_bottom_level numeric 7,3 null
wn_elevation_accuracy int4 10 null
wn_fk_dataowner varchar 16 null
wn_fk_hydr_geometry varchar 16 null
wn_fk_provider varchar 16 null
wn_fk_wastewater_structure varchar 16 null
wn_function_node_amelioration int4 10 null
wn_identifier text 2147483647 null
wn_last_modification timestamp 29,6 null
wn_obj_id varchar 16 null
wn_remark text 2147483647 null
wn_wwtp_number int4 10 null
ws_type text 2147483647 null
year_of_construction int2 5 null
year_of_replacement int2 5 null
cover_shape_code int4 10 null
cover_shape_abbr_de varchar 3 null
cover_shape_abbr_en varchar 3 null
cover_shape_abbr_fr varchar 3 null
cover_shape_abbr_it varchar 3 null
cover_shape_abbr_ro varchar 3 null
cover_shape_active bool 1 null
cover_shape_value_de varchar 100 null
cover_shape_value_en varchar 100 null
cover_shape_value_fr varchar 100 null
cover_shape_value_it varchar 100 null
cover_shape_value_ro varchar 100 null
cover_shape_vsacode int4 10 null
cover_fastening_code int4 10 null
cover_fastening_abbr_de varchar 3 null
cover_fastening_abbr_en varchar 3 null
cover_fastening_abbr_fr varchar 3 null
cover_fastening_abbr_it varchar 3 null
cover_fastening_abbr_ro varchar 3 null
cover_fastening_active bool 1 null
cover_fastening_value_de varchar 100 null
cover_fastening_value_en varchar 100 null
cover_fastening_value_fr varchar 100 null
cover_fastening_value_it varchar 100 null
cover_fastening_value_ro varchar 100 null
cover_fastening_vsacode int4 10 null
cover_material_code int4 10 null
cover_material_abbr_de varchar 3 null
cover_material_abbr_en varchar 3 null
cover_material_abbr_fr varchar 3 null
cover_material_abbr_it varchar 3 null
cover_material_abbr_ro varchar 3 null
cover_material_active bool 1 null
cover_material_value_de varchar 100 null
cover_material_value_en varchar 100 null
cover_material_value_fr varchar 100 null
cover_material_value_it varchar 100 null
cover_material_value_ro varchar 100 null
cover_material_vsacode int4 10 null
positional_accuracy_code int4 10 null
positional_accuracy_abbr_de varchar 3 null
positional_accuracy_abbr_en varchar 3 null
positional_accuracy_abbr_fr varchar 3 null
positional_accuracy_abbr_it varchar 3 null
positional_accuracy_abbr_ro varchar 3 null
positional_accuracy_active bool 1 null
positional_accuracy_value_de varchar 100 null
positional_accuracy_value_en varchar 100 null
positional_accuracy_value_fr varchar 100 null
positional_accuracy_value_it varchar 100 null
positional_accuracy_value_ro varchar 100 null
positional_accuracy_vsacode int4 10 null
sludge_bucket_code int4 10 null
sludge_bucket_abbr_de varchar 3 null
sludge_bucket_abbr_en varchar 3 null
sludge_bucket_abbr_fr varchar 3 null
sludge_bucket_abbr_it varchar 3 null
sludge_bucket_abbr_ro varchar 3 null
sludge_bucket_active bool 1 null
sludge_bucket_value_de varchar 100 null
sludge_bucket_value_en varchar 100 null
sludge_bucket_value_fr varchar 100 null
sludge_bucket_value_it varchar 100 null
sludge_bucket_value_ro varchar 100 null
sludge_bucket_vsacode int4 10 null
venting_code int4 10 null
venting_abbr_de varchar 3 null
venting_abbr_en varchar 3 null
venting_abbr_fr varchar 3 null
venting_abbr_it varchar 3 null
venting_abbr_ro varchar 3 null
venting_active bool 1 null
venting_value_de varchar 100 null
venting_value_en varchar 100 null
venting_value_fr varchar 100 null
venting_value_it varchar 100 null
venting_value_ro varchar 100 null
venting_vsacode int4 10 null
renovation_demand_code int4 10 null
renovation_demand_abbr_de varchar 3 null
renovation_demand_abbr_en varchar 3 null
renovation_demand_abbr_fr varchar 3 null
renovation_demand_abbr_it varchar 3 null
renovation_demand_abbr_ro varchar 3 null
renovation_demand_active bool 1 null
renovation_demand_value_de varchar 100 null
renovation_demand_value_en varchar 100 null
renovation_demand_value_fr varchar 100 null
renovation_demand_value_it varchar 100 null
renovation_demand_value_ro varchar 100 null
renovation_demand_vsacode int4 10 null
financing_code int4 10 null
financing_abbr_de varchar 3 null
financing_abbr_en varchar 3 null
financing_abbr_fr varchar 3 null
financing_abbr_it varchar 3 null
financing_abbr_ro varchar 3 null
financing_active bool 1 null
financing_value_de varchar 100 null
financing_value_en varchar 100 null
financing_value_fr varchar 100 null
financing_value_it varchar 100 null
financing_value_ro varchar 100 null
financing_vsacode int4 10 null
renovation_necessity_code int4 10 null
renovation_necessity_abbr_de varchar 3 null
renovation_necessity_abbr_en varchar 3 null
renovation_necessity_abbr_fr varchar 3 null
renovation_necessity_abbr_it varchar 3 null
renovation_necessity_abbr_ro varchar 3 null
renovation_necessity_active bool 1 null
renovation_necessity_value_de varchar 100 null
renovation_necessity_value_en varchar 100 null
renovation_necessity_value_fr varchar 100 null
renovation_necessity_value_it varchar 100 null
renovation_necessity_value_ro varchar 100 null
renovation_necessity_vsacode int4 10 null
rv_construction_type_code int4 10 null
rv_construction_type_abbr_de varchar 3 null
rv_construction_type_abbr_en varchar 3 null
rv_construction_type_abbr_fr varchar 3 null
rv_construction_type_abbr_it varchar 3 null
rv_construction_type_abbr_ro varchar 3 null
rv_construction_type_active bool 1 null
rv_construction_type_value_de varchar 100 null
rv_construction_type_value_en varchar 100 null
rv_construction_type_value_fr varchar 100 null
rv_construction_type_value_it varchar 100 null
rv_construction_type_value_ro varchar 100 null
rv_construction_type_vsacode int4 10 null
status_code int4 10 null
status_abbr_de varchar 3 null
status_abbr_en varchar 3 null
status_abbr_fr varchar 3 null
status_abbr_it varchar 3 null
status_abbr_ro varchar 3 null
status_active bool 1 null
status_value_de varchar 100 null
status_value_en varchar 100 null
status_value_fr varchar 100 null
status_value_it varchar 100 null
status_value_ro varchar 100 null
status_vsacode int4 10 null
structure_condition_code int4 10 null
structure_condition_abbr_de varchar 3 null
structure_condition_abbr_en varchar 3 null
structure_condition_abbr_fr varchar 3 null
structure_condition_abbr_it varchar 3 null
structure_condition_abbr_ro varchar 3 null
structure_condition_active bool 1 null
structure_condition_value_de varchar 100 null
structure_condition_value_en varchar 100 null
structure_condition_value_fr varchar 100 null
structure_condition_value_it varchar 100 null
structure_condition_value_ro varchar 100 null
structure_condition_vsacode int4 10 null
owner_obj_id varchar 16 null
owner_fk_dataowner varchar 16 null
owner_fk_provider varchar 16 null
owner_identifier text 2147483647 null
owner_identifier_short text 2147483647 null
owner_last_modification timestamp 29,6 null
owner_municipality_number int2 5 null
owner_organisation_type int4 10 null
owner_remark text 2147483647 null
owner_status int4 10 null
owner_tww_active bool 1 null
owner_tww_local_extension bool 1 null
owner_uid text 2147483647 null
operator_obj_id varchar 16 null
operator_fk_dataowner varchar 16 null
operator_fk_provider varchar 16 null
operator_identifier text 2147483647 null
operator_identifier_short text 2147483647 null
operator_last_modification timestamp 29,6 null
operator_municipality_number int2 5 null
operator_organisation_type int4 10 null
operator_remark text 2147483647 null
operator_status int4 10 null
operator_tww_active bool 1 null
operator_tww_local_extension bool 1 null
operator_uid text 2147483647 null
manhole_function_code int4 10 null
manhole_function_abbr_de varchar 3 null
manhole_function_abbr_en varchar 3 null
manhole_function_abbr_fr varchar 3 null
manhole_function_abbr_it varchar 3 null
manhole_function_abbr_ro varchar 3 null
manhole_function_active bool 1 null
manhole_function_value_de varchar 100 null
manhole_function_value_en varchar 100 null
manhole_function_value_fr varchar 100 null
manhole_function_value_it varchar 100 null
manhole_function_value_ro varchar 100 null
manhole_function_vsacode int4 10 null
material_code int4 10 null
material_abbr_de varchar 3 null
material_abbr_en varchar 3 null
material_abbr_fr varchar 3 null
material_abbr_it varchar 3 null
material_abbr_ro varchar 3 null
material_active bool 1 null
material_value_de varchar 100 null
material_value_en varchar 100 null
material_value_fr varchar 100 null
material_value_it varchar 100 null
material_value_ro varchar 100 null
material_vsacode int4 10 null
surface_inflow_code int4 10 null
surface_inflow_abbr_de varchar 3 null
surface_inflow_abbr_en varchar 3 null
surface_inflow_abbr_fr varchar 3 null
surface_inflow_abbr_it varchar 3 null
surface_inflow_abbr_ro varchar 3 null
surface_inflow_active bool 1 null
surface_inflow_value_de varchar 100 null
surface_inflow_value_en varchar 100 null
surface_inflow_value_fr varchar 100 null
surface_inflow_value_it varchar 100 null
surface_inflow_value_ro varchar 100 null
surface_inflow_vsacode int4 10 null
bypass_code int4 10 null
bypass_abbr_de varchar 3 null
bypass_abbr_en varchar 3 null
bypass_abbr_fr varchar 3 null
bypass_abbr_it varchar 3 null
bypass_abbr_ro varchar 3 null
bypass_active bool 1 null
bypass_value_de varchar 100 null
bypass_value_en varchar 100 null
bypass_value_fr varchar 100 null
bypass_value_it varchar 100 null
bypass_value_ro varchar 100 null
bypass_vsacode int4 10 null
special_structure_function_code int4 10 null
special_structure_function_abbr_de varchar 3 null
special_structure_function_abbr_en varchar 3 null
special_structure_function_abbr_fr varchar 3 null
special_structure_function_abbr_it varchar 3 null
special_structure_function_abbr_ro varchar 3 null
special_structure_function_active bool 1 null
special_structure_function_value_de varchar 100 null
special_structure_function_value_en varchar 100 null
special_structure_function_value_fr varchar 100 null
special_structure_function_value_it varchar 100 null
special_structure_function_value_ro varchar 100 null
special_structure_function_vsacode int4 10 null
stormwater_tank_arrangement_code int4 10 null
stormwater_tank_arrangement_abbr_de varchar 3 null
stormwater_tank_arrangement_abbr_en varchar 3 null
stormwater_tank_arrangement_abbr_fr varchar 3 null
stormwater_tank_arrangement_abbr_it varchar 3 null
stormwater_tank_arrangement_abbr_ro varchar 3 null
stormwater_tank_arrangement_active bool 1 null
stormwater_tank_arrangement_value_de varchar 100 null
stormwater_tank_arrangement_value_en varchar 100 null
stormwater_tank_arrangement_value_fr varchar 100 null
stormwater_tank_arrangement_value_it varchar 100 null
stormwater_tank_arrangement_value_ro varchar 100 null
stormwater_tank_arrangement_vsacode int4 10 null
relevance_code int4 10 null
relevance_abbr_de varchar 3 null
relevance_abbr_en varchar 3 null
relevance_abbr_fr varchar 3 null
relevance_abbr_it varchar 3 null
relevance_abbr_ro varchar 3 null
relevance_active bool 1 null
relevance_value_de varchar 100 null
relevance_value_en varchar 100 null
relevance_value_fr varchar 100 null
relevance_value_it varchar 100 null
relevance_value_ro varchar 100 null
relevance_vsacode int4 10 null

Relationships

View Definition


Possibly Referenced Tables/Views