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

Joining Population Data to Census Tract Shapefile using ArcGIS Desktop?

I'm trying to create a population density map and I'm struggling with getting the population data to join correctly to a census tract shapefile. Between the census tract shapefile and population ...
1
vote
1answer
819 views

Join attributes by location error

I'm trying to join attributes by location - my Join layer is one I created from a 10m fixed width buffer, my geometric predicate is only 'within'. When I run the algorithm, I get an error of "-...
0
votes
2answers
428 views

Merging Rows in Table using ArcGIS Desktop?

I am fairly new to GIS and I am using ArcGIS Desktop 10.4. The wildlife monitoring company I work for uses camera pods to sample fisheries population and uses side scan sonar to collect habitat data. ...
1
vote
1answer
96 views

join or merge empty table with layer

I'm building a municipal model with many pipes, manholes & other structures as vector layers - these are coming from several different sources of information and the field structure can be ...
4
votes
1answer
820 views

Assign raster values to a grid (polygon) in QGIS

I have a few raster datasets and I created a fishnet (polygon). I tried to add the values which the rasters have in the grid cells to the attribute Table from the polygon.
2
votes
1answer
66 views

Spread attribute and recursively join in standalone pyqgis app

TL;DR Is there a pyqgis equivalent to R's tidyr::spread or reshape2::cast ? If not, how do we recursively join by attribute n layers to another without erasing previous join ? The problem I have a ...
1
vote
1answer
251 views

many to one join in QGIS

Having looked at many duplicates I still can't seem to get a concensus especially with regards to using QGIS. I've read Creating duplicate features - many to one - in qgis and several others. My data ...
2
votes
1answer
61 views

Making species map using km grid in ArcGIS Desktop?

In ArcGIS Desktop 10.5, I am trying to make a species map to show the locations certain species are observed. I want to do this using kmgrid. I got quite far I think but now I am stuck. I made a km ...
1
vote
1answer
825 views

Joining .csv to attribute table in ArcMap?

Is there an ArcMap 10.5 method of joining an excel file (.csv) to a shapefile/attribute table using several fields instead of an explicit identifier? I've been having trouble with this, and joins ...
2
votes
1answer
535 views

Keep only matching records on QGIS

Is there any way of doing the "keep only matching records" on QGIS when working with joint tables? (This is an option on ArcGIS, but not on QGIS as far as I know)
4
votes
1answer
264 views

QGIS Attribute Table Format (columns and rows)

I am having a Data Format problem with Qgis using the timemanager. I loaded a layer with timecodes and values for 1 point and finally made it work. Now i dont have one point, but 250. Those 250 points ...
1
vote
1answer
179 views

Understanding Join Data vs Spatial Join?

I am working on a semester project for my GIS Programming and Customization course. I built a model that receives updated crime point data from the City of Denver as an input. The sequence of tools ...
2
votes
2answers
3k views

Merge consecutive GPX tracks?

Is there a (Windows) application that takes multiple, consecutive tracks, and merge them into a single GPX file? I tried deadware "GPS Track Editor", but neither Merge nor Join did the trick:
1
vote
2answers
3k views

How to combine/merge attribute data from 1 layer to another, polygon to point, merge attributes and wrap/carriage return attributes

I am trying to merge field areas from a polygon layer into a point layer So the field area from this polygon onto the dot layer. Where the Point layer, has an String attribute, and set to Multiline, ...
1
vote
0answers
219 views

Joining csv table and shapefile via ArcPy?

I want to join the attribute table of a shapefile with an externally created csv table via ArcPy. The format of the columns are: for attribute table: "Variable1" "Variable2" "Variable3" "CATCHID" ...
0
votes
1answer
15 views

When I run the Join function on two vector layers the distance field keeps returning “-1”

When joining two point layers by geographic location with the "Each point will be given attribute" selection, I keep getting a NEARDIST of -1.
2
votes
1answer
585 views

Import CSV and join with another table to add geometry in QGIS

This relatively simple task has me stumped in QGIS so want to check if I'm missing something. We get a lot of data supplied in spreadsheets. These datasets have no spatial information but will ...
1
vote
2answers
896 views

Joining attributes from points to polygons

I have a polygon layer without data, and a point layer with attributes. Each point is contained in one polygon, and I would like to have the data from the point layer joint in the polygon layer, so ...
1
vote
1answer
83 views

When joining a CSV file to a Vector layer on QGIS, the Graduate style can't be classified [closed]

I have a CSV file with GEOID, GEO.id2, and then 5 calculated values. I am trying to make a map using the graduated style with my shapefile. I have made a CSVT file w/ "String","String","Real","Real","...
1
vote
1answer
126 views

uneditable variable in attribute table?

Shapefile A was joined with a new variable x from table C. Then I saved Shapefile A under a new name Shapefile B. The joined field (variable x) appears in Shapefile B as a "native" variable (which was ...
1
vote
0answers
49 views

Intersect ignores joined fields

In QGIS, I use the intersect function provided by the saga algorithms. The resulting shapefile contains the original attributes but misses joined fields of the input layers. Is there an elegant ...
1
vote
1answer
108 views

Joining Census block data

I know I'm probably missing something very basic, but I've been trying to join census block data together. The table contained within the block shapefile contains a field called GEOID10, which has ...
4
votes
1answer
719 views

Permanent attribute join (for dissolving)

I am quite new with QGIS and I have run into a problem that I would love your suggestions to. Here we go: I want to end up with a municipality map with the sum of perish population. Here's what I ...
1
vote
0answers
32 views

Only Integers Transferred when Joining by Location

When joining attributes from a points layer to a polygon layer of Postcodes, only the integer fields from the points layer are transferred. See screenshots below. Points Layer Points Layer Continued ...
2
votes
1answer
644 views

Table Join Resulting in NULL

I'm trying to join a field named "Area" belonging to the shapefile 'Ancient Woodland' with the shapefile 'Net Development Area' (see screenshots below). The results only return 'NULL' which I don't ...
3
votes
1answer
133 views

Spatio-temporal joins in QGIS?

Does anyone know how to count points within radius of another point when a time/temporal condition is met in QGIS? I assume I need to create buffer zones, but I do not know how to then count ...
-1
votes
1answer
389 views

Join Field Management

I have not used the following tool, and am recieving the following error when trying to add a field to two of the following FC's below. Is this a syntax issue? import arcpy PlaceFC= filepath ...
0
votes
1answer
84 views

How do I get Table from Vector layers for use with joinattributestable

I am attempting to run: processing.runandload('qgis:joinattributestable', layer1, layer2, 'id', 'id', None) To join my tables and output to a temporary viewing layer. layer1 and layer2 are both ...
0
votes
1answer
49 views

Updating the legend of a joined SDE feature layer in Python

Is it possible in Python to apply the legend from a template layer file to a SDE based feature layer with a GDB table joined to it where the value field being used for the unique values symbology is ...
2
votes
1answer
726 views

When joining tables, style of vector layer can't find new column in QGIS

When I joined a csv file with the attribute table of my vector label everything's cool. Now, when I open the attribute table of the vector layer I can see that I successfully added the new designated ...
0
votes
1answer
481 views

Adding and filling GEOMETRY column in new spatialite

I have three tables. One has no geometry. The second is POINT type, and shows up correctly on the map. The third is, for the moment, a simple checker table, don't worry about it. I am able to perform ...
1
vote
0answers
101 views

PostGIS: Query using spatial join using pgadmin3

I have created three tables ch01.restaurants (SRID 2163;columnsfranchise, geom), ch01.lu_franchises (lookup table, no geom field;columnsid, franchise), ch01.highways (SRID 2163;columnsgid, feature, ...
0
votes
1answer
786 views

Joining multiple lines into single line in ArcGIS Desktop? [closed]

In ArcGIS, I have digitized roadmap in shapefile, and i want to join several lines into one (singlepart) line, NOT merging (i.e., I want to join from one's node to another node). The feature exist in ...
2
votes
1answer
309 views

Attribute Tables with drop down menus from lookup tables with joins

I am attempting to create drop down lists when editing attributes in Arcgis Desktop in order to eliminate human errors. Through using domains I managed to carry this out successfully and the drop down ...
2
votes
1answer
68 views

Data being excluded from table joins (QGIS)

I've got a map with spatial data that I want to merge with some non-spatial tables. The tables will become spatial based on unique numerical identifiers contained in a column shared with the spatial ...
3
votes
1answer
2k views

Creating spatial-join which will calculate sum of values in certain field behind attribute in ArcMap?

When using the "Update Column" tool within MapInfo Pro, you have the ability to update a column in one table with the sum of values from a column in another table; joining them only where objects in ...
3
votes
1answer
288 views

Alternatives to joining attributes in QGIS?

In QGIS 2.18, I can join attributes stored in a csv-sheet to a shapefile, which works fine. However, when saving the respective layer, the joined attributes are not stored. Is it possible to add ...
1
vote
1answer
214 views

Join taking far too long! [closed]

I am joining points to polygons in ArcGIS (10.5), but this is taking a ridiculous amount of time (roughly a week!). The points are climatic data covering the UK - approx 450,000 points. The polygon is ...
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
1answer
179 views

Compare two fields not equal to each other in a join from a feature layer

I am wanting to find features not equal to each other in a feature layer in Python, and I am not finding the right SQL to use. The two features are joined to each other on a MasterID field. When using ...
0
votes
1answer
329 views

Arcpy.AddJoin error

I am trying to populate a table by joining an excel sheet to a featureclass and using field calculator to populate the fields, but I am getting errors for the arcpy.addjoin_management. import arcpy ...
7
votes
2answers
499 views

In QGIS is it possible to apply an expression to a join

I am trying to join by 2 text fields and there is a lot of mismatch due to CaSe and space issues... can it be run so that it's lower("field1")=lower("field2") I otherwise have to create a new field ...
0
votes
1answer
64 views

Combining Data from a CSV file to a Shapefile based on matching FID

I am relatively new to GIS. I have an existing shapefile of New Zealand islands that details island name, Lat/Long, island group, area, etc. Included in this shapefile is a unique FID for each island....
0
votes
0answers
249 views

QGIS table join does not work with a join field starting with '0' (zero)

I'm trying to perform a table join in QGIS (2.14.5-Essen) between a shapefile and a attribute table. The join field and the target field is the ID of a spatial enumeration unit of 8 numerical ...
1
vote
0answers
66 views

Excluding matching records from Tabular Join?

This may be slightly esoteric and I suspect it just can't be done but I have found myself in the following situation. I have a roads layer with a routeid (short integer) field. This field has been ...
2
votes
1answer
50 views

Updating the shapefile after a join

I need to update a shapefile by joining it with a csv file in PyQGIS. This process occurs only in the memory and I want to make it permanent. The sample code is as below: from PyQt4.QtCore import * ...
3
votes
1answer
831 views

Using AddJoin in ArcPy?

I'm trying to join 8000+ daily rain tables to one climatic stations shape. The goal is to get 8000+ daily rain point features. I used to work with the next arcgis model, but now i'm trying to put it ...
0
votes
1answer
271 views

Adding non-spatial Oracle table to QGIS

I can connect to Oracle database adding and creating spatial layer. In the same database there are non-spatial tables but I cannot view any of them when connected to the database. I need to add ...
1
vote
0answers
267 views

Joining tables to feature classes in batch using ArcPy?

I need some help with batch processing using python. I am trying to join fields to multiple point features classes from multiple dbf tables (650 feature classes and tables). Names of the dbf tables ...
0
votes
2answers
119 views

ArcPy: 999999 ERROR when using AddJoin_management

I want to execute three joins in total. The first two joins work, but when I'm trying to join both resulting datasets I get the beloved 999999 ERROR. # sr tables for joins sr1Table = sr1Path + ".dbf" ...