utilisation : charger la base 'recommend_listedschool' à partir du fichier sql, puis cliquer sur tous les boutons 'execute' dans ci-dessous l'ordre. Enfin, cliquer sur les example en bas. Pour voir les établissements non associés, cliquer sur 'nonmatching'.

• Generate all execution query in 'nearby.sql': generate
• Create recommendation : query execute
• Create academy : query execute
• Create academy_dpt : query execute
• Prepare recommend_listedschool : query execute (takes a dozen seconds)
• View by academie (modify url to filter by academie in range 1-30) : colleges lycees both all
• View participating schools all
• Prepare table normalized names query execute
• Matching schools matching 1(preview for 100 first schools) nonmatching(view all), matching 1 and 2 : execute (takes a minute or so), manual matching : execute
• Particip by academie (modify url to select an academie in the range 1-30) : colleges lycees both all
• View details of page for teacher (modify url to change teacher id) : example collège example lycée example unknown
• View page for teacher (modify url to change teacher id) : example collège example lycée example unknown

Select action from menu above.