Skip to main content
Geographic Information Systems

Questions tagged [query-layer]

Ask Question

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.

111 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
0 answers
49 views

We want to be able to pose arbitrary queries against a MS SQL Server spatial database and display the results in QGIS. One approach is to query the database with a separate pyodbc connection, loop ...
til_b's user avatar
  • 5,335
3 votes
1 answer
122 views

How can I create a query in a layer using the Model Designer in QGIS, like the example shown in the picture below? How i can make this in Model Designer?
MTH MHTd's user avatar
  • 31
0 votes
1 answer
85 views

Filtering query: INTERSECTS(the_geom, collectGeometries(queryCollection('sphaera:municipality_area', 'the_geom', 'INCLUDE')));INCLUDE Problem: geometry that is too complex generates a string that is ...
Vlad's user avatar
  • 1
1 vote
1 answer
104 views

I tried using Extract Multi Values to Points in ArcGIS Pro with a query layer for the points layer and a local geotiff for the raster. I received the error "ERROR 010560: Cannot create table or ...
ycartwhelen's user avatar
  • 2,506
3 votes
0 answers
116 views

I want to update a virtual layer using PyQGIS by modifying the layer name in the query. Although I have executed the following code, the virtual layer's query remains unchanged when I open the project ...
user234164's user avatar
  • 31
0 votes
0 answers
690 views

We have created a Query Layer in ArcGIS Pro. It connects to a SQL Server database asking for the result of a SQL Server User Defined Function (not a View). Its syntax is as shown below, where (...
Carlos G's user avatar
  • 1
2 votes
1 answer
1k views

About 90% of the layers on my maps are query layers from SQL Server database connection. My typical workflow is to drag and drop the spatial objects from the Catalog pane into the map frame and then ...
aakims's user avatar
  • 21
1 vote
1 answer
340 views

ArcGIS Pro 3.0.2 Is it possible to use the column of table in my Project to filter a query using the make query layer tool? I have a table of events in my project with a location_id column, and I want ...
sushi's user avatar
  • 405
0 votes
0 answers
161 views

Is there any way to add a feature class from a .sqlite database to ArcMap using ArcPy (Python)? If I drag and drop the feature class from the .sqlite database, ArcMap creates a Query Feature Class, ...
Emil Nielsen's user avatar
  • 1
2 votes
1 answer
916 views

I have the coordinates for 30000 locations I would like to to sample from raster layers. These locations are not located next to one another. This is currently done with an external python script and ...
Ethan's user avatar
  • 53
0 votes
0 answers
625 views

I have a query layer pulling from a SQL Server database that I use within ArcGIS Pro and am wondering if there is a way I can publish this to our GIS server (10.8.1) to maintain connectivity to the ...
Dmob17's user avatar
  • 5
1 vote
1 answer
617 views

I have created a Query Feature Class in ArcGIS Pro using point data that is stored in Snowflake (following the steps in this video https://www.youtube.com/watch?v=pnSaS95Rlqs). Is there a way to ...
DotPi's user avatar
  • 51
0 votes
1 answer
118 views

I have an Oracle 18c/SDE.ST_GEOMETRY polyline FC (15,000 features). I want to create a query layer (or db view) that will display the startpoints and endpoints of the lines in ArcGIS Pro. Is there a ...
User1974's user avatar
  • 1,246
0 votes
1 answer
143 views

I have an Oracle 18c non-spatial table that has textual IDs as the unique ID: The table doesn't have a ObjectID or numeric ID. I'm not able to add new columns to the table. The table isn't registered ...
User1974's user avatar
  • 1,246
1 vote
1 answer
1k views

I am trying to write a query that shows all the highway in an area, except for one feature in overpass-turbo. The query wizard in overpass-turbo has highway=* which shows everything. But I want to ...
Robert's user avatar
  • 13
3 votes
3 answers
1k views

I'm trying to compare 'layer A' with 'layer B'. Layer B is the result of the intersection between layer A and another layer C, so the elements in B are all contained in A. My goal is to create a new ...
anea's user avatar
  • 161
2 votes
1 answer
154 views

I'm having a minor issue with GetFeatureInfo and I quite frankly don't know how to solve it. It's a bit of a long story but here goes: When I make the following request to our GeoServer it'll return ...
Benjamin Mikkelsen's user avatar
  • 21
0 votes
1 answer
121 views

I have a point feature layer in ArcGIS Online. I want to create a query on top of that FC that will translate the data: Calculate and concatenate fields Use coded value domain descriptions instead of ...
User1974's user avatar
  • 1,246
0 votes
0 answers
68 views

I have a project in ArcMap 10.7. In this project I defined a query layer that join a polygon feature class (SDE) with an Oracle view (non spatial). For each polygon I have many (7) records in the ...
MarcoB3lotti's user avatar
  • 65
2 votes
1 answer
478 views

Oracle 18c; ArcGIS 10.7.1 I have a query that produces an ST_POINT column: --Mimics the SDO_GEOMETRY get_vertices function --https://docs.oracle.com/database/121/SPATL/sdo_util-getvertices.htm ...
User1974's user avatar
  • 1,246
1 vote
1 answer
229 views

I'm trying to load layers from PostGIS using the code bellow: uri = QgsDataSourceUri() uri.setConnection(server, PORT, base, user, mdp) root = QgsProject.instance().layerTreeRoot() group = root....
nmokht97's user avatar
  • 143
1 vote
1 answer
824 views

I am working within a Jupyter notebook, trying to display a query layer (querying a SQL database) into a map view within the notebook. I receive a Runtime Error (described below) when I try to add ...
ycartwhelen's user avatar
  • 2,506
2 votes
2 answers
1k views

In the image example below: Feature Line Layer = Transport - District Lookup Table = TRAFFIC_IMPACTOR_CODE What is the most efficient way to "connect" (join/relation/query/field calculator) both ...
Mars's user avatar
  • 385
1 vote
0 answers
81 views

Simple Query: I have a query that connects to a table in a work order management database (Oracle 12c; non-GDB). select wo.wonum from maximo.workorder wo The query returns 428 records in ...
User1974's user avatar
  • 1,246
3 votes
0 answers
538 views

I am working with GeoServer, WFS and have querylayer module installed. I have been trying to extract information around a featured points. For example, the location of all hospitals within 1000 ...
Zachary Liu's user avatar
  • 41
2 votes
0 answers
498 views

I have a large Postgres/PostGIS database table with ~100 million points that I need to have available for editing (mainly, removing points). Currently, I'm trying to use a QueryLayer in QGIS using ...
Todd's user avatar
  • 51
1 vote
1 answer
151 views

I have a query running against an Oracle non-spatial database that returns thousands of records, but when I run CopyRows against that query only 24 rows are carried over! What the heck is going on? I'...
matt wilkie's user avatar
  • 28.3k
0 votes
0 answers
901 views

I am attempting to add a query layer to ArcGIS Pro 2.1.2 via SQL Server. The table consists of Ticket_ID, Latitude, Longitude. The query layer works if I only add the top 1000 rows. However, when I ...
Ethan Heidtman's user avatar
  • 79
3 votes
2 answers
2k views

I'm using MakeQueryLayer to create a view from a database table in the ArcMap python window. The command completes successfully but I can't see the result. Where does it go? arcpy....
matt wilkie's user avatar
  • 28.3k
3 votes
1 answer
2k views

I am attempting to build an Operations Dashboard in our ArcGIS Online account using data from a SQL Server database. I’ve successfully added the data from SQL to ArcMap using the New Query tool, and ...
Steven C's user avatar
  • 177
1 vote
1 answer
452 views

As shown in the image below, I need to fetch query mentioned within query section of a layer using ArcObjects in C#. IDocument doc = ArcMap.Application.Document; IMxDocument ...
jay's user avatar
  • 141
2 votes
0 answers
85 views

I have a layer and the query for layer is a select query consisting of ID field in it. This query is being executed on top of Oracle and its throwing an exception for field "ID" when "ID" field is ...
jay's user avatar
  • 141
3 votes
1 answer
330 views

We have a SQL table view with point locations and are creating a query layer from it. However, the resulting points do not plot to the same location as the latitudes & longitudes in the table. In ...
user104307's user avatar
  • 41
1 vote
0 answers
139 views

I need to create a spatial view with Make Query Layer. My query includes outer joins, so I must combine every table's ID field to create a unique identifier. Since there might not always be a child ...
GISGe's user avatar
  • 9,684
2 votes
1 answer
203 views

I am having problem creating a query. I have a data map, which is organised in areas with codes (which in turn correspond to funding oportunities). I am trying to select for each code a layer. Up ...
Rita Machado's user avatar
  • 21
2 votes
0 answers
553 views

I am trying to establish a connection from ArcMap 10.0 -- Service Pack 5 to an Oracle DB (I thought it was 10g if might be 11g) on windows 7.. It is windows have connected to the database via Catalog....
Ethan Heidtman's user avatar
  • 79
7 votes
2 answers
1k views

In ArcGIS Desktop 10.4, is it possible to edit programmatically with Python the SQL query of a Query Layer? I'm not referring to the Definition Query of the layer, but to the window that is manually ...
Andreampa's user avatar
  • 730
2 votes
1 answer
834 views

My project starts from a MXD containing Query Layers. I have to prepare the data in this "MasterMXD" for use in an offline application. Working with ArcMap 10.2.1 for this project. My Python script ...
Wout's user avatar
  • 139
2 votes
1 answer
129 views

I have managed to connect to my OSM data using database connections in ArcGIS Desktop. I have the OSM line, point, polygon and roads tables. Now I am trying to query the tables using the Add New ...
Jon McCloskey's user avatar
  • 29
2 votes
1 answer
453 views

I use ArcMap 10.3 to create a query layer of points. The layer is used in a JavaScript API map as a ArcGISDynamicMapServiceLayer. Each point has two attributes: point_color and frame_color. I have 10 ...
Daniel H's user avatar
  • 21
-1 votes
1 answer
1k views

Composing a map using query layers in ArcGIS 10.4.1 (Basic) the final step is to backup the data used when the map is finalised. Exporting manually is straight forward. But using the conversion tool ...
stevo's user avatar
  • 47
1 vote
0 answers
125 views

I am trying to add WFS capabilities to an existing MXD, but it throws errors for multiple references to a Feature Class. To work around this, I've tried two options: Creating database views and ...
guest1111's user avatar
  • 11
2 votes
1 answer
131 views

I have a query layer that is published onto arcGIS server. I am having difficulty returning the fields in a javascript application. I need to be able to iterate over this array. Code is bellow.. ...
LCaraway's user avatar
  • 339
2 votes
1 answer
1k views

I am connecting to a SQL Server 2016 database, and adding data into ArcMap 10.3.1 as a Query Layer. I want to publish this data as a Feature Access service to ArcGIS Server 10.3.1. I have no problems ...
a1234's user avatar
  • 911
0 votes
2 answers
1k views

I have access to two databases, each with a separate connection. The first connection is an .sde connection to a SDE 10.3.1 Oracle database, and the second connection is a .odc OLE DB connection to a ...
User1974's user avatar
  • 1,246
5 votes
2 answers
3k views

I have a field in a table that is a double data type, but the values are actually integers. The table is from third-party software, so I don't have control of the field data types. I'm attempting to ...
User1974's user avatar
  • 1,246
0 votes
1 answer
4k views

I'm trying to group layers in the table of content so that I can expand or collapse them as needed. Not sure how. I'm using ArcGIS 10.3 for Desktop.
user70650's user avatar
  • 139
1 vote
1 answer
474 views

I am trying to create a python script to copy data from a MSSQL view (includes a geometry field) into a feature class. They are both held within the same database. I have tried arcpy....
N. Begg's user avatar
  • 313
3 votes
0 answers
571 views

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 ...
Aenne Ramm's user avatar
  • 71
2 votes
1 answer
477 views

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 ...
Dan Narsavage's user avatar
  • 478

1
2 3