Dear sir

I have drilled bore well in my agricultural land near Manaparai, Tamilnadu. First water source comes from 450ft (1/2 inch water), and after that there is no water source upto 800ft., but wet sand comes till the last .
Now water is available @ 450 ft.
My question is what type of compressor & what hp should we use for it & how deep should  we put the hose to lift water for get maximum yield.

Thank you for your help in advance.

Regards,
Venkatesh