[Chugalug] crazy

Ed King chevyiinova at bellsouth.net
Mon Nov 18 12:48:55 UTC 2013


after 3 false starts (script errors) and HOURS of downloading census data files, I have a local postgresql/postgis database of TN geocodes...   woohoo...

geo=# select ST_X(geomout),ST_Y(geomout),(addy).* from geocode('928 McCallie Ave Chattanooga TN');

       st_x        |       st_y       | address | predirabbrev | streetname | streettypeabbrev | postdirabbrev | internal |  location   | stateabbrev |  zip  | parsed
-------------------+------------------+---------+--------------+------------+------------------+---------------+----------+-------------+-------------+-------+--------
 -85.2923689434073 | 35.0423585097344 |     928 |              | McCallie   | Ave              |               |          | Chattanooga | TN          | 37403 | t
 -85.2845940259718 | 35.0394792200586 |    1124 |              | McCallie   | Ave              |               |          | Chattanooga | TN          | 37404 | t
(2 rows)


if it takes 3 hours of downloading census data files per state...      and there are 50 states...      hmmm, this might take awhile...     




________________________________
 From: Ed King <chevyiinova at bellsouth.net>
To: Chattanooga Unix Gnu Android Linux Users Group <chugalug at chugalug.org> 
Sent: Saturday, November 16, 2013 12:59 PM
Subject: [Chugalug] crazy
 


slackware fanboy, so I usually download source and compile and install.     I'm crazy like that.

so anyway I'm currently attempting to install postgis and the census tiger data to set up my own local geocode database because geocoder.us is getting flakey lately


part of the dependancies was this... http://gdal.org/
I don't claim to understand what it does, but I's need it

anyway, the whole point of this worthless email is that I was amazed at how long it took to compile the source code for gdal on an amd64 quad 3ghz with 8gb ram

I might re-compile it again, this time put a timer on it...    cause I'm crazy like that

and then get back to my Drupal tutorial ;-)

_______________________________________________
Chugalug mailing list
Chugalug at chugalug.org
http://chugalug.org/cgi-bin/mailman/listinfo/chugalug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://chugalug.org/pipermail/chugalug/attachments/20131118/cf3a864a/attachment.html>


More information about the Chugalug mailing list