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

2
votes
1answer
586 views

Accessing PostGIS raster data using Query Layer in ArcGIS Desktop?

I tried to load raster file (jpg) into post gis using the syntax provided here "C:\Program Files (x86)\PostgreSQL\9.1\bin>raster2pgsql -I -C -e -Y -F -s 102003 -t 300x300 ras_test.tif ras_test1 | psql ...
0
votes
1answer
445 views

ArcGIS Server REST-Query Layer: only few attribute fileds are returned in response

a newbie question in using ArcGIS Server REST service: from ArcGIS Services Directory, I opened the page of one layer in a MapServer service, this layer has a long list of attributes/fields. however, ...
1
vote
0answers
431 views

Cannot join feature layer with SQL Server table with query built in it in ArcMap

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder. When I ...
7
votes
5answers
16k views

How to create a new layer from a selection in QGIS?

I have been using ArcMap for the last three years. But I am now considering switching to Quantum-GIS. Is it possible to create layers from selection in QGIS? I am using QGIS 1.7.4-Wroclaw. UPDATE: ...
2
votes
0answers
91 views

Determine which points fall within a 3D polygon and export this subset to a flat file

I am working in ArcMap 10 and will have a 3D representation of a zone of transmission. I would like to determine which GPS points fall within this polygon and then export this subset out to a flat ...
3
votes
1answer
544 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
989 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 ...