Hello Stephan,
and which number is for lat/lng?
----- Ursprüngliche Mail -----
Von: "Stephan Holl" <stephan.h...@intevation.de>
An: postgis-users@postgis.refractions.net
Gesendet: Dienstag, 8. Februar 2011 12:34:41
Betreff: Re: [postgis-users] multipolygom
Hello Marcel,
Marcel Kroschel <marcel.krosc...@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.h...@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
