[178753] in North American Network Operators' Group
Re: FCC form 477 geocoding
daemon@ATHENA.MIT.EDU (Stephen Frost)
Tue Mar 3 19:11:15 2015
X-Original-To: nanog@nanog.org
Date: Tue, 3 Mar 2015 19:11:11 -0500
From: Stephen Frost <sfrost@snowman.net>
To: Jay Hennigan <jay@west.net>
In-Reply-To: <54F63798.3050603@west.net>
Cc: nanog@nanog.org
Errors-To: nanog-bounces@nanog.org
--p2N8/IdOpufTRkPb
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
* Jay Hennigan (jay@west.net) wrote:
> The CFO here is working on FCC form 477 and tells me that he needs to
> enter census tract and block information for our customers. He says that
> the US Census site is worse than useless and the info isn't on the FCC
> site.
The US Census Tiger data set is available from their FTP site in
Shapefile format. PostGIS (the spatial extension to PostgreSQL)
includes the Tiger geocoder which can be used to geocode addresses,
based on that Census data.
The PostGIS Tiger extension also includes scripts to load the data into
a PostGIS-enabled PostgreSQL database.
If there are questions about the geocoder, I can try and answer them, I
had a hand in writing it.
Thanks!
Stephen
--p2N8/IdOpufTRkPb
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1
iQIcBAEBCgAGBQJU9k2eAAoJEO1sijiDR2RVcnYQAIGJDFeGL14798oMWF5OSUMb
TLer6Su0mmjYKMUqVw5vRWFaLVy9eD857yK3EGQcwnktz0bPq4R4QRbJs04kXvLl
kxU3IAbFRH069ax0kJ2ZyIIRzjlxy0UupLveZ2NCzZtUNXF28tjueLYCCPf2Zl9I
EJyTzR11VB9JWnu8JVgmLXZrTh4znXMbh4gghugjiEF/UxzkW42VwnZYlHO8MzSW
Nj1zjzmITE5++9UBwrV1BHWnlHlCURUbRmpkovCoxysUcSwDNyiZLWTgbz/fMCwx
KoRSWo5iDo/mz8LCCFe7SjKV3nde3FjHdekBIfw+D98nEpxfUCzO2GTlWHaTWMF2
sGS6YjGzWu6Gdt5rXfu1PuRJacKc7QvNtcsKCPYmLZ3518NWTjvS6tAHTIeXCepa
toOQ3bxjdVSrG9D+LbJWy1kyhggm6IB4CmRbU9MzjF4YoL2JhvR43SoybfNu6/PX
huMuyyM3txo/pmmF5bWjLX29fdhx71kSr+9iLokenNzluwptA16hZgXCWznAaPhH
YCMWQ0NKn3L+aUTGOjUuhm/szQTcMDAIsFazsyAVLM6hwdTRgXw0yxkV33uOJzew
k2/bt01QLXRGRj1aAqT6UgbZGa8K49BFX6ErMR6be3Acigdv4yEyOqdz0gyDDKm0
1Zez5X0YJaMvkbXqR6g7
=Yze2
-----END PGP SIGNATURE-----
--p2N8/IdOpufTRkPb--
