sql syntax arcSDE query layer points within polygon

Question

Hi all,

We have a Microsoft sql server which our ArcSDE is located on.

In the database are a collection of feature classes.

I want to add a query layer using 2 feature classes.

It's a simple query involving a points FC & a polygon FC.

I want to query points which are within a polygon based on an attribute.

for example:

select * from FC_Points, FC_Polygon

where FC_Points are within FC_Polygon and FC_Points.ID = FC_Polygon.ID

could someone point me in the right direction to write the syntax?

Many thanks

TimDunlevie2 · Answer

Gotcha…thanks.

Regards,

Tim

VinceAngelo · Answer

You can make the Query Layer SQL expression as complex as you like, but you may be better off prototyping the SQL using Management Studio first, since it can give you more syntax information.

- V

TimDunlevie2 · Answer

Hi Vince,

Righto – thanks for the info….might not have structured that post correctly…

What I was attempting to do is “add query layer” from our enterprise geodatabase via ArcMap.

And was hoping to add a fairly detailed SQL expression to get the result I wanted and wanted some help in the sql commands that would work.

If you think it’s best to do this on the actual Microsoft sql database then I’ll do it that way.

Thanks,

Tim