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
2
votes
1answer
19 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
30 views

Joining csv with shapefile using Python [on hold]

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

When I run the Join function on two vector layers the distance field keeps returning “-1”

When joining two point layers by geographic location with the "Each point will be given attribute" selection, I keep getting a NEARDIST of -1.
6
votes
2answers
8k views

Join / merge lines that touch and intersect in QGIS

I have a large dataset consisting of lines/polylines where I would like to join/merge the lines that touch / intersect. Each line has an individual ID and there are no common attributes I can use for ...
12
votes
4answers
9k views

Join attributes of point and line layer by location (closest distance) in QGIS

My problem is the following: i have a line shp (target layer) and a point shp (join layer). the second one (point layer) holds an attribute which i want to join with a line layer based on closest ...
0
votes
3answers
120 views

Filtering attributes in a shapefile using a common ID from an Excel file

I am using QGIS 2.18.11 and I have a shape layer with lines and polylines I need to review; but not all of them, only certain ones. The ones I need to review are marked in a specific field (rev = 0 or ...
1
vote
2answers
49 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 - ...
0
votes
1answer
22 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
1answer
170 views

Arcpy: Delete rows from joined table

I would like to delete all rows which are joined to a layer from a csv table. Only the joined records which match (keep only matching records) should be deleted. After the records are deleted, the ...
4
votes
1answer
3k views

Using many-to-many join in ArcMap

I'm working in ArcMap 10 and can move around in R, though am not an expert. I have a shp file and an xlsx file. The shp file is 20,221 rows and includes a field GID (grid ID) which is not unique ...
3
votes
1answer
248 views

Join .csv file and .shp of georeferenced points

I have georeferenced a map and saved a selection of some points on the map. These points are cities of departure and arrival and I want to join the .shp with a and excel .csv with the information of ...
3
votes
1answer
112 views

Issue with “Join attributes by field value” on QGIS 3.4.7

I have a shape file with polygons and a xlsx sheet, and I need to join their tables using Join attributes by field value in the modeler. At QGIS 2.18 it works perfectly, but in 3.4.7 the join doesn't ...
1
vote
1answer
103 views

Table join to KML file

I want to add a classification to photos which are in an excel spreadsheet within a KML file. Need a way to combine/join fields that are in an Excel spreadsheet to a KML file.
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 ...
11
votes
5answers
6k views

After joining shapefile with CSV file graduated symbols option unavailable in QGIS?

I have successfully joined data from a csv file to a shapefile in QGIS but for some reason I am having trouble symbolizing my data. I want to use a graduated symbology however this option is not ...
1
vote
1answer
75 views

Change attribute of a line according to overlapping polygon features

I'm pretty new to QGIS and python in general. For my work I'm faced with a bit of a problem. I got 100-m-segments of several streams and polygon-features of the surrounding substrate. The polygon ...
1
vote
1answer
47 views

Adding points when joining two datasets together in ArcGIS Desktop

I am trying to join an excel file with a shapefile based on a zipcode. My problem is that I have multiple persons with the same zip code, but it joins only 1 of those persons. Is it possible to ...
2
votes
2answers
128 views

Adding field in vector layer from attribute table in QGIS? [duplicate]

I have an Attribute Table named 'data.shp' and a Vector Layer 'pop.shp'. The 'data.shp' has the following fields "ID", "value1", "value2" The 'pop.shp' has the "ID" field (same with the 'data.shp') ...
3
votes
2answers
151 views

Joining by 'almost' identical attributes using QGIS?

So I have two point shapefiles - their attribute table consist of names, lat, lon, and others. I would like to join the attributes of shapefile 1 to shapefile 2. A normal join between the names would ...
2
votes
2answers
377 views

Joining CSV to KML/GeoJSON in Leaflet webmap and showing joined data in popups?

I'm trying to create a Leaflet/Mapbox webmap with line layer (GeoJSON or KML) with some IDs and data coming from the .csv (after joining through this ID) file located on the same path as the index....
0
votes
1answer
26 views

Using Spatial Join to join geologic features to polylines

I want to spatially join polygons (geologic features, major aquifers) to where the NHD polylines (rivers/streams) fall. I want to be able to click on a polyline and see what geologic feature or major ...
0
votes
0answers
21 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 ...
0
votes
1answer
24 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
49 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 ...
1
vote
0answers
52 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 ...
3
votes
2answers
135 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 ...
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
41 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 ...
0
votes
1answer
483 views

Adding and filling GEOMETRY column in new spatialite

I have three tables. One has no geometry. The second is POINT type, and shows up correctly on the map. The third is, for the moment, a simple checker table, don't worry about it. I am able to perform ...
1
vote
0answers
41 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
77 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
140 views

Automatically Generate Attribute Table in Qgis

I am working with historical parcel data in Qgis and have the following fields in my attribute table, (name, grantee date, grantor date, parcel ID, acreage, previous owner). Unfortunately, I have ...
0
votes
1answer
87 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, ...
2
votes
1answer
65 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 ...
1
vote
2answers
76 views

Joining Attributes from Layer Limitation in QGIS 3.2?

I want to join two txt-tables as a layer in QGIS 3.2. In earlier versions (QGIS 2.12) works to join one of the tables more times to the other table. Now in version 3.2, I can join only one time. The ...
2
votes
0answers
18 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
37 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 ...
3
votes
2answers
68 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 ...
1
vote
0answers
26 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 ...
2
votes
2answers
220 views

Joining two tables on ArcMap together that are different types (String-Double)?

I am trying to figure out Population percentage change based off census tract data from 2010 and 2014 data. One of my tables I pulled from the U.S. Census Bureau (2010 data); this table came with the ...
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 ...
0
votes
1answer
85 views

How do I get Table from Vector layers for use with joinattributestable

I am attempting to run: processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None) To join my tables and output to a temporary viewing layer. layer1 and layer2 are both ...
1
vote
1answer
69 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', '...
2
votes
2answers
8k views

Fastest way to Join tables in python automation

My issue comes form the fact that doing Joins manually is actually relatively quick (5mins), but python automation of this process is 6hrs! Here is my code: import arcpy GDB_MARK_TO_MARK_VECTOR_VIEW ...
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
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 ...