Global Mapper v26.0

Points not Displaying a Cardinal Degrees

Roger Edrinn
Roger Edrinn Global Mapper UserTrusted User
edited July 2010 in Bug Report
This is weird, seems like a bug, time will tell. I created a 40K point dataset by downloading Place Names from the USGS: here and used Excel to merge the 2K max downloads and export as tab delimited, the USGS likes pipe "|" delimited. GM won't open the "|" file.

When I Import the text file(s), I get ~0.1 degree blank areas at 1 degree intervals. Don't see how the data could do this and I'm inferring a GM bug. I'm running GM 11.02 June 26

I've attached two sample files, the raw download and the excel tab conversion. Surprisingly the Excel file is noticeably smaller.

Comments

  • global_mapper
    global_mapper Administrator
    edited July 2010
    I took a look and was able to import the USGS GNIS (Geographic Names) importer to support how they are now saving their files (they seem to change it every few months for no obvious reason), so now your original .txt file comes in directly with the correct placement and classification. I have placed a new build at http://www.globalmapper.com/global_mapper11.zip with the change for you to try. Simply download that file and extract the contents into your existing v11.xx installation folder to give it a try. If you are using the 64-bit v11 version there is a new build at http://www.globalmapper.com/global_mapper11_64bit.zip .

    Let me know if I can be of further assistance.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    I'm still seeing the ~0.1 deg gap with no data at every 1 deg. Did you not see this pattern? Use the post office raw file. They are not at cardinal values.
  • global_mapper
    global_mapper Administrator
    edited July 2010
    I'm seeing the full coordinates from the file. I have loaded your raw file from the post office and then exported as a CSV, which I've attached for you to see. What does the build date show for you on the Help->About dialog? It sounds like you didn't get the new build.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    The build is showing July 25.

    Getting more weirdness. I've set 1 deg custom grid and get a too many lines to display. The zoom scale to show the entire state (AZ) is like 1:Billion, actually: (1:41914625351).

    I'm doing something wrong, but can't figure out what?
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    Am I supposed to be using File > Open > Import ASCII data?
  • global_mapper
    global_mapper Administrator
    edited July 2010
    Ah that's likely the issue, just use File->Open Data File and it will automatically be recognized and loaded as a USGS GNIS format file.

    Let me know if I can be of further assistance.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    Don't understand why the ASCII import created such chaos?

    If I left it at UTM my data was at the equator, with Geographic it was on another planet.

    IIRC I've always used ASCII import in the past. Besides .txt is NOT an accepted data type, had to use All *.*
  • global_mapper
    global_mapper Administrator
    edited July 2010
    The coordinates in the file aren't formatted in a way that the generic ASCII import can recognize (i.e. they are DDDMMSS values with a hemisphere character, rather than decimal degrees or something that is recognized and supported. Those packed DMS values interpreted as lat/lon are obviously ridiculous values, and as UTM they aren't wrong either.

    The .txt file is too common for non-data files to include in the 'Commonly Supported Types' filter, but it will show up for the GNIS filter.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    global_mapper wrote: »
    The coordinates in the file aren't formatted in a way that the generic ASCII import can recognize (i.e. they are DDDMMSS values with a hemisphere character, rather than decimal degrees or something that is recognized and supported. Those packed DMS values interpreted as lat/lon are obviously ridiculous values, and as UTM they aren't wrong either.
    I was puzzled that the values had no decimal. GNIS is simply using character position instead of a decimal. So you had to write a custom script to unpack the data. No doubt this is all driven by ArcGIS, the 800# GIS gorilla.

    So my 40K line Excel spreadsheet is worthless. :(
  • global_mapper
    global_mapper Administrator
    edited July 2010
    Yeah the Excel spreadsheet can't be directly imported, although if you added some formulas to break up the DMS encoded coordinates into a single decimal value in your spreadsheet you could turn it into something useful.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    Indeed, to get -113.1250 from 1131250W do this:
    =CONCATENATE("-",MID(G2,1,3),".",MID(G2,4,4))

    Took a half-hour using help to find the right key word, to figure out the mid operator. Mid isn't exactly a term that comes to mind when searching for a string trimmer.
  • global_mapper
    global_mapper Administrator
    edited July 2010
    Roger,

    Unfortunately that is not correct, the value 1131250W corresponds to -113 12' 50", which is equivalent to -( 113 + 12 / 60 + 50 / 3600 ), which is not the same as -113.1250, so you'll have to tweak your formula a bit more.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    Oops, thanks for the heads up. I'll post the correction after I engage brain later today.
  • Roger Edrinn
    Roger Edrinn Global Mapper User Trusted User
    edited July 2010
    Well unexpected problems.

    This formula CONCATENATE("-",MID(G2,1,3)+MID(G2,4,2)/60+MID(G2,6,2)/3600) created the correct value except the CONCATENATE function would not allow cell formatting, so numbers can trail out to Excel's 15 char max. Half of the 40,000 Longitude values have 15 characters.

    This 1131250W becomes this -113.213888888889

    whereas w/o the "-" needed for the west hemisphere, I can format

    360629N to 36.10806 with any number of characters after the decimal.

    I doubt if GM cares, 5 or 15?
  • global_mapper
    global_mapper Administrator
    edited July 2010
    GM won't care if you have 5 or 15 decimal places. I'm guessing the coordinates aren't accurate beyond 5 decimal digits of degree precision anyway, so just having 5 would be fine for that data set.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com

Categories

In this Discussion