====== Open Refine ======

[[http://openrefine.org/]] et [[https://github.com/OpenRefine/]]

Anciennement [[http://code.google.com/p/google-refine/|Google Refine]]

  * OpenRefine [[https://github.com/OpenRefine/OpenRefine/wiki/Recipes|Recipes]]

===== Géocodage =====

==== Avec adresse.data.gouv.fr ====

  * [[https://cquest.hackpad.com/OpenRefine-et-gocodage-avec-adresse.data.gouv.fr-PCbRafrVuef|OpenRefine et géocodage avec adresse.data.gouv.fr]]

<code>"http://api-adresse.data.gouv.fr/search/?q="+(cells["Adresse"].value+" "+cells["Code postal"].value+" "+cells["Ville"].value).replace(" ","%20")+"&limit=1"</code>
==== Avec Google ====

  * [[http://blog.ouseful.info/2013/02/20/geocoding-using-the-google-maps-geocoder-via-openrefine/|Geocoding Using the Google Maps Geocoder via OpenRefine]]
  * [[http://datadrivenjournalism.net/resources/geocoding_using_the_google_maps_geocoder_via_openrefine|Geocoding Using the Google Maps Geocoder via OpenRefine - See more at: http://datadrivenjournalism.net/resources/geocoding_using_the_google_maps_geocoder_via_openrefine#sthash.31MQpsT9.dpuf]]

  "http://maps.googleapis.com/maps/api/geocode/json?sensor=false&address="+escape(value,"url")+",FR"