We’re rewarding the question askers & reputations are being recalculated! Read more.

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
16 views

Using join based on date in ArcGIS Desktop [on hold]

I have a pipe layer (line) and a break history layer (point). The break layer only has the date of the break. Many pipes have multiple breaks. I need to add the date of the latest break with 15 feet ...
0
votes
0answers
17 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
12 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
92 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
12 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
40 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
21 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
43 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
37 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
23 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
56 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
18 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
177 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
53 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
30 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
42 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
43 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
87 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
34 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
91 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
55 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
67 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 ...
2
votes
0answers
19 views

Loading point features into Network Analyst without losing the point's attribute fields

I have points that represent schools (facilities) and points that represent homes (incidents). I need to do a closest facility analysis to calcualte how long the residents need to reach the schools. ...
0
votes
0answers
21 views

Keeping temporal data in separate tables using ArcGIS Pro?

I am trying to set up a temporal layer as outlined here (Note, I'm using ArcGIS Pro instead of ArcMap): http://desktop.arcgis.com/en/arcmap/10.3/map/time/temporal-data-in-separate-tables.htm My data ...
2
votes
1answer
40 views

Retrieving startpoint and endpoint (from/To list) of polyline layer from point layer using QGIS?

I am using QGIS 3.8 and I have a polyline layer with the attribute below And a point layer with the attribute below So I wonder if there is an expression to get the field 'Name' of the point layer ...
1
vote
0answers
27 views

Multiple attribute layers with same geometry in geopackage with ogr2ogr

I have multiple PostGIS tables I want to export to a single gpkg file. The tables have identical schema, and identical geometries -- the numerical attributes differ. How do I create a gpkg file, using ...
3
votes
2answers
73 views

Joining the attributes of two nearly congruent streetnetworks (lines) in QGIS

I have two streetnetwork layers containing both different attributes, none of them is similar so I can´t do a simple join. Unfortunately they are not congruent, but the line objects are close to each ...
2
votes
0answers
35 views

Join attributes to nearest without repeating feature

I have two layers, one of point and one of polygons, each with approximately 1000 features. I need to join the attributes of the points to the nearest polygons. The problem is that point attributes ...
1
vote
1answer
25 views

Joining feature classes defined in list to dbf tables which defined in another list using ArcPy?

I am trying to join feature classes in a list to tables in another list using a join field which is the same for all joins. In general terms, I want to join the first feature class in the list to the ...
1
vote
1answer
46 views

Information of two attribute tables together in one

I need the information of a layer with track points (X and Y coordinates) and the information of a polygon layer (area) together in one layer. The problem is that the two attribute tables have no ...
0
votes
0answers
20 views

Understanding properties clause in WFS 2.0 join query?

I can't completely understand wfs:PropertyName (the projection clause) syntax in XML encoded query. How can I get non-mandatory properties for the following request? For example, I need Grounds->...
1
vote
2answers
49 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
44 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 ...
2
votes
0answers
40 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
110 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
122 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
26 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
39 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
81 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
35 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
22 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
13 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
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
99 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. ...