User:Pere prlpz
Babel user information | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
Users by language |
Llista de seguiment altres humans
Llocs:
Consultes
[edit]Revisió general
[edit]#Les meves imatges geolocalitzades
SELECT ?file ?coord ?layer ?image
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P1259 ?coord.
?file wdt:P571 ?data.
?file schema:url ?image.
BIND(year(?data) as ?layer)
}
#defaultView:Map
#Coses representades a les meves fotos
SELECT ?item ?itemLabel ?layer ?layerLabel ?coord
WITH {
SELECT DISTINCT ?item WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
}
} AS %1
WHERE {
INCLUDE %1.
SERVICE <https://query.wikidata.org/sparql> {
?item wdt:P31 ?layer.
?item wdt:P625 ?coord .
OPTIONAL{?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "ca").}
OPTIONAL{?layer rdfs:label ?layerLabel.
FILTER(LANG(?layerLabel) = "ca").}
}
}
#defaultView:Map
#Coses representades a les meves fotos i coordenades de les fotos
SELECT ?layer ?coord ?image ?file ?item ?itemLabel
WITH {
SELECT DISTINCT ?item WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
}
} AS %1
WHERE {
{
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P1259 ?coord.
?file schema:url ?image.
VALUES ?layer {"foto"}
}
UNION
{
INCLUDE %1.
SERVICE <https://query.wikidata.org/sparql> {
?item wdt:P625 ?coord .
OPTIONAL{?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "ca").}
VALUES ?layer {"objecte"}
}
}
}
#defaultView:Map
#Coses més representades a les meves fotos
SELECT DISTINCT ?item ?itemLabel (COUNT(DISTINCT(?file)) AS ?totfiles)
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
SERVICE <https://query.wikidata.org/sparql> {
OPTIONAL{?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "ca").}
}
}
GROUP BY ?item ?itemLabel
ORDER BY DESC(?totfiles) ?itemlabel
#Instàncies de coses representades a les meves fotos
SELECT ?inst ?instLabel (COUNT(DISTINCT(?item)) AS ?totitems)
WITH {
SELECT DISTINCT ?item WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
}
} AS %1
WHERE {
INCLUDE %1.
SERVICE <https://query.wikidata.org/sparql> {
?item wdt:P31 ?inst.
OPTIONAL{?inst rdfs:label ?instLabel.
FILTER(LANG(?instLabel) = "ca").}
}
}
GROUP BY ?inst ?instLabel
ORDER BY DESC(?totitems) ?instLabel
# Els meus dies més productius
SELECT DISTINCT ?data (COUNT(DISTINCT(?file)) AS ?totfiles) (COUNT(DISTINCT(?item)) AS ?totitems)
(SAMPLE(?item) AS ?mostraItems) (SAMPLE(?file) AS ?mostraFiles)
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
OPTIONAL {?file wdt:P180 ?item.}
?file wdt:P571 ?data.
}
GROUP BY ?data
#Coses representades més dies a les meves fotos (taula)
SELECT DISTINCT ?item ?itemLabel (COUNT(DISTINCT(?data)) AS ?totdates)
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
OPTIONAL {?file wdt:P571 ?data.}
SERVICE <https://query.wikidata.org/sparql> {
OPTIONAL{?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "ca").}
}
}
GROUP BY ?item ?itemLabel
ORDER BY DESC(?totdates) ?itemlabel
#Coses representades més dies a les meves fotos (mapa)
SELECT DISTINCT ?item ?itemLabel (COUNT(DISTINCT(?data)) AS ?layer) ?coord
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
OPTIONAL {?file wdt:P571 ?data.}
SERVICE <https://query.wikidata.org/sparql> {
?item wdt:P625 ?coord.
OPTIONAL{?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "ca").}
}
}
GROUP BY ?item ?itemLabel ?coord
#defaultView:Map
Revisió amb paràmetre
[edit]#Excursió a la Vall d'Aran (per data)
SELECT ?file ?image ?data ?coord
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P571 ?data.
FILTER("2022-08-13"^^xsd:dateTime <= ?data && ?data <= "2022-08-15"^^xsd:dateTime).
?file schema:url ?image.
OPTIONAL {
?file wdt:P1259 ?coord.
}
}
ORDER BY ?data
#defaultView:ImageGrid
#Fotos meves que representen focs artificials o el que sigui
SELECT ?file ?image
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file schema:url ?image.
?file wdt:P180 wd:Q127933. # canviar pel que sigui
}
#defaultView:ImageGrid
#Fotos meves que representen instàncies d'escola o el que sigui
SELECT ?file ?image
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file schema:url ?image.
?file wdt:P180 ?item.
SERVICE <https://query.wikidata.org/sparql> {
?item wdt:P31 wd:Q111236457# canviar pel que sigui
}
}
#defaultView:ImageGrid
#Coses més representades a les meves fotos per un dia concret
SELECT DISTINCT ?item ?itemLabel (COUNT(DISTINCT(?file)) AS ?totfiles)
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
?file wdt:P571 ?data.
FILTER("2012-04-09"^^xsd:dateTime = ?data).
SERVICE <https://query.wikidata.org/sparql> {
OPTIONAL{?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "ca").}
}
}
GROUP BY ?item ?itemLabel
ORDER BY DESC(?totfiles) ?itemlabel
Manteniment de depicts (P180)
[edit]#Fotos meves que no representen res
SELECT ?file ?image
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file schema:url ?image.
MINUS {?file wdt:P180 []}
}
#defaultView:ImageGrid
#Fotos meves que no representen res, per un any concret
SELECT ?file ?image
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file schema:url ?image.
MINUS {?file wdt:P180 []}
?file wdt:P571 ?data.
FILTER(year(?data)=2015)
}
#defaultView:ImageGrid
#Les meves imatges geolocalitzades que no representen res
SELECT ?file ?coord ?layer ?image
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P1259 ?coord.
?file wdt:P571 ?data.
?file schema:url ?image.
BIND(year(?data) as ?layer)
MINUS {?file wdt:P180 []}
}
#defaultView:Map
#Coses per il·lustrar amb les meves fotos
SELECT DISTINCT ?item ?itemLabel ?file
WHERE {
?file (p:P170/pq:P4174) "Pere prlpz".
?file wdt:P180 ?item.
SERVICE <https://query.wikidata.org/sparql> {
MINUS {?item wdt:P18 []}
OPTIONAL{?item rdfs:label ?itemLabel.
FILTER(LANG(?itemLabel) = "ca").}
}
}
ORDER BY ?item
De tot
[edit]- petscan:28971851 Categories d'ajuntaments de Catalunya sense sitelink (per trobar ajuntaments sense foto a Wikidata amb categoria de fotos a Commons).
De tot, però segurament obsolet.
http://tools.wikimedia.de/~daniel/WikiSense/CheckUsage.php?i=#end
Imatges que he pujat a commons - Compte que no totes són meves
La imatge que no em surt a la galeria perquè algú altre li ha remenat els colors
Category:Images from Wiki Loves Monuments 2011
Les meves contribucions a commons del dia que em vaig oblidar d'iniciar la sessió
Eines i recordatoris
[edit]És habitual trobar propostes d'esborrat de fitxers en ús, que són clarament contràries a les normes:
Keep The logo/map/flag/etc is in use by other Wikimedia projects (several Wikipedia articles) and therefore in scope. According to commons:scope, "It should be stressed that Commons does not exist to editorialise on other projects – that an image is in use on a non talk/user page is enough for it to be within scope." If you feel this logo/map/flag/etc should not be used, you should tell the Wikipedias and try to convince local communities to use another one or not to use any logo/map/flag/etc at all.
{{vk}} The logo/map/flag/etc is in use by other Wikimedia projects (several Wikipedia articles) and therefore in scope. According to [[:commons:scope]], "''It should be stressed that Commons does not exist to editorialise on other projects – that an image is in use on a non talk/user page is enough for it to be within scope.''" If you feel this logo/map/flag/etc should not be used, you should tell the Wikipedias and try to convince local communities to use another one or not to use any logo/map/flag/etc at all.