My team and I ran a series of zip codes from addresses within our data set against MSA to Zip Code data found on The Census' website here. We found that a relatively high number of the addresses did match, or potentially fall within the limits of any MSA. However, we want to verify that in fact the 1000 or so address that did fall within any MSA based on Census data simply do not lie within the geometric bounds of any particular MSA.

What tool could I use to verify this?

For example, If I have a series of addresses that I ran through an algorithm to retireve their Lat Long points, I could use something like LatLong.net to verify the correctness of the said algorithm to some degree.

Is there an equivalent tool other than say using PostGIS and running the Lat Longs through a geometric comparison function within Postgres (Our database is a Postgres DB by the way)?

I am not well versed in PostGIS to know offhand how use it to solve this problem.


Solved. We lucked out in finding a list of MSAs (Metropolitan Statistical Area) and every zip code within that MSA. Thus the mapping could then be handled with our database. But this issue was about how to go about mapping MSA data to the address data that we have. And the answer was that we needed a key to map them together and this file provides that key - the zip code.

I hope this file and idea help anyone else out with a similar issue with say Micropolitan Statistical Areas for example.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.