How to add geospatial data to PostgreSQL - PostGIS Tutorial 1

Опубликовано: 18 Март 2026
на канале: GeoProgramming
1,945
14

Learn how to add geospatial data to PostgreSQL using the PostGIS extension.

1:44 Create table
4:20 Creating INSERT INTO statement

----------------------------------------------------------------------------------------------------------------------------------------------------------------
📄 Code - INSERT INTO public.test VALUES ('Sofia', ST_GeomFromText('Point(23.319941 42.69833)', 4326))
📖 WKT - https://es.wikipedia.org/wiki/Well_Kn...
📖 Add geometry from the text - https://postgis.net/docs/ST_GeomFromT...
💻 Platform - https://www.postgresql.org/
🎶 Music by RelaxingTime from Pixabay.

Install PostgreSQL on Windows -    • PostgreSQL: How to download & install Post...  
Install PostGIS on Windows-    • PostgreSQL Tutorial: How to download and i...  

----------------------------------------------------------------------------------------------------------------------------------------------------------------
You can also follow me here:

GitHub - https://github.com/Ponsoda/
Twitter -   / _ponsoda_  
Linkedin -   / ignponsoda  

----------------------------------------------------------------------------------------------------------------------------------------------------------------


#tutorial #GeoProgramming #postgresql #postgis