Quelle  rtree.result   Sprache: Lisp

create table t1 (i int, g geometry not null, spatial index (g))engine=innodb;
insert into t1 values (1, POINT(1,1));
insert into t1 values (1, POINT(1.5,1.5));
insert into t1 values (1, POINT(3,3));
insert into t1 values (1, POINT(3.1,3.1));
insert into t1 values (1, POINT(5,5));
analyze table t1;
Table Op Msg_type Msg_text
test.t1 analyze status Engine-independent statistics collected
test.t1 analyze status OK
set @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
explain select ST_astext(t1.g) from t1 where MBRWithin(t1.g, @g1);
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 range g g 34 NULL 5 Using where
select ST_astext(t1.g) from t1 where MBRWithin(t1.g, @g1);
ST_astext(t1.g)
POINT(1.5 1.5)
POINT(1 1)
set @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
delete from t1 where MBRWithin(t1.g, @g1);
check table t1;
Table Op Msg_type Msg_text
test.t1 check status OK
select ST_astext(t1.g) from t1;
ST_astext(t1.g)
POINT(3 3)
POINT(3.1 3.1)
POINT(5 5)
set @g1 = ST_GeomFromText('Polygon((5 5,5 5,5 5,5 5,5 5))');
update t1 set g = POINT(2,2) where MBRWithin(t1.g, @g1);
check table t1;
Table Op Msg_type Msg_text
test.t1 check status OK
select ST_astext(t1.g) from t1;
ST_astext(t1.g)
POINT(3 3)
POINT(3.1 3.1)
POINT(2 2)
show indexes from t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored
t1 1 g 1 g A # 32 NULL  SPATIAL   NO
drop table t1;
create table t1 (name VARCHAR(100), square GEOMETRY not null, spatial index (square))engine=innodb;
INSERT INTO t1 VALUES("small",  ST_GeomFromText('POLYGON (( 0 0, 0 1, 1 1, 1 0, 0 0))'));
INSERT INTO t1 VALUES("big",    ST_GeomFromText('POLYGON (( 0 0, 0 3, 3 3, 3 0, 0 0))'));
INSERT INTO t1 VALUES("up",     ST_GeomFromText('POLYGON (( 0 1, 0 3, 2 3, 2 1, 0 1))'));
INSERT INTO t1 VALUES("up2",    ST_GeomFromText('POLYGON (( 0 2, 0 4, 2 4, 2 2, 0 2))'));
INSERT INTO t1 VALUES("up3",    ST_GeomFromText('POLYGON (( 0 3, 0 5, 2 5, 2 3, 0 3))'));
INSERT INTO t1 VALUES("down",   ST_GeomFromText('POLYGON (( 0 -1, 0  1, 2  1, 2 -1, 0 -1))'));
INSERT INTO t1 VALUES("down2",  ST_GeomFromText('POLYGON (( 0 -2, 0  0, 2  0, 2 -2, 0 -2))'));
INSERT INTO t1 VALUES("down3",  ST_GeomFromText('POLYGON (( 0 -3, 0 -1, 2 -1, 2 -3, 0 -3))'));
INSERT INTO t1 VALUES("right",  ST_GeomFromText('POLYGON (( 1 0, 1 2, 3 2, 3 0, 1 0))'));
INSERT INTO t1 VALUES("right2", ST_GeomFromText('POLYGON (( 2 0, 2 2, 4 2, 4 0, 2 0))'));
INSERT INTO t1 VALUES("right3", ST_GeomFromText('POLYGON (( 3 0, 3 2, 5 2, 5 0, 3 0))'));
INSERT INTO t1 VALUES("left",   ST_GeomFromText('POLYGON (( -1 0, -1 2,  1 2,  1 0, -1 0))'));
INSERT INTO t1 VALUES("left2",  ST_GeomFromText('POLYGON (( -2 0, -2 2,  0 2,  0 0, -2 0))'));
INSERT INTO t1 VALUES("left3",  ST_GeomFromText('POLYGON (( -3 0, -3 2, -1 2, -1 0, -3 0))'));
SET @p = ST_GeomFromText('POLYGON (( 0 0, 0 2, 2 2, 2 0, 0 0))');
SELECT name, ST_AsText(square) from t1 where MBRContains(@p, square);
name ST_AsText(square)
small POLYGON((0 0,0 1,1 1,1 0,0 0))
SELECT name, ST_AsText(square) from t1 where MBRDisjoint(@p, square);
name ST_AsText(square)
up3 POLYGON((0 3,0 5,2 5,2 3,0 3))
down3 POLYGON((0 -3,0 -1,2 -1,2 -3,0 -3))
right3 POLYGON((3 0,3 2,5 2,5 0,3 0))
left3 POLYGON((-3 0,-3 2,-1 2,-1 0,-3 0))
SELECT name, ST_AsText(square) from t1 where MBREquals(@p, square);
name ST_AsText(square)
SELECT name, ST_AsText(square) from t1 where MBRIntersects(@p, square);
name ST_AsText(square)
right2 POLYGON((2 0,2 2,4 2,4 0,2 0))
right POLYGON((1 0,1 2,3 2,3 0,1 0))
up2 POLYGON((0 2,0 4,2 4,2 2,0 2))
up POLYGON((0 1,0 3,2 3,2 1,0 1))
big POLYGON((0 0,0 3,3 3,3 0,0 0))
small POLYGON((0 0,0 1,1 1,1 0,0 0))
down POLYGON((0 -1,0 1,2 1,2 -1,0 -1))
down2 POLYGON((0 -2,0 0,2 0,2 -2,0 -2))
left POLYGON((-1 0,-1 2,1 2,1 0,-1 0))
left2 POLYGON((-2 0,-2 2,0 2,0 0,-2 0))
SELECT name, ST_AsText(square) from t1 where MBROverlaps(@p, square);
name ST_AsText(square)
right POLYGON((1 0,1 2,3 2,3 0,1 0))
up POLYGON((0 1,0 3,2 3,2 1,0 1))
down POLYGON((0 -1,0 1,2 1,2 -1,0 -1))
left POLYGON((-1 0,-1 2,1 2,1 0,-1 0))
SELECT name, ST_AsText(square) from t1 where MBRTouches(@p, square);
name ST_AsText(square)
right2 POLYGON((2 0,2 2,4 2,4 0,2 0))
up2 POLYGON((0 2,0 4,2 4,2 2,0 2))
down2 POLYGON((0 -2,0 0,2 0,2 -2,0 -2))
left2 POLYGON((-2 0,-2 2,0 2,0 0,-2 0))
SELECT name, ST_AsText(square) from t1 where MBRWithin(@p, square);
name ST_AsText(square)
big POLYGON((0 0,0 3,3 3,3 0,0 0))
SET @vert1   = ST_GeomFromText('POLYGON ((0 -2, 0 2, 0 -2))');
SET @horiz1  = ST_GeomFromText('POLYGON ((-2 0, 2 0, -2 0))');
SET @horiz2 = ST_GeomFromText('POLYGON ((-1 0, 3 0, -1 0))');
SET @horiz3 = ST_GeomFromText('POLYGON ((2 0, 3 0, 2 0))');
SET @point1 = ST_GeomFromText('POLYGON ((0 0))');
SET @point2 = ST_GeomFromText('POLYGON ((-2 0))');
SELECT GROUP_CONCAT(a1.name ORDER BY a1.name) AS MBRoverlaps FROM t1 a1 WHERE MBROverlaps(a1.square, @vert1) GROUP BY a1.name;
MBRoverlaps
SELECT GROUP_CONCAT(a1.name ORDER BY a1.name) AS MBRoverlaps FROM t1 a1 WHERE MBROverlaps(a1.square, @horiz1) GROUP BY a1.name;
MBRoverlaps
SELECT MBROverlaps(@horiz1, @vert1) FROM DUAL;
MBROverlaps(@horiz1, @vert1)
0
SELECT MBROverlaps(@horiz1, @horiz2) FROM DUAL;
MBROverlaps(@horiz1, @horiz2)
1
SELECT MBROverlaps(@horiz1, @horiz3) FROM DUAL;
MBROverlaps(@horiz1, @horiz3)
0
SELECT MBROverlaps(@horiz1, @point1) FROM DUAL;
MBROverlaps(@horiz1, @point1)
0
SELECT MBROverlaps(@horiz1, @point2) FROM DUAL;
MBROverlaps(@horiz1, @point2)
0
DROP TABLE t1;
create table t1 (i int not null, g geometry not null)engine=innodb;
insert into t1 values (1, POINT(1,1));
insert into t1 values (2, POINT(1.5,1.5));
insert into t1 values (3, POINT(3,3));
insert into t1 values (4, POINT(3.1,3.1));
insert into t1 values (5, POINT(5,5));
alter table t1 add primary key(i);
alter table t1 drop primary key;
create spatial index idx on t1(g);
create spatial index idx2 on t1(g);
Warnings:
Note 1831 Duplicate index `idx2`. This is deprecated and will be disallowed in a future release
alter table t1 add primary key(i);
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
  `i` int(11) NOT NULL,
  `g` geometry NOT NULL,
  PRIMARY KEY (`i`),
  SPATIAL KEY `idx` (`g`),
  SPATIAL KEY `idx2` (`g`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
drop index idx on t1;
drop table t1;
create table t1 (i int, i2 char(10), g geometry not null, primary key (i, i2), spatial index (g))engine=innodb;
insert into t1 values (1, "111", POINT(1,1));
insert into t1 values (2, "222", POINT(1.5,1.5));
insert into t1 values (3, "333", POINT(3,3));
insert into t1 values (4, "444", POINT(3.1,3.1));
insert into t1 values (5, "555", POINT(5,5));
analyze table t1;
Table Op Msg_type Msg_text
test.t1 analyze status Engine-independent statistics collected
test.t1 analyze status OK
set @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
explain select ST_astext(t1.g) from t1 where MBRWithin(t1.g, @g1);
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 range g g 34 NULL 5 Using where
select ST_astext(t1.g) from t1 where MBRWithin(t1.g, @g1);
ST_astext(t1.g)
POINT(1.5 1.5)
POINT(1 1)
set @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))');
delete from t1 where MBRWithin(t1.g, @g1);
check table t1;
Table Op Msg_type Msg_text
test.t1 check status OK
select ST_astext(t1.g) from t1;
ST_astext(t1.g)
POINT(3 3)
POINT(3.1 3.1)
POINT(5 5)
set @g1 = ST_GeomFromText('Polygon((5 5,5 5,5 5,5 5,5 5))');
update t1 set g = POINT(2,2) where MBRWithin(t1.g, @g1);
check table t1;
Table Op Msg_type Msg_text
test.t1 check status OK
select ST_astext(t1.g) from t1;
ST_astext(t1.g)
POINT(3 3)
POINT(3.1 3.1)
POINT(2 2)
show indexes from t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored
t1 0 PRIMARY 1 i A # NULL NULL  BTREE   NO
t1 0 PRIMARY 2 i2 A # NULL NULL  BTREE   NO
t1 1 g 1 g A # 32 NULL  SPATIAL   NO
drop table t1;
CREATE TABLE `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`way` geometry NOT NULL,
PRIMARY KEY (`id`),
SPATIAL KEY `way` (`way`)
) ENGINE=InnoDB;
INSERT INTO t1 SET way = ST_GeomFromText('POINT(1 1)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(1 2)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(1 3)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(1 4)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(1 5)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(2 1)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(2 2)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(2 3)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(2 4)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(2 5)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(3 1)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(3 2)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(3 3)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(3 4)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(3 5)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(4 1)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(4 2)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(4 3)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(4 4)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(4 5)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(5 1)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(5 2)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(5 3)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(5 4)');
INSERT INTO t1 SET way = ST_GeomFromText('POINT(5 5)');
SELECT COUNT(*)
FROM t1
WHERE ST_CONTAINS(ST_GeomFromText('POLYGON((2 2,4 2, 4 4, 2 4, 2 2))'),way);
COUNT(*)
9
OPTIMIZE TABLE t1;
Table Op Msg_type Msg_text
test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
test.t1 optimize status OK
SELECT COUNT(*)
FROM t1
WHERE ST_CONTAINS(ST_GeomFromText('POLYGON((2 2,4 2, 4 4, 2 4, 2 2))'),way);
COUNT(*)
9
DROP TABLE t1;
CREATE TABLE t1( i INT, g GEOMETRY NOT NULL, SPATIAL INDEX (g)) ENGINE=InnoDB;
INSERT INTO t1 VALUES(1, LINESTRING(POINT(1,1), POINT(4, 4)));
INSERT INTO t1 VALUES(2, LINESTRING(POINT(2,2), POINT(5, 5)));
UPDATE t1 SET g = LINESTRING(POINT(1,1), POINT(2,2), POINT(3,3), POINT(4,4))
WHERE i = 1;
UPDATE t1 SET g = LINESTRING(POINT(1,1), POINT(2,2), POINT(3,3), POINT(8,8))
WHERE i = 2;
CHECK TABLE t1;
Table Op Msg_type Msg_text
test.t1 check status OK
DELETE FROM t1
WHERE ST_CONTAINS(ST_GeomFromText('POLYGON((0 0,4 0, 4 4, 0 4, 0 0))'),g);
DROP TABLE t1;
CREATE TABLE address (
address_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
address VARCHAR(50) NOT NULL,
address2 VARCHAR(50) DEFAULT NULL,
district VARCHAR(20) NOT NULL,
city_id SMALLINT UNSIGNED NOT NULL,
postal_code VARCHAR(10) DEFAULT NULL,
phone VARCHAR(20) NOT NULL,
location GEOMETRY NOT NULL,
last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY  (address_id),
SPATIAL KEY `idx_location` (location)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET AUTOCOMMIT=0;
INSERT INTO `address` VALUES (1,'47 MySakila Drive',NULL,'Alberta',300,'','',0x0000000001010000003E0A325D63345CC0761FDB8D99D94840,'2014-09-25 22:30:27'),
(2,'28 MySQL Boulevard',NULL,'QLD',576,'','',0x0000000001010000008E10D4DF812463404EE08C5022A23BC0,'2014-09-25 22:30:09'),
(3,'23 Workhaven Lane',NULL,'Alberta',300,'','14033335568',0x000000000101000000CDC4196863345CC01DEE7E7099D94840,'2014-09-25 22:30:27'),
(4,'1411 Lillydale Drive',NULL,'QLD',576,'','6172235589',0x0000000001010000005B0DE4341F26634042D6AE6422A23BC0,'2014-09-25 22:30:09'),
(5,'1913 Hanoi Way','','Nagasaki',463,'35200','28303384290',0x00000000010100000028D1370E21376040ABB58BC45F944040,'2014-09-25 22:31:53'),
(6,'1121 Loja Avenue','','California',449,'17886','838635286649',0x0000000001010000003C94579D8B525DC0E860472DDE0D4140,'2014-09-25 22:34:01'),
(7,'692 Joliet Street','','Attika',38,'83579','448477190408',0x000000000101000000076F59CF5AB737404105D1A45EFD4240,'2014-09-25 22:31:07'),
(8,'1566 Inegl Manor','','Mandalay',349,'53561','705814003527',0x00000000010100000006240626DCD857403C45B357C4753540,'2014-09-25 22:32:18'),
(9,'53 Idfu Parkway','','Nantou',361,'42399','10655648674',0x0000000001010000001F813FFC7C2A5E40357A354069EA3740,'2014-09-25 22:33:16'),
(10,'1795 Santiago de Compostela Way','','Texas',295,'18743','860452626434',0x00000000010100000050502F9D7BE058C0D0CF7932A4813B40,'2014-09-25 22:33:55'),
(11,'900 Santiago de Compostela Parkway','','Central Serbia',280,'93896','716571220373',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:34:11'),
(12,'478 Joliet Way','','Hamilton',200,'77948','657282285970',0x000000000101000000DC84D61E11E9654072B7353344E442C0,'2014-09-25 22:32:22'),
(13,'613 Korolev Drive','','Masqat',329,'45844','380657522649',0x00000000010100000001023164D04B4D40CEAC003A279D3740,'2014-09-25 22:32:29'),
(14,'1531 Sal Drive','','Esfahan',162,'53628','648856936185',0x000000000101000000DE0951195AD64940635A400D84534040,'2014-09-25 22:31:36'),
(15,'1542 Tarlac Parkway','','Kanagawa',440,'1027','635297277345',0x000000000101000000B4CDE8A27C6B61406B7D361724C74140,'2014-09-25 22:31:53'),
(16,'808 Bhopal Manor','','Haryana',582,'10672','465887807014',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:30'),
(17,'270 Amroha Parkway','','Osmaniye',384,'29610','695479687538',0x0000000001010000001F436C55B71F4240A11408967E894240,'2014-09-25 22:33:27'),
(18,'770 Bydgoszcz Avenue','','California',120,'16266','517338314235',0x0000000001010000006D63A2F7FC515EC04C040539835A4340,'2014-09-25 22:33:47'),
(19,'419 Iligan Lane','','Madhya Pradesh',76,'72878','990911107354',0x000000000101000000B7B01303C9595340E6F10FB633413740,'2014-09-25 22:31:13'),
(20,'360 Toulouse Parkway','','England',495,'54308','949312333307',0x000000000101000000860FDBCCD7DBE63FFDCFAB4BD7C44940,'2014-09-25 22:33:40'),
(21,'270 Toulon Boulevard','','Kalmykia',156,'81766','407752414682',0x000000000101000000FD0BA947BF204640316D495865274740,'2014-09-25 22:32:48'),
(22,'320 Brest Avenue','','Kaduna',252,'43331','747791594069',0x0000000001010000006D3425FECDC01D40623FD532630B2540,'2014-09-25 22:32:25'),
(23,'1417 Lancaster Avenue','','Northern Cape',267,'72192','272572357893',0x000000000101000000FEE8E5C127C338404DED56E075BB3CC0,'2014-09-25 22:33:03'),
(24,'1688 Okara Way','','Nothwest Border Prov',327,'21954','144453869132',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:30'),
(25,'262 A Corua (La Corua) Parkway','','Dhaka',525,'34418','892775750063',0x000000000101000000F13790E4A87A5640E7F6370DF63F3840,'2014-09-25 22:30:12'),
(26,'28 Charlotte Amalie Street','','Rabat-Sal-Zammour-Z',443,'37551','161968374323',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:16'),
(27,'1780 Hino Boulevard','','Liepaja',303,'7716','902731229323',0x000000000101000000360F1604450435403CA3AD4A22424C40,'2014-09-25 22:31:58'),
(28,'96 Tafuna Way','','Crdoba',128,'99865','934730187245',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:05'),
(29,'934 San Felipe de Puerto Plata Street','','Sind',472,'99780','196495945706',0x0000000001010000008E6B8D52D3285140D58E876302F53B40,'2014-09-25 22:32:31'),
(30,'18 Duisburg Boulevard','','',121,'58327','998009777982',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:08'),
(31,'217 Botshabelo Place','','Southern Mindanao',138,'49521','665356572025',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:36'),
(32,'1425 Shikarpur Manor','','Bihar',346,'65599','678220867005',0x0000000001010000007F9F16284E9E55408201840F25603940,'2014-09-25 22:31:20'),
(33,'786 Aurora Avenue','','Yamaguchi',474,'65750','18461860151',0x000000000101000000E712584AA05E6040D15735ADB9FA4040,'2014-09-25 22:31:53'),
(34,'1668 Anpolis Street','','Taipei',316,'50199','525255540978',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:15'),
(35,'33 Gorontalo Way','','West Bengali',257,'30348','745994947458',0x0000000001010000001A828879FB17564061585936CEAB3640,'2014-09-25 22:31:18'),
(36,'176 Mandaluyong Place','','Uttar Pradesh',239,'65213','627705991774',0x00000000010100000073309B0043A553409E3AA0B657743940,'2014-09-25 22:31:17'),
(37,'127 Purnea (Purnia) Manor','','Piemonte',17,'79388','911872220378',0x0000000001010000002A2B97D75B382140F2892B1D62744640,'2014-09-25 22:31:42'),
(38,'61 Tama Street','','Okayama',284,'94065','708403338270',0x0000000001010000001F7013A488B86040670696C8AA4A4140,'2014-09-25 22:31:49'),
(39,'391 Callao Drive','','Midi-Pyrnes',544,'34021','440512153169',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:01'),
(40,'334 Munger (Monghyr) Lane','','Markazi',31,'38145','481183273622',0x000000000101000000737275B636D848404B958334BE0B4140,'2014-09-25 22:31:36'),
(41,'1440 Fukuyama Loop','','Henan',362,'47929','912257250465',0x0000000001010000005E3CCD1319225C405886DD1C537F4040,'2014-09-25 22:30:40'),
(42,'269 Cam Ranh Parkway','','Chisinau',115,'34689','489783829737',0x000000000101000000AD97F0958ADB3C40CCD47F31B6804740,'2014-09-25 22:32:15'),
(43,'306 Antofagasta Place','','Esprito Santo',569,'3989','378318851631',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:23'),
(44,'671 Graz Street','','Oriental',353,'94399','680768868518',0x00000000010100000083F7FAFFDD7707C0F7B7BA5285954140,'2014-09-25 22:32:16'),
(45,'42 Brindisi Place','','Yerevan',586,'16744','42384721397',0x000000000101000000281BC528BE4146403BD400EF2E174440,'2014-09-25 22:30:08'),
(46,'1632 Bislig Avenue','','Nonthaburi',394,'61117','471675840679',0x000000000101000000935C59FDEC1F5940D5D0611976D32B40,'2014-09-25 22:33:20'),
(47,'1447 Imus Way','','Tahiti',167,'48942','539758313890',0x00000000010100000090CE0A56E6B562C059BB9289008E31C0,'2014-09-25 22:31:02'),
(48,'1998 Halifax Drive','','Lipetsk',308,'76022','177727722820',0x00000000010100000087985CD60EC943409F1738EA324D4A40,'2014-09-25 22:32:54'),
(49,'1718 Valencia Street','','Antofagasta',27,'37359','675292816413',0x0000000001010000007E82D5A24F9951C0C46B4DA901A737C0,'2014-09-25 22:30:29'),
(50,'46 Pjatigorsk Lane','','Moscow (City)',343,'23616','262076994845',0x0000000001010000009C51F355F2C4424002E3CFA6D9DF4B40,'2014-09-25 22:32:55'),
(51,'686 Garland Manor','','Cear',247,'52535','69493378813',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:19'),
(52,'909 Garland Manor','','Tatarstan',367,'69367','705800322606',0x000000000101000000376DC66988E949402CA85E6D7BD14B40,'2014-09-25 22:32:55'),
(53,'725 Isesaki Place','','Mekka',237,'74428','876295323994',0x000000000101000000213361455799434061EB0896D98A3540,'2014-09-25 22:33:00'),
(54,'115 Hidalgo Parkway','','Khartum',379,'80168','307703950263',0x00000000010100000004503173263D40404D0DD9E5004A2F40,'2014-09-25 22:33:11'),
(55,'1135 Izumisano Parkway','','California',171,'48150','171822533480',0x0000000001010000009763C3E4D75B5DC0799A2732CE0B4140,'2014-09-25 22:33:50'),
(56,'939 Probolinggo Loop','','Galicia',1,'4166','680428310138',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:08'),
(57,'17 Kabul Boulevard','','Chiba',355,'38594','697760867968',0x000000000101000000EB257CA5E27C61406F70D86C9BED4140,'2014-09-25 22:31:51'),
(58,'1964 Allappuzha (Alleppey) Street','','Yamaguchi',227,'48980','920811325222',0x000000000101000000C2572A5E1B876040D19A7A38DC144140,'2014-09-25 22:31:47'),
(59,'1697 Kowloon and New Kowloon Loop','','Moskova',49,'57807','499352017190',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:47'),
(60,'1668 Saint Louis Place','','Tahiti',397,'39072','347487831378',0x0000000001010000006FF3C64921B262C0F8F47DDD8E8931C0,'2014-09-25 22:31:02'),
(61,'943 Tokat Street','','Vaduz',560,'45428','889318963672',0x0000000001010000007F784C93080B23400341800C1D924740,'2014-09-25 22:31:58'),
(62,'1114 Liepaja Street','','Sarawak',282,'69226','212869228936',0x000000000101000000047FAE6C55955B408285DDC199E9F83F,'2014-09-25 22:32:00'),
(63,'1213 Ranchi Parkway','','Karnataka',350,'94352','800024380485',0x000000000101000000000080279AD7C641AA21BB1CC0202B40,'2014-09-25 22:31:21'),
(64,'81 Hodeida Way','','Rajasthan',231,'55561','250767749542',0x0000000001010000000A09BDA36BF25240F8B138526CEB3A40,'2014-09-25 22:31:17'),
(65,'915 Ponce Place','','Basel-Stadt',56,'83980','1395251317',0x0000000001010000000D6146C2084B1E40E58B07A579C74740,'2014-09-25 22:33:12'),
(66,'1717 Guadalajara Lane','','Missouri',441,'85505','914090181665',0x000000000101000000A926D247AA8C56C0A456F3774A504340,'2014-09-25 22:33:59'),
(67,'1214 Hanoi Way','','Nebraska',306,'67055','491001136577',0x000000000101000000D6671888AF2A58C0C0E2152DE5684440,'2014-09-25 22:33:56'),
(68,'1966 Amroha Avenue','','Sichuan',139,'70385','333489324603',0x0000000001010000000A7778190FE05A402F6013E346373F40,'2014-09-25 22:30:32'),
(69,'698 Otsu Street','','Cayenne',105,'71110','409983924481',0x000000000101000000D879C0E1AA2A4AC0D57EC6E0BCBB1340,'2014-09-25 22:31:02'),
(70,'1150 Kimchon Manor','','Skne ln',321,'96109','663449333709',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:11'),
(71,'1586 Guaruj Place','','Hunan',579,'5135','947233365992',0x000000000101000000AD3A06BFE83F5C4083047B0217DA3B40,'2014-09-25 22:30:46'),
(72,'57 Arlington Manor','','Madhya Pradesh',475,'48960','990214419142',0x0000000001010000008E6D63FDB069534027D9EA724A6E3940,'2014-09-25 22:31:27'),
(73,'1031 Daugavpils Parkway','','Bchar',63,'59025','107137400143',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:29:59'),
(74,'1124 Buenaventura Drive','','Mekka',13,'6856','407733804223',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:59'),
(75,'492 Cam Ranh Street','','Eastern Visayas',61,'50805','565018274456',0x0000000001010000007500C45D3D335F40B90265AE675B2540,'2014-09-25 22:32:34'),
(76,'89 Allappuzha (Alleppey) Manor','','National Capital Reg',517,'75444','255800440636',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:39'),
(77,'1947 Poos de Caldas Boulevard','','Chiayi',114,'60951','427454485876',0x0000000001010000002F06C54524195E40B4475E8C37763740,'2014-09-25 22:33:14'),
(78,'1206 Dos Quebradas Place','','So Paulo',431,'20207','241832790687',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:21'),
(79,'1551 Rampur Lane','','Changhwa',108,'72394','251164340471',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:14'),
(80,'602 Paarl Street','','Pavlodar',402,'98889','896314772871',0x000000000101000000359078C34740534032D010E912234A40,'2014-09-25 22:31:55'),
(81,'1692 Ede Loop','','So Paulo',30,'9223','918711376618',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:16'),
(82,'936 Salzburg Lane','','Uttar Pradesh',425,'96709','875756771675',0x0000000001010000000C0EE5FAAD4F5440CBF8F71917383A40,'2014-09-25 22:31:24'),
(83,'586 Tete Way','','Kanagawa',256,'1079','18581624103',0x000000000101000000783B0CF79B716140E96D22E989A74140,'2014-09-25 22:31:48'),
(84,'1888 Kabul Drive','','Oyo & Osun',217,'20936','701457319790',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:24'),
(85,'320 Baiyin Parkway','','Mahajanga',319,'37307','223664661973',0x000000000101000000EAFD90C888284740CDC75AE8EF6E2FC0,'2014-09-25 22:31:59'),
(86,'927 Baha Blanca Parkway','','Krim',479,'9495','821972242086',0x000000000101000000417DCB9C2E0E4140BC29406F857A4640,'2014-09-25 22:33:33'),
(87,'929 Tallahassee Loop','','Gauteng',497,'74671','800716535041',0x000000000101000000647F8FB05E6B3C407F60D8ABD9403AC0,'2014-09-25 22:33:06'),
(88,'125 Citt del Vaticano Boulevard','','Puebla',40,'67912','48417642933',0x000000000101000000536232B0E99B58C03D0D18247DE83240,'2014-09-25 22:32:02'),
(89,'1557 Ktahya Boulevard','','England',88,'88002','720998247660',0x0000000001010000001B43A5B67908FCBF439D03159FE54A40,'2014-09-25 22:33:36'),
(90,'870 Ashqelon Loop','','Songkhla',489,'84931','135117278909',0x000000000101000000E82510C017265940115A6A1899CB1C40,'2014-09-25 22:33:20'),
(91,'1740 Portoviejo Avenue','','Sucre',480,'29932','198123170793',0x000000000101000000C4AD275F75D952C07A51BB5F059C2240,'2014-09-25 22:30:53'),
(92,'1942 Ciparay Parkway','','Cheju',113,'82624','978987363654',0x00000000010100000048F13B97F3A25F40358EA2186AB34040,'2014-09-25 22:33:06'),
(93,'1926 El Alto Avenue','','Buenos Aires',289,'75543','846225459260',0x000000000101000000AD05AC0B2EFA4CC0C5D0A057F27541C0,'2014-09-25 22:30:05'),
(94,'1952 Chatsworth Drive','','Guangdong',332,'25958','991562402283',0x000000000101000000A5F386A08F085D406DF65157885A3840,'2014-09-25 22:30:40'),
(95,'1370 Le Mans Avenue','','Brunei and Muara',53,'52163','345679835036',0x00000000010100000013E85D06ADBC5C402A0E5652DDC21340,'2014-09-25 22:30:23'),
(96,'984 Effon-Alaiye Avenue','','Gois',183,'17119','132986892228',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:17'),
(97,'832 Nakhon Sawan Manor','','Inner Mongolia',592,'49021','275595571388',0x000000000101000000535C55F6DDAD5E400000001D69FABC41,'2014-09-25 22:30:50'),
(98,'152 Kitwe Parkway','','Caraga',82,'53182','835433605312',0x000000000101000000DF652BD43F945F4006CAB788396E2040,'2014-09-25 22:32:35'),
(99,'1697 Tanauan Lane','','Punjab',399,'22870','4764773857',0x000000000101000000CA97063447E95240B933B852742A4040,'2014-09-25 22:31:22'),
(100,'1308 Arecibo Way','','Georgia',41,'30695','6171054059',0x000000000101000000FC00FFEF637E54C0BD9EF9E648BC4040,'2014-09-25 22:33:43'),
(101,'1599 Plock Drive','','Tete',534,'71986','817248913162',0x000000000101000000DC77561C18CB4040B443577D092830C0,'2014-09-25 22:32:18'),
(102,'669 Firozabad Loop','','Abu Dhabi',12,'92265','412903167998',0x0000000001010000009C76E73F5AE14B404AD05FE811313840,'2014-09-25 22:33:35'),
(103,'588 Vila Velha Manor','','Kyongsangbuk',268,'51540','333339908719',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:07'),
(104,'1913 Kamakura Place','','Lipetsk',238,'97287','942570536750',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:49'),
(105,'733 Mandaluyong Place','','Asir',2,'77459','196568435814',0x0000000001010000007823980FAD404540798FD89365373240,'2014-09-25 22:32:59'),
(106,'659 Vaduz Drive','','Ha Darom',34,'49708','709935135487',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:40'),
(107,'1177 Jelets Way','','Kwara & Kogi',220,'3305','484292626944',0x0000000001010000001767672CF53712407E3E25427E192140,'2014-09-25 22:32:24'),
(108,'1386 Yangor Avenue','','Provence-Alpes-Cte',543,'80720','449216226468',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:01'),
(109,'454 Nakhon Sawan Boulevard','','Funafuti',173,'76383','963887147572',0x0000000001010000005822ABB636666640FF74A84B6B0C21C0,'2014-09-25 22:33:31'),
(110,'1867 San Juan Bautista Tuxtepec Avenue','','Ivanovo',225,'78311','547003310357',0x000000000101000000BC6DF0CF567C4440E2B034F0A37F4C40,'2014-09-25 22:32:48'),
(111,'1532 Dzerzinsk Way','','Buenos Aires',334,'9599','330838016880',0x000000000101000000BF93BB74385D4DC0E207420D3A5541C0,'2014-09-25 22:30:06'),
(112,'1002 Ahmadnagar Manor','','Mxico',213,'93026','371490777743',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:07'),
(113,'682 Junan Way','','North West',273,'30418','622255216127',0x000000000101000000714683CAAEAA3A406AEDC73725DA3AC0,'2014-09-25 22:33:04'),
(114,'804 Elista Drive','','Hubei',159,'61069','379804592943',0x0000000001010000009E013FF4EE5E5B40E7E099D0245F3E40,'2014-09-25 22:30:33'),
(115,'1378 Alvorada Avenue','','Distrito Federal',102,'75834','272234298332',0x0000000001010000000C3444BA44B850C047B1378CDDF92440,'2014-09-25 22:34:03'),
(116,'793 Cam Ranh Avenue','','California',292,'87057','824370924746',0x00000000010100000003AF3B82C0885DC0610212A859594140,'2014-09-25 22:33:55'),
(117,'1079 Tel Aviv-Jaffa Boulevard','','Sucre',132,'10885','358178933857',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:34:04'),
(118,'442 Rae Bareli Place','','Nordrhein-Westfalen',148,'24321','886636413768',0x000000000101000000C19EC085860F1B40E37ED12F5BB74940,'2014-09-25 22:31:04'),
(119,'1107 Nakhon Sawan Avenue','','Mxico',365,'75149','867546627903',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:11'),
(120,'544 Malm Parkway','','Central Java',403,'63502','386759646229',0x0000000001010000003AEF5A9D77575B4026F103A106C51BC0,'2014-09-25 22:31:34'),
(121,'1967 Sincelejo Place','','Gujarat',176,'73644','577812616052',0x00000000010100000059912CBBBB2B52408DBC074378373740,'2014-09-25 22:31:16'),
(122,'333 Goinia Way','','Texas',185,'78625','909029256431',0x0000000001010000002AE67BA1DB3F58C0E46B2AE67B5F4040,'2014-09-25 22:33:51'),
(123,'1987 Coacalco de Berriozbal Loop','','al-Qalyubiya',476,'96065','787654415858',0x000000000101000000595AFC5C23403F40AFBA698E07203E40,'2014-09-25 22:30:58'),
(124,'241 Mosul Lane','','Risaralda',147,'76157','765345144779',0x000000000101000000983A23A5B4EA52C06155BDFC4E5B1340,'2014-09-25 22:30:52'),
(125,'211 Chiayi Drive','','Uttar Pradesh',164,'58186','665993880048',0x000000000101000000A44BA4D961C1534007F247AC20C73A40,'2014-09-25 22:31:15'),
(126,'1175 Tanauan Way','','Lima',305,'64615','937222955822',0x000000000101000000848A60D2CE4153C0E5417A8A1C1628C0,'2014-09-25 22:32:33'),
(127,'117 Boa Vista Way','','Uttar Pradesh',566,'6804','677976133614',0x00000000010100000085364AA8AAC0544086BAFE1312513940,'2014-09-25 22:31:29'),
(128,'848 Tafuna Manor','','Ktahya',281,'45142','614935229095',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:27'),
(129,'569 Baicheng Lane','','Gauteng',85,'60304','490211944645',0x000000000101000000D71E51FC73423C4048AE51C543363AC0,'2014-09-25 22:33:02'),
(130,'1666 Qomsheh Drive','','So Paulo',410,'66255','582835362905',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:20'),
(131,'801 Hagonoy Drive','','Smolensk',484,'8439','237426099212',0x0000000001010000001EB814A122054040BB8509FE12644B40,'2014-09-25 22:32:57'),
(132,'1050 Garden Grove Avenue','','Slaskie',236,'4999','973047364353',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:42'),
(133,'1854 Tieli Street','','Shandong',302,'15819','509492324775',0x0000000001010000007A820E0492FE5C408F0475255D3A4240,'2014-09-25 22:30:39'),
(134,'758 Junan Lane','','Gois',190,'82639','935448624185',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:18'),
(135,'1752 So Leopoldo Parkway','','Taka-Karpatia',345,'14014','252265130067',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:32'),
(136,'898 Belm Manor','','Free State',87,'49757','707169393853',0x000000000101000000ED4CFCAC8DB43A409EAC623B29453DC0,'2014-09-25 22:33:02'),
(137,'261 Saint Louis Way','','Coahuila de Zaragoza',541,'83401','321944036800',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:13'),
(138,'765 Southampton Drive','','al-Qalyubiya',421,'4285','23712411567',0x0000000001010000001BEB877DA7343F409FBC7E77E12D3E40,'2014-09-25 22:30:57'),
(139,'943 Johannesburg Avenue','','Maharashtra',417,'5892','90921003005',0x000000000101000000F27A3029BE7652405E2ADB2C03853240,'2014-09-25 22:31:24'),
(140,'788 Atinsk Street','','Karnataka',211,'81691','146497509724',0x0000000001010000000000801B1998C64157A945E977E62E40,'2014-09-25 22:31:17'),
(141,'1749 Daxian Place','','Gelderland',29,'11044','963369996279',0x000000000101000000E4CE96BDB6E0174000B0952B171C4A40,'2014-09-25 22:32:20'),
(142,'1587 Sullana Lane','','Inner Mongolia',207,'85769','468060467018',0x000000000101000000870CF505BEE95B407422669BC0674440,'2014-09-25 22:30:35'),
(143,'1029 Dzerzinsk Manor','','Ynlin',542,'57519','33173584456',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:16'),
(144,'1666 Beni-Mellal Place','','Tennessee',123,'13377','9099941466',0x00000000010100000005D1A45E01D755C084CCDFCECF434240,'2014-09-25 22:33:48'),
(145,'928 Jaffna Loop','','Hiroshima',172,'93762','581852137991',0x0000000001010000002F2988CBBBAB6040E2FF33EFDD3D4140,'2014-09-25 22:31:45'),
(146,'483 Ljubertsy Parkway','','Scotland',149,'60562','581174211853',0x000000000101000000C53E5CCD95CC07C0FAFD518A0C3C4C40,'2014-09-25 22:33:36'),
(147,'374 Bat Yam Boulevard','','Kilis',266,'97700','923261616249',0x000000000101000000184FF344C68E4240FD55DBA8A95B4240,'2014-09-25 22:33:26'),
(148,'1027 Songkhla Manor','','Minsk',340,'30861','563660187896',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:13'),
(149,'999 Sanaa Loop','','Gauteng',491,'3439','918032330119',0x0000000001010000000E0D309864193C40F234AA1D0F7939C0,'2014-09-25 22:33:05'),
(150,'879 Newcastle Way','','Michigan',499,'90732','206841104594',0x000000000101000000916A8E62EFC154C08244C99A474A4540,'2014-09-25 22:34:01'),
(151,'1337 Lincoln Parkway','','Saitama',555,'99457','597815221267',0x0000000001010000005E0E6036A6746140456227614BEE4140,'2014-09-25 22:31:55'),
(152,'1952 Pune Lane','','Saint-Denis',442,'92150','354615066969',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:46'),
(153,'782 Mosul Street','','Massachusetts',94,'25545','885899703621',0x000000000101000000E9C4D44C2DC151C0D1686105AE0A4540,'2014-09-25 22:33:46'),
(154,'781 Shimonoseki Drive','','Michoacn de Ocampo',202,'95444','632316273199',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:06'),
(155,'1560 Jelets Boulevard','','Shandong',291,'77777','189446090264',0x00000000010100000018D57D5B0B6A5D40ADDA3521AD184240,'2014-09-25 22:30:38'),
(156,'1963 Moscow Place','','Assam',354,'64863','761379480249',0x000000000101000000203BB9F04D2C57405D595826B2593A40,'2014-09-25 22:31:21'),
(157,'456 Escobar Way','','Jakarta Raya',232,'36061','719202533520',0x000000000101000000DDC2A9C516B65A4095CCFB49C6DB18C0,'2014-09-25 22:31:33'),
(158,'798 Cianjur Avenue','','Shanxi',590,'76990','499408708580',0x00000000010100000013D6C6D889BF5B409B4BBBE2F3824140,'2014-09-25 22:30:49'),
(159,'185 Novi Sad Place','','Bern',72,'41778','904253967161',0x00000000010100000000D0BC772FCA1D40377D2C335B794740,'2014-09-25 22:33:13'),
(160,'1367 Yantai Manor','','Ondo & Ekiti',381,'21294','889538496300',0x000000000101000000C25E72ED555514408A7A1C61ACAA1C40,'2014-09-25 22:32:26'),
(161,'1386 Nakhon Sawan Boulevard','','Pyongyang-si',420,'53502','368899174225',0x000000000101000000F4BA8FED46705F40A55F6C6B55844340,'2014-09-25 22:32:28'),
(162,'369 Papeete Way','','North Carolina',187,'66639','170117068815',0x000000000101000000C49D66DCAFF253C07A2D324B4C094240,'2014-09-25 22:33:52'),
(163,'1440 Compton Place','','North Austria',307,'81037','931059836497',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:10'),
(164,'1623 Baha Blanca Manor','','Moskova',310,'81511','149981248346',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:54'),
(165,'97 Shimoga Avenue','','Tel Aviv',533,'44660','177167004331',0x0000000001010000009A56AFC7E96341403192E2885A0A4040,'2014-09-25 22:31:41'),
(166,'1740 Le Mans Loop','','Pays de la Loire',297,'22853','168476538960',0x000000000101000000452A8C2D04B9D23F0000006AB82DBD41,'2014-09-25 22:31:01'),
(167,'1287 Xiangfan Boulevard','','Gifu',253,'57844','819416131190',0x0000000001010000006AE514D3BB1B61408141D2A755B54140,'2014-09-25 22:31:48'),
(168,'842 Salzburg Lane','','Adana',529,'3313','697151428760',0x0000000001010000007207A0072DD5414093228D6555A64240,'2014-09-25 22:33:29'),
(169,'154 Tallahassee Loop','','Xinxiang',199,'62250','935508855935',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:34'),
(170,'710 San Felipe del Progreso Avenue','','Lilongwe',304,'76901','843801144113',0x00000000010100000089C855D1C4E44040501D064E11EF2BC0,'2014-09-25 22:31:59'),
(171,'1540 Wroclaw Drive','','Maharashtra',107,'62686','182363341674',0x0000000001010000004E10D0D8F2D253407CFB294476F23340,'2014-09-25 22:31:14'),
(172,'475 Atinsk Way','','Gansu',240,'59571','201705577290',0x0000000001010000007872970E678C59405544978114404340,'2014-09-25 22:30:36'),
(173,'1294 Firozabad Drive','','Jiangxi',407,'70618','161801569569',0x000000000101000000EED7F8A7AF775C402332079C00943B40,'2014-09-25 22:30:40'),
(174,'1877 Ezhou Lane','','Rajasthan',550,'63337','264541743403',0x00000000010100000029722DFF466C52401969F34938923840,'2014-09-25 22:31:28'),
(175,'316 Uruapan Street','','Perak',223,'58194','275788967899',0x0000000001010000005A3629BB4F4559400AC5B18927561240,'2014-09-25 22:31:59'),
(176,'29 Pyongyang Loop','','Batman',58,'47753','734780743462',0x0000000001010000001C430070EC9044403C8963B895F14240,'2014-09-25 22:33:23'),
(177,'1010 Klerksdorp Way','','Steiermark',186,'6802','493008546874',0x000000000101000000CFEE35A90DE72E409C0425BB88884740,'2014-09-25 22:30:10'),
(178,'1848 Salala Boulevard','','Miranda',373,'25220','48265851133',0x0000000001010000006D08E984ABB150C02F90FBB1A43B2440,'2014-09-25 22:34:04'),
(179,'431 Xiangtan Avenue','','Kerala',18,'4854','230250973122',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:10'),
(180,'757 Rustenburg Avenue','','Skikda',483,'89668','506134035434',0x000000000101000000BFD76BD509A31B4063867C8626704240,'2014-09-25 22:30:01'),
(181,'146 Johannesburg Way','','Tamaulipas',330,'54132','953689007081',0x0000000001010000003C45B357446058C0EAD621ED35E13940,'2014-09-25 22:32:09'),
(182,'1891 Rizhao Boulevard','','So Paulo',456,'47288','391065549876',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:21'),
(183,'1089 Iwatsuki Avenue','','Kirov',270,'35109','866092335135',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:50'),
(184,'1410 Benin City Parkway','','Risaralda',405,'29747','104150372603',0x0000000001010000007C4F9B278DEC52C0795BE9B5D9401340,'2014-09-25 22:30:52'),
(185,'682 Garden Grove Place','','Tennessee',333,'67497','72136330362',0x0000000001010000004204C188228356C06B4F24F323934140,'2014-09-25 22:33:57'),
(186,'533 al-Ayn Boulevard','','California',126,'8862','662227486184',0x000000000101000000BF2264C5158E5DC08533AE6EABF24040,'2014-09-25 22:33:48'),
(187,'1839 Szkesfehrvr Parkway','','Gois',317,'55709','947468818183',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:20'),
(188,'741 Ambattur Manor','','Noord-Brabant',438,'43310','302590383819',0x000000000101000000699E6D7F78371540EF0D74A37ED94940,'2014-09-25 22:32:21'),
(189,'927 Barcelona Street','','Chaharmahal va Bakht',467,'65121','951486492670',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:38'),
(190,'435 0 Way','','West Bengali',195,'74750','760171523969',0x000000000101000000D9846A3906075640037168DB7A0F3640,'2014-09-25 22:31:16'),
(191,'140 Chiayi Parkway','','Sumy',506,'38982','855863906434',0x0000000001010000002C43C1317066414051BB5F05F8754940,'2014-09-25 22:33:34'),
(192,'1166 Changhwa Street','','Caraga',62,'58852','650752094490',0x0000000001010000009DB756201F715F40F53E9F1221832140,'2014-09-25 22:32:34'),
(193,'891 Novi Sad Manor','','Ontario',383,'5379','247646995453',0x0000000001010000005E49F25C5FB653C0DE6AE74537F34540,'2014-09-25 22:30:28'),
(194,'605 Rio Claro Parkway','','Tabora',513,'49348','352469351088',0x0000000001010000004E8B0B51CF694040DF67017F9D1014C0,'2014-09-25 22:33:18'),
(195,'1077 San Felipe de Puerto Plata Place','','Rostov-na-Donu',369,'65387','812824036424',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:56'),
(196,'9 San Miguel de Tucumn Manor','','Uttar Pradesh',169,'90845','956188728558',0x00000000010100000067DBC424B7995340A461E75C40263B40,'2014-09-25 22:31:15'),
(197,'447 Surakarta Loop','','Nyanza',271,'10428','940830176580',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:56'),
(198,'345 Oshawa Boulevard','','Tokyo-to',204,'32114','104491201771',0x000000000101000000FB5E9E29CF6C61404BFCF61A27D64140,'2014-09-25 22:31:45'),
(199,'1792 Valle de la Pascua Place','','Nordrhein-Westfalen',477,'15540','419419591240',0x000000000101000000E9BD8CBD720C204056725F18FA6F4940,'2014-09-25 22:31:06'),
(200,'1074 Binzhou Manor','','Baden-Wrttemberg',325,'36490','331132568928',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:05'),
(201,'817 Bradford Loop','','Jiangsu',109,'89459','264286442804',0x000000000101000000C3E1BB830EFD5D4006B243A10AC63F40,'2014-09-25 22:30:31'),
(202,'955 Bamenda Way','','Ondo & Ekiti',218,'1545','768481779568',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:24'),
(203,'1149 A Corua (La Corua) Boulevard','','Haiphong',194,'95824','470884141195',0x0000000001010000007573F1B7BDAB5A4050A0997164DD3440,'2014-09-25 22:34:06'),
(204,'387 Mwene-Ditu Drive','','Ahal',35,'8073','764477681869',0x000000000101000000B0253F3D11314D40A538A2D68FFA4240,'2014-09-25 22:33:30'),
(205,'68 Molodetno Manor','','Nordrhein-Westfalen',575,'4662','146640639760',0x000000000101000000EEF3739E0C691D40FE486CD2C8B84940,'2014-09-25 22:31:06'),
(206,'642 Nador Drive','','Maharashtra',77,'3924','369050085652',0x000000000101000000559D7A4908F25240E010AAD4EC0B3540,'2014-09-25 22:31:13'),
(207,'1688 Nador Lane','','Sulawesi Utara',184,'61613','652218196731',0x000000000101000000E358727044945E4093F139C148B9E83F,'2014-09-25 22:31:32'),
(208,'1215 Pyongyang Parkway','','Usak',557,'25238','646237101779',0x000000000101000000019E59B7E6673D40735E08DE35564340,'2014-09-25 22:33:30'),
(209,'1679 Antofagasta Street','','Alto Paran',122,'86599','905903574913',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:32'),
(210,'1304 s-Hertogenbosch Way','','Santa Catarina',83,'10925','90336226227',0x000000000101000000BDEAB765768848C05755D40561EB3AC0,'2014-09-25 22:30:16'),
(211,'850 Salala Loop','','Kitaa',371,'10800','403404780639',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:07'),
(212,'624 Oshawa Boulevard','','West Bengali',51,'89959','49677664184',0x0000000001010000000FBCB5A7BF315640EA7CD34F93383940,'2014-09-25 22:31:11'),
(213,'43 Dadu Avenue','','Rajasthan',74,'4855','95666951770',0x000000000101000000BCF957A0A7A852404046E5CBB0583940,'2014-09-25 22:31:12'),
(214,'751 Lima Loop','','Aden',7,'99405','756460337785',0x0000000001010000005ECF21BAB1844640A9007388138F2940,'2014-09-25 22:34:08'),
(215,'1333 Haldia Street','','Jilin',174,'82161','408304391718',0x00000000010100000007A51E5844345F404CE71E6D77974640,'2014-09-25 22:30:33'),
(216,'660 Jedda Boulevard','','Washington',65,'25053','168758068397',0x00000000010100000009EEF60FD88C5EC03C331C2A21CE4740,'2014-09-25 22:33:45'),
(217,'1001 Miyakonojo Lane','','Taizz',518,'67924','584316724815',0x0000000001010000006642DD51AD024640782C1103B8282B40,'2014-09-25 22:34:11'),
(218,'226 Brest Manor','','California',508,'2299','785881412500',0x000000000101000000CF9F36AA53825EC0B54D96FF35AF4240,'2014-09-25 22:34:02'),
(219,'1229 Valencia Parkway','','Haskovo',498,'99124','352679173732',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:24'),
(220,'1201 Qomsheh Manor','','Gois',28,'21464','873492228462',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:15'),
(221,'866 Shivapuri Manor','','Uttar Pradesh',448,'22474','778502731092',0x000000000101000000940BDF0C48A4534072648ADE4E953C40,'2014-09-25 22:31:26'),
(222,'1168 Najafabad Parkway','','Kabol',251,'40301','886649065861',0x0000000001010000009173AC9C074B51408EBDCDD199434140,'2014-09-25 22:29:59'),
(223,'1244 Allappuzha (Alleppey) Place','','Buenos Aires',567,'20657','991802825778',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:08'),
(224,'1842 Luzinia Boulevard','','Zanzibar West',593,'94420','706878974831',0x00000000010100000045E169E855994340B62C5F97E1A718C0,'2014-09-25 22:33:19'),
(225,'1926 Gingoog Street','','Sisilia',511,'22824','469738825391',0x0000000001010000004DD9E907758D2E40719AF4ADC58A4240,'2014-09-25 22:31:44'),
(226,'810 Palghat (Palakkad) Boulevard','','Jaroslavl',235,'73431','516331171356',0x00000000010100000069D48DC1D4EF43400294D0A79FD04C40,'2014-09-25 22:32:49'),
(227,'1820 Maring Parkway','','Punjab',324,'88307','99760893676',0x0000000001010000001E053EF5FE5E52406C617193AC4A4040,'2014-09-25 22:32:30'),
(228,'60 Poos de Caldas Street','','Rajasthan',243,'82338','963063788669',0x00000000010100000069EED7536140524079605B9AB6443A40,'2014-09-25 22:31:18'),
(229,'1014 Loja Manor','','Tamil Nadu',22,'66851','460795526514',0x000000000101000000803E366E560A5440A1212DDF44322A40,'2014-09-25 22:31:10'),
(230,'201 Effon-Alaiye Way','','Asuncin',37,'64344','684192903087',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:31'),
(231,'430 Alessandria Loop','','Saarland',439,'47446','669828224459',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:06'),
(232,'754 Valencia Place','','Phnom Penh',406,'87911','594319417514',0x0000000001010000009093D3E89F3A5A40AACCDE63FA1F2740,'2014-09-25 22:30:25'),
(233,'356 Olomouc Manor','','Gois',26,'93323','22326410776',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:15'),
(234,'1256 Bislig Boulevard','','Botosani',86,'50598','479007229460',0x00000000010100000085059C4AABAA3A408DAC46C032E04740,'2014-09-25 22:32:46'),
(235,'954 Kimchon Place','','West Bengali',559,'42420','541327526474',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:28'),
(236,'885 Yingkou Manor','','Kaduna',596,'31390','588964509072',0x00000000010100000006CF296D16E41E4038E3EAB6FA382640,'2014-09-25 22:32:28'),
(237,'1736 Cavite Place','','Qina',216,'98775','431770603551',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:56'),
(238,'346 Skikda Parkway','','Hawalli',233,'90628','630424482919',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:57'),
(239,'98 Stara Zagora Boulevard','','Valle',96,'76448','610173756082',0x00000000010100000084CD4AA4FE4153C0DB9953138E0A0F40,'2014-09-25 22:30:51'),
(240,'1479 Rustenburg Boulevard','','Southern Tagalog',527,'18727','727785483194',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:40'),
(241,'647 A Corua (La Corua) Street','','Chollanam',357,'36971','792557457753',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:07'),
(242,'1964 Gijn Manor','','Karnataka',473,'14408','918119601885',0x000000000101000000BBC3DCA458E45240DA4246F6F7DC2B40,'2014-09-25 22:31:26'),
(243,'47 Syktyvkar Lane','','West Java',118,'22236','63937119031',0x000000000101000000EDABBC2E8DB05A40C3C1397E037E1AC0,'2014-09-25 22:31:31'),
(244,'1148 Saarbrcken Parkway','','Fukushima',226,'1921','137773001988',0x000000000101000000AD8ACB4C449C614053F8229001874240,'2014-09-25 22:31:47'),
(245,'1103 Bilbays Parkway','','Hubei',578,'87660','279979529227',0x000000000101000000A76ED34444095C401234C1CB67054040,'2014-09-25 22:30:45'),
(246,'1246 Boksburg Parkway','','Hebei',422,'28349','890283544295',0x000000000101000000B66A323EA7E55D40E508BE0E41F74340,'2014-09-25 22:30:41'),
(247,'1483 Pathankot Street','','Tucumn',454,'37288','686015532180',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:06'),
(248,'582 Papeete Loop','','Central Visayas',294,'27722','569868543137',0x0000000001010000001F189BB1C3FC5E407DC4F9E5DD9E2440,'2014-09-25 22:32:38'),
(249,'300 Junan Street','','Kyonggi',553,'81314','890289150158',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:08'),
(250,'829 Grand Prairie Way','','Paran',328,'6461','741070712873',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:20'),
(251,'1473 Changhwa Parkway','','Mxico',124,'75933','266798132374',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:03'),
(252,'1309 Weifang Street','','Florida',520,'57338','435785045362',0x000000000101000000EC0CF8A1F71155C0995A006432703E40,'2014-09-25 22:34:02'),
(253,'1760 Oshawa Manor','','Tianjin',535,'38140','56257502250',0x000000000101000000FBBD5EAB4E4B5D40EB0A6C8434924340,'2014-09-25 22:30:43'),
(254,'786 Stara Zagora Way','','Oyo & Osun',390,'98332','716256596301',0x000000000101000000DB45E22F77770F4073C8BC44AB691F40,'2014-09-25 22:32:27'),
(255,'1966 Tonghae Street','','Anhalt Sachsen',198,'36481','567359279425',0x0000000001010000000000009825D59D41450A0A2879C84940,'2014-09-25 22:31:05'),
(256,'1497 Yuzhou Drive','','England',312,'3433','246810237916',0x000000000101000000CC4642B68718C0BFCA822E8617C14940,'2014-09-25 22:33:37'),
(258,'752 Ondo Loop','','Miyazaki',338,'32474','134673576619',0x00000000010100000048AD8B36226260408871EDFABBBB3F40,'2014-09-25 22:31:50'),
(259,'1338 Zalantun Lane','','Minas Gerais',413,'45403','840522972766',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:21'),
(260,'127 Iwakuni Boulevard','','Central Luzon',192,'20777','987442542471',0x0000000001010000000E6954E0E42E5E40AF05627E13AB2D40,'2014-09-25 22:32:37'),
(261,'51 Laredo Avenue','','Sagaing',342,'68146','884536620568',0x0000000001010000008720BD97B1C85740D4D7F335CB1B3640,'2014-09-25 22:32:18'),
(262,'771 Yaound Manor','','Sofala',64,'86768','245477603573',0x000000000101000000103345CA606B414046CB2665F7D733C0,'2014-09-25 22:32:17'),
(263,'532 Toulon Street','','Santiago',460,'69517','46871694740',0x000000000101000000ECD33B269CAC51C09AB67F65A5733340,'2014-09-25 22:30:55'),
(264,'1027 Banjul Place','','West Bengali',197,'50390','538241037443',0x000000000101000000FE14223BCA1A5640AC6F6072A3EE3640,'2014-09-25 22:31:16'),
(265,'1158 Mandi Bahauddin Parkway','','Shanxi',136,'98484','276555730211',0x000000000101000000ECC84741A6525C40A93C7084FB0B4440,'2014-09-25 22:30:32'),
(266,'862 Xintai Lane','','Cagayan Valley',548,'30065','265153400632',0x00000000010100000015580053866E5E408A5CCBBFF19C3140,'2014-09-25 22:32:41'),
(267,'816 Cayenne Parkway','','Manab',414,'93629','282874611748',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:56'),
(268,'1831 Nam Dinh Loop','','National Capital Reg',323,'51990','322888976727',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:38'),
(269,'446 Kirovo-Tepetsk Lane','','Osaka',203,'19428','303967439816',0x0000000001010000008D94D2D8C3F36040608CED5AE7554140,'2014-09-25 22:31:45'),
(270,'682 Halisahar Place','','Severn Morava',378,'20536','475553436330',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:54'),
(271,'1587 Loja Manor','','Salzburg',447,'5410','621625204422',0x0000000001010000002C83C53C86162A405886DD1C53E64740,'2014-09-25 22:30:10'),
(272,'1762 Paarl Parkway','','Hunan',298,'53928','192459639410',0x00000000010100000067333D177CDB5B40DBA8A9C024B03B40,'2014-09-25 22:30:39'),
(273,'1519 Ilorin Place','','Kerala',395,'49298','357445645426',0x0000000001010000000C4FF921002A5340BD772F52838C2540,'2014-09-25 22:31:21'),
(274,'920 Kumbakonam Loop','','California',446,'75090','685010736240',0x00000000010100000012EF4ADCF4695EC01B95E535C0564240,'2014-09-25 22:34:00'),
(275,'906 Goinia Way','','Wielkopolskie',255,'83565','701767622697',0x0000000001010000007FA2B2614D1732404064366D6BE14940,'2014-09-25 22:32:42'),
(276,'1675 Xiangfan Manor','','Tamil Nadu',283,'11763','271149517630',0x00000000010100000042B687180AD95340EE4108C897EC2540,'2014-09-25 22:31:20'),
(277,'85 San Felipe de Puerto Plata Drive','','Shandong',584,'46063','170739645687',0x000000000101000000EA605859365C5E40EF1010DDFDBC4240,'2014-09-25 22:30:48'),
(278,'144 South Hill Loop','','Guanajuato',445,'2012','45387294817',0x0000000001010000002B84D558424C59C0699B2CFF6B923440,'2014-09-25 22:32:11'),
(279,'1884 Shikarpur Avenue','','Haryana',263,'85548','959949395183',0x0000000001010000002CE395DA413F5340EB460EC7A9B03D40,'2014-09-25 22:31:19'),
(280,'1980 Kamjanets-Podilskyi Street','','Illinois',404,'89502','874337098891',0x000000000101000000167CE420B26556C0B7966EB7C9584440,'2014-09-25 22:33:57'),
(281,'1944 Bamenda Way','','Michigan',573,'24645','75975221996',0x000000000101000000B8B64B76C7C154C0EF254344203D4540,'2014-09-25 22:34:03'),
(282,'556 Baybay Manor','','Oyo & Osun',374,'55802','363982224739',0x000000000101000000F5C6FFD3C30E1140FC30E7BE41502040,'2014-09-25 22:32:25'),
(283,'457 Tongliao Loop','','Bursa',222,'56254','880756161823',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:25'),
(284,'600 Bradford Street','','East Azerbaidzan',514,'96204','117592274996',0x000000000101000000EE4E2D115E25474044FF5FD09D0A4340,'2014-09-25 22:31:40'),
(285,'1006 Santa Brbara dOeste Manor','','Ondo & Ekiti',389,'36229','85059738746',0x000000000101000000FBC67CE5E6581640531A7B40EAC81C40,'2014-09-25 22:32:26'),
(286,'1308 Sumy Loop','','Fujian',175,'30657','583021225407',0x000000000101000000DC7AF25597D35D409617AAACB70F3A40,'2014-09-25 22:30:34'),
(287,'1405 Chisinau Place','','Ponce',411,'8160','62781725285',0x000000000101000000974341DF4CA750C03F219628D6023240,'2014-09-25 22:32:45'),
(288,'226 Halifax Street','','Xinxiang',277,'58492','790651020929',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:38'),
(289,'1279 Udine Parkway','','Edo & Delta',69,'75860','195003555232',0x000000000101000000FFB7EDD68D8216408FF4B3A217571940,'2014-09-25 22:32:23'),
(290,'1336 Benin City Drive','','Shiga',386,'46044','341242939532',0x000000000101000000D5810761C9FB60401B07A8BA91804140,'2014-09-25 22:31:53'),
(291,'1155 Liaocheng Place','','Oyo & Osun',152,'22650','558236142492',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:23'),
(292,'1993 Tabuk Lane','','Tamil Nadu',522,'64221','648482415405',0x0000000001010000002AF3A0EA210854407F94C78965D92940,'2014-09-25 22:31:27'),
(293,'86 Higashiosaka Lane','','Guanajuato',563,'33768','957128697225',0x0000000001010000002DAF5C6F1B4C59C07F34F7EBA9643440,'2014-09-25 22:32:14'),
(294,'1912 Allende Manor','','Kowloon and New Kowl',279,'58124','172262454487',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:09'),
(295,'544 Tarsus Boulevard','','Gurico',562,'53145','892523334',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:34:05'),
(296,'1936 Cuman Avenue','','Virginia',433,'61195','976798660411',0x000000000101000000FD7B3A6840FC53C065F4ED6EAFA24240,'2014-09-25 22:33:58'),
(297,'1192 Tongliao Street','','Sharja',470,'19065','350970907017',0x000000000101000000AA27F38FBEB44B4053E68B625E563940,'2014-09-25 22:33:35'),
(298,'44 Najafabad Way','','Baskimaa',146,'61391','96604821070',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:08'),
(299,'32 Pudukkottai Lane','','Ohio',140,'38834','967274728547',0x000000000101000000077AA86D430C55C0409C2C5A25E14340,'2014-09-25 22:33:49'),
(300,'661 Chisinau Lane','','Pietari',274,'8856','816436065431',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:51'),
(301,'951 Stara Zagora Manor','','Punjab',400,'98573','429925609431',0x0000000001010000001E296C50C51953405651723DC0533E40,'2014-09-25 22:31:22'),
(302,'922 Vila Velha Loop','','Maharashtra',9,'4085','510737228015',0x000000000101000000738F5B8242AF5240612129D835183340,'2014-09-25 22:31:10'),
(303,'898 Jining Lane','','Pohjois-Pohjanmaa',387,'40070','161643343536',0x0000000001010000003DFB80F6D9773940C8D0B183CA405040,'2014-09-25 22:31:00'),
(304,'1635 Kuwana Boulevard','','Hiroshima',205,'52137','710603868323',0x000000000101000000AA944330B38E6040247035FCB8324140,'2014-09-25 22:31:46'),
(305,'41 El Alto Parkway','','Maharashtra',398,'56883','51917807050',0x000000000101000000D487E41A55315340BC3088FEBF443340,'2014-09-25 22:31:22'),
(306,'1883 Maikop Lane','','Kaliningrad',254,'68469','96110042435',0x00000000010100000020DF94A8CD82344015D918856E5A4B40,'2014-09-25 22:32:50'),
(307,'1908 Gaziantep Place','','Liaoning',536,'58979','108053751300',0x0000000001010000004DAA6C0EC6E65E408E9F7C30DF344540,'2014-09-25 22:30:43'),
(308,'687 Alessandria Parkway','','Sanaa',455,'57587','407218522294',0x0000000001010000000C60257A741A4640854A123A9EB52E40,'2014-09-25 22:34:10'),
(309,'827 Yuncheng Drive','','Callao',99,'79047','504434452842',0x000000000101000000C2514DA48F4753C0271CD544FA1C28C0,'2014-09-25 22:32:32'),
(310,'913 Coacalco de Berriozbal Loop','','Texas',33,'42141','262088367001',0x00000000010100000023371EC7EA4658C0A86851442B5E4040,'2014-09-25 22:33:43'),
(311,'715 So Bernardo do Campo Lane','','Kedah',507,'84804','181179321332',0x000000000101000000D8DBC1E3361F5940520DFB3DB1961640,'2014-09-25 22:32:00'),
(312,'1354 Siegen Street','','Rio de Janeiro',25,'80184','573441801529',0x0000000001010000009146054EB62846C0FCA0D398B50137C0,'2014-09-25 22:30:15'),
(313,'1191 Sungai Petani Boulevard','','Missouri',262,'9668','983259819766',0x00000000010100000055890D7107A557C0CB7564F6C38C4340,'2014-09-25 22:33:54'),
(314,'1224 Huejutla de Reyes Boulevard','','Lombardia',91,'70923','806016930576',0x000000000101000000D85B6F40F06D24405EEE38EA8DC44640,'2014-09-25 22:31:43'),
(315,'543 Bergamo Avenue','','Minas Gerais',215,'59686','103602195112',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:18'),
(316,'746 Joliet Lane','','Kursk',286,'94878','688485191923',0x00000000010100000085949F54FB174240E0DCBAF660DE4940,'2014-09-25 22:32:52'),
(317,'780 Kimberley Way','','Tabuk',515,'17032','824396883951',0x0000000001010000001BD47E6B274942408B53AD8559663C40,'2014-09-25 22:33:00'),
(318,'1774 Yaound Place','','Hubei',166,'91400','613124286867',0x0000000001010000002A00C633E8B15C404C63C5BA027D3E40,'2014-09-25 22:30:33'),
(319,'1957 Yantai Lane','','So Paulo',490,'59255','704948322302',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:22'),
(320,'1542 Lubumbashi Boulevard','','Tel Aviv',57,'62472','508800331065',0x000000000101000000765F84DF3C6041403CAB60AF0B034040,'2014-09-25 22:31:41'),
(321,'651 Pathankot Loop','','Maharashtra',336,'59811','139378397418',0x0000000001010000002198FE8062A952408AC168FBFCD23040,'2014-09-25 22:31:20'),
(322,'1359 Zhoushan Parkway','','Streymoyar',545,'29763','46568045367',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:59'),
(323,'1769 Iwaki Lane','','Kujawsko-Pomorskie',97,'25787','556100547674',0x000000000101000000487B7203F4013240837EF0EBD18F4A40,'2014-09-25 22:32:41'),
(324,'1145 Vilnius Manor','','Mxico',451,'73170','674805712553',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:12'),
(325,'1892 Nabereznyje Telny Lane','','Tutuila',516,'28396','478229987054',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:02'),
(326,'470 Boksburg Street','','Central',81,'97960','908029859266',0x000000000101000000DAE78C83263855405BE21291AB023B40,'2014-09-25 22:32:19'),
(327,'1427 A Corua (La Corua) Place','','Buenos Aires',45,'85799','972574862516',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:04'),
(328,'479 San Felipe del Progreso Avenue','','Morelos',130,'54949','869051782691',0x000000000101000000C87E710484BC58C039FD8F02FACD3240,'2014-09-25 22:32:04'),
(329,'867 Benin City Avenue','','Henan',591,'78543','168884817145',0x000000000101000000A0F2F972B05D5C405D68531AD6144140,'2014-09-25 22:30:50'),
(330,'981 Kumbakonam Place','','Distrito Federal',89,'87611','829116184079',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:17'),
(331,'1016 Iwakuni Street','','St George',269,'49833','961370847344',0x000000000101000000A1DC11A9C49C4EC0D11B936A44512A40,'2014-09-25 22:32:59'),
(332,'663 Baha Blanca Parkway','','Adana',5,'33463','834418779292',0x000000000101000000BE72182719AA4140CCD1E3F736804240,'2014-09-25 22:33:22'),
(333,'1860 Taguig Loop','','West Java',119,'59550','38158430589',0x00000000010100000042ACA34FD0E55A40D698C6E52ED81BC0,'2014-09-25 22:31:32'),
(334,'1816 Bydgoszcz Loop','','Dhaka',234,'64308','965273813662',0x000000000101000000A717C627AE7C564080BD1D3C6EEB3840,'2014-09-25 22:30:12'),
(335,'587 Benguela Manor','','Illinois',42,'91590','165450987037',0x00000000010100000097CEE2207C1456C0DDEFABCD5AE14440,'2014-09-25 22:33:44'),
(336,'430 Kumbakonam Drive','','Santa F',457,'28814','105470691550',0x00000000010100000004C1882249304DC055DF54FF7B4E41C0,'2014-09-25 22:30:07'),
(337,'1838 Tabriz Lane','','Dhaka',143,'1195','38988715447',0x0000000001010000001A5D948F139A5640C4D21B49DDB53740,'2014-09-25 22:30:12'),
(338,'431 Szkesfehrvr Avenue','','Baki',48,'57828','119501405123',0x000000000101000000A77686A92DF248400FAECACF57304440,'2014-09-25 22:30:11'),
(339,'503 Sogamoso Loop','','Sumqayit',505,'49812','834626715837',0x0000000001010000006C83C94395D548402C8EB9217C4B4440,'2014-09-25 22:30:11'),
(340,'507 Smolensk Loop','','Sousse',492,'22971','80303246192',0x000000000101000000298EA8F52346254075DA649EA6E94140,'2014-09-25 22:33:21'),
(341,'1920 Weifang Avenue','','Uttar Pradesh',427,'15643','869507847714',0x0000000001010000001F3EFA70DAC153407410CF6D1DCF3C40,'2014-09-25 22:31:25'),
(342,'124 al-Manama Way','','Hiroshima',382,'52368','647899404952',0x0000000001010000004BE07B244AA760407B0ED18D55354140,'2014-09-25 22:31:52'),
(343,'1443 Mardan Street','','Western Cape',392,'31483','231383037471',0x000000000101000000FB6074D42CF73240B0B03B3833DA40C0,'2014-09-25 22:33:05'),
(344,'1909 Benguela Lane','','Henan',581,'19913','624138001031',0x000000000101000000F4AD6AA480775C4066EB2AEE89A74140,'2014-09-25 22:30:47'),
(345,'68 Ponce Parkway','','Hanoi',201,'85926','870635127812',0x0000000001010000005DF525C0D5755A4000F61B3746063540,'2014-09-25 22:34:06'),
(346,'1217 Konotop Avenue','','Gelderland',151,'504','718917251754',0x000000000101000000F438679F22A2164019B4EB3944044A40,'2014-09-25 22:32:20'),
(347,'1293 Nam Dinh Way','','Roraima',84,'71583','697656479977',0x0000000001010000008EE6C8CA2F564EC0D9C23DE0CB8E0640,'2014-09-25 22:30:17'),
(348,'785 Vaduz Street','','Baja California',335,'36170','895616862749',0x0000000001010000000D61EB0816DD5CC07DB328475C504040,'2014-09-25 22:32:10'),
(349,'1516 Escobar Drive','','Tongatapu',370,'46069','64536069371',0x0000000001010000009132987575E665C0BE11DDB3AE2335C0,'2014-09-25 22:33:20'),
(350,'1628 Nagareyama Lane','','Central',453,'60079','20064292617',0x00000000010100000019A5F04520C14CC029006B7AF55639C0,'2014-09-25 22:32:32'),
(351,'1157 Nyeri Loop','','Adygea',320,'56380','262744791493',0x000000000101000000AC91B8228C0D4440EBD10AC2CB4D4640,'2014-09-25 22:32:55'),
(352,'1673 Tangail Drive','','Daugavpils',137,'26857','627924259271',0x0000000001010000004377A45588883A40E580B80611F14B40,'2014-09-25 22:31:57'),
(353,'381 Kabul Way','','Taipei',209,'87272','55477302294',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:15'),
(354,'953 Hodeida Street','','Southern Tagalog',221,'18841','53912826864',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:37'),
(355,'469 Nakhon Sawan Street','','Tuvassia',531,'58866','689199636560',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:58'),
(356,'1378 Beira Loop','','Krasnojarsk',597,'40792','840957664136',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:58'),
(357,'1641 Changhwa Place','','Nord-Ouest',52,'37636','256546485220',0x000000000101000000103B53E8BC4A2440A4C0A7DEBFD61740,'2014-09-25 22:30:25'),
(358,'1698 Southport Loop','','Hidalgo',393,'49009','754358349853',0x0000000001010000007AB82E46EEAE58C03DED951EF21D3440,'2014-09-25 22:32:11'),
(359,'519 Nyeri Manor','','So Paulo',461,'37650','764680915323',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:21'),
(360,'619 Hunuco Avenue','','Shimane',331,'81508','142596392389',0x000000000101000000A09ADC399EA160405B1D4AFE71BC4140,'2014-09-25 22:31:50'),
(361,'45 Aparecida de Goinia Place','','Madhya Pradesh',464,'7431','650496654258',0x0000000001010000009E0CE94BCA345440C9FDB38B0E953840,'2014-09-25 22:31:26'),
(362,'482 Kowloon and New Kowloon Manor','','Bratislava',90,'97056','738968474939',0x00000000010100000070DC18F1531B3140BDB90908F7124840,'2014-09-25 22:33:02'),
(363,'604 Bern Place','','Jharkhand',429,'5373','620719383725',0x000000000101000000799F9916AB55554037CC86EB07593740,'2014-09-25 22:31:25'),
(364,'1623 Kingstown Drive','','Buenos Aires',20,'91299','296394569728',0x000000000101000000791563AAAA2A4DC0E4839ECDAA6A41C0,'2014-09-25 22:30:04'),
(365,'1009 Zanzibar Lane','','Arecibo',32,'64875','102396298916',0x000000000101000000FBBD5EABCEAD50C0E9787187F2783240,'2014-09-25 22:32:45'),
(366,'114 Jalib al-Shuyukh Manor','','Centre',585,'60440','845378657301',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:25'),
(367,'1163 London Parkway','','Par',66,'6066','675120358494',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:16'),
(368,'1658 Jastrzebie-Zdrj Loop','','Central',372,'96584','568367775448',0x0000000001010000002B73A900CEEF4240660811BA956FB9BF,'2014-09-25 22:31:56'),
(369,'817 Laredo Avenue','','Jalisco',188,'77449','151249681135',0x000000000101000000F00BF9B113D959C03E4EE2BDB4AA3440,'2014-09-25 22:32:06'),
(370,'1565 Tangail Manor','','Okinawa',377,'45750','634445428822',0x000000000101000000D94C744CCCAA5F4045A1C096B2C53940,'2014-09-25 22:31:52'),
(371,'1912 Emeishan Drive','','Balikesir',50,'33050','99883471275',0x000000000101000000F1074D5CD8E23B400B2A053818D34340,'2014-09-25 22:33:22'),
(372,'230 Urawa Drive','','Andhra Pradesh',8,'2738','166898395731',0x0000000001010000008B04AE869F515340B2930BDF0C402F40,'2014-09-25 22:31:09'),
(373,'1922 Miraj Way','','Esfahan',356,'13203','320471479776',0x00000000010100000017050B71F6AE494026231DD434514040,'2014-09-25 22:31:37'),
(374,'433 Florencia Street','','Chihuahua',250,'91330','561729882725',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:08'),
(375,'1049 Matamoros Parkway','','Karnataka',191,'69640','960505250340',0x0000000001010000007923F3C89F355340386744696F563140,'2014-09-25 22:31:16'),
(376,'1061 Ede Avenue','','Southern Tagalog',98,'57810','333390595558',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:35'),
(377,'154 Oshawa Manor','','East Java',415,'72771','440365973660',0x00000000010100000005B93077D24D5C4065074B2B74041FC0,'2014-09-25 22:31:34'),
(378,'1191 Tandil Drive','','Southern Tagalog',523,'6362','45554316010',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:40'),
(379,'1133 Rizhao Avenue','','Pernambuco',572,'2800','600264533987',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:23'),
(380,'1519 Santiago de los Caballeros Loop','','East Kasai',348,'22025','409315295763',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:53'),
(381,'1618 Olomouc Manor','','Kurgan',285,'26385','96846695220',0x000000000101000000B1694A5755555040EA8FD552E5B94B40,'2014-09-25 22:32:51'),
(382,'220 Hidalgo Drive','','Kermanshah',265,'45298','342720754566',0x0000000001010000004E7A843F6888474008605EDB36284140,'2014-09-25 22:31:37'),
(383,'686 Donostia-San Sebastin Lane','','Guangdong',471,'97390','71857599858',0x000000000101000000F90A1C1A60845C400FDB711EA98B3640,'2014-09-25 22:30:42'),
(384,'97 Mogiljov Lane','','Gujarat',73,'89294','924815207181',0x000000000101000000B4F116FEC209524097DB076A42C63540,'2014-09-25 22:31:11'),
(385,'1642 Charlotte Amalie Drive','','Slaskie',549,'75442','821476736117',0x000000000101000000DDC4DA2967F73240D5D6E3198F114940,'2014-09-25 22:32:44'),
(386,'1368 Maracabo Boulevard','','',493,'32716','934352415130',0x000000000101000000731074B4AA8A4FC050920953EF2E3240,'2014-09-25 22:30:03'),
(387,'401 Sucre Boulevard','','New Hampshire',322,'25007','486395999608',0x000000000101000000817FA54E1BDD51C013718456717F4540,'2014-09-25 22:33:56'),
(388,'368 Hunuco Boulevard','','Namibe',360,'17165','106439158941',0x000000000101000000B5858CECEF4D28404D8EF11769642EC0,'2014-09-25 22:30:03'),
(389,'500 Lincoln Parkway','','Jiangsu',210,'95509','550306965159',0x0000000001010000003C399E2A3AC15D404409449957CB4040,'2014-09-25 22:30:35'),
(390,'102 Chapra Drive','','Ibaragi',521,'14073','776031833752',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:54'),
(391,'1793 Meixian Place','','Hmelnytskyi',258,'33535','619966287415',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:31'),
(392,'514 Ife Way','','Shaba',315,'69973','900235712074',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:53'),
(393,'717 Changzhou Lane','','Southern Tagalog',104,'21615','426255288071',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:36'),
(394,'753 Ilorin Avenue','','Sichuan',157,'3656','464511145118',0x0000000001010000008531D8C3CDD8594059D70D805D883D40,'2014-09-25 22:30:32'),
(395,'1337 Mit Ghamr Avenue','','Nakhon Sawan',358,'29810','175283210378',0x0000000001010000009A588572C70859404D237722D2682F40,'2014-09-25 22:33:19'),
(396,'767 Pyongyang Drive','','Osaka',229,'83536','667736124769',0x000000000101000000149A7F4FC7EA6040A02413A6DE2F4140,'2014-09-25 22:31:48'),
(397,'614 Pak Kret Street','','Addis Abeba',6,'27796','47808359842',0x0000000001010000009F84E3439A5F43402233BCFEC90C2240,'2014-09-25 22:30:59'),
(398,'954 Lapu-Lapu Way','','Moskova',278,'8816','737229003916',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:51'),
(399,'331 Bydgoszcz Parkway','','Asturia',181,'966','537374465982',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:09'),
(400,'1152 Citrus Heights Manor','','al-Qadarif',15,'5239','765957414528',0x00000000010100000084F6459D14B14140AA36EE83E2112C40,'2014-09-25 22:33:11'),
(401,'168 Cianjur Manor','','Saitama',228,'73824','679095087143',0x000000000101000000DEA925C2EB75614032005471E3F94140,'2014-09-25 22:31:48'),
(402,'616 Hagonoy Avenue','','Krasnojarsk',39,'46043','604177838256',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:47'),
(403,'1190 0 Place','','Rio Grande do Sul',44,'10417','841876514789',0x0000000001010000002347DF49B00D4BC086151340D6543FC0,'2014-09-25 22:30:16'),
(404,'734 Bchar Place','','Punjab',375,'30586','280578750435',0x0000000001010000006D3B6D8D885C5240C4A40925DDCE3E40,'2014-09-25 22:32:31'),
(405,'530 Lausanne Lane','','Texas',135,'11067','775235029633',0x0000000001010000009C830C89A03358C0E2D3F7753B644040,'2014-09-25 22:33:49'),
(406,'454 Patiala Lane','','Fukushima',276,'13496','794553031307',0x000000000101000000EC3D4B46448C614091306711E5BB4240,'2014-09-25 22:31:49'),
(407,'1346 Mysore Drive','','Bretagne',92,'61507','516647474029',0x0000000001010000004474BE8EEEEE11C070010DDBBB3F4840,'2014-09-25 22:31:00'),
(408,'990 Etawah Loop','','Tamil Nadu',564,'79940','206169448769',0x000000000101000000D54B42D8DF3C5340FE518A0C61A72440,'2014-09-25 22:31:29'),
(409,'1266 Laredo Parkway','','Saitama',380,'7664','1483365694',0x000000000101000000FBD97EE8F87361403BA5283C0DF44140,'2014-09-25 22:31:52'),
(410,'88 Nagaon Manor','','Buenos Aires',524,'86868','779461480495',0x000000000101000000CA3736960B914DC0D78A91802CA942C0,'2014-09-25 22:30:07'),
(411,'264 Bhimavaram Manor','','St Thomas',111,'54749','302526949177',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:34:08'),
(412,'1639 Saarbrcken Drive','','North West',437,'9827','328494873422',0x00000000010100000015CB8866F93D3B40E48AE65CE5AA39C0,'2014-09-25 22:33:05'),
(413,'692 Amroha Drive','','Northern',230,'35575','359478883004',0x00000000010100000027648CB47900544098E777503F562340,'2014-09-25 22:33:10'),
(414,'1936 Lapu-Lapu Parkway','','Bauchi & Gombe',141,'7122','653436985797',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:23'),
(415,'432 Garden Grove Street','','Ontario',430,'65630','615964523510',0x0000000001010000003E867DF1FBDB53C05900AEBF80EF4540,'2014-09-25 22:30:28'),
(416,'1445 Carmen Parkway','','West Java',117,'70809','598912394463',0x000000000101000000957950F550C55A40B3BFA21122171BC0,'2014-09-25 22:31:30'),
(417,'791 Salinas Street','','Punjab',208,'40509','129953030512',0x000000000101000000579E9B911CFA524075D256804A883F40,'2014-09-25 22:31:17'),
(418,'126 Acua Parkway','','West Bengali',71,'58888','480039662421',0x000000000101000000C3013E89191056404E9F7829D01A3840,'2014-09-25 22:31:11'),
(419,'397 Sunnyvale Avenue','','Guanajuato',19,'55566','680851640676',0x000000000101000000754419059C2F59C02409C21550EA3440,'2014-09-25 22:32:01'),
(420,'992 Klerksdorp Loop','','Utrecht',23,'33711','855290087237',0x000000000101000000C1DFD4ACD88C15404FDC3BB4D9134A40,'2014-09-25 22:32:19'),
(421,'966 Arecibo Loop','','Sind',134,'94018','15273765306',0x000000000101000000BE9B1320AFF15040D93400659DBB3A40,'2014-09-25 22:32:30'),
(422,'289 Santo Andr Manor','','al-Sharqiya',16,'72410','214976066017',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:59'),
(423,'437 Chungho Drive','','Puerto Plata',450,'59489','491271355190',0x000000000101000000225A86930FAC51C0082692431FCB3340,'2014-09-25 22:30:55'),
(424,'1948 Bayugan Parkway','','Bihar',264,'60622','987306329957',0x0000000001010000007613211A82E45540D685C4E2DC893940,'2014-09-25 22:31:19'),
(425,'1866 al-Qatif Avenue','','California',155,'89420','546793516940',0x000000000101000000B4EE7AC4C3815DC0165D28AAC8084140,'2014-09-25 22:33:50'),
(426,'1661 Abha Drive','','Tamil Nadu',416,'14400','270456873752',0x000000000101000000D3B36A2192B45340FBC5111038C32440,'2014-09-25 22:31:23'),
(427,'1557 Cape Coral Parkway','','Hubei',293,'46875','368284120423',0x00000000010100000034CC1A06BDEA5B402D5A25FD62314040,'2014-09-25 22:30:38'),
(428,'1727 Matamoros Place','','Sawhaj',465,'78813','129673677866',0x00000000010100000083E38D27DDB13F40555BA093948E3A40,'2014-09-25 22:30:57'),
(429,'1269 Botosani Manor','','Guangdong',468,'47394','736517327853',0x000000000101000000C8E1DDDB3ED65C40281B20E230C83640,'2014-09-25 22:30:42'),
(430,'355 Vitria de Santo Anto Way','','Oaxaca',452,'81758','548003849552',0x0000000001010000000363D8BC050858C0503750E09D163240,'2014-09-25 22:32:13'),
(431,'1596 Acua Parkway','','Jharkhand',418,'70425','157133457169',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:24'),
(432,'259 Ipoh Drive','','So Paulo',189,'64964','419009857119',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:18'),
(433,'1823 Hoshiarpur Lane','','Komi',510,'33191','307133768620',0x000000000101000000C6DA8420AC674940DD9ACF1495D64E40,'2014-09-25 22:32:57'),
(434,'1404 Taguig Drive','','Okayama',547,'87212','572068624538',0x000000000101000000205D11A1F6BF6040BFE90203AD864140,'2014-09-25 22:31:54'),
(435,'740 Udaipur Lane','','Nizni Novgorod',150,'33505','497288595103',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:47'),
(436,'287 Cuautla Boulevard','','Chuquisaca',501,'72736','82619513349',0x0000000001010000002A0B15D2D05050C049C44ABB870833C0,'2014-09-25 22:30:14'),
(437,'1766 Almirante Brown Street','','KwaZulu-Natal',364,'63104','617567598243',0x000000000101000000FDAB7DF090EE3D40488D64EA09C23BC0,'2014-09-25 22:33:04'),
(438,'596 Huixquilucan Place','','Nampula',351,'65892','342709348083',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:17'),
(439,'1351 Aparecida de Goinia Parkway','','Northern Mindanao',391,'41775','959834530529',0x000000000101000000DAFF006B55F55E40898C58D5DC4F2040,'2014-09-25 22:32:38'),
(440,'722 Bradford Lane','','Shandong',249,'90920','746251338300',0x000000000101000000653E7B890CB55D4078A0A932E7954140,'2014-09-25 22:30:37'),
(441,'983 Santa F Way','','British Colombia',565,'47472','145720452260',0x000000000101000000719CCA58A3C75EC0EEE7B92AF59F4840,'2014-09-25 22:30:28'),
(442,'1245 Ibirit Way','','La Romana',290,'40926','331888642162',0x0000000001010000006D59BE2E433E51C04FC87322666D3240,'2014-09-25 22:30:54'),
(443,'1836 Korla Parkway','','Copperbelt',272,'55405','689681677428',0x000000000101000000064257C796363C40BB7EC16ED89A29C0,'2014-09-25 22:34:11'),
(444,'231 Kaliningrad Place','','Lombardia',70,'57833','575081026569',0x0000000001010000007A185A9D9C552340A77E390E17D94640,'2014-09-25 22:31:42'),
(445,'495 Bhimavaram Lane','','Maharashtra',144,'3','82088937724',0x0000000001010000003EE1911DC0B15240B39943520BE73440,'2014-09-25 22:31:15'),
(446,'1924 Shimonoseki Drive','','Batna',59,'52625','406784385440',0x000000000101000000347CB03154B21840DF814B112AC74140,'2014-09-25 22:29:59'),
(447,'105 Dzerzinsk Manor','','Inner Mongolia',540,'48570','240776414296',0x000000000101000000F1C05B7BFA905E40F5EC03DA67CE4540,'2014-09-25 22:30:44'),
(448,'614 Denizli Parkway','','Rio Grande do Sul',486,'29444','876491807547',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:22'),
(449,'1289 Belm Boulevard','','Tartumaa',530,'88306','237368926031',0x00000000010100000079680EFF9FB93A406C7E575FB8304D40,'2014-09-25 22:30:58'),
(450,'203 Tambaram Street','','Buenos Aires',161,'73942','411549550611',0x000000000101000000E753C72AA5604DC0438CD7BCAA2A41C0,'2014-09-25 22:30:05'),
(451,'1704 Tambaram Manor','','West Bengali',554,'2834','39463554936',0x000000000101000000A4E9A2D755065640F598EDAFC3793640,'2014-09-25 22:31:28'),
(452,'207 Cuernavaca Loop','','Tatarstan',352,'52671','782900030287',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:55'),
(453,'319 Springs Loop','','Baijeri',160,'99552','72524459905',0x0000000001010000006A62CB3C0304264081FEE7D5A5CB4840,'2014-09-25 22:31:05'),
(454,'956 Nam Dinh Manor','','Kerman',481,'21872','474047727727',0x000000000101000000F16206CF29D74B40CFA91A738D733D40,'2014-09-25 22:31:39'),
(455,'1947 Paarl Way','','Central Java',509,'23636','834061016202',0x000000000101000000C4D78D2D3AB55B40AC996B8775391EC0,'2014-09-25 22:31:35'),
(456,'814 Simferopol Loop','','Sinaloa',154,'48745','524567129902',0x000000000101000000954330B3F42F5BC090CCD9F115313A40,'2014-09-25 22:32:05'),
(457,'535 Ahmadnagar Manor','','Abu Dhabi',3,'41136','985109775584',0x000000000101000000D3E6EE29EF2E4B4099C6E52E78773840,'2014-09-25 22:33:34'),
(458,'138 Caracas Boulevard','','Zulia',326,'16790','974433019532',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:34:04'),
(459,'251 Florencia Drive','','Michoacn de Ocampo',556,'16119','118011831565',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:13'),
(460,'659 Gatineau Boulevard','','La Paz',153,'28587','205524798287',0x00000000010100000017E7B9CFBB0B51C0A029858ABB7B30C0,'2014-09-25 22:30:13'),
(461,'1889 Valparai Way','','Ziguinchor',600,'75559','670370974122',0x00000000010100000020E1C50C9E4530C0FC219111AB2A2940,'2014-09-25 22:33:01'),
(462,'1485 Bratislava Place','','Illinois',435,'83183','924663855568',0x000000000101000000A081A2C30D4656C04453D1B3B4224540,'2014-09-25 22:33:59'),
(463,'935 Aden Boulevard','','Central Java',532,'64709','335052544020',0x000000000101000000C7139C55FA485B40BEE435655D7A1BC0,'2014-09-25 22:31:35'),
(464,'76 Kermanshah Manor','','Esfahan',423,'23343','762361821578',0x000000000101000000FF66182DF6EE4940A60BB1FA23014040,'2014-09-25 22:31:37'),
(465,'734 Tanshui Avenue','','Caquet',170,'70664','366776723320',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:52'),
(466,'118 Jaffna Loop','','Northern Mindanao',182,'10447','325526730021',0x00000000010100000028B27B9777475F40BAEA4B80ABAA2140,'2014-09-25 22:32:36'),
(467,'1621 Tongliao Avenue','','Irkutsk',558,'22173','209342540247',0x000000000101000000C7269E584CE95940E56A1ACA3F604A40,'2014-09-25 22:32:58'),
(468,'1844 Usak Avenue','','Nova Scotia',196,'84461','164414772677',0x0000000001010000004205871744C94FC0162B0F779A524640,'2014-09-25 22:30:27'),
(469,'1872 Toulon Loop','','OHiggins',428,'7939','928809465153',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:30'),
(470,'1088 Ibirit Place','','Jalisco',595,'88502','49084281333',0x0000000001010000007820578FA0D859C06AE514D33BB93440,'2014-09-25 22:32:15'),
(471,'1322 Mosul Parkway','','Shandong',145,'95400','268053970382',0x0000000001010000002856574F779F5D402425E2523ABB4240,'2014-09-25 22:30:32'),
(472,'1447 Chatsworth Place','','Chihuahua',129,'41545','769370126331',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:04'),
(473,'1257 Guadalajara Street','','Karnataka',78,'33599','195337700615',0x000000000101000000052049A4C8ED5240E702F2800DD33040,'2014-09-25 22:31:14'),
(474,'1469 Plock Lane','','Galicia',388,'95835','622884741180',0x000000000101000000FB44F9DDCF741FC0ED9A90D6182B4540,'2014-09-25 22:33:09'),
(475,'434 Ourense (Orense) Manor','','Hodeida',206,'14122','562370137426',0x000000000101000000F56FF2B62D7A4540DF80E03B7B982D40,'2014-09-25 22:34:10'),
(476,'270 Tambaram Parkway','','Gauteng',244,'9668','248446668735',0x0000000001010000005B5540EB2B0B3C4082412D61C8333AC0,'2014-09-25 22:33:03'),
(477,'1786 Salinas Place','','Nam Ha',359,'66546','206060652238',0x00000000010100000044BD851A2A7E5A40C2DB8310908D3440,'2014-09-25 22:34:07'),
(478,'1078 Stara Zagora Drive','','Aceh',301,'69221','932992626595',0x00000000010100000034057CC8A5495840D2C9ADA470B81440,'2014-09-25 22:31:33'),
(479,'1854 Okara Boulevard','','Drenthe',158,'42123','131912793873',0x0000000001010000006E8AC745B5A01B40947BCBE6BB634A40,'2014-09-25 22:32:21'),
(480,'421 Yaound Street','','Sumy',385,'11363','726875628268',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:33'),
(481,'1153 Allende Way','','Qubec',179,'20336','856872225376',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:26'),
(482,'808 Naala-Porto Parkway','','England',500,'41060','553452430707',0x0000000001010000000E6036A6CC4201C0B9D7930A74B44A40,'2014-09-25 22:33:41'),
(483,'632 Usolje-Sibirskoje Parkway','','Ha Darom',36,'73085','667648979883',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:41'),
(484,'98 Pyongyang Boulevard','','Ohio',11,'88749','191958435142',0x0000000001010000008AB1A778376154C0990524AB6C8A4440,'2014-09-25 22:33:42'),
(485,'984 Novoterkassk Loop','','Gaziantep',180,'28165','435118527255',0x000000000101000000CAAF7A1BF6B04240AA8889BC9B874240,'2014-09-25 22:33:25'),
(486,'64 Korla Street','','Mwanza',347,'25145','510383179153',0x0000000001010000002A28FB9DDC7B40402EBB719C252204C0,'2014-09-25 22:33:17'),
(487,'1785 So Bernardo do Campo Street','','Veracruz',125,'71182','684529463244',0x000000000101000000A1551CBD509C57C0141F44D72A223240,'2014-09-25 22:32:04'),
(488,'698 Jelets Boulevard','','Denizli',142,'2596','975185523021',0x000000000101000000EECD6F9868163D40B226BB3E18E34240,'2014-09-25 22:33:24'),
(489,'1297 Alvorada Parkway','','Ningxia',587,'11839','508348602835',0x0000000001010000001583D1F679915A4029876066E93B4340,'2014-09-25 22:30:49'),
(490,'1909 Dayton Avenue','','Guangdong',469,'88513','702955450528',0x0000000001010000007BE0BE6955655C405457998466E43840,'2014-09-25 22:30:42'),
(491,'1789 Saint-Denis Parkway','','Coahuila de Zaragoza',4,'8268','936806643983',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:01'),
(492,'185 Mannheim Lane','','Stavropol',408,'23661','589377568313',0x000000000101000000333E82D19B87454024592CEA38064640,'2014-09-25 22:32:56'),
(493,'184 Mandaluyong Street','','Baja California Sur',288,'94239','488425406814',0x000000000101000000173B2BB3D2935BC078F6F0C05B233840,'2014-09-25 22:32:09'),
(494,'591 Sungai Petani Drive','','Okayama',376,'46400','37247325001',0x0000000001010000001966B2C9EBBD60404CC054D8B1544140,'2014-09-25 22:31:51'),
(495,'656 Matamoros Drive','','Boyac',487,'19489','17305839123',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:53'),
(496,'775 ostka Drive','','al-Daqahliya',337,'22358','171973024401',0x000000000101000000FC4DCD8A4D423F403EDF60B9EFB63E40,'2014-09-25 22:30:57'),
(497,'1013 Tabuk Boulevard','','West Bengali',261,'96203','158399646978',0x0000000001010000005D1B857F6C1B5640793BC269C1F53640,'2014-09-25 22:31:19'),
(498,'319 Plock Parkway','','Istanbul',504,'26101','854259976812',0x000000000101000000B6EFF6C54A453D40277E3100F97A4440,'2014-09-25 22:33:28'),
(499,'1954 Kowloon and New Kowloon Way','','Chimborazo',434,'63667','898559280434',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:56'),
(500,'362 Rajkot Lane','','Gansu',47,'98030','962020153680',0x0000000001010000004F6FEB13E50A5A4028733D1B03464240,'2014-09-25 22:30:31'),
(501,'1060 Tandil Lane','','Shandong',432,'72349','211256301880',0x000000000101000000CAB61D6423DD5D40ADF1E379BAB64140,'2014-09-25 22:30:41'),
(502,'1515 Korla Way','','England',589,'57197','959467760895',0x0000000001010000004C42D8DFC852F1BFBA826DC493FA4A40,'2014-09-25 22:33:42'),
(503,'1416 San Juan Bautista Tuxtepec Avenue','','Zufar',444,'50592','144206758053',0x000000000101000000A6684018D30B4B40078662E1DA033140,'2014-09-25 22:32:29'),
(504,'1 Valle de Santiago Avenue','','Apulia',93,'86208','465897838272',0x000000000101000000CAFED4D3A2EF3140584D7C5AEA504440,'2014-09-25 22:31:43'),
(505,'519 Brescia Parkway','','East Java',318,'69504','793996678771',0x000000000101000000A3C794B487E15B400A230736F8841EC0,'2014-09-25 22:31:33'),
(506,'414 Mandaluyong Street','','Lubelskie',314,'16370','52709222667',0x0000000001010000000FE6C0BC1191364020F0C000C2A04940,'2014-09-25 22:32:43'),
(507,'1197 Sokoto Boulevard','','West Bengali',478,'87687','868602816371',0x000000000101000000109546CC6C1B56408F0FC4C3C5B53A40,'2014-09-25 22:31:27'),
(508,'496 Celaya Drive','','Nagano',552,'90797','759586584889',0x000000000101000000254E3805034961402486D3388A334240,'2014-09-25 22:31:54'),
(509,'786 Matsue Way','','Illinois',245,'37469','111177206479',0x0000000001010000000F3B9D75570556C0FA91C77839C34440,'2014-09-25 22:33:54'),
(510,'48 Maracabo Place','','Central Luzon',519,'1570','82671830126',0x000000000101000000223999B8D53A5E408D87AD8F3D2D2F40,'2014-09-25 22:32:39'),
(511,'1152 al-Qatif Lane','','Kalimantan Barat',412,'44816','131370665218',0x000000000101000000107FA88F9B545B4021037976F9D69FBF,'2014-09-25 22:31:34'),
(512,'1269 Ipoh Avenue','','Eskisehir',163,'54674','402630109080',0x000000000101000000E9D32AFA43853E40767D303A6AE34340,'2014-09-25 22:33:24'),
(513,'758 Korolev Parkway','','Andhra Pradesh',568,'75474','441628280920',0x00000000010100000031DA99F859285440AF528BD2EF843040,'2014-09-25 22:31:29'),
(514,'1747 Rustenburg Place','','Bihar',110,'51369','442673923363',0x0000000001010000000BFD5DE9C62E554041C4BC7D0CC83940,'2014-09-25 22:31:14'),
(515,'886 Tonghae Place','','Volgograd',259,'19450','711928348157',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:50'),
(516,'1574 Goinia Boulevard','','Heilongjiang',502,'39529','59634255214',0x00000000010100000017128B73AFBF5F40C5ECC094DC514740,'2014-09-25 22:30:43'),
(517,'548 Uruapan Street','','Ontario',312,'35653','879347453467',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:38'),
(519,'962 Tama Loop','','',583,'65952','282667506728',0x000000000101000000FA545FA722DD6440AA7A9EE4B321E1BF,'2014-09-25 22:32:19'),
(520,'1778 Gijn Manor','','Hubei',594,'35156','288910576761',0x000000000101000000E358727044305C40A58A3D0F49104040,'2014-09-25 22:30:50'),
(521,'568 Dhule (Dhulia) Loop','','Coquimbo',127,'92568','602101369463',0x0000000001010000000000804A296FC5C1DDA85F330AC13EC0,'2014-09-25 22:30:30'),
(522,'1768 Udine Loop','','Battambang',60,'32347','448876499197',0x000000000101000000708802C7AFCC59402ABC15D396342A40,'2014-09-25 22:30:24'),
(523,'608 Birgunj Parkway','','Taipei',116,'400','627425618482',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:14'),
(524,'680 A Corua (La Corua) Manor','','Sivas',482,'49806','158326114853',0x000000000101000000936EF02A10824240F2F6D676C9DF4340,'2014-09-25 22:33:28'),
(525,'1949 Sanya Street','','Gumma',224,'61244','132100972047',0x000000000101000000943F29A406696140E4CA8FAE88284240,'2014-09-25 22:31:47'),
(526,'617 Klerksdorp Place','','Khanh Hoa',366,'94707','574973479129',0x0000000001010000004A1751C96F4C5B4032F504D37A7D2840,'2014-09-25 22:34:07'),
(527,'1993 0 Loop','','Liaoning',588,'41214','25865528181',0x000000000101000000B65E1D119D8E5E40171A3ED818554440,'2014-09-25 22:30:49'),
(528,'1176 Southend-on-Sea Manor','','Southern Tagalog',458,'81651','236679267178',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:39'),
(529,'600 Purnea (Purnia) Avenue','','Nghe An',571,'18043','638409958875',0x000000000101000000962364204F6C5A407A6D365662AC3240,'2014-09-25 22:34:07'),
(530,'1003 Qinhuangdao Street','','West Java',419,'25972','35533115997',0x0000000001010000005EA516A55FDC5A40A21639FA4E3A1AC0,'2014-09-25 22:31:35'),
(531,'1986 Sivas Place','','Friuli-Venezia Giuli',551,'95775','182059202712',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:44'),
(532,'1427 Tabuk Place','','Florida',101,'31342','214756839122',0x0000000001010000003C702942C57C54C02A5D555117903A40,'2014-09-25 22:33:47'),
(533,'556 Asuncin Way','','Mogiljov',339,'35364','338244023543',0x0000000001010000006B6DD04D51583E40673513C259F54A40,'2014-09-25 22:30:13'),
(534,'486 Ondo Parkway','','Benguela',67,'35202','105882218332',0x000000000101000000BD83E9C59ACF2A40B9FA56900B2729C0,'2014-09-25 22:30:02'),
(535,'635 Brest Manor','','Andhra Pradesh',75,'40899','80593242951',0x00000000010100000079FA52897C615440D2C9ADA4708A3040,'2014-09-25 22:31:13'),
(536,'166 Jinchang Street','','Buenos Aires',165,'86760','717566026669',0x0000000001010000003EB896242A434DC0E0771DBB556D41C0,'2014-09-25 22:30:05'),
(537,'958 Sagamihara Lane','','Mie',287,'88408','427274926505',0x000000000101000000BED29E37BA1761409B5F837467884140,'2014-09-25 22:31:50'),
(538,'1817 Livorno Way','','Khanh Hoa',100,'79401','478380208348',0x000000000101000000944A78422F4A5B40236D3E09C7D72740,'2014-09-25 22:34:05'),
(539,'1332 Gaziantep Lane','','Shandong',80,'22813','383353187467',0x000000000101000000BC2F1D2911815D4074B0A316EFAE4240,'2014-09-25 22:30:31'),
(540,'949 Allende Lane','','Uttar Pradesh',24,'67521','122981120653',0x0000000001010000008C91DBE5119E534039A8B34934E73C40,'2014-09-25 22:31:11'),
(541,'195 Ilorin Street','','Chari-Baguirmi',363,'49250','8912935608',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:29'),
(542,'193 Bhusawal Place','','Kang-won',539,'9750','745267607502',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:07'),
(543,'43 Vilnius Manor','','Colorado',42,'79814','484500282381',0x0000000001010000009389004C3E355AC0D03582435EDD4340,'2014-09-25 22:33:44'),
(544,'183 Haiphong Street','','Jilin',46,'69953','488600270038',0x000000000101000000AFA3607C87B45E4038A85890C1CD4640,'2014-09-25 22:30:30'),
(545,'163 Augusta-Richmond County Loop','','Carabobo',561,'33030','754579047924',0x000000000101000000CC0C1B657D0051C06B7F677BF4522440,'2014-09-25 22:34:05'),
(546,'191 Jos Azueta Parkway','','Ruse',436,'13629','932156667696',0x00000000010100000067A9ABF188F83940CD6CA1759EED4540,'2014-09-25 22:30:23'),
(547,'379 Lublin Parkway','','Toscana',309,'74568','921960450089',0x00000000010100000090920D5AFEA62440CC13BEADAAC54540,'2014-09-25 22:31:44'),
(548,'1658 Cuman Loop','','Sumatera Selatan',396,'51309','784907335610',0x00000000010100000018D75306E9885A40E8209EDB3A4E01C0,'2014-09-25 22:31:34'),
(549,'454 Qinhuangdao Drive','','Tadla-Azilal',68,'25866','786270036240',0x000000000101000000419479F53B6619C04F09E3022B2B4040,'2014-09-25 22:32:16'),
(550,'1715 Okayama Street','','So Paulo',485,'55676','169352919175',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:22'),
(551,'182 Nukualofa Drive','','Sumy',275,'15414','426346224043',0x00000000010100000079F71109F099404055BBCBEAC29E4940,'2014-09-25 22:33:32'),
(552,'390 Wroclaw Way','','Hainan',462,'5753','357593328658',0x000000000101000000F70FD88B57605B40364E5480393E3240,'2014-09-25 22:30:41'),
(553,'1421 Quilmes Lane','','Ishikawa',260,'19151','135407755975',0x0000000001010000008F9F32A30414614053AEF02E174C4240,'2014-09-25 22:31:49'),
(554,'947 Trshavn Place','','Central Luzon',528,'841','50898428626',0x000000000101000000C56DD9C644265E4002B5BD82D9F52E40,'2014-09-25 22:32:40'),
(555,'1764 Jalib al-Shuyukh Parkway','','Galicia',459,'77642','84794532510',0x00000000010100000090FFB8B3651721C09DB23FF5B4704540,'2014-09-25 22:33:10'),
(556,'346 Cam Ranh Avenue','','Zhejiang',599,'39976','978430786151',0x000000000101000000A0E63FFF188D5E4056DBA8A9C0023E40,'2014-09-25 22:30:51'),
(557,'1407 Pachuca de Soto Place','','Rio Grande do Sul',21,'26284','380077794770',0x000000000101000000A3CEDC43C28449C0608209922DFD3DC0,'2014-09-25 22:30:14'),
(558,'904 Clarksville Drive','','Zhejiang',193,'52234','955349440539',0x000000000101000000E5886B6BFA2A5E4038E04E7D7B7A3E40,'2014-09-25 22:30:34'),
(559,'1917 Kumbakonam Parkway','','Vojvodina',368,'11892','698182547686',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:34:11'),
(560,'1447 Imus Place','','Gujarat',426,'12905','62127829280',0x000000000101000000667F4523C4B25140819C8B1AA74A3640,'2014-09-25 22:31:25'),
(561,'1497 Fengshan Drive','','KwaZulu-Natal',112,'63022','368738360376',0x000000000101000000938FDD054AE43E402AF97DA42DEB3DC0,'2014-09-25 22:33:03'),
(562,'869 Shikarpur Way','','England',496,'57380','590764256785',0x000000000101000000894FF003460D08C0828472ECEAD24A40,'2014-09-25 22:33:40'),
(563,'1059 Yuncheng Avenue','','Vilna',570,'47498','107092893983',0x00000000010100000046B82462A5473940BA0ACE8536584B40,'2014-09-25 22:31:58'),
(564,'505 Madiun Boulevard','','Dolnoslaskie',577,'97271','970638808606',0x000000000101000000F0D46D9A8808314023A93B05AF914940,'2014-09-25 22:32:44'),
(565,'1741 Hoshiarpur Boulevard','','al-Sharqiya',79,'22372','855066328617',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:30:56'),
(566,'1229 Varanasi (Benares) Manor','','Buenos Aires',43,'40195','817740355461',0x00000000010100000014DA28A1AA2A4DC02E156580555541C0,'2014-09-25 22:30:04'),
(567,'1894 Boa Vista Way','','Texas',178,'77464','239357986667',0x000000000101000000C1D1448EE32858C0AD8D0CCDD0744040,'2014-09-25 22:33:51'),
(568,'1342 Sharja Way','','Sokoto & Kebbi & Zam',488,'93655','946114054231',0x0000000001010000005B087250C2F41440E711ED74311F2A40,'2014-09-25 22:32:27'),
(569,'1342 Abha Boulevard','','Bukarest',95,'10714','997453607116',0x000000000101000000924FD9FA331B3A40B1CBA61254374640,'2014-09-25 22:32:46'),
(570,'415 Pune Avenue','','Shandong',580,'44274','203202500108',0x000000000101000000CC3857DE1F705D408F26CDD545F34140,'2014-09-25 22:30:47'),
(571,'1746 Faaa Way','','Huanuco',214,'32515','863080561151',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:33'),
(572,'539 Hami Way','','Tokat',538,'52196','525518075499',0x0000000001010000006F302F1BF8464240AD7B759F2D284440,'2014-09-25 22:33:29'),
(573,'1407 Surakarta Manor','','Moskova',466,'33224','324346485054',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:56'),
(574,'502 Mandi Bahauddin Parkway','','Anzotegui',55,'15992','618156722572',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:34:03'),
(575,'1052 Pathankot Avenue','','Sichuan',299,'77397','128499386727',0x000000000101000000AA054026E3F05940CCC12275F18F3D40,'2014-09-25 22:30:39'),
(576,'1351 Sousse Lane','','Coahuila de Zaragoza',341,'37815','203804046132',0x0000000001010000006AB86D84EA5A59C027AA12C028E83A40,'2014-09-25 22:32:10'),
(577,'1501 Pangkal Pinang Avenue','','Mazowieckie',409,'943','770864062795',0x0000000001010000001646C4DED5B43340308AD46AFE454A40,'2014-09-25 22:32:43'),
(578,'1405 Hagonoy Avenue','','Slaskie',133,'86587','867287719310',0x0000000001010000002431F77FC41F3340F5B06197F2654940,'2014-09-25 22:32:42'),
(579,'521 San Juan Bautista Tuxtepec Place','','Qaraghandy',598,'95093','844018348565',0x0000000001010000006848CB3711F15040E32A604C44E44740,'2014-09-25 22:31:56'),
(580,'923 Tangail Boulevard','','Tokyo-to',10,'33384','315528269898',0x00000000010100000078E5C468A76B6140C3A27D079ADA4140,'2014-09-25 22:31:45'),
(581,'186 Skikda Lane','','Morelos',131,'89422','14465669789',0x00000000010100000048C2BE9DC4CE58C0DA3DD4111BED3240,'2014-09-25 22:32:05'),
(582,'1568 Celaya Parkway','','Kaohsiung',168,'34750','278669994384',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:15'),
(583,'1489 Kakamigahara Lane','','Taipei',526,'98883','29341849811',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:16'),
(584,'1819 Alessandria Loop','','Campeche',103,'53829','377633994405',0x0000000001010000008636A5611DF556C0374F1A0F5BA53240,'2014-09-25 22:32:02'),
(585,'1208 Tama Loop','','Ninawa',344,'73605','954786054144',0x000000000101000000314F9DFD378F4540961EF23BF22A4240,'2014-09-25 22:31:40'),
(586,'951 Springs Lane','','Central Mindanao',219,'96115','165164761435',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:37'),
(587,'760 Miyakonojo Drive','','Guerrero',246,'64682','294449058179',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:32:08'),
(588,'966 Asuncin Way','','Hidalgo',212,'62703','995527378381',0x000000000101000000EBBD4230D89A58C0E30632F1FD233540,'2014-09-25 22:32:07'),
(589,'1584 Ljubertsy Lane','','England',494,'22954','285710089439',0x00000000010100000035385B8AF577F6BF8C7560EFB4734940,'2014-09-25 22:33:38'),
(590,'247 Jining Parkway','','Banjul',54,'53446','170115379190',0x0000000001010000001BE4E434FA9330C08A8F4FC8CEE72A40,'2014-09-25 22:31:04'),
(591,'773 Dallas Manor','','Buenos Aires',424,'12664','914466027044',0x00000000010100000009C3802557204DC0B75CA21FB25C41C0,'2014-09-25 22:30:06'),
(592,'1923 Stara Zagora Lane','','Nantou',546,'95179','182178609211',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:33:17'),
(593,'1402 Zanzibar Boulevard','','Guanajuato',106,'71102','387448063440',0x000000000101000000FCB7DCAA353459C05CA8A1B206863440,'2014-09-25 22:32:03'),
(594,'1464 Kursk Parkway','','Shandong',574,'17381','338758048786',0x0000000001010000008CA2073E86C65D40055669E6245B4240,'2014-09-25 22:30:44'),
(595,'1074 Sanaa Parkway','','Loja',311,'22474','154124128457',0x00000000010100000092DBE51112CD53C00EF96706F1F10FC0,'2014-09-25 22:30:55'),
(596,'1759 Niznekamsk Avenue','','al-Manama',14,'39414','864392582257',0x000000000101000000044D9539A74A49401224004922373A40,'2014-09-25 22:30:11'),
(597,'32 Liaocheng Way','','Minas Gerais',248,'1944','410877354933',0x000000000101000000C2757BFFD5AC45C0424F1432A1C335C0,'2014-09-25 22:30:19'),
(598,'42 Fontana Avenue','','Fejr',512,'14684','437829801725',0x00000000010100000000000000000000000000000000000000,'2014-09-25 22:31:09'),
(599,'1895 Zhezqazghan Drive','','California',177,'36693','137809746111',0x0000000001010000003EC7ECD1407C5DC057FA1A930FE34040,'2014-09-25 22:33:51'),
(600,'1837 Kaduna Parkway','','Inner Mongolia',241,'82580','640843562301',0x000000000101000000D61A4AEDC5465C400E64E2FB87834440,'2014-09-25 22:30:37'),
(601,'844 Bucuresti Place','','Liaoning',242,'36603','935952366111',0x000000000101000000B88086EDDD6D5E407CED9925018D4340,'2014-09-25 22:30:37'),
(602,'1101 Bucuresti Boulevard','','West Greece',401,'97661','199514580428',0x000000000101000000AAC1EA7E04BC3540E65F26E5491F4340,'2014-09-25 22:31:07'),
(603,'1103 Quilmes Boulevard','','Piura',503,'52137','644021380889',0x000000000101000000AD9685C0DB2B54C09B012EC8969D13C0,'2014-09-25 22:32:34'),
(604,'1331 Usak Boulevard','','Vaud',296,'61960','145308717464',0x000000000101000000CE273CB203881A40205734E72A424740,'2014-09-25 22:33:14'),
(605,'1325 Fukuyama Street','','Heilongjiang',537,'27107','288241215394',0x00000000010100000017540A70700160401E1C47077F7D4740,'2014-09-25 22:30:44');
COMMIT;
DROP TABLE address;
#
# MDEV-35116 InnoDB fails to set error index
#        for HA_ERR_NULL_IN_SPATIAL
#
BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';
CREATE TABLE t1 (i INT, g GEOMETRY NOT NULL,
SPATIAL INDEX (g)) ENGINE=InnoDB;
CREATE TEMPORARY TABLE t2 (PRIMARY KEY(a)) ENGINE=InnoDB
WITH RECURSIVE t(a) AS (VALUES(1),(1)) SELECT * FROM t;
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
call mtr.add_suppression("BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table .*");
BINLOG ' SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf /+ AgAAAA==';
ERROR 22003: Cannot get geometry object from data you send to the GEOMETRY field
DROP TABLE t1;