[postgis-users] within function

2007-08-07 Thread Dave Potts
I have a table with a list of places described as Geometry type POINT and a table loaded from a shape file, which takes the form of target (ie several inscribed circles), each is encoded as a MULTIPOLYGON. I am attempting to discover which point lie within within these circle. I had assumed

Re: [postgis-users] Again: ERROR: function 60821C60 returned NULL

2007-08-07 Thread Mark Cave-Ayland
On Mon, 2007-08-06 at 13:09 -0400, Burgholzer,Robert wrote: > I am experiencing an error that I have seen in the archives with the > title: “ERROR: function 60821C60 returned NULL”. Any help would be > appreciated. > > > > It seems that in the previous posts, a null geometry (or rather too > m

[postgis-users] st_dwithin()

2007-08-07 Thread Santosh Gaikwad
Hi All, I have installed PostGIS 1.2.1 version but I could not able to find out st_dwithin() in it. In which version this function will be available? Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Ma

Re: [postgis-users] within function

2007-08-07 Thread Mark Cave-Ayland
On Tue, 2007-08-07 at 09:06 +0100, Dave Potts wrote: > I have a table with a list of places described as Geometry type POINT > and a table loaded from a shape file, which takes the form of target > (ie several inscribed circles), each is encoded as a MULTIPOLYGON. I am > attempting to discover

RE: [postgis-users] Again: ERROR: function 60821C60 returned NULL

2007-08-07 Thread Obe, Regina
Just to add to what Mark said. I had this issue when switching over from 8.1 to 8.2. It was a problem with the GEOS library interaction with 8.2 which I think was fixed with Geos 3.0.0rc4 and above (there might have been a slightly lower version that fixed it.) If you are running 8.2 with Geos 2.

RE: [postgis-users] st_dwithin()

2007-08-07 Thread Obe, Regina
This was introduced in I think in 1.2.2. In short st_dwithin() is a short-hand way of writing geom1 && geom2 AND distance(geom1, geom2) <= somedistance Hope that helps, Regina From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Santosh Gaikwad

RE: [postgis-users] howto register an existing column intogeometry_columns

2007-08-07 Thread Obe, Regina
The only guaranteed way is to add the records in geometry_columns manually. With a command something like INSERT INTO geometry_columns( f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type") VALUES ('', 'public', 'sometable',

[postgis-users] Why choose PostGIS?

2007-08-07 Thread Alan Cunnane
Hey guys I have been using PostGIS for my dissertation now for 6 months and have found it extremely useful, fast and understandable and along with the support you get from this mailing group I have never regretted this decision. However as i am completing my write up I cant seem to find any sol

RE: [postgis-users] Why choose PostGIS?

2007-08-07 Thread Gregory Williamson
Alan, MySQL's spatial functionality is very limited IMHO -- they only have a bounding box intersection, similar to the && operator, and nothing like a "within" or distance function. So if you have, say, a lot of rectangular tiles and a query shape that is a large semi-circle, both MySQL and pos

RE: [postgis-users] Why choose PostGIS?

2007-08-07 Thread Jason Birch
Alan Cunnane wrote: -- I have read in some places that MySQL is not as OGC compliant as PostGIS however I need an official source to prove this. Can anyone send me any links to such proof or recommend any literature on this matter? Even one reference would do. --

RE: [postgis-users] st_dwithin()

2007-08-07 Thread Santosh Gaikwad
Hi, Is PostGIS 1.2.2 version available for download? If so, please provide the link for it. Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone : +91 20 66071397 Mo

[postgis-users] PostGIS 1.2.2 version

2007-08-07 Thread Santosh Gaikwad
Hi, Is PostGIS 1.2.2 version available for download? If so, please provide the link for it Thanks & Regards, Santosh Gaikwad Senior Software Developer Saama Technologies (India) Pvt Ltd. 6th Floor West Wing, Marisoft III, Marigold Premises, Kalayani Nagar, Pune - 411014. India Phone