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
26 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 ...
user avatar
  • 1
0 votes
1 answer
12 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 ...
user avatar
  • 756
0 votes
1 answer
14 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 ...
user avatar
  • 756
0 votes
0 answers
10 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 ...
user avatar
  • 19
1 vote
1 answer
41 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 ...
user avatar
  • 13
3 votes
2 answers
90 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 ...
user avatar
  • 161
2 votes
1 answer
45 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 ...
user avatar
0 votes
1 answer
35 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 ...
user avatar
  • 756
0 votes
0 answers
27 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 ...
user avatar
2 votes
1 answer
132 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 ...
user avatar
  • 756
1 vote
1 answer
103 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....
user avatar
  • 133
1 vote
1 answer
421 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 ...
user avatar
  • 2,084
2 votes
2 answers
446 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 ...
user avatar
  • 386
1 vote
0 answers
44 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 ...
user avatar
  • 756
3 votes
0 answers
259 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 ...
user avatar
2 votes
0 answers
333 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 ...
user avatar
  • 51
1 vote
1 answer
102 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'...
user avatar
  • 27.5k
0 votes
1 answer
495 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 ...
user avatar
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....
user avatar
  • 27.5k
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 ...
user avatar
  • 177
0 votes
1 answer
287 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 ...
user avatar
  • 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 ...
user avatar
  • 131
3 votes
1 answer
187 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 ...
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 ...
user avatar
  • 9,567
2 votes
1 answer
109 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 ...
user avatar
1 vote
0 answers
410 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....
user avatar
7 votes
2 answers
949 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 ...
user avatar
  • 710
2 votes
1 answer
600 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 ...
user avatar
  • 139
2 votes
1 answer
111 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 ...
user avatar
2 votes
1 answer
369 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 ...
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 ...
user avatar
  • 47
1 vote
0 answers
108 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 ...
user avatar
2 votes
1 answer
107 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.. ...
user avatar
  • 339
2 votes
1 answer
843 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 ...
user avatar
  • 901
0 votes
2 answers
916 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 ...
user avatar
  • 756
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 ...
user avatar
  • 756
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.
user avatar
1 vote
1 answer
378 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....
user avatar
  • 313
3 votes
0 answers
497 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 ...
user avatar
2 votes
1 answer
359 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 ...
user avatar
1 vote
3 answers
397 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:
user avatar
1 vote
1 answer
509 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 ...
user avatar
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.%...
user avatar
  • 1,060
4 votes
2 answers
378 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 ...
user avatar
  • 2,487
7 votes
1 answer
571 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 ...
user avatar
4 votes
2 answers
662 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 ...
user avatar
  • 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 ...
user avatar
  • 43
1 vote
0 answers
129 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') = ...
user avatar
1 vote
2 answers
488 views

ArcGIS 10.2 Query layer ID field using double / floating field?

I am using ArcGIS for Desktop 10.2. Am I correct in understanding that ArcGIS will only let you select an integer or text fields as the "key" ID when adding a query layer? Our Oracle enterprise ...
user avatar
2 votes
2 answers
322 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 ...
user avatar
  • 21