Tagged Questions

1
vote
2answers
67 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
1answer
49 views

ArcGIS Statistics tool problem

I have an excel file for average rainfall by month and I added that on ArcMap. while I tried to check the statistics the tool is passive for last 3 months and I checked the data on arcmap, they are ...
5
votes
2answers
396 views

Importing attributes from Excel file into new Polygons

I have a constantly updated Excel file containing address information which I am currently copying into the attributes of new polygons which I am creating on a daily basis. I am currently doing this ...
3
votes
1answer
342 views

Why are the results from the same data different in ArcGIS vs MS Excel?

I have done some interpolation in Geostatistical Analyst in ArcGIS and I got the Standard Deviation (SD) a bit different from the SD that I calculated in Excel Spreadsheet. What algorithm does each ...
1
vote
1answer
196 views

ArcPy: Creating weekly-sum layers by summing field values from seven consecutive daily .dbf's

So I have 490 consecutive daily rainfall shapefiles/.dbf files in a single directory. Each consists of a uniform even-spaced grid of 220 points having uniform pointIDs, number of records, field names ...
4
votes
2answers
979 views

VBA functions use in ArcGIS Field Calculator

Would this be ok to use them for the field calculator in ArcGIS 9.3 ? See here MS Excel VBA Functions Or should I fix them in MS Excel and save as a file and then use the join with the shapefile or ...
3
votes
7answers
8k 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
2answers
329 views

Data-type detection in ArcGIS table loading

When adding tables layers from Excel files, ArcGIS attempts to guess the data-types: Microsoft Excel does not enforce field types for values during data entry like standard databases do. ...