static void Main(string[] args)
{
//while (true)
//{
// Console.WriteLine("Write a place name in USA for getting info:");
// Console.WriteLine(AddressParser.GetJsonMapResponse(Console.ReadLine(),Constants.TypeOfMapGrabbing.ByLatlng));
// Console.WriteLine("Do you wish to get info about another place? \nPress \"1\" to continue, any other to interrupt:");
// ConsoleKeyInfo k = Console.ReadKey();
// if(k.Key != ConsoleKey.D1)
// {
// Console.WriteLine("\nGoog Bye!");
// Console.ReadKey();
// return;
// }
//
//}
AddressParser parser = new AddressParser();
//parser.StartGrabbing();
//string json = "{ \"results\" : [ { \"address_components\" : [ { \"long_name\" : \"118\", \"short_name\" : \"118\", \"types\" : [ \"street_number\" ] }, { \"long_name\" : \"Broaddus Street\", \"short_name\" : \"Broaddus St\", \"types\" : [ \"route\" ] }, { \"long_name\" : \"Lufkin\", \"short_name\" : \"Lufkin\", \"types\" : [ \"locality\", \"political\" ] }, { \"long_name\" : \"Angelina County\", \"short_name\" : \"Angelina County\", \"types\" : [ \"administrative_area_level_2\", \"political\" ] }, { \"long_name\" : \"Texas\", \"short_name\" : \"TX\", \"types\" : [ \"administrative_area_level_1\", \"political\" ] }, { \"long_name\" : \"United States\", \"short_name\" : \"US\", \"types\" : [ \"country\", \"political\" ] }, { \"long_name\" : \"75901\", \"short_name\" : \"75901\", \"types\" : [ \"postal_code\" ] } ], \"formatted_address\" : \"118 Broaddus St, Lufkin, TX 75901, USA\", \"geometry\" : { \"location\" : { \"lat\" : 31.3494116, \"lng\" : -94.6928006 }, \"location_type\" : \"ROOFTOP\", \"viewport\" : { \"northeast\" : { \"lat\" : 31.3507605802915, \"lng\" : -94.6914516197085 }, \"southwest\" : { \"lat\" : 31.3480626197085, \"lng\" : -94.69414958029151 } } }, \"place_id\" : \"ChIJrSqlQi89OIYRQpkIb2QUH7c\", \"types\" : [ \"street_address\" ] }, { \"address_components\" : [ { \"long_name\" : \"Lufkin\", \"short_name\" : \"Lufkin\", \"types\" : [ \"locality\", \"political\" ] }, { \"long_name\" : \"Angelina County\", \"short_name\" : \"Angelina County\", \"types\" : [ \"administrative_area_level_2\", \"political\" ] }, { \"long_name\" : \"Texas\", \"short_name\" : \"TX\", \"types\" : [ \"administrative_area_level_1\", \"political\" ] }, { \"long_name\" : \"United States\", \"short_name\" : \"US\", \"types\" : [ \"country\", \"political\" ] } ], \"formatted_address\" : \"Lufkin, TX, USA\", \"geometry\" : { \"bounds\" : { \"northeast\" : { \"lat\" : 31.379695, \"lng\" : -94.6782559 }, \"southwest\" : { \"lat\" : 31.26476409999999, \"lng\" : -94.77503710000001 } }, \"location\" : { \"lat\" : 31.3382406, \"lng\" : -94.729097 }, \"location_type\" : \"APPROXIMATE\", \"viewport\" : { \"northeast\" : { \"lat\" : 31.379695, \"lng\" : -94.6782559 }, \"southwest\" : { \"lat\" : 31.26476409999999, \"lng\" : -94.77503710000001 } } }, \"place_id\" : \"ChIJsbOqGT03OIYRSb8SwfR5Q0k\", \"types\" : [ \"locality\", \"political\" ] }, { \"address_components\" : [ { \"long_name\" : \"75901\", \"short_name\" : \"75901\", \"types\" : [ \"postal_code\" ] }, { \"long_name\" : \"Lufkin\", \"short_name\" : \"Lufkin\", \"types\" : [ \"locality\", \"political\" ] }, { \"long_name\" : \"Angelina County\", \"short_name\" : \"Angelina County\", \"types\" : [ \"administrative_area_level_2\", \"political\" ] }, { \"long_name\" : \"Texas\", \"short_name\" : \"TX\", \"types\" : [ \"administrative_area_level_1\", \"political\" ] }, { \"long_name\" : \"United States\", \"short_name\" : \"US\", \"types\" : [ \"country\", \"political\" ] } ], \"formatted_address\" : \"Lufkin, TX 75901, USA\", \"geometry\" : { \"bounds\" : { \"northeast\" : { \"lat\" : 31.482505, \"lng\" : -94.541657 }, \"southwest\" : { \"lat\" : 31.1039179, \"lng\" : -94.87966209999999 } }, \"location\" : { \"lat\" : 31.3382166, \"lng\" : -94.6657027 }, \"location_type\" : \"APPROXIMATE\", \"viewport\" : { \"northeast\" : { \"lat\" : 31.482505, \"lng\" : -94.541657 }, \"southwest\" : { \"lat\" : 31.1039179, \"lng\" : -94.75184689999999 } } }, \"place_id\" : \"ChIJqSWndK0YOIYR_iDkf8waoYA\", \"types\" : [ \"postal_code\" ] }, { \"address_components\" : [ { \"long_name\" : \"Lufkin, TX\", \"short_name\" : \"Lufkin, TX\", \"types\" : [ \"political\" ] }, { \"long_name\" : \"Angelina County\", \"short_name\" : \"Angelina County\", \"types\" : [ \"administrative_area_level_2\", \"political\" ] }, { \"long_name\" : \"Texas\", \"short_name\" : \"TX\", \"types\" : [ \"administrative_area_level_1\", \"political\" ] }, { \"long_name\" : \"United States\", \"short_name\" : \"US\", \"types\" : [ \"country\", \"political\" ] } ], \"formatted_address\" : \"Lufkin, TX, TX, USA\", \"geometry\" : { \"bounds\" : { \"northeast\" : { \"lat\" : 31.526956, \"lng\" : -94.129632 }, \"southwest\" : { \"lat\" : 31.026384, \"lng\" : -95.005549 } }, \"location\" : { \"lat\" : 31.2704698, \"lng\" : -94.64503499999999 }, \"location_type\" : \"APPROXIMATE\", \"viewport\" : { \"northeast\" : { \"lat\" : 31.526956, \"lng\" : -94.129632 }, \"southwest\" : { \"lat\" : 31.026384, \"lng\" : -95.005549 } } }, \"place_id\" : \"ChIJ52zDgXE5OIYRjbzKt8wEPus\", \"types\" : [ \"political\" ] }, { \"address_components\" : [ { \"long_name\" : \"Angelina County\", \"short_name\" : \"Angelina County\", \"types\" : [ \"administrative_area_level_2\", \"political\" ] }, { \"long_name\" : \"Texas\", \"short_name\" : \"TX\", \"types\" : [ \"administrative_area_level_1\", \"political\" ] }, { \"long_name\" : \"United States\", \"short_name\" : \"US\", \"types\" : [ \"country\", \"political\" ] } ], \"formatted_address\" : \"Angelina County, TX, USA\", \"geometry\" : { \"bounds\" : { \"northeast\" : { \"lat\" : 31.526916, \"lng\" : -94.129632 }, \"southwest\" : { \"lat\" : 31.0260881, \"lng\" : -95.005566 } }, \"location\" : { \"lat\" : 31.2704698, \"lng\" : -94.64503499999999 }, \"location_type\" : \"APPROXIMATE\", \"viewport\" : { \"northeast\" : { \"lat\" : 31.526916, \"lng\" : -94.16901159999999 }, \"southwest\" : { \"lat\" : 31.0260881, \"lng\" : -95.005566 } } }, \"place_id\" : \"ChIJbWUFnLAwOIYRDxGvxNngXxE\", \"types\" : [ \"administrative_area_level_2\", \"political\" ] }, { \"address_components\" : [ { \"long_name\" : \"Texas\", \"short_name\" : \"TX\", \"types\" : [ \"administrative_area_level_1\", \"establishment\", \"point_of_interest\", \"political\" ] }, { \"long_name\" : \"United States\", \"short_name\" : \"US\", \"types\" : [ \"country\", \"political\" ] } ], \"formatted_address\" : \"Texas, USA\", \"geometry\" : { \"bounds\" : { \"northeast\" : { \"lat\" : 36.5007041, \"lng\" : -93.5080389 }, \"southwest\" : { \"lat\" : 25.8371638, \"lng\" : -106.6456461 } }, \"location\" : { \"lat\" : 31.9685988, \"lng\" : -99.9018131 }, \"location_type\" : \"APPROXIMATE\", \"viewport\" : { \"northeast\" : { \"lat\" : 36.5018864, \"lng\" : -93.5080389 }, \"southwest\" : { \"lat\" : 25.83819, \"lng\" : -106.6452951 } } }, \"place_id\" : \"ChIJSTKCCzZwQIYRPN4IGI8c6xY\", \"types\" : [ \"administrative_area_level_1\", \"establishment\", \"point_of_interest\", \"political\" ] }, { \"address_components\" : [ { \"long_name\" : \"United States\", \"short_name\" : \"US\", \"types\" : [ \"country\", \"political\" ] } ], \"formatted_address\" : \"United States\", \"geometry\" : { \"bounds\" : { \"northeast\" : { \"lat\" : 71.5388001, \"lng\" : -66.885417 }, \"southwest\" : { \"lat\" : 18.7763, \"lng\" : 170.5957 } }, \"location\" : { \"lat\" : 37.09024, \"lng\" : -95.712891 }, \"location_type\" : \"APPROXIMATE\", \"viewport\" : { \"northeast\" : { \"lat\" : 49.38, \"lng\" : -66.94 }, \"southwest\" : { \"lat\" : 25.82, \"lng\" : -124.39 } } }, \"place_id\" : \"ChIJCzYy5IS16lQRQrfeQ5K5Oxw\", \"types\" : [ \"country\", \"political\" ] } ], \"status\" : \"OK\" } ";
//string json = "{ 'error_message' : 'You have exceeded your daily request quota for this API. We recommend registering for a key at the Google Developers Console: https://console.developers.google.com/apis/credentials?project=_', 'results' : [], 'status' : 'OVER_QUERY_LIMIT' }";
//GeocodeJsonObject o = AddressParser.ReadJsonToObject(json);
//RooftopResultPlace place = new RooftopResultPlace(o);
parser.ConvertJsonStringFromDbToCells();
Console.WriteLine("I'm done!");
Console.ReadKey();
}
public void StartGrabbing()
{
ParallelOptions options = new ParallelOptions();
options.MaxDegreeOfParallelism = Convert.ToInt32(Resources.MaxDegreeOfParallelism);
long TruliaCount = DataProviders.DataProvider.Instance.GetCount(); //смотрим, сколько записей в таблице
Console.WriteLine(TruliaCount);
int range = 10000;
for (int i = 1; i <= TruliaCount; i += range)
{
if ((i - 1) % 1000 == 0)
{
Console.WriteLine("Now {0} cells", i - 1);
}
List <AddressInfo> adresses;
if (i + range > TruliaCount)
{
adresses = GetAddressesByRange(i, TruliaCount);
}
else
{
adresses = GetAddressesByRange(i, i + range - 1);
}
Parallel.ForEach(adresses, options, address =>
{
//for (int j = 0;j < adresses.Count;j++)
Console.WriteLine(address.PlaceName);
address.ParseJSON();
if (address.JSON != Constants.WebAttrsNames.NotFound)
{
if (AddressParser.ReadJsonToObject(address.JSON).status == Constants.GoogleMapsGeocodingStatusCodes.OVER_QUERY_LIMIT)
{
return;
}
}
address.InsertIntoDb();
});
//Parallel.ForEach(adresses,options, address => {
// address.ParseJSON();
// address.InsertIntoDb();
//});
}
}