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.
108
questions
3
votes
0
answers
37
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 ...
- 31
0
votes
0
answers
33
views
Issue with Query Layer and view ArcGIS 10.7
I've encountered an issue regarding working with views in SQL Server Enterprise. There is a Left Outer Joind view created by joining two tables (Spatial) and using fields from only the Left side with ...
- 1
0
votes
0
answers
349
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 (...
- 1
2
votes
1
answer
433
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 ...
- 21
1
vote
1
answer
217
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 ...
- 307
0
votes
0
answers
106
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, ...
1
vote
1
answer
443
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 ...
- 43
0
votes
0
answers
285
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 ...
- 5
1
vote
1
answer
409
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 ...
- 41
0
votes
1
answer
67
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 ...
- 1,114
0
votes
1
answer
93
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 ...
- 1,114
1
vote
1
answer
531
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 ...
- 13
3
votes
2
answers
667
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 ...
- 161
2
votes
1
answer
109
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 ...
0
votes
1
answer
80
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 ...
- 1,114
0
votes
0
answers
47
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 ...
- 65
2
votes
1
answer
358
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
...
- 1,114
1
vote
1
answer
185
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....
- 143
1
vote
1
answer
704
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 ...
- 2,362
2
votes
2
answers
902
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 ...
- 385
1
vote
0
answers
69
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 ...
- 1,114
3
votes
0
answers
425
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 ...
- 41
2
votes
0
answers
443
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 ...
- 51
1
vote
1
answer
115
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'...
- 28.1k
0
votes
0
answers
773
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 ...
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....
- 28.1k
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 ...
- 177
0
votes
1
answer
405
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 ...
- 131
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 ...
- 131
3
votes
1
answer
248
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 ...
- 41
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 ...
- 9,674
2
votes
1
answer
154
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 ...
- 21
2
votes
0
answers
489
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....
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 ...
- 720
2
votes
1
answer
731
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 ...
- 139
2
votes
1
answer
118
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 ...
2
votes
1
answer
421
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 ...
- 21
-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 ...
- 47
1
vote
0
answers
115
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 ...
- 11
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.. ...
- 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 ...
- 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 ...
- 1,114
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 ...
- 1,114
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.
- 139
1
vote
1
answer
440
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....
- 313
3
votes
0
answers
531
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 ...
- 71
2
votes
1
answer
413
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 ...
- 468
1
vote
3
answers
408
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:
- 33
1
vote
1
answer
581
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 ...
- 10.2k
0
votes
0
answers
88
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 Connections\\ConnectionFile.sde\\sde.SDE.%...
- 1,080