Geopackages and SQL in QGIS | burdGIS

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 20

  • @RobinFoxie
    @RobinFoxie Рік тому +2

    Excellent, helpful content - and really appreciate the straightforward and efficient video with no intros or animations!

    • @burdGIS
      @burdGIS  Рік тому

      Thanks Oscar. I used to include all the intro etc but I think for instructional vids just better to get straight to it

  • @Ronniegti
    @Ronniegti 6 місяців тому +1

    the final query isn't shown on the screen

    • @burdGIS
      @burdGIS  6 місяців тому +1

      Thanks for watching. You're not the first to notice this :-) From the description...
      ALSO... at 7:50 I messed up the zoom and pan so the code is out of view. You can download it here docs.google.com/document/d/1k7mQX5EFT4FUQv9UtTAWHhbiymsIimjPN1lgdqB_BUo/edit?usp=sharing

  • @StefanoVerugi
    @StefanoVerugi Рік тому +1

    Hi @budrGIS
    please do you know if a SQL'd layer can be saved in the GeoPackage along with its script? like with virtual layer for instance
    at the moment I can only save it (preserving the SQL to create it) in the project file,which is saved in the GeoPackage
    thanks

    • @burdGIS
      @burdGIS  Рік тому +1

      Hmm good question. I don't know. Did you get any further with this? You can always export the data but the script wouldn't be preserved

    • @StefanoVerugi
      @StefanoVerugi Рік тому +1

      @@burdGIS not really, the way around so far is creating a virtual layer with the SQL, since the QGZ file is saved in the GeoPackage the VL is saved too. cheers

  • @John_K.A
    @John_K.A Рік тому +1

    Hello, very informative video. I am completely new to QGIS and therefore have a question and I will be glad if you will be nice to support.
    I have connected an access DB with ODBC to QGIS. But the coordinate systems in the database are Gauss-Krüger coordinate system format. The mapped points therefore do not show up and not read into the maps at all. Can you guide me with how best to make the points readable in QGIS. Thanks in advance

    • @burdGIS
      @burdGIS  Рік тому

      What is the EPSG code for the Gauss-kruger coordinate reference system? Also is this a spatial database or is it just a table with coordinate columns in it? If it's the latter you'll need to convert that table to have geometry.

  • @StefanoVerugi
    @StefanoVerugi Рік тому +3

    SQL & spatialite are very powerful tools, along with virtual layers + DB Manager I find them easier to use than processing tools
    thanks for posting
    PS from 7:50 the screen is cut off and what you type is not visible 🙂

    • @burdGIS
      @burdGIS  Рік тому

      Thanks Stefano. And yikes! I'll look into fixes for the 7:50 blunder

    • @burdGIS
      @burdGIS  Рік тому

      Hmm, it looks like UA-cam no longer allow you to edit and overlay text on a video

  • @humbertonicolasdimitrius1935
    @humbertonicolasdimitrius1935 5 місяців тому +1

    Such a magnificent video! Thank you very much for sharing!

    • @burdGIS
      @burdGIS  4 місяці тому

      Glad you liked it :-)

  • @TheDuke1231
    @TheDuke1231 Рік тому +1

    Trigger functions in a geopackage are quite fun, maybe cover that next? I suppose you can create a lot of similar functions in attribute widgets though 🤔

    • @burdGIS
      @burdGIS  Рік тому +1

      Oooh very good suggestion. Thanks Phil.

  • @philcadorette1383
    @philcadorette1383 Рік тому +1

    Great video, appreciate the time you put in making this content !

    • @burdGIS
      @burdGIS  Рік тому

      Thanks phil. I appreciate you watching them! 🙂 I hope they inspire your mapping