Master Address Table

62,226 Berkeley addresses with APNs and coordinates

Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS

59 rows where street_name = "WILDCAT CANYON" and zipcode = 94708

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94708 · 59 ✖

street_type 1

street_name 1

  • WILDCAT CANYON · 59 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1980 1980 1980 063 313009500 800 Wildcat Canyon Rd 800 WILDCAT CANYON RD 800 WILDCAT CANYON RD 800.0 WILDCAT CANYON RD     Berkeley 94708 37.89819493221879 -122.2568541269536
3566 3566 3566 063 312000600 710 Wildcat Canyon Rd 710 WILDCAT CANYON RD 710 WILDCAT CANYON RD 710.0 WILDCAT CANYON RD     Berkeley 94708 37.89962378762548 -122.26008919295536
4447 4447 4447 063 313009400 798 Wildcat Canyon Rd 798 WILDCAT CANYON RD 798 WILDCAT CANYON RD 798.0 WILDCAT CANYON RD     Berkeley 94708 37.898445177684565 -122.25675720771756
5206 5206 5206 063 313001600 994 Wildcat Canyon Rd 994 WILDCAT CANYON RD 994 WILDCAT CANYON RD 994.0 WILDCAT CANYON RD     Berkeley 94708 37.8960621077265 -122.25631001648767
5306 5306 5306 063 310005500 544 Wildcat Canyon Rd 544 WILDCAT CANYON RD 544 WILDCAT CANYON RD 544.0 WILDCAT CANYON RD     Berkeley 94708 37.9039796591307 -122.26769197386972
6468 6468 6468 063 310005802 552 Wildcat Canyon Rd 552 WILDCAT CANYON RD 552 WILDCAT CANYON RD 552.0 WILDCAT CANYON RD     Berkeley 94708 37.90412379934182 -122.26720534570052
6584 6584 6584 063 311008900 664 Wildcat Canyon Rd 664 WILDCAT CANYON RD 664 WILDCAT CANYON RD 664.0 WILDCAT CANYON RD     Berkeley 94708 37.90001838701303 -122.26144303044532
6825 6825 6825 063 310005600 548 Wildcat Canyon Rd 548 WILDCAT CANYON RD 548 WILDCAT CANYON RD 548.0 WILDCAT CANYON RD     Berkeley 94708 37.904078467603306 -122.26752106309873
7613 7613 7613 063 312002200 782 Wildcat Canyon Rd A 782 WILDCAT CANYON RD A 782 WILDCAT CANYON RD 782.0 WILDCAT CANYON RD A   Berkeley 94708 37.89890688380832 -122.2566589014828
7702 7702 7702 063 311009100 660 Wildcat Canyon Rd 660 WILDCAT CANYON RD 660 WILDCAT CANYON RD 660.0 WILDCAT CANYON RD     Berkeley 94708 37.90037744930225 -122.2614750239442
8799 8799 8799 063 313000300 794 Wildcat Canyon Rd 794 WILDCAT CANYON RD 794 WILDCAT CANYON RD 794.0 WILDCAT CANYON RD     Berkeley 94708 37.89827403143872 -122.25639375115024
9191 9191 9191 063 312001800 756 Wildcat Canyon Rd 756 WILDCAT CANYON RD 756 WILDCAT CANYON RD 756.0 WILDCAT CANYON RD     Berkeley 94708 37.89915867782696 -122.25763400116412
10259 10259 10259 063 311007000 652 Wildcat Canyon Rd 652 WILDCAT CANYON RD 652 WILDCAT CANYON RD 652.0 WILDCAT CANYON RD     Berkeley 94708 37.90083524965641 -122.26166863604074
10882 10882 10882 063 311010700 634 Wildcat Canyon Rd 634 WILDCAT CANYON RD 634 WILDCAT CANYON RD 634.0 WILDCAT CANYON RD     Berkeley 94708 37.90162977011122 -122.2626641894628
11308 11308 11308 063 313005204 1008 Wildcat Canyon Rd 1008 WILDCAT CANYON RD 1008 WILDCAT CANYON RD 1008.0 WILDCAT CANYON RD     Berkeley 94708 37.89591069415505 -122.25510511068867
13039 13039 13039 063 313000200 792 Wildcat Canyon Rd 792 WILDCAT CANYON RD 792 WILDCAT CANYON RD 792.0 WILDCAT CANYON RD     Berkeley 94708 37.898490250614536 -122.25637122948775
13132 13132 13132 063 312001600 746 Wildcat Canyon Rd B 746 WILDCAT CANYON RD B 746 WILDCAT CANYON RD 746.0 WILDCAT CANYON RD B   Berkeley 94708 37.898931037391726 -122.25814147473947
14497 14497 14497 063 311006405 610 Wildcat Canyon Rd 610 WILDCAT CANYON RD 610 WILDCAT CANYON RD 610.0 WILDCAT CANYON RD     Berkeley 94708 37.90280944898949 -122.26343792279005
15028 15028 15028 063 313001500 990 Wildcat Canyon Rd 990 WILDCAT CANYON RD 990 WILDCAT CANYON RD 990.0 WILDCAT CANYON RD     Berkeley 94708 37.896252484717174 -122.25641976815751
15035 15035 15035 063 312001900 760 Wildcat Canyon Rd 760 WILDCAT CANYON RD 760 WILDCAT CANYON RD 760.0 WILDCAT CANYON RD     Berkeley 94708 37.89927937365728 -122.25738514806748
16455 16455 16455 063 311009000 662 Wildcat Canyon Rd 662 WILDCAT CANYON RD 662 WILDCAT CANYON RD 662.0 WILDCAT CANYON RD     Berkeley 94708 37.90023212436344 -122.2614784977294
17509 17509 17509 063 315001002 1140 Wildcat Canyon Rd 1140 WILDCAT CANYON RD 1140 WILDCAT CANYON RD 1140.0 WILDCAT CANYON RD     Berkeley 94708 37.89355781182576 -122.25095462547978
17898 17898 17898 063 313009103 900 Wildcat Canyon Rd 900 WILDCAT CANYON RD 900 WILDCAT CANYON RD 900.0 WILDCAT CANYON RD     Berkeley 94708 37.89787460736736 -122.25705670333836
17924 17924 17924 063 313001400 986 Wildcat Canyon Rd 986 WILDCAT CANYON RD 986 WILDCAT CANYON RD 986.0 WILDCAT CANYON RD     Berkeley 94708 37.896464555083746 -122.25651220659688
19261 19261 19261 063 310006304 574 Wildcat Canyon Rd 574 WILDCAT CANYON RD 574 WILDCAT CANYON RD 574.0 WILDCAT CANYON RD     Berkeley 94708 37.904084379053586 -122.2654057192508
19279 19279 19279 063 312002100 780 Wildcat Canyon Rd 780 WILDCAT CANYON RD 780 WILDCAT CANYON RD 780.0 WILDCAT CANYON RD     Berkeley 94708 37.899187991077014 -122.25678050911776
20163 20163 20163 063 313000600 970 Wildcat Canyon Rd 970 WILDCAT CANYON RD 970 WILDCAT CANYON RD 970.0 WILDCAT CANYON RD     Berkeley 94708 37.89750291568589 -122.25671076571572
20277 20277 20277 063 311006700 636 Wildcat Canyon Rd 636 WILDCAT CANYON RD 636 WILDCAT CANYON RD 636.0 WILDCAT CANYON RD     Berkeley 94708 37.901185516282 -122.26257481877008
22930 22930 22930 063 310006702 580 Wildcat Canyon Rd 580 WILDCAT CANYON RD 580 WILDCAT CANYON RD 580.0 WILDCAT CANYON RD     Berkeley 94708 37.90345337371509 -122.26463078038444
25223 25223 25223 063 310005400 540 Wildcat Canyon Rd 540 WILDCAT CANYON RD 540 WILDCAT CANYON RD 540.0 WILDCAT CANYON RD     Berkeley 94708 37.90387591792402 -122.26787413154808
25759 25759 25759 063 311009200 658 Wildcat Canyon Rd 658 WILDCAT CANYON RD 658 WILDCAT CANYON RD 658.0 WILDCAT CANYON RD     Berkeley 94708 37.90059050724943 -122.26151424079622
26047 26047 26047 063 311006602 632 Wildcat Canyon Rd 632 WILDCAT CANYON RD 632 WILDCAT CANYON RD 632.0 WILDCAT CANYON RD     Berkeley 94708 37.901760554201985 -122.26307138230636
26969 26969 26969 063 313000100 790 Wildcat Canyon Rd 790 WILDCAT CANYON RD 790 WILDCAT CANYON RD 790.0 WILDCAT CANYON RD     Berkeley 94708 37.89866526247553 -122.25652916589114
27194 27194 27194 063 312001500 740 Wildcat Canyon Rd 740 WILDCAT CANYON RD 740 WILDCAT CANYON RD 740.0 WILDCAT CANYON RD     Berkeley 94708 37.89882978991774 -122.25850923693196
28890 28890 28890 063 312000800 720 Wildcat Canyon Rd 720 WILDCAT CANYON RD 720 WILDCAT CANYON RD 720.0 WILDCAT CANYON RD     Berkeley 94708 37.8996234246943 -122.25963635761052
30849 30849 30849 063 313000500 962 Wildcat Canyon Rd 962 WILDCAT CANYON RD 962 WILDCAT CANYON RD 962.0 WILDCAT CANYON RD     Berkeley 94708 37.89775062504832 -122.2566852329004
31407 31407 31407 063 312001400 738 Wildcat Canyon Rd 738 WILDCAT CANYON RD 738 WILDCAT CANYON RD 738.0 WILDCAT CANYON RD     Berkeley 94708 37.89884318732449 -122.25883204922428
33552 33552 33552 063 312000401 700 Wildcat Canyon Rd 700 WILDCAT CANYON RD 700 WILDCAT CANYON RD 700.0 WILDCAT CANYON RD     Berkeley 94708 37.89941615030601 -122.26075188014046
33916 33916 33916 063 312001300 734 Wildcat Canyon Rd 734 WILDCAT CANYON RD 734 WILDCAT CANYON RD 734.0 WILDCAT CANYON RD     Berkeley 94708 37.898938897193176 -122.25897989575036
34280 34280 34280 063 314000300 1016 Wildcat Canyon Rd 1016 WILDCAT CANYON RD 1016 WILDCAT CANYON RD 1016.0 WILDCAT CANYON RD     Berkeley 94708 37.89590516909989 -122.25436947670924
34642 34642 34642 063 312001200 730 Wildcat Canyon Rd 730 WILDCAT CANYON RD 730 WILDCAT CANYON RD 730.0 WILDCAT CANYON RD     Berkeley 94708 37.899092916666376 -122.25909214294003
38235 38235 38235 063 312001600 746 Wildcat Canyon Rd 746 WILDCAT CANYON RD 746 WILDCAT CANYON RD 746.0 WILDCAT CANYON RD     Berkeley 94708 37.898931037391726 -122.25814147473947
38688 38688 38688 063 312000405 704 Wildcat Canyon Rd 704 WILDCAT CANYON RD 704 WILDCAT CANYON RD 704.0 WILDCAT CANYON RD     Berkeley 94708 37.89948074369972 -122.26053720614377
39638 39638 39638 063 312001700 750 Wildcat Canyon Rd 750 WILDCAT CANYON RD 750 WILDCAT CANYON RD 750.0 WILDCAT CANYON RD     Berkeley 94708 37.89905769010719 -122.25783999024868
40494 40494 40494 063 312002200 782 Wildcat Canyon Rd 782 WILDCAT CANYON RD 782 WILDCAT CANYON RD 782.0 WILDCAT CANYON RD     Berkeley 94708 37.89890688380832 -122.2566589014828
40643 40643 40643 063 314000101 1012 Wildcat Canyon Rd 1012 WILDCAT CANYON RD 1012 WILDCAT CANYON RD 1012.0 WILDCAT CANYON RD     Berkeley 94708 37.89611236263824 -122.25489152724673
42699 42699 42699 063 311009300 648 Wildcat Canyon Rd 648 WILDCAT CANYON RD 648 WILDCAT CANYON RD 648.0 WILDCAT CANYON RD     Berkeley 94708 37.90117676146192 -122.26172044457807
48887 48887 48887 063 312002200 782 Wildcat Canyon Rd B 782 WILDCAT CANYON RD B 782 WILDCAT CANYON RD 782.0 WILDCAT CANYON RD B   Berkeley 94708 37.89890688380832 -122.2566589014828
49064 49064 49064 063 310005900 556 Wildcat Canyon Rd 556 WILDCAT CANYON RD 556 WILDCAT CANYON RD 556.0 WILDCAT CANYON RD     Berkeley 94708 37.90422745797758 -122.26692662631564
49104 49104 49104 063 312000900 722 Wildcat Canyon Rd 722 WILDCAT CANYON RD 722 WILDCAT CANYON RD 722.0 WILDCAT CANYON RD     Berkeley 94708 37.89949466695557 -122.2594832532451
49672 49672 49672 063 314000203 1010 Wildcat Canyon Rd 1010 WILDCAT CANYON RD 1010 WILDCAT CANYON RD 1010.0 WILDCAT CANYON RD     Berkeley 94708 37.89576707873906 -122.25488744260711
49981 49981 49981 063 312000501 706 Wildcat Canyon Rd 706 WILDCAT CANYON RD 706 WILDCAT CANYON RD 706.0 WILDCAT CANYON RD     Berkeley 94708 37.899548113604816 -122.26028479931183
50519 50519 50519 063 312001001 724 Wildcat Canyon Rd 724 WILDCAT CANYON RD 724 WILDCAT CANYON RD 724.0 WILDCAT CANYON RD     Berkeley 94708 37.89927626888004 -122.25928770438075
50844 50844 50844 063 313001200 980 Wildcat Canyon Rd 980 WILDCAT CANYON RD 980 WILDCAT CANYON RD 980.0 WILDCAT CANYON RD     Berkeley 94708 37.89689585079834 -122.25663903434194
52962 52962 52962 063 312002000 770 Wildcat Canyon Rd 770 WILDCAT CANYON RD 770 WILDCAT CANYON RD 770.0 WILDCAT CANYON RD     Berkeley 94708 37.89940841531348 -122.25699302356448
55731 55731 55731 063 311008800 670 Wildcat Canyon Rd 670 WILDCAT CANYON RD 670 WILDCAT CANYON RD 670.0 WILDCAT CANYON RD     Berkeley 94708 37.89971260008687 -122.26133390579956
56304 56304 56304 063 312001600 746 Wildcat Canyon Rd A 746 WILDCAT CANYON RD A 746 WILDCAT CANYON RD 746.0 WILDCAT CANYON RD A   Berkeley 94708 37.898931037391726 -122.25814147473947
56995 56995 56995 063 312000700 716 Wildcat Canyon Rd 716 WILDCAT CANYON RD 716 WILDCAT CANYON RD 716.0 WILDCAT CANYON RD     Berkeley 94708 37.899662069055296 -122.25982532901034
58283 58283 58283 063 313005300 1006 Wildcat Canyon Rd 1006 WILDCAT CANYON RD 1006 WILDCAT CANYON RD 1006.0 WILDCAT CANYON RD     Berkeley 94708 37.895772581829085 -122.25535492677928

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "addresses" (
"address_id" INTEGER,
  "apn" TEXT,
  "address_full" TEXT,
  "address_normalized" TEXT,
  "base_address" TEXT,
  "street_number" REAL,
  "street_name" TEXT,
  "street_type" TEXT,
  "unit" TEXT,
  "unit_type" TEXT,
  "city" TEXT,
  "zipcode" INTEGER,
  "latitude" REAL,
  "longitude" REAL
);
CREATE INDEX idx_addresses_apn ON addresses(apn);
CREATE INDEX idx_addresses_base ON addresses(base_address);
CREATE INDEX idx_addresses_street ON addresses(street_name);
CREATE INDEX idx_addresses_zipcode ON addresses(zipcode);
CREATE INDEX idx_addresses_coords ON addresses(latitude, longitude);