0
votes
0answers
30 views

How can I correctly delete a join from featurelayer using arcobjects?

If I create a join using ArcMap dialog definition query can be changed if joined layer contains a definition query. For example, layer A has definition query "A", layer B has definition query "B", ...
1
vote
1answer
76 views

Creating a Simple Join Script in Python

I'm trying to create a simple join script in python from an arcgis model, where the only steps are joining a map to a table to produce a map with the table's properties. The attributes joined ...
0
votes
0answers
15 views

Broken links after joining an .accdb with a .csv in ArcGIS 10.1

I have two sets of data: A "master" file of coordinates that has one row for each location, saved as a .csv file A table with information for each location but no coordinates, saved in an Access ...
0
votes
1answer
28 views

Joining Textfile to Shapefile Arc 10 and 10.2 Differences

I am trying to join a textfile generated in stata that includes caoname, caoid, and fips. The fips code should match to a shapefile county map that matches to the cntyidfp category. In ArcGIS 10.0, ...
0
votes
1answer
24 views

how to create a cloropleth world map in arcgis 10.2

I am new to arcgis and I am trying to create a cloropleth map to display ratio values for different countries. I believe that my basemap will need to have a country layer so that the shading of ...
0
votes
1answer
35 views

Join by attribute when unique identifier has multiple rows using ArcMap 10.2?

I would like to join the attributes of one polygon layer to another polygon layer by their common ID. The problem is that in layer A, each ID has multiple rows, because each represent shapes from the ...
0
votes
1answer
52 views

Can anybody help me with Spatial Join in ArcGIS 10?

I have a doubt, I do not find what's happening. Screenshot: Using the Join (Join data from another layer based on spatial location) I have done an Spatial Join by location, and it is said that the ...
0
votes
2answers
49 views

Joining two polygon layers based on distance?

I'm new to GIS so this question may be an obvious one. I have one polygon layer of urban land use and another polygon layer of swamps. How do I join the two layers so that I get a column in the ...
1
vote
1answer
44 views

Modelbuilder - Join - Keep matching records only - export to feature class

I need to join a table to a feature class in a model. Have it keep only the matching records and then export that joined feature class into a new feature class.
0
votes
1answer
35 views

Creating a New Shapefile from Joined Access Table

I'm dealing with a very large amount of polygons. Once I join the land use access table to the parcel shapefile, it takes forever for Arc to draw the polygons. I'm trying to select all residential ...
0
votes
0answers
54 views

In ArcGIS, how to automatically recalculate a calculation if I modify the Excel data source?

There's a database with buildings. Each of them has a few parameters, for example building type codes. In a distinct table each building type codes has 4 attributes. During the Join, the datas will ...
0
votes
1answer
37 views

Trouble joining table in arcgis. Joining field is 'greyed out'

I'm trying to join a shape file with a excel file I converted into a CSV. I had done this before with the same shape file but with a different CSV but this time when I try to select the column it's ...
3
votes
1answer
45 views

Coloring of features in ArcMap 10.1 changes randomly while zooming

I am using the sovereign states shapefile (ne_110m_admin_0_countries.zip) from http://www.naturalearthdata.com/ and joined the attributes with a spreadsheet file that codes many (but not all) country ...
0
votes
0answers
57 views

How to create a many to one spatial join?

I have a polygon feature class of territories and a point feature class of trees. The points have many attributes, one of them is the tree species name. I need to get the list of all the tree species ...
0
votes
1answer
71 views

Python field calc syntax error

The screenshot shows a calculate field tool in modelbuilder. The error I'm getting is invalid syntax line 1. I can't see any issues w/the syntax so I'm hoping someone out there can help. It ...
4
votes
2answers
225 views

Spatial join - many to one

I'm trying to do a spatial join that takes the attributes of multiple polygons and applies them to a single polygon in another layer. The data is currently in a geodatabase, but can be exported to shp ...
0
votes
1answer
85 views

arcgis - updating joined excel file when adding a new sheet

When adding a new sheet to a joined Excel file in ArcGIS, the new sheet will not show till I exit both arcgis and excel. Is there a better way to update the connection...? edit: sorry for the delay ...
3
votes
2answers
136 views

Arcgis not seeing my column header to join tables

I am trying to join a data table to the attribute table of a shapefile. I have done all the necessary steps to makes sure it works: removed spaces, not use numbers in column headers, remove illegal ...
1
vote
0answers
46 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
2answers
431 views

Fastest way to Join tables in python automation

My issue comes form the fact that doing Joins manually is actually relatively quick (5mins), but python automation of this process is 6hrs! Here is my code: import arcpy GDB_MARK_TO_MARK_VECTOR_VIEW ...
2
votes
1answer
49 views

Can ArcGIS make a join with selected attributes being added into the outcome?

My question is when making a spatial join, is it possible to only assign selected attributes of source layer to the target layer instead of getting all attributes from source layer? I'm asking is ...
1
vote
0answers
42 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 ...
0
votes
1answer
53 views

Using JOIN TOOL in ModelBuilder

I want to perform JOIN TOOL for all DBFs generated from ZONAL STATISTICS AS TABLE into one table. However, it seems that DBF has a maximum of 255 fields while my dataset has more than 500 ...
0
votes
2answers
223 views

Problem with adding new field to attribute table after performing join by attributes

I am studying ArcMap 10.2 and concentrates on different join operations. I am working on a Personal Geodatabase. I have digitized some polygons from a raster representing houses and have created a ...
6
votes
1answer
77 views

Is there maximum number of .DBFs that can be joined using ModelBuilder?

Is there a maximum number of .DBFs that can be joined using the Join Tool in ModelBuilder? I tried joining 480 .DBFs but results generated only 250 fields in the input table. Is this a glitch? I am ...
1
vote
4answers
155 views

Joining shapefile table with csv

So I am having a shapefile with all the world countries. And the table for this shapefile has a column named "Country Name". Each of this entry is unique, meaning, each country takes only 1 row, and ...
0
votes
2answers
135 views

How to permanently join MDB database (access) table with spatial data in ArcGIS for Desktop?

I have an Access file (*.mdb), and I want to join between this attribute data with its spatial data ? But other than (join & relate way) . And I need it to be permanent .
1
vote
0answers
50 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. ...
0
votes
1answer
659 views

Problem adding a join to a table via Python using addJoin_management

I am currently building a script for a script tool that will join data from a multitude of tables into a single table based on a common join field. Now, I have attempted to use ...
0
votes
1answer
60 views

AddJoin_management crashes ArcMap

I am going to be using an AddJoin_management command in a python script at the end of several loops. To test, I used the AddJoin tool and use the below command in the Python window and made the ...
3
votes
1answer
691 views

Creating a spatial “Many to one” join

I'm trying to create what I call a "many to one" join. I don't know if that would be the correct term or not. I have a table that has unique account numbers for mobile homes (i.e. - M1007970) per ...
2
votes
1answer
151 views

Joining Multiple Features to One Feature

I have two layers - an index layer (polygon) and a town boundary layer (polygon). The desired output is a FC with each town represented as only one feature and that FC's table having a field with ...
7
votes
5answers
472 views

How to programatically identify the “Joined Field” in ArcMap?

Is it possible to programmatically identify the Join Field that is being used to Table Join two datasets together in ArcMap? I am currently using ArcGIS 10.0, SP5 and would prefer an ArcPy solution, ...
0
votes
1answer
67 views

Why is ArcGIS for Desktop not joining records when values have dot (.) in text string?

ArcGIS is not joining records from a table that have a dot (.) in the text string. Has anyone else come across this problem? Is it a known issue?
1
vote
1answer
1k views

Join Fields from Multiple Tables to One Table in Modelbuilder

I have 40 tables with about 2000 row with a shared ID that I want to merge into 1 table with 2000 rows. I only want to retain a distance field calculated within each table. The distance field is ...
2
votes
2answers
390 views

Why does ArcMap crash if I try this Join Field (which ArcPy does not like either)?

I'm a little uncertain whether this question belongs here or on http://gis.stackexchange.com Have an "AddJoin" that results in no shared records, which is not what I'm expecting. Is it because I'm ...
6
votes
2answers
137 views

How to enumerate join values with ArcGIS?

I have two shape files (e.g. postal code areas and cities) which I want to join based on an id that both shape files have in common (the id would be the city name in this example). Joining the two ...
0
votes
0answers
38 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
70 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 ...
2
votes
2answers
1k views

Creating non-spatial Many to One Joins/Relationships between tables

I may have missed a trick here but I can't seem to find a solution. I have a table of ~1.6 million postcodes, also containing co-ordinates, and a separate file detailing ~6000 a population with ...
0
votes
0answers
148 views

MS Access join table values, not recognized by ArcGIS symbology

I joined a MS Access database table to a GIS file. When I try to use symbology (categories) to represent a yes/no value which is in the table file (0/-1) it does not recognize it as a value.
7
votes
4answers
2k views

How to close multipart polyline gaps in ArcMap

I have a multiple multipart contour lines that originally came from CAD drawing. I converted these into a polyline shapefile in ArcGIS. The issue I have is with gap in each contour lines that are ...
4
votes
1answer
384 views

How to join fields which must still be created in ArcGIS Model Builder?

I am in the process of creating a generic model in ArcGIS Model Builder. At one point in my model, I have to do a join between an existing layer (entry parameter) and a table issued from the "Zonal ...
1
vote
0answers
666 views

arcpy spatial join input parameter problems [closed]

Using ArcGIS 10 SP4 with all extensions... I have a parent directory (J:\...\spatialjoin) containing two sub-directories of feature classes I want to spatially join. Directory 1 (target features) ...
3
votes
8answers
16k views

Having problems with joining an excel table to a shapefile in ArcMap

I have a shapefile of lower layer super output areas (LSOA) for England and Wales and I have a spreadsheet of the indices of deprivation for each of the LSOA's in England. I want to join the ...