nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Find more posts tagged with

Local

Accepted answers

JoeBorgione

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.

All comments

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

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!!

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.