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

learn more… | top users | synonyms

4
votes
0answers
51 views

Using one to many join to *.xlsx in ArcGIS Desktop?

I'm working with ArcMap 10 and have some trouble joining a shapefile and a .xlsx file. The .xlsx contains sensor data (CO2, NO2 etc.) without location information. The shapefile contains all the ...
3
votes
0answers
29 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
56 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
977 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
36 views

Unable to add feature class based on database view in ArcMap

To solve Rendering features based on relationships using ArcGIS for Server?, we created a view in the database that joins the two tables together. That works fine. I see the feature class in ...
2
votes
0answers
127 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
61 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
42 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
341 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
233 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
77 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
432 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
17 views

CartoDB geom (coordinates) join: without exact match

Trying to join two datasets (layers) on CartoDB based on their geographical fields (in CartoDB's the_geom created field). However, the basic ST_Intersection function does not work since its tolerance ...
1
vote
0answers
17 views

Expression Within ModelBuilder?

In ArcMap I add 2 tables, join on a field then run an attribute query to return any of the joined tables records that are not null in a particular field - all works OK. I would like to build this ...
1
vote
0answers
45 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
21 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
15 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
104 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
28 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
80 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
46 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
57 views

Export Joined table an Feature layer based on a query

I have a table and a layer joined fine, I am trying to export the end result into a file geodatabase, the export is fine if I specify specific name, other than that it exports the original layer data. ...
1
vote
0answers
45 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
393 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
76 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
21 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
76 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
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
58 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
90 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
325 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
66 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
102 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
106 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
132 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
372 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
171 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
43 views

multiple data atach with shape file in GIS-regarding

I have different sampling data of one location that is a point so, multiple data how to join with single point. after joining i need quries by select attribute in GIS.
1
vote
0answers
92 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
364 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
605 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
34 views

Updating attribute data based on another layer and key field?

I currently have two polygon layers (one building layer and one property layer). The information for the property layer is updated and supplied by an external source. In the building layer, I use a ...
0
votes
0answers
27 views

Add Join issue with ModelBuilder?

I am trying to do a simple Add Join within ModelBuilder but it keeps throwing the 99999 error. What is going wrong? I have even tried to create a Table View for the table I am joining to a feature ...
0
votes
0answers
17 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
52 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
34 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 ...