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
1 vote
1 answer
48 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 ...
  • 33
0 votes
0 answers
27 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
0 votes
1 answer
109 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 ...
  • 31
0 votes
1 answer
26 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 ...
  • 918
0 votes
1 answer
21 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 ...
  • 918
0 votes
0 answers
17 views

ArcMap query layer versus geodatabase relationship discrepency

I have a geodatabase with relationships between tables. objet_poly <-> objet_recense <-> detail_objet <-> mention Now I need to filter out objects from one table based on the values ...
  • 19
1 vote
1 answer
100 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
163 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
52 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
42 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 ...
  • 918
0 votes
0 answers
30 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 ...
2 votes
1 answer
182 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 ...
  • 918
1 vote
1 answer
123 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....
  • 133
1 vote
1 answer
491 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,109
2 votes
2 answers
551 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 ...
  • 386
1 vote
0 answers
52 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 ...
  • 918
3 votes
0 answers
310 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 ...
2 votes
0 answers
366 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
106 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'...
  • 27.7k
0 votes
1 answer
571 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
1k 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....
  • 27.7k
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
332 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
77 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
197 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 ...
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,577
2 votes
1 answer
122 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 ...
2 votes
0 answers
425 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
979 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 ...
  • 710
2 votes
1 answer
642 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
113 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
378 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 ...
-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
110 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 ...
2 votes
1 answer
108 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
897 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
939 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 ...
  • 918
4 votes
3 answers
2k 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 ...
  • 918
0 votes
1 answer
3k 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.
1 vote
1 answer
402 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
500 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 ...
2 votes
1 answer
374 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
3 answers
398 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:
1 vote
1 answer
518 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 ...
0 votes
0 answers
82 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,060
4 votes
2 answers
381 views

How to detect Query Layer for toolvalidation using arcpy?

For an arcpy toolvalidation script, I have been trying to figure out a good way to detect ArcGIS layer files (*.lyr) based on "Query Layers", and to distinguish them from "normal" feature layers ...
  • 2,522
7 votes
1 answer
583 views

Query Feature Class Service - Portal display

I am new to arcgis and i have tried to use the right terminology. I have a Query Feature Class consisting of Polygons and points referrencing a non-geodatabase that I have published as a service via ...
4 votes
2 answers
679 views

In terms of SQL, what exactly is Query Layer's "Unique Identifier" doing?

When you make a link with a database using Query Layer in ArcMap, you must select a Unique Identifier, which ensures that the resulting Layer only has unique records in the Attribute table. In some ...
  • 87
4 votes
1 answer
1k views

Mapping SQL tables in ArcGIS Desktop

I have several tables in SQL server. I am trying to visualize my data in ArcGIS. However, I have not been able to do so. I started off my making a database connection in Arc Catalog to my SQL. I did ...
  • 43
1 vote
0 answers
138 views

Need Help Creating Query Layer From Oracle For Past 365 Days [closed]

I have several Query layers that work fine for generic, long term date ranges such as: This shows all entries that have the previous YEAR in the date field. AND To_char(ds.calendar_date, 'YYYY') = ...