Jennifer,

 

Peter is correct that your Lat/Lon were reversed in the dialog box, but even so, your geometry should have shown up, which it sounds like they do (just in the wrong place).  In the cases where nothing shows up, I have noticed it has to do with the file name.  Are their spaces, dashes, other odd characters in the original file name?  Also I would make sure you have closed out of your excel program before performing these operations as well.

 

-M

 

---
Matthew J. Mayo, M.S., GISP, CPG, PG | 617-395-5597

 

From: Unmoderated discussion list for Connecticut GIS Users [mailto:[log in to unmask]] On Behalf Of Sandgren, Peter
Sent: Wednesday, August 12, 2015 1:15 PM
To: [log in to unmask]
Subject: Re: [CTGIS-L] Add XY Data frustration

 

Jennifer, put longitude for the X field and latitude for the Y.  Then click the “Edit” button in the dialogue and choose Geographic Coordinate System/North America/NAD83.  That should do it.

 

Peter N. Sandgren

CT DESPP – DEMHS

State EOC GeoLab

25 Sigourney Street

Hartford, CT 06106

ph. 860-256-0875

mobile 860-597-5647

fax 860-256-0819

 

From: Unmoderated discussion list for Connecticut GIS Users [mailto:[log in to unmask]] On Behalf Of Jennifer M. Kalasardo
Sent: Wednesday, August 12, 2015 12:37 PM
To: [log in to unmask]
Subject: [CTGIS-L] Add XY Data frustration

 

Alright Folks,

 

I am at a loss.  I have an excel sheet with these columns:

OBJECTID            LAT_DD                LONG_DD

1                            44.10                    -73.52

2                            43.92                    -73.62

3                            41.37                    -74.20

ETC.                      ETC.                      ETC.

 

I keep getting this (see below) when I try to Add XY Data in ArcMap:

 

When I just click OK, no matter how I have the fields formatted, what I call OBJECTID, if I switch the XY field, if I switch the negative sign to the other column, I get the same warning, and the points do not show up where they should.  If I manually enter them in, they locate fine.  I have also tried editing a new feature class directly and creating a feature class from the data in ArcCatalog to no avail.  What else can I try?

 

Thanks,

 

Jennifer M. Kalasardo

 

GIS/CAD Operator

Iroquois Pipeline Operating Company

One Corporate Drive, Suite 600

Shelton, CT  06484-6211

203-925-7224 (W)

203-925-7213 (F)

860-967-9795 (C)

[log in to unmask]

 

------------------------------------------------------------------------- This list (CTGIS-L) is an unmoderated discussion list for all CT GIS Users.

If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/ctgis-l.html

------------------------------------------------------------------------- This list (CTGIS-L) is an unmoderated discussion list for all CT GIS Users.

If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/ctgis-l.html

------------------------------------------------------------------------- This list (CTGIS-L) is an unmoderated discussion list for all CT GIS Users.

If you no longer wish to receive e-mail from this list, you can remove yourself by going to http://listserv.uconn.edu/ctgis-l.html