✅ Database connection OK

Host: urban-alert.com
Database: urbanale_urban_report

Tables

Preview: complaint

Showing up to 50 rows.

complaint_IDcompCategory_IDcomplaintPicturecomplaintRemarklocation_IDlatitudelongitudecomplaint_datecomplaint_timesubCategory_IDstatus_IDcomplaint_statusDateuser_IDcomplaint_numericcomplaintTypesubCategoryNamestatusTypelocationName
CM001CT001uploadedImage/img_66747a927e2b3.jpgMohon tindakan segera diambil.LC0022.285402925102.27061652024-06-0102:51:00CS001SS0062024-06-12US0011Road | JalanPotholes | Jalan BerlubangCompletedMT - Ayer Keroh
CM002CT003uploadedImage/img_66747d5d69ce3.jpgMohon tindakan segera diambil.LC0092.31247036102.28583482024-06-0103:04:00CS007SS0062024-06-12US0022Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM003CT001uploadedImage/img_66747de0e1293.jpgMohon tindakan segera diambil.LC0092.312243093102.28262742024-06-0103:06:00CS001SS0062024-06-12US0033Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM004CT001uploadedImage/img_66747e86cb657.jpgMohon tindakan segera diambil.LC0092.312210933102.28267032024-06-0103:09:00CS001SS0072024-06-13US0044Road | JalanPotholes | Jalan BerlubangRejectedAG - Durian Tunggal
CM005CT001uploadedImage/img_66747f179b17a.jpgMohon tindakan segera diambil.LC0092.325861308102.29507292024-06-0103:11:00CS001SS0072024-06-14US0055Road | JalanPotholes | Jalan BerlubangRejectedAG - Durian Tunggal
CM006CT003uploadedImage/img_66747fdf086c0.jpgMohon tindakan segera diambil.LC0022.269282716102.2879872024-06-0103:15:00CS010SS0062024-06-14US0066Vegetation | TumbuhanBlocked Sidewalks by Trees | Kaki Lima Terhalang Oleh PokokCompletedMT - Ayer Keroh
CM007CT002uploadedImage/img_66748039d0ba1.jpgMohon tindakan segera diambil.LC0022.269277356102.28805992024-06-0103:18:00CS005SS0062024-06-15US0077Drainage | SaliranMissing Drain Covers | Penutup Longkang HilangCompletedMT - Ayer Keroh
CM008CT002uploadedImage/img_667480df648c0.jpgMohon tindakan segera diambil.LC0022.269503557102.28758252024-06-0103:23:00CS003SS0062024-06-15US0088Drainage | SaliranClogged Drains | Longkang TersumbatCompletedMT - Ayer Keroh
CM009CT003uploadedImage/img_667481466a344.jpgMohon tindakan segera diambil.LC0092.312328854102.28527692024-06-0105:21:00CS007SS0062024-06-16US0099Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM010CT003uploadedImage/img_6674819eafb40.jpgMohon tindakan segera diambil.LC0092.312371734102.2857062024-06-0104:22:00CS007SS0062024-06-18US01010Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM011CT001uploadedImage/img_667482425f0ce.jpgMohon tindakan segera diambil.LC0092.327675666102.30035732024-06-0106:25:00CS001SS0062024-06-18US01111Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM012CT003uploadedImage/img_6674828a4fe58.jpgMohon tindakan segera diambil.LC0092.31269977102.28581982024-06-0105:26:00CS007SS0062024-06-19US01212Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM013CT001uploadedImage/img_667483761c416.jpgMohon tindakan segera diambil.LC0092.312213077102.28265422024-06-0103:36:00CS001SS0072024-06-19US01313Road | JalanPotholes | Jalan BerlubangRejectedAG - Durian Tunggal
CM014CT001uploadedImage/img_667483ba5f75f.jpgMohon tindakan segera diambil.LC0022.285361115102.2706172024-06-0103:31:00CS001SS0062024-06-19US01414Road | JalanPotholes | Jalan BerlubangCompletedMT - Ayer Keroh
CM015CT003uploadedImage/img_667484062d9ef.jpgMohon tindakan segera diambil.LC0092.312547544102.2859852024-06-0103:33:00CS007SS0062024-06-19US01515Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM016CT001uploadedImage/img_6674845e5ce8e.jpgMohon tindakan segera diambil.LC0092.312196997102.28287152024-06-0103:34:00CS001SS0062024-06-20US01616Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM017CT002uploadedImage/img_667484a3031c1.jpgMohon tindakan segera diambil.LC0092.327387298102.29976512024-06-0103:35:00CS003SS0062024-06-20US01717Drainage | SaliranClogged Drains | Longkang TersumbatCompletedAG - Durian Tunggal
CM018CT001uploadedImage/img_66754fd91a6c7.jpgMohon tindakan segera diambil.LC0022.284945167102.2710592024-06-0206:02:00CS001SS0062024-06-21US01818Road | JalanPotholes | Jalan BerlubangCompletedMT - Ayer Keroh
CM019CT003uploadedImage/img_66755078447fb.jpgMohon tindakan segera diambil.LC0092.312376023102.28510522024-06-0406:05:00CS007SS0062024-06-21US01919Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM020CT001uploadedImage/img_667550bd41c79.jpgMohon tindakan segera diambil.LC0092.312288118102.28245412024-06-0606:06:00CS001SS0062024-06-22US02020Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM021CT001uploadedImage/img_6675516b77b78.jpgMohon tindakan segera diambil.LC0092.312444095102.28241552024-06-0606:09:00CS001SS0072024-06-23US02121Road | JalanPotholes | Jalan BerlubangRejectedAG - Durian Tunggal
CM022CT001uploadedImage/img_667551c214644.jpgMohon tindakan segera diambil.LC0092.325956716102.29522312024-06-0606:10:00CS002SS0062024-06-24US02222Road | JalanFaded Road Markings | Tanda Jalan PudarCompletedAG - Durian Tunggal
CM023CT003uploadedImage/img_667552197e2dc.jpgMohon tindakan segera diambil.LC0022.269295044102.2880242024-06-0606:12:00CS010SS0072024-06-24US02323Vegetation | TumbuhanBlocked Sidewalks by Trees | Kaki Lima Terhalang Oleh PokokRejectedMT - Ayer Keroh
CM024CT002uploadedImage/img_667553257d8ae.jpgMohon tindakan segera diambil.LC0022.269278964102.28806422024-06-0606:13:00CS005SS0072024-06-24US02424Drainage | SaliranMissing Drain Covers | Penutup Longkang HilangRejectedMT - Ayer Keroh
CM025CT002uploadedImage/img_667555d81ad62.jpgMohon tindakan segera diambil.LC0022.269850898102.28749672024-06-0606:21:00CS003SS0062024-06-25US02525Drainage | SaliranClogged Drains | Longkang TersumbatCompletedMT - Ayer Keroh
CM026CT003uploadedImage/img_6675591f9348d.jpgMohon tindakan segera diambil.LC0092.312719066102.28621672024-06-0606:32:00CS007SS0062024-06-25US02626Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM027CT003uploadedImage/img_667559843f100.jpgMohon tindakan segera diambil.LC0092.312399607102.28539062024-06-0706:43:00CS007SS0062024-06-25US02727Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM028CT001uploadedImage/img_667559de10d89.jpgMohon tindakan segera diambil.LC0092.326958499102.29715262024-06-0606:45:00CS001SS0062024-06-26US02828Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM029CT003uploadedImage/img_66755a296bf1b.jpgMohon tindakan segera diambil.LC0092.313428736102.28780782024-06-0606:46:00CS007SS0062024-06-26US02929Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM030CT001uploadedImage/img_66755c76d2194.jpgMohon tindakan segera diambil.LC0092.312245237102.28286882024-06-0606:56:00CS001SS0062024-06-27US03030Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM031CT001uploadedImage/img_667641273a70a.jpgMohon tindakan segera diambil.LC0092.312131604102.28517822024-06-1011:12:00CS002SS0062024-06-27US03131Road | JalanFaded Road Markings | Tanda Jalan PudarCompletedAG - Durian Tunggal
CM032CT001uploadedImage/img_667642b802a80.jpgMohon tindakan segera diambil.LC0092.326612243102.29643062024-06-1011:15:00CS001SS0062024-06-28US03232Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM033CT002uploadedImage/img_6676431642a78.jpgMohon tindakan segera diambil.LC0092.327430178102.29985632024-06-1011:20:00CS004SS0062024-06-28US03333Drainage | SaliranBroken Drains | Longkang PecahCompletedAG - Durian Tunggal
CM034CT002uploadedImage/img_667643880a9e0.jpgMohon tindakan segera diambil.LC0092.327512722102.29992822024-06-1011:22:00CS003SS0062024-06-28US03434Drainage | SaliranClogged Drains | Longkang TersumbatCompletedAG - Durian Tunggal
CM035CT003uploadedImage/img_667643ddaa68e.jpgMohon tindakan segera diambil.LC0092.312740506102.28658582024-06-1011:23:00CS007SS0062024-06-29US03535Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM036CT001uploadedImage/img_66764519c996f.jpgMohon tindakan segera diambil.LC0092.326024788102.29536842024-06-1011:29:00CS001SS0072024-06-29US03636Road | JalanPotholes | Jalan BerlubangRejectedAG - Durian Tunggal
CM037CT003uploadedImage/img_667645e74962c.jpgMohon tindakan segera diambil.LC0092.312629017102.28646562024-06-1011:32:00CS007SS0062024-06-30US03737Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM038CT001uploadedImage/img_667646c80224f.jpgMohon tindakan segera diambil.LC0092.312355654102.28243432024-06-1011:36:00CS001SS0062024-06-30US03838Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM039CT001uploadedImage/img_667648f51633a.jpgMohon tindakan segera diambil.LC0092.31249716102.28242362024-06-1011:45:00CS001SS0072024-07-02US03939Road | JalanPotholes | Jalan BerlubangRejectedAG - Durian Tunggal
CM040CT001uploadedImage/img_667649ce3788c.jpgMohon tindakan segera diambil.LC0092.325854876102.29506212024-06-1011:48:00CS001SS0072024-07-03US04040Road | JalanPotholes | Jalan BerlubangRejectedAG - Durian Tunggal
CM041CT003uploadedImage/img_66764ab8d3084.jpgMohon tindakan segera diambil.LC0022.269289148102.28803852024-06-1011:52:00CS007SS0072024-07-03US04141Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongRejectedMT - Ayer Keroh
CM042CT002uploadedImage/img_66764b8eb7e35.jpgMohon tindakan segera diambil.LC0022.269270387102.28802942024-06-1011:56:00CS005SS0072024-07-04US04242Drainage | SaliranMissing Drain Covers | Penutup Longkang HilangRejectedMT - Ayer Keroh
CM043CT002uploadedImage/img_66764cbc97bd9.jpgMohon tindakan segera diambil.LC0092.327435538102.29982952024-06-1012:01:00CS004SS0062024-07-05US04343Drainage | SaliranBroken Drains | Longkang PecahCompletedAG - Durian Tunggal
CM044CT003uploadedImage/img_66764d88bc9c7.jpgMohon tindakan segera diambil.LC0092.313079261102.28720812024-06-1012:05:00CS007SS0072024-07-06US04444Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongRejectedAG - Durian Tunggal
CM045CT003uploadedImage/img_66764e1d6e597.jpgMohon tindakan segera diambil.LC0092.312517528102.28559452024-06-1012:07:00CS007SS0062024-07-06US04545Vegetation | TumbuhanUntrimmed Trees | Pokok Tidak DipotongCompletedAG - Durian Tunggal
CM046CT001uploadedImage/img_66764f14231f1.jpgMohon tindakan segera diambil.LC0092.32609554102.29554332024-06-1012:09:00CS001SS0062024-07-07US04646Road | JalanPotholes | Jalan BerlubangCompletedAG - Durian Tunggal
CM047CT001uploadedImage/img_66765005a04c4.jpgMohon tindakan segera diambil.LC0022.28531609102.27075432024-06-1012:15:00CS001SS0062024-07-07US04747Road | JalanPotholes | Jalan BerlubangCompletedMT - Ayer Keroh
CM048CT001uploadedImage/img_6676509eceaa0.jpgMohon tindakan segera diambil.LC0022.285203527102.27100652024-06-1012:17:00CS001SS0062024-07-08US04848Road | JalanPotholes | Jalan BerlubangCompletedMT - Ayer Keroh
CM049CT002uploadedImage/img_66765112972f0.jpgMohon tindakan segera diambil.LC0092.327344419102.29962562024-06-1012:20:00CS003SS0062024-07-09US04949Drainage | SaliranClogged Drains | Longkang TersumbatCompletedAG - Durian Tunggal
CM050CT002uploadedImage/img_66765188314b8.jpgMohon tindakan segera diambil.LC0092.327461266102.30020712024-06-1012:22:00CS003SS0062024-07-09US05050Drainage | SaliranClogged Drains | Longkang TersumbatCompletedAG - Durian Tunggal