[postgis-users] multipolygom

[Stephan Holl]

Hello Marcel,

Marcel Kroschel <marcel.kroschel at kaufda.de>, [20110208 - 12:29:18]

> hi @all.
> Hope someone can help me ;)
> I uses postgis 1.5.2., create a table with with multipolygon and
> lng/lat coordinates called zip_polygon
> 
> SELECT AddGeometryColumn ( 'zip_polygon', 'geom', 4326,
> 'MULTIPOLYGON', 2 );
> 
> When ich want all polygons in distance i use this query:
> SELECT *
> FROM zip_polygon
> WHERE ST_DWithin(geom, ST_GeomFromText('POINT(13.171982 52.52646)',
> 4326), 0.02);
> 
> But the manual say, that the last entry is the distance in meter.
> When i replace the 0.02 to the value 1, then i get the whole list.

AFAIK it uses the map-units, which is in your case decimal degrees
(epsg:4326).

HTH

	Stephan

-- 
Stephan Holl <stephan.holl at intevation.de> | Tel.: +49 (0)541-33 508 3663
Intevation GmbH, Neuer Graben 17, 49074 OS  |  AG Osnabrück - HR B 18998
Geschäftsführer:  Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110208/3f9e3893/attachment.pgp>