[postgis-users] st_within maddness

[Maxime van Noppen]

On 07/24/09 16:46, Kevin Galligan wrote:
> Might I ask where you get the definition of srid '900913'?  I know I
> had to insert that myself from something I found on the web.  I'm
> shooting in the dark here, but that's another possible variable in the
> mix.

I didn't check the SRID value but PostGIS said nothing about it :

> tmp=# create table testwithin(id int);
> CREATE TABLE
> tmp=# SELECT AddGeometryColumn('testwithin','bbox',900913,'POLYGON',2);
>                    addgeometrycolumn                    
> --------------------------------------------------------
>  public.testwithin.bbox SRID:900913 TYPE:POLYGON DIMS:2
>   
> (1 row)
> 
> tmp=# insert into testwithin(id, bbox) values(1, ST_SetSRID(ST_MakeBox2D(ST_Point(-8232000, 4980000),ST_Point(-8231900,
> 4980100)),900913));
> INSERT 0 1
> tmp=# select asewkt(bbox) from testwithin where st_within(bbox, ST_Buffer(ST_SetSRID(ST_MakePoint(-8232000, 4980000),900913), 500));
>                                                    asewkt                                                    
> -------------------------------------------------------------------------------------------------------------
>  SRID=900913;POLYGON((-8232000 4980000,-8232000 4980100,-8231900 4980100,-8231900 4980000,-8232000 4980000))
> (1 row)

AFAIK it's a vanilla PostGIS-1.3.6.

-- 
yabo