Changeset 33787 for other-projects

Timestamp:

2019-12-10T20:36:30+13:00 (4 years ago)

Author:

ak19

Message:

Documented another mongodb query that I'm using, the one to produce the map data that Dr Bainbridge wanted for ALL the sites (not just the ones that have /mi/ in the url).

File:

• other-projects/maori-lang-detection/MoreReading/mongodb.txt (modified) (2 diffs)

other-projects/maori-lang-detection/MoreReading/mongodb.txt

@@ -483 +483 @@
 
 # Number of websites that are outside NZ that contain /mi(/) in any of its sub-urls
-db.getCollection('Websites').find({urlContainsLangCodeInpath:true, geoLocationCountryCode: {$ne : "NZ"} }).count()
+0db.getCollection('Websites').find({urlContainsLangCodeInpath:true, geoLocationCountryCode: {$ne : "NZ"} }).count()
 148
 
@@ -542 +542 @@
 
 
+    # count of all sites for which the geolocation is UNKNOWN
+    db.getCollection('Websites').find({geoLocationCountryCode: {$eq:"UNKNOWN"}}).count()
+
+
 # AGGREGATION QUERIES THAT WORK:
 #https://stackoverflow.com/questions/14924495/mongodb-count-num-of-distinct-values-per-field-key
+
+WORKS:
+// count of country codes for all sites
+db.Websites.aggregate([
+   
+    { $unwind: "$geoLocationCountryCode" },
+    {
+        $group: {
+            _id: "$geoLocationCountryCode",
+            count: { $sum: 1 }
+        }
+    },
+    { $sort : { count : -1} }
+]);
+
+
+WORKS:
+// count of country codes for sites that have /mi(/) in path
 
 db.Websites.aggregate([