Lost Mapper
Lost Mapper
  • Видео 26
  • Просмотров 15 029
Running PostGIS with Docker on Windows, Mac & Linux
Learn how to run #postgis on Windows, Mac and Linux using #docker & Docker Compose, then connect with #qgis to create tables and layers!
0:00 - Intro
0:22 - What is Docker?
0:52 - Installing Docker
1:21 - Docker Compose Configuration
4:42 - Starting PostGIS with Docker Compose
5:38 - Connecting to PostGIS from QGIS
7:08 - Hiding ID Fields
7:48 - Stopping PostGIS with Docker Compose
8:40 - Outro
- www.docker.com
- github.com/postgis/docker-postgis
- wiki.osgeo.org/wiki/DockerImages
- github.com/lostmapper/postgis-dockerized
---
Buy me a Coffee: ko-fi.com/lostmapper
Mastodon: mapstodon.space/@lostmapper
Web site: lostmapper.com
Email: brian@lostmapper.com
Просмотров: 770

Видео

Getting Started with PostGIS in QGIS on Windows
Просмотров 462Год назад
In this video we''ll use EnterpriseDB and StackBuilder to get you up and running with #PostGIS on Windows. Then we'll connect to PostGIS from QGIS and make a table! 0:00 - Intro 0:18 - Installing PostgreSQL 1:38 - Enabling PostGIS with StackBuilder 3:05 - Creating a Database User 4:40 - Connecting to PostGIS from QGIS 6:40 - Connecting to PostGIS with pgAdmin - www.enterprisedb.com Buy me a Cof...
Getting Started with PostGIS in QGIS on macOS
Просмотров 600Год назад
This video will get you up and running with #PostGIS in #QGIS. I show you how to install a convenient version of PostGIS, connect to it through QGIS, create tables and import data from a #Shapefile. 0:00 - Intro 0:25 - What is PostGIS? 0:48 - Installing Postgres.app 2:27 - Enabling PostGIS Extensions in PostgreSQL 4:17 - Connecting to PostGIS from QGIS 5:02 - Creating Schemas and Tables in Post...
30 Day Map Challenge 2023: Day 15 - OpenStreetMap
Просмотров 207Год назад
We’re working with OpenStreetmap for Day 15 of the #30daymapchallenge. We’ll learn how to use the QuickOSM plugin for #QGIS to download data and then style that data similarly to the OpenStreetMap tiles. Happy #GISDay!
30 Day Map Challenge 2023: Day 13 - Choropleth
Просмотров 166Год назад
For Day 13 - Choropleth I take the map we made on Day 3 - Polygons and improve it using advice from the book "Making Maps". #30daymapchallenge - 30daymapchallenge.com/ - www.guilford.com/books/Making-Maps/Krygier-Wood/9781462509980 Buy me a Coffee: ko-fi.com/lostmapper Mastodon: mapstodon.space/@lostmapper Web site: lostmapper.com Email: brian@lostmapper.com
30 Day Map Challenge 2023: Day 12 - South America
Просмотров 254Год назад
It's #30daymapchallenge Day 12 - South America and we're making a map of the continent using the flags of each country. France also makes an appearance. - 30daymapchallenge.com/ - www.naturalearthdata.com - en.wikipedia.org/wiki/South_America - en.wikipedia.org/wiki/French_Guiana Buy me a Coffee: ko-fi.com/lostmapper Mastodon: mapstodon.space/@lostmapper Web site: lostmapper.com Email: brian@lo...
30 Day Map Challenge 2023: Day 11 - Retro
Просмотров 144Год назад
It's Day 11 of #30daymapchallenge and the theme is "Retro". In this video I show you how to make a map like the ones featured in the 80s classic "WarGames" using #QGIS. That means lots of glowing lines, simple geometric symbols, console fonts and secret military data! Or maybe just public military data... - 30daymapchallenge.com/ - ruclips.net/video/ijVEvzTzlNo/видео.html - www.naturalearthdata...
30 Day Map Challenge 2023: Day 10 - North America (Livestream)
Просмотров 123Год назад
Today I livestreamed on Windows! I used #QGIS to create a map of the countries & sovereignties that make up the Caribbean Sea. Lots of data filtering, labels using expressions, customized callouts, layout struggles and pronunciation learning in this one. #30daymapchallenge - 30daymapchallenge.com/ - www.naturalearthdata.com Buy me a Coffee: ko-fi.com/lostmapper Mastodon: mapstodon.space/@lostma...
30 Day Map Challenge 2023: Day 9 - Hexagon
Просмотров 181Год назад
For Day 9 of #30daymapchallenge we're collecting point data into a hexagon grid and styling it based on the number points using #qgis. - 30daymapchallenge.com/ - www.naturalearthdata.com Buy me a Coffee: ko-fi.com/lostmapper Mastodon: mapstodon.space/@lostmapper Web site: lostmapper.com Email: brian@lostmapper.com
30 Day Map Challenge 2023: Day 8 - Africa
Просмотров 123Год назад
Learn how to use Balloon Callouts and synchronize Symbology/Label coloring in #QGIS. That’s right - it’s Day 8 of #30daymapchallenge and we’re mapping western African countries for fun and learning! - 30daymapchallenge.com/ - www.naturalearthdata.com Buy me a Coffee: ko-fi.com/lostmapper Mastodon: mapstodon.space/@lostmapper Web site: lostmapper.com Email: brian@lostmapper.com
30 Day Map Challenge 2023: Day 7 - Navigation
Просмотров 139Год назад
For #30daymapchallenge Day 7 (Navigation) I’m revisiting adding images to Labels and make a map of businesses in my town. This time I use a Geometry Generator for better positioning control and the Blob type to store images as Feature Attributes. #QGIS for the win! - 30daymapchallenge.com/ - www.mentonealabama.gov - Mentone Inn Photo by Brad Lackey: www.lookoutphoto.com - gis.stackexchange.com/...
30 Day Map Challenge 2023: Day 6 - Asia
Просмотров 124Год назад
Let's make a map of the 10 most populated places in Asia using Natural Earth data for Day 6 of the #30daymapchallenge. We'll duplicate layers and style them differently, filter data, dissolve a bunch of countries together for a nice shadow and make a full size layout to top it all off - all in #QGIS! - 30daymapchallenge.com/ - www.naturalearthdata.com Buy me a Coffee: ko-fi.com/lostmapper Masto...
30 Day Map Challenge 2023: Day 5 - Analog
Просмотров 114Год назад
I take an alternate definition of the word "analog" and make a map of the real world locations found in the game #Fallout76 for #30daymapchallenge. I use an Expression to get a two-line label and a Raster Image Marker to put screenshots of the game next to those labels. - 30daymapchallenge.com/ - wvtourism.com/insiders-guide-to-real-world-wv-locations-in-fallout-76/ - www.weather.gov/gis/USStat...
30 Day Map Challenge 2023: Day 4 - A Bad Map
Просмотров 149Год назад
In this video I use a lot of drop shadows and fight the urge to make improvements to a map. It's Day 4 of the #30daymapchallenge - make a bad map! - 30daymapchallenge.com/ - en.wikipedia.org/wiki/Big_Audio_Dynamite Buy me a Coffee: ko-fi.com/lostmapper Mastodon: mapstodon.space/@lostmapper Web site: lostmapper.com Email: brian@lostmapper.com
30 Day Map Challenge 2023: Day 3 - Polygons
Просмотров 178Год назад
The theme for Day 3 of the #30daymapchallenge is Polygons! In this video I show you how to make a map of postal codes and use Graduated Symbology to represent their attributes. - 30daymapchallenge.com/ - data-algeohub.opendata.arcgis.com/search?groupIds=f9d89eb1c7c64ed39ab92c2e541369c4&type=feature layer Buy me a Coffee: ko-fi.com/lostmapper Mastodon: mapstodon.space/@lostmapper Web site: lostm...
30 Day Map Challenge 2023: Day 2 - Lines
Просмотров 226Год назад
30 Day Map Challenge 2023: Day 2 - Lines
30 Day Map Challenge 2023: Day 1 - Points
Просмотров 782Год назад
30 Day Map Challenge 2023: Day 1 - Points
3 Ways to Convert Singlepart Layers to Multipart Layers in QGIS
Просмотров 1,6 тыс.Год назад
3 Ways to Convert Singlepart Layers to Multipart Layers in QGIS
Working with Multipart Features in QGIS
Просмотров 915Год назад
Working with Multipart Features in QGIS
Working with Polygon Layers in QGIS
Просмотров 620Год назад
Working with Polygon Layers in QGIS
Working with Line Layers in QGIS
Просмотров 438Год назад
Working with Line Layers in QGIS
Working with Point Layers in QGIS
Просмотров 484Год назад
Working with Point Layers in QGIS
Working with GPX Files in QGIS - Part 2
Просмотров 1,1 тыс.Год назад
Working with GPX Files in QGIS - Part 2
Working with GPX Files in QGIS - Part 1
Просмотров 2,5 тыс.Год назад
Working with GPX Files in QGIS - Part 1
Adding Google Maps to QGIS
Просмотров 2,2 тыс.Год назад
Adding Google Maps to QGIS
Getting Started with QGIS
Просмотров 496Год назад
Getting Started with QGIS

Комментарии

  • @nicoxas6608
    @nicoxas6608 19 часов назад

    Thanks you so much! this will be useful to my thesis :D

  • @pablojimenez5736
    @pablojimenez5736 6 дней назад

    Can you explain how to obtain topographic curves from google earth site, doing paths, then importing into QGIS as a gpx file? I am not expert in maps and I would like to have the curves to work in other design terrain modelling software's

  • @GomadaTube
    @GomadaTube 24 дня назад

    excellent

  • @chrisford2906
    @chrisford2906 Месяц назад

    Excellent - a level of QGIS I've not understood before. Thanks. Took me a time to replicate your num_geometries calculation in the expression tool. The screen isn't clear.

    • @lostmapper
      @lostmapper Месяц назад

      Ah, sorry about that! I probably should've magnified that portion of the video or put the formula in the video description.

  • @konakfotogrametri2082
    @konakfotogrametri2082 2 месяца назад

    dude you are a great guy. You are the person who explained the QGIS program best so far. You explain it very carefully. thank you very much

    • @lostmapper
      @lostmapper Месяц назад

      Thank you so much for the comment - it means a lot!

  • @ManishBam
    @ManishBam 2 месяца назад

    Thanks man, it's helping me even in 2024.

    • @lostmapper
      @lostmapper 2 месяца назад

      Glad they're continuing to help! I wish I could partake this year but I've got a full-time GIS-adjacent position keeping me busy (and paid!)

  • @ManishBam
    @ManishBam 2 месяца назад

    Thanks man, helped me a lot

  • @lighttotheNEEDS
    @lighttotheNEEDS 2 месяца назад

    Thank you so much

    • @lostmapper
      @lostmapper 2 месяца назад

      You're very welcome!

  • @ManishBam
    @ManishBam 2 месяца назад

    Loving the series

  • @ManishBam
    @ManishBam 3 месяца назад

    Appreciate the efforts.

    • @lostmapper
      @lostmapper 2 месяца назад

      Thanks for watching!

  • @ManishBam
    @ManishBam 3 месяца назад

    Great video. P.s. I ran into a problem while following the video tutorial-I couldn’t move the labels, even after setting 'label x' and 'label y' for the x and y placements. So, I decided to try using ‘Name' as a feature ID instead, and that did the trick! If anyone else is stuck on this, give it a shot-might work for you too.

    • @lostmapper
      @lostmapper 2 месяца назад

      That's a great solution - thanks for sharing!

  • @ManishBam
    @ManishBam 3 месяца назад

    Thanks sir

  • @ManishBam
    @ManishBam 3 месяца назад

    amazing

  • @ManishBam
    @ManishBam 3 месяца назад

    Thank you

  • @BrandonNaupa-x8m
    @BrandonNaupa-x8m 6 месяцев назад

    Actually i did not found the URL

    • @lostmapper
      @lostmapper 6 месяцев назад

      Which URL are you talking about? Did you check the video details?

  • @stephenlee8275
    @stephenlee8275 6 месяцев назад

    How to magnify the text or labels size of google map? It's too small

    • @lostmapper
      @lostmapper 6 месяцев назад

      Google Maps are served as tiles of images, so there's no way to increase their font size. Check out my video on OpenStreetMap to get an idea of how you can change the style of an OSM vector layer: ruclips.net/video/C-nvk10xXM8/видео.html

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

    Thank you a lot for your precise work! :)

  • @Archiblog
    @Archiblog 9 месяцев назад

    Thank you for this, Lost Mapper! I appreciate the work you've put in to make this task so easy!

    • @lostmapper
      @lostmapper 8 месяцев назад

      Thank you so much!

  • @joancobenacevallos
    @joancobenacevallos 10 месяцев назад

    Hola estimado, podrias hacer un tutorial de como instalar el postgis shapefile manager en macOS o como agregar varias capas, ya que el ejemplo que muestras es solo con una. Gracias de antemano.

  • @evanlee6546
    @evanlee6546 10 месяцев назад

    Thank you! I also tried adding the Google Maps raster through XYZ tiles via the URL but nothing showed. But yours worked. Not sure why??

    • @lostmapper
      @lostmapper 9 месяцев назад

      Are you talking about the URL for lostmapper.com/qgis-xyz-tiles/? Did you make sure to click Select All when importing them?

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

    Amazing content

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

      Thank you so much!

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

      @@lostmapper One question: If I have a polygon layer which represents let’s say the state of New York, and I have another polygon layer which represents the borough of Brooklyn in New York. How can I make a ring/hole erasing the Brooklyn part in the New York layer? Hope that makes sense. Thanks!

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

      Hey. Sorry for the delay. I thought I already responded to this but I guess it didn't go through. You likely want to use Vector > Geoprocessing Tools > Difference to "subtract" the Brooklyn layer from the New York layer.

  • @DavidReynolds-that_dad
    @DavidReynolds-that_dad Год назад

    I just want to say, these videos have been incredibly helpful to me on my journey to learn how to use this software. Thank you very much!

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

      I'm so glad they've been helping you out. And comments like these are really helpful to me!

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

    BTW I am trying to edit a layer on QGIS in order to amend a land boundary polygon within another polygon (within the same shape file) what is the best way to do this accurately? Thanks in advance

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

      Can you share some more information/image about what you're trying to do? What is the amendment? Feel free to hit me up on Mastodon if you have an image to share: mapstodon.space/@lostmapper

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

    Good vid

  • @zizou_5757.
    @zizou_5757. Год назад

    il est de retour

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

    Is that a full-blown Postgres database with POSTGIS already enabled or is that ONLY postgis ... stupid question I know, but I want to be sure nothing is lacking here. Many thanks for the video BTW

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

      You can't have PostGIS without PostgreSQL - PostGIS is an extension for PostgreSQL. So yes, it's a full blown Postgres database with PostGIS extensions enabled.

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

    nice intro - glad you included creating a role. good advice :-)

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

      Thank you! I figured it was good for security reasons and also for keeping things consistent between the macOS and Windows setups.

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

    Thanks for sharing, beautiful video.

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

    Useful ! Thanks

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

      Glad you found it useful!

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

    Much appreciated, Brian!

  • @zizou_5757.
    @zizou_5757. Год назад

    thank you brian interesting video subscriber and liked the video for more readability

  • @juanpablobigordag.1537
    @juanpablobigordag.1537 Год назад

    TIL about the qNote plugin. Instantly installed it. TY!

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

      I’m glad you found it useful!

  • @zizou_5757.
    @zizou_5757. Год назад

    Encore une fois merci beaucoup ❤

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

    :D I only learned while I studied in Rio de Janeiro that the longest border France has with any other country was with Brazil, through French Guyane (pronounced ~"gwi-yann"). Another fun looking map!

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

      I ended up reading about the border on Wikipedia after this debacle today :-)

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

      :D It's definitely not in Europe, unless the title of the column is "Continent of the colonial power holding that territory". 😅

  • @juanpablobigordag.1537
    @juanpablobigordag.1537 Год назад

    Now I want to fly an Airwolf...

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

      I never played Airwolf but I did play a game called... Skyfox :-D

  • @zizou_5757.
    @zizou_5757. Год назад

    merci

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

    Things that had never occurred to me before watching: the idea of having an image label (blob fields are so cool!), and the sheer genius of rotating the whole map to enhance your emphasis on select businesses. Thanks for sharing!

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

      "Genius" you say? I like your perspective on my laziness! I just wanted an easy way for the labels and images to line up nicely next to the road :-)

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

    Danger Mouse!

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

      I loved that cartoon as a kid. Watched it on Nickelodeon all the time. I used to have a framed poster like this shirt but I have no idea where it got to.

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

    You are doing great sir, keep going. Love from Nepal.

  • @zizou_5757.
    @zizou_5757. Год назад

    impressionnant

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

      Thank you, I appreciate it!

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

    This is super cool! Watching someone who really knows their way around QGIS is wildly helpful; thanks for sharing!

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

      Thank you! Please let me know if there's anything else you'd like to see explained in QGIS.

  • @zizou_5757.
    @zizou_5757. Год назад

    tres claire

  • @zizou_5757.
    @zizou_5757. Год назад

    merci

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

    assets.wfcdn.com/im/97062273/resize-h445%5Ecompr-r85/2137/213729322/Bees+Work+On+Honeycomb+On+Canvas+by+Smaglov+Print.jpg

  • @zizou_5757.
    @zizou_5757. Год назад

    Hello Brian, I would like to thank you again for your availability to share your knowledge with us. Yes, I really appreciate this video full of lessons that I never received. I agree that you are a good and excellent teacher. I always stay connected to your channel and let myself be guided by you. Yes I see that you in the USA did not speak French there. I write in Fr and translate into ANG using Google. I am impatiently waiting in your videos for a course dedicated to Senegal, it would be a pleasure. THANKS

  • @zizou_5757.
    @zizou_5757. Год назад

    merci encore une foie et contant de voir mon pays le Sénégal dans la carte

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

      J'ai pensé que tu pourrais apprécier ça ! J'espère que le thème de la carte n'était pas insensible. De plus, je ne parle pas français - j'ai demandé à Google de traduire cela pour moi.

  • @zizou_5757.
    @zizou_5757. Год назад

    Good day sir, I am writing to you from Senegal, I am very happy with you, I do not have the words to thank you. I find your videos very interesting, even I won't hide it from you, you have taught me a lot of things that I never saw at school or also from my work colleagues. I am grateful to you, very grateful indeed Today I spent all my time watching all of your videos, you explain things in a very clear way. I have a love for GIS I am passionate, please never stop your videos continue to surprise us gave courses it is thanks to you that I know hidden things. May the good Lord keep you and give you health and many things to you!

  • @zizou_5757.
    @zizou_5757. Год назад

    merci pour la video

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

    Thank you very much for the video, it was very interesting to follow the development - from the first motivation to the (almost finished) map.

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

      Thank you so much for your feedback - I'm glad you found it interesting! Somebody helped me figure out a better way to manage the labeled images so I'm hoping to return to this project and make another video showing its completion, ideally a little more streamlined.

    • @zizou_5757.
      @zizou_5757. Год назад

      I'm impatiently waiting for this video, I have to do it but I can't, I don't know why@@lostmapper

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

      ​@@zizou_5757. You can get the non-video answer here: gis.stackexchange.com/questions/469661/setting-a-layers-raster-image-marker-x-y-location-based-on-the-x-y-coordinates/469664

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

      @@zizou_5757. FYI, I use one of these better label/image techniques in my Day 7 - Navigation video from today: ruclips.net/video/h64B2T3z77g/видео.html