SELECT
MIN(TU.id),
LV.LINE,
LV.ZONE,
drop table tab1 purge;
create table tab1(
LINE varchar2(10),
ZONE varchar2(10),
TRACK varchar2(15),
START_MARKER number,
START_OFFSET number,
TURNOUT_ID number,
ASSET_TAG varchar2(10),
CLASS varchar2(5),
GPS_LONG number,
GPS_LAT number
);
insert into tab1 values( 'MAIN LINE', 'TRAMO 2', 'LINEA FERREA', 2, 180, 768, 'SW MOW 1', 'N/A', 1, 1);
insert into tab1 values( 'MAIN LINE', 'TRAMO 2', 'LINEA FERREA', 2, 180, 767, 'SW MOW 1', 'N/A', 1, 1);
insert into tab1 values( 'MAIN LINE', 'TRAMO 2', 'LINEA FERREA', 2, 180, 745, 'SW MOW 1', 'N/A', 1, 1);
commit;
SELECT LINE, ZONE, TRACK, START_MARKER, START_OFFSET, MAX(TURNOUT_ID) AS TURNOUT_ID, ASSET_TAG, CLASS, GPS_LONG, GPS_LAT
FROM TAB1
GROUP BY LINE, ZONE, TRACK, START_MARKER, START_OFFSET, ASSET_TAG, CLASS, GPS_LONG, GPS_LAT
ORDER BY LINE, ZONE, TRACK, START_MARKER, START_OFFSET, ASSET_TAG DESC
/
LINE ZONE TRACK START_MARKER START_OFFSET TURNOUT_ID ASSET_TAG CLASS GPS_LONG GPS_LAT
---------- ---------- --------------- ------------ ------------ ---------- ---------- ----- ---------- ----------
MAIN LINE TRAMO 2 LINEA FERREA 2 180 768 SW MOW 1 N/A 1 1
LINE ZONE TRACK START_MARK START_OFFS TURNOUT_ID ASSET_TAG CLASS GPS_LONG GPS_LAT
---------- ---------- -------------------- ---------- ---------- ---------- --------------- ---------- ---------- ----------
MAIN LINE TRAMO 2 LINEA FERREA 2 180 768 SW MOW 1 N/A 0 0
/*
--drop table V_LINES_ZONES_TRACKS purge;
--drop table V_TURNOUTS purge;
*/
CREATE table V_LINES_ZONES_TRACKS(
LINE varchar2(50),
ZONE varchar2(50),
TRACK varchar2(50),
START_MARKER varchar2(50),
START_OFFSET varchar2(50),
END_MARKER varchar2(50),
END_OFFSET varchar2(50),
COLOR varchar2(50),
TRACK_ID varchar2(50),
ZONE_ID varchar2(50),
YARD varchar2(50),
LINE_ID varchar2(50));
CREATE table V_TURNOUTS(
TRACK_ID varchar2(50),
START_MARKER varchar2(50),
START_OFFSET varchar2(50),
CONNECTID varchar2(50),
RECORDINDEX varchar2(50),
SWITCHNUMBER varchar2(50),
POINTLENGTHFEET varchar2(50),
POINTLENGTHINCH varchar2(50),
SWITCH_POINT_TYPE_ID varchar2(50),
TIE_TYPE_ID varchar2(50),
SWITCH_MACHINE_TYPE_ID varchar2(50),
SWITCHMACHINEMANUFACTURER varchar2(50),
SWITCHMACHINENUMBER varchar2(50),
INSTALLATIONDATE varchar2(50),
INSPECTIONDATE varchar2(50),
MAINTENANCEDATE varchar2(50),
RELTRACK_1 varchar2(50),
RELTRACK_2 varchar2(50),
SPEED varchar2(50),
LEAD_LENGTH varchar2(50),
STANDARD_DRAWING varchar2(50),
APPROACH varchar2(50),
TIMESTAMP varchar2(50),
USERSTAMP varchar2(50),
LOCATIONSTAMP varchar2(50),
SITENAMEID varchar2(50),
FACING varchar2(50),
TURNOUT_TYPE_ID varchar2(50),
FROG_DRAWING varchar2(50),
ALIGNMENT_DRAWING varchar2(50),
GEOMETRY_DRAWING varchar2(50),
CONNECTID0 varchar2(50),
CONNECTFEET0 varchar2(50),
CONNECTSTART0 varchar2(50),
DELETED varchar2(50),
INTERLOCKINGID varchar2(50),
CONNECTFEET varchar2(50),
CONNECTSTART varchar2(50),
CONNECTZONEID varchar2(50),
TURNOUT_ID varchar2(50),
TOTALMGT varchar2(50),
GPS_LONG varchar2(50),
GPS_LAT varchar2(50),
IMPORT_DATE varchar2(50),
SAME_DAY_CHANGE varchar2(50),
TRACK_TYPE varchar2(50),
POINT_DIR varchar2(50),
TURNOUT_REC_NBR varchar2(50),
TO_SIZE varchar2(50),
TO_SWC_TYPE varchar2(50),
TO_RAIL_TYPE_ID varchar2(50),
TO_DESC varchar2(50),
CLASS varchar2(50),
TRAF_DENSITY varchar2(50),
TRAF_TYPE_LOW varchar2(50),
TRAF_TYPE_NORM varchar2(50),
TRAF_TYPE_HAZ varchar2(50),
TRAF_TYPE_PASS varchar2(50),
TRAF_TYPE_KEY varchar2(50),
SWSTANDTYP varchar2(50),
EYEBOLTSIZE varchar2(50),
CONRODLEN varchar2(50),
SWRODTYP varchar2(50),
FRONTROD varchar2(50),
SWPTLEN varchar2(50),
RAILBRACETYP varchar2(50),
HEELBLOCKPRES varchar2(50),
FROGBOLTSTYP varchar2(50),
FRONTRODSPEC varchar2(50),
DERAIL varchar2(50),
ASSET_TAG varchar2(50),
SIGNATURE_ID varchar2(50),
START_LAT varchar2(50),
START_LONG varchar2(50),
FROG_TYPE varchar2(50),
FASTENER_TYPE varchar2(50),
TOTAL_MGT varchar2(50),
GUARD_RAILS_TYP varchar2(50),
GUARD_RAILS_LEN varchar2(50),
RAIL_ANCHORS_TYPE varchar2(50),
BALLAST_TYPE varchar2(50),
POINT_PROTECTORS varchar2(50),
SWITCH_RODS varchar2(50),
HEEL_TYPE varchar2(50),
FROG_SIZE varchar2(50),
LAST_MONTHLY_ID varchar2(50),
LAST_DETAILED_ID varchar2(50),
TURNOUT_DIRECTION varchar2(50),
FOOT_GUARDS varchar2(50),
INTERLOCKING_ID varchar2(50),
SUPERSEDED varchar2(50),
SWITCHPOINTTYPE varchar2(50),
TIETYPE varchar2(50),
SWITCHMACHINETYPE varchar2(50),
TURNOUTTYPEID varchar2(50),
TURNOUTTYPE varchar2(50));
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 3','SIDING ISHAMANA','44','630','47','177','-8388353','75','3','0','3');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINEA TALLER NO4','0','0','0','231','33023','84','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL COMBUSTIBLE','0','0','0','168','33023','42','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINEA PINTURA','0','0','0','447','33023','44','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINEA SOLDADURA 1','0','0','0','241','33023','45','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL TRACTOPUERTO','0','0','0','185','33023','47','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINEA SOLDADURA 2','0','0','0','58','33023','48','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINEA EXPLOSIVOS','0','0','0','419','33023','49','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL AGUA','0','0','0','255','33023','50','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','ALVARO SARMIENTO','0','0','0','62','33023','51','1','0','1');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 4','BACK TRACK K57','57','203','57','519','-8388353','26','4','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 5','SIDING 81 URIBIA','81','464','84','273','-8388353','27','5','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 6','SIDING COSINAS','107','664','110','245','-8388353','28','6','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 7','BACK TRACK K128','128','800','129','200','-8388353','68','7','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 5','BACK TRACK URIBIA','81','625','82','0','-8388353','69','5','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 6','BACK TRACK COSINAS','107','880','108','200','-8388353','70','6','0','3');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL MADRAKE','0','0','0','100','33023','76','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINEA TALLER NO3','0','0','0','280','33023','77','1','0','1');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 3','BACK TRACK ITAKA','27','950','28','250','-8388353','71','3','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 2','LINEA FERREA','0','0','25','0','-8388353','13','2','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 3','LINEA FERREA','25','0','55','0','-8388353','14','3','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 4','LINEA FERREA','55','0','80','0','-8388353','15','4','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 5','LINEA FERREA','80','0','100','0','-8388353','16','5','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 6','LINEA FERREA','100','0','120','0','-8388353','17','6','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 7','LINEA FERREA','120','0','144','638','-8388353','18','7','0','3');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','IN-BOUND','0','0','2','228','33023','19','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','OUT-BOUND','4','552','6','740','33023','20','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LOOP','2','228','4','552','33023','21','1','0','1');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','LOOP','148','80','150','912','16744448','22','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','IN-BOUND','144','638','148','80','16744448','23','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','OUT-BOUND','150','912','153','188','16744448','24','8','0','2');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 3','SIDING ITAKA','27','394','30','54','-8388353','25','3','0','3');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINE 1','0','0','2','227','33023','29','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINE 2','0','0','0','976','33023','30','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINE 3','0','0','0','994','33023','31','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINE 4','0','0','1','15','33023','32','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINE 5','0','0','2','288','33023','33','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINE 6','0','0','0','925','33023','34','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','L TALLER NO1','0','0','0','840','33023','35','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','L TALLER NO2','0','0','0','712','33023','36','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','MV1','0','0','0','240','33023','37','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','MV2','0','0','0','107','33023','38','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL BODEGA','0','0','1','200','33023','39','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','ACCESO SUR','0','0','0','452','33023','40','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','ACCESO NORTE','0','0','0','244','33023','41','1','0','1');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','RAMAL CERREJON','0','0','3','337','16744448','52','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','RAMAL EXPLOSIVOS','0','0','0','260','16744448','53','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','ACCESO Y1','0','0','0','319','16744448','54','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','ACCESO Y2','0','0','0','319','16744448','55','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','RAMAL EARLY COAL','0','0','3','400','16744448','56','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','RAMAL AGUA','0','0','0','426','16744448','57','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','LINEA 1','0','0','0','649','16744448','59','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','LINEA 2','0','0','0','601','16744448','60','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','LINEA TALLER 1','0','0','0','490','16744448','61','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','LINEA TALLER 2','0','0','0','174','16744448','62','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','RAMAL COMBUSTIBLE','0','0','0','342','16744448','63','8','0','2');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','RAMAL RAMPA DESCARGUE DE EQUIPOS','0','0','0','243','16744448','64','8','0','2');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL MANUEL FORERO','0','0','0','285','33023','65','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL CDC 1','0','0','0','426','33023','66','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','RAMAL CDC 2','0','0','0','235','33023','67','1','0','1');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 2','LINEAS MOW','2','180','2','460','-8388353','78','2','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 4','BACK TRACK K64','64','101','64','568','-8388353','79','4','0','3');
insert into v_lines_zones_tracks values('MAIN LINE','TRAMO 5','BACK TRACK K91','91','172','91','660','-8388353','80','5','0','3');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','LINE 1A','0','0','0','750','33023','81','1','0','1');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','NEW FUEL LINE','0','0','0','690','33023','82','1','0','1');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','IN-BOUND LOOP','145','25','148','31','16744448','83','8','0','2');
insert into v_lines_zones_tracks values('MINE LOOP','TRAMO 1','PLANEACION TRAMO1','0','0','6','740','33023','72','1','0','1');
insert into v_lines_zones_tracks values('MAIN LINE','PLANEACION 2','PLANEACION K0A144.6','0','0','144','638','-8388353','73','9','0','3');
insert into v_lines_zones_tracks values('PORT LOOP','TRAMO 8','PLANEACION PATIOPBV','144','638','153','188','16744448','74','8','0','2');
insert into v_turnouts values('35','0','353','84','758','SW SN','0','0','','','','0','N/A','17-JAN-18','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','17-JAN-18','jsanch22','14-CJNDTW78F070R1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','1','758','','0','0','17-JAN-18','1','N/A','N/A','758','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW SN','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('15','55','0','79','747','SW K64 NORTE','0','0','','','','0','N/A','05-AUG-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','3-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','21','101','64','4','747','','0','0','06-FEB-14','1','N/A','N/A','747','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW K64 NORTE','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('16','91','660','80','749','SW K91 NORTE','0','0','','','','0','N/A','25-AUG-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','5-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','23','184','91','5','749','55.5','0','0','06-FEB-14','1','N/A','N/A','749','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW K91 NORTE','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('29','2','227','81','751','SW 1 - 1A','0','0','','','','0','N/A','08-JUL-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','7-CJNDTW78F070R1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','750','0','1','751','','0','0','06-FEB-14','1','N/A','N/A','751','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 - 1A','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('23','145','25','83','753','SW 2 LOC20','0','0','','','','0','N/A','10-SEP-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','9-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','12','31','148','8','753','13.8','0','0','06-FEB-14','1','N/A','N/A','753','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2 LOC20','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('41','0','47','0','665','SW C','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','8-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','665','','0','0','08-SEP-09','1','N/A','N/A','665','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW C','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('41','0','89','0','666','SW B','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','9-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','666','','0','0','08-SEP-09','1','N/A','N/A','666','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW B','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('41','0','131','0','667','SW A','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','10-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','667','','0','0','08-SEP-09','1','N/A','N/A','667','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW A','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('41','0','210','0','668','SW 1B L12','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','11-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','3','0','0','','668','','0','0','08-SEP-09','1','N/A','N/A','668','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1B L12','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','0','0','669','SW MF','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','12-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','669','','0','0','08-SEP-09','1','N/A','N/A','669','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW MF','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','99','0','670','SW K','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','13-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','670','','0','0','08-SEP-09','1','N/A','N/A','670','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW K','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','141','0','671','SW L','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','14-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','671','','0','0','08-SEP-09','1','N/A','N/A','671','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW L','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','190','0','672','SW M','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','15-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','672','','0','0','08-SEP-09','1','N/A','N/A','672','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW M','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','192','0','673','SW N','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','16-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','673','','0','0','08-SEP-09','1','N/A','N/A','673','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW N','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','296','0','675','SW R','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','18-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','675','','0','0','08-SEP-09','1','N/A','N/A','675','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW R','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','366','0','677','SW T','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','20-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','677','','0','0','08-SEP-09','1','N/A','N/A','677','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW T','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','392','0','678','SW U','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','21-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','678','','0','0','08-SEP-09','1','N/A','N/A','678','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW U','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('19','0','134','0','679','SW 2 L13','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','22-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','4','0','0','','679','','0','0','08-SEP-09','1','N/A','N/A','679','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2 L13','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('19','1','128','0','680','SW 1A L12','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','23-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','3','0','0','','680','','0','0','08-SEP-09','1','N/A','N/A','680','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1A L12','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('19','1','677','0','681','SW 2B L11','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','24-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','2','0','0','','681','','0','0','08-SEP-09','1','N/A','N/A','681','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2B L11','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('19','2','184','0','683','SW 3 L10','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','26-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','1','0','0','','683','','0','0','08-SEP-09','1','N/A','N/A','683','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 3 L10','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','122','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('19','2','226','0','684','SW 2B L10','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','27-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','1','0','0','','684','','0','0','08-SEP-09','1','N/A','N/A','684','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2B L10','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('33','1','800','0','690','SW P','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','33-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','690','','0','0','08-SEP-09','1','N/A','N/A','690','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW P','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('33','2','288','0','693','SW Z','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','36-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','693','','0','0','08-SEP-09','1','N/A','N/A','693','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW Z','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('35','0','577','0','696','SW MK','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','39-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','696','','0','0','08-SEP-09','1','N/A','N/A','696','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW MK','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('36','0','572','0','697','SW LM','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','40-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','697','','0','0','08-SEP-09','1','N/A','N/A','697','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW LM','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('21','4','480','0','699','SW 4 L10','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','42-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','1','0','0','','699','','0','0','08-SEP-09','1','N/A','N/A','699','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 4 L10','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('20','4','552','0','700','SW 1A L10','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','43-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','1','0','0','','700','','0','0','08-SEP-09','1','N/A','N/A','700','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1A L10','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('39','0','57','0','703','SW G','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','46-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','703','','0','0','08-SEP-09','1','N/A','N/A','703','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW G','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('39','0','93','0','704','SW H','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','47-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','704','','0','0','08-SEP-09','1','N/A','N/A','704','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW H','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('39','0','192','0','705','SW I','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','48-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','705','','0','0','08-SEP-09','1','N/A','N/A','705','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW I','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('39','0','292','0','706','SW J','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','49-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','706','','0','0','08-SEP-09','1','N/A','N/A','706','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW J','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('25','27','950','0','709','SW 2 L14','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','52-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','5','0','0','','709','','0','0','08-SEP-09','1','N/A','N/A','709','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2 L14','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('14','47','177','0','713','SW 15B','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','56-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','18','0','0','','713','55.5','0','0','08-SEP-09','1','N/A','N/A','713','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 15B','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('27','81','625','0','714','SW 2 L16','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','57-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','8','0','0','','714','','0','0','08-SEP-09','1','N/A','N/A','714','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2 L16','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('28','108','200','0','718','SW 3 L18','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','61-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','10','0','0','','718','','0','0','08-SEP-09','1','N/A','N/A','718','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 3 L18','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('17','110','245','0','719','SW 1 L19','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','62-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','11','0','0','','719','55.5','0','0','08-SEP-09','1','N/A','N/A','719','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L19','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('18','129','200','0','720','SW 129.2 N','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','63-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','7','0','0','','720','55.5','0','0','08-SEP-09','1','N/A','N/A','720','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 129.2 N','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('24','150','912','0','722','SW 1 L22','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','65-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','14','0','0','','722','','0','0','08-SEP-09','1','N/A','N/A','722','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L22','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('52','0','774','0','726','SW C','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','69-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','726','','0','0','08-SEP-09','1','N/A','N/A','726','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW C','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('52','0','777','0','727','SW D','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','70-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','727','','0','0','08-SEP-09','1','N/A','N/A','727','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW D','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('52','1','428','0','729','SW J','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','72-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','729','','0','0','08-SEP-09','1','N/A','N/A','729','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW J','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('52','2','271','0','730','SW L','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','73-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','730','','0','0','08-SEP-09','1','N/A','N/A','730','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW L','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('57','0','45','0','731','SW E','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','74-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','731','','0','0','08-SEP-09','1','N/A','N/A','731','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW E','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('57','0','91','0','732','SW F','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','75-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','732','','0','0','08-SEP-09','1','N/A','N/A','732','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW F','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('59','0','603','0','733','SW H','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','76-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','733','','0','0','08-SEP-09','1','N/A','N/A','733','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW H','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('61','0','250','0','734','SW K','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','77-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','734','','0','0','08-SEP-09','1','N/A','N/A','734','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW K','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('63','0','36','0','735','SW M','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','78-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','735','','0','0','08-SEP-09','1','N/A','N/A','735','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW M','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('56','0','0','0','736','SW A1','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','79-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','736','','0','0','08-SEP-09','1','N/A','N/A','736','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW A1','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('41','0','2','0','645','SW D','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','04-SEP-09','asanchez','1-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','645','','0','0','04-SEP-09','1','N/A','N/A','645','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW D','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('13','0','440','0','646','SW 1 L13','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','04-SEP-09','asanchez','2-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','4','0','0','','646','55.5','0','0','04-SEP-09','1','N/A','N/A','646','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L13','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','42','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('16','81','464','0','648','SW 1 L16','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','04-SEP-09','asanchez','4-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','8','0','0','','648','55.5','0','0','04-SEP-09','1','N/A','N/A','648','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L16','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('18','128','800','0','650','SW 128.8 S','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','04-SEP-09','asanchez','6-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','7','0','0','','650','55.5','0','0','04-SEP-09','1','N/A','N/A','650','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 128.8 S','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('14','26','994','25','756','SW 1 LOC 14','0','0','','','','0','N/A','15-APR-14','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','15-APR-14','jsanch22','12-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','5','49','27','3','756','55.5','0','0','15-APR-14','1','N/A','N/A','756','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 LOC 14','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('39','0','14','0','702','SW F','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','45-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','702','','0','0','08-SEP-09','1','N/A','N/A','702','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW F','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','200','0','674','SW Q','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','17-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','674','','0','0','08-SEP-09','1','N/A','N/A','674','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW Q','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('16','91','184','80','748','SW K91 SUR','0','0','','','','0','N/A','16-AUG-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','4-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','22','660','91','5','748','55.5','0','0','06-FEB-14','1','N/A','N/A','748','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW K91 SUR','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('20','4','718','0','701','SW 2A L10','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','44-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','1','0','0','','701','','0','0','08-SEP-09','1','N/A','N/A','701','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2A L10','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('15','64','101','79','746','SW K64 SUR','0','0','','','','0','N/A','20-AUG-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','2-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','20','568','64','4','746','55.5','0','0','06-FEB-14','1','N/A','N/A','746','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW K64 SUR','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('52','1','425','0','728','SW I','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','71-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','728','','0','0','08-SEP-09','1','N/A','N/A','728','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW I','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('33','0','630','0','688','SW E','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','31-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','688','','0','0','08-SEP-09','1','N/A','N/A','688','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW E','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('16','84','273','0','716','SW 1 L17','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','59-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','9','0','0','','716','55.5','0','0','08-SEP-09','1','N/A','N/A','716','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L17','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('28','107','880','0','717','SW 2 L18','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','60-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','10','0','0','','717','','0','0','08-SEP-09','1','N/A','N/A','717','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2 L18','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('14','30','1','0','711','SW 1 L15','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','54-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','6','0','0','','711','55.5','0','0','08-SEP-09','1','N/A','N/A','711','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L15','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('24','151','767','59','755','SW 4 LOC20','0','0','','','','0','N/A','26-SEP-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','11-CJNDTW78F070R1','0','0','1','N/A','N/A','N/A','0','0','0','0','12','0','0','8','755','','0','0','06-FEB-14','1','N/A','N/A','755','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 4 LOC20','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('33','2','83','0','691','SW W','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','34-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','691','','0','0','08-SEP-09','1','N/A','N/A','691','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW W','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('17','107','664','0','649','SW 1 L18','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','04-SEP-09','asanchez','5-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','10','0','0','','649','55.5','0','0','04-SEP-09','1','N/A','N/A','649','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L18','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('29','0','508','0','686','SW 2A L11','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','29-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','2','0','0','','686','','0','0','08-SEP-09','1','N/A','N/A','686','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2A L11','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('39','0','815','0','707','SW AS','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','50-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','707','','0','0','08-SEP-09','1','N/A','N/A','707','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW AS','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('14','44','630','0','712','SW 15A','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','55-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','17','0','0','','712','55.5','0','0','08-SEP-09','1','N/A','N/A','712','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 15A','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('13','2','180','0','769','N/A','0','0','','','','0','N/A','01-JAN-50','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','19-DEC-18','dsniegon','2-RAIUSCOLLTEG782','0','0','2','N/A','N/A','N/A','0','0','0','0','0','0','0','','768','','0','0','19-DEC-18','1','N/A','N/A','0','0','N/A','0','N/A','N/A','0','0','0','0','0','0','N/A','N/A','6','N/A','N/A','0','N/A','N/A','N/A','0','0','SW MOW 1','0','','','N/A','N/A','0','N/A','0','N/A','N/A','0','0','0','0','0','0','R','0','0','01-JAN-50','0','0','0','2','Turnouts Arema No 15');
insert into v_turnouts values('13','2','180','0','768','N/A','0','0','','','','0','N/A','01-JAN-50','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','18-DEC-18','dsniegon','1-RAIUSCOLLTEG782','0','0','2','N/A','N/A','N/A','0','0','0','0','0','0','0','','767','','0','0','18-DEC-18','1','N/A','N/A','0','0','N/A','0','N/A','N/A','0','0','0','0','0','0','N/A','N/A','5','N/A','N/A','0','N/A','N/A','N/A','0','0','SW MOW 1','0','','','N/A','N/A','0','N/A','0','N/A','N/A','0','0','0','0','0','0','R','0','0','01-JAN-50','0','0','0','2','Turnouts Arema No 15');
insert into v_turnouts values('52','0','381','0','724','SW A','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','67-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','724','','0','0','08-SEP-09','1','N/A','N/A','724','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW A','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('13','2','180','78','745','SW MOW 1','0','0','','','','0','N/A','06-NOV-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','1-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','19','480','2','2','745','55.5','0','0','06-FEB-14','1','N/A','N/A','745','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW MOW 1','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('19','2','228','0','685','SW 1B L10','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','28-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','1','0','0','','685','','0','0','08-SEP-09','1','N/A','N/A','685','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1B L10','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('24','151','115','0','723','SW 2B L21','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','66-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','13','0','0','','723','','0','0','08-SEP-09','1','N/A','N/A','723','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2B L21','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('40','0','333','0','676','SW S','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','19-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','676','','0','0','08-SEP-09','1','N/A','N/A','676','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW S','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('66','0','187','0','708','SW CDC','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','51-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','708','','0','0','08-SEP-09','1','N/A','N/A','708','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW CDC','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('82','0','0','82','752','New Fuel Line','0','0','','','','0','N/A','15-JUL-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','8-CJNDTW78F070R1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','690','0','1','752','','0','0','06-FEB-14','1','N/A','N/A','752','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','New Fuel Line','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('25','28','250','0','710','SW 3 L14','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','53-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','5','0','0','','710','','0','0','08-SEP-09','1','N/A','N/A','710','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 3 L14','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('29','0','0','29','750','SW 3 LOC13','0','0','','','','0','N/A','06-JUL-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','6-CJNDTW78F070R1','0','0','1','N/A','N/A','N/A','0','0','0','0','4','227','2','1','750','','0','0','06-FEB-14','1','N/A','N/A','750','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 3 LOC13','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('19','1','679','0','682','SW 1B L11','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','25-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','2','0','0','','682','','0','0','08-SEP-09','1','N/A','N/A','682','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1B L11','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('27','82','0','0','715','SW 3 L16','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','58-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','8','0','0','','715','','0','0','08-SEP-09','1','N/A','N/A','715','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 3 L16','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('33','1','764','0','689','SW O','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','32-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','689','','0','0','08-SEP-09','1','N/A','N/A','689','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW O','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('23','146','658','0','721','SW 2A L21','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','64-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','13','0','0','','721','13.8','0','0','08-SEP-09','1','N/A','N/A','721','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 2A L21','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('23','148','31','83','754','SW 3 LOC20','0','0','','','','0','N/A','20-SEP-13','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','06-FEB-14','asanchez','10-CJNDTW78F070R1','0','0','2','N/A','N/A','N/A','0','0','0','0','12','25','145','8','754','13.8','0','0','06-FEB-14','1','N/A','N/A','754','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 3 LOC20','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('36','0','382','0','698','SW AD','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','41-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','0','0','','698','','0','0','08-SEP-09','1','N/A','N/A','698','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW AD','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('23','144','638','0','651','SW 1 L20','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','04-SEP-09','asanchez','7-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','12','0','0','','651','','0','0','04-SEP-09','1','N/A','N/A','651','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L20','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('35','0','124','84','757','SW MP','0','0','','','','0','N/A','17-JAN-18','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','17-JAN-18','jsanch22','13-CJNDTW78F070R1','0','0','1','N/A','N/A','N/A','0','0','0','0','15','231','0','1','757','','0','0','17-JAN-18','1','N/A','N/A','757','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW MP','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('52','0','388','0','725','SW B','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','68-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','16','0','0','','725','','0','0','08-SEP-09','1','N/A','N/A','725','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW B','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
insert into v_turnouts values('14','27','394','0','647','SW 1 L14','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','04-SEP-09','asanchez','3-LMNDTXP49XQPC1','0','0','2','N/A','N/A','N/A','0','0','0','0','5','0','0','','647','55.5','0','0','04-SEP-09','1','N/A','N/A','647','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1 L14','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','21','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 15');
insert into v_turnouts values('29','0','683','0','687','SW 1A L11','0','0','','','','0','N/A','01-JAN-85','01-JAN-50','01-JAN-50','N/A','N/A','0','N/A','N/A','0','08-SEP-09','asanchez','30-LMNDTXP49XQPC1','0','0','1','N/A','N/A','N/A','0','0','0','0','2','0','0','','687','','0','0','08-SEP-09','1','N/A','N/A','687','N/A','N/A','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','SW 1A L11','0','','','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','N/A','0','0','0','R','0','0','01-JAN-50','0','0','0','1','Turnouts Arema No 10');
commit;
SELECT LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET, MAX(TU.TURNOUT_ID) AS TURNOUT_ID, TU.ASSET_TAG, TU.CLASS, TU.GPS_LONG, TU.GPS_LAT
FROM V_LINES_ZONES_TRACKS LV, V_TURNOUTS TU
WHERE TU.TRACK_ID = LV.TRACK_ID
AND (TU.TURNOUT_ID IS NOT NULL) AND (TU.TURNOUT_ID > 0)
--AND LV.ZONE = 'TRAMO 2'
and tu.start_offset='180'
GROUP BY LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET, TU.ASSET_TAG, TU.CLASS, TU.GPS_LONG, TU.GPS_LAT
ORDER BY LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET, TU.ASSET_TAG DESC
/
Open in new window