<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">This looks <i>really, really, really</i> nice.<div><br></div><div>Thanks for releasing!</div><div><br><div>
<div><div style="font-family: arial; font-size: small; "><div style="margin: 0px; "><span style="font-size: 9pt; font-family: Helvetica, sans-serif; ">Skye Book</span><u></u><u></u></div></div><div style="font-family: arial; font-size: small; "><div><div style="margin: 0px; "><span style="font-size: 9pt; font-family: Helvetica, sans-serif; "><a href="http://skyebook.net" target="_blank"><font color="#0433ff">http://skyebook.net</font></a> -- <a href="https://twitter.com/sbook" target="_blank"><font color="#0433ff">@sbook</font></a></span></div></div></div></div>
</div>
<br><div><div>On Feb 7, 2013, at 5:18 PM, Andy Colson <<a href="mailto:andy@squeakycode.net">andy@squeakycode.net</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">On 12/13/2011 10:35 PM, Stephen Woodbridge wrote:<br><blockquote type="cite">On 12/13/2011 10:16 PM, Andy Colson wrote:<br><blockquote type="cite">I downloaded PostGis 2 to play around with, and tried out the tiger<br>stuff. I have to say, that's kinda painful.<br><br>The doc says: add "set -e -u", which causes as many problems as it might<br>catch.<br>Editing the .sql was a little confusing, and the resulting .sh file is<br>not really re-startable.<br><br>Would anyone be interested in a perl script to simplify things? I'm<br>thinking of replacing the stored proc that generates a script, all of<br>which you have to edit, with a perl script (which would have a config to<br>edit).<br><br>Or... maybe other's have not had the problems I had? I don't really have<br>a use for this right now, just playing around. If anyone had some<br>requests, I might be interested in working on it.<br></blockquote><br>Andy,<br><br>I think this would be a good idea. One trick I use a lot with Perl is<br>find2perl which I use to walk a directory structure like the Tiger<br>source tree to find the files I want to load.<br><br>Also Census just released the Tiger2011 files, unfortunately, they have<br>only released them in the type directory structure and not in the state<br>directory structure. Each year there are file name changes and column<br>name changes within the files. I think using Perl would make it easier<br>to remap these column names.<br><br>-Steve<br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></blockquote><br><br>Its only been a year... not to bad for a turn around time :-)<br><br>I started on a perl program to import data, but then got side tracked and forgot about it.<br><br>Few weeks ago I needed to pull more data, so I dusted off my script, cleaned it up, ran it, and published it:<br><br><a href="https://github.com/AndyColson/tigerLoader">https://github.com/AndyColson/tigerLoader</a><br><br>It only does 2010 data, and I might have gotten carried away with the threads. I'm not sure how easy it'll be for others to use.<br><br>But there it is.<br><br>-Andy<br><br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@lists.osgeo.org<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br></blockquote></div><br></div></body></html>