Latitude, Longitude and the nautical Mile

  • SQAPro

    Right there with Babe

    Points: 742

    Comments posted to this topic are about the item Latitude, Longitude and the nautical Mile

  • parshv

    SSC Journeyman

    Points: 86

    What makes you think that this question is related to SQL Server? :exclamationmark:

  • This was removed by the editor as SPAM

  • ronmoses@gmail.com

    SSCarpal Tunnel

    Points: 4480

    Sure, spatial data is useful... so are duct tape, lawn mowers, and pinking shears -- none of which have anything to do with SQL Server. Parshv's question stands.

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • This was removed by the editor as SPAM

  • Gary Varga

    SSC Guru

    Points: 82166

    Of course the answer to the question "What is a Sea Mile...".

    It has been a long time since the two were seen as equivalent, if they ever truly were.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • Dale Turley

    Right there with Babe

    Points: 740

    WTF???

    There are some really useless and pointless questions on here sometimes... but this takes the biscuit!!

  • Gary Varga

    SSC Guru

    Points: 82166

    Dale Turley (11/11/2009)


    WTF???

    There are some really useless and pointless questions on here sometimes... but this takes the biscuit!!

    ...classic seafaring food, biscuits.

    But seriously, the spatial questions tend to be. Some of the questions/answers are even ambiguous or more than one answer can apply. However, such occurances are rare and I am not paying a professional company money to test my knowledge (albeit a site run professionally). So I think, in keeping with the thread's theme, I'll accept the rough with the smooth!!!

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!

  • SanjayAttray

    SSChampion

    Points: 13157

    Dale Turley (11/11/2009)


    WTF???

    There are some really useless and pointless questions on here sometimes... but this takes the biscuit!!

    I had asked the same question for previous question on spatial data question. Go through the discussion.

    If I am not using spatial data ( well most of us would never use it in future also ) that does not mean its not worth a question.

    http://www.sqlservercentral.com/Forums/Topic756337-32-1.aspx

    SQL DBA.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715117

    It's a bit of trivia related to spatial information. If you work with data on the oceans, this can be valuable. It's not something most of us will deal with, but now it might stick in your head.

  • SQAPro

    Right there with Babe

    Points: 742

    Dale Turley (11/11/2009)


    WTF???

    There are some really useless and pointless questions on here sometimes... but this takes the biscuit!!

    I suppose if you feel that using SQL server to store locational information such as lat/long is "useless and pointless" then you'd feel that way about this question.

    But for folks that need to work with such data, perhaps tracking movement of shipping containers (which can now 'phone home' using GPS/Satcom systems mounted on the container) or similar things, the relationship between units of distance, and the units used to store the locations can potentially be important.

    Is that truely more trivial then some of the very obscure SQL details we've sometimes seen posted? I guess like art, that's in the eye of the beholder.

  • Dan Guzman - Not the MVP

    Hall of Fame

    Points: 3752

    It's not just oceans. With Geospatial you can never draw a straight line between two points. Most of us work in geographically limited data so it doesn't matter much, but with larger distances the differences can add up fast. Geospatial is always dealing with the surface of the sphere(ellipsoid).

    I used to have to deal with data that would be disqualified if it was more than 300m from a given point. In some cases the difference between Nautical and Standard was enough to drop a few points.

    What this has to do with SQL Server vs. any other db I'm not sure.

  • Cliff Jones

    SSChampion

    Points: 10517

    No problem, it is just a fairly easy point for Veterans Day.

  • FargoUT

    SSC Eights!

    Points: 853

    I think it's pointless because it's too exclusive and doesn't relate to SQL Server specifically (instead it relates to data which might be stored). It would be like asking what the markup value for a retail chain's merchandise might be. Sure, it may be useful for those people in retail, but not entirely useful for the SQL Server community.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715117

    Feel free to ignore questions that don't apply to you.

    Should we not ask questions on Service Broker because few of you use it? Or skip replication because it's not in most environments?

    Complaining that it doesn't apply to your environment, or even a majority of the SQL Server community seems a little silly to me.

Viewing 15 posts - 1 through 15 (of 31 total)

You must be logged in to reply to this topic. Login to reply