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
1
vote
0answers
72 views

QGIS: Add attribute from polyline layer to point layer [closed]

I want to add an attribute from a vector line layer to a vector point layer. The vectorline is railwaynetwork. It has been divided into segments automatically. To process the data further I had to ...
2
votes
2answers
49 views

Selecting features of a shapefile using attributes of another shapefile

A newbie here trying to learn QGIS for work. How can I select specific features of a polyline with the same values as the attributes of the buffer polygons I generated? I have a layer of polylines ...
2
votes
1answer
172 views

Join attributes by location gives out wrong sum

I have an input vector polygon layer which has different areas. Now I want to join a different vector polygon layer which contains over 1 million 100x100 meter squares with information about the ...
5
votes
2answers
286 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 ...
1
vote
0answers
50 views

Refresh layer with joined tables from watched files

I have a shapefile joined to data from a CSV file that is being watched by QGIS. If the CSV file is updated, the attributes in the CSV layer are updated as expected, but the data in the joined ...
1
vote
0answers
179 views

Large increase in .dbf file size after attribute table join

I have a polygon shapefile of about 12,000 features that I joined a CSV attribute table to using 'Join attributes by field value' in QGIS 3.2.1 The .dbf file size before the join = 5.6 MB The .dbf ...
1
vote
1answer
268 views

Invalid Primary Key error message when attempting to join table view and feature layer

I am attempting to join a feature layer to a table view in order to export a table of all non-joining features in the table view by selecting NULLS from the join field related to the feature layer. ...
0
votes
1answer
68 views

Join linestrings in shapefile of watercourses that have same NAME and PERENNIALITY

I have a shapefile (link below) of only watercourses comprised of many short linestrings. OpenJUMP displays this about each segment LINESTRING ( 153.05422 -26.44881350000003, 153.05448 -26....
1
vote
1answer
196 views

Python QGIS 2.18 to QGIS 3 : Shp file attribute joins and how do i specify the join fields?

My question is in two parts : 1) How do I modify my pre-existing QGIS 2.18 script to work in QGIS 3? (i'm still learning Python) 2) How do I modify it to join only specific fields (i.e. i dont want ...
0
votes
1answer
368 views

Find the closest Point from a Point which contains the same attribute

I am trying to create python code to iterate through points on 1 layer and find the closest point on another layer (Road Chainages) based on attribute values. I need to limit the search to < 20m ...
2
votes
0answers
76 views

How do Joins & Relates in layer file and Layer Properties work?

I'm using ArcMap 10.5. I set up symbology for a feature class based on joined attributes from a table in the same file geodatabase. I want to be able to apply the same set-up in different geodatabases ...
3
votes
2answers
84 views

Refering to (Joined) Field Names in arcpy in Field Calculator

I'm trying to update the locations of a point FeatureClass using a table. I have joined the table to the featureclass, and am attempting to use Field Calculator to update the SHAPE field. I found ...
1
vote
2answers
124 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 ...
4
votes
3answers
299 views

QGIS Joined Layer not displaying points visible on pre-join layer (No Extent)

I have a shp file which is the output of the Toolbox Check validity tool in QGIS 3.4.3 The points display for me correctly but if I then join the layer with a csv attribute using the toolbox Join ...
1
vote
0answers
38 views

How can I make integers on a join SHP file stay as INT and not as qlonglong?

So I've been trying to join a CSV file with a polygon SHP file and everytime I try to save the joint SHP into a new file it transforms the type from int to qlonglong and prevents me from using some ...
1
vote
1answer
63 views

Create new vector of polygons that are within 500m of a point in vector of points P

If I have a vector of polygons A (say 200) and want to create a new vector (say 120) of the original 200 polygons that are with 500m of a vector of points P (say 50), this is the method I do. I want ...
1
vote
1answer
60 views

Failure with Excel join QGIS

I'm trying to join an excel spreadsheet with one of my layers. I've formatted the spreadsheet to fit QGIS, with basicaly one string and a few integers. I've saved my spreadsheet in a .csv fromat, and ...
1
vote
0answers
95 views

Extracting attributes from one layer into another layer's different features using ArcGIS Desktop? [closed]

I am trying to work out how to do something in ArcGIS Desktop 10.6 and just can't find a way. I have a land use map of an area as seen in the first picture. I have this layer in both polygon and ...
0
votes
1answer
99 views

Joining attribute by location failing to join all attributes

I have a polygon representing an urban area. I have point data representing the cities which fall in this urban area. I'm trying to combine both polygon and points using a "join attributes by location"...
1
vote
1answer
144 views

Join attributes by location - false information

I've been working on an analysis involving animal vehicle collisions. The data has been passed to r-stats and I keep noticing peculiar things in the cross referencing of the data. I've created highway ...
1
vote
0answers
82 views

How can I restrict the relation so the tables just join when is a relationship?

I made a relations (1:n) between 2 tables. Not every element from fathers layer have connection with elements from child layer. The connection is made between 'Tipo de Estrutura' Field and 'Est' Field ...
2
votes
1answer
497 views

Merge CSV file with Shapefile in QGIS

I have CSV file with have ID which is repeating, something like: ID other values.. 1 njhb 1 njhb 2 njhb 2 njhb 1 njhb Anyway, I have in shapefile that ID which is ...
1
vote
1answer
245 views

Joining Two Fields of Differing Cases in QGIS

I am attempting to conduct table joins using a common ID field in QGIS. The issue it that the ID field in one table contains letters in the upper case and the other contains them in the lower case. ...
0
votes
0answers
25 views

Finding number of points within each respective polygon in table [duplicate]

I have: a shapefile of circles at 15 meters radius and point data with GPS coordinates. How can I count the number of points within each circle and have a raw number that can show such? I've tried ...
1
vote
0answers
51 views

Joining a row of data to multiple polygons (zip codes)

I received some data from a partner and was trying to do a visualization. I'm using ArcGIS / ArcMap 10.2 I have a table where each row (first column is the ID) represents a facility and all the US ...
2
votes
1answer
320 views

QGIS/QField - Joining updated and new features to original shapefile

I am currently working in QGIS 2.18 with Qfield to collect address information. I currently have a list of addresses (.csv) that were given as part of the project which contains a variety of ...
0
votes
2answers
3k views

Left join using merge in geopandas

Is there a way to do a "left join" when using the "merge" command on a geopandas df to merge by attribute? The problem I am running into is that I am joining a geopandas df with CA counites to a ...
0
votes
3answers
252 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
0answers
62 views

Joining CSV data with a polygon Layer

I have a CSV file with 800 rows and 20 columns that I would like to join with a shapefile (polygon) that has only 10 rows and 1 column (Id). How should I go about this?
1
vote
1answer
27 views

Finding many intersecting polygons of one layer and listing them in single field using ArcGIS Desktop?

I have a polygon layer of a grid of USGS Quads Index clipped to the Southwestern US (https://catalog.data.gov/dataset/united-states-7-5-usgs-quad-index). I also have a polygon layer of county ...
2
votes
1answer
257 views

Joining CSV file to Shp file using ogr2ogr and python?

I am having problems with the code below i.e. parsing the SQL string in python. I keep getting an error. I am joining a CSV file called lookup_scales.csv to a shp file called RC_CATALOGUE_GRANTED. I ...
1
vote
1answer
24 views

calculating share of layer refer to another layer

I have two vector layers (1) with 107 subdistricts (2) soil map with classification of the soil value. I like to calculate the share of the area of the soil map with values classified as "very_high" ...
2
votes
3answers
56 views

Can I join a CSV field to one of any matching values in a single cell within a shapefile?

I'm working with the Global Administrative Boundaries shapefile, and am have a CSV of values I'd like to join to it. My issue, however, is that there are multiple ways to spell the region names. ...
3
votes
1answer
50 views

Calculate the sum of the areas of polygons within bigger polygons from another layer _ QGIS

I would like to add in the attributes of each of my roof boundaries (red polygons, which sometimes overlap) the sum of the surfaces of the (green) surfaces. I have already tried "join attributes ...
2
votes
1answer
1k views

Join attributes of polygons to another polygon feature based on location QGIS

I have two large polygon data-sets. One highlights the building footprints for a county and the other highlights the parcel boundaries for the same county. Some parcel polygon features have multiple ...
2
votes
1answer
158 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.
0
votes
1answer
47 views

Join by attribute KeyError

I'm trying to join a shp and a CSV, by joinbyattibutes, by the Column "KOMNAVN" in QGIS 2.18. However, I get this log message error and I can't figure out what I'm doing wrong.
1
vote
0answers
189 views

Uneditable fields in attribute table

I have data in a .csv sheet that I imported as a vector layer into QGIS. I then joined the imported table with an existing .shp file. The fields that I joined into the .shp file are not editable (they ...
3
votes
1answer
869 views

Join Pandas Dataframe to Shapefile?

I have a shapefile: Street1 Street2 Street3 Field Clark Taylor Field Jackson State Franklin 23rd 25th And a Dataframe df: Page Entry_Date 12 08012018 17 ...
2
votes
0answers
91 views

What characters are not acceptable in an ArcGIS text field (File Geodatabase)?

Trying to join a table to my feature and it keeps leaving out a field. The field is a legal description of a property, it has all sorts of funky characters: : ; / \ () ' " and more The field is ...
1
vote
1answer
86 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
494 views

Export shapefile with column name of csv file or change column names afterwards

I am joining a .csv file with a shapefile in QGIS 2.18.12 and I need the column names for further processing (but they are way longer than 10 digits). However, when I save the new file, the column ...
0
votes
0answers
43 views

Putting raster values in polygons ArcGIS

I'm trying to extract values from a raster file dataset (called land_use) to polygons (in a file called Hydro_buff) that I have created. I read a few questions on that topic but some other issues come ...
0
votes
1answer
296 views

Exporting multiple feature classes with joined fields using ArcPy?

I have multiple FGBs (10) with many feature classes (about 30). Most of the feature classes are joined to a table which is specific to each feature class (i.e. 30 feature classes to 30 tables). I ...
1
vote
2answers
72 views

Linking Excel Sheet to Point Data reference table using ArcMap?

I am trying to join an excel spreadsheet to the attribute table of project locations in ArcMap. The excel CSV file is in my layers and I can open and view it as an attribute table. However, it is ...
2
votes
1answer
409 views

QGIS 3 - Python : QgsVectorLayerJoinInfo issue

I'm trying to use Python to join a table to a vector layer within QGIS (v. 3.2.0) Here is the script I use : >>>root = QgsProject.instance().layerTreeRoot() >>>ids = root....
2
votes
1answer
103 views

Auto snap of point features with lines

I want to snap my point feature with Line features. So That I can perform join attribute by location to read attributed from points into lines. Is there any way I can do this task automated. Once ...
0
votes
1answer
215 views

arcpy Add Join with “KEEP_ALL” Does not Keep All

Using arcpy for ArcGIS 10.5.1, I'm joining a feature layer to a table using arcpy.AddJoin_management() with the KEEP_ALL option in order to keep all features whether they have a related record in the ...
1
vote
1answer
151 views

How can I keep my GEOID a 12 character string when adding csv layer in QGIS?

I am trying to join my csv data to TIGER census block group shapefiles. Every time I bring the table into QGIS it changes the string for the GEOID into a number so the join comes up null. My csv only ...
0
votes
1answer
120 views

Aggregate and split layer by location into multiple layer in ArcMap? [duplicate]

I'm pretty new to GIS, but hope I'm moving in the right direction. I have a layer of the county map of LA, which is divided into communities and a layer of the building coverage of the county. The ...

1 2 3
4
5
16