How to add geospatial data to PostgreSQL – PostGIS Tutorial 1
Learn how to add geospatial data to PostgreSQL using the PostGIS extension.
—————————————————————————————————————————————————————-
📄 Code – INSERT INTO public.test VALUES (‘Sofia’, ST_GeomFromText(‘Point(23.319941 42.69833)’, 4326))
📖 WKT – https://es.wikipedia.org/wiki/Well_Known_Text
📖 Add geometry from text – https://postgis.net/docs/ST_GeomFromText.html
💻 Platform – https://www.postgresql.org/
🎶 Music by RelaxingTime from Pixabay.
Install PostgreSQL on Windows – https://www.youtube.com/watch?v=MTRtusym-2s
Install PostGIS on Windows- https://www.youtube.com/watch?v=afK8GWpb8RU
—————————————————————————————————————————————————————-
You can also follow me here:
GitHub – https://github.com/Ponsoda/
Twitter – https://twitter.com/_Ponsoda_
Linkedin – https://www.linkedin.com/in/ignponsoda/
—————————————————————————————————————————————————————-
#tutorial #GeoProgramming #postgresql #postgis
Comments are closed.