Questions tagged [attribute-joins]
The process of connecting two or more datasets based on common attribute values. For spatial joins there is a separate tag.
927
questions
0
votes
0
answers
16
views
join shapefile to a raster created by interpolation (IDW)
I want to join this raster to a shape file; I created this raster by IDW, it is rainfall information for my country and the shapefile it is for all the townships, I wanna know the exactly rainfall ...
- 1
4
votes
1
answer
51
views
Extending "Join attributes by nearest" with WHERE clause in QGIS
I am using QGIS v3.24.1-Tisler and the "Join attributes by nearest" tool in Processing Toolbox, which does 90% of what I need. However I would like to be able to add a WHERE clause, so join ...
- 41
0
votes
0
answers
11
views
Cross Join in ArcGIS Pro/ Joining one value to many without join field
I have an attribute table with one single value and an attribute table with different rows. I want to join the single entry to all rows from the other table, without using a certain join field on ...
- 1
2
votes
0
answers
38
views
How to join a column from a line data layer attribute table and join it to a shapefile attribute table in QGIS?
Issue:
I have calculated the distance from shore from point data showing dolphin IDs to the coastline by using these commands:
Step 1: Digitise the country lines for administration country shapefiles ...
- 275
0
votes
0
answers
24
views
JoinField doesn't concatenate date type fields from database view
I'm using this code to make a join to a SQL Server database view.
arcpy.management.MakeQueryTable(CEView, "CE", "USE_KEY_FIELDS", "SID")
arcpy.management.JoinField(...
- 11
1
vote
1
answer
46
views
Calculating distance from point to line, depending on unique ID using QGIS
I have four points of interest for each plot, a line representing the segment that faces the road and the plots themselves for representation purposes (all of them share in common an unique "id&...
- 71
2
votes
2
answers
64
views
Joining two polygons where they overlap the most in QGIS
I have two layers: district (with lots of districts) and an object layer.
I want to add the information where the object lies in the most to the object.
For example: this object lies the most in ...
- 23
0
votes
0
answers
16
views
Expression field returns an error while labeling an annotation
I work in ArcGIS Pro 2.9.2.
My dataset consists of multiple polygon feature classes. I labeled them combining two attribute fields through VB expression. Then I created linked Annotation feature ...
- 173
0
votes
0
answers
7
views
Graduated Color Ramp by Rate per Zip Code?
I am very new to qgis (I started teaching myself about a week ago) so I will try and be as concise as possible. I am using version 3.22 and I am mapping violation of probation rates (vop rates). I ...
- 1
2
votes
0
answers
38
views
How to join attributes by field value on-the-fly?
I have two spatial (polygon) layers (table 1 and 2), and another non spatial table (table 3).
Table 1 & Table 2 have identical columns but different fields.
Table 1 is edited by user 1 only
Table ...
- 49
1
vote
1
answer
36
views
Problem using aggregate function to do a 1:m join
I am using QGIS, version 3.24.0. I have a shapefile called "Map_CorrectionDEF", uniquely identify by fields "GID" and "unitcode". It is a grid cell, in which the field &...
- 445
1
vote
2
answers
45
views
Qgis- Merging datasets of similar data without losing attributes
I'm looking for advice on how to compile some datasets that each have a different set of attributes.
Each dataset is point data, recorded in one of the two coordinate systems that have been used ...
- 19
2
votes
1
answer
122
views
Problem joining multiple matching rows from non-geometry CSV file
I am using QGIS 3.24.0. I have a shapefile, called "Map_CorrectionDEF, in which one of the fields is "unitcode". On the other hand, I have a CSV file, called crop_main (no geometry), in ...
- 445
0
votes
0
answers
30
views
Joining Tables in ArcGIS Pro results in majority <null> values
The goal is to try to join a table with calculated fields (produced in ArcGIS Pro) with the attribute table of a shapefile. Trying to join them with the common "APN_8" Field, both text, 8 ...
- 19
5
votes
2
answers
396
views
Joining two Pandas DataFrames based on lat, long as fields
I have two Pandas DataFrames containing "lat" and "long" coordinates. I'd like to do a spatial join and merge columns from one DataFrame into another.
import pandas as pd
df1 = pd....
- 323
1
vote
0
answers
24
views
Merge Duplicate Rows with different Values in one Row using ArcGIS Pro
I joined a table with the area of a value to a shapefile with building footprints. Now I have up to 3 rows with the same ObjectId/Single Building Footprint (from the Join) but each of the 3 rows has ...
- 11
1
vote
1
answer
39
views
Spatial Joins - Intersect then non-joined Nearest
Is there a tool to join by interest and then for those that are not joined, join by nearest - all in one calculation? If not, maybe this is a valid feature request, to combine these two tools together ...
0
votes
1
answer
92
views
Join Field based on multiple fields using ArcGIS Pro
I am giving a simplified example, but the principle is the same for my problem. In the end I show you my actual case with a screenshot.
There are 100 municipalities. Their borders divide land data. ...
- 57
4
votes
2
answers
203
views
Uppercasing all strings of certain column using QGIS
I am using QGIS.
I have two shapefiles which I want to join based on address columns. SO far I have not been able to join them. I think the reason might be that one column is capitalized while the ...
- 347
1
vote
1
answer
48
views
Join Field not joining all tables using ModelBuilder of ArcGIS Pro
I have a File Geodatabase in which there are 3 stand-alone tables and I have a shapefile to which I want to join fields of the standalone tables. I am using the Iterate Table tool of the ModelBuilder ...
2
votes
3
answers
81
views
Troubles on joining data and identifying specific fields via "joined fields" in QGIS
I do have frequent crashes as soon as I try to select a subset of fields to be joined via layer properties / joins / joined fields checkboxes. joins of the same pair of tables without limiting fields ...
- 820
1
vote
1
answer
52
views
Joining two layers based on two fields with very similar values
I have two shapefiles ("tax_parcels" and "buffalo") that I would like to join based on the address fields ('PropAddres' and 'physical_a') of their attribute tables. The problem is ...
- 347
0
votes
0
answers
33
views
Raster field after Join is just black
I have a polygon Feature Class and a Table with a raster field. They have a N : 1 relation.
I have joined the Table to the Feature Class. After this, if I open a Pop Up of a Feature inside my Feature ...
- 161
0
votes
0
answers
36
views
Editing attribute table, when it's not allowing to edit the output field length
I joined two attributes making a field called "fid" to appear. Since then when I try to edit or add a field I am unable to change the output field length or the precision. I have tried ...
0
votes
1
answer
71
views
Query SQL x Virtual Layer x Joined Fields
I am facing the following situation.
I have a spatial layer which I did a JOIN tool with a data table. Now in my attributes window I see all the fields: the original ones and the ones from the joined ...
0
votes
1
answer
53
views
Performing near point-to-point merge with ArcPy?
I have a series of .csv datasets with points in Lat/Long mapped to Town Names:
In addition, I have a shapefile containing similar data (town names with their corresponding x/y):
I also have ...
- 13
5
votes
2
answers
408
views
Splitting query into different views or tables using PostgreSQL/PostGIS
I'm working with PostgreSQL 14.1 with PostGIS 3.1. I've got two tables:
grid that holds a 10x10 km UTM grid, using field utm as PK.
species that holds fields name (for the species name), utm as a FK, ...
- 2,273
2
votes
1
answer
48
views
Rendering NULL values with joined CSV file in QGIS
I have a set of polygons in a single shapefile layer. I have added a data table as a new layer and joined the two layers. Some of my polygons do not have entries in the data layer and consequently, ...
- 133
1
vote
0
answers
38
views
Relate two tables with different number of entities
I want to join two layers: One which has information about the height and width of the wind turbines (fields to join) with only 4 or 5 entities or sometimes less, and the other is a layer with lots of ...
- 41
2
votes
1
answer
114
views
Column fields that are part of a join convert to null or 0 when exported
I've seen similar questions on here, but none seem to resolve my specific problem. I am very new to ArcGIS Pro.
I have a shapefile of parcels that I want to join two tables to.
I use columns with ...
- 21
0
votes
0
answers
10
views
Joining two .sqlitedb maps into one using MOBAC or other software
I have two .sqlitedb maps converted from same source - for example Google Sattelite (one part complementing another).
How can I join them into one .sqlitedb map using MOBAC or other software?
5
votes
2
answers
222
views
Joining multiple layers in QGIS
I have about 25 GeoPackage files, each containing a table with an "ID" field and another with density information about that area. I want to join all those density information into one layer,...
- 53
4
votes
2
answers
79
views
Join tables with different amount of rows using SQL in QGIS3
I want to join two tables. The second table has only one row. I want to append this row to every row of table 1. How can I achieve that with SQL in QGIS3?
- 103
1
vote
1
answer
21
views
Show selection of point in relation of a vector field?
I have two files,
vector "streets"
a series of point "civic numers" or "address"
I want to select a random street and have the field selection of the relative civic ...
0
votes
1
answer
39
views
Adding name of FeatureClasses to names of joined fields using ArcPy
Using ArcPy, how do I add the name of FeatureClasses to the names of the joined fields?
This is my code which I think helps explain what I am looking for.
----------------------------------------------...
2
votes
1
answer
37
views
Migrate attributes from old line feature to a new one where differences in geometry and common attribute exist between the two
I recently received an older Centerline modified by an external consulting firm my management team hired (which they contracted out GIS work for without consulting their own GIS staff, go figure.)
As ...
- 199
2
votes
1
answer
145
views
Grouping features by attribute with sum function in QGIS
I want to consolidate my attribute table by grouping it based on several similar features. I cannot share the data due to confidentiality but it goes like this:
1000 data, grouped with same score, ...
- 33
3
votes
1
answer
48
views
Removing table join using PyQGIS
I joined a table to a layer in QGIS using code from this thread: Joining layers with PyQGIS 3.
Now I would like to remove the join. How can I do it?
- 188
0
votes
0
answers
47
views
Attribute data from two points to one line
I have exported GPS points into QGIS and I created individual lines between the points based on date. In each points attribute table I can find the speed. Now I want to join the attribute data from 2 ...
- 29
0
votes
1
answer
32
views
Merge data in QGIS
So I have one table with attributes and adresses and one .shp file with coordinates and adresses can I merge these data in QGIS somehow?
- 23
0
votes
0
answers
59
views
Joining Layers with PyQGIS [duplicate]
I need to make a LEFT JOIN (using a Python QGIS script) between two layers:
a shape (point): s_node
a csv (table): t_infos
Can you show me how to do that?
The result (the joined layers) has to be in ...
- 1
0
votes
0
answers
44
views
Exporting joined attribute table features gives wrong number of records using ArcMap
I work in ArcMap 10.8.1.
I have a feature class of ~40k records of road segments. I dissolved the segments using a field containing numbername of the roads. This created a feature class of ~10k ...
- 173
1
vote
1
answer
48
views
Joining CSV tables by multiple attributes
I am using QGIS 3.16
I have a shapefile with an attribute table containing regions, district-numbers and building-numbers and I have an additional table (CSV) that (besides other relevant information) ...
- 83
0
votes
0
answers
51
views
Joining Table attribute to Map attributes without matching properties
I have a Dataset (10Gb) that I imported to QGIS 3.22.
It contains multiple tables and maps.
The first map categorizes land usage (HWRM_HWRK_LN) and I was able to attribute a color gradient.
The four ...
- 1
0
votes
1
answer
26
views
Joining field of multiple tables into one shapefile using ArcMap
I have one shapefile containing several zones (polygons), which are several agricultural parcels. Each parcel has its own FID. I also have five tables containing the crop type of each parcel for five ...
- 103
2
votes
1
answer
66
views
'Join Attribute by Location (Summary)' slows down with time
I'm attempting to perform a 'Join Attribute by Location (Summary)' between two polygon layers where I calculate the sum of a given field in the join layer using the 'Intersect' predicate. The process ...
- 573
0
votes
0
answers
46
views
Table join working weirdly in QGIS
I am trying to join a .shp (polygon) with a .csv table containing numerical values. My key is "Agenzia" which is in both cases a string field. The join works except for the two values shown ...
- 29
0
votes
0
answers
41
views
Joined field makes features disappear with graduated symbology using ArcGIS Pro
I have a CSV file joined to my shapefile and I can choose the joined fields in the dropdown for graduated symbology but the geometries are not visible on the map when I select field from the CSV. The ...
- 103
0
votes
0
answers
28
views
Join two Tables based on two common columns
Let's say I have two time series shapefiles and I want to join them based on the common values in ID (not ArcGIS created ID) and Date column. Currently I am using join via table attributes, but the ...
- 614
2
votes
0
answers
70
views
Adding data from CSV file to vector layer in QGIS
I am trying to add data from a CSV file to a Vector layer (shapefile). I already created a column with same numbers to have a reference column, so I could join my CSV data to that reference column.
I ...
- 233