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.
815
questions
0
votes
0answers
11 views
Joining attributes via webmap hyperlinks
I have a parcel dataset from Henrico County Virginia but it doesn't include parcel owner names, which would be incredibly helpful in the analysis I'm running. The county has an online parcel webmap ...
0
votes
0answers
29 views
Calculate multiple fields from joined fields
QGIS 3.14.
I just joined a table to my a layer with already multiple fields.
I want to replace the values in all the original fields with the values in the joined table.
I'm searching a way to ...
2
votes
1answer
26 views
Call an input layer in field calculator for another layer
My model start by asking two input layer LAYER1 and LAYER2.
Then, in field calculator for LAYER1, i want to join an attribute value from LAYER2. Using this code :
attribute( get_feature( 'LAYER2','ID1'...
1
vote
2answers
35 views
Layer Join and Styling Trouble because of Field Types
I am trying to join a .csv-file with als rates and zip3 values to a shapefile with zip3 values and then color the map based on the als rates.
This seems very simple and I have done similar maps before ...
3
votes
1answer
84 views
Merging touching lines in QGIS
I have a vector layer, in which structures (pipes under roads) are made up of multiple lines. I wish to spatially join all the lines that make up a single structure, but cannot figure out a way to do ...
1
vote
1answer
36 views
Why is a (self) join so slow with Virtual Layer
I use QGIS 3.4 on Windows 10
I have a polygon layer and a point layer. The points have a streetname attribute. I want to check if there are polygons with more then 1 streetname.
I took 2 steps, first ...
0
votes
0answers
33 views
Merge attributes of selected features not working in QGIS 3
The following option in the advanced digitizing toolbar: Merge attributes with following features is not working.
According to the following query:
Copy attributes from one feature to empty row of ...
1
vote
0answers
18 views
Spatial Joining multiple features (from one layer) to one feature os other layer on QGIS 3.4
My objective is similar to the one especified on
Joining Multiple Features to One Feature
The thing is that I'm on QGIS, and seems that tools are slightly different, so that confuses me on how to use ...
0
votes
0answers
12 views
Right table values missing from AddJoin() when Join table order reversed?
Trying to get to the bottom of an unusual behaviour which I am seeing in a join. Background as follows:
I have a feature class of centroids which have been located on the network.
I have a solved OD ...
-1
votes
0answers
24 views
QGIS one line feature segment multiple attributes
So, It's a common task at my job to split a line feature with property boundaries and join property owner details to the splitted line segments. With one property owner per line segment there is no ...
1
vote
2answers
24 views
How can I display a polygon layer after joining it with a point layer using the polygon geometry saved in the table of attributes?
I joined a polygon layer to a point layer using a common field and then exported as a new layer. Just in case I first saved the geometry of the polygon layer (shape and area) in the table of ...
0
votes
0answers
28 views
Joining geometry tables in GeoPackage using SQL
I want to join two geometry tables (table1 containing and table2) inside the same GeoPackage and eventually two tables in two separate GeoPackage. Just to be clear, when I open the GeoPackage in QGIS, ...
0
votes
1answer
27 views
How I can make a child table appear in the parent table of attributes in QGIS?
I used "relate" to connect a many to one child table to a parent table (addresses to land parcels, one parcel can have several parcels) and I see it in the "form view but it is not ...
0
votes
1answer
35 views
Performing many to one join in QGIS
I have read https://docs.qgis.org/2.18/en/docs/user_manual/working_with_vector/attribute_table.html#creating-one-or-many-to-many-relations and also many to one join in QGIS but I can't seem to be able ...
0
votes
0answers
21 views
Identify multiple polylines in one polygon (ArcGIS)
I have coastal city polygons, and one polyline with a numeric attribute (X) that I am interested in, which ranges from 1-9. One city can have diverse values of X. My final goal is to have one table, ...
0
votes
0answers
23 views
Take first match when encountering a 1-Many relationship when joining with ArcPy Data Access UpdateCursors
My current code is as follows:
import arcpy
sourceFC = r"C:\Path\SourceFeatureClass"
sourceFieldsList = ["JoinField", "ValueField1", "ValueField2", "...
0
votes
0answers
17 views
Random assignment of attribute table values to features
I have the current SQL expression, which I have already had help with … thank you:
SELECT j_pipeline_midpts.*, j_pipeline_inc.*
FROM j_pipeline_midpts
INNER JOIN
j_pipeline_inc
ON ...
0
votes
1answer
15 views
How to join/relate points to polygons by field
I am using ArcMap with a basic license. I have a layer of polygon parcels and a layer of point turnouts. The turnouts deliver water to the parcel, but are not located within the parcel.
My parcels ...
2
votes
2answers
42 views
Update coordinates on geopackage with shapefile
I have a geopackage file that has all the information about certain items but the coordinates need to be updated. I'm using an old Leica 1200 GPS to get the new coordinates and giving the same ID to ...
1
vote
1answer
34 views
SpatiaLite database error: no such table, but it is present in the SpatiaLite database
I am new to databases in QGIS, but cannot find any answer in all the documentation and online help in a weeks worth of desperate searching. I think this might be a newbie error, but just cannot solve ...
1
vote
1answer
55 views
How to generate a column with a count of number of points in a polygon AND have 0 for the rows where there are no points in the polygon?
I have two data sets with a large number of points that I’m organizing into a hexbin grid.
I'm associating these points with the hexbin polygons by using PostGIS to determine if a point falls within a ...
0
votes
1answer
34 views
Using Join Field in ArcPy to merge multiple tables
I'm trying to merge multiple tables using the Join Field function in ArcPy. This script currently runs perfectly to merge the multiple tables but gives the columns new names. However, I will like the ...
0
votes
1answer
31 views
Missing / misnamed fields in PostgreSQL table join in QGIS
First, I'm brand new to PostgreSQL and PostGIS, so my question is probably asked wrong, and it may be a duplicate – but my search attempts didn't find anything. Also, I don't expect this is an issue ...
0
votes
1answer
43 views
Using “Make Query Table” in ArcPy
I'm trying to join over a hundred tables (arranged in columns) in ArcGIS using Python (ArcPy). They all have the same number of rows and columns (same data, but different values). I had them as dBase ...
1
vote
1answer
121 views
Query a JOINED ArcGIS Online resultset (via an HTTP request)
In a related question, we determined that it's possible to query an ArcGIS Online FC via an HTTP request.
(I'll refer to the feature class as FC1.)
In addition to the above, I want to dynamically join ...
0
votes
0answers
22 views
Join attributes from point into lines (but only lines with certain attribute value)
I have point objects with attributes and line objects, where the attributes are missing.
The only connection between these geometries is an angle I calculated. (the labeling of the points has the same ...
0
votes
0answers
31 views
Chaining outputs in ArcPy standalone script
I am trying to create a standalone ArcPy script.
I started by creating this in ModelBuilder and then I exported it as a Python script. This works perfectly in ModelBuilder but produces only an empty ...
1
vote
1answer
22 views
Join/relation not an available widget option in the attributes form?
I cannot figure out why, but, in a tree/planting projects database, I have a fairly simply data model where I have one polygon layer to symbolize the area/project (eg. Maple Oak Park, John Smith ...
0
votes
0answers
17 views
How to add data to attribute table in ArcGIS 10.4?
I have a question about how to add data manually to the attribute table of a shapefile. Whenever I add data to the file or need to change data in the file, I right-click on the layer and select "...
0
votes
0answers
21 views
ArcGIS Join returning some null values
I am a student in an ArcGIS specialization using ArcGIS 10.7.1 for Desktop, and have been struggling to complete part of an assignment.
My assignment is to interpolate ozone data from monitoring ...
0
votes
0answers
29 views
How can I join attributes by nearest, filtering the results by an another attribute present in both tables?
I have the centroid layer of climate polygons and I want to find the closest weather station of the same type of climate. The two layers (the one of centroids and the one of weather stations) contain ...
0
votes
1answer
76 views
Google Earth Engine: join featureCollections
I have two feature collections, produced using the reduceRegions function, from different image collections. I can export both as CSV, but I've been trying to join or merge them so I can export them ...
1
vote
0answers
23 views
Joining attributes between layers based on proximity of features [duplicate]
In QGIS 3.12 I have a Layer Y that has a specific attribute and my objective is to fill this attribute with information from Layer X regarding the proximity between the features of Layer X and Layer Y....
1
vote
0answers
13 views
Labeling a joined (one to many) layer with the number of feature joined to it in ArcGIS Online
Using ArcGIS Online, I performed a one to many join with a buildings layer (one) and a table of internal cameras (many). This produced a layer showing buildings and allows me to scroll though all the ...
4
votes
2answers
125 views
Setting QField for 1:n photos
I'm using QGIS 3.12 on Win10 x64.
I'm trying to configure QField for 1:n photos. I have a point layer representing trees, and I want to be able to add multiple photos to that pt.
I have set up as ...
0
votes
1answer
45 views
Matching points to grid-cells - using join attributes by location
I have point data in a shapefile covering most of Africa. I've made 0.1x0.1 grids using the make grid option from QGIS and now I want to link the grid_id to my point data. Below you will find a ...
0
votes
0answers
9 views
Merging a raster file to polylines according to their attributes
In ArcGIS Pro, I have a raster layer of slope-aspect of Toronto and I want to merge it another feature which contains bus routes. How can I do it? Join tool is useless since the raster layer is not a ...
0
votes
1answer
35 views
List of elements in join layer without a match
When I set up a table join in one layer A, how do I find all elements from layer B that didn't find their way into the joined table?
This is much like doing a left outer join and trying to find all ...
5
votes
1answer
118 views
Get points within maximum distance from any point in GeoPandas
Given a set of points (with meters coordinates), I am trying to create lines between them. But I don't want to create lines of each pair of points, Iwant to create thoses lines if the distance between ...
1
vote
0answers
26 views
Join the fields (column) into headers after geoprocessing
I am new on QGIS, I will try to be as specific as possible, but it seems quite hard to explain...
I am working with a first polygon vector: species' territories [In the attributes table: 50 lines, for ...
1
vote
0answers
27 views
Pasting elements into layer with Value Relation widget
I have a layer, which contains data. Elements from this layer should be pasted into another one, which has value relation widget applyed to its columns. I'm missing values from the first (source) ...
0
votes
0answers
28 views
WFS Request against a layer with a foreign table join
I have a Geoserver layer that is pulling from a Postgresql view that contains a left join to a foreign table (data from a SQL Server database). If I query against the view in PGAdmin (ie. SELECT * ...
1
vote
1answer
48 views
Create one-to-one relationship in QGIS
Can I create one-to-one relationship using project relations in QGIS?
I am trying to create a spatial database in QGIS. I want to link my attribute data to my spatial data(shapefile). I have already ...
0
votes
2answers
49 views
How to join shapefile to CSV (not other way around)?
I have a CSV with multiple rows per county (it contains data on number of coronavirus cases per week). I want to make a choropleth map showing the change over time, but when I join this data to a ...
1
vote
1answer
32 views
How to get a report of the unjoinable records from a table when joining attributes by field value in QGIS?
I am working on a "Join attributes by field value" processing, but I would like to get the "unjoined" records from the table, not those from the vector layer, and if it's possible, to get a report in ...
1
vote
1answer
52 views
Join attributes by location in GRASS GIS
I have spatially superimposed points in two layers from which I want to copy one column of attributes to the other layer. In QGIS you can do this with 'Join attributes by location' which worked great.
...
1
vote
1answer
74 views
Many to one relationship or join in QGIS
I have a road network layer that has a unique id "ID_2" for each road segment. I also have a table that contains the route for each bus network. Each row in this table contains the name of the bus and ...
1
vote
1answer
24 views
Missing entities when JOIN between differencce layer to origianl layer in SQL QGIS3
I have two layers :
1. layer of fake plots
2. layer that shows only the safe area inside those plots (generated with the Difference tool), and contains data about the area of each safe polygon.
this ...
0
votes
0answers
35 views
Geometry loss/mix up of a spatialite view joining two tables
I have two Spatialite tables:
- Sites (with geometry column) (ca. 5000 single sites)
- Samples (ca. 6800 samples)
To display the samples in QGIS I want to create a spatial view showing all samples at ...
1
vote
0answers
18 views
Add Join Management and UpdateCursor in Arcpy
How to join multiple table with shapefile, update cursor specific field of the table in shapefile table and remove the join table? I write some script but it not work, please correct my script.
...
