Skip to main content

Questions tagged [query-layer]

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
20 views

GeoServer Querylayer plugin exception max number of collected

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
29 views

Can Extract Multi Values to Points be used with a query layer as input?

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,417
3 votes
0 answers
60 views

Updating Virtual Layer by PyQGIS

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
0 votes
0 answers
509 views

Problem to see data in ArcGIS Enterprise from a Query Layer

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
2 votes
1 answer
650 views

ArcGIS Pro unable to add SQL database object when new fields had been added

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
273 views

Filter Query Layer with Field from a Table in a Geodatabase

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
  • 319
0 votes
0 answers
123 views

Add Query Feature Class to ArcMap using ArcPy

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
2 votes
1 answer
667 views

Sample Multiple Points from Raster Layer Python QGIS 3.26.1

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
414 views

Publish a query layer from ArcGIS Pro to your GIS Server to maintain connection

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
504 views

Publish a Query Feature Class from ArcGIS Pro to ArcGIS Online

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
  • 41
0 votes
1 answer
83 views

Polyline endpoint query layer in ArcGIS Pro

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,172
0 votes
1 answer
112 views

Integer representation of textual value (as unique ID for query layer)

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,172
1 vote
1 answer
763 views

Running a query in overpass-turbo

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
944 views

Comparing two different layers with duplicates in QGIS

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
130 views

GeoServer 2.20.1 doesn't respect multiple styles with query layers

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
0 votes
1 answer
84 views

Translate data right in ArcGIS Online?

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,172
0 votes
0 answers
53 views

Performance problem with labels on query layer in ArcMap 10.7

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
2 votes
1 answer
401 views

Convert ST_POINT subtype to ST_GEOMETRY supertype?

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,172
1 vote
1 answer
194 views

Enabling toggle editing when loading layers form postgis in QGIS

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
766 views

Adding query layer to MapView in Jupyter Notebook returns "RuntimeError: Cannot infer layer: will not be added to map"

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,417
2 votes
2 answers
1k views

QGIS - look up Table to feature Layer where Table answers questions to Multiple Columns in Feature Layer

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
70 views

Unexpected query layer results: Why does unioning with DUAL fix it?

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,172
3 votes
0 answers
481 views

Using spatial filters in cross-layer filtering by GeoServer?

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
2 votes
0 answers
461 views

Enabling editing for QGIS query layer?

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
121 views

Arcpy CopyRows writes only a fraction of MakeQueryLayer results

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.2k
0 votes
0 answers
834 views

Adding ArcGIS Pro Query Layer?

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
3 votes
2 answers
2k views

Where are results of Make Query Layer?

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.2k
3 votes
1 answer
1k views

Updating ArcGIS Online data from SQL Table

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
421 views

Fetching query from query layer using ArcObjects and C#?

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
79 views

Setting ID in query as IQueryDescriptions OIDFields throwing error?

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
279 views

Why is query layer rounding down coordinates to 6 digits?

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
1 vote
0 answers
138 views

Make Query Layer - field not available as unique identifier when using NVL [duplicate]

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
182 views

Selecting features from an expression

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
2 votes
0 answers
510 views

Connecting ArcMap to Oracle DB

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
7 votes
2 answers
1k views

Edit a Query Layer with Arcpy

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
766 views

Make Feature Layer from Query Layer yields an ArcPy error?

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
120 views

Using ESRI Query Layer to query OSM data in PostGIS database connection?

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
2 votes
1 answer
433 views

Creating symbols with multiple colors each from attributes

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
-1 votes
1 answer
1k views

Export Query Layer to shapefile using arcpy [closed]

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
117 views

ArcGIS WFS Errors - Multiple Feature Class References

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
2 votes
1 answer
112 views

ESRI JAVASCRIPT API - Can you return a list of fields from a published Querylayer

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

Publish a Query Layer as a Feature Access Service - ArcGIS Server

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
  • 901
0 votes
2 answers
1k views

Use multiple connections/databases in a query layer?

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,172
5 votes
2 answers
3k views

Converting double field to integer in database view so ArcMap query layer can use field as unique identifier

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,172
0 votes
1 answer
4k views

Grouping layers in Table of Contents in ArcGIS for Desktop?

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
453 views

Copy query feature layer into a feature class - error 000732

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
546 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 ...
Aenne Ramm's user avatar
2 votes
1 answer
424 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 ...
Dan Narsavage's user avatar
1 vote
3 answers
415 views

CMV Search widget url query string

I am migrating my Flex eSearch widget to the CMV Search widget. I need to be able to pass a query through an url within the widget. Currently my widget has 8 URLs that are in the widget. Flex Code:
cmccullough's user avatar
1 vote
1 answer
597 views

ArcGIS query layer shape=long integer and not geometry

I want to add a Query Layer in ArcMap to eventually publish WMS services. WMS services cannot be created with a selection layer so I though I would try the Query Layer variation. My problem is that I ...
Robert Buckley's user avatar