$periksa_jln = NULL;
}
//cek listrik
/* $cek_listrik="SELECT gridcode FROM listrik WHERE(ST_Within(ST_SetSRID(ST_MakePoint($lng,$lat),4326), geom))";
$kueri= $cek_listrik;
$output_listrik = run_kueri($pg_conn_string, $kueri);
$listrik=$output_listrik;
if($listrik[0]==1){
$periksa_listrik="<li style='text-align:left;'>Lokasi terlalu jauh dari jaringan listrik<br />(jarak ke jaringan listrik > 200 m).<br /><strong>Rekomendasi: jarak < 200 m</strong></li>";
} ELSE {
$periksa_listrik=NULL;
} */
//cek bencana
$cek_bcn = "SELECT gridcode FROM bencana WHERE(ST_Within(ST_SetSRID(ST_MakePoint({$lng},{$lat}),4326), geom))";
$kueri = $cek_bcn;
$output_bcn = run_kueri($pg_conn_string, $kueri);
$bcn = $output_bcn;
if ($bcn[0] == 2) {
$periksa_bcn = "<li style='text-align:left;'>Lokasi berada pada daerah rawan bencana</li>";
} else {
$periksa_bcn = NULL;
}
if ($jlhbaris == 0) {
echo "<h4>Data tidak tersedia!</h4>";
echo "<strong>Lokasi anda di luar Parung?<br />Silakan klik tombol isi manual dengan form</strong>";
} else {
echo "<table class='table table-striped table-hover'>";
echo "<thead>";
echo "<tr>";
echo "<th>Desa</th>";
echo "<th>Luas desa</th>";
pie: {
allowPointSelect: true,
cursor: 'pointer',
dataLabels: {
enabled: false
},
showInLegend: true
}
},
series: [{
type: 'pie',
name: 'Luas',
<?php
$jlh_row = "SELECT count(*) FROM persenluas AS p, desa AS d WHERE skor>3 AND p.id_desa=d.id_desa";
$kueri = $jlh_row;
$jlhrow = run_kueri($pg_conn_string, $kueri);
$slc_kode = "SELECT d.nama_desa, p.luas FROM persenluas AS p, desa AS d WHERE skor>3 AND p.id_desa=d.id_desa ORDER BY p.luas";
$kueri = $slc_kode;
$conn = pg_pconnect($pg_conn_string);
$hasil = pg_query($conn, $kueri);
$hasilrekom = pg_fetch_all($hasil);
?>
data: [
['Iwul', 192.09],
['Jabon Mekar', 45.61],
['Pamagersari', 41.89],
['Warujaya', 36.86],
['Parung', 28.59],
['Waru', 102.91],
['Cogreg', 116.239],
['Bojong Indah', 15.74],
