[postgis-users] postgis-users Digest, Vol 86, Issue 13
orkun
temiz at deprem.gov.tr
Wed Oct 14 05:03:06 PDT 2009
On Tue, 2009-10-13 at 12:00 -0700,
postgis-users-request at postgis.refractions.net wrote:
> Send postgis-users mailing list submissions to
> postgis-users at postgis.refractions.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> or, via email, send a message with subject or body 'help' to
> postgis-users-request at postgis.refractions.net
>
> You can reach the person managing the list at
> postgis-users-owner at postgis.refractions.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of postgis-users digest..."
>
>
> Today's Topics:
>
> 1. Re: Closest point on a POLYGON to a given POINT
> (Paragon Corporation)
> 2. Question (Simon Greener)
> 3. Re: Question (nicklas.aven at jordogskog.no)
> 4. extending a line without having any elbow (Ahmet Temiz)
> 5. Re: Question (Simon Greener)
> 6. make install problem in v. 1.4.0 as well as in 1.4.1.SVN
> (Peter Sarkoci)
> 7. Re: Question (nicklas.aven at jordogskog.no)
> 8. Re: Question (Maxime van Noppen)
> 9. Re: Closest point on a POLYGON to a given POINT
> (Juergen Lorenz Simon)
> 10. Update the geom of a table WHERE "i" is an even number
> (Daniel Grum)
> 11. Re: Update the geom of a table WHERE "i" is an even number
> (Nicolas Gillet - MARKET-IP)
> 12. Create points with a geoserver WFS-T (Daniel Grum)
> 13. Re: extending a line without having any elbow (Randall, Eric)
> 14. Exportar Shp (Manuel Castro)
> 15. Re: Exportar Shp (Emilie Laffray)
> 16. Re: Exportar Shp (Matias Massigoge)
> 17. Re: Exportar Shp (Chris Hermansen)
> 18. Re: Exportar Shp (Cristian Olgu?n Avila)
> 19. Re: Exportar Shp (Jorge Ar?valo)
> 20. Re: Question (Martin Davis)
> 21. Split / Divide linestring into parts / segments ? (Grant Masan)
> 22. Re: Split / Divide linestring into parts / segments ?
> (Paragon Corporation)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 12 Oct 2009 20:04:10 -0400
> From: "Paragon Corporation" <lr at pcorp.us>
> Subject: Re: [postgis-users] Closest point on a POLYGON to a given
> POINT
> To: "'PostGIS Users Discussion'"
> <postgis-users at postgis.refractions.net>
> Message-ID: <05D5622382E6429EA033CB918A82C9AD at H>
> Content-Type: text/plain; charset="us-ascii"
>
> Well the ideal solution would be the ST_ShortestLine that Nicklas has done
> which will give you a 2 point line where the start and end points represent
> the closest point on each geometry.
>
> This is in
> http://svn.osgeo.org/postgis/spike/nicklas/
>
> And on the list here
> http://trac.osgeo.org/postgis/ticket/231
>
> I really would like to see his changes in PostGIS 1.5 since they are more
> useful to me at this point than the current slated PostGIS 1.5 stuff -- HINT
> HINT
>
> Barring that I suppose you can do a
> SELECT ST_PointOnSurface(ST_Intersection(ST_Buffer(the_point,
> ST_Distance(the_poly, the_point) + somemarging of error), the_poly)
>
> Hope that helps,
> Regina
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Juergen
> Lorenz Simon
> Sent: Monday, October 12, 2009 10:44 AM
> To: PostGIS Users
> Subject: [postgis-users] Closest point on a POLYGON to a given POINT
>
> Hi,
>
> I have a nut to crack and i'm not finding anything suitable in the PostGIS
> documentation. The problem is as follows:
>
> I have a POLYGON G and a POINT P. I'd like to find the closest point to P on
> G (not in, ON). Is there a quick way of doing this with the build-in
> functions? Or is there some plsql routine I can use?
>
> Thanks in advance.
>
> PS: Coming to think of it: is there some open source repository for PostGIS
> code?
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 13 Oct 2009 15:27:26 +1100
> From: "Simon Greener" <simon at spatialdbadvisor.com>
> Subject: [postgis-users] Question
> To: "postgis-users at postgis.refractions.net"
> <postgis-users at postgis.refractions.net>
> Message-ID: <op.u1p1b0c9zbn0g9 at spdba>
> Content-Type: text/plain; charset=iso-8859-1; format=flowed; delsp=yes
>
> Folks,
>
> I am giving a talk at FOSS4G in Sydney next week. That talk's title and abstract are:
>
> ==================================================================
> Title: PostGIS and Oracle Spatial
> Abstract:
> Oracle Spatial and PostGIS are two of the most mature implementations of a spatial type system for their relevant host databases.
>
> With Postgres increasing in strength, and offshoot EnterpriseDB aiming to convert businesses running Oracle to EnterpriseDB/Postgres, the question of the relative merits of each of the spatial implementations arises.
>
> This talk will attempt to provide the audience with an understanding of the relative strengths and weaknesses of the two implementations so that they can feel they have some useful information which might aid decision making for new installations or conversions.
> ==================================================================
>
> While I already have quite a bit of material I thought I would ask the PostGIS community for suggestions as to what they would like covered if they were attending FOSS4G. Nothing worse than attending a presentation and, at the end, saying to youself that it was not what you expected and that nothing much was of use.
>
> So, what sorts of things do you think should be covered?
>
> regards
> SImon
> --
> SpatialDB Advice and Design, Solutions Architecture and Programming,
> Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
> Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
> 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
> Website: www.spatialdbadvisor.com
> Email: simon at spatialdbadvisor.com
> Voice: +61 362 396397
> Mobile: +61 418 396391
> Skype: sggreener
> Longitude: 147.20515 (147? 12' 18" E)
> Latitude: -43.01530 (43? 00' 55" S)
> GeoHash: r22em9r98wg
> NAC:W80CK 7SWP3
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 13 Oct 2009 08:52:23 +0200
> From: nicklas.aven at jordogskog.no
> Subject: Re: [postgis-users] Question
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <200910130652.n9D6qNNj027587 at mail-core.space2u.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hallo I think it couldn't be held high enough in this comparasion that postgis is an open source project (and I guess that's what they want to hear at FOSS4G :-) ). two examples The 13 of aug Jose Carlos asked a question about strange performance when using indexes in a particular situation.http://postgis.refractions.net/pipermail/postgis-users/2009-August/024238.html After that we can all follow the discussions on the users and development lists and I realise myself that this is a problem I have had too without seeing it. Paul Ramsey and Tom Lane finds how to solve the problem in postgresql and 2009-09-09 the solution is released in postgresql 8.4.1. I think that is very impressive. A problem occurs in postgis and less than a month later the solution is released in postgresql. Even if the release of 8.4.1 wouldn't have been that close, Tom committed the solution about one week I think after Jose Carlos first message. So from that day it was possible for anyone to use it!
.I!
> guess this was a special case, but worth mentioning. the second example is about my own experiance with postgis.In january I asked about the same question on this list as Juergen Lorenz Simon did yesterday. the post from january:http://postgis.refractions.net/pipermail/postgis-users/2009-February/022699.html I had about the same answer of solution then as Regina now suggests for postgis 1.4http://postgis.refractions.net/pipermail/postgis-users/2009-October/024838.html Since this is an open source project I downloaded the source and gave it a try. With some quite small modifications I could get the functionality I requested with great help and peptalk from the community (read Regina). And as the GPL license request I am happy to deliver it back as a suggestion for the future release.It was no big or advanced modification but it meant a lot to me, both for functionality and for the satisfaction of having managed it. ThanksNicklas
> 2009-10-13 Simon Greener wrote:
>
> Folks,
> >
> >I am giving a talk at FOSS4G in Sydney next week. That talk's title and abstract are:
> >
> >==================================================================
> >Title: PostGIS and Oracle Spatial
> >Abstract:
> >Oracle Spatial and PostGIS are two of the most mature implementations of a spatial type system for their relevant host databases.
> >
> >With Postgres increasing in strength, and offshoot EnterpriseDB aiming to convert businesses running Oracle to EnterpriseDB/Postgres, the question of the relative merits of each of the spatial implementations arises.
> >
> >This talk will attempt to provide the audience with an understanding of the relative strengths and weaknesses of the two implementations so that they can feel they have some useful information which might aid decision making for new installations or conversions.
> >==================================================================
> >
> >While I already have quite a bit of material I thought I would ask the PostGIS community for suggestions as to what they would like covered if they were attending FOSS4G. Nothing worse than attending a presentation and, at the end, saying to youself that it was not what you expected and that nothing much was of use.
> >
> >So, what sorts of things do you think should be covered?
> >
> >regards
> >SImon
> >--
> >SpatialDB Advice and Design, Solutions Architecture and Programming,
> >Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
> >Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
> >39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
> >Website: www.spatialdbadvisor.com
> > Email: simon at spatialdbadvisor.com
> > Voice: +61 362 396397
> >Mobile: +61 418 396391
> >Skype: sggreener
> >Longitude: 147.20515 (147? 12' 18" E)
> >Latitude: -43.01530 (43? 00' 55" S)
> >GeoHash: r22em9r98wg
> >NAC:W80CK 7SWP3
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20091013/51829ce0/attachment-0001.html>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 13 Oct 2009 09:52:57 +0300
> From: "Ahmet Temiz" <temiz at deprem.gov.tr>
> Subject: [postgis-users] extending a line without having any elbow
> To: postgis-users at postgis.refractions.net
> Message-ID: <20091013064856.M66368 at deprem.gov.tr>
> Content-Type: text/plain; charset=iso-8859-9
>
>
> hello
>
> I was wondering how I could extend a line without having any bent ?
> (on the direction of both original end and starting points)
>
> regards
>
> Ahmet TEM?Z
>
> --
> Open WebMail Project (http://openwebmail.org)
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 13 Oct 2009 18:20:14 +1100
> From: "Simon Greener" <simon at spatialdbadvisor.com>
> Subject: Re: [postgis-users] Question
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID: <op.u1p9b0jczbn0g9 at spdba>
> Content-Type: text/plain; charset=iso-8859-1; format=flowed; delsp=yes
>
> Niklaus,
>
> Thanks for your observations and comments.
>
> There are a few things in your email but the main thing I take home, as I have done via my interaction with this list, is that the developers of the product (PostGIS) are more involved in the user community than the Oracle equivalents specifically in being able to do something - directly - about the problems presented (not that PostGIS is not an official part of PostgreSQL as against Oracle). It is not that I say the Oracle team are not involved in their own forum, it is just that, I think, there is a tangible difference between what they can or are willing to do than their open source competitors.
>
> I will say so in a slide or two but it will be a minor aspect of my talk.
>
> Again, thanks very much for taking the time ot comment.
>
> regards
> Simon
> On Tue, 13 Oct 2009 17:52:23 +1100, <nicklas.aven at jordogskog.no> wrote:
>
> > Hallo I think it couldn't be held high enough in this comparasion that postgis is an open source project (and I guess that's what they want to hear at FOSS4G :-) ). two examples The 13 of aug Jose Carlos asked a question about strange performance when using indexes in a particular situation.http://postgis.refractions.net/pipermail/postgis-users/2009-August/024238.html After that we can all follow the discussions on the users and development lists and I realise myself that this is a problem I have had too without seeing it. Paul Ramsey and Tom Lane finds how to solve the problem in postgresql and 2009-09-09 the solution is released in postgresql 8.4.1. I think that is very impressive. A problem occurs in postgis and less than a month later the solution is released in postgresql. Even if the release of 8.4.1 wouldn't have been that close, Tom committed the solution about one week I think after Jose Carlos first message. So from that day it was possible for anyone to use !
it.
> I!
> > guess this was a special case, but worth mentioning. the second example is about my own experiance with postgis.In january I asked about the same question on this list as Juergen Lorenz Simon did yesterday. the post from january:http://postgis.refractions.net/pipermail/postgis-users/2009-February/022699.html I had about the same answer of solution then as Regina now suggests for postgis 1.4http://postgis.refractions.net/pipermail/postgis-users/2009-October/024838.html Since this is an open source project I downloaded the source and gave it a try. With some quite small modifications I could get the functionality I requested with great help and peptalk from the community (read Regina). And as the GPL license request I am happy to deliver it back as a suggestion for the future release.It was no big or advanced modification but it meant a lot to me, both for functionality and for the satisfaction of having managed it. ThanksNicklas
> > 2009-10-13 Simon Greener wrote:
> >
> > Folks,
> >>
> >> I am giving a talk at FOSS4G in Sydney next week. That talk's title and abstract are:
> >>
> >> ==================================================================
> >> Title: PostGIS and Oracle Spatial
> >> Abstract:
> >> Oracle Spatial and PostGIS are two of the most mature implementations of a spatial type system for their relevant host databases.
> >>
> >> With Postgres increasing in strength, and offshoot EnterpriseDB aiming to convert businesses running Oracle to EnterpriseDB/Postgres, the question of the relative merits of each of the spatial implementations arises.
> >>
> >> This talk will attempt to provide the audience with an understanding of the relative strengths and weaknesses of the two implementations so that they can feel they have some useful information which might aid decision making for new installations or conversions.
> >> ==================================================================
> >>
> >> While I already have quite a bit of material I thought I would ask the PostGIS community for suggestions as to what they would like covered if they were attending FOSS4G. Nothing worse than attending a presentation and, at the end, saying to youself that it was not what you expected and that nothing much was of use.
> >>
> >> So, what sorts of things do you think should be covered?
> >>
> >> regards
> >> SImon
> >> --
> >> SpatialDB Advice and Design, Solutions Architecture and Programming,
> >> Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
> >> Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
> >> 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
> >> Website: www.spatialdbadvisor.com
> >> Email: simon at spatialdbadvisor.com
> >> Voice: +61 362 396397
> >> Mobile: +61 418 396391
> >> Skype: sggreener
> >> Longitude: 147.20515 (147? 12' 18" E)
> >> Latitude: -43.01530 (43? 00' 55" S)
> >> GeoHash: r22em9r98wg
> >> NAC:W80CK 7SWP3
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
>
>
> --
> SpatialDB Advice and Design, Solutions Architecture and Programming,
> Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
> Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
> 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
> Website: www.spatialdbadvisor.com
> Email: simon at spatialdbadvisor.com
> Voice: +61 362 396397
> Mobile: +61 418 396391
> Skype: sggreener
> Longitude: 147.20515 (147? 12' 18" E)
> Latitude: -43.01530 (43? 00' 55" S)
> GeoHash: r22em9r98wg
> NAC:W80CK 7SWP3
>
>
> ------------------------------
>
> Message: 6
> Date: Tue, 13 Oct 2009 09:24:00 +0200
> From: Peter Sarkoci <peter.sarkoci at gmail.com>
> Subject: [postgis-users] make install problem in v. 1.4.0 as well as
> in 1.4.1.SVN
> To: postgis-users at postgis.refractions.net
> Message-ID:
> <d837cfbd0910130024w529c8a08u155688c020555a5d at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hello everybody,
>
> trying to make a slackbuild script for Slackware 13.0 I encountered a problem.
>
> * Short description: "make install" does not copy the man pages into
> the destination directory. This applies to postgis 1.4.0 as well as to
> 1.4.1.SVN trunk.
>
> * Long description: I do the following (step by step):
>
> 1a) configure --prefix=/usr
> which runs without any problem, just complaining it is not able to
> find any XSL-template of the docbook system. Having on mind this could
> be the reason why, later on, make gives up to do anything with man
> pages I tried also
>
> 1b) configure --prefix=/usr
> --with-xsldir=/usr/share/xml/docbook/xsl-stylesheets-1.75.1
> in which case configure runs without complaints.
>
> 2) make
> runs without any problem
>
> 3) make install DESTDIR=/tmp/SBo/package-postgis
> runs also without complaints, but in the end, there are no man pages
> in the sub-directories of $(DESTDIR). Moreover, during both runs of
> "make" the directory with documentation is _never_ entered.
>
> * Now the question: is it my mistake, an intentional behavior or a
> bug? It is not a big problem anyway, within the slackbuild script I
> can fix the problem easily. On the other hand, it could turn out that
> such a fix is not the kosher way to go.
>
> Thanks
> Peter
>
>
> ------------------------------
>
> Message: 7
> Date: Tue, 13 Oct 2009 10:48:10 +0200
> From: nicklas.aven at jordogskog.no
> Subject: Re: [postgis-users] Question
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <200910130848.n9D8mAhb014886 at mail-core.space2u.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Simon Great, just a complementing comment.What I mean is that those examples shows in a good way that the transparancy open source gives, means a lot in itself.
> It gives the possibility of new users to contribute with ideas from looking at the code and it makes it easier for postgresql-postgis to get a good interaction. As I imagine the road from a problem in postgis to a solution i postgresql would have been quite long and windling in a closed source environment where Paul and Tom would have to hide their codes from each other, only discussing the API:s. In that case Oracle would have a great point in controling the whole chain. But that benefit is not that clear when comparing to an open source system chain. I guess this is all worn out arguments in the open source world, but important to remember I think. The open source in it self gives a strength to the system and contributes to a more flexible and exciting development (development in a wider perspective). /Nicklas
> 2009-10-13 Simon Greener wrote:
>
> Niklaus,
> >
> >Thanks for your observations and comments.
> >
> >There are a few things in your email but the main thing I take home, as I have done via my interaction with this list, is that the developers of the product (PostGIS) are more involved in the user community than the Oracle equivalents specifically in being able to do something - directly - about the problems presented (not that PostGIS is not an official part of PostgreSQL as against Oracle). It is not that I say the Oracle team are not involved in their own forum, it is just that, I think, there is a tangible difference between what they can or are willing to do than their open source competitors.
> >
> >I will say so in a slide or two but it will be a minor aspect of my talk.
> >
> >Again, thanks very much for taking the time ot comment.
> >
> >regards
> >Simon
> >On Tue, 13 Oct 2009 17:52:23 +1100,wrote:
> >
> >> Hallo I think it couldn't be held high enough in this comparasion that postgis is an open source project (and I guess that's what they want to hear at FOSS4G :-) ). two examples The 13 of aug Jose Carlos asked a question about strange performance when using indexes in a particular situation.http://postgis.refractions.net/pipermail/postgis-users/2009-August/024238.html After that we can all follow the discussions on the users and development lists and I realise myself that this is a problem I have had too without seeing it. Paul Ramsey and Tom Lane finds how to solve the problem in postgresql and 2009-09-09 the solution is released in postgresql 8.4.1. I think that is very impressive. A problem occurs in postgis and less than a month later the solution is released in postgresql. Even if the release of 8.4.1 wouldn't have been that close, Tom committed the solution about one week Ithink after Jose Carlos first message. So from that day it was possible for anyone to use it.
> > I!
> >> guess this was a special case, but worth mentioning. the second example is about my own experiance with postgis.In january I asked about the same question on this list as Juergen Lorenz Simon did yesterday. the post from january:http://postgis.refractions.net/pipermail/postgis-users/2009-February/022699.html I had about the same answer of solution then as Regina now suggests for postgis 1.4http://postgis.refractions.net/pipermail/postgis-users/2009-October/024838.html Since this is an open source project I downloaded the source and gave it a try. With some quite small modifications I could get the functionality I requested with great help and peptalk from the community (read Regina). And as the GPL license request I am happy to deliver it back as a suggestion for the future release.It was no big or advanced modification but it meant a lot to me, both for functionality and for thesatisfaction of having managed it. ThanksNicklas
> >> 2009-10-13 Simon Greener wrote:
> >>
> >> Folks,
> >>>
> >>> I am giving a talk at FOSS4G in Sydney next week. That talk's title and abstract are:
> >>>
> >>> ==================================================================
> >>> Title: PostGIS and Oracle Spatial
> >>> Abstract:
> >>> Oracle Spatial and PostGIS are two of the most mature implementations of a spatial type system for their relevant host databases.
> >>>
> >>> With Postgres increasing in strength, and offshoot EnterpriseDB aiming to convert businesses running Oracle to EnterpriseDB/Postgres, the question of the relative merits of each of the spatial implementations arises.
> >>>
> >>> This talk will attempt to provide the audience with an understanding of the relative strengths and weaknesses of the two implementations so that they can feel they have some useful information which might aid decision making for new installations or conversions.
> >>> ==================================================================
> >>>
> >>> While I already have quite a bit of material I thought I would ask the PostGIS community for suggestions as to what they would like covered if they were attending FOSS4G. Nothing worse than attending a presentation and, at the end, saying to youself that it was not what you expected and that nothing much was of use.
> >>>
> >>> So, what sorts of things do you think should be covered?
> >>>
> >>> regards
> >>> SImon
> >>> --
> >>> SpatialDB Advice and Design, Solutions Architecture and Programming,
> >>> Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
> >>> Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
> >>> 39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
> >>> Website: www.spatialdbadvisor.com
> >>> Email: simon at spatialdbadvisor.com
> >>> Voice: +61 362 396397
> >>> Mobile: +61 418 396391
> >>> Skype: sggreener
> >>> Longitude: 147.20515 (147? 12' 18" E)
> >>> Latitude: -43.01530 (43? 00' 55" S)
> >>> GeoHash: r22em9r98wg
> >>> NAC:W80CK 7SWP3
> >>> _______________________________________________
> >>> postgis-users mailing list
> >>> postgis-users at postgis.refractions.net
> >>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>>
> >>>
> >
> >
> >--
> >SpatialDB Advice and Design, Solutions Architecture and Programming,
> >Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
> >Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
> >39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
> >Website: www.spatialdbadvisor.com
> > Email: simon at spatialdbadvisor.com
> > Voice: +61 362 396397
> >Mobile: +61 418 396391
> >Skype: sggreener
> >Longitude: 147.20515 (147? 12' 18" E)
> >Latitude: -43.01530 (43? 00' 55" S)
> >GeoHash: r22em9r98wg
> >NAC:W80CK 7SWP3
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20091013/f91f9327/attachment-0001.html>
>
> ------------------------------
>
> Message: 8
> Date: Tue, 13 Oct 2009 10:51:01 +0200
> From: Maxime van Noppen <maxime at altribe.org>
> Subject: Re: [postgis-users] Question
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <4AD43F75.8030401 at altribe.org>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Simon Greener wrote:
> > So, what sorts of things do you think should be covered?
>
> As a company what is the most important for me is that the product works
> and adds value to my products. From this point of view, it is often
> considered that professional solutions are better, with strong
> guarantees (support, ...). What is interesting IMHO is to show that
> PostGIS is ready for production use, and that the open source model
> works like a charm. This means that the money saved is not wasted in
> additional development costs.
>
> --
> Maxime
>
>
> ------------------------------
>
> Message: 9
> Date: Tue, 13 Oct 2009 11:09:25 +0200
> From: Juergen Lorenz Simon <simon at webtecc.com>
> Subject: Re: [postgis-users] Closest point on a POLYGON to a given
> POINT
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <E0D9AB09-3DA4-4FEF-BF2B-C4D065D7E262 at webtecc.com>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
> Hi,
>
> i'm inclined to go with Regina's solution as a starting point (since
> it won't involve any looping etc). I'm beginning to see how the
> PostGIS 'thinking' works. Could it be that the ST_Buffer() function is
> one of the most ... 'used' functions in PostGIS?
>
> Anyways, in the long run I probably have little choice but to write a
> real function, since my Poly's do have holes. I will have to take care
> of this fact eventually.
>
> Thanks all for the useful answers!
>
> J.
>
>
> On 13.10.2009, at 02:04, Paragon Corporation wrote:
>
> > Well the ideal solution would be the ST_ShortestLine that Nicklas
> > has done
> > which will give you a 2 point line where the start and end points
> > represent
> > the closest point on each geometry.
> >
> > This is in
> > http://svn.osgeo.org/postgis/spike/nicklas/
> >
> > And on the list here
> > http://trac.osgeo.org/postgis/ticket/231
> >
> > I really would like to see his changes in PostGIS 1.5 since they are
> > more
> > useful to me at this point than the current slated PostGIS 1.5 stuff
> > -- HINT
> > HINT
> >
> > Barring that I suppose you can do a
> > SELECT ST_PointOnSurface(ST_Intersection(ST_Buffer(the_point,
> > ST_Distance(the_poly, the_point) + somemarging of error), the_poly)
> >
> > Hope that helps,
> > Regina
> >
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> > Juergen
> > Lorenz Simon
> > Sent: Monday, October 12, 2009 10:44 AM
> > To: PostGIS Users
> > Subject: [postgis-users] Closest point on a POLYGON to a given POINT
> >
> > Hi,
> >
> > I have a nut to crack and i'm not finding anything suitable in the
> > PostGIS
> > documentation. The problem is as follows:
> >
> > I have a POLYGON G and a POINT P. I'd like to find the closest point
> > to P on
> > G (not in, ON). Is there a quick way of doing this with the build-in
> > functions? Or is there some plsql routine I can use?
> >
> > Thanks in advance.
> >
> > PS: Coming to think of it: is there some open source repository for
> > PostGIS
> > code?
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
>
> ------------------------------
>
> Message: 10
> Date: Tue, 13 Oct 2009 11:17:43 +0200
> From: Daniel Grum <daniel.grum at unibw.de>
> Subject: [postgis-users] Update the geom of a table WHERE "i" is an
> even number
> To: PostGIS Mailing-List <postgis-users at postgis.refractions.net>
> Message-ID: <4AD445B7.8000905 at unibw.de>
> Content-Type: text/plain; charset=ISO-8859-15; format=flowed
>
> Hi,
>
> I need a possibilty that a table "wald_by" will be updatet WHERE my
> counter "i" is an even number?!
>
> UPDATE wald_by
> SET the_geom = the_geom -
> ST_Intersection(poly.the_geom,ST_Expand(pt.the_geom, 2000))
> FROM public.wald_by poly, public.holzfaeller pt, public.runden i
> WHERE poly.the_geom && ST_Expand(pt.the_geom, 2000) AND pt.style=2 AND*
> i/5=2*;
>
> i/5=2 ???--> That mean: this UPDATE should be done if i=[10, 20, 30,
> 40...] !!!!
> And WHERE "i" is another number nothing should be done-->the_geom=the_geom
>
> the_geom is a forest area where forest will be cut, and after 10 rounds
> the area of the cut down area should be deducted from the original
> forest area-->the forest will be smaller after 10 rounds!
> There are two modes of lumberjacks, the one mode(pt.style=1) he cut down
> the wood regenerative and the other one is clearing the forest
> completely-->the area should be deducted.
>
> "i" will be stored every round in one table: "runden" and every round
> this SQL will be done:
> UPDATE runden SET i=i+1;
>
> Are there any ideas?
>
> --daniel
>
>
> ------------------------------
>
> Message: 11
> Date: Tue, 13 Oct 2009 11:37:08 +0200
> From: "Nicolas Gillet - MARKET-IP" <nicolas.gillet at market-ip.com>
> Subject: Re: [postgis-users] Update the geom of a table WHERE "i" is
> an even number
> To: <daniel.grum at unibw.de>, "'PostGIS Users Discussion'"
> <postgis-users at postgis.refractions.net>
> Message-ID: <007b01ca4be8$bb74a480$325ded80$@gillet at market-ip.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello Daniel,
>
> I am not very sure of your question but
>
> What about the modulo (%) operator ?
>
> - "WHERE i%10 = 0"
> This will keep only rows where the rest of division of i by 10 is 0.
> e.g.
> 15 % 10 = 5 KO (15 / 10 = 1 rest 5)
> 30 % 10 = 0 OK (30 / 10 = 3 rest 0)
> 23 % 10 = 2 KO (22 / 10 = 2 rest 3)
> ...
>
> Regards,
>
> Nicolas Gillet
>
>
> -----Message d'origine-----
> De?: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] De la part de Daniel
> Grum
> Envoy??: mardi 13 octobre 2009 11:18
> ??: PostGIS Mailing-List
> Objet?: [postgis-users] Update the geom of a table WHERE "i" is an even
> number
>
> Hi,
>
> I need a possibilty that a table "wald_by" will be updatet WHERE my
> counter "i" is an even number?!
>
> UPDATE wald_by
> SET the_geom = the_geom -
> ST_Intersection(poly.the_geom,ST_Expand(pt.the_geom, 2000))
> FROM public.wald_by poly, public.holzfaeller pt, public.runden i
> WHERE poly.the_geom && ST_Expand(pt.the_geom, 2000) AND pt.style=2 AND*
> i/5=2*;
>
> i/5=2 ???--> That mean: this UPDATE should be done if i=[10, 20, 30,
> 40...] !!!!
> And WHERE "i" is another number nothing should be done-->the_geom=the_geom
>
> the_geom is a forest area where forest will be cut, and after 10 rounds
> the area of the cut down area should be deducted from the original
> forest area-->the forest will be smaller after 10 rounds!
> There are two modes of lumberjacks, the one mode(pt.style=1) he cut down
> the wood regenerative and the other one is clearing the forest
> completely-->the area should be deducted.
>
> "i" will be stored every round in one table: "runden" and every round
> this SQL will be done:
> UPDATE runden SET i=i+1;
>
> Are there any ideas?
>
> --daniel
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> ------------------------------
>
> Message: 12
> Date: Tue, 13 Oct 2009 13:54:29 +0200
> From: Daniel Grum <daniel.grum at unibw.de>
> Subject: [postgis-users] Create points with a geoserver WFS-T
> To: PostGIS Mailing-List <postgis-users at postgis.refractions.net>
> Message-ID: <4AD46A75.8080403 at unibw.de>
> Content-Type: text/plain; charset=ISO-8859-15; format=flowed
>
> Hi,
>
> I want to create points(buildings) with a WFS-T in mapbender and before
> this was done there must be the possibility to control if there is
> another point-(building) or linestring-(water) geometry around the
> point...if there is another geometry the WFT-T should stop and write an
> ERROR message: "You are not able to create a point(building) there!"
> New points were digitized,with digitize tool in mapbender, but it don't
> control if there is a point/line at this area where the new point will
> be digitized!
>
> Do I have to create a PostGIS SQL script to stop the digitizing of an
> new point?
> I found the "mod_digitize_messages.php" whre I can create massages for
> several actions, but I don't know how I can create the "control-action"
> that control if there is a point in a defined area or not?!
>
> I wrote this in the mapbender mailing list too, with now answer!
>
> Are there any ideas??
>
> --daniel
>
>
> ------------------------------
>
That's right ? How can I do that ?
> Message: 13
> Date: Tue, 13 Oct 2009 10:58:46 -0400
> From: "Randall, Eric" <ERandall at eriecountygov.org>
> Subject: Re: [postgis-users] extending a line without having any elbow
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <CD32AE6ACD828644B29601ADC966FDCB01B4AD56 at ex1.eriecountygov.local>
> Content-Type: text/plain; charset="iso-8859-9"
>
> Ahmet,
>
> I don't understand. Do you mean you want to extend the line backward and forward by the angles of its first and last 2-point segments respectively?
>
> Eric
>
>
>
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Ahmet Temiz
> Sent: Tuesday, October 13, 2009 2:53 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] extending a line without having any elbow
>
>
>
> hello
>
> I was wondering how I could extend a line without having any bent ?
> (on the direction of both original end and starting points)
>
> regards
>
> Ahmet TEM?Z
>
> --
> Open WebMail Project (http://openwebmail.org)
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> ------------------------------
>
> Message: 14
> Date: Tue, 13 Oct 2009 09:22:47 -0600
> From: Manuel Castro <cp.manuel at gmail.com>
> Subject: [postgis-users] Exportar Shp
> To: postgis-users at postgis.refractions.net
> Message-ID:
> <c0724b140910130822i74c13952tef11807e097a0473 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Solicito que alguien me explicara como poder exportar un shp desde
> postgresql
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20091013/6445d1d9/attachment-0001.html>
>
> ------------------------------
>
> Message: 15
> Date: Tue, 13 Oct 2009 16:33:30 +0100
> From: Emilie Laffray <emilie.laffray at gmail.com>
> Subject: Re: [postgis-users] Exportar Shp
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
> <7e9dfabf0910130833l2c478697i85c9760aed19906f at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 2009/10/13 Manuel Castro <cp.manuel at gmail.com>
>
> > Solicito que alguien me explicara como poder exportar un shp desde
> > postgresql
> >
>
> Te necessitas usar pgsql2shp.
>
> Emilie Laffray
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20091013/5025893b/attachment-0001.html>
>
> ------------------------------
>
> Message: 16
> Date: Tue, 13 Oct 2009 12:34:09 -0300
> From: Matias Massigoge <matias.massigoge at agerpro.com.ar>
> Subject: Re: [postgis-users] Exportar Shp
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
> <f3853bdf0910130834y54bafc88s4bcbeef6b6f166be at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Manuel,
>
> La mayor parte de los participantes de este foro hablan Ingles, as?
> que siempre vas a tener mas ?xito si escrib?s las consultas en Ingles.
>
> Respondo a tu pregunta: Existen algunas aplicaciones que resuelven
> este tipo de problema, en tu caso particular se llama "pgsql2shp". La
> ubicaci?n de la aplicaci?n depender? del Sistema Operativo y la
> instalaci?n que hayas hecho.
>
> Copio una pregunta al foro similar:
> "http://wiki.postgis.org/pipermail/postgis-users/2005-October/009767.html"
>
> Saludos.
>
> Mat?as
>
> 2009/10/13 Manuel Castro <cp.manuel at gmail.com>:
> > Solicito que alguien me explicara como poder exportar un shp desde
> > postgresql
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
>
>
> --
> Lic. Mat?as Massigoge
> Cel: 54-11-62047686
> www.agerpro.com.ar
>
>
> ------------------------------
>
> Message: 17
> Date: Tue, 13 Oct 2009 15:35:59 +0000
> From: "Chris Hermansen" <chris.hermansen at timberline.ca>
> Subject: Re: [postgis-users] Exportar Shp
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Message-ID:
> <857608161-1255448063-cardhu_decombobulator_blackberry.rim.net-1991350970- at bda860.bisx.prod.on.blackberry>
>
> Content-Type: text/plain; charset="Windows-1252"
>
> You can use the pgsql2shp utility. It is documented on the (English) PostGIS web site; or Google will find it for you.
> Chris Hermansen chris.hermansen at timberline.ca
> tel+1.604.714.2878 ? fax+1.604.733.0631 ? mob+1.778.840.4625
> Timberline Natural Resource Group ? www.timberline.ca
> 401 ? 958 West 8th Avenue ? Vancouver BC ? Canada ? V5Z 1E5
>
>
> -----Original Message-----
> From: Manuel Castro <cp.manuel at gmail.com>
> Date: Tue, 13 Oct 2009 09:22:47
> To: <postgis-users at postgis.refractions.net>
> Subject: [postgis-users] Exportar Shp
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> ------------------------------
>
> Message: 18
> Date: Tue, 13 Oct 2009 12:42:14 -0300
> From: Cristian Olgu?n Avila <cristianolguin at gmail.com>
> Subject: Re: [postgis-users] Exportar Shp
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
> <3d02109c0910130842t35b8ece7qa4abb46f8b383fd9 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> debes usar pgsql2shpbusca las opciones en la propia p?gina de postgis,
> puedes exportar un layer o tabla, como tambi?n exportar una determinada
> consulta.
>
> saludos
> Cristian O.
>
>
>
> 2009/10/13 Manuel Castro <cp.manuel at gmail.com>
>
> > Solicito que alguien me explicara como poder exportar un shp desde
> > postgresql
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20091013/6d7d2872/attachment-0001.html>
>
> ------------------------------
>
> Message: 19
> Date: Tue, 13 Oct 2009 18:10:59 +0200
> From: Jorge Ar?valo <jorge.arevalo at gmail.com>
> Subject: Re: [postgis-users] Exportar Shp
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID:
> <cb4457700910130910r1a5405bka89c605b56b93528 at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> You could use ogr2ogr too: http://www.gdal.org/ogr2ogr.html
>
> [SP] Por favor, escribe en ingl?s. Conseguir?s m?s ayuda de esa manera. [/SP]
>
> 2009/10/13 Cristian Olgu?n Avila <cristianolguin at gmail.com>:
> > debes usar?pgsql2shp
> > busca las opciones en la propia p?gina de postgis, puedes exportar un layer
> > o tabla, como tambi?n exportar una determinada consulta.
> > saludos
> > Cristian O.
> >
> >
> >
> > 2009/10/13 Manuel Castro <cp.manuel at gmail.com>
> >>
> >> Solicito que alguien me explicara como poder exportar un shp desde
> >> postgresql
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
>
> ------------------------------
>
> Message: 20
> Date: Tue, 13 Oct 2009 09:59:08 -0700
> From: Martin Davis <mbdavis at refractions.net>
> Subject: Re: [postgis-users] Question
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> Message-ID: <4AD4B1DC.6050103 at refractions.net>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Simon,
>
> Here's some ideas for areas where I think there is a significant
> difference between Oracle and PostGIS
>
> - Oracle's tolerance-based precision model VS ??? in PostGIS
> - 3D support
> - Geodetic data support
> - robustness (may be hard to provide examples, but I have seeen some
> fairly simple functions (eg buffer) completely kill the Oracle
> instance. PostGIS no doubt has its own failure modes)
> - external tools for loading and viewing spatial data
>
>
>
> Simon Greener wrote:
> > Folks,
> >
> > I am giving a talk at FOSS4G in Sydney next week. That talk's title
> > and abstract are:
> >
> > ==================================================================
> > Title: PostGIS and Oracle Spatial
> > Abstract:
> > Oracle Spatial and PostGIS are two of the most mature implementations
> > of a spatial type system for their relevant host databases.
> >
> > With Postgres increasing in strength, and offshoot EnterpriseDB aiming
> > to convert businesses running Oracle to EnterpriseDB/Postgres, the
> > question of the relative merits of each of the spatial implementations
> > arises.
> >
> > This talk will attempt to provide the audience with an understanding
> > of the relative strengths and weaknesses of the two implementations so
> > that they can feel they have some useful information which might aid
> > decision making for new installations or conversions.
> > ==================================================================
> >
> > While I already have quite a bit of material I thought I would ask the
> > PostGIS community for suggestions as to what they would like covered
> > if they were attending FOSS4G. Nothing worse than attending a
> > presentation and, at the end, saying to youself that it was not what
> > you expected and that nothing much was of use.
> >
> > So, what sorts of things do you think should be covered?
> >
> > regards
> > SImon
>
> --
> Martin Davis
> Senior Technical Architect
> Refractions Research, Inc.
> (250) 383-3022
>
>
>
> ------------------------------
>
> Message: 21
> Date: Tue, 13 Oct 2009 20:38:46 +0300
> From: Grant Masan <grant.massan at gmail.com>
> Subject: [postgis-users] Split / Divide linestring into parts /
> segments ?
> To: postgis-users at postgis.refractions.net
> Message-ID:
> <c09b5d640910131038q1e0cf17aj7ddee29d1df3f4f1 at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi all,
> I am having this kind of problem that I have one linestring("door") and then
> I am searching how many linestrings has intersect the linestring("door").
> I am getting the intersections thats not a problem. What I need is to split
> / divide this "door" linestring to segments or parts or what ever...
> So my goal is to devide "door" into 30 different parts (like if door is
> 30meters then I need thirty 1meter pieces). Then I can calculate how many
> linestrings are intersecting door
> and in what part of door.
>
> linestring "door"
>
> <----1------><-----2-----><------3------><-------5-----><-----6-------> and
> so on ...
>
> Hope you guys undestood my need and somebody can help me little bit !
>
> Thanks mates
>
> Br.
> Grant
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20091013/fc36fead/attachment-0001.html>
>
> ------------------------------
>
> Message: 22
> Date: Tue, 13 Oct 2009 14:51:50 -0400
> From: "Paragon Corporation" <lr at pcorp.us>
> Subject: Re: [postgis-users] Split / Divide linestring into parts /
> segments ?
> To: "'PostGIS Users Discussion'"
> <postgis-users at postgis.refractions.net>
> Message-ID: <A0F839D753544905836C3A321A22F08B at H>
> Content-Type: text/plain; charset="us-ascii"
>
> Grant,
> We have an example something like this in the docs. Look at the example that
> cuts a linestring into 100 unit length segments. In your case if your SRID
> is in meters you should be able to change the 100 to 30.
>
> http://www.postgis.org/documentation/manual-svn/ST_Line_Substring.html
>
> Not quite sure its what you are looking for but sounds like it .
> Hope that helps,
> Regina
>
> _____
>
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Grant
> Masan
> Sent: Tuesday, October 13, 2009 1:39 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Split / Divide linestring into parts / segments ?
>
>
> Hi all,
>
> I am having this kind of problem that I have one linestring("door") and then
> I am searching how many linestrings has intersect the linestring("door").
> I am getting the intersections thats not a problem. What I need is to split
> / divide this "door" linestring to segments or parts or what ever...
> So my goal is to devide "door" into 30 different parts (like if door is
> 30meters then I need thirty 1meter pieces). Then I can calculate how many
> linestrings are intersecting door
> and in what part of door.
>
> linestring "door"
>
> <----1------><-----2-----><------3------><-------5-----><-----6-------> and
> so on ...
>
> Hope you guys undestood my need and somebody can help me little bit !
>
> Thanks mates
>
> Br.
> Grant
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://postgis.refractions.net/pipermail/postgis-users/attachments/20091013/3afd37d9/attachment-0001.html>
>
> ------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> End of postgis-users Digest, Vol 86, Issue 13
> *********************************************
>
--
Ahmet Temiz
Jeo. Müh.
Afet İşleri Gen. Md.lüğü
Deprem Ar. D.
Ahmet Temiz
Geo. Eng.
General Dir. of
Disaster Affairs
TURKEY
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
More information about the postgis-users
mailing list