{"id":9139,"date":"2021-04-19T22:48:00","date_gmt":"2021-04-19T14:48:00","guid":{"rendered":"https:\/\/masterconcept.ai\/?p=9139"},"modified":"2025-05-06T13:10:55","modified_gmt":"2025-05-06T05:10:55","slug":"bigquery-gis-analysis","status":"publish","type":"post","link":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/","title":{"rendered":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 &#8211; \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">BigQuery GIS \u70ba Google BigQuery \u670d\u52d9\u4e2d\u6240\u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\uff08Geospatial Information Systems, GIS\uff09\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\uff0c\u7c21\u7a31 <strong>BigQuery GIS<\/strong>\uff0c\u9996\u5ea6\u66dd\u5149\u65bc 2018 \u5e74\u767c\u4f48\u7684 beta \u6e2c\u8a66\u7248\u3002\u7576\u6642 BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u96f2\u7aef MPP\uff08<a href=\"https:\/\/en.wikipedia.org\/wiki\/Massively_parallel\">Massively Parallel Processing<\/a>, \u5927\u898f\u6a21\u5e73\u884c\u8655\u7406\u904b\u7b97\u6280\u8853\uff09\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc&#8230;\u7b49\uff09\u4e5f\u6210\u70ba BigQuery \u9810\u8a2d\u652f\u63f4\u7684<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/data-types#geography-type\">\u8cc7\u6599\u683c\u5f0f<\/a>\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\uff0c\u5982\u9ede\u3001\u7dda\u3001\u9762\u7b49\u76f8\u95dc\u8cc7\u8a0a\uff0c\u9032\u884c\u8cc7\u6599\u5206\u6790\u3001\u8f49\u63db\uff0c\u4ee5\u9032\u4e00\u6b65\u7372\u53d6\u6df1\u5165\u898b\u89e3\u3002\u800c\u5728 2019 \u5e74\uff0cBigQuery GIS \u6b63\u5f0f\u5ba3\u5e03\u91cb\u51fa\u4e86 GA \u7248\uff0c\u5373\u5b98\u65b9\u6b63\u5f0f\u516c\u958b\u767c\u884c\u7248\u672c\u3002<\/p>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u4eca\uff0c\u5730\u7406\u7a7a\u9593\u8207\u4f4d\u7f6e\u8cc7\u8a0a\u5728\u8cc7\u6599\u5206\u6790\u4e2d\u975e\u5e38\u5e38\u898b\uff0c\u6839\u64da Google \u7d71\u8a08\uff0c\u5728 Github \u4e2d\u6709 9% \u7684 SQL \u6a94\u6848\u6703\u57f7\u884c\u7a7a\u9593\u67e5\u8a62\uff0c\u5176\u5206\u6790\u7d50\u679c\u66f4\u8207\u4f01\u696d\u7684\u5546\u696d\u6c7a\u7b56\u606f\u606f\u76f8\u95dc\uff0c\u4f8b\u5982\uff1a\u300c\u5546\u5e97\u958b\u5728\u54ea\u500b\u4f4d\u7f6e\u80fd\u5438\u5f15\u5230\u6700\u591a\u4eba\u6d41\uff1f\u300d\u3001\u300c \u6211\u7684\u5305\u88f9\u6703\u6e96\u6642\u5230\u9054\u55ce\uff1f\u300d \u6216\u300c\u6211\u5011\u61c9\u8a72\u5c07\u4fc3\u92b7\u512a\u60e0\u5238\u63a8\u64ad\u7d66\u8ab0\uff1f\u300d\u7b49\uff0c\u6578\u64da\u5206\u6790\u4eba\u54e1\u53ef\u4ee5\u900f\u904e BigQuery GIS \u8f15\u9b06\u57f7\u884c\u7a7a\u9593\u8cc7\u8a0a\u76f8\u95dc\u7684\u8cc7\u6599\u5206\u6790\u64cd\u4f5c\uff0c\u66f4\u8f15\u6613\u5730\u505a\u51fa\u6578\u64da\u5c0e\u5411\u7684\u6c7a\u7b56\u3002<\/p>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u9664\u4e86\u80fd\u5728 <a href=\"https:\/\/masterconcept.ai\/zh-hant\/google-cloud-platform\/\" target=\"_blank\" rel=\"noopener\">BigQuery<\/a> \u904b\u7528 GIS \u7684\u5404\u5f0f\u8a9e\u6cd5\uff0cBigQuery GIS \u9084\u63d0\u4f9b\u4e86 <a href=\"https:\/\/bigquerygeoviz.appspot.com\/\">BigQuery Geo Viz<\/a> &#8212; \u9019\u662f\u4e00\u5957\u7531 Google \u63a8\u51fa\u7684\u514d\u8cbb\u958b\u6e90\u5de5\u5177\uff0c\u8b93\u4f7f\u7528\u8005\u53ef\u5c07\u900f\u904e BigQuery \u8a9e\u6cd5\u67e5\u8a62\u7684\u904b\u7b97\u7d50\u679c\u65bc\u5730\u5716\u4e0a\u5feb\u901f\u5730\u8996\u89ba\u5316\u5c55\u793a\uff0c\u4e26\u652f\u63f4\u8a2d\u5b9a\u5728\u5730\u5716\u5448\u73fe\u4e0a\u9ede\uff0f\u7dda\uff0f\u9762\u7b49\u4e0d\u540c\u6a23\u5f0f\u3002<\/p>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" class=\"lazyload\" data-src=\"https:\/\/miro.medium.com\/max\/1400\/0*-k7iVo89OYpu-YS9.GIF\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" alt=\"BigQuery GIS demo 1\" width=\"600\" height=\"400\"\/><noscript><img decoding=\"async\" src=\"https:\/\/miro.medium.com\/max\/1400\/0*-k7iVo89OYpu-YS9.GIF\" alt=\"BigQuery GIS demo 1\" width=\"600\" height=\"400\"><\/noscript><figcaption>\u4f7f\u7528 BigQuery Geo Viz \u5c55\u793a\u66fc\u54c8\u9813Citybike\u516c\u5171\u81ea\u884c\u8eca\u51fa\u79df\u7ad9\u9ede\u4f4d\u8207\u53ef\u79df\u501f\u8eca\u8f1b\u6578\uff0c\u4ee5\u85cd\u8272\u8868\u793a\u53ef\u79df\u501f\u8eca\u8f1b\u6578\u8f03\u591a\u3001\u7d2b\u8272\u8f03\u5c11\uff0c\u4ee5\u5713\u5708\u76f4\u5f91\u5927\u5c0f\u8868\u793a\u81ea\u884c\u8eca\u7ad9\u8eca\u8f1b\u7e3d\u5bb9\u91cf<\/figcaption><\/figure>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img decoding=\"async\" class=\"lazyload\" data-src=\"https:\/\/storage.googleapis.com\/gweb-cloudblog-publish\/images\/BigQuery_GIS_functions.max-700x700.png\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" alt=\"BigQuery GIS demo 2\" width=\"553\" height=\"350\"\/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/gweb-cloudblog-publish\/images\/BigQuery_GIS_functions.max-700x700.png\" alt=\"BigQuery GIS demo 2\" width=\"553\" height=\"350\"><\/noscript><figcaption>\u4f7f\u7528BigQuery GIS\u7e6a\u88fd\u98b6\u98a8\u884c\u7d93\u8def\u5f91\uff0c\u8a73\u8acb\u53c3\u898b<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/gis-tutorial-hurricane\">Google\u6559\u5b78\u8aaa\u660e<\/a><\/figcaption><\/figure>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">BigQuery GIS \u652f\u63f4\u9ede\uff08Point\uff09\u3001\u7dda\uff08Linestring\uff09\u3001\u9762\uff08Polygon\uff09\u7684 GIS \u7a7a\u9593\u8cc7\u6599\u683c\u5f0f\uff0c\u5176\u529f\u80fd\u8207\u50b3\u7d71\u4f7f\u7528 PostGIS \u7684\u7d93\u9a57\u975e\u5e38\u76f8\u4f3c\uff0c\u5747\u9075\u5faa\u4e14\u7b26\u5408 SQL MM\uff08ISO \u6a19\u6e96\uff09\uff1bBigQuery GIS \u6240\u63d0\u4f9b<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/geography_functions\">\u7a7a\u9593\u5206\u6790\u529f\u80fd<\/a>\u7bc4\u7587\uff0c\u53c3\u898b\u4e0b\u8868\uff1a<\/p>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"lazyload\" data-src=\"https:\/\/storage.googleapis.com\/gweb-cloudblog-publish\/images\/BQFnTypes.max-1200x1200.png\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" alt=\"BigQuery GIS table\n\" width=\"600\" height=\"519\"\/><noscript><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/storage.googleapis.com\/gweb-cloudblog-publish\/images\/BQFnTypes.max-1200x1200.png\" alt=\"BigQuery GIS table\n\" width=\"600\" height=\"519\"><\/noscript><\/figure>\n\n\n\n<div style=\"height:47px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u601d\u60f3\u79d1\u6280 \u5be6\u969b\u6e2c\u8a66\u6848\u4f8b<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-size:25px\"><strong><span style=\"color:#0e2240\" class=\"has-inline-color\">#Demo\u7bc4\u4f8b 1<\/span><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u516c\u958b\u8cc7\u6599\u96c6public dataset<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>bigquery-public-data.geo_us_boundaries.zip_codes (\u7f8e\u570b\u90f5\u905e\u5340\u865f\u5206\u5340)<\/li><li>bigquery-public-data.census_bureau_usa.population_by_zip_2010 (\u5168\u7f8e2010\u5e74\u4eba\u53e3\u7d71\u8a08\u6578\u64da)<\/li><\/ul>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6e2c\u8a66\u60c5\u5883<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u4f7f\u7528\u300c\u7a7a\u9593\u9023\u7d50(spatial joins)\u300d\u8a9e\u6cd5\uff0c\u5c07\u4eba\u53e3\u7d71\u8a08\u6578\u64dajoin\u52a0\u5165\u81f3\u90f5\u905e\u5340\u865f\u5206\u5340\u4e2d\uff0c\u4e26\u5f9e\u4e2d\u9078\u51fa\u7d10\u7d04\u5e02\u7bc4\u570d\u8cc7\u6599\uff0c\u65bcBigQuery Geo Viz\u4e0a\u9032\u884c\u8996\u89ba\u5316\u5c55\u793a<\/li><\/ul>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u8a9e\u6cd5<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT\u00a0\n    zip_code, city, county, state_name, zip_code_geom, zipcode, population\nFROM\n    `bigquery-public-data.geo_us_boundaries.zip_codes`\n    join `bigquery-public-data.census_bureau_usa.population_by_zip_2010` on zip_code = zipcode \n    where city = 'New York city'=<\/code><\/pre>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>BigQuery Geo Viz \u7d50\u679c<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"\u601d\u60f3\u79d1\u6280 BigQuery GIS Demo\u7bc4\u4f8b 1\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/f0TZPevEPws?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div style=\"height:41px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\" style=\"font-size:25px\"><strong>#Demo\u7bc4\u4f8b 2<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u516c\u958b\u8cc7\u6599\u96c6 Public Dataset<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>bigquery-public-data.geo_us_boundaries.zip_codes (\u7f8e\u570b\u90f5\u905e\u5340\u865f\u5206\u5340)<\/li><li>bigquery-public-data.new_york_citibike.citibike_stations (\u7d10\u7d04citybike\u516c\u5171\u8173\u8e0f\u8eca\u79df\u501f\u7ad9)<\/li><\/ul>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6e2c\u8a66\u60c5\u5883<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u4f7f\u7528\u300cST_DWithin\u300d\u7a7a\u9593\u74b0\u57df\u5206\u6790\u8a9e\u6cd5\uff0c\u9078\u53d6\u90f5\u905e\u5340\u865f\u70ba\u300c10026\u300d\u6216\u300c10029\u300d\u5169\u5340\u3001\u4ee5\u53ca\u8ddd\u96e2\u6b64\u4e8c\u5340\u57df\u5916\u570d300\u516c\u5c3a\u5167\u4e4b\u6240\u6709citybike\u516c\u5171\u8173\u8e0f\u8eca\u79df\u501f\u7ad9\uff0c\u65bcBigQuery Geo Viz\u4e0a\u8996\u89ba\u5316\u5c55\u793a\uff0c\u52d5\u614b\u589e\u6e1b\u74b0\u57df\u7bc4\u570d\u89c0\u5bdf\u9078\u53d6\u7d50\u679c\u8b8a\u5316<\/li><\/ul>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u8a9e\u6cd5<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH zipcode AS (\n    SELECT zip_code_geom AS polygon\n    FROM `bigquery-public-data.geo_us_boundaries.zip_codes`\n    WHERE zip_code = '10026' or zip_code = '10029'\n),\nstations AS (\n    SELECT\n       name, num_bikes_available, latitude, longitude,\n       ST_GeogPoint(longitude, latitude) coordinates,\n    FROM\n       `bigquery-public-data.new_york_citibike.citibike_stations` as cbs,\n       zipcode\n    WHERE ST_DWithin(ST_GeogPoint(longitude, latitude), zipcode.polygon, 300)\n)\nSELECT * from stations<\/code><\/pre>\n\n\n\n<div style=\"height:35px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>BigQuery Geo Viz \u7d50\u679c<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"\u601d\u60f3\u79d1\u6280 BigQuery GIS Demo\u7bc4\u4f8b 2\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/C1ETX353DQ4?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div style=\"height:43px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u66f4\u591a\u4ecb\u7d39\u5f71\u7247<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.youtube.com\/watch?v=Mho9OjFQWbA\">How Geotab Drives Smart City Innovation, Using BigQuery<\/a><br>Google Partner &#8211; Geotab\uff0c\u65bc Cloud Next &#8217;18 \u5927\u6703\u4e2d\uff0c\u5c55\u793a\u5982\u4f55\u4f7f\u7528 BigQueryGIS \u904b\u7528\u65bc\u8eca\u8f09\u7cfb\u7d71\u56de\u50b3\u4e4b GPS \u6578\u64da\uff0c\u63d0\u4f9b\u6821\u5712\u9644\u8fd1\u884c\u8eca\u8eca\u901f\u76e3\u63a7\u8207\u8857\u5340\u6f5b\u5728\u98a8\u96aa\u5206\u6790\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.youtube.com\/watch?v=2YqCz1Fzx-0\">BigQuery GIS (3\u5206\u9418\u529f\u80fd\u4e00\u89bd)<\/a><br>\u904b\u7528 BigQueryGIS \u8a9e\u6cd5\uff0c\u9078\u51fa\u67d0\u4e00\u90f5\u905e\u5340\u865f\u5206\u5340\u5468\u570d 10 \u516c\u91cc\u7684\u6240\u6709\u6c23\u8c61\u7ad9\uff1b\u4e26\u4f7f\u7528\u300c\u7a7a\u9593\u9023\u7d50 (Spatial Joins)\u300d\u8a9e\u6cd5\uff0c\u5c07\u4eba\u53e3\u7d71\u8a08\u6578\u64da Join \u52a0\u5165\u81f3\u90f5\u905e\u5340\u865f\u5206\u5340\u5730\u7406\u8cc7\u6599\u4e2d\u3002\u5f71\u7247\u8aaa\u660e\u6b04\u63d0\u4f9b\u6240\u4f7f\u7528\u7684 <a href=\"http:\/\/bit.ly\/2LwlLaw\">query \u8a9e\u6cd5\u653e\u5728 Github \u4e0a\u7684\u9023\u7d50<\/a>\u4f9b\u5404\u754c\u53c3\u8003<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.youtube.com\/watch?v=ZOLSVi3sBnk&amp;feature=youtu.be\">BigQuery Public Dataset and GIS demo<\/a>&nbsp;<br>\u904b\u7528 BigQueryGIS \u8a9e\u6cd5\uff0c\u986f\u793a\u5168\u7f8e 2018 \u5e74\u96f7\u64ca\u6b21\u6578\u4e4b\u7a7a\u9593\u5206\u4f48\uff0c\u4e26\u4ee5\u5967\u514b\u62c9\u8377\u99ac\u5dde\u70ba\u4f8b\uff0c\u5c07\u5e73\u5747\u6bcf\u65e5\u96f7\u64ca\u6b21\u6578\u4ee5\u300c\u7a7a\u9593\u9023\u7d50 (Spatial Joins)\u300d\u8a9e\u6cd5 Join \u52a0\u5165\u81f3\u90e1\u884c\u653f\u5340\u5206\u5340\u5716\u4ee5\u53ca\u90f5\u905e\u5340\u865f\u5206\u5340\u5716\u4e2d\u3002<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u76f8\u95dc\u8cc7\u6e90<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/gis\">BigQuery GIS<\/a> &#8211; \u8aaa\u660e\u6587\u4ef6<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/gis-tutorial-hurricane\">BigQuery GIS \u5be6\u969b\u61c9\u7528\u60c5\u5883<\/a> &#8211; \u7e6a\u88fd\u98b6\u98a8\u884c\u7d93\u8def\u5f91<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/console.cloud.google.com\/marketplace?hl=zh-tw&amp;project=my-maps-project--1526624107041\">Google Platform Console Marketplace<\/a> &#8211; Public Dataset \u516c\u958b\u8cc7\u6599\u96c6\uff0c\u4f9b BigQuery GIS \u529f\u80fd\u6e2c\u8a66\u4f7f\u7528<\/p>\n","protected":false},"excerpt":{"rendered":"<p>BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc&#8230;\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002<\/p>\n","protected":false},"author":7,"featured_media":9150,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[109],"tags":[559,363],"region":[],"class_list":["post-9139","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-google-maps-platform-zh-hant","tag-363"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc...\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Johnny Zhou\"\/>\n\t<meta name=\"keywords\" content=\"google maps platform,\u5730\u7406\u8cc7\u8a0a\u7cfb\u7d71,\u7db2\u8a8c\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"zh_TW\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Master Concept\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790 |\" \/>\n\t\t<meta property=\"og:description\" content=\"BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc...\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2021-04-19T14:48:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-05-06T05:10:55+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Hkmci\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790 |\" \/>\n\t\t<meta name=\"twitter:description\" content=\"BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc...\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#article\",\"name\":\"BigQuery GIS \\u529f\\u80fd\\u4ecb\\u7d39 \\u2013 \\u4f7f\\u7528 Google BigQuery \\u9032\\u884c GIS \\u7a7a\\u9593\\u8cc7\\u6599\\u5206\\u6790 |\",\"headline\":\"BigQuery GIS \\u529f\\u80fd\\u4ecb\\u7d39 &#8211; \\u4f7f\\u7528 Google BigQuery \\u9032\\u884c GIS \\u7a7a\\u9593\\u8cc7\\u6599\\u5206\\u6790\",\"author\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/author\\\/johnny-zhou\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/masterconcept.ai\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/TW-GMP-Blog-1.png\",\"width\":1280,\"height\":720,\"caption\":\"\\u601d\\u60f3\\u79d1\\u6280 BigQuery GIS \\u529f\\u80fd\\u4ecb\\u7d39 - \\u4f7f\\u7528 Google BigQuery \\u9032\\u884c GIS \\u7a7a\\u9593\\u8cc7\\u6599\\u5206\\u6790\"},\"datePublished\":\"2021-04-19T22:48:00+08:00\",\"dateModified\":\"2025-05-06T13:10:55+08:00\",\"inLanguage\":\"zh-TW\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#webpage\"},\"articleSection\":\"\\u7db2\\u8a8c, Google Maps Platform, \\u5730\\u7406\\u8cc7\\u8a0a\\u7cfb\\u7d71, \\u53ef\\u9078\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/\\u5206\\u985e\\\/blog\\\/#listItem\",\"name\":\"\\u7db2\\u8a8c\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/\\u5206\\u985e\\\/blog\\\/#listItem\",\"position\":2,\"name\":\"\\u7db2\\u8a8c\",\"item\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/\\u5206\\u985e\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#listItem\",\"name\":\"BigQuery GIS \\u529f\\u80fd\\u4ecb\\u7d39 &#8211; \\u4f7f\\u7528 Google BigQuery \\u9032\\u884c GIS \\u7a7a\\u9593\\u8cc7\\u6599\\u5206\\u6790\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#listItem\",\"position\":3,\"name\":\"BigQuery GIS \\u529f\\u80fd\\u4ecb\\u7d39 &#8211; \\u4f7f\\u7528 Google BigQuery \\u9032\\u884c GIS \\u7a7a\\u9593\\u8cc7\\u6599\\u5206\\u6790\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/\\u5206\\u985e\\\/blog\\\/#listItem\",\"name\":\"\\u7db2\\u8a8c\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/#organization\",\"name\":\"Master Concept\",\"description\":\"\\u4e9e\\u592a\\u5730\\u5340\\u9818\\u5148\\u7d1a\\u96f2\\u7aef\\u6280\\u8853\\u9867\\u554f\",\"url\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/\",\"telephone\":\"+85235896700\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/hkmci.com\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/mci_logo.png\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#organizationLogo\"},\"image\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/author\\\/johnny-zhou\\\/#author\",\"url\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/author\\\/johnny-zhou\\\/\",\"name\":\"Johnny Zhou\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/16e25d54bdce1f79db43a80b307d3f7237a74da3853262e24b659d26dfec2de0?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Johnny Zhou\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#webpage\",\"url\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/\",\"name\":\"BigQuery GIS \\u529f\\u80fd\\u4ecb\\u7d39 \\u2013 \\u4f7f\\u7528 Google BigQuery \\u9032\\u884c GIS \\u7a7a\\u9593\\u8cc7\\u6599\\u5206\\u6790 |\",\"description\":\"BigQuery GIS \\u70ba Google BigQuery \\u63d0\\u4f9b\\u91dd\\u5c0d\\u5730\\u7406\\u7a7a\\u9593\\u8cc7\\u8a0a\\u7684\\u5206\\u6790\\u76f8\\u95dc\\u529f\\u80fd\\u3002BigQuery \\u662f\\u5168\\u7403\\u7b2c\\u4e00\\u500b\\u652f\\u63f4\\u5730\\u7406\\u7a7a\\u9593\\u6578\\u64da\\u985e\\u8207\\u529f\\u80fd\\u7684\\u8cc7\\u6599\\u5009\\u5132\\u670d\\u52d9\\uff0c\\u9019\\u4f7f\\u5f97\\u50b3\\u7d71 GIS \\u9818\\u57df\\u4e2d\\u7684\\u5730\\u7406\\u7a7a\\u9593\\u76f8\\u95dc\\u8cc7\\u6599\\u683c\\u5f0f\\uff08\\u5982\\uff1a\\u7d93\\uff0f\\u7def\\u5ea6\\u3001\\u57ce\\u5e02\\u3001\\u5dde\\u3001\\u90f5\\u653f\\u7de8\\u78bc...\\u7b49\\uff09\\u6210\\u70ba\\u9810\\u8a2d\\u8cc7\\u6599\\u683c\\u5f0f\\u4e4b\\u4e00\\uff0c\\u63d0\\u4f9b\\u4f7f\\u7528\\u8005\\u5c07\\u76f8\\u95dc\\u7684 GIS \\u6578\\u64da\\u3002\",\"inLanguage\":\"zh-TW\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/author\\\/johnny-zhou\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/author\\\/johnny-zhou\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/masterconcept.ai\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/TW-GMP-Blog-1.png\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#mainImage\",\"width\":1280,\"height\":720,\"caption\":\"\\u601d\\u60f3\\u79d1\\u6280 BigQuery GIS \\u529f\\u80fd\\u4ecb\\u7d39 - \\u4f7f\\u7528 Google BigQuery \\u9032\\u884c GIS \\u7a7a\\u9593\\u8cc7\\u6599\\u5206\\u6790\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/blog\\\/bigquery-gis-analysis\\\/#mainImage\"},\"datePublished\":\"2021-04-19T22:48:00+08:00\",\"dateModified\":\"2025-05-06T13:10:55+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/#website\",\"url\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/\",\"name\":\"Master Concept\",\"description\":\"\\u4e9e\\u592a\\u5730\\u5340\\u9818\\u5148\\u7d1a\\u96f2\\u7aef\\u6280\\u8853\\u9867\\u554f\",\"inLanguage\":\"zh-TW\",\"publisher\":{\"@id\":\"https:\\\/\\\/masterconcept.ai\\\/zh-hant\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790 |","description":"BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc...\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002","canonical_url":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/","robots":"max-image-preview:large","keywords":"google maps platform,\u5730\u7406\u8cc7\u8a0a\u7cfb\u7d71,\u7db2\u8a8c","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#article","name":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790 |","headline":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 &#8211; \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790","author":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/author\/johnny-zhou\/#author"},"publisher":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png","width":1280,"height":720,"caption":"\u601d\u60f3\u79d1\u6280 BigQuery GIS \u529f\u80fd\u4ecb\u7d39 - \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790"},"datePublished":"2021-04-19T22:48:00+08:00","dateModified":"2025-05-06T13:10:55+08:00","inLanguage":"zh-TW","mainEntityOfPage":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#webpage"},"isPartOf":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#webpage"},"articleSection":"\u7db2\u8a8c, Google Maps Platform, \u5730\u7406\u8cc7\u8a0a\u7cfb\u7d71, \u53ef\u9078"},{"@type":"BreadcrumbList","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/masterconcept.ai\/zh-hant\/#listItem","position":1,"name":"Home","item":"https:\/\/masterconcept.ai\/zh-hant\/","nextItem":{"@type":"ListItem","@id":"https:\/\/masterconcept.ai\/zh-hant\/\u5206\u985e\/blog\/#listItem","name":"\u7db2\u8a8c"}},{"@type":"ListItem","@id":"https:\/\/masterconcept.ai\/zh-hant\/\u5206\u985e\/blog\/#listItem","position":2,"name":"\u7db2\u8a8c","item":"https:\/\/masterconcept.ai\/zh-hant\/\u5206\u985e\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#listItem","name":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 &#8211; \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790"},"previousItem":{"@type":"ListItem","@id":"https:\/\/masterconcept.ai\/zh-hant\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#listItem","position":3,"name":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 &#8211; \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790","previousItem":{"@type":"ListItem","@id":"https:\/\/masterconcept.ai\/zh-hant\/\u5206\u985e\/blog\/#listItem","name":"\u7db2\u8a8c"}}]},{"@type":"Organization","@id":"https:\/\/masterconcept.ai\/zh-hant\/#organization","name":"Master Concept","description":"\u4e9e\u592a\u5730\u5340\u9818\u5148\u7d1a\u96f2\u7aef\u6280\u8853\u9867\u554f","url":"https:\/\/masterconcept.ai\/zh-hant\/","telephone":"+85235896700","logo":{"@type":"ImageObject","url":"https:\/\/hkmci.com\/wp-content\/uploads\/2020\/05\/mci_logo.png","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#organizationLogo"},"image":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/masterconcept.ai\/zh-hant\/author\/johnny-zhou\/#author","url":"https:\/\/masterconcept.ai\/zh-hant\/author\/johnny-zhou\/","name":"Johnny Zhou","image":{"@type":"ImageObject","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/16e25d54bdce1f79db43a80b307d3f7237a74da3853262e24b659d26dfec2de0?s=96&d=mm&r=g","width":96,"height":96,"caption":"Johnny Zhou"}},{"@type":"WebPage","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#webpage","url":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/","name":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790 |","description":"BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc...\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002","inLanguage":"zh-TW","isPartOf":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/#website"},"breadcrumb":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#breadcrumblist"},"author":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/author\/johnny-zhou\/#author"},"creator":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/author\/johnny-zhou\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png","@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#mainImage","width":1280,"height":720,"caption":"\u601d\u60f3\u79d1\u6280 BigQuery GIS \u529f\u80fd\u4ecb\u7d39 - \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790"},"primaryImageOfPage":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/#mainImage"},"datePublished":"2021-04-19T22:48:00+08:00","dateModified":"2025-05-06T13:10:55+08:00"},{"@type":"WebSite","@id":"https:\/\/masterconcept.ai\/zh-hant\/#website","url":"https:\/\/masterconcept.ai\/zh-hant\/","name":"Master Concept","description":"\u4e9e\u592a\u5730\u5340\u9818\u5148\u7d1a\u96f2\u7aef\u6280\u8853\u9867\u554f","inLanguage":"zh-TW","publisher":{"@id":"https:\/\/masterconcept.ai\/zh-hant\/#organization"}}]},"og:locale":"zh_TW","og:site_name":"Master Concept","og:type":"article","og:title":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790 |","og:description":"BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc...\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002","og:url":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/","og:image":"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png","og:image:secure_url":"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png","og:image:width":1280,"og:image:height":720,"article:published_time":"2021-04-19T14:48:00+00:00","article:modified_time":"2025-05-06T05:10:55+00:00","article:publisher":"https:\/\/www.facebook.com\/Hkmci\/","twitter:card":"summary","twitter:title":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790 |","twitter:description":"BigQuery GIS \u70ba Google BigQuery \u63d0\u4f9b\u91dd\u5c0d\u5730\u7406\u7a7a\u9593\u8cc7\u8a0a\u7684\u5206\u6790\u76f8\u95dc\u529f\u80fd\u3002BigQuery \u662f\u5168\u7403\u7b2c\u4e00\u500b\u652f\u63f4\u5730\u7406\u7a7a\u9593\u6578\u64da\u985e\u8207\u529f\u80fd\u7684\u8cc7\u6599\u5009\u5132\u670d\u52d9\uff0c\u9019\u4f7f\u5f97\u50b3\u7d71 GIS \u9818\u57df\u4e2d\u7684\u5730\u7406\u7a7a\u9593\u76f8\u95dc\u8cc7\u6599\u683c\u5f0f\uff08\u5982\uff1a\u7d93\uff0f\u7def\u5ea6\u3001\u57ce\u5e02\u3001\u5dde\u3001\u90f5\u653f\u7de8\u78bc...\u7b49\uff09\u6210\u70ba\u9810\u8a2d\u8cc7\u6599\u683c\u5f0f\u4e4b\u4e00\uff0c\u63d0\u4f9b\u4f7f\u7528\u8005\u5c07\u76f8\u95dc\u7684 GIS \u6578\u64da\u3002","twitter:image":"https:\/\/masterconcept.ai\/wp-content\/uploads\/2021\/04\/TW-GMP-Blog-1.png"},"aioseo_meta_data":{"post_id":"9139","title":"#post_title |","description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[],"defaultGraph":"Article","defaultPostTypeGraph":""},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"},\"blockGraphs\":[]}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-04-16 09:01:39","updated":"2026-03-09 03:41:26","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/masterconcept.ai\/zh-hant\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/masterconcept.ai\/zh-hant\/\u5206\u985e\/blog\/\" title=\"\u7db2\u8a8c\">\u7db2\u8a8c<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tBigQuery GIS \u529f\u80fd\u4ecb\u7d39 \u2013 \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/masterconcept.ai\/zh-hant\/"},{"label":"\u7db2\u8a8c","link":"https:\/\/masterconcept.ai\/zh-hant\/\u5206\u985e\/blog\/"},{"label":"BigQuery GIS \u529f\u80fd\u4ecb\u7d39 &#8211; \u4f7f\u7528 Google BigQuery \u9032\u884c GIS \u7a7a\u9593\u8cc7\u6599\u5206\u6790","link":"https:\/\/masterconcept.ai\/zh-hant\/blog\/bigquery-gis-analysis\/"}],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/posts\/9139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/comments?post=9139"}],"version-history":[{"count":0,"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/posts\/9139\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/media\/9150"}],"wp:attachment":[{"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/media?parent=9139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/categories?post=9139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/tags?post=9139"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/masterconcept.ai\/zh-hant\/wp-json\/wp\/v2\/region?post=9139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}