https://bugzilla.wikimedia.org/show_bug.cgi?id=64495

            Bug ID: 64495
           Summary: Add missing globes to wikidata_family.py
           Product: Pywikibot
           Version: core (2.0)
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Wikidata
          Assignee: pywikipedia-b...@lists.wikimedia.org
          Reporter: maar...@mdammers.nl
       Web browser: ---
   Mobile Platform: ---

These globes are supported right now:

    def globes(self, code):
        """Supported globes for Coordinate datatype"""
        return {
            'earth': 'http://www.wikidata.org/entity/Q2',
            'mars': 'http://www.wikidata.org/entity/Q111',
            'mercury': 'http://www.wikidata.org/entity/Q308',
            'mimas': 'http://www.wikidata.org/entity/Q15034',
            'moon': 'http://www.wikidata.org/entity/Q405',
            'venus': 'http://www.wikidata.org/entity/Q313',
        }

This is what I can pull from the database:

MariaDB [enwiki_p]> connect enwiki_p enwiki.labsdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Connection id:    41347153
Current database: enwiki_p

MariaDB [enwiki_p]> SELECT DISTINCT(gt_globe) FROM geo_tags LIMIT 100;
+------------+
| gt_globe   |
+------------+
| earth      |
| moon       |
| titan      |
| mars       |
| io         |
| mercury    |
| venus      |
| europa     |
| oberon     |
| phobos     |
| mimas      |
| ganymede   |
| enceladus  |
| tethys     |
| hyperion   |
| miranda    |
| umbriel    |
| callisto   |
| dione      |
| deimos     |
| phoebe     |
| ceres      |
| vesta      |
| rhea       |
| iapetus    |
| ariel      |
| titania    |
| triton     |
| pluto      |
| sun        |
| terra      |
| luna       |
| ida        |
| gaspra     |
| eros       |
| golevka    |
| borrelly   |
| jupiter    |
| metis      |
| adrastea   |
| amalthea   |
| thebe      |
| saturn     |
| pan        |
| atlas      |
| prometheus |
| pandora    |
| epimetheus |
| janus      |
| telesto    |
| calypso    |
| helene     |
| uranus     |
| cordelia   |
| ophelia    |
| bianca     |
| cressida   |
| desdemona  |
| juliet     |
| portia     |
| rosalind   |
| belinda    |
| puck       |
| neptune    |
| naiad      |
| thalassa   |
| despina    |
| galatea    |
| larissa    |
| proteus    |
| charon     |
+------------+
71 rows in set (0.76 sec)

Some statistics:

MariaDB [enwiki_p]> SELECT gt_globe, COUNT(gt_globe) FROM geo_tags WHERE NOT
(gt_globe='earth' OR gt_globe='mars' OR gt_globe='mercury' OR gt_globe='mimas'
OR gt_globe='
moon' OR gt_globe='venus') GROUP BY gt_globe ORDER BY COUNT(gt_globe) LIMIT
100;
+------------+-----------------+
| gt_globe   | COUNT(gt_globe) |
+------------+-----------------+
| metis      |               1 |
| charon     |               1 |
| sun        |               1 |
| belinda    |               1 |
| uranus     |               1 |
| pan        |               1 |
| eros       |               1 |
| despina    |               1 |
| desdemona  |               1 |
| janus      |               1 |
| adrastea   |               1 |
| terra      |               1 |
| puck       |               1 |
| cordelia   |               1 |
| atlas      |               1 |
| golevka    |               1 |
| galatea    |               1 |
| juliet     |               1 |
| telesto    |               1 |
| amalthea   |               1 |
| luna       |               1 |
| neptune    |               1 |
| ophelia    |               1 |
| prometheus |               1 |
| borrelly   |               1 |
| larissa    |               1 |
| portia     |               1 |
| calypso    |               1 |
| thebe      |               1 |
| ida        |               1 |
| naiad      |               1 |
| bianca     |               1 |
| pandora    |               1 |
| proteus    |               1 |
| rosalind   |               1 |
| helene     |               1 |
| saturn     |               1 |
| gaspra     |               1 |
| thalassa   |               1 |
| cressida   |               1 |
| epimetheus |               1 |
| ceres      |               2 |
| triton     |               2 |
| jupiter    |               2 |
| pluto      |               2 |
| vesta      |               3 |
| europa     |               4 |
| dione      |               5 |
| tethys     |               6 |
| deimos     |               6 |
| hyperion   |               7 |
| phoebe     |               8 |
| oberon     |              13 |
| miranda    |              14 |
| umbriel    |              17 |
| titania    |              21 |
| phobos     |              27 |
| ariel      |              28 |
| enceladus  |              49 |
| iapetus    |              72 |
| rhea       |              95 |
| callisto   |             143 |
| ganymede   |             147 |
| titan      |             150 |
| io         |             269 |
+------------+-----------------+
65 rows in set (0.58 sec)

Missing globes should be added or, if the list contains incorrect globes, fixed
on the English Wikipedia.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to