I'm strugeling with a query I should write to UPDATE my dataset.
First of all, I have 2 tables containing data and I need to mix it.
Tabel 1 -- lets call it names:
- the_geom (points)
Table 2 -- lets call it objects:
- the_geom (polygons)
Now i want to do a cross selection and update my objects table. If a point is in the polygon it should update the objects.name_str with the value in the names.name_str.
Please keep in mind that I have over 2 mil datasets in the table!
I tried a selection query like this without success:
SELECT * FROM name, object WHERE st_contains(the_geom, way)='t' LIMIT 10
Please help! I have no clue where the error is hidden!