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.

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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(...
user avatar
  • 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&...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 &...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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....
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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. ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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, ...
user avatar
  • 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, ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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?
user avatar
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,...
user avatar
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?
user avatar
  • 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 ...
user avatar
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. ----------------------------------------------...
user avatar
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 ...
user avatar
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, ...
user avatar
  • 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?
user avatar
  • 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 ...
user avatar
  • 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?
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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) ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 233

1
2 3 4 5
19