SELECT  f.id  FROM intensive_hotspots AS f, test WHERE f.id<>test.id;

#!/usr/bin/php
<?php
$dbconn=pg_connect("host=***** port=**** dbname=***** user=***** password=****") or die('Could not connect' . pg_last_error());
$createTempTableQuery = "CREATE TEMP  TABLE intensive_hotspots AS (SELECT * FROM hotspots WHERE probability > 80);";
$nearPointsQuery = "CREATE TEMP  TABLE near_point AS (SELECT f.id as f_id, f.power AS f_power, s.id AS s_id, s.power AS s_power,
 ST_Distance_Sphere(f.the_geom, s.the_geom)  FROM intensive_hotspots f, intensive_hotspots s WHERE ST_Distance_Sphere(f.the_geom, s.the_geom) < 2000 and f.id<>s.id AND f.id <s.id);";
pg_query($createTempTableQuery);
pg_query($nearPointsQuery);
$selectQuery = "SELECT * FROM near_point;";
$result = pg_query($selectQuery);
while($notice[]=pg_fetch_row($result));
array_pop($notice);
$delete_point = array();
$true_point = array();
$length_array = count($notice)-1;
for ($i=0; $i<=$length_array;$i += $count_i){
        $count_i = 0;
        $length_small_array = count($notice[$i]);
        $near_point_array = array(array());
        for ($k=0; $k<$length_small_array; $k++){
                $near_point_array[0][$k]=$notice[$i][$k];
        }
        for ($j=$i+1; $j<=$length_array;$j++){
                if ($notice[$i][0] == $notice[$j][0]){
                        for ($k=0; $k<$length_small_array; $k++){
                                $near_point_array[$count_i+1][$k]=$notice[$j][$k];
                        }
                        $count_i=$count_i+1;
                } else {
                        break;
                }
        }
        $true = 0;
        $true_1_i;
        $true_2_i;
        for ($j=0; $j<count($near_point_array);$j++){
                $a = $near_point_array[$j][1];
                $b = $near_point_array[$j][3];
                if ($a >= $b){
                        array_push($delete_point,$near_point_array[$j][2]);
                        $max = $a;
                        $max_1_i = $j;
                        $max_2_i = 0;
                } else {
                        array_push($delete_point,$near_point_array[$j][0]);
                        $max = $b;
                        $max_1_i = $j;
                        $max_2_i = 2;
                }
                if ($true < $max){
                        $true = $max;
                        $true_1_i = $max_1_i;
                        $true_2_i = $max_2_i;
                }
        }
        array_push($true_point,$near_point_array[$true_1_i][$true_2_i]);
        $count_i = $count_i+1;
}
$createTempDeletePointTable = "CREATE TEMP TABLE delete_point (id int);";
pg_query($createTempDeletePointTable);
for ($i=0; $i<count($delete_point); $i++){
        pg_query("INSERT INTO delete_point VALUES('$delete_point[$i]');");
}
$truePointQuery = "SELECT f.id, temperature,height_size, width_size, probability, power, the_geom, time_recieve FROM intensive_hotspots AS f, delete_point WHERE f.id<>delete_point.id;";
$r = pg_query($truePointQuery);
pg_close($dbconn);
?>