2
votes
1answer
44 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
192 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
35 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
39 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
36 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
63 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
38 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
58 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
75 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
64 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
48 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
78 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
60 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
99 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
1answer
105 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
86 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
138 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
218 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
279 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
53 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
83 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
55 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
125 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
280 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
243 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
171 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
142 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
46 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
533 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
130 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
464 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
51 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
942 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
314 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
722 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 ...
1
vote
1answer
165 views

Software program (or spreadsheet calculations) to find Borehole Deviation?

I was given a bunch of surveyed borehole data (azimuth, depth, dip, geology, etc) and am required to calculate a deviation variable. Besides querying the data and averaging the surveyed borehole ...
1
vote
2answers
107 views

Help excel table not transferring to Arc correctly!

New to GIS and Ive been trying to figure this out for a while. I have an excel sheet with CT names such as 0128.03, 0128.04, starting from 0001.00 and up. Not all CTs have .01, .02 at the end just ...
0
votes
0answers
35 views

EM (electromagnetic) map to AWC (available water holding capacity) map

How do you use an equation from a regression analysis from Microsoft Excel to create a new available water holding capacity (AWC) map from an electromagnetic (EM) map. They are both to be in raster ...
0
votes
5answers
2k views

Changing null value to specific numbers in ArcGIS for Desktop? [closed]

I have a Excel file showing annual precipitation and I add it on arcmap. When I tried to check it's attribute table the field calculator is passive. I want to change all the Null value to specific ...
15
votes
5answers
1k views

How to make a GIS inventory?

My office will be seeing a big change in its GIS section. This section has been operational since the 1980's and has a huge collection of GIS data (i.e., shapefiles, raster files, data, etc) but never ...
4
votes
5answers
6k views

How to export attribute table to Excel using ArcGIS Desktop? [duplicate]

In previous versions I could just export as a .DBF file, open it with Excel and then convert it to an Excel file. However, now in ArcGIS 9.3.1 the .DBF file can no longer be open by Excel. I have also ...
3
votes
1answer
805 views

How to change data type in Excel file before creating feature class?

I am trying to import data from Excel spreadsheets where each point coordinate has a 'datetime' timestamp (e.g. "2012-06-01 14:45:32") associated to it. When I check the table properties ArcGIS 10 ...
5
votes
3answers
1k views

Saving *.dbf as *.xls using Python?

i've been let loose in the workplace to learn python to do things in Arcmap10. so, i've learning python as i go and trying to remember the programming i have done. where i am in this project is ...
3
votes
8answers
17k 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 ...
7
votes
4answers
36k views

Export table from ArcGis to Excel file

Is there a way to export a table with selected records to an Excel spreadsheet? I was trying to export just to .txt file but ArcGIS gives me an error message. The other problem I have is with ...