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
2 votes
0 answers
24 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 votes
0 answers
27 views

Using join field tool and getting generic ERROR 999999:: Something unexpected caused tool to fail [closed]

I am using the join field tool and getting the generic ERROR 999999:: Something unexpected caused the tool to fail. These are my inputs and I am following my lab assignment correctly so I am not sure ...
k'shaun Wordlow's user avatar
1 vote
2 answers
69 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
56 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
0 votes
2 answers
81 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
  • 363
0 votes
1 answer
32 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(...
Badboy's user avatar
  • 31
0 votes
1 answer
54 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
97 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
21 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
34 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
20 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
  • 19
0 votes
1 answer
32 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
38 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
22 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
56 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
54 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
69 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
98 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,637
3 votes
2 answers
151 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
36 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
55 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
66 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
45 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
83 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
42 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
76 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
192 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
105 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
52 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
103 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
121 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
31 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
71 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
1k 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
  • 317
1 vote
2 answers
564 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,059
0 votes
0 answers
41 views

Link multiple tables to one geometry layer in QGIS

I have a QGIS-project with one geometry layer (.shp), with some attributes, and multiple tables without geometry (.dbf). The different tables and the geometry layer share a column with unique ID-...
BramV's user avatar
  • 107
0 votes
0 answers
16 views

Receive null values in spatial join with census tract data in QGIS

I have tried this in both QGIS and GISmap. I am attempting to get average wind speed by census tract. I am using the census tract boundary information from ArcGIS Online (polygon ESRI data) as well as ...
Katarina's user avatar
1 vote
1 answer
143 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
665 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 vote
0 answers
29 views

Join all results from a one to many join in ArcGIS Pro

I want to join all possible results (up to 5 counties intersect ZIP codes) from ZIP_County_Intersect to be populated as the null County fields in ZIP_County_Dissolve. These results are coming from ...
rachel.passer's user avatar
0 votes
0 answers
37 views

Adding a field to a feature layer from a dataset

I'm currently working in ArcGIS with shapefiles that have a code (1-100) in the attribute table, but no name. Bear in mind that there are over 10000 polygons in this layer. In addition to this feature ...
Kali's user avatar
  • 1
0 votes
0 answers
86 views

Choosing parcels listed from Excel sheet in QGIS

I was sent an Excel sheet by a different department with all the parcel numbers they want to be mapped. They are all over the county. What is the best way to select the parcels that were given to me ...
user avatar
1 vote
1 answer
34 views

Merge shapefiles with different divisions

I have two shapefiles with similar borders but different internal divisions. One shapefiles shows schools' catchment areas and I have a field "mobility". In the other shapefile, there are ...
gusv2000's user avatar
  • 348
1 vote
1 answer
495 views

ArcGIS Pro: Export file geodatabase feature class including JOINs and RELATEs

Question: Is there an approach to export a File Geodatabase Feature Class with the content resulting from all of its JOINs and RELATEs with File Geodatabase Tables from the same Esri geodatabase file ...
stonebe's user avatar
  • 445
1 vote
0 answers
56 views

ArcGIS Pro: Merge tables of geodatabases including existing joins

Is there an option to keep existing Joins for the output of the Data Management > Merge process applied on multiple geodatabase files? I have multiple geodatabase files *.gdb with the same ...
stonebe's user avatar
  • 445
0 votes
1 answer
43 views

Joining Sentinel-1 Collection to Landsat C2 T2

I am interested in creating a time series of Landsat from 2000 to 2022. I want to join Sentinel-1 as an additional band to each Landsat Image in the image collection before I aggregate my date to ...
pbalteza's user avatar
1 vote
1 answer
219 views

Joining attribute tables without columns with the same name in QGIS

I would like to link the two attribute tables (see image). However, as far as I know, I need two columns with the same name for the link. Is there an alternative so that I can link the two attribute ...
vuayalo's user avatar
  • 11
2 votes
0 answers
30 views

Assessing two rasters to identify areas where one species exists but not other using ArcGIS Pro

I'm re-learning ArcGIS Pro having not been in the GIS world for quite a few years (not since ArcMap). I have two vegetation species raster data sets and what I'd like to do is to find the areas where ...
Emily's user avatar
  • 21

1
2 3 4 5
21