MSSQL server and Spatial query on ArcSDE Database

FrancisMoisan

Hi!

We store our spatial data into a SDE geodatabase (with sde geometry) into a MSSQL server 2008 database.

I need to create a SQL query with spatial relation but need to perform the query onto the database wichi I think will be faster than a tool from ArcGIS.

 

I can do it with model builder or Python but very slow and need to write a table down into the database.

I just need to analyse and return a count of the result...

 

When I was using Oracle my query was :

 

SELECT *

FROM [my_points] pts, [my_area] poly

WHERE CODE_MUN NOT LIKE 'NR%'

and sdo_inside(pts.geoloc,poly.geom) = 'TRUE'

and pts.CODE_MUN <> poly.MUS_CO_GEO

 

How to do this into MSSQL server with sdebinary.

Any idea?

thanks!

VinceAngelo

GEOMETRY has been the default geometry storage since ArcGIS 10.1, I believe (certainly since 10.2), but that only applies to new installations.  SQL-Server 2008R2 is the least recent supported Microsoft database, so you may be using both older ArcGIS and RDBMS.

In the future, I recommend you post geedatabase management questions in GIS > Managing Data, and use a "geodatabase" tag, rather than relying on the "every post by time" feed for geodatabase experts to find your post.

- V