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.
1
vote
0answers
15 views
Using Join Field more than once in ArcGIS Pro ModelBuilder?
I have a model where I'm trying to aggregate the zonal sums of a set of ~30 rasters into attributes on a shapefile of country boundaries. Ideally my model would create a new field in the country ...
1
vote
1answer
31 views
Define multiple fields to copy in graphical modeler in QGIS 3.6
I am looking to find the correct syntax for copying a defined set of fields when using the "Join attributes by field value tool" in the graphical modeler in QGIS 3.6.
I would like to know how the ...
1
vote
1answer
37 views
Joining attributes by field value not working
I cannot figure out why this join is failing when using the Join attribute be field value tool in QGIS 3.6.
Please see my image below which highlights the two layers attribute table and the criteria ...
-1
votes
0answers
18 views
Making all values in field of a point feature take on number of field in polygon it resides in, and retain the points outside of polygon?
I have a bunch of address points that fall inside 10 polygons. The polygon has a NAME field corresponding to the numbering 1-10. I have a field in the point attributes with the same name (NAME) that ...
0
votes
0answers
10 views
QGIS table with filter does not update when it is joined to a spatial file
Using QGIS 3.6.2 I have a CSV file with a dimension string field. This table is joined to a Shapefile via 1 matching string field. I filter the table source using the Query Builder on the dimension ...
0
votes
1answer
31 views
QGIS joined attributes not visible in categorized symbology
I am trying to make a thematic layer using the attributes from my now main table which were previously joined.
I would like it to look something like this:
As visible in picture, the columns ...
0
votes
0answers
13 views
Attribute Join creates headers but cells remain empty in ArcMap?
I'm trying to carry out an attribute join using one CSV and shapefile using the "LSOA11CD" fields as pictured below
The join validates in ArcGIS Desktop, however I get the following error message ...
3
votes
0answers
30 views
Issue with “Join attributes by field value” on QGIS 3.4.7
I have a shape file with polygons and a xlsx sheet, and I need to join their tables using Join attributes by field value in the modeler.
At QGIS 2.18 it works perfectly, but in 3.4.7 the join doesn't ...
3
votes
1answer
41 views
Most cells are “null” during join in QGIS?
I'm really new to QGIS and GIS software in general. I'm trying make a map travel time across different wards in a city, I have the average travel time and range between peak traffic and lowest traffic....
0
votes
1answer
25 views
Table Join on distance measures returns NULL
I followed every step of this tutorial but when I join the distToRoads and distance in m I get a table distToRoads which contains just the null vaues, why is that?
Tutorial: https://www....
0
votes
1answer
16 views
Graduated Style Renderer not displaying for joined csv to shp
I have joined a csv file (via the add spreadsheet layer plugin) and the field types have saved correctly (i.e. they are "real" types, see attached image), and yet the graduated style renderer option ...
0
votes
1answer
24 views
Using Spatial Join to join geologic features to polylines
I want to spatially join polygons (geologic features, major aquifers) to where the NHD polylines (rivers/streams) fall. I want to be able to click on a polyline and see what geologic feature or major ...
2
votes
2answers
133 views
Joining table with multiple-values-field in QGIS
I have a vegetation vector layer with vegetation type mapping. I want to join this vector layer with a CSV-file (no geometry) which includes threatened species occurrence.
The vector layer has a "...
1
vote
0answers
35 views
Many-to-many join in QGIS
Just want to know if there is a tool to do a many-to-many join in QGIS.
I have X number of polygons that I want to join with a CSV table which contains Y number of entries. Essentially I need to ...
0
votes
0answers
11 views
Update a join table in SDE
I'm trying to make edits to a versioned SDE Feature Class.
I joined a table that contained a list of all the point IDs that need to be updated. I called these PT_ID1 and joined them with PT_ID in the ...
4
votes
1answer
33 views
Join completed, can't set field from the table add for my graduated map
I've two thing that I joined, a shapefile of PollingStation and a csv of the results of the election. When I join them by the right field, I get a new table with all the information I need.
My ...
1
vote
0answers
23 views
Defining geometrical predicate [duplicate]
What are the exact differences between 'intersects' , 'contains', 'equals', 'touches' , 'overlaps' , 'within' and 'crosses' for attribute joints?
2
votes
0answers
40 views
Testing for vector joins in PyQGIS 3
I'm writing a plugin in PyQGIS 3, and I've to test for vector joins before run a code, so I've found here about vectorJoin() and write this:
def joinTables(self):
d, f = self.lyrPair() # d = {...
1
vote
2answers
29 views
Joining selected fields from table to shapefile using ArcGIS Pro?
I have a line shapefile with 100+ fields and a separate dbf file with 100+ fields. I'd like to programatically (using arcpy and Python 3) eliminate all but 3 fields in both shapefile and the dbf, and ...
1
vote
1answer
27 views
Applying same symbology to different DEMs?
I am using ArcScene and ran into this problem where I downloaded a couple of neighboring/bordering DEMs(in BIL format), imported them into the scene (as separate entities) and applied Base Heights so ...
2
votes
2answers
55 views
Understanding arcpy.CalculateField_management with Join?
I am using arcpy.CalculateField_management to fill a column field with another column values.
I have two shapefiles, fishnet.shp and new_run.shp. First I joined both using arcpy.AddJoin_management as ...
1
vote
0answers
29 views
QGIS: Copy all attributes of polyline layer when converting it to point layer
I want to add attributes from a polyline layer to a vector point layer.
The polyline is railway network. It has been divided into segments automatically, where as the attributes apply for each ...
0
votes
0answers
15 views
Joining xls file with shapefile attribute through ModelBuilder?
I have folder contains xls files and I need to make join for each file with a shapefile attribute using ModelBuilder.
My trial is as follows:
and obtained "Precondition" option only.
How can I ...
2
votes
1answer
63 views
UNION two LEFT JOINs as Virtual Layer in QGIS
In QGIS 2.18, there are two layers, e.g. "Locations" and "Connections"
"Locations" has values
Id | Dimension
---------------
1 | 4
2 | 8
3 | 2
"Connections" maintains attributes
...
2
votes
0answers
102 views
Join attributes by value in QGIS 3.4.3 Processing Modeler
I want to add only a few specific columns from the join table but there is no drop down list. When selecting manually I'm able to select only 1 column when trying more than 1 I'm not getting the ...
2
votes
0answers
58 views
Updating set of attributes on vector layer from .csv table?
I have over 1,000 records in a .shp file, all with a unique ID field (LINKID), along with many other fields containing data (TXTFLD1, TXTFLD2, INTFLD1, INTFLD2, etc).
These records have been copied ...
0
votes
0answers
41 views
How to merge / join line segments by attribute and split at intersection
I have a complex network of line features with a lot of attributes (and unique IDs). Many features have the exact same values (exept the ID). I need to join all features with the same attribute which ...
0
votes
1answer
31 views
left join returning one more row than expected
I have a table of single polygons (table rast_poly) derived from a raster and a table of polygons that represents buffered points (table pt_buff). The raster polygon geometry has been reduced by using ...
1
vote
1answer
62 views
PostgreSQL PostGIS: Spatial join but keep all features that don't intersect
Spatial joining a point table to a polygon table, creating a new output table. So far I can only get the output table to contain features that satisfy the spatial join. However, I want the output to ...
1
vote
0answers
19 views
QGIS 2.12 How can I assign the attributes of the polygons of the layer A containing the geometry of layer B?
In other words, I have two shapefiles:
Layer A: not-intersected Areas (1 attribute: ID);
Layer B: Buildings (Several attributes).
I want to identified by the related ID attribute all the buildings ...
0
votes
0answers
12 views
Attribute table QGIS [duplicate]
I have a attribute table with different columns. I have to add one more column and then copy paste the values from a different column, but both columns are in the same table attribute.
How can I do ...
1
vote
0answers
45 views
QGIS Join is returning Null values
I am trying to join this data to this data (UTM32 Ebenen file = VG250_GEM.shp) using columns Column2 and SDV_RS, respectively. I am using QGIS 3.4
I am following the instructions found here . ...
2
votes
2answers
65 views
Adding field in vector layer from attribute table in QGIS? [duplicate]
I have an Attribute Table named 'data.shp' and a Vector Layer 'pop.shp'.
The 'data.shp' has the following fields "ID", "value1", "value2"
The 'pop.shp' has the "ID" field (same with the 'data.shp')
...
1
vote
0answers
51 views
QGIS: Add attribute from polyline layer to point layer [closed]
I want to add an attribute from a vector line layer to a vector point layer.
The vectorline is railwaynetwork. It has been divided into segments automatically. To process the data further I had to ...
2
votes
2answers
44 views
Selecting features of a shapefile using attributes of another shapefile
A newbie here trying to learn QGIS for work.
How can I select specific features of a polyline with the same values as the attributes of the buffer polygons I generated?
I have a layer of polylines ...
2
votes
1answer
92 views
Join attributes by location gives out wrong sum
I have an input vector polygon layer which has different areas.
Now I want to join a different vector polygon layer which contains over 1 million 100x100 meter squares with information about the ...
3
votes
1answer
109 views
Joining by 'almost' identical attributes using QGIS?
So I have two point shapefiles - their attribute table consist of names, lat, lon, and others.
I would like to join the attributes of shapefile 1 to shapefile 2. A normal join between the names would ...
1
vote
0answers
31 views
Refresh layer with joined tables from watched files
I have a shapefile joined to data from a CSV file that is being watched by QGIS.
If the CSV file is updated, the attributes in the CSV layer are updated as expected, but the data in the joined ...
1
vote
0answers
53 views
Large increase in .dbf file size after attribute table join
I have a polygon shapefile of about 12,000 features that I joined a CSV attribute table to using 'Join attributes by field value' in QGIS 3.2.1
The .dbf file size before the join = 5.6 MB
The .dbf ...
0
votes
1answer
36 views
Invalid Primary Key error message when attempting to join table view and feature layer
I am attempting to join a feature layer to a table view in order to export a table of all non-joining features in the table view by selecting NULLS from the join field related to the feature layer. ...
0
votes
1answer
37 views
Join linestrings in shapefile of watercourses that have same NAME and PERENNIALITY
I have a shapefile (link below) of only watercourses comprised of many short linestrings.
OpenJUMP displays this about each segment
LINESTRING (
153.05422 -26.44881350000003,
153.05448 -26....
1
vote
1answer
81 views
Python QGIS 2.18 to QGIS 3 : Shp file attribute joins and how do i specify the join fields?
My question is in two parts :
1) How do I modify my pre-existing QGIS 2.18 script to work in QGIS 3? (i'm still learning Python)
2) How do I modify it to join only specific fields (i.e. i dont want ...
0
votes
0answers
13 views
Joining Daily Temperature Data to Another Table
I am using ArcGIS Desktop.
We are looking at the movements of organisms daily as a result of temperature changes. We have a layer that displays surface temperature values daily for several years. We ...
0
votes
1answer
76 views
Find the closest Point from a Point which contains the same attribute
I am trying to create python code to iterate through points on 1 layer and find the closest point on another layer (Road Chainages) based on attribute values. I need to limit the search to < 20m ...
2
votes
0answers
33 views
How do Joins & Relates in layer file and Layer Properties work?
I'm using ArcMap 10.5. I set up symbology for a feature class based on joined attributes from a table in the same file geodatabase. I want to be able to apply the same set-up in different geodatabases ...
4
votes
2answers
66 views
Refering to (Joined) Field Names in arcpy in Field Calculator
I'm trying to update the locations of a point FeatureClass using a table.
I have joined the table to the featureclass, and am attempting to use Field Calculator to update the SHAPE field.
I found ...
0
votes
1answer
53 views
QGIS 3.2 Join Attributes from Layer Limitation?
I want to join two txt tables as a layer in QGis 3.2. In eralier versions (2.12) works to join one of the tabel more times to the other table. Now in the version 3.2 i can join only one time. The ...
4
votes
2answers
152 views
QGIS Joined Layer not displaying points visible on pre-join layer (No Extent)
I have a shp file which is the output of the Toolbox Check validity tool in QGIS 3.4.3
The points display for me correctly but if I then join the layer with a csv attribute using the toolbox Join ...
1
vote
0answers
29 views
How can I make integers on a join SHP file stay as INT and not as qlonglong?
So I've been trying to join a CSV file with a polygon SHP file and everytime I try to save the joint SHP into a new file it transforms the type from int to qlonglong and prevents me from using some ...
1
vote
1answer
43 views
Create new vector of polygons that are within 500m of a point in vector of points P
If I have a vector of polygons A (say 200) and want to create a new vector (say 120) of the original 200 polygons that are with 500m of a vector of points P (say 50), this is the method I do. I want ...
