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.
848
questions
1
vote
1answer
21 views
Dissolving point files by shapefile boundaries
I have a point-data file representing polling booth locations which each contain information pertaining to the vote for a political party that was recorded at each poll.
Underlying this file is a ...
1
vote
0answers
34 views
Loop through folder and join pairs of files with the same prefix
I have two sets of shapefiles that I would like to join based on a similar field. They are all stored in a path folder which is stored as the variable "steps".
One group of shapefiles are ...
4
votes
1answer
69 views
Making a join permanent using QGIS 3.16 with a shapefile and Excel spreadsheet
I have a point layer representing sites where data was collected. The data was edited and stored in an Excel spreadsheet (CSV). I needed the data to be joined to the sample sites. I followed the steps ...
0
votes
1answer
35 views
ArcMap attribute joins generating incorrect values
Background:
At 10.8.1, ArcMap attribute joins run without complaint, yet generate incorrect results.
As shown in the screenshot below, the tables component (parent) and chorizon (child) are joined 1:1,...
0
votes
0answers
14 views
Joining Excel with hyperlinks from Excel to ArcGIS Pro or ArcMap
I was trying join a Excel spreadsheet with hyperlinks to the ArcMap and ArcGIS Pro based on the same field. The hyperlink text went through the join, however, the actual hyperlink did not go through.
0
votes
0answers
20 views
Join (map-matching) observations to roads
I know that the subject is wide, but I could not find answers to my problem. I have to shapefiles: Roads(c.a. 580 rows and divided into three categories of roads) and observations (detected speed ...
2
votes
1answer
53 views
Adding new field values to layer from another layer
I have two layers that share a Unique "ID" field. Can I easily update the field values in one layer with the field values in the other layer using the Unique "ID" as the link field?...
0
votes
0answers
18 views
Appending two Joined layers
I have two polyline shapefiles, Green and Gold which are supposed to match but don't. Gold is larger than green, and slightly offset. Some line IDs are a match, but other IDs have been changed.
I am ...
1
vote
1answer
20 views
QGIS: Join attributes by location calculates values wrong
It seems like I got the same problem which is discussed in this thread. But since it's 2 years old already, there's an easy solution to this by now?
I'm joining a vector layer which contains seperat ...
2
votes
1answer
19 views
QGIS: No values in field after creating spatial index
I want to join a vectorlayer with a grid using the algorithm "join attributes by location (summary)". It took hours to execute, but it worked. Then I found This thread which told me I have ...
0
votes
0answers
19 views
Unable to join data by field value
i have a dataset which contain object_id, poi_x and poi_y and another data set with same object_ids but different poi_x and poi_y. i want to join poi_x and poi_y from second dataset to first dataset. ...
1
vote
1answer
49 views
Joining attributes from both sides of a line
I have a layer with street segments that I would like to join with a building + population layer. Desired result: The segment contains population data. Nearest neighbor (NNjoin) finds the closest ...
1
vote
1answer
22 views
Join County Data by state and county name without FIPS - join by two attributes?
I have data by county that I want to join with census data but when I do the join by county name it messes up because some states have the same county names and I don't know how to get around this ...
0
votes
0answers
12 views
Attribute table multiple selections from external data file
I have a county parcels attribute file in which I can select a row entry and have it highlighted on the shapefile (standard behavior). I also have a separate file (excel or dBase) with entries for ...
3
votes
2answers
49 views
QGIS Join issue on tables with generated unique value index field
I'm trying to make a simple join in QGIS 3.10 between a table with a generated ID (using "Add unique value index field") named POINTID and a table created by the Distance Matrix algorithm ...
1
vote
1answer
28 views
Create geometries from data-only tables using virtual layers
In QGIS 3.18, I have two data-only layers (csv) - the table coordinates containing lat/lon values, the table data containing attribute data. Both tables have a common unique id: 1 (data) : n (...
1
vote
0answers
37 views
Joining or relating multiple data in one single data using QGIS
I do not know how to solve this problem using QGIS. I have tried several ways but it did not work out.
I have a lot of data, I have one coordinate system for each location, for example
Alor setar ...
2
votes
2answers
105 views
Calculate field in a joined table in ArcPy
EDIT: I was able to solve the problem with the dictionary approach suggested by @BERA. However, I still don't get why it does not work with the CalculateField method.
I'm trying to calculate a field ...
1
vote
0answers
23 views
Spatial join (Points to Polygons) joining points that do not fall inside polygons to attribute table
I am using ArcMap 10.6.1 and am having trouble with a spatial join. I have created 250km buffer polygons around some of my sampled data points and I am now trying to join some modelled data to those ...
0
votes
1answer
46 views
How to write merged geodataframe to shapefile
Tried the following code. I am able to see the merged data in the console but I don't get any output file. Running my code does not raise any errors either.
import geopandas
import pathlib
import ...
2
votes
2answers
44 views
Joining multiple tables to multiple feature classes using ModelBuilder / arcpy
I have a list of tables (1,2,3) and would like to join the tables, tables by table, to a list of feature classes (1X,2X,3X). So that table 1 combines with feature class 1X, table 2 with feature class ...
2
votes
0answers
28 views
QGIS Hidden attributes not hidden in Relations
I have a PostGIS view, which a referencing layer for another layer for many to one relation in QGIS. I have hidden the following fields id, table_name, oid of the postgis view so that the user would ...
0
votes
0answers
28 views
How to use Field Calculator on 1 to Many Join and keep most recent
I have a Hydrant layer and a hydrant inspection table. So when I join them, it is a one to many join since there are multiple inspections for one hydrant.
I need to populate a field in the hydrant ...
0
votes
1answer
20 views
JoinFeature attribute_relationship syntax (arcpy)
I am building a Python Toolbox for ArcGIS using Python 3 with ArcPy. I have two tables that I need to relate based upon an attribute. The information on the documentation for the JoinFeatures() ...
4
votes
3answers
146 views
Joining/merging rows by attribute
I have a beautiful grid/polygon, each square having its own "ID", and several observations for each square. But, I have three categories of observation, each with its own row, matching the ...
3
votes
1answer
41 views
How to do a “many-to-one” join
I have used the distance matrix tool for a large point set (100 000+ points) to find three closest POI's from another layer and their distances. The distance matrix outputs a table much like this:
...
1
vote
1answer
55 views
QGIS - Join polygon layer attributes to line segments
I've got a hexagon layer with data that I want to have joined to the available road network for the area so that the road segments have the attributes from the hexagon layer.
Each segment of the road ...
2
votes
1answer
32 views
Trying to perform table joins iteratively using Python in QGIS3
Back again with a similar issue, but this time with commented code! I'm trying to perform table joins iteratively for each field in each CSV I'm using for each of vector layers in the project. The ...
0
votes
0answers
25 views
Attribute join on the fly for visualization with ArcGIS JS API
Lets say I have 2 layers - one that contains shape information about a given group of entities, say countries, and one that contains some data attributes about the same group of entities. Both layers ...
3
votes
1answer
35 views
Saving Starting / Ending points of connecting line in attribute table
I have 3 layers ( 1 line and 2 points) as shown in image. The layer id,s are mixture of integers and text such as cable4389175, node1 , service_point5316. I connect the two point layers (node and ...
1
vote
0answers
45 views
Create non trivial join/view via PyQGIS in a QgsProcessingAlgorithm
In the context of QgsProcessingAlgorithm, what is the best way to take information from several layers and output based upon that combination of layers? or: What is wrong with my layer creation?
The ...
0
votes
1answer
36 views
Why does making a join layer editable cause so many issues?
I'm using QGIS. When I do a join it creates new column values with a long title because of the prefix it adds from the join. I need to shorten the column names in order to create new shapefiles from ...
1
vote
0answers
80 views
Join attributes by location in QGIS 3
I wonder if there is a better way to join attributes based on location.
I have a vector layer with polygons representing lines.
Layer A is the layer where I want to take the correct attributes and ...
2
votes
1answer
39 views
QGIS: String formatting when creating a virtual field
I would like to join US census population estimates with county boundaries.
The population estimates layer (co-est2019-alldata) contains STATE and COUNTY fields with state and county FIPS codes, like ...
3
votes
1answer
64 views
QGIS access Oracle non-spatial database tables
I stumbled accross this when I tried to connect to a "normal" Oracle 11g instance (no Oracle Spatial) in order to join Oracle tables to spatial data in other formats. Note that this is not ...
1
vote
0answers
41 views
Joining table to feature class AND matching fields using ArcMap
I am digitizing points from pdfs and aerial imagery. Just points. Then I want to create lots of fields and populate them without resorting to FieldCalculator or arcpy.DA modules. There are too many ...
-2
votes
1answer
77 views
Join CSV and shapefile files using common field in QGIS [duplicate]
I am trying to join a .CSV and a shapefile using "join attributes by field value." The common field I'm using is "County_Cit." I get an error message when I try this.
Do you know ...
0
votes
0answers
60 views
Join Field Error (ERROR_000499 Table is not editable)
I'm trying to join a field from a table to a census tract shapefile based on the CT name field. I'm getting this error however:
Has anyone encountered this error before and possibly know where it's ...
1
vote
1answer
30 views
Dissolve FeatureCollection using attribute
I have a feature collection with a number of properties, all numbers. I want to aggregate all features in the collection that have a property in common. For instance, I want to merge features that ...
0
votes
0answers
46 views
How to solve Error 000840 from arcpy.JoinField_management?
As part of a larger Python script, I am attempting for my last step to join an Excel file to a spatial layer. I was able to perform this step just fine in ArcGIS Pro Model Builder, but when I attempt ...
0
votes
1answer
40 views
Exporting joined table fields to new shapefile using ArcMap converts text fields to numbers
I have a problem when exporting to new shapefile by ArcMap 10.5. I use "add join" to join attribute from table (dbf file) to shapefile. Afterword, I need to export it to a new shapefile. It ...
2
votes
1answer
45 views
Join Attribute by location (Summary) not capturing all inputs
I created a 0.1 acre hexagonal grid and am trying to produce a heat map based on the respective polygon area that are found within a hexagon. I am using the Join Attribute by location (Summary) tool, ...
4
votes
1answer
117 views
How does one make and use temporal joins of CSV files in QGIS?
I have two CSV files, one with spatial information, and one with temporal information, to be joined on id
It looks like there are several methods,
Layer/Add Layer/Add Vector Layer of both CSVs (or ....
0
votes
0answers
18 views
Joining attributes via webmap hyperlinks
I have a parcel dataset from Henrico County Virginia but it doesn't include parcel owner names, which would be incredibly helpful in the analysis I'm running. The county has an online parcel webmap ...
3
votes
1answer
42 views
Call an input layer in field calculator for another layer
My model start by asking two input layer LAYER1 and LAYER2.
Then, in field calculator for LAYER1, i want to join an attribute value from LAYER2. Using this code :
attribute( get_feature( 'LAYER2','ID1'...
1
vote
2answers
40 views
Layer Join and Styling Trouble because of Field Types
I am trying to join a .csv-file with als rates and zip3 values to a shapefile with zip3 values and then color the map based on the als rates.
This seems very simple and I have done similar maps before ...
3
votes
1answer
229 views
Merging touching lines in QGIS
I have a vector layer, in which structures (pipes under roads) are made up of multiple lines. I wish to spatially join all the lines that make up a single structure, but cannot figure out a way to do ...
1
vote
1answer
97 views
Why is a (self) join so slow with Virtual Layer
I use QGIS 3.4 on Windows 10
I have a polygon layer and a point layer. The points have a streetname attribute. I want to check if there are polygons with more then 1 streetname.
I took 2 steps, first ...
0
votes
0answers
54 views
Merge attributes of selected features not working in QGIS 3
The following option in the advanced digitizing toolbar: Merge attributes with following features is not working.
According to the following query:
Copy attributes from one feature to empty row of ...
1
vote
2answers
62 views
Connecting column from Excel table with attribute table in QGIS
Is it possible to connect an Excel table or column from an Excel table with an attribute table in QGIS?
