• DİKKAT

    DOSYA İndirmek/Yüklemek için ÜCRETLİ ALTIN ÜYELİK Gereklidir!
    Altın Üyelik Hakkında Bilgi

Kmz'deki Rotaya Belli Aralıklarla Belirteç Ekleme

Katılım
30 Mart 2010
Mesajlar
240
Excel Vers. ve Dili
2007,2010,2013
Merhaba, kmz dosyasında elle çizilmiş bir rotam var. Bu rota üzerine başlangıcı 0.km olacak şekilde 1'er km arayla km bilgisini işlemek istiyorum.
Excel ile nasıl yapacağım konusunda fikirlerinize ihtiyacım var. Şimdiden teşekkürler.


Not: Dosya uzantısını site kabul etmediği için dosya tc serverına yükledim.
 
Merhaba, kmz dosyasında elle çizilmiş bir rotam var. Bu rota üzerine başlangıcı 0.km olacak şekilde 1'er km arayla km bilgisini işlemek istiyorum.
Excel ile nasıl yapacağım konusunda fikirlerinize ihtiyacım var. Şimdiden teşekkürler.


Not: Dosya uzantısını site kabul etmediği için dosya tc serverına yükledim.
Merhaba,
ekte sunulan bir KMZ dosyası, siz bu güzergahı Excel dosyası üzerinde mi yapmak istiyordunuz?
 
Merhaba,

Excel den google earth e erişim olacağını sanmıyorum ancak google map e yapılabilir.
KMZ olarak araştırdığımda genelde excel deki datalar ile KMZ dosya oluşturma ile ilgili çalışmalar çıkıyor.

KMZ dosya yapısını incelediğimde koordinatlar görülebiliyor
Belkide istediğiniz şeyi bu XML dosya üzerinde yapıp google earth e yükleyebilirsiniz.

Nasıl yapılır derseniz bilemiyorum ama bir fikir. :)

Kod:
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2" xmlns:kml="http://www.opengis.net/kml/2.2" xmlns:atom="http://www.w3.org/2005/Atom">
<Document>
    <name>Adsız Yol.kmz</name>
    <StyleMap id="m_ylw-pushpin">
        <Pair>
            <key>normal</key>
            <styleUrl>#s_ylw-pushpin</styleUrl>
        </Pair>
        <Pair>
            <key>highlight</key>
            <styleUrl>#s_ylw-pushpin_hl</styleUrl>
        </Pair>
    </StyleMap>
    <Style id="s_ylw-pushpin_hl">
        <IconStyle>
            <scale>1.3</scale>
            <Icon>
                <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>
            </Icon>
            <hotSpot x="20" y="2" xunits="pixels" yunits="pixels"/>
        </IconStyle>
        <LineStyle>
            <color>ff00ffff</color>
            <width>3</width>
        </LineStyle>
    </Style>
    <Style id="s_ylw-pushpin">
        <IconStyle>
            <scale>1.1</scale>
            <Icon>
                <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>
            </Icon>
            <hotSpot x="20" y="2" xunits="pixels" yunits="pixels"/>
        </IconStyle>
        <LineStyle>
            <color>ff00ffff</color>
            <width>3</width>
        </LineStyle>
    </Style>
    <Placemark>
        <name>Adsız Yol</name>
        <styleUrl>#m_ylw-pushpin</styleUrl>
        <LineString>
            <tessellate>1</tessellate>
            <coordinates>
                33.47980438903123,39.82789785771246,0 33.48043086857647,39.82557327657769,0 33.48037864368671,39.82326443234814,0 33.48066372349328,39.82092769490671,0 33.48113585405167,39.81891437427754,0 33.48230959709223,39.81772025443561,0 33.4842085610345,39.81653686953377,0 33.48623217708121,39.815651544734,0 33.4885276163922,39.81463521549482,0 33.49018747392188,39.81367240428732,0 33.4919577830399,39.81196116679048,0 33.49310077042846,39.81020327782725,0 33.49363833994262,39.80813511561287,0 33.49390186658721,39.8060286516223,0 33.49333819275193,39.80408941136398,0 33.49234719590318,39.80148967039994,0 33.49141985647139,39.79912029417,0 33.4902652821488,39.79728703666719,0 33.48887258210699,39.79394344948581,0 33.48737422593543,39.79031280409147,0 33.48591869782771,39.78630106584392,0 33.48432402534855,39.78277100735697,0 33.48327380091749,39.78081119450037,0 33.48251275042406,39.77871128622738,0 33.48168360380372,39.77673096653419,0 33.48184083331627,39.77528674419076,0 33.48258155063675,39.77421325801174,0 33.48385421759053,39.77319907425625,0 33.48583241314859,39.7713780641378,0 33.48741526996935,39.76961543554416,0 33.48877769778571,39.76791624308647,0 33.49079057528723,39.76660307222943,0 33.49311473646996,39.76561508618865,0 33.49615308857239,39.76510936231958,0 33.49890130882022,39.76481287816768,0 33.50212360993036,39.76452002146345,0 33.50433505504,39.76385343379553,0 33.50655267347696,39.7628752604259,0 33.50871171021227,39.76138092178807,0 33.51006344273759,39.75937414467202,0 33.51197415424718,39.75577833361724,0 33.51333543593983,39.75279854530287,0 33.51475149988238,39.74980004568337,0 33.51480880171114,39.74828302203829,0 33.51487750545347,39.74646373541232,0 33.51561869801486,39.74471309229958,0 33.51728296389151,39.7433898049669,0 33.51972689793259,39.74269064942462,0 33.52269529988761,39.74225170568579,0 33.52518042142067,39.74226856546874,0 33.52807363685648,39.7418806585981,0 33.53076261082175,39.74128876038981,0 33.5328536258908,39.7405292385367,0 33.53422845038217,39.73952352193328,0 33.53648319752231,39.73752036302658,0 33.54027807401274,39.73449466952259,0 33.54368316907072,39.731656481586,0 33.54932999991408,39.72733326234986,0 33.55151651621252,39.72618018209812,0 33.55400636203973,39.72574107466959,0 33.55629135749238,39.72530137365543,0 33.55858361562333,39.72430890202181,0 33.56060647292354,39.72296825933976,0 33.56209769152473,39.72168063434943,0 33.56363782534525,39.71960696204594,0 33.56434346599119,39.71759697930791,0 33.56532044055544,39.71549919728284,0 33.56635319308495,39.71352244411092,0 33.56782968870456,39.71213173438015,0 33.56956627170312,39.71080157967241,0 33.57195756764482,39.70978977448713,0 33.57495260814085,39.70842866511479,0 33.58202552160095,39.70512881881499,0 33.5834065571722,39.70435248545216,0 33.58451912808517,39.70326436699904,0 33.58549166751926,39.70217991317276,0 33.5863310863013,39.70078967389905,0 33.58894141629208,39.69645631692863,0 33.59055323381753,39.69336698298251,0 33.59235609750401,39.68993388995448,0 33.594824294749,39.68594910355996,0 33.59705544400746,39.68231793892392,0 33.59868354542796,39.67909761706879,0 33.60026149673498,39.67671056840021,0 33.60198426615682,39.67506368012879,0 33.60507289340458,39.67350707814932,0 33.60794618426742,39.67252700130722,0 33.61027065326246,39.67091053187121,0 33.61204605823126,39.66845963078288,0 33.6138982294502,39.66575546375361,0 33.6151915734253,39.66293954635633,0 33.61600471679438,39.65937354309747,0 33.61727676946014,39.65674339708375,0 33.61930021592918,39.65384702968522,0 33.62263926098944,39.65018471252375,0 33.62615174070663,39.64556699395592,0 33.63108023567543,39.64040487670089,0 33.63683913203733,39.6336310289452,0 33.64572858807736,39.62508651082093,0 33.65259486895036,39.61896099158966,0 33.66497942362706,39.60695194104527,0 33.66982214496056,39.60261643853737,0 33.6720793041988,39.60044149339468,0 33.67527383827348,39.59896619379663,0 33.67880595105342,39.59750146069147,0 33.68392509278797,39.59565308522876,0 33.68874321359744,39.5943928106619,0 33.69296182855758,39.59244696544447,0 33.69669483300989,39.59051345396848,0 33.70077697512955,39.58818305901703,0 33.70454745437284,39.58600898851971,0 33.71027766524843,39.58307500490501,0 33.71633276612319,39.57955238019488,0 33.72192201424239,39.57643084610659,0 33.72644093822657,39.57334174173943,0
            </coordinates>
        </LineString>
    </Placemark>
</Document>
</kml>


Saygılarımla.
 
Bu konuyu da inceleyiniz.
Belirteç konulacak koordinatları kmz dosyasından alıp bu linkte olduğu gibi hazırlayın.
Google earth e yükleyin. İlgili koordinatlara belirteçleri ekleyecektir diye düşünüyorum.

 
Merhaba, yorumlarınız için teşekkür ederim. Hemen inceliyorum.
 
Geri
Üst