2
votes
5answers
102 views

Unable to export data to ShapeFile in ArcGIS

I've imported an Excel sheet into my ArcGIS project but am unable to convert this to a ShapeFile. When I try, via export data, I get an error message saying either 'output name is not valid', whatever ...
1
vote
2answers
37 views

Creating Shapefile from Excel Data

I have an Excel file with three columns, IncidentID, Latitude, and Longitude. Each row in the file corresponds to an incident and the location of the incident in units of decimal degrees. I also ...
3
votes
2answers
117 views

How to map tabular data based on city/province name?

I am very new to GIS and ArcGIS so would appreciate any advice/help. I have an Excel file containing data on cities (only names) and provinces (of those cities) for 158 countries around the world. ...
1
vote
1answer
11 views

Error 001156. increasing the length of text limit [duplicate]

I'm fairly new to ArcGIS for Desktop and i want to import my excel table to my personal gdb but i end up getting an error code:001156 and my import fails. I soon found out that it was the lengthy ...
0
votes
1answer
27 views

Data refusing to line up with basemap after re-setting source for data

I've only been using GIS for a couple of months so this is probably just a really n00b problem but I cannot for the life of me fix it. The other day I managed, with a lot of finagling, to create a ...
2
votes
0answers
46 views

Calculating Distances between coordinates

I have perused through the other questions that are very similar to mine but am still having some trouble. I have 75 coordinates in WGS84 that I brought in from an Excel table. They are now on my ...
0
votes
1answer
28 views

Table to dBase tool failure when converting .xls files

Whenever I load my Excel 2010 worksheets into ArcMap 10 Table to dBASE tool, it fails, returning the error: "Failed to Copy Rows" The Copy Rows tool works just fine for me on a single document. There ...
1
vote
0answers
70 views

Adding information from excel into ArcGIS [closed]

I am working in ArcGIS and have a excel sheet with data pertaining to properties. I want to add this data to a map in ArcGIS of which i have property boundaries as a shapefile? I have a common folio ...
1
vote
0answers
22 views

One to Many relation in ArcGIS for Desktop?

I'm working on ArcMap, and I have a one to many relation between a building column and the residents in the building. The attribute table for the building has these columns: id,label,number. I ...
0
votes
0answers
56 views

calculating decimal degrees from coordinates found in an excel table

What is the exact syntax to use when calculating decimal degrees in the field calculator? I know the general formula {i.e. Degree + (minute/60) + (second/3600)} but how do I put this into the gis? I ...
2
votes
1answer
32 views

Atributing fields in arcmap and excel

How do I populate a field in ArcMap (and Excel) with only a specific part of another field's attributes? For example: I want to populate the LATDEG field with only the degree part of a latitudinal ...
1
vote
1answer
49 views

Can I batch import attribute tables into existing excel spreadsheets

I am using arcGIS 10.2 and I need to import the attribute tables of 100 layers into existing excel spreadsheets which will make graphs based on the values in the attribute tables. Doing this ...
1
vote
2answers
43 views

Changing field type of Excel attribute table for a Join

I have a string field type of shapefile already in ArcMap. I need to import an excel file in and join with the shapefile. The only problem is the field type of the shapefile is a String and the field ...
-1
votes
2answers
47 views

Adding an excel database to an existing shapefile [duplicate]

I have a spreadsheet with various feature data; I would like to add this data to an existing shapefile. I have a common column in both the shapefile and the excel data. I would like to be able to ...
2
votes
1answer
61 views

Randomly choosing one from multiple fields in Field Calculator of ArcGIS for Desktop?

Using the Field Calculator in ArcGIS for Desktop, I want to randomly choose one field from a list of 10 fields (strings). The Excel equivalent, which is working, is: =INDEX(A2:J2;rnd()*10+1). How ...
-2
votes
1answer
256 views

Creating a python script to import an excel spreadsheet, create shapefile and do some analysis [closed]

I am trying to write a script that does the following. Imports an xls file containing x, y, and other columns with data. I want to make this into a point shape file. I want to take that point ...
1
vote
0answers
37 views

Segmenting road from Excel spreadsheet based on specified distance? [closed]

I have created a model that turns an excel spreadsheet containing coordinates into a Kml/Kmz file of a road that is segmented based on the X_from,X_to,Y_from,Y_to Columns, and the image below ...
1
vote
1answer
48 views

How to count the number of entries a user has selected in a multivalue field of a tool dialogue using Python and ArcGIS 10.2.1

I am currently creating a script that will read data in one (to many) Excel spreadsheet(s) and would like to know how to get a count of the number of spreadsheets entered by the user. The script will ...
1
vote
1answer
42 views

Can X-Ray for ArcCatalog be used without Excel?

Can X-Ray for ArcCatalog be used without Excel? Our organization went with Libre Office as a budget savings move. Calc in that suite can read/write .xls files, but X-Ray appears to require Excel ...
1
vote
0answers
74 views

Batch Zonal Statistics to Spreadsheets?

I have a pretty immense amount of Zonal Statistics as Table computations to do, and would love to find a way to grab mean and variance values from the little .dbf tables ArcGIS creates and put them ...
0
votes
2answers
51 views

excel column does not appear when doing join after doing modification to the column

Using ArcGIS 10.1 I am trying to add " /1 " my column provided Shp File how it appears in the county supplied excel spreadsheet under "parcel #" 43002/1 18524/1 1666/1 4270/1 Currently, the county ...
0
votes
0answers
64 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
112 views

Street index to CSV/Excel file

Anyone know how to generate a street index for a map with accompnaying page numbers that are data driven? I am use the toolbox for creating the street index but exports to PDF however I need it to be ...
0
votes
2answers
79 views

How to Convert Interpolated Map to Excel using ArcGIS for Desktop?

I have interpolated some SO2 data using IDW and have calculated means on county level using Zonal Statistics. I would like to convert this data now into an excel file. I already got the hint, that I ...
0
votes
1answer
60 views

Hand-written coordinates from a Garmin NUVI

I've been asked to map point data that was collected in the field by manually writing down the coordinate from a Garmin NUVI 1490 LMT. They were put into a spreadsheet and sent my way which I was ...
0
votes
1answer
89 views

Help in importing excel data

I have downloaded the hourly solar radiation data from NREL which is in CSV format but the problem is that the file does not have an exclusive column called latitude and longitude. There are 100s of ...
2
votes
1answer
70 views

Problem adding dates into an existing feature class from an excel spreadsheet [closed]

I've been trying to load data from an excel spreadsheet into existing feature classes, but I've been having some trouble with the dates. I've written a script that compares the values in the ...
2
votes
2answers
118 views

ArcMap's Join and symbology

I'm still new into the GIS World, and here's what i'm trying to achieve , i have Yemen administrative shapfile with list of governments, and districts,i also have an excel file with a list of migrants ...
0
votes
2answers
223 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 ...
0
votes
0answers
100 views

Creating Cluster “Zones”

I've looked at the "Questions that may already have my answer" and it didn't appear that the questions were specific to my questions. Although I am sure I am not uncovering some brand new quetsion ...
3
votes
1answer
161 views

Is there a method to write feature class attributes and counts to an excel workbook in Python? [closed]

I have a feature class with 3 fields that I would like to reference later in an excel workbook. They are all represented in 3 different maps. Essentially, I would like to show the the attribute ...
0
votes
1answer
299 views

Adding and Editing Excel table to the data frame

I have few excel tables of almost 5-6 columns and i need to paste them at different locations in the same map. The values in the excel table gets revised every quarter and i need to edit the table. ...
2
votes
2answers
427 views

Issue on Generating Points Shapefile From An Excel File with X Y Values

Using ArcGIS 10.2, I have an Excel file (Please review attached zipped Excel file) from which I am able to Generate Points by using the "Add XY Data". The points are generated on the map (using ...
-1
votes
1answer
54 views

Where did my points go?

I had an excel file marking points on my map. I then added a base map and my points are gone. Even with the base map layer turned off the points do not show. I tried reordering the layers and tried ...
3
votes
1answer
106 views

How to export layer attribute table to specific worksheet of already existing Excel workbook?

How to export a feature layer attribute table to a specific worksheet of an already existing Excel workbook?
0
votes
0answers
72 views

When doing table to table conversion, a text field gets converted to Blob type

I have one field that keeps getting converted to Blob type after conversion using table to table tool. The field is mostly text and fairly lengthy, maybe 250 ish characters. Is the length of the field ...
0
votes
1answer
168 views

Update the layout excel file automatically when the attribute table chnages in arcmap

I am trying to put an excel table in arcmap layout where this table includes some statistics over one of the Features Attribute table. This Feature is going to be updated regularly and consequently ...
2
votes
1answer
378 views

How to export Select By Location result to Excel using Python and ArcPy?

I have been using ArcGIS for a few years now but have only started using Python scripting for ArcGIS for a month or so. I am trying to create a script and I am having a hard time trying to get it to ...
9
votes
2answers
273 views

Can ArcGIS ModelBuilder open Excel file for manual editing, then feed those edits back into model?

I have been tasked with creating a model using ArcGIS ModelBuilder, that initially runs a couple of geoprocessing tasks, before then joining an Excel table to the result of those geoprocesses. ...
6
votes
1answer
202 views

How to call arcpy.RefreshActiveView() every 5 seconds using ArcGIS Python?

I have an Excel macro that generates random values after every 5 secs and I am reading it in ArcGIS for Desktop... to refresh the view I have to press f5 and the view gets updated. Now I want to ...
6
votes
1answer
171 views

Pull Data from Specific Excel Cell into ArcPy

I am new to Python and ArcPy, and wish to create a short script that pulls in a value from one specific Excel worksheet cell (namely, A2) and then performs an 'if' statement, whereby if the value of ...
1
vote
0answers
61 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
1answer
742 views

Error exporting attribute table in ArcMap to Excel

I try to export an attribute (and dbf) table from ArcMap10 to txt file, but the program gives "An error occurred exporting the table" I checked all others types of exporting - all give the same, ...
0
votes
1answer
150 views

Import raster into ArcGIS

I received raster data from a grid of 1100 by 1000 meters with a resolution of 1 meter. It is the output of EFC-400 software showing the field strength around power lines. The data is currently in ...
5
votes
1answer
639 views

ArcGIS modelbuilder: Iterate through Excel sheets?

I am trying to use modelbuilder (ArcGIS 10.1) to add XY data to ArcGIS, then export the events as Feature Classes. The data comes in one xlsx document with a large number of sheets, each with an X and ...
4
votes
7answers
2k views

What is the best way to change a data type in the ArcGIS attribute table?

What is the easiest way to change the data type in an attribute table in ArcGIS for multiple fields? Say if the fields have been exported as a string from Excel and I would like to use them as ...
1
vote
0answers
59 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
1k views

How to extract polygon location data (County) to a point shapefile (only has DMS)

I have imported an excel spreadsheet to my map and the points have fallen into certain locations. How do I add the location of the polygon that the point has landed in, to the attributes table of the ...
5
votes
1answer
341 views

Translate Excel formula to be used in field calculator

I have a series of equations to create corner points to make rotated polygons based on angles in the attribute table, but I have created it in excel and can't figure out the syntax to get it to work ...
0
votes
2answers
814 views

How to export data from DBF to Excel template using ModelBuilder?

I have created a model in ModelBuilder that uses the iterator tool to run through a polygon layer and clip a raster based on the polygon's unique name in the attribute table. The model then copies the ...