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);
}
}
}
//////////////////////////
//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();
}
}
}