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

195 rows where street_name = "THE ALAMEDA" and zipcode = 94707

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94707 · 195 ✖

street_name 1

  • THE ALAMEDA · 195 ✖

street_type 0

Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
239 239 239 061 260300400 908 The Alameda 908 THE ALAMEDA 908 THE ALAMEDA 908.0 THE ALAMEDA       Berkeley 94707 37.891225835811646 -122.27738852020052
323 323 323 061 260500500 1110 The Alameda A 1110 THE ALAMEDA A 1110 THE ALAMEDA 1110.0 THE ALAMEDA   A   Berkeley 94707 37.88747538085358 -122.27660341959168
378 378 378 061 257402400 961 The Alameda 961 THE ALAMEDA 961 THE ALAMEDA 961.0 THE ALAMEDA       Berkeley 94707 37.889527960310815 -122.27624530710196
475 475 475 061 260500700 1116 The Alameda 1116 THE ALAMEDA 1116 THE ALAMEDA 1116.0 THE ALAMEDA       Berkeley 94707 37.88717292006334 -122.2765563245146
631 631 631 062 288500200 726 The Alameda 726 THE ALAMEDA 726 THE ALAMEDA 726.0 THE ALAMEDA       Berkeley 94707 37.89493325482819 -122.27804374597888
738 738 738 061 260501300 1140 The Alameda 1140 THE ALAMEDA 1140 THE ALAMEDA 1140.0 THE ALAMEDA       Berkeley 94707 37.88636801585232 -122.27624852127408
1021 1021 1021 062 288500100 720 The Alameda 720 THE ALAMEDA 720 THE ALAMEDA 720.0 THE ALAMEDA       Berkeley 94707 37.895044765359096 -122.27813931414872
1548 1548 1548 061 260300400 904 The Alameda 904 THE ALAMEDA 904 THE ALAMEDA 904.0 THE ALAMEDA       Berkeley 94707 37.891225835811646 -122.27738852020052
1664 1664 1664 061 257506500 751 The Alameda 751 THE ALAMEDA 751 THE ALAMEDA 751.0 THE ALAMEDA       Berkeley 94707 37.89435883064264 -122.27682188268228
2256 2256 2256 061 257506900 735 The Alameda 735 THE ALAMEDA 735 THE ALAMEDA 735.0 THE ALAMEDA       Berkeley 94707 37.89487986437515 -122.27734666679312
2687 2687 2687 061 257402700 949 The Alameda 949 THE ALAMEDA 949 THE ALAMEDA 949.0 THE ALAMEDA       Berkeley 94707 37.8899406521719 -122.2763762051136
2927 2927 2927 062 292304004 500 The Alameda 500 THE ALAMEDA 500 THE ALAMEDA 500.0 THE ALAMEDA       Berkeley 94707 37.90042491764439 -122.27986848573067
3587 3587 3587 061 260300500 912 The Alameda 912 THE ALAMEDA 912 THE ALAMEDA 912.0 THE ALAMEDA       Berkeley 94707 37.89101638120276 -122.2773736530826
3792 3792 3792 061 260300400 908 The Alameda 7 908 THE ALAMEDA 7 908 THE ALAMEDA 908.0 THE ALAMEDA   7   Berkeley 94707 37.891225835811646 -122.27738852020052
4438 4438 4438 062 289501000 584 The Alameda 584 THE ALAMEDA 584 THE ALAMEDA 584.0 THE ALAMEDA       Berkeley 94707 37.89796059356441 -122.28177789439296
4439 4439 4439 061 257504700 877 The Alameda 877 THE ALAMEDA 877 THE ALAMEDA 877.0 THE ALAMEDA       Berkeley 94707 37.89180829175399 -122.2768303124729
4498 4498 4498 062 289300300 606 The Alameda 606 THE ALAMEDA 606 THE ALAMEDA 606.0 THE ALAMEDA       Berkeley 94707 37.897048605660984 -122.281807953819
4667 4667 4667 062 290001300 641 The Alameda 641 THE ALAMEDA 641 THE ALAMEDA 641.0 THE ALAMEDA       Berkeley 94707 37.89622878323079 -122.28075415453225
4744 4744 4744 062 289500800 576 The Alameda 576 THE ALAMEDA 576 THE ALAMEDA 576.0 THE ALAMEDA       Berkeley 94707 37.89825791331195 -122.28178889426364
4945 4945 4945 061 257301300 1111 The Alameda 1111 THE ALAMEDA 1111 THE ALAMEDA 1111.0 THE ALAMEDA       Berkeley 94707 37.88753612440381 -122.2759064284408
4972 4972 4972 062 289300400 612 The Alameda 612 THE ALAMEDA 612 THE ALAMEDA 612.0 THE ALAMEDA       Berkeley 94707 37.89690100432804 -122.28190540036609
5121 5121 5121 062 288500400 734 The Alameda 734 THE ALAMEDA 734 THE ALAMEDA 734.0 THE ALAMEDA       Berkeley 94707 37.894687158650925 -122.27787491570608
5387 5387 5387 061 257505200 851 The Alameda 851 THE ALAMEDA 851 THE ALAMEDA 851.0 THE ALAMEDA       Berkeley 94707 37.89247772959532 -122.2770022706795
5647 5647 5647 062 290000500 691 The Alameda 691 THE ALAMEDA 691 THE ALAMEDA 691.0 THE ALAMEDA       Berkeley 94707 37.89582190404382 -122.2795062544654
5806 5806 5806 061 257504900 863 The Alameda 863 THE ALAMEDA 863 THE ALAMEDA 863.0 THE ALAMEDA       Berkeley 94707 37.89207368592456 -122.27692067131235
5911 5911 5911 062 288800400 820 The Alameda 820 THE ALAMEDA 820 THE ALAMEDA 820.0 THE ALAMEDA       Berkeley 94707 37.893416215047665 -122.2774881460605
5991 5991 5991 062 289301300 650 The Alameda 650 THE ALAMEDA 650 THE ALAMEDA 650.0 THE ALAMEDA       Berkeley 94707 37.89582147162306 -122.28108966361276
7681 7681 7681 062 290700600 558 The Alameda 558 THE ALAMEDA 558 THE ALAMEDA 558.0 THE ALAMEDA       Berkeley 94707 37.899062567031976 -122.2815791205768
7807 7807 7807 062 289602300 573 The Alameda 573 THE ALAMEDA 573 THE ALAMEDA 573.0 THE ALAMEDA       Berkeley 94707 37.898379068544145 -122.28127962944755
7992 7992 7992 061 260500500 1110 The Alameda 1110 THE ALAMEDA 1110 THE ALAMEDA 1110.0 THE ALAMEDA       Berkeley 94707 37.88747538085358 -122.27660341959168
8114 8114 8114 061 260300400 908 The Alameda 1 908 THE ALAMEDA 1 908 THE ALAMEDA 908.0 THE ALAMEDA   1   Berkeley 94707 37.891225835811646 -122.27738852020052
8175 8175 8175 062 290300700 534 The Alameda 534 THE ALAMEDA 534 THE ALAMEDA 534.0 THE ALAMEDA       Berkeley 94707 37.899881973704495 -122.28130313746026
8715 8715 8715 061 260203301 898 The Alameda 898 THE ALAMEDA 898 THE ALAMEDA 898.0 THE ALAMEDA       Berkeley 94707 37.891698743590936 -122.27742902164344
8736 8736 8736 062 289301100 640 The Alameda 640 THE ALAMEDA 640 THE ALAMEDA 640.0 THE ALAMEDA       Berkeley 94707 37.89607640379315 -122.28121762143846
8788 8788 8788 061 257506200 815 The Alameda 815 THE ALAMEDA 815 THE ALAMEDA 815.0 THE ALAMEDA       Berkeley 94707 37.89392603065429 -122.27667565671696
8976 8976 8976 061 257506101 817 The Alameda 817 THE ALAMEDA 817 THE ALAMEDA 817.0 THE ALAMEDA       Berkeley 94707 37.89375644625537 -122.27666006286194
9701 9701 9701 062 288900200 704 The Alameda 704 THE ALAMEDA 704 THE ALAMEDA 704.0 THE ALAMEDA       Berkeley 94707 37.89524975737395 -122.27899068617104
10163 10163 10163 062 288900300 706 The Alameda 706 THE ALAMEDA 706 THE ALAMEDA 706.0 THE ALAMEDA       Berkeley 94707 37.89523022668675 -122.2788177991064
10262 10262 10262 061 260300400 908 The Alameda 2 908 THE ALAMEDA 2 908 THE ALAMEDA 908.0 THE ALAMEDA   2   Berkeley 94707 37.891225835811646 -122.27738852020052
10318 10318 10318 061 260202700 842 The Alameda 842 THE ALAMEDA 842 THE ALAMEDA 842.0 THE ALAMEDA       Berkeley 94707 37.89252976208535 -122.2776690137581
10779 10779 10779 061 260203100 856 The Alameda 856 THE ALAMEDA 856 THE ALAMEDA 856.0 THE ALAMEDA       Berkeley 94707 37.89197522075948 -122.27762024601796
11640 11640 11640 062 289301000 638 The Alameda 638 THE ALAMEDA 638 THE ALAMEDA 638.0 THE ALAMEDA       Berkeley 94707 37.896157830426965 -122.28130801800718
11976 11976 11976 061 256901500 1161 The Alameda 1161 THE ALAMEDA 1161 THE ALAMEDA 1161.0 THE ALAMEDA       Berkeley 94707 37.885768492766175 -122.27497529410611
12101 12101 12101 061 260501000 1128 The Alameda 1128 THE ALAMEDA 1128 THE ALAMEDA 1128.0 THE ALAMEDA       Berkeley 94707 37.886770464449285 -122.27642624396988
12178 12178 12178 061 256901600 1153 The Alameda 1153 THE ALAMEDA 1153 THE ALAMEDA 1153.0 THE ALAMEDA       Berkeley 94707 37.88603534581192 -122.27505611104068
12353 12353 12353 061 260301400 948 The Alameda 948 THE ALAMEDA 948 THE ALAMEDA 948.0 THE ALAMEDA       Berkeley 94707 37.88979339531287 -122.27711905885296
12387 12387 12387 061 257504500 901 The Alameda 901 THE ALAMEDA 901 THE ALAMEDA 901.0 THE ALAMEDA       Berkeley 94707 37.8915396773858 -122.27667696196906
12496 12496 12496 061 257301700 1101 The Alameda 1101 THE ALAMEDA 1101 THE ALAMEDA 1101.0 THE ALAMEDA       Berkeley 94707 37.88805540707926 -122.27584797326864
12796 12796 12796 061 257505100 855 The Alameda 855 THE ALAMEDA 855 THE ALAMEDA 855.0 THE ALAMEDA       Berkeley 94707 37.892347909446286 -122.2769746636542
12852 12852 12852 061 257002400 1139 The Alameda 1139 THE ALAMEDA 1139 THE ALAMEDA 1139.0 THE ALAMEDA       Berkeley 94707 37.886627867723966 -122.27552436237409
12952 12952 12952 061 257301600 1103 The Alameda 1103 THE ALAMEDA 1103 THE ALAMEDA 1103.0 THE ALAMEDA       Berkeley 94707 37.887927895313034 -122.27588929038184
13016 13016 13016 061 257002500 1135 The Alameda 1135 THE ALAMEDA 1135 THE ALAMEDA 1135.0 THE ALAMEDA       Berkeley 94707 37.886788305061074 -122.27558348679112
13361 13361 13361 061 260203000 854 The Alameda 854 THE ALAMEDA 854 THE ALAMEDA 854.0 THE ALAMEDA       Berkeley 94707 37.892115070689094 -122.27763655762688
13418 13418 13418 062 289602200 575 The Alameda 575 THE ALAMEDA 575 THE ALAMEDA 575.0 THE ALAMEDA       Berkeley 94707 37.898257371740584 -122.28129843927128
13998 13998 13998 061 260501100 1132 The Alameda 1132 THE ALAMEDA 1132 THE ALAMEDA 1132.0 THE ALAMEDA       Berkeley 94707 37.886636467590975 -122.27635199551668
14455 14455 14455 062 289501200 592 The Alameda 592 THE ALAMEDA 592 THE ALAMEDA 592.0 THE ALAMEDA       Berkeley 94707 37.89769469463637 -122.2817260409398
14817 14817 14817 062 289602100 579 The Alameda 579 THE ALAMEDA 579 THE ALAMEDA 579.0 THE ALAMEDA       Berkeley 94707 37.8981328180128 -122.28130563477671
16491 16491 16491 062 289300900 632 The Alameda 632 THE ALAMEDA 632 THE ALAMEDA 632.0 THE ALAMEDA       Berkeley 94707 37.89626748041357 -122.28140695755428
16576 16576 16576 062 289500700 572 The Alameda 572 THE ALAMEDA 572 THE ALAMEDA 572.0 THE ALAMEDA       Berkeley 94707 37.89838919818004 -122.28177562435025
16734 16734 16734 061 257402200 993 The Alameda 993 THE ALAMEDA 993 THE ALAMEDA 993.0 THE ALAMEDA       Berkeley 94707 37.8892592986306 -122.27621299559956
17199 17199 17199 061 257500100 723 The Alameda 723 THE ALAMEDA 723 THE ALAMEDA 723.0 THE ALAMEDA       Berkeley 94707 37.89530870810361 -122.27762134016598
17615 17615 17615 062 290300300 524 The Alameda 524 THE ALAMEDA 524 THE ALAMEDA 524.0 THE ALAMEDA       Berkeley 94707 37.90019035217123 -122.28097254935084
18023 18023 18023 062 290700300 544 The Alameda 544 THE ALAMEDA 544 THE ALAMEDA 544.0 THE ALAMEDA       Berkeley 94707 37.899445946890275 -122.28161723429766
18106 18106 18106 061 257301400 1109 The Alameda 1109 THE ALAMEDA 1109 THE ALAMEDA 1109.0 THE ALAMEDA       Berkeley 94707 37.88766610546484 -122.27593793684942
18598 18598 18598 061 260203301 896 The Alameda 896 THE ALAMEDA 896 THE ALAMEDA 896.0 THE ALAMEDA       Berkeley 94707 37.891698743590936 -122.27742902164344
18836 18836 18836 061 257402300 965 The Alameda 965 THE ALAMEDA 965 THE ALAMEDA 965.0 THE ALAMEDA       Berkeley 94707 37.88938188231676 -122.27628520757196
19374 19374 19374 061 260202800 846 The Alameda 846 THE ALAMEDA 846 THE ALAMEDA 846.0 THE ALAMEDA       Berkeley 94707 37.89239448689248 -122.277650191358
19544 19544 19544 062 288700400 750 The Alameda 750 THE ALAMEDA 750 THE ALAMEDA 750.0 THE ALAMEDA       Berkeley 94707 37.89411299909258 -122.27742076971924
19582 19582 19582 061 260301800 964 The Alameda 964 THE ALAMEDA 964 THE ALAMEDA 964.0 THE ALAMEDA       Berkeley 94707 37.88917407431677 -122.27687820345731
20282 20282 20282 061 260301300 942 The Alameda 942 THE ALAMEDA 942 THE ALAMEDA 942.0 THE ALAMEDA       Berkeley 94707 37.88993004425453 -122.27714573522364
20663 20663 20663 061 260300400 908 The Alameda 5 908 THE ALAMEDA 5 908 THE ALAMEDA 908.0 THE ALAMEDA   5   Berkeley 94707 37.891225835811646 -122.27738852020052
20736 20736 20736 061 260503500 1170 The Alameda 1170 THE ALAMEDA 1170 THE ALAMEDA 1170.0 THE ALAMEDA       Berkeley 94707 37.88544206193452 -122.27535266198392
20753 20753 20753 061 257504300 919 The Alameda 919 THE ALAMEDA 919 THE ALAMEDA 919.0 THE ALAMEDA       Berkeley 94707 37.891032496661566 -122.27654649964032
21287 21287 21287 061 260301100 934 The Alameda 934 THE ALAMEDA 934 THE ALAMEDA 934.0 THE ALAMEDA       Berkeley 94707 37.89020382345664 -122.2772008271034
21433 21433 21433 061 260400600 1012 The Alameda 1012 THE ALAMEDA 1012 THE ALAMEDA 1012.0 THE ALAMEDA       Berkeley 94707 37.88824500577836 -122.27681855262747
22187 22187 22187 062 289301600 662 The Alameda B 662 THE ALAMEDA B 662 THE ALAMEDA 662.0 THE ALAMEDA   B   Berkeley 94707 37.895506735961575 -122.28073292195216
22391 22391 22391 062 289302000 690 The Alameda 690 THE ALAMEDA 690 THE ALAMEDA 690.0 THE ALAMEDA       Berkeley 94707 37.89540311962733 -122.27965370573276
22460 22460 22460 062 290300103 510 The Alameda A 510 THE ALAMEDA A 510 THE ALAMEDA 510.0 THE ALAMEDA   A   Berkeley 94707 37.900400203148074 -122.28038809554556
22773 22773 22773 062 288900100 700 The Alameda 700 THE ALAMEDA 700 THE ALAMEDA 700.0 THE ALAMEDA       Berkeley 94707 37.895223136346296 -122.27922149930014
23124 23124 23124 061 257402500 957 The Alameda 957 THE ALAMEDA 957 THE ALAMEDA 957.0 THE ALAMEDA       Berkeley 94707 37.88966153150224 -122.2762875431917
23363 23363 23363 062 289300700 622 The Alameda 622 THE ALAMEDA 622 THE ALAMEDA 622.0 THE ALAMEDA       Berkeley 94707 37.89639967832616 -122.28169889654689
23428 23428 23428 062 289300600 620 The Alameda 620 THE ALAMEDA 620 THE ALAMEDA 620.0 THE ALAMEDA       Berkeley 94707 37.89652407619765 -122.28186950997552
23594 23594 23594 062 290900900 513 The Alameda 513 THE ALAMEDA 513 THE ALAMEDA 513.0 THE ALAMEDA       Berkeley 94707 37.89987042161704 -122.28029183746956
24040 24040 24040 061 260500900 1124 The Alameda 1124 THE ALAMEDA 1124 THE ALAMEDA 1124.0 THE ALAMEDA       Berkeley 94707 37.88690767838044 -122.2764728359904
24344 24344 24344 062 289601900 593 The Alameda 593 THE ALAMEDA 593 THE ALAMEDA 593.0 THE ALAMEDA       Berkeley 94707 37.89789427841741 -122.28126281927366
24574 24574 24574 062 290101400 717 The Alameda 717 THE ALAMEDA 717 THE ALAMEDA 717.0 THE ALAMEDA       Berkeley 94707 37.89569216351645 -122.27845278665698
25517 25517 25517 062 290001000 663 The Alameda 663 THE ALAMEDA 663 THE ALAMEDA 663.0 THE ALAMEDA       Berkeley 94707 37.89586341217411 -122.28040065129828
26196 26196 26196 062 290700800 566 The Alameda 566 THE ALAMEDA 566 THE ALAMEDA 566.0 THE ALAMEDA       Berkeley 94707 37.89879601851791 -122.28160108348716
26255 26255 26255 061 257504200 921 The Alameda 921 THE ALAMEDA 921 THE ALAMEDA 921.0 THE ALAMEDA       Berkeley 94707 37.89090010904121 -122.2765018165398
26793 26793 26793 061 257504600 899 The Alameda 899 THE ALAMEDA 899 THE ALAMEDA 899.0 THE ALAMEDA       Berkeley 94707 37.89168583758766 -122.2767856688982
28042 28042 28042 061 260203200 860 The Alameda 860 THE ALAMEDA 860 THE ALAMEDA 860.0 THE ALAMEDA       Berkeley 94707 37.891860647986846 -122.27751948019592
28685 28685 28685 061 260301500 952 The Alameda 952 THE ALAMEDA 952 THE ALAMEDA 952.0 THE ALAMEDA       Berkeley 94707 37.88966196041451 -122.27709252082283
29488 29488 29488 062 290900801 517 The Alameda 517 THE ALAMEDA 517 THE ALAMEDA 517.0 THE ALAMEDA       Berkeley 94707 37.89986665267456 -122.28044868241987
30132 30132 30132 062 289501100 588 The Alameda 588 THE ALAMEDA 588 THE ALAMEDA 588.0 THE ALAMEDA       Berkeley 94707 37.8978230564317 -122.2817456008568
30598 30598 30598 062 289301700 666 The Alameda 666 THE ALAMEDA 666 THE ALAMEDA 666.0 THE ALAMEDA       Berkeley 94707 37.8954628415065 -122.28057434594837
30646 30646 30646 061 257505700 831 The Alameda 831 THE ALAMEDA 831 THE ALAMEDA 831.0 THE ALAMEDA       Berkeley 94707 37.893181310355246 -122.27690562003976
30683 30683 30683 061 256901700 1147 The Alameda 1147 THE ALAMEDA 1147 THE ALAMEDA 1147.0 THE ALAMEDA       Berkeley 94707 37.886113585343026 -122.27514999576763
31612 31612 31612 062 289301800 670 The Alameda 670 THE ALAMEDA 670 THE ALAMEDA 670.0 THE ALAMEDA       Berkeley 94707 37.89543262931783 -122.28041444942102
31631 31631 31631 061 260300400 908 The Alameda 4 908 THE ALAMEDA 4 908 THE ALAMEDA 908.0 THE ALAMEDA   4   Berkeley 94707 37.891225835811646 -122.27738852020052
32278 32278 32278 061 260300400 908 The Alameda 6 908 THE ALAMEDA 6 908 THE ALAMEDA 908.0 THE ALAMEDA   6   Berkeley 94707 37.891225835811646 -122.27738852020052

Next page

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);