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 ...
2
votes
2answers
135 views

How to add attribute in shapefile guidedly

I have a point layer (31 by 31 grid = 961 points) created by fishnet tool > feature vertices to point tool (but with duplicate points). NOx Concentration data are in an Excel file. I want to ...
1
vote
1answer
370 views

How to create Feature Class based on DBF schema?

I have an attribute table schema (about 30 fields) stored in an Excel document, which I exported as a dbf. I can easily make a geodatabase table from this, using the Excel sheet as a template. How can ...
4
votes
2answers
2k views

Importing data with empty cells without GIS replacing the empty cell with 0

I am importing data from excel into ArcGIS 10. The data are columns of GPS data, associated date and time, and a unique point identifier. For some of the rows the GPS data is missing and so the Lat ...
3
votes
1answer
838 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
2k 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 ...
6
votes
1answer
1k views

Excel object does not display more than 19 fields in ArcMap 10

I have an A0 map. I want to put a table underneath it. I want to insert an Excel object as the table. When I do this, the size of the table is 19 fields/columns. I cannot increase this number of ...
0
votes
2answers
2k views

How to import data from excel and associate it with individual shapes?

New user on ArcMap - Working with shapefiles... Question: the shapefile I am working on, a polygon is a plot of land, each plot of land has a history of owners. I am currently having to copy/paste ...
8
votes
2answers
377 views

How can I find the median column in a database?

I have data on period of construction for dwellings in dissemination areas. I have transferred this data to my study areas and would like to determine the median period of construction for each study ...