Question about using Wikipedia content. About &quot;CC-BY-SA&quot; license. About its &quot;Copyleft/Share Alike&quot; part
<p><strong>What I want to do:</strong>
Let's assume that there is article, on Wikipedia, that is under CC-BY-SA license. For exemple "<a href="https://en.wikipedia.org/wiki/List_of_pies,_tarts_and_flans" rel="nofollow noreferrer">https://en.wikipedia.org/wiki/List_of_pies,_tarts_and_flans</a>". Assume next that I want to get from that article only table that contain list of pies. I want to get <strong>only</strong> it data (only facts, only copying "words" from the "name", "origin" and "type" columns, but not from "description" column ), <strong>without pictures.</strong> Let's assume that I want to create pies database using data from this tables. And than I want to build some website, in which user can get "list of random pies". This "random pies" will, of course, be gotten from that database. At one time, user will get only some limited amount of such pies. For example - generating list of 10 pies - by one pressing of button "generate random pies".</p>

<p><strong>What I already found:</strong>
This type of use, in general, is linked to license on which that article are licensed. This Wikipedia article have license "CC-BY-SA". Also on wikipedia present detailed article on <a href="https://en.wikipedia.org/wiki/Wikipedia:Reusing_Wikipedia_content" rel="nofollow noreferrer">reusing Wikipedia content</a>, where described how to correctly satisfy license terms.
So for now I understand that I need to: make attribution, indicate changes, stick "licensing notice" of used article, and also satisfy "Copyleft/Share Alike" part. Please keep this last, "Share Alike", part in mind.</p>

<p><strong>Also license notes from official site:</strong>
<a href="https://creativecommons.org/licenses/by-sa/3.0/" rel="nofollow noreferrer">https://creativecommons.org/licenses/by-sa/3.0/</a></p>

<p><strong>So, here is my question:</strong>
Trying to satisfy "Copyleft/Share Alike" part:
 - Am I <strong>obligated</strong> to make that database of pies publicly available, and with this also license them in the same license? For example, am I <strong>obligated</strong> to make a button - "download pies database as some file". Or I don't need to do this because I don't share the database directly. I just use some parts of it at once, in not direct way.</p>

<p><strong>What I think about that:</strong>
Problem is that, that I really need to apply the same license on that database if I will be sharing it publicly. If I made it public. Because this database is "build upon", or is something similar to "adaptation" (<a href="https://creativecommons.org/faq/#what-is-an-adaptation" rel="nofollow noreferrer">https://creativecommons.org/faq/#what-is-an-adaptation</a>), of that table ("ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original." (<a href="https://creativecommons.org/licenses/by-sa/3.0/" rel="nofollow noreferrer">https://creativecommons.org/licenses/by-sa/3.0/</a>)). But I don't know, if giving to users of that site, random parts of that pies database - will this be considered as if database is shared publicly.</p>

<p>And I knew that there was such statement that there no copyrights on information. But there copyrights on databases, and also - is this creation of database will be considered as just use of information, but not other things from used tables.</p>

<p><em>So my question is merely about "Copyleft/Share Alike" part. Merely about of obligation of making database public.</em></p>

<p>(For the data you use, you <a href="https://creativecommons.org/faq/#do-i-always-have-to-comply-with-the-license-terms-if-not-what-are-the-exceptions" rel="nofollow noreferrer" title="CC FAQ: &#39;Do I always have to comply with the license terms? If not, what are the exceptions?&#39;"><em>might</em> not have to</a> follow the license. But let’s assume you have to.)</p>

<p>The <a href="https://creativecommons.org/licenses/by-sa/3.0/legalcode" rel="nofollow noreferrer" title="Legal Code: Attribution-ShareAlike 3.0 Unported">license</a> only applies to the content you <em>distribute</em> (or <em>publicly perform</em>, but that’s likely not relevant in your context):</p>

<blockquote>
  <p>"<strong>Distribute</strong>" means to make available to the public the original and copies of the Work or Adaptation, as appropriate, through sale or other transfer of ownership.</p>
</blockquote>

<p>It doesn’t matter what’s saved on your server, it only matters what’s published (i.e., <em>distributed</em>). </p>

<p>So you don’t have to publish the database. You have to attribute the content from the database <strong><em>when</em></strong> and <strong><em>as long</em></strong> you show (i.e., <em>distribute</em>) it. Not earlier nor longer than that.</p>

<p>To generate what is below i used next resources:  </p>

<ul>
<li><a href="https://law.stackexchange.com/questions/27391/question-about-using-wikipedia-content-about-cc-by-sa-license-about-its-cop">law.stackexchange</a>;</li>
<li>en.wikipedia: <a href="https://en.wikipedia.org/wiki/Wikipedia:Teahouse" rel="nofollow noreferrer">Teahouse</a>, and personal Talk page;</li>
<li><a href="https://creativecommons.org/" rel="nofollow noreferrer">creativecommons.org</a> (possibility to write email to them).</li>
</ul>

<p>What is below is only mine interpretation, but I think, that is enough <em>near to source</em> interpretation.</p>

<p><strong>So, approximation to solution:</strong></p>

<ol>
<li>First of all, best way to solve such legal problems, and answer on such question, is to use <a href="https://en.wikipedia.org/wiki/Legal_advice" rel="nofollow noreferrer">legal advice</a>, that can be received from <em>legal experts</em>, like e.g. from copyright lawyer. No one, nor from "Wikipedia", nor from "stackexchange", nor people from "creativecommons" , can give such legal advice (at least on the pages of such sites, and thru emails). It's maybe similar to medical advice, that only advice from professional is such that you can really rely on it. But still people from this sources can give something to work on.</li>
</ol>

<p>Solution is linked to next two questions: <strong>What</strong> is used, and <strong>How</strong> it will be used.</p>

<p><strong>What:</strong></p>

<ol start="2">
<li>In our case we have tables from some article form Wikipedia. Will be used only collection of data from them. And here arise question - what will be controlling correct use of this data? Is this will be <a href="https://creativecommons.org/licenses/by-sa/3.0/" rel="nofollow noreferrer">CC-BY-SA</a> ( from <a href="https://en.wikipedia.org/wiki/Wikipedia:Reusing_Wikipedia_content" rel="nofollow noreferrer">Reusing_Wikipedia_content</a>), by which nearly all content on Wikipedia is licensed (but there present a lot of exceptions). Or it falls under <a href="https://en.wikipedia.org/wiki/Sui_generis_database_right" rel="nofollow noreferrer">Sui_generis_database_right</a>. Or falls under something else. But, <strong>holding in the head statement "1."</strong>, people from Wikipedia, and some from stackexchange, said that this tables, and their content, data, is available under the conditions of "CC-BY-SA".</li>
</ol>

<p>So let's consider that that tables fall under "CC-BY-SA" (<strong>if not</strong> - than what is below <strong>can't be used</strong>).</p>

<p><strong>How:</strong></p>

<ol start="3">
<li>From that how that tables will be used will depend what obligation will be applied. A lot of important things was said by @unor. I add something from myself, also. This all is linked to <a href="https://creativecommons.org/licenses/by-sa/3.0/legalcode" rel="nofollow noreferrer">legalcode of the license</a>. So, as I understand, this license do "in particular" two things. <strong>First</strong> - its grants you with some possibilities. Which include possibility of distribution, and using in other way that is not distribution (e.g. personal use). <strong>Two</strong> - this license has some conditions that if you want to use tables you must follow them. This conditions include: "attribution", and "sharealike" parts. <strong>But what is very important is that that this two conditions must be done only when you distribute something, and only on that parts that you distribute.</strong> Better is to read original answer of @unor, there present some very important things.  </li>
</ol>

<p>General considerations:</p>

<ol start="4">
<li>This all is only some approximation to solution. And one must think before use it somehow, because that this solution still can be wrong (or can be not). Also web developers must consider that they not only need to follow laws of their own country, but (maybe) also laws of country where will be stay server with web-app, and also laws of countries, of users. This is still open question for me. But there was already some discussion about it (<a href="http://www.webhostingtalk.com/showthread.php?t=1465264" rel="nofollow noreferrer">http://www.webhostingtalk.com/showthread.php?t=1465264</a>).</li>
</ol>

<p><em>All nuances is hard to close by oneself, and there are many of them. So - professional advice, legal advice, is may be the best way. But, also,  there can be some safe, small, things that developer can do by himself.</em></p>

<p>You don't only have to worry about copyright.  A number of jurisdictions (in particular all the jurisdictions of the European Union) have a <a href="https://en.wikipedia.org/wiki/Sui_generis_database_right" rel="nofollow noreferrer">database right</a>.
Note that the term "database" doesn't just mean MySQL or similar.  The table on the Wiki page counts.</p>

<p>All text content (and most images) from Wikipedia is available under the CC-BY-SA (v3.0) license. That license pretty clearly spells out the rights it grants and the obligations it imposes. The most important obligation is that if you distribute content that you have obtained under that license, you must place it under the same license. You also need to attribute the content to the source. That much is pretty clear.</p>

<p>Facts, which i would think include individual numbers, are generally not subject to copyright. However, collections of facts, and arrangements of facts are. If you used only one or two numbers, copyright is probably not an issue. Beyond that, if you don't want to accept the CC-BY-SA license, you should probably consult a copyright lawyer, as the question of how else you might use the content legally may be a bit tricky. </p>

<p>I am not a lawyer, and this should not be taken as legal advice.</p>

copyright creative-commons