Batch convert address to coordinates: Difference between revisions

Revision as of 14:50, 29 July 2019

About Fusion Tables - Fusion Tables Help

批次轉換地址為經緯度: 可^[1]
匯出經緯度: 否。Fusion tables 轉換地址為經緯度，只能顯示在 Fusion tables 服務上，無法下載經緯度資料。

Get Started | Geocoding API | Google Developers

查詢次數: Geocoding API Usage and Billing | Geocoding API | Google Developers

查詢次數: $ 8000/月 for Professional plan^[2]
批次轉換地址為經緯度: 可^[3]。部分地址可能無法識別，需要手動輸入經緯度。
匯出經緯度: 部分檔案可用。
- 匯出的 CSV 檔案的經緯度被編碼，無法使用。例如網頁上雖然顯示 120.1800, 22.9902 ，但是下載的 CSV ，the_geom 欄位顯示為 0101000020E610000044696FF0850B5E403D27BD6F7CFD3640
- 匯出的 SHP 檔案，不包含經緯度可用。
- 匯出的 KML 檔案的經緯度可用 ex:

  <Placemark>
        <ExtendedData><SchemaData schemaUrl="#ae_1">
                <SimpleData name="cartodb_id">1</SimpleData>
                <SimpleData name="_">69507496</SimpleData>
                <SimpleData name="field_11"></SimpleData>
                <SimpleData name="field_10"></SimpleData>
                <SimpleData name="field_9"></SimpleData>
                <SimpleData name="field_8"></SimpleData>
                <SimpleData name="field_7"></SimpleData>
                <SimpleData name="__5">ME</SimpleData>
                <SimpleData name="__4"></SimpleData>
                <SimpleData name="__3">www.XX.com</SimpleData>
                <SimpleData name="__2">台南市XX號</SimpleData>
                <SimpleData name="__1">XX公司</SimpleData>
                <SimpleData name="cartodb_georef_status">1</SimpleData>
        </SchemaData></ExtendedData>
      <Point><coordinates>120.18005,22.99018</coordinates></Point>
  </Placemark>

- 匯出的 GeoJSON 檔案的經緯度可用 ex:

{"cartodb_id":1,"_":69507496,"field_11":"","field_10":"","field_9":"","field_8":"","field_7":"","__5":"ME","__4":"","__3":"www.XX.com","__2":"台南市XX號","__1":"XX公司","cartodb_georef_status":true}},{"type":"Feature","geometry":{"type":"Point","coordinates":[120.23722,22.97507]},"properties":

- 匯出的 SVG 檔案，內容只有經緯度，沒有地點名稱，無法使用 ex:

<circle r="5" cx="37.6859" cy="761.842822" />
<circle r="5" cx="145.760433" cy="306.9488" />
<circle r="5" cx="126.734335" cy="303.810725" />
<circle r="5" cx="148.85679" cy="308.726431" />

Hassle-free geocoding - Geocodio [Last visited: 2019-07-29]

支援哪個國家的地址: 限制美國加拿大的地址

USPS & International Address Verification - SmartyStreets [Last visited: 2019-07-29]

支援哪個國家的地址: 限制美國的地址

Address Verification, Data Cleansing & Geocoding • Loqate, a GBG solution [Last visited: 2019-07-29]

支援哪個國家的地址: 似乎沒有限制 "we can provide international coordinate data for most major trading countries around the world. ^[4]"
查詢次數: $ ^[5]

微博API / address to geo - 微博API 「根據實際地址返回地理信息坐標」摘錄自官方文件 尚未測試

references:

[1] Geocode location data - Fusion Tables Help

[2] Pricing — CARTO

[3] Geocoding your Data — Help Center

[4] Address Validation & Location Data FAQs - Loqate

[5] Validation Costs & Data Quality Management Pricing - Loqate, a GBG solution

[1]

[2]

[3]

[4]

[5]

@@ Line 2: / Line 2: @@
 * 批次轉換地址為經緯度: 可<ref>[https://support.google.com/fusiontables/answer/1012281?hl=en Geocode location data - Fusion Tables Help]</ref>
 * 匯出經緯度: 否。Fusion tables 轉換地址為經緯度，只能顯示在 Fusion tables 服務上，無法下載經緯度資料。
+[https://developers.google.com/maps/documentation/geocoding/start Get Started  |  Geocoding API  |  Google Developers]
+* 查詢次數: [https://developers.google.com/maps/documentation/geocoding/usage-and-billing Geocoding API Usage and Billing  |  Geocoding API  |  Google Developers]
 [https://carto.com/ CARTO] (formerly [https://cartodb.com/ CartoDB])
@@ Line 42: / Line 45: @@
 </pre>
+[https://www.geocod.io/ Hassle-free geocoding - Geocodio] {{access | date=2019-07-29}}
+* 支援哪個國家的地址: 限制美國加拿大的地址
+[https://smartystreets.com/ USPS & International Address Verification - SmartyStreets] {{access | date=2019-07-29}}
+* 支援哪個國家的地址: 限制美國的地址
+[https://www.loqate.com/en-gb/ Address Verification, Data Cleansing & Geocoding • Loqate, a GBG solution] {{access | date=2019-07-29}}
+* 支援哪個國家的地址: 似乎沒有限制 "we can provide international coordinate data for most major trading countries around the world. <ref>[https://www.loqate.com/resources/support/faqs/Geocoding/ Address Validation & Location Data FAQs - Loqate]</ref>"
+* 查詢次數: ''$'' <ref>[https://www.loqate.com/en-gb/pricing/?rd=pca Validation Costs & Data Quality Management Pricing - Loqate, a GBG solution]</ref>
 [http://open.weibo.com/wiki/%E9%A6%96%E9%A1%B5 微博API] / [http://open.weibo.com/wiki/2/location/geo/address_to_geo address to geo - 微博API] 「根據實際地址返回地理信息坐標」摘錄自官方文件 ''尚未測試''

Batch convert address to coordinates: Difference between revisions

Revision as of 14:50, 29 July 2019

Navigation menu

Search