User:JotaCartas/Queries
index edit
Portugal edit
- página de desambiguação da Wikimedia (Q4167410)
- categoria de Wikimedia (Q4167836)
- artigo de lista da Wikimedia (Q13406463)
- human settlement (Q486972)
- third-level administrative country subdivision (Q13221722)
- single entity of population (Q3055118) retirar
- village (Q532)village - aldeia
- suburb (Q188509) subúrbio - arredores
- quarter (Q2983893) - bairro
- neighborhood (Q123705) - subúrbio - arredores
- locality (Q3257686) - localidade
- human settlement (Q486972) - povoamento humano - povoação - povoação
EN | WD | PT | EN pai | |
---|---|---|---|---|
city of Portugal | Q15647906 | cidade de Portugal | Q515 | city |
district of Portugal | Q3032141 | distrito de Portugal | ||
mancomunidad | Q531230 | entidade intermunicipal | ||
Intermunicipal communitie of Portugal | Q27995043 | entidade Intermunicipal de Portugal | ||
freguesia | Q1131296 | freguesia | Q13221722 | third-level administrative country subdivision |
lugar | Q130360 | lugar | ||
municipality of Portugal | Q13217644 | município de Portugal | Q15284 | municipality |
province of Portugal | Q24206770 | província de Portugal | ||
overseas province of Portugal | Q333542 | província ultramarina | ||
autonomous region of Portugal | Q2914565 | região autónoma de Portugal | ||
region of Portugal | Q17297619 | região de Portugal | ||
reitoria of Portugal | Q21528797 | reitoria | ||
subregion of Portugal | Q15630525 | sub-região de Portugal | ||
town of Portugal | Q19833170 | vila de Portugal | Q3957 | town |
Cebuano tradutor edit
- freguesia - parokya
- minicípio -munisipyo
- distrito - distrito
- cidade - lungsod - syudad (city)
- vila - lungsod (town)
- capital _ kapital
Working with sitelinks edit
Countries that have sitelinks to en-wiki edit
SELECT ?country ?countryLabel ?article WHERE {
?country wdt:P31 wd:Q3624078 . # sovereign state
?article schema:about ?country .
?article schema:isPartOf <https://en.wikipedia.org/>.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en"
}
}
Last monumentos edit
- ?item (wdt:P131/wdt:P279?) wd:Q36433. #Porto
- minus {
- ?article2 schema:about ?item .
- ?article2 schema:isPartOf <https://commons.wikimedia.org/> . #Commons
- }
- ?desig wdt:P31 wd:Q45580643 .
- ?article schema:about ?item;
- schema:isPartOf <https://pt.wikipedia.org/>.
SELECT ?item ?itemLabel ?wiki ?iges ?sipa ?coo WHERE {
{ ?item wdt:P2186 ?wiki. }
{ ?item wdt:P17 wd:Q45. }
{ ?item wdt:P1435 wd:Q54163210. }
MINUS { ?item wdt:P625 ?coo. }
{ ?item wdt:P1702 ?iges. }
MINUS { ?item wdt:P1700 ?sipa. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "pt". }
}
Obter páginas wikipedias pt,en,commons edit
SELECT ?item ?itemLabel ?article ?article1 ?article2 WHERE {
?item (wdt:P131/wdt:P279?) wd:Q36433. #Porto
{?item wdt:P1702 [] . } #iges
UNION
{ ?item wdt:P1700 [] . } #sipa
?article schema:about ?item .
?article schema:isPartOf <https://pt.wikipedia.org/> . #WP.pt
?article1 schema:about ?item .
?article1 schema:isPartOf <https://en.wikipedia.org/> . #WP.en
?article2 schema:about ?item .
?article2 schema:isPartOf <https://commons.wikimedia.org/> . #Commons
SERVICE wikibase:label {
bd:serviceParam wikibase:language "pt"
}
}
Query by natural language edit
Falta label em Braileiro com label em Portuguese edit
Search for labels in other languages that do not exist in a target language. Can be input for QuickStatements.
Example: instance of human with country of citizenship Belgium with missing Brasilia label:
SELECT ?item ?itemLabel ?itemDescription ?langlabel1Label ?langlabelLabel WHERE {
# ?item wdt:P31 wd:Q5.
# ?item wdt:P27 wd:Q31.
?item (p:P31/ps:P31/wdt:P279*) wd:Q28797. #item é instance of applied science (Q28797) e todas as subclasses
SERVICE wikibase:label { bd:serviceParam wikibase:language "pt,pt-br,en". }
?item rdfs:label ?langlabel1.
FILTER((LANG(?langlabel1)) = "pt") #tem label em Portugues
FILTER(NOT EXISTS {
?item rdfs:label ?langlabel.
FILTER(LANG(?langlabel) = "pt-br") #falta label em Brasileiro
})
}
ORDER BY ?itemLabel
Query de qualifiers edit
SELECT ?item ?itemLabel ?instaceOfStatement ?endTime WHERE {
?item wdt:P31 wd:Q1131296 . #instance of 'freguesia'
?item p:P31 ?instaceOfStatement . #obtem qual o statment of P31
?instaceOfStatement ps:P31 wd:Q1131296 . #o statment será igual a 'freguesia'
?instaceOfStatement pq:P582 ?endTime . #o qualifier será 'end time'
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
LIMIT 100
Obter aliases edit
SELECT DISTINCT ?item ?label ?alias WHERE {
{?item wdt:P131/wdt:P279? wd:Q36433 .}
{?item wdt:P1702 ?omim }
?item rdfs:label ?label . FILTER(lang(?label) = 'pt' )
OPTIONAL {
?item skos:altLabel ?alias . FILTER(lang(?alias) = 'pt' )
}
}
convert labels minuscula edit
SELECT ?item ?langlabelLabel ?langlabel2Label ?langlabel3Label ?itemDescription WHERE {
{ ?item wdt:P279/wdt:P279? wd:Q811979 . } #sub classes
UNION
{ ?item wdt:P31/wdt:P279? wd:Q811979 . } #items
MINUS { ?item wdt:P31 wd:Q4167410 . } #disambig
MINUS { ?item wdt:P31 wd:Q4167836 . } #category
MINUS { ?item wdt:P31 wd:Q13406463 . } #list article
MINUS { ?item wdt:P17 []. } #sem pais
?item rdfs:label ?langlabel.
FILTER((LANG(?langlabel)) = "en") #tem label em ingles
?item rdfs:label ?langlabel2.
FILTER((LANG(?langlabel2)) = "pt") #tem label em Portugues
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,pt". }
}
LIMIT 5000
convert labels minuscula v3 edit
#alterar MAIUS - minus Thesaurus encylopedia
SELECT ?item ?langlabelEN ?langlabelPT
WHERE
{
?item wdt:P1711 [] . #British Museum person-institution
MINUS { ?item wdt:P1014 [] . } #AAT ID ID -tratado
MINUS { ?item wdt:P3916 [] . } #UNESCO Thesaurus ID -tratado
MINUS { ?item wdt:P508 [] . } #BNCF Thesaurus ID -tratado
MINUS { ?item wdt:P3219 [] . } #Encyclopædia Universalis -tratado
MINUS { ?item wdt:P2581 [] . } #babelNET -tratado
MINUS { ?item wdt:P1417 [] . } #britanica -tratado
MINUS { ?item wdt:P3417 [] . } #Quora ID -tratado
# MINUS { ?item wdt:P830 [] . } #encylopedia of LIFE
# MINUS { ?item wdt:P1566 [] . } #geonames
# MINUS { ?item wdt:P213 [] . } #ISNI
# MINUS { ?item wdt:P31 wd:Q5 . } #human
?item rdfs:label ?langlabelPT.
FILTER(LANG(?langlabelPT) = "pt")
?item rdfs:label ?langlabelEN.
FILTER(LANG(?langlabelEN) = "en")
# SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
OFFSET 0
LIMIT 100000
exemplo the uso de regexp, rank edit
SELECT ?item ?itemLabel ?value ?rank
WHERE
{
{
SELECT ?item ?value ?rank
WHERE
{
?item p:P345 [ ps:P345 ?value; wikibase:rank ?rank ]
FILTER( REGEX( STR( ?value ), "^(ch)\\d{7}$" ) ) .
FILTER( ?rank != wikibase:DeprecatedRank )
FILTER( ?item NOT IN ( wd:Q4115189, wd:Q13406268, wd:Q15397819 ) ) .
}
} .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
exemplo the uso de qualifiers edit
SELECT ?item ?itemLabel ?itemdesc ?concelhoLabel ?distritoLabel
WHERE {
?item wdt:P17 wd:Q45 .
?item wdt:P31 wd:Q1131296.
?item wdt:P131 ?concelho .
?concelho wdt:P131 ?distrito .
?item schema:description ?itemdesc.
FILTER(LANG(?itemdesc) = "pt")
MINUS { ?item wdt:P1566 [] . }
?item p:P31 ?statement.
?statement ps:P31 ?instance .
MINUS { ?statement pq:P582 ?endtime . }
MINUS { ?statement pq:P580 ?starttime . }
MINUS { ?item wdt:P31/wdt:P279* wd:Q486972. } #povoamento
MINUS {
?article1 schema:about ?item .
?article1 schema:isPartOf <https://ceb.wikipedia.org/> . #WP.pt
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
Ordens edit
#CATEGORIA PARA RECIPIENTES DE UM GRAU DE ORDEM SEM COMMONS
SELECT DISTINCT ?item ?itemLabel ?grau ?grauLabel ?order ?orderLabel
WHERE
{
?item wdt:P301 ?grau . #catego art princ grau
?grau wdt:P361 ?order . #grau parte de ordem
?order wdt:P31/wdt:P279* wd:Q193622 . #ordem intance order
?order wdt:P17 wd:Q45 .
?grau wdt:P17 wd:Q45 .
MINUS { ?article2 schema:about ?item .
?article2 schema:isPartOf <https://commons.wikimedia.org/> . #Commons
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE], en , pt". }
}
Todos recipientes ordens port edit
#Todos recipientes ordens port
SELECT ?item ?itemLabel ?article
WHERE
{
{ ?item wdt:P166 ?rank .
?rank wdt:P361 ?order .
?order wdt:P31/wdt:P279* wd:Q193622 .
?order wdt:P17 wd:Q45.
?rank wdt:P17 wd:Q45.
?article schema:about ?item .
?article schema:isPartOf <https://pt.wikipedia.org/> . #WP.pt
}
UNION
{ ?item wdt:P166 ?order .
?order wdt:P31/wdt:P279* wd:Q193622 .
?order wdt:P17 wd:Q45.
?article schema:about ?item .
?article schema:isPartOf <https://pt.wikipedia.org/> . #WP.pt
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Carregar referências edit
#Carregar referênciaa
SELECT ?itemLabel ?item ?rank
WHERE {
?item wdt:P166 ?rank .
{ ?rank wdt:P361 wd:Q93932 . } UNION
{ ?rank wdt:P361 wd:Q11696769 . } UNION
{ ?rank wdt:P361 wd:Q23657078 . } UNION
{ ?rank wdt:P361 wd:Q1515829 . } UNION
{ ?rank wdt:P361 wd:Q2083850 . } UNION
{ ?rank wdt:P361 wd:Q743230 . } UNION
{ ?rank wdt:P361 wd:Q93488 . } UNION
{ ?rank wdt:P361 wd:Q639335 . } UNION
{ ?rank wdt:P361 wd:Q495686 . }
MINUS { ?item wdt:P17 wd:Q45 . }
MINUS { ?item wdt:P31 wd:Q5 . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],pt,en". }
}
COUNT, DISTINCT, GROUP BY edit
#COUNT, DISTINCT, GROUP BY
SELECT ?item ?itemLabel (COUNT (DISTINCT ?order ) AS ?count) WHERE {
?item wdt:P166 ?rank .
?rank wdt:P361 ?order .
{?rank wdt:P361 wd:Q23657078 . }
UNION
{?rank wdt:P361 wd:Q639358 . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],pt,en". }
}
GROUP BY ?item ?itemLabel
Sem referencias edit
#Sem referencias
SELECT ?itemLabel ?item ?rank ?ref ?refLabel
WHERE {
?item wdt:P166 ?rank .
{ ?rank wdt:P361 wd:Q93932 . } UNION #militar torre espada
{ ?rank wdt:P361 wd:Q11696769 . } UNION #militar cristo
{ ?rank wdt:P361 wd:Q23657078 . } UNION #militar avis
{ ?rank wdt:P361 wd:Q1515829 . } UNION #militar santiago
{ ?rank wdt:P361 wd:Q2083850 . } UNION #imperio
{ ?rank wdt:P361 wd:Q743230 . } UNION #liberdade
{ ?rank wdt:P361 wd:Q93488 . } UNION #infante
{ ?rank wdt:P361 wd:Q639335 . } UNION #Merito
{ ?rank wdt:P361 wd:Q495686 . } UNION #Public Instruction
{ ?rank wdt:P361 wd:Q2029023 . } UNION #Merito empresarial
{ ?rank wdt:P361 wd:Q10341302 . } UNION #torre espada
{ ?rank wdt:P361 wd:Q840941 . } UNION #cristo
{ ?rank wdt:P361 wd:Q639358 . } UNION #avis
{ ?rank wdt:P361 wd:Q67041645 . } UNION #santiago
{ ?rank wdt:P361 wd:Q16142399 . } UNION #duas bandas
{ ?rank wdt:P361 wd:Q347377 . } UNION #tres bandas
{ ?rank wdt:P361 wd:Q1604729 . } UNION #vila vico
{ ?rank wdt:P361 wd:Q1228761 . } UNION #isabel
{ ?rank wdt:P361 wd:Q1696581 . } #miguel ala
MINUS {
?item p:P166 ?statement.
?statement ps:P166 ?rank.
?statement prov:wasDerivedFrom ?refnode.
{ ?refnode pr:P854 ?ref. } UNION
{ ?refnode pr:P143 ?ref. } UNION
{ ?refnode pr:P4656 ?ref. } UNION
{ ?refnode pr:P248 ?ref. }
}
# FILTER (SUBSTR(str(?ref), 1 , 40) = "http://www.ordens.presidencia.pt/?idc=15") .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY ?itemLabel
Qualifiers edit
#Qualifiers
SELECT ?item ?itemLabel ?itemDescription ?propLabel ?pq_pred ?pq_obj WHERE {
?item wdt:P17 wd:Q45 .
?item wdt:P31 wd:Q1131296 .
?item p:P31 ?award_statement .
?award_statement ps:P31 wd:Q1131296 . # freguesia
# FILTER NOT EXISTS {
?award_statement pq:P582 ?pq_obj . # a triple involving the freguesia ...
?prop wikibase:qualifier pq:P582 . # ... with a predicate pq:P582 that is a qualifier
# }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
Freguesias antigas edit
#Freguesias antigas
SELECT distinct ?item ?itemLabel ?locadm ?locadmLabel ?conadm ?conadmLabel ?locloc ?loclocLabel ?conloc ?conlocLabel ?locendTime
WHERE
{
{ ?item wdt:P131/wdt:P131* wd:Q2915956 . } #portugal
{ ?item wdt:P131 ?locadm . } #locadm
{ ?locadm wdt:P131 ?conadm . } #conadm
{ ?conadm wdt:P31 wd:Q13217644 . } #freguesia
{ ?locadm wdt:P31 wd:Q1131296 . } #freguesia
# ?locadm p:P31 ?instaceOfStatement . #obtem qual o statment of P31
# ?instaceOfStatement ps:P31 wd:Q1131296 . #o statment será igual a 'freguesia'
# ?instaceOfStatement pq:P580 ?admstarTime . #o qualifier será 'start time'
{ ?item wdt:P276 ?locloc . } #local
{ ?locloc wdt:P131 ?conloc . } #conadm
{ ?conloc wdt:P31 wd:Q13217644 . } #freguesia
{ ?locloc wdt:P31 wd:Q1131296 . } #freguesia
?locloc p:P31 ?instaceOfStatement . #obtem qual o statment of P31
?instaceOfStatement ps:P31 wd:Q1131296 . #o statment será igual a 'freguesia'
?instaceOfStatement pq:P582 ?locendTime . #o qualifier será 'end time'
SERVICE wikibase:label { bd:serviceParam wikibase:language "pt". }
}
Farois selecionar para AWB edit
- Farois selecionar para AWB
SELECT ?place ?elev ?unit ?unitLabel ?comm WHERE {
?place wdt:P31/wdt:P279* wd:Q39715. # Must be of a lighthouse ?place p:P2923/psv:P2923 ?placeElev. ?placeElev wikibase:quantityAmount ?elev. ?placeElev wikibase:quantityUnit ?unit. ?comm schema:about ?place ; schema:isPartOf <https://commons.wikimedia.org/> . bind(1 as ?km). filter( (?elev < ?km*11 && ?unit = wd:Q11573) || (?elev < ?km*36.091 && ?unit = wd:Q3710) || (?elev < ?km && ?unit = wd:Q828224) ).
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,es,de" } }
LIMIT 2000
Farois analisar tudo edit
#Farois analisar tudo
SELECT ?itemLabel ?item ?wikiLabel ?sipa ?dgpc ?heritageLabel ?cultLabel
# ?marine ?partof ?data ?arlhs ?official ?cultLabel ?focal ?alt ?pornum ?admiral ?nga ?retir ?charact ?range
WHERE
{
?item wdt:P31/wdt:P279* wd:Q39715. # Must be of a lighthouse
?item wdt:P17 wd:Q45. # Must be of a heritage
OPTIONAL { ?item wdt:P2186 ?wiki . }
OPTIONAL { ?item wdt:P730 ?retir . }
OPTIONAL { ?item wdt:P706 ?official . }
OPTIONAL{ ?item wdt:P1030 ?charact . }
OPTIONAL{ ?item wdt:P2923 ?focal . }
OPTIONAL{ ?item wdt:P31 ?cult . }
OPTIONAL { ?item wdt:P2048 ?alt . }
OPTIONAL { ?item wdt:P1702 ?dgpc . }
OPTIONAL { ?item wdt:P2929 ?range . }
OPTIONAL { ?item wdt:P1435 ?heritage . }
OPTIONAL { ?item wdt:P361 ?partof . }
OPTIONAL { ?item wdt:P2980 ?arlhs . }
OPTIONAL { ?item wdt:P571 ?data . }
OPTIONAL { ?item wdt:P1700 ?sipa . }
OPTIONAL { ?item wdt:P3563 ?nga . }
OPTIONAL { ?item wdt:P3601 ?marine . }
OPTIONAL { ?item wdt:P4423 ?pornum . }
OPTIONAL { ?item wdt:P3562 ?admiral . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}
ORDER BY DESC(?elev)
LIMIT 20000
Marinha analisar tudo edit
#Marinha analisar tudo
SELECT ?item ?itemLabel ?instLabel ?subclaLabel ?vesselLabel ?serv ?incep ?pennant
WHERE
{
?item wdt:P31 ?inst . # instance classe navio e subclasses
OPTIONAL { ?item wdt:P571 ?incep . } #numero vessel class
OPTIONAL { ?item wdt:P18 ?foto . } #numero vessel class
OPTIONAL { ?item wdt:P289 ?vessel . } #numero vessel class
OPTIONAL { ?item wdt:P879 ?pennant . } #numero amura
OPTIONAL { ?item wdt:P279 ?subcla . } #numero subcal
OPTIONAL { ?item wdt:P1813 ?short . } # short
OPTIONAL { ?item wdt:P729 ?serv . } # operator portuguese navy
?item wdt:P137 wd:Q588089 . # operator portuguese navy
# FILTER NOT EXISTS { ?item wdt:P18 ?foto . } # operator portuguese navy
?item wdt:P137 ?navy . # Must be of a ca
optional {?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}
Marinha sem fotos edit
#Marinha sem fotos
SELECT ?item ?itemLabel ?serv ?servret
WHERE
{
?item wdt:P31 ?inst . # instance classe navio e subclasses
?item wdt:P137 wd:Q588089 . # operator portuguese navy
?item wdt:P137 ?navy . # Must be of a ca
OPTIONAL { ?item wdt:P729 ?serv . } # operator portuguese navy
OPTIONAL { ?item wdt:P730 ?servret . } # operator portuguese navy
FILTER NOT EXISTS { ?item wdt:P18 ?foto . } # operator portuguese navy
optional {?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language, if not, then en language
}
Marinha ultimo edit
SELECT distinct ?item ?itemLabel ?instLabel ?powered ?serv ?foto # ?instLabel ?lenght # ?draft ?beam ?serv ?refurl ?evento ?eventoLabel
# ?operatorLabel ?propriLabel ?itemDescription
# ?foto # ?instLabel ?itemDescription # ?foto # ?itemAltLabel # ?servret ?pennant ?differ ?instLabel
# ?operatorLabel ?topic ?classLabel ?foto # ?mass ?serv
# ?countryLabel ?manufLabel ?manuf ?incep ?catshipname ?imo ?manuf
# ?vesselLabel ?namedLabel ?subclaLabel ?vesselLabel
# ?itemDescription ?itemAltLabel
WHERE
{
{ ?item wdt:P31 ?inst . } # instance - tipo de navio
{ ?item wdt:P31/wdt:P279* wd:Q1229765 . } # instancia - watercraft e subclasses
UNION { ?item wdt:P31/wdt:P279* wd:Q559026 . } # instancia - ship class
{ ?item wdt:P137 ?navy . } # operator ?navi
{ ?item wdt:P137 wd:Q588089 . } # operator portuguese navy
#ver daqui
# { ?item wdt:P495/wdt:P361* wd:Q200464 . } # pais origem - imperio portugues
# { ?item wdt:P495/wdt:P361* wd:Q148 . } # pais origem - imperio portugues
# ate aqui
# { ?item wdt:P31 wd:Q5258439 . } # inst - galeota real
# { ?item wdt:P516 wd:Q25999 . } # powered by sail
# { ?item wdt:P31/wdt:P279* wd:Q559026 . }
# FILTER NOT EXISTS { ?item wdt:P373 ?comcat . } # comons cat
# FILTER NOT EXISTS { ?item wdt:P186 ?made . } # made from material
# FILTER NOT EXISTS { ?item wdt:P31/wdt:P279* wd:Q559026 . }
# FILTER NOT EXISTS { ?item wdt:P176 ?manuf . } #numero vessel class
# filter not exists { ?item wdt:P31 wd:Q12859788 . }
# { ?item wdt:P31 wd:Q214196. } #canhoneira
#caracte ----------------------------------------------------------------------
OPTIONAL { ?item wdt:P516 ?powered . } # 1 powered by - motores
optional { ?item wdt:P2067 ?mass . } # 2 mass
OPTIONAL { ?item wdt:P2043 ?lenght . } # 31 length comprimento
OPTIONAL { ?item wdt:P2261 ?beam . } # 32 beam boca
OPTIONAL { ?item wdt:P2262 ?draft . } # 33 draft calado
OPTIONAL { ?item wdt:P4511 ?pontal . } # 34 vertical depth - (ver PetScan) pontal (P2048)
Optional { ?item wdt:P1083 ?guarn . } # 4 capacidade maxima - guarniçao
Optional { ?item wdt:P520 ?armament . } # 5 armamento (ver PetScan) Q1330003 torpedo tube
OPTIONAL { ?item wdt:P2052 ?speed . } # 6 speed
#fim caracte ----------------------------------------------------------------------
OPTIONAL { ?item wdt:P7782 ?catshipname . } # operator portuguese navy
OPTIONAL { ?item wdt:P289 ?class . } # numero vessel class
OPTIONAL { ?item wdt:P607 ?conflit . } # numero conflit war
OPTIONAL { ?item wdt:P373 ?commonscat . } # operator portuguese navy
OPTIONAL { ?item wdt:P495 ?country . } # numero vessel clas
OPTIONAL { ?item wdt:P1071 ?criado . } # criado em
OPTIONAL { ?item wdt:P1889 ?differ . } # different
OPTIONAL { ?item wdt:P793 ?evento . } # evento
OPTIONAL { ?item wdt:P18 ?foto . } # foto
OPTIONAL { ?item wdt:P458 ?imo . } # operator portuguese navy
OPTIONAL { ?item wdt:P571 ?incep . } # numero vessel class
OPTIONAL { ?item wdt:P1071 ?local . } # location of cration
OPTIONAL { ?item wdt:P176 ?manuf . } # numero vessel class
OPTIONAL { ?item wdt:P138 ?named . } # numero vessel class
OPTIONAL { ?item wdt:P137 ?operator . } # numero amura
OPTIONAL { ?item wdt:P495 ?paisori . } # pais de origem
OPTIONAL { ?item wdt:P879 ?pennant . } # numero amura
OPTIONAL { ?item wdt:P127 ?propri . } # proprietario owned b
OPTIONAL { ?item wdt:P973 ?refurl . } # proprietario referencia URL
OPTIONAL { ?item wdt:P729 ?serv . } # operator portuguese navy
OPTIONAL { ?item wdt:P730 ?servret . } # operator portuguese navy
OPTIONAL { ?item wdt:P1813 ?short . } # short
OPTIONAL { ?item wdt:P279 ?subcla . } # numero subcal
OPTIONAL { ?item wdt:P910 ?topic . } # topico
# OPTIONAL {?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language,
#defaultView:Map if not, then en language
# ?article2 schema:about ?item .
# ?article2 schema:isPartOf <https://commons.wikimedia.org/> . #Commons
#FILTER(NOT EXISTS {
# ?item schema:description ?itemdesc.
# FILTER(LANG(?itemdesc) = "pt")
# })
# ?article1 schema:about ?item .
# ?article1 schema:isPartOf <https://pt.wikipedia.org/> . #WP.en
}
#Limit 50
# order by ?serverv
Obter propriedades edit
# items with most values of the property P1700
# added by User:Infovarius, 2019-07-15
SELECT ?item ?itemLabel ?event ?eventLabel
{
# ?item wdt:P1700 ?value
{ ?item wdt:P137 wd:Q172771 . } UNION #navy hms
{ ?item wdt:P137 wd:Q11220 . } UNION #uss
{ ?item wdt:P137 wd:Q217406 . } #frenca
{ ?item wdt:P793 ?event . } #evento notavel
# ?item ?propri ?value .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?cnt)
LIMIT 20000
Contar propriedades edit
# items with most values of the property P1700
# added by User:Infovarius, 2019-07-15
SELECT ?item ?itemLabel ?cnt
{
{
SELECT ?item (COUNT(?value) AS ?cnt)
{
# ?item wdt:P1700 ?value
{ ?item wdt:P137 wd:Q172771 . } UNION #navy hms
{ ?item wdt:P137 wd:Q11220 . } UNION #uss
{ ?item wdt:P137 wd:Q217406 . } #frenca
# { ?item wdt:P793 ?event . } #evento notavel
?item ?propri ?value .
}
GROUP BY ?item ORDER BY DESC(?cnt) LIMIT 100
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?cnt)
Marinha ultimo novembro edit
SELECT distinct ?item ?itemLabel ?lenght ?refURL #?serv ?manufLabel ?criadoLabel ?countryLabel # ?localLabel # ?foto # ?instLabel ?powered ?serv # ?foto # ?instLabel ?lenght # ?draft ?beam ?serv ?refurl ?evento ?eventoLabel
# ?operatorLabel ?propriLabel ?itemDescription
# ?foto # ?instLabel ?itemDescription # ?foto # ?itemAltLabel # ?servret ?pennant ?differ ?instLabel
# ?operatorLabel ?topic ?classLabel ?foto # ?mass ?serv
# ?countryLabel ?manufLabel ?manuf ?incep ?catshipname ?imo ?manuf
# ?vesselLabel ?namedLabel ?subclaLabel ?vesselLabel
# ?itemDescription ?itemAltLabel
WHERE
{
{ ?item wdt:P31 ?inst . } # instance - tipo de navio
{ ?item wdt:P31/wdt:P279* wd:Q1229765 . } # instancia - watercraft e subclasses
# UNION
# { ?item wdt:P31/wdt:P279* wd:Q559026 . } # instancia - ship class
{ ?item wdt:P137 ?navy . } # operator ?navi
{ ?item wdt:P137 wd:Q588089 . } # operator portuguese navy
#novo
# ?item wdt:P2043 ?lenght .
# ?item p:P2043 [ prov:wasDerivedFrom [ pr:P958 ?refURL ] ] .
#novo fim
#ver daqui
# { ?item wdt:P495/wdt:P361* wd:Q200464 . } # pais origem - imperio portugues
# { ?item wdt:P495/wdt:P361* wd:Q148 . } # pais origem - imperio portugues
# ate aqui
# { ?item wdt:P31 wd:Q5258439 . } # inst - galeota real
# { ?item wdt:P516 wd:Q25999 . } # powered by sail
# { ?item wdt:P31/wdt:P279* wd:Q559026 . }
# FILTER NOT EXISTS { ?item wdt:P373 ?comcat . } # comons cat
# FILTER NOT EXISTS { ?item wdt:P186 ?made . } # made from material
# FILTER NOT EXISTS { ?item wdt:P31/wdt:P279* wd:Q559026 . }
# FILTER NOT EXISTS { ?item wdt:P176 ?manuf . } #numero vessel class
# filter not exists { ?item wdt:P31 wd:Q12859788 . }
# { ?item wdt:P31 wd:Q214196. } #canhoneira
#caracte ----------------------------------------------------------------------
# OPTIONAL { ?item wdt:P516 ?powered . } # 1 powered by - motores
# optional { ?item wdt:P2067 ?mass . } # 2 mass
OPTIONAL { ?item wdt:P2043 ?lenght . } # 31 length comprimento
# OPTIONAL { ?item wdt:P2261 ?beam . } # 32 beam boca
# OPTIONAL { ?item wdt:P2262 ?draft . } # 33 draft calado
# OPTIONAL { ?item wdt:P4511 ?pontal . } # 34 vertical depth - (ver PetScan) pontal (P2048)
# Optional { ?item wdt:P1083 ?guarn . } # 4 capacidade maxima - guarniçao
# Optional { ?item wdt:P520 ?armament . } # 5 armamento (ver PetScan) Q1330003 torpedo tube
# OPTIONAL { ?item wdt:P2052 ?speed . } # 6 speed
#fim caracte ----------------------------------------------------------------------
OPTIONAL { ?item wdt:P7782 ?catshipname . } # operator portuguese navy
OPTIONAL { ?item wdt:P289 ?class . } # numero vessel class
OPTIONAL { ?item wdt:P607 ?conflit . } # numero conflit war
OPTIONAL { ?item wdt:P373 ?commonscat . } # operator portuguese navy
OPTIONAL { ?item wdt:P495 ?country . } # numero vessel clas
OPTIONAL { ?item wdt:P1071 ?criado . } # criado em
OPTIONAL { ?item wdt:P1889 ?differ . } # different
OPTIONAL { ?item wdt:P793 ?evento . } # evento
OPTIONAL { ?item wdt:P18 ?foto . } # foto
OPTIONAL { ?item wdt:P458 ?imo . } # operator portuguese navy
OPTIONAL { ?item wdt:P571 ?incep . } # numero vessel class
OPTIONAL { ?item wdt:P1071 ?local . } # location of cration
OPTIONAL { ?item wdt:P176 ?manuf . } # numero vessel class
OPTIONAL { ?item wdt:P138 ?named . } # numero vessel class
OPTIONAL { ?item wdt:P137 ?operator . } # numero amura
OPTIONAL { ?item wdt:P495 ?paisori . } # pais de origem
# OPTIONAL { ?item wdt:P879 ?pennant . } # numero amura
# OPTIONAL { ?item wdt:P127 ?propri . } # proprietario owned b
OPTIONAL { ?item wdt:P973 ?refurl . } # proprietario referencia URL
OPTIONAL { ?item wdt:P729 ?serv . } # operator portuguese navy
# OPTIONAL { ?item wdt:P730 ?servret . } # operator portuguese navy
# OPTIONAL { ?item wdt:P1813 ?short . } # short
# OPTIONAL { ?item wdt:P279 ?subcla . } # numero subcal
# OPTIONAL { ?item wdt:P910 ?topic . } # topico
# OPTIONAL {?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } # Helps get the label in your language,
#defaultView:Map if not, then en language
# ?article2 schema:about ?manuf .
# ?article2 schema:isPartOf <https://commons.wikimedia.org/> . #Commons
#FILTER(NOT EXISTS {
# ?item schema:description ?itemdesc.
# FILTER(LANG(?itemdesc) = "pt")
# })
# ?article1 schema:about ?item .
# ?article1 schema:isPartOf <https://pt.wikipedia.org/> . #WP.en
}
ORDER BY ?serv
LIMIT 700
Nome ultimo abril edit
SELECT distinct ?item ?itemLabel ?commcat ?slink ?stat # ?datnas ?datmor ?fleu ?foto
# ?nick ?pseu ?alias # ?native ?label #?ptwiki # ?itemDescription ?paisLabel
WHERE {
# { ?item wdt:P69 wdt:Q66814784 . } #FEBAUP
# optional { ?item wdt:P569 ?datnas . }
# optional { ?item wdt:P570 ?datmor . }
# optional { ?item wdt:P27 ?pais }
# optional { ?item wdt:P1317 ?fleuri . }
# filter not exists { ?item wdt:P18 ?foto . } #passa a not
# filter not exists { ?item wdt:P569 ?datnas . }
# filter not exists { ?item wdt:P570 ?datmor . }
# filter not exists { ?item wdt:P106 ?occup . }
# ?item wdt:P21 wd:Q6581072 . #mulher
# ?item wdt:P166 ?premio . #premios recebidos
?item wdt:P31 wd:Q5.
{ ?item wdt:P27 wd:Q45.} union
{ ?item wdt:P27 wd:Q45670. }
?item wdt:P31 ?value ; wikibase:statements ?stat . #numero de site links
?item wdt:P31 ?value ; wikibase:sitelinks ?slink . #numero de statments
# filter not exists { ?item wdt:P1559 ?native . } # name in native
filter not exists { ?item wdt:P734 ?gnome . } # famili name
{ ?item wdt:P373 ?commcat . } # comm cat
#label e alias
# { ?item rdfs:label ?label FILTER(lang(?label) = 'pt') . }
# optional { ?item rdfs:label ?label . }
# { ?item skos:altLabel ?alias FILTER (LANG (?alias) = 'pt') }
#optional { ?item skos:altLabel ?alias }
# filter (regex (?itemDescription , ".*[a].*" ))
# FILTER (?itemDescription != " ")
# FILTER (?native = ?alias)
# { ?ptwiki schema:about ?item ; schema:isPartOf <https://en.wikipedia.org/> . }
# { ?ptwiki schema:about ?item ; schema:isPartOf <https://pt.wikipedia.org/> . }
{ ?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "pt". }
# SERVICE wikibase:label { bd:serviceParam wikibase:language "nl,fr,en,de,it,es,no,pt". }
# FILTER(NOT EXISTS {
# ?item rdfs:label ?lang_label.
# FILTER(LANG(?lang_label) = "pt")
# })
}
ORDER BY desc (?slink) desc (?stat)
LIMIT 15000
persons surnames 12 maio edit
SELECT distinct ?person ?personLabel ?surname ?surnameLabel ?commcat ?familyLabel # ?comm
WHERE {
?person wdt:P31 wd:Q5 . # é pessoa
# ?person wdt:P21 wd:Q6581072 . # é mulher
?person wdt:P734 ?surname . # tem famyli name
?person wdt:P27 wd:Q38 . # pais ou continente ortugal # /wdt:P361*
?commpe schema:about ?person ; schema:isPartOf <https://commons.wikimedia.org/> . #esta na commons
?surname wdt:P31 ?family .
{ ?surname wdt:P31 wd:Q101352 . } # UNION # /wdt:P279* #é family name Q101352
# { ?surname wdt:P31 wd:Q66480858 . } UNION #affixed
# { ?surname wdt:P31 wd:Q29042997 . } UNION #double
# { ?surname wdt:P31 wd:Q106319018 . } #hyphenated
optional { ?surname wdt:P373 ?commcat . }
filter not exists { ?commsu schema:about ?surname ; schema:isPartOf <https://commons.wikimedia.org/> . } # nao esta na commons
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,pt". }
}
LIMIT 15000
persons surnames 21 jun edit
SELECT distinct ?surname ?a ?b ?c ?d ?surnameLabel ?commcat ?person ?personLabel ?familyLabel
{
{ ?surname wdt:P31 ?family . }
{ ?surname wdt:P31 wd:Q101352 . } #/wdt:P279*
{ ?surname rdfs:label ?label FILTER(lang(?label) = 'en') . }
filter (regex (?label , "^.*" ))
# minus { ?commsu schema:about ?surname ; schema:isPartOf <https://commons.wikimedia.org/> . }
# { ?surname wdt:P407 wd:Q9043 . } # lingua norway
filter not exists { ?surname wdt:P373 ?commcat . }
{ ?commper schema:about ?person ; schema:isPartOf <https://commons.wikimedia.org/> . }
{ ?person wdt:P569 ?birth . } # birth date
#g { ?person wdt:P570 ?death . } # death date
{ ?person wdt:P31 wd:Q5 . } # é pessoa
{ ?person wdt:P734 ?surname . } union # tem famyli name <======
{ ?person wdt:P1950 ?surname . } union # tem second famyli name <======
{ ?person wdt:P9139 ?surname . } # tem first famyli name <======
# ?person wdt:P27 wd:Q183 . # pais ou continente ortugal # /wdt:P361*
# ?person wdt:P21 wd:Q6581072 . # mulher
# ?person wdt:P373 ?commcatper . # comm cat
# ?person wdt:P18 ?image . # comm cat
hint:Prior hint:rangeSafe true . #???????
# tell the optimizer that fields doesn’t mix dates, strings, integers or other data types, which simplifies the range comparison
#g FILTER (?death < "1900-01-01"^^xsd:dateTime) # death 3N 65 act
#g FILTER (?death > "1900-01-01"^^xsd:dateTime && ?death < "1950-01-01"^^xsd:dateTime) # death 4N 72 act
#g FILTER (?death > "1950-01-01"^^xsd:dateTime && ?death < "2024-01-01"^^xsd:dateTime) # birth 0N 106 act
#g FILTER (?birth < "1900-01-01"^^xsd:dateTime) # birth 7N 175 act
FILTER (?birth > "1900-01-01"^^xsd:dateTime && ?birth < "1950-01-01"^^xsd:dateTime) # birth 0N act
#g FILTER (?birth > "1950-01-01"^^xsd:dateTime && ?birth < "2024-01-01"^^xsd:dateTime) # birth 1N act
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
mostra laguage (native) edit
#Popular eye colors among humans
#title:Popular eye colors among humans
#illustrates bubblechart view, count
#defaultView:BubbleChart
SELECT ?item ?itemLabel ?langwork ?langworkLabel ?langnat ?som #(COUNT(?human) AS ?count)
WHERE
{
?item wdt:P31 wd:Q101352 .
# ?human wdt:P407 wd:Q7913 .
minus { ?item wdt:P407 ?langwork. }
{ ?item wdt:P443 ?som. }
{ ?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> . }
# { ?rowiki schema:about ?item ; schema:isPartOf <https://ro.wikipedia.org/> . }
# { ?enwiki schema:about ?item ; schema:isPartOf <https://en.wikipedia.org/> . }
OPTIONAL { ?item wdt:P1705 ?nativename.
BIND( LANG(?nativename) AS ?langnat). }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?langnat)
LIMIT 5000
#GROUP BY ?eyeColor ?eyeColorLabel ?rgb
procurar surnames wikidata (04Jul) edit
SELECT distinct ?surname ?a ?b ?c ?d ?surnameLabel ?commcat ?person ?personLabel ?familyLabel
{
{ ?surname wdt:P31 ?family . }
{ ?surname wdt:P31/wdt:P279* wd:Q101352 . } #/wdt:P279*
{ ?surname rdfs:label ?label FILTER(lang(?label) = 'en') . }
#g filter (regex (?label , "^[A-B].*" )) # 7 act
#g filter (regex (?label , "^C.*" )) # 5 act
#g filter (regex (?label , "^D.*" )) # 4 act
#g filter (regex (?label , "^[A-E].*" )) # 0 act
#g filter (regex (?label , "^F.*" )) # 0 act
#g filter (regex (?label , "^G.*" )) # 2 act
#g filter (regex (?label , "^H.*" )) # 5 act
#g filter (regex (?label , "^I.*" )) # 1 act
#g filter (regex (?label , "^J.*" )) # 0 act
#g filter (regex (?label , "^K.*" )) # 4 act
#g filter (regex (?label , "^[L-N].*" )) # 12 act
#g filter (regex (?label , "^O.*" )) # 3 act
#g filter (regex (?label , "^[P-Q].*" )) # 4 act
#g filter (regex (?label , "^[R-T].*" )) # 11 act
#g filter (regex (?label , "^[U-Z].*" )) # 7 act
#g filter (regex (?label , "^[A-Z].*" )) # 64 act
# minus { ?commsu schema:about ?surname ; schema:isPartOf <https://commons.wikimedia.org/> . }
# { ?surname wdt:P407 wd:Q9043 . } # lingua norway
filter not exists { ?surname wdt:P373 ?commcat . }
{ ?commper schema:about ?person ; schema:isPartOf <https://commons.wikimedia.org/> . }
{ ?person wdt:P569 ?birth . } # birth date
# { ?person wdt:P570 ?death . } # death date
{ ?person wdt:P31 wd:Q5 . } # é pessoa
{ ?person wdt:P734 ?surname . } union # tem famyli name <======
{ ?person wdt:P1950 ?surname . } union # tem second famyli name <======
{ ?person wdt:P9139 ?surname . } # tem first famyli name <======
# ?person wdt:P27 wd:Q183 . # pais ou continente ortugal # /wdt:P361*
# ?person wdt:P21 wd:Q6581072 . # mulher
# ?person wdt:P373 ?commcatper . # comm cat
# ?person wdt:P18 ?image . # comm cat
hint:Prior hint:rangeSafe true . #???????
# tell the optimizer that fields doesn’t mix dates, strings, integers or other data types, which simplifies the range comparison
#g FILTER (?death < "1900-01-01"^^xsd:dateTime) # death 3N 65 act
#g FILTER (?death > "1900-01-01"^^xsd:dateTime && ?death < "1950-01-01"^^xsd:dateTime) # death 4N 72 act
#g FILTER (?death > "1950-01-01"^^xsd:dateTime && ?death < "2024-01-01"^^xsd:dateTime) # birth 0N 106 act
#g FILTER (?birth < "1900-01-01"^^xsd:dateTime) # birth 7N 175 act
#g FILTER (?birth > "1900-01-01"^^xsd:dateTime && ?birth < "1950-01-01"^^xsd:dateTime) # birth 0N 97 act
#g FILTER (?birth > "1950-01-01"^^xsd:dateTime && ?birth < "2024-01-01"^^xsd:dateTime) # birth 1N 235 act
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}