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.
0
votes
0answers
25 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
1answer
32 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 ...
0
votes
1answer
32 views
GQGIS 3.2 Join Attributes from Layer Limitation?
I want to join two txt tables as a layer in QGis 3.2. In eralier versions (2.12) works to join one of the tabel more times to the other table. Now in the version 3.2 i can join only one time. The ...
4
votes
2answers
130 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
24 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
35 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
41 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
24 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
35 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
votes
1answer
45 views
Join attributes by location is not showing the desire result [closed]
I have one point file and one line file and I performed join attributes by location. I am finding point layer columns are getting created in Line file but fields are showing NULL value. Where I am ...
1
vote
1answer
54 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
40 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
23 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....
1
vote
1answer
72 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
36 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
22 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
35 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
91 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
41 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 ...
-1
votes
0answers
11 views
Joining multiple polygon attributes
Using QGIS I'm trying to assign PLSS quarter sections to a grid overlay. How can I join/intersect/union these two shapefiles in such a way that if one polygon overlays multiple quarter sections it ...
0
votes
3answers
50 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
50 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
18 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
22 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
51 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
22 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
43 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. ...
0
votes
0answers
19 views
Showing joined and related non-spatial tables in feature forms
I have a polygon layer that is joined via a 1-to-1 relationship with an Access table (table A), and the access table is related via a 1-to-many relationship to another Access table (table B). When ...
3
votes
1answer
39 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 ...
0
votes
0answers
97 views
Calculate percentage overlap of polygon features in two layers QGIS
I have two polygon layers (building footprints and parcel boundaries) for a county.
I want to join the parcel ID numbers to the attributes of the building footprint features based on location and ...
2
votes
1answer
210 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 ...
0
votes
1answer
29 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
29 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
43 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 ...
1
vote
1answer
132 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
36 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
59 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
113 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
12 views
Joining Block Groups with Municipalities layer
I am trying to preform a join between block groups and municipalities to give the Block Groups a "District". Ideally what I wanted to do was preform a join between the Place File and Block Group file. ...
0
votes
0answers
40 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
54 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 ...
0
votes
0answers
19 views
Join table with street address to line feature class based on street names
I need to join a table that has street addresses and dates to a line feature class that also has street names.
How do I join the date from MyTable to MyFeatureClass?
Notice: The street types are ...
1
vote
2answers
32 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
150 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
44 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
47 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
58 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
28 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
453 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
28 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 ...
