Projekt

Obecné

Profil

Stáhnout (6.02 KB) Statistiky
| Větev: | Revize:
1
-- tento skript vlozi geosouradnice k existujicim ulicim
2

    
3

    
4
UPDATE `ulice` SET lat=49.369388,lng=12.858804400000054 WHERE id=1; 
5
UPDATE `ulice` SET lat=49.5942514,lng=13.100573599999962 WHERE id=2;
6
UPDATE `ulice` SET lat=49.5325795,lng=12.932922299999973 WHERE id=3;
7
UPDATE `ulice` SET lat=49.5331401,lng=12.944697200000064 WHERE id=4;
8
UPDATE `ulice` SET lat=49.5290441,lng=12.924181900000008 WHERE id=5;
9
UPDATE `ulice` SET lat=49.4348481,lng=12.814734700000031 WHERE id=6;
10
UPDATE `ulice` SET lat=49.3661949,lng=13.134370499999932 WHERE id=7;
11
UPDATE `ulice` SET lat=49.5073853,lng=12.801840500000026 WHERE id=8;
12
UPDATE `ulice` SET lat=49.5511106,lng=13.065398100000039 WHERE id=9;
13
UPDATE `ulice` SET lat=49.3016091,lng=13.312576700000022 WHERE id=10;
14
UPDATE `ulice` SET lat=49.5018924,lng=13.294453100000055 WHERE id=11;
15
UPDATE `ulice` SET lat=49.1962834,lng=13.509260100000006 WHERE id=12;
16
UPDATE `ulice` SET lat=49.2989568,lng=13.439006199999994 WHERE id=13;
17
UPDATE `ulice` SET lat=49.726864,lng=12.901699000000008 WHERE id=14;
18
UPDATE `ulice` SET lat=49.8893779,lng=12.606704600000057 WHERE id=15;
19
UPDATE `ulice` SET lat=49.8067796,lng=12.642488400000047 WHERE id=16;
20
UPDATE `ulice` SET lat=49.7911169,lng=12.648667199999977 WHERE id=17;
21
UPDATE `ulice` SET lat=49.8030504,lng=12.63480770000001 WHERE id=18;
22
UPDATE `ulice` SET lat=49.4329948,lng=12.951485300000058 WHERE id=19;
23
UPDATE `ulice` SET lat=49.5615961,lng=12.77715139999998 WHERE id=20;
24
UPDATE `ulice` SET lat=49.5891548,lng=12.881511600000067 WHERE id=21;
25
UPDATE `ulice` SET lat=49.4365627,lng=12.720542000000023 WHERE id=22;
26
UPDATE `ulice` SET lat=49.3667667,lng=13.009845799999994 WHERE id=23;
27
UPDATE `ulice` SET lat=49.8416809,lng=13.229441100000031 WHERE id=24;
28
UPDATE `ulice` SET lat=49.34425969999999,lng=13.219951100000003 WHERE id=25;
29
UPDATE `ulice` SET lat=49.3590594,lng=13.384042300000033 WHERE id=26;
30
UPDATE `ulice` SET lat=49.3603773,lng=13.356904600000007 WHERE id=27;
31
UPDATE `ulice` SET lat=49.3909746,lng=13.468732700000032 WHERE id=28;
32
UPDATE `ulice` SET lat=49.6655193,lng=12.827393700000016 WHERE id=29;
33
UPDATE `ulice` SET lat=49.591775,lng=12.705252900000005 WHERE id=30;
34
UPDATE `ulice` SET lat=49.5893638,lng=12.720079899999973 WHERE id=31;
35
UPDATE `ulice` SET lat=49.3247489,lng=13.69061750000003 WHERE id=32;
36
UPDATE `ulice` SET lat=49.3195422,lng=13.71081079999999 WHERE id=33;
37
UPDATE `ulice` SET lat=49.323759,lng=13.703250000000025 WHERE id=34;
38
UPDATE `ulice` SET lat=49.1460905,lng=13.564452399999936 WHERE id=35;
39
UPDATE `ulice` SET lat=49.0240725,lng=13.499317499999961 WHERE id=36;
40
UPDATE `ulice` SET lat=49.0285263,lng=13.517740499999945 WHERE id=37;
41
UPDATE `ulice` SET lat=49.2881779,lng=13.143561800000043 WHERE id=38;
42
UPDATE `ulice` SET lat=49.2863376,lng=13.12969309999994 WHERE id=39;
43
UPDATE `ulice` SET lat=49.293581,lng=13.125704600000063 WHERE id=40;
44
UPDATE `ulice` SET lat=49.2951762,lng=13.150141200000007 WHERE id=41;
45
UPDATE `ulice` SET lat=49.2276062,lng=13.520478400000002 WHERE id=42;
46
UPDATE `ulice` SET lat=49.2234632,lng=13.511268900000005 WHERE id=43;
47
UPDATE `ulice` SET lat=49.24249409999999,lng=13.532533599999965 WHERE id=44;
48
UPDATE `ulice` SET lat=49.1374427,lng=13.235204599999975 WHERE id=45;
49
UPDATE `ulice` SET lat=49.7173149,lng=12.777892800000018 WHERE id=46;
50
UPDATE `ulice` SET lat=49.893186,lng=12.730072699999937 WHERE id=47;
51
UPDATE `ulice` SET lat=49.863975,lng=12.725196099999948 WHERE id=48;
52
UPDATE `ulice` SET lat=49.6681792,lng=12.551898199999982 WHERE id=49;
53
UPDATE `ulice` SET lat=49.752874,lng=12.989615299999969 WHERE id=50;
54
UPDATE `ulice` SET lat=49.7515438,lng=13.00579289999996 WHERE id=51;
55
UPDATE `ulice` SET lat=49.3986612,lng=12.862793099999976 WHERE id=52;
56
UPDATE `ulice` SET lat=49.3825977,lng=13.049589999999966 WHERE id=53;
57
UPDATE `ulice` SET lat=49.59149559999999,lng=12.715902400000004 WHERE id=54;
58
UPDATE `ulice` SET lat=49.4462758,lng=12.932268199999953 WHERE id=55;
59
UPDATE `ulice` SET lat=49.4417745,lng=12.917492100000004 WHERE id=56;
60
UPDATE `ulice` SET lat=49.5316687,lng=12.951474599999983 WHERE id=57;
61
UPDATE `ulice` SET lat=49.5256309,lng=12.93846629999996 WHERE id=58;
62
UPDATE `ulice` SET lat=49.4188422,lng=12.716298300000062 WHERE id=59;
63
UPDATE `ulice` SET lat=49.3434229,lng=13.133497300000045 WHERE id=60;
64
UPDATE `ulice` SET lat=49.4249957,lng=13.285349600000018 WHERE id=61;
65
UPDATE `ulice` SET lat=49.3858178,lng=13.304274299999975 WHERE id=62;
66
UPDATE `ulice` SET lat=49.3831621,lng=13.297191399999974 WHERE id=63;
67
UPDATE `ulice` SET lat=49.4024071,lng=13.293027400000028 WHERE id=64;
68
UPDATE `ulice` SET lat=49.3939022,lng=13.28203080000003 WHERE id=65;
69
UPDATE `ulice` SET lat=49.402985,lng=13.28112520000002 WHERE id=66;
70
UPDATE `ulice` SET lat=49.3954174,lng=13.304848499999935 WHERE id=67;
71
UPDATE `ulice` SET lat=49.7114696,lng=12.772997000000032 WHERE id=68;
72
UPDATE `ulice` SET lat=49.7088027,lng=12.782785699999977 WHERE id=69;
73
UPDATE `ulice` SET lat=49.6779674,lng=12.654376100000036 WHERE id=70;
74
UPDATE `ulice` SET lat=49.0871919,lng=13.480447700000013 WHERE id=71;
75
UPDATE `ulice` SET lat=49.8255089,lng=12.523725000000013 WHERE id=72;
76
UPDATE `ulice` SET lat=49.348875,lng=12.85527849999994 WHERE id=73;
77
UPDATE `ulice` SET lat=49.2316758,lng=13.520409299999983 WHERE id=74;
78
UPDATE `ulice` SET lat=49.6692003,lng=13.448342300000036 WHERE id=75;
79
UPDATE `ulice` SET lat=49.696732,lng=13.459893899999997 WHERE id=76;
80
UPDATE `ulice` SET lat=49.62768089999999,lng=13.152081500000008 WHERE id=77;
81
UPDATE `ulice` SET lat=49.4861699,lng=13.582260899999937 WHERE id=78;
82
UPDATE `ulice` SET lat=49.6404353,lng=13.519626600000038 WHERE id=79;
83
UPDATE `ulice` SET lat=49.89313869999999,lng=13.382958300000041 WHERE id=80;
84
UPDATE `ulice` SET lat=49.981924,lng=13.487483500000053 WHERE id=81;
85
UPDATE `ulice` SET lat=49.76380169999999,lng=13.252113799999961 WHERE id=82;
86
UPDATE `ulice` SET lat=49.6784086,lng=13.22565439999994 WHERE id=83;
87
UPDATE `ulice` SET lat=49.6548327,lng=13.29307730000005 WHERE id=84;
88
UPDATE `ulice` SET lat=49.9344975,lng=13.390364999999974 WHERE id=85;
89
UPDATE `ulice` SET lat=49.7298911,lng=13.276285899999948 WHERE id=86;
90
UPDATE `ulice` SET lat=49.5729906,lng=13.33350710000002 WHERE id=87;
(13-13/17)