clld / glottolog3

glottolog2 re-implemented as CLLD app
MIT License
112 stars 27 forks source link

Add country codes to RDF #29

Closed xflr6 closed 10 years ago

xflr6 commented 10 years ago

Although at least the country of the linguistic center could in principle derived from the coordinates, it would be nice to have the full language-country relationship information in the linked data (possibly also in the CSV view).

HedvigS commented 10 years ago

You can search for countries and get all language that have been located there here: http://glottolog.org/glottolog, but that's not what you're looking for I know. Problem is that Glottolog locates the center but that doesn't mean that it's not spoken elsewhere etc etc.

xflr6 commented 10 years ago

Thanks for your comment. Just for clarification: I meant including the (m:n) languoid-country information which is already there in the export:

SELECT count(*) AS n, ncountries
FROM (SELECT count(*) AS ncountries
  FROM languoidcountry AS lc
  GROUP BY lc.languoid_pk) AS lcountries
GROUP BY ncountries
ORDER BY n DESC
LIMIT 5

  n   | ncountries
------+------------
 6686 |          1
 1004 |          2
  264 |          3
   85 |          4
   45 |          5