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

1
vote
1answer
288 views

Using Query Layers with ArcGIS Server 10.0 for Java on Linux

I have an ArcGIS Server 10.0 for Java running under Red Hat Linux. I would like to be able to publish a Map Document that I have created which has a working Query Layer connecting to Oracle 11g. In ...
0
votes
1answer
343 views

How to query osm data served by geoserver?

We have a specific point and would like to count all features in a circular area with center at that specific point. The data is: - Stored in a shapefile layer created in QGIS - Served by geoserver - ...
0
votes
1answer
103 views

How to detect(condition) if Query Layer Connection is failing?

I have a job (arcpy script) which relies on a query layer but it fails sometimes. It has to do with the query layer connection (the point where job fails randomly)- which is totally under the control ...
2
votes
2answers
798 views

Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?

I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)?? Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
4
votes
3answers
5k views

Query Layer with user-defined (dynamic) parameters in ArcGIS 10.1

I have prepared and published with ArcMap 10.1 to my ArcGIS Server a Query Layer to access some information in my database. My output map represents the European Union states and using annotations, ...
2
votes
0answers
85 views

queried layer is not updating after drawing new feature in original shapefile

I have a project in qgis 1.8 where I added the same shapefile 3 times. On 2 of them I made a query. The third one is for edditing purposes. When I change the value of one of the features (in the ...
3
votes
1answer
282 views

How to clip a Oracle query layer directly in a Python script?

I have a query layer directly running from ORACLE database in a MXD. I want to clip this layer with a layer being created in another MXD in a Python based tool. My question is to do this clip ...
5
votes
1answer
1k views

ArcGIS Query Layer performance documentation or feedback

I first tried asking this question in the ArcGIS forums but as is common I got a total of 0 responses. I'm willing to accept this may be due to a lack of knowledge on the subject, but I'm optimistic. ...
2
votes
2answers
306 views

Negative values in ArcGIS API for Flex app?

I have a contractor working for me on a Flex application. He retrieves recordset for a intersect query from the web service published in house. But he is getting some ids as negative random number ...
2
votes
1answer
500 views

Query a polyline layer using arcGIS's Javascript API

I'm attempting to query a polyline layer using the ArcGIS Javascript API I all ready have a lot of experience doing this with Point layers. So I set my Polyline layer up the same way and stopped and ...
1
vote
1answer
290 views

Using database tables with bigint columns in ArcMap query layer?

I am very new to GIS and am using the ArcMap 10 program. Currently, I am trying to set up a query layer from a remote database. I am able to connect to the database, but I am having trouble making ...
2
votes
1answer
633 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
474 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
499 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 ...
10
votes
5answers
28k 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
97 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
573 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
1k 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
6k 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 ...