Spatial Join by ArcSDE

2588
6
Jump to solution
12-23-2015 08:29 AM
Highlighted
Occasional Contributor

"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!

1 Solution

Accepted Solutions
Highlighted
MVP Frequent Contributor
6 Replies
Highlighted
MVP Esteemed Contributor

"table Position and an other table City"

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

0 Kudos
Highlighted
Occasional Contributor

This is spatial data!

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

0 Kudos
Highlighted
MVP Esteemed Contributor

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

0 Kudos
Highlighted
Occasional Contributor

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

0 Kudos
Highlighted
MVP Frequent Contributor
Highlighted
Occasional Contributor

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

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

0 Kudos