search

yakra / DataProcessing

Data Processing Scripts and Programs for Travel Mapping Project
0 stars 0 forks source link

overallMileageByRegion table can has epsilon #98

Open yakra opened 5 years ago

yakra commented 5 years ago 
CREATE TABLE overallMileageByRegion (region VARCHAR(8), activeMileage FLOAT, activePreviewMileage FLOAT);
INSERT INTO overallMileageByRegion VALUES
('AB','9205.78806588264','18443.1292934951')

... ,('AUS-QLD','0','7234.29054017452') ,('AUS-QLD','0','7234.29054017451') ... ,('AZ','6339.54724998451','6444.36770648277') ,('AZ','6339.54724998452','6444.36770648277') There's something going on. Just. Barely. Not. Deterministic. region.active_only_mileage, region.active_preview_mileage