Usuario:Rowanwindwhistler/Commons

De Wikipedia, la enciclopedia libre

Búsquedas[editar]

  • Filtrar por SVG: "intitle:svg"
  • Filtrar SVG en una categoría: 'svg incategory:"Historical SVG maps in Greek"'
  • Filtrar dentro de una categoría con el desplegable (hay que activar GalleryFilterExtension)
  • Consultas:
1.-"Files with extension X (say .png)" & "Linked from Wikipedia Y (say, French) more than Z times"
"PNGs linked over 10,000 times on fr wikipedia"
use commonswiki_p; Select img_name, count(*) from image inner join globalimagelinks on gil_to = img_name where img_media_type = 'BITMAP' and img_major_mime = 'image' and img_minor_mime = 'png' and gil_wiki = 'frwiki' group by img_name having count(*) > 10000;}}
2.-"Files with extension X (say .svg)" & "uploaded in the last Y days"
"SVGs uploaded last week"
use commonswiki_p; SELECT img_name, img_user_text, img_timestamp from image WHERE img_media_type = 'DRAWING' AND img_timestamp > '20150220000000' order by img_timestamp desc limit 100;
3.-"Files with extension X (say .svg)" & "uploaded in the last Y days" & "Uploaded by user Z"
4.-"Files with extension X (say .svg)" & "Belonging to category Y"
  • Consultas interesantes:
Get Commons file uploaders in category: interesante ejemplo complejo usando varias tablas.
Varias consultas
Más
Ejemplo complejo (abajo)

commonswiki_p currently contains the following tables:

MariaDB [commonswiki_p]> show tables;
+-------------------------+
Tables_in_commonswiki_p

+-------------------------+
abuse_filter
abuse_filter_action
abuse_filter_history
abuse_filter_log
archive
archive_userindex
category
categorylinks
change_tag
externallinks
geo_killlist
geo_tags
geo_updates
global_block_whitelist
globalimagelinks
hashs
hitcounter
image
imagelinks
interwiki
ipblocks
ipblocks_ipindex
iwlinks
l10n_cache
langlinks
localisation
localisation_file_hash
logging
logging_logindex
logging_userindex
mark_as_helpful
math
module_deps
msg_resource
msg_resource_links
oldimage
oldimage_userindex
page
page_props
page_restrictions
pagelinks
pif_edits
povwatch_log
povwatch_subscribers
protected_titles
recentchanges
recentchanges_userindex
redirect
revision
revision_userindex
site_identifiers
site_stats
sites
tag_summary
templatelinks
transcode
updatelog
updates
user
user_former_groups
user_groups
valid_tag
wikilove_image_log
wikilove_log

Mapas interesantes[editar]

Mapas topográficos básicos en SVG[editar]

Recomendaciones para SVG[editar]

Mapas topográficos[editar]

  • Escala de colores:


  1. F5F4F2

R:245 V:244 B:242

  1. E0DED8

R:224 V:222 B:216

  1. CAC3B8

R:202 V:195 B:184

  1. BAAE9A

R:186 V:174 B:154

  1. AC9A7C

R:172 V:154 B:124

  1. AA8753

R:170 V:135 B:83

  1. B9985A

R:185 V:152 B:90

  1. C3A76B

R:195 V:167 B:107

  1. CAB982

R:202 V:185 B:130


1500-

  1. D3CA9D

R:211 V:202 B:157


1250-1500 m

  1. DED6A3

R:222 V:214 B:163


1000-1250 m

  1. E8E1B6

R:232 V:225 B:182


750-1000 m

  1. EFEBC0

R:239 V:235 B:192


500-750 m

  1. E1E4B5

R:225 V:228 B:181


250-500 m

  1. D1D7AB

R:209 V:215 B:171


100-250 m

  1. BDCC96

R:189 V:204 B:150


100-250 m

  1. A8C68F

R:168 V:198 B:143


50-100 m

  1. 94BF8B

R:148 V:191 B:139


0-50 m

  1. ACD0A5

R:172 V:208 B:165

Fronteras[editar]

Nuevos ficheros[editar]

Nuevos ficheros (2018-11-04)[editar]

Nuevos ficheros (2019-1-8)[editar]

Nuevos ficheros (2019-2-23)[editar]

Nuevos ficheros (2019-4-13)[editar]

Nuevos ficheros (2019-4-23)[editar]

Nuevos ficheros (2019-5)[editar]

Nuevos ficheros (2019-7)[editar]

Nuevos ficheros (2019-8)[editar]

Nuevos ficheros (2019-9)[editar]

Nuevos ficheros (2019-10)[editar]

Nuevos ficheros (2019-11)[editar]

Nuevos ficheros (2019-12)[editar]