User Account Map Added to Hive Analytics by eroche

View this thread on: hive.blog | peakd.com | ecency.com

hive-133987 · @eroche · Jun 12 '21 (edited)

$8.94

User Account Map Added to Hive Analytics

This week there were several useful additions to Hive Analytics, an app for analysing the Hive Blockchain powered by data from #hivesql

https://eroche.shinyapps.io/hiveanalytics/

# Updates This week
## Tags
There are two places where you can now analyse Tags

On the Activity Tab you can search for a tag and see the posts that were made within a date range. 
*Thanks @demotruck for this suggestion*

![image.png](https://images.hive.blog/DQmQHrPU19KysbsZNMEC9jJG2bbJmD3YARV6tzDhr5sBzuJ/image.png)

On the Tags Tab you can see a breakdown of the tags used for the last 7 days

![image.png](https://images.hive.blog/DQmbSxozt4pMMQbmMN8MMoLqnb2K9whkTgu15AEQXVWjqhc/image.png)

## User Map
The highlight this week is the interactive user map. This parses the location information on the full set of user accounts and where a location has been specified by the account holder. 

![image.png](https://images.hive.blog/DQmf92X5grG2Pq62LXEk9Ams4gW98ZfsBz5t64vKtnYJP5G/image.png)

* It's interesting to see the trends over time for some of the countries in the table below the map.

Try the App out today and let me know how you find it in the comments!
https://eroche.shinyapps.io/hiveanalytics/

👍 acidyo, slobberchops, demotruk, livinguktaiwan, steevc, deepresearch, eroche, penguinpablo, jeffjagoe, itchyfeetdonica, richardcrill, blockchainyouth, ninnu, toofasteddie, steemexperience, enforcer48, bil.prag, smartvote, bashadow, belemo, stefano.massari, vallesleoruther, sbi3, rt395, oneshot, eastmael, dilimunanzar, cryptonized, mister-meeseeks, wagnertamanaha, jagoe, photographercr, kgakakillerg, alphacore, hivelist, nicollefiallo, pocketrocket, remenzer, sinochip, leveluplifestyle, raiseup, watersnake101, kimzwarch, intacto, seablue, martibis, hive-169313, onepercentbetter, passion-fruit, fortune-master, policewala, floatinglin, steemaction, larry21, ajaxalot, ghaazi, rendrianarma, wolfofnostreet, ganjafarmer, biglove, steemfestdreams, freebornsociety, floweroflife, gradeon, and 16 others

`author`	eroche
`permlink`	user-account-map-added-to-hive-analytics
`category`	hive-133987
`json_metadata`	{"tags":["hivesql","blockchain","hive","stats"],"users":["demotruck"],"image":["https://images.hive.blog/DQmf92X5grG2Pq62LXEk9Ams4gW98ZfsBz5t64vKtnYJP5G/image.png","https://images.hive.blog/DQmQHrPU19KysbsZNMEC9jJG2bbJmD3YARV6tzDhr5sBzuJ/image.png","https://images.hive.blog/DQmbSxozt4pMMQbmMN8MMoLqnb2K9whkTgu15AEQXVWjqhc/image.png"],"links":["https://eroche.shinyapps.io/hiveanalytics/"],"app":"hiveblog/0.1","format":"markdown"}
`created`	2021-06-12 22:15:09
`last_update`	2021-06-12 22:16:36
`depth`	0
`children`	16
`last_payout`	2021-06-19 22:15:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	4.592 HBD
`curator_payout_value`	4.345 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	1,190
`author_reputation`	70,759,290,299,941
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,294,944
`net_rshares`	17,270,485,672,558
`author_curate_reward`	""

properties (23)vote details (80)

voter	rshares	pct
acidyo	8,630,793,490,684	80%
jeffjagoe	326,169,961,909	100%
demotruk	1,112,255,767,178	100%
steevc	820,556,405,524	50%
penguinpablo	336,652,618,203	6%
richardcrill	293,620,056,586	50%
floweroflife	1,844,283,040	100%
eroche	368,999,540,752	100%
steemfestdreams	2,261,250,996	100%
wagnertamanaha	33,048,095,991	50%
seablue	9,220,182,979	100%
rahul.stan	702,612,305	40%
oneshot	45,656,591,876	100%
ganjafarmer	3,260,622,985	4%
freebornsociety	2,121,503,522	10%
passion-fruit	5,980,799,930	100%
fortune-master	5,979,030,806	100%
rt395	47,977,662,920	100%
alphacore	25,216,292,062	1.81%
wdougwatson	1,172,520,122	34%
livinguktaiwan	843,965,605,474	49%
toofasteddie	149,797,310,694	30%
vallesleoruther	55,932,519,968	100%
watersnake101	12,340,069,597	50%
pocketrocket	22,548,644,497	100%
martibis	8,773,017,414	9.8%
floatinglin	4,890,300,104	100%
bashadow	88,828,338,692	25%
kimzwarch	11,695,112,773	4%
eastmael	43,884,758,088	100%
dilimunanzar	40,361,184,736	100%
itchyfeetdonica	314,622,243,601	50%
elderson	1,043,412,780	2%
cryptonized	35,412,466,348	6%
iwanderela	1,007,755,365	50%
deepresearch	626,185,258,416	67%
sinochip	15,997,575,631	40%
belemo	79,623,435,525	100%
ajaxalot	4,054,230,130	5%
jagoe	29,594,491,347	24%
didutza	798,332,952	50%
blockchainyouth	247,393,184,943	100%
bil.prag	105,180,987,685	20%
onepercentbetter	7,845,036,496	6%
kgakakillerg	26,022,333,467	10%
steemexperience	142,024,280,468	50%
oscurity	1,789,789,930	4%
sbi3	51,996,502,580	1.76%
slobberchops	1,517,848,523,788	30%
enforcer48	121,584,586,546	15%
worldwildflora	1,089,340,008	40%
wolfofnostreet	3,812,957,838	46%
merlion	361,157,454	6%
experienced	1,678,542,152	100%
smartvote	100,886,917,128	4.8%
raiseup	12,453,512,483	6%
steemaction	4,543,651,220	6%
mister-meeseeks	34,670,494,384	40%
stefano.massari	79,191,138,584	48%
goodcontentbot	807,450,589	15%
hungrybear	215,776,779	6%
guysellars	1,050,560,574	100%
photographercr	27,809,291,003	16%
nicollefiallo	22,917,125,497	50%
kgswallet	543,903,546	20%
policewala	5,371,991,623	6%
bilpcoinbpc	514,567,415	5%
zeusflatsak	1,026,777,009	4%
gradeon	1,817,476,489	8%
hivelist	24,870,509,769	8%
ninnu	191,336,316,600	40%
hive-169313	8,151,902,662	100%
ghaazi	3,912,420,091	80%
intacto	10,465,664,361	2%
larry21	4,109,135,548	6%
remenzer	17,665,329,824	100%
biglove	2,574,084,874	100%
rendrianarma	3,903,738,605	40%
leveluplifestyle	15,101,906,826	40%
auliaarma	1,101,451,218	40%

@belemo · Jun 14 '21

$0.14

Does it track location solely based on what is specified in the user profile info or is it like a super computer that will also scour through the user's content over a period of time to make a super smart bot decision?

👍 eroche, stefano.massari

`author`	belemo
`permlink`	re-eroche-quomli
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2021.06.2"}
`created`	2021-06-14 08:08:09
`last_update`	2021-06-14 08:08:09
`depth`	1
`children`	1
`last_payout`	2021-06-21 08:08:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.068 HBD
`curator_payout_value`	0.067 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	218
`author_reputation`	1,001,022,450,983,988
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,321,924
`net_rshares`	446,932,205,425
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
eroche	0 B		369,229,098,859	100%
stefano.massari	0 B		77,703,106,566	48%

@eroche · Jun 14 '21 (edited)

At the moment it's just looking at the user profile info and with some clever text matching it's giving really good results. It can always be made better

It should be possible to extend this incorporate other information also. Some ideas I would like to try out are
* Predominant Languages used in Posts
* Introduce Yourself Posts (are places mentioned in the text)
* Local Meetups Attended

There are some fairly sophisticated GEO matching algorithims out there (for a fee) and where I am seeing stuff that the other methods dont perform well on I may look to using some of these if feasible. Better to start with the easier stuff first if its works good enough :)

properties (22)

`author`	eroche
`permlink`	quoy2j
`category`	hive-133987
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-06-14 12:15:57
`last_update`	2021-06-14 12:19:18
`depth`	2
`children`	0
`last_payout`	2021-06-21 12:15:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	666
`author_reputation`	70,759,290,299,941
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,325,023
`net_rshares`	0

@deepresearch · Jun 14 '21

$0.11

Geographical data might be rough but it mirrors tendencies seen among posts, strong Venezuela, Nigeria, Indonesia, I believe a lot of marketing efforts directed there could give outstanding results in the long term. We need either one killer app or one country mass adopting Hive.

👍 eroche

`author`	deepresearch
`permlink`	re-eroche-2021614t143616470z
`category`	hive-133987
`json_metadata`	{"tags":["hivesql","blockchain","hive","stats"],"app":"ecency/3.0.18-mobile","format":"markdown+html"}
`created`	2021-06-14 12:36:15
`last_update`	2021-06-14 12:36:15
`depth`	1
`children`	0
`last_payout`	2021-06-21 12:36:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.055 HBD
`curator_payout_value`	0.056 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	280
`author_reputation`	128,614,046,688,269
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,325,392
`net_rshares`	370,384,081,456
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
eroche	0 B		370,384,081,456	100%

@dilimunanzar · Jun 12 '21

$0.12

Hi @eroche how do you do my friend :) 
Its so Long time not see your blog buddy

👍 eroche

`author`	dilimunanzar
`permlink`	re-eroche-qum4nn
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2021.06.2"}
`created`	2021-06-12 23:45:27
`last_update`	2021-06-12 23:45:27
`depth`	1
`children`	4
`last_payout`	2021-06-19 23:45:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.060 HBD
`curator_payout_value`	0.060 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	80
`author_reputation`	142,843,119,048,229
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,296,148
`net_rshares`	366,800,646,209
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
eroche	0 B		366,800,646,209	100%

@eroche · Jun 13 '21

Hi buddy.  Its been a while,  good to see you.

properties (22)

`author`	eroche
`permlink`	qumw34
`category`	hive-133987
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-06-13 09:37:54
`last_update`	2021-06-13 09:37:54
`depth`	2
`children`	3
`last_payout`	2021-06-20 09:37:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	46
`author_reputation`	70,759,290,299,941
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,302,260
`net_rshares`	0

@dilimunanzar · Jun 14 '21

It's great to see you again @eroche, how are you there, is the pandemic still there. In Indonesia too, even now in the province of Aceh is improving health procedures in every community activity.

properties (22)

`author`	dilimunanzar
`permlink`	re-eroche-quopl7
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2021.06.2"}
`created`	2021-06-14 09:12:45
`last_update`	2021-06-14 09:12:45
`depth`	3
`children`	2
`last_payout`	2021-06-21 09:12:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	195
`author_reputation`	142,843,119,048,229
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,322,863
`net_rshares`	0

2 replies

@steevc · Jun 13 '21

$0.14

The location data is very patchy and tricky to work with as people will put all sorts of variations. UK can mean Ukraine in some cases. I have been running some queries to find Brits, but it's often not obvious where they are. Have to use other clues that are harder to automate for. Still cool to have that map. Nobody in Greenland? 

!PIZZA

👍 eroche, stefano.massari

`author`	steevc
`permlink`	re-eroche-qunqgh
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2021.06.2"}
`created`	2021-06-13 20:33:54
`last_update`	2021-06-13 20:33:54
`depth`	1
`children`	6
`last_payout`	2021-06-20 20:33:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.070 HBD
`curator_payout_value`	0.071 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	342
`author_reputation`	1,045,287,084,744,801
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,311,686
`net_rshares`	448,818,036,039
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
eroche	0 B		370,384,081,456	100%
stefano.massari	0 B		78,433,954,583	48%

@eroche · Jun 14 '21

$0.03

Really good point on the Countries. There are a few wiseguys in there too living on the Moon :)

The algorithm I am using has been tweaked some time back, but I will keep working on it  to improve it. Adding in a check on languages used in posts and a few other tricks might improve performance.

👍 steevc

`author`	eroche
`permlink`	quolqr
`category`	hive-133987
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-06-14 07:49:39
`last_update`	2021-06-14 07:49:39
`depth`	2
`children`	4
`last_payout`	2021-06-21 07:49:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.024 HBD
`curator_payout_value`	0.007 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	295
`author_reputation`	70,759,290,299,941
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,321,709
`net_rshares`	168,716,882,368
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
steevc	0 B		168,716,882,368	10%

@steevc · Jun 14 '21

$0.11

You can derive some insight from [Pinmapple](https://pinmapple.com/), but a lot of that is people travelling around. It is useful to have some location data and we can see some hotspots like Venezuela. At least we have some useful tools to do analysis with. @HiveSQL is great.

👍 eroche

`author`	steevc
`permlink`	re-eroche-quom2u
`category`	hive-133987
`json_metadata`	{"tags":["hive-133987"],"app":"peakd/2021.06.2"}
`created`	2021-06-14 07:56:54
`last_update`	2021-06-14 07:56:54
`depth`	3
`children`	3
`last_payout`	2021-06-21 07:56:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.055 HBD
`curator_payout_value`	0.055 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	276
`author_reputation`	1,045,287,084,744,801
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,321,793
`net_rshares`	368,580,787,767
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
eroche	0 B		368,580,787,767	100%

3 replies

@pizzabot · Jun 13 '21

<div class='pull-right'><center><sup>Connect</sup></center><p><a href="https://discord.gg/Q9bQAKpWGS"><img src="https://files.peakd.com/file/peakd-hive/pizzabot/AKF96fKjnX3wjXERHcKAFHaoHnfTVhXqPjXVz8E1Th9nPiJqmFtaycosVpPBZ7z.png"></a></p></div><div class='pull-right'><center><sup>Trade</sup></center><p><a href='https://hive-engine.com/?p=market&t=PIZZA'><img src="https://files.peakd.com/file/peakd-hive/pizzabot/23sxbi2M4UjELDzQjxPdzubdgfMjHTCtA1xueyxmnhJUrB8136VyK3pqynyWYiZYF9HrC.png"></a></p></div><center><br> <p>@eroche! I sent you a slice of <strong><em>$PIZZA</em></strong> on behalf of @steevc.</p> <p>Learn more about <strong><em>$PIZZA Token</em></strong> at <a href="https://hive.pizza">hive.pizza</a> <sub>(2/10)</sub></p> </center><div></div>

properties (22)

`author`	pizzabot
`permlink`	re-re-eroche-qunqgh-20210613t203500z
`category`	hive-133987
`json_metadata`	"{"app": "beem/0.24.19"}"
`created`	2021-06-13 20:35:00
`last_update`	2021-06-13 20:35:00
`depth`	2
`children`	0
`last_payout`	2021-06-20 20:35:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	758
`author_reputation`	6,151,190,082,577
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,311,706
`net_rshares`	0

@stefano.massari · Jun 14 '21

$0.11

I like this map of users, thanks for sharing

👍 eroche

`author`	stefano.massari
`permlink`	re-eroche-2021614t212825722z
`category`	hive-133987
`json_metadata`	{"tags":["hivesql","blockchain","hive","stats"],"app":"ecency/3.0.18-mobile","format":"markdown+html"}
`created`	2021-06-14 19:28:24
`last_update`	2021-06-14 19:28:24
`depth`	1
`children`	0
`last_payout`	2021-06-21 19:28:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.054 HBD
`curator_payout_value`	0.054 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	44
`author_reputation`	175,049,347,069,434
`root_title`	"User Account Map Added to Hive Analytics"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,332,289
`net_rshares`	362,977,972,285
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
eroche	0 B		362,977,972,285	100%