The process of connecting two or more datasets based on a common attribute or spatial location.

learn more… | top users | synonyms

3
votes
0answers
27 views

Optimisation of MySQL JOIN based on a Within match

I have a table of points and boundaries, and am trying to add the boundary ID which a point is within. However, using a LEFT JOIN ON Within(location, boundary) it is taking about 3.5 hours match ...
3
votes
0answers
220 views

Startup python script to re-join layers in QGIS?

In QGIS 2.2, there is a bug which involves using the JOINS properties on a vector layer (that is already being joined with several other vector layers) whereby the attributes are not fully loaded. ...
3
votes
0answers
54 views

Adjacent DEM files have narrow triangular gaps when joined

Newbie here. I've downloaded several DEM files from GeoCommunity which correspond to adjacent regions. When I join them together to form a larger relief map there are triangular 'gaps' on all four ...
3
votes
0answers
958 views

How to join data from a CSV to a shapefile using QGIS

I'm new to GIS and new to StackedExchange. I need help joining a CSV of Accessibility data to a LSOA shapefile in QGIS. The process explained here does not work for me and I don't know why. The ...
2
votes
0answers
87 views

How to automate calculation of distance between a zip code (centroid) and an address within one line of data?

I have a large data set of federal contracts which includes two pieces of spatial data per entry (or line): the zip code in which the project took place and the address of the contractor. I am ...
2
votes
0answers
50 views

Making Large Data Sets Faster in ArcGIS Online or Portal

I have a sql view joined to a parcel layer for the entire city of New York (over 800k records). All data is registered to to the arcgis server. As you could imagine, this produces very slow response ...
2
votes
0answers
41 views

Can joined tables be served by QGIS Server WFS?

I'm trying to figure out whether it's just me, or if I'm forgetting a setting. I have a shapefile which I make available for WFS-requests. Now I added a join (to a MySQL table). I tried playing ...
2
votes
0answers
295 views

Create a non spatial index on an attribute in QGIS before joining two layers

I’m using QGIS 2.0.1 on Windows 7. I’m trying to join a .dbf which contains no spatial data to a shape file containing spatial data. Ideally I’d like to create an attribute index on the join field in ...
2
votes
0answers
208 views

Joining nearest neighbor small polygons using R

The figure shows a plot of numerous polygons (zoom in) made from a raster file by require(sp) require(raster) pol100 <- rasterToPolygons(r, fun=function(x){x==1}, dissolve=FALSE) There polygon ...
2
votes
0answers
124 views

QGIS - How to avoid -2147483648 value from imported CSV?

I am attempting to join a spreadsheet containing all the CIA Factbook Country Comparison Data (many columns) to the existing Natural Earth world countries shapefile. I followd the tutorial here, but ...
2
votes
0answers
2k views

QGIS: After performing a table join, all the fields are “NULL”

Within QGIS, I joined .dbf table containing population data to a shapefile of Census tracts. The join field is called GISJOIN in both the target table and the shapefile's table, and this attribute ...
2
votes
0answers
76 views

How to join two fields after calculating?

I have been working with two layers and I am trying to join them and turn them into a raster data. The first layer is a watershed layer which I have assigned each shed a location from the center point ...
2
votes
0answers
418 views

ArcObjects : How to change layers connection properties without losing joins

I'm using arcObjects 9.2.6 java librairies to change connection/path properties within a java prog. This prog aims to change path and connection properties for all layers of an mxd file. It works well ...
1
vote
0answers
40 views

Polygons get lost when doing Join attributes by location

I am trying to do the operation "Join attributes by location" in QGIS. I have a point layer and a few polygon layers, all of them in shapefile format. I want to sum the values of the attributes of the ...
1
vote
0answers
18 views

“undo” pivot table with ArcGIS ModelBuilder?

I have a table in a geodatabase with an ID and a text field for each day of a week. The text fields contains 0 or 1 for monday, 0 or 2 for tuesday, and so on. One ID can have multiple day entries, so ...
1
vote
0answers
13 views

QGIS .shp joined to xlsx.vrt; Classify works, Rule-based does not

Very simple set up. Tiger .shp file as a layer. Has a join to an xlsx non geo attribute table as a .vrt .shp has join on MTFCC to MTFCC in xlsx.vrt. xlsx.vrt, has a string field with a brief label ...
1
vote
0answers
60 views

Add join works, join field doesn't

My input join field and output join field are text type, and my problem is that when I use "Add Join" all joins ok, but if I want to use "Join field" there are some records with Null, it seems like it ...
1
vote
0answers
27 views

How to avoid field duplication when joining two vector layers?

I have 2 point vector layers wich differ in 2 fields while both of them have the same number of fields (10). What I want to do is produce a new point vector layer with 12 fields. When I join the two ...
1
vote
0answers
27 views

listing existing joins in table of contents feature

I am looking for a way to use python in ArcGIS desktop to check and print out the joins that exist between tables and feature classes in my map rather than right-clicking, going to joins and relates ...
1
vote
0answers
63 views

How to show two layers at the same time in Qgis

I have a question about Qgis layers. I want to see two layers at the same times. one is lines which are boundary lines and the other is polygon which are district. when i was surfing about this ...
1
vote
0answers
28 views

Join tables in QGis 2.01. Dufour

I performed a "join" going to the properties option in a shapefile (in this case is just a table), in order to join the attributes from another shapefile that has a field in common, specifically ...
1
vote
0answers
38 views

Nearest neighbour / spatial join with attribute condition

I have 2 point format datasets I wish to schematically join (manholes & gullies). I am content that I can join them by nearest proximity alone using e.g. NNJoin plugin. What I would like to do ...
1
vote
0answers
44 views

Can I define a style for one layer, taking into account a defined relationship with another? (QGIS 2.8)

I have two sets of data. A large set of lines with a line_ref field, and a small data-only (no geometry) table with a matching line_ref field (let's say for argument's sake that the data-only table ...
1
vote
0answers
91 views

Using the QGIS Graphical Modeller how can I choose specific fields to make a join based on?

I wish to join one field from a shapefile to another shapefile within the QGIS graphical modeler. I am aware that there is a 'Join attributes table' algorithm but this joins all of the fields from the ...
1
vote
0answers
301 views

Joining to data in ArcGIS Online

I'm a GIS professional. One of my clients (an ArcMap user) has asked our firm to teach some of his staff about ArcGIS online. In so doing, we are to provide an overview of GIS-- how to think ...
1
vote
0answers
64 views

Saving fields after a raster join with python arcgis

I am working on a raster processing script in which i join a categorical raster with a table that includes some extra data on each category. After much hassle, I have the join working, but I can't ...
1
vote
0answers
20 views

Join a table to a pre-joined field in QGIS

I'm trying to join a .csv (X) to a .shp layer (Y), but X and Y don't share an ID field. Another .csv, Z, has TWO ID fields--one shared with X and one shared with Y. In any other language, I'd first ...
1
vote
0answers
14 views

Editing the configuration of a join in QGIS

Is there any way to edit the conditions of an existing join in QGIS? I have a .csv joined to a (polygon) .shp layer; because I only needed a few fields from the .csv, I only joined those I needed. ...
1
vote
0answers
74 views

Fastest method to join a lot of tables

i have a lot of feature class (see figure 1) the objective is to create one feature class that combines the attribute table (especially one field) of each feature class the attribute table of each ...
1
vote
0answers
211 views

Can Virtual Fields be used for a rendering style?

In QGIS 2.6, creating a virtual field for a layer and adding up 2 integer fields work fine. I get the correct results and I can use that field for styling. However, when doing a Joins with 2 layers ...
1
vote
0answers
33 views

Time not configuring correctly?

I'm trying to match data in a textfile that contains time, value, and fips code to the cntyidfp part of a map of US counties. However, even though I am able to match the two sets of data together, ...
1
vote
0answers
55 views

Join does not return matching records after 1001 records have been successfully joined

I'm working on a process that joins a feature layer to another feature class. The code is as follows: arcpy.MakeFeatureLayer_management ("New_FC", "newFC_layer") ...
1
vote
0answers
85 views

Categorized style hiding map

I am having an issue with the style properties of my map. I imported the US Zip Code Tabulation Area map from a government website, and in a separate excel file I have a list of people connected to ...
1
vote
0answers
267 views

Join operation does not return any matching records if the join table contains “coded value domains”

I have a point feature class and performed a join operation against a destination table with two fields containing coded value domains defined in the same file geodatabase. Another field called ...
1
vote
0answers
65 views

How to create a 1:n join and concatenate text attributes?

I have 2 polygon layers A and B. I would like to join the attributes from B into A for all the polygons from B that intersect A and for text attributes, i would like them concatenate. But apparently ...
1
vote
0answers
94 views

Record Set (Recordset) for Join in ModelBuilder

I am trying to use a recordset to develop a Table View to use to join to a feature layer in model builder. I can export the table view directly with the user input included. However, when I attempt to ...
1
vote
0answers
99 views

How to repair a data source with joins to Excel?

I have a set of MXD files, that do not use relative paths, and related data that have been copied to a new computer. Normally it's not a big problem to repair the data sources in the project, but in ...
1
vote
0answers
116 views

Joining Data in ArcMap Errors

Has anybody encountered issues with ArcMap when joining data? Specifically, my rows join, however, depending on how ArcMap is feeling, I might or might not receive my data in the form of quantities. ...
1
vote
0answers
342 views

Quering a ArcSDE featureclass attribute table after joining

I am trying to query a ArcSDE Feature Class after joining using Iqueryfilter I have two SDE feature classes. 1) Subdivisions : which has details of subdivision and districts (parent) 2) ...
1
vote
0answers
158 views

Join .csv file and .shp of georeferenced points

I have georeferenced a map and saved a selection of some points on the map. These points are cities of departure and arrival and I want to join the .shp with a and excel .csv with the information of ...
1
vote
0answers
87 views

Join field from table to a raster layer

I'm trying to join a field in a table to a raster layer. I'm using the tool 'Join Field'. The table is in a excel sheet, but have been imported to a file geodatabase. The table has an ObjectID field ...
1
vote
0answers
361 views

In ArcGis 10, spatial join of a hot street value to a fishnet cell is counting multiple values for same street segment

So, I am working on a fishnet, so that we can attribute multiple values to points within different cells (i.e., ranking light poles as optimum for traffic cameras based on the number of speeding ...
1
vote
0answers
569 views

Should Delete Field work in ModelBuilder while there is a Join present that appears unrelated?

I am having an issue with a very simple Model, both in ArcGIS 9.3 and ArcGIS 10.0. The part of the Model that is causing trouble is shown below, along with ModelBuilder's error message (in ArcGIS ...
0
votes
0answers
16 views

One to Many link that can be queried

I'm at my wits end, having looked through a number of posts and tried several options. At this point I'm just looking for confirmation that I cannot do what I am trying to do without ArcGIS or using a ...
0
votes
0answers
32 views

Multiple join of Access data with ArcGIS shapefile

I am looking for a solution for joining constantly modificated data to my shapefile. The shapefile consists of polygons. Each one has a code. In the Access database, I have varias colums for one code ...
0
votes
0answers
30 views

Preserving Reclassified Values as Attributes?

What is the BEST way to preserve original raster values as attributes in the output raster when reclassifying? I see that this question has been asked before as Making reclassified raster layers ...
0
votes
0answers
36 views

Convert raster to polygon then join attributes

I'm trying to convert IMG files to shapefiles, then joining the attributes of the IMG file to the new shapefile. I got the conversion part to work, but am a stuck on how to join the tables. I have ...
0
votes
0answers
16 views

(non spatial) One to one join and keeping all data

I have a set of over 20,000 villages in xls that only have a ward assigned to them - no coordinate. I do have a ward shapefile. Now I have created a data set of random points (shp) and spatially ...
0
votes
0answers
47 views

Using Join with a Raster File

I would like to add a new field to a raster file. Then, I would like to add the new field content. Can I do this with a join of attributes? I know that a raster file can be reclassed. But there ...
0
votes
0answers
23 views

Fail in searches on the joined table data

When a table is joined to a standalone table, the searches on the joined table data return a fail. Is there another way to solve this inconvenient without save the layer with joined table under a new ...