Passenger Information System

sign Passenger Information System string(718) "SELECT a.*, cast(concat('[',group_concat(json_object('os_id',LPAD(b.id_shelter,7,'0'),'os_name',b.nama_selter) order by find_in_set(b.id_shelter, a.toshel) desc),']') as json) as shelter_array from ( SELECT a.origin,a.kor ,CONCAT_WS(',',SUBSTRING_INDEX(LEFT(a.routes,POSITION(',0044688' IN a.routes)-1),',',-7),'0044688') AS toshel ,a.toward,'' AS tw_lat,'' AS tw_lng, b.color,REPLACE(a.toward,' ','') as toward_ FROM ngi_routes_maps a left join ref_koridor b on a.kor = b.koridor and b.pref = 1 where a.pref=1 HAVING LENGTH(toshel)>8) a left join ngi_shelter_baru b on find_in_set(b.id_shelter, a.toshel) group by a.toshel,a.origin,a.toward,a.kor order by cast(a.kor as unsigned)"

Dinas Perhubungan
Daerah Istimewa Yogyakarta

1B
Halte ngabean

NGABEAN

KS TUBUN

SDN GEDONGTENGEN

LETJEN SUPRAPTO

JLAGRAN

STASIUN YOGYAKARTA

ABADI HOTEL JOGJA

ABU BAKAR ALI

2B
Halte ngabean

NGABEAN

KHA DAHLAN (SELATAN)

SENOPATI

HALTE KATAMSO 2

TPB PURAWISATA

HALTE SUGIONO 2

TPB PASAR SEPEDA TUNJUNGSARI

HALTE PSKY

3B
Condong Catur

NGABEAN

PORTABEL TEJOKUSUMAN (TAMANSARI)

HALTE MT HARYONO 2 (SMA N 7)

PORTABEL JL. MAYJEN SUTOYO (PASAR GADING)

PORTABEL JL. MAYJEN SUTOYO (JOKTENG WETAN)

HALTE SUGIONO 2

TPB PA MUHAMMADIYAH

TPB WIDYA WIWAHA 2

3A
Terminal Giwangan

NGABEAN

KHA DAHLAN (SELATAN)

MALIOBORO 3

MALIOBORO 2

MALIOBORO 1

EKS MENARA KOPI (SELATAN)

HALTE KRIDOSONO

HALTE BULOG

6
Halte Gamping (Ambarketawang)

NGABEAN

KHA DAHLAN (SELATAN)

MALIOBORO 3

6
Halte Malioboro 3

NGABEAN

PORTABEL TEJOKUSUMAN (TAMANSARI)

MUALLIMIN (UTARA)

PASAR LEGI YOGYAKARTA

TPB SMK SENI 2

SMAN 1 KASIHAN (BARAT)

TPB GEDUNG MADU CANDHYA 2

TPB SIMPANG DIKLAT DIY

8
Halte ngabean

NGABEAN

KHA DAHLAN (SELATAN)

MALIOBORO 3

MALIOBORO 2

MALIOBORO 1

EKS MENARA KOPI (SELATAN)

HALTE KRIDOSONO

9
Terminal Giwangan

NGABEAN

TPB RE MARTADINATA

HALTE SMA 1 YOGYAKARTA

HALTE SAUDAGARAN

HALTE SAMSAT

HOTEL UTARA (TIMUR)

KARANGWARU (TIMUR)

TPB TVRI ( TIIMUR )

9
Terminal Jombor

NGABEAN

PORTABEL TEJOKUSUMAN (TAMANSARI)

HALTE MT HARYONO 2 (SMA N 7)

PORTABEL JL. MAYJEN SUTOYO (PASAR GADING)

PORTABEL JL. MAYJEN SUTOYO (JOKTENG WETAN)

PASAR PRAWIROTAMAN (BARAT JALAN)

JOGOKARIYAN

SALAKAN DRUWO

10
Kusumanegara

NGABEAN

PORTABEL TEJOKUSUMAN (TAMANSARI)

MUALLIMIN (UTARA)

GKJ WIROBRAJAN (TIMUR)

SMP MUHAMMADIYAH 3

TPB MUSEUM BAHARI 2

TPB RUKO BAYEMAN 2

PALEM GURIH

10
Park Gamping

NGABEAN

KHA DAHLAN (SELATAN)

MALIOBORO 3

MALIOBORO 2

MALIOBORO 1

PORTABLE TERAS MALIOBORO 2

JL. MATARAM HOTEL AKUR

BAUSASRAN

11
Terminal Giwangan

NGABEAN

TPB RE MARTADINATA

HALTE SMA 1 YOGYAKARTA

HALTE SAUDAGARAN

HALTE SAMSAT

HALTE TJ DIPONEGORO

HALTE SUDIRMAN BUMIPUTERA

HALTE TJ KOTABARU

11
RS Panti Rapih

NGABEAN

PORTABEL TEJOKUSUMAN (TAMANSARI)

HALTE MT HARYONO 2 (SMA N 7)

SURYODININGRATAN (BARAT)

TPB RUBA GRAHA 1

TPB HOTEL PRAMESTHI

JOGOKARIYAN

TPB PASAR TELO 1

13
Halte Ngabean

NGABEAN

KHA DAHLAN (SELATAN)

MALIOBORO 3

MALIOBORO 2

MALIOBORO 1

EKS MENARA KOPI (SELATAN)

HALTE KRIDOSONO

15
Terminal Palbapang (B)

NGABEAN

KHA DAHLAN (SELATAN)

MALIOBORO 3

15
Halte Malioboro 3

NGABEAN

PORTABEL TEJOKUSUMAN (TAMANSARI)

FIP UNY

DUKUH (BARAT)

TPB PASTY

SIMPANG DONGKELAN (HALTE 2)

PASAR NITEN (HALTE 2)

SIMPANG KASONGAN (HALTE 2)

Technical Support Trans Jogja Istimewa : +62 853-2639-8448