pile foundation is the type of deep foundation, ie the depth
of foundation is greater than the width.

a type of foundation which is used for the highrise 
buildings, and in the soft soil.

a type of foundation which is used for the highrise 
buildings, and in the soft soil.

Pile foundations are the part of a structure used to carry 
and transfer the load of the structure to the bearing 
ground located at some depth below ground surface. The main 
components of the foundation are the pile cap and the 
piles. Piles are long and slender members which transfer 
the load to deeper soil or rock of high bearing capacity 
avoiding shallow soil of low bearing capacity The main 
types of materials used for piles are Wood, steel and 
concrete. Piles made from these materials are driven, 
drilled or jacked into the ground and connected to pile 
caps. Depending upon type of soil, pile material and load 
transmitting characteristic piles are classified 
accordingly. In the following chapter we learn about, 
classifications, functions and pros and cons of piles.

Pile foundation is a deep foundation & it is uses to 
transfer the heavy load. the ratio of the l/b is very high.
It is uses when the bearing capacity of soil is very less.

SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename

select sitename,count(sitename) as total_sites  from
tbl_sites group by sitename having (count(sitename)>1)

SELECT sitename,COUNT(sitename) FROM tbl_sites GROUP BY
sitename