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

5
votes
3answers
8k 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: ...
5
votes
4answers
105 views

uDig window to change between historical dates?

I'm new to uDig, but I'm experienced Java developer. I have points with temperature measurements that change overtime in SQL database. I would like to give user ability to change between historical ...
4
votes
2answers
1k 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 ...
4
votes
3answers
899 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 ...
4
votes
1answer
997 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. ...
4
votes
0answers
57 views

Adding data from PostgreSQL to Query Layer of ArcGIS for Desktop warns that given coordinate references are incompatible?

When adding data from PostgreSQL in a Query Layer I get the warning "The given coordinate references are incompatible" I have added many other layers with the same properties no problems, but I have ...
4
votes
1answer
157 views

How can I exclude a field on a table from being copied?

I have a query "layer": >>> r = arcpy.MakeQueryLayer_management(r'C:\path\to\connection\file\connection.sde', 'TEST', 'SELECT T.ID AS OBJECTID, T.* FROM MY_TABLE T WHERE T.SOME_COLUMN = 1', ...
3
votes
1answer
618 views

Use arcpy to connect to database without connection file

It seems like arcpy can only work with connection files. This creates one of two problems: Deployment requires manual creation of connection files. We have to write a bunch of code to recreate the ...
3
votes
1answer
505 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 ...
3
votes
0answers
53 views

Changing workspace path of query layer using ArcPy?

I'm trying to change the workspace path of a query layer using the code below and it always breaks. The layer is connected to a view in an Oracle Spatial 10g database. The database is SDE enabled ...
3
votes
0answers
166 views

ArcGIS FeatureService/Dynamic Map Service using SQL joins and aggregations

I have a bunch of operational tables, some contain spatial data, some do not. In order to fulfill all my operational mapping reports, I will need to have the flexibility to have feature services or ...
3
votes
1answer
232 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 ...
2
votes
2answers
2k views

Spatial query in ArcGIS Javascript Api 3.1

I have scenario in which I have to select features drawing a polygon and and get the attribute values in to a tables or lists.The features on the map consist of polygon, line,point at the same time so ...
2
votes
2answers
557 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 ...
2
votes
2answers
106 views

Defining OID causes Query Layer on PostGIS to disappear from ArcMap?

I used query layer to load my layer from PostGIS and show it in ArcMap 10, I had two cases; if I defined the OID in the configuration of connection, there was no problem with the attribute table of ...
2
votes
1answer
140 views

Table analog of MakeQueryLayer

As of 10.1, arcpy provides the rather handy MakeQueryLayer function. This allows us to use arcpy to create query layers programmatically instead of having to go through MXDs (as was the case in 10.0). ...
2
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 ...
2
votes
1answer
726 views

how to add a query layer to a mxd in a python script

I want to add a query layer to an arcmap document so that whenever i have a db data update, it is reflected in my ma and I can update my service through python script. This is my script so far... ...
2
votes
1answer
81 views

Model Builder Query by date

I've created a model that does several spatial joins based off of a lat/long in a table. In the table, I have a "Modified_date" which gives year, month, date, time. This model is set to run ...
2
votes
1answer
636 views

Why is Oracle Spatial Query Layer Not Displaying in ArcMap?

I am having an issue with an Oracle query layer using SDO_Geometry not displaying. I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a ...
2
votes
0answers
72 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 ...
2
votes
0answers
84 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 ...
1
vote
1answer
374 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
301 views

Can I create an Oracle Spatial View from a non-spatial table?

Let's say I have an Oracle database table with latitudes and longitudes. I don't have access to modify the schema of this table, or even create tables. However, I can create views and indexes on those ...
1
vote
1answer
66 views

How to connect ArcMap 10.0 query layer to a different port?

I have an instance where I have a server that has postgres 8.3 and postgres 9.2 on it. I have the 8.3 version on port 5432 and 9.2 on port 5433. I want to connect to the 9.2 instance, here is a ...
1
vote
1answer
244 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 ...
1
vote
0answers
51 views

Query layer in ArcGIS 10.2.2 with PostgreSQL not querying data

After some days I was finally able to import OSM data to a PostgreSQL database and connect it with ArcGIS 10.2.2 I can load every piece I want by simple clicking "Add data ..." however a SQL query ...
1
vote
1answer
37 views

Adding PostGIS query layer says Query class name is invalid?

I am having issues with adding postgis query layers in ArcMAP 10.2.2.3552, not doing anything special just adding a layer, this works in 10.2.1 so I don't know if its a bug or something Also this ...
1
vote
0answers
42 views

Real-time Feature/Geometry Aggregation in Map Service Layer

Use-Case Provide a map service layer that perform a real-time aggregation of geometry objects grouped on a set of criteria from a normalized data source, labeling the resulting image based on data ...
1
vote
1answer
265 views

ArcGIS Publish query layer as Feature Service fails

I have a query layer that's simply a DB view call in PostgreSQL, the view is as such: CREATE OR REPLACE VIEW daily_query AS SELECT b.id, b.first_name, b.last_name, c.assignment_date::date ...
1
vote
0answers
151 views

ArcGIS Query Layer SQL Server Performance Issue

I'm experiencing a performance issue with ArcGIS Query Layer using non-sde Sql Server 2008 R2. Actually, I'm using a rather comprehensive view that pulls and joins data from multiple databases and ...
1
vote
0answers
123 views

How can I retrieve/query data from shape file for forms/grid in website?

I've made a site using openlayers and geoserver. currently im serving WMS layers from geoserver (shape files). I want to add in my site a search form that the user can search for data (which I have in ...
1
vote
2answers
65 views

How to create thinner outside boundary outlines with bolder interior lines [closed]

I am working with a shapefile with a jagged coastline and interior regional boundaries. I am trying to create a thin line for the coast, so it appears more clearly, while still keeping bold, thicker ...
1
vote
1answer
180 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 ...
1
vote
0answers
370 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 ...
0
votes
1answer
246 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
306 views

Why does reading shapefile from PostgreSQL database give Error reading OID from table …?

I'm using arcgis 10.1 and i have a connection to a PostgreSQL 9.3 database. When i try to load a shapefile using the add query layer I get an error when opening the attribute table. The error says ...
0
votes
1answer
358 views

ArcGIS Android Reverse geocoding, Cannot perform query. Invalid query parameters

I'm trying to write reverse geocoding. And i copied code given here... Here is my code sample.. public class MagProActivity extends Activity { private MapView mMapView; ...
0
votes
1answer
90 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 ...
0
votes
1answer
74 views

Requesting help designing the query in a Query Layer

I am pulling data from our OMS SQL database to show our SAIDI and SAIFI numbers visually for our operations department. I have a functioning query that can pull in the needed data, and currently I ...
0
votes
1answer
62 views

run a make query table based on a selection

I have a feature class of land parcels. I do a select by location to select the land parcels that intersect a line feature. Now I want to use the Make Query Table tool in model builder. I include the ...
0
votes
0answers
67 views

OpenLayers: WMSGetFeatureInfo shouldn't return feature when a layer is hidden

In OpenLayers, I have a map with several layers. I created a control to query the layers and return feature info. var info= new OpenLayers.Control.WMSGetFeatureInfo({ ...
0
votes
1answer
408 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, ...