So I am trying to identify which items from the
requests table fall into some particular district from the
district table using
postgis. Basically, I am writing an
UPDATE query that will take the district number from the
district table and put that into the district field of the
requests table. Here is the query that I have been using so far, but it does not return any rows.
Note that the
requests table uses
POINT geometry while the
district table is a
update requests set req_district = districts.district from districts where st_intersects(requests.geom, districts.geom);
Note sure why such a simple query would not work. Am I missing something?