topic Re: Spatial Join by ArcSDE in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829610#M4176 <HTML><HEAD></HEAD><BODY><P>And a bread and butter spatail join won't work for you?</P></BODY></HTML> Mon, 28 Dec 2015 00:33:43 GMT JoeBorgione 2015-12-28T00:33:43Z Spatial Join by ArcSDE https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829607#M4173 <HTML><HEAD></HEAD><BODY><P>"Hello world"!</P><P></P><P>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.</P><P>I searched <A href="http://desktop.arcgis.com/fr/desktop/latest/manage-data/using-sql-with-gdbs/st-contains.htm">there</A>​ 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...</P><P></P><P>Thank you by advanced!</P></BODY></HTML> Wed, 23 Dec 2015 16:29:26 GMT https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829607#M4173 FlorianCADOZ 2015-12-23T16:29:26Z Re: Spatial Join by ArcSDE https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829608#M4174 <HTML><HEAD></HEAD><BODY><P>"<EM><STRONG>table Position and an other table City</STRONG></EM>"</P><P></P><P>These are just tables or spatial data (feature class; point, line or polygon)</P></BODY></HTML> Wed, 23 Dec 2015 16:33:41 GMT https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829608#M4174 JoeBorgione 2015-12-23T16:33:41Z Re: Spatial Join by ArcSDE https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829609#M4175 <HTML><HEAD></HEAD><BODY><P>This is spatial data!</P><P>Points for the Position's table and polygon for City's table!</P></BODY></HTML> Sun, 27 Dec 2015 17:36:12 GMT https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829609#M4175 FlorianCADOZ 2015-12-27T17:36:12Z Re: Spatial Join by ArcSDE https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829610#M4176 <HTML><HEAD></HEAD><BODY><P>And a bread and butter spatail join won't work for you?</P></BODY></HTML> Mon, 28 Dec 2015 00:33:43 GMT https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829610#M4176 JoeBorgione 2015-12-28T00:33:43Z Re: Spatial Join by ArcSDE https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829611#M4177 <HTML><HEAD></HEAD><BODY><P>Joe,</P><P>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.<STRONG>​...</STRONG></P></BODY></HTML> Mon, 28 Dec 2015 08:54:49 GMT https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829611#M4177 FlorianCADOZ 2015-12-28T08:54:49Z Re: Spatial Join by ArcSDE https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829612#M4178 <HTML><HEAD></HEAD><BODY><P>you can do it with ST_INSTERSECTS:</P><P></P><P><A href="https://community.esri.com/migration-blogpost/2176">Repetitive Attribute Values Automated with SQL</A> </P></BODY></HTML> Wed, 20 Jan 2016 12:50:54 GMT https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829612#M4178 ThomasColson 2016-01-20T12:50:54Z Re: Spatial Join by ArcSDE https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829613#M4179 <HTML><HEAD></HEAD><BODY><P>Oh yeah, I forgot to answer to my own question !</P><P>Indeed, I used ST_Intersect in a subquery and it works fine ! </P></BODY></HTML> Wed, 20 Jan 2016 13:29:58 GMT https://community.esri.com/t5/geodatabase-questions/spatial-join-by-arcsde/m-p/829613#M4179 FlorianCADOZ 2016-01-20T13:29:58Z