[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 many of

[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,

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] 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',

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