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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
