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.

136 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
108 views

Join CSV to shapefile failing when in saved map document in QGIS

I am trying to join a CSV file to a shapefile by matching on attributes. Here is the minimal workflow: Import shapefile in blank document. Save attributes of shapefile to CSV. 2.5 eventually, I ...
3
votes
0answers
2k views

QGIS “join attributes by location” fails

I am trying to join attributes from a vector polygon layer to a vector points layer wherever a point falls inside one of the polygons. I tried to use the QGIS 'join attributes by location" tool, ...
3
votes
0answers
53 views

Joined table fields don't work in print composer?

I am trying to use the attributes of the current atlas feature, which is from a joined table. In the expression builder it shows the correct value, but the result is blank when I actually try to ...
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
0answers
63 views

Adjacent DEM files have narrow triangular gaps when joined

Newbie here. I've downloaded several DEM files from GeoCommunity which correspond to adjacent regions. When I join them together to form a larger relief map there are triangular 'gaps' on all four ...
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.
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. ...
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 ...
2
votes
0answers
39 views

Pull information from one shapefile and add it to the attribute table of another?

I'm trying to create a shapefile for one particular area in Germany. I have various shapefiles which store all the information that I need. One of them is a 100m_Gitter_raster (a raster consisting of ...
2
votes
0answers
54 views

Testing for vector joins in PyQGIS 3

I'm writing a plugin in PyQGIS 3, and I've to test for vector joins before run a code, so I've found here about vectorJoin() and write this: def joinTables(self): d, f = self.lyrPair() # d = {...
2
votes
0answers
31 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 ...
2
votes
0answers
55 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 ...
2
votes
0answers
51 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 ...
2
votes
2answers
374 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....
2
votes
0answers
1k views

QGIS Error: Join attribute by location

I'm getting this error code with QGIS when I am using the tool Join attribute by location: I'm trying to join the attribute table of polygons into my vector points attribute table. Processing ...
2
votes
0answers
75 views

How to see joins (one-to-many) in the QGIS 2.18.14?

I made a join with two tables - one to many. territories and roads. Meaning, one territory have many roads. territories -> 98 territories/features roads -> 529 roads/features So, in the ...
2
votes
0answers
143 views

Joining data associated with geographic coordinate to region in shapefile containing those coordinates?

I have two shapefiles that I essentially need to join, but inconvenience in the boundaries in each shapefile, traditional join methods have proven to be quite difficult (often there are multiple ...
2
votes
0answers
160 views

Remove all joins from a layer using pyqgis

The title says it all. I want to remove all joins from a layer. After examining the QGIS API documentation and playing a bit with the QgsVectorLayer class I've figured out how to do it but my doubt ...
2
votes
0answers
50 views

CartoDB geom (coordinates) join: without exact match

Trying to join two datasets (layers) on CartoDB based on their geographical fields (in CartoDB's the_geom created field). However, the basic ST_Intersection function does not work since its tolerance ...
2
votes
0answers
427 views

Command line join attributes by location using OGR

I have two overlapping vector files (polygons and sample) and want to do a spatial join from the command line to extract all features in polygons that intersect with sample. Essentially I want to have ...
2
votes
0answers
327 views

Update Attribute based on spatial location

I want to spatially (Spatial Join) update few fields, not all, from another feature class. Is there any way to select and update few fields instead of all the fields from the other layer and ...
2
votes
0answers
616 views

Create a non spatial index on an attribute in QGIS before joining two layers

I’m trying to join a .dbf which contains no spatial data to a shapefile containing spatial data. Ideally I’d like to create an attribute index on the join field in the .dbf before I join it to the ...
2
votes
0answers
151 views

How to create a 1:n join and concatenate text attributes?

I have 2 polygon layers A and B. I would like to join the attributes from B into A for all the polygons from B that intersect A and for text attributes, i would like them concatenate. But apparently "...
2
votes
0answers
162 views

QGIS - How to avoid -2147483648 value from imported CSV?

I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but ...
2
votes
0answers
102 views

Joining two fields after calculating?

I have been working with two layers and I am trying to join them and turn them into a raster data. The first layer is a watershed layer which I have assigned each shed a location from the center point ...
2
votes
0answers
601 views

ArcObjects : How to change layers connection properties without losing joins

I'm using arcObjects 9.2.6 java librairies to change connection/path properties within a java prog. This prog aims to change path and connection properties for all layers of an mxd file. It works well ...
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 ...
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 ...
1
vote
0answers
40 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 ...
1
vote
1answer
48 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
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 ...
1
vote
0answers
55 views

Joining attributes by location/intersect works for all but one polygon in QGIS?

I used the Join attributes by location and Intersect tools in QGIS 3.4 for my points layer to add a column with name of the intersected area into the attribute table of points. It works perfectly for ...
1
vote
0answers
35 views

Joining .csv with duplicate values to .shp layer with points and getting all points visible using QGIS?

My problem with QGIS (version 3.4.8) I have a .shp map layer containing point data of buildings. I want to join .csv spreadsheet to this layer so I can look into it and visualize different variables ...
1
vote
0answers
21 views

QGIS - How to add joined values table data to shapefile

For some reason I lost my previous question here but I proceeded a little bit after upgrading to the newer version of QGIS. My problem was combining spreadsheet .csv data to the .shp map layer, where ...
1
vote
1answer
11 views

ArcMap: Combining County Polygons for 3 separate states into one layer with attributes

I have 3 separate layers with the counties for 3 separate states: WA, OR, & ID. I want to combine them into one layer "Counties" so they all share an attribute table with the same fields. I am ...
1
vote
1answer
67 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', '...
1
vote
0answers
22 views

Joining two vector layers with polygons and then selecting one via other in QGIS?

This could very well be a duplicate question, but i can't find the answer in the site. Using QGIS 3.4, I have two vector layers with polygons and same projections: one with all individual watersheds ...
1
vote
0answers
22 views

Using Join Field more than once in ArcGIS Pro ModelBuilder?

I have a model where I'm trying to aggregate the zonal sums of a set of ~30 rasters into attributes on a shapefile of country boundaries. Ideally my model would create a new field in the country ...
1
vote
0answers
98 views

Many-to-many join in QGIS

Just want to know if there is a tool to do a many-to-many join in QGIS. I have X number of polygons that I want to join with a CSV table which contains Y number of entries. Essentially I need to ...
1
vote
0answers
20 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 ...
1
vote
0answers
88 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
0answers
41 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
83 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
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 ...
1
vote
0answers
30 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
0answers
57 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 ...
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 ...
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
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.