Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Driving Distance vs AStar Path issue #52

Closed
woodbri opened this issue Feb 14, 2012 · 3 comments
Closed

Driving Distance vs AStar Path issue #52

woodbri opened this issue Feb 14, 2012 · 3 comments
Milestone

Comments

@woodbri
Copy link
Contributor

woodbri commented Feb 14, 2012

Samuel Schembri reports on 2012-01-16:

I used pgrouting 1.02 on postgres 8.2.17. At this time, I can't update Postgresql.

There is a different comportment between 'shortest_path_astar' and 'driving_distance' functions when I use reverse_cost column.

Here are graphe conditions :

For each edge without one-way : cost=reverse_cost=length
For each edge with one-way similar to digitalisation way : cost=length reverse_cost=-1 (or 100000)
For each edge with one-way inverse of digitalisation way : cost=-1  (or 100000) reverse_cost=length
All another edges are not in graphe. 

shortest_path_astar:

has_reverse_cost = false :
Edges with 'cost=-1' are forbiden and Pgrouting don't used them. 'Reverse_cost' information is not used.

has_reverse_cost = true:
Edges with 'cost=-1' are used if 'reserve_cost' is more than 0. Cost used by pgrouting is 'reserve_cost' column.
Edges with 'reverse_cost=-1' are used if 'cost' is more than 0. Cost used by pgrouting is 'cost' column.

T his computing is correct.

Driving_distance:

has_reverse_cost = false :
Edges with 'cost=-1' are forbiden and Pgrouting don't used them. 'Reverse_cost' information is not used.

has_reverse_cost = true :
Case one : Edge with 'cost=-1' and 'reverse_cost=length':
Edge can be traveled on digitalisation way ( cost =-1!!). Cost used by pgrouting is 'Reverse_cost' column.

Case two : Edge with cost=length and reverse_cost=-1:
Edge can be traveled on inverse digitalisation way. More, Cost used by pgrouting is 'cost' column.

In this two case, pgrouting don't respect restrictions. This computing is not correct.

Why I would like to used this method. I prefer driving-distance functions because when we must compute a lot of distances with same departure point, this method is more fast than 'shortest_path_astar' method. After, I can get distance with nodes directly.

Example : get distance between shop and 100 customers.

I can create little graphe ,function, and snapshot.

This is zip file with:
http://imaptools.com:8080/dl/pgRouting-bug52.zip

*Bug1.png You can see :

  • Shortest_path function result : Green line
  • Graph with digitalisation sens
  • Id of vertex
  • One way of 2 edges : red arrows

To go to vertex(48) since vertex (540), pgrouting is doing good choice because the edge (2: gid 51) has a big cost value . Full distance is 1159 meters.

*Bug2.png You can see :

  • Driving distance result: blue labels and variant color : Distance ( meters)
  • Edges used by pgrouting : blue line
  • One way of 2 edges : red arrows

To go to vertex(48) since vertex(540), pgrouting takes the edge (2) with big cost value and he used reverse_cost value to calculate full distance.

Distance vertex must be egal to 1159.

*Dump with my graphe . (create a tif1104 schema before import)

Query:

 select * 
 from shortest_path('
     select 
      id
      ,source
      ,target
      ,cost
      ,reverse_cost,
      to_cost
      ,rule

     from  
      tif1104.graphe
     where 
      statut is true
      order by id',
     540,
    48,
    false,
    true )

select 
* 
from  
 driving_distance(' 
    select 
     id
     ,source
     ,target
     ,cost
     ,reverse_cost
     ,to_cost
     ,rule
    from 
     tif1104.graphe
    where 
     statut is true
    order by id',
    540,
    2000,
    false,
    true)
@woodbri
Copy link
Contributor Author

woodbri commented Jun 7, 2013

Here is how to test this under pgr2.0:

createdb -U postgres -h localhost issue52
psql -U postgres -h localhost issue52
create extension postgis;
create extension pgrouting;
create schema tif1104;
\q
wget http://imaptools.com:8080/dl/pgRouting-bug52.zip
unzip pgRouting-bug52.zip
pg_restore -U postgres -h localhost -d issue52 -O -x  graphe_pg.dump
psql -U postgres -h localhost issue52
alter table tif1104.graphe set schema public;
drop schema tif1104;

select *
 from pgr_dijkstra('
     select
      id
      ,source
      ,target
      ,cost
      ,reverse_cost,
      to_cost
      ,rule
     from
      graphe
     where
      statut is true
      order by id',
     540,
    48,
    false,
    true );
/*
 seq | id1 |   id2   |       cost
-----+-----+---------+------------------
   0 | 540 | 9241160 | 241.930348071403
   1 | 561 | 9241159 | 44.2837141618171
   2 | 560 | 9241158 | 9.46509792548807
   3 |  26 | 9240901 | 31.8591261981089
   4 | 388 | 9240933 | 31.7064829130223
   5 | 412 | 9240932 | 18.1574044928279
   6 |  25 | 9240522 | 66.3302588909766
   7 |  46 | 9240872 | 159.740728300701
   8 | 366 | 9240873 | 100.544732163867
   9 |  47 | 9240524 | 119.631833407237
  10 |  50 | 9720091 |   21.60986242827
  11 |  52 | 9240525 | 313.357639261124
  12 |  48 |      -1 |                0
(13 rows)
*/

select
*
from
 pgr_drivingdistance('
    select
     id
     ,source
     ,target
     ,cost
     ,reverse_cost
     ,to_cost
     ,rule
    from
     graphe
    where
     statut is true
    order by id',
    540,
    2000,
    false,
    true);

/*
 seq | id1 |   id2   |       cost
-----+-----+---------+------------------
   0 |   1 | 9240497 | 587.022474487888
   1 |   2 | 9240491 | 515.428937333436
   2 |   3 | 9240483 | 1623.82778370157
   3 |   4 | 9720021 | 817.409654244303
   4 |   5 | 9240486 | 1540.40428236587
   5 |   6 | 9240628 | 560.083475505751
   6 |   7 | 9240499 | 624.575512994249
   7 |   8 | 9240553 | 1573.02039770026
   8 |   9 | 9241130 | 1294.40812474277
   9 |  10 | 9241097 | 1611.28868720573
  10 |  11 | 9720077 | 1486.48637884059
  11 |  12 | 9240777 | 1553.06686538372
  12 |  13 | 9240886 | 1750.39323950513
  13 |  14 | 9720077 | 1528.27079386028
  14 |  15 | 9240552 | 1562.15321295137
  15 |  16 | 9241096 | 1589.43264621895
  16 |  17 | 9240500 | 493.674146671686
  17 |  18 | 9240490 |  498.70590867323
  18 |  19 | 9240627 | 526.827100895348
  19 |  20 | 9240495 | 596.602862085516
  20 |  21 | 9241129 | 719.274319284833
  21 |  22 | 9240498 | 579.354479898052
  22 |  23 | 9241065 | 864.319472274324
  23 |  24 | 9240521 | 480.263196848175
  24 |  25 | 9240932 | 377.402173762667
  25 |  26 | 9241158 | 295.679160158708
  26 |  27 | 9240501 | 186.969375132806
  27 |  28 | 9240509 | 112.713477992685
  28 |  29 | 9240503 | 177.585836016781
  29 |  30 | 9689631 | 144.940198741662
  30 |  31 | 9689689 | 202.525933551599
  31 |  32 | 9689689 | 277.577366950964
  32 |  33 | 9240810 | 293.847916341788
  33 |  34 | 9240846 | 234.671926467552
  34 |  35 | 9240507 |   441.0044649971
  35 |  36 | 9240847 | 393.706856166307
  36 |  37 | 9241133 | 19.6280280321922
  37 |  38 | 9240518 | 66.9147885936418
  38 |  39 | 9240513 |  57.820402959506
  39 |  40 | 9240926 | 564.975695566513
  40 |  41 | 9240580 | 230.954876674043
  41 |  42 | 9720180 | 385.333996814764
  42 |  43 | 9241146 | 512.613524298608
  43 |  44 | 9241144 | 212.825238592637
  44 |  45 | 9240570 | 394.999299608896
  45 |  46 | 9240872 | 443.732432653644
  46 |  47 | 9240898 | 704.017893118212
  47 |  48 | 9240900 | 1158.61722821484
  48 |  49 | 9240899 | 808.132443346997
  49 |  50 | 9720091 | 823.649726525448
  50 |  51 | 9241012 | 1376.59537140326
  51 |  52 | 9720091 | 845.259588953718
  52 |  53 | 9240949 | 1185.52201871672
  53 |  54 | 9240897 | 1308.48597925101
  54 |  55 | 9720064 | 759.050843136542
  55 |  56 | 9241011 | 1196.50266542737
  56 |  57 | 9240896 | 1202.13599010882
  57 |  58 | 9240529 | 1239.36521487246
  58 |  59 | 9240532 | 1309.72171692133
  59 |  60 | 9240531 | 1398.51767798253
  60 |  61 | 9240541 | 1331.71198046956
  61 |  62 | 9240534 |  1364.6495774109
  62 |  63 | 9240542 | 1379.09783182416
  63 |  64 | 9240537 | 1344.32419782204
  64 |  65 | 9240538 | 1323.63020424014
  65 |  66 | 9240554 | 1622.02354522185
  66 |  67 | 9240540 | 1391.40058884795
  67 |  68 | 9720108 | 1388.11781240984
  68 |  69 | 9240545 | 1447.87158076492
  69 |  70 | 9240544 | 1429.55283457275
  70 |  71 | 9241003 | 1422.85196395515
  71 |  72 | 9720003 | 1377.74190222034
  72 |  73 | 9240548 | 1452.56831087282
  73 |  74 | 9240546 | 1413.64473308435
  74 |  75 | 9240548 | 1421.86148765832
  75 |  76 | 9240990 | 970.948418998596
  76 |  77 | 9689722 | 1214.68288720712
  77 |  78 | 9720108 | 1366.09891475888
  78 |  79 | 9240874 | 1582.04955742292
  79 |  80 | 9240877 | 1568.96768849067
  80 |  81 | 9240876 | 1656.69288920803
  81 |  82 | 9240606 |  1631.2385225457
  82 |  83 | 9240775 | 1733.30740636314
  83 |  84 | 9689632 | 1763.40957569333
  84 |  85 | 9241088 | 1755.58848841673
  85 |  86 | 9240997 | 1541.66439232531
  86 |  87 | 9241001 | 1745.39661065362
  87 |  88 | 9241000 | 1907.30747230675
  88 |  89 | 9241105 | 1951.89332590057
  89 |  90 | 9240978 | 1805.71267364253
  90 |  91 | 9240977 | 1888.01290106811
  91 |  92 | 9241108 | 1263.54661881119
  92 |  93 | 9241107 | 1420.96108034553
  93 |  94 | 9241151 | 419.628163841331
  94 |  95 | 9240564 | 531.929065876686
  95 |  96 | 9240565 |  604.14936029684
  96 |  97 | 9240567 |  571.04379536179
  97 |  98 | 9241100 | 554.856527195052
  98 |  99 | 9240572 | 504.160791650019
  99 | 100 | 9240840 | 467.959902015225
 100 | 101 | 9240841 | 325.506736598034
 101 | 102 | 9240577 | 512.614924113366
 102 | 103 | 9240573 | 702.995465952432
 103 | 104 | 9240576 | 589.631925088499
 104 | 105 | 9240574 | 709.084259845851
 105 | 106 | 9240575 | 633.776975504243
 106 | 107 | 9240903 | 559.561403462825
 107 | 108 | 9240578 | 607.880706953911
 108 | 109 | 9240905 | 813.982452969644
 109 | 110 | 9240587 | 302.344752428111
 110 | 111 | 9240581 | 799.082836025598
 111 | 112 | 9240984 |  689.48986176669
 112 | 114 | 9240981 | 745.564264434452
 113 | 115 | 9240982 | 808.715868055465
 114 | 116 | 9240985 | 732.753765916017
 115 | 117 | 9240588 | 521.438372682158
 116 | 118 | 9240983 | 649.439507648194
 117 | 119 | 9720231 | 321.788427473839
 118 | 120 | 9240839 |  389.42678610601
 119 | 121 | 9240833 |  522.20699482507
 120 | 122 | 9240589 | 544.418758670957
 121 | 123 | 9241004 | 871.121677924884
 122 | 124 | 9240812 | 1044.09752582637
 123 | 125 | 9241005 | 978.732999120136
 124 | 126 | 9720123 | 693.214823764082
 125 | 127 | 9720123 | 758.692831326995
 126 | 128 | 9241015 |  651.34692249644
 127 | 129 | 9240593 | 735.541556777191
 128 | 130 | 9241014 | 565.719517651729
 129 | 131 | 9240594 | 650.400770273296
 130 | 132 | 9720124 | 680.128865428172
 131 | 133 | 9720124 | 745.094983578801
 132 | 134 | 9241093 | 1003.29335052695
 133 | 135 | 9241089 |  1075.5966477232
 134 | 136 | 9240914 | 1145.94292785809
 135 | 137 | 9240915 | 1221.53092077623
 136 | 138 | 9689722 | 1151.32806971482
 137 | 139 | 9240991 | 1023.40674772882
 138 | 140 | 9241094 | 1048.96878423852
 139 | 141 | 9240600 | 1001.75970466873
 140 | 142 | 9720020 | 1684.26502813216
 141 | 143 | 9240610 | 1578.90262232548
 142 | 144 | 9240604 | 1846.54852518027
 143 | 145 | 9240611 | 1740.02264025002
 144 | 146 | 9720229 | 1938.26770678166
 145 | 147 | 9240821 | 1980.95440341127
 146 | 148 | 9240968 | 1987.21940468159
 147 | 150 | 9240828 | 1812.26689422631
 148 | 152 | 9720125 | 1992.27651070797
 149 | 153 | 9240941 | 1681.11756857338
 150 | 154 | 9240609 |   1861.559611245
 151 | 155 | 9240929 | 1654.49601899085
 152 | 156 | 9689622 | 1179.45025796689
 153 | 157 | 9240954 | 1810.28172701235
 154 | 158 | 9240956 | 1728.79327721748
 155 | 160 | 9689623 |  1792.1206221377
 156 | 161 | 9240623 |  1822.1977739356
 157 | 162 | 9689723 | 1935.25759413229
 158 | 163 | 9689723 | 1981.27286746938
 159 | 164 | 9240620 | 1902.30233478846
 160 | 165 | 9240621 | 1960.92643016412
 161 | 166 | 9240624 | 1940.21625381883
 162 | 167 | 9240624 | 1853.34655014017
 163 | 168 | 9240907 | 1845.75738076698
 164 | 169 | 9240816 | 1978.30199116178
 165 | 171 | 9241143 | 264.294042120369
 166 | 172 | 9240629 | 768.724601736154
 167 | 173 | 9720137 | 553.973470719193
 168 | 174 | 9240631 | 618.493468557154
 169 | 175 | 9720137 | 599.798810537423
 170 | 176 | 9240633 | 653.039745817716
 171 | 177 | 9240634 | 828.406246178029
 172 | 178 | 9240646 | 670.887398116187
 173 | 179 | 9241055 | 1030.14589506142
 174 | 180 | 9689742 | 1194.08214215607
 175 | 181 | 9689742 | 1133.75487781476
 176 | 182 | 9240636 |  1203.6030134166
 177 | 183 | 9720138 |  877.57282908266
 178 | 184 | 9240638 | 971.014371109608
 179 | 185 | 9720138 | 917.473365062777
 180 | 186 | 9720139 | 1041.00443074113
 181 | 187 | 9240641 | 1112.72386826387
 182 | 188 | 9720139 | 1151.10877246703
 183 | 189 | 9240645 | 1196.08350057861
 184 | 190 | 9240645 | 975.616912731822
 185 | 191 | 9240998 | 691.838699423188
 186 | 192 | 9240649 | 737.399405275756
 187 | 197 | 9720004 | 771.423791582386
 188 | 205 | 9241027 |  1920.1506663953
 189 | 206 | 9240657 | 1974.50620391102
 190 | 282 | 9240891 | 1977.91427801157
 191 | 283 | 9240993 | 1935.39475650957
 192 | 284 | 9240853 |  1894.4028325475
 193 | 286 | 9240945 | 1975.79704081827
 194 | 287 | 9240892 | 1869.10957631048
 195 | 288 | 9241136 |  1823.8859570195
 196 | 289 | 9240893 |   1784.314200204
 197 | 290 | 9240784 | 1707.57178096054
 198 | 291 | 9240784 | 1694.07201910041
 199 | 292 | 9240783 | 1687.83664248352
 200 | 293 | 9240782 | 1714.30111505263
 201 | 294 | 9240786 | 1796.50520611482
 202 | 299 | 9240894 | 1929.07271776074
 203 | 309 | 9240863 | 1982.19273057938
 204 | 315 | 9240810 | 320.847050462632
 205 | 316 | 9240812 | 1161.31507426941
 206 | 317 | 9240814 | 802.344858805026
 207 | 320 | 9240971 | 1933.61965784175
 208 | 321 | 9720229 | 1834.47286265748
 209 | 322 | 9240972 | 1968.55490079247
 210 | 328 | 9240828 | 1858.85081386254
 211 | 331 | 9240973 | 1704.67932891359
 212 | 332 | 9240975 | 1939.44766494715
 213 | 333 | 9240834 | 572.915825997275
 214 | 334 | 9240836 |  723.26684532302
 215 | 335 | 9720231 | 365.434285198485
 216 | 336 | 9240842 | 377.348669725291
 217 | 337 | 9240843 | 478.517499886654
 218 | 338 | 9240844 | 405.791734917285
 219 | 339 | 9240844 | 439.926785363091
 220 | 340 | 9240845 | 402.898974523075
 221 | 341 | 9240848 | 320.191249502259
 222 | 342 | 9240850 | 334.885409368591
 223 | 343 | 9240850 | 364.339882044591
 224 | 344 | 9720003 |  1344.3249640236
 225 | 345 | 9241134 | 1941.98414805777
 226 | 347 | 9720004 | 1367.31302968628
 227 | 349 | 9241043 | 1871.41760656729
 228 | 350 | 9241035 | 1962.74224555193
 229 | 351 | 9241029 | 1988.28448294935
 230 | 360 | 9241075 | 1639.42827229836
 231 | 361 | 9241036 | 1696.15980682024
 232 | 362 | 9240869 | 1817.06754067876
 233 | 363 | 9241049 | 1660.22022731952
 234 | 364 | 9240871 |  1734.0796773108
 235 | 365 | 9241066 | 1203.10130404946
 236 | 366 | 9240873 | 603.473160954344
 237 | 367 | 9240875 | 1694.76995087123
 238 | 368 | 9240877 | 1623.18054898822
 239 | 370 | 9240881 | 1999.62570735733
 240 | 374 | 9240883 | 1944.57270502562
 241 | 376 | 9689622 | 1208.11472326747
 242 | 377 | 9241112 | 1856.38849461479
 243 | 378 | 9720012 | 1773.58153785783
 244 | 383 | 9240893 |  1824.7458177182
 245 | 384 | 9240895 | 1995.29241676157
 246 | 385 | 9240897 | 1257.32880409468
 247 | 386 | 9240899 | 747.234582430361
 248 | 387 | 9240930 | 1260.98886377655
 249 | 388 | 9240933 | 327.538286356817
 250 | 389 | 9241152 | 324.764046407529
 251 | 390 | 9240904 | 628.272841991976
 252 | 391 | 9240905 | 734.768223964158
 253 | 392 | 9240986 | 796.985275966788
 254 | 393 | 9240979 | 1322.76075316589
 255 | 394 | 9689623 |  1812.4891861317
 256 | 395 | 9240957 | 1513.22255428491
 257 | 396 | 9689631 | 175.606386772598
 258 | 397 | 9240913 | 193.149756658779
 259 | 398 | 9240913 | 219.145525989522
 260 | 399 | 9240916 | 1189.83542477445
 261 | 400 | 9240916 | 1205.17374066799
 262 | 403 | 9240923 | 887.893070878299
 263 | 404 | 9689721 | 544.586055080605
 264 | 405 | 9240911 | 727.498073454439
 265 | 406 | 9240924 | 302.496544002426
 266 | 407 | 9240926 | 636.995214665568
 267 | 408 | 9240928 | 556.715409055665
 268 | 409 | 9720020 |   1726.875880947
 269 | 410 | 9240930 | 1432.74064052686
 270 | 411 | 9240931 | 418.498764572068
 271 | 412 | 9240933 | 359.244769269839
 272 | 413 | 9240935 | 1985.24015163182
 273 | 415 | 9241087 | 1115.71033563059
 274 | 416 | 9720021 | 639.591219118341
 275 | 417 | 9689743 |  1407.5803987568
 276 | 419 | 9689632 | 1753.94935981561
 277 | 420 | 9240942 | 1782.30146199099
 278 | 421 | 9240947 | 1999.97769117631
 279 | 423 | 9240950 | 874.015723561347
 280 | 424 | 9240950 | 886.609639989568
 281 | 425 | 9240952 | 986.646986990657
 282 | 426 | 9240955 | 1733.37509089133
 283 | 427 | 9240957 | 1616.15651611431
 284 | 435 | 9240968 | 1972.78697641194
 285 | 436 | 9240970 | 1907.87902101863
 286 | 437 | 9240972 | 1951.08059703456
 287 | 438 | 9241111 | 1808.58307398049
 288 | 440 | 9241106 | 1924.25545291789
 289 | 441 | 9240978 | 1882.59282451935
 290 | 442 | 9240980 | 1307.82045365925
 291 | 443 | 9240982 | 786.807797038594
 292 | 444 | 9240984 | 671.647054687697
 293 | 445 | 9240986 | 753.639661882429
 294 | 448 | 9720064 | 793.456369484784
 295 | 449 | 9240991 | 1017.54322110121
 296 | 450 | 9241013 | 554.940200685775
 297 | 453 | 9240997 | 1393.71949878441
 298 | 454 | 9241018 | 721.901649827517
 299 | 455 | 9241161 |   517.0239176045
 300 | 456 | 9241001 | 1891.60182473972
 301 | 457 | 9241003 | 1387.55465635016
 302 | 458 | 9241005 | 914.287449027078
 303 | 459 | 9241007 | 1944.32818031084
 304 | 462 | 9241012 | 1346.86422975323
 305 | 463 | 9241014 | 564.709236895346
 306 | 464 | 9241016 | 569.810687922216
 307 | 465 | 9241017 | 552.147891074836
 308 | 466 | 9241114 | 768.988891705661
 309 | 467 | 9241021 |   1878.871131423
 310 | 468 | 9241051 | 1935.91492489449
 311 | 469 | 9241050 | 1867.65168178786
 312 | 470 | 9241022 | 1884.39098588312
 313 | 471 | 9241024 | 1877.62936107633
 314 | 478 | 9241035 | 1949.04085277379
 315 | 479 | 9241051 | 1909.65172301527
 316 | 483 | 9241045 | 1976.37378086843
 317 | 485 | 9241074 | 1560.11599770627
 318 | 486 | 9241076 |  1474.5719367372
 319 | 487 | 9241077 |  1635.6333556347
 320 | 491 | 9241056 | 1132.86950534279
 321 | 492 | 9241069 |   930.8027105332
 322 | 493 | 9241068 | 822.313086542195
 323 | 495 | 9241062 | 1421.13027319921
 324 | 496 | 9241116 | 822.672910817144
 325 | 497 | 9241128 |  1027.5374790267
 326 | 498 | 9241125 | 846.274286037747
 327 | 499 | 9241067 | 1251.36974820062
 328 | 500 | 9241122 | 798.877923039909
 329 | 501 | 9241120 | 893.503568135128
 330 | 504 | 9241075 |     1599.2872307
 331 | 505 | 9241077 | 1499.76526076619
 332 | 509 | 9241084 | 551.028627493181
 333 | 510 | 9241062 | 1588.14832723793
 334 | 511 | 9241123 | 1379.44491054859
 335 | 512 | 9241087 | 1171.93429752545
 336 | 513 | 9241088 |  1803.4173672555
 337 | 514 | 9241109 | 1296.93694982256
 338 | 515 | 9241091 | 1062.74903311358
 339 | 516 | 9241095 | 1053.73722467342
 340 | 517 | 9241095 | 1012.75406041291
 341 | 518 | 9241098 | 1605.01732361303
 342 | 519 | 9241098 | 1866.83697605259
 343 | 520 | 9241104 | 661.867609737322
 344 | 521 | 9241103 | 642.057123395146
 345 | 522 | 9241104 | 655.145099990228
 346 | 523 | 9241106 | 1931.13634432588
 347 | 524 | 9241108 | 1388.53930663453
 348 | 525 | 9241110 | 1294.69488687169
 349 | 526 | 9241112 | 1836.74588116616
 350 | 527 | 9241119 | 852.937784138034
 351 | 528 | 9241121 |  773.99362153586
 352 | 529 | 9689743 | 1403.77027023717
 353 | 530 | 9241126 | 825.761152923218
 354 | 531 | 9241127 | 829.916670128466
 355 | 533 | 9241120 | 872.864826003019
 356 | 534 | 9241122 | 792.687282981735
 357 | 535 | 9241124 | 1389.99385725164
 358 | 536 | 9241126 | 840.337624985657
 359 | 537 | 9241128 | 845.212784501521
 360 | 538 | 9241130 | 1252.62567005043
 361 | 540 | 9241160 |                0
 362 | 542 | 9241136 | 1868.75458228276
 363 | 543 | 9241142 | 128.301737148882
 364 | 544 | 9241138 | 134.975057465502
 365 | 545 | 9241139 | 144.045563659145
 366 | 546 | 9241142 | 122.920951130802
 367 | 547 | 9241141 |  154.33788569102
 368 | 548 | 9241140 | 149.711940139653
 369 | 549 | 9241145 | 242.721112497208
 370 | 550 | 9241145 | 261.201493549968
 371 | 551 | 9720179 | 493.787320375581
 372 | 552 | 9720179 | 550.263954534061
 373 | 553 | 9241148 | 492.499814472359
 374 | 554 | 9241154 | 457.786631485516
 375 | 555 | 9241155 | 448.706301055248
 376 | 556 | 9241150 | 459.861136385038
 377 | 557 | 9241153 |  344.38065557017
 378 | 558 | 9241157 | 392.188805797488
 379 | 559 | 9241156 | 426.657208441732
 380 | 560 | 9241159 |  286.21406223322
 381 | 561 | 9241160 | 241.930348071403
 382 | 562 | 9720180 | 483.301447476245
 383 | 563 | 9241163 | 1645.12102875836
 384 | 564 | 9241164 | 1416.35776255028
 385 | 565 | 9241165 |  1389.6303010148
 386 | 567 | 9241086 | 1212.11657683313
 387 | 568 | 9241064 | 1230.44062596538
 388 | 570 | 9241102 |  791.21768594355
 389 | 572 | 9240927 | 625.776008182241
 390 | 573 | 9241099 | 739.158744985071
 391 | 574 | 9241084 | 594.080200944671
 392 | 579 | 9241056 | 1169.75012557737
 393 | 580 | 9241067 | 1498.45784881773
 394 | 591 | 9240923 | 856.256598876129
 395 | 596 | 9241162 | 1828.07165200992
(396 rows)
*/

@woodbri
Copy link
Contributor Author

woodbri commented Jun 7, 2013

bug1

bug2

@woodbri
Copy link
Contributor Author

woodbri commented Jun 7, 2013

I must have fixed this when making other changes, because I have verified that both are generating the same results now. Closing.

@woodbri woodbri closed this as completed Jun 7, 2013
@dkastl dkastl removed the 2.0 label Mar 23, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants