From 1663dd49a4cd91ca529357aa6608b8c0cde8ce23 Mon Sep 17 00:00:00 2001
From: Brian Quinion <openstreetmap@brian.quinion.co.uk>
Date: Tue, 16 Nov 2010 13:24:52 +0000
Subject: [PATCH] more tiger import code

---
 utils/imports.php           | 43 +++++++++++++++++++++++++++++++++++++
 utils/tigerAddressImport.py |  8 +++----
 2 files changed, 47 insertions(+), 4 deletions(-)
 create mode 100755 utils/imports.php

diff --git a/utils/imports.php b/utils/imports.php
new file mode 100755
index 00000000..7e9de8e4
--- /dev/null
+++ b/utils/imports.php
@@ -0,0 +1,43 @@
+#!/usr/bin/php -Cq
+<?php
+
+	require_once(dirname(dirname(__FILE__)).'/lib/init-cmd.php');
+	ini_set('memory_limit', '800M');
+
+	$aCMDOptions = array(
+		"Create and setup nominatim search system",
+		array('help', 'h', 0, 1, 0, 0, false, 'Show Help'),
+		array('quiet', 'q', 0, 1, 0, 0, 'bool', 'Quiet output'),
+		array('verbose', 'v', 0, 1, 0, 0, 'bool', 'Verbose output'),
+
+		array('parse-tiger', '', 0, 1, 1, 1, 'realpath', 'Convert tigger edge files to nominatim sql import'),
+	);
+	getCmdOpt($_SERVER['argv'], $aCMDOptions, $aCMDResult, true, true);
+
+	$bDidSomething = false;
+
+	if (isset($aCMDResult['parse-tiger']))
+	{
+		$sTempDir = tempnam('/tmp', 'tiger');
+		unlink($sTempDir);
+		mkdir($sTempDir);
+
+		foreach(glob($aCMDResult['parse-tiger'].'/??_*', GLOB_ONLYDIR) as $sStateFolder)
+		{
+			foreach(glob($sStateFolder.'/?????_*', GLOB_ONLYDIR) as $sCountyFolder)
+			{
+				preg_match('#([0-9]{5})_(.*)#',basename($sCountyFolder), $aMatch);
+				$sCountyID = $aMatch[1];
+				$sCountyName = str_replace('_', ' ', $aMatch[2]);
+				$sImportFile = $sCountyFolder.'/tl_2009_'.$sCountyID.'_edges.zip';
+				if (!file_exists($sImportFile))
+				{
+					echo "Missing: $sImportFile\n";
+				}
+				$sUnzipCmd = "unzip -d $sTempDir $sImportFile";
+var_dump($sUnzipCmd);
+exit;
+//				exec($sUnzipCmd);
+			}
+		}
+	}
diff --git a/utils/tigerAddressImport.py b/utils/tigerAddressImport.py
index 9bb63590..0dd8b3f9 100755
--- a/utils/tigerAddressImport.py
+++ b/utils/tigerAddressImport.py
@@ -996,7 +996,7 @@ county_fips = {
 '19135' : 'Monroe, IA' ,
 '19137' : 'Montgomery, IA' ,
 '19139' : 'Muscatine, IA' ,
-'19141' : 'O'Brien, IA' ,
+'19141' : 'O\'Brien, IA' ,
 '19143' : 'Osceola, IA' ,
 '19145' : 'Page, IA' ,
 '19147' : 'Palo Alto, IA' ,
@@ -1350,9 +1350,9 @@ county_fips = {
 '24027' : 'Howard, MD' ,
 '24029' : 'Kent, MD' ,
 '24031' : 'Montgomery, MD' ,
-'24033' : 'Prince George's, MD' ,
-'24035' : 'Queen Anne's, MD' ,
-'24037' : 'St. Mary's, MD' ,
+'24033' : 'Prince George\'s, MD' ,
+'24035' : 'Queen Anne\'s, MD' ,
+'24037' : 'St. Mary\'s, MD' ,
 '24039' : 'Somerset, MD' ,
 '24041' : 'Talbot, MD' ,
 '24043' : 'Washington, MD' ,
-- 
2.45.1