Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Are the posted questions getting worse? Rate Topic Display Mode Topic Options
Author
 Message
 Posted Wednesday, November 13, 2013 8:24 AM
 Ten Centuries Group: General Forum Members Last Login: Friday, March 07, 2014 3:50 PM Points: 1,159, Visits: 2,395
 Ed Wagner (11/13/2013)Greg Edwards-268690 (11/13/2013)venoym (11/13/2013)L' Eomot Inversé (11/12/2013)wolfkillj (11/12/2013)My new blog post on appropriate data types for storing latitude and longitude coordinates is up. Thanks for indulging me in a little bit of self-promotion. I'm finding that it's hard to hit the critical mass of audience where a new post gets attention just by virtue of being posted.Interesting article. I don't like the terminology though: a number like 123.456789 has 9 decimal places, not 6. It has 6 decimal places after the point and 3 before, making 9 in all. But I guess terminology is different in different places.In this case I believe 9 would refer to Significant Digits (or Figures)(in many math/physics classes you hear the refrain of "Sig Figs" a lot). It's fairly common practice, in the US at least, to refer to the number of digits after the decimal point as "Decimal Places"I was taught size (how many places for numbers) and precision, as some systems do not store the decimal point in the raw data, but have it defined in a data dictionary.I'm sure with Steve this may bring back JDE memories. I was taught 9 significant digits with 6 decimal places. I also thought the article was pretty interesting reading - good job.Thanks for the feedback and discussion, everyone. It's nice to know you're reading my posts. I take some comfort in having L'Eomot Inverse around to point out any errors or inconsistencies in my discourses on mathematics. I'll cop to muddling the terminology a bit. I used the term "decimal places" in the colloquial sense common in the U.S. to mean "digits to the right of the decimal point." I could have been more definite by stating that nine significant digits are necessary to represent latitude (as measured by augmented GPS) with appropriate precision - three for the integer part and six for the fractional part - while representing latitude with appropriate precision requires eight significant digits - two for the integer part and six for the fractional part. When writing for a global audience, it's good to remember that conventions for talking about and representing numbers can differ from place to place. At least we English-speakers have finally agreed that "billion" means a thousand millions and "trillion" means a million millions! Jason WolfkillBlog: SQLSouthTwitter: @SQLSouth
Post #1513918
 Posted Wednesday, November 13, 2013 10:17 AM
 SSCrazy Eights Group: General Forum Members Last Login: Yesterday @ 6:35 AM Points: 8,176, Visits: 8,617
Post #1513976
 Posted Wednesday, November 13, 2013 10:20 AM
 SSCrazy Eights Group: General Forum Members Last Login: Yesterday @ 6:35 AM Points: 8,176, Visits: 8,617
 duplicate post - website problem?? Tom
Post #1513979
 Posted Wednesday, November 13, 2013 11:43 AM
 SSCrazy Group: General Forum Members Last Login: Tuesday, February 25, 2014 9:05 AM Points: 2,602, Visits: 17,842
 wolfkillj (11/12/2013)My new blog post on appropriate data types for storing latitude and longitude coordinates is up. Thanks for indulging me in a little bit of self-promotion. I'm finding that it's hard to hit the critical mass of audience where a new post gets attention just by virtue of being posted.I hit F5 a couple times for you
Post #1514012
 Posted Wednesday, November 13, 2013 12:00 PM
 SSC-Insane Group: General Forum Members Last Login: Today @ 7:13 AM Points: 22,241, Visits: 29,569
 It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!
Post #1514019
 Posted Wednesday, November 13, 2013 12:02 PM
 Hall of Fame Group: General Forum Members Last Login: Today @ 5:33 AM Points: 3,125, Visits: 2,135
 Lynn Pettis (11/13/2013)It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!All the best, Lynn. I'm sure you'll do well. Hopefully, you'll have something better to come home to when you're done over there.
Post #1514023
 Posted Wednesday, November 13, 2013 3:37 PM
 SSC-Insane Group: General Forum Members Last Login: Today @ 7:13 AM Points: 22,241, Visits: 29,569
Post #1514082
 Posted Wednesday, November 13, 2013 3:46 PM
 SSChampion Group: General Forum Members Last Login: Today @ 5:44 AM Points: 14,452, Visits: 26,744
Post #1514085
 Posted Wednesday, November 13, 2013 3:53 PM
 SSChampion Group: General Forum Members Last Login: Today @ 7:34 AM Points: 11,572, Visits: 10,683