Batch convert address to coordinates

From LemonWiki共筆
Revision as of 14:50, 29 July 2019 by Planetoid (talk | contribs)
Jump to navigation Jump to search

About Fusion Tables - Fusion Tables Help

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

Get Started  |  Geocoding API  |  Google Developers

CARTO (formerly CartoDB)

  • 查詢次數: $ 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: