Spatial Join by ArcSDE

3278
6
Jump to solution
12-23-2015 08:29 AM
FlorianCADOZ
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
ThomasColson
MVP Frequent Contributor
6 Replies
JoeBorgione
MVP Emeritus

"table Position and an other table City"

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

That should just about do it....
0 Kudos
FlorianCADOZ
Occasional Contributor

This is spatial data!

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

0 Kudos
JoeBorgione
MVP Emeritus

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

That should just about do it....
0 Kudos
FlorianCADOZ
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
ThomasColson
MVP Frequent Contributor

you can do it with ST_INSTERSECTS:

Repetitive Attribute Values Automated with SQL

FlorianCADOZ
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