+ Reply to Thread
Results 1 to 5 of 5

Thread: Importing Lat/Long Formats into GIS

  1. #1
    Lyndy worsham
    Join Date
    Jun 2010
    Posts
    72
    Points
    2
    Answers Provided
    0


    0

    Default Importing Lat/Long Formats into GIS

    Hi,

    I understand that it's not possible to import degrees, minutes, and seconds format of lat/long into ArcGIS. I have a client who has all their data in an Excel spreadsheet in degrees, minutes, seconds.

    First, may I just confirm that it's not possible to import degrees, minutes, seconds format into ArcGIS.

    Second, what is the best way to convert the data in Excel? I have written a function that converts the data for the client so that it may be imported into ArcGIS. But I am not sure if this is the most efficient way to handle the problem. They seem reticent to collect the data in decimal degrees because they have always been collecting the data in degrees, minutes, seconds.

    Any advice?

    Regards,
    Lyndy

  2. #2
    Lucas Danzinger

    Join Date
    Oct 2011
    Posts
    389
    Points
    198
    Answers Provided
    25


    0

    Default Re: Importing Lat/Long Formats into GIS

    Hi Lyndy,

    This is a current enhancment request that is resolved at version 10.1 (NIM004573:ENH: Add XY Data/Create Feature Class From XY Table: add support for Degrees Minutes Seconds data (and other formats, like Degrees Decimal Minutes) when you create XY event layers).

    In Excel, you will have to create an equation that divides minutes by 60 and divides seconds by 3600. Add these fields to your degrees field and you should have decimal degrees.
    Lucas Danzinger | Product Engineer

  3. 04-05-2012 10:29 PM


  4. #3
    Lyndy worsham
    Join Date
    Jun 2010
    Posts
    72
    Points
    2
    Answers Provided
    0


    0

    Default Re: Importing Lat/Long Formats into GIS

    Quote Originally Posted by ldanzinger View Post
    Hi Lyndy,

    This is a current enhancment request that is resolved at version 10.1 (NIM004573:ENH: Add XY Data/Create Feature Class From XY Table: add support for Degrees Minutes Seconds data (and other formats, like Degrees Decimal Minutes) when you create XY event layers).

    In Excel, you will have to create an equation that divides minutes by 60 and divides seconds by 3600. Add these fields to your degrees field and you should have decimal degrees.
    HI ldanzinger,

    Ah, I figured it only be a matter of time before someone figured out a fix to resolve this issue. Thanks for letting me know. I sounds like I am doing the best I could do by converting the data with a function so it can be imported as client is using 9.3.

    Thanks again!

    Lyndy

  5. #4
    Curtis Price

    Join Date
    Oct 2009
    Posts
    1,798
    Points
    874
    Answers Provided
    127


    0

    Default Re: Importing Lat/Long Formats into GIS

    Quote Originally Posted by ldanzinger View Post
    This is a current enhancment request that is resolved at version 10.1 (NIM004573:ENH: Add XY Data/Create Feature Class From XY Table: add support for Degrees Minutes Seconds data (and other formats, like Degrees Decimal Minutes) when you create XY event layers).
    Wow. This is something users have been asking for since, well, as long as there has been a table to XY feature in ArcView (mid-1990s).

  6. #5
    Ian Johnson
    Join Date
    Apr 2010
    Posts
    22
    Points
    0
    Answers Provided
    0


    0

    Default Re: Importing Lat/Long Formats into GIS

    Quote Originally Posted by lyndy View Post
    Hi,

    I understand that it's not possible to import degrees, minutes, and seconds format of lat/long into ArcGIS. I have a client who has all their data in an Excel spreadsheet in degrees, minutes, seconds.

    First, may I just confirm that it's not possible to import degrees, minutes, seconds format into ArcGIS.

    Second, what is the best way to convert the data in Excel? I have written a function that converts the data for the client so that it may be imported into ArcGIS. But I am not sure if this is the most efficient way to handle the problem. They seem reticent to collect the data in decimal degrees because they have always been collecting the data in degrees, minutes, seconds.

    Any advice?

    Regards,
    Lyndy

    You may also try the "Convert Coordinate Notation" Tool (http://help.arcgis.com/en/arcgisdesk...000000tw000000)

    I will admit that I haven't had great luck with it, and just end up doing what has been described in posts above, but hey, if you can make it work it sounds handy! It's very particular about the format of your DMS coords, so just be conscious of that.

    Ian

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts