Hi Chandler,
Did you check projection system of the both Geometries? Just to make sure, use
ST_TRANSFORM as inner function.
regards
Muhammad Imran
--- On Fri, 8/3/12, CHANDLER DOUGLAS COLEMAN <chandler.d.cole...@stu.mmu.ac.uk>
wrote:
From: CHANDLER DOUGLAS COLEMAN <chandler.d.cole...@stu.mmu.ac.uk>
Subject: [postgis-users] area and distance
To: "postgis-users@postgis.refractions.net"
<postgis-users@postgis.refractions.net>
Date: Friday, August 3, 2012, 3:01 AM
#yiv946520484 P {margin-top:0;margin-bottom:0;}
Hello,
I am a newbie to PostGIS. I am hoping some one can explain to me why the
following simple query doesn't return any info:
SELECT f.fact_name
FROM factory AS f, inner_area AS i
WHERE i.name = 'Dewsbury'
AND ST_WITHIN (f.geom,i.geom);
I have geom in as a column and I have 'Dewsbury' as a polygon record in
inner_area and there are 5 records in factory that fall within this polygon.
But the resulting table shows that none were selected.
My assumption here is that the SQL statement is correct, but that something is
wrong with the tables: could it be how I imported the two tables from
shapefiles.
Thanks,
Chandler
-----Inline Attachment Follows-----
_______________________________________________
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
