Re: How to create a View of geometry type equals point? - Mailing list pgsql-novice
Create view polys as
Select * from <table> where ST_GeometryType(<geom>) = ‘ST_Polygon’;Returns ST_Linestring, ST_Polygon, etc.
|
There is also GeometryType
|
Roxanne
On Jun 13, 2024, at 9:36 PM, Sándor Daku <daku.sandor@gmail.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) = 0Regards,Sándor
pgsql-novice by date: