Oracle Query using max with group by and order by

66chawger
66chawger used Ask the Experts™
on
Struggling with some SQL in Oracle 11g.  

I have a result set with group by and order by along with a MAX on a particular column, however results are not filtering out the results based on the max.  I assume this is because of how I have the select statement set up, possibly the group by and order by.  Maybe need to use a nested select or such.   The query is as follows:

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 CERREJON.V_LINES_ZONES_TRACKS LV, CERREJON.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'
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, TU.IMPORT_DATE  
ORDER BY LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET, TU.ASSET_TAG DESC, TU.IMPORT_DATE DESC

The results are attached.   The item in yellow is the MAX value for that result set (line, zone, track, start_marker, start_offset and asset_tag.  This is the only row out of this result set I want to be included.  the two rows following should not be included.
SI_SQL_Results_Capture.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Zakaria AcharkiAnalyst Developer
Distinguished Expert 2018

Commented:
Have you tried to group just by the following columns :

GROUP BY LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET,

Open in new window

66chawger

Author

Commented:
Yes, Oracle throws an error.  ORA-00979: not a GROUP BY expression because it is expecting those other columns in the group by... regardless of using the order by or not.
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Why are you grouping by TU.IMPORT_DATE?  You should only group by the non-aggregate columns you select.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Find out now!
66chawger

Author

Commented:
Good point.  I took out of the GROUP BY and ORDER BY, but the desired results set remains the same (as posted),  Either the max is getting lost in the group by or looking at a sub select?
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>I took out of the GROUP BY and ORDER BY

You mean you took the import_Date out of the group by and you returned 678, 767 and 645?  Not seeing how that is possible,
Zakaria AcharkiAnalyst Developer
Distinguished Expert 2018

Commented:
Try to add the MIN(TU.id) to your select like :

SELECT
	MIN(TU.id), 
	LV.LINE,
	LV.ZONE,

Open in new window

slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
We don't see GPS_LAT in the image.  Are those different for those 3 rows?
66chawger

Author

Commented:
No, sorry, doesn't change the results.  

In the image I attached originally, you see lines 2, 3 and 4 contain the same line, zone, track, start_marker, start_offset and asset_tag.  The only difference is they are unique by turnout_id.   I only want to display the row with the MAX turnout_id.   Currently they are as grouped ans sorted 745, 767 and 768.  Only the row with 768 (the max id) should display as part of the results.
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I cannot reproduce your results.

Here is a test case based on your columns and data:
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
/

Open in new window


My results:
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

Open in new window

66chawger

Author

Commented:
Slightwv, the GPS_LAT is just cut off in the image... they are all zero (0).   And, yes to your question, rows with 745, 767 and 768 are still displaying... I am baffled also.  This is in Oracle SQL Developer.   The SQL I provided is EXACTLY as I am running in Oracle SQL Developer.
66chawger

Author

Commented:
It appears to have something to do with the join.  Look at my query and you will see pulling data from LV and TU.  When I take LV out of the equation, I only see the turnout for 768.
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>Look at my query and you will see pulling data from LV and TU.

I saw that but I wasn't going to mock up a two table test case and type in all the data for the two tables.

If you want to provide me a test case with sample data that shows the repeating values, I'll take a look at it.
66chawger

Author

Commented:
Slightwv, what all do you need as far as a test case and sample data.  For sample data, do you want in a file I assume as apposed to the image I attached, correct?  Thanks for your help and sorry for the email.... I forgot once you assist you get notified.
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
I would prefer the complete create table, insert into statements to go with the select you want me to look at.

At a minimum:  Table descriptions and data in a text file.
Kent OlsenDBA

Commented:
Hi 66,

A couple of thoughts...

In the originally posted query, one of the "group by" items is TU.IMPORT_DATE.  That value isn't one of the columns selected so what's being shown in the query could be correct if there are multiple values of IMPORT_DATE for the other key values.

Another thing to check is the data types.  If any of the columns used in the grouping are a CHAR type column instead of a VARCHAR type, trailing spaces could be causing the separation.
66chawger

Author

Commented:
Kent, another contributor commented on the TU.IMPORT_DATE previously, I had subsequently removed with same results.   I will check regarding char and varchar..

As I was discussing with slightwv, it has something to do with the join.  When I remove the join with the LV table, which is first three columns of results set, and use only TU table, MAX works fine.
66chawger

Author

Commented:
SLightwv, attached are the table definitions and data.
v_lines_zones_tracks_ddl.txt
v_turnouts_ddl.txt
v_lines_zones_tracks.txt
V_TURNOUTS.txt
Kent OlsenDBA

Commented:
Apologies....  I read through the comments and missed the IMPORT_DATE comment.

The join happens before the aggregation, so the anomaly that's causing the issue is in the second table.

Go back to the original query and change the SELECT and GROUP BY clauses to be less restrictive by omitting one column at a time and running the (new) query.  When the duplicates disappear, you'll have found the offending column.  Then it should be a relatively simple matter to see what the data issue is.


Kent
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Thanks for the data.  I created tables instead of the views and made everything varchar2 because it was the easiest.

I'm not able to reproduce your results.  I only get the expected rows.

In my query, I added "and tu.start_offset='180'" to show what you claim repeats in your image.  I only get the one row.

My output:
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

Open in new window



Here is my complete test case based on your provided data:
/*
--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

66chawger

Author

Commented:
Kent and slightwv, thanks for the info.  Maybe I have blinders on, need to take them off and not look at the obvious.   It could be something as simple as varchar vs char like Kent mentioned.  I posted this originally hesitantly because I was actually flabbergasted, I'm a DBA/Developer/Network Engineer/Server Admin... etc for over 30 years.   This type of query is normally routine, but there must be something beyond what I am looking at.   I stated previously, when I remove the LV table, works like a charm, just had to remove the LV columns from the select, where, group by and order by.  Anyway, let me work with it some more in the morning.  I might even do the select into a temp table and try the filtering in a separate query... just saying.   Don't want to make a cookie factory out of this so to speak.
slightwv (䄆 Netminder)
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>> might even do the select into a temp table and try the filtering in a separate query.

NO.  most of the time TEMP tables are a crutch.

>> It could be something as simple as varchar vs char like Kent mentioned

Describe the views and look for CHAR types:
desc V_LINES_ZONES_TRACKS
desc V_TURNOUTS
66chawger

Author

Commented:
Yes, temp table for debugging, not for the solution.
66chawger

Author

Commented:
No char vs varchar issues
Kent OlsenDBA

Commented:
Ok.  Maybe my brain cramp is about over.  Let's see.

You're getting duplicates only when you join the second table, which suggests that the join results in a Cartesian Product.

Let's go to the data.  We don't see the joined column in your query, so let's go there.  It appears to me that the Asset Tag is the place to start.

SELECT *
FROM CERREJON.V_LINES_ZONES_TRACKS
WHERE AssetTag = 'SW MOW 1'

SELECT *
FROM CERREJON.V_TURNOUTS TU
WHERE AssetTag = 'SW MOW 1'
  AND (TU.TURNOUT_ID IS NOT NULL) AND (TU.TURNOUT_ID > 0)

SELECT *
FROM CERREJON.V_TURNOUTS TU
WHERE AssetTag like 'SW MOW 1%'
  AND (TU.TURNOUT_ID IS NOT NULL) AND (TU.TURNOUT_ID > 0)

What do the results of those two queries look like, and do the two queries from V_TURNOUTS return the same number of rows?
66chawger

Author

Commented:
Kent,

Yeah, I tried breaking out the query myself.

The first query you have listed won't work because Asset_Tag is in V_TURNOUTS, not the V_LINES_ZONES_TRACKS

The other two queries both return the three rows as in the original results I attached.

The only items retrieved from the zones.. table are line, zone and track.
66chawger

Author

Commented:
Also, why Asset_Tag?   Track_Id is the joined column
Kent OlsenDBA

Commented:
Ok.  

Next up is to check those 3 rows to see if any of the columns that appear blank are really NULL.  Key on the columns in the GROUP BY clause and test those columns for blank and NULL.
Kent OlsenDBA

Commented:
Track_ID would be ideal, maybe even required, but I don't see a way to get to it without going through another column.
66chawger

Author

Commented:
I solved it by the doing the following.  We knew the join was causing the issue as I indicated in earlier posts.

SELECT LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET, MAX(TU.TURNOUT_ID), TU.ASSET_TAG, TU.CLASS, TU.GPS_LONG, TU.GPS_LAT
FROM (
      SELECT LINE, ZONE, TRACK, TRACK_ID
      FROM CERREJON.V_LINES_ZONES_TRACKS
     ) LV
JOIN (
      SELECT START_MARKER, START_OFFSET, TURNOUT_ID, ASSET_TAG, CLASS, GPS_LONG, GPS_LAT, TRACK_ID
      FROM CERREJON.V_TURNOUTS
      WHERE TURNOUT_ID IS NOT NULL AND TURNOUT_ID > 0
     ) TU
ON LV.TRACK_ID = TU.TRACK_ID
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
Kent OlsenDBA

Commented:
Strongly suggesting that one of the peripheral columns isn't as it appears...

Glad you got it!
66chawger

Author

Commented:
Thanks Kent.  I don't see any issues with the columns.  The columns in the views are defined exactly as in the tables.  I worked the query on both with the same results.  

This demonstrates the single-value rule, which prohibits the undefined results you get when you run a GROUP BY query, and you include any columns in the select-list that are neither part of the grouping criteria, nor appear in aggregate functions (SUM, MIN, MAX, etc.).

In my case, the inclusion of the select w/ join and group by were working against the aggregate in the same manner as order of arithmetic calculation.  BUT, I have not had the same issue with other DB's, i.e, MS SQL.  SQL is SQL is SQL, but proprietorial engine, syntax, etc., are and can be different.
Commented:
I solved it by the doing the following.  We knew the join was causing the issue as I indicated in earlier posts.

SELECT LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET, MAX(TU.TURNOUT_ID), TU.ASSET_TAG, TU.CLASS, TU.GPS_LONG, TU.GPS_LAT
FROM (
      SELECT LINE, ZONE, TRACK, TRACK_ID
      FROM CERREJON.V_LINES_ZONES_TRACKS
     ) LV
JOIN (
      SELECT START_MARKER, START_OFFSET, TURNOUT_ID, ASSET_TAG, CLASS, GPS_LONG, GPS_LAT, TRACK_ID
      FROM CERREJON.V_TURNOUTS
      WHERE TURNOUT_ID IS NOT NULL AND TURNOUT_ID > 0
     ) TU
ON LV.TRACK_ID = TU.TRACK_ID
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
Kent OlsenDBA

Commented:
And the query is now in the modern style.  :)  A pretty good twofer!

Our shop, like so many, has been around long enough that there is no uniform style to the queries.  In fact, the style is a good indication of how long it has been in production.  I particularly dislike the queries that use the old (+) syntax for outer joints....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial