X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/02bd322c1dc185a6eef072de7398c190fe7a2e0c..4f9f21f661685d4b14654253dacb09848b16d69c:/utils/setup.php?ds=sidebyside diff --git a/utils/setup.php b/utils/setup.php index 60fe5dac..0026a813 100755 --- a/utils/setup.php +++ b/utils/setup.php @@ -156,9 +156,10 @@ { echo "WARNING: external UK postcode table not found.\n"; } - pgsqlRunScriptFile(CONST_BasePath.'/data/us_statecounty.sql'); - pgsqlRunScriptFile(CONST_BasePath.'/data/us_state.sql'); - pgsqlRunScriptFile(CONST_BasePath.'/data/us_postcode.sql'); + if (CONST_Use_Extra_US_Postcodes) + { + pgsqlRunScriptFile(CONST_BasePath.'/data/us_postcode.sql'); + } if ($aCMDResult['no-partitions']) { @@ -509,10 +510,13 @@ $sSQL .= "from placex where postcode is not null group by calculated_country_code,postcode) as x"; if (!pg_query($oDB->connection, $sSQL)) fail(pg_last_error($oDB->connection)); - $sSQL = "insert into placex (osm_type,osm_id,class,type,postcode,calculated_country_code,geometry) "; - $sSQL .= "select 'P',nextval('seq_postcodes'),'place','postcode',postcode,'us',"; - $sSQL .= "ST_SetSRID(ST_Point(x,y),4326) as geometry from us_postcode"; - if (!pg_query($oDB->connection, $sSQL)) fail(pg_last_error($oDB->connection)); + if (CONST_Use_Extra_US_Postcodes) + { + $sSQL = "insert into placex (osm_type,osm_id,class,type,postcode,calculated_country_code,geometry) "; + $sSQL .= "select 'P',nextval('seq_postcodes'),'place','postcode',postcode,'us',"; + $sSQL .= "ST_SetSRID(ST_Point(x,y),4326) as geometry from us_postcode"; + if (!pg_query($oDB->connection, $sSQL)) fail(pg_last_error($oDB->connection)); + } } if ($aCMDResult['osmosis-init'] || ($aCMDResult['all'] && !$aCMDResult['drop'])) // no use doing osmosis-init when dropping update tables