Kmz'deki Rotaya Belli Aralıklarla Belirteç Ekleme

[cicosz]

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.

Adsiz_Yol.kmz dosyasını indir - download

Adsiz_Yol.kmz dosyasını indir, download. Dosya.tc .Dosya Upload. Dosya Paylaş. Dosya Yükle

www.dosya.tc

Not: Dosya uzantısını site kabul etmediği için dosya tc serverına yükledim.

 

[tamer42]

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.

Adsiz_Yol.kmz dosyasını indir - download

Adsiz_Yol.kmz dosyasını indir, download. Dosya.tc .Dosya Upload. Dosya Paylaş. Dosya Yükle

www.dosya.tc

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?

 

[cicosz]

Merhabalar, Excel ile kmz üzerinde işlem yapmak istiyorum.
https://www.excel.web.tr/threads/renge-goere-harita-boelge-resim-tiklama-isaretleme.188938/ bu linkteki konuya benzer olarak düşünebiliriz.
Kmz'de sarı ile çizilmiş rotaya excel aracılığıyla belirlenen aralıklarda pinler atıp o pinlerin etiketine km değerlerini yazdırmayı istiyorum.

 

[Asri]

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.

<?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.

 

[Asri]

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.

How to map points from Excel in Google Earth Pro | Environmental Prose

Environmental professionals often use Google Earth as an inexpensive way to view and analyze data. In February, we wrote about the relaunch of Google Earth Pro as a FREE program available to anybody with a computer. One of the key advantages … Continue reading →

www.banksinfo.com

 

[cicosz]

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