Re: Second call for platform testing
| От | Mark Knox |
|---|---|
| Тема | Re: Second call for platform testing |
| Дата | |
| Msg-id | 5.1.0.14.0.20011201205944.0276bfe0@core.hardline.org обсуждение исходный текст |
| Ответ на | Second call for platform testing (Thomas Lockhart <lockhart@fourpalms.org>) |
| Ответы |
Re: Second call for platform testing
|
| Список | pgsql-hackers |
>Linux/arm Mark Knox
Had a look at 7.2b3 and sadly it's failing several tests. I saw several
"ERROR: PGSTAT: Creation of DB hash table failed" which I haven't seen before.
Geometry fails as usual due to some minor rounding. The others are
completely wrong. I'm afraid I don't have much time to look at this right
now (sorry) but I've attached the regression output and diffs if anyone
wants to check them.
(Note: any responses should probably be addressed to me directly as well as
to the list.. I will likely miss them otherwise. Thanks.)
__ .--------.
|==|| | -( Mark 'segfault' Knox )-
|==||________|
|::| __====__`. .'`. "Unix *is* user-friendly.. it's just
|__|/::::::::\ ~ (_) picky about its friends."
parallel group (13 tests): char name text boolean int2 oid varchar int8 float4 int4 float8 bit numeric
boolean ... ok
char ... ok
name ... ok
varchar ... ok
text ... ok
int2 ... ok
int4 ... ok
int8 ... ok
oid ... ok
float4 ... ok
float8 ... ok
bit ... ok
numeric ... FAILED
test strings ... ok
test numerology ... ok
parallel group (20 tests): point lseg box path circle time polygon timetz date interval reltime abstime comments
tintervalinet timestamp type_sanity timestamptz opr_sanity oidjoins
point ... ok
lseg ... ok
box ... ok
path ... ok
polygon ... ok
circle ... ok
date ... ok
time ... ok
timetz ... ok
timestamp ... ok
timestamptz ... ok
interval ... ok
abstime ... ok
reltime ... ok
tinterval ... ok
inet ... ok
comments ... ok
oidjoins ... ok
type_sanity ... ok
opr_sanity ... ok
test geometry ... FAILED
test horology ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok
parallel group (7 tests): create_aggregate create_operator triggers inherit constraints create_misc create_index
constraints ... ok
triggers ... ok
create_misc ... ok
create_aggregate ... ok
create_operator ... ok
create_index ... ok
inherit ... ok
test create_view ... ok
test sanity_check ... FAILED
test errors ... ok
test select ... FAILED
parallel group (16 tests): select_distinct_on select_into select_distinct select_having transactions random union
subselectcase arrays select_implicit portals join aggregates hash_index btree_index
select_into ... ok
select_distinct ... ok
select_distinct_on ... ok
select_implicit ... ok
select_having ... ok
subselect ... ok
union ... ok
case ... ok
join ... ok
aggregates ... ok
transactions ... ok
random ... ok
portals ... ok
arrays ... ok
btree_index ... ok
hash_index ... ok
test privileges ... ok
test misc ... ok
parallel group (5 tests): portals_p2 alter_table rules foreign_key select_views
select_views ... FAILED
alter_table ... FAILED
portals_p2 ... ok
rules ... ok
foreign_key ... ok
parallel group (3 tests): limit temp plpgsql
limit ... ok
plpgsql ... ok
temp ... ok
*** ./expected/numeric.out Fri Apr 7 15:17:42 2000
--- ./results/numeric.out Sat Dec 1 21:22:26 2001
***************
*** 489,494 ****
--- 489,495 ----
CREATE UNIQUE INDEX num_exp_log10_idx ON num_exp_log10 (id);
CREATE UNIQUE INDEX num_exp_power_10_ln_idx ON num_exp_power_10_ln (id);
VACUUM ANALYZE num_exp_add;
+ ERROR: PGSTAT: Creation of DB hash table failed
VACUUM ANALYZE num_exp_sub;
VACUUM ANALYZE num_exp_div;
VACUUM ANALYZE num_exp_mul;
======================================================================
*** ./expected/geometry.out Fri Sep 28 03:59:52 2001
--- ./results/geometry.out Sat Dec 1 21:23:06 2001
***************
*** 127,133 ****
| (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439)
| (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878)
| (0,0) | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264)
! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473)
| (-3,4) | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303)
| (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925)
| (-5,-12) | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616)
--- 127,133 ----
| (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439)
| (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878)
| (0,0) | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264)
! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472)
| (-3,4) | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303)
| (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925)
| (-5,-12) | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616)
***************
*** 150,160 ****
six | box
-----+----------------------------------------------------------------------------
| (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964)
! | (71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548)
! | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
| (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
| (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
! | (170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)
(6 rows)
-- translation
--- 150,160 ----
six | box
-----+----------------------------------------------------------------------------
| (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964)
! | (71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547)
! | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
| (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
| (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
! | (170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)
(6 rows)
-- translation
***************
*** 443,454 ****
FROM CIRCLE_TBL;
six |
polygon
-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
! |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359078377e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718156754e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077235131e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
|
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
! |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887966),(-3.33012701896897,0.500000000081028))
! |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617))
|
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
! |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239385585e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
(6 rows)
-- convert the circle to an 8-point polygon
--- 443,454 ----
FROM CIRCLE_TBL;
six |
polygon
-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
! |
((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138))
|
((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983795))
! |
((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028))
! |
((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.598076211373729),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048616))
|
((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162))
! |
((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983795))
(6 rows)
-- convert the circle to an 8-point polygon
***************
*** 456,467 ****
FROM CIRCLE_TBL;
six |
polygon
-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
! |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359078377e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718156754e-11),(2.12132034353258,-2.12132034358671),(-4.59307077235131e-11,-3),(-2.12132034359753,-2.12132034352175))
! |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181134),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
|
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
|
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
|
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
! |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181134),(200,-1.02068239385585e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6 rows)
--
--- 456,467 ----
FROM CIRCLE_TBL;
six |
polygon
-----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
! |
((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175))
! |
((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.710678119196,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917))
|
((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586))
|
((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752))
|
((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261))
! |
((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917))
(6 rows)
--
***************
*** 503,513 ****
WHERE (p1.f1 <-> c1.f1) > 0
ORDER BY distance, circle, point using <<;
twentyfour | circle | point | distance
! ------------+----------------+------------+-------------------
! | <(100,0),100> | (5.1,34.5) | 0.976531926977965
| <(1,2),3> | (-3,4) | 1.47213595499958
| <(0,0),3> | (-3,4) | 2
! | <(100,0),100> | (-3,4) | 3.07764064044151
| <(100,0),100> | (-5,-12) | 5.68348972285122
| <(1,3),5> | (-10,0) | 6.40175425099138
| <(1,3),5> | (10,10) | 6.40175425099138
--- 503,513 ----
WHERE (p1.f1 <-> c1.f1) > 0
ORDER BY distance, circle, point using <<;
twentyfour | circle | point | distance
! ------------+----------------+------------+------------------
! | <(100,0),100> | (5.1,34.5) | 0.97653192697797
| <(1,2),3> | (-3,4) | 1.47213595499958
| <(0,0),3> | (-3,4) | 2
! | <(100,0),100> | (-3,4) | 3.07764064044152
| <(100,0),100> | (-5,-12) | 5.68348972285122
| <(1,3),5> | (-10,0) | 6.40175425099138
| <(1,3),5> | (10,10) | 6.40175425099138
======================================================================
*** ./expected/sanity_check.out Mon Aug 27 19:23:34 2001
--- ./results/sanity_check.out Sat Dec 1 21:25:17 2001
***************
*** 1,4 ****
--- 1,5 ----
VACUUM;
+ ERROR: PGSTAT: Creation of DB hash table failed
--
-- sanity check, if we don't have indices the test will take years to
-- complete. But skip TOAST relations since they will have varying
***************
*** 21,26 ****
--- 22,28 ----
hash_name_heap | t
hash_txt_heap | t
ihighway | t
+ inet_tbl | t
num_exp_add | t
num_exp_div | t
num_exp_ln | t
***************
*** 59,63 ****
shighway | t
tenk1 | t
tenk2 | t
! (49 rows)
--- 61,65 ----
shighway | t
tenk1 | t
tenk2 | t
! (50 rows)
======================================================================
*** ./expected/select.out Mon Jul 16 01:07:00 2001
--- ./results/select.out Sat Dec 1 21:25:20 2001
***************
*** 211,232 ****
-- so ANALYZE first.
--
ANALYZE onek2;
--
-- awk '{if($1<10){print $0;}else{next;}}' onek.data | sort +0n -1
--
SELECT onek2.* WHERE onek2.unique1 < 10;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 0 | 998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
|AAAAAA | KMBAAA | OOOOxx
1 | 214 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3
|BAAAAA | GIAAAA | OOOOxx
2 | 326 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 5
|CAAAAA | OMAAAA | OOOOxx
3 | 431 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 6 | 7
|DAAAAA | PQAAAA | VVVVxx
- 4 | 833 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 9
|EAAAAA | BGBAAA | HHHHxx
5 | 541 | 1 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 10 | 11
|FAAAAA | VUAAAA | HHHHxx
- 6 | 978 | 0 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 13
|GAAAAA | QLBAAA | OOOOxx
7 | 647 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 14 | 15
|HAAAAA | XYAAAA | VVVVxx
8 | 653 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 16 | 17
|IAAAAA | DZAAAA | HHHHxx
! 9 | 49 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 18 | 19
|JAAAAA | XBAAAA | HHHHxx
(10 rows)
--
--- 211,233 ----
-- so ANALYZE first.
--
ANALYZE onek2;
+ ERROR: PGSTAT: Creation of DB hash table failed
--
-- awk '{if($1<10){print $0;}else{next;}}' onek.data | sort +0n -1
--
SELECT onek2.* WHERE onek2.unique1 < 10;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even
|stringu1 | stringu2 | string4
---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------
! 9 | 49 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 18 | 19
|JAAAAA | XBAAAA | HHHHxx
1 | 214 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3
|BAAAAA | GIAAAA | OOOOxx
2 | 326 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 5
|CAAAAA | OMAAAA | OOOOxx
3 | 431 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 6 | 7
|DAAAAA | PQAAAA | VVVVxx
5 | 541 | 1 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 10 | 11
|FAAAAA | VUAAAA | HHHHxx
7 | 647 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 14 | 15
|HAAAAA | XYAAAA | VVVVxx
8 | 653 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 16 | 17
|IAAAAA | DZAAAA | HHHHxx
! 4 | 833 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 9
|EAAAAA | BGBAAA | HHHHxx
! 6 | 978 | 0 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 13
|GAAAAA | QLBAAA | OOOOxx
! 0 | 998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
|AAAAAA | KMBAAA | OOOOxx
(10 rows)
--
***************
*** 266,290 ****
WHERE onek2.unique1 > 980;
unique1 | stringu1
---------+----------
! 981 | TLAAAA
! 982 | ULAAAA
983 | VLAAAA
- 984 | WLAAAA
- 985 | XLAAAA
- 986 | YLAAAA
- 987 | ZLAAAA
- 988 | AMAAAA
989 | BMAAAA
990 | CMAAAA
991 | DMAAAA
! 992 | EMAAAA
993 | FMAAAA
994 | GMAAAA
! 995 | HMAAAA
! 996 | IMAAAA
! 997 | JMAAAA
! 998 | KMAAAA
! 999 | LMAAAA
(19 rows)
SELECT two, stringu1, ten, string4
--- 267,291 ----
WHERE onek2.unique1 > 980;
unique1 | stringu1
---------+----------
! 997 | JMAAAA
! 995 | HMAAAA
! 999 | LMAAAA
983 | VLAAAA
989 | BMAAAA
+ 986 | YLAAAA
+ 996 | IMAAAA
+ 982 | ULAAAA
+ 992 | EMAAAA
990 | CMAAAA
991 | DMAAAA
! 984 | WLAAAA
! 981 | TLAAAA
! 998 | KMAAAA
993 | FMAAAA
994 | GMAAAA
! 988 | AMAAAA
! 987 | ZLAAAA
! 985 | XLAAAA
(19 rows)
SELECT two, stringu1, ten, string4
======================================================================
*** ./expected/select_views.out Sat Oct 13 13:41:11 2001
--- ./results/select_views.out Sat Dec 1 21:27:40 2001
***************
*** 6,342 ****
name |
thepath
| cname
------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------
Access Rd 25 | [(-121.9283,37.894),(-121.9283,37.9)]
| Oakland
Agua Fria Creek | [(-121.9254,37.922),(-121.9281,37.889)]
| Oakland
Andrea Cir | [(-121.733218,37.88641),(-121.733286,37.90617)]
| Oakland
Apricot Lane | [(-121.9471,37.401),(-121.9456,37.392)]
| Oakland
- Arlington Dr | [(-121.8802,37.408),(-121.8807,37.394)]
| Oakland
- Arlington Road | [(-121.7957,37.898),(-121.7956,37.906)]
| Oakland
- Arroyo Las Positas | [(-121.7973,37.997),(-121.7957,37.005)]
| Oakland
- Arroyo Seco | [(-121.7073,37.766),(-121.6997,37.729)]
| Oakland
- Calaveras Creek | [(-121.8203,37.035),(-121.8207,37.931)]
| Oakland
- Corriea Way | [(-121.9501,37.402),(-121.9505,37.398)]
| Oakland
- Cowing Road | [(-122.0002,37.934),(-121.9772,37.782)]
| Oakland
- Driscoll Road | [(-121.9482,37.403),(-121.948451,37.39995)]
| Oakland
- Enos Way | [(-121.7677,37.896),(-121.7673,37.91)]
| Oakland
- Fairview Ave | [(-121.999,37.428),(-121.9863,37.351)]
| Oakland
- I- 580 | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]
| Oakland
- I- 580 |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]
| Oakland
- I- 580 Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]
| Oakland
- I- 580 Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]
| Oakland
- I- 580 Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]
| Oakland
- I- 580 Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]
| Oakland
- I- 580/I-680 Ramp | ((-121.9207,37.988),(-121.9192,37.016))
| Oakland
- I- 680 |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
| Oakland
- I- 680 |
[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)]
| Oakland
- I- 680 | [(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)]
| Oakland
- I- 680 Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]
| Oakland
- I- 680 Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]
| Oakland
- I- 680 Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]
| Oakland
- I- 880 |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
| Oakland
- I- 880 |
[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)]
| Oakland
- Johnson Dr | [(-121.9145,37.901),(-121.915,37.877)]
| Oakland
- Juniper St | [(-121.7823,37.897),(-121.7815,37.9)]
| Oakland
- Las Positas Road | [(-121.764488,37.99199),(-121.75569,37.02022)]
| Oakland
- Livermore Ave | [(-121.7687,37.448),(-121.769,37.375)]
| Oakland
- Livermore Ave | [(-121.772719,37.99085),(-121.7728,37.001)]
| Oakland
- Mission Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
| Oakland
- Mission Blvd | [(-122.0006,37.896),(-121.9989,37.88)]
| Oakland
- Navajo Ct | [(-121.8779,37.901),(-121.8783,37.9)]
| Oakland
- Paseo Padre Pkwy | [(-122.0021,37.639),(-121.996,37.628)]
| Oakland
- Pimlico Dr | [(-121.8616,37.998),(-121.8618,37.008)]
| Oakland
- Rosedale Ct | [(-121.9232,37.9),(-121.924,37.897)]
| Oakland
- Saginaw Ct | [(-121.8803,37.898),(-121.8806,37.901)]
| Oakland
- Sp Railroad | [(-121.893564,37.99009),(-121.897,37.016)]
| Oakland
- Sp Railroad | [(-121.9565,37.898),(-121.9562,37.9)]
| Oakland
- State Hwy 84 |
[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)]
| Oakland
- Sunol Ridge Trl | [(-121.9419,37.455),(-121.9345,37.38)]
| Oakland
- Tassajara Creek | [(-121.87866,37.98898),(-121.8782,37.015)]
| Oakland
- Theresa Way | [(-121.7289,37.906),(-121.728,37.899)]
| Oakland
- Tissiack Way | [(-121.920364,37),(-121.9208,37.995)]
| Oakland
- Vallecitos Road | [(-121.8699,37.916),(-121.8703,37.891)]
| Oakland
- Warm Springs Blvd | [(-121.933956,37),(-121.9343,37.97)]
| Oakland
- Welch Creek Road | [(-121.7695,37.386),(-121.7737,37.413)]
| Oakland
- Whitlock Creek | [(-121.74683,37.91276),(-121.733107,37)]
| Oakland
- 1st St | [(-121.75508,37.89294),(-121.753581,37.90031)]
| Oakland
Apricot Lane | [(-121.9471,37.401),(-121.9456,37.392)]
| Oakland
Arden Road | [(-122.0978,37.177),(-122.1,37.177)]
| Oakland
Arlington Dr | [(-121.8802,37.408),(-121.8807,37.394)]
| Oakland
Arroyo Las Positas | [(-121.7973,37.997),(-121.7957,37.005)]
| Oakland
Ash St | [(-122.0408,37.31),(-122.04,37.292)]
| Oakland
- Bridgepointe Dr | [(-122.0514,37.305),(-122.0509,37.299)]
| Oakland
- Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Oakland
- Calaveras Creek | [(-121.8203,37.035),(-121.8207,37.931)]
| Oakland
- Celia St | [(-122.0611,37.3),(-122.0616,37.299)]
| Oakland
- Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Oakland
- Corriea Way | [(-121.9501,37.402),(-121.9505,37.398)]
| Oakland
- Crystaline Dr | [(-121.925856,37),(-121.925869,37.00527)]
| Oakland
- Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Oakland
- Driscoll Road | [(-121.9482,37.403),(-121.948451,37.39995)]
| Oakland
- Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Oakland
- Fairview Ave | [(-121.999,37.428),(-121.9863,37.351)]
| Oakland
- Hesperian Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]
| Oakland
- I- 580 |
[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]
|Oakland
- I- 580 | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]
| Oakland
- I- 580 |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]
| Oakland
- I- 580 Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]
| Oakland
- I- 580 Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]
| Oakland
- I- 580 Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]
| Oakland
- I- 580 Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]
| Oakland
- I- 580/I-680 Ramp | ((-121.9207,37.988),(-121.9192,37.016))
| Oakland
- I- 680 |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
| Oakland
- I- 680 Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]
| Oakland
- I- 680 Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]
| Oakland
- I- 680 Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]
| Oakland
- I- 880 |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
| Oakland
- I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Oakland
- I- 880 |
[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)]
| Oakland
- I- 880 Ramp | [(-122.0019,37.301),(-122.002,37.293)]
| Oakland
- I- 880 Ramp |
[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)]
| Oakland
- I- 880 Ramp |
[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)]
| Oakland
- I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Oakland
- I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Oakland
- I- 880 Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]
| Oakland
- I- 880 Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]
| Oakland
- Kildare Road | [(-122.0968,37.016),(-122.0959,37)]
| Oakland
- Las Positas Road | [(-121.764488,37.99199),(-121.75569,37.02022)]
| Oakland
- Livermore Ave | [(-121.7687,37.448),(-121.769,37.375)]
| Oakland
- Livermore Ave | [(-121.772719,37.99085),(-121.7728,37.001)]
| Oakland
- Mildred Ct | [(-122.0002,37.388),(-121.9998,37.386)]
| Oakland
- Miramar Ave | [(-122.1009,37.025),(-122.099089,37.03209)]
| Oakland
- Mission Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
| Oakland
- Moores Ave | [(-122.0087,37.301),(-122.0094,37.292)]
| Oakland
- Oakridge Road | [(-121.8316,37.049),(-121.828382,37)]
| Oakland
- Paseo Padre Pkwy | [(-121.9143,37.005),(-121.913522,37)]
| Oakland
- Periwinkle Road | [(-122.0451,37.301),(-122.044758,37.29844)]
| Oakland
- Pimlico Dr | [(-121.8616,37.998),(-121.8618,37.008)]
| Oakland
- Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Oakland
- Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Oakland
- Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Oakland
- Sp Railroad | [(-121.893564,37.99009),(-121.897,37.016)]
| Oakland
- Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Oakland
- Stanton Ave | [(-122.100392,37.0697),(-122.099513,37.06052)]
| Oakland
- Sunol Ridge Trl | [(-121.9419,37.455),(-121.9345,37.38)]
| Oakland
- Tassajara Creek | [(-121.87866,37.98898),(-121.8782,37.015)]
| Oakland
- Thackeray Ave | [(-122.072,37.305),(-122.0715,37.298)]
| Oakland
- Tissiack Way | [(-121.920364,37),(-121.9208,37.995)]
| Oakland
- Warm Springs Blvd | [(-121.933956,37),(-121.9343,37.97)]
| Oakland
- Welch Creek Road | [(-121.7695,37.386),(-121.7737,37.413)]
| Oakland
- Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Oakland
- Whitlock Creek | [(-121.74683,37.91276),(-121.733107,37)]
| Oakland
Avenue 134th | [(-122.1823,37.002),(-122.1851,37.992)]
| Oakland
Avenue 140th | [(-122.1656,37.003),(-122.1691,37.988)]
| Oakland
B St | [(-122.1749,37.451),(-122.1743,37.443)]
| Oakland
Bancroft Ave | [(-122.15714,37.4242),(-122.156,37.409)]
| Oakland
Bancroft Ave | [(-122.1643,37.523),(-122.1631,37.508),(-122.1621,37.493)]
| Oakland
Birch St | [(-122.1617,37.425),(-122.1614,37.417)]
| Oakland
Birch St | [(-122.1673,37.509),(-122.1661,37.492)]
| Oakland
Blacow Road | [(-122.0179,37.469),(-122.0167,37.465)]
| Oakland
Broadmore Ave | [(-122.095,37.522),(-122.0936,37.497)]
| Oakland
- Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Oakland
- C St | [(-122.1768,37.46),(-122.1749,37.435)]
| Oakland
- Cameron Ave | [(-122.1316,37.502),(-122.1327,37.481)]
| Oakland
- Cedar Blvd | [(-122.0282,37.446),(-122.0265,37.43)]
| Oakland
- Chapman Dr | [(-122.0421,37.504),(-122.0414,37.498)]
| Oakland
- Charles St | [(-122.0255,37.505),(-122.0252,37.499)]
| Oakland
- Cherry St | [(-122.0437,37.42),(-122.0434,37.413)]
| Oakland
- Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Oakland
- Coliseum Way | [(-122.2001,37.47),(-122.1978,37.516)]
| Oakland
- Cull Canyon Road | [(-122.0536,37.435),(-122.0499,37.315)]
| Oakland
- D St | [(-122.1811,37.505),(-122.1805,37.497)]
| Oakland
- Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Oakland
- Driftwood Dr | [(-122.0109,37.482),(-122.0113,37.477)]
| Oakland
- E St | [(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)]
| Oakland
- Eden Ave | [(-122.1143,37.505),(-122.1142,37.491)]
| Oakland
- Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Oakland
- Gading Road | [(-122.0801,37.343),(-122.08,37.336)]
| Oakland
- Harris Road | [(-122.0659,37.372),(-122.0675,37.363)]
| Oakland
- Hegenberger Exwy | [(-122.1946,37.52),(-122.1947,37.497)]
| Oakland
- Herrier St | [(-122.1943,37.006),(-122.1936,37.998)]
| Oakland
- Hesperian Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]
| Oakland
- I- 580 |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
| Oakland
- I- 580 |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
| Oakland
- I- 580 Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
| Oakland
- I- 580 Ramp | [(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)]
| Oakland
- I- 880 |
[(-122.0219,37.466),(-122.0205,37.447),(-122.020331,37.44447),(-122.020008,37.43962),(-122.0195,37.432),(-122.0193,37.429),(-122.0164,37.393),(-122.010219,37.34771),(-122.0041,37.313)]
| Oakland
- I- 880 |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
| Oakland
- I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Oakland
- I- 880 |
[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)]
| Oakland
- I- 880 |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
| Oakland
- I- 880 Ramp |
[(-122.0236,37.488),(-122.0231,37.458),(-122.0227,37.458),(-122.0223,37.452),(-122.0205,37.447)]
| Oakland
- I- 880 Ramp | [(-122.0238,37.491),(-122.0215,37.483),(-122.0211,37.477),(-122.0205,37.447)]
| Oakland
- I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Oakland
- I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Oakland
- I- 880 Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]
| Oakland
- I- 880 Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]
| Oakland
- Kaiser Dr | [(-122.067163,37.47821),(-122.060402,37.51961)]
| Oakland
- La Playa Dr | [(-122.1039,37.545),(-122.101,37.493)]
| Oakland
- Locust St | [(-122.1606,37.007),(-122.1593,37.987)]
| Oakland
- Logan Ct | [(-122.0053,37.492),(-122.0061,37.484)]
| Oakland
- Magnolia St | [(-122.0971,37.5),(-122.0962,37.484)]
| Oakland
- Mattos Dr | [(-122.0005,37.502),(-122.000898,37.49683)]
| Oakland
- Maubert Ave | [(-122.1114,37.009),(-122.1096,37.995)]
| Oakland
- McClure Ave | [(-122.1431,37.001),(-122.1436,37.998)]
| Oakland
- Medlar Dr | [(-122.0627,37.378),(-122.0625,37.375)]
| Oakland
- National Ave | [(-122.1192,37.5),(-122.1281,37.489)]
| Oakland
- Newark Blvd | [(-122.0352,37.438),(-122.0341,37.423)]
| Oakland
- Portsmouth Ave | [(-122.1064,37.315),(-122.1064,37.308)]
| Oakland
- Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Oakland
- Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Oakland
- Redwood Road | [(-122.1493,37.98),(-122.1437,37.001)]
| Oakland
- Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Oakland
- Skyline Blvd | [(-122.1738,37.01),(-122.1714,37.996)]
| Oakland
- Skyline Dr | [(-122.0277,37.5),(-122.0284,37.498)]
| Oakland
- Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Oakland
- Sp Railroad | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
| Oakland
- Sp Railroad | [(-122.1947,37.497),(-122.193328,37.4848)]
| Oakland
- State Hwy 84 | [(-122.0671,37.426),(-122.07,37.402),(-122.074,37.37),(-122.0773,37.338)]
| Oakland
- State Hwy 92 |
[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)]
| Oakland
- State Hwy 92 Ramp | [(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)]
| Oakland
- Tennyson Road | [(-122.0891,37.317),(-122.0927,37.317)]
| Oakland
- Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Oakland
- Willimet Way | [(-122.0964,37.517),(-122.0949,37.493)]
| Oakland
- Wisconsin St | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
| Oakland
- 100th Ave | [(-122.1657,37.429),(-122.1647,37.432)]
| Oakland
- 107th Ave | [(-122.1555,37.403),(-122.1531,37.41)]
| Oakland
- 85th Ave | [(-122.1877,37.466),(-122.186,37.476)]
| Oakland
- 89th Ave | [(-122.1822,37.459),(-122.1803,37.471)]
| Oakland
- 98th Ave | [(-122.1568,37.498),(-122.1558,37.502)]
| Oakland
- 98th Ave | [(-122.1693,37.438),(-122.1682,37.444)]
| Oakland
- Allen Ct | [(-122.0131,37.602),(-122.0117,37.597)]
| Berkeley
- Alvarado Niles Road | [(-122.0325,37.903),(-122.0316,37.9)]
| Berkeley
- Arizona St | [(-122.0381,37.901),(-122.0367,37.898)]
| Berkeley
- Avenue 134th | [(-122.1823,37.002),(-122.1851,37.992)]
| Berkeley
- Avenue 140th | [(-122.1656,37.003),(-122.1691,37.988)]
| Berkeley
- Avenue D | [(-122.298,37.848),(-122.3024,37.849)]
| Berkeley
Broadway | [(-122.2409,37.586),(-122.2395,37.601)]
| Berkeley
Buckingham Blvd | [(-122.2231,37.59),(-122.2214,37.606)]
| Berkeley
Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Berkeley
California St | [(-122.2032,37.005),(-122.2016,37.996)]
| Berkeley
Campus Dr | [(-122.1704,37.905),(-122.1678,37.868),(-122.1671,37.865)]
| Berkeley
Carson St | [(-122.1846,37.9),(-122.1843,37.901)]
| Berkeley
Cedar St | [(-122.3011,37.737),(-122.2999,37.739)]
| Berkeley
Central Ave | [(-122.2343,37.602),(-122.2331,37.595)]
| Berkeley
Champion St | [(-122.214,37.991),(-122.2147,37.002)]
| Berkeley
Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Berkeley
Coliseum Way | [(-122.2113,37.626),(-122.2085,37.592),(-122.2063,37.568)]
| Berkeley
Cornell Ave | [(-122.2956,37.925),(-122.2949,37.906),(-122.2939,37.875)]
| Berkeley
Creston Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
| Berkeley
Crow Canyon Creek | [(-122.043,37.905),(-122.0368,37.71)]
| Berkeley
Cull Creek | [(-122.0624,37.875),(-122.0582,37.527)]
| Berkeley
Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Berkeley
Deering St | [(-122.2146,37.904),(-122.2126,37.897)]
| Berkeley
Dimond Ave | [(-122.2167,37.994),(-122.2162,37.006)]
| Berkeley
Donna Way | [(-122.1333,37.606),(-122.1316,37.599)]
| Berkeley
Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Berkeley
Euclid Ave | [(-122.2671,37.009),(-122.2666,37.987)]
| Berkeley
Foothill Blvd | [(-122.2414,37.9),(-122.2403,37.893)]
| Berkeley
Fountain St | [(-122.2306,37.593),(-122.2293,37.605)]
| Berkeley
Grizzly Peak Blvd | [(-122.2213,37.638),(-122.2127,37.581)]
| Berkeley
Grove Way |
[(-122.0643,37.884),(-122.062679,37.89162),(-122.061796,37.89578),(-122.0609,37.9)]
| Berkeley
Herrier St | [(-122.1943,37.006),(-122.1936,37.998)]
| Berkeley
Hesperian Blvd | [(-122.1132,37.6),(-122.1123,37.586)]
| Berkeley
I- 580 |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
| Berkeley
I- 580 |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
| Berkeley
I- 580 |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
| Berkeley
I- 580 Ramp | [(-122.093241,37.90351),(-122.09364,37.89634),(-122.093788,37.89212)]
| Berkeley
I- 580 Ramp | [(-122.0934,37.896),(-122.09257,37.89961),(-122.0911,37.906)]
| Berkeley
I- 580 Ramp | [(-122.0941,37.897),(-122.0943,37.902)]
| Berkeley
I- 580 Ramp | [(-122.096,37.888),(-122.0962,37.891),(-122.0964,37.9)]
| Berkeley
I- 580 Ramp | [(-122.101,37.898),(-122.1005,37.902),(-122.0989,37.911)]
| Berkeley
I- 580 Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
| Berkeley
I- 880 |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
| Berkeley
I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Berkeley
I- 880 |
[(-122.1365,37.902),(-122.1358,37.898),(-122.1333,37.881),(-122.1323,37.874),(-122.1311,37.866),(-122.1308,37.865),(-122.1307,37.864),(-122.1289,37.851),(-122.1277,37.843),(-122.1264,37.834),(-122.1231,37.812),(-122.1165,37.766),(-122.1104,37.72),(-122.109695,37.71094),(-122.109,37.702),(-122.108312,37.69168),(-122.1076,37.681)]
| Berkeley
I- 880 |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
| Berkeley
I- 880 |
[(-122.2214,37.711),(-122.2202,37.699),(-122.2199,37.695),(-122.219,37.682),(-122.2184,37.672),(-122.2173,37.652),(-122.2159,37.638),(-122.2144,37.616),(-122.2138,37.612),(-122.2135,37.609),(-122.212,37.592),(-122.2116,37.586),(-122.2111,37.581)]
| Berkeley
I- 880 |
[(-122.2707,37.975),(-122.2693,37.972),(-122.2681,37.966),(-122.267,37.962),(-122.2659,37.957),(-122.2648,37.952),(-122.2636,37.946),(-122.2625,37.935),(-122.2617,37.927),(-122.2607,37.921),(-122.2593,37.916),(-122.258,37.911),(-122.2536,37.898),(-122.2432,37.858),(-122.2408,37.845),(-122.2386,37.827),(-122.2374,37.811)]
| Berkeley
I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Berkeley
I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Berkeley
I- 880 Ramp | [(-122.1029,37.61),(-122.1013,37.587),(-122.0999,37.569)]
| Berkeley
I- 880 Ramp | [(-122.1379,37.891),(-122.1383,37.897),(-122.1377,37.902)]
| Berkeley
I- 880 Ramp |
[(-122.1379,37.931),(-122.137597,37.92736),(-122.1374,37.925),(-122.1373,37.924),(-122.1369,37.914),(-122.1358,37.905),(-122.1365,37.908),(-122.1358,37.898)]
| Berkeley
I- 880 Ramp | [(-122.2536,37.898),(-122.254,37.902)]
| Berkeley
Jackson St | [(-122.0845,37.6),(-122.0842,37.606)]
| Berkeley
Joyce St | [(-122.0792,37.604),(-122.0774,37.581)]
| Berkeley
Keeler Ave | [(-122.2578,37.906),(-122.2579,37.899)]
| Berkeley
Laguna Ave | [(-122.2099,37.989),(-122.2089,37)]
| Berkeley
Lakehurst Cir | [(-122.284729,37.89025),(-122.286096,37.90364)]
| Berkeley
Lakeshore Ave | [(-122.2586,37.99),(-122.2556,37.006)]
| Berkeley
Linden St | [(-122.2867,37.998),(-122.2864,37.008)]
| Berkeley
Locust St | [(-122.1606,37.007),(-122.1593,37.987)]
| Berkeley
Marin Ave | [(-122.2741,37.894),(-122.272,37.901)]
| Berkeley
Martin Luther King Jr Way | [(-122.2712,37.608),(-122.2711,37.599)]
| Berkeley
Maubert Ave | [(-122.1114,37.009),(-122.1096,37.995)]
| Berkeley
McClure Ave | [(-122.1431,37.001),(-122.1436,37.998)]
| Berkeley
Miller Road | [(-122.0902,37.645),(-122.0865,37.545)]
| Berkeley
Mission Blvd | [(-122.0006,37.896),(-121.9989,37.88)]
| Berkeley
Oakland Inner Harbor | [(-122.2625,37.913),(-122.260016,37.89484)]
| Berkeley
Oneil Ave | [(-122.076754,37.62476),(-122.0745,37.595)]
| Berkeley
Parkridge Dr | [(-122.1438,37.884),(-122.1428,37.9)]
| Berkeley
Parkside Dr | [(-122.0475,37.603),(-122.0443,37.596)]
| Berkeley
Paseo Padre Pkwy | [(-122.0021,37.639),(-121.996,37.628)]
| Berkeley
Pearl St | [(-122.2383,37.594),(-122.2366,37.615)]
| Berkeley
Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Berkeley
Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Berkeley
Redding St | [(-122.1978,37.901),(-122.1975,37.895)]
| Berkeley
Redwood Road | [(-122.1493,37.98),(-122.1437,37.001)]
| Berkeley
Roca Dr | [(-122.0335,37.609),(-122.0314,37.599)]
| Berkeley
Sacramento St | [(-122.2799,37.606),(-122.2797,37.597)]
| Berkeley
Saddle Brook Dr | [(-122.1478,37.909),(-122.1454,37.904),(-122.1451,37.888)]
| Berkeley
San Andreas Dr | [(-122.0609,37.9),(-122.0614,37.895)]
| Berkeley
Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Berkeley
Shattuck Ave | [(-122.2686,37.904),(-122.2686,37.897)]
| Berkeley
Shoreline Dr | [(-122.2657,37.603),(-122.2648,37.6)]
| Berkeley
Skyline Blvd | [(-122.1738,37.01),(-122.1714,37.996)]
| Berkeley
Skywest Dr | [(-122.1161,37.62),(-122.1123,37.586)]
| Berkeley
Southern Pacific Railroad | [(-122.3002,37.674),(-122.2999,37.661)]
| Berkeley
Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Berkeley
Sp Railroad | [(-122.0914,37.601),(-122.087,37.56),(-122.086408,37.5551)]
| Berkeley
Sp Railroad | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
| Berkeley
State Hwy 123 |
[(-122.3004,37.986),(-122.2998,37.969),(-122.2995,37.962),(-122.2992,37.952),(-122.299,37.942),(-122.2987,37.935),(-122.2984,37.924),(-122.2982,37.92),(-122.2976,37.904),(-122.297,37.88),(-122.2966,37.869),(-122.2959,37.848),(-122.2961,37.843)]
| Berkeley
State Hwy 13 |
[(-122.1797,37.943),(-122.179871,37.91849),(-122.18,37.9),(-122.179023,37.86615),(-122.1787,37.862),(-122.1781,37.851),(-122.1777,37.845),(-122.1773,37.839),(-122.177,37.833)]
| Berkeley
State Hwy 238 |
((-122.098,37.908),(-122.0983,37.907),(-122.099,37.905),(-122.101,37.898),(-122.101535,37.89711),(-122.103173,37.89438),(-122.1046,37.892),(-122.106,37.89))
| Berkeley
State Hwy 238 Ramp | [(-122.1288,37.9),(-122.1293,37.895),(-122.1296,37.906)]
| Berkeley
Stuart St | [(-122.2518,37.6),(-122.2507,37.601),(-122.2491,37.606)]
| Berkeley
Tupelo Ter | [(-122.059087,37.6113),(-122.057021,37.59942)]
| Berkeley
West Loop Road | [(-122.0576,37.604),(-122.0602,37.586)]
| Berkeley
Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Berkeley
Wisconsin St | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
| Berkeley
Wp Railroad | [(-122.254,37.902),(-122.2506,37.891)]
| Berkeley
19th Ave | [(-122.2366,37.897),(-122.2359,37.905)]
| Berkeley
5th St | [(-122.296,37.615),(-122.2953,37.598)]
| Berkeley
82nd Ave | [(-122.1695,37.596),(-122.1681,37.603)]
| Berkeley
! Ada St | [(-122.2487,37.398),(-122.2496,37.401)]
| Lafayette
! California St | [(-122.2032,37.005),(-122.2016,37.996)]
| Lafayette
! Capricorn Ave | [(-122.2176,37.404),(-122.2164,37.384)]
| Lafayette
! Chambers Dr | [(-122.2004,37.352),(-122.1972,37.368)]
| Lafayette
! Chambers Lane | [(-122.2001,37.359),(-122.1975,37.371)]
| Lafayette
! Champion St | [(-122.214,37.991),(-122.2147,37.002)]
| Lafayette
! Coolidge Ave | [(-122.2007,37.058),(-122.1992,37.06)]
| Lafayette
! Creston Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
| Lafayette
! Dimond Ave | [(-122.2167,37.994),(-122.2162,37.006)]
| Lafayette
! Edgewater Dr | [(-122.201,37.379),(-122.2042,37.41)]
| Lafayette
! Euclid Ave | [(-122.2671,37.009),(-122.2666,37.987)]
| Lafayette
! Heartwood Dr | [(-122.2006,37.341),(-122.1992,37.338)]
| Lafayette
! Hollis St | [(-122.2885,37.397),(-122.289,37.414)]
| Lafayette
! I- 580 |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
| Lafayette
! I- 80 | ((-122.2937,37.277),(-122.3016,37.262))
| Lafayette
! I- 80 | ((-122.2962,37.273),(-122.3004,37.264))
| Lafayette
! I- 80 Ramp | [(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)]
| Lafayette
! I- 880 Ramp | [(-122.2771,37.002),(-122.278,37)]
| Lafayette
! Indian Way | [(-122.2066,37.398),(-122.2045,37.411)]
| Lafayette
! Laguna Ave | [(-122.2099,37.989),(-122.2089,37)]
| Lafayette
! Lakeshore Ave | [(-122.2586,37.99),(-122.2556,37.006)]
| Lafayette
! Linden St | [(-122.2867,37.998),(-122.2864,37.008)]
| Lafayette
! Mandalay Road | [(-122.2322,37.397),(-122.2321,37.403)]
| Lafayette
! Proctor Ave | [(-122.2267,37.406),(-122.2251,37.386)]
| Lafayette
! Sheridan Road | [(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)]
| Lafayette
! State Hwy 13 |
[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)]
| Lafayette
! State Hwy 13 Ramp | [(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)]
| Lafayette
! State Hwy 24 |
[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)]
| Lafayette
! Taurus Ave | [(-122.2159,37.416),(-122.2128,37.389)]
| Lafayette
! 14th St | [(-122.299,37.147),(-122.3,37.148)]
| Lafayette
! 5th St | [(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)]
| Lafayette
98th Ave | [(-122.2001,37.258),(-122.1974,37.27)]
| Lafayette
(333 rows)
--- 6,342 ----
name |
thepath
| cname
------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------
Access Rd 25 | [(-121.9283,37.894),(-121.9283,37.9)]
| Oakland
+ Ada St | [(-122.2487,37.398),(-122.2496,37.401)]
| Lafayette
Agua Fria Creek | [(-121.9254,37.922),(-121.9281,37.889)]
| Oakland
+ Allen Ct | [(-122.0131,37.602),(-122.0117,37.597)]
| Berkeley
+ Alvarado Niles Road | [(-122.0325,37.903),(-122.0316,37.9)]
| Berkeley
Andrea Cir | [(-121.733218,37.88641),(-121.733286,37.90617)]
| Oakland
Apricot Lane | [(-121.9471,37.401),(-121.9456,37.392)]
| Oakland
Apricot Lane | [(-121.9471,37.401),(-121.9456,37.392)]
| Oakland
Arden Road | [(-122.0978,37.177),(-122.1,37.177)]
| Oakland
+ Arizona St | [(-122.0381,37.901),(-122.0367,37.898)]
| Berkeley
+ Arlington Dr | [(-121.8802,37.408),(-121.8807,37.394)]
| Oakland
Arlington Dr | [(-121.8802,37.408),(-121.8807,37.394)]
| Oakland
+ Arlington Road | [(-121.7957,37.898),(-121.7956,37.906)]
| Oakland
+ Arroyo Las Positas | [(-121.7973,37.997),(-121.7957,37.005)]
| Oakland
Arroyo Las Positas | [(-121.7973,37.997),(-121.7957,37.005)]
| Oakland
+ Arroyo Seco | [(-121.7073,37.766),(-121.6997,37.729)]
| Oakland
Ash St | [(-122.0408,37.31),(-122.04,37.292)]
| Oakland
Avenue 134th | [(-122.1823,37.002),(-122.1851,37.992)]
| Oakland
+ Avenue 134th | [(-122.1823,37.002),(-122.1851,37.992)]
| Berkeley
Avenue 140th | [(-122.1656,37.003),(-122.1691,37.988)]
| Oakland
+ Avenue 140th | [(-122.1656,37.003),(-122.1691,37.988)]
| Berkeley
+ Avenue D | [(-122.298,37.848),(-122.3024,37.849)]
| Berkeley
B St | [(-122.1749,37.451),(-122.1743,37.443)]
| Oakland
Bancroft Ave | [(-122.15714,37.4242),(-122.156,37.409)]
| Oakland
Bancroft Ave | [(-122.1643,37.523),(-122.1631,37.508),(-122.1621,37.493)]
| Oakland
Birch St | [(-122.1617,37.425),(-122.1614,37.417)]
| Oakland
Birch St | [(-122.1673,37.509),(-122.1661,37.492)]
| Oakland
Blacow Road | [(-122.0179,37.469),(-122.0167,37.465)]
| Oakland
+ Bridgepointe Dr | [(-122.0514,37.305),(-122.0509,37.299)]
| Oakland
Broadmore Ave | [(-122.095,37.522),(-122.0936,37.497)]
| Oakland
Broadway | [(-122.2409,37.586),(-122.2395,37.601)]
| Berkeley
Buckingham Blvd | [(-122.2231,37.59),(-122.2214,37.606)]
| Berkeley
+ Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Oakland
+ Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Oakland
Butterfield Dr | [(-122.0838,37.002),(-122.0834,37.987)]
| Berkeley
+ C St | [(-122.1768,37.46),(-122.1749,37.435)]
| Oakland
+ Calaveras Creek | [(-121.8203,37.035),(-121.8207,37.931)]
| Oakland
+ Calaveras Creek | [(-121.8203,37.035),(-121.8207,37.931)]
| Oakland
California St | [(-122.2032,37.005),(-122.2016,37.996)]
| Berkeley
+ California St | [(-122.2032,37.005),(-122.2016,37.996)]
| Lafayette
+ Cameron Ave | [(-122.1316,37.502),(-122.1327,37.481)]
| Oakland
Campus Dr | [(-122.1704,37.905),(-122.1678,37.868),(-122.1671,37.865)]
| Berkeley
+ Capricorn Ave | [(-122.2176,37.404),(-122.2164,37.384)]
| Lafayette
Carson St | [(-122.1846,37.9),(-122.1843,37.901)]
| Berkeley
+ Cedar Blvd | [(-122.0282,37.446),(-122.0265,37.43)]
| Oakland
Cedar St | [(-122.3011,37.737),(-122.2999,37.739)]
| Berkeley
+ Celia St | [(-122.0611,37.3),(-122.0616,37.299)]
| Oakland
Central Ave | [(-122.2343,37.602),(-122.2331,37.595)]
| Berkeley
+ Chambers Dr | [(-122.2004,37.352),(-122.1972,37.368)]
| Lafayette
+ Chambers Lane | [(-122.2001,37.359),(-122.1975,37.371)]
| Lafayette
Champion St | [(-122.214,37.991),(-122.2147,37.002)]
| Berkeley
+ Champion St | [(-122.214,37.991),(-122.2147,37.002)]
| Lafayette
+ Chapman Dr | [(-122.0421,37.504),(-122.0414,37.498)]
| Oakland
+ Charles St | [(-122.0255,37.505),(-122.0252,37.499)]
| Oakland
+ Cherry St | [(-122.0437,37.42),(-122.0434,37.413)]
| Oakland
+ Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Oakland
+ Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Oakland
Claremont Pl | [(-122.0542,37.995),(-122.0542,37.008)]
| Berkeley
+ Coliseum Way | [(-122.2001,37.47),(-122.1978,37.516)]
| Oakland
Coliseum Way | [(-122.2113,37.626),(-122.2085,37.592),(-122.2063,37.568)]
| Berkeley
+ Coolidge Ave | [(-122.2007,37.058),(-122.1992,37.06)]
| Lafayette
Cornell Ave | [(-122.2956,37.925),(-122.2949,37.906),(-122.2939,37.875)]
| Berkeley
+ Corriea Way | [(-121.9501,37.402),(-121.9505,37.398)]
| Oakland
+ Corriea Way | [(-121.9501,37.402),(-121.9505,37.398)]
| Oakland
+ Cowing Road | [(-122.0002,37.934),(-121.9772,37.782)]
| Oakland
Creston Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
| Berkeley
+ Creston Road | [(-122.2639,37.002),(-122.2613,37.986),(-122.2602,37.978),(-122.2598,37.973)]
| Lafayette
Crow Canyon Creek | [(-122.043,37.905),(-122.0368,37.71)]
| Berkeley
+ Crystaline Dr | [(-121.925856,37),(-121.925869,37.00527)]
| Oakland
+ Cull Canyon Road | [(-122.0536,37.435),(-122.0499,37.315)]
| Oakland
Cull Creek | [(-122.0624,37.875),(-122.0582,37.527)]
| Berkeley
+ D St | [(-122.1811,37.505),(-122.1805,37.497)]
| Oakland
+ Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Oakland
+ Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Oakland
Decoto Road | [(-122.0159,37.006),(-122.016,37.002),(-122.0164,37.993)]
| Berkeley
Deering St | [(-122.2146,37.904),(-122.2126,37.897)]
| Berkeley
Dimond Ave | [(-122.2167,37.994),(-122.2162,37.006)]
| Berkeley
+ Dimond Ave | [(-122.2167,37.994),(-122.2162,37.006)]
| Lafayette
Donna Way | [(-122.1333,37.606),(-122.1316,37.599)]
| Berkeley
+ Driftwood Dr | [(-122.0109,37.482),(-122.0113,37.477)]
| Oakland
+ Driscoll Road | [(-121.9482,37.403),(-121.948451,37.39995)]
| Oakland
+ Driscoll Road | [(-121.9482,37.403),(-121.948451,37.39995)]
| Oakland
+ E St | [(-122.1832,37.505),(-122.1826,37.498),(-122.182,37.49)]
| Oakland
+ Eden Ave | [(-122.1143,37.505),(-122.1142,37.491)]
| Oakland
+ Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Oakland
+ Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Oakland
Eden Creek | [(-122.022037,37.00675),(-122.0221,37.998)]
| Berkeley
+ Edgewater Dr | [(-122.201,37.379),(-122.2042,37.41)]
| Lafayette
+ Enos Way | [(-121.7677,37.896),(-121.7673,37.91)]
| Oakland
Euclid Ave | [(-122.2671,37.009),(-122.2666,37.987)]
| Berkeley
+ Euclid Ave | [(-122.2671,37.009),(-122.2666,37.987)]
| Lafayette
+ Fairview Ave | [(-121.999,37.428),(-121.9863,37.351)]
| Oakland
+ Fairview Ave | [(-121.999,37.428),(-121.9863,37.351)]
| Oakland
Foothill Blvd | [(-122.2414,37.9),(-122.2403,37.893)]
| Berkeley
Fountain St | [(-122.2306,37.593),(-122.2293,37.605)]
| Berkeley
+ Gading Road | [(-122.0801,37.343),(-122.08,37.336)]
| Oakland
Grizzly Peak Blvd | [(-122.2213,37.638),(-122.2127,37.581)]
| Berkeley
Grove Way |
[(-122.0643,37.884),(-122.062679,37.89162),(-122.061796,37.89578),(-122.0609,37.9)]
| Berkeley
+ Harris Road | [(-122.0659,37.372),(-122.0675,37.363)]
| Oakland
+ Heartwood Dr | [(-122.2006,37.341),(-122.1992,37.338)]
| Lafayette
+ Hegenberger Exwy | [(-122.1946,37.52),(-122.1947,37.497)]
| Oakland
+ Herrier St | [(-122.1943,37.006),(-122.1936,37.998)]
| Oakland
Herrier St | [(-122.1943,37.006),(-122.1936,37.998)]
| Berkeley
+ Hesperian Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]
| Oakland
+ Hesperian Blvd | [(-122.097,37.333),(-122.0956,37.31),(-122.0946,37.293)]
| Oakland
Hesperian Blvd | [(-122.1132,37.6),(-122.1123,37.586)]
| Berkeley
+ Hollis St | [(-122.2885,37.397),(-122.289,37.414)]
| Lafayette
+ I- 580 |
[(-121.727,37.074),(-121.7229,37.093),(-121.722301,37.09522),(-121.721001,37.10005),(-121.7194,37.106),(-121.7188,37.109),(-121.7168,37.12),(-121.7163,37.123),(-121.7145,37.127),(-121.7096,37.148),(-121.707731,37.1568),(-121.7058,37.166),(-121.7055,37.168),(-121.7044,37.174),(-121.7038,37.172),(-121.7037,37.172),(-121.7027,37.175),(-121.7001,37.181),(-121.6957,37.191),(-121.6948,37.192),(-121.6897,37.204),(-121.6697,37.185)]
|Oakland
+ I- 580 | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]
| Oakland
+ I- 580 | [(-121.9322,37.989),(-121.9243,37.006),(-121.9217,37.014)]
| Oakland
+ I- 580 |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]
| Oakland
+ I- 580 |
[(-122.018,37.019),(-122.0009,37.032),(-121.9787,37.983),(-121.958,37.984),(-121.9571,37.986)]
| Oakland
+ I- 580 |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
| Oakland
I- 580 |
[(-122.1108,37.023),(-122.1101,37.02),(-122.108103,37.00764),(-122.108,37.007),(-122.1069,37.998),(-122.1064,37.994),(-122.1053,37.982),(-122.1048,37.977),(-122.1032,37.958),(-122.1026,37.953),(-122.1013,37.938),(-122.0989,37.911),(-122.0984,37.91),(-122.098,37.908)]
| Berkeley
+ I- 580 |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
| Oakland
I- 580 |
[(-122.1543,37.703),(-122.1535,37.694),(-122.1512,37.655),(-122.1475,37.603),(-122.1468,37.583),(-122.1472,37.569),(-122.149044,37.54874),(-122.1493,37.546),(-122.1501,37.532),(-122.1506,37.509),(-122.1495,37.482),(-122.1487,37.467),(-122.1477,37.447),(-122.1414,37.383),(-122.1404,37.376),(-122.1398,37.372),(-122.139,37.356),(-122.1388,37.353),(-122.1385,37.34),(-122.1382,37.33),(-122.1378,37.316)]
| Berkeley
I- 580 |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
| Berkeley
+ I- 580 |
[(-122.2197,37.99),(-122.22,37.99),(-122.222092,37.99523),(-122.2232,37.998),(-122.224146,37.99963),(-122.2261,37.003),(-122.2278,37.007),(-122.2302,37.026),(-122.2323,37.043),(-122.2344,37.059),(-122.235405,37.06427),(-122.2365,37.07)]
| Lafayette
+ I- 580 Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]
| Oakland
+ I- 580 Ramp |
[(-121.8521,37.011),(-121.8479,37.999),(-121.8476,37.999),(-121.8456,37.01),(-121.8455,37.011)]
| Oakland
+ I- 580 Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]
| Oakland
+ I- 580 Ramp | [(-121.8743,37.014),(-121.8722,37.999),(-121.8714,37.999)]
| Oakland
+ I- 580 Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]
| Oakland
+ I- 580 Ramp |
[(-121.9043,37.998),(-121.9036,37.013),(-121.902632,37.0174),(-121.9025,37.018)]
| Oakland
+ I- 580 Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]
| Oakland
+ I- 580 Ramp |
[(-121.9368,37.986),(-121.936483,37.98832),(-121.9353,37.997),(-121.93504,37.00035),(-121.9346,37.006),(-121.933764,37.00031),(-121.9333,37.997),(-121.9322,37.989)]
| Oakland
I- 580 Ramp | [(-122.093241,37.90351),(-122.09364,37.89634),(-122.093788,37.89212)]
| Berkeley
I- 580 Ramp | [(-122.0934,37.896),(-122.09257,37.89961),(-122.0911,37.906)]
| Berkeley
I- 580 Ramp | [(-122.0941,37.897),(-122.0943,37.902)]
| Berkeley
I- 580 Ramp | [(-122.096,37.888),(-122.0962,37.891),(-122.0964,37.9)]
| Berkeley
I- 580 Ramp | [(-122.101,37.898),(-122.1005,37.902),(-122.0989,37.911)]
| Berkeley
+ I- 580 Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
| Oakland
I- 580 Ramp | [(-122.1086,37.003),(-122.1068,37.993),(-122.1066,37.992),(-122.1053,37.982)]
| Berkeley
+ I- 580 Ramp | [(-122.1414,37.383),(-122.1407,37.376),(-122.1403,37.372),(-122.139,37.356)]
| Oakland
+ I- 580/I-680 Ramp | ((-121.9207,37.988),(-121.9192,37.016))
| Oakland
+ I- 580/I-680 Ramp | ((-121.9207,37.988),(-121.9192,37.016))
| Oakland
+ I- 680 |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
| Oakland
+ I- 680 |
((-121.939,37.15),(-121.9387,37.145),(-121.9373,37.125),(-121.934242,37.07643),(-121.933886,37.0709),(-121.9337,37.068),(-121.933122,37.06139),(-121.932736,37.05698),(-121.93222,37.05108),(-121.931844,37.04678),(-121.930113,37.027),(-121.926829,37),(-121.9265,37.998),(-121.9217,37.96),(-121.9203,37.949),(-121.9184,37.934))
| Oakland
+ I- 680 |
[(-121.9101,37.715),(-121.911269,37.74682),(-121.9119,37.764),(-121.9124,37.776),(-121.9174,37.905),(-121.9194,37.957),(-121.9207,37.988)]
| Oakland
+ I- 680 | [(-121.9184,37.934),(-121.917,37.913),(-121.9122,37.83),(-121.9052,37.702)]
| Oakland
+ I- 680 Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]
| Oakland
+ I- 680 Ramp |
[(-121.8833,37.376),(-121.8833,37.392),(-121.883,37.4),(-121.8835,37.402),(-121.8852,37.422)]
| Oakland
+ I- 680 Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]
| Oakland
+ I- 680 Ramp | [(-121.92,37.438),(-121.9218,37.424),(-121.9238,37.408),(-121.9252,37.392)]
| Oakland
+ I- 680 Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]
| Oakland
+ I- 680 Ramp | [(-121.9238,37.402),(-121.9234,37.395),(-121.923,37.399)]
| Oakland
+ I- 80 | ((-122.2937,37.277),(-122.3016,37.262))
| Lafayette
+ I- 80 | ((-122.2962,37.273),(-122.3004,37.264))
| Lafayette
+ I- 80 Ramp | [(-122.2962,37.413),(-122.2959,37.382),(-122.2951,37.372)]
| Lafayette
+ I- 880 |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
| Oakland
+ I- 880 |
((-121.9669,37.075),(-121.9663,37.071),(-121.9656,37.065),(-121.9618,37.037),(-121.95689,37),(-121.948,37.933))
| Oakland
+ I- 880 |
[(-121.948,37.933),(-121.9471,37.925),(-121.9467,37.923),(-121.946,37.918),(-121.9452,37.912),(-121.937,37.852)]
| Oakland
+ I- 880 |
[(-122.0219,37.466),(-122.0205,37.447),(-122.020331,37.44447),(-122.020008,37.43962),(-122.0195,37.432),(-122.0193,37.429),(-122.0164,37.393),(-122.010219,37.34771),(-122.0041,37.313)]
| Oakland
+ I- 880 |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
| Oakland
I- 880 |
[(-122.0375,37.632),(-122.0359,37.619),(-122.0358,37.616),(-122.034514,37.60409),(-122.031876,37.57965),(-122.031193,37.57332),(-122.03016,37.56375),(-122.02943,37.55698),(-122.028689,37.54929),(-122.027833,37.53908),(-122.025979,37.51698),(-122.0238,37.491)]
| Berkeley
+ I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Oakland
+ I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Oakland
I- 880 |
[(-122.0612,37.003),(-122.0604,37.991),(-122.0596,37.982),(-122.0585,37.967),(-122.0583,37.961),(-122.0553,37.918),(-122.053635,37.89475),(-122.050759,37.8546),(-122.05,37.844),(-122.0485,37.817),(-122.0483,37.813),(-122.0482,37.811)]
| Berkeley
+ I- 880 |
[(-122.0831,37.312),(-122.0819,37.296),(-122.081,37.285),(-122.0786,37.248),(-122.078,37.24),(-122.077642,37.23496),(-122.076983,37.22567),(-122.076599,37.22026),(-122.076229,37.21505),(-122.0758,37.209)]
| Oakland
+ I- 880 |
[(-122.0978,37.528),(-122.096,37.496),(-122.0931,37.453),(-122.09277,37.4496),(-122.090189,37.41442),(-122.0896,37.405),(-122.085,37.34)]
| Oakland
I- 880 |
[(-122.1365,37.902),(-122.1358,37.898),(-122.1333,37.881),(-122.1323,37.874),(-122.1311,37.866),(-122.1308,37.865),(-122.1307,37.864),(-122.1289,37.851),(-122.1277,37.843),(-122.1264,37.834),(-122.1231,37.812),(-122.1165,37.766),(-122.1104,37.72),(-122.109695,37.71094),(-122.109,37.702),(-122.108312,37.69168),(-122.1076,37.681)]
| Berkeley
+ I- 880 |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
| Oakland
I- 880 |
[(-122.1755,37.185),(-122.1747,37.178),(-122.1742,37.173),(-122.1692,37.126),(-122.167792,37.11594),(-122.16757,37.11435),(-122.1671,37.111),(-122.1655,37.1),(-122.165169,37.09811),(-122.1641,37.092),(-122.1596,37.061),(-122.158381,37.05275),(-122.155991,37.03657),(-122.1531,37.017),(-122.1478,37.98),(-122.1407,37.932),(-122.1394,37.924),(-122.1389,37.92),(-122.1376,37.91)]
| Berkeley
I- 880 |
[(-122.2214,37.711),(-122.2202,37.699),(-122.2199,37.695),(-122.219,37.682),(-122.2184,37.672),(-122.2173,37.652),(-122.2159,37.638),(-122.2144,37.616),(-122.2138,37.612),(-122.2135,37.609),(-122.212,37.592),(-122.2116,37.586),(-122.2111,37.581)]
| Berkeley
I- 880 |
[(-122.2707,37.975),(-122.2693,37.972),(-122.2681,37.966),(-122.267,37.962),(-122.2659,37.957),(-122.2648,37.952),(-122.2636,37.946),(-122.2625,37.935),(-122.2617,37.927),(-122.2607,37.921),(-122.2593,37.916),(-122.258,37.911),(-122.2536,37.898),(-122.2432,37.858),(-122.2408,37.845),(-122.2386,37.827),(-122.2374,37.811)]
| Berkeley
+ I- 880 Ramp | [(-122.0019,37.301),(-122.002,37.293)]
| Oakland
+ I- 880 Ramp |
[(-122.0041,37.313),(-122.0018,37.315),(-122.0007,37.315),(-122.0005,37.313),(-122.0002,37.308),(-121.9995,37.289)]
| Oakland
+ I- 880 Ramp |
[(-122.0041,37.313),(-122.0038,37.308),(-122.0039,37.284),(-122.0013,37.287),(-121.9995,37.289)]
| Oakland
+ I- 880 Ramp |
[(-122.0236,37.488),(-122.0231,37.458),(-122.0227,37.458),(-122.0223,37.452),(-122.0205,37.447)]
| Oakland
+ I- 880 Ramp | [(-122.0238,37.491),(-122.0215,37.483),(-122.0211,37.477),(-122.0205,37.447)]
| Oakland
+ I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Oakland
+ I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Oakland
I- 880 Ramp | [(-122.059,37.982),(-122.0577,37.984),(-122.0612,37.003)]
| Berkeley
+ I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Oakland
+ I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Oakland
I- 880 Ramp | [(-122.0618,37.011),(-122.0631,37.982),(-122.0585,37.967)]
| Berkeley
+ I- 880 Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]
| Oakland
+ I- 880 Ramp | [(-122.085,37.34),(-122.0801,37.316),(-122.081,37.285)]
| Oakland
+ I- 880 Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]
| Oakland
+ I- 880 Ramp | [(-122.085,37.34),(-122.0866,37.316),(-122.0819,37.296)]
| Oakland
I- 880 Ramp | [(-122.1029,37.61),(-122.1013,37.587),(-122.0999,37.569)]
| Berkeley
I- 880 Ramp | [(-122.1379,37.891),(-122.1383,37.897),(-122.1377,37.902)]
| Berkeley
I- 880 Ramp |
[(-122.1379,37.931),(-122.137597,37.92736),(-122.1374,37.925),(-122.1373,37.924),(-122.1369,37.914),(-122.1358,37.905),(-122.1365,37.908),(-122.1358,37.898)]
| Berkeley
I- 880 Ramp | [(-122.2536,37.898),(-122.254,37.902)]
| Berkeley
+ I- 880 Ramp | [(-122.2771,37.002),(-122.278,37)]
| Lafayette
+ Indian Way | [(-122.2066,37.398),(-122.2045,37.411)]
| Lafayette
Jackson St | [(-122.0845,37.6),(-122.0842,37.606)]
| Berkeley
+ Johnson Dr | [(-121.9145,37.901),(-121.915,37.877)]
| Oakland
Joyce St | [(-122.0792,37.604),(-122.0774,37.581)]
| Berkeley
+ Juniper St | [(-121.7823,37.897),(-121.7815,37.9)]
| Oakland
+ Kaiser Dr | [(-122.067163,37.47821),(-122.060402,37.51961)]
| Oakland
Keeler Ave | [(-122.2578,37.906),(-122.2579,37.899)]
| Berkeley
+ Kildare Road | [(-122.0968,37.016),(-122.0959,37)]
| Oakland
+ La Playa Dr | [(-122.1039,37.545),(-122.101,37.493)]
| Oakland
Laguna Ave | [(-122.2099,37.989),(-122.2089,37)]
| Berkeley
+ Laguna Ave | [(-122.2099,37.989),(-122.2089,37)]
| Lafayette
Lakehurst Cir | [(-122.284729,37.89025),(-122.286096,37.90364)]
| Berkeley
Lakeshore Ave | [(-122.2586,37.99),(-122.2556,37.006)]
| Berkeley
+ Lakeshore Ave | [(-122.2586,37.99),(-122.2556,37.006)]
| Lafayette
+ Las Positas Road | [(-121.764488,37.99199),(-121.75569,37.02022)]
| Oakland
+ Las Positas Road | [(-121.764488,37.99199),(-121.75569,37.02022)]
| Oakland
Linden St | [(-122.2867,37.998),(-122.2864,37.008)]
| Berkeley
+ Linden St | [(-122.2867,37.998),(-122.2864,37.008)]
| Lafayette
+ Livermore Ave | [(-121.7687,37.448),(-121.769,37.375)]
| Oakland
+ Livermore Ave | [(-121.7687,37.448),(-121.769,37.375)]
| Oakland
+ Livermore Ave | [(-121.772719,37.99085),(-121.7728,37.001)]
| Oakland
+ Livermore Ave | [(-121.772719,37.99085),(-121.7728,37.001)]
| Oakland
+ Locust St | [(-122.1606,37.007),(-122.1593,37.987)]
| Oakland
Locust St | [(-122.1606,37.007),(-122.1593,37.987)]
| Berkeley
+ Logan Ct | [(-122.0053,37.492),(-122.0061,37.484)]
| Oakland
+ Magnolia St | [(-122.0971,37.5),(-122.0962,37.484)]
| Oakland
+ Mandalay Road | [(-122.2322,37.397),(-122.2321,37.403)]
| Lafayette
Marin Ave | [(-122.2741,37.894),(-122.272,37.901)]
| Berkeley
Martin Luther King Jr Way | [(-122.2712,37.608),(-122.2711,37.599)]
| Berkeley
+ Mattos Dr | [(-122.0005,37.502),(-122.000898,37.49683)]
| Oakland
+ Maubert Ave | [(-122.1114,37.009),(-122.1096,37.995)]
| Oakland
Maubert Ave | [(-122.1114,37.009),(-122.1096,37.995)]
| Berkeley
+ McClure Ave | [(-122.1431,37.001),(-122.1436,37.998)]
| Oakland
McClure Ave | [(-122.1431,37.001),(-122.1436,37.998)]
| Berkeley
+ Medlar Dr | [(-122.0627,37.378),(-122.0625,37.375)]
| Oakland
+ Mildred Ct | [(-122.0002,37.388),(-121.9998,37.386)]
| Oakland
Miller Road | [(-122.0902,37.645),(-122.0865,37.545)]
| Berkeley
+ Miramar Ave | [(-122.1009,37.025),(-122.099089,37.03209)]
| Oakland
+ Mission Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
| Oakland
+ Mission Blvd | [(-121.918886,37),(-121.9194,37.976),(-121.9198,37.975)]
| Oakland
+ Mission Blvd | [(-122.0006,37.896),(-121.9989,37.88)]
| Oakland
Mission Blvd | [(-122.0006,37.896),(-121.9989,37.88)]
| Berkeley
+ Moores Ave | [(-122.0087,37.301),(-122.0094,37.292)]
| Oakland
+ National Ave | [(-122.1192,37.5),(-122.1281,37.489)]
| Oakland
+ Navajo Ct | [(-121.8779,37.901),(-121.8783,37.9)]
| Oakland
+ Newark Blvd | [(-122.0352,37.438),(-122.0341,37.423)]
| Oakland
Oakland Inner Harbor | [(-122.2625,37.913),(-122.260016,37.89484)]
| Berkeley
+ Oakridge Road | [(-121.8316,37.049),(-121.828382,37)]
| Oakland
Oneil Ave | [(-122.076754,37.62476),(-122.0745,37.595)]
| Berkeley
Parkridge Dr | [(-122.1438,37.884),(-122.1428,37.9)]
| Berkeley
Parkside Dr | [(-122.0475,37.603),(-122.0443,37.596)]
| Berkeley
+ Paseo Padre Pkwy | [(-121.9143,37.005),(-121.913522,37)]
| Oakland
+ Paseo Padre Pkwy | [(-122.0021,37.639),(-121.996,37.628)]
| Oakland
Paseo Padre Pkwy | [(-122.0021,37.639),(-121.996,37.628)]
| Berkeley
Pearl St | [(-122.2383,37.594),(-122.2366,37.615)]
| Berkeley
+ Periwinkle Road | [(-122.0451,37.301),(-122.044758,37.29844)]
| Oakland
+ Pimlico Dr | [(-121.8616,37.998),(-121.8618,37.008)]
| Oakland
+ Pimlico Dr | [(-121.8616,37.998),(-121.8618,37.008)]
| Oakland
+ Portsmouth Ave | [(-122.1064,37.315),(-122.1064,37.308)]
| Oakland
+ Proctor Ave | [(-122.2267,37.406),(-122.2251,37.386)]
| Lafayette
+ Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Oakland
+ Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Oakland
Railroad Ave | [(-122.0245,37.013),(-122.0234,37.003),(-122.0223,37.993)]
| Berkeley
+ Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Oakland
+ Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Oakland
Ranspot Dr | [(-122.0972,37.999),(-122.0959,37)]
| Berkeley
Redding St | [(-122.1978,37.901),(-122.1975,37.895)]
| Berkeley
+ Redwood Road | [(-122.1493,37.98),(-122.1437,37.001)]
| Oakland
Redwood Road | [(-122.1493,37.98),(-122.1437,37.001)]
| Berkeley
Roca Dr | [(-122.0335,37.609),(-122.0314,37.599)]
| Berkeley
+ Rosedale Ct | [(-121.9232,37.9),(-121.924,37.897)]
| Oakland
Sacramento St | [(-122.2799,37.606),(-122.2797,37.597)]
| Berkeley
Saddle Brook Dr | [(-122.1478,37.909),(-122.1454,37.904),(-122.1451,37.888)]
| Berkeley
+ Saginaw Ct | [(-121.8803,37.898),(-121.8806,37.901)]
| Oakland
San Andreas Dr | [(-122.0609,37.9),(-122.0614,37.895)]
| Berkeley
+ Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Oakland
+ Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Oakland
Santa Maria Ave | [(-122.0773,37),(-122.0773,37.98)]
| Berkeley
Shattuck Ave | [(-122.2686,37.904),(-122.2686,37.897)]
| Berkeley
+ Sheridan Road | [(-122.2279,37.425),(-122.2253,37.411),(-122.2223,37.377)]
| Lafayette
Shoreline Dr | [(-122.2657,37.603),(-122.2648,37.6)]
| Berkeley
+ Skyline Blvd | [(-122.1738,37.01),(-122.1714,37.996)]
| Oakland
Skyline Blvd | [(-122.1738,37.01),(-122.1714,37.996)]
| Berkeley
+ Skyline Dr | [(-122.0277,37.5),(-122.0284,37.498)]
| Oakland
Skywest Dr | [(-122.1161,37.62),(-122.1123,37.586)]
| Berkeley
Southern Pacific Railroad | [(-122.3002,37.674),(-122.2999,37.661)]
| Berkeley
+ Sp Railroad | [(-121.893564,37.99009),(-121.897,37.016)]
| Oakland
+ Sp Railroad | [(-121.893564,37.99009),(-121.897,37.016)]
| Oakland
+ Sp Railroad | [(-121.9565,37.898),(-121.9562,37.9)]
| Oakland
+ Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Oakland
+ Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Oakland
Sp Railroad | [(-122.0734,37.001),(-122.0734,37.997)]
| Berkeley
Sp Railroad | [(-122.0914,37.601),(-122.087,37.56),(-122.086408,37.5551)]
| Berkeley
+ Sp Railroad | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
| Oakland
Sp Railroad | [(-122.137792,37.003),(-122.1365,37.992),(-122.131257,37.94612)]
| Berkeley
+ Sp Railroad | [(-122.1947,37.497),(-122.193328,37.4848)]
| Oakland
+ Stanton Ave | [(-122.100392,37.0697),(-122.099513,37.06052)]
| Oakland
State Hwy 123 |
[(-122.3004,37.986),(-122.2998,37.969),(-122.2995,37.962),(-122.2992,37.952),(-122.299,37.942),(-122.2987,37.935),(-122.2984,37.924),(-122.2982,37.92),(-122.2976,37.904),(-122.297,37.88),(-122.2966,37.869),(-122.2959,37.848),(-122.2961,37.843)]
| Berkeley
State Hwy 13 |
[(-122.1797,37.943),(-122.179871,37.91849),(-122.18,37.9),(-122.179023,37.86615),(-122.1787,37.862),(-122.1781,37.851),(-122.1777,37.845),(-122.1773,37.839),(-122.177,37.833)]
| Berkeley
+ State Hwy 13 |
[(-122.2049,37.2),(-122.20328,37.17975),(-122.1989,37.125),(-122.198078,37.11641),(-122.1975,37.11)]
| Lafayette
+ State Hwy 13 Ramp | [(-122.2244,37.427),(-122.223,37.414),(-122.2214,37.396),(-122.2213,37.388)]
| Lafayette
State Hwy 238 |
((-122.098,37.908),(-122.0983,37.907),(-122.099,37.905),(-122.101,37.898),(-122.101535,37.89711),(-122.103173,37.89438),(-122.1046,37.892),(-122.106,37.89))
| Berkeley
State Hwy 238 Ramp | [(-122.1288,37.9),(-122.1293,37.895),(-122.1296,37.906)]
| Berkeley
+ State Hwy 24 |
[(-122.2674,37.246),(-122.2673,37.248),(-122.267,37.261),(-122.2668,37.271),(-122.2663,37.298),(-122.2659,37.315),(-122.2655,37.336),(-122.265007,37.35882),(-122.264443,37.37286),(-122.2641,37.381),(-122.2638,37.388),(-122.2631,37.396),(-122.2617,37.405),(-122.2615,37.407),(-122.2605,37.412)]
| Lafayette
+ State Hwy 84 |
[(-121.9565,37.898),(-121.956589,37.89911),(-121.9569,37.903),(-121.956,37.91),(-121.9553,37.919)]
| Oakland
+ State Hwy 84 | [(-122.0671,37.426),(-122.07,37.402),(-122.074,37.37),(-122.0773,37.338)]
| Oakland
+ State Hwy 92 |
[(-122.1085,37.326),(-122.1095,37.322),(-122.1111,37.316),(-122.1119,37.313),(-122.1125,37.311),(-122.1131,37.308),(-122.1167,37.292),(-122.1187,37.285),(-122.12,37.28)]
| Oakland
+ State Hwy 92 Ramp | [(-122.1086,37.321),(-122.1089,37.315),(-122.1111,37.316)]
| Oakland
Stuart St | [(-122.2518,37.6),(-122.2507,37.601),(-122.2491,37.606)]
| Berkeley
+ Sunol Ridge Trl | [(-121.9419,37.455),(-121.9345,37.38)]
| Oakland
+ Sunol Ridge Trl | [(-121.9419,37.455),(-121.9345,37.38)]
| Oakland
+ Tassajara Creek | [(-121.87866,37.98898),(-121.8782,37.015)]
| Oakland
+ Tassajara Creek | [(-121.87866,37.98898),(-121.8782,37.015)]
| Oakland
+ Taurus Ave | [(-122.2159,37.416),(-122.2128,37.389)]
| Lafayette
+ Tennyson Road | [(-122.0891,37.317),(-122.0927,37.317)]
| Oakland
+ Thackeray Ave | [(-122.072,37.305),(-122.0715,37.298)]
| Oakland
+ Theresa Way | [(-121.7289,37.906),(-121.728,37.899)]
| Oakland
+ Tissiack Way | [(-121.920364,37),(-121.9208,37.995)]
| Oakland
+ Tissiack Way | [(-121.920364,37),(-121.9208,37.995)]
| Oakland
Tupelo Ter | [(-122.059087,37.6113),(-122.057021,37.59942)]
| Berkeley
+ Vallecitos Road | [(-121.8699,37.916),(-121.8703,37.891)]
| Oakland
+ Warm Springs Blvd | [(-121.933956,37),(-121.9343,37.97)]
| Oakland
+ Warm Springs Blvd | [(-121.933956,37),(-121.9343,37.97)]
| Oakland
+ Welch Creek Road | [(-121.7695,37.386),(-121.7737,37.413)]
| Oakland
+ Welch Creek Road | [(-121.7695,37.386),(-121.7737,37.413)]
| Oakland
West Loop Road | [(-122.0576,37.604),(-122.0602,37.586)]
| Berkeley
+ Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Oakland
+ Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Oakland
Western Pacific Railroad Spur | [(-122.0394,37.018),(-122.0394,37.961)]
| Berkeley
+ Whitlock Creek | [(-121.74683,37.91276),(-121.733107,37)]
| Oakland
+ Whitlock Creek | [(-121.74683,37.91276),(-121.733107,37)]
| Oakland
+ Willimet Way | [(-122.0964,37.517),(-122.0949,37.493)]
| Oakland
+ Wisconsin St | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
| Oakland
Wisconsin St | [(-122.1994,37.017),(-122.1975,37.998),(-122.1971,37.994)]
| Berkeley
Wp Railroad | [(-122.254,37.902),(-122.2506,37.891)]
| Berkeley
+ 100th Ave | [(-122.1657,37.429),(-122.1647,37.432)]
| Oakland
+ 107th Ave | [(-122.1555,37.403),(-122.1531,37.41)]
| Oakland
+ 14th St | [(-122.299,37.147),(-122.3,37.148)]
| Lafayette
19th Ave | [(-122.2366,37.897),(-122.2359,37.905)]
| Berkeley
+ 1st St | [(-121.75508,37.89294),(-121.753581,37.90031)]
| Oakland
+ 5th St | [(-122.278,37),(-122.2792,37.005),(-122.2803,37.009)]
| Lafayette
5th St | [(-122.296,37.615),(-122.2953,37.598)]
| Berkeley
82nd Ave | [(-122.1695,37.596),(-122.1681,37.603)]
| Berkeley
! 85th Ave | [(-122.1877,37.466),(-122.186,37.476)]
| Oakland
! 89th Ave | [(-122.1822,37.459),(-122.1803,37.471)]
| Oakland
! 98th Ave | [(-122.1568,37.498),(-122.1558,37.502)]
| Oakland
! 98th Ave | [(-122.1693,37.438),(-122.1682,37.444)]
| Oakland
98th Ave | [(-122.2001,37.258),(-122.1974,37.27)]
| Lafayette
(333 rows)
======================================================================
*** ./expected/alter_table.out Sat Nov 3 22:08:11 2001
--- ./results/alter_table.out Sat Dec 1 21:26:15 2001
***************
*** 98,128 ****
-- it might not. Therefore, vacuum first.
--
VACUUM ANALYZE tenk1;
ALTER TABLE tenk1 RENAME TO ten_k;
-- 20 values, sorted
SELECT unique1 FROM ten_k WHERE unique1 < 20;
unique1
---------
! 0
! 1
! 2
! 3
4
! 5
6
! 7
! 8
9
! 10
! 11
! 12
13
! 14
! 15
! 16
! 17
! 18
19
(20 rows)
-- 20 values, sorted
--- 98,129 ----
-- it might not. Therefore, vacuum first.
--
VACUUM ANALYZE tenk1;
+ ERROR: PGSTAT: Creation of DB hash table failed
ALTER TABLE tenk1 RENAME TO ten_k;
-- 20 values, sorted
SELECT unique1 FROM ten_k WHERE unique1 < 20;
unique1
---------
! 18
! 15
4
! 2
! 1
6
! 14
9
! 8
! 5
! 3
13
! 12
19
+ 17
+ 11
+ 7
+ 10
+ 16
+ 0
(20 rows)
-- 20 values, sorted
***************
*** 262,272 ****
SELECT unique1 FROM tenk1 WHERE unique1 < 5;
unique1
---------
! 0
! 1
2
3
! 4
(5 rows)
-- FOREIGN KEY CONSTRAINT adding TEST
--- 263,273 ----
SELECT unique1 FROM tenk1 WHERE unique1 < 5;
unique1
---------
! 4
2
+ 1
3
! 0
(5 rows)
-- FOREIGN KEY CONSTRAINT adding TEST
======================================================================
В списке pgsql-hackers по дате отправления: