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.
745
questions
0
votes
1answer
25 views
Join Attribute Table with multiple owners with only one Parcel
I have a problem in QGIS. I have an attribute table (no geographical information), which contains owners of parcels and an ID for every row.
Then I have a shapefile, which contains polygons and an ...
1
vote
0answers
32 views
Unable to perform join raster-table ArcGIS 10.3
I am trying to replicate some results from a publication. There, one of the datasets they use is WISE30sec map (available for download here: https://www.isric.org/explore/wise-databases). My problem ...
3
votes
1answer
68 views
Joining fields with long field attribute names
I am working with the "Joins" option in QGIS 3.10, which joins the fields from two attribute tables based on a common shared attribute column.
However, this does not work for attribute values with a ...
0
votes
0answers
21 views
Taking bulk data and updating attribute fields efficiently [closed]
I need to get mailing address information into my attribute table for two whole counties parcels. The data the counties gave me didn't come with that information. However, it is available. I don't ...
1
vote
1answer
40 views
Join attributes by location fails to join to selected features
There's an issue when I perform the "join attributes by location" tool. I have a simple polygon layer representing urban areas. I also have a point layer with human population estimates. My aim is to ...
1
vote
1answer
22 views
Attach features of lines to points
I am trying to calculate the cost of network to homes. In the image i have cable (brown line) between utility boxes(pink/blue points) and home feed (black dash) to the home.
I know the cost for each ...
0
votes
0answers
35 views
Join attribute by location giving bigger results QGIS
I have created a grid over South Africa, each cell being 10 km x 10 km. In addition, I have a raster layer that has been polygonized, each polygon containing a population count. The total of these ...
4
votes
1answer
50 views
CopyFeatures management creates long name
I'm trying to join a shapefile to a csv file. The join works but the attribute table has the long name of the shapefiles which makes the fields not readable.
How can i fix this problem?
Calling the ...
0
votes
0answers
46 views
Using ArcPy to select joined field
I have written a script which takes two inputs, intersects them, creates a new field in the output feature class and joins it back to one of the input feature classes. I would then like to select the ...
1
vote
1answer
28 views
Additional features added when using “join attributes by location” QGIS
I'm getting some weird output after performing the "Join attributes by location" tool inside QGIS 3.10. Below is a shapefile representing watersheds in South Africa. I'm only interested in the ...
3
votes
0answers
42 views
Joining lines intersecting with only one other line?
I have road centerline file that is split into smaller segments. I need to make a node file. How can I join line segments intersecting only once - so I wouldn't join ones that have 3-4 intersections ...
1
vote
2answers
27 views
Many to one join in Carto
I have two datasets:
A point shapefile of companies (each row/record is a unique company)
A list of awards given to those companies (each row is a unique award, but since companies can win multiple ...
0
votes
0answers
12 views
Merge attributes from identical point clouds
I started this process with one point cloud, and classified it in TBC, and exported as .las file. While exporting, it does not save GPS time (only Mobile Mapping system export works with GPS time).
I ...
0
votes
1answer
48 views
Joining more than two lines that intersected in one point using FME
i have point connects with four lines in dgn file
Each line has his unique id ,iam usng FME 2018 software
i used line combiner for the map ,i found only ,each two lines is able to connect together ....
1
vote
1answer
38 views
QGIS Update Column
I have a CSV file which I would like to join to a TAB file.
The TAB file has the table structure shown below. The column PLAN_NO is the unique reference in this table.
The CSV file has the table ...
1
vote
2answers
52 views
QGIS - look up Table to feature Layer where Table answers questions to Multiple Columns in Feature Layer
In the image example below:
Feature Line Layer = Transport - District
Lookup Table = TRAFFIC_IMPACTOR_CODE
What is the most efficient way to "connect" (join/relation/query/field calculator) both ...
4
votes
1answer
140 views
Importing Data from CSV without longitude and latitude but a location code
I am new to QGIS. Above is the image of data I have. The .shp file in QGIS have that geographical department codes as well. I want to read the data from CSV and plot in map but don't know what to put ...
1
vote
1answer
41 views
Joining point layer with line layer using coordinates
I am using QGIS 3.14, and I want to represent a road network.
I had a polyline layer (3257 entities) as a background. For each one I have calculated x_start, y_start, x_end, y_end coordinates, length ...
1
vote
2answers
35 views
Performing one-to-many join with address and crime data using ArcMap
Goal: I want to show the police calls coming from a parcel on ArcMap. So if you click on the parcel, it will show all the calls for the year. I want to join the address attribute from the parcel data ...
5
votes
1answer
173 views
QGIS and 1-to-many relationship
I am using QGIS 3.10.0
I am attempting to join a spatial vector layer to a non-spatial layer (CSV).
Each polygon on the spatial layer has a unique id attribute. The CSV also has this id attribute ...
0
votes
0answers
20 views
Joining z-values (from point file) to map generated by Kriging in ArcGIS Pro
I am using ArcGIS Pro 2.4.0.
I am making a fertilizer application map that changes the rates, based on the location of the field. The overall goal of the operation is to create a grid of squares, ...
0
votes
0answers
17 views
Joining multiple layers to a dBase table
I am attempting to join my standalone dBase table to all other shapefile layers in my project. I have about 5-6 hundred layers give or take and all of them share the same table format. I want to join ...
0
votes
0answers
16 views
Join fields from multiple shapefile in a folder to one shapefile
I have 39 shapefiles in a folder with each shp having 368 attributes. Every shapefile has the same attribute name (FID, pointid, grid code and 365/366 others; depending on them being leap year).
I ...
0
votes
1answer
40 views
Return all results from join of non-spatial CSV to spatial data using ogr2ogr and SQLite dialect
I am attempting to carry out a simple join of a non-spatial CSV to a GeoJSON data source using ogr2ogr an its built-in SQL capabilities. I would like to use the SQLite dialect to carry out the join. ...
0
votes
1answer
45 views
Error message when joining two dataframes with sf -Error: y should be a data.frame; for spatial joins, use st_join
In R, I'm trying to count the number of points which fall within a buffer around polygons and add the count result to the original shapefile from which the polygon file was created. I've followed the ...
0
votes
1answer
17 views
QGIS add/join fields from geosjson
I want to join some fields from a .geojson file wihtout geometry to another .shp layer.
The join function is not working because I want to keep the fields in the .shp file even then the .geojson has ...
0
votes
0answers
12 views
Joining Spreadsheet to Vector Layer
I am working with QGIS Zanzibar. I have a spreadsheet that I am "joining" to a vector layer. BUT it should be a Many-to-One relationship (Many rows in Spreadsheet to One row in Vector Layer. I have ...
3
votes
1answer
171 views
Shapefile disappeared from layout view and its symbology changed after updating data source?
I am trying to update a map based on a pre-built mxd template. However, after everything ran successfully (python code below), the shapefile that was updated did not show up on the map. Its symbology ...
1
vote
0answers
15 views
Joining fields in Processing Modeler of QGIS
I am trying to join field district layer with output A .
How can I do this?
I added Vector field input but i cannot see the output A field to make the join by fields .
I have attached an image to ...
3
votes
0answers
43 views
Joining attributes from points to polygon
I am working with two shapefile, polygons and points. These shapefiles do not overlap and have different attribute values.
The point layer contains data that I want to join to the beginning and end ...
0
votes
0answers
27 views
Arcade Script to Link to Attachment Lost in Join
I created a survey using Survey123. The survey produces a table, no points. I then join the table to my existing point feature in ArcOnline. This works great except that I lose the photo attachment ...
3
votes
1answer
51 views
Merging or joining two tables with some matching columns in QGIS to calclulate unique values
I have two tables (A and B) that display the presence or absence of a species within a polygon and within each polygons associated buffer layer. The purpose of the buffer layer is to account for a ...
0
votes
1answer
41 views
Joining csv with shapefile using Python [closed]
I am wanting to join a csv with an shp file any ideas on the methods used to complete this.
I've seen a few different ways none of which are working for me?
0
votes
1answer
25 views
Joining tables that have different numbers of rows using ArcMap?
I am trying to join a table to a raster output for an assignment in ArcMap (10.7), but they both have different numbers of rows.
Is it possible to join them?
1
vote
2answers
65 views
Using table joins with ST_DWithin to optimise process?
I am trying to select all segments (among millions of them) that are less than X metres from a few thousands polygons obtained from a raster dataset (meaning they've got quite a complex geometry - ...
1
vote
0answers
19 views
Joining my spreadsheet data to my geodatabase file is not including all matching records
I have a map with roads, trails, and site gdb layers, and I have an Excel spreadsheet that I have imported with a list of the permitted companies for each of the designated roads and trails. I would ...
0
votes
0answers
23 views
Performing table join using NextGIS
I'm getting start with NextGIS and have a web map with a couple shapefile layers on it. Now, I'm trying to recreate some existing functionality on QGIS that involves a table join between a shapefile ...
3
votes
2answers
401 views
Joining attributes from points to lines QGIS
I am working with two shapefile layers: lines and points. These shapefiles do not overlap and have different attribute values.
The point layer contains data that I want to join to the beginning and ...
0
votes
1answer
26 views
Will my join remove my relate?
I have spatial data that has an existing related table with photo info.
I have data from another separate table that I want to join and then field calculate to add to my spatial data, then I would ...
1
vote
0answers
61 views
Automatically update records in layer based on changes in another
I am using QGIS and I have two layers the first one is "Reading" layer with the attribute details
The second layer is "Reading_History" layer with the attribute details
I want to use the expression ...
0
votes
0answers
32 views
Joining data without having a common ID or same spatial location
I have two polygon shapefiles, which don't have same spatial locations, neither have common attributes. Is it anyhow possible to join these files in ArcGIS 10.3?
I know the ArcGIS supports two kinds ...
2
votes
0answers
43 views
Join selected features from different shapefiles (QGIS)
I have two different shapefiles, with selected points.
I want to create a new shapefile with only the selected features of those two shapefiles.
0
votes
1answer
31 views
Using join in ArcGIS Pro?
I am trying to join the information from a line to that of a point associated with that point. To explain a bit, it would be adding the information from a bus line to the associated bus stops with ...
1
vote
0answers
50 views
Fill in gaps in QGIS shapes?
So basically, I've written a script that generates a lot of polygons over the UK with certain criteria. The output it a lot of shapes like the following - I wanted to know if, in QGIS, I'm able to ...
4
votes
2answers
141 views
Spatial join based on polygon centroid in QGIS
I have 2 cleaned shapefiles, one containing building footprints and one land parcel shapes, both have attributes. I want to do a spatial join when data from the land parcel is merged into the ...
0
votes
0answers
21 views
Selecting Polygons of one layer with information from table using ArcGIS Desktop?
I have two 2 datasets:
A shapefile with many polygons. They all have an ID.
A table (.csv) that has one column with IDs.
I need to select all Polygons in 1) that are mentioned in the column of ...
0
votes
1answer
83 views
Specifying join on multiple datasets in a WFS URL request (CQL/Filter)?
I’m using a WFS and trying to join two/three datasets together in a URL query.
Two of the datasets are linked via an aspatial table in the middle like so:
| Table 1 | | Table 2 | ...
0
votes
1answer
100 views
QGIS one to many join issue
I already asked in previous question QGIS table join issue, how to join shape file data and CSV data which contain multiple SAME ID for one object?
Shape file contains columns: object id, area, ...
1
vote
1answer
87 views
QGIS: Joining data from multiple road lines onto polygons by location
I'm looking to add traffic data linked to a polyline shapefile of road centerlines to a multipolygon shapefile of land parcels. I want to join this data using proximity to roads instead of by matching ...
2
votes
1answer
86 views
QGIS table join issue
I got CSV data on analysed buildings containing object ID, materials etc. And I have vector file with spatial location of all buildings in the city containing as well object ID and some other ...
