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
11 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
111 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
24 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
46 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
28 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
38 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
29 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
38 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
65 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
19 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
22 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 | ...
1
vote
1answer
83 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
44 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
63 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
16 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
20 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
35 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
24 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
66 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
24 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
45 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
38 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
32 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
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
64 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
114 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
27 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
46 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
19 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
28 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
91 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
25 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
33 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
132 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
34 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
27 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
40 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
66 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
19 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
48 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
147 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
62 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 ...