Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
1answer
85 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
86 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
59 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 ...
0
votes
0answers
83 views

Python - Merge shapefile polygons based on criteria

I have a shapefile with thousands of polygons and would like to merge (join) adjacent polygons based on a threshold between attributes. I need to use python because I'm not allowed to use ArcGIS. e.g....
2
votes
1answer
240 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
127 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
24 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
43 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
196 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
1answer
1k 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
121 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
57 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
0answers
31 views

QGIS 3.2 crashing on joins

I'm using a few joins on a complex project. Lately, adding a further join has caused a crash (or hang) and the project also crashes on exit (although it saves fine). When I put the two files I want ...
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 ...
1
vote
1answer
178 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
55 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
44 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 by ...
2
votes
1answer
798 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 ...
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.
0
votes
1answer
41 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
105 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 ...
2
votes
1answer
512 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
53 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
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
260 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
42 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
154 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
53 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
326 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
85 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
147 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
108 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
53 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 ...
0
votes
1answer
1k views

Saving dataframe as dbf with simpledbf in Python?

I am doing a number of joins outside of ArcGIS as pandas seems to outperform it. I read in the dbf file with simpledbf, convert it to a dataframe, then do the join: import pandas as pd from simpledbf ...
1
vote
1answer
35 views

Combining attributes from multiple point shapefiles using PyQGIS?

I have seven point shapefiles with the same points (number and location) but different attributes. I would like to collapse all the attributes to a single point shapefile. I know that if I had only ...
2
votes
2answers
380 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
30 views

Disappearing header

I am trying to perform a join on a zip code .shp and a table that contains the same GEOID10 zip code column along with some diagnosis counts by month/year. The fields for all the dx mo/yr columns ...
1
vote
1answer
736 views

Attribute table of shapefile completely blank and empty after a join - ArcMap - how to recover it?

I'm using ArcMap 10.6. I have a shapefile of geo-political borders from Natural Earth. Both the shapefile and its attribute table are in working order. But after I join a csv to the shapefile, the ...
-2
votes
1answer
76 views

NNJoin aborted with error “worker: no geometry”

I have a series of points in a csv file, with lattitude, longitude in WGS84, and I want to know to which country they belong. These points are on the shore, not inside a country, that's why I'm using ...
0
votes
0answers
94 views

Joining Excel file with shapefile

I am using QGIS version 2.18.19. I have created a shapefile using a script and its attribute table is empty as shown in below image. I am adding an Excel file. It includes a table as the input to the ...
2
votes
1answer
55 views

GDAL/OGR Error: Cyclic VRT opening detected

GDAL 2.2.4 (64bit Windows) throws an error during opening of a cyclic OGRVRT file. There was no problem with cyclic VRTs in GDAL 1.10.1 (32bit Windows). Here is a sample VRT file, which I used to ...
2
votes
1answer
702 views

How to join tables to create a new shapefile in ArcMap?

I'm unsure how to join a table and reference shapefile in order to create a new shapefile. I'm using ArcMap. I made a simplified version example below. I have a shapefile of points (locations where ...
3
votes
1answer
96 views

Mass updating of joins in ArcGIS Desktop?

I have an MXD used to join many feature classes to the same table. This table has moved to a different workspace and so I need to update all the Joins to point to the new workspace. I don't see any ...
2
votes
1answer
126 views

Table Join only returns first record from CSV table in QGIS 3.0.3

I have a .csv file that contains instances of hospitalization with diagnosis codes and zip codes and I want to join it to the corresponding polygons in the TIGER 2017 zcta510 shapefile. Every time I ...
1
vote
1answer
195 views

Join.Field_management extremely slow in arcpy stand-alone script

I have an arcpy script that joins two tables together based on the FID field. This slows down my script considerably. The joining process takes several tens of minutes. import arcpy import os from ...
3
votes
1answer
245 views

Joining a shapefile attribute table to a CSV file pyqgis3.0

I would like to join a shapefile to a CSV file in PyQGIS 3.0. So, when I run the following code, it executes without errors but the join action does not succeed. What is wrong with the following code? ...
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 ...
2
votes
2answers
106 views

Copy Features consistently failing in ArcGIS ModelBuilder?

I'm running a model to convert .txt files to a table, then join that table with a parcels shapefile, and finally export out that join as a new shapefile. However, the copy Feature's tool is ...
-1
votes
1answer
106 views

Add Join not working in ArcGIS ModelBuilder? [closed]

I'm trying to built a really simple model in ArcGIS 10.6 but it won't work. I want to merge two shapefiles and then join the output-file with a .csv table. The merging works fine but the model ...