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

84 rows where street_name = "CEDAR" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94710 · 84 ✖

street_type 1

street_name 1

  • CEDAR · 84 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
554 554 554 059 231601102 753 Cedar St 753 CEDAR ST 753 CEDAR ST 753.0 CEDAR ST     Berkeley 94710 37.873955218664825 -122.30142913951104
733 733 733 058 212500200 1004 Cedar St 1004 CEDAR ST 1004 CEDAR ST 1004.0 CEDAR ST     Berkeley 94710 37.87460467496349 -122.29595775174543
814 814 814 058 212400500 966 Cedar St 966 CEDAR ST 966 CEDAR ST 966.0 CEDAR ST     Berkeley 94710 37.87446426492218 -122.2966577477609
2512 2512 2512 058 212800200 1032 Cedar St 1032 CEDAR ST 1032 CEDAR ST 1032.0 CEDAR ST     Berkeley 94710 37.87486024715694 -122.2947242094518
2926 2926 2926 059 231800112 635 Cedar St 635 CEDAR ST 635 CEDAR ST 635.0 CEDAR ST     Berkeley 94710 37.87357439639497 -122.30366968964492
4121 4121 4121 059 231302400 903 Cedar St 903 CEDAR ST 903 CEDAR ST 903.0 CEDAR ST     Berkeley 94710 37.874563468266864 -122.2983268939156
4960 4960 4960 058 212100200 904 Cedar St 904 CEDAR ST 904 CEDAR ST 904.0 CEDAR ST     Berkeley 94710 37.87412732128411 -122.29818469599604
5952 5952 5952 058 212500300 1008 Cedar St 1008 CEDAR ST 1008 CEDAR ST 1008.0 CEDAR ST     Berkeley 94710 37.874637767515054 -122.29580684465915
5953 5953 5953 059 231101300 1017 Cedar St 1017 CEDAR ST 1017 CEDAR ST 1017.0 CEDAR ST     Berkeley 94710 37.87511171072904 -122.29573173202672
6372 6372 6372 057 210900103 600 Cedar St Unit B 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST B UNIT Berkeley 94710 37.87285298994809 -122.30437873259363
6742 6742 6742 057 210900103 600 Cedar St 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST     Berkeley 94710 37.87271044924099 -122.30454586954212
7202 7202 7202 057 210900103 600 Cedar St Unit C 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST C UNIT Berkeley 94710 37.8728380377022 -122.30445389912502
7263 7263 7263 059 231601102 753 Cedar St B 753 CEDAR ST B 753 CEDAR ST 753.0 CEDAR ST B   Berkeley 94710 37.873955218664825 -122.30142913951104
7444 7444 7444 059 231101700 1001 Cedar St 1001 CEDAR ST 1001 CEDAR ST 1001.0 CEDAR ST     Berkeley 94710 37.87500192287292 -122.29624364777112
7693 7693 7693 058 212400300 958 Cedar St 958 CEDAR ST 958 CEDAR ST 958.0 CEDAR ST     Berkeley 94710 37.874402371786914 -122.29695513503572
7811 7811 7811 059 231401400 851 Cedar St B 851 CEDAR ST B 851 CEDAR ST 851.0 CEDAR ST B   Berkeley 94710 37.87438843598565 -122.29927912518475
7880 7880 7880 059 231501501 801 Cedar St 801 CEDAR ST 801 CEDAR ST 801.0 CEDAR ST     Berkeley 94710 37.87413791729597 -122.30052396019984
8020 8020 8020 057 210900103 600 Cedar St Unit D 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST D UNIT Berkeley 94710 37.872823946310376 -122.30452473667506
8155 8155 8155 058 212400200 954 Cedar St 954 CEDAR ST 954 CEDAR ST 954.0 CEDAR ST     Berkeley 94710 37.87437439523599 -122.2970982734914
9796 9796 9796 059 231000400 1039 Cedar St 1039 CEDAR ST 1039 CEDAR ST 1039.0 CEDAR ST     Berkeley 94710 37.87531818633496 -122.29470851408716
9913 9913 9913 059 231800112 625 Cedar St 625 CEDAR ST 625 CEDAR ST 625.0 CEDAR ST     Berkeley 94710 37.87352091245325 -122.30393434231075
11845 11845 11845 059 231101600 1005 Cedar St 1005 CEDAR ST 1005 CEDAR ST 1005.0 CEDAR ST     Berkeley 94710 37.87502890150048 -122.29611182808804
12188 12188 12188 059 231302000 921 Cedar St 921 CEDAR ST 921 CEDAR ST 921.0 CEDAR ST     Berkeley 94710 37.87468509219922 -122.29772091288282
12307 12307 12307 059 231000600 1035 Cedar St C 1035 CEDAR ST C 1035 CEDAR ST 1035.0 CEDAR ST C   Berkeley 94710 37.87527086914836 -122.29494380711458
12357 12357 12357 058 212100400 912 Cedar St 912 CEDAR ST 912 CEDAR ST 912.0 CEDAR ST     Berkeley 94710 37.87418753905941 -122.29788207333976
12669 12669 12669 057 210900103 600 Cedar St Unit A 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST A UNIT Berkeley 94710 37.87286700333252 -122.30430828940398
12672 12672 12672 058 212500300 1006 Cedar St 1006 CEDAR ST 1006 CEDAR ST 1006.0 CEDAR ST     Berkeley 94710 37.874637767515054 -122.29580684465915
13300 13300 13300 059 231501300 821 Cedar St 821 CEDAR ST 821 CEDAR ST 821.0 CEDAR ST     Berkeley 94710 37.87418891399424 -122.29995950738432
14896 14896 14896 059 231101200 1021 Cedar St 1021 CEDAR ST 1021 CEDAR ST 1021.0 CEDAR ST     Berkeley 94710 37.87513619617121 -122.29561107660597
15070 15070 15070 059 231101500 1009 Cedar St 1009 CEDAR ST 1009 CEDAR ST 1009.0 CEDAR ST     Berkeley 94710 37.875057686161405 -122.29597999942176
15175 15175 15175 059 231501400 811 Cedar St 811 CEDAR ST 811 CEDAR ST 811.0 CEDAR ST     Berkeley 94710 37.87414634631133 -122.30017502310244
17293 17293 17293 059 231302200 911 Cedar St 911 CEDAR ST 911 CEDAR ST 911.0 CEDAR ST     Berkeley 94710 37.87462504997601 -122.29802351487784
17568 17568 17568 059 231101400 1013 Cedar St 1013 CEDAR ST 1013 CEDAR ST 1013.0 CEDAR ST     Berkeley 94710 37.87508649066551 -122.2958489990022
18961 18961 18961 059 231800112 631 Cedar St 631 CEDAR ST 631 CEDAR ST 631.0 CEDAR ST     Berkeley 94710 37.87357439639497 -122.30366968964492
19408 19408 19408 057 210900103 600 Cedar St Unit H 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST H UNIT Berkeley 94710 37.872762621920295 -122.3048330106328
19428 19428 19428 059 231000600 1035 Cedar St B 1035 CEDAR ST B 1035 CEDAR ST 1035.0 CEDAR ST B   Berkeley 94710 37.87527086914836 -122.29494380711458
19649 19649 19649 059 231000500 1037 Cedar St 1037 CEDAR ST 1037 CEDAR ST 1037.0 CEDAR ST     Berkeley 94710 37.87529009880558 -122.29485151689722
20004 20004 20004 059 231601101 761 Cedar St B 761 CEDAR ST B 761 CEDAR ST 761.0 CEDAR ST B   Berkeley 94710 37.87398166727136 -122.30129646732676
20100 20100 20100 058 212000100 852 Cedar St 852 CEDAR ST 852 CEDAR ST 852.0 CEDAR ST     Berkeley 94710 37.87401307599857 -122.29924393368351
20648 20648 20648 059 231800107 675 Cedar St 675 CEDAR ST 675 CEDAR ST 675.0 CEDAR ST     Berkeley 94710 37.87353107458244 -122.30346702792018
20657 20657 20657 058 212000100 850 Cedar St 850 CEDAR ST 850 CEDAR ST 850.0 CEDAR ST     Berkeley 94710 37.87401307599857 -122.29924393368351
20728 20728 20728 059 231000700 1031 Cedar St 1031 CEDAR ST 1031 CEDAR ST 1031.0 CEDAR ST     Berkeley 94710 37.87524880811131 -122.29505155643965
20951 20951 20951 059 231401300 855 Cedar St 855 CEDAR ST 855 CEDAR ST 855.0 CEDAR ST     Berkeley 94710 37.87442675464643 -122.29909290532468
22428 22428 22428 057 211700200 830 Cedar St 830 CEDAR ST 830 CEDAR ST 830.0 CEDAR ST     Berkeley 94710 37.873806846337295 -122.2999086825022
22589 22589 22589 059 231000600 1035 Cedar St A 1035 CEDAR ST A 1035 CEDAR ST 1035.0 CEDAR ST A   Berkeley 94710 37.87527086914836 -122.29494380711458
23616 23616 23616 058 212500600 1016 Cedar St 1016 CEDAR ST 1016 CEDAR ST 1016.0 CEDAR ST     Berkeley 94710 37.87470786745852 -122.29548204709008
23974 23974 23974 059 231401200 857 Cedar St 857 CEDAR ST 857 CEDAR ST 857.0 CEDAR ST     Berkeley 94710 37.874454349685834 -122.29896272327034
24148 24148 24148 059 231000400 1041 Cedar St 1041 CEDAR ST 1041 CEDAR ST 1041.0 CEDAR ST     Berkeley 94710 37.87531818633496 -122.29470851408716
24479 24479 24479 059 231302100 915 Cedar St 915 CEDAR ST 915 CEDAR ST 915.0 CEDAR ST     Berkeley 94710 37.874655735865915 -122.2978751949396
24785 24785 24785 058 212100300 908 Cedar St 908 CEDAR ST 908 CEDAR ST 908.0 CEDAR ST     Berkeley 94710 37.87415694302956 -122.29803554062455
27645 27645 27645 058 212500700 1020 Cedar St 1020 CEDAR ST 1020 CEDAR ST 1020.0 CEDAR ST     Berkeley 94710 37.874732296307734 -122.29536565776864
28696 28696 28696 058 212100500 918 Cedar St 918 CEDAR ST 918 CEDAR ST 918.0 CEDAR ST     Berkeley 94710 37.87421776280191 -122.2977338010122
28726 28726 28726 059 231900502 601 Cedar St 601 CEDAR ST 601 CEDAR ST 601.0 CEDAR ST     Berkeley 94710 37.87352722203586 -122.3047964932182
29499 29499 29499 057 211700200 822 Cedar St 822 CEDAR ST 822 CEDAR ST 822.0 CEDAR ST     Berkeley 94710 37.873806846337295 -122.2999086825022
30620 30620 30620 059 231302500 901 Cedar St 901 CEDAR ST 901 CEDAR ST 901.0 CEDAR ST     Berkeley 94710 37.87453218457441 -122.29847605916856
32897 32897 32897 058 212500500 1014 Cedar St 1014 CEDAR ST 1014 CEDAR ST 1014.0 CEDAR ST     Berkeley 94710 37.874687571177965 -122.29558286142118
33474 33474 33474 059 231000600 1035 Cedar St 1035 CEDAR ST 1035 CEDAR ST 1035.0 CEDAR ST     Berkeley 94710 37.87527086914836 -122.29494380711458
33993 33993 33993 059 231101100 1025 Cedar St 1025 CEDAR ST 1025 CEDAR ST 1025.0 CEDAR ST     Berkeley 94710 37.875162074958105 -122.29548778103656
35430 35430 35430 059 231601000 765 Cedar St 765 CEDAR ST 765 CEDAR ST 765.0 CEDAR ST     Berkeley 94710 37.87400870087302 -122.30117140566948
35907 35907 35907 059 231401400 851 Cedar St A 851 CEDAR ST A 851 CEDAR ST 851.0 CEDAR ST A   Berkeley 94710 37.87438843598565 -122.29927912518475
36557 36557 36557 059 231800112 629 Cedar St 629 CEDAR ST 629 CEDAR ST 629.0 CEDAR ST     Berkeley 94710 37.87357439639497 -122.30366968964492
37177 37177 37177 059 231800112 633 Cedar St 633 CEDAR ST 633 CEDAR ST 633.0 CEDAR ST     Berkeley 94710 37.87357439639497 -122.30366968964492
39490 39490 39490 057 210900103 600 Cedar St Unit E 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST E UNIT Berkeley 94710 37.87280881039967 -122.30460082218302
40406 40406 40406 059 231201200 997 Cedar St 997 CEDAR ST 997 CEDAR ST 997.0 CEDAR ST     Berkeley 94710 37.87484529744575 -122.29701436814892
40541 40541 40541 059 231201200 999 Cedar St 999 CEDAR ST 999 CEDAR ST 999.0 CEDAR ST     Berkeley 94710 37.87484529744575 -122.29701436814892
41043 41043 41043 059 231401400 853 Cedar St 853 CEDAR ST 853 CEDAR ST 853.0 CEDAR ST     Berkeley 94710 37.87438843598565 -122.29927912518475
41338 41338 41338 058 212500100 1000 Cedar St 1000 CEDAR ST 1000 CEDAR ST 1000.0 CEDAR ST     Berkeley 94710 37.87457536823456 -122.29610603934437
42407 42407 42407 058 212100400 914 Cedar St 914 CEDAR ST 914 CEDAR ST 914.0 CEDAR ST     Berkeley 94710 37.87414573648941 -122.29787143459184
43143 43143 43143 059 231601201 741 Cedar St 741 CEDAR ST 741 CEDAR ST 741.0 CEDAR ST     Berkeley 94710 37.87391390524028 -122.30163604128391
43267 43267 43267 057 211200101 650 Cedar St 650 CEDAR ST 650 CEDAR ST 650.0 CEDAR ST     Berkeley 94710 37.87287542965688 -122.3036747848892
44917 44917 44917 059 231601101 761 Cedar St 761 CEDAR ST 761 CEDAR ST 761.0 CEDAR ST     Berkeley 94710 37.87398166727136 -122.30129646732676
46143 46143 46143 057 210900103 600 Cedar St Unit G 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST G UNIT Berkeley 94710 37.872778488222146 -122.30475325371027
46573 46573 46573 058 212100500 916 Cedar St 916 CEDAR ST 916 CEDAR ST 916.0 CEDAR ST     Berkeley 94710 37.87421776280191 -122.2977338010122
47595 47595 47595 058 212100100 900 Cedar St 900 CEDAR ST 900 CEDAR ST 900.0 CEDAR ST     Berkeley 94710 37.87409861071468 -122.29833641785426
48149 48149 48149 058 212100600 920 Cedar St 920 CEDAR ST 920 CEDAR ST 920.0 CEDAR ST     Berkeley 94710 37.87424752349346 -122.29758555383748
49207 49207 49207 058 212500400 1010 Cedar St 1010 CEDAR ST 1010 CEDAR ST 1010.0 CEDAR ST     Berkeley 94710 37.8746674727279 -122.29568200039428
52328 52328 52328 059 231601201 749 Cedar St 749 CEDAR ST 749 CEDAR ST 749.0 CEDAR ST     Berkeley 94710 37.87391390524028 -122.30163604128391
53875 53875 53875 059 231800112 637 Cedar St 637 CEDAR ST 637 CEDAR ST 637.0 CEDAR ST     Berkeley 94710 37.87357439639497 -122.30366968964492
54093 54093 54093 057 210900103 600 Cedar St Unit F 600 CEDAR ST 600 CEDAR ST 600.0 CEDAR ST F UNIT Berkeley 94710 37.87279419709858 -122.30467428281368
54172 54172 54172 058 212400400 962 Cedar St 962 CEDAR ST 962 CEDAR ST 962.0 CEDAR ST     Berkeley 94710 37.87443324922456 -122.29680514872264
56207 56207 56207 059 231601102 753 Cedar St A 753 CEDAR ST A 753 CEDAR ST 753.0 CEDAR ST A   Berkeley 94710 37.873955218664825 -122.30142913951104
56681 56681 56681 059 231302300 907 Cedar St 907 CEDAR ST 907 CEDAR ST 907.0 CEDAR ST     Berkeley 94710 37.87459393507336 -122.2981769255688
58020 58020 58020 059 231000800 1029 Cedar St 1029 CEDAR ST 1029 CEDAR ST 1029.0 CEDAR ST     Berkeley 94710 37.8752257394581 -122.2951704835018
58215 58215 58215 059 231800106 695 Cedar St 695 CEDAR ST 695 CEDAR ST 695.0 CEDAR ST     Berkeley 94710 37.87364651048532 -122.303312798864

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