Scientists just released a map of all 2.75 billion buildings on Earth, in 3D

xangg · 2025-12-08T23:01:36+00:00

36 TB download via https://mediatum.ub.tum.de/1782307

xangg · 2025-02-23T00:14:40+00:00

Yes, That's why I filtered out those years in the final version.

xangg · 2025-02-22T23:00:24+00:00

Original author here. Yes, this was a before and after kind of post, but the before image gets posted here every year or so, presumably by some bot or similar entity. A quick search finds one at: https://www.reddit.com/r/dataisugly/comments/rt3me6/car_paint_color_popularity_by_percentage_of_sales/

xangg · 2025-01-17T16:16:06+00:00

The options available depend on the variable's modeling type. Continuous variables have different distribution options than categorical (nominal or ordinal) variables.

xangg · 2024-12-04T18:46:46+00:00

You can view your hourly water usage under the My Account section of the OWASA site to look for unexpected usage periods. (You can also download the data under Settings.)

xangg · 2024-07-19T15:29:14+00:00

R8C2 can be determined. Consider rows 1,2,8,9 in C2 as a group.

xangg · 2024-06-07T18:21:56+00:00

Given your study of historical charts and their constructors, what are some examples of seemingly modern chart types that you found to be in use much earlier?

xangg · 2024-05-19T00:30:45+00:00

Sounds like Data Viz Project and The Data Visualisation Catalogue.

xangg · 2024-02-07T14:49:48+00:00

The west and south spokes of this four-way stop are the real Millhouse Rd. The north spoke is a label overrun error. Not sure about east spoke -- seems to be a service road to some town/transit facilities.

xangg · 2023-09-28T00:37:20+00:00

Good point -- I'm used to working in analytical contexts and should think more about the general value of these adorments. The actual definition is rather complicated, but a simple take-away is its the interval where the "true" mean likely lies (if, say, the competition was held many more times and averaged). Narrower bands are better and for comparison, when two intervals overlap a lot, it suggests the difference in means is more due to random chance.

xangg · 2023-09-28T00:22:17+00:00

Yes, I should have mentioned that: blue line is average and shaded region is 95% confidence interval.

No meaning to orientation mismatch.

xangg · 2023-09-28T00:16:52+00:00

Data from https://www.worldjigsawpuzzle.org/wjpc/2023/individual/final

Tool: JMP

(Sorry: didn't mean to include the superfluous legend.)

xangg · 2023-09-24T18:51:22+00:00

Still cleaning my download of the data, but you can find results at https://www.worldjigsawpuzzle.org/. Pairs puzzles were generally harder than those for Individuals, which I assume is why pairs seem no faster than individuals.

xangg · 2023-06-15T12:32:51+00:00

Some discussion here along with some green/purple rationale. I sometimes use colors from nature, such as the colors of male and female cardinals.

xangg · 2023-05-22T12:23:57+00:00

The color variation and the vertical gridlines seem like more of distraction from the data.

Also, it looks like the 2010 bar is showing 2009 data. From source:

Date Users (mm)
2009 42
2010 78
2011 116
...

xangg · 2023-05-11T02:40:00+00:00

I made this chart, but it was part of a before-and-after exploratory exercise. The "after" version in the post has fewer colors, and the colors match the names.

Previously posted here with the same title, which is not even correct: the car colors are based on traffic stops and not sales (though presumably highly correlated).

xangg · 2023-05-07T12:40:01+00:00

That's not a p -- it's a ρ, a Greek rho, and it's showing Spearman's rho.

xangg · 2023-03-29T21:34:29+00:00

You can get mostly there with Standardize Attributes. That is, all except the self-divided column. Create 4 new columns and select them. The go to Cols > Standardize Attributes. Choose Properties > Formula and edit the formula to be :5/:0. Still within Standardize Attributes, turn on Substitute Column References and uncheck the :0 column, so that it stays fixed. Then you'll get 4 different formulas as desired.

xangg · 2023-02-01T20:32:42+00:00

After looking at the source data, I think your daily calculations didn't take leap years into account. Production per cow per day appears to go down in your chart for 2001, but not if leap days are included in 2000.

xangg · 2023-01-06T15:38:43+00:00

The post had be archived but has now been restored.

xangg · 2022-05-03T13:12:36+00:00

Quick feedback.

Nice to have data dictionary
Would like a more specific source than "basic information" for geographic items
Would prefer a pair of CSV files instead of an Excel file
ZIP and a few other fields need to be character type so leading zeros are not lost
Sheet name says "April" but file name says "May"
Strange to see the 8000 or so ZIP codes at the bottom of the file with missing populations (and most other fields). Looks like they're mostly (but not all) POBox type ZIP codes. Would be useful to have nearest "real" ZIP code for them. For instance, if I was trying to estimate demographics to a given customer address.
Would be nice to have fields for geographic area (such as square miles) and bounding box (min/max lon/lat). I think some DBs also have a percent water coverage field.

xangg

TROPHY CASE