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

Поиск
Список
Период
Сортировка
От Sándor Daku
Тема Re: How to create a View of geometry type equals point?
Дата
Msg-id CAKyoTgYyrrDCUL=G5DoiWByS9cO3uCBVHZa6CvotwYhvHq_BVQ@mail.gmail.com
обсуждение исходный текст
Ответ на How to create a View of geometry type equals point?  (Nicholas G Lawrence <nicholas.g.lawrence@tmr.qld.gov.au>)
Ответы Re: How to create a View of geometry type equals point?
Список pgsql-novice
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Nicholas G Lawrence
Дата:
Сообщение: How to create a View of geometry type equals point?
Следующее
От: Roxanne Reid-Bennett
Дата:
Сообщение: Re: How to create a View of geometry type equals point?