Skip to main content

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
0 answers
5 views

After spatial join of layer and table, set symbology to unique values but unique colors do not show on map of layer

I am taking Fundamentals of GIS through Coursera (UC-Davis) and on Assignment 2 where we used source data gdb to add a standalone table. After that, joined soils layer to table. Next, did spatial join ...
Marina Steiner's user avatar
0 votes
0 answers
17 views

Converting patch ID output file from FRAGSTATS into vector file with QGIS

I am trying to convert a patch ID file (raster) which I generated using FRAGSTATS into a vector file to perform a table join between this vector file and the .patch file that contains the patch IDs ...
AlFelix's user avatar
1 vote
1 answer
37 views

Union of 2+ point datasets with overlapping and non-overlapping lat/lon points

I have three point layers with n1, n2, and n3 number of points. Each dataset shares with the others a common set of points that refer to the same spatial entities. The lat/lon values of these shared ...
Oliver Amundsen's user avatar
0 votes
0 answers
53 views

Extracting border from shapefile and then calculate distance to the border

I started with a states boundaries shapefile. I want to extract a part of state border and then calculate the distance of village centroids to the nearest point on this border. I have already ...
Ak2020's user avatar
  • 1
0 votes
0 answers
15 views

ArcGIS Pro publishing map/feature service from featueclass and joined dynamic table (db view)

I need to join a dynamic PostGIS database view "measurements" to a static SDE geodatabase point featureclass "locations" (same SDE/PostGIS geodatabase). They have the same number ...
juraj murcko's user avatar
1 vote
0 answers
35 views

PostGIS: Left Join (ST_intersects) lead to multiple counts (not distinct) in aggregate function [duplicate]

I have a query with 2 left joints (ON ST_Within, ON ST_Intersects).The second left join (ST_Intersects) in the example below causes multiple counts of the point_table in the aggregate function (SUM). ...
teamspeakuser's user avatar
1 vote
1 answer
55 views

Join KML with CSV and conduct Interpolation

I have a KML file created in Google Earth that has points where we sampled 11 monitoring wells (my work uses Google Earth Pro and I'm trying to introduce QGIS). I have a CSV that has the contamination ...
BiosphereEngineering's user avatar
0 votes
0 answers
28 views

ArcGIS Pro Feature to Point attribute inconsistency

I'm curious to see if anyone has run into an issue where the ArcGIS Pro Feature to Point tool has generated inconsistent data? I have a set of polygons that I'm use to collect zonal statistics. I ...
James Stewart's user avatar
1 vote
0 answers
44 views

Join Layers for PyQGIS

I am using version 3.0 and above. Below is my code where i want to join two layers. I didn't get any error but the Charting Layer doesn't show update on fields. I need to join UPI field of Excel file ...
unknown's user avatar
  • 13
4 votes
1 answer
205 views

How can I use ogr2ogr to left join a CSV to a GPKG file and produce a GeoJSON output in a scalable way?

I have a large GPKG and a CSV file, and I'd like to (left) join the CSV to the GPKG on one of the columns. A visualisation of what I'm trying to achieve: Reproducible example We can create an example ...
zabop's user avatar
  • 2,224
0 votes
0 answers
36 views

QGIS vector layer attribute table update using CSV - JOIN not working

I have an existing vector layer which I have added features to and updated the geometry existing features. The associated attribute table has 34 FIELDS (with 25 features). I'm trying to undertake a ...
finchys's user avatar
0 votes
0 answers
38 views

Automatically populating field on layer with geometry when corresponding field on layer without geometry is edited using QGIS

I have a "Burn Plan" Form layer (no geometry) that has a "wind_direction" field whose widget is a Value Relation with 16 options to choose from (from a "directions" no-...
Georgia Slim's user avatar
2 votes
0 answers
38 views

Join attributes by location for lines

I have two line shapefiles in QGIS: Providing a road network (many lines) Providing the shortest route between two points via the road network (one line) I'd like to join the two attribute tables ...
Xanthia's user avatar
  • 21
1 vote
2 answers
114 views

Filling field with values from field of another table using QGIS

I am using QGIS 3.28.9. I need to complete a field from a building's layer with the field's values from a plot's layer, based on the location of the buildings. At first I thought of doing it through ...
Mig TabSher's user avatar
3 votes
1 answer
64 views

Add attribute to a point it shares line segment with in QGIS

I have two point layers, say Point layer A and Point Layer B. I also have a line layer. I want to transfer the attributes of the point layer A to Point Layer B, only if it shares the line segment. I ...
Akshara's user avatar
  • 31
1 vote
2 answers
168 views

How to union two polygon shapefiles by one or more attribute fields in QGIS

I would like to union two polygons that have the exact same fields in their attribute tables in QGIS. However when I use the Union tool, it makes an attribute table that has exactly twice the amount ...
MapDeath's user avatar
  • 341
0 votes
0 answers
38 views

Getting an empty Python geodataframe while I perform spatial join operation on - polyline/line and points

import os os.environ['USE_PYGEOS'] = '0' import geopandas as gpd sv=gpd.read_file(r"D:\Sampledata\Kerala\Schools.shp") sr=gpd.read_file(r"D:\Map\Kerala\Road_line.shp") gh=gpd.sjoin(...
mangotree's user avatar
0 votes
1 answer
82 views

Joining by attribute using Fuzzywuzzy module (Python Script)

I'm hoping to get some assistance of debugging my script using fuzzywuzzy attribute joins. I have housing permit data that needs to be joined to parcel data. Unfortunately, the housing permit data is ...
Warren Navarro's user avatar
2 votes
1 answer
109 views

Join Field does not work properly I end up getting Null

I have the ports shapefile downloaded from here. the 2009 version. https://ec.europa.eu/eurostat/web/gisco/geodata/reference-data/transport-networks I need to select and export only the ports that are ...
Bilgeyts's user avatar
0 votes
0 answers
32 views

Setting up a dynamic spreadsheet to join with feature layer in ArcMap

I am building a map of about 500 storage units that are being acquired and relocated, each unit is represented as a polygon. Each polygon is coded by Unit Number and will go through about 5 different ...
kkaszas's user avatar
  • 290
0 votes
0 answers
36 views

'Join attributes' failing to merge data

In QGIS 3.22.9, I retrieved data from buildings from a WFS. I want to use the 'join attributes by location' to add more data from other layers into the attributes table. To be precise: if a building ...
JT99's user avatar
  • 1
0 votes
0 answers
21 views

AddJoin_management function from GPTool not working. Any examples of the usage of this function in ArcGIS Pro SDK?

I have a feature class using which I create a Layer: featurelayerNew = await QueuedTask.Run(() => { var lcp = new FeatureLayerCreationParams(featureClass); var featureLayer = LayerFactory....
SriMari's user avatar
  • 29
0 votes
1 answer
35 views

Add condition to select only images between 1 day and 2 days difference

I want to compute the difference in chloa concentration at an interval of 2 days. I used this function to create a join with the images from a date range of 2 days but I only want to select images ...
Aurélien Lengrand's user avatar
1 vote
0 answers
43 views

How to define the points in ST_PointFromText command based on lon lat field

I have a filename with the columns: lon, lat, val1, val2 etc. and I want to join it with a grid shapefile in WGS84. I use the following command but I get an error in ST_PointFromText ogr2ogr -sql &...
nat's user avatar
  • 289
2 votes
0 answers
23 views

How to spatially join a csv database with a polygon shape file based on lon lat fields using ogr2ogr

I have multiple databases in csv files (e.g. data.csv) with the following columns : id, lon, lat, val1, val2, val3, val4, val5, val6 I want to spatially join all the fields of data.csv with a grid ...
nat's user avatar
  • 289
1 vote
0 answers
92 views

Overwrite / replace a shapefile with a new one without losing symbology and shapefile queries

I'm currently trying to encourage the company for which I work for to start using QGIS to display boreholes on a map, one of my current problems is updating the data / shapefiles within QGIS for large ...
LiMoNiZeR's user avatar
1 vote
1 answer
72 views

QGIS multilevel query: aggregate values from different layers

QGIS 3.28.4. I have 3 shapefiles: polyline, street information (streetId, + streetInfos...) point, stake information (StakeId,streetId, + Stakeinfos.....) polyline, pannels information (PannelId, ...
ClaudeVer's user avatar
  • 630
2 votes
0 answers
97 views

Removing joins to layers using ArcPy in ArcGIS Pro

I have some layers that point to feature classes in a geodatabase. Some of the layers are joined to a table also in the geodatabase and I am trying to remove all the joins so that I can run some other ...
James's user avatar
  • 41
4 votes
1 answer
107 views

Getting only joined fields using PyQGIS

How do I get a list of fields that have been joined to a layer, or how can I check if a specific field has been joined? In older versions there seemed to be field.source(), but this is not available ...
BritishSteel's user avatar
  • 6,647
3 votes
2 answers
195 views

Joining vector layer with CSV-file that contain duplicates in QGIS

I'm currently working on a project, and I received a CSV file which has additional information about each feature. I intend to join the CSV file with an existing layer. Picture it like this: However, ...
eafwnrg's user avatar
  • 51
1 vote
0 answers
40 views

Calculate the intersection area of three types of polygons in QGIS

I have three layers -- US Census tract boundaries (vector) Radius of superfund sites (vector) US Land Use (raster) So I only want the land cover types starting with 'Developed', and let's call it '...
lianal's user avatar
  • 21
0 votes
1 answer
58 views

QGIS - I cannot add attributes to a line segment [closed]

I am trying to add the name of a polygon (an attribute called "member") that the line segment falls within, so that a field called member is added to the line file and it is filled with the ...
PattyB's user avatar
  • 17
0 votes
0 answers
87 views

ArcPy JoinField Error 000574: Python is not installed

I am new in coding. I am trying to add a field of to my attribute map using "Zonal statistics as Table" and "Join field" tools. For the last one I am using arcpy.management....
Антон Попов's user avatar
1 vote
1 answer
51 views

Join non-spatial CSV layer with spatial shape layer, using multiple input fields

I have two separate layers i want to join in my QGIS-project based on multiple matching input fields. One layer consists of a non-spatial CSV table, but with the matching fields: Streetname, House ...
JTHW's user avatar
  • 13
0 votes
1 answer
124 views

Represent linestrings with arrow direction based on origin and destination points location

I have two layers: one linestring layer with two attribute fields that identify the codes of the origin (field A) and of the destination (field B) nodes; one point layer with one attribute (unique ...
Michele Cordini's user avatar
0 votes
0 answers
55 views

Joining street ID to Sidewalk polygons using ArcGIS Pro

I am using ArcGIS Pro 3.0.3. I am trying to match a set of Street IDs (line data) to sidewalk polygons. I have buffered the street line data based on street width, and then ran a spatial join, joining ...
Jason Leland's user avatar
0 votes
1 answer
84 views

Joint feature QGIS 1 a N

I have 3 tables, a linear table of sections, a non geometric table of bus lines, and a intermediate table between both, with relations N:M. In the intermediate table I have the ID of sections table ...
pablo.olivares's user avatar
0 votes
0 answers
445 views

How to Fix ArcGIS Pro error Cannot get exclusive schema lock. Either being edited or in use by another application or service

I am trying to complete an Add Join between a shapefile and a .csv table in ArcGIS Pro. I downloaded the shapefile from a government website, and I created the CSV with my own data. I want to join ...
galaxy-friday1017's user avatar
3 votes
1 answer
128 views

Calculating field with input from two layers in QGIS Graphical Modeler

Even though I found similar questions, I couldn't find a suitable answer for the problem I have. I want to create a model that calculates the difference between two fields ("NUMPOINTS") from ...
Sebastian Silva's user avatar
0 votes
1 answer
56 views

Joining CSV to shapefile, only some attributes are joined, others are not (QGIS)

I have a CSV with census population data and a shapefile with census tracts, a classic example where you would use a table join. For four of the files that i joined, there has been no problem besides ...
Tronald's user avatar
  • 11
3 votes
1 answer
119 views

Autofill records with previous values in QGIS

I have a track (point layer with date and positions) and some information associated to it. I enter this information when some event changes (Effort on/off or Beaufort goes up or down in this example)....
Kike's user avatar
  • 33
0 votes
1 answer
203 views

Remove all spaces in attribute fields using field calculator

I've been trying to join two layers (one shapefile point-layer and one table without geometry) using one attribute column with mutual attributes. Normally this works perfectly. However, only one fifth ...
BramV's user avatar
  • 107
-1 votes
1 answer
32 views

Join attribute table - 2 different layers - 2 different classifications (QGIS)

I have 2 vector layers, one containing cells on a municipality level and one containing a more detailed classification on a district level. Some municipality contain multiple districts, whereas other ...
Ann's user avatar
  • 1
0 votes
0 answers
30 views

Inaccurate attribute values using joins attribute in QGIS

I have a shapefile data that represent the location (polygons) and a tabular data represent its detail information. I want to merge the tabular data to the shapefile. I use QGIS 3.22.12 Here are the ...
Azzam Zainurrafi's user avatar
0 votes
1 answer
82 views

Using Arcmap to Join two tables based on a field with similar values

I am working in Arcmap and attempting to understand a way to join two tables based on similar values. In Service_Points I have a field called Address where the value is 1862 Waterfall Rd In ...
JTstone's user avatar
  • 37
2 votes
1 answer
2k views

GeoPandas: AttributeError: 'DataFrame' object has no attribute 'to_file'. Did you mean: 'to_pickle'?

I am at a complete loss, I have looked at other posts to no avail. Following is the code I am trying to execute: import os import geopandas as gpd root_dir = r"C:\Users\s.oneill\Desktop\SAMPLE\...
SeamusO's user avatar
  • 23
1 vote
0 answers
21 views

Connect different point layers to one layer

I have different projects, which all have a point layer. I would like to compile the data of these point layers into one layer automatically. So that everytime when I add information to the point ...
lesto's user avatar
  • 327
2 votes
2 answers
886 views

Attribute nearest raster values to points, only for points within X distance of raster

We have points data which represent places we tied a gillnet (imagine a tennis net underwater) to mangrove roots along the shoreline and subsequently caught (and released) sawfish, a type of shark. ...
dez93_2000's user avatar
  • 1,079
1 vote
1 answer
222 views

Visualizing features from properties of a feature collection

I would like to know how to visualize features (points) situated in the properties of feature collection that was obtained after applying 'spatial joins' on primary collection ( protected areas (...
genny's user avatar
  • 11
0 votes
2 answers
1k views

ArcGIS Online Dashboard join layers through Arcade scripting

I'm trying to build a script to create a joined layer based on a feature layer and a table my client gave me with only data entry permissions. The structure of the two layers is something as following ...
NorthSon's user avatar
  • 339

1
2 3 4 5
21