 |
 |
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]<mailto:[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: [cid:[log in to unmask]] 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]<mailto:[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