[postgis-users] multipolygom

[Marcel Kroschel]

Hello Stephan,
and which number is for lat/lng? 

----- Ursprüngliche Mail -----
Von: "Stephan Holl" <stephan.holl at intevation.de>
An: postgis-users at postgis.refractions.net
Gesendet: Dienstag, 8. Februar 2011 12:34:41
Betreff: Re: [postgis-users] multipolygom

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

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users