search

opengisch / pum

Postgres Upgrades Manager
GNU General Public License v2.0
30 stars 7 forks source link

fix output of pum check #80

Closed olivierdalang closed 4 years ago

olivierdalang commented 4 years ago

fix for #78

olivierdalang commented 4 years ago

also improved listing of triggers, here some diffs were missing

3nids commented 4 years ago

can you paste the new output?

olivierdalang commented 4 years ago

Before (colorized as yaml):

Check...
DIFFERENCES FOUND
columns:
- '- (''qgep_od'', ''catchment_area'', ''surface_area'', None, ''YES'', ''numeric'',
  None, '''
- + ('qgep_od', 'catchment_area', 'surface_area', None, 'YES', 'numeric', None, '
- '- (''qgep_od'', ''cover'', ''situation_geometry'', None, ''NO'', ''USER-DEFINED'',
  None, '
- + ('qgep_od', 'cover', 'situation_geometry', None, 'YES', 'USER-DEFINED', None,
- '- (''qgep_od'', ''cover_190910'', ''brand'', None, ''YES'', ''character varying'',
  ''50'', '
- '- (''qgep_od'', ''cover_190910'', ''cover_shape'', None, ''YES'', ''integer'',
  None, ''32'''
- '- (''qgep_od'', ''cover_190910'', ''diameter'', None, ''YES'', ''smallint'', None,
  ''16'', '
- '- (''qgep_od'', ''cover_190910'', ''fastening'', None, ''YES'', ''integer'', None,
  ''32'', '
- '- (''qgep_od'', ''cover_190910'', ''level'', None, ''YES'', ''numeric'', None,
  ''7'', ''10'','
- '- (''qgep_od'', ''cover_190910'', ''material'', None, ''YES'', ''integer'', None,
  ''32'', '''
- '- (''qgep_od'', ''cover_190910'', ''obj_id'', None, ''YES'', ''character varying'',
  ''16'','
- '- (''qgep_od'', ''cover_190910'', ''positional_accuracy'', None, ''YES'', ''integer'',
  No'
- '- (''qgep_od'', ''cover_190910'', ''situation_geometry'', None, ''YES'', ''USER-DEFINED'''
- '- (''qgep_od'', ''cover_190910'', ''sludge_bucket'', None, ''YES'', ''integer'',
  None, ''3'
- '- (''qgep_od'', ''cover_190910'', ''venting'', None, ''YES'', ''integer'', None,
  ''32'', ''2'
- '- (''qgep_od'', ''fi_statistic'', ''fi_ct_element'', None, ''YES'', ''bigint'',
  None, ''64'
- '- (''qgep_od'', ''fi_statistic'', ''fi_table'', None, ''YES'', ''character varying'',
  ''50'
- '- (''qgep_od'', ''reach'', ''progression_geometry'', None, ''NO'', ''USER-DEFINED'',
  None'
- + ('qgep_od', 'reach', 'progression_geometry', None, 'YES', 'USER-DEFINED', Non
- '- (''qgep_od'', ''reach_point'', ''situation_geometry'', None, ''NO'', ''USER-DEFINED'', '
- + ('qgep_od', 'reach_point', 'situation_geometry', None, 'YES', 'USER-DEFINED',
- '- (''qgep_od'', ''stat_reach'', ''ch_bedding_encasement'', None, ''YES'', ''integer'',
  No'
- '- (''qgep_od'', ''stat_reach'', ''ch_connection_type'', None, ''YES'', ''integer'',
  None,'
- '- (''qgep_od'', ''stat_reach'', ''ch_jetting_interval'', None, ''YES'', ''numeric'',
  None'
- '- (''qgep_od'', ''stat_reach'', ''ch_pipe_length'', None, ''YES'', ''numeric'',
  None, ''7'''
- '- (''qgep_od'', ''stat_reach'', ''ch_usage_planned'', None, ''YES'', ''integer'',
  None, '''
- '- (''qgep_od'', ''stat_reach'', ''clear_height'', None, ''YES'', ''integer'', None,
  ''32'','
- '- (''qgep_od'', ''stat_reach'', ''coefficient_of_friction'', None, ''YES'', ''smallint'','
- '- (''qgep_od'', ''stat_reach'', ''elevation_determination'', None, ''YES'', ''integer'', '
- '- (''qgep_od'', ''stat_reach'', ''fk_dataowner'', None, ''YES'', ''character varying'',
  '''
- '- (''qgep_od'', ''stat_reach'', ''fk_pipe_profile'', None, ''YES'', ''character
  varying'''
- '- (''qgep_od'', ''stat_reach'', ''fk_provider'', None, ''YES'', ''character varying'',
  ''1'
- '- (''qgep_od'', ''stat_reach'', ''fk_wastewater_structure'', None, ''YES'', ''character '
- '- (''qgep_od'', ''stat_reach'', ''function_hierarchic'', None, ''YES'', ''integer'',
  None'
- '- (''qgep_od'', ''stat_reach'', ''function_hydraulic'', None, ''YES'', ''integer'',
  None,'
- '- (''qgep_od'', ''stat_reach'', ''horizontal_positioning'', None, ''YES'', ''integer'',
  N'
- '- (''qgep_od'', ''stat_reach'', ''identifier'', None, ''YES'', ''character varying'',
  ''20'
- '- (''qgep_od'', ''stat_reach'', ''inside_coating'', None, ''YES'', ''integer'',
  None, ''32'
- '- (''qgep_od'', ''stat_reach'', ''last_modification'', None, ''YES'', ''timestamp
  withou'
- '- (''qgep_od'', ''stat_reach'', ''length_effective'', None, ''YES'', ''numeric'',
  None, '''
- '- (''qgep_od'', ''stat_reach'', ''material'', None, ''YES'', ''integer'', None,
  ''32'', ''2'''
- '- (''qgep_od'', ''stat_reach'', ''obj_id'', None, ''YES'', ''character varying'',
  ''16'', N'
- '- (''qgep_od'', ''stat_reach'', ''progression_geometry'', None, ''YES'', ''USER-DEFINED'''
- '- (''qgep_od'', ''stat_reach'', ''reliner_material'', None, ''YES'', ''integer'',
  None, '''
- '- (''qgep_od'', ''stat_reach'', ''reliner_nominal_size'', None, ''YES'', ''integer'',
  Non'
- '- (''qgep_od'', ''stat_reach'', ''relining_construction'', None, ''YES'', ''integer'',
  No'
- '- (''qgep_od'', ''stat_reach'', ''relining_kind'', None, ''YES'', ''integer'',
  None, ''32'''
- '- (''qgep_od'', ''stat_reach'', ''remark'', None, ''YES'', ''character varying'',
  ''80'', N'
- '- (''qgep_od'', ''stat_reach'', ''ring_stiffness'', None, ''YES'', ''smallint'',
  None, ''1'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_elevation_accuracy'', None, ''YES'',
  ''integer'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_fk_dataowner'', None, ''YES'', ''character
  var'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_fk_provider'', None, ''YES'', ''character
  vary'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_fk_wastewater_networkelement'', None,
  ''YES'''
- '- (''qgep_od'', ''stat_reach'', ''rp_from_identifier'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_last_modification'', None, ''YES'', ''timestam'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_level'', None, ''YES'', ''numeric'',
  None, ''7'','
- '- (''qgep_od'', ''stat_reach'', ''rp_from_obj_id'', None, ''YES'', ''character
  varying'','
- '- (''qgep_od'', ''stat_reach'', ''rp_from_outlet_shape'', None, ''YES'', ''integer'',
  Non'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_position_of_connection'', None, ''YES'',
  ''sma'
- '- (''qgep_od'', ''stat_reach'', ''rp_from_remark'', None, ''YES'', ''character
  varying'','
- '- (''qgep_od'', ''stat_reach'', ''rp_to_elevation_accuracy'', None, ''YES'', ''integer'','
- '- (''qgep_od'', ''stat_reach'', ''rp_to_fk_dataowner'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''stat_reach'', ''rp_to_fk_provider'', None, ''YES'', ''character
  varyin'
- '- (''qgep_od'', ''stat_reach'', ''rp_to_fk_wastewater_networkelement'', None, ''YES'', '
- '- (''qgep_od'', ''stat_reach'', ''rp_to_identifier'', None, ''YES'', ''character
  varying'
- '- (''qgep_od'', ''stat_reach'', ''rp_to_last_modification'', None, ''YES'', ''timestamp '
- '- (''qgep_od'', ''stat_reach'', ''rp_to_level'', None, ''YES'', ''numeric'', None,
  ''7'', '''
- '- (''qgep_od'', ''stat_reach'', ''rp_to_obj_id'', None, ''YES'', ''character varying'',
  '''
- '- (''qgep_od'', ''stat_reach'', ''rp_to_outlet_shape'', None, ''YES'', ''integer'',
  None,'
- '- (''qgep_od'', ''stat_reach'', ''rp_to_position_of_connection'', None, ''YES'',
  ''small'
- '- (''qgep_od'', ''stat_reach'', ''rp_to_remark'', None, ''YES'', ''character varying'',
  '''
- '- (''qgep_od'', ''stat_reach'', ''slope_building_plan'', None, ''YES'', ''smallint'',
  Non'
- '- (''qgep_od'', ''stat_reach'', ''_slope_per_mill'', None, ''YES'', ''numeric'',
  None, No'
- '- (''qgep_od'', ''stat_reach'', ''status'', None, ''YES'', ''integer'', None, ''32'',
  ''2'', '
- '- (''qgep_od'', ''stat_reach'', ''usage_current'', None, ''YES'', ''integer'',
  None, ''32'''
- '- (''qgep_od'', ''stat_reach'', ''wall_roughness'', None, ''YES'', ''numeric'',
  None, ''5'''
- '- (''qgep_od'', ''stat_reach'', ''width'', None, ''YES'', ''integer'', None, ''32'',
  ''2'', N'
- '- (''qgep_od'', ''stat_reach'', ''ws_accessibility'', None, ''YES'', ''integer'',
  None, '''
- '- (''qgep_od'', ''stat_reach'', ''ws_contract_section'', None, ''YES'', ''character
  vary'
- '- (''qgep_od'', ''stat_reach'', ''ws_financing'', None, ''YES'', ''integer'', None,
  ''32'','
- '- (''qgep_od'', ''stat_reach'', ''ws_fk_operator'', None, ''YES'', ''character
  varying'','
- '- (''qgep_od'', ''stat_reach'', ''ws_fk_owner'', None, ''YES'', ''character varying'',
  ''1'
- '- (''qgep_od'', ''stat_reach'', ''ws_gross_costs'', None, ''YES'', ''numeric'',
  None, ''10'
- '- (''qgep_od'', ''stat_reach'', ''ws_identifier'', None, ''YES'', ''character varying'', '
- '- (''qgep_od'', ''stat_reach'', ''ws_inspection_interval'', None, ''YES'', ''numeric'',
  N'
- '- (''qgep_od'', ''stat_reach'', ''ws_last_modification'', None, ''YES'', ''timestamp
  wit'
- '- (''qgep_od'', ''stat_reach'', ''ws_location_name'', None, ''YES'', ''character
  varying'
- '- (''qgep_od'', ''stat_reach'', ''ws_obj_id'', None, ''YES'', ''character varying'',
  ''16'''
- '- (''qgep_od'', ''stat_reach'', ''ws_records'', None, ''YES'', ''character varying'',
  ''25'
- '- (''qgep_od'', ''stat_reach'', ''ws_remark'', None, ''YES'', ''character varying'',
  ''80'''
- '- (''qgep_od'', ''stat_reach'', ''ws_renovation_necessity'', None, ''YES'', ''integer'', '
- '- (''qgep_od'', ''stat_reach'', ''ws_replacement_value'', None, ''YES'', ''numeric'',
  Non'
- '- (''qgep_od'', ''stat_reach'', ''ws_rv_base_year'', None, ''YES'', ''smallint'',
  None, '''
- '- (''qgep_od'', ''stat_reach'', ''ws_rv_construction_type'', None, ''YES'', ''integer'', '
- '- (''qgep_od'', ''stat_reach'', ''ws_structure_condition'', None, ''YES'', ''integer'',
  N'
- '- (''qgep_od'', ''stat_reach'', ''ws_subsidies'', None, ''YES'', ''numeric'', None,
  ''10'','
- '- (''qgep_od'', ''stat_reach'', ''ws_year_of_replacement'', None, ''YES'', ''smallint'', '
- '- (''qgep_od'', ''stat_reach'', ''year_of_construction'', None, ''YES'', ''smallint'',
  No'
- '- (''qgep_od'', ''stat_reach_clear_h'', ''clear_height'', None, ''YES'', ''integer'',
  Non'
- '- (''qgep_od'', ''stat_reach_clear_h'', ''clear_h_length'', None, ''YES'', ''numeric'',
  N'
- '- (''qgep_od'', ''stat_reach_clear_h'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'','
- '- (''qgep_od'', ''stat_reach_clear_r'', ''clear_r_length'', None, ''YES'', ''numeric'',
  N'
- '- (''qgep_od'', ''stat_reach_clear_r'', ''length_class'', None, ''YES'', ''character
  var'
- '- (''qgep_od'', ''stat_reach_clear_r'', ''length_count'', None, ''YES'', ''bigint'',
  None'
- '- (''qgep_od'', ''stat_reach_clear_r'', ''length_fid'', None, ''NO'', ''integer'',
  None, '
- '- (''qgep_od'', ''stat_reach_fun_hie'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'','
- '- (''qgep_od'', ''stat_reach_fun_hie'', ''function_hierarchic'', None, ''YES'',
  ''intege'
- '- (''qgep_od'', ''stat_reach_fun_hie'', ''fun_hie_de'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''stat_reach_fun_hie'', ''fun_hie_length'', None, ''YES'', ''numeric'',
  N'
- '- (''qgep_od'', ''stat_reach_fun_hyd'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'','
- '- (''qgep_od'', ''stat_reach_fun_hyd'', ''function_hydraulic'', None, ''YES'',
  ''integer'
- '- (''qgep_od'', ''stat_reach_fun_hyd'', ''fun_hyd_de'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''stat_reach_fun_hyd'', ''fun_hyd_length'', None, ''YES'', ''numeric'',
  N'
- '- (''qgep_od'', ''stat_reach_length'', ''length_class'', None, ''YES'', ''character
  vary'
- '- (''qgep_od'', ''stat_reach_length'', ''length_count'', None, ''YES'', ''bigint'',
  None,'
- '- (''qgep_od'', ''stat_reach_length'', ''length_fid'', None, ''NO'', ''integer'',
  None, '''
- '- (''qgep_od'', ''stat_reach_length'', ''len_length'', None, ''YES'', ''numeric'',
  None, '
- '- (''qgep_od'', ''stat_reach_material'', ''count'', None, ''YES'', ''bigint'',
  None, ''64'''
- '- (''qgep_od'', ''stat_reach_material'', ''mat_ab_de'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''stat_reach_material'', ''mat_de'', None, ''YES'', ''character
  varying'''
- '- (''qgep_od'', ''stat_reach_material'', ''material'', None, ''YES'', ''integer'',
  None, '
- '- (''qgep_od'', ''stat_reach_material'', ''mat_length'', None, ''YES'', ''numeric'',
  None'
- '- (''qgep_od'', ''stat_reach_owner'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'', '''
- '- (''qgep_od'', ''stat_reach_owner'', ''owner_length'', None, ''YES'', ''numeric'',
  None,'
- '- (''qgep_od'', ''stat_reach_owner'', ''owner_sta'', None, ''YES'', ''character
  varying'''
- '- (''qgep_od'', ''stat_reach_owner'', ''ws_fk_owner'', None, ''YES'', ''character
  varyin'
- '- (''qgep_od'', ''stat_reach_status'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'', '
- '- (''qgep_od'', ''stat_reach_status'', ''stat_length'', None, ''YES'', ''numeric'',
  None,'
- '- (''qgep_od'', ''stat_reach_status'', ''status'', None, ''YES'', ''integer'',
  None, ''32'''
- '- (''qgep_od'', ''stat_reach_status'', ''status_de'', None, ''YES'', ''character
  varying'
- '- (''qgep_od'', ''stat_reach_use_cur'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'','
- '- (''qgep_od'', ''stat_reach_use_cur'', ''usage_current'', None, ''YES'', ''integer'',
  No'
- '- (''qgep_od'', ''stat_reach_use_cur'', ''use_cur_de'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''stat_reach_use_cur'', ''use_cur_length'', None, ''YES'', ''numeric'',
  N'
- '- (''qgep_od'', ''stat_reach_year_o_c'', ''count'', None, ''YES'', ''bigint'',
  None, ''64'''
- '- (''qgep_od'', ''stat_reach_year_o_c'', ''year_of_construction'', None, ''YES'',
  ''smal'
- '- (''qgep_od'', ''stat_reach_year_o_c'', ''yoc_length'', None, ''YES'', ''numeric'',
  None'
- '- (''qgep_od'', ''stat_wws'', ''accessibility'', None, ''YES'', ''integer'', None,
  ''32'', '
- '- (''qgep_od'', ''stat_wws'', ''_channel_function_hierarchic'', None, ''YES'',
  ''integer'
- '- (''qgep_od'', ''stat_wws'', ''_channel_usage_current'', None, ''YES'', ''integer'',
  Non'
- '- (''qgep_od'', ''stat_wws'', ''co_brand'', None, ''YES'', ''character varying'',
  ''50'', N'
- '- (''qgep_od'', ''stat_wws'', ''co_diameter'', None, ''YES'', ''smallint'', None,
  ''16'', '''
- '- (''qgep_od'', ''stat_wws'', ''co_fastening'', None, ''YES'', ''integer'', None,
  ''32'', '''
- '- (''qgep_od'', ''stat_wws'', ''co_identifier'', None, ''YES'', ''character varying'',
  ''2'
- '- (''qgep_od'', ''stat_wws'', ''co_level'', None, ''YES'', ''numeric'', None, ''7'',
  ''10'', '
- '- (''qgep_od'', ''stat_wws'', ''co_material'', None, ''YES'', ''integer'', None,
  ''32'', ''2'
- '- (''qgep_od'', ''stat_wws'', ''contract_section'', None, ''YES'', ''character
  varying'','
- '- (''qgep_od'', ''stat_wws'', ''co_obj_id'', None, ''YES'', ''character varying'',
  ''16'', '
- '- (''qgep_od'', ''stat_wws'', ''co_positional_accuracy'', None, ''YES'', ''integer'',
  Non'
- '- (''qgep_od'', ''stat_wws'', ''co_remark'', None, ''YES'', ''character varying'',
  ''80'', '
- '- (''qgep_od'', ''stat_wws'', ''co_renovation_demand'', None, ''YES'', ''integer'',
  None,'
- '- (''qgep_od'', ''stat_wws'', ''co_shape'', None, ''YES'', ''integer'', None, ''32'',
  ''2'', '
- '- (''qgep_od'', ''stat_wws'', ''co_sludge_bucket'', None, ''YES'', ''integer'',
  None, ''32'
- '- (''qgep_od'', ''stat_wws'', ''co_venting'', None, ''YES'', ''integer'', None,
  ''32'', ''2'''
- '- (''qgep_od'', ''stat_wws'', ''_depth'', None, ''YES'', ''numeric'', None, ''6'',
  ''10'', No'
- '- (''qgep_od'', ''stat_wws'', ''dp_fk_sector_water_body'', None, ''YES'', ''character
  va'
- '- (''qgep_od'', ''stat_wws'', ''dp_highwater_level'', None, ''YES'', ''numeric'',
  None, '''
- '- (''qgep_od'', ''stat_wws'', ''dp_relevance'', None, ''YES'', ''integer'', None,
  ''32'', '''
- '- (''qgep_od'', ''stat_wws'', ''dp_terrain_level'', None, ''YES'', ''numeric'',
  None, ''7'''
- '- (''qgep_od'', ''stat_wws'', ''dp_upper_elevation'', None, ''YES'', ''numeric'',
  None, '''
- '- (''qgep_od'', ''stat_wws'', ''dp_waterlevel_hydraulic'', None, ''YES'', ''numeric'',
  No'
- '- (''qgep_od'', ''stat_wws'', ''financing'', None, ''YES'', ''integer'', None,
  ''32'', ''2'','
- '- (''qgep_od'', ''stat_wws'', ''fk_dataowner'', None, ''YES'', ''character varying'',
  ''16'
- '- (''qgep_od'', ''stat_wws'', ''fk_operator'', None, ''YES'', ''character varying'',
  ''16'''
- '- (''qgep_od'', ''stat_wws'', ''fk_owner'', None, ''YES'', ''character varying'',
  ''16'', N'
- '- (''qgep_od'', ''stat_wws'', ''fk_provider'', None, ''YES'', ''character varying'',
  ''16'''
- '- (''qgep_od'', ''stat_wws'', ''function'', None, ''YES'', ''integer'', None, ''32'',
  ''2'', '
- '- (''qgep_od'', ''stat_wws'', ''gross_costs'', None, ''YES'', ''numeric'', None,
  ''10'', ''1'
- '- (''qgep_od'', ''stat_wws'', ''identifier'', None, ''YES'', ''character varying'',
  ''20'','
- '- (''qgep_od'', ''stat_wws'', ''ii_absorption_capacity'', None, ''YES'', ''numeric'',
  Non'
- '- (''qgep_od'', ''stat_wws'', ''ii_defects'', None, ''YES'', ''integer'', None,
  ''32'', ''2'''
- '- (''qgep_od'', ''stat_wws'', ''ii_dimension1'', None, ''YES'', ''smallint'', None,
  ''16'','
- '- (''qgep_od'', ''stat_wws'', ''ii_dimension2'', None, ''YES'', ''smallint'', None,
  ''16'','
- '- (''qgep_od'', ''stat_wws'', ''ii_distance_to_aquifer'', None, ''YES'', ''numeric'',
  Non'
- '- (''qgep_od'', ''stat_wws'', ''ii_effective_area'', None, ''YES'', ''numeric'',
  None, ''8'
- '- (''qgep_od'', ''stat_wws'', ''ii_emergency_spillway'', None, ''YES'', ''integer'',
  None'
- '- (''qgep_od'', ''stat_wws'', ''ii_fk_aquifier'', None, ''YES'', ''character varying'',
  '''
- '- (''qgep_od'', ''stat_wws'', ''ii_kind'', None, ''YES'', ''integer'', None, ''32'',
  ''2'', N'
- '- (''qgep_od'', ''stat_wws'', ''ii_labeling'', None, ''YES'', ''integer'', None,
  ''32'', ''2'
- '- (''qgep_od'', ''stat_wws'', ''ii_seepage_utilization'', None, ''YES'', ''integer'',
  Non'
- '- (''qgep_od'', ''stat_wws'', ''ii_upper_elevation'', None, ''YES'', ''numeric'',
  None, '''
- '- (''qgep_od'', ''stat_wws'', ''ii_vehicle_access'', None, ''YES'', ''integer'',
  None, ''3'
- '- (''qgep_od'', ''stat_wws'', ''ii_watertightness'', None, ''YES'', ''integer'',
  None, ''3'
- '- (''qgep_od'', ''stat_wws'', ''inspection_interval'', None, ''YES'', ''numeric'',
  None, '
- '- (''qgep_od'', ''stat_wws'', ''_label'', None, ''YES'', ''text'', None, None,
  None, None'
- '- (''qgep_od'', ''stat_wws'', ''last_modification'', None, ''YES'', ''timestamp
  without '
- '- (''qgep_od'', ''stat_wws'', ''location_name'', None, ''YES'', ''character varying'',
  ''5'
- '- (''qgep_od'', ''stat_wws'', ''ma_dimension1'', None, ''YES'', ''smallint'', None,
  ''16'','
- '- (''qgep_od'', ''stat_wws'', ''ma_dimension2'', None, ''YES'', ''smallint'', None,
  ''16'','
- '- (''qgep_od'', ''stat_wws'', ''ma_material'', None, ''YES'', ''integer'', None,
  ''32'', ''2'
- '- (''qgep_od'', ''stat_wws'', ''ma_orientation'', None, ''YES'', ''numeric'', None,
  None,'
- '- (''qgep_od'', ''stat_wws'', ''ma_surface_inflow'', None, ''YES'', ''integer'',
  None, ''3'
- '- (''qgep_od'', ''stat_wws'', ''obj_id'', None, ''YES'', ''character varying'',
  ''16'', Non'
- '- (''qgep_od'', ''stat_wws'', ''records'', None, ''YES'', ''character varying'',
  ''255'', N'
- '- (''qgep_od'', ''stat_wws'', ''remark'', None, ''YES'', ''character varying'',
  ''80'', Non'
- '- (''qgep_od'', ''stat_wws'', ''renovation_necessity'', None, ''YES'', ''integer'',
  None,'
- '- (''qgep_od'', ''stat_wws'', ''replacement_value'', None, ''YES'', ''numeric'',
  None, ''1'
- '- (''qgep_od'', ''stat_wws'', ''rv_base_year'', None, ''YES'', ''smallint'', None,
  ''16'', '
- '- (''qgep_od'', ''stat_wws'', ''rv_construction_type'', None, ''YES'', ''integer'',
  None,'
- '- (''qgep_od'', ''stat_wws'', ''situation_geometry'', None, ''YES'', ''USER-DEFINED'',
  No'
- '- (''qgep_od'', ''stat_wws'', ''ss_bypass'', None, ''YES'', ''integer'', None,
  ''32'', ''2'','
- '- (''qgep_od'', ''stat_wws'', ''ss_emergency_spillway'', None, ''YES'', ''integer'',
  None'
- '- (''qgep_od'', ''stat_wws'', ''ss_function'', None, ''YES'', ''integer'', None,
  ''32'', ''2'
- '- (''qgep_od'', ''stat_wws'', ''ss_stormwater_tank_arrangement'', None, ''YES'',
  ''integ'
- '- (''qgep_od'', ''stat_wws'', ''ss_upper_elevation'', None, ''YES'', ''numeric'',
  None, '''
- '- (''qgep_od'', ''stat_wws'', ''status'', None, ''YES'', ''integer'', None, ''32'',
  ''2'', No'
- '- (''qgep_od'', ''stat_wws'', ''structure_condition'', None, ''YES'', ''integer'',
  None, '
- '- (''qgep_od'', ''stat_wws'', ''subsidies'', None, ''YES'', ''numeric'', None,
  ''10'', ''10'''
- '- (''qgep_od'', ''stat_wws'', ''wn_backflow_level'', None, ''YES'', ''numeric'',
  None, ''7'
- '- (''qgep_od'', ''stat_wws'', ''wn_bottom_level'', None, ''YES'', ''numeric'',
  None, ''7'','
- '- (''qgep_od'', ''stat_wws'', ''wn_fk_dataowner'', None, ''YES'', ''character varying'', '
- '- (''qgep_od'', ''stat_wws'', ''wn_fk_hydr_geometry'', None, ''YES'', ''character
  varyin'
- '- (''qgep_od'', ''stat_wws'', ''wn_fk_provider'', None, ''YES'', ''character varying'',
  '''
- '- (''qgep_od'', ''stat_wws'', ''wn_identifier'', None, ''YES'', ''character varying'',
  ''2'
- '- (''qgep_od'', ''stat_wws'', ''wn_last_modification'', None, ''YES'', ''timestamp
  witho'
- '- (''qgep_od'', ''stat_wws'', ''wn_obj_id'', None, ''YES'', ''character varying'',
  ''16'', '
- '- (''qgep_od'', ''stat_wws'', ''wn_remark'', None, ''YES'', ''character varying'',
  ''80'', '
- '- (''qgep_od'', ''stat_wws'', ''ws_type'', None, ''YES'', ''text'', None, None,
  None, Non'
- '- (''qgep_od'', ''stat_wws'', ''year_of_construction'', None, ''YES'', ''smallint'',
  None'
- '- (''qgep_od'', ''stat_wws'', ''year_of_replacement'', None, ''YES'', ''smallint'',
  None,'
- '- (''qgep_od'', ''stat_wws_man_fun'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'', '''
- '- (''qgep_od'', ''stat_wws_man_fun'', ''ma_function'', None, ''YES'', ''integer'',
  None, '
- '- (''qgep_od'', ''stat_wws_man_fun'', ''man_fun_de'', None, ''YES'', ''character
  varying'
- '- (''qgep_od'', ''stat_wws_owner'', ''count'', None, ''YES'', ''bigint'', None,
  ''64'', ''2'''
- '- (''qgep_od'', ''stat_wws_owner'', ''fk_owner'', None, ''YES'', ''character varying'',
  '''
- '- (''qgep_od'', ''stat_wws_owner'', ''owner_sta'', None, ''YES'', ''character varying'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_bedding_encasement'', None, ''YES'',
  ''integ'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_connection_type'', None, ''YES'', ''integer'''
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_function_hierarchic'', None, ''YES'',
  ''inte'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_function_hydraulic'', None, ''YES'',
  ''integ'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_jetting_interval'', None, ''YES'',
  ''numeric'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_pipe_length'', None, ''YES'', ''numeric'',
  No'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_usage_current'', None, ''YES'', ''integer'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ch_usage_planned'', None, ''YES'', ''integer'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''clear_height'', None, ''YES'', ''integer'',
  None'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''coefficient_of_friction'', None, ''YES'',
  ''sma'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''elevation_determination'', None, ''YES'',
  ''int'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''fk_dataowner'', None, ''YES'', ''character
  vary'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''fk_pipe_profile'', None, ''YES'', ''character
  v'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''fk_provider'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''fk_wastewater_structure'', None, ''YES'',
  ''cha'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''horizontal_positioning'', None, ''YES'',
  ''inte'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''identifier'', None, ''YES'', ''character
  varyin'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''inside_coating'', None, ''YES'', ''integer'',
  No'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''last_modification'', None, ''YES'', ''timestamp'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''length_effective'', None, ''YES'', ''numeric'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''material'', None, ''YES'', ''integer'',
  None, ''3'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''obj_id'', None, ''YES'', ''character varying'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''progression_geometry'', None, ''YES'',
  ''USER-D'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''reliner_material'', None, ''YES'', ''integer'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''reliner_nominal_size'', None, ''YES'',
  ''intege'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''relining_construction'', None, ''YES'',
  ''integ'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''relining_kind'', None, ''YES'', ''integer'',
  Non'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''remark'', None, ''YES'', ''character varying'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ring_stiffness'', None, ''YES'', ''smallint'',
  N'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_elevation_accuracy'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_fk_dataowner'', None, ''YES'',
  ''charac'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_fk_provider'', None, ''YES'',
  ''charact'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_fk_wastewater_networkelement'',
  None'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_identifier'', None, ''YES'', ''characte'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_last_modification'', None, ''YES'',
  ''t'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_level'', None, ''YES'', ''numeric'',
  Non'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_obj_id'', None, ''YES'', ''character
  va'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_outlet_shape'', None, ''YES'',
  ''intege'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_position_of_connection'', None,
  ''YES'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_from_remark'', None, ''YES'', ''character
  va'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_elevation_accuracy'', None, ''YES'',
  ''in'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_fk_dataowner'', None, ''YES'', ''characte'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_fk_provider'', None, ''YES'', ''character'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_fk_wastewater_networkelement'',
  None, '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_identifier'', None, ''YES'', ''character '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_last_modification'', None, ''YES'',
  ''tim'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_level'', None, ''YES'', ''numeric'',
  None,'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_obj_id'', None, ''YES'', ''character
  vary'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_outlet_shape'', None, ''YES'', ''integer'''
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_position_of_connection'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''rp_to_remark'', None, ''YES'', ''character
  vary'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''slope_building_plan'', None, ''YES'',
  ''smallin'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''_slope_per_mill'', None, ''YES'', ''numeric'',
  N'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''wall_roughness'', None, ''YES'', ''numeric'',
  No'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''width'', None, ''YES'', ''integer'', None,
  ''32'','
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_accessibility'', None, ''YES'', ''integer'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_contract_section'', None, ''YES'',
  ''charact'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_financing'', None, ''YES'', ''integer'',
  None'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_fk_operator'', None, ''YES'', ''character
  va'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_fk_owner'', None, ''YES'', ''character
  varyi'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_gross_costs'', None, ''YES'', ''numeric'',
  No'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_identifier'', None, ''YES'', ''character
  var'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_inspection_interval'', None, ''YES'',
  ''nume'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_last_modification'', None, ''YES'',
  ''timest'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_location_name'', None, ''YES'', ''character '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_obj_id'', None, ''YES'', ''character
  varying'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_records'', None, ''YES'', ''character
  varyin'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_remark'', None, ''YES'', ''character
  varying'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_renovation_necessity'', None, ''YES'',
  ''int'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_replacement_value'', None, ''YES'',
  ''numeri'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_rv_base_year'', None, ''YES'', ''smallint'', '
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_rv_construction_type'', None, ''YES'',
  ''int'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_status'', None, ''YES'', ''integer'',
  None, '''
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_structure_condition'', None, ''YES'',
  ''inte'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_subsidies'', None, ''YES'', ''numeric'',
  None'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_year_of_construction'', None, ''YES'',
  ''sma'
- '- (''qgep_od'', ''vw_qgep_reach_avm'', ''ws_year_of_replacement'', None, ''YES'',
  ''smal'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure'', ''co_obj_id'', None, ''YES'',
  ''charac'
- + ('qgep_od', 'vw_qgep_wastewater_structure', 'co_obj_id', "qgep_sys.generate_o
- '- (''qgep_od'', ''vw_qgep_wastewater_structure'', ''obj_id'', None, ''YES'', ''character'
- + ('qgep_od', 'vw_qgep_wastewater_structure', 'obj_id', "qgep_sys.generate_oid(
- '- (''qgep_od'', ''vw_qgep_wastewater_structure'', ''wn_fk_wastewater_structure'',
  Non'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''accessibility'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''_channel_function_hierarchic'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''_channel_usage_current'',
  Non'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_brand'', None, ''YES'',
  ''cha'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_diameter'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_fastening'', None, ''YES'', '
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_identifier'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_level'', None, ''YES'',
  ''num'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_material'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''contract_section'', None,
  ''YE'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_obj_id'', "qgep_sys.genera'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_positional_accuracy'',
  Non'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_remark'', None, ''YES'',
  ''ch'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_renovation_demand'',
  None,'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_shape'', None, ''YES'',
  ''int'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_sludge_bucket'', None,
  ''YE'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''co_venting'', None, ''YES'',
  ''i'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''_depth'', None, ''YES'',
  ''numer'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''dp_fk_sector_water_body'',
  No'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''dp_highwater_level'', None,
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''dp_relevance'', None, ''YES'', '
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''dp_terrain_level'', None,
  ''YE'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''dp_upper_elevation'', None,
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''dp_waterlevel_hydraulic'',
  No'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''financing'', None, ''YES'',
  ''in'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''fk_dataowner'', None, ''YES'', '
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''fk_operator'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''fk_owner'', None, ''YES'',
  ''cha'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''fk_provider'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''gross_costs'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''identifier'', None, ''YES'',
  ''c'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_absorption_capacity'',
  Non'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_defects'', None, ''YES'',
  ''i'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_dimension1'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_dimension2'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_distance_to_aquifer'',
  Non'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_effective_area'', None,
  ''Y'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_emergency_spillway'',
  None'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_fk_aquifier'', None,
  ''YES'''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_kind'', None, ''YES'',
  ''inte'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_labeling'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_seepage_utilization'',
  Non'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_upper_elevation'', None,
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_vehicle_access'', None,
  ''Y'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ii_watertightness'', None,
  ''Y'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''inspection_interval'',
  None, '
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''_label'', None, ''YES'',
  ''text'''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''last_modification'', None,
  ''Y'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''location_name'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ma_dimension1'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ma_dimension2'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ma_function'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ma_material'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ma_orientation'', None,
  ''YES'''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ma_surface_inflow'', None,
  ''Y'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''obj_id'', "qgep_sys.generate_'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''records'', None, ''YES'',
  ''char'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''remark'', None, ''YES'',
  ''chara'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''renovation_necessity'',
  None,'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''replacement_value'', None,
  ''Y'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''rv_base_year'', None, ''YES'', '
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''rv_construction_type'',
  None,'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''situation_geometry'', None,
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ss_bypass'', None, ''YES'',
  ''in'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ss_emergency_spillway'',
  None'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ss_function'', None, ''YES'',
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ss_stormwater_tank_arrangeme'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ss_upper_elevation'', None,
  '''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''status'', None, ''YES'',
  ''integ'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''structure_condition'',
  None, '
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''subsidies'', None, ''YES'',
  ''nu'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_backflow_level'', None,
  ''Y'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_bottom_level'', None,
  ''YES'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_fk_dataowner'', None,
  ''YES'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_fk_hydr_geometry'',
  None, '
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_fk_provider'', None,
  ''YES'''
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_identifier'', None,
  ''YES'','
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_last_modification'',
  None,'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_obj_id'', None, ''YES'',
  ''ch'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''wn_remark'', None, ''YES'',
  ''ch'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''ws_type'', None, ''YES'',
  ''text'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''year_of_construction'',
  None,'
- '- (''qgep_od'', ''vw_qgep_wastewater_structure_avm'', ''year_of_replacement'',
  None, '
- '- (''qgep_od'', ''wastewater_node'', ''situation_geometry'', None, ''NO'', ''USER-DEFINE'
- + ('qgep_od', 'wastewater_node', 'situation_geometry', None, 'YES', 'USER-DEFIN
- '- (''qgep_od'', ''wastewater_node'', ''situation_geometry_point'', None, ''YES'',
  ''USER'
- '- (''qgep_od'', ''wastewater_node'', ''situation_geometry_pointz'', None, ''YES'',
  ''USE'
- '- (''qgep_od'', ''wastewater_structure'', ''fk_main_wastewater_node'', None, ''YES'',
  '''
constraints:
- '- (''zone_a_2016_pkey'', ''arbon_kan.zone_a_2016.ogc_fid'', ''arbon_kan'', ''zone_a_20'
- '- (''zone_b_2017_pkey'', ''arbon_kan.zone_b_2017.ogc_fid'', ''arbon_kan'', ''zone_b_20'
- '- (''zone_c_2018_pkey'', ''arbon_kan.zone_c_2018.ogc_fid'', ''arbon_kan'', ''zone_c_20'
- '- (''zone_d_2019_pkey'', ''arbon_kan.zone_d_2019.ogc_fid'', ''arbon_kan'', ''zone_d_20'
- '- (''ableitung_hofen_pkey'', ''fischer.ableitung_hofen.fid'', ''fischer'', ''ableitung'
- '- (''arbon_tp37_versickerung_pkey'', ''fischer.arbon_tp37_versickerung.fi_fid'',
  ''f'
- '- (''arbon_tp4_fliesszeit_pkey'', ''fischer.arbon_tp4_fliesszeit.fi_fid'', ''fischer'
- '- (''fi_tp4_gefahren_pkey'', ''fischer.arbon_tp4_gefahren.fi_fid'', ''fischer'',
  ''arb'
- '- (''t_pkey'', ''fischer.arbon_zonen_unterhalt.fid'', ''fischer'', ''arbon_zonen_unter'
- '- (''atlas_500_arbon_pkey'', ''fischer.atlas_500_arbon.fid'', ''fischer'', ''atlas_500'
- '- (''avm_sobau_pkey'', ''fischer.avm_sobau.fid'', ''fischer'', ''avm_sobau'', ''fid'',
  ''a'
- '- (''avm_tp32_problemstelle_pkey'', ''fischer.avm_tp32_problemstelle.fi_fid'',
  ''fis'
- '- (''avm_tp7_massnahme_pkey'', ''fischer.avm_tp7_massnahme.fi_fid'', ''fischer'',
  ''av'
- '- (''avm_pkey'', ''fischer.avm_zonen_unterhalt.fid'', ''fischer'', ''avm_zonen_unterha'
- '- (''beschriftung_pkt_pkey'', ''fischer.beschriftung_pkt.fid'', ''fischer'', ''beschri'
- '- (''entwaesserungsgraben_pkey'', ''fischer.entwaesserungsgraben.gid'', ''fischer'', '
- '- (''fi_a2000_pkey'', ''fischer.fi_a2000.gid'', ''fischer'', ''fi_a2000'', ''gid'',
  ''fi_a'
- '- (''fi_avm_500_pkey'', ''fischer.fi_avm_500.fid'', ''fischer'', ''fi_avm_500'',
  ''fid'','
- '- (''fi_dp_oeko_pkey'', ''fischer.fi_dp_oeko.gid'', ''fischer'', ''fi_dp_oeko'',
  ''gid'','
- '- (''fi_ezg_pkey'', ''fischer.fi_ezg_basis.gidd'', ''fischer'', ''fi_ezg_basis'',
  ''gidd'
- '- (''fi_ezg_rb_pkey'', ''fischer.fi_ezg_rb.fid'', ''fischer'', ''fi_ezg_rb'', ''fid'',
  ''f'
- '- (''fi_ezg_ru_pkey'', ''fischer.fi_ezg_ru.fid'', ''fischer'', ''fi_ezg_ru'', ''fid'',
  ''f'
- '- (''fi_ezg_system_current_pkey'', ''fischer.fi_ezg_system_current.fid'', ''fischer'''
- '- (''fi_grenze_arbon_pkey'', ''fischer.fi_grenze_arbon.fid'', ''fischer'', ''fi_grenze'
- '- (''fi_kan_gem_pkey'', ''fischer.fi_kan_gem.fid'', ''fischer'', ''fi_kan_gem'',
  ''fid'','
- '- (''fi_rect_pkey'', ''fischer.fi_rect.fi_fid'', ''fischer'', ''fi_rect'', ''fi_fid'',
  ''f'
- '- (''fliessgewaesser_pkey'', ''fischer.fliessgewaesser.gid'', ''fischer'', ''fliessgew'
- '- (''fliessgewaesser_name_pkey'', ''fischer.fliessgewaesser_name.gid'', ''fischer'', '
- '- (''fliessgewaesser_schacht_pkey'', ''fischer.fliessgewaesser_schacht.gid'', ''fisc'
- '- (''fz_e5_pkey'', ''fischer.fz_e5.fid'', ''fischer'', ''fz_e5'', ''fid'', ''fz_e5'',
  ''fid'''
- '- (''fz_twa_pkey'', ''fischer.fz_twa.fid'', ''fischer'', ''fz_twa'', ''fid'', ''fz_twa'',
  '''
- '- (''gewaesserabschnitt_pkey'', ''fischer.gewaesserabschnitt.gid'', ''fischer'',
  ''gew'
- '- (''gewaessereinzugsgebiet_pkey'', ''fischer.gewaessereinzugsgebiet.gid'', ''fische'
- '- (''gewaessermetrierung_pkey'', ''fischer.gewaessermetrierung.gid'', ''fischer'',
  ''g'
- '- (''gewaessersystem_pkey'', ''fischer.gewaessersystem.gid'', ''fischer'', ''gewaesser'
- '- (''gewaesserverlauf_pkey'', ''fischer.gewaesserverlauf.gid'', ''fischer'', ''gewaess'
- '- (''stehendes_gewaesser_pkey'', ''fischer.stehendes_gewaesser.gid'', ''fischer'',
  ''s'
- '- (''abwasserknoten_pkey'', ''import_sbu.abwasserknoten.fid'', ''import_sbu'',
  ''abwas'
- '- (''bankett_pkey'', ''import_sbu.bankett.fid'', ''import_sbu'', ''bankett'', ''fid'',
  ''b'
- '- (''deckel_pkey'', ''import_sbu.deckel.fid'', ''import_sbu'', ''deckel'', ''fid'',
  ''deck'
- '- (''einleitstelle_pkey'', ''import_sbu.einleitstelle.fid'', ''import_sbu'', ''einleit'
- '- (''einstiegshilfe_pkey'', ''import_sbu.einstiegshilfe.fid'', ''import_sbu'',
  ''einst'
- '- (''haltung_pkey'', ''import_sbu.haltung.fid'', ''import_sbu'', ''haltung'', ''fid'',
  ''h'
- '- (''haltungspunkt_pkey'', ''import_sbu.haltungspunkt.fid'', ''import_sbu'', ''haltung'
- '- (''kanal_pkey'', ''import_sbu.kanal.fid'', ''import_sbu'', ''kanal'', ''fid'',
  ''kanal'','
- '- (''normschacht_pkey'', ''import_sbu.normschacht.fid'', ''import_sbu'', ''normschacht'
- '- (''privat_pkey'', ''import_sbu.privat.fid'', ''import_sbu'', ''privat'', ''fid'',
  ''priv'
- '- (''rohrprofil_pkey'', ''import_sbu.rohrprofil.fid'', ''import_sbu'', ''rohrprofil'', '
- '- (''spezialbauwerk_pkey'', ''import_sbu.spezialbauwerk.fid'', ''import_sbu'',
  ''spezi'
- '- (''stat_reach_clear_r_pkey'', ''qgep_od.stat_reach_clear_r.length_fid'', ''qgep_od'
- '- (''stat_reach_length_pkey'', ''qgep_od.stat_reach_length.length_fid'', ''qgep_od'','
- '- (''rel_wastewater_structure_main_wastewater_node'', ''qgep_od.wastewater_structu'
functions:
- '- (''update_wastewater_structure_label'', ''boolean'', "  DECLARE\n  myrec record;\'
- + ('update_wastewater_structure_label', 'boolean', "\n  DECLARE\n  myrec record
- '- (''update_wastewater_structure_label'', ''text'', "  DECLARE\n  myrec record;\n\n'
- + ('update_wastewater_structure_label', 'text', "\n  DECLARE\n  myrec record;\n
indexes:
- '- (''ableitung_hofen'', ''ableitung_hofen_geom_geom_idx'', ''geom'')'
- '- (''ableitung_hofen'', ''ableitung_hofen_pkey'', ''fid'')'
- '- (''abwasserknoten'', ''abwasserknoten_geom_geom_idx'', ''geom'')'
- '- (''abwasserknoten'', ''abwasserknoten_pkey'', ''fid'')'
- '- (''arbon_tp37_versickerung'', ''arbon_tp37_versickerung_pkey'', ''fi_fid'')'
- '- (''arbon_tp4_fliesszeit'', ''arbon_tp4_fliesszeit_pkey'', ''fi_fid'')'
- '- (''arbon_tp4_gefahren'', ''fi_tp4_gefahren_pkey'', ''fi_fid'')'
- '- (''arbon_zonen_unterhalt'', ''t_geom_geom_idx'', ''geom'')'
- '- (''arbon_zonen_unterhalt'', ''t_pkey'', ''fid'')'
- '- (''atlas_500_arbon'', ''atlas_500_arbon_geom_geom_idx'', ''geom'')'
- '- (''atlas_500_arbon'', ''atlas_500_arbon_pkey'', ''fid'')'
- '- (''avm_sobau'', ''avm_sobau_geom_geom_idx'', ''geom'')'
- '- (''avm_sobau'', ''avm_sobau_pkey'', ''fid'')'
- '- (''avm_tp32_problemstelle'', ''avm_tp32_problemstelle_pkey'', ''fi_fid'')'
- '- (''avm_tp7_massnahme'', ''avm_tp7_massnahme_pkey'', ''fi_fid'')'
- '- (''avm_zonen_unterhalt'', ''avm_geom_geom_idx'', ''geom'')'
- '- (''avm_zonen_unterhalt'', ''avm_pkey'', ''fid'')'
- '- (''bankett'', ''bankett_pkey'', ''fid'')'
- '- (''beschriftung_pkt'', ''beschriftung_pkt_geom_geom_idx'', ''geom'')'
- '- (''beschriftung_pkt'', ''beschriftung_pkt_pkey'', ''fid'')'
- '- (''deckel'', ''deckel_geom_geom_idx'', ''geom'')'
- '- (''deckel'', ''deckel_pkey'', ''fid'')'
- '- (''einleitstelle'', ''einleitstelle_geom_geom_idx'', ''geom'')'
- '- (''einleitstelle'', ''einleitstelle_pkey'', ''fid'')'
- '- (''einstiegshilfe'', ''einstiegshilfe_pkey'', ''fid'')'
- '- (''entwaesserungsgraben'', ''entwaesserungsgraben_pkey'', ''gid'')'
- '- (''fi_a2000'', ''fi_a2000_pkey'', ''gid'')'
- '- (''fi_avm_500'', ''fi_avm_500_geom_geom_idx'', ''geom'')'
- '- (''fi_avm_500'', ''fi_avm_500_pkey'', ''fid'')'
- '- (''fi_dp_oeko'', ''fi_dp_oeko_pkey'', ''gid'')'
- '- (''fi_ezg_basis'', ''fi_ezg_basis_geom_geom_idx'', ''geom'')'
- '- (''fi_ezg_basis'', ''fi_ezg_pkey'', ''gidd'')'
- '- (''fi_ezg_rb'', ''fi_ezg_rb_geom_geom_idx'', ''geom'')'
- '- (''fi_ezg_rb'', ''fi_ezg_rb_pkey'', ''fid'')'
- '- (''fi_ezg_ru'', ''fi_ezg_ru_geom_geom_idx'', ''geom'')'
- '- (''fi_ezg_ru'', ''fi_ezg_ru_pkey'', ''fid'')'
- '- (''fi_ezg_system_current'', ''fi_ezg_system_current_geom_geom_idx'', ''geom'')'
- '- (''fi_ezg_system_current'', ''fi_ezg_system_current_pkey'', ''fid'')'
- '- (''fi_grenze_arbon'', ''fi_grenze_arbon_geom_geom_idx'', ''geom'')'
- '- (''fi_grenze_arbon'', ''fi_grenze_arbon_pkey'', ''fid'')'
- '- (''fi_kan_gem'', ''fi_kan_gem_geom_geom_idx'', ''geom'')'
- '- (''fi_kan_gem'', ''fi_kan_gem_pkey'', ''fid'')'
- '- (''fi_rect'', ''fi_rect_pkey'', ''fi_fid'')'
- '- (''fliessgewaesser'', ''fliessgewaesser_pkey'', ''gid'')'
- '- (''fliessgewaesser_name'', ''fliessgewaesser_name_pkey'', ''gid'')'
- '- (''fliessgewaesser_schacht'', ''fliessgewaesser_schacht_pkey'', ''gid'')'
- '- (''fz_e5'', ''fz_e5_pkey'', ''fid'')'
- '- (''fz_twa'', ''fz_twa_pkey'', ''fid'')'
- '- (''gewaesserabschnitt'', ''gewaesserabschnitt_pkey'', ''gid'')'
- '- (''gewaessereinzugsgebiet'', ''gewaessereinzugsgebiet_pkey'', ''gid'')'
- '- (''gewaessermetrierung'', ''gewaessermetrierung_pkey'', ''gid'')'
- '- (''gewaessersystem'', ''gewaessersystem_pkey'', ''gid'')'
- '- (''gewaesserverlauf'', ''gewaesserverlauf_pkey'', ''gid'')'
- '- (''haltung'', ''haltung_geom_geom_idx'', ''geom'')'
- '- (''haltung'', ''haltung_pkey'', ''fid'')'
- '- (''haltungspunkt'', ''haltungspunkt_geom_geom_idx'', ''geom'')'
- '- (''haltungspunkt'', ''haltungspunkt_pkey'', ''fid'')'
- '- (''kanal'', ''kanal_pkey'', ''fid'')'
- '- (''normschacht'', ''normschacht_pkey'', ''fid'')'
- '- (''privat'', ''privat_pkey'', ''fid'')'
- '- (''rohrprofil'', ''rohrprofil_pkey'', ''fid'')'
- '- (''spezialbauwerk'', ''spezialbauwerk_geom_geom_idx'', ''geom'')'
- '- (''spezialbauwerk'', ''spezialbauwerk_pkey'', ''fid'')'
- '- (''stat_reach_clear_r'', ''stat_reach_clear_r_pkey'', ''length_fid'')'
- '- (''stat_reach_length'', ''stat_reach_length_pkey'', ''length_fid'')'
- '- (''stehendes_gewaesser'', ''stehendes_gewaesser_pkey'', ''gid'')'
- '- (''zone_a_2016'', ''zone_a_2016_pkey'', ''ogc_fid'')'
- '- (''zone_b_2017'', ''zone_b_2017_pkey'', ''ogc_fid'')'
- '- (''zone_c_2018'', ''zone_c_2018_pkey'', ''ogc_fid'')'
- '- (''zone_d_2019'', ''zone_d_2019_pkey'', ''ogc_fid'')'
rules:
- + ('qgep_od', 'reach', 'DELETE')
sequences:
- '- (''arbon_tp4_gefahren_fi_fid_seq'',)'
- '- (''fi_dp_oeko_gid_seq'',)'
tables:
- '- (''qgep_od'', ''cover_190910'')'
- '- (''qgep_od'', ''fi_statistic'')'
- '- (''qgep_od'', ''stat_reach'')'
- '- (''qgep_od'', ''stat_reach_clear_h'')'
- '- (''qgep_od'', ''stat_reach_clear_r'')'
- '- (''qgep_od'', ''stat_reach_fun_hie'')'
- '- (''qgep_od'', ''stat_reach_fun_hyd'')'
- '- (''qgep_od'', ''stat_reach_length'')'
- '- (''qgep_od'', ''stat_reach_material'')'
- '- (''qgep_od'', ''stat_reach_owner'')'
- '- (''qgep_od'', ''stat_reach_status'')'
- '- (''qgep_od'', ''stat_reach_use_cur'')'
- '- (''qgep_od'', ''stat_reach_year_o_c'')'
- '- (''qgep_od'', ''stat_wws'')'
- '- (''qgep_od'', ''stat_wws_man_fun'')'
- '- (''qgep_od'', ''stat_wws_owner'')'
triggers:
- '- ("\nDECLARE\n  channel_id text;\n  reach_count integer;\nBEGIN\n  -- get chan'
- '- (''RI_FKey_cascade_upd'', ''wastewater_node'')'
- '- (''RI_FKey_setnull_del'', ''wastewater_node'')'
- '- (''RI_FKey_check_ins'', ''wastewater_structure'')'
- '- (''RI_FKey_check_upd'', ''wastewater_structure'')'
views:
- '- (''vw_manhole'', '' SELECT DISTINCT ON (ws.obj_id) ws.obj_id,\n    ws.identifier'
- + ('vw_manhole', ' SELECT DISTINCT ON (ws.obj_id) ws.obj_id,\n    ws.identifier
- '- (''vw_qgep_reach_avm'', " SELECT vw_qgep_reach.obj_id,\n    vw_qgep_reach.clear'
- '- (''vw_qgep_wastewater_structure'', " SELECT ws.identifier,\n        CASE\n     '
- '- (''vw_qgep_wastewater_structure_avm'', " SELECT ws.identifier,\n        CASE\n '
- '+ (''vw_qgep_wastewater_structure'', " SELECT ws.identifier,\n        CASE\n     '

After (colorized as diff): 

Check...
DIFFERENCES FOUND
tables
- ('qgep_od', 'cover_190910')
- ('qgep_od', 'fi_statistic')
- ('qgep_od', 'stat_reach')
- ('qgep_od', 'stat_reach_clear_h')
- ('qgep_od', 'stat_reach_clear_r')
- ('qgep_od', 'stat_reach_fun_hie')
- ('qgep_od', 'stat_reach_fun_hyd')
- ('qgep_od', 'stat_reach_length')
- ('qgep_od', 'stat_reach_material')
- ('qgep_od', 'stat_reach_owner')
- ('qgep_od', 'stat_reach_status')
- ('qgep_od', 'stat_reach_use_cur')
- ('qgep_od', 'stat_reach_year_o_c')
- ('qgep_od', 'stat_wws')
- ('qgep_od', 'stat_wws_man_fun')
- ('qgep_od', 'stat_wws_owner')
columns
- ('qgep_od', 'catchment_area', 'surface_area', None, 'YES', 'numeric', None, '
+ ('qgep_od', 'catchment_area', 'surface_area', None, 'YES', 'numeric', None, '
- ('qgep_od', 'cover', 'situation_geometry', None, 'NO', 'USER-DEFINED', None, 
+ ('qgep_od', 'cover', 'situation_geometry', None, 'YES', 'USER-DEFINED', None,
- ('qgep_od', 'cover_190910', 'brand', None, 'YES', 'character varying', '50', 
- ('qgep_od', 'cover_190910', 'cover_shape', None, 'YES', 'integer', None, '32'
- ('qgep_od', 'cover_190910', 'diameter', None, 'YES', 'smallint', None, '16', 
- ('qgep_od', 'cover_190910', 'fastening', None, 'YES', 'integer', None, '32', 
- ('qgep_od', 'cover_190910', 'level', None, 'YES', 'numeric', None, '7', '10',
- ('qgep_od', 'cover_190910', 'material', None, 'YES', 'integer', None, '32', '
- ('qgep_od', 'cover_190910', 'obj_id', None, 'YES', 'character varying', '16',
- ('qgep_od', 'cover_190910', 'positional_accuracy', None, 'YES', 'integer', No
- ('qgep_od', 'cover_190910', 'situation_geometry', None, 'YES', 'USER-DEFINED'
- ('qgep_od', 'cover_190910', 'sludge_bucket', None, 'YES', 'integer', None, '3
- ('qgep_od', 'cover_190910', 'venting', None, 'YES', 'integer', None, '32', '2
- ('qgep_od', 'fi_statistic', 'fi_ct_element', None, 'YES', 'bigint', None, '64
- ('qgep_od', 'fi_statistic', 'fi_table', None, 'YES', 'character varying', '50
- ('qgep_od', 'reach', 'progression_geometry', None, 'NO', 'USER-DEFINED', None
+ ('qgep_od', 'reach', 'progression_geometry', None, 'YES', 'USER-DEFINED', Non
- ('qgep_od', 'reach_point', 'situation_geometry', None, 'NO', 'USER-DEFINED', 
+ ('qgep_od', 'reach_point', 'situation_geometry', None, 'YES', 'USER-DEFINED',
- ('qgep_od', 'stat_reach', 'ch_bedding_encasement', None, 'YES', 'integer', No
- ('qgep_od', 'stat_reach', 'ch_connection_type', None, 'YES', 'integer', None,
- ('qgep_od', 'stat_reach', 'ch_jetting_interval', None, 'YES', 'numeric', None
- ('qgep_od', 'stat_reach', 'ch_pipe_length', None, 'YES', 'numeric', None, '7'
- ('qgep_od', 'stat_reach', 'ch_usage_planned', None, 'YES', 'integer', None, '
- ('qgep_od', 'stat_reach', 'clear_height', None, 'YES', 'integer', None, '32',
- ('qgep_od', 'stat_reach', 'coefficient_of_friction', None, 'YES', 'smallint',
- ('qgep_od', 'stat_reach', 'elevation_determination', None, 'YES', 'integer', 
- ('qgep_od', 'stat_reach', 'fk_dataowner', None, 'YES', 'character varying', '
- ('qgep_od', 'stat_reach', 'fk_pipe_profile', None, 'YES', 'character varying'
- ('qgep_od', 'stat_reach', 'fk_provider', None, 'YES', 'character varying', '1
- ('qgep_od', 'stat_reach', 'fk_wastewater_structure', None, 'YES', 'character 
- ('qgep_od', 'stat_reach', 'function_hierarchic', None, 'YES', 'integer', None
- ('qgep_od', 'stat_reach', 'function_hydraulic', None, 'YES', 'integer', None,
- ('qgep_od', 'stat_reach', 'horizontal_positioning', None, 'YES', 'integer', N
- ('qgep_od', 'stat_reach', 'identifier', None, 'YES', 'character varying', '20
- ('qgep_od', 'stat_reach', 'inside_coating', None, 'YES', 'integer', None, '32
- ('qgep_od', 'stat_reach', 'last_modification', None, 'YES', 'timestamp withou
- ('qgep_od', 'stat_reach', 'length_effective', None, 'YES', 'numeric', None, '
- ('qgep_od', 'stat_reach', 'material', None, 'YES', 'integer', None, '32', '2'
- ('qgep_od', 'stat_reach', 'obj_id', None, 'YES', 'character varying', '16', N
- ('qgep_od', 'stat_reach', 'progression_geometry', None, 'YES', 'USER-DEFINED'
- ('qgep_od', 'stat_reach', 'reliner_material', None, 'YES', 'integer', None, '
- ('qgep_od', 'stat_reach', 'reliner_nominal_size', None, 'YES', 'integer', Non
- ('qgep_od', 'stat_reach', 'relining_construction', None, 'YES', 'integer', No
- ('qgep_od', 'stat_reach', 'relining_kind', None, 'YES', 'integer', None, '32'
- ('qgep_od', 'stat_reach', 'remark', None, 'YES', 'character varying', '80', N
- ('qgep_od', 'stat_reach', 'ring_stiffness', None, 'YES', 'smallint', None, '1
- ('qgep_od', 'stat_reach', 'rp_from_elevation_accuracy', None, 'YES', 'integer
- ('qgep_od', 'stat_reach', 'rp_from_fk_dataowner', None, 'YES', 'character var
- ('qgep_od', 'stat_reach', 'rp_from_fk_provider', None, 'YES', 'character vary
- ('qgep_od', 'stat_reach', 'rp_from_fk_wastewater_networkelement', None, 'YES'
- ('qgep_od', 'stat_reach', 'rp_from_identifier', None, 'YES', 'character varyi
- ('qgep_od', 'stat_reach', 'rp_from_last_modification', None, 'YES', 'timestam
- ('qgep_od', 'stat_reach', 'rp_from_level', None, 'YES', 'numeric', None, '7',
- ('qgep_od', 'stat_reach', 'rp_from_obj_id', None, 'YES', 'character varying',
- ('qgep_od', 'stat_reach', 'rp_from_outlet_shape', None, 'YES', 'integer', Non
- ('qgep_od', 'stat_reach', 'rp_from_position_of_connection', None, 'YES', 'sma
- ('qgep_od', 'stat_reach', 'rp_from_remark', None, 'YES', 'character varying',
- ('qgep_od', 'stat_reach', 'rp_to_elevation_accuracy', None, 'YES', 'integer',
- ('qgep_od', 'stat_reach', 'rp_to_fk_dataowner', None, 'YES', 'character varyi
- ('qgep_od', 'stat_reach', 'rp_to_fk_provider', None, 'YES', 'character varyin
- ('qgep_od', 'stat_reach', 'rp_to_fk_wastewater_networkelement', None, 'YES', 
- ('qgep_od', 'stat_reach', 'rp_to_identifier', None, 'YES', 'character varying
- ('qgep_od', 'stat_reach', 'rp_to_last_modification', None, 'YES', 'timestamp 
- ('qgep_od', 'stat_reach', 'rp_to_level', None, 'YES', 'numeric', None, '7', '
- ('qgep_od', 'stat_reach', 'rp_to_obj_id', None, 'YES', 'character varying', '
- ('qgep_od', 'stat_reach', 'rp_to_outlet_shape', None, 'YES', 'integer', None,
- ('qgep_od', 'stat_reach', 'rp_to_position_of_connection', None, 'YES', 'small
- ('qgep_od', 'stat_reach', 'rp_to_remark', None, 'YES', 'character varying', '
- ('qgep_od', 'stat_reach', 'slope_building_plan', None, 'YES', 'smallint', Non
- ('qgep_od', 'stat_reach', '_slope_per_mill', None, 'YES', 'numeric', None, No
- ('qgep_od', 'stat_reach', 'status', None, 'YES', 'integer', None, '32', '2', 
- ('qgep_od', 'stat_reach', 'usage_current', None, 'YES', 'integer', None, '32'
- ('qgep_od', 'stat_reach', 'wall_roughness', None, 'YES', 'numeric', None, '5'
- ('qgep_od', 'stat_reach', 'width', None, 'YES', 'integer', None, '32', '2', N
- ('qgep_od', 'stat_reach', 'ws_accessibility', None, 'YES', 'integer', None, '
- ('qgep_od', 'stat_reach', 'ws_contract_section', None, 'YES', 'character vary
- ('qgep_od', 'stat_reach', 'ws_financing', None, 'YES', 'integer', None, '32',
- ('qgep_od', 'stat_reach', 'ws_fk_operator', None, 'YES', 'character varying',
- ('qgep_od', 'stat_reach', 'ws_fk_owner', None, 'YES', 'character varying', '1
- ('qgep_od', 'stat_reach', 'ws_gross_costs', None, 'YES', 'numeric', None, '10
- ('qgep_od', 'stat_reach', 'ws_identifier', None, 'YES', 'character varying', 
- ('qgep_od', 'stat_reach', 'ws_inspection_interval', None, 'YES', 'numeric', N
- ('qgep_od', 'stat_reach', 'ws_last_modification', None, 'YES', 'timestamp wit
- ('qgep_od', 'stat_reach', 'ws_location_name', None, 'YES', 'character varying
- ('qgep_od', 'stat_reach', 'ws_obj_id', None, 'YES', 'character varying', '16'
- ('qgep_od', 'stat_reach', 'ws_records', None, 'YES', 'character varying', '25
- ('qgep_od', 'stat_reach', 'ws_remark', None, 'YES', 'character varying', '80'
- ('qgep_od', 'stat_reach', 'ws_renovation_necessity', None, 'YES', 'integer', 
- ('qgep_od', 'stat_reach', 'ws_replacement_value', None, 'YES', 'numeric', Non
- ('qgep_od', 'stat_reach', 'ws_rv_base_year', None, 'YES', 'smallint', None, '
- ('qgep_od', 'stat_reach', 'ws_rv_construction_type', None, 'YES', 'integer', 
- ('qgep_od', 'stat_reach', 'ws_structure_condition', None, 'YES', 'integer', N
- ('qgep_od', 'stat_reach', 'ws_subsidies', None, 'YES', 'numeric', None, '10',
- ('qgep_od', 'stat_reach', 'ws_year_of_replacement', None, 'YES', 'smallint', 
- ('qgep_od', 'stat_reach', 'year_of_construction', None, 'YES', 'smallint', No
- ('qgep_od', 'stat_reach_clear_h', 'clear_height', None, 'YES', 'integer', Non
- ('qgep_od', 'stat_reach_clear_h', 'clear_h_length', None, 'YES', 'numeric', N
- ('qgep_od', 'stat_reach_clear_h', 'count', None, 'YES', 'bigint', None, '64',
- ('qgep_od', 'stat_reach_clear_r', 'clear_r_length', None, 'YES', 'numeric', N
- ('qgep_od', 'stat_reach_clear_r', 'length_class', None, 'YES', 'character var
- ('qgep_od', 'stat_reach_clear_r', 'length_count', None, 'YES', 'bigint', None
- ('qgep_od', 'stat_reach_clear_r', 'length_fid', None, 'NO', 'integer', None, 
- ('qgep_od', 'stat_reach_fun_hie', 'count', None, 'YES', 'bigint', None, '64',
- ('qgep_od', 'stat_reach_fun_hie', 'function_hierarchic', None, 'YES', 'intege
- ('qgep_od', 'stat_reach_fun_hie', 'fun_hie_de', None, 'YES', 'character varyi
- ('qgep_od', 'stat_reach_fun_hie', 'fun_hie_length', None, 'YES', 'numeric', N
- ('qgep_od', 'stat_reach_fun_hyd', 'count', None, 'YES', 'bigint', None, '64',
- ('qgep_od', 'stat_reach_fun_hyd', 'function_hydraulic', None, 'YES', 'integer
- ('qgep_od', 'stat_reach_fun_hyd', 'fun_hyd_de', None, 'YES', 'character varyi
- ('qgep_od', 'stat_reach_fun_hyd', 'fun_hyd_length', None, 'YES', 'numeric', N
- ('qgep_od', 'stat_reach_length', 'length_class', None, 'YES', 'character vary
- ('qgep_od', 'stat_reach_length', 'length_count', None, 'YES', 'bigint', None,
- ('qgep_od', 'stat_reach_length', 'length_fid', None, 'NO', 'integer', None, '
- ('qgep_od', 'stat_reach_length', 'len_length', None, 'YES', 'numeric', None, 
- ('qgep_od', 'stat_reach_material', 'count', None, 'YES', 'bigint', None, '64'
- ('qgep_od', 'stat_reach_material', 'mat_ab_de', None, 'YES', 'character varyi
- ('qgep_od', 'stat_reach_material', 'mat_de', None, 'YES', 'character varying'
- ('qgep_od', 'stat_reach_material', 'material', None, 'YES', 'integer', None, 
- ('qgep_od', 'stat_reach_material', 'mat_length', None, 'YES', 'numeric', None
- ('qgep_od', 'stat_reach_owner', 'count', None, 'YES', 'bigint', None, '64', '
- ('qgep_od', 'stat_reach_owner', 'owner_length', None, 'YES', 'numeric', None,
- ('qgep_od', 'stat_reach_owner', 'owner_sta', None, 'YES', 'character varying'
- ('qgep_od', 'stat_reach_owner', 'ws_fk_owner', None, 'YES', 'character varyin
- ('qgep_od', 'stat_reach_status', 'count', None, 'YES', 'bigint', None, '64', 
- ('qgep_od', 'stat_reach_status', 'stat_length', None, 'YES', 'numeric', None,
- ('qgep_od', 'stat_reach_status', 'status', None, 'YES', 'integer', None, '32'
- ('qgep_od', 'stat_reach_status', 'status_de', None, 'YES', 'character varying
- ('qgep_od', 'stat_reach_use_cur', 'count', None, 'YES', 'bigint', None, '64',
- ('qgep_od', 'stat_reach_use_cur', 'usage_current', None, 'YES', 'integer', No
- ('qgep_od', 'stat_reach_use_cur', 'use_cur_de', None, 'YES', 'character varyi
- ('qgep_od', 'stat_reach_use_cur', 'use_cur_length', None, 'YES', 'numeric', N
- ('qgep_od', 'stat_reach_year_o_c', 'count', None, 'YES', 'bigint', None, '64'
- ('qgep_od', 'stat_reach_year_o_c', 'year_of_construction', None, 'YES', 'smal
- ('qgep_od', 'stat_reach_year_o_c', 'yoc_length', None, 'YES', 'numeric', None
- ('qgep_od', 'stat_wws', 'accessibility', None, 'YES', 'integer', None, '32', 
- ('qgep_od', 'stat_wws', '_channel_function_hierarchic', None, 'YES', 'integer
- ('qgep_od', 'stat_wws', '_channel_usage_current', None, 'YES', 'integer', Non
- ('qgep_od', 'stat_wws', 'co_brand', None, 'YES', 'character varying', '50', N
- ('qgep_od', 'stat_wws', 'co_diameter', None, 'YES', 'smallint', None, '16', '
- ('qgep_od', 'stat_wws', 'co_fastening', None, 'YES', 'integer', None, '32', '
- ('qgep_od', 'stat_wws', 'co_identifier', None, 'YES', 'character varying', '2
- ('qgep_od', 'stat_wws', 'co_level', None, 'YES', 'numeric', None, '7', '10', 
- ('qgep_od', 'stat_wws', 'co_material', None, 'YES', 'integer', None, '32', '2
- ('qgep_od', 'stat_wws', 'contract_section', None, 'YES', 'character varying',
- ('qgep_od', 'stat_wws', 'co_obj_id', None, 'YES', 'character varying', '16', 
- ('qgep_od', 'stat_wws', 'co_positional_accuracy', None, 'YES', 'integer', Non
- ('qgep_od', 'stat_wws', 'co_remark', None, 'YES', 'character varying', '80', 
- ('qgep_od', 'stat_wws', 'co_renovation_demand', None, 'YES', 'integer', None,
- ('qgep_od', 'stat_wws', 'co_shape', None, 'YES', 'integer', None, '32', '2', 
- ('qgep_od', 'stat_wws', 'co_sludge_bucket', None, 'YES', 'integer', None, '32
- ('qgep_od', 'stat_wws', 'co_venting', None, 'YES', 'integer', None, '32', '2'
- ('qgep_od', 'stat_wws', '_depth', None, 'YES', 'numeric', None, '6', '10', No
- ('qgep_od', 'stat_wws', 'dp_fk_sector_water_body', None, 'YES', 'character va
- ('qgep_od', 'stat_wws', 'dp_highwater_level', None, 'YES', 'numeric', None, '
- ('qgep_od', 'stat_wws', 'dp_relevance', None, 'YES', 'integer', None, '32', '
- ('qgep_od', 'stat_wws', 'dp_terrain_level', None, 'YES', 'numeric', None, '7'
- ('qgep_od', 'stat_wws', 'dp_upper_elevation', None, 'YES', 'numeric', None, '
- ('qgep_od', 'stat_wws', 'dp_waterlevel_hydraulic', None, 'YES', 'numeric', No
- ('qgep_od', 'stat_wws', 'financing', None, 'YES', 'integer', None, '32', '2',
- ('qgep_od', 'stat_wws', 'fk_dataowner', None, 'YES', 'character varying', '16
- ('qgep_od', 'stat_wws', 'fk_operator', None, 'YES', 'character varying', '16'
- ('qgep_od', 'stat_wws', 'fk_owner', None, 'YES', 'character varying', '16', N
- ('qgep_od', 'stat_wws', 'fk_provider', None, 'YES', 'character varying', '16'
- ('qgep_od', 'stat_wws', 'function', None, 'YES', 'integer', None, '32', '2', 
- ('qgep_od', 'stat_wws', 'gross_costs', None, 'YES', 'numeric', None, '10', '1
- ('qgep_od', 'stat_wws', 'identifier', None, 'YES', 'character varying', '20',
- ('qgep_od', 'stat_wws', 'ii_absorption_capacity', None, 'YES', 'numeric', Non
- ('qgep_od', 'stat_wws', 'ii_defects', None, 'YES', 'integer', None, '32', '2'
- ('qgep_od', 'stat_wws', 'ii_dimension1', None, 'YES', 'smallint', None, '16',
- ('qgep_od', 'stat_wws', 'ii_dimension2', None, 'YES', 'smallint', None, '16',
- ('qgep_od', 'stat_wws', 'ii_distance_to_aquifer', None, 'YES', 'numeric', Non
- ('qgep_od', 'stat_wws', 'ii_effective_area', None, 'YES', 'numeric', None, '8
- ('qgep_od', 'stat_wws', 'ii_emergency_spillway', None, 'YES', 'integer', None
- ('qgep_od', 'stat_wws', 'ii_fk_aquifier', None, 'YES', 'character varying', '
- ('qgep_od', 'stat_wws', 'ii_kind', None, 'YES', 'integer', None, '32', '2', N
- ('qgep_od', 'stat_wws', 'ii_labeling', None, 'YES', 'integer', None, '32', '2
- ('qgep_od', 'stat_wws', 'ii_seepage_utilization', None, 'YES', 'integer', Non
- ('qgep_od', 'stat_wws', 'ii_upper_elevation', None, 'YES', 'numeric', None, '
- ('qgep_od', 'stat_wws', 'ii_vehicle_access', None, 'YES', 'integer', None, '3
- ('qgep_od', 'stat_wws', 'ii_watertightness', None, 'YES', 'integer', None, '3
- ('qgep_od', 'stat_wws', 'inspection_interval', None, 'YES', 'numeric', None, 
- ('qgep_od', 'stat_wws', '_label', None, 'YES', 'text', None, None, None, None
- ('qgep_od', 'stat_wws', 'last_modification', None, 'YES', 'timestamp without 
- ('qgep_od', 'stat_wws', 'location_name', None, 'YES', 'character varying', '5
- ('qgep_od', 'stat_wws', 'ma_dimension1', None, 'YES', 'smallint', None, '16',
- ('qgep_od', 'stat_wws', 'ma_dimension2', None, 'YES', 'smallint', None, '16',
- ('qgep_od', 'stat_wws', 'ma_material', None, 'YES', 'integer', None, '32', '2
- ('qgep_od', 'stat_wws', 'ma_orientation', None, 'YES', 'numeric', None, None,
- ('qgep_od', 'stat_wws', 'ma_surface_inflow', None, 'YES', 'integer', None, '3
- ('qgep_od', 'stat_wws', 'obj_id', None, 'YES', 'character varying', '16', Non
- ('qgep_od', 'stat_wws', 'records', None, 'YES', 'character varying', '255', N
- ('qgep_od', 'stat_wws', 'remark', None, 'YES', 'character varying', '80', Non
- ('qgep_od', 'stat_wws', 'renovation_necessity', None, 'YES', 'integer', None,
- ('qgep_od', 'stat_wws', 'replacement_value', None, 'YES', 'numeric', None, '1
- ('qgep_od', 'stat_wws', 'rv_base_year', None, 'YES', 'smallint', None, '16', 
- ('qgep_od', 'stat_wws', 'rv_construction_type', None, 'YES', 'integer', None,
- ('qgep_od', 'stat_wws', 'situation_geometry', None, 'YES', 'USER-DEFINED', No
- ('qgep_od', 'stat_wws', 'ss_bypass', None, 'YES', 'integer', None, '32', '2',
- ('qgep_od', 'stat_wws', 'ss_emergency_spillway', None, 'YES', 'integer', None
- ('qgep_od', 'stat_wws', 'ss_function', None, 'YES', 'integer', None, '32', '2
- ('qgep_od', 'stat_wws', 'ss_stormwater_tank_arrangement', None, 'YES', 'integ
- ('qgep_od', 'stat_wws', 'ss_upper_elevation', None, 'YES', 'numeric', None, '
- ('qgep_od', 'stat_wws', 'status', None, 'YES', 'integer', None, '32', '2', No
- ('qgep_od', 'stat_wws', 'structure_condition', None, 'YES', 'integer', None, 
- ('qgep_od', 'stat_wws', 'subsidies', None, 'YES', 'numeric', None, '10', '10'
- ('qgep_od', 'stat_wws', 'wn_backflow_level', None, 'YES', 'numeric', None, '7
- ('qgep_od', 'stat_wws', 'wn_bottom_level', None, 'YES', 'numeric', None, '7',
- ('qgep_od', 'stat_wws', 'wn_fk_dataowner', None, 'YES', 'character varying', 
- ('qgep_od', 'stat_wws', 'wn_fk_hydr_geometry', None, 'YES', 'character varyin
- ('qgep_od', 'stat_wws', 'wn_fk_provider', None, 'YES', 'character varying', '
- ('qgep_od', 'stat_wws', 'wn_identifier', None, 'YES', 'character varying', '2
- ('qgep_od', 'stat_wws', 'wn_last_modification', None, 'YES', 'timestamp witho
- ('qgep_od', 'stat_wws', 'wn_obj_id', None, 'YES', 'character varying', '16', 
- ('qgep_od', 'stat_wws', 'wn_remark', None, 'YES', 'character varying', '80', 
- ('qgep_od', 'stat_wws', 'ws_type', None, 'YES', 'text', None, None, None, Non
- ('qgep_od', 'stat_wws', 'year_of_construction', None, 'YES', 'smallint', None
- ('qgep_od', 'stat_wws', 'year_of_replacement', None, 'YES', 'smallint', None,
- ('qgep_od', 'stat_wws_man_fun', 'count', None, 'YES', 'bigint', None, '64', '
- ('qgep_od', 'stat_wws_man_fun', 'ma_function', None, 'YES', 'integer', None, 
- ('qgep_od', 'stat_wws_man_fun', 'man_fun_de', None, 'YES', 'character varying
- ('qgep_od', 'stat_wws_owner', 'count', None, 'YES', 'bigint', None, '64', '2'
- ('qgep_od', 'stat_wws_owner', 'fk_owner', None, 'YES', 'character varying', '
- ('qgep_od', 'stat_wws_owner', 'owner_sta', None, 'YES', 'character varying', 
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_bedding_encasement', None, 'YES', 'integ
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_connection_type', None, 'YES', 'integer'
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_function_hierarchic', None, 'YES', 'inte
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_function_hydraulic', None, 'YES', 'integ
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_jetting_interval', None, 'YES', 'numeric
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_pipe_length', None, 'YES', 'numeric', No
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_usage_current', None, 'YES', 'integer', 
- ('qgep_od', 'vw_qgep_reach_avm', 'ch_usage_planned', None, 'YES', 'integer', 
- ('qgep_od', 'vw_qgep_reach_avm', 'clear_height', None, 'YES', 'integer', None
- ('qgep_od', 'vw_qgep_reach_avm', 'coefficient_of_friction', None, 'YES', 'sma
- ('qgep_od', 'vw_qgep_reach_avm', 'elevation_determination', None, 'YES', 'int
- ('qgep_od', 'vw_qgep_reach_avm', 'fk_dataowner', None, 'YES', 'character vary
- ('qgep_od', 'vw_qgep_reach_avm', 'fk_pipe_profile', None, 'YES', 'character v
- ('qgep_od', 'vw_qgep_reach_avm', 'fk_provider', None, 'YES', 'character varyi
- ('qgep_od', 'vw_qgep_reach_avm', 'fk_wastewater_structure', None, 'YES', 'cha
- ('qgep_od', 'vw_qgep_reach_avm', 'horizontal_positioning', None, 'YES', 'inte
- ('qgep_od', 'vw_qgep_reach_avm', 'identifier', None, 'YES', 'character varyin
- ('qgep_od', 'vw_qgep_reach_avm', 'inside_coating', None, 'YES', 'integer', No
- ('qgep_od', 'vw_qgep_reach_avm', 'last_modification', None, 'YES', 'timestamp
- ('qgep_od', 'vw_qgep_reach_avm', 'length_effective', None, 'YES', 'numeric', 
- ('qgep_od', 'vw_qgep_reach_avm', 'material', None, 'YES', 'integer', None, '3
- ('qgep_od', 'vw_qgep_reach_avm', 'obj_id', None, 'YES', 'character varying', 
- ('qgep_od', 'vw_qgep_reach_avm', 'progression_geometry', None, 'YES', 'USER-D
- ('qgep_od', 'vw_qgep_reach_avm', 'reliner_material', None, 'YES', 'integer', 
- ('qgep_od', 'vw_qgep_reach_avm', 'reliner_nominal_size', None, 'YES', 'intege
- ('qgep_od', 'vw_qgep_reach_avm', 'relining_construction', None, 'YES', 'integ
- ('qgep_od', 'vw_qgep_reach_avm', 'relining_kind', None, 'YES', 'integer', Non
- ('qgep_od', 'vw_qgep_reach_avm', 'remark', None, 'YES', 'character varying', 
- ('qgep_od', 'vw_qgep_reach_avm', 'ring_stiffness', None, 'YES', 'smallint', N
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_elevation_accuracy', None, 'YES', '
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_fk_dataowner', None, 'YES', 'charac
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_fk_provider', None, 'YES', 'charact
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_fk_wastewater_networkelement', None
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_identifier', None, 'YES', 'characte
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_last_modification', None, 'YES', 't
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_level', None, 'YES', 'numeric', Non
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_obj_id', None, 'YES', 'character va
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_outlet_shape', None, 'YES', 'intege
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_position_of_connection', None, 'YES
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_from_remark', None, 'YES', 'character va
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_elevation_accuracy', None, 'YES', 'in
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_fk_dataowner', None, 'YES', 'characte
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_fk_provider', None, 'YES', 'character
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_fk_wastewater_networkelement', None, 
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_identifier', None, 'YES', 'character 
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_last_modification', None, 'YES', 'tim
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_level', None, 'YES', 'numeric', None,
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_obj_id', None, 'YES', 'character vary
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_outlet_shape', None, 'YES', 'integer'
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_position_of_connection', None, 'YES',
- ('qgep_od', 'vw_qgep_reach_avm', 'rp_to_remark', None, 'YES', 'character vary
- ('qgep_od', 'vw_qgep_reach_avm', 'slope_building_plan', None, 'YES', 'smallin
- ('qgep_od', 'vw_qgep_reach_avm', '_slope_per_mill', None, 'YES', 'numeric', N
- ('qgep_od', 'vw_qgep_reach_avm', 'wall_roughness', None, 'YES', 'numeric', No
- ('qgep_od', 'vw_qgep_reach_avm', 'width', None, 'YES', 'integer', None, '32',
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_accessibility', None, 'YES', 'integer', 
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_contract_section', None, 'YES', 'charact
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_financing', None, 'YES', 'integer', None
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_fk_operator', None, 'YES', 'character va
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_fk_owner', None, 'YES', 'character varyi
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_gross_costs', None, 'YES', 'numeric', No
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_identifier', None, 'YES', 'character var
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_inspection_interval', None, 'YES', 'nume
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_last_modification', None, 'YES', 'timest
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_location_name', None, 'YES', 'character 
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_obj_id', None, 'YES', 'character varying
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_records', None, 'YES', 'character varyin
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_remark', None, 'YES', 'character varying
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_renovation_necessity', None, 'YES', 'int
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_replacement_value', None, 'YES', 'numeri
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_rv_base_year', None, 'YES', 'smallint', 
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_rv_construction_type', None, 'YES', 'int
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_status', None, 'YES', 'integer', None, '
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_structure_condition', None, 'YES', 'inte
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_subsidies', None, 'YES', 'numeric', None
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_year_of_construction', None, 'YES', 'sma
- ('qgep_od', 'vw_qgep_reach_avm', 'ws_year_of_replacement', None, 'YES', 'smal
- ('qgep_od', 'vw_qgep_wastewater_structure', 'co_obj_id', None, 'YES', 'charac
+ ('qgep_od', 'vw_qgep_wastewater_structure', 'co_obj_id', "qgep_sys.generate_o
- ('qgep_od', 'vw_qgep_wastewater_structure', 'obj_id', None, 'YES', 'character
+ ('qgep_od', 'vw_qgep_wastewater_structure', 'obj_id', "qgep_sys.generate_oid(
- ('qgep_od', 'vw_qgep_wastewater_structure', 'wn_fk_wastewater_structure', Non
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'accessibility', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', '_channel_function_hierarchic
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', '_channel_usage_current', Non
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_brand', None, 'YES', 'cha
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_diameter', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_fastening', None, 'YES', 
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_identifier', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_level', None, 'YES', 'num
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_material', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'contract_section', None, 'YE
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_obj_id', "qgep_sys.genera
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_positional_accuracy', Non
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_remark', None, 'YES', 'ch
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_renovation_demand', None,
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_shape', None, 'YES', 'int
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_sludge_bucket', None, 'YE
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'co_venting', None, 'YES', 'i
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', '_depth', None, 'YES', 'numer
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'dp_fk_sector_water_body', No
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'dp_highwater_level', None, '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'dp_relevance', None, 'YES', 
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'dp_terrain_level', None, 'YE
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'dp_upper_elevation', None, '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'dp_waterlevel_hydraulic', No
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'financing', None, 'YES', 'in
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'fk_dataowner', None, 'YES', 
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'fk_operator', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'fk_owner', None, 'YES', 'cha
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'fk_provider', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'gross_costs', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'identifier', None, 'YES', 'c
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_absorption_capacity', Non
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_defects', None, 'YES', 'i
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_dimension1', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_dimension2', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_distance_to_aquifer', Non
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_effective_area', None, 'Y
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_emergency_spillway', None
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_fk_aquifier', None, 'YES'
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_kind', None, 'YES', 'inte
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_labeling', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_seepage_utilization', Non
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_upper_elevation', None, '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_vehicle_access', None, 'Y
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ii_watertightness', None, 'Y
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'inspection_interval', None, 
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', '_label', None, 'YES', 'text'
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'last_modification', None, 'Y
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'location_name', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ma_dimension1', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ma_dimension2', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ma_function', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ma_material', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ma_orientation', None, 'YES'
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ma_surface_inflow', None, 'Y
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'obj_id', "qgep_sys.generate_
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'records', None, 'YES', 'char
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'remark', None, 'YES', 'chara
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'renovation_necessity', None,
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'replacement_value', None, 'Y
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'rv_base_year', None, 'YES', 
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'rv_construction_type', None,
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'situation_geometry', None, '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ss_bypass', None, 'YES', 'in
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ss_emergency_spillway', None
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ss_function', None, 'YES', '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ss_stormwater_tank_arrangeme
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ss_upper_elevation', None, '
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'status', None, 'YES', 'integ
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'structure_condition', None, 
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'subsidies', None, 'YES', 'nu
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_backflow_level', None, 'Y
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_bottom_level', None, 'YES
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_fk_dataowner', None, 'YES
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_fk_hydr_geometry', None, 
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_fk_provider', None, 'YES'
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_identifier', None, 'YES',
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_last_modification', None,
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_obj_id', None, 'YES', 'ch
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'wn_remark', None, 'YES', 'ch
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'ws_type', None, 'YES', 'text
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'year_of_construction', None,
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', 'year_of_replacement', None, 
- ('qgep_od', 'wastewater_node', 'situation_geometry', None, 'NO', 'USER-DEFINE
+ ('qgep_od', 'wastewater_node', 'situation_geometry', None, 'YES', 'USER-DEFIN
- ('qgep_od', 'wastewater_node', 'situation_geometry_point', None, 'YES', 'USER
- ('qgep_od', 'wastewater_node', 'situation_geometry_pointz', None, 'YES', 'USE
- ('qgep_od', 'wastewater_structure', 'fk_main_wastewater_node', None, 'YES', '
constraints
- ('zone_a_2016_pkey', 'arbon_kan.zone_a_2016.ogc_fid', 'arbon_kan', 'zone_a_20
- ('zone_b_2017_pkey', 'arbon_kan.zone_b_2017.ogc_fid', 'arbon_kan', 'zone_b_20
- ('zone_c_2018_pkey', 'arbon_kan.zone_c_2018.ogc_fid', 'arbon_kan', 'zone_c_20
- ('zone_d_2019_pkey', 'arbon_kan.zone_d_2019.ogc_fid', 'arbon_kan', 'zone_d_20
- ('ableitung_hofen_pkey', 'fischer.ableitung_hofen.fid', 'fischer', 'ableitung
- ('arbon_tp37_versickerung_pkey', 'fischer.arbon_tp37_versickerung.fi_fid', 'f
- ('arbon_tp4_fliesszeit_pkey', 'fischer.arbon_tp4_fliesszeit.fi_fid', 'fischer
- ('fi_tp4_gefahren_pkey', 'fischer.arbon_tp4_gefahren.fi_fid', 'fischer', 'arb
- ('t_pkey', 'fischer.arbon_zonen_unterhalt.fid', 'fischer', 'arbon_zonen_unter
- ('atlas_500_arbon_pkey', 'fischer.atlas_500_arbon.fid', 'fischer', 'atlas_500
- ('avm_sobau_pkey', 'fischer.avm_sobau.fid', 'fischer', 'avm_sobau', 'fid', 'a
- ('avm_tp32_problemstelle_pkey', 'fischer.avm_tp32_problemstelle.fi_fid', 'fis
- ('avm_tp7_massnahme_pkey', 'fischer.avm_tp7_massnahme.fi_fid', 'fischer', 'av
- ('avm_pkey', 'fischer.avm_zonen_unterhalt.fid', 'fischer', 'avm_zonen_unterha
- ('beschriftung_pkt_pkey', 'fischer.beschriftung_pkt.fid', 'fischer', 'beschri
- ('entwaesserungsgraben_pkey', 'fischer.entwaesserungsgraben.gid', 'fischer', 
- ('fi_a2000_pkey', 'fischer.fi_a2000.gid', 'fischer', 'fi_a2000', 'gid', 'fi_a
- ('fi_avm_500_pkey', 'fischer.fi_avm_500.fid', 'fischer', 'fi_avm_500', 'fid',
- ('fi_dp_oeko_pkey', 'fischer.fi_dp_oeko.gid', 'fischer', 'fi_dp_oeko', 'gid',
- ('fi_ezg_pkey', 'fischer.fi_ezg_basis.gidd', 'fischer', 'fi_ezg_basis', 'gidd
- ('fi_ezg_rb_pkey', 'fischer.fi_ezg_rb.fid', 'fischer', 'fi_ezg_rb', 'fid', 'f
- ('fi_ezg_ru_pkey', 'fischer.fi_ezg_ru.fid', 'fischer', 'fi_ezg_ru', 'fid', 'f
- ('fi_ezg_system_current_pkey', 'fischer.fi_ezg_system_current.fid', 'fischer'
- ('fi_grenze_arbon_pkey', 'fischer.fi_grenze_arbon.fid', 'fischer', 'fi_grenze
- ('fi_kan_gem_pkey', 'fischer.fi_kan_gem.fid', 'fischer', 'fi_kan_gem', 'fid',
- ('fi_rect_pkey', 'fischer.fi_rect.fi_fid', 'fischer', 'fi_rect', 'fi_fid', 'f
- ('fliessgewaesser_pkey', 'fischer.fliessgewaesser.gid', 'fischer', 'fliessgew
- ('fliessgewaesser_name_pkey', 'fischer.fliessgewaesser_name.gid', 'fischer', 
- ('fliessgewaesser_schacht_pkey', 'fischer.fliessgewaesser_schacht.gid', 'fisc
- ('fz_e5_pkey', 'fischer.fz_e5.fid', 'fischer', 'fz_e5', 'fid', 'fz_e5', 'fid'
- ('fz_twa_pkey', 'fischer.fz_twa.fid', 'fischer', 'fz_twa', 'fid', 'fz_twa', '
- ('gewaesserabschnitt_pkey', 'fischer.gewaesserabschnitt.gid', 'fischer', 'gew
- ('gewaessereinzugsgebiet_pkey', 'fischer.gewaessereinzugsgebiet.gid', 'fische
- ('gewaessermetrierung_pkey', 'fischer.gewaessermetrierung.gid', 'fischer', 'g
- ('gewaessersystem_pkey', 'fischer.gewaessersystem.gid', 'fischer', 'gewaesser
- ('gewaesserverlauf_pkey', 'fischer.gewaesserverlauf.gid', 'fischer', 'gewaess
- ('stehendes_gewaesser_pkey', 'fischer.stehendes_gewaesser.gid', 'fischer', 's
- ('abwasserknoten_pkey', 'import_sbu.abwasserknoten.fid', 'import_sbu', 'abwas
- ('bankett_pkey', 'import_sbu.bankett.fid', 'import_sbu', 'bankett', 'fid', 'b
- ('deckel_pkey', 'import_sbu.deckel.fid', 'import_sbu', 'deckel', 'fid', 'deck
- ('einleitstelle_pkey', 'import_sbu.einleitstelle.fid', 'import_sbu', 'einleit
- ('einstiegshilfe_pkey', 'import_sbu.einstiegshilfe.fid', 'import_sbu', 'einst
- ('haltung_pkey', 'import_sbu.haltung.fid', 'import_sbu', 'haltung', 'fid', 'h
- ('haltungspunkt_pkey', 'import_sbu.haltungspunkt.fid', 'import_sbu', 'haltung
- ('kanal_pkey', 'import_sbu.kanal.fid', 'import_sbu', 'kanal', 'fid', 'kanal',
- ('normschacht_pkey', 'import_sbu.normschacht.fid', 'import_sbu', 'normschacht
- ('privat_pkey', 'import_sbu.privat.fid', 'import_sbu', 'privat', 'fid', 'priv
- ('rohrprofil_pkey', 'import_sbu.rohrprofil.fid', 'import_sbu', 'rohrprofil', 
- ('spezialbauwerk_pkey', 'import_sbu.spezialbauwerk.fid', 'import_sbu', 'spezi
- ('stat_reach_clear_r_pkey', 'qgep_od.stat_reach_clear_r.length_fid', 'qgep_od
- ('stat_reach_length_pkey', 'qgep_od.stat_reach_length.length_fid', 'qgep_od',
- ('rel_wastewater_structure_main_wastewater_node', 'qgep_od.wastewater_structu
views
- ('vw_manhole', ' SELECT DISTINCT ON (ws.obj_id) ws.obj_id,\n    ws.identifier
+ ('vw_manhole', ' SELECT DISTINCT ON (ws.obj_id) ws.obj_id,\n    ws.identifier
- ('vw_qgep_reach_avm', " SELECT vw_qgep_reach.obj_id,\n    vw_qgep_reach.clear
- ('vw_qgep_wastewater_structure', " SELECT ws.identifier,\n        CASE\n     
- ('vw_qgep_wastewater_structure_avm', " SELECT ws.identifier,\n        CASE\n 
+ ('vw_qgep_wastewater_structure', " SELECT ws.identifier,\n        CASE\n     
sequences
- ('arbon_tp4_gefahren_fi_fid_seq',)
- ('fi_dp_oeko_gid_seq',)
indexes
- ('ableitung_hofen', 'ableitung_hofen_geom_geom_idx', 'geom')
- ('ableitung_hofen', 'ableitung_hofen_pkey', 'fid')
- ('abwasserknoten', 'abwasserknoten_geom_geom_idx', 'geom')
- ('abwasserknoten', 'abwasserknoten_pkey', 'fid')
- ('arbon_tp37_versickerung', 'arbon_tp37_versickerung_pkey', 'fi_fid')
- ('arbon_tp4_fliesszeit', 'arbon_tp4_fliesszeit_pkey', 'fi_fid')
- ('arbon_tp4_gefahren', 'fi_tp4_gefahren_pkey', 'fi_fid')
- ('arbon_zonen_unterhalt', 't_geom_geom_idx', 'geom')
- ('arbon_zonen_unterhalt', 't_pkey', 'fid')
- ('atlas_500_arbon', 'atlas_500_arbon_geom_geom_idx', 'geom')
- ('atlas_500_arbon', 'atlas_500_arbon_pkey', 'fid')
- ('avm_sobau', 'avm_sobau_geom_geom_idx', 'geom')
- ('avm_sobau', 'avm_sobau_pkey', 'fid')
- ('avm_tp32_problemstelle', 'avm_tp32_problemstelle_pkey', 'fi_fid')
- ('avm_tp7_massnahme', 'avm_tp7_massnahme_pkey', 'fi_fid')
- ('avm_zonen_unterhalt', 'avm_geom_geom_idx', 'geom')
- ('avm_zonen_unterhalt', 'avm_pkey', 'fid')
- ('bankett', 'bankett_pkey', 'fid')
- ('beschriftung_pkt', 'beschriftung_pkt_geom_geom_idx', 'geom')
- ('beschriftung_pkt', 'beschriftung_pkt_pkey', 'fid')
- ('deckel', 'deckel_geom_geom_idx', 'geom')
- ('deckel', 'deckel_pkey', 'fid')
- ('einleitstelle', 'einleitstelle_geom_geom_idx', 'geom')
- ('einleitstelle', 'einleitstelle_pkey', 'fid')
- ('einstiegshilfe', 'einstiegshilfe_pkey', 'fid')
- ('entwaesserungsgraben', 'entwaesserungsgraben_pkey', 'gid')
- ('fi_a2000', 'fi_a2000_pkey', 'gid')
- ('fi_avm_500', 'fi_avm_500_geom_geom_idx', 'geom')
- ('fi_avm_500', 'fi_avm_500_pkey', 'fid')
- ('fi_dp_oeko', 'fi_dp_oeko_pkey', 'gid')
- ('fi_ezg_basis', 'fi_ezg_basis_geom_geom_idx', 'geom')
- ('fi_ezg_basis', 'fi_ezg_pkey', 'gidd')
- ('fi_ezg_rb', 'fi_ezg_rb_geom_geom_idx', 'geom')
- ('fi_ezg_rb', 'fi_ezg_rb_pkey', 'fid')
- ('fi_ezg_ru', 'fi_ezg_ru_geom_geom_idx', 'geom')
- ('fi_ezg_ru', 'fi_ezg_ru_pkey', 'fid')
- ('fi_ezg_system_current', 'fi_ezg_system_current_geom_geom_idx', 'geom')
- ('fi_ezg_system_current', 'fi_ezg_system_current_pkey', 'fid')
- ('fi_grenze_arbon', 'fi_grenze_arbon_geom_geom_idx', 'geom')
- ('fi_grenze_arbon', 'fi_grenze_arbon_pkey', 'fid')
- ('fi_kan_gem', 'fi_kan_gem_geom_geom_idx', 'geom')
- ('fi_kan_gem', 'fi_kan_gem_pkey', 'fid')
- ('fi_rect', 'fi_rect_pkey', 'fi_fid')
- ('fliessgewaesser', 'fliessgewaesser_pkey', 'gid')
- ('fliessgewaesser_name', 'fliessgewaesser_name_pkey', 'gid')
- ('fliessgewaesser_schacht', 'fliessgewaesser_schacht_pkey', 'gid')
- ('fz_e5', 'fz_e5_pkey', 'fid')
- ('fz_twa', 'fz_twa_pkey', 'fid')
- ('gewaesserabschnitt', 'gewaesserabschnitt_pkey', 'gid')
- ('gewaessereinzugsgebiet', 'gewaessereinzugsgebiet_pkey', 'gid')
- ('gewaessermetrierung', 'gewaessermetrierung_pkey', 'gid')
- ('gewaessersystem', 'gewaessersystem_pkey', 'gid')
- ('gewaesserverlauf', 'gewaesserverlauf_pkey', 'gid')
- ('haltung', 'haltung_geom_geom_idx', 'geom')
- ('haltung', 'haltung_pkey', 'fid')
- ('haltungspunkt', 'haltungspunkt_geom_geom_idx', 'geom')
- ('haltungspunkt', 'haltungspunkt_pkey', 'fid')
- ('kanal', 'kanal_pkey', 'fid')
- ('normschacht', 'normschacht_pkey', 'fid')
- ('privat', 'privat_pkey', 'fid')
- ('rohrprofil', 'rohrprofil_pkey', 'fid')
- ('spezialbauwerk', 'spezialbauwerk_geom_geom_idx', 'geom')
- ('spezialbauwerk', 'spezialbauwerk_pkey', 'fid')
- ('stat_reach_clear_r', 'stat_reach_clear_r_pkey', 'length_fid')
- ('stat_reach_length', 'stat_reach_length_pkey', 'length_fid')
- ('stehendes_gewaesser', 'stehendes_gewaesser_pkey', 'gid')
- ('zone_a_2016', 'zone_a_2016_pkey', 'ogc_fid')
- ('zone_b_2017', 'zone_b_2017_pkey', 'ogc_fid')
- ('zone_c_2018', 'zone_c_2018_pkey', 'ogc_fid')
- ('zone_d_2019', 'zone_d_2019_pkey', 'ogc_fid')
triggers
+ ('manhole_quarantine', 'after_update_try_outlet_update', "\n  DECLARE\n    le
- ('manhole_quarantine', 'after_update_try_outlet_update', "\n  DECLARE\n    le
+ ('manhole_quarantine', 'after_insert_try_structure_update', "\nDECLARE\n  mul
- ('manhole_quarantine', 'after_insert_try_structure_update', "\nDECLARE\n  mul
- ('reach', 'on_reach_1_delete', "\nDECLARE\n  channel_id text;\n  reach_count 
- ('reach', 'on_reach_2_change', "\nDECLARE\n  rp_obj_ids TEXT[];\n  _ws_obj_id
+ ('reach', 'on_reach_change', "\nDECLARE\n  rp_obj_ids TEXT[];\n  _ws_obj_id T
functions
- ('update_wastewater_structure_label', 'boolean', "  DECLARE\n  myrec record;\
+ ('update_wastewater_structure_label', 'boolean', "\n  DECLARE\n  myrec record
- ('update_wastewater_structure_label', 'text', "  DECLARE\n  myrec record;\n\n
+ ('update_wastewater_structure_label', 'text', "\n  DECLARE\n  myrec record;\n
rules
+ ('qgep_od', 'reach', 'reach_on_delete', 'DELETE')
- ('qgep_od', 'vw_qgep_reach_avm', '_RETURN', 'SELECT')
- ('qgep_od', 'vw_qgep_wastewater_structure_avm', '_RETURN', 'SELECT')