A query layer is a layer or stand-alone table that is defined by a SQL query. Query layers allow both spatial and nonspatial information stored in a DBMS to be easily integrated into GIS projects.

learn more… | top users | synonyms

3
votes
1answer
543 views

Extract data from QueryLayer to Shapefile

I have a QueryLayer that I need to export as a shape file. This was previously implemented as an ArcSDE feature class which we converted to a QueryLayer (running against SQLServer) in order to have ...
4
votes
2answers
2k views

Adding data from a SQL Server Spatial database to ArcMap or ArcEngine application with ArcObjects for better performance

I have an ArcSDE geodatabase stored in MS SQL Server 2008 R2. The datasets in this geodatabase range from 10 record to 7 million records and there is a mixture of tables and spatial datasets (SQL ...
3
votes
2answers
2k views

How to query which features of all vector layers intersect with a given bounds?

I am writing a Openlayers map app, and wondering whether there's a better practice to query which features of which vector layers intersect with a given bounds.. It's certainly not a good idea to ...
4
votes
3answers
977 views

ArcMap query layer with Oracle Locator displaying no results

I have an Oracle 11g database setup with Oracle Locator. I have created a table with the this query: CREATE TABLE geotest (id NUMBER(38) NOT NULL, shape SDO_GEOMETRY); Then I inserted one point ...
7
votes
3answers
5k views

Why does query table return more records than expected?

I need to join one feature class and one table. This is a one to multiple join, therefore, my only option seems to be by creating a query table. My problem is that the fields I want to join do not ...