Display XY Data not showing up where its supposed to...

[ChristopherLong1]

Hello,

I'm currently working on creating a feature class for bus stops in my city. The transportation manager gave me a spreadsheet with lat long on it which I converted to decimal degrees so I could use the Display XY data tool when you right click on the spreadsheet. Once I display the data I export it with the data frames cordinate system so that it will be in VA state plane south but once I add it back to the map its not showing up near all of my other data.

The bus stops are showing up at 38822226.125, 34219046.878

While my roads/other data that are right are showing up at 10880205.128, 3573999.38

Any know what I'm doing wrong?!

Thanks!

[JoeBorgione]

Hello,

I'm currently working on creating a feature class for bus stops in my city. The transportation manager gave me a spreadsheet with lat long on it which I converted to decimal degrees so I could use the Display XY data tool when you right click on the spreadsheet. Once I display the data I export it with the data frames cordinate system so that it will be in VA state plane south but once I add it back to the map its not showing up near all of my other data.

The bus stops are showing up at 38822226.125, 34219046.878

While my roads/other data that are right are showing up at 10880205.128, 3573999.38

Any know what I'm doing wrong?!

Thanks!

It actually displays correctly before you export it?  I assume you add xy, then right click on the subsequent feature class, and export using the display coordinates or those of your roads?  Something seems kind of fishy.....

[ChristopherLong1]

Sorry I forgot to add that part its not displaying correctly before I export it either... I was doing that to try and fix it... which it doesn't. I think I must be missing one step in the process.


-Chris

[JoeBorgione]

You might want to check your math....

[ChristopherLong1]

Sorry Check my math for?

I used a VB script in excel to change my lat long from DMS to decimal deg.

Function Convert_Decimal(Degree_Deg As String) As Double
   ' Declare the variables to be double precision floating-point.
   Dim degrees As Double
   Dim minutes As Double
   Dim seconds As Double
   ' Set degree to value before "°" of Argument Passed.
   degrees = Val(Left(Degree_Deg, InStr(1, Degree_Deg, "°") - 1))
   ' Set minutes to the value between the "°" and the "'"
   ' of the text string for the variable Degree_Deg divided by
   ' 60. The Val function converts the text string to a number.
   minutes = Val(Mid(Degree_Deg, InStr(1, Degree_Deg, "°") + 2, _
             InStr(1, Degree_Deg, "'") - InStr(1, Degree_Deg, _
             "°") - 2)) / 60
    ' Set seconds to the number to the right of "'" that is
    ' converted to a value and then divided by 3600.
    seconds = Val(Mid(Degree_Deg, InStr(1, Degree_Deg, "'") + _
            2, Len(Degree_Deg) - InStr(1, Degree_Deg, "'") - 2)) _
            / 3600
   Convert_Decimal = degrees + minutes + seconds
End Function

I'm not sure where I could have gone wrong...

Thanks,

Chris

[JoeBorgione · Accepted solution]

That's thing with forums; you asked for suggestions, I gave one. Here's another suggestion:

Since your area of operation is the USA, your longitudes need to be negative values.

[ChristopherLong1]

That worked!!

Sorry if I came off snippy in the last post I just didn't know what you meant by check your math.

Again thanks so much!!