Spatial Join by ArcSDE

[FlorianCADOZ]

"Hello world"!

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!

[JoeBorgione]

"table Position and an other table City"

These are just tables or spatial data (feature class; point, line or polygon)

[FlorianCADOZ]

This is spatial data!

Points for the Position's table and polygon for City's table!

[JoeBorgione]

And a bread and butter spatail join won't work for you?

[FlorianCADOZ]

Joe,

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.​...

[ThomasColson · Accepted solution]

you can do it with ST_INSTERSECTS:

Repetitive Attribute Values Automated with SQL

[FlorianCADOZ]

Oh yeah, I forgot to answer to my own question !

Indeed, I used ST_Intersect in a subquery and it works fine !