Esempio n. 1
0
        public void TestAddressGeocode()
        {
            //arrange
            var address  = "1455 E Sandy Acres Dr";
            var city     = "Salisbury";
            var zip      = "21804";
            var geocoder = new MDLocatorWithZip();//default lat/lon
            //act
            var result     = geocoder.geocode(address, city, zip);
            var resultObj  = Net.deserializeJson(result);
            var candidates = resultObj.candidates as IEnumerable <dynamic>;

            Console.WriteLine(geocoder.Url);

            foreach (var candidate in candidates)
            {
                if (candidate.score == 100)
                {
                    Console.WriteLine(candidate);
                }
            }
        }
Esempio n. 2
0
        //////////////////////////
        //helpers
        ///////////////////////
        //attempt to geocode the profile address
        protected void addUpdateAddrGeoTag(int profileId)
        {
            var profile = _workUnit.ProfileRepository.GetEntityByID(profileId);

            if (profile == null)
            {
                return;
            }

            var address = profile.Organization.StreetAddress;
            var zip     = profile.Organization.Zip;
            var city    = profile.Organization.City;
            var state   = profile.Organization.State;

            //if any field is empty do nothing
            if (string.IsNullOrEmpty(address) ||
                string.IsNullOrEmpty(zip) ||
                string.IsNullOrEmpty(city))
            {
                return;
            }

            //geocode
            var geocoder   = new MDLocatorWithZip();
            var jsonResult = geocoder.geocode(address, city, zip);
            var resultObj  = Net.deserializeJson(jsonResult);

            if (resultObj == null)
            {
                return;
            }
            var result = resultObj.candidates as IEnumerable <dynamic>;

            if (result == null)
            {
                return;
            }

            var     bestScore = geocoder.AcceptableScore;
            dynamic location  = null;

            //parse result (get the entry with highest score and above acceptable score 65)
            foreach (var candidate in result)
            {
                if (candidate.score > bestScore)
                {
                    bestScore = candidate.score;
                    location  = candidate.location;
                }
            }
            //create geo tag
            if (location != null)
            {
                var tagName = string.Format("{0}, {1}, {2} {3}", address, city, state, zip);
                var wkt     = string.Format("POINT({0} {1})", location.x, location.y);
                //create geo tag
                var geoTag = new GeoTag()
                {
                    Name        = tagName,
                    Geometry    = DbGeometry.PointFromText(wkt, geocoder.SpatialReference),
                    Description = "address"
                };
                //remove all old references
                try {
                    var oldAddrTagRefs = profile
                                         .ProfileTags
                                         .Where(x => (x.Tag is GeoTag) && x.Tag.Description == "address")
                                         .ToList();
                    oldAddrTagRefs.ForEach(x => _workUnit.ProfileTagRepository.DeleteEntity(x));
                    _workUnit.saveChanges();
                }
                catch (ArgumentNullException) {
                    //no item found
                }
                //update new tags
                try {
                    var currentTag = _workUnit.TagRepository.Entities.OfType <GeoTag>().First(x => x.Name.ToUpper() == tagName.ToUpper());
                    //update the geometry if it already exists
                    currentTag.Geometry = geoTag.Geometry;
                    if (currentTag.Description == "")
                    {
                        currentTag.Description = "address";
                    }
                    //update to database
                    _workUnit.TagRepository.UpdateEntity(currentTag);
                    //check if it already has referenced this profile
                    if (!profile.ProfileTags.Select(x => x.Tag).Contains(currentTag))
                    {
                        var profileTag = new ProfileTag()
                        {
                            Tag     = currentTag,
                            Profile = profile
                        };
                        _workUnit.ProfileTagRepository.InsertEntity(profileTag);
                    }
                }
                catch {
                    //create ProfileTag
                    var profileTag = new ProfileTag()
                    {
                        Tag     = geoTag,
                        Profile = profile
                    };
                    _workUnit.ProfileTagRepository.InsertEntity(profileTag);
                }
                finally {
                    _workUnit.saveChanges();
                }
            }
        }