when I run a query on Postgis
select st_astext(ST_SetSRID(f.geom,4326) ),st_astext(st_centroid(ST_Transform(b.wkb_geometry,4326))) from a,b where ST_Distance_Sphere( ST_Transform(a.geom,4269),ST_Transform(b.wkb_geometry,4269))<10 limit 1;
I got this message on my screen print in infinite loop
Coordinate values were coerced into range [-180 -90, 180 90] for GEOGRAPHY
to give you an idea about what I am getting when I fetch a.geom and wkb_geometry ?
select st_astext(ST_SetSRID(f.geom,4326) ),st_astext(st_centroid(ST_Transform(b.wkb_geometry,4326))) from a,b limit 1;
I got this :
POINT(-73.9798264975362 40.679599746172) | MULTIPOLYGON(((989878.855200246 186914.37490882,989831.404507741 186822.841299236,989812.018719748 186832.772053644,989859.469740331 186924.306319401,989878.855200246 186914.37490882))) |
what does that mean ? Does this affect results I am getting ?