Changeset 638 in tmcsimulator for trunk/webapps
- Timestamp:
- 03/08/2021 01:26:46 PM (5 years ago)
- Location:
- trunk/webapps
- Files:
-
- 3 edited
-
dynamicdata/unifiedlog_final.csv (modified) (2 diffs)
-
mergelogs.bash (modified) (1 diff)
-
mergelogs.bat (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/webapps/dynamicdata/unifiedlog_final.csv
r551 r638 1 00:0 1:00, CAD Log, Incident #187, Detail: STALLED DOT SB SR-55 AT I-4051 00:00:00, CAD Log, Incident #181, Detail: ENRT FROM NB 405 AT JEFFREY 2 2 00:01:18, Activity Log,,021 10-98 Assignment Completed 75-1 3 3 00:01:18, Activity Log,,021 10-98 Let's get pizza. 75-1 … … 13 13 00:01:18, CMS Activated,N SR-55 5.38 Baker Street, 'BBBBB:::::' 14 14 00:01:53, CMS Activated,N SR-73 24.91 North of Jamboree, 'LINES ON ROAD:::::' 15 00:02:00, Evaluation, ATMS, Average16 00:02:00, Evaluation, CAD, Best17 15 00:02:28, CMS Updated, N SR-73 24.91 North of Jamboree, 'SNOW ON ROAD:::::' 18 00:03:00, CAD Log, Incident #18 7, Detail: CELLULAR 911 RPT DOT HT 2ND VEH OVER THE SIDE UNVERIFIED16 00:03:00, CAD Log, Incident #181, Detail: 14-13 10-97 1125 EMS 10-97 HAY TRK VS 2 VEH #1 2 3 LNS BLCKD REQ ADDL UNITS 19 17 00:03:13, CAD Log, Incident #187, Jose Trainee: SEND ICE CREAM 20 00:03:30, CAD Log, Incident #187, Detail: DUPLICATE CALL21 18 00:03:33, CMS Deactivated, N SR-73 24.91 North of Jamboree 19 00:04:00, CAD Log, Incident #181, Detail: 14-7 ENRT FROM SB 405 AT BROOKHURST 14-21 ENRT FROM 55 AT MACARTHUR 22 20 00:04:04, CAD Log, Simulation Paused. 23 00:04:30, CAD Log, Incident #187, Detail: DUPLICATE CALL 24 00:05:00, CAD Log, Incident #187, Detail: DOT HIT BY VEH VEH OVER SIDE.2ND VEH LANDED NB 405 BELOW LG COLLISION OCCUR. REQ 2 1141 CODE 2 UNITS ASSIST 25 00:05:30, CAD Log, Incident #187, Detail: DUPLICATE CALL 26 00:06:00, CAD Log, Incident #187, Detail: 14-17 14-9 ENRT ASSIST 1183 1125 27 00:06:30, CAD Log, Incident #187, Detail: DUPLICATE CALL 28 00:07:00, CAD Log, Incident #187, Detail: DOT DRIVER UNINJURED #2 3 LNS BLCKD SB 55.14-14 MVNG TO 405 ASSESS DMG 29 00:10:00, CAD Log, Incident #188, Detail: 9-9 ENRT FRM I405 @ IRVINE CTR 30 00:12:00, CAD Log, Incident #187, Detail: 14-14 1097 MULTIPLE 1144 NB 405 AT 55 OVERPASS 6 VEH TCBLOCKING 3 INSIDE LNS NB 405. DRVR AND PSSNGR IN VEH 1144 2 OTHER FATALS MULT INJR REQ CRNR AND SIGALERT 31 00:12:30, CAD Log, Incident #187, Detail: 1039 CRNR 32 00:13:00, CAD Log, Incident #187, Detail: 14-17 1097 PARAMEDICS 1097. 1184 SB 55 FOR DOT 1125 33 00:14:00, CAD Log, Incident #187, Detail: REQ MAIT REQ 14-S UNIT REQ TMT 34 00:14:00, CAD Log, Incident #188, Detail: 9-9 FD PARAMEDICS 1097. TC SEMI W/TOMATOES AND VEH ON NB-5 #3 4 5 LNSTRCK ON FIRE REQ CT CLNUP UNITS 1184 35 00:17:00, CAD Log, Incident #187, Detail: 14-9 1097 ASSIST 1184 36 00:18:00, CAD Log, Incident #187, Detail: TRAFFIC BACKING SB 55 REQ TMT MEDIUM DUTY 1185 37 00:19:00, CAD Log, Incident #187, Detail: 4 1144'S 2 1180'S 4 1181'S 38 00:20:00, CAD Log, Incident #188, Detail: 9-15 9-19 ENRT FOR 1184 39 00:21:00, CAD Log, Incident #187, Detail: 1039 SABLAN TOWING 40 00:22:00, CAD Log, Incident #187, Detail: 14-S3 1097 NB 405 @ 55MAIT ETA 15 41 00:24:00, CAD Log, Incident #188, Detail: 1141 1097 TRCK STLL FIRE 2 1180 IN VEH UNK IN TRCK 42 00:25:00, CAD Log, Incident #188, Detail: REQUEST 1185 BIG RIG AND 1185 ROT ISSUE SIG ALERT 43 00:27:00, CAD Log, Incident #187, Detail: CRNR 1097 INJURED TRANSPORTED 44 00:30:00, CAD Log, Incident #188, Detail: 9-15 1097 ADVS PD TO DIRECT TRAFFIC OFF AT LAKE FOREST 45 00:31:00, CAD Log, Incident #188, Detail: 1039 COLLEGE OAK BIG RIG CYCLE TOW FOR ROT 46 00:32:00, CAD Log, Incident #188, Detail: 9-19 1097 ASSISTNG 1184 47 00:35:00, CAD Log, Incident #187, Detail: MAIT 1097 STARTING INVESTIGATION SB SR55 48 00:37:00, CAD Log, Incident #187, Detail: MED DUTY 1185 1097 AWAIT FINISH MAIT BEFORE TOW VEH 49 00:38:00, CAD Log, Incident #188, Detail: 1039 PD SENDING 2 UNITS ASST 1184 50 00:40:00, CAD Log, Incident #187, Detail: CRNR CONFIRMED FOUR FATAL PREP TO TRANSPORT 51 00:42:00, CAD Log, Incident #188, Detail: 1180S TRANSPORTED 52 00:43:00, CAD Log, Incident #188, Detail: 9-9 FIRE OUT 53 00:44:00, CAD Log, Incident #188, Detail: LAKE FOREST ONRAMP CLOSED DIRECTING TRAFFIC OFF LAKE FOREST OFFRAMP 54 00:47:00, CAD Log, Incident #187, Detail: MAIT FINISHED W/ INVESTIGATION SB SR-55 AT I-405 PREP DOT TRCK FOR TOW 55 00:48:00, CAD Log, Incident #188, Detail: 1 1144 IN TRCK REQ CRNR 56 00:50:00, CAD Log, Incident #188, Detail: 9-9 1039 CRNR ETA 15 57 00:51:00, CAD Log, Incident #188, Detail: CT 1097 STRTNG CLNUP OF TOMATOES 58 00:53:00, CAD Log, Incident #188, Detail: 1185 ROT 1097 59 00:54:00, CAD Log, Incident #187, Detail: MAIT STARTING INVESTIGATION NB 405 TO TAKE 30 MIN 60 00:55:00, CAD Log, Incident #187, Detail: CLNUP NRLY FNSHD DOT RDY TO BE TWD SB SR-55 LNS OPN IN 5 61 00:56:00, CAD Log, Incident #188, Detail: WTNSSES JOHN/BETTY JONES SAW TOMATO TRUCK LOSE CONTROL FLIP OVER VEH HIT TRCK IMM CAUGHT FIRE 62 00:59:00, CAD Log, Incident #188, Detail: BIG RIG 1185 1097 63 01:02:00, CAD Log, Incident #187, Detail: 14-17 1097 DOT TRCK TWD SB SR-55 OPN 64 01:03:00, CAD Log, Incident #187, Detail: MAIT PARTIAL CMPLT PICS TKN NEED MSRMNTS INTERVIEWS 65 01:05:00, CAD Log, Incident #188, Detail: CT #3 LN ALMOST CLEARED OF TOMATOES 66 01:07:00, CAD Log, Incident #188, Detail: CRNR 1097 67 01:08:00, CAD Log, Incident #187, Detail: REQ 6 ROT 1185 68 01:09:00, CAD Log, Incident #188, Detail: VEH TOWED #3 LN CLEARED OPENING 69 01:10:00, CAD Log, Incident #187, Detail: MAIT NEARLY COMPLETE FINISHING INTERVIEWS TOW ETA 10 70 01:12:00, CAD Log, Incident #188, Detail: 1144 CNFRMD #3 LN OPN FULL OPNNG 20 MIN 71 01:15:00, CAD Log, Incident #188, Detail: CT NRLY FNSHD CLNUP TRCK BEING PRPRD FOR 1185 72 01:16:30, CAD Log, Incident #187, Detail: MAIT FINISHED INVESTIGATION 1098 START CLEANUP WHEN 1185S ARRIVE 73 01:19:00, CAD Log, Incident #187, Detail: 1185 1097 PARTIAL OPENING IN 15 74 01:20:00, CAD Log, Incident #188, Detail: CT 98 TOMATOES LNS OPN IN 10 75 01:23:00, CAD Log, Incident #189, Detail: CELLULAR 911 RPT SUICIDE BMBR AT I-405 @ JEFFREY UNVERIFIED1039 IRV PD PD ENRT 28-24 ENRT FROM I-405 @ IRVINE CNTR. 76 01:24:00, CAD Log, Incident #188, Detail: TRCK TWD FD SPRYNG LNS LNS OPN IN 5 77 01:25:00, CAD Log, Incident #189, Detail: 28-24 1097 PD 1097 78 01:29:00, CAD Log, Incident #189, Detail: 28-19 ENRT FROM I-5 AT SND CYN 28-13 ENRT FROM I-5 AT 133SHUT DWN NB I-405 AT SND CYN OFFR 79 01:30:00, CAD Log, Incident #187, Detail: OPN #2 3 LNS FULL OPN IN 5 80 01:31:00, CAD Log, Incident #188, Detail: ALL LNS CLR 9-15 OPENING LAKE FOREST ONRAMP9-9 9-15 9-19 1098 81 01:31:00, CAD Log, Incident #189, Detail: 28-11 ENRT FROM I405 AT BRISTOL 28-07 ENRT FROM SR55 AT DYER28-11 28-07 TO SHT DWN SB I405 AT CULVER OFFR 82 01:32:00, CAD Log, Incident #189, Detail: PD CLOSING JEFFREY AND UNIV DR SENDING NEGOTIATOR REQ SIGALERT 83 01:35:00, CAD Log, Incident #187, Detail: VEH TWD LNS OPN 14-S 14-9 14-14 1098 84 01:36:00, CAD Log, Incident #189, Detail: 28-13 1097 10-23 28-19 B4 CLOSING NB LNS 1039 DOT FOR SIGN TRUCKS 85 01:37:00, CAD Log, Incident #189, Detail: 28-11 1097 CLSNG DWN SB LNS AT CULVER DR OFFR 86 01:38:00, CAD Log, Incident #189, Detail: 28-13 28-19 SHUTTING DWN NB 405 LNS AT SAND CYN ST OFFR 87 01:40:00, CAD Log, Incident #189, Detail: 28-07 1097 ASSTNG 28-11 CLSNG SB LNS AT CULVER OFFR 88 01:41:00, CAD Log, Incident #189, Detail: 28-S4 1097 I5 JEFFREY AVE ASSIST 89 01:43:00, CAD Log, Incident #189, Detail: PD STTNG DETOURS SB TRFFC OFF AT CULVER AVE NB TRFFC OFF AT SAND CYN 90 01:44:00, CAD Log, Incident #189, Detail: NEGOTIATOR 1097 91 01:45:00, CAD Log, Incident #189, Detail: NB LNS SHUT DOWN 92 01:46:00, CAD Log, Incident #189, Detail: SUSP WON'T ALLOW NEGOTIATOR NEAR HIM 93 01:47:00, CAD Log, Incident #189, Detail: 28-07 SB LNS SHUT DOWN 94 01:50:00, CAD Log, Incident #189, Detail: SUSP IS CALMING DOWN. BOMB SQD 1097 95 01:53:00, CAD Log, Incident #190, Detail: 9-22 ENRT FROM 57 @ CHAPMAN 96 01:58:00, CAD Log, Incident #190, Detail: 9-22 1097 2 VEH TC VEH VS TANKER TRK BLKNG #3 4UNID LIQUID LEAKING FROM TNKR NEED TO CLOSE NB LANES REQ UNITS 97 01:59:00, CAD Log, Incident #190, Detail: 9-23 9-26 ENRT TO ASSIST 9-22 98 02:00:00, CAD Log, Incident #190, Detail: 1141 FD 1097 TRCK DRVR 1180 UNCONCIOUS 2 1181S LIQUID LEAKING INTO #2 LN. #2 3 4 BLKD AT THIS TIME 99 02:01:00, CAD Log, Incident #189, Detail: NEGOTIATOR MAKING PROGRESS SUSP MAY SURRENDER 100 02:01:00, CAD Log, Incident #190, Detail: DONT HAVE TO SHUT THE FWY LIQUID ID'D AS MILK. #1 LN WILL REMAIN OPEN.ATTEMPTING TO CONTROL THE LEAK. REQ BIG RIG AND ROT 1185 101 02:04:00, CAD Log, Incident #190, Detail: 9-23 1097 REQ TMT TRAFFIC BACKING 102 02:06:00, CAD Log, Incident #189, Detail: MAN TRIED TO DETONATE THE DEVICE BOMB DIDNT ACTIVATE PD APPRHNDNG 103 02:08:00, CAD Log, Incident #189, Detail: SUSP IN CUSTODY BOMB SQD INSPECTING BOMB 104 02:11:00, CAD Log, Incident #190, Detail: PREPARING TO TRANSPORT VICTIMS #1 LN OPN 105 02:13:00, CAD Log, Incident #190, Detail: 9-26 1097 VICTIMS TRANSPORTED 106 02:14:00, CAD Log, Incident #189, Detail: CODE A BOMB DEFUSED LNS BEING OPENED 107 02:15:00, CAD Log, Incident #190, Detail: HOLE IN TANKER PLUGGED FD WASHING DOWN RDWY 108 02:16:00, CAD Log, Incident #189, Detail: SB LNS OPN 28-11 28-07 1098 109 02:17:00, CAD Log, Incident #189, Detail: NB LNS OPN 28-13 28-19 1098 110 02:17:00, CAD Log, Incident #191, Detail: 911 CELLULAR CALL RV FIRE SB-73 AT BEAR St UNVERIFIED 111 02:18:00, CAD Log, Incident #189, Detail: 28-24 28-S4 1098 PD OPNNG OVRPASS 112 02:19:00, CAD Log, Incident #191, Detail: 17-14 ENRT FROM 405 AT EUCLID 113 02:20:00, CAD Log, Incident #190, Detail: 1185 ROT 1097 114 02:21:00, CAD Log, Incident #190, Detail: BIG RIG 1185 1097 ONCE FD IS DONE WILL START CLEANUP 115 02:23:00, CAD Log, Incident #190, Detail: FD DONE OPENING #2 STARTING CLEANUP 116 02:24:00, CAD Log, Incident #191, Detail: RV ON FIRE ON RS 2 1181S PARAMEDICS 1097 REQ UNIT TO ASSIST 117 02:25:00, CAD Log, Incident #191, Detail: 17-16 ENRT FROM S-405 @ EUCLID TO ASSIST 17-14 118 02:26:00, CAD Log, Incident #191, Detail: FD 1097 CLOSING RT LN REQ TMT TRAFFIC ADVISORY 119 02:27:00, CAD Log, Incident #190, Detail: #2 LN OPN FULL CLNUP IN 20 120 02:29:00, CAD Log, Incident #191, Detail: 17-14 1097 121 02:32:00, CAD Log, Incident #190, Detail: VEH READY TO BE TOWED TRCK AND TNKR BEING UPRIGHTED 122 02:33:00, CAD Log, Incident #191, Detail: VICTIMS TRANSPORTED PASSERS BY RESCUED VICTIMS 123 02:35:00, CAD Log, Incident #191, Detail: FIRE IS OUT FD INVESTIGATING CAUSE OF FIRE 124 02:37:00, CAD Log, Incident #190, Detail: VEH TOWED TNKR UPRGHT FULL OPENING IN 10 125 02:39:00, CAD Log, Incident #191, Detail: REQ FLAT BED 1185 FD 98 IN 15 126 02:41:00, CAD Log, Incident #191, Detail: 1039 1185 ENRT ETA 10 127 02:42:00, CAD Log, Incident #190, Detail: TANKER READY FOR TOW FINISHING CLEANUP 128 02:46:00, CAD Log, Incident #190, Detail: TANKER TOWED RDWY CLR OPENING LANES 129 02:48:00, CAD Log, Incident #191, Detail: 1185 1097 INVESTIGATION NEARLY COMPLETE 130 02:49:00, CAD Log, Incident #190, Detail: LNS OPN 9-22 9-23 9-26 10-98 131 02:51:00, CAD Log, Incident #191, Detail: FD INVESTIGATION COMPLETE SPRAYING RS FIRE CAUSED BY KITCHEN FIRE 132 02:54:00, CAD Log, Incident #191, Detail: RV READY FOR 1185 LN OPN IN 10 133 02:58:00, CAD Log, Incident #191, Detail: RV TOWED LANES OPEN IN 5 134 03:01:00, CAD Log, Incident #191, Detail: 17-14 17-16 1098. LN OPN 21 00:05:00, CAD Log, Incident #181, Detail: 1144 IN HAY TRK 2 1181S REQ CORONERREQ DOT TO REMOVE HAY SPILLED IN SB LANES 22 00:07:00, CAD Log, Incident #181, Detail: 14-7 REQ 1185 BIG RIG AND 2 ROT 1185 23 00:09:00, CAD Log, Incident #181, Detail: 10-39 COLLEGE OAK FOR BIG RIG AND CYCLE FOR ROT 24 00:11:00, CAD Log, Incident #181, Detail: 14-21 1097 PROV 1184 TRF BACKING QUICKLY 25 00:12:00, CAD Log, Incident #181, Detail: VEH KNOCKED HAY BALES ONTO VON KARMAN AVENUE ADV CITY 26 00:15:00, CAD Log, Incident #181, Detail: 1181 TRANSPORTED REQ ETA FOR CORONERETA FOR CORONER 10 27 00:18:00, CAD Log, Incident #181, Detail: 14-13 1185 1097 #3 LN WILL OPEN 5-10 28 00:20:00, CAD Log, Incident #181, Detail: DOT 1097 TO REMOVE BALES 29 00:23:00, CAD Log, Incident #181, Detail: CORONER 1097 30 00:24:00, Evaluation, FACILITATOR, 'anything will do' 31 00:24:00, Evaluation, FACILITATOR, 'snoopy says go' 32 00:24:00, Evaluation, FACILITATOR, 'we all scream for ice cream' 33 00:24:00, Evaluation, RADIO, 'Forgot pizza toppings' 34 00:24:00, Evaluation, RADIO, 'Had trouble finding phone number' 35 00:24:00, Evaluation, RADIO, Poor 36 00:25:00, CAD Log, Incident #181, Detail: #3 LN CLEARED OPENING NOW 37 00:25:00, Evaluation, ACTIVITY_LOG, 'User prefers mushrooms over peppers' 38 00:25:00, Evaluation, FACILITATOR, 'When out at night, where white' 39 00:28:00, CAD Log, Incident #181, Detail: CORONER CONFIRMED 1144 VEHS READY FOR TOW HAY NEARLY CLEARED ALL LANES OPEN IN 15 40 00:30:00, CAD Log, Incident #181, Detail: WTNSSES JOHN/BETTY JONES SAW HAY TRUCK LOSE CONTROL FLIP OVER 2 VEH HIT 41 00:32:00, CAD Log, Incident #181, Detail: HAY TRK READY FOR TOW 2 VEHS TOWED DOT CLEARED HAY BALES LANES OPEN IN 10 42 00:35:00, Evaluation, ACTIVITY_LOG, 'every good boy does fine' 43 00:36:00, CAD Log, Incident #181, Detail: LANES OPEN IN 5 44 00:36:00, Evaluation, FACILITATOR, 'Prefer chocolate ice cream in the cone' 45 00:36:00, Evaluation, FACILITATOR, 'Put cones on heads' 46 00:41:00, CAD Log, Incident #181, Detail: 14-13 14-7 14-21 1098 TRK TOWED ALL LNS CLR 47 01:38:00, Evaluation, CMS, Worst 48 01:43:00, Evaluation, ACTIVITY_LOG, Best 49 01:43:00, Evaluation, ACTIVITY_LOG, Worst 50 01:44:00, Evaluation, ACTIVITY_LOG, Good 51 01:46:00, Evaluation, ACTIVITY_LOG, Average 52 01:53:00, Evaluation, ATMS, Good 53 01:53:00, Evaluation, CAD, Best 54 01:53:00, Evaluation, CAD, Poor 55 0:24:41 LCS new closure: Sue TraineeT133AA.1, 133EB, Lane, Special Event 56 0:24:41 LCS new closure: Sue Trainee, T1AC.1, 1SB, Full, AC Paving 57 0:24:41 LCS new closure: User, T5AD.1, 5NB, Lane, Drainage Inspection 58 0:24:41 LCS status update: Sue Trainee, T73AA, 1097, Marjie 59 0:24:41 LCS status update: T1AB, 1022, JeNnY 60 0:24:41 LCS status update: T22AA, 1022, Joel 61 0:24:41 LCS status update: T22AB, 1022, april may 62 0:24:41 LCS status update: T22AB, 1098, APRIL MAY 63 09:03 LCS status update: T22AA, 1098, JOEL 64 09:31:46 LCS status update: T1AB, 1097, Jenny 65 09:36:26 LCS status update: T1AB, 1098, JENNY -
trunk/webapps/mergelogs.bash
r637 r638 1 1 # Merge log files and sort by timestamp 2 # Invoke from ' trunk' folder3 # TODO: Add error handling - missing files, not executed from ' trunk', ...2 # Invoke from 'webapps' folder 3 # TODO: Add error handling - missing files, not executed from 'webapps', ... 4 4 5 5 # 1. Runs a python program named "extract_caddetails" 6 6 # to extract CAD DETAIL lines from incident_script.xml 7 7 # and creates an output file "caddetails.csv" 8 PYTHONPATH= webapps/unifiedlogger.zip python -m extract_caddetails8 PYTHONPATH=unifiedlogger.zip python -m extract_caddetails 9 9 10 10 # 2. Define a variable for the directory containing the data files 11 dir=" webapps/dynamicdata"11 dir="dynamicdata" 12 12 13 13 # 3. Merge three files: unified log, cad details, and evaluation ratings 14 14 # then sort them by timestamp (reverse chronological). 15 15 # Final result placed in "unifiedlog_final.csv" 16 cat $dir/unifiedlog.csv $dir/caddetails.csv $dir/evalratings.csv | sort > $dir/unifiedlog_final.csv16 cat $dir/unifiedlog.csv $dir/caddetails.csv $dir/evalratings.csv ../../../web2py/samplelogfile.txt | sort > $dir/unifiedlog_final.csv 17 17 18 18 # 4. Next, launch the webserver and browse to localhost:8080/unifiedlogdisplay.html -
trunk/webapps/mergelogs.bat
r554 r638 7 7 set dir="webapps\dynamicdata" 8 8 REM 2. Merge the unified log with cad details and evaluation ratings 9 type %dir%\unifiedlog.csv %dir%\caddetails.csv %dir%\ ratings.csv| sort > %dir%\unifiedlog_final.csv9 type %dir%\unifiedlog.csv %dir%\caddetails.csv %dir%\evalratings.csv w:\web2py\samplelogfile.txt | sort > %dir%\unifiedlog_final.csv 10 10
Note: See TracChangeset
for help on using the changeset viewer.
