Internal Server Error

Nominatim has encountered an internal error while processing your request. This is most likely because of a bug in the software.

Details: ".$sError,"

Feel free to report the bug in the OSM bug database. Please include the error message above an the URL you used.

Debugging Information

SQL query

Result

";
//var_dump($aAddressLines);
		$aAddress = array();
		$aClassType = getClassTypes();
		foreach($aAddressLines as $aLine)
		{
			$aTypeLabel = false;
			if (isset($aClassType[$aLine['class'].':'.$aLine['type'].':'.$aLine['admin_level']])) $aTypeLabel = $aClassType[$aLine['class'].':'.$aLine['type'].':'.$aLine['admin_level']];
			elseif (isset($aClassType[$aLine['class'].':'.$aLine['type']])) $aTypeLabel = $aClassType[$aLine['class'].':'.$aLine['type']];
			else $aTypeLabel = array('simplelabel'=>$aLine['class']);
			if ($aTypeLabel && ($aLine['localname'] || $aLine['housenumber']))
			{
				$sTypeLabel = strtolower(isset($aTypeLabel['simplelabel'])?$aTypeLabel['simplelabel']:$aTypeLabel['label']);
				$sTypeLabel = str_replace(' ','_',$sTypeLabel);
				if (!isset($aAddress[$sTypeLabel]) && $aLine['localname']) $aAddress[$sTypeLabel] = $aLine['localname']?$aLine['localname']:$aLine['housenumber'];
			}
		}
//var_dump($aAddress);
//exit;
		return $aAddress;

		$aHouseNumber = $oDB->getRow('select housenumber, get_name_by_language(name,ARRAY[\'addr:housename\']) as housename,rank_search,postcode from placex where place_id = '.$iPlaceID);
		$sHouseNumber = $aHouseNumber['housenumber'];
		$sHouseName = $aHouseNumber['housename'];
		$sPostcode = $aHouseNumber['postcode'];
		$iRank = $aHouseNumber['rank_search'];

	        // Address
        	$sSQL = "select country_code, placex.place_id, osm_type, osm_id, class, type, housenumber, admin_level, rank_address, rank_search, ";
	        $sSQL .= "get_searchrank_label(rank_search) as rank_search_label, fromarea, isaddress, distance, ";
        	$sSQL .= " CASE WHEN type = 'postcode' THEN postcode ELSE get_name_by_language(name,$sLanguagePrefArraySQL) END as localname, ";
		$sSQL .= " length(name::text) as namelength ";
	        $sSQL .= " from place_addressline join placex on (address_place_id = placex.place_id)";
        	$sSQL .= " where place_addressline.place_id = $iPlaceID and (rank_address > 0 OR address_place_id = $iPlaceID)";
		if (!$bRaw) $sSQL .= " and isaddress";
        	$sSQL .= " order by cached_rank_address desc,isaddress desc,fromarea desc,distance asc,rank_search desc,namelength desc";
//var_dump($sSQL);
	        $aAddressLines = $oDB->getAll($sSQL);
        	if (PEAR::IsError($aAddressLines))
	        {
        	        var_dump($aAddressLines);
                	exit;
	        }
		if ($bRaw) return $aAddressLines;
	
		$aClassType = getClassTypes();

		$iMinRank = 100;
		$aAddress = array();
		if ($iRank >= 28 && $sHouseNumber) $aAddress['house_number'] = $sHouseNumber;
		if ($iRank >= 28 && $sHouseName) $aAddress['house_name'] = $sHouseName;
		foreach($aAddressLines as $aLine)
		{
			if (!$sCountryCode) $sCountryCode = $aLine['country_code'];
			if ($aLine['rank_address'] < $iMinRank)
			{
				$aTypeLabel = false;
				if (isset($aClassType[$aLine['class'].':'.$aLine['type'].':'.$aLine['admin_level']])) $aTypeLabel = $aClassType[$aLine['class'].':'.$aLine['type'].':'.$aLine['admin_level']];
				elseif (isset($aClassType[$aLine['class'].':'.$aLine['type']])) $aTypeLabel = $aClassType[$aLine['class'].':'.$aLine['type']];
				else $aTypeLabel = array('simplelabel'=>$aLine['class']);
				if ($aTypeLabel && ($aLine['localname'] || $aLine['housenumber']))
				{
					$sTypeLabel = strtolower(isset($aTypeLabel['simplelabel'])?$aTypeLabel['simplelabel']:$aTypeLabel['label']);
					$sTypeLabel = str_replace(' ','_',$sTypeLabel);
					if (!isset($aAddress[$sTypeLabel]) && $aLine['localname']) $aAddress[$sTypeLabel] = $aLine['localname']?$aLine['localname']:$aLine['housenumber'];
				}
				$iMinRank = $aLine['rank_address'];
			}
		}

		if ($sPostcode)
		{
			$aAddress['postcode'] = $sPostcode;
		}

		if ($iMinRank > 4 && $sCountryCode)
		{
			$sSQL = "select get_name_by_language(country_name.name,$sLanguagePrefArraySQL) as name";
			$sSQL .= " from country_name where country_code = '$sCountryCode'";
			$sCountryName = $oDB->getOne($sSQL);
			if ($sCountryName)
			{
				$aAddress['country'] = $sCountryName;
			}
		}
		if ($sCountryCode)
		{
			$aAddress['country_code'] = $sCountryCode;
		}

		return $aAddress;
	}

	function getWordSuggestions(&$oDB, $sWord)
	{
		$sWordQuoted = getDBQuoted(trim($sWord));
		$sSQL = "select *,levenshtein($sWordQuoted,word) from test_token ";
		$sSQL .= "where (metaphone = dmetaphone($sWordQuoted) or metaphonealt = dmetaphone($sWordQuoted) or ";
		$sSQL .= "metaphone = dmetaphone_alt($sWordQuoted) or metaphonealt = dmetaphone_alt($sWordQuoted)) ";
		$sSQL .= "and len between length($sWordQuoted)-2 and length($sWordQuoted)+2 ";
		$sSQL .= "and levenshtein($sWordQuoted,word) < 3 ";
		$sSQL .= "order by levenshtein($sWordQuoted,word) asc, abs(len - length($sWordQuoted)) asc limit 20";
		$aSimilar = $oDB->getAll($sSQL);
		return $aSimilar;
	}

	function geocodeReverse($fLat, $fLon, $iZoom=18)
	{
		$oDB =& getDB();

		$sPointSQL = "ST_SetSRID(ST_Point($fLon,$fLat),4326)";

		// Zoom to rank, this could probably be calculated but a lookup gives fine control
		$aZoomRank = array(
			0 => 2, // Continent / Sea
			1 => 2,
			2 => 2,
			3 => 4, // Country
			4 => 4,
			5 => 8, // State
			6 => 10, // Region
			7 => 10, 
			8 => 12, // County
			9 => 12,  
			10 => 17, // City
			11 => 17, 
			12 => 18, // Town / Village
			13 => 18, 
			14 => 22, // Suburb
			15 => 22,
			16 => 26, // Street, TODO: major street?
			17 => 26, 
			18 => 30, // or >, Building
			19 => 30, // or >, Building
			);
		$iMaxRank = isset($aZoomRank[$iZoom])?$aZoomRank[$iZoom]:28;

		// Find the nearest point
		$fSearchDiam = 0.0001;
		$iPlaceID = null;
		$aArea = false;
		$fMaxAreaDistance = 1;
		while(!$iPlaceID && $fSearchDiam < $fMaxAreaDistance)
		{
			$fSearchDiam = $fSearchDiam * 2;

			// If we have to expand the search area by a large amount then we need a larger feature
			// then there is a limit to how small the feature should be
			if ($fSearchDiam > 2 && $iMaxRank > 4) $iMaxRank = 4;
			if ($fSearchDiam > 1 && $iMaxRank > 9) $iMaxRank = 8;
			if ($fSearchDiam > 0.8 && $iMaxRank > 10) $iMaxRank = 10;
			if ($fSearchDiam > 0.6 && $iMaxRank > 12) $iMaxRank = 12;
			if ($fSearchDiam > 0.2 && $iMaxRank > 17) $iMaxRank = 17;
			if ($fSearchDiam > 0.1 && $iMaxRank > 18) $iMaxRank = 18;
			if ($fSearchDiam > 0.008 && $iMaxRank > 22) $iMaxRank = 22;
			if ($fSearchDiam > 0.001 && $iMaxRank > 26) $iMaxRank = 26;

			$sSQL = 'select place_id,parent_place_id from placex';
			$sSQL .= ' WHERE ST_DWithin('.$sPointSQL.', geometry, '.$fSearchDiam.')';
			$sSQL .= ' and rank_search != 28 and rank_search >= '.$iMaxRank;
			$sSQL .= ' and (name is not null or housenumber is not null)';
			$sSQL .= ' and class not in (\'waterway\')';
			$sSQL .= ' and (ST_GeometryType(geometry) not in (\'ST_Polygon\',\'ST_MultiPolygon\') ';
			$sSQL .= ' OR ST_DWithin('.$sPointSQL.', ST_Centroid(geometry), '.$fSearchDiam.'))';
			$sSQL .= ' ORDER BY ST_distance('.$sPointSQL.', geometry) ASC limit 1';
//var_dump($sSQL);
			$aPlace = $oDB->getRow($sSQL);
			$iPlaceID = $aPlace['place_id'];
			if (PEAR::IsError($iPlaceID))
			{
				var_Dump($sSQL, $iPlaceID); 
				exit;
			}
		}

		// The point we found might be too small - use the address to find what it is a child of
		if ($iPlaceID)
		{
			$sSQL = "select address_place_id from place_addressline where cached_rank_address <= $iMaxRank and place_id = $iPlaceID order by cached_rank_address desc,isaddress desc,distance desc limit 1";
			$iPlaceID = $oDB->getOne($sSQL);
			if (PEAR::IsError($iPlaceID))
			{
				var_Dump($sSQL, $iPlaceID); 
				exit;
			}

			if ($iPlaceID && $aPlace['place_id'] && $iMaxRank < 28)
			{
				$sSQL = "select address_place_id from place_addressline where cached_rank_address <= $iMaxRank and place_id = ".$aPlace['place_id']." order by cached_rank_address desc,isaddress desc,distance desc";
				$iPlaceID = $oDB->getOne($sSQL);
				if (PEAR::IsError($iPlaceID))
				{
					var_Dump($sSQL, $iPlaceID); 
					exit;
				}
			}
			if (!$iPlaceID)
			{
				$iPlaceID = $aPlace['place_id'];
			}
		}

		return $iPlaceID;
	}