• 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

C

cicosz

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.

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 www.dosya.tc

Not: Dosya uzantısını site kabul etmediği için dosya tc serverına yükledim.
 
cicosz' Alıntı:
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 www.dosya.tc

Not: Dosya uzantısını site kabul etmediği için dosya tc serverına yükledim.
Genişletmek için tıkla ...
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.

www.banksinfo.com

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
 
Merhaba, yorumlarınız için teşekkür ederim. Hemen inceliyorum.
 
Cevap yazmak için giriş yap yada kayıt ol.
Geri
Üst