1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
| #!/usr/bin/env python -u
# -*- coding: utf-8 -*-
#******************************************************************************
#
#
# ---------------------------------------------------------
# Grab data on buildings, put it in the CSV table.
# More:
#
# Usage:
# usage: *********.py [-h] [-o ORIGINALS_FOLDER] id output_name
# where:
# -h show this help message and exit
# id Region ID
# -o,overwrite Overwite all, will write over previously downloaded files
# output_name Where to store the results (path to CSV file)
# -of ORIGINALS_FOLDER Folder to save original html files. Skip saving if empty.
# Examples:
# python *******.py 2280999 data/*******.csv -o html_orig
#
#
#
#******************************************************************************
from bs4 import BeautifulSoup
import urllib2
import csv
from progressbar import *
from httplib import BadStatusLine,IncompleteRead
import socket
import argparse
from collections import namedtuple
from time import sleep
import requesocks
from stem import Signal
from stem.control import Controller
parser = argparse.ArgumentParser()
parser.add_argument('id', help='Region ID')
parser.add_argument('output_name', help='Where to store the results (path to CSV file)')
parser.add_argument('-o','--overwrite', action="store_true", help='Overwite all, will write over previously downloaded files.')
parser.add_argument('-of','--originals_folder', help='Folder to save original html files. Skip saving if empty.')
args = parser.parse_args()
if args.originals_folder:
if not args.originals_folder.endswith('\\'): args.originals_folder = args.originals_folder + '\\'
if not os.path.exists(args.originals_folder): os.mkdir(args.originals_folder)
def console_out(text):
#write httplib error messages to console
time_current = datetime.datetime.now()
timestamp = time_current.strftime('%Y-%m-%d %H:%M:%S')
f_errors.write(timestamp + ': '+ text)
def get_content(link):
numtries = 5
timeoutvalue = 40
for i in range(1,numtries+1):
try:
res = session.get(link).text
except:
time.sleep(3)
res = ''
else:
break
if res == '':
print('Session time out')
sys.exit()
return res
def urlopen_house(link,id):
#fetch html data on a house
res = get_content(link)
if args.originals_folder:
f = open(args.originals_folder + id + ".html","wb")
f.write(res.encode('utf-8'))
f.close()
return res
def change_proxy():
with Controller.from_port(port = 9151) as controller:
controller.authenticate(password="password")
controller.signal(Signal.NEWNYM)
def extract_value(tr):
#extract value for general attributes
res = tr.findAll('td')[1].text.strip()
return res
def extract_subvalue(tr,num):
#extract value for general attributes
res = tr.findAll('tr')[num].text.strip()
return res
def check_size(link):
res = get_content(link)
soup = BeautifulSoup(''.join(res), 'html.parser')
captcha = check_captcha(soup)
while captcha == True:
res = get_content(link)
soup = BeautifulSoup(''.join(res), 'html.parser')
captcha = check_captcha(soup)
change_proxy()
divs = soup.findAll('div', { 'class' : 'clearfix' })
table = divs[1].find('table', { 'class' : 'col_list' })
size = table.findAll('td')[3].text.replace(u' ед.','').replace(' ','')
return size
def get_house_list(link):
size = check_size(link)
if size == 0: size = check_size(link)
pages = (int(size) / 10000) + 1
houses_ids = []
for page in range(1,pages+1):
res = get_content(link + '&page=' + str(page) + '&limit=10000')
soup = BeautifulSoup(''.join(res), 'html.parser')
captcha = check_captcha(soup)
while captcha == True:
res = get_content(link + '&page=' + str(page) + '&limit=10000')
soup = BeautifulSoup(''.join(res), 'html.parser')
captcha = check_captcha(soup)
change_proxy()
tds = soup.findAll('td')
for td in tds:
if td.find('a') is not None:
if td.find('a').has_attr('href') and 'myhouse' in td.find('a')['href']:
house_id = td.find('a')['href'].split('/')[4]
houses_ids.append(house_id)
return houses_ids
def get_data_links(id):
f_atd = open('atd.csv','rb')
csvreader = csv.reader(f_atd, delimiter=',')
regs = []
for row in csvreader:
if id in row:
r = region(row[0],row[1],row[2],row[3],row[4],row[5])
regs.append(r)
return regs
def check_captcha(soup):
captcha = soup.find('form', { 'name' : 'request_limiter_captcha'})
if captcha != None or u'Каптча' in soup.text or 'captcha' in str(soup):
return True
else:
return False
def get_housedata(link,house_id,lvl1_name,lvl1_id,lvl2_name,lvl2_id):
#process house data to get main attributes
if args.originals_folder:
if not os.path.isfile(args.originals_folder + '/' + house_id + ".html"):
try:
res = urlopen_house(link + 'view/' + house_id,house_id)
except:
f_errors.write(link + 'view/' + house_id + '\n')
res = False
else:
res = open(args.originals_folder + '/' + house_id + ".html",'rb').read()
else:
try:
res = urlopen_house(link + 'view/' + house_id,house_id)
except:
f_errors.write(link + 'view/' + house_id + '\n')
res = False
if res != False:
soup = BeautifulSoup(''.join(res),'html.parser')
f_ids.write(link + 'view/' + house_id + ',' + house_id + '\n')
if len(soup) > 0 and 'Time-out' not in soup.text and '502 Bad Gateway' not in soup.text: #u'Ошибка' not in soup.text
address = soup.find('span', { 'class' : 'float-left loc_name_ohl width650 word-wrap-break-word' }).text.strip()
#GENERAL
div = soup.find('div', { 'class' : 'fr' })
tables = div.findAll('table')
table0 = tables[0]
trs = table0.findAll('tr')
mgmt_company = trs[0].findAll('td')[1].text.strip()
if trs[0].findAll('td')[1].find('a'):
mgmt_company_link = '***********' + trs[0].findAll('td')[1].find('a')['href']
mgmt_company_link = mgmt_company_link.split('?')[0]
else:
mgmt_company_link = ''
table1 = tables[1]
trs = table1.findAll('tr')
status = '' #trs[1].findAll('td')[1].text.strip()
table1 = tables[1]
trs = table1.findAll('tr')
#area = float(trs[2].findAll('td')[1].text.strip().replace(' ',''))
#year = trs[6].findAll('td')[1].text.strip()
lastupdate = trs[8].findAll('td')[1].text.strip()
lastupdate = ' '.join(lastupdate.replace('\n','').split())
servicedate_start = trs[10].findAll('td')[1].text.strip()
servicedate_end = '' #trs[5].findAll('td')[1].text.strip()
#TODO extract lat/long coords from script
if 'center' in soup.findAll('script')[11]:
lat,lon = soup.findAll('script')[11].text.split('\n')[3].split('[')[1].split(']')[0].split(',')
else:
lat,lon = soup.findAll('script')[12].text.split('\n')[3].split('[')[1].split(']')[0].split(',')
#PASSPORT
##GENERAL
divs = soup.findAll('div', { 'class' : 'numbered' })
div0 = divs[0]
trs = div0.findAll('tr')
lentrs = len(trs)
if lentrs > 58:
trs_offset = lentrs - 58
else:
trs_offset = 0
year = extract_value(trs[3])
serie = extract_value(trs[5])
house_type = extract_value(trs[7])
capfond = extract_value(trs[9])
avar = extract_value(trs[11])
levels_max = extract_subvalue(trs[12], 1)
levels_min = extract_subvalue(trs[12], 3)
doors = extract_value(trs[18])
room_count = extract_value(trs[23])
room_count_live = extract_value(trs[26])
room_count_nonlive = extract_value(trs[28])
area = extract_value(trs[31]).replace(' ','')
area_live = extract_value(trs[34]).replace(' ','')
area_nonlive = extract_value(trs[36]).replace(' ','')
area_gen = extract_value(trs[38]).replace(' ','')
area_land = extract_value(trs[41]).replace(' ','')
area_park = extract_value(trs[43]).replace(' ','')
cadno = trs[44].findAll('td')[1].text
energy_class = extract_value(trs[48 + trs_offset])
blag_playground = extract_value(trs[51 + trs_offset])
blag_sport = extract_value(trs[53 + trs_offset])
blag_other = extract_value(trs[55 + trs_offset])
other = extract_value(trs[57 + trs_offset])
f_housedata.close()
f_errors.close()
f_ids.close() |