Postgres Pro
Downloads
Home   >   mailing lists

Re: How to create a View of geometry type equals point? - Mailing list pgsql-novice

From Sándor Daku
Subject Re: How to create a View of geometry type equals point?
Date
Msg-id CAKyoTgYyrrDCUL=G5DoiWByS9cO3uCBVHZa6CvotwYhvHq_BVQ@mail.gmail.com
Whole thread Raw
In response to How to create a View of geometry type equals point?  (Nicholas G Lawrence <nicholas.g.lawrence@tmr.qld.gov.au>)
Responses Re: How to create a View of geometry type equals point?
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Nicholas G Lawrence
Date:
Subject: How to create a View of geometry type equals point?
Next
From: Roxanne Reid-Bennett
Date:
Subject: Re: How to create a View of geometry type equals point?