| Idx | Field Name | Data Type |
|---|---|---|
| * | bridge_id | bigint |
| * | address_id | bigint |
| Indexes | ||
| address_to_bridge_pk | ON bridge_id, address_id | |
| address_to_bridge_fkx | ON address_id | |
| address_to_bridge_fkx1 | ON bridge_id | |
| Foreign Keys | ||
| address_to_bridge_fk | address_id ↗ ❏ address(id) | |
| address_to_bridge_fk1 | bridge_id ↗ ❏ bridge(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| bridge_parent_id | bigint | |
| bridge_root_id | bigint | |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| year_of_construction | date | |
| year_of_demolition | date | |
| is_movable | numeric | |
| lod1_terrain_intersection | geometry | |
| lod2_terrain_intersection | geometry | |
| lod3_terrain_intersection | geometry | |
| lod4_terrain_intersection | geometry | |
| lod2_multi_curve | geometry | |
| lod3_multi_curve | geometry | |
| lod4_multi_curve | geometry | |
| lod1_multi_surface_id | bigint | |
| lod2_multi_surface_id | bigint | |
| lod3_multi_surface_id | bigint | |
| lod4_multi_surface_id | bigint | |
| lod1_solid_id | bigint | |
| lod2_solid_id | bigint | |
| lod3_solid_id | bigint | |
| lod4_solid_id | bigint | |
| Indexes | ||
| bridge_pk | ON id | |
| bridge_parent_fkx | ON bridge_parent_id | |
| bridge_root_fkx | ON bridge_root_id | |
| bridge_lod1msrf_fkx | ON lod1_multi_surface_id | |
| bridge_lod2msrf_fkx | ON lod2_multi_surface_id | |
| bridge_lod3msrf_fkx | ON lod3_multi_surface_id | |
| bridge_lod4msrf_fkx | ON lod4_multi_surface_id | |
| bridge_lod1solid_fkx | ON lod1_solid_id | |
| bridge_lod2solid_fkx | ON lod2_solid_id | |
| bridge_lod3solid_fkx | ON lod3_solid_id | |
| bridge_lod4solid_fkx | ON lod4_solid_id | |
| bridge_objectclass_fkx | ON objectclass_id | |
| bridge_lod1terr_spx | ON lod1_terrain_intersection | |
| bridge_lod2terr_spx | ON lod2_terrain_intersection | |
| bridge_lod3terr_spx | ON lod3_terrain_intersection | |
| bridge_lod4terr_spx | ON lod4_terrain_intersection | |
| bridge_lod2curve_spx | ON lod2_multi_curve | |
| bridge_lod3curve_spx | ON lod3_multi_curve | |
| bridge_lod4curve_spx | ON lod4_multi_curve | |
| Foreign Keys | ||
| bridge_parent_fk | bridge_parent_id ↗ ❏ bridge(id) | |
| bridge_root_fk | bridge_root_id ↗ ❏ bridge(id) | |
| bridge_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_lod1msrf_fk | lod1_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod1solid_fk | lod1_solid_id ↗ ❏ surface_geometry(id) | |
| bridge_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod2solid_fk | lod2_solid_id ↗ ❏ surface_geometry(id) | |
| bridge_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod3solid_fk | lod3_solid_id ↗ ❏ surface_geometry(id) | |
| bridge_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| address_to_bridge_fk1 | id ↙ ❏ address_to_bridge(bridge_id) | |
| brd_them_srf_bridge_fk | id ↙ ❏ bridge_thematic_surface(bridge_id) | |
| bridge_constr_bridge_fk | id ↙ ❏ bridge_constr_element(bridge_id) | |
| bridge_inst_bridge_fk | id ↙ ❏ bridge_installation(bridge_id) | |
| bridge_parent_fk | id ↙ ❏ bridge(bridge_parent_id) | |
| bridge_room_bridge_fk | id ↙ ❏ bridge_room(bridge_id) | |
| bridge_root_fk | id ↙ ❏ bridge(bridge_root_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| bridge_id | bigint | |
| lod1_terrain_intersection | geometry | |
| lod2_terrain_intersection | geometry | |
| lod3_terrain_intersection | geometry | |
| lod4_terrain_intersection | geometry | |
| lod1_brep_id | bigint | |
| lod2_brep_id | bigint | |
| lod3_brep_id | bigint | |
| lod4_brep_id | bigint | |
| lod1_other_geom | geometry | |
| lod2_other_geom | geometry | |
| lod3_other_geom | geometry | |
| lod4_other_geom | geometry | |
| lod1_implicit_rep_id | bigint | |
| lod2_implicit_rep_id | bigint | |
| lod3_implicit_rep_id | bigint | |
| lod4_implicit_rep_id | bigint | |
| lod1_implicit_ref_point | geometry | |
| lod2_implicit_ref_point | geometry | |
| lod3_implicit_ref_point | geometry | |
| lod4_implicit_ref_point | geometry | |
| lod1_implicit_transformation | varchar(1000) | |
| lod2_implicit_transformation | varchar(1000) | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| bridge_constr_element_pk | ON id | |
| bridge_constr_bridge_fkx | ON bridge_id | |
| bridge_constr_lod1brep_fkx | ON lod1_brep_id | |
| bridge_constr_lod2brep_fkx | ON lod2_brep_id | |
| bridge_constr_lod3brep_fkx | ON lod3_brep_id | |
| bridge_constr_lod4brep_fkx | ON lod4_brep_id | |
| bridge_constr_lod1impl_fkx | ON lod1_implicit_rep_id | |
| bridge_constr_lod2impl_fkx | ON lod2_implicit_rep_id | |
| bridge_constr_lod3impl_fkx | ON lod3_implicit_rep_id | |
| bridge_constr_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_constr_objclass_fkx | ON objectclass_id | |
| bridge_constr_lod1terr_spx | ON lod1_terrain_intersection | |
| bridge_constr_lod2terr_spx | ON lod2_terrain_intersection | |
| bridge_constr_lod3terr_spx | ON lod3_terrain_intersection | |
| bridge_constr_lod4terr_spx | ON lod4_terrain_intersection | |
| bridge_const_lod1xgeom_spx | ON lod1_other_geom | |
| bridge_const_lod2xgeom_spx | ON lod2_other_geom | |
| bridge_const_lod3xgeom_spx | ON lod3_other_geom | |
| bridge_const_lod4xgeom_spx | ON lod4_other_geom | |
| bridge_const_lod1refpt_spx | ON lod1_implicit_ref_point | |
| bridge_const_lod2refpt_spx | ON lod2_implicit_ref_point | |
| bridge_const_lod3refpt_spx | ON lod3_implicit_ref_point | |
| bridge_const_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_constr_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| bridge_constr_cityobj_fk | id ↗ ❏ cityobject | |
| bridge_constr_lod1impl_fk | lod1_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_constr_lod1brep_fk | lod1_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_constr_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_constr_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_constr_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_them_srf_brd_const_fk | id ↙ ❏ bridge_thematic_surface(bridge_constr_element_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| bridge_room_id | bigint | |
| lod4_brep_id | bigint | |
| lod4_other_geom | geometry | |
| lod4_implicit_rep_id | bigint | |
| lod4_implicit_ref_point | geometry | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| bridge_furniture_pk | ON id | |
| bridge_furn_brd_room_fkx | ON bridge_room_id | |
| bridge_furn_lod4brep_fkx | ON lod4_brep_id | |
| bridge_furn_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_furn_objclass_fkx | ON objectclass_id | |
| bridge_furn_lod4xgeom_spx | ON lod4_other_geom | |
| bridge_furn_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_furn_brd_room_fk | bridge_room_id ↗ ❏ bridge_room(id) | |
| bridge_furn_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_furn_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_furn_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| bridge_id | bigint | |
| bridge_room_id | bigint | |
| lod2_brep_id | bigint | |
| lod3_brep_id | bigint | |
| lod4_brep_id | bigint | |
| lod2_other_geom | geometry | |
| lod3_other_geom | geometry | |
| lod4_other_geom | geometry | |
| lod2_implicit_rep_id | bigint | |
| lod3_implicit_rep_id | bigint | |
| lod4_implicit_rep_id | bigint | |
| lod2_implicit_ref_point | geometry | |
| lod3_implicit_ref_point | geometry | |
| lod4_implicit_ref_point | geometry | |
| lod2_implicit_transformation | varchar(1000) | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| bridge_installation_pk | ON id | |
| bridge_inst_objclass_fkx | ON objectclass_id | |
| bridge_inst_bridge_fkx | ON bridge_id | |
| bridge_inst_brd_room_fkx | ON bridge_room_id | |
| bridge_inst_lod2brep_fkx | ON lod2_brep_id | |
| bridge_inst_lod3brep_fkx | ON lod3_brep_id | |
| bridge_inst_lod4brep_fkx | ON lod4_brep_id | |
| bridge_inst_lod2impl_fkx | ON lod2_implicit_rep_id | |
| bridge_inst_lod3impl_fkx | ON lod3_implicit_rep_id | |
| bridge_inst_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_inst_lod2xgeom_spx | ON lod2_other_geom | |
| bridge_inst_lod3xgeom_spx | ON lod3_other_geom | |
| bridge_inst_lod4xgeom_spx | ON lod4_other_geom | |
| bridge_inst_lod2refpt_spx | ON lod2_implicit_ref_point | |
| bridge_inst_lod3refpt_spx | ON lod3_implicit_ref_point | |
| bridge_inst_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_inst_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| bridge_inst_brd_room_fk | bridge_room_id ↗ ❏ bridge_room(id) | |
| bridge_inst_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_inst_lod2impl_fk | lod2_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_inst_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_inst_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_inst_lod2brep_fk | lod2_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_inst_lod3brep_fk | lod3_brep_id ↗ ❏ surface_geometry(id) | |
| bridge_inst_lod4brep_fk | lod4_brep_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_them_srf_brd_inst_fk | id ↙ ❏ bridge_thematic_surface(bridge_installation_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | bridge_opening_id | bigint |
| * | bridge_thematic_surface_id | bigint |
| Indexes | ||
| bridge_open_to_them_srf_pk | ON bridge_opening_id, bridge_thematic_surface_id | |
| brd_open_to_them_srf_fkx | ON bridge_opening_id | |
| brd_open_to_them_srf_fkx1 | ON bridge_thematic_surface_id | |
| Foreign Keys | ||
| brd_open_to_them_srf_fk | bridge_opening_id ↗ ❏ bridge_opening(id) | |
| brd_open_to_them_srf_fk1 | bridge_thematic_surface_id ↗ ❏ bridge_thematic_surface(id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| address_id | bigint | |
| lod3_multi_surface_id | bigint | |
| lod4_multi_surface_id | bigint | |
| lod3_implicit_rep_id | bigint | |
| lod4_implicit_rep_id | bigint | |
| lod3_implicit_ref_point | geometry | |
| lod4_implicit_ref_point | geometry | |
| lod3_implicit_transformation | varchar(1000) | |
| lod4_implicit_transformation | varchar(1000) | |
| Indexes | ||
| bridge_opening_pk | ON id | |
| bridge_open_objclass_fkx | ON objectclass_id | |
| bridge_open_address_fkx | ON address_id | |
| bridge_open_lod3msrf_fkx | ON lod3_multi_surface_id | |
| bridge_open_lod4msrf_fkx | ON lod4_multi_surface_id | |
| bridge_open_lod3impl_fkx | ON lod3_implicit_rep_id | |
| bridge_open_lod4impl_fkx | ON lod4_implicit_rep_id | |
| bridge_open_lod3refpt_spx | ON lod3_implicit_ref_point | |
| bridge_open_lod4refpt_spx | ON lod4_implicit_ref_point | |
| Foreign Keys | ||
| bridge_open_address_fk | address_id ↗ ❏ address(id) | |
| bridge_open_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_open_lod3impl_fk | lod3_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_open_lod4impl_fk | lod4_implicit_rep_id ↗ ❏ implicit_geometry(id) | |
| bridge_open_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_open_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_open_to_them_srf_fk | id ↙ ❏ bridge_open_to_them_srf(bridge_opening_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| class | varchar(256) | |
| class_codespace | varchar(4000) | |
| function | varchar(1000) | |
| function_codespace | varchar(4000) | |
| usage | varchar(1000) | |
| usage_codespace | varchar(4000) | |
| bridge_id | bigint | |
| lod4_multi_surface_id | bigint | |
| lod4_solid_id | bigint | |
| Indexes | ||
| bridge_room_pk | ON id | |
| bridge_room_bridge_fkx | ON bridge_id | |
| bridge_room_lod4msrf_fkx | ON lod4_multi_surface_id | |
| bridge_room_lod4solid_fkx | ON lod4_solid_id | |
| bridge_room_objclass_fkx | ON objectclass_id | |
| Foreign Keys | ||
| bridge_room_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| bridge_room_cityobject_fk | id ↗ ❏ cityobject | |
| bridge_room_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| bridge_room_lod4solid_fk | lod4_solid_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_them_srf_brd_room_fk | id ↙ ❏ bridge_thematic_surface(bridge_room_id) | |
| bridge_furn_brd_room_fk | id ↙ ❏ bridge_furniture(bridge_room_id) | |
| bridge_inst_brd_room_fk | id ↙ ❏ bridge_installation(bridge_room_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint |
| * | objectclass_id | integer |
| bridge_id | bigint | |
| bridge_room_id | bigint | |
| bridge_installation_id | bigint | |
| bridge_constr_element_id | bigint | |
| lod2_multi_surface_id | bigint | |
| lod3_multi_surface_id | bigint | |
| lod4_multi_surface_id | bigint | |
| Indexes | ||
| bridge_thematic_surface_pk | ON id | |
| brd_them_srf_objclass_fkx | ON objectclass_id | |
| brd_them_srf_bridge_fkx | ON bridge_id | |
| brd_them_srf_brd_room_fkx | ON bridge_room_id | |
| brd_them_srf_brd_inst_fkx | ON bridge_installation_id | |
| brd_them_srf_brd_const_fkx | ON bridge_constr_element_id | |
| brd_them_srf_lod2msrf_fkx | ON lod2_multi_surface_id | |
| brd_them_srf_lod3msrf_fkx | ON lod3_multi_surface_id | |
| brd_them_srf_lod4msrf_fkx | ON lod4_multi_surface_id | |
| Foreign Keys | ||
| brd_them_srf_bridge_fk | bridge_id ↗ ❏ bridge(id) | |
| brd_them_srf_brd_const_fk | bridge_constr_element_id ↗ ❏ bridge_constr_element(id) | |
| brd_them_srf_brd_inst_fk | bridge_installation_id ↗ ❏ bridge_installation(id) | |
| brd_them_srf_brd_room_fk | bridge_room_id ↗ ❏ bridge_room(id) | |
| brd_them_srf_cityobj_fk | id ↗ ❏ cityobject | |
| brd_them_srf_lod2msrf_fk | lod2_multi_surface_id ↗ ❏ surface_geometry(id) | |
| brd_them_srf_lod3msrf_fk | lod3_multi_surface_id ↗ ❏ surface_geometry(id) | |
| brd_them_srf_lod4msrf_fk | lod4_multi_surface_id ↗ ❏ surface_geometry(id) | |
| Referring Foreign Keys | ||
| brd_open_to_them_srf_fk1 | id ↙ ❏ bridge_open_to_them_srf(bridge_thematic_surface_id) | |
| Idx | Field Name | Data Type |
|---|---|---|
| * | id | bigint DEFAULT nextval('cityobject_seq'::regclass) |
| * | objectclass_id | integer |
| gmlid | varchar(256) | |
| gmlid_codespace | varchar(1000) | |
| name | varchar(1000) | |
| name_codespace | varchar(4000) | |
| description | varchar(4000) | |
| envelope | geometry | |
| creation_date | timestamptz | |
| termination_date | timestamptz | |
| relative_to_terrain | varchar(256) | |
| relative_to_water | varchar(256) | |
| last_modification_date | timestamptz | |
| updating_person | varchar(256) | |
| reason_for_update | varchar(4000) | |
| lineage | varchar(256) | |
| xml_source | text | |
| Indexes | ||
| cityobject_pk | ON id | |
| cityobject_inx | ON gmlid, gmlid_codespace | |
| cityobject_objectclass_fkx | ON objectclass_id | |
| cityobject_lineage_inx | ON lineage | |
| cityobj_creation_date_inx | ON creation_date | |
| cityobj_term_date_inx | ON termination_date | |
| cityobj_last_mod_date_inx | ON last_modification_date | |
| cityobject_envelope_spx | ON envelope | |
| Referring Foreign Keys | ||
| appearance_cityobject_fk | id ↙ ❏ appearance(cityobject_id) | |
| bldg_furn_cityobject_fk | id ↙ ❏ building_furniture | |
| bldg_inst_cityobject_fk | id ↙ ❏ building_installation | |
| brd_them_srf_cityobj_fk | id ↙ ❏ bridge_thematic_surface | |
| bridge_cityobject_fk | id ↙ ❏ bridge | |
| bridge_constr_cityobj_fk | id ↙ ❏ bridge_constr_element | |
| bridge_furn_cityobject_fk | id ↙ ❏ bridge_furniture | |
| bridge_inst_cityobject_fk | id ↙ ❏ bridge_installation | |
| bridge_open_cityobject_fk | id ↙ ❏ bridge_opening | |
| bridge_room_cityobject_fk | id ↙ ❏ bridge_room | |
| building_cityobject_fk | id ↙ ❏ building | |
| city_furn_cityobject_fk | id ↙ ❏ city_furniture | |
| cityobject_member_fk | id ↙ ❏ cityobject_member(cityobject_id) | |
| ext_ref_cityobject_fk | id ↙ ❏ external_reference(cityobject_id) | |
| gen_object_cityobject_fk | id ↙ ❏ generic_cityobject | |
| general_cityobject_fk | id ↙ ❏ generalization(cityobject_id) | |
| general_generalizes_to_fk | id ↙ ❏ generalization(generalizes_to_id) | |
| genericattrib_cityobj_fk | id ↙ ❏ cityobject_genericattrib(cityobject_id) | |
| group_cityobject_fk | id ↙ ❏ cityobjectgroup | |
| group_parent_cityobj_fk | id ↙ ❏ cityobjectgroup(parent_cityobject_id) | |
| group_to_cityobject_fk | id ↙ ❏ group_to_cityobject(cityobject_id) | |
| land_use_cityobject_fk | id ↙ ❏ land_use | |
| opening_cityobject_fk | id ↙ ❏ opening | |
| plant_cover_cityobject_fk | id ↙ ❏ plant_cover | |
| relief_comp_cityobject_fk | id ↙ ❏ relief_component | |
| relief_feat_cityobject_fk | id ↙ ❏ relief_feature | |
| room_cityobject_fk | id ↙ ❏ room | |
| sol_veg_obj_cityobject_fk | id ↙ ❏ solitary_vegetat_object | |
| surface_geom_cityobj_fk | id ↙ ❏ surface_geometry(cityobject_id) | |
| them_surface_cityobject_fk | id ↙ ❏ thematic_surface | |
| traffic_area_cityobject_fk | id ↙ ❏ traffic_area | |
| tran_complex_cityobject_fk | id ↙ ❏ transportation_complex | |
| tun_hspace_cityobj_fk | id ↙ ❏ tunnel_hollow_space | |
| tun_them_srf_cityobj_fk | id ↙ ❏ tunnel_thematic_surface | |
| tunnel_cityobject_fk | id ↙ ❏ tunnel | |
| tunnel_furn_cityobject_fk | id ↙ ❏ tunnel_furniture | |
| tunnel_inst_cityobject_fk | id ↙ ❏ tunnel_installation | |
| tunnel_open_cityobject_fk | id ↙ ❏ tunnel_opening | |
| waterbnd_srf_cityobject_fk | id ↙ ❏ waterboundary_surface | |
| waterbody_cityobject_fk | id ↙ ❏ waterbody | |