Użytkownik:Gn/mapa: Różnice pomiędzy wersjami

Z Formicopedia
Skocz do: nawigacja, szukaj
Linia 583: Linia 583:
 
50.651367,17.985033
 
50.651367,17.985033
 
50.651367,17.985217
 
50.651367,17.985217
 +
6#B23AB64B
 +
50.6582,17.921833
 +
50.6581,17.921783
 +
50.657983,17.921733
 +
50.657883,17.921667
 +
50.6578,17.921633
 +
50.657667,17.921567
 +
50.657583,17.921633
 +
50.65755,17.921767
 +
50.657483,17.921867
 +
50.657367,17.921933
 +
50.657233,17.921983
 +
50.657133,17.922
 +
50.657,17.92205
 +
50.656883,17.922067
 +
50.65675,17.922083
 +
50.656633,17.92215
 +
50.656533,17.9222
 +
50.656433,17.922267
 +
50.656317,17.92235
 +
50.656217,17.9224
 +
50.656133,17.922483
 +
50.656017,17.92255
 +
50.655917,17.922633
 +
50.6558,17.922733
 +
50.655683,17.922783
 +
50.655583,17.92285
 +
50.655483,17.922933
 +
50.655383,17.923
 +
50.655267,17.923067
 +
50.655167,17.923133
 +
50.655067,17.9232
 +
50.654983,17.923283
 +
50.6549,17.92335
 +
50.6548,17.92345
 +
50.6547,17.923533
 +
50.6546,17.9236
 +
50.6545,17.923667
 +
50.654367,17.9237
 +
50.65425,17.923733
 +
50.654133,17.9238
 +
50.654067,17.923917
 +
50.653983,17.92405
 +
50.653917,17.924183
 +
50.6539,17.92435
 +
50.653883,17.924517
 +
50.653867,17.9247
 +
50.653833,17.924883
 +
50.653783,17.925067
 +
50.653717,17.925233
 +
50.65365,17.9254
 +
50.6536,17.925567
 +
50.653533,17.925717
 +
50.653467,17.925867
 +
50.653417,17.926017
 +
50.653367,17.926167
 +
50.6533,17.926317
 +
50.653217,17.926433
 +
50.653083,17.926417
 +
50.652967,17.9264
 +
50.652833,17.926383
 +
50.652717,17.92635
 +
50.652583,17.926333
 +
50.652467,17.926317
 +
50.652333,17.926267
 +
50.652217,17.92625
 +
50.6521,17.926233
 +
50.651967,17.9262
 +
50.6518,17.926217
 +
50.651667,17.926167
 +
50.65155,17.926133
 +
50.6514,17.926083
 +
50.651283,17.92605
 +
50.65115,17.926033
 +
50.65105,17.926
 +
50.650933,17.92595
 +
50.6508,17.925917
 +
50.650683,17.925883
 +
50.650583,17.92585
 +
50.650467,17.92585
 +
50.65035,17.925833
 +
50.650217,17.9258
 +
50.650067,17.925767
 +
50.64995,17.925633
 +
50.649933,17.925467
 +
50.649867,17.9253
 +
50.649817,17.925017
 +
6#B2093ED5
 +
50.649867,17.925067
 +
50.6498,17.924933
 +
50.64975,17.924783
 +
50.649667,17.924617
 +
50.6496,17.92445
 +
50.649583,17.924233
 +
50.649517,17.924033
 +
50.649483,17.923883
 +
50.649467,17.923833
 +
50.649467,17.92365
 +
50.649433,17.923433
 +
50.649433,17.92325
 +
50.6494,17.923033
 +
50.6494,17.922833
 +
50.6494,17.922633
 +
50.649417,17.922433
 +
50.649417,17.922267
 +
50.6494,17.922067
 +
50.649367,17.92185
 +
50.649367,17.921667
 +
50.649367,17.921483
 +
50.6494,17.921283
 +
50.649383,17.9211
 +
50.649417,17.920883
 +
50.649417,17.920667
 +
50.649433,17.9205
 +
50.6495,17.920333
 +
50.6496,17.920233
 +
50.649767,17.920167
 +
50.649917,17.920067
 +
50.65005,17.920033
 +
50.650183,17.92
 +
50.650333,17.919967
 +
50.6505,17.91995
 +
50.650617,17.9199
 +
50.650717,17.919833
 +
50.650783,17.919717
 +
50.65085,17.9196
 +
50.65095,17.919517
 +
50.651033,17.9194
 +
50.651117,17.9193
 +
50.6512,17.919217
 +
50.651333,17.919133
 +
50.65145,17.919033
 +
50.65155,17.918983
 +
50.651667,17.91895
 +
50.651817,17.91895
 +
50.65195,17.918917
 +
50.652067,17.918933
 +
50.6522,17.91895
 +
50.65235,17.919033
 +
50.652467,17.919067
 +
50.652583,17.919117
 +
50.6527,17.919183
 +
50.652833,17.91925
 +
50.652967,17.919333
 +
50.653083,17.9194
 +
50.653217,17.919467
 +
50.65335,17.919533
 +
50.653467,17.919583
 +
50.653583,17.91965
 +
50.653717,17.919717
 +
50.653833,17.9198
 +
50.65395,17.9199
 +
50.65405,17.919967
 +
50.654167,17.920033
 +
50.6543,17.920083
 +
50.654417,17.92015
 +
50.654533,17.920233
 +
50.654617,17.920317
 +
50.654733,17.920433
 +
50.654833,17.920517
 +
50.65495,17.920633
 +
50.65505,17.920767
 +
50.655167,17.920883
 +
50.655267,17.921
 +
50.655333,17.92115
 +
50.655383,17.9213
 +
50.65545,17.921517
 +
50.6555,17.921733
 +
50.655533,17.921917
 +
50.655567,17.922083
 +
50.655583,17.922217
 +
50.655617,17.922367
 +
50.655667,17.922517
 +
50.655733,17.9226
 +
50.65585,17.922567
 +
50.655933,17.922483
 +
50.656017,17.9224
 +
50.656117,17.922317
 +
50.656217,17.92225
 +
50.656333,17.9222
 +
50.656433,17.922133
 +
50.656533,17.922083
 +
50.656617,17.922017
 +
50.656733,17.921967
 +
50.65685,17.921967
 +
50.656983,17.921933
 +
50.657117,17.921867
 +
50.657233,17.921817
 +
50.65735,17.921767
 +
50.657417,17.921667
 +
50.6575,17.92155
 +
50.657617,17.92155
 +
50.657733,17.9216
 +
50.657833,17.92165
 +
50.657933,17.9217
 +
50.658067,17.921767
 +
50.658183,17.921817
 +
50.658283,17.921867
 +
50.658383,17.9219
 +
50.658483,17.92195
 +
50.658583,17.922
 +
50.658683,17.922067
 +
50.6588,17.922117
 +
50.658917,17.922183
 +
50.659,17.922233
 +
50.6591,17.922267
 +
50.659183,17.922317
 +
50.659283,17.922367
 +
50.65935,17.9225
 +
50.659367,17.922667
 +
50.65935,17.922817
 +
50.659333,17.923
 +
50.65935,17.92315
 +
50.659333,17.9233
 +
50.659317,17.92345
 +
50.659317,17.923617
 +
50.659367,17.92375
 +
50.659433,17.923883
 +
50.6595,17.924
 +
50.659567,17.92415
 +
50.659533,17.9243
 +
50.659467,17.924417
 +
50.6594,17.924517
 +
50.659333,17.924617
 +
50.65925,17.92475
 +
50.659167,17.924883
 +
50.659167,17.925017
 +
50.65925,17.925133
 +
50.659267,17.925267
 +
50.65925,17.925433
 +
50.65925,17.925583
 +
50.659233,17.925767
 +
50.659183,17.925933
 +
50.659133,17.926083
 +
50.659083,17.926217
 +
50.659,17.926283
 +
50.658933,17.926417
 +
50.658867,17.926567
 +
50.658817,17.926683
 +
50.658767,17.9268
 +
50.658717,17.926917
 +
50.65865,17.927067
 +
50.658567,17.9272
 +
50.658517,17.9273
 +
50.658433,17.92745
 +
50.658367,17.927567
 +
50.6583,17.927683
 +
50.658217,17.927817
 +
50.65815,17.927917
 +
50.658083,17.92805
 +
50.658,17.928183
 +
50.657933,17.9283
 +
50.6579,17.928467
 +
50.657883,17.9286
 +
50.65785,17.928783
 +
50.657817,17.9289
 +
50.65785,17.92905
 +
50.6579,17.9292
 +
50.657967,17.929333
 +
50.658017,17.929467
 +
50.658083,17.929583
 +
50.658133,17.929717
 +
50.658183,17.92985
 +
50.658233,17.929967
 +
50.6583,17.930067
 +
50.658317,17.9302
 +
50.658267,17.93035
 +
50.658233,17.930517
 +
50.658183,17.930683
 +
50.65815,17.930833
 +
50.658083,17.931
 +
50.65805,17.931133
 +
50.657983,17.931267
 +
50.657933,17.9314
 +
50.657883,17.931517
 +
50.657817,17.93165
 +
50.657733,17.931767
 +
50.657683,17.931867
 +
50.6576,17.93195
 +
50.657533,17.932067
 +
50.65745,17.932183
 +
50.657383,17.9323
 +
50.6573,17.9324
 +
50.657217,17.932517
 +
50.657133,17.93265
 +
50.657083,17.932733
 +
50.656983,17.93285
 +
50.6569,17.932967
 +
50.6568,17.933083
 +
50.6567,17.9332
 +
50.656617,17.933317
 +
50.656533,17.933433
 +
50.65645,17.93355
 +
50.656367,17.933683
 +
50.656283,17.9338
 +
50.6562,17.933917
 +
50.656133,17.934033
 +
50.65605,17.93415
 +
50.655967,17.934267
 +
50.6559,17.934367
 +
50.6558,17.934483
 +
50.655733,17.934583
 +
50.65565,17.9347
 +
50.655567,17.934817
 +
50.6555,17.934933
 +
50.655433,17.93505
 +
50.655383,17.9352
 +
50.655333,17.935317
 +
50.6553,17.93545
 +
50.655283,17.935617
 +
50.655217,17.935717
 +
50.655133,17.9358
 +
50.65505,17.935917
 +
50.654967,17.936033
 +
50.654883,17.936117
 +
50.654817,17.9362
 
</googlemap>
 
</googlemap>
 
http://www.google.com/apis/maps/documentation/polylineutility.html
 
http://www.google.com/apis/maps/documentation/polylineutility.html
 +
 +
 +
TEST GOOGLE MAPY
 +
 +
Przepis na zrobienie z danych gps kolorowej linii na mapie
 +
 
 +
0. Zapisać dane do pliku tekstowego.
 +
 +
1. Zaimportować do excela plik txt z elementami rozdzielającymi: tabulatory i spacje
 +
 +
2. Wyczyścić pierwszą kolumnę.
 +
 +
3. W pierszej kolumnie wpisać formułę
 +
    (wzór jest w rozbiciu na parę linii ale ma być wpisany bez spacji!)
 +
 +
    =JEŻELI(CZY.PUSTA(B2);"6#B23AB64B";
 +
    PODSTAW((PODSTAW(B2;"N";"")+ZAOKR(PODSTAW(C2;".";"")/60000;6));",";".")
 +
    &","&
 +
    PODSTAW((PODSTAW(D2;"E";"")+ZAOKR(PODSTAW(E2;".";"")/60000;6));",";"."))
 +
 +
4. Skopiować wynik z pierwszej kolumny i wstawić do mapy.
 +
 +
5. Zrobione :-)

Wersja z 14:07, 16 sie 2009

<googlemap lat="50.671" lon="17.945" type="normal" zoom="12" width="700" height="400"> 50.677, 17.9699, Tutaj znajdziesz gniazda mrówki Manica rubida 50.663147,17.973224, Tutaj jest kilka ciekawych gniazd mrówek (nieużytek więc powstają duże ziemne kopce) 50.6651,17.9185, To były stare http://www.google.com/apis/maps/documentation/polylineutility.htmlkasztany z mrówkami 50.671,17.948, gn - moje miejsce na mapie hodowców :-) 50.6651,17.9185, To były stare kasztany z mrówkami, można było obserwować ścieżki w zagłębieniach kory. 50.6687,17.9533, wybudowali Tesco ścinając wcześniej kilka starych drzew rosnących tuż przy ul Ozimskiej. W tych drzewach mieszkały mrówki.. szkoda 50.6689,17.9581, Tu było moje ulubione drzewo z mrówkami w dziupli. Obok mieszkała Formica cunicularia. 50.6318,17.9878, Kilka gniazd ślicznych dwubarwnych Formic. 50.6472,17.9276, Ciekawe stanowisko do poszukiwań mrówek. :-) 50.6598,17.948, Myrmice, 50.6542,17.9708, W połowie tego dziwnego lasku jest nasłoneczniona polanka z dużym kopcem.. nieopodal na zdziczałym placu po jakimś zakładzie przemysłowym Formica cunicularia. 50.6538,17.9696, Formica cunicularia i ciekawe gniazda Tetramorium caespitum. 50.6636,17.9747, Nasyp kolejowy w którym pozostały jeszcze drewniane podkłady, w nich i pod nimi Formica cunicularia. 50.6732,17.8788, naprzeciwko kaplicy, pod asfaltem duże gniazdo mrówek.. 50.6847,17.9028, wały to miejsca na których łatwo obserwować mrówki. 50.84,17.6835, Na terenie skansenu jest pełno gniazd ciepłolubnych mrówek, Doskonała piaszczysta ziemia o miejscami czerwonawym odcieniu. Kilka większych kęp trawy to gniazda mrówek. Tutaj można dokonać ciekawych odkryć. 52.3986, 16.9843, Poznań, Malta u góry na polanie wokół pomika harcerzy kilka ciekawych stanowisk Lasius fuliginosus. Warto tutaj zajrzeć i obejść polanę dookoła. 50.7121, 18.1018, Turawa, jezioro średnie, na skarpie pod korzeniami jest Camponotus herculeanus a w drzewie Dolichoderus quadripunctatus. Powoli dookoła obchodząc jezioro można spotkać wiele ciekawych mrówek. Zobacz to miejsce na panoramio 7#b2752BC5 50.651367,17.985217 50.651217,17.985867 50.6511,17.985883 50.650983,17.985917 50.650867,17.985933 50.65075,17.98595 50.650617,17.985983 50.6505,17.986 50.650367,17.986017 50.65025,17.986033 50.650133,17.98605 50.650017,17.986067 50.649917,17.986083 50.6498,17.9861 50.649683,17.986117 50.649567,17.986133 50.649467,17.98615 50.64935,17.986167 50.649233,17.986183 50.649117,17.9862 50.649017,17.986217 50.6489,17.986217 50.648783,17.98625 50.648667,17.986267 50.64855,17.986283 50.648433,17.9863 50.648317,17.986317 50.6482,17.986317 50.6481,17.986333 50.647983,17.98635 50.647883,17.986367 50.647767,17.986383 50.647667,17.986383 50.64755,17.9864 50.64745,17.986417 50.647333,17.986433 50.647217,17.98645 50.647117,17.986467 50.647,17.986483 50.646883,17.9865 50.646767,17.986517 50.64665,17.986533 50.646533,17.986567 50.6464,17.986583 50.646283,17.9866 50.646167,17.986617 50.64605,17.986617 50.645933,17.9866 50.645817,17.9866 50.645767,17.986733 50.645733,17.9869 50.6457,17.987083 50.645667,17.987267 50.645633,17.98745 50.6456,17.9876 50.6455,17.987667 50.645383,17.987683 50.645267,17.987667 50.645133,17.987683 50.64505,17.987617 50.644967,17.987517 50.64485,17.987417 50.64475,17.987433 50.644683,17.98755 50.644633,17.9877 50.644583,17.987833 50.644533,17.98795 50.644483,17.988117 50.644417,17.98825 50.644367,17.9884 50.644283,17.9885 50.644183,17.98855 50.6441,17.988633 50.644017,17.988567 50.643917,17.98845 50.643817,17.988317 50.643717,17.9882 50.643617,17.988083 50.643533,17.98795 50.643433,17.987833 50.643333,17.9877 50.64325,17.98755 50.64315,17.9874 50.643083,17.987233 50.643017,17.987067 50.642967,17.986917 50.642917,17.986733 50.64285,17.9866 50.6428,17.986467 50.64275,17.986317 50.642683,17.986167 50.642633,17.986017 50.6426,17.985883 50.64255,17.98575 50.642483,17.985617 50.642417,17.985467 50.64235,17.985333 50.642267,17.985283 50.642217,17.985367 50.6422,17.985533 50.6422,17.985717 50.6422,17.9859 50.6422,17.9861 50.642183,17.9863 50.642167,17.986483 50.642167,17.9867 50.64215,17.986833 50.64215,17.987 50.642133,17.98715 50.642117,17.9873 50.6421,17.98745 50.64205,17.987617 50.641917,17.987667 50.641767,17.987683 50.641683,17.9877 50.641533,17.987733 50.641383,17.98775 50.64125,17.98775 50.641083,17.987767 50.640933,17.987783 50.6408,17.987767 50.640683,17.98775 50.640567,17.987733 50.640433,17.9877 50.6403,17.987683 50.640183,17.98765 50.640083,17.9876 50.639983,17.987467 50.639883,17.98735 50.639783,17.987233 50.6397,17.987133 50.6396,17.987033 50.639517,17.986933 50.639417,17.986817 50.639317,17.9867 50.639217,17.986567 50.639117,17.98645 50.639017,17.986333 50.638933,17.986233 50.638817,17.986133 50.6387,17.986083 50.6386,17.986067 50.6385,17.98605 50.638417,17.986017 50.638333,17.986 50.6382,17.985967 50.638067,17.985933 50.63795,17.9859 50.637817,17.985867 50.6377,17.985833 50.637567,17.9858 50.637467,17.985767 50.63735,17.98575 50.637233,17.985717 50.637133,17.985683 50.637033,17.985617 50.636967,17.985483 50.636867,17.985467 50.636767,17.985467 50.636667,17.985467 50.636583,17.9855 50.636483,17.98555 50.6364,17.985617 50.6363,17.985717 50.6362,17.985817 50.6361,17.9859 50.636,17.985933 50.635883,17.985967 50.635783,17.9859 50.635683,17.9859 50.635583,17.98595 50.6355,17.986 50.6354,17.986017 50.6353,17.986017 50.635183,17.985967 50.635067,17.985917 50.634967,17.985867 50.63485,17.985817 50.634733,17.98575 50.63465,17.9857 50.634533,17.98565 50.634433,17.9856 50.63435,17.985533 50.634317,17.985567 50.634317,17.985567 50.634317,17.985583 50.634317,17.9855 50.634317,17.985567 50.634267,17.985517 50.634333,17.985433 50.634317,17.98545 50.63435,17.985333 50.634383,17.9852 50.63445,17.985117 50.63455,17.985183 50.634617,17.9853 50.634633,17.98545 50.63465,17.985617 50.634717,17.985733 50.6348,17.985783 50.6349,17.985817 50.635,17.98585 50.635083,17.9859 50.635117,17.98605 50.63505,17.986183 50.634983,17.986267 50.634867,17.986317 50.634767,17.986367 50.634667,17.986417 50.634567,17.986483 50.634467,17.986517 50.634367,17.986567 50.634283,17.986617 50.634167,17.98665 50.634067,17.9867 50.633983,17.986767 50.633883,17.98685 50.6338,17.9869 50.6337,17.98695 50.6336,17.986983 50.6335,17.987017 50.6334,17.987033 50.6333,17.9871 50.633233,17.9872 50.63315,17.987267 50.633067,17.987333 50.632967,17.98735 50.63285,17.987333 50.632767,17.9874 50.632667,17.9875 50.632567,17.98755 50.632483,17.987617 50.632383,17.987667 50.632283,17.987733 50.632183,17.9878 50.632083,17.987867 50.631983,17.98795 50.631883,17.988 50.631783,17.988033 50.6317,17.988117 50.631617,17.9882 50.631533,17.988283 50.63145,17.98835 50.631367,17.988417 50.631267,17.988467 50.631183,17.988533 50.6311,17.988583 50.631017,17.988683 50.630933,17.988767 50.630883,17.988883 50.6308,17.98895 50.6307,17.989 50.630633,17.9891 50.63055,17.989167 50.63045,17.98915 50.630367,17.989167 50.630267,17.989217 50.630183,17.989283 50.630067,17.98935 50.629983,17.989433 50.629883,17.989533 50.629817,17.989617 50.62975,17.989733 50.629667,17.98985 50.629583,17.989933 50.629483,17.990017 50.6294,17.990117 50.629317,17.9902 50.629217,17.990283 50.629133,17.9903 50.62905,17.9902 50.628967,17.990083 50.628883,17.989967 50.6288,17.989867 50.628733,17.989767 50.62865,17.989667 50.628567,17.98955 50.6285,17.98945 50.628433,17.989333 50.62835,17.989217 50.628283,17.989133 50.628217,17.98905 50.628117,17.988933 50.62805,17.988833 50.627967,17.988733 50.6279,17.988633 50.627833,17.988533 50.627767,17.9884 50.6277,17.9883 50.62765,17.98815 50.627617,17.988017 50.6276,17.98785 50.6276,17.9877 50.627617,17.98755 50.627667,17.9874 50.627733,17.987283 50.627817,17.987183 50.627917,17.987133 50.628017,17.987083 50.628117,17.987017 50.628183,17.9869 50.628283,17.986833 50.628367,17.986767 50.628467,17.986683 50.628567,17.986633 50.628667,17.986567 50.62875,17.986483 50.628833,17.986417 50.628917,17.98635 50.629017,17.986283 50.629117,17.986217 50.6292,17.986167 50.6293,17.986083 50.6294,17.986017 50.629483,17.985967 50.629583,17.985917 50.629667,17.985817 50.62975,17.98575 50.629833,17.985683 50.629933,17.985583 50.630033,17.9855 50.630133,17.985433 50.630217,17.985317 50.6303,17.985217 50.630383,17.985133 50.6305,17.985083 50.6306,17.985033 50.630683,17.98495 50.630783,17.98485 50.630867,17.984783 50.630967,17.984733 50.63105,17.984683 50.631133,17.984583 50.6312,17.984483 50.6313,17.9844 50.631383,17.984333 50.631483,17.98425 50.63155,17.984183 50.631633,17.984117 50.631733,17.984033 50.631833,17.98395 50.631933,17.983867 50.632017,17.9838 50.6321,17.98375 50.632183,17.983667 50.632267,17.9836 50.63235,17.983533 50.632417,17.983467 50.632517,17.9834 50.6326,17.983317 50.6327,17.983233 50.632783,17.983167 50.632867,17.9831 50.632933,17.983017 50.633017,17.982883 50.6331,17.9828 50.633183,17.982733 50.633267,17.98265 50.633333,17.982583 50.633433,17.9825 50.633533,17.982417 50.633617,17.982333 50.6337,17.98225 50.633783,17.982167 50.633883,17.982083 50.633983,17.982017 50.634067,17.981917 50.634167,17.981833 50.634267,17.98175 50.634367,17.98165 50.63445,17.981567 50.634517,17.981467 50.6346,17.981367 50.634683,17.9813 50.634783,17.98125 50.634883,17.981183 50.634967,17.981117 50.63505,17.981033 50.635133,17.980967 50.635217,17.980883 50.635317,17.980817 50.6354,17.980733 50.635483,17.98065 50.635583,17.980567 50.63565,17.98045 50.63575,17.980367 50.63585,17.980267 50.63595,17.980167 50.63605,17.980083 50.636133,17.98 50.636233,17.979917 50.636317,17.979833 50.636417,17.97975 50.6365,17.979667 50.6366,17.97965 50.6367,17.9797 50.636783,17.97975 50.636867,17.9798 50.636983,17.979833 50.637067,17.979817 50.637167,17.979783 50.637267,17.97975 50.63735,17.979717 50.63745,17.979683 50.637533,17.97965 50.63765,17.979633 50.637733,17.979617 50.637833,17.9796 50.63795,17.97955 50.638033,17.979517 50.63815,17.979483 50.63825,17.979433 50.638367,17.9794 50.638467,17.979383 50.638567,17.97935 50.638667,17.979333 50.638783,17.979283 50.638867,17.97925 50.638967,17.979233 50.639067,17.979217 50.639183,17.979183 50.639267,17.97915 50.639367,17.979083 50.63945,17.97905 50.63955,17.979 50.63965,17.978967 50.639767,17.978933 50.639867,17.978883 50.639967,17.97885 50.640067,17.978817 50.64015,17.9788 50.64025,17.978767 50.64035,17.978717 50.64045,17.9787 50.640533,17.978667 50.640633,17.97865 50.6407,17.978567 50.640633,17.978483 50.6407,17.978567 50.640783,17.978667 50.640867,17.978733 50.640967,17.978817 50.64105,17.978883 50.64115,17.97895 50.641267,17.978983 50.641367,17.97905 50.641483,17.979117 50.641567,17.979183 50.641667,17.97925 50.64175,17.97935 50.641817,17.979483 50.641867,17.979617 50.6419,17.9798 50.641933,17.979967 50.64195,17.980133 50.641967,17.980317 50.641967,17.9805 50.64195,17.9807 50.64195,17.9809 50.641933,17.9811 50.641933,17.981283 50.64195,17.981417 50.64195,17.98125 50.641967,17.9811 50.64205,17.98105 50.642167,17.98105 50.642267,17.981067 50.642383,17.981067 50.6425,17.981067 50.6426,17.981067 50.642717,17.98105 50.642833,17.98105 50.64295,17.981033 50.643067,17.981033 50.643183,17.981033 50.6433,17.981033 50.643417,17.981033 50.64355,17.981017 50.643667,17.981017 50.643767,17.981017 50.64385,17.981017 50.64395,17.980983 50.64405,17.980967 50.64415,17.980967 50.64425,17.980967 50.64435,17.980967 50.64445,17.980967 50.64455,17.98095 50.64465,17.98095 50.644733,17.98095 50.644833,17.98095 50.644933,17.980933 50.645033,17.980933 50.645133,17.980933 50.645217,17.98095 50.645333,17.98095 50.64545,17.980933 50.645567,17.980933 50.645667,17.98095 50.645767,17.980967 50.645883,17.980967 50.646,17.980967 50.6461,17.980983 50.6462,17.980983 50.6463,17.981 50.6464,17.981 50.6465,17.981 50.6466,17.981017 50.6467,17.981017 50.646783,17.981017 50.646883,17.981033 50.646983,17.980983 50.647067,17.98095 50.647117,17.98105 50.647117,17.981217 50.6472,17.9813 50.647317,17.981333 50.647417,17.981367 50.647533,17.981417 50.64765,17.98145 50.647767,17.981483 50.647883,17.981517 50.648017,17.98155 50.64815,17.981583 50.648233,17.9816 50.648317,17.981617 50.648417,17.981633 50.6485,17.981667 50.6486,17.981683 50.648683,17.9817 50.648783,17.981733 50.648867,17.98175 50.648967,17.981767 50.64905,17.9818 50.64915,17.981817 50.649233,17.981833 50.649367,17.981867 50.649483,17.9819 50.6496,17.981917 50.649717,17.98195 50.649817,17.981967 50.649933,17.982 50.650033,17.982033 50.650133,17.982067 50.650217,17.98215 50.6503,17.982267 50.650383,17.982383 50.650467,17.982517 50.650567,17.98265 50.650667,17.982783 50.650783,17.982917 50.650867,17.983067 50.65095,17.983217 50.651033,17.983367 50.651117,17.983517 50.651183,17.983667 50.651233,17.983867 50.651283,17.984067 50.651317,17.98425 50.651317,17.98445 50.651333,17.984633 50.65135,17.984833 50.651367,17.985033 50.651367,17.985217 6#B23AB64B 50.6582,17.921833 50.6581,17.921783 50.657983,17.921733 50.657883,17.921667 50.6578,17.921633 50.657667,17.921567 50.657583,17.921633 50.65755,17.921767 50.657483,17.921867 50.657367,17.921933 50.657233,17.921983 50.657133,17.922 50.657,17.92205 50.656883,17.922067 50.65675,17.922083 50.656633,17.92215 50.656533,17.9222 50.656433,17.922267 50.656317,17.92235 50.656217,17.9224 50.656133,17.922483 50.656017,17.92255 50.655917,17.922633 50.6558,17.922733 50.655683,17.922783 50.655583,17.92285 50.655483,17.922933 50.655383,17.923 50.655267,17.923067 50.655167,17.923133 50.655067,17.9232 50.654983,17.923283 50.6549,17.92335 50.6548,17.92345 50.6547,17.923533 50.6546,17.9236 50.6545,17.923667 50.654367,17.9237 50.65425,17.923733 50.654133,17.9238 50.654067,17.923917 50.653983,17.92405 50.653917,17.924183 50.6539,17.92435 50.653883,17.924517 50.653867,17.9247 50.653833,17.924883 50.653783,17.925067 50.653717,17.925233 50.65365,17.9254 50.6536,17.925567 50.653533,17.925717 50.653467,17.925867 50.653417,17.926017 50.653367,17.926167 50.6533,17.926317 50.653217,17.926433 50.653083,17.926417 50.652967,17.9264 50.652833,17.926383 50.652717,17.92635 50.652583,17.926333 50.652467,17.926317 50.652333,17.926267 50.652217,17.92625 50.6521,17.926233 50.651967,17.9262 50.6518,17.926217 50.651667,17.926167 50.65155,17.926133 50.6514,17.926083 50.651283,17.92605 50.65115,17.926033 50.65105,17.926 50.650933,17.92595 50.6508,17.925917 50.650683,17.925883 50.650583,17.92585 50.650467,17.92585 50.65035,17.925833 50.650217,17.9258 50.650067,17.925767 50.64995,17.925633 50.649933,17.925467 50.649867,17.9253 50.649817,17.925017 6#B2093ED5 50.649867,17.925067 50.6498,17.924933 50.64975,17.924783 50.649667,17.924617 50.6496,17.92445 50.649583,17.924233 50.649517,17.924033 50.649483,17.923883 50.649467,17.923833 50.649467,17.92365 50.649433,17.923433 50.649433,17.92325 50.6494,17.923033 50.6494,17.922833 50.6494,17.922633 50.649417,17.922433 50.649417,17.922267 50.6494,17.922067 50.649367,17.92185 50.649367,17.921667 50.649367,17.921483 50.6494,17.921283 50.649383,17.9211 50.649417,17.920883 50.649417,17.920667 50.649433,17.9205 50.6495,17.920333 50.6496,17.920233 50.649767,17.920167 50.649917,17.920067 50.65005,17.920033 50.650183,17.92 50.650333,17.919967 50.6505,17.91995 50.650617,17.9199 50.650717,17.919833 50.650783,17.919717 50.65085,17.9196 50.65095,17.919517 50.651033,17.9194 50.651117,17.9193 50.6512,17.919217 50.651333,17.919133 50.65145,17.919033 50.65155,17.918983 50.651667,17.91895 50.651817,17.91895 50.65195,17.918917 50.652067,17.918933 50.6522,17.91895 50.65235,17.919033 50.652467,17.919067 50.652583,17.919117 50.6527,17.919183 50.652833,17.91925 50.652967,17.919333 50.653083,17.9194 50.653217,17.919467 50.65335,17.919533 50.653467,17.919583 50.653583,17.91965 50.653717,17.919717 50.653833,17.9198 50.65395,17.9199 50.65405,17.919967 50.654167,17.920033 50.6543,17.920083 50.654417,17.92015 50.654533,17.920233 50.654617,17.920317 50.654733,17.920433 50.654833,17.920517 50.65495,17.920633 50.65505,17.920767 50.655167,17.920883 50.655267,17.921 50.655333,17.92115 50.655383,17.9213 50.65545,17.921517 50.6555,17.921733 50.655533,17.921917 50.655567,17.922083 50.655583,17.922217 50.655617,17.922367 50.655667,17.922517 50.655733,17.9226 50.65585,17.922567 50.655933,17.922483 50.656017,17.9224 50.656117,17.922317 50.656217,17.92225 50.656333,17.9222 50.656433,17.922133 50.656533,17.922083 50.656617,17.922017 50.656733,17.921967 50.65685,17.921967 50.656983,17.921933 50.657117,17.921867 50.657233,17.921817 50.65735,17.921767 50.657417,17.921667 50.6575,17.92155 50.657617,17.92155 50.657733,17.9216 50.657833,17.92165 50.657933,17.9217 50.658067,17.921767 50.658183,17.921817 50.658283,17.921867 50.658383,17.9219 50.658483,17.92195 50.658583,17.922 50.658683,17.922067 50.6588,17.922117 50.658917,17.922183 50.659,17.922233 50.6591,17.922267 50.659183,17.922317 50.659283,17.922367 50.65935,17.9225 50.659367,17.922667 50.65935,17.922817 50.659333,17.923 50.65935,17.92315 50.659333,17.9233 50.659317,17.92345 50.659317,17.923617 50.659367,17.92375 50.659433,17.923883 50.6595,17.924 50.659567,17.92415 50.659533,17.9243 50.659467,17.924417 50.6594,17.924517 50.659333,17.924617 50.65925,17.92475 50.659167,17.924883 50.659167,17.925017 50.65925,17.925133 50.659267,17.925267 50.65925,17.925433 50.65925,17.925583 50.659233,17.925767 50.659183,17.925933 50.659133,17.926083 50.659083,17.926217 50.659,17.926283 50.658933,17.926417 50.658867,17.926567 50.658817,17.926683 50.658767,17.9268 50.658717,17.926917 50.65865,17.927067 50.658567,17.9272 50.658517,17.9273 50.658433,17.92745 50.658367,17.927567 50.6583,17.927683 50.658217,17.927817 50.65815,17.927917 50.658083,17.92805 50.658,17.928183 50.657933,17.9283 50.6579,17.928467 50.657883,17.9286 50.65785,17.928783 50.657817,17.9289 50.65785,17.92905 50.6579,17.9292 50.657967,17.929333 50.658017,17.929467 50.658083,17.929583 50.658133,17.929717 50.658183,17.92985 50.658233,17.929967 50.6583,17.930067 50.658317,17.9302 50.658267,17.93035 50.658233,17.930517 50.658183,17.930683 50.65815,17.930833 50.658083,17.931 50.65805,17.931133 50.657983,17.931267 50.657933,17.9314 50.657883,17.931517 50.657817,17.93165 50.657733,17.931767 50.657683,17.931867 50.6576,17.93195 50.657533,17.932067 50.65745,17.932183 50.657383,17.9323 50.6573,17.9324 50.657217,17.932517 50.657133,17.93265 50.657083,17.932733 50.656983,17.93285 50.6569,17.932967 50.6568,17.933083 50.6567,17.9332 50.656617,17.933317 50.656533,17.933433 50.65645,17.93355 50.656367,17.933683 50.656283,17.9338 50.6562,17.933917 50.656133,17.934033 50.65605,17.93415 50.655967,17.934267 50.6559,17.934367 50.6558,17.934483 50.655733,17.934583 50.65565,17.9347 50.655567,17.934817 50.6555,17.934933 50.655433,17.93505 50.655383,17.9352 50.655333,17.935317 50.6553,17.93545 50.655283,17.935617 50.655217,17.935717 50.655133,17.9358 50.65505,17.935917 50.654967,17.936033 50.654883,17.936117 50.654817,17.9362 </googlemap> http://www.google.com/apis/maps/documentation/polylineutility.html


TEST GOOGLE MAPY

Przepis na zrobienie z danych gps kolorowej linii na mapie 
 
0. Zapisać dane do pliku tekstowego.

1. Zaimportować do excela plik txt z elementami rozdzielającymi: tabulatory i spacje

2. Wyczyścić pierwszą kolumnę.

3. W pierszej kolumnie wpisać formułę 
   (wzór jest w rozbiciu na parę linii ale ma być wpisany bez spacji!)

   =JEŻELI(CZY.PUSTA(B2);"6#B23AB64B";
    PODSTAW((PODSTAW(B2;"N";"")+ZAOKR(PODSTAW(C2;".";"")/60000;6));",";".")
    &","&
    PODSTAW((PODSTAW(D2;"E";"")+ZAOKR(PODSTAW(E2;".";"")/60000;6));",";"."))

4. Skopiować wynik z pierwszej kolumny i wstawić do mapy.

5. Zrobione :-)