From: Nicholas G Lawrence <nicholas.g.lawrence@tmr.qld.gov.au>
To: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Subject: How to create a View of geometry type equals point?
Thread-Topic: How to create a View of geometry type equals point?
Thread-Index: Adq+Dc1lJlUV6naKTkGZVqoxlUsgWw==
Date: Fri, 14 Jun 2024 03:50:31 +0000
Message-ID: 
 <SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22@SY6P282MB3816.AUSP282.PROD.OUTLOOK.COM>
Accept-Language: en-AU, en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?2ycN6pfFYVachvZXw2jVS6Luv0rENG1xAxfivus8P30e+4omO/1zgACUNvS+?=
 =?us-ascii?Q?RtoXz8el4MH4a8lmbnvLQa93CC7bZ33BJWGrir2L8hiUDCtLaP/NuFkiXaIY?=
 =?us-ascii?Q?WlZKL5i+9/RIj0Qy6yofh/z951VbBzBkAgi6XVD3SCBcA5yJSjxm+2pivviE?=
 =?us-ascii?Q?YEe+aN94B7VHP1HLCX6/GJAK9fBBB3JcFLF9akHsy9eaBxKYcdlNSK3Xu+HN?=
 =?us-ascii?Q?iXMZgoWxEBHbfaDrid3X7K/k4kzu7UvKVv0T5NS/gYwNaEtUpxfCaZV8xkTJ?=
 =?us-ascii?Q?aP/hzppDXC3OmJLC8SrG2AqPnjklnt9oJPf3mML/3ngFcvKjn1C3B+VADfbX?=
 =?us-ascii?Q?mtTgqvnFTSXTS2g4IsbsXUNNiJC6G70WkUBLacS9fGqGx9QgEgQGakAmgfCp?=
 =?us-ascii?Q?tgHuW0XlQ0cK3uC3HhTmqWz3J5ze9GPu1OiX8yQOkLw2utDTenQWHIfolOx1?=
 =?us-ascii?Q?DF1QJokm4bRZrDDz3ZQG+dC/WJb7IgUmMvsWfiWqhHXgFEMyPbwhktjXSOCl?=
 =?us-ascii?Q?iPm2qjronlrpqSzAp8ntFS27RiZn5lWd+7m5Ph4Kv9uX2yQ8TkCcFKeJ5B54?=
 =?us-ascii?Q?6aM6NcEcoHDKqiiDUbd1r/xMn7sDrZKQxDtfzhphDSPcDHvRrAeAgGulQ9WV?=
 =?us-ascii?Q?aJA66boLPBHuBIT7IRjZ5F0hiW33IPBIgvRTxtPd0RjRxBqRVyVg8BjCSuPw?=
 =?us-ascii?Q?/DL45EXi6MQJCOsIAhyVnJAsj2i8OghDrcmw5qhHNn+EGOhDuZD7uZUrSIR4?=
 =?us-ascii?Q?l8y6cuVnI1GlGGlCanBpE1KGY1+ipVE6/W2f+Ul0zriwGf7noi/wHqyya80s?=
 =?us-ascii?Q?7YM7XDRqjNOMu111lPirasIiyhVbpM3zUlpq2ZkVmd8JzSuUxSKx8rl9fGdD?=
 =?us-ascii?Q?+yMjqWfMBe7xla1mhUrgb5ciBTEJvNZnn4VAd4TcCDhh97z0NbZicrISX0rC?=
 =?us-ascii?Q?3NqNCJ2jmvtaEwWm9y5ptkugapGEr7zJesooXl9xHBpRiSxLNWBn677YZ4Jr?=
 =?us-ascii?Q?wqXohWfm/tmLi7KWw7NEpIw37zr5STZl69WA1yWvofQQSKbUgpR2rRF/Yp1F?=
 =?us-ascii?Q?wShOeGkQaq6pnH7IXN4EzNvFLh+QfMEBjVRPtcGHOdxffhbfMiu5na146JXp?=
 =?us-ascii?Q?L6NLqU1X4t56t9b1hn347qMaQuRwnXJqJ9XBlKhWaIdWaPh278vrd1FNKEMK?=
 =?us-ascii?Q?V/65+vQDO3kfHx7a4k1uGv+x5UxDCI/VXcW2MooYsFU3j+3/wu71zlHAhWDo?=
 =?us-ascii?Q?wuC/EZLub7LNLl7w+1jXJXumZpglJzzXymuAgp42do5s1W+QhJ96w709Gi5x?=
 =?us-ascii?Q?rwhPpE0mNk1yqcCpHJHsoQQCr/1amftPAG8Vvc+7Yub1FgWg1jWhTgPDk7ZJ?=
 =?us-ascii?Q?FViigXzIgY5k9eCoTWlIhS03E5K7taEpMIUrLTm7fo/A6ayCMgNxNVgSZD4H?=
 =?us-ascii?Q?qUklT9zSfDjN5Y9H/GOEjbIP+5rC4hf5xvRM4IcWVOZz/wprlmjU/52m1MIh?=
 =?us-ascii?Q?eqbSNT2sPi201p3SHnj+GWp6iuMkIFrny233OQw17EZX9Fw38wJ5/ZT0ERcb?=
 =?us-ascii?Q?zHwvy5swK1hW4DFJuQK2GSbVMcqYuen06UAtcGvI1dy/uGxSONoLBgLzEdvm?=
 =?us-ascii?Q?bg=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22SY6P282MB3816AUSP_"
MIME-Version: 1.0
X-OriginatorOrg: tmr.qld.gov.au
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SY6P282MB3816.AUSP282.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 0b092202-d3a4-4a6d-b400-08dc8c25238f
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Jun 2024 03:50:31.7915
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 7448469d-8ba5-44d4-a43c-8d7ff6fb550d
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 rw6bbRY/aIQ+HyeRLBme00GNBMOt0nYLFIV6WD/mtXbJmLPWxwz8jANa/+f+v+CmYNg/xwtD72J+uwbvzRq1N8W10wYKdTNM8n0APps7HE+H+wqXVK8DTqu178N4+MmO
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY8P282MB5257
X-Proofpoint-GUID: gOysInqsicaMJ3klc3ovHLsJ9SZ7Ec66
X-Proofpoint-ORIG-GUID: gOysInqsicaMJ3klc3ovHLsJ9SZ7Ec66
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.28.16
 definitions=2024-06-13_15,2024-06-13_02,2024-05-17_01
List-Id: <pgsql-novice.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-novice@lists.postgresql.org>
List-Owner: <mailto:pgsql-novice-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-novice>
Archived-At: 
 <https://www.postgresql.org/message-id/SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22%40SY6P282MB3816.AUSP282.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22SY6P282MB3816AUSP_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello pgsql-novice,

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?

Thanks,

Nick Lawrence
Senior Spatial Science Officer | Geospatial Technologies
Engineering & Technology | Transport and Main Roads

Floor 19 | 313 Adelaide Street | Brisbane City Qld 4000
GPO Box 1412 | Brisbane City Qld 4001
P: (07) 30667977
E: nicholas.g.lawrence@tmr.qld.gov.au<mailto:nicholas.g.lawrence@tmr.qld.go=
v.au>
W: www.tmr.qld.gov.au<https://urldefense.proofpoint.com/v2/url?u=3Dhttp-3A_=
_www.tmr.qld.gov.au_&d=3DDwMFAg&c=3DtpTxelpKGw9ZbZ5Dlo0lybSxHDHIiYjksG4icXf=
algk&r=3DB7lks60cqtX0KvQXGVj8MbkZJQP0MAFzax_Bmdw0hOA&m=3DoK6xl56P5IxMSPEf8J=
QbFBSpJihJZHSNA6rNzgUM1_E&s=3Dv6_q-k1ArpX6YM1NqnIOVudS4W5Ulmhgs1t4YXykjH4&e=
=3D>

WARNING: This email (including any attachments) may contain legally privile=
ged, confidential or private information and may be protected by copyright.=
 You may only use it if you are the person(s) it was intended to be sent to=
 and if you use it in an authorised way. No one is allowed to use, review, =
alter, transmit, disclose, distribute, print or copy this email without app=
ropriate authority.

If this email was not intended for you and was sent to you by mistake, plea=
se telephone or email me immediately, destroy any hard copies of this email=
 and delete it and any copies of it from your computer system. Any right wh=
ich the sender may have under copyright law, and any legal privilege and co=
nfidentiality attached to this email is not waived or destroyed by that mis=
take.

It is your responsibility to ensure that this email does not contain and is=
 not affected by computer viruses, defects or interference by third parties=
 or replication problems (including incompatibility with your computer syst=
em).

Opinions contained in this email do not necessarily reflect the opinions of=
 the Department of Transport and Main Roads, or endorsed organisations util=
ising the same infrastructure.=20

--_000_SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22SY6P282MB3816AUSP_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ligatures:standardcontextual;
	mso-fareast-language:EN-US;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-AU" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hello pgsql-novice,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I want to create a View within PostGIS that filters =
only those records that have Geometry type equal to Point<o:p></o:p></p>
<p class=3D"MsoNormal">(and also another view of geometry type equal to Pol=
ygon)<o:p></o:p></p>
<p class=3D"MsoNormal">What SELECT statement achieves this?<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanks,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-autospace:none"><b><span style=3D"colo=
r:black;mso-ligatures:none;mso-fareast-language:EN-AU">Nick Lawrence</span>=
</b><span style=3D"color:black;mso-ligatures:none;mso-fareast-language:EN-A=
U"><br>
</span><span style=3D"color:#003C6A;mso-ligatures:none;mso-fareast-language=
:EN-AU">Senior Spatial Science Officer</span><span style=3D"color:black;mso=
-ligatures:none;mso-fareast-language:EN-AU"> | Geospatial Technologies<br>
<b>Engineering &amp; Technology</b> | Transport and Main Roads<o:p></o:p></=
span></p>
<p class=3D"MsoNormal" style=3D"text-autospace:none"><span style=3D"color:b=
lack;mso-ligatures:none;mso-fareast-language:EN-AU"><o:p>&nbsp;</o:p></span=
></p>
<p class=3D"MsoNormal" style=3D"text-autospace:none"><span style=3D"color:#=
8F8F8F;mso-ligatures:none;mso-fareast-language:EN-AU">Floor 19 | 313 Adelai=
de Street | Brisbane City Qld 4000<br>
GPO Box 1412 | Brisbane City Qld 4001<br>
</span><span style=3D"color:#003C6A;mso-ligatures:none;mso-fareast-language=
:EN-AU">P:</span><span style=3D"color:#004080;mso-ligatures:none;mso-fareas=
t-language:EN-AU">
</span><span style=3D"color:#8F8F8F;mso-ligatures:none;mso-fareast-language=
:EN-AU">(07) 30667977<br>
</span><span style=3D"color:#003C6A;mso-ligatures:none;mso-fareast-language=
:EN-AU">E:
</span><span style=3D"mso-ligatures:none;mso-fareast-language:EN-AU"><a hre=
f=3D"mailto:nicholas.g.lawrence@tmr.qld.gov.au"><span style=3D"color:#0563C=
1">nicholas.g.lawrence@tmr.qld.gov.au</span></a><span style=3D"color:#003C6=
A"><br>
W: </span><a href=3D"https://urldefense.proofpoint.com/v2/url?u=3Dhttp-3A__=
www.tmr.qld.gov.au_&amp;d=3DDwMFAg&amp;c=3DtpTxelpKGw9ZbZ5Dlo0lybSxHDHIiYjk=
sG4icXfalgk&amp;r=3DB7lks60cqtX0KvQXGVj8MbkZJQP0MAFzax_Bmdw0hOA&amp;m=3DoK6=
xl56P5IxMSPEf8JQbFBSpJihJZHSNA6rNzgUM1_E&amp;s=3Dv6_q-k1ArpX6YM1NqnIOVudS4W=
5Ulmhgs1t4YXykjH4&amp;e=3D"><span style=3D"color:#003C6A">www.tmr.qld.gov.a=
u</span></a><o:p></o:p></span></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>

<DIV>
<hr><font face=3D"calibri" size=3D"1"><i><p><b>WARNING:</b> This email (inc=
luding any attachments) may contain legally privileged, confidential or pri=
vate information and may be protected by copyright. You may only use it if =
you are the person(s) it was intended to be sent to and if you use it in an=
 authorised way. No one is allowed to use, review, alter, transmit, disclos=
e, distribute, print or copy this email without appropriate authority.<BR>
<BR>
If this email was not intended for you and was sent to you by mistake, plea=
se telephone or email me immediately, destroy any hard copies of this email=
 and delete it and any copies of it from your computer system. Any right wh=
ich the sender may have under copyright law, and any legal privilege and co=
nfidentiality attached to this email is not waived or destroyed by that mis=
take.<BR>
<BR>
It is your responsibility to ensure that this email does not contain and is=
 not affected by computer viruses, defects or interference by third parties=
 or replication problems (including incompatibility with your computer syst=
em).<BR>
<BR>
Opinions contained in this email do not necessarily reflect the opinions of=
 the Department of Transport and Main Roads, or endorsed organisations util=
ising the same infrastructure. </p></i></font>
</DIV></body>
</html>

--_000_SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22SY6P282MB3816AUSP_--