Re: How to create a View of geometry type equals point?

Create view polys as
Select * from <table> where ST_GeometryType(<geom>) = ‘ST_Polygon’;

Returns ST_Linestring, ST_Polygon, etc.

ST_GeometryType
postgis.net

There is also GeometryType 
GeometryType
postgis.net

Roxanne

On Jun 13, 2024, at 9:36 PM, Sándor Daku <daku(dot)sandor(at)gmail(dot)com> wrote:


Hello Nicholas,
I want to create a View within PostGIS that filters only those records that have Geometry type equal to Point

(and also another view of geometry type equal to Polygon)

What SELECT statement achieves this?

I'm not familiar with PostGIS, but based on a quick glance at the docs I think the ST_Dimension function is what you need. Something like: ...where ST_Dimension(geometry_field) = 0

Regards,

Sándor