crazy

From: Ed King 
------------------------------------------------------
slackware fanboy, so I usually download source and compile and install.=A0=
=A0=A0=A0 I'm crazy like that.=0A=0Aso anyway I'm currently attempting to i=
nstall postgis and the census tiger data to set up my own local geocode dat=
abase because geocoder.us is getting flakey lately=0A=0A=0Apart of the depe=
ndancies was this... http://gdal.org/=0AI don't claim to understand what it=
 does, but I's need it=0A=0Aanyway, the whole point of this worthless email=
 is that I was amazed at how long it took to compile the source code for gd=
al on an amd64 quad 3ghz with 8gb ram=0A=0AI might re-compile it again, thi=
s time put a timer on it...=A0=A0=A0 cause I'm crazy like that=0A=0Aand the=
n get back to my Drupal tutorial ;-)=0A

=============================================================== From: Ed King ------------------------------------------------------ after 3 false starts (script errors) and HOURS of downloading census data f= iles, I have a local postgresql/postgis database of TN geocodes...=A0=A0 wo= ohoo...=0A=0Ageo=3D# select ST

=============================================================== From: K I Goldman ------------------------------------------------------ RnJvbSB3aGVyZSBhcmUgeW91IGRvd25sb2FkaW5nIHRoZSBjZW5zdXMgZGF0YT8NCg0KVGhlIHBy b3RlaW4gZGF0YWJhc2UgaXMgYWxzbyBmdW4gdG8gcGxheSB3aXRoLiANCg0KS2VpdGgNCg0KPiBP biBOb3YgMTYsIDIwMTMsIGF0IDEyOjU5IFBNLCAiRWQgS2luZyIgPGNoZXZ5aWlub3ZhQGJlbGxz b3V0aC5uZXQ+IHdyb3RlOg0KPiANCj4gc2xhY2t3YXJlIGZhbmJveSwgc28gSSB1c3VhbGx5IGRv d25sb2FkIHNvdXJjZSBhbmQgY29tcGlsZSBhbmQgaW5zdGFsbC4gICAgIEknbSBjcmF6eSBsaWtl IHRoYXQuDQo+IA0KPiBzbyBhbnl3YXkgSSdtIGN1cnJlbnRseSBhdHRlbXB0aW5nIHRvIGluc3Rh bGwgcG9zdGdpcyBhbmQgdGhlIGNlbnN1cyB0aWdlciBkYXRhIHRvIHNldCB1cCBteSBvd24gbG9j YWwgZ2VvY29kZSBkYXRhYmFzZSBiZWNhdXNlIGdlb2NvZGVyLnVzIGlzIGdldHRpbmcgZmxha2V5 IGxhdGVseQ0KPiANCj4gcGFydCBvZiB0aGUgZGVwZW5kYW5jaWVzIHdhcyB0aGlzLi4uIGh0dHA6 Ly9nZGFsLm9yZy8NCj4gSSBkb24ndCBjbGFpbSB0byB1bmRlcnN0YW5kIHdoYXQgaXQgZG9lcywg YnV0IEkncyBuZWVkIGl0DQo+IA0KPiBhbnl3YXksIHRoZSB3aG9sZSBwb2ludCBvZiB0aGlzIHdv cnRobGVzcyBlbWFpbCBpcyB0aGF0IEkgd2FzIGFtYXplZCBhdCBob3cgbG9uZyBpdCB0b29rIHRv IGNvbXBpbGUgdGhlIHNvdXJjZSBjb2RlIGZvciBnZGFsIG9uIGFuIGFtZDY0IHF1YWQgM2doeiB3 aXRoIDhnYiByYW0NCj4gDQo+IEkgbWlnaHQgcmUtY29tcGlsZSBpdCBhZ2FpbiwgdGhpcyB0aW1l IHB1dCBhIHRpbWVyIG9uIGl0Li4uICAgIGNhdXNlIEknbSBjcmF6eSBsaWtlIHRoYXQNCj4gDQo+ IGFuZCB0aGVuIGdldCBiYWNrIHRvIG15IERydXBhbCB0dXRvcmlhbCA7LSkNCj4gX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCj4gQ2h1Z2FsdWcgbWFpbGlu ZyBsaXN0DQo+IENodWdhbHVnQGNodWdhbHVnLm9yZw0KPiBodHRwOi8vY2h1Z2FsdWcub3JnL2Nn aS1iaW4vbWFpbG1hbi9saXN0aW5mby9jaHVnYWx1Zw0K

=============================================================== From: Ed King ------------------------------------------------------ install postgis and look at the readme file in the extras/tiger folder, and= all will become clear. :)=0A=0Apostgis generates a bash script that will d= ownload the census data and squirt it into the postgis-enabled postgres dat= abase...=A0=A0=A0=A0 =0A=0A=0Ahere's a sample...=0A=0Aset -e -u=0ATMPDIR=3D= "/sdb1/gisdata/temp/"=0AUNZIPTOOL=3Dunzip=0AWGETTOOL=3D"/usr/bin/wget"=0Aex= port PGBIN=3D/usr/local/pgsql/bin/=0Aexport PGPORT=3D5432=0Aexport PGHOST= =3Dlocalhost=0Aexport PGUSER=3Dpostgres=0Aexport PGPASSWORD=3Ded