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
1answer
30 views

arcpy.AddJoin_management() Error [closed]

I'm having an issue with some code I'm trying to write. Here's the code and below that is the output. # -*- coding: utf-8 -*- # -----------------------------------------------------------------...
1
vote
2answers
103 views

Merging attribute tables in QGIS

Currently, I have two attribute tables my vector table and an additional table for vector interaction. I was wondering if I could merge the attribute tables within the software. As I would like to use ...
0
votes
1answer
29 views

Iteration of AddJoin to join CSV files and a geodatabase feature class file

I have a geodatabase feature class file and I want to join the feature class file to CSV files respectively. For example: Join the geodatabase feature class and CSV 1 => save as CSV 1 in gdb. ...
1
vote
2answers
35 views

Copy selected attributes from one table to another in ArcGIS

I have two SHP files, with different attribute tables. The first is my base data, and the second is for use to import into an external modelling software package. The base data contains a whole ...
3
votes
2answers
142 views

Doing COUNTIFS equivalent in ArcGIS Field Calculator?

I have an attribute table with location data for a series of individual animals. They are often found at the same locations, so I have created a column in my attribute table where I list the rock ID. ...
1
vote
1answer
39 views

Transfering attributes from nearest feature using ArcGIS Desktop?

I have two layers, containing polygons (lots) and points (meters). I want to identify the closest polygon to the point, and then copy specific attributes from the polygon to the points. Is this ...
0
votes
1answer
32 views

ArcGIS attribute tables exploitation

I have kind of the same question as "greyline" : How to implement 3NF (third normal form) in ArcGIS attribute tables? I need, among other things, to place foreign key in my tables to combine them and ...
1
vote
1answer
45 views

Attribute Joining with .shp and .dbf showing NULL values in ArcMap?

I have a shapefile that only has 2 fields, one of which is the same as one of the fields in the .dbf file. I tried joining these 2 by their common field but after I do so, the 10 other fields in the ....
1
vote
1answer
84 views

Join a CSV file to GeoJSON using ogr2ogr in a Python script?

I have a CSV which I would like to join to a GeoJSON. I found this answer which I tried to implement but I can't get it to work just yet. Here's an extract of my python: join_command = ['ogr2ogr', '...
1
vote
0answers
22 views

Joining two vector layers with polygons and then selecting one via other in QGIS?

This could very well be a duplicate question, but i can't find the answer in the site. Using QGIS 3.4, I have two vector layers with polygons and same projections: one with all individual watersheds ...
1
vote
0answers
25 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
64 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
313 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 ...
0
votes
0answers
13 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
112 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
16 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
1answer
133 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
66 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
27 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
30 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
27 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
569 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
109 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
15 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
35 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
27 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
57 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
35 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
31 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
78 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 ...
2
votes
0answers
31 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
18 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
93 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
1answer
274 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 ...
0
votes
0answers
57 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
33 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
76 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
20 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
105 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
196 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
59 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
45 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
138 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
2answers
172 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
41 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
94 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 ...
1
vote
1answer
126 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
56 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
133 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 ...