nanog mailing list archives

Re: FCC form 477 geocoding


From: Jay Hennigan <jay () west net>
Date: Tue, 03 Mar 2015 17:43:15 -0800

On 3/3/15 15:13, Sean Donelan wrote:
On Tue, 3 Mar 2015, Jay Hennigan wrote:
Well you'll need to translate those into addresses.  That should be easy
with Google or Bing.

We have the addresses, need census tract and block.

For small address batches you can use the Census Geocoder.  The
documentation is at

http://www.census.gov/geo/maps-data/data/geocoder.html

Basically you upload a CSV file addresses and you'll get back FIPS
codes for state, county, census tract and census block for each address.
Concatenate the FIPS state+county+censustract code (not the census block).

This turns out to be the least hassle, thanks to all in the group who
replied. Note that although the Census website says that it will handle
a CSV file of up to 1000 addresses, in reality it pukes on anything
greater than about 100 at a time.


-- 
--
Jay Hennigan - CCIE #7880 - Network Engineering - jay () impulse net
Impulse Internet Service  -  http://www.impulse.net/
Your local telephone and internet company - 805 884-6323 - WB6RDV


Current thread: