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
0answers
22 views

Joining CSV tables by multiple attributes

I am using QGIS 3.16 I have a shapefile with an attribute table containing regions, district-numbers and building-numbers and I have an additional table (CSV) that (besides other relevant information) ...
0
votes
0answers
48 views

Joining Table attribute to Map attributes without matching properties

I have a Dataset (10Gb) that I imported to QGIS 3.22. It contains multiple tables and maps. The first map categorizes land usage (HWRM_HWRK_LN) and I was able to attribute a color gradient. The four ...
0
votes
1answer
20 views

Joining field of multiple tables into one shapefile using ArcMap

I have one shapefile containing several zones (polygons), which are several agricultural parcels. Each parcel has its own FID. I also have five tables containing the crop type of each parcel for five ...
1
vote
0answers
14 views

'Join Attribute by Location (Summary)' slows down with time

I'm attempting to perform a 'Join Attribute by Location (Summary)' between two polygon layers where I calculate the sum of a given field in the join layer using the 'Intersect' predicate. The process ...
0
votes
0answers
44 views

Table join working weirdly in QGIS

I am trying to join a .shp (polygon) with a .csv table containing numerical values. My key is "Agenzia" which is in both cases a string field. The join works except for the two values shown ...
0
votes
0answers
11 views

Joined field makes features disappear with graduated symbology using ArcGIS Pro

I have a CSV file joined to my shapefile and I can choose the joined fields in the dropdown for graduated symbology but the geometries are not visible on the map when I select field from the CSV. The ...
0
votes
0answers
20 views

Join two Tables based on two common columns

Let's say I have two time series shapefiles and I want to join them based on the common values in ID (not ArcGIS created ID) and Date column. Currently I am using join via table attributes, but the ...
2
votes
0answers
35 views

Adding data from CSV file to vector layer in QGIS

I am trying to add data from a CSV file to a Vector layer (shapefile). I already created a column with same numbers to have a reference column, so I could join my CSV data to that reference column. I ...
0
votes
0answers
30 views

ArcMap spatial join only partially working

I have 141 main polygons, and then a list of thousands of smaller polygons that are clipped to the main polygons. I am interested in knowing what percentage of the surface area of the main polygons is ...
1
vote
0answers
30 views

Symbology on joined variables not showing up on map in QGIS

I am trying to add a certain styling to points I have on the map. I have set a Rule-based styling with a range added based on a different variable. Both variables were added to the point DB from a ...
1
vote
0answers
31 views

Ignoring small areas in QGIS join attributes by location

I want to add the attributes of a first data layer, of selected land ownership data, to a second layer, of land parcels across the county. The second layer covers the whole of the county, the first ...
0
votes
0answers
32 views

Joined attributes by location ERROR not find some attributes

I have two layers to join attributes by location: a. road map (attributes=segments of roads) b. fastest path (with shortest path from layer to point plugin going over "road map") to identify ...
2
votes
1answer
47 views

Spatial Join takes very long time on two small datasets using PostGIS

I have two datasets: A is a hexagon grid and has 19089 rows B contains linestrings and has 18641 rows I want to know, which linestrings are within which hexagon. WITH bufferedB AS ( SELECT ...
0
votes
0answers
34 views

Setting start id and end id to attribute of polyline from ids of point layer using QGIS [duplicate]

I assigned automatic nodes to the start and end points of the path I digitized. I want to add the start id and end id of the points to the attribute table of the road layer so that I can use the ...
0
votes
0answers
30 views

Joining SHP with XLS sheet using Excel

I am trying to join SHP by field CONCATENATE with my XLS sheet. SHP attributes looks like this: ID NAME CONCATENATE 122 765 122765 345/1 765 345/1765 987/3 345 987/3345 Because of those slashes ...
0
votes
1answer
55 views

Merging two spatial datasets based on both geometry intersection and year (try to create cell-year panel data, so basically 2 conditions) in R

I am trying to merge two datasets, both have geometry column (1st with polygons-cells and 2nd with points). Where i want the 2nd dataset (with the points) to be merged to the 1st dataset (with ...
1
vote
1answer
33 views

Moving Excel/CAD data into ArcMap [closed]

I am new to GIS. I was wondering how to go about taking geometry data (from AutoCAD) and attribute data (from Excel) and combining them into a single layer or shapefile or feature class. The AutoCAD ...
6
votes
3answers
216 views

Find missing attribute values / features by comparing GeoPackage table with Excel sheet or CSV

As I digitized stuff manually from a raster map and I have a list of all needed features, I want to compare tables. One complete CSV or Excel, for illustration: Feature_Code Fruit Disabled TH1 ...
6
votes
1answer
50 views

Merging features in shapefile with same name and concatenate all attributes as single field

I've got a dataset of tiles with individual attributes (NAME,date,sensor). All tiles have the same size. After dissolving layer, in some locations tiles with the same NAME attribute overlap each other ...
0
votes
0answers
32 views

Using Join Multiple Lines Plugin for QGIS

I am using the Join Multiple Lines plugin for QGIS Hannover to join segments of a watercourse layer and while it seems simple enough, it just doesn't work. I select the segments I want joined, select ...
0
votes
1answer
44 views

Combine two shapefiles in ArcGIS Pro [closed]

I have two shapefiles - one contains 3000 polygons representing the electoral divisions of Ireland, and the second contains 18,000 polygons representing the land use classification of Ireland in 2018. ...
1
vote
1answer
24 views

Sum of a attribute at different points with the same coordinate

I am quite new to ArcGIS. I want to know how can I sum the number of different assets at the same point in a table as follows. As a result, I want to have a table as follows:
1
vote
1answer
46 views

Weighted mean in attribute union with QGIS

I have joined Argentina's census data wich has small area divisions, with electoral disctrict data wich has a bigger area than those of the census. In QGIS, I've calculated centroids for the census ...
1
vote
0answers
12 views

Table join only inserting values depending on values in column from other table [closed]

I have two tables. One table with areas of certain types a.matrikulaere_foreninger with 274 rows and another table with a column called b.pnr. I want to create a view where the pnr from table b is ...
2
votes
1answer
69 views

Appending field from one layer into a different layer in QGIS

In QGIS, I have one layer (called 'All data shapefile') which is a shapefile with my entire set of data, and another layer (called 'Y_data') that is also a shape file with a subset of 'All data ...
0
votes
1answer
59 views

Joining all atrributes of one column in point-layer like number in multiple columns of a polygon-layer like number_1, number_2 etc. in QGIS

I got a point-layer Points where all points lying exactly on the vertexes of the polygons of a polygon-layer Polygons. How do I join all numbers of the point-layer to the polygon-layer? All algorithms ...
2
votes
0answers
40 views

How to make a column in a joined layer editable?

I have layer1 from postgresql which has is joined to layer2. Most users work on layer1 but there is a column on layer2 which needs to be updated by users of layer1 Without making layer2 fully ...
0
votes
1answer
72 views

R Leaflet SpatialPolygonsDataFrame @data join w/ dataframe; data on wrong polygon

The polygons are plotted using the US census county file: https://www2.census.gov/geo/tiger/GENZ2018/shp/cb_2018_us_county_500k.zip Read into R with : UScounties <- rgdal::readOGR(dsn = paste0(...
1
vote
0answers
37 views

QGIS omitting repeat fields in a CSV

Total QGIS noob here who started using the software last night, I've looked all over SE for a solution but nothing helped. I joined a shapefile to a CSV. The join field is 'market_number', target ...
0
votes
0answers
47 views

Joining Excel table to shapefile is too slow

I am trying to join the information I have in some Excel files to their corresponding layers in QGIS 3.16. Disclosure: I am pretty new to QGIS. My workflow is the following: I have an Excel file of ...
2
votes
1answer
30 views

How to join the content of an attribute in multiple rows with semicolon and delete doubles (QGIS)?

I have a shapefile with a large number of buildings (polygons) and want to add an the parcel number from a different shapefile in QGIS. In most cases this works well using join by position. However ...
0
votes
0answers
40 views

Help joining two polygon layers using ArcGIS Spatial Join

I am trying to use ArcGIS Pro to spatially join approximately 600,000 polygons in ESRI TitleInfo with the polygons in this London landuse dataset. However, the spatial join fails to match any record. ...
1
vote
1answer
30 views

Matching/Joining Photos to two fields and a fuzzy time

I have a directory with around 100,000 images sorted by the crew that took the photo and the time it was uploaded. I also have a master spreadsheet with the dates the images were taken, the camera's ...
1
vote
1answer
42 views

Spatial join with "IF" operator and "Closest" match option

To add AdressIDs from a point feature layer to noise immission point features (Target, green points)), I need to spatially join immission points (IPs) to addresses (Join Features, red points). The ...
1
vote
1answer
33 views

Joining by location and by fields simultaneously using ArcMap

ArcMap 10.4.0.5524 for Desktop. No internet connection. I have points with street names and lines with street names. I would like to join the points and the lines (giving the attributes of the lines ...
1
vote
0answers
21 views

Making ModelBuilder tool with series of joins 'generic' using ArcGIS Pro

I am using ArcGIS Pro 2.7.1 My workflow involves ingesting data from various jurisdictions, populating several of the fields and then appending it to a master dataset. I wanted to create a tool ...
0
votes
1answer
89 views

Solving error 00226 to publish a joined table from ArcGIS Pro to Online

I've created a layer where I've appended population data to a set of polygons (neighbourhoods of a city) by using a join. I want to share this layer on a web app, but I get an error message when ...
1
vote
1answer
40 views

Joining ArcMap to Excel table but join fields not showing up in join dialog

I have datasets in a File GDB Feature Class and an Excel table. I want to join them on a field named JOINFIELD. I have the same field name in the FC & in the top line of a column in the Excel ...
6
votes
2answers
152 views

How to group polygons based on spatial proximity and field value?

I have a shapefile consisting of the day of the year on which the temperature in a lake exceeds 15 degrees Celsius. I can see clear patterns in this (here seen as a raster): I want to group the ...
0
votes
2answers
34 views

Joining a table to a feature class based on two or more fields

I have a Table and I would like to join it to a polygon feature class but based on two columns. As in if the polygon has the same values in in column A and column B it will join. If the table has the ...
0
votes
2answers
32 views

Join attributes of a point layer with fishnet (grid of 20km)

I am fairly new to QGIS. I am using version 3.18. The idea is to find the relationship between the project activities of NGOs in a country and the level of conflict. For this I have a txt delimited ...
1
vote
0answers
48 views

Migrating polyline sidewalk data into centerline (two lines into one without attribute loss) using ArcMap

I'm in the process of amalgamating several sidewalk datasets which require updating. All data I intend to consolidate within my centerline is based off of older versions of the data, and is a single ...
0
votes
0answers
21 views

Join two polyline shapefiles without a common field to copy over attributes?

I am trying to sort out how to utilize two polyline shapefiles where their data doesn't have any common "data" attributes but they generally represent the same features. Spatially, there are ...
1
vote
1answer
38 views

Trying to join Excel table to shapefile using ArcPy (ArcMap 10.8) fails using JoinField_Management

I have a shapefile of drone flight footprints that I am trying to merge an excel tracker/log file to. The shapefile and Excel file will change each time I run the script so I am trying to store the ...
1
vote
0answers
29 views

R dangerous streets: match routes and crashes

This is my first attempt with mapping in R. I have posted my question also in openTransportDataDemo github and I copy it here to hopefully gain broader attention: My goal is to find the roads where ...
1
vote
1answer
39 views

Adding data from CSV file to new attribute fields in QGIS

I'm very new to QGIS and have started by downloading a shapefile and importing it. The attribute table had only 1 attribute field ("name"). We needed more attribute fields so I manually ...
0
votes
1answer
36 views

After joining a CSV to a shapefile in QGIS, some place names are left with null values. How do I get the original values into the shapefile?

I'm editing a shapefile for an election map, so I downloaded some county level vote totals and am adding them to a preexisting shapefile. This works for the most part (I can produce most of a new map ...
0
votes
0answers
39 views

QGIS Missing Features on Map

I have a shapefile in QGIS 3.16 that I created by performing a spatial join. It displayed properly on the map. I then edited some of the data in one of the spatially joined fields. After doing so, ...
1
vote
1answer
22 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
52 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 ...

1
2 3 4 5
18