Google Maps adds real-time images

Yesterday I was amazed to see yet another new feature in Google Maps .

A new button [Street View], gives you are real view of the street in question, you can rotate the image around 360 degrees, and move up and down the street. Now not all areas have been mapped yet, but you will see highlighted in blue what is.

It’s rather amazing what they can do. Presently they have images of San Francisco, Las Vegas, Denver, Miami and New York.

BTW: On the news tonight (Wed May 30) there is already controversy over the feature. People have been able to zoom in and see great detail of people, sometimes in places were it may be inappropriate.

Tagged with: Google

Producing IQR and Outlier statistics with SQL

The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3). Combined with Tukey’s 1.

Producing Mode statistics with SQL

The mode is the value or values that appear most frequently in a dataset. Unlike the mean or median, it applies naturally to categorical and ordinal data — star ratings, product codes, survey responses — and reveals what is most common, not what is average.

Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install. These are: User Defined Function (UDF) MySQL Manual MySQL Plugin MySQL Manual MySQL Component MySQL Manual In my prior post I provided a new uuidv function that accepted a numeric argument to return a string of the version of UUID specified.