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
2answers
20 views
Joining selected fields from table to shapefile using ArcGIS Pro?
I have a line shapefile with 100+ fields and a separate dbf file with 100+ fields. I'd like to programatically (using arcpy and Python 3) eliminate all but 3 fields in both shapefile and the dbf, and ...
1
vote
1answer
26 views
Applying same symbology to different DEMs?
I am using ArcScene and ran into this problem where I downloaded a couple of neighboring/bordering DEMs(in BIL format), imported them into the scene (as separate entities) and applied Base Heights so ...
2
votes
2answers
49 views
Understanding arcpy.CalculateField_management with Join?
I am using arcpy.CalculateField_management to fill a column field with another column values.
I have two shapefiles, fishnet.shp and new_run.shp. First I joined both using arcpy.AddJoin_management as ...
1
vote
0answers
28 views
QGIS: Copy all attributes of polyline layer when converting it to point layer
I want to add attributes from a polyline layer to a vector point layer.
The polyline is railway network. It has been divided into segments automatically, where as the attributes apply for each ...
0
votes
0answers
15 views
Joining xls file with shapefile attribute through ModelBuilder?
I have folder contains xls files and I need to make join for each file with a shapefile attribute using ModelBuilder.
My trial is as follows:
and obtained "Precondition" option only.
How can I ...
2
votes
1answer
43 views
Creating Virtual Layer as a UNION of two LEFT JOINs in QGIS
In QGIS 2.18 I have two layers, e.g. "Locations" and "Connections"
"Locations" has values
Id | Dimension
---------------
1 | 4
2 | 8
3 | 2
"Connections" maintains attributes
Origin ...
2
votes
0answers
64 views
Join attributes by value in QGIS 3.4.3 Processing Modeler
I want to add only a few specific columns from the join table but there is no drop down list. When selecting manually I'm able to select only 1 column when trying more than 1 I'm not getting the ...
1
vote
0answers
50 views
Updating set of attributes on vector layer from .csv table?
I have over 1,000 records in a .shp file, all with a unique ID field (LINKID), along with many other fields containing data (TXTFLD1, TXTFLD2, INTFLD1, INTFLD2, etc).
These records have been copied ...
0
votes
0answers
36 views
How to merge / join line segments by attribute and split at intersection
I have a complex network of line features with a lot of attributes (and unique IDs). Many features have the exact same values (exept the ID). I need to join all features with the same attribute which ...
0
votes
1answer
30 views
left join returning one more row than expected
I have a table of single polygons (table rast_poly) derived from a raster and a table of polygons that represents buffered points (table pt_buff). The raster polygon geometry has been reduced by using ...
1
vote
1answer
51 views
PostgreSQL PostGIS: Spatial join but keep all features that don't intersect
Spatial joining a point table to a polygon table, creating a new output table. So far I can only get the output table to contain features that satisfy the spatial join. However, I want the output to ...
1
vote
0answers
19 views
QGIS 2.12 How can I assign the attributes of the polygons of the layer A containing the geometry of layer B?
In other words, I have two shapefiles:
Layer A: not-intersected Areas (1 attribute: ID);
Layer B: Buildings (Several attributes).
I want to identified by the related ID attribute all the buildings ...
0
votes
0answers
12 views
Attribute table QGIS [duplicate]
I have a attribute table with different columns. I have to add one more column and then copy paste the values from a different column, but both columns are in the same table attribute.
How can I do ...
1
vote
0answers
39 views
QGIS Join is returning Null values
I am trying to join this data to this data (UTM32 Ebenen file = VG250_GEM.shp) using columns Column2 and SDV_RS, respectively. I am using QGIS 3.4
I am following the instructions found here . ...
1
vote
2answers
46 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')
...
1
vote
0answers
48 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
43 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
64 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 ...
3
votes
1answer
99 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
23 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
47 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 ...
0
votes
1answer
18 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
35 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
75 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
0answers
13 views
Joining Daily Temperature Data to Another Table
I am using ArcGIS Desktop.
We are looking at the movements of organisms daily as a result of temperature changes. We have a layer that displays surface temperature values daily for several years. We ...
0
votes
1answer
52 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
27 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
63 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
52 views
QGIS 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
147 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
28 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
39 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
49 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
27 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
48 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
56 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
48 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
46 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
110 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
62 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
23 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
38 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
124 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
141 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
60 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
51 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
23 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
24 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
98 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" ...
