Questions tagged [query-table]

Tool from the ArcGIS toolbox that applies an SQL query to a database represents the results in a layer or table.

Filter by
Sorted by
Tagged with
1 vote
0 answers
90 views

Create dynamic layer based on a query in ArcGIS Pro: "ERROR 000055: Cannot create a Query Table for this workspace" when using "Make Query Table"

I have connected the SQL database server myserver in ArcGIS Pro. It then appears as myserver.sde under Databases in the Catalog window. Points can be visualized in a map with the fields X and Y (EPSG:...
stonebe's user avatar
  • 445
2 votes
1 answer
151 views

ArcGIS Desktop Script Tool fails when I run MakeQueryTable_management. How to read intermediate outputs?

I am seeking some help with fixing my Python script to allow it to run as an ArcGIS Script Tool. Let me first say that the script runs without issue outside of ArcGIS. The section giving me grief ...
RockyFlintstone's user avatar
0 votes
1 answer
595 views

Using "Make Query Table" in ArcPy

I'm trying to join over a hundred tables (arranged in columns) in ArcGIS using Python (ArcPy). They all have the same number of rows and columns (same data, but different values). I had them as dBase ...
Cheee's user avatar
  • 9
0 votes
0 answers
801 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
0 votes
1 answer
388 views

Using arcpy.makequerytable_management with where clause?

I have a script that works great with selecting dates greater than "my From date" but I can't get the code to work when I want to add a less than to the sql where clause (a to date). I had add the {0}...
Mary Andrews's user avatar
1 vote
0 answers
492 views

Make Query Table error: "The value is not a Raster Layer"?

I'm pretty new in coding and I'm struggling with my MakeQueryTable_managment tool using arcpy. I'm trying to do a query Layer based on a Layer and a table I have both in my gdb. I keep getting this ...
Maja's user avatar
  • 33
0 votes
1 answer
49 views

Error when using variable in SQL clause with arcpy.MakeQueryTable_management

When I hard code a date my SQL query works fine where_week = "dtrepor > ‘2017-04-21 07:00:00’" but when I try to use a variable it booms out. This variable prints to the exact same date and time ...
Mary Andrews's user avatar
1 vote
1 answer
478 views

One to many join with Make Query Table

I have a feature class and table. The table contains about 18000 data. the polygon feature class contain 269 data. Both common column are [MAHALLE_AD] and [Mahalle]. Also Both are same personal ...
madereli's user avatar
-1 votes
1 answer
90 views

Writing table view to disk using ArcGIS Desktop? [closed]

I am attempting to collapse three separate (non-spatial) tables with related records into one. I have used the Make Query Table tool to do this (I think) by joining them based on a shared field, ...
RobinHorner's user avatar
1 vote
0 answers
203 views

Using Make Query Table to join featureclass with table using 2 fields

I would like to join a forest density table to a forest ownership featureclass in a geodatabase based on two columns in each (TPO_Owner and County_Nm) so I can populate the Density column in the ...
NatalieM's user avatar
  • 109
1 vote
1 answer
360 views

Making table from MySQL query with ArcPy?

I am trying to interact directly with data from a MySQL database in ArcMap using Python. So far, I have successfully connected the database using the MySQLdb.connect() function and have successfully ...
Rae's user avatar
  • 31
1 vote
0 answers
64 views

One-to-many feature class to table in ArcGIS MakeQueryTable [closed]

I try to put up a one-to-many relationship between a feature class (one) and a table (many) using MakeQueryTable tool. One entry in the feature class needs to be linked to many entries in the table ...
nilsnolde's user avatar
  • 487
1 vote
1 answer
102 views

Updating numerical column with autonumbers in sorted query table in ArcGIS for Desktop?

I am trying to find a suitable code that lets me to update a numerical column (namely, "RevOdrNo") of a sorted query table (not a separate table) with autonumbers (e.g. 1,2,3,4,5,6) in ArcGIS 10.3's ...
Chris's user avatar
  • 11
0 votes
1 answer
141 views

Using function in SQL query with ArcPy?

I am trying to join points to polygons based on whether their addresses match as well as if the distance between them is less than 2500 feet. I defined a haversine function that computes the distance ...
ketar's user avatar
  • 466