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
0
votes
0answers
103 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 ...
0
votes
1answer
60 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}...
1
vote
0answers
201 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 ...
0
votes
1answer
25 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 ...
1
vote
1answer
202 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 ...
-1
votes
1answer
64 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, ...
1
vote
0answers
167 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 ...
1
vote
1answer
271 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 ...
1
vote
0answers
58 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 ...
1
vote
1answer
86 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 ...
0
votes
1answer
134 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 ...