I've got a database with a table Position and an other table City, and I'ld like to check for each entity in Position if it's contains in a City, and if it is, put the id_city from the City's table to the Position's one.
I searched there but there's nothing like the spatial relation I would like to do ! So, I guess I have to do a process based on the ST_Contains but I don't know how to do...
Thank you by advanced!
Solved! Go to Solution.
you can do it with ST_INSTERSECTS:
"table Position and an other table City"
These are just tables or spatial data (feature class; point, line or polygon)
This is spatial data!
Points for the Position's table and polygon for City's table!
And a bread and butter spatail join won't work for you?
I have to industrialize a process of treatment, that's why I can not use classic Desktop features but I am forced to use SDE features....
Oh yeah, I forgot to answer to my own question !
Indeed, I used ST_Intersect in a subquery and it works fine !