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_TRA
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
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_TRA
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
Have you tried to group just by the following columns :
GROUP BY LV.LINE, LV.ZONE, LV.TRACK, TU.START_MARKER, TU.START_OFFSET,
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.
Why are you grouping by TU.IMPORT_DATE? You should only group by the non-aggregate columns you select.
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?
>>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,
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,
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.
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.
I cannot reproduce your results.
Here is a test case based on your columns and data:
My 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
/
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
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.
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.
>>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.
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.
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.
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.
At a minimum: Table descriptions and data in a text file.
Data Warehouse / Database Architect
CERTIFIED EXPERT
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.
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.
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.
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.
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
v_lines_zones_tracks_ddl.txt
v_turnouts_ddl.txt
v_lines_zones_tracks.txt
V_TURNOUTS.txt
Data Warehouse / Database Architect
CERTIFIED EXPERT
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
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
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:
Here is my complete test case based on your provided data:
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
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
/
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.
>> 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
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
Data Warehouse / Database Architect
CERTIFIED EXPERT
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_TRA
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?
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_TRA
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?
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.
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.
Data Warehouse / Database Architect
CERTIFIED EXPERT
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.
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.
Data Warehouse / Database Architect
CERTIFIED EXPERT
Track_ID would be ideal, maybe even required, but I don't see a way to get to it without going through another column.
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_TRA
) 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
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_TRA
) 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
Data Warehouse / Database Architect
CERTIFIED EXPERT
Strongly suggesting that one of the peripheral columns isn't as it appears...
Glad you got it!
Glad you got it!
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.
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.
Data Warehouse / Database Architect
CERTIFIED EXPERT
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....
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....
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions