public inbox for [email protected]  

help / color / mirror / Atom feed

From: Nicholas G Lawrence <[email protected]>
To: [email protected] <[email protected]>
Subject: How to create a View of geometry type equals point?
Date: Fri, 14 Jun 2024 03:50:31 +0000
Message-ID: <SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22@SY6P282MB3816.AUSP282.PROD.OUTLOOK.COM> (raw)

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: [email protected]<mailto:[email protected]>
W: www.tmr.qld.gov.au<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.tmr.qld.gov.au_&d=DwMFAg&c=tpTxelpKG...;

WARNING: This email (including any attachments) may contain legally privileged, 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 appropriate authority.

If this email was not intended for you and was sent to you by mistake, please 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 which the sender may have under copyright law, and any legal privilege and confidentiality attached to this email is not waived or destroyed by that mistake.

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 system).

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: How to create a View of geometry type equals point?
  In-Reply-To: <SY6P282MB3816FC60EBF8F7E10D2CB99AD3C22@SY6P282MB3816.AUSP282.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox