Skip to content

Instantly share code, notes, and snippets.

@haganbt
Created September 5, 2013 08:55
Show Gist options
  • Save haganbt/6447674 to your computer and use it in GitHub Desktop.
Save haganbt/6447674 to your computer and use it in GitHub Desktop.
DataSift CSDL filter - tracking tweets from France in French
/*
* http://simple.wikipedia.org/wiki/List_of_cities_in_France
*
*/
(
// GEO
interaction.geo geo_polygon "51.08282186160978,2.548828125:50.816347765191075,2.63671875:50.68775800806201,2.900390625:50.78510168548186,3.131103515625:50.53088873891836,3.2794189453125:50.523904629228625,3.4716796875:50.31039245071915,3.71337890625:50.3454604086048,4.031982421875:50.257741984396894,4.2352294921875:50.13466432216696,4.1473388671875:50.06066538593667,4.229736328125:50.01832895590886,4.1473388671875:49.9759551873433,4.1473388671875:49.94061518401988,4.4769287109375:50.004208515595614,4.6746826171875:50.15930523913416,4.7735595703125:50.152266272562684,4.8834228515625:49.97242235423708,4.801025390625:49.85569332253434,4.8614501953125:49.75997752330658,5.0811767578125:49.710272582105695,5.16357421875:49.64273443429918,5.3338623046875:49.48240137826932,5.482177734375:49.55728898983402,5.745849609375:49.44670029695473,6.1083984375:49.468124067331644,6.4434814453125:49.35375571830993,6.580810546875:49.160154652338015,6.756591796875:49.2140089056539,6.8609619140625:49.196064000723794,7.0257568359375:49.106241774469055,7.0751953125:49.17093019244911,7.459716796875:49.0558701819386,7.80029296875:48.96218736991556,8.23974609375:48.3416461723746,7.745361328125:47.5913464767971,7.58056640625:47.48008846346322,7.196044921875:47.37603463349758,6.8994140625:47.34626718205299,7.05322265625:46.9502622421856,6.4599609375:46.57396679652779,6.13037109375:46.41892578708076,6.075439453125:46.30520105581194,6.119384765625:46.198844376182535,5.9820556640625:46.10370875598025,5.9710693359375:46.198844376182535,6.2786865234375:46.36209301204985,6.21826171875:46.44164232762498,6.56982421875:46.40756396630067,6.822509765625:46.27863122156088,6.85546875:46.126556302418514,6.8719482421875:45.91294412737392,7.0477294921875:45.82879925192134,6.8115234375:45.67932023569538,6.888427734375:45.39844997630408,7.174072265625:45.213003555993964,6.9927978515625:45.108423337694084,6.6357421875:44.91813929958515,6.7291259765625:44.83639545410477,6.998291015625:44.68427737181224,7.0806884765625:44.42593442145313,6.9378662109375:44.264871151101985,6.9873046875:44.11914151643737,7.36083984375:44.15856343854312,7.66845703125:43.78695837311561,7.525634765625:43.03677585761058,7.119140625:42.44778143462245,3.240966796875:42.374778361114195,1.944580078125:42.85180609584705,0.68115234375:42.66628070564928,0.648193359375:42.81152174509788,-0.318603515625:43.09296067711629,-1.29638671875:43.421008829947255,-1.8896484375:48.74894534343293,-5.712890625"
// General
OR twitter.user.location contains_any "France"
OR twitter.retweet.user.location contains_any "France"
// Commune
OR twitter.user.location contains_any "Aix en Provence, Amiens, Angers, Argenteuil, Asnières sur Seine, Aulnay sous Bois, Avignon, Besançon, Bordeaux, Boulogne Billancourt, Brest, Caen, Calais, Clermont Ferrand, Colombes, Créteil, Dijon, Fort de France, Grenoble, La Rochelle, Le Havre, Le Mans, Lille, Limoges, Lyon, Marseille, Metz, Montpellier, Montreuil, Mulhouse, Nancy, Nanterre, Nantes, Nice, Nîmes, Orléans, Paris, Pau, Perpignan, Poitiers, Reims, Rennes, Roubaix, Rouen, Saint Denis, Saint Denis, Saint Étienne, Saint Paul, Strasbourg, Toulon, Toulouse, Tourcoing, Tours, Versailles, Villeurbanne, Vitry sur Seine"
OR twitter.retweet.user.location contains_any "Aix en Provence, Amiens, Angers, Argenteuil, Asnières sur Seine, Aulnay sous Bois, Avignon, Besançon, Bordeaux, Boulogne Billancourt, Brest, Caen, Calais, Clermont Ferrand, Colombes, Créteil, Dijon, Fort de France, Grenoble, La Rochelle, Le Havre, Le Mans, Lille, Limoges, Lyon, Marseille, Metz, Montpellier, Montreuil, Mulhouse, Nancy, Nanterre, Nantes, Nice, Nîmes, Orléans, Paris, Pau, Perpignan, Poitiers, Reims, Rennes, Roubaix, Rouen, Saint Denis, Saint Denis, Saint Étienne, Saint Paul, Strasbourg, Toulon, Toulouse, Tourcoing, Tours, Versailles, Villeurbanne, Vitry sur Seine"
// Department
OR twitter.user.location contains_any "Alpes Maritimes, Bas Rhin, Bouches du Rhône, Calvados, Charente Maritime, Côte d'Or, Doubs, Finistère, Gard, Gironde, Haut Rhin, Haute Garonne, Haute Vienne, Hauts de Seine, Hérault, Ille et Vilaine, Indre et Loire, Isère, Loire, Loire Atlantique, Loiret, Maine et Loire, Marne, Martinique, Meurthe et Moselle, Moselle, Nord, Paris, Pas de Calais, Puy de Dôme, Pyrénées Atlantiques, Pyrénées Orientales, Réunion, Rhône, Sarthe, Seine Maritime, Seine Saint Denis, Somme, Val d'Oise, Val de Marne, Var, Vaucluse, Vienne, Yvelines"
OR twitter.retweet.user.location contains_any "Alpes Maritimes, Bas Rhin, Bouches du Rhône, Calvados, Charente Maritime, Côte d'Or, Doubs, Finistère, Gard, Gironde, Haut Rhin, Haute Garonne, Haute Vienne, Hauts de Seine, Hérault, Ille et Vilaine, Indre et Loire, Isère, Loire, Loire Atlantique, Loiret, Maine et Loire, Marne, Martinique, Meurthe et Moselle, Moselle, Nord, Paris, Pas de Calais, Puy de Dôme, Pyrénées Atlantiques, Pyrénées Orientales, Réunion, Rhône, Sarthe, Seine Maritime, Seine Saint Denis, Somme, Val d'Oise, Val de Marne, Var, Vaucluse, Vienne, Yvelines"
// Region
OR twitter.user.location contains_any "Alsace, Aquitaine, Auvergne, Basse Normandie, Bourgogne, Brittany, Centre, Champagne Ardenne, Free County, Haute Normandie, Île de France, Languedoc Roussillon, Limousin, Lorraine, Martinique, Midi Pyrénées, Nord Pas de Calais, Pays de la Loire, Picardie, Poitou Charentes, Provence Alpes Côte d'Azur, Réunion, Rhône Alpes, "
OR twitter.retweet.user.location contains_any "Alsace, Aquitaine, Auvergne, Basse Normandie, Bourgogne, Brittany, Centre, Champagne Ardenne, Free County, Haute Normandie, Île de France, Languedoc Roussillon, Limousin, Lorraine, Martinique, Midi Pyrénées, Nord Pas de Calais, Pays de la Loire, Picardie, Poitou Charentes, Provence Alpes Côte d'Azur, Réunion, Rhône Alpes, "
// Place
OR twitter.place.country == "France"
OR twitter.place.country_code == "Fr"
// Timezone
OR twitter.user.time_zone == "Paris"
OR twitter.retweet.user.time_zone == "Paris"
)
// Language
and language.tag == "fr"
and language.confidence > 80
// Data sources
and interaction.type in "twitter"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment