- 14
- 67 009
Geospatial Programming
เข้าร่วมเมื่อ 2 ม.ค. 2022
Creating a web mapping application - Prototyping for your app
In this series we'll be creating a web application for maps. This video covers prototyping new ideas for your web app, including accessing and transforming data in the same way your app itself does.
Code/notebook can be found here:
github.com/GeospatialProgramming/Flask-Map-Application/blob/main/Video3/Prototyping.ipynb
Subset of data here:
drive.google.com/file/d/1ANznYZ4YgtHMJb-MleLRIFtxlmPrmTIg/view?usp=sharing
Airport laydown can be found here: drive.google.com/file/d/1zpBjIUTGYaEMGPhIiJL55KTgIUqhEigx/view?usp=sharing
Code/notebook can be found here:
github.com/GeospatialProgramming/Flask-Map-Application/blob/main/Video3/Prototyping.ipynb
Subset of data here:
drive.google.com/file/d/1ANznYZ4YgtHMJb-MleLRIFtxlmPrmTIg/view?usp=sharing
Airport laydown can be found here: drive.google.com/file/d/1zpBjIUTGYaEMGPhIiJL55KTgIUqhEigx/view?usp=sharing
มุมมอง: 1 007
วีดีโอ
Creating a web mapping application - Flask and Maplibre (#4)
มุมมอง 1.8Kปีที่แล้ว
In this series we'll be creating a web application for maps. This video covers getting data from the database using flask, and passing that information to the frontend to be displayed. We'll be using all open source tools, including Flask, Maplibre, Postgres/Postgis, and pg_tileserv The code for this video can be found here: github.com/GeospatialProgramming/Flask-Map-Application/tree/main/Video...
Creating a web mapping application - Maplibre and pg_tileserv (#3)
มุมมอง 4.9Kปีที่แล้ว
In this third video in our web mapping app series, we spool up an instance of pg_tileserv and point it to our PostGIS instance. We add that new endpoint to our Maplibre map, and add popups when a user hovers over the vector data. Installing Postgres/Postgis with docker: th-cam.com/video/h-Cr5Ana0GA/w-d-xo.html Adding data to Postgres: th-cam.com/video/vu8XfNDWOvI/w-d-xo.html Link to this code: ...
Creating a web mapping application - Flask and Maplibre (#2)
มุมมอง 3.3K2 ปีที่แล้ว
In this series we'll be creating a web application for maps. This video covers creating the initial flask route and adding a basic maplibre map to a web page. We'll be using all open source tools, including Flask, Maplibre, Postgres/Postgis, and pg_tileserv The code for this video can be found here: github.com/GeospatialProgramming/Flask-Map-Application/tree/main/Video1 The maplibre example pag...
Creating a web mapping application (#1)
มุมมอง 1.9K2 ปีที่แล้ว
In this series we'll be creating a web application for maps. This video covers the general design at a high level to better understand how the pieces work together. The audio is on the quiet side, that will be fixed in future videos. We'll be using all open source tools, including Flask, Maplibre, Postgres/Postgis, and pg_tileserv
Unstructured Text to Shapefile using Regex and Geopandas
มุมมอง 3712 ปีที่แล้ว
We take word documents with dates, times, and coordinates, and create a point shapefile using regular expressions and geopandas. Please comment with any questions or suggestions! Code can be found here: github.com/GeospatialProgramming/Geopandas/blob/main/RegularExpressions/DocxToShp.ipynb More in-depth reading on regular expressions: automatetheboringstuff.com/2e/chapter7/ Whitespace, provider...
Exploring Moving Pandas
มุมมอง 2.8K2 ปีที่แล้ว
In this video we use simulated GPS data from Whitespace to identify possible crimes committed by a suspect using the Moving Pandas library. I apologize for the keyboard noise, I didn't realize it wasn't well isolated. Whitespace: inthewhitespace.com/ Moving Pandas: anitagraser.github.io/movingpandas/ Github Link: github.com/GeospatialProgramming/Geopandas/blob/main/MovingPandas/Moving Pandas.ipynb
Geoalchemy2 and PostGIS - Introduction to Object Relational Mapping
มุมมอง 2.5K2 ปีที่แล้ว
We start with a shallow dive into what Object Relational Mapping (ORM) is, and give a few examples on using th2 SQLAchemy and GeoAlchemy2 python libraries. We stick with using the FlightRadar24 data for these examples. The notebook created in this video can be found here: github.com/GeospatialProgramming/PostGIS/blob/main/GeoAlchemy2/GeoAlchemy2.ipynb Information about the spatial functions in ...
Querying PostGIS with GeoPandas
มุมมอง 2.3K2 ปีที่แล้ว
This video discusses how to get data out of PostGIS and into GeoPandas. Code written in this video can be found here: github.com/GeospatialProgramming/PostGIS/blob/main/Querying Postgis/QueryingData.ipynb GeoPandas from_postgis() function documentation geopandas.org/en/stable/docs/reference/api/geopandas.GeoDataFrame.from_postgis.html List of PostGIS functions for reference: postgis.net/docs/ma...
Inserting Data into PostGIS
มุมมอง 3K2 ปีที่แล้ว
We cover inserting data into PostGIS using GeoPandas and GDAL's ogr2ogr. Please feel free to ask questions about anything that wasn't clear, or you'd like to see more of! Code from the video can be found here: github.com/GeospatialProgramming/PostGIS/blob/main/Inserting Data into Postgis/Inserting Data.ipynb The data used is from Flight Radar 24: www.flightradar24.com/ The data was pulled using...
Installing PostGIS with Docker
มุมมอง 5K2 ปีที่แล้ว
Installing a local version of PostGIS and PGAdmin using docker Calls used in this video: docker network create postgresnet docker run -d name postgis network=”postgresnet” -e POSTGRES_PASSWORD=fr24Password -e POSTGRES_DB=flightradar -p 5432:5432 postgis/postgis docker run -d -p 8080:80 network=”postgresnet” -e PGADMIN_DEFAULT_EMAIL=admin@gmail.com -e PGADMIN_DEFAULT_PASSWORD=pgadmin_password dp...
Spatial Databases, and PostGIS
มุมมอง 1.3K2 ปีที่แล้ว
In this first video of our "Intro to PostGIS" we talk about why PostGIS, and discuss a few other spatial databases and when you might choose them. Wikipedia's list of Spatial Databases: en.wikipedia.org/wiki/Spatial_database#Spatial_database_management_systems MongoDB: www.mongodb.com/ Redis: redis.io/ Elasticsearch: www.elastic.co/ Neo4J: neo4j.com/ Spatialite: www.gaia-gis.it/fossil/libspatia...
Using Folium with GeoPandas
มุมมอง 19K2 ปีที่แล้ว
Being able to quickly visualize your data as you work, as well as publish your results for others to see, interact with, and understand is important for any data scientist. In this video we cover creating dynamic maps with Folium. Github content: There are three notebooks, as well as the source data github.com/GeospatialProgramming/Geopandas/tree/main/GeoPandas and Folium Folium Documentation: ...
Intro to GeoPandas
มุมมอง 18K2 ปีที่แล้ว
This is an introductory video to working with GeoPandas, using data pulled from Washing DC's Open Data page. We'll combine neighborhood polygons with construction permit point data to get permits per neighborhood per year, and create plots and maps with our results. Notebook in Github: github.com/GeospatialProgramming/Geopandas/blob/main/Intro to Geopandas/DC Construction.ipynb Links about proj...
I dont see the table I need when I initiate my pg_tileserv. The table does exist in my postgis db. What should I do?
Hello, Thank you for the video. Do you provide consulting/development?
I tried it with a different dataset and get a ValueError: geometry (geometry(MULTIPOLYGON,4326)) not a string when doing the to_postgis. Does anyone have an idea why?
What advantages does hosting PG Admin on Docker have compared to just having PG Admin locally on my machine? Following the tutorial for the web application in conjunction with these, would it be possible to have PG Admin locally and have the app call to that database?
Using docker lets you migrate this environment anywhere - it also lets you have this software without having to manage it locally. This would absolutely work installing postgres and pgadmin locally rather than in docker.
Thank you so much! This video was really helpful. Besides, it's good to ogr2ogr in action. It seems more adapted to geospatial data ingestion into postgis than using geopandas.to_postgis method at scale
Hey, this is a nice project! Your videos are really good :D
just check those " " for the 'pgnet' syntax. Thank you for the video.
Great thanks , you helped me a lot
Hi Geospatial Programming! I have been following your work! Thank you so much for the tutorials they are awesome! You said to leave a comment if we ran into trouble, and I am stuck at the preview view from localhost:7800/ once the pg_tileserv server is running. My instance sees the geo data in my db, but when I go to Table Layers --> preview, my browser says unable to connect. Same thing happens when trying to preview the json response. Pg_tileserv generates no errors in the terminal. Thank you so much!
Does anyone have the link to the actual dataset? Thank you!!
The notebook in github has links right at the top to all the datasets: github.com/GeospatialProgramming/Geopandas/blob/main/Intro%20to%20Geopandas/DC%20Construction.ipynb
Thank you!!! @@geospatial_programming
Sorry for the weird audio blip in the middle, exported it a few times and it hung out.
Can you share the dataset that you are using in Postgis? You were speaking somewhere about a video showing how to get the data, but cannot find it. Btw awesome video's 🎉🔥
Nice job. I dont use flask too often but pg_tileserv with maplibre is my go to. Do you do any react + maplibre?
Hey, is it possible to follow you on LinkedIn or other social media?
Awesome videos, thank you!! Would love to see #4 :)
Thanks for this tutorial
Very nice, thank you. May I suggest a time series heatmap and/or choropleth? That would be very neat.
did you just say 'in portfolium' ?!?
bud, your text is too small. way to small, you have a whole screen you are not using
Genial!
Excellent. Thanks for the videos!
Great explanation and example, thanks!
How to fix this error docker: Error response from daemon: network ”pgnet” not found.
the network should get created when you spool up the image - if it doesn't for whatever reason, see if you can create it using "docker network create pgnet"
Please I do get Esri shapefile
Hey, thanks for good videos! Do you know of any other similar dataset that is easy accesible to test what you are doing in the videos? I have been able to setup everything, but haven't had the time or the knowledge to retrieve the Flight data you been able to retrieve. Thanks!
Sorry for the late reply - I'd check Kaggle, any dataset of points with a Lat and Lon should work
Hello! I want know can i upload raster/vector data using folium or any other python library?
great series and waitjng for the fourth video
Hi mate, great video that helped me immensely!!
Just found your channel. Thanks for the videos.
Awesome Tutorial... Thanks! Greetings from México.
Impressive, and waiting for the 3rd part
Hey, very helpful video. waiting for the other parts...
How can I connect the postgis database with apache superset ?
Is your superset running in docker as well? If not, you should just be able to use localhost as the IP in your connection string (superset.apache.org/docs/databases/postgres/). If it IS in docker, you'll have to make sure they're both on the same docker network, then use the container name as the host
Super useful. Thank you!
Thanks for the well explained solutions and waiting for more new videos
Cool
Thank you so much for the tutorial. Had a blast with it!
Very well explained...
This is fantastic thank you for sharing. I'm currently a GIS undergrad and this is incredibly useful content, I appreciate it!
Your channel will grow if you keep on sharing your knowledge. Really Professional Explanation.
Thank You!
I'm really interested in spatial analysis, so glad I stumbled across this channel! Great videos, I hope you have more to come, the quality of these is fantastic.
Great content, thank you!
Excellent series, exactly what i was looking for
Hey man, I saw your post on r/gis a few weeks ago and I only got around to watching a couple of your vids today. I'm looking into migrating my geospatial data into a postgis database but I couldn't find any resources that I really like, they're either too high level or low level for my current knowledge, the audio isn't great, or the content is outdated. You keep it simple and concise with nice clear audio, great explanations, and perfect pace (not too much content per video and not too slow). The only bit of feedback I have is that sometimes your mouse cursor disappears and it can be hard to follow what is going on - maybe just an OBS issue? Do you have a Twitter handle or anything? Anyway, I'm looking forward to more!
using pandas .shape and .describe methods before/after performing data operations would be great info to highlight on screen.
These two tutorials are an awesome start to the channel. I'm taught myself gpd just enough to make some crude maps, so seeing an expert navigate and build with these libraries is very enlightening. Looking forward to what you've got planned next. Thanks! One tiny point of feedback - the audio quality could use a bit of improvement. I can hear everything, but it sounds like you're in a cavern.
thank you for the video :) it's a meaningful source of information for student like me. Can't wait to see your next videos
Great video! I found it clear and useful. I can't wait to see what's next!