def osm_nominatim(DataLocation):
#    DataLocation = r'C:\Users\Wuga\Documents\DATASETS\SFREHPDATA\HousingSales2012.csv'
    geolocator=Nominatim()
    df=DO.readfile(DataLocation)
    print df
    df['Location'][:]=[x[0:x.find('#')] if x.find('#')!=-1 else x for x in df['Location']]
    print df
    complete=df['Location'][3]+" San Francisco"
    print complete
    longlat=geolocator.geocode(complete)
    print((longlat.latitude,longlat.longitude))
    transed=[]
    #transed=[geolocator.geocode(x+" San Francisco", timeout=None) for x in df['Location'][:5]]#need to sleep for a sec
    for x in df['Location'][:5]:
        transed.append(geolocator.geocode(x+" San Francisco", timeout=10))
        time.sleep(2)
    transed_la=[x.latitude if x is not None else 0 for x in transed]
    transed_lo=[x.longitude if x is not None else 0 for x in transed]
    cood_price=zip(df['Price'],transed_la,transed_lo)
    df_cood_price=pd.DataFrame(data=cood_price, columns=['Price','Latitude','Longitude'])
    df_cood_price.to_csv(Constants.filelocations.OSM_NOMINATIM_HOUSEPRICE, header= True, index=False)
    print df_cood_price
    return

    
Example #2
0
 def get_nearest_businesses(self,user_id,count,address):
     """Getting latitude and longitude oflocations and finding businesses near to user's address"""
     geolocator = Nominatim()
     location = geolocator.geocode(address)
     latitude = location.latitude
     longitude = location.longitude
     ratings = self.get_top_ratings_nearest(user_id, count, latitude, longitude)
     return ratings
Example #3
0
class NominatimTestCase(_BackendTestCase): # pylint: disable=R0904,C0111
    def setUp(self):
        from geopy.geocoders.osm import Nominatim
        self.geocoder = Nominatim()

    def test_reverse(self):
        known_addr = 'Jose Bonifacio de Andrada e Silva, 6th Avenue, Diamond '\
            'District, Manhattan, NYC, New York, 10020, United States of America'
        known_coords = (40.75376406311989, -73.98489005863667)
        addr, coords = self.geocoder.reverse(
            "40.75376406311989, -73.98489005863667",
            exactly_one=True
        )
        self.assertEqual(str_coerce(addr), known_addr)
        self.assertAlmostEqual(coords[0], known_coords[0], delta=self.delta_exact)
        self.assertAlmostEqual(coords[1], known_coords[1], delta=self.delta_exact)
Example #4
0
class NominatimTestCase(_BackendTestCase):  # pylint: disable=R0904,C0111
    def setUp(self):
        from geopy.geocoders.osm import Nominatim
        self.geocoder = Nominatim()

    def test_reverse(self):
        known_addr = 'Jose Bonifacio de Andrada e Silva, 6th Avenue, Diamond '\
            'District, Manhattan, NYC, New York, 10020, United States of America'
        known_coords = (40.75376406311989, -73.98489005863667)
        addr, coords = self.geocoder.reverse(
            "40.75376406311989, -73.98489005863667", exactly_one=True)
        self.assertEqual(str_coerce(addr), known_addr)
        self.assertAlmostEqual(coords[0],
                               known_coords[0],
                               delta=self.delta_exact)
        self.assertAlmostEqual(coords[1],
                               known_coords[1],
                               delta=self.delta_exact)
Example #5
0
 def setUp(self):
     from geopy.geocoders.osm import Nominatim
     self.geocoder = Nominatim()
Example #6
0
 def setUp(self):
     from geopy.geocoders.osm import Nominatim
     self.geocoder = Nominatim()