Hi Andre. Jaime's query is a good starting point, it would get you the data you need for one wiki. We can import the templatelinks table and then we can run it on Hadoop and get all wikis at once (we already have the other tables).
But once we got that, we'd have a graph with millions of nodes and edges. That's not possible to consume in visual form, so you could serve slices of the data and visualize parts of the graph. The question is, then, what purpose would this visualization have? If that's well defined, maybe we can figure out what slices of the data would be most useful. On Tue, Nov 21, 2017 at 2:04 PM, Joseph Allemandou < [email protected]> wrote: > Hi Andre, > I'm not aware of any tool as you describe. > I however think it would be super useful ! > I'll think a bout it some more and possibly draft a ticket. > Cheers > Joseph > > On Tue, Nov 21, 2017 at 4:29 PM, Federico Leva (Nemo) <[email protected]> > wrote: > >> Andre Klapper, 21/11/2017 17:15: >> >>> I've been wondering if anyone's aware of any visualization tool that >>> draws a graph showing which wiki pages are linked from which other wiki >>> pages (up to a certain depth) >>> >> >> The closest thing I can think of is Erik's chart of category links, >> generated with a script which is published somewhere and could be adapted >> at least for simple regex filters. >> https://stats.wikimedia.org/EN/CategoryOverviewIndex.htm >> https://stats.wikimedia.org/wikimedia/pageviews/categorized/ >> >> There's also <http://www.chrisharrison.net/index.php/Visualizations/Clust >> erBall> and a graph of links between user pages, which was made perhaps >> in 2014. >> >> Federico >> >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> > > > > -- > *Joseph Allemandou* > Data Engineer @ Wikimedia Foundation > IRC: joal > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
