PO Box addresses

Jul 15, 2011 at 4:33 PM

How does the process handle PO Box addresses?  I have been evaluating the Latitude and Longitude values being returned and they are looking good.  Except for PO Box addresses, they are showing for Europe.  Even though the City and Zip Code are in the US.  Have you run accross this before? 

Thanks In Advance John

 

Coordinator
Jul 15, 2011 at 5:32 PM

All interpretation of the address queries is performed by the Bing Maps Geocode Flow. I would expect a PO box address to return a specific entity type such as "PostOffice." It seems likely that the latitude and longitude would be that of the post office building itself, which which in turn could be in a different city, county, or state from the organization or individual represented.

Are you including the "en-US" culture or another culture code in your queries?

If it turns out that there are definite problems with the data being returned, I have two options. First I can take the issue back to Bing or to the company that provides the technology to Bing. Second, if the problems can't be resolved then I could potentially offer a second geocoder option, such as Google, although I do not have time for such a project myself right now.

Jul 15, 2011 at 7:50 PM

Here are some examples.  Still trying to find the examples of European locations I set them back to null.  But I do have some for BO Boxes that have the correct latitude and longitude.

These all came back with the latitude and longitude for the following, 49821 Prosperity Ln, O'Neals, CA 93645. the first address is in Mississppi and the rest are in Missouri.

6182666 PATRICK FULGHAM 37.148140221834183 -119.64424878358841 PO BOX 699 HAZLEHURST 39083 en-US CA AdminDivision1 Success Medium California CA United States

6645270 KELLY MORRIS 37.148140221834183 -119.64424878358841 PO BOX 7812 CHESTERFIELD 63006 en-US CA AdminDivision1 Success Medium California CA United States

4295510 YOLANDA THORNTON 37.148140221834183 -119.64424878358841 PO BOX 6223 CHESTERFIELD 63006 en-US CA AdminDivision1 Success Medium California CA United States

6645268 CHARLES MORRIS 37.148140221834183 -119.64424878358841 PO BOX 7812 CHESTERFIELD 63006 en-US CA AdminDivision1 Success Medium California CA United States

4274499 MARY HARRIS 37.148140221834183 -119.64424878358841 PO BOX 678 CHESTERFIELD 63006 en-US CA AdminDivision1 Success Medium California CA United States

4274339 JON HARRIS 37.148140221834183 -119.64424878358841 PO BOX 678 CHESTERFIELD 63006 en-US CA AdminDivision1 Success Medium California CA United States

4073539 BEVERLY RODGERS 37.148140221834183 -119.64424878358841 PO BOX 6161 CHESTERFIELD 63006 en-US CA AdminDivision1 Success Medium California CA United States

4291910 JANET STELMACKI 37.148140221834183 -119.64424878358841 PO BOX 214 CHESTERFIELD 630060214 en-US CA AdminDivision1 Success Medium California CA United States

 

These all came back with the latitude and longitude for the same CA address, but the are all from the state of NH.

 5886223 COLLEEN VAN ONSELEN 37.148140221834183 -119.64424878358841 P.O. BOX 327 CANDIA 03034 en-US CA AdminDivision1 Success Medium California CA United States

5840594 RICHARD THERRIEN 37.148140221834183 -119.64424878358841 PO BOX 398 CANDIA 03034 en-US CA AdminDivision1 Success Medium California CA United States

6113705 THOMAS VAN ONSELEN 37.148140221834183 -119.64424878358841 P.O. BOX 327 CANDIA 03034 en-US CA AdminDivision1 Success Medium California CA United States

7125459 BEVERLY THERRIEN 37.148140221834183 -119.64424878358841 PO BOX 398 CANDIA 03034 en-US CA AdminDivision1 Success Medium California CA United States

5815851 HELEN CAMPBELL 37.148140221834183 -119.64424878358841 PO BOX 277 DEERFIELD 03037 en-US CA AdminDivision1 Success Medium California CA United States

6420086 JAMES RICHARDSON 37.148140221834183 -119.64424878358841 PO BOX 213 DEERFIELD 03037 en-US CA AdminDivision1 Success Medium California CA United States

7120176 DANE ANDERSON 37.148140221834183 -119.64424878358841 PO BOX 141 DERRY 03038 en-US CA AdminDivision1 Success Medium California CA United States

7063291 THERESA WOLFORD 37.148140221834183 -119.64424878358841 P.O.BOX # 8 DERRY 03038 en-US CA AdminDivision1 Success Medium California CA United States



Coordinator
Jul 15, 2011 at 8:11 PM
Edited Jul 16, 2011 at 4:42 PM

There are two clues in the returned data, a matching level of "Medium" (which tends to be rather poor) and an entity type of AdminDivision1, which is "A first-order, initial political subdivision of a [Sovereign], such as a state, a province, a department, a region, or a prefecture."

I can try to reproduce the problem this weekend. Are you submitting the fields separately or as a composite query?

Jul 15, 2011 at 9:15 PM

As composite query.

Thanks

From: mcb2003 [email removed]
Sent: Friday, July 15, 2011 2:11 PM
To: Grindel, John
Subject: Re: PO Box addresses [SsisBatchGeocoder:265319]

From: mcb2003

There are a two clues in the returned data, a matching level of "Medium" (which tends to be rather poor) and an entity type of AdminDivision1, which is "A first-order, initial political subdivision of a [Sovereign], such as a state, a province, a department, a region, or a prefecture."

I can try to reproduce the problem this weekend. Are you submitting the fields separately or as a composite query?



CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Coordinator
Jul 16, 2011 at 6:04 PM

I found that the example file contained more of the original application from which it was derived than I had intended. For field-oriented (as opposed to composite) queries, it was forcing the state (AdminDistrict) to "CA" (California). I have updated the example files to not do that, but rather to read the AdminDistrict from the input file.

This should not have affected composite queries, which embed the state within the query string. Check your data flow to make sure that the AdminDistrict is not being forced to "CA".

Jul 18, 2011 at 3:53 PM

The data flow is hard coding to “CA”, is tried to edit it but now I am getting the following error. Can you send me a new example file without the AdminDistrict hard coded to “CA”.

[Geocode From Fields [331]] Error: System.NullReferenceException: Object reference not set to an instance of an object.

at SSISBatchGeocoder.GeocoderTransformation.GetTrimmedInputValue(PipelineBuffer buffer, String sColumnName)

at SSISBatchGeocoder.GeocoderTransformation.ProcessInput(Int32 inputID, PipelineBuffer buffer)

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper,

Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Geocode From Fields" (331)

failed with error code 0x80004003 while processing input "Input" (333). The identified component returned an error

from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop

running. There may be error messages posted before this with more information about the failure.

Thanks

John Grindel

From: mcb2003 [email removed]
Sent: Saturday, July 16, 2011 12:04 PM
To: Grindel, John
Subject: Re: PO Box addresses [SsisBatchGeocoder:265319]

From: mcb2003

I found that the example file contained more of the original application from which it was derived than I had intended. For field-oriented (as opposed to composite) queries, it was forcing the state (AdminDistrict) to "CA" (California). I have updated the example files to not do that, but rather to read the AdminDistrict from the input file.

This should not have affected composite queries, which embed the state within the query string. Check your data flow to make sure that the AdminDistrict is not being forced to "CA".



CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Jul 18, 2011 at 4:00 PM

Never mind request for file, I got from the download tab.

Thanks

John

From: mcb2003 [email removed]
Sent: Saturday, July 16, 2011 12:04 PM
To: Grindel, John
Subject: Re: PO Box addresses [SsisBatchGeocoder:265319]

From: mcb2003

I found that the example file contained more of the original application from which it was derived than I had intended. For field-oriented (as opposed to composite) queries, it was forcing the state (AdminDistrict) to "CA" (California). I have updated the example files to not do that, but rather to read the AdminDistrict from the input file.

This should not have affected composite queries, which embed the state within the query string. Check your data flow to make sure that the AdminDistrict is not being forced to "CA".



CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.