Cascading select QGIS forms (aka drill down select) | burdGIS

Поделиться
HTML-код
  • Опубликовано: 5 янв 2025

Комментарии • 53

  • @burdGIS
    @burdGIS  4 года назад +1

    Are you just getting started with #GIS and #QGIS? This online course will teach you the basics and then you can come back to the #burdGIS channel to improve your skills! :)
    www.udemy.com/course/an-introduction-to-gis-and-qgis/?referralCode=E39701D884A9EB2B5831

  • @jamespotts5853
    @jamespotts5853 Год назад +1

    Exactly what I was looking for! I've got plans for using this to pull through into automated carbon storage outputs for tree survey layers 😁

    • @burdGIS
      @burdGIS  Год назад

      Glad I could help!

  • @JamesPotts-k2p
    @JamesPotts-k2p Год назад +1

    This has been really helpful but I'm having some trouble applying it to my survey layers. I'm trying to pull a 'cascaded' value through a case statement of an expression in another field but the expression seems to be using the 'primary' value rather than the 'cascaded' one. I know this probably isn't the clearest explanation but hopefully it makes enough sense to provide a couple of a pointer or two :)

    • @burdGIS
      @burdGIS  Год назад +1

      Check this gis stackexchange post for the fix gis.stackexchange.com/questions/370398/value-relation-widget-in-qgis

  • @Grimjow470
    @Grimjow470 Год назад +1

    Hi, thank you for this video, great work. I was wonderful if it’s possible to link those tables directly to the layer so I only need to send the gpkg layer to my coworker without the entire project.
    Thank you !

    • @burdGIS
      @burdGIS  Год назад

      Thanks fo rthe question and the for supporting the channel! :-D It;s possible to save your .qgs or .qgz project file to the gpkg too and to save default styles for every layer there as well. This means you could just fire across the gpkg and everything required would be there. If you're doing this with Mergin Maps I'm not sure how it would handle it as it needs a .qgs or .qgz in the project folder.

  • @ManuelHernandez-sz3rz
    @ManuelHernandez-sz3rz Год назад +1

    Hello, thanks for your excellent video. Just one question... it works for creation of new features but when you try to edit one the filter looks does not work and the drop down menu show all the options. Do you know how to fix it?

    • @burdGIS
      @burdGIS  Год назад

      Check my post on gis stack exchange on this topic.

  • @StuartVenn-b2k
    @StuartVenn-b2k Год назад +1

    Just stumbled across this video, really informative, exactly what I am trying to do, I am having real difficulty working out the homework answer as I am really new to Qgis, is theri a solution video or guidance please.

    • @burdGIS
      @burdGIS  Год назад

      Check the stack exchange post in the comments / description

  • @ernestocarreras7652
    @ernestocarreras7652 2 года назад +1

    Thanks for the excellent video! Just what I was looking for. Can you share your geopackage and CSV tables? Doing something similar with tree/plant inventories.

    • @burdGIS
      @burdGIS  2 года назад +1

      Ernesto! Thanks for the watching. I think these gpkgs and csvs have been consigned to the digital bin in the sky. Check out the GIS SE page for the complete solution ;-) I'm working on a full tree solution with Mergin Maps at the moment which might be of interest too.

    • @ernestocarreras7652
      @ernestocarreras7652 2 года назад +1

      @@burdGIS can you share the link here? I go to you site but I am not sure where exactly it’s located.

    • @burdGIS
      @burdGIS  2 года назад +1

      Sure, here you go gis.stackexchange.com/questions/370398/value-relation-widget-in-qgis

  • @Wildlifeimpulse
    @Wildlifeimpulse 5 лет назад +1

    Another great video. Thanks for sharing your knowledge.

  • @messaoudirabah3878
    @messaoudirabah3878 5 лет назад +1

    Very elegant work, thank you ...

    • @burdGIS
      @burdGIS  5 лет назад +1

      Thanks messaoudi. I hope you find it useful. Feel free to share your implementation

  • @StefanoVerugi
    @StefanoVerugi 5 лет назад +1

    Excellent job, very much appreciated. Thank you

    • @burdGIS
      @burdGIS  5 лет назад

      No problem Stefano. It was a fun one to do and I'm hoping QGISQuick can be developed to integrate this functionality soon. Cascading selects is so useful for field data collection. I've used it before with ODK but Input's handling of lines and polygons seems far better.

  • @pabloantonioolivaresmanzan8589
    @pabloantonioolivaresmanzan8589 7 месяцев назад +1

    Hi, thanks for your video, nice job, it's amazin how QGIS is improving! I have a question: I am trying to do "the same thing" but with several conditions involved. For example, if I have field A with values 1 and 2, field B with values 1, 2, 3, 4, and field C with values 1, 2, 3, 4. If I choose in field A the value 1, in field C I should be able to select only 2, 3, 4. But if then in field B I choose 2, field C should be able to select only 3 and 4. I have many conditions and I need to implement them in the QGIS form so that when adding the information these conditions are respected.
    I hope I have been sufficiently clear

    • @burdGIS
      @burdGIS  7 месяцев назад +1

      Thanks Pablo. I got your email too. I've replied so f you can send me an example of the data I might be able to help you out (or some dummy data if you can't share actual data)

    • @pabloantonioolivaresmanzan8589
      @pabloantonioolivaresmanzan8589 7 месяцев назад

      @@burdGIS thanks, I send you an example!

  • @aliciaavril1865
    @aliciaavril1865 5 месяцев назад +1

    Thanks for this tutorial but I still have a question, could it be possible do a multiple drill down ? As an example, if I take your fields "Code", "Class" and "Habitat" is it possible to program that "Code" filter "Class" and then filter "Habitat" ? Sorry if my question is a bit misexplained I'm French and I'm not sure of my English langage 😅

    • @burdGIS
      @burdGIS  5 месяцев назад

      Yes I think you could. It's the same principle, just cascaded onto other form entries. If you send me a sample of your data I can set one up.

  • @1raskumar
    @1raskumar 2 года назад +1

    Wow.great trick.thank you!

  • @naeemahmed1078
    @naeemahmed1078 4 года назад +1

    Very informative to the point!

    • @burdGIS
      @burdGIS  4 года назад

      Glad it was helpful!

  • @jd6393
    @jd6393 2 года назад +1

    Hi,
    I can’t figure out the homework for this. I’ve followed through well, but can’t quite figure this last bit out on how to populate the JNCC code automatically. Can you help please??

    • @burdGIS
      @burdGIS  2 года назад

      Hi JD, apologies for the late reply. Things are busy here. Feel free to email me if you're still stuck with this

  • @mattsully5949
    @mattsully5949 3 года назад +1

    Great Video. I will be expanding on this in our National Park, Where can I find your examples to this you have used? Thanks very much.

    • @burdGIS
      @burdGIS  3 года назад

      Thanks Matt. I haven't used Input in a live project yet apart from an ecological survey techniques course for Oxford University. I've used ODK in live projects in the past. It'd be great to hear more about how you're using it in the National Park!

  • @nabazgharib
    @nabazgharib 4 года назад +1

    Thanks for this great content,
    and I have a question,
    if I have a layer from PostgreSQL and add a dropdown to a column, would that dropdown be saved in the server?
    I mean if someone else opened that layer, would he/she see the dropdown list??

    • @burdGIS
      @burdGIS  3 года назад

      Hi Nabaz,
      I think this would only persist if they were accessing the layer through the project you had saved with the dropdown. If they started a new project and added the layer the drop down would not exist.

  • @jonathanswart7928
    @jonathanswart7928 4 года назад +1

    Thank you for this useful insight! I have followed the procedure you showed with a geopackage containing point file and two csv tables, that I am aiming to use for field data collection, and it works great when I populate the form, similar to what you show in your video. The problem I am having though is that when I look in the attribute table after I have saved the edits, each entry has defaulted to the first item in the list, no matter which other item I have selected. This means that for each group or class all the selections end up the same. Any ideas what is causing this?

    • @burdGIS
      @burdGIS  4 года назад

      Hmm, difficult to troubleshoot without seeing the project. Are you able to send it over? Http://www.burdgis.com/contact

    • @jonathanswart7928
      @jonathanswart7928 4 года назад +1

      @@burdGIS Sure, will do.

    • @burdGIS
      @burdGIS  4 года назад +1

      Upon further investigation it looks like cascading selects within QGIS aren't working in 3.12 or 3.13. I'll have a look to see if any issues have been raised in the git repos. Lutra consulting have confirmed that cascading selects won't work in input until the Quick library has been updated.

    • @jonathanswart7928
      @jonathanswart7928 4 года назад

      @@burdGIS Thank you for the clarity on this, I look forward to the bug fixes.

    • @burdGIS
      @burdGIS  4 года назад

      Hi Jonathan, I made an error when testing your project. There's a full description of the set up and what I was doing wrong here:
      gis.stackexchange.com/questions/370398/value-relation-widget-in-qgis
      I also learned a thing or two about sharing gpkgs :-)

  • @ThePaullosse
    @ThePaullosse 4 года назад +1

    This is really useful - and what I've been trying to work out how to do with exactly the same data. However I'm struggling with your 'homework' i.e. how to populate 'code' automatically. Any chance you could go through this?

    • @burdGIS
      @burdGIS  4 года назад +2

      Thanks Paul. I'm releasing an update of this video soon as there's an error iin this one. I'll included homework answer ;-)

    • @ThePaullosse
      @ThePaullosse 4 года назад +1

      @@burdGIS Thanks. I did finally manage to work it out.

    • @joeljambalos4982
      @joeljambalos4982 3 года назад

      @@ThePaullosse Hi! May I know how did you populate it automatically? I'm having a bit of trouble transferring it to other qgis projects since I have to populate it manually and place the delimited layers on the working layers again

    • @jefwesb
      @jefwesb 3 года назад

      @@burdGIS Hi, is the video out? I am struggling with the homework too :/

    • @jarekjakub
      @jarekjakub 3 года назад

      @@ThePaullosse Hi, Can you please explaing how did you make it work?

  • @vierminus
    @vierminus 4 года назад +1

    Useful, thank you!

    • @burdGIS
      @burdGIS  4 года назад

      Happy to help marius 😀