[postgis] Windows cygwin build

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[postgis] Windows cygwin build

Doug Nebert-2
I have cygwin installed on my Windows 2000 Pro system but
am still unable to compile things correctly though I seem to
be able to run executables compiled elsewhere. Can someone
provide (or maybe even post at refractions on a regular basis)
the full postgres/postgis installation for cygwin?

Doug.



To unsubscribe from this group, send an email to:
[hidden email]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 



Reply | Threaded
Open this post in threaded view
|

Re: [postgis] Windows cygwin build

Paul Ramsey-2
Hi Doug,
I will be attempting to do compiles on CygWin over the next couple
weeks, and may try to do some packaging, however, no promises. I am also
going to be working on a proposal for some gov't grant dollars to
support PostGIS development, which is pretty important also :)
Definately, in an ideal world we would have RPMs, DEBs, setup.exe's and
PKGs, however, all that takes work and thus far the amount of
compensation we have been able to derive from PostGIS work has been
pretty limited. Our optimism knows no bounds, however :)
TTYL,
Paul

DeeNebert wrote:

>
> I have cygwin installed on my Windows 2000 Pro system but
> am still unable to compile things correctly though I seem to
> be able to run executables compiled elsewhere. Can someone
> provide (or maybe even post at refractions on a regular basis)
> the full postgres/postgis installation for cygwin?
>
> Doug.
>
> To unsubscribe from this group, send an email to:
> [hidden email]
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of
VeriSign's FREE Guide "Securing Your Web Site for Business." Get it now!
http://www.verisign.com/cgi-bin/go.cgi?a=n094442340008000
http://us.click.yahoo.com/6lIgYB/IWxCAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[hidden email]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 



Reply | Threaded
Open this post in threaded view
|

RE: [postgis] Windows cygwin build

Norman Vine
In reply to this post by Doug Nebert-2
DeeNebert writes:
>
>I have cygwin installed on my Windows 2000 Pro system but
>am still unable to compile things correctly though I seem to
>be able to run executables compiled elsewhere. Can someone
>provide (or maybe even post at refractions on a regular basis)
>the full postgres/postgis installation for cygwin?

I will post a new versions as I compile them.

But IMHO it is probably more important to figure out
why you can not get it to compile.

FWIW
I am always running a very current < developers version of Cygwin >
but this should not make any difference and if it does I want to know
why so that I can alert the Cygwin team that it is time to make a new
release.

What problems are you encountering trying to build PostGIS ??

Norman Vine

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of
VeriSign's FREE Guide "Securing Your Web Site for Business." Get it now!
http://www.verisign.com/cgi-bin/go.cgi?a=n094442340008000
http://us.click.yahoo.com/6lIgYB/IWxCAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[hidden email]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 



Reply | Threaded
Open this post in threaded view
|

[postgis] Point within circle

David Blasby-3
In reply to this post by Doug Nebert-2
Due to Doug's request, I've added a new postgis function;

point_inside_circle(geometry, Px, Py, d)
        - returns true if there is a point in geometry whose distance to
(Px,Py) is < d


For example for the table,

t2=# select * from ttt;
   the_geom  
--------------
 POINT(10 10)
 POINT(10 0)
(2 rows)

You get these results;


t2=# select point_inside_circle(the_geom,10,10,0.1) from ttt;
 point_inside_circle
---------------------
 t
 f
(2 rows)


You can also do a more optimized search (see below).  This will first do
an index search to find all the points that are inside the BOX3D (dont
forget to build your GIST index first).  The geometries that pass this
are then put through point_inside_circle(the_geom,0,0,11).

select * from <table> where point_inside_circle(<geom column
name>,0,0,10) and <geom column name> && 'BOX3D(-10 -10,10 10)'::BOX3D;

Obviously, the BOX3D is BOX3D(Px-d   Py-d    ,   Px+d   Py+d)

dave
ps. We're currently getting ready to release PostGIS 0.5.  This function
will be in that release.

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Secure your servers with 128-bit SSL encryption! Grab your copy of
VeriSign's FREE Guide "Securing Your Web Site for Business." Get it now!
http://www.verisign.com/cgi-bin/go.cgi?a=n094442340008000
http://us.click.yahoo.com/6lIgYB/IWxCAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[hidden email]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/