[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Help with an area and hole filter query?
From: "Bob and Deb" <bobdebm () gmail ! com>
Date: 2008-12-31 7:08:00
Message-ID: 7a3148720812302308r2066202fof75a3b4714f24f31 () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I am hoping to fill in the small holes and remove small areas. I'll read up
on these functions and see what I can come up with, but I might need help in
making an efficient query since there are over 100K polygons.
Thank you for your help.
Bob
On Tue, Dec 30, 2008 at 5:15 PM, Paragon Corporation <lr@pcorp.us> wrote:
> Bob,
>
> Are you looking to fill in the holes or just exclude polygons with small
> holes and that have small areas.
>
> Anyrate you should take a look at
>
>
> http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html
> (will give you number of holes)
>
>
> ST_InterionRingN
>
>
> http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html
> (will give you the holes)
>
> Then use ST_BuildArea to convert holes to polygons so you can take the
> ST_Area of it.
>
> http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html
>
>
>
> ------------------------------
> *From:* postgis-users-bounces@postgis.refractions.net [mailto:
> postgis-users-bounces@postgis.refractions.net] *On Behalf Of *Bob and Deb
> *Sent:* Tuesday, December 30, 2008 5:50 PM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] Help with an area and hole filter query?
>
> Hello PostGIS Users,
>
> I have a polygon table that has many small areas and holes. Now, I would
> like to remove small areas and holes that are 2800 m^2.
>
> Any help or advice would be really appreciated.
>
> Thanks in advance.
>
> Bob
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
[Attachment #5 (text/html)]
I am hoping to fill in the small holes and remove small areas. I'll read up \
on these functions and see what I can come up with, but I might need help in making \
an efficient query since there are over 100K polygons.<br> <br>Thank you for your \
help.<br><br>Bob<br><br><div class="gmail_quote">On Tue, Dec 30, 2008 at 5:15 PM, \
Paragon Corporation <span dir="ltr"><<a \
href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" \
size="2">Bob,</font></span></div> <div dir="ltr" align="left"><span><font \
color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" \
align="left"><span><font color="#0000ff" face="Arial" size="2">Are you looking to \
fill in the holes or just exclude polygons with small holes and that have small \
areas.</font></span></div> <div dir="ltr" align="left"><span><font color="#0000ff" \
face="Arial" size="2"></font></span> </div> <div dir="ltr" \
align="left"><span><font color="#0000ff" face="Arial" size="2">Anyrate you should \
take a look at </font></span></div> <div dir="ltr" align="left"><span><font \
color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" \
align="left"><span><font color="#0000ff" face="Arial" size="2"><a \
href="http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html" \
target="_blank">http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html</a> \
(will give you number of holes)</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span><font \
color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" \
align="left"><span><font color="#0000ff" face="Arial" \
size="2">ST_InterionRingN</font></span></div> <div dir="ltr" align="left"><span><font \
color="#0000ff" face="Arial" size="2"></font></span> </div> <div dir="ltr" \
align="left"><span><font color="#0000ff" face="Arial" size="2"><a \
href="http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html" \
target="_blank">http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.html</a> \
(will give you the holes)</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span><font \
color="#0000ff" face="Arial" size="2">Then use ST_BuildArea to convert holes to \
polygons so you can take the ST_Area of it. </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span><font \
color="#0000ff" face="Arial" size="2"><a \
href="http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html" \
target="_blank">http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span><font \
color="#0000ff" face="Arial" size="2"></font></span> </div><font color="#0000ff" \
face="Arial" size="2"></font><font color="#0000ff" face="Arial" size="2"></font><br> \
<div dir="ltr" align="left" lang="en-us"> <hr>
<font face="Tahoma" size="2"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" \
target="_blank">postgis-users-bounces@postgis.refractions.net</a> [mailto:<a \
href="mailto:postgis-users-bounces@postgis.refractions.net" \
target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of \
</b>Bob and Deb<br><b>Sent:</b> Tuesday, December 30, 2008 5:50 PM<br><b>To:</b> \
PostGIS Users Discussion<br><b>Subject:</b> [postgis-users] Help with an area and \
hole filter query?<br></font><br></div><div><div></div><div class="Wj3C7c">
<div></div>Hello PostGIS Users,<br><br>I have a polygon table that has many
small areas and holes. Now, I would like to remove small areas and holes
that are 2800 m^2.<br><br>
<div><font size="2"><font size="2">Any help or advice would be really
appreciated.</font></font></div>
<div> </div>
<div><font size="2"><font size="2">Thanks in
advance.<br><br>Bob<br></font></font></div><br></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
<br></blockquote></div><br>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic