如何将地理编码的地址信息存储到数据库中

本文关键字：存储 信息 数据库 地址 编码 | 更新日期: 2023-09-27 18:25:23

我有一个地理编码请求，它在数据库中的多个地址中循环，并返回纬度和经度以及其他信息。

foreach(var row in data){
        <script type="text/javascript" src="https://maps.googleapis.com/maps/api/geocode/json?address=@HttpUtility.UrlEncode(row.ADDRESS1)+@HttpUtility.UrlEncode(row.CITY)+@row.ST+CA&key=???apikey???"></script>
    }

它变成了几百个请求，并为每个请求提供了我的纬度和经度。我需要获取纬度和经度并将其存储到数据库中。

我真的不在乎它是返回json还是xml。

我找不到很多关于如何做到这一点的信息，我发现的大多数信息都是质疑你是否真的要大声做这件事，我已经调查过了。一般来说，我对编程是新手，对c#和护目镜api的也是新手

我在配送呼叫中心使用此代码，也许它可以帮助您：

                foreach(var row in data)
                {
                    string strAddr = row.ADDRESS1 + "," + row.CITY; //here you've to write the exact address you want to geo
                    GoogleMapsDll.GeoResponse myCoordenadas = new GoogleMapsDll.GeoResponse();
                    myCoordenadas = GoogleMapsDll.GoogleMaps.GetGeoCodedResults(strAddr);
                    string strLat = myCoordenadas.Results[0].Geometry.Location.Lat.ToString();  
                    string strLong = myCoordenadas.Results[0].Geometry.Location.Lng.ToString();
                    System.Threading.Thread.Sleep(2000); //THIS IS AN API LIMITs
                    //this is just an example to update your sql rows, you can use the info where you need
                    using(SqlConnection myConnection = new SqlConnection(yourConnectionString))
                    {
                        myConnection.Open();
                        string strQueryUpdate = "UPDATE yourAddressTable SET lat = '" + strLat + "' , lon = '" + strLong + "' "
                            + "WHERE yourId = '" + row.YourId + "' ";
                        SqlCommand myCommandUpdate = new SqlCommand(strQueryUpdate, myConnectionUpdate);
                        myCommandUpdate.ExecuteNonQuery();
                    }
                 }

以及对您的地址进行地理编码的类（我从StackOverflow中获取了它，但没有链接）

using System.Net;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;
using System.Web;
public class GoogleMapsDll
{
    public class GoogleMaps
    {
        /// <summary>
        ///
        /// </summary>
        /// <param name="address"></param>
        /// <returns></returns>
        public static GeoResponse GetGeoCodedResults(string address)
        {
            string url = string.Format(
                    "http://maps.google.com/maps/api/geocode/json?address={0}&region=dk&sensor=false",
                    HttpUtility.UrlEncode(address)
                    );
            var request = (HttpWebRequest)HttpWebRequest.Create(url);
            request.Headers.Add(HttpRequestHeader.AcceptEncoding, "gzip,deflate");
            request.AutomaticDecompression = DecompressionMethods.GZip | DecompressionMethods.Deflate;
            DataContractJsonSerializer serializer = new DataContractJsonSerializer(typeof(GeoResponse));
            var res = (GeoResponse)serializer.ReadObject(request.GetResponse().GetResponseStream());
            return res;
        }
    }
    [DataContract]
    public class GeoResponse
    {
        [DataMember(Name = "status")]
        public string Status { get; set; }
        [DataMember(Name = "results")]
        public CResult[] Results { get; set; }
        [DataContract]
        public class CResult
        {
            [DataMember(Name = "geometry")]
            public CGeometry Geometry { get; set; }
            [DataContract]
            public class CGeometry
            {
                [DataMember(Name = "location")]
                public CLocation Location { get; set; }
                [DataContract]
                public class CLocation
                {
                    [DataMember(Name = "lat")]
                    public double Lat { get; set; }
                    [DataMember(Name = "lng")]
                    public double Lng { get; set; }
                }
            }
        }
        public GeoResponse()
        { }
    }
}

如何将地理编码的地址信息存储到数据库中

相关文章：