The Heap™ – Consultancy ©®

« first day (2940 days earlier) ← previous day next day → last day (1931 days later) »

1:35 AM

How is advertising a product on a question not spam?

lol

A: Problem getting zips in radius via MySQL

Check out this data set from GreatData.com They use population density instead of center of zip. And how to use sql server spatial data type to get fast correct results. http://mitchelsellers.com/blogs/2012/01/23/simple-zip-code-to-zip-code-distance-calculations-with-sql-server.aspx http...

Annual Subscription; $499 USD; 30-Day Money-Back Guarantee

4 hours later…

Master Database

5:25 AM

Q: Old questions showing recent activity

Why do some questions come to the top of the active list when nothing seems to have been changed? Example question:Old question without noticeable activity

Paul White

5:48 AM

@EvanCarroll The definition we use is at meta.stackexchange.com/a/58035.

Evan Carroll

So you have a definition of spam that totally excludes unwanted targeted advertising?

I guess, =)

I do agree, it doesn't follow that definition

Paul White

6:06 AM

I have a low tolerance for spam in general, but there has to be a lack of disclosure of an affiliation or the product has to be irrelevant to the post or the poster has to have a history of posting spam-ish posts. None of those really apply here, which isn't to say I think it is a great answer.

There's also the history of the flagger to take into account when handling flags 😉

Evan Carroll

6:22 AM

It's certainly not on topic, even remotely it's not even the same dataset. and I'm not sure how population density solves the problem over centroid