I have a large amount of data stored in a PostGRES database, that I have been able to access using a Query Layer through ArcMap. My first question is a) Can the database be spatially queried using a local shapefile - e.g. SELECT FROM <PostGRES Table> WHERE <PostGRES geometry> INTERSECTS <localshapefile located in my C:\Temp>. I know that's not the actual syntax, but the main point is whether I can use a local file to do the querying or if it needs to be loaded into the PostGRES database. and if this is possible - what would the proper syntax look like? Probably involving ST_INTERSECTS()... Thanks,
... View more