Skip to Main Content

Averages, not as simple as it seems!

FlyingGuyFeb 26 2014 — edited Feb 28 2014

Hey there folks...

oracle 11gR2 EE / Oracle Linux, 12 cores  48gigs of ram big but relatively slow disk array ( 7200 rpm )

I asked this question a while back ( or something very similar ) but the whole problem got back burnered but it has seen come to the front so...

The basic challenge is this.  We receive  data for a detector every 30 seconds and the time is stored in the column measure_dt as a timestamp and the values we are interested in this case are: flow,density and speed.  We take a straight avg() for each over a 15 minute period and store that value.  The trick is that assuming a midnight starting point that "15" minute average is actually 14.5 minutes since we average from midnight 00:00:00 to 00:14:30, 00:15:00 - 00:29:30, etc.  and for a single period and a single vds_id the query is utterly simple:

select vds_id,avg(flow),avg(density),avg(speed) from detector_30_sec_filt where vds_id = x and measure_dt between a and b group by vds_id

The problem comes in when you want to run this over thousands of vds ID's for a period of a few months and store the resulting 15 min averages per vds ID.  Each day will yield 96 averages per VDS ID (24 hours / 15 minutes = 96 ) and each entry stores the 15 minute stamp, eg: 00:00:00, 00:15:00, 00:30:00, 00:45:00, 01:00:00, 01:15:00.  I thought about grouping but then how do you make it jump 30 seconds after each vds to get an output that looks like:

154305,01-JAN-2014 00:00:00,avg_speed,avg_density,avg_flow

154305,01-JAN-2014 00:15:00,avg_speed,avg_density,avg_flow

154305,01-JAN-2014 00:30:00,avg_speed,avg_density,avg_flow

I built a stored procedure that wraps the simple query in loops that handle the time periods and vds_id but when it starts trying to handle months at a time, it just takes forever!  It is currently running for 269 hours handling  1348 vds_id over 97 days * 2880 rows = 287285760 rows of data.  This results in running 7200 queries per vds ID to cover the time period. There has just GOT to be a better way so i come to you the best and the brightest and humbly ask for some help.

Table Definition...

CREATE TABLE DETECTOR_30SEC_FILT (

VDS_ID NUMBER NOT NULL ENABLE,

MEASURE_DT TIMESTAMP (6) NOT NULL ENABLE,

FLOW NUMBER,

DENSITY NUMBER,

DENSITY_ERR NUMBER,

SPEED NUMBER,

SPEED_ERROR NUMBER,

FF_SPEED NUMBER,

FUNC_LOOP_FACT NUMBER,

G_FACTOR_LANE_0 NUMBER,

G_FACTOR_LANE_1 NUMBER,

G_FACTOR_LANE_2 NUMBER,

G_FACTOR_LANE_3 NUMBER,

G_FACTOR_LANE_4 NUMBER,

G_FACTOR_LANE_5 NUMBER,

G_FACTOR_LANE_6 NUMBER,

G_FACTOR_LANE_7 NUMBER,

G_FACTOR_LANE_8 NUMBER,

G_FACTOR_LANE_9 NUMBER,

DATA_SOURCE NUMBER,

FILTER_METHOD NUMBER,

CREATED DATE DEFAULT sysdate,

CREATED_BY VARCHAR2(30 BYTE) DEFAULT user,

MODIFIED_BY VARCHAR2(30 BYTE) DEFAULT USER,

MODIFIED DATE DEFAULT sysdate,

MODSTAMP TIMESTAMP (6) DEFAULT systimestamp )

Some data..  There are billions of rows.  This is a one hour sample over 8 detectors...

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:59:30',1.10000002,.036794275,0,25.7488174,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:59:30',1.16666663,.0385323875,0,26.1210613,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:59:30',.933333337,.0335450135,0,26.0185242,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:59:30',.566666663,.0191561617,0,26.3159828,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:59:00',1.23333335,.0410595126,0,25.9766655,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:59:00',.866666675,.0320429504,0,26.013443,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:59:00',.566666663,.0189796351,0,26.3929977,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:59:00',1.0333333,.0339946412,0,26.028162,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:58:30',1,.0374622829,0,26.1249561,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:58:30',.433333337,.014676135,0,26.5715179,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:58:30',1.06666672,.0364466906,0,25.8776989,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:58:30',.966666639,.0358237401,0,26.2722359,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:58:00',.400000006,.0137882847,0,26.5434399,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:58:00',.600000024,.02207442,0,26.4553738,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:58:00',1.20000005,.0453900732,0,24.2125568,.991019309,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:58:00',.733333349,.0257789269,0,26.2994156,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:57:30',1.23333335,.0414882973,0,25.7374821,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:57:30',1.89999998,.0676473677,0,25.4973793,1.19699037,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:57:30',.833333313,.0315991044,0,26.2739811,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:57:30',.355555564,.012828812,0,26.6172047,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:57:00',1.10000002,.03976129,0,25.8381386,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:57:00',.800000012,.0269245915,0,26.4278908,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:57:00',.600000024,.0196788609,0,26.4761143,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:57:00',.366666675,.0128519135,0,26.5728416,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:56:30',1.20000005,.0387390181,0,25.7116356,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:56:30',1.20000005,.0400853418,0,26.156786,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:56:30',.933333337,.0336009525,0,26.1298542,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:56:30',.333333343,.011560224,0,26.6982098,2.42083335,27,0.5

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:56:00',1.4666667,.0529077239,0,25.8722286,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:56:00',.666666687,.0238381065,0,26.3169365,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:56:00',.433333337,.0146617852,0,26.5460854,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:56:00',.733333349,.0240400303,0,26.3146648,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:55:30',.766666651,.027072439,0,26.3320065,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:55:30',.622222245,.0211633667,0,26.3711205,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:55:30',1.06666672,.0395578369,0,25.7430458,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:55:30',1.13333333,.0379981399,0,26.1902885,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:55:00',.5,.0169112794,0,26.366888,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:55:00',1.0333333,.0374409109,0,25.9768639,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:55:00',1.60000002,.0622406974,0,25.0592079,1.12628841,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:55:00',.600000024,.0213013701,0,26.4183102,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:54:30',1.36666667,.0460035019,0,26.0357857,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:54:30',.800000012,.0274427794,0,26.2878456,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:54:30',.366666675,.0117667094,0,26.5484371,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:54:30',.933333337,.0319267884,0,26.1768532,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:54:00',.866666675,.0314954668,0,26.2209206,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:54:00',1.60000002,.0555948466,0,25.8689728,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:54:00',.766666651,.0281630959,0,26.2580929,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:54:00',.633333325,.0211714413,0,26.1947117,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:53:30',.566666663,.0191091206,0,26.4393387,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:53:30',.766666651,.027546823,0,26.1642475,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:53:30',1.0333333,.0345468856,0,26.2228584,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:53:30',1.56666672,.0563200936,0,25.5612087,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:53:00',1.36666667,.0480245985,0,25.8790359,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:53:00',1.20000005,.041964177,0,25.9274578,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:53:00',.400000006,.0137815922,0,26.5553322,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:53:00',1.5333333,.0549016334,0,25.5410137,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:52:30',1.10000002,.0363990702,0,25.8527508,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:52:30',1.0333333,.0408963971,0,23.5311623,.865557969,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:52:30',1.20000005,.0419423804,0,25.9321213,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:52:30',.5,.0178194046,0,26.3669243,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:52:00',1.33333337,.0434140451,0,25.7183666,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:52:00',1.63333333,.0607905798,0,25.7922421,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:52:00',1.39999998,.0507564321,0,25.7549038,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:52:00',.566666663,.02050386,0,26.3936634,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:51:30',1.43333328,.0508472212,0,25.7198334,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:51:30',.311111122,.010839086,0,26.6595802,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:51:30',.666666687,.021262534,0,26.336956,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:51:30',1.36666667,.0469470322,0,25.9280624,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:51:00',1.16666663,.0423574708,0,26.1650944,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:51:00',1.20000005,.0418253653,0,25.8250732,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:51:00',.600000024,.0222824439,0,26.2675514,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:51:00',1.26666665,.0456481874,0,25.8860359,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:50:30',.5,.0180453062,0,26.4758148,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:50:30',1.16666663,.0409231782,0,25.84025,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:50:30',1.56666672,.0529764332,0,25.8255978,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:50:30',1.23333335,.0434693992,0,25.9094601,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:50:00',.600000024,.01980621,0,26.4768314,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:50:00',.366666675,.0129917059,0,26.676445,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:50:00',1.0333333,.0354797021,0,26.0802441,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:50:00',1.56666672,.055549819,0,25.8458157,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:49:30',1.60000002,.0591207892,0,25.4723434,1.17467117,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:49:30',1.20000005,.0413498692,0,25.9017239,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:49:30',.300000012,.0103630181,0,26.7286129,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:49:30',1,.0370010734,0,25.8767414,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:49:00',1.29999995,.0448883548,0,25.5611458,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:49:00',1.56666672,.0579477251,0,25.8238411,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:49:00',.699999988,.0246491283,0,26.3969593,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:49:00',.400000006,.0138451895,0,26.5966167,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:48:30',1.26666665,.0470498465,0,24.9336987,1.0725286,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:48:30',1.39999998,.0496194661,0,25.6786861,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:48:30',.400000006,.0139142647,0,26.634161,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:48:30',.933333337,.0345602557,0,26.0691471,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:48:00',1.23333335,.0430807509,0,25.9026566,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:48:00',.600000024,.020614367,0,26.318924,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:48:00',.800000012,.0299798883,0,26.1673679,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:48:00',1.76666665,.0655644462,0,25.3301468,1.16534531,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:47:30',1.70000005,.0580305047,0,25.6667995,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:47:30',1,.0360166878,0,26.1231823,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:47:30',.444444448,.0155932698,0,26.5242081,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:47:30',1.73333335,.0662574247,0,24.8417435,3.72769165,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:47:00',.833333313,.0322832465,0,26.2556438,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:47:00',.400000006,.0139377797,0,26.6329288,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:47:00',.633333325,.021031959,0,26.429678,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:47:00',1.33333337,.0475750156,0,25.5786648,1.16009521,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:46:30',1.39999998,.0543983541,0,25.9749966,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:46:30',1.10000002,.0411358662,0,25.9273281,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:46:30',.400000006,.0137261106,0,26.5565186,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:46:30',1.39999998,.0460350923,0,25.7383118,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:46:00',1.16666663,.040278025,0,26.1601467,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:46:00',.733333349,.0240304098,0,26.3075752,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:46:00',.600000024,.0216049887,0,26.4809418,2.42083335,27,0.5

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:46:00',.866666675,.0280375369,0,26.1797104,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:45:30',.966666639,.0341083407,0,25.823925,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:45:30',.466666669,.0163308978,0,26.5895386,2.42083335,27,0.5

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:45:30',1.23333335,.042304758,0,25.7401161,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:45:30',.966666639,.0331444591,0,26.2908974,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:45:00',1.13333333,.0379189327,0,25.7345982,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:45:00',1.0333333,.0382109098,0,25.3052597,1.11989903,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:45:00',.866666675,.0324718058,0,26.2031384,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:45:00',.333333343,.0110148266,0,26.4973717,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:44:30',1.29999995,.0430218056,0,25.9332523,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:44:30',1.10000002,.0394031517,0,25.8702774,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:44:30',.600000024,.0201853868,0,26.4759426,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:44:30',.899999976,.0282701459,0,25.9764729,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:44:00',1.5,.051945895,0,25.8790474,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:44:00',.600000024,.0217911415,0,26.4731236,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:44:00',.233333334,.00767803984,0,26.7527752,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:44:00',.933333337,.0320957638,0,26.0990181,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:43:30',1.10000002,.0363866575,0,26.1637478,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:43:30',.800000012,.0286090728,0,26.221941,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:43:30',.266666681,.00894672982,0,26.71138,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:43:30',1.0333333,.0340924896,0,26.0605373,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:43:00',1.16666663,.0413970277,0,25.9633503,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:43:00',.355555564,.0121688079,0,26.6575565,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:43:00',1.0333333,.0335907638,0,25.978096,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:43:00',.966666639,.0349247418,0,26.3108864,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:42:30',1.33333337,.0527307838,0,23.6582794,2.31080198,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:42:30',1.76666665,.0600531399,0,25.7049007,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:42:30',1.39999998,.0516614132,0,25.7329445,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:42:30',.566666663,.0189369805,0,26.3612785,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:42:00',1.43333328,.0528840162,0,25.0379772,1.09536362,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:42:00',.600000024,.0211357679,0,26.4733849,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:42:00',.400000006,.0136115896,0,26.633522,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:42:00',.833333313,.030618323,0,26.2040157,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:41:30',.866666675,.0294643361,0,26.1299458,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:41:30',1.20000005,.0447548293,0,26.1176472,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:41:30',1.39999998,.0479256324,0,25.7385063,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:41:30',.333333343,.0109200114,0,26.652895,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:41:00',1.10000002,.03644263,0,26.1917534,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:41:00',.966666639,.0364437662,0,26.1435528,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:41:00',.366666675,.0122681316,0,26.506916,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:41:00',1.33333337,.047054816,0,25.5015678,1.43467855,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:40:30',1.66666663,.0540990904,0,25.7395668,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:40:30',.899999976,.0358423218,0,26.2137032,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:40:30',.48888889,.0166124478,0,26.4387665,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:40:30',1.5333333,.0562530272,0,25.471056,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:40:00',1.43333328,.050845921,0,25.8563519,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:40:00',.733333349,.025815716,0,26.2750835,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:40:00',.48888889,.016179353,0,26.572937,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:40:00',1.10000002,.0381858163,0,25.7633801,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:39:30',.733333349,.0257103294,0,26.3661251,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:39:30',.866666675,.0303824898,0,26.2399597,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:39:30',.48888889,.016864514,0,26.5732918,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:39:30',1.16666663,.0399914086,0,25.9560547,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:39:00',1.36666667,.0462289676,0,25.9021473,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:39:00',1.79999995,.0652935207,0,25.3645401,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:39:00',.333333343,.0117460322,0,26.4912834,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:39:00',1.33333337,.0472122505,0,25.6199512,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:38:30',1.23333335,.0471341349,0,25.6743507,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:38:30',.699999988,.0240158997,0,26.3873749,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:38:30',1.86666667,.0664299577,0,25.2763767,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:38:30',.333333343,.0115575381,0,26.5949745,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:38:00',1.06666672,.0388021767,0,25.8682137,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:38:00',1.20000005,.0422049016,0,26.0882492,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:38:00',.833333313,.0271060225,0,26.1192646,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:38:00',.400000006,.0145171657,0,26.5395622,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:37:30',1.83333337,.0679331422,0,25.3069553,1.17467117,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:37:30',1.06666672,.0385840982,0,25.6459103,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:37:30',.433333337,.0157113317,0,26.5047398,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:37:30',.866666675,.0304694455,0,26.1671753,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:37:00',1.10000002,.0360985063,0,26.1872368,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:37:00',.733333349,.0262550917,0,26.3136139,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:37:00',.533333361,.0194438845,0,26.4349327,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:37:00',1.29999995,.0459790677,0,25.7212563,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:36:30',1.39999998,.0474921502,0,26.0016899,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:36:30',.866666675,.0314092711,0,26.2091827,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:36:30',.5,.0181204155,0,26.4258327,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:36:30',.866666675,.0267862622,0,26.1674652,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:36:00',1.10000002,.0360312946,0,25.8411045,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:36:00',1.56666672,.0535975508,0,25.8416271,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:36:00',.600000024,.0210990757,0,26.1669331,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:36:00',.633333325,.0231275,0,26.3676376,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:35:30',.866666675,.0324042365,0,26.1056747,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:35:30',1.26666665,.0420085825,0,25.9998531,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:35:30',.533333361,.0193287488,0,26.506525,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:35:30',.466666669,.0169548616,0,26.5239544,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:35:00',.311111122,.0112625631,0,26.6655273,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:35:00',.633333325,.019471921,0,26.3499966,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:35:00',1.79999995,.0701022968,0,25.6383915,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:35:00',1.23333335,.0427606404,0,25.9093456,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:34:30',1.60000002,.0598209165,0,24.5777225,1.00954771,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:34:30',1,.0353313833,0,26.0224171,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:34:30',.833333313,.0307502113,0,26.1518154,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:34:30',1.33333337,.0483324826,0,25.6388187,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:34:00',1.36666667,.0487795547,0,25.506752,1.43467855,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:34:00',1.4666667,.0497741252,0,25.9591866,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:34:00',1.13333333,.0443511307,0,25.9033642,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:34:00',.400000006,.0140412273,0,26.4978733,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:33:30',1.36666667,.0516251065,0,25.4095497,1.14591122,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:33:30',1.20000005,.0429558381,0,25.9273548,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:33:30',.533333361,.0187034011,0,26.4044228,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:33:30',1.29999995,.0444128402,0,25.4565067,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:33:00',.866666675,.0283166785,0,26.2865295,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:33:00',.766666651,.0257335454,0,26.2239342,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:33:00',.400000006,.0138713047,0,26.5636215,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:33:00',.533333361,.017791478,0,26.4808731,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:32:30',.833333313,.0262206309,0,26.208931,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:32:30',1.29999995,.0445116051,0,26.0735817,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:32:30',1.39999998,.049937129,0,25.7222919,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:32:30',.666666687,.0240460746,0,26.3501701,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:32:00',1.60000002,.0636322722,0,23.4381371,3.47463799,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:32:00',1.29999995,.0422780402,0,25.9521599,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:32:00',1.23333335,.0430579633,0,25.9103928,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:32:00',.633333325,.0220178012,0,26.2938919,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:31:30',.200000003,.00684644515,0,26.8100986,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:31:30',1.33333337,.0489823446,0,25.6513767,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:31:30',1.63333333,.058057528,0,25.8213959,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:31:30',.899999976,.0322744101,0,26.2039948,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:31:00',1.33333337,.0442832559,0,25.999073,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:31:00',1.0333333,.038434837,0,26.0527229,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:31:00',.200000003,.00663795276,0,26.8143291,2.42083335,27,0.5

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:31:00',1.10000002,.0347558148,0,25.8378239,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:30:30',.699999988,.022284817,0,26.2230053,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:30:30',1.5,.0494040623,0,25.8661041,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:30:30',.866666675,.0325205773,0,25.8482094,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:30:30',.400000006,.0135791954,0,26.5581875,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:30:00',1.33333337,.043976564,0,26.0474644,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:30:00',1.0333333,.0362899452,0,26.0901852,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:30:00',.5,.0174527708,0,26.376297,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:30:00',.899999976,.032649301,0,26.1803684,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:29:30',.266666681,.00918175746,0,26.7097492,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:29:30',.933333337,.0331015401,0,26.1959133,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:29:30',1.56666672,.0523975044,0,25.8710461,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:29:30',.866666675,.0333947875,0,26.1266041,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:29:00',1.06666672,.0414241217,0,26.2427597,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:29:00',1.79999995,.066537343,0,25.3157024,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:29:00',.622222245,.0224001464,0,26.4431591,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:29:00',1.5,.050254792,0,25.5070667,1.43467855,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:28:30',1.39999998,.0470818616,0,25.3929882,1.43467855,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:28:30',1.5,.060968738,0,24.5350342,1.01851821,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:28:30',1.16666663,.0411048867,0,25.9628525,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:28:30',.400000006,.0141206766,0,26.5678043,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:28:00',1.70000005,.0625104457,0,25.7795353,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:28:00',1.36666667,.0480234884,0,25.7905941,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:28:00',.566666663,.0203524847,0,26.4027519,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:28:00',1,.0338404551,0,25.9699726,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:27:30',1.10000002,.0371518731,0,25.9754276,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:27:30',1.20000005,.0428056642,0,26.0063419,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:27:30',1.60000002,.0598532036,0,25.5623436,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:27:30',.566666663,.0200345945,0,26.2593803,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:27:00',.733333349,.0259478055,0,26.2734261,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:27:00',1.13333333,.0406422354,0,26.1756172,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:27:00',.766666651,.0276329778,0,26.1760349,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:27:00',.433333337,.015522304,0,26.49757,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:26:30',1.66666663,.0577175841,0,25.3659821,1.43467855,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:26:30',1.06666672,.0342451483,0,26.2029438,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:26:30',1.5,.0541944653,0,25.6627293,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:26:30',.311111122,.0110530704,0,26.6530666,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:26:00',1.10000002,.0400185473,0,26.1739883,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:26:00',.833333313,.0307758581,0,26.2725849,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:26:00',.311111122,.0112785716,0,26.6614876,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:26:00',1.33333337,.0461658053,0,25.7986794,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:25:30',1.5,.0507958531,0,25.8748302,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:25:30',1.36666667,.0511128604,0,25.777504,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:25:30',.300000012,.0106611885,0,26.6700439,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:25:30',1,.034162268,0,25.9637737,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:25:00',.311111122,.0111848218,0,26.6434116,.605208337,27,0.75

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:25:00',1.23333335,.040632382,0,25.8015003,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:25:00',1.26666665,.0425387882,0,26.0292263,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:25:00',.933333337,.0333536156,0,26.1694984,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:24:30',1.36666667,.0484900437,0,25.5973644,1.43467855,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:24:30',1.4666667,.0468237549,0,25.8922462,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:24:30',1.26666665,.0463570729,0,25.8793602,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1118326,'17-JUL-2013 19:24:30',.633333325,.0227941833,0,26.3631725,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108479,'17-JUL-2013 19:24:00',1.39999998,.0497448631,0,25.6783276,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108592,'17-JUL-2013 19:24:00',1.16666663,.0384706482,0,26.1816654,.246238023,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSITY,DENSITY_ERR,SPEED,SPEED_ERROR,FF_SPEED,FUNC_LOOP_FACT) values(1108465,'17-JUL-2013 19:24:00',1.20000005,.0449601561,0,25.5543461,1.42675292,27,1

insert into detector_30sec_filt(VDS_ID,MEASURE_DT,FLOW,DENSI

Comments
Post Details
Added on Feb 26 2014
14 comments
300 views