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
1answer
59 views

GDAL/OGR Error: Cyclic VRT opening detected

GDAL 2.2.4 (64bit Windows) throws an error during opening of a cyclic OGRVRT file. There was no problem with cyclic VRTs in GDAL 1.10.1 (32bit Windows). Here is a sample VRT file, which I used to ...
2
votes
1answer
788 views

How to join tables to create a new shapefile in ArcMap?

I'm unsure how to join a table and reference shapefile in order to create a new shapefile. I'm using ArcMap. I made a simplified version example below. I have a shapefile of points (locations where ...
3
votes
1answer
98 views

Mass updating of joins in ArcGIS Desktop?

I have an MXD used to join many feature classes to the same table. This table has moved to a different workspace and so I need to update all the Joins to point to the new workspace. I don't see any ...
2
votes
1answer
133 views

Table Join only returns first record from CSV table in QGIS 3.0.3

I have a .csv file that contains instances of hospitalization with diagnosis codes and zip codes and I want to join it to the corresponding polygons in the TIGER 2017 zcta510 shapefile. Every time I ...
1
vote
1answer
212 views

Join.Field_management extremely slow in arcpy stand-alone script

I have an arcpy script that joins two tables together based on the FID field. This slows down my script considerably. The joining process takes several tens of minutes. import arcpy import os from ...
3
votes
2answers
275 views

Joining a shapefile attribute table to a CSV file pyqgis3.0

I would like to join a shapefile to a CSV file in PyQGIS 3.0. So, when I run the following code, it executes without errors but the join action does not succeed. What is wrong with the following code? ...
0
votes
1answer
143 views

Automatically Generate Attribute Table in Qgis

I am working with historical parcel data in Qgis and have the following fields in my attribute table, (name, grantee date, grantor date, parcel ID, acreage, previous owner). Unfortunately, I have ...
2
votes
2answers
111 views

Copy Features consistently failing in ArcGIS ModelBuilder?

I'm running a model to convert .txt files to a table, then join that table with a parcels shapefile, and finally export out that join as a new shapefile. However, the copy Feature's tool is ...
-1
votes
1answer
111 views

Add Join not working in ArcGIS ModelBuilder? [closed]

I'm trying to built a really simple model in ArcGIS 10.6 but it won't work. I want to merge two shapefiles and then join the output-file with a .csv table. The merging works fine but the model ...
-1
votes
2answers
313 views

Finding Start and End Point IDs for a Line [duplicate]

I have a simple point feature class and line feature class. Each point has an ID. The Line feature class has a "Start Point ID" and "End Point ID" field, both of which are currently empty. The line ...
1
vote
0answers
87 views

ArcGIS JS API join ArcGIS Online layers

I am attempting to join 2 layers from the same ArcGIS Online service together, using ESRI's limited sample for MapImageLayer. I would like to join the first [ID: 0] and second [ID: 1] layers in my ...
1
vote
1answer
161 views

Aggregating attribute data with one-to-many relationship class in ArcMap?

I am using ArcMap 10.6. I am joining a table of public housing developments to a parcel map layer, and there is a one-to-many relationship between the parcels and developments: multiple buildings ...
1
vote
1answer
38 views

Creating attribute tables and joining tables

I hope someone can help me! So I have multiple shapefiles and layers. I didn't give them an ID when I created them. But now that I have finished my drawings, I need to give them an id (?) and I need ...
1
vote
2answers
69 views

Join layers in PyQGIS, on multiple fields

Is it possible to join two layers in PyQGIS, on multiple fields? ie, JOIN ON layer1field1 = layer2field1 AND layer1field2 = layer2field2 If so, how?
0
votes
1answer
110 views

Add CSV file, join to feature class, field calculate and save output using ArcPy?

I am having some difficulty conceptualizing how the code should work for a custom ArcPy Script tool. Currently our work flow involves QA/QC and taking a csv file and joining it to a feature class. ...
1
vote
0answers
61 views

Change polygon color over time by number of events in polygon

In ArcGIS Desktop 10.5.1, I have a layer of XY events with a date field, and a layer of polygons. I have spatial joined the points so that each event is associated with a polygon. I want to show the ...
4
votes
1answer
439 views

ArcGIS Select By Attribute with join returning extra, incorrect features?

I am attempting to run a simple Select by Attribute on a large File Geodatabase feature class (1,751,339 polygons) in ArcMap 10.6, but the query returns extra, incorrect records along with the ...
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 ...
-1
votes
1answer
59 views

Create points on the line between speed limit signs near the road in ArcGIS [closed]

I have a road shapefile (lines) and and speed limit signs (points) near the roads. Now I want to create points on every 5m on the roads between these signs so every single created point should have a ...
1
vote
1answer
259 views

Joining attributes from start and end point to line feature in QGIS?

I have a line shapefile and a point shapefile that are start and end point of these line features. Now I want to join ALL attributes from both start and end points to the line shapefile. How do I do ...
1
vote
0answers
93 views

joining tables with different number of entries

I work in ArcGIS 10.3 and I have this problem: I have a dbf table of about 300 restaurants, each restaurant has a different values like address, number of seats etc. I have another dbf table of beers ...
0
votes
1answer
134 views

Obtaining attribute data at given GPS coordinates?

I have a csv file containing information at given lat and lon GPS coordinates, as well as a shapefile containing, among other things, annual average daily traffic (AADT) values along stretches of road ...
1
vote
1answer
90 views

Field format when saving joined layer from xls

If I perform a join of an xls file to a shapefile and then save it as another shapefile, my numeric fields from the xls are displayed with many decimal ceroes. Here is an example: The upper table is ...
-3
votes
1answer
25 views

Copy postal code to point shapefile

I have a layer with postal codes represented by polygons and another layer with points. I want to copy the postal code attribute to the points layer based on what postal code the point is in. Is ...
1
vote
1answer
348 views

Point in Polygon Add Polygon Value

I have a file of points with Easting and Northing. I have a 1km grid table. Both have the same projection and I can see in a map where the points are layered over the grid squares. What I need is to ...
2
votes
2answers
1k views

One-to-Many Spatial Join in QGIS

I am trying to join attributes from 2 shapefiles. 1 shapefile is a polygon layer indicating police precincts and the second is a point layer with crime statistics for each police station. The police ...
1
vote
0answers
251 views

Join multiple Points to Polygon and concatenate joined point values of column into Polygon column

My data: Points: ID HN Street 1 5 Examplestreet 2 6 Examplestreet 3 2 Otherstreet 4 2 Anotherstreet Polygons: Name Firstpolygon Secondpolygon Otherpolygon ...
0
votes
1answer
45 views

Spatial join of two polygon feature classes produces some <Null> values in ArcPy?

I have a two polygon feature classes stored in a geodatabase: Natural reserves and Forest cover. Using ArcGIS Desktop 10.4, I would like to subset National reserves where the forest covers more then ...
0
votes
1answer
251 views

Spatial Join based on Attribute Join?

I am working in ArcGIS Desktop 10.5.1 (Basic level). I have a point feature class and a polygon feature class. The point feature class has a field that contains either null or the ID of one of the ...
1
vote
1answer
208 views

Joining a table to a polygon using Esri Insights for ArcGIS

I am trying to perform a many to one join using Esri Insights for ArcGIS. With in Insights I am trying to join a flow and pressure table to a polygon. Esri Insights does not allow for spatial joins or ...
2
votes
1answer
229 views

How to join attributes of points with several overlapping polygons?

I am making a road atlas using QGIS, where the pages overlap: I would like the intersection of the roads and the edge of each atlas page (for example, Point A and Point B) to tell which pages you ...
0
votes
2answers
194 views

Using ArcPy to join feature class to Oracle Spatial View?

I am trying to join an Oracle table to a feature class but I keep getting the error "000339 : Input does not have OIDs." The view has a unique incrementing field already, but I am unsure how to ...
2
votes
1answer
40 views

Join from list with duplicates in list

I have a vector layer that i would like to join with a list. The problem is that my vactor layer does not hold any overlapping or dublicate objects, but my list does. The list does not have any ...
1
vote
0answers
41 views

ArcGIS Near equivalent in MySQL?

I am trying to replicate a process in MySQL that I have had been through in ArcGIS thereby using MySQL to set up an automated system for extracting future climate predictions from downscaled data to ...
-3
votes
1answer
55 views

Why do I have bunch of 'NULL's in the resulting 'join'…why is that? [closed]

Trying to join an Excel-table(.xls) - cleaned up - with a polygon shapefile. Getting a bunch of 'NULL' why this ? But validating the two aboove mentioned files go's without any error, all green ! ...
1
vote
1answer
91 views

Why does QGIS algorithm 'Join attributes table' change the types of the shapefile attributes?

In QGIS 2.18.9... I have a shapefile with two attributes 'ID' and 'POP', each of which is of the integer type. I have a CSV file loaded as a delimited, text-only table layer with two attributes 'ID' ...
4
votes
1answer
362 views

Seeing all existing joins in any MXD layer in one place?

I've got an MXD with about fifty layers, and I know there is a table that is joined to at least one, possibly more, of those layers. But I don't know which one :) I know I can easily look at a ...
1
vote
1answer
334 views

Using Join Table in ModelBuilder?

I want to create a workflow in ModelBuilder. The workflow I work on is this: first I create a fishnet on my land use raster's extent. Then I assign dominant land use classes on every grid as table ...
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 ...
7
votes
1answer
266 views

Select by Location and Join the Attributes of Two Line layers

I want to import the name of streets from OSM shapefile layer to another line layer based on neighborhood distance. The distances between two layers (line layers) are variable between 0 to 10 meter. ...
1
vote
0answers
139 views

Looping through data to perform one to many join in ArcPy?

I want to join the attribute tables of two feature classes in ArcGIS and populate the fields from one table to another. This is a one to many join and there are duplicate rows of data in the join ...
2
votes
2answers
104 views

Removing a joined layer using PyQGIS?

I have two layers that I want to remove using PyQGis as part of a larger script. The first layer I can removed using: QgsMapLayerRegistry.instance().removeMapLayer( shp.id() ) However, it seems that ...
1
vote
1answer
158 views

Pyqgis: How to take output from Qgs.ZonalStatistics and join by ID with point layer

What I'm trying to do: Extract median by a single polygon from multiple GeoTIFF rasters stored in a folder (Solved) Add each median value to a point shapefile (Match/join by: id column for each point ...
1
vote
1answer
3k views

Join Attributes by Location - Precision

What does "Precision" do within "Join Attributes by Location"? Also, what's the difference between the "Geometric Predicates"?
1
vote
0answers
927 views

Using “Join Attributes by Location” to perform spatial join of layer with joined data on dissolved layer

I'm relatively new to QGIS and have been using it for a project related to gerrymandering and electoral redistricting. My apologies if the question may seem a bit novice. I have two layers that I've ...
2
votes
2answers
991 views

Area of Intersection between two polygon files in QGIS

I'm new to mapping concepts and software. I need to report on the intersecting area of postcode polygons and NBN Rollout areas. So postcode 3000 has 3 units of area in rollout region 1 and 6 units of ...
2
votes
1answer
118 views

A column/attribute has a different length and precision than in the PDF output of the same table in QGIS

The fields populated by running my script have a different length and precision in QGIS, than what appears in the output of the attribute table with a PDF. I should also mention that before the output ...
2
votes
1answer
331 views

Unable to only include specific attributes/columns to be joined when joining attribute tables in QGIS with python

I'm having trouble using selecting specific fields that I want to include from one layer to be added to the target layer's attribute table when performing an attribute table join. The code runs ...
0
votes
1answer
222 views

Cannot calculate new values for an empty attribute using existing attributes in QGIS with python

I'm having difficulty in calculating the values for features in an empty attribute column by using existing values from other attribute columns in a joined table. For example, the feature 1 in ...
1
vote
0answers
42 views

Referencing an external editable CSV file in a spatialite base

I would like to join a CSV file attributes to multiple spatialite layers, but I would like to be able to edit the csv externally (export it from a different project on Excel or Numbers every time I ...