MIME-Version: 1.0
References: 
 <SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22@SY6P282MB3816.AUSP282.PROD.OUTLOOK.COM>
In-Reply-To: 
 <SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22@SY6P282MB3816.AUSP282.PROD.OUTLOOK.COM>
From: =?UTF-8?B?U8OhbmRvciBEYWt1?= <daku.sandor@gmail.com>
Date: Fri, 14 Jun 2024 06:36:26 +0200
Message-ID: 
 <CAKyoTgYyrrDCUL=G5DoiWByS9cO3uCBVHZa6CvotwYhvHq_BVQ@mail.gmail.com>
Subject: Re: How to create a View of geometry type equals point?
To: Nicholas G Lawrence <nicholas.g.lawrence@tmr.qld.gov.au>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000004222a2061ad229d1"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKyoTgYyrrDCUL%3DG5DoiWByS9cO3uCBVHZa6CvotwYhvHq_BVQ%40mail.gmail.com>
Precedence: bulk

--0000000000004222a2061ad229d1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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) =3D 0


Regards,

S=C3=A1ndor

--0000000000004222a2061ad229d1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hello Nicholas,<div class=3D"gmail_quote" dir=3D"auto"><b=
lockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-le=
ft:1px solid rgb(204,204,204);padding-left:1ex"><div lang=3D"EN-AU" link=3D=
"#0563C1" vlink=3D"#954F72"><div>
<p class=3D"MsoNormal">I want to create a View within PostGIS that filters =
only those records that have Geometry type equal to Point<u></u><u></u></p>
<p class=3D"MsoNormal">(and also another view of geometry type equal to Pol=
ygon)<u></u><u></u></p>
<p class=3D"MsoNormal">What SELECT statement achieves this?</p></div></div>=
</blockquote></div><div dir=3D"auto"><br></div><div dir=3D"auto">I&#39;m no=
t familiar with PostGIS, but based on a quick glance at the docs I think th=
e ST_Dimension function is what you need. Something like: ...where ST_Dimen=
sion(geometry_field) =3D 0</div><div dir=3D"auto"><br></div><div dir=3D"aut=
o"><br></div><div dir=3D"auto">Regards,</div><div dir=3D"auto"><br></div><d=
iv dir=3D"auto">S=C3=A1ndor</div><div dir=3D"auto"><br></div><div class=3D"=
gmail_quote" dir=3D"auto"><blockquote class=3D"gmail_quote" style=3D"margin=
:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"=
><div lang=3D"EN-AU" link=3D"#0563C1" vlink=3D"#954F72"><div>
</div></div>

</blockquote></div></div>

--0000000000004222a2061ad229d1--