public inbox for [email protected]
help / color / mirror / Atom feedHow to create a View of geometry type equals point?
3+ messages / 3 participants
[nested] [flat]
* How to create a View of geometry type equals point?
@ 2024-06-14 03:50 Nicholas G Lawrence <[email protected]>
2024-06-14 04:36 ` Re: How to create a View of geometry type equals point? Sándor Daku <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Nicholas G Lawrence @ 2024-06-14 03:50 UTC (permalink / raw)
To: [email protected] <[email protected]>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to create a View of geometry type equals point?
2024-06-14 03:50 How to create a View of geometry type equals point? Nicholas G Lawrence <[email protected]>
@ 2024-06-14 04:36 ` Sándor Daku <[email protected]>
2024-06-14 06:38 ` Re: How to create a View of geometry type equals point? Roxanne Reid-Bennett <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Sándor Daku @ 2024-06-14 04:36 UTC (permalink / raw)
To: Nicholas G Lawrence <[email protected]>; +Cc: [email protected]
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to create a View of geometry type equals point?
2024-06-14 03:50 How to create a View of geometry type equals point? Nicholas G Lawrence <[email protected]>
2024-06-14 04:36 ` Re: How to create a View of geometry type equals point? Sándor Daku <[email protected]>
@ 2024-06-14 06:38 ` Roxanne Reid-Bennett <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Roxanne Reid-Bennett @ 2024-06-14 06:38 UTC (permalink / raw)
To: [email protected] <[email protected]>
Create view polys as
Select * from <table> where ST_GeometryType(<geom>) = ‘ST_Polygon’;
Returns ST_Linestring, ST_Polygon, etc.
ST_GeometryType
postgis.net
There is also GeometryType
GeometryType
postgis.net
Roxanne
On Jun 13, 2024, at 9:36 PM, Sándor Daku <[email protected]> wrote:
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-06-14 06:38 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-14 03:50 How to create a View of geometry type equals point? Nicholas G Lawrence <[email protected]>
2024-06-14 04:36 ` Sándor Daku <[email protected]>
2024-06-14 06:38 ` Roxanne Reid-Bennett <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox