topic Re: Display X,Y data comes in a line in Map Projections Questions https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872575#M288 <HTML><HEAD></HEAD><BODY><P>You might as well close this out and report back when you get it resolved</P></BODY></HTML> Thu, 10 May 2018 01:45:04 GMT DanPatterson_Retired 2018-05-10T01:45:04Z Display X,Y data comes in a line https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872570#M283 <HTML><HEAD></HEAD><BODY><P>OK so I have found old posts about this from 10 years ago but nothing recent. I have a spreadsheet originally in excel, I have added new fields (longitude, latitude) as double, even saved as CSV yet data still comes in a line? I have used the excel to table tool still did not help. I have added to a blank arcmap without projection and to an arcmap with projection. When I display X,Y I have tried WGS 84 and many others.I have tried numerous coordinate and projections, yet still wrong. Any Ideas.</P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/406130_pastedImage_1.png" /></P></BODY></HTML> Wed, 09 May 2018 15:18:59 GMT https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872570#M283 GeorgeKatsambas 2018-05-09T15:18:59Z Re: Display X,Y data comes in a line https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872571#M284 <HTML><HEAD></HEAD><BODY><P>Longitude is X, Latitude is Y.&nbsp; You have a whole load of duplicates</P><P>Define it as a Geographic Coordinate system WGS84</P><P>Save it to a geodatabase featureclass.</P><P>You will have to figure out what to do with the duplicates... they seem to be the centroids of some geocoding or something</P></BODY></HTML> Wed, 09 May 2018 15:26:46 GMT https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872571#M284 DanPatterson_Retired 2018-05-09T15:26:46Z Re: Display X,Y data comes in a line https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872572#M285 <HTML><HEAD></HEAD><BODY><P>Yes, duplicates needed, still comes in a line?</P></BODY></HTML> Wed, 09 May 2018 16:03:20 GMT https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872572#M285 GeorgeKatsambas 2018-05-09T16:03:20Z Re: Display X,Y data comes in a line https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872573#M286 <HTML><HEAD></HEAD><BODY><P>The data are what they are... they are points all squished together.&nbsp; If the pattern isn't what you expected, then the problem is with how it was acquired or processed.&nbsp; Sorry but....</P><P><IMG alt="" class="image-1 jive-image" height="467" src="https://community.esri.com/legacyfs/online/406139_junk.png" width="508" /></P></BODY></HTML> Wed, 09 May 2018 16:14:39 GMT https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872573#M286 DanPatterson_Retired 2018-05-09T16:14:39Z Re: Display X,Y data comes in a line https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872574#M287 <HTML><HEAD></HEAD><BODY><P>if I geocode it I get the random distribution, yes it has to be something with the lat/lon originally</P></BODY></HTML> Wed, 09 May 2018 16:22:32 GMT https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872574#M287 GeorgeKatsambas 2018-05-09T16:22:32Z Re: Display X,Y data comes in a line https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872575#M288 <HTML><HEAD></HEAD><BODY><P>You might as well close this out and report back when you get it resolved</P></BODY></HTML> Thu, 10 May 2018 01:45:04 GMT https://community.esri.com/t5/map-projections-questions/display-x-y-data-comes-in-a-line/m-p/872575#M288 DanPatterson_Retired 2018-05-10T01:45:04Z