title: Matching pincodes with latitude and longitude (India)
body: <p>I am trying to get corresponding latitudes and longitudes for a particular pincode for India.</p>
  
  <p>For pincode I have the following file.</p>
  
  <p><a href="https://data.gov.in/sites/default/files/all_india_PO_list_without_APS_offices_ver2_lat_long.csv" rel="nofollow noreferrer">https://data.gov.in/sites/default/files/all_india_PO_list_without_APS_offices_ver2_lat_long.csv</a></p>
  
  <p>The data has 15 columns. I just show a part of it so that you can see how this data looks like.</p>
  
  <pre><code>                   officename pincode officeType Deliverystatus divisionname   regionname
   1:             Achalapur B.O  504273        B.O       Delivery     Adilabad    Hyderabad
   2:                   Ada B.O  504293        B.O       Delivery     Adilabad    Hyderabad
   3:               Adegaon B.O  504307        B.O       Delivery     Adilabad    Hyderabad
   4: Adilabad Collectorate S.O  504001        S.O   Non-Delivery     Adilabad    Hyderabad
   5:              Adilabad H.O  504001        H.O       Delivery     Adilabad    Hyderabad
  </code></pre>
  
  <p>This file has multiple lat-long mapped to one pincode. </p>
  
  <p>For my use, I need to have one lat-long for a particular pincode (I have two address X and Y) and then I use Haversine to calculate the distance between X and Y</p>
  
  <p>Possible options for me</p>
  
  <ol>
  <li>Take an average of lat-long for pincodes, then map them. Calculate Haversine distance between X and Y.</li>
  <li>Tried to use geocode. </li>
  </ol>
  
  <p>I am getting this error mainly because I am behind office firewall</p>
  
  <pre><code>Error in curl::curl_fetch_memory(url, handle = handle) : 
    Timeout was reached: [maps.googleapis.com] Connection timed out after 10000 milliseconds
  </code></pre>
  
  <ol start="3">
  <li>Any other source on net or any other way to get 1:1 mapping between pincode and lat-long</li>
  </ol>
  
  <p>Any help is appreciated!</p>