Konfigurowanie funkcji Places Insights

Statystyki miejsc umożliwiają wzbogacanie własnych danych o statystyki dotyczące ciekawych miejsc, co pozwala podejmować bardziej świadome decyzje biznesowe.

Zanim zaczniesz wysyłać zapytania o dane Statystyk miejsc, musisz się zarejestrować, aby uzyskać dostęp do usługi Statystyki miejsc. Po wprowadzeniu konta możesz zasubskrybować zbiór danych Statystyki miejsc dla kraju docelowego.

Wymagania wstępne

Aby uzyskać dostęp do danych Statystyk miejsc, musisz:

1. Zarejestruj się, aby poprosić o dostęp do Statystyk miejsc.

2. mieć konto Google Cloud,

   Jeśli nie masz konta, kliknij przycisk Rozpocznij, który prowadzi do interaktywnego procesu konfiguracji w konsoli Cloud dla nowych użytkowników:

   Rozpocznij

3. Włącz interfejs BigQuery API. Instrukcje włączania BigQuery i samouczek dotyczący korzystania z BigQuery znajdziesz w artykule Wykonywanie zapytania na publicznym zbiorze danych za pomocą konsoli Google Cloud.

4. Włącz Analytics Hub API.

5. Upewnij się, że Twoje konto ma rolę Właściciel subskrypcji Analytics Hub (roles/analyticshub.subscriptionOwner), która umożliwia wykonywanie zadań subskrybenta.

6. Upewnij się, że Twoje konto ma rolę Użytkownik BigQuery (roles/bigquery.user), która umożliwia tworzenie zbiorów danych.

7. Upewnij się, że Twoje konto ma rolę BigQuery Data Viewer (roles/bigquery.dataViewer), aby wyświetlać połączone zbiory danych i wykonywać na nich zapytania.

   Więcej informacji znajdziesz w artykule Wyświetlanie i subskrybowanie ofert.

Subskrybowanie zbioru danych Statystyki miejsc

Dane Statystyk miejsc są dostępne dla miast i krajów wymienionych w tabeli poniżej. Każde miasto i kraj ma własną listę danych, którą musisz zasubskrybować osobno.

Aby zasubskrybować ofertę:

1. Wybierz link do subskrypcji dla interesującego Cię miasta z tabeli poniżej.

2. W konsoli Google Cloud otworzy się okno dotyczące tego kraju. Na przykład w przypadku wizytówki w Nowym Jorku w Stanach Zjednoczonych:

   

3. W oknie kliknij przycisk Subskrybuj.

4. W oknie dialogowym potwierdź lub zmodyfikuj Projekt, Nazwę połączonego zbioru danych, Region główny i Regiony replik. Możesz użyć domyślnej nazwy strony aplikacji lub opcjonalnie ustawić nazwę zgodnie z własną konwencją nazewnictwa.

   

5. Kliknij Zapisz.

6. Po zakończeniu subskrypcja tabeli pojawi się w panelu Eksplorator BigQuery w konsoli Google Cloud. Aby uzyskać dostęp do danych, w zapytaniach SQL używaj nazwy tabeli podanej poniżej.

   

Dostępne informacje o produktach

W poniższych tabelach znajdziesz listę obsługiwanych miast i krajów oraz linki do subskrypcji. Możesz zasubskrybować dane próbkowane i pełne dane dla każdego miasta i kraju.

Wskazówka: aby pominąć progi prywatności i uzyskać dokładne liczby oraz identyfikatory miejsc, zdecydowanie zalecamy używanie funkcji liczby miejsc zamiast bezpośredniego wysyłania zapytań do zbioru danych. Aby użyć funkcji, zastąp FUNCTION_NAME w odwołaniach do tabeli wybraną funkcją (np. PLACES_COUNT_V2 lub PLACES_COUNT_PER_H3).

Po zasubskrybowaniu co najmniej 1 zestawienia uruchom ten notatnik, aby zobaczyć dane w działaniu w interaktywnym środowisku.

Uruchom w Google Colab

Wyświetl źródło na GitHubie

Uwaga: jeśli podczas konfigurowania Statystyk miejsc nazwa połączonego zbioru danych została zmieniona, użyj nazwy niestandardowej zamiast domyślnych nazw tabel.

Przykładowe dane

Miasto, kraj	Link do subskrypcji	Nazwy tabel
Buenos Aires, Argentyna	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
Sydney, Australia	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, Austria	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, Bahrajn	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
Bruksela, Belgia	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
São Paulo, Brazylia	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
Płowdiw, Bułgaria	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, Chile	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, Kolumbia	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, Czechy	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
Kopenhaga, Dania	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
Kair, Egipt	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, Finlandia	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
Paryż, Francja	Francja	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, Niemcy	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
Ateny, Grecja	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
Hongkong, Hongkong	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
Debreczyn, Węgry	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
Bombaj, Indie	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
Dżakarta, Indonezja	Identyfikator	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, Irlandia	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 Awiw-Jafa, Izrael	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
Rzym, Włochy	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
Tokio, Japonia	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, Korea Południowa	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, Malezja	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
Meksyk (miasto), Meksyk	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, Holandia	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, Nowa Zelandia	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, Norwegia	NIE	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, Filipiny	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
Warszawa, Polska	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
Lizbona, Portugalia	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
Lusajl, Katar	QA	places_insights___qa___sample.places_sample places_insights___qa___sample.places_sample_historical places_insights___qa___sample.types places_insights___qa___sample.FUNCTION_NAME
Bukareszt, Rumunia	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
Dżudda, Arabia Saudyjska	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, Republika Południowej Afryki	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
Madryt, Hiszpania	Hiszpania	places_insights___es___sample.places_sample places_insights___es___sample.places_sample_historical places_insights___es___sample.types places_insights___es___sample.FUNCTION_NAME
Sztokholm, Szwecja	SE	places_insights___se___sample.places_sample places_insights___se___sample.places_sample_historical places_insights___se___sample.types places_insights___se___sample.FUNCTION_NAME
Zurych, Szwajcaria	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
Tajpej, Tajwan	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, Tajlandia	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, Turcja	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
Szardża, Zjednoczone Emiraty Arabskie	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
Londyn, Wielka Brytania	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
Nowy Jork, Stany Zjednoczone	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, Wietnam	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

Pełne dane

Kraj	Link do subskrypcji	Nazwy tabel
Argentyna	AR	places_insights___ar.places places_insights___ar.places_historical places_insights___ar.types places_insights___ar.FUNCTION_NAME
Australia	AU	places_insights___au.places places_insights___au.places_historical places_insights___au.brands places_insights___au.types places_insights___au.FUNCTION_NAME
Austria	AT	places_insights___at.places places_insights___at.places_historical places_insights___at.types places_insights___at.FUNCTION_NAME
Bahrajn	BH	places_insights___bh.places places_insights___bh.places_historical places_insights___bh.types places_insights___bh.FUNCTION_NAME
Belgia	BE	places_insights___be.places places_insights___be.places_historical places_insights___be.types places_insights___be.FUNCTION_NAME
Brazylia	BR	places_insights___br.places places_insights___br.places_historical places_insights___br.types places_insights___br.FUNCTION_NAME
Bułgaria	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
Chile	CL	places_insights___cl.places places_insights___cl.places_historical places_insights___cl.types places_insights___cl.FUNCTION_NAME
Kolumbia	CO	places_insights___co.places places_insights___co.places_historical places_insights___co.types places_insights___co.FUNCTION_NAME
Czechy	CZ	places_insights___cz.places places_insights___cz.places_historical places_insights___cz.types places_insights___cz.FUNCTION_NAME
Dania	DK	places_insights___dk.places places_insights___dk.places_historical places_insights___dk.types places_insights___dk.FUNCTION_NAME
Egipt	EG	places_insights___eg.places places_insights___eg.places_historical places_insights___eg.types places_insights___eg.FUNCTION_NAME
Finlandia	FI	places_insights___fi.places places_insights___fi.places_historical places_insights___fi.types places_insights___fi.FUNCTION_NAME
Francja	Francja	places_insights___fr.places places_insights___fr.places_historical places_insights___fr.types places_insights___fr.FUNCTION_NAME
Niemcy	DE	places_insights___de.places places_insights___de.places_historical places_insights___de.types places_insights___de.FUNCTION_NAME
Grecja	GR	places_insights___gr.places places_insights___gr.places_historical places_insights___gr.types places_insights___gr.FUNCTION_NAME
Hongkong	HK	places_insights___hk.places places_insights___hk.places_historical places_insights___hk.types places_insights___hk.FUNCTION_NAME
Węgry	HU	places_insights___hu.places places_insights___hu.places_historical places_insights___hu.types places_insights___hu.FUNCTION_NAME
Indie	IN	places_insights___in.places places_insights___in.places_historical places_insights___in.types places_insights___in.FUNCTION_NAME
Indonezja	Identyfikator	places_insights___id.places places_insights___id.places_historical places_insights___id.types places_insights___id.FUNCTION_NAME
Irlandia	IE	places_insights___ie.places places_insights___ie.places_historical places_insights___ie.types places_insights___ie.FUNCTION_NAME
Izrael	IL	places_insights___il.places places_insights___il.places_historical places_insights___il.types places_insights___il.FUNCTION_NAME
Włochy	IT	places_insights___it.places places_insights___it.places_historical places_insights___it.types places_insights___it.FUNCTION_NAME
Japonia	JP	places_insights___jp.places places_insights___jp.places_historical places_insights___jp.types places_insights___jp.FUNCTION_NAME
Malezja	MY	places_insights___my.places places_insights___my.places_historical places_insights___my.types places_insights___my.FUNCTION_NAME
Meksyk	MX	places_insights___mx.places places_insights___mx.places_historical places_insights___mx.types places_insights___mx.FUNCTION_NAME
Holandia	NL	places_insights___nl.places places_insights___nl.places_historical places_insights___nl.types places_insights___nl.FUNCTION_NAME
Nowa Zelandia	NZ	places_insights___nz.places places_insights___nz.places_historical places_insights___nz.types places_insights___nz.FUNCTION_NAME
Norwegia	NIE	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
Filipiny	PH	places_insights___ph.places places_insights___ph.places_historical places_insights___ph.types places_insights___ph.FUNCTION_NAME
Polska	PL	places_insights___pl.places places_insights___pl.places_historical places_insights___pl.types places_insights___pl.FUNCTION_NAME
Portugalia	PT	places_insights___pt.places places_insights___pt.places_historical places_insights___pt.types places_insights___pt.FUNCTION_NAME
Katar	QA	places_insights___qa.places places_insights___qa.places_historical places_insights___qa.types places_insights___qa.FUNCTION_NAME
Rumunia	RO	places_insights___ro.places places_insights___ro.places_historical places_insights___ro.types places_insights___ro.FUNCTION_NAME
Arabia Saudyjska	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
Republika Południowej Afryki	ZA	places_insights___za.places places_insights___za.places_historical places_insights___za.types places_insights___za.FUNCTION_NAME
Korea Południowa	KR	places_insights___kr.places places_insights___kr.places_historical places_insights___kr.types places_insights___kr.FUNCTION_NAME
Hiszpania	Hiszpania	places_insights___es.places places_insights___es.places_historical places_insights___es.types places_insights___es.FUNCTION_NAME
Szwecja	SE	places_insights___se.places places_insights___se.places_historical places_insights___se.types places_insights___se.FUNCTION_NAME
Szwajcaria	CH	places_insights___ch.places places_insights___ch.places_historical places_insights___ch.types places_insights___ch.FUNCTION_NAME
Tajwan	TW	places_insights___tw.places places_insights___tw.places_historical places_insights___tw.types places_insights___tw.FUNCTION_NAME
Tajlandia	TH	places_insights___th.places places_insights___th.places_historical places_insights___th.types places_insights___th.FUNCTION_NAME
Turcja	TR	places_insights___tr.places places_insights___tr.places_historical places_insights___tr.types places_insights___tr.FUNCTION_NAME
Zjednoczone Emiraty Arabskie	AE	places_insights___ae.places places_insights___ae.places_historical places_insights___ae.types places_insights___ae.FUNCTION_NAME
Wielka Brytania	GB	places_insights___gb.places places_insights___gb.places_historical places_insights___gb.brands places_insights___gb.types places_insights___gb.FUNCTION_NAME
Stany Zjednoczone	US	places_insights___us.places places_insights___us.places_historical places_insights___us.brands places_insights___us.types places_insights___us.FUNCTION_NAME
Wietnam	VN	places_insights___vn.places places_insights___vn.places_historical places_insights___vn.types places_insights___vn.FUNCTION_NAME