AboutPricingCommunityTeamsStart Free TrialLog in
Avatar of 66chawger
66chawger
Flag for United States of America asked on

Oracle Query using max with group by and order by

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
Oracle DatabaseSQL
Avatar of undefined
Last Comment
Kent Olsen
8/22/2022 - Mon
Zakaria Acharki
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
ASKER
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)
Why are you grouping by TU.IMPORT_DATE?  You should only group by the non-aggregate columns you select.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
66chawger
ASKER
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)
>>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 Acharki
Try to add the MIN(TU.id) to your select like :

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

Open in new window

⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
slightwv (䄆 Netminder)
We don't see GPS_LAT in the image.  Are those different for those 3 rows?
66chawger
ASKER
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)
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

Your help has saved me hundreds of hours of internet surfing.
fblack61
66chawger
ASKER
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
ASKER
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)
>>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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
66chawger
ASKER
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)
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 Olsen
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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
66chawger
ASKER
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
ASKER
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 Olsen
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
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
slightwv (䄆 Netminder)
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
ASKER
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)
>> 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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
66chawger
ASKER
Yes, temp table for debugging, not for the solution.
66chawger
ASKER
No char vs varchar issues
Kent Olsen
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?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
66chawger
ASKER
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
ASKER
Also, why Asset_Tag?   Track_Id is the joined column
Kent Olsen
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Kent Olsen
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
ASKER
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 Olsen
Strongly suggesting that one of the peripheral columns isn't as it appears...

Glad you got it!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
66chawger
ASKER
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.
ASKER CERTIFIED SOLUTION
66chawger
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Kent Olsen
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....
Plans and Pricing
Resources
Product
Podcasts
Careers
Contact Us
Teams
Certified Expert Program
Credly Partnership
Udemy Partnership
Privacy Policy
Terms of Use

© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent