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.
693
questions
1
vote
2answers
19 views
Wrong result using virtual layer sum with join and group by
I am trying to join the grouped sum of two layers using virutal layers in QGIS 3.2.
My query looks like:
select nvewi.zone as "Zone-Type", sum(nvewi.bev) as "Inhabitants Isochrones", sum(nvewp.bev) ...
0
votes
1answer
25 views
QGIS3 - how to define/change field type for non-spatial data table?
I am playing with joining data in QGIS. I previously did it only with two spatial layers and now I am trying to connect one spatial layer (polygons) and "non-spatial" data in a CSV table using a text ...
-1
votes
0answers
36 views
Joining spreadsheet (.xlxs) to raster using script in ArcPy? [closed]
I'm creating a script to serve as the base for an ArcMap tool. At this stage, I have two input data: a raster (land cover, TIFF) and an Excel table (.xlxs). They both have a field called "Value" which ...
2
votes
0answers
39 views
Pull information from one shapefile and add it to the attribute table of another?
I'm trying to create a shapefile for one particular area in Germany. I have various shapefiles which store all the information that I need. One of them is a 100m_Gitter_raster (a raster consisting of ...
1
vote
1answer
42 views
Combining properties of two FeatureCollections that have same Features in Google Earth Engine?
This is throwing me for a loop, yet it seems so simple. I have two FeatureCollections that have the same features (but different properties), as they were generated by reducing over the same ...
4
votes
2answers
103 views
CSV file not joining to Shapefile using QGIS?
I am trying to join a .csv onto shapefile data. This csv file is a non-geometric file. When I go to join the two, the shapefile reads that the columns are null. Both files have matching columns.
I ...
0
votes
1answer
22 views
Relating a 1:M from CSV file to Shapefile and exporting?
I have a shapefile with 3 different statations, in addition to a CSV with time data and multiple records for each station, based on time.
Shapefile dbf:
ID Station
1 A
2 B
3 C
...
0
votes
0answers
21 views
Join attributes by location using gdal in command line
I have a Shapefile with lon-lat coordinates (points) and I want to join it with a vector grid. When using QGIS I do this with "Join attributes by location" , using as input layer the vector grid and ...
1
vote
0answers
36 views
Joining attributes by location/intersect works for all but one polygon in QGIS?
I used the Join attributes by location and Intersect tools in QGIS 3.4 for my points layer to add a column with name of the intersected area into the attribute table of points. It works perfectly for ...
1
vote
0answers
31 views
Joining .csv with duplicate values to .shp layer with points and getting all points visible using QGIS?
My problem with QGIS (version 3.4.8)
I have a .shp map layer containing point data of buildings. I want to join .csv spreadsheet to this layer so I can look into it and visualize different variables ...
1
vote
0answers
16 views
QGIS - How to add joined values table data to shapefile
For some reason I lost my previous question here but I proceeded a little bit after upgrading to the newer version of QGIS.
My problem was combining spreadsheet .csv data to the .shp map layer, where ...
1
vote
1answer
11 views
ArcMap: Combining County Polygons for 3 separate states into one layer with attributes
I have 3 separate layers with the counties for 3 separate states: WA, OR, & ID. I want to combine them into one layer "Counties" so they all share an attribute table with the same fields. I am ...
0
votes
1answer
27 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
84 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
19 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
32 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
126 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
28 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
26 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
39 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
46 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
18 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
43 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
64 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
12 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
43 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
0answers
54 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
44 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
21 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
238 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
67 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
12 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
24 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
46 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
32 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
29 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
61 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
17 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
69 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
148 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
59 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
46 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
32 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
64 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 ...
