I have 3 line type vector layers representing municipal infrastructure; sanitary, storm, and water main pipes. Each of these layers should remain separate and all of these layers have different fields, but some common attributes.

I'm trying to create a single atlas that looks at a few of the common attributes between the 3 layers to highlight missing information to present to the client; I don't want to merge the tables to do so or create 3 separate atlases.

I've created a virtual layer that selects the proper information from each table and provides the results in a single table - but unless there's something I'm missing, I cannot include any geometry in the virtual layer, and therefore my atlas doesn't work.

  • can you provide more information, like the SQL statement which defines your virtual layer and the structure of your 3 line layers?
    – eurojam
    Oct 16, 2020 at 5:21
  • Use a virtual layer, see: gis.stackexchange.com/a/409634/88814
    – Babel
    Sep 1, 2021 at 13:44


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.