0
votes
0answers
50 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 ...
-1
votes
2answers
32 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 ...
1
vote
0answers
45 views

How to convert picture to annotation in ArcGIS 10.1?

I have been tasked to display analytical data tables (currently in MS Excel) in an ArcGIS (v 10.1) map document (.mxd) and would also like to convert them to map document annotation, if possible. ...
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 ...
0
votes
2answers
40 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
1answer
47 views

Ohio DNR Oil Gas Lat / Long Conversion in ArcGIS 10.1

Is anyone familiar with the Ohio Oil Well Search off their website? For the Lat/Long, they have WH_X and WH_Y. The numbers in their do not match up with the actual Lats/Longs off the OHio Well ...
1
vote
1answer
66 views

Need to use xlsx data to clip a shapefile

I have an Excel table with just one column, with 1150 records, each of them a species name. I also have a shapefile with 24,000 records, each of them a species name and its geographic range. I need to ...
-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 ...
5
votes
1answer
504 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 ...
1
vote
1answer
164 views

updating a feature class from an EXCEL spreadsheet

I created feature classes that only contains the data from an EXCEL file. I did this to enable the search function to search the data in these tables. The FCs also have relationships between ...
1
vote
4answers
2k views

Get pixel value from a raster in a xy table

I'm trying to find a way to convert a raster (in my case it's a Landsat satellite image) into a table with 3 columns which would represent: 1) x coordinates (the so called "xllcorners" in ASCII ...
4
votes
1answer
608 views

Using matplotlib to create and export graphs automatically from ArcMap

I am going to start a project soon where, after the data has been processed in various ways, an output jpg showing a graph of the data should be produced. The workflow is as follows: 1. A feature ...
1
vote
1answer
181 views

Tables within the Reclassify tool- what is it, where is it?

ArcMap 10.1 here. I have a raster set I'm looking to reclassify. The field I need to re-classify is currently a string of words like "Thing 1" and "Thing 2" and I'm going to set them to be 1 and 2. I ...
3
votes
2answers
345 views

Why do I lose data after converting from .xlsx to .shp?

I have a fairly large excel file that I need to convert to a shapefile, but everytime I export the data, I lose a bunch of it. The excel file has about 277,000 records, but the shapefile will only ...