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

Type the max number title in Excel

I want two fill land type with column a , b , c , d. If A is greater then all 3 then type A or if b is greater then A, C and D then type B or if c is greater then A, B and D then Type C or if D is ...
1 vote
0 answers
19 views

ArcGIS Pro - Data joined back to original misses matches using Join

I had a feature class with postcodes of Spain. Out of this I compared it to a different layer, performed some geospatial analysis and I have the output feature class that also contains the postcode ...
  • 239
2 votes
1 answer
28 views

Combine features into new category

Within a vector layer I have dissolved 25k polygons into 43 different categories of land ownership (Ld_Use_Des). But now I want to further ''group'' them. For example I want to select Mineral Rights ...
  • 443
0 votes
1 answer
16 views

Join Validation Report Contains Invalid Character " "

Very new to ArcGIS. I am attempting to do a table join. It is joining a shapefile of the us states with a CSV of import data. However when I try to validate the join i get an error saying the ...
0 votes
0 answers
9 views

One-to-many Joins on two txt files in ArcGIS Pro - GTFS

I want to work on a GTFS project and trying to figure out if I can perform all my data engineering processes in ArcGIS Pro without having to go to some external tools to perform joins. What I want to ...
  • 239
0 votes
0 answers
29 views

ArcGIS Join Field not adhering to field mapping merge rules in one-to-many join

I am trying to join records from Table B (join table) to Table A (input table) in ArcGIS Pro using the Join Field tool. This is a one-to-many join such that there are multiple records in Table B that ...
  • 21
0 votes
0 answers
14 views

How can I join data to an attribute table while keeping all of the data records of the data I am joining?

I am trying to join the data of a CSV file to a shapefile attribute table. I am trying to join data based on the 'name' column. But I want to join multiple values from the CSV file to each value in ...
  • 11
1 vote
1 answer
57 views

Move points with same name and the nearest distance

In QGIS 3.28.3 and i have layers A and B (both contain only points) and I want to move the points in layer B to the nearest point in layer A, under the following conditions: The points must have the ...
1 vote
0 answers
30 views

How to use Near tool then join by FID to calculate exposure index [closed]

I am working on a project and the instruction I am given is: For each school, calculate an index of its exposure to toxic emissions. For all toxic sites within 1 mile of each school, divide the site’...
  • 11
-1 votes
2 answers
69 views

Comparing similar words in two different columns [closed]

i have list of different categories in same dataset in two different coulumns There are some similar words in the two columns. So by comparing the two columns the maximum matched wordings should be ...
  • 645
0 votes
0 answers
21 views

Loading non geometric JSON in QGIS [duplicate]

I try to import non geometric JSON data from a webservice into a QGIS project (version 3.18), as data table. These data could then be joined to a geometric layer with a common identifier. This JSON ...
  • 321
0 votes
0 answers
25 views

Time format/ data display changes following join then export to data

I am working on a simple join of data in an excel table to create an attribute table from kml's that were converted to polygons. The join works perfectly, however when exporting the data as a new ...
  • 1
0 votes
0 answers
23 views

Use join field as replace - ArcGIS Pro/Model Builder

I am looking for a tool that replaces specific values from an existing shapefile field, these specific values need to come from a separated CSV or Excel table. For example, my shapefile has the field &...
  • 41
1 vote
1 answer
103 views

(Geo)DataFrame left join leads to NaN in all right values

Let these two CSV files on the disk: $ cat /path/to/gdf0.csv myid,geometry 332,"MULTIPOLYGON Z (((0 0 0, 0 0 1, 0 1 1, 0 0 0)))" 220,"MULTIPOLYGON Z (((1 1 1, 1 1 2, 1 2 2, 1 1 1)))&...
  • 9,111
0 votes
1 answer
47 views

Permanent Join Raster ArcGIS Pro

I combined two raster datasets. Which results in a dataset with non-descriptive information. I then joined a text file to the combined raster dataset. I want to make this join permanent. I've tried ...
6 votes
3 answers
158 views

Is it possible to join the same table twice in QGIS?

Basically, I have the layers above: As shown in the image, I'm trying to join the layer lines with the layer points two times in a row so the labels of origin_id and extremity_id appear in the ...
  • 604
1 vote
2 answers
43 views

Finding a reason why table join fails

I try to follow the 'visualize temporal data' tutorial step by step, but the table result doesn't match. The chinesetourism_transposed data store a float type yearly data from 1997-2017, and the ...
  • 11
2 votes
1 answer
90 views

Applying cross join or cartesian product (database table join) for GeoDataFrames using GeoPandas [closed]

I have a set of points and I want to calculate the distance from each point to all other points in GeoDataFrame. This is my GeoDataFrame: id Longitude Latitude geometry 0 1 -71.275580 ...
  • 599
3 votes
1 answer
78 views

Not all rows join successfully in QGIS

I have a shapefile of census tracts and a CSV file with information I want to join to them. The CSV I am using has 65 rows, each for a unique census tract. I am using the census tract ID number as the ...
0 votes
1 answer
24 views

Descending list of polygons based on how many points they contain [closed]

I have a polygon and a point table and want to put the polygons in descending order based on how many points they contain, in other words find the polygons containing most points I tried experimenting ...
  • 1
5 votes
2 answers
110 views

Summing values of different layers based on another

I have a layer (called here 'layer_top') made of multiple polygons (in orange in the picture). Each polygon of the 'layer_top' overlaps with polygons of other different layers (called here 1,2,3,...). ...
  • 425
1 vote
1 answer
49 views

Creating a spatial join for longitude/latitude data to areas on a base map

I have three different sets of data: The basemap (local authority wards), crime (recorded through longitude and latitude), population (recorded by local authority ward). I have already mapped the ...
  • 19
0 votes
0 answers
116 views

How to create 'select by attributes' feature layer when greyed out? File is a feature class (not a feature layer) and I cannot convert it

I have a subset of attributes selected from a query in 'Select by Attributes' in the Attribute Table. I want to export these selected attributes into a new layer, and am unable to do so in ArcGIS Pro (...
0 votes
0 answers
27 views

Show duplicates from two different tables using ArcGIS Pro

In ArcGIS Pro, I have a shapefile of parcel boundaries mapped out. I also have a list of new applications for these parcels in Excel. I want to be able to compare the excel list with the shapefile ...
  • 1
1 vote
1 answer
46 views

How to Get Join Count using Add Join

ArcGIS Pro 3.0.2 When I do a spatial join one-to-many between polygon and point, I get nice count field that shows how many points landed in my polygon. Is it possible to replicate this using the Add ...
  • 285
1 vote
0 answers
109 views

Auto-populate a field based on information in two different fields

I am attempting to auto-populate a field using matching information in two different fields in ArcGIS Pro. The field that I am trying to populate is "Unique_ID." Table #1 includes three ...
1 vote
2 answers
88 views

Sample Regions - excludes points with masked bands. Google Earth Engine

I have a set of points from around the world and I want to extract the pixel values from a set of images, giving information about the local environment, for each point. Then export the set of values ...
  • 147
0 votes
0 answers
11 views

Join a layer and a table to get a new layer 1-M

I need to join (1-M) a feature dataset (points) located in AGOL with a table (locally stored in a GDB) to get another feature dataset with as many elements as the table. I' working with ArcGIS Pro 3. ...
1 vote
1 answer
109 views

Filter Query Layer with Field from a Table in a Geodatabase

ArcGIS Pro 3.0.2 Is it possible to use the column of table in my Project to filter a query using the make query layer tool? I have a table of events in my project with a location_id column, and I want ...
  • 285
3 votes
2 answers
70 views

Giving specific naming of points within quadrant in QGIS

In QGIS 3.18.1 I am doing sampling to estimate deer densities. I would like to know which tool I can use to specifically name points within quadrants. There are four points in a quadrant, each point ...
2 votes
2 answers
84 views

QGIS 3.22.11: How can I attach different species to one polygon in a polygon layer

I have a polygon-layer with several polygons, and I have an excel-table with many detected species in some of these polygons. I want to attach all the species that belong to polygon 1 to polygon 1, ...
  • 421
0 votes
1 answer
110 views

Join FeatureCollection based on multiple Feature properties using Google Earth Engine

I have 2 timeseries FeatureCollection collected from Landsat looks similar to the following tables. 1st FeatureCollection (fc1): ID Date prop_1 prop_2 1 2022/10/01 missing in fc2 0.1 0.15 1 2022/10/...
0 votes
1 answer
105 views

"Keep All Records" not keeping all records

Did ArcMap lose some functionality recently? I am trying to join two tables to find which records don't have a match in the other. "Keep All Records" is selected in the join but it does not ...
  • 374
1 vote
0 answers
107 views

Joining Access tables to ArcGIS layers

I'm attempting to Join an Access query/table from an .accdb to a layer in ArcGIS Pro 3.0. I've made an OLE DB connection to the Access database, and made a query to get the table in access able to be ...
3 votes
3 answers
197 views

Joining attributes by location where percentage of polygon feature is more within a polygon in QGIS

I am trying to join the attributes of bigger polygon layer to smaller polygon layer as seen below. The location geometric predicate I used in WITHIN, so that all smaller polygons within lager polygon ...
1 vote
1 answer
38 views

Automatic updating of column

Have come across a problem in Qgis (3.16.9) I have a geometry layer (A) with lines and a csv file (B) with prices. I have a joint so the price from the csv file (B) comes over in the geometry file (A)....
3 votes
0 answers
52 views

Copy/paste the JOIN settings in the layer properties from a layer to another like you do with styles using QGIS

I have a project with many layers that have the same columns, I need to copy paste a join with a table to each of those layers, but the copy/paste style with "JOIN" settings doesn't work. Is ...
1 vote
0 answers
88 views

NULL values after joining a CSV file to a shapefile layer on ArcGIS Pro

I am trying to join a CSV file to a shapefile layer (points) and after the joining all column values are NULL I checked the joining field to be in the exact same type Here is my data: The shapefile ...
  • 29
0 votes
1 answer
35 views

Joining fields from two datasets and appending from one to other in ArcMap

I am looking to be able to append a field titled "premise ID" from one data set (from billing department) to the data set used in ArcMap. The data set provided from billing is taken and ...
1 vote
0 answers
41 views

How to set order of layers when pushing "Save for All layers" in QGIS

I have two layers in PostGIS that are joined together. To make it simple, imagine layer tree and layer city. (See the ER diagram below). Layer city is the 1 side and layer tree is the n side. (It is a ...
  • 63
0 votes
0 answers
47 views

ArcGIS Pro calculations combining joined and zonal statistics tables

I have calculated the area of intersect/sum of intersect of rasters using zonal statistics by using province ID as a zone field. I now want to divide that summed data for each province, by the total ...
  • 1
0 votes
1 answer
76 views

How to implement fuzzy join on ArcGIS Pro?

I need to join a table to a shapefile based on the names of the items. Problem is, the items are regional names translated in English from Chinese and sometimes the names don't match (e.g. a 'sh' in ...
2 votes
1 answer
390 views

QGIS How can I transfer atributes from one layer to another when those layers do not share the same number of features?

I am trying to add the most populated towns within a number of regions as an attribute to those regions. IE, I want a column on the polygon sheet listing the most populated town in that polygon. I ...
1 vote
0 answers
21 views

Extracting names of POIs from multiple point feature to polygon

I have many point features and polygons, The point file contains names of the POIs, what I want to do is, through spatial join I want to extract the names from the point file to the polygon, the only ...
0 votes
1 answer
51 views

How to aggregate data from different sources in QGIS into one table

This is a very basic beginner question and i need just a direction what keywords to look for. I have GPS waypoint data from my GPS tracker. Just Long + Lat + Id. And i have infos from a wfs server as ...
  • 173
0 votes
0 answers
19 views

Joined CSV table to feature class had NULL values that should not have been there

This is bothering me. I had a feature class who's join field was "double" and the field in the CSV table was also "double". Essentially the same data type. I had about 2/3rd of ...
  • 1
0 votes
1 answer
52 views

Select polygons that contain attribute listed in a separate table

I am using ArcGIS Pro and am trying to select a number of polygons based on a list of postcodes from a standalone table. I am using the Code-Point Polygon Dataset for the entirety of England, and I am ...
  • 1
1 vote
0 answers
86 views

Attribute Join Works One Way but not the Reverse

I have a census blockgroup shapefile of my local tri-county area with the original fields and a numeric version of the Geographic ID field (data type is double), and I have a census blockgroup data/...
  • 315
1 vote
0 answers
86 views

Fields with both numbers and letters don't join in QGIS [closed]

I have a bizarre problem with QGIS. I'm trying to join a .csv file with a shapefile, and the join field is a precinct code. Some precinct codes in my .csv are purely numbers, but some have a letter ...
1 vote
0 answers
61 views

Using joinattributesbylocation in PyQGIS

I want to join the attributes of two layers but only want to keep the objects of my input layer. So I came across the function "joinattributesbylocation" and tried to add it in my script ...
  • 87

1
2 3 4 5
20