Geometry Creation and Manipulation Using PostGIS | PostGIS Baby Steps

In this tutorial we are going to learn about geometries and manipulate them using Postgis Spatial Functions. This is one of those tutorials you should watch till the end.

Are these videos helpful?
LIKE | SHARE | SUBSCRIBE

[gregamos]

Whoa - there's suddenly a lot going on at the 5:00 mark, with the speed changes, the longer SQL statements, and the weirdly spelled 'geomoetries' table. For those who missed a few things here (I did!), here's the SQL statements that work if you copy/paste them into pgAdmin (assuming you spelled your table name as 'geometries'):

INSERT INTO geometries VALUES
('Point', 'POINT (0 0)'),
('Linestring', 'LINESTRING(0 0, 1 1, 2 1, 2 2 )'),
('Polygon', 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'),
('PolyWithHole', 'POLYGON((0 0, 10 0, 0 10, 0 0, 0 0), (1 1, 1 2, 2 2, 1 1))'),
('Collection', 'GEOMETRYCOLLECTION( POINT(2 0), POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0)) )')

[PEdulis]

Thank you for your videos, they help me getting an understanding of PostGIS. I'm not through with your videos yet, so maybe the answer is in one of the others but here's my question: I have a huge database with many items and each of them has a longitude and a latitude. I want to convert them into a geometry entry to then build an index over those so that the items can be displayed on google maps, meaning I can find all the objects in my database that fit into the current zoom factor a user has when he searches for the items on my website. Could you point me to one of your videos that deals with this or maybe create a video that shows how to do that?

[GIS-Engineer]

If we have geojson data in excel cell then how will import this data in postgresql and create geometry??

[melikeyildiz]

can ı do point detection in polygon with this tutorial

[erickkinuthia]

in what scenario would you create a geometry within the database and not create in Qgis and import

[GIS-Engineer]

How will geojson data store in postgresql