Latitude, Longitude and the nautical Mile

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

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

  • This was removed by the editor as SPAM

  • 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

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

  • WTF???

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

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

  • 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.

  • 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.

  • 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.

  • 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.

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

  • 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.

  • 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 30 total)

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