Yer Analizleri'ni ayarlama

Places Insights, daha bilinçli iş kararları almak için önemli yer verileriyle ilgili istatistiksel analizlerle kendi verilerinizi geliştirmenize olanak tanır.

Places Insights verilerini sorgulayabilmek için önce Places Insights ürününe erişmek üzere kaydolmanız gerekir. Hesabınızın ilk katılım süreci tamamlandıktan sonra hedef ülkeniz için Places Insights veri kümesine abone olabilirsiniz.

Ön koşullar

Places Insights verilerine erişmek için:

1. Places Insights'a erişim isteğinde bulunmak için kaydolun.

2. Google Cloud hesabınız olmalıdır.

   Hesabınız yoksa yeni kullanıcılar için Cloud Console'da etkileşimli bir kurulum deneyimine yönlendiren Başlayın düğmesini tıklayın:

   Başlayın

3. BigQuery API'yi etkinleştirin. BigQuery'yi etkinleştirme talimatları ve BigQuery'yi kullanmayla ilgili bir eğitim için Google Cloud Console ile herkese açık bir veri kümesini sorgulama başlıklı makaleyi inceleyin.

4. Analytics Hub API'yi etkinleştirin.

5. Abone görevlerini gerçekleştirmek için hesabınızın Analiz merkezi Abonelik Sahibi (roles/analyticshub.subscriptionOwner) rolüne sahip olduğundan emin olun.

6. Veri kümeleri oluşturmak için hesabınızın BigQuery Kullanıcısı (roles/bigquery.user) rolüne sahip olduğundan emin olun.

7. Bağlı veri kümelerini görüntülemek ve sorgulamak için hesabınızın BigQuery Veri Görüntüleyici (roles/bigquery.dataViewer) rolüne sahip olduğundan emin olun.

   Daha fazla bilgi için Listelemeleri görüntüleme ve listelemelere abone olma başlıklı makaleyi inceleyin.

Places Insights veri kümesine abone olun

Places Insights verileri, aşağıdaki tabloda listelenen şehirler ve ülkeler için kullanılabilir. Her şehir ve ülkenin, ayrı ayrı abone olmanız gereken kendi veri listesi vardır.

Bir girişe abone olmak için:

1. Aşağıdaki tablodan ilgilendiğiniz şehir için abonelik bağlantısını seçin.

2. Google Cloud Console'da ilgili ülke için bir iletişim kutusu açılır. Örneğin, New York, ABD girişi için:

   

3. İletişim kutusunda Abone ol düğmesini seçin.

4. İletişim kutusunda Project (Proje), Linked dataset name (Bağlı veri kümesi adı), Primary region (Birincil bölge) ve Replica regions (Replika bölgeleri) bilgilerini onaylayın veya düzenleyin. Varsayılan giriş adını kullanmayı seçebilir veya isteğe bağlı olarak adı kendi adlandırma kuralınızı kullanacak şekilde ayarlayabilirsiniz.

   

5. Kaydet'i seçin.

6. İşlem tamamlandığında tablo aboneliği, Google Cloud Console'daki BigQuery Explorer panelinde görünür. SQL sorgularınızda verilere erişmek için aşağıda gösterilen tablo adını kullanın.

   

Kullanılabilir listelemeler

Aşağıdaki tablolarda, desteklenen şehirler ve ülkeler listelenmiş ve abone olmak için bağlantılar verilmiştir. Her şehir ve ülke için örnek verilere ve tam verilere abone olabilirsiniz.

İpucu: Gizlilik eşiklerini atlamak ve tam sayıları ve yer kimliklerini almak için veri kümesini doğrudan sorgulamak yerine Yer Sayısı işlevlerini kullanmanızı önemle tavsiye ederiz. Bir işlevi kullanmak için tablo referanslarındaki FUNCTION_NAME ifadesini seçtiğiniz işlevle (ör. PLACES_COUNT_V2 veya PLACES_COUNT_PER_H3) değiştirin.

Bir veya daha fazla listelemeye abone olduktan sonra, verileri etkileşimli bir ortamda çalışırken görmek için aşağıdaki not defterini çalıştırın.

Google Colab'de çalıştır

Kaynağı GitHub'da görüntüle

Not: Places Insights'ı ayarlarken bağlı veri kümesi adını değiştirdiyseniz bu varsayılan tablo adları yerine özel adınızı kullanın.

Örnek veri

Şehir, Ülke	Abonelik bağlantısı	Tablo adları
Buenos Aires, Arjantin	AR	places_insights___ar___sample.places_sample places_insights___ar___sample.places_sample_historical places_insights___ar___sample.types places_insights___ar___sample.FUNCTION_NAME
Sidney, Avustralya	AU	places_insights___au___sample.places_sample places_insights___au___sample.places_sample_historical places_insights___au___sample.brands places_insights___au___sample.types places_insights___au___sample.FUNCTION_NAME
Bad Gastein, Avusturya	AT	places_insights___at___sample.places_sample places_insights___at___sample.places_sample_historical places_insights___at___sample.types places_insights___at___sample.FUNCTION_NAME
Riffa, Bahreyn	BH	places_insights___bh___sample.places_sample places_insights___bh___sample.places_sample_historical places_insights___bh___sample.types places_insights___bh___sample.FUNCTION_NAME
Brüksel, Belçika	BE	places_insights___be___sample.places_sample places_insights___be___sample.places_sample_historical places_insights___be___sample.types places_insights___be___sample.FUNCTION_NAME
Sao Paulo, Brezilya	BR	places_insights___br___sample.places_sample places_insights___br___sample.places_sample_historical places_insights___br___sample.types places_insights___br___sample.FUNCTION_NAME
Filibe, Bulgaristan	BG	places_insights___bg___sample.places_sample places_insights___bg___sample.places_sample_historical places_insights___bg___sample.types places_insights___bg___sample.FUNCTION_NAME
Toronto, Kanada	CA	places_insights___ca___sample.places_sample places_insights___ca___sample.places_sample_historical places_insights___ca___sample.brands places_insights___ca___sample.types places_insights___ca___sample.FUNCTION_NAME
Santiago, Şili	CL	places_insights___cl___sample.places_sample places_insights___cl___sample.places_sample_historical places_insights___cl___sample.types places_insights___cl___sample.FUNCTION_NAME
Medellín, Kolombiya	CO	places_insights___co___sample.places_sample places_insights___co___sample.places_sample_historical places_insights___co___sample.types places_insights___co___sample.FUNCTION_NAME
Brno, Çekya	CZ	places_insights___cz___sample.places_sample places_insights___cz___sample.places_sample_historical places_insights___cz___sample.types places_insights___cz___sample.FUNCTION_NAME
Kopenhag, Danimarka	DK	places_insights___dk___sample.places_sample places_insights___dk___sample.places_sample_historical places_insights___dk___sample.types places_insights___dk___sample.FUNCTION_NAME
Kahire, Mısır	EG	places_insights___eg___sample.places_sample places_insights___eg___sample.places_sample_historical places_insights___eg___sample.types places_insights___eg___sample.FUNCTION_NAME
Helsinki, Finlandiya	FI	places_insights___fi___sample.places_sample places_insights___fi___sample.places_sample_historical places_insights___fi___sample.types places_insights___fi___sample.FUNCTION_NAME
Paris, Fransa	FR	places_insights___fr___sample.places_sample places_insights___fr___sample.places_sample_historical places_insights___fr___sample.types places_insights___fr___sample.FUNCTION_NAME
Berlin, Almanya	DE	places_insights___de___sample.places_sample places_insights___de___sample.places_sample_historical places_insights___de___sample.types places_insights___de___sample.FUNCTION_NAME
Atina, Yunanistan	GR	places_insights___gr___sample.places_sample places_insights___gr___sample.places_sample_historical places_insights___gr___sample.types places_insights___gr___sample.FUNCTION_NAME
Hong Kong, Hong Kong	HK	places_insights___hk___sample.places_sample places_insights___hk___sample.places_sample_historical places_insights___hk___sample.types places_insights___hk___sample.FUNCTION_NAME
Debrecen, Macaristan	HU	places_insights___hu___sample.places_sample places_insights___hu___sample.places_sample_historical places_insights___hu___sample.types places_insights___hu___sample.FUNCTION_NAME
Mumbai, Hindistan	IN	places_insights___in___sample.places_sample places_insights___in___sample.places_sample_historical places_insights___in___sample.types places_insights___in___sample.FUNCTION_NAME
Cakarta, Endonezya	No	places_insights___id___sample.places_sample places_insights___id___sample.places_sample_historical places_insights___id___sample.types places_insights___id___sample.FUNCTION_NAME
Cork, İrlanda	IE	places_insights___ie___sample.places_sample places_insights___ie___sample.places_sample_historical places_insights___ie___sample.types places_insights___ie___sample.FUNCTION_NAME
Tel Aviv-Yafo, İsrail	IL	places_insights___il___sample.places_sample places_insights___il___sample.places_sample_historical places_insights___il___sample.types places_insights___il___sample.FUNCTION_NAME
Roma, İtalya	IT	places_insights___it___sample.places_sample places_insights___it___sample.places_sample_historical places_insights___it___sample.types places_insights___it___sample.FUNCTION_NAME
Tokyo, Japonya	JP	places_insights___jp___sample.places_sample places_insights___jp___sample.places_sample_historical places_insights___jp___sample.types places_insights___jp___sample.FUNCTION_NAME
Busan, Güney Kore	KR	places_insights___kr___sample.places_sample places_insights___kr___sample.places_sample_historical places_insights___kr___sample.types places_insights___kr___sample.FUNCTION_NAME
Kuala Lumpur, Malezya	MY	places_insights___my___sample.places_sample places_insights___my___sample.places_sample_historical places_insights___my___sample.types places_insights___my___sample.FUNCTION_NAME
Mexico City, Meksika	MX	places_insights___mx___sample.places_sample places_insights___mx___sample.places_sample_historical places_insights___mx___sample.types places_insights___mx___sample.FUNCTION_NAME
Amsterdam, Hollanda	NL	places_insights___nl___sample.places_sample places_insights___nl___sample.places_sample_historical places_insights___nl___sample.types places_insights___nl___sample.FUNCTION_NAME
Wellington, Yeni Zelanda	NZ	places_insights___nz___sample.places_sample places_insights___nz___sample.places_sample_historical places_insights___nz___sample.types places_insights___nz___sample.FUNCTION_NAME
Oslo, Norveç	HAYIR	places_insights___no___sample.places_sample places_insights___no___sample.places_sample_historical places_insights___no___sample.types places_insights___no___sample.FUNCTION_NAME
Arequipa, Peru	PE	places_insights___pe___sample.places_sample places_insights___pe___sample.places_sample_historical places_insights___pe___sample.types places_insights___pe___sample.FUNCTION_NAME
Manila, Filipinler	PH	places_insights___ph___sample.places_sample places_insights___ph___sample.places_sample_historical places_insights___ph___sample.types places_insights___ph___sample.FUNCTION_NAME
Varşova, Polonya	PL	places_insights___pl___sample.places_sample places_insights___pl___sample.places_sample_historical places_insights___pl___sample.types places_insights___pl___sample.FUNCTION_NAME
Lizbon, Portekiz	PT	places_insights___pt___sample.places_sample places_insights___pt___sample.places_sample_historical places_insights___pt___sample.types places_insights___pt___sample.FUNCTION_NAME
Lusail, Katar	Kalite güvencesi	places_insights___qa___sample.places_sample places_insights___qa___sample.places_sample_historical places_insights___qa___sample.types places_insights___qa___sample.FUNCTION_NAME
Bükreş, Romanya	RO	places_insights___ro___sample.places_sample places_insights___ro___sample.places_sample_historical places_insights___ro___sample.types places_insights___ro___sample.FUNCTION_NAME
Cidde, Suudi Arabistan	SA	places_insights___sa___sample.places_sample places_insights___sa___sample.places_sample_historical places_insights___sa___sample.types places_insights___sa___sample.FUNCTION_NAME
Downtown Core, Singapur	SG	places_insights___sg___sample.places_sample places_insights___sg___sample.places_sample_historical places_insights___sg___sample.types places_insights___sg___sample.FUNCTION_NAME
Johannesburg, Güney Afrika	ZA	places_insights___za___sample.places_sample places_insights___za___sample.places_sample_historical places_insights___za___sample.types places_insights___za___sample.FUNCTION_NAME
Madrid, İspanya	ES	places_insights___es___sample.places_sample places_insights___es___sample.places_sample_historical places_insights___es___sample.types places_insights___es___sample.FUNCTION_NAME
Stockholm, İsveç	GD	places_insights___se___sample.places_sample places_insights___se___sample.places_sample_historical places_insights___se___sample.types places_insights___se___sample.FUNCTION_NAME
Zürih, İsviçre	CH	places_insights___ch___sample.places_sample places_insights___ch___sample.places_sample_historical places_insights___ch___sample.types places_insights___ch___sample.FUNCTION_NAME
Taipei, Tayvan	TW	places_insights___tw___sample.places_sample places_insights___tw___sample.places_sample_historical places_insights___tw___sample.types places_insights___tw___sample.FUNCTION_NAME
Chiang Mai, Tayland	TH	places_insights___th___sample.places_sample places_insights___th___sample.places_sample_historical places_insights___th___sample.types places_insights___th___sample.FUNCTION_NAME
Ankara, Türkiye	TR	places_insights___tr___sample.places_sample places_insights___tr___sample.places_sample_historical places_insights___tr___sample.types places_insights___tr___sample.FUNCTION_NAME
Şarika, Birleşik Arap Emirlikleri	AE	places_insights___ae___sample.places_sample places_insights___ae___sample.places_sample_historical places_insights___ae___sample.types places_insights___ae___sample.FUNCTION_NAME
Londra, İngiltere	GB	places_insights___gb___sample.places_sample places_insights___gb___sample.places_sample_historical places_insights___gb___sample.brands places_insights___gb___sample.types places_insights___gb___sample.FUNCTION_NAME
New York, ABD	US	places_insights___us___sample.places_sample places_insights___us___sample.places_sample_historical places_insights___us___sample.brands places_insights___us___sample.types places_insights___us___sample.FUNCTION_NAME
Hanoi, Vietnam	VN	places_insights___vn___sample.places_sample places_insights___vn___sample.places_sample_historical places_insights___vn___sample.types places_insights___vn___sample.FUNCTION_NAME

Tam veri

Ülke	Abonelik bağlantısı	Tablo adları
Arjantin	AR	places_insights___ar.places places_insights___ar.places_historical places_insights___ar.types places_insights___ar.FUNCTION_NAME
Avustralya	AU	places_insights___au.places places_insights___au.places_historical places_insights___au.brands places_insights___au.types places_insights___au.FUNCTION_NAME
Avusturya	AT	places_insights___at.places places_insights___at.places_historical places_insights___at.types places_insights___at.FUNCTION_NAME
Bahreyn	BH	places_insights___bh.places places_insights___bh.places_historical places_insights___bh.types places_insights___bh.FUNCTION_NAME
Belçika	BE	places_insights___be.places places_insights___be.places_historical places_insights___be.types places_insights___be.FUNCTION_NAME
Brezilya	BR	places_insights___br.places places_insights___br.places_historical places_insights___br.types places_insights___br.FUNCTION_NAME
Bulgaristan	BG	places_insights___bg.places places_insights___bg.places_historical places_insights___bg.types places_insights___bg.FUNCTION_NAME
Kanada	CA	places_insights___ca.places places_insights___ca.places_historical places_insights___ca.brands places_insights___ca.types places_insights___ca.FUNCTION_NAME
Şili	CL	places_insights___cl.places places_insights___cl.places_historical places_insights___cl.types places_insights___cl.FUNCTION_NAME
Kolombiya	CO	places_insights___co.places places_insights___co.places_historical places_insights___co.types places_insights___co.FUNCTION_NAME
Çekya	CZ	places_insights___cz.places places_insights___cz.places_historical places_insights___cz.types places_insights___cz.FUNCTION_NAME
Danimarka	DK	places_insights___dk.places places_insights___dk.places_historical places_insights___dk.types places_insights___dk.FUNCTION_NAME
Mısır	EG	places_insights___eg.places places_insights___eg.places_historical places_insights___eg.types places_insights___eg.FUNCTION_NAME
Finlandiya	FI	places_insights___fi.places places_insights___fi.places_historical places_insights___fi.types places_insights___fi.FUNCTION_NAME
Fransa	FR	places_insights___fr.places places_insights___fr.places_historical places_insights___fr.types places_insights___fr.FUNCTION_NAME
Almanya	DE	places_insights___de.places places_insights___de.places_historical places_insights___de.types places_insights___de.FUNCTION_NAME
Yunanistan	GR	places_insights___gr.places places_insights___gr.places_historical places_insights___gr.types places_insights___gr.FUNCTION_NAME
Hong Kong	HK	places_insights___hk.places places_insights___hk.places_historical places_insights___hk.types places_insights___hk.FUNCTION_NAME
Macaristan	HU	places_insights___hu.places places_insights___hu.places_historical places_insights___hu.types places_insights___hu.FUNCTION_NAME
Hindistan	IN	places_insights___in.places places_insights___in.places_historical places_insights___in.types places_insights___in.FUNCTION_NAME
Endonezya	No	places_insights___id.places places_insights___id.places_historical places_insights___id.types places_insights___id.FUNCTION_NAME
İrlanda	IE	places_insights___ie.places places_insights___ie.places_historical places_insights___ie.types places_insights___ie.FUNCTION_NAME
İsrail	IL	places_insights___il.places places_insights___il.places_historical places_insights___il.types places_insights___il.FUNCTION_NAME
İtalya	IT	places_insights___it.places places_insights___it.places_historical places_insights___it.types places_insights___it.FUNCTION_NAME
Japonya	JP	places_insights___jp.places places_insights___jp.places_historical places_insights___jp.types places_insights___jp.FUNCTION_NAME
Malezya	MY	places_insights___my.places places_insights___my.places_historical places_insights___my.types places_insights___my.FUNCTION_NAME
Meksika	MX	places_insights___mx.places places_insights___mx.places_historical places_insights___mx.types places_insights___mx.FUNCTION_NAME
Hollanda	NL	places_insights___nl.places places_insights___nl.places_historical places_insights___nl.types places_insights___nl.FUNCTION_NAME
Yeni Zelanda	NZ	places_insights___nz.places places_insights___nz.places_historical places_insights___nz.types places_insights___nz.FUNCTION_NAME
Norveç	HAYIR	places_insights___no.places places_insights___no.places_historical places_insights___no.types places_insights___no.FUNCTION_NAME
Peru	PE	places_insights___pe.places places_insights___pe.places_historical places_insights___pe.types places_insights___pe.FUNCTION_NAME
Filipinler	PH	places_insights___ph.places places_insights___ph.places_historical places_insights___ph.types places_insights___ph.FUNCTION_NAME
Polonya	PL	places_insights___pl.places places_insights___pl.places_historical places_insights___pl.types places_insights___pl.FUNCTION_NAME
Portekiz	PT	places_insights___pt.places places_insights___pt.places_historical places_insights___pt.types places_insights___pt.FUNCTION_NAME
Katar	Kalite güvencesi	places_insights___qa.places places_insights___qa.places_historical places_insights___qa.types places_insights___qa.FUNCTION_NAME
Romanya	RO	places_insights___ro.places places_insights___ro.places_historical places_insights___ro.types places_insights___ro.FUNCTION_NAME
Suudi Arabistan	SA	places_insights___sa.places places_insights___sa.places_historical places_insights___sa.types places_insights___sa.FUNCTION_NAME
Singapur	SG	places_insights___sg.places places_insights___sg.places_historical places_insights___sg.types places_insights___sg.FUNCTION_NAME
Güney Afrika	ZA	places_insights___za.places places_insights___za.places_historical places_insights___za.types places_insights___za.FUNCTION_NAME
Güney Kore	KR	places_insights___kr.places places_insights___kr.places_historical places_insights___kr.types places_insights___kr.FUNCTION_NAME
İspanya	ES	places_insights___es.places places_insights___es.places_historical places_insights___es.types places_insights___es.FUNCTION_NAME
İsveç	GD	places_insights___se.places places_insights___se.places_historical places_insights___se.types places_insights___se.FUNCTION_NAME
İsviçre	CH	places_insights___ch.places places_insights___ch.places_historical places_insights___ch.types places_insights___ch.FUNCTION_NAME
Tayvan	TW	places_insights___tw.places places_insights___tw.places_historical places_insights___tw.types places_insights___tw.FUNCTION_NAME
Tayland	TH	places_insights___th.places places_insights___th.places_historical places_insights___th.types places_insights___th.FUNCTION_NAME
Türkiye	TR	places_insights___tr.places places_insights___tr.places_historical places_insights___tr.types places_insights___tr.FUNCTION_NAME
Birleşik Arap Emirlikleri	AE	places_insights___ae.places places_insights___ae.places_historical places_insights___ae.types places_insights___ae.FUNCTION_NAME
İngiltere	GB	places_insights___gb.places places_insights___gb.places_historical places_insights___gb.brands places_insights___gb.types places_insights___gb.FUNCTION_NAME
Amerika Birleşik Devletleri	US	places_insights___us.places places_insights___us.places_historical places_insights___us.brands places_insights___us.types places_insights___us.FUNCTION_NAME
Vietnam	VN	places_insights___vn.places places_insights___vn.places_historical places_insights___vn.types places_insights___vn.FUNCTION_NAME