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
2answers
138 views

ESRI QueryLayer + Javascript API - map displays inconsistent results

We recently migrated one of our map services from FGDB to an SQL Server spatial db backend. We are noticing a problem now in that the map appears to display locations inconsistently. I created a ...
3
votes
1answer
1k 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 ...
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 ...
0
votes
1answer
78 views

Intersection of two tables using the matching values in multiple fields

Primary usage of ArcGIS Desktop Basic: I have to find the intersection of two tables in the same file geodatabase based on the values in multiple fields. Almost all queries to find some help are ...
0
votes
1answer
509 views

CartoDB layer selector - selecting data from 2 layers

I used the CartoDB layer selector example (http://cartodb.github.io/cartodb.js/examples/layer_selector.html) with my data. Works fine. Now, what I really want to do is to select data from 2 layers at ...
0
votes
1answer
98 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
125 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 ...
4
votes
0answers
102 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 ...
3
votes
0answers
694 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
460 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 ...
2
votes
0answers
189 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 ...
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 ...
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 ...
1
vote
0answers
21 views

QGis Graphic Query builder for PostGis

My question is about availabe QGis Plugins that could help me with the following issue: I have a PostGis database that has one shapefile as a main table and a lot of tables containing the shapefile's ...
1
vote
0answers
37 views

Can't specify OID field in arcpy.MakeQueryLayer_management

I manage a library of query layers and have recently had the need to apply the same update to a bunch of them at once. Seems the only way to do that in python is to create new ones and apply ...
1
vote
0answers
60 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
1
vote
0answers
100 views

Publishing map to ArcGIS Server with time enabled data and query joining transposed data with shapefile

I am trying to figure out if I can publish my map service to ArcGIS Server that has time enabled data and uses a query table.... The query table joins my transposed time data and my shapefile. When I ...
1
vote
0answers
280 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
0answers
93 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
0answers
260 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
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 ...
0
votes
0answers
39 views

Return table names for query layers using arcpy

The dataSource property for layers does not return the name of the tables used in query layers. Instead, it returns something like the following: 'Database ...
0
votes
0answers
37 views

Storing Select Statements for ArcGIS Query Layers: LYR Files vs Views vs Application Code

I've inherited maintenance of an extension to ArcGIS Desktop (ArcObjects, C#) that allows users to view spatial data and related attributes from our databases (SQL 2008 R2). This is of course ...
0
votes
0answers
50 views

Utilize a Domain for a Query Layer in ArcGIS

I'm using the ESRI "Web App Builder for Developer" and Robert Scheitlins "Enhanced Query" widget. I'm trying to create a map that allows users (mostly police officers) to select a Crime Code (of ...
0
votes
0answers
59 views

Rasterize layer with GDAL after attribute filtering

I am working with GDAL/OGR and I need to do the following task : I have a shapefile with many attributes. I performed a query over one of them, "type_of_building='Church'". I have done this with the ...
0
votes
0answers
81 views

Creating Query Layer with 1:M relationship in ArcGIS?

I am trying to create a query layer in ArcGIS which contains 1:M relationship, When i execute query i am getting blank feature class. My query is as below SELECT a.Industrialcode, a.Industrialname, ...
0
votes
0answers
318 views

ArcMap 10.1, the identify tool does not show feature attributes on a query layer on a PostgreSQL database. Why?

I'm developing an ArcGIS 10.1 desktop map editing application using ArcEngine and ArcObjects. I'm using a PostgreSQL database. After a direct database connection (using a query layer), I displayed the ...