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

206 rows where street_name = "SPRUCE" and zipcode = 94707

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94707 · 206 ✖

street_type 1

street_name 1

  • SPRUCE · 206 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
569 569 569 061 255702300 1188 Spruce St 1188 SPRUCE ST 1188 SPRUCE ST 1188.0 SPRUCE ST     Berkeley 94707 37.88628578362558 -122.26686644188658
574 574 574 063 295904700 769 Spruce St 769 SPRUCE ST 769 SPRUCE ST 769.0 SPRUCE ST     Berkeley 94707 37.89578253531088 -122.2689920031725
906 906 906 063 295904800 765 Spruce St 765 SPRUCE ST 765 SPRUCE ST 765.0 SPRUCE ST     Berkeley 94707 37.89592158051158 -122.26897045977532
955 955 955 061 255604200 1139 Spruce St 1139 SPRUCE ST 1139 SPRUCE ST 1139.0 SPRUCE ST     Berkeley 94707 37.88782112973 -122.26636239718064
1110 1110 1110 061 255702300 1194 Spruce St 1194 SPRUCE ST 1194 SPRUCE ST 1194.0 SPRUCE ST     Berkeley 94707 37.88628578362558 -122.26686644188658
1253 1253 1253 063 295801700 671 Spruce St 671 SPRUCE ST 671 SPRUCE ST 671.0 SPRUCE ST     Berkeley 94707 37.898779200862606 -122.26978066560144
1321 1321 1321 063 295207200 531 Spruce St 531 SPRUCE ST 531 SPRUCE ST 531.0 SPRUCE ST     Berkeley 94707 37.90131821926596 -122.26930336374151
1501 1501 1501 063 297405301 995 Spruce St 995 SPRUCE ST 995 SPRUCE ST 995.0 SPRUCE ST     Berkeley 94707 37.89075655616146 -122.26689231336675
1575 1575 1575 062 291402201 630 Spruce St 630 SPRUCE ST 630 SPRUCE ST 630.0 SPRUCE ST     Berkeley 94707 37.89888357021265 -122.2708383725597
1753 1753 1753 061 258802300 1062 Spruce St 1062 SPRUCE ST 1062 SPRUCE ST 1062.0 SPRUCE ST     Berkeley 94707 37.889448211512835 -122.26720607513252
1889 1889 1889 063 295205300 635 Spruce St 635 SPRUCE ST 635 SPRUCE ST 635.0 SPRUCE ST     Berkeley 94707 37.899287453165975 -122.27037919870224
2011 2011 2011 063 295905400 741 Spruce St 741 SPRUCE ST 741 SPRUCE ST 741.0 SPRUCE ST     Berkeley 94707 37.89675426682092 -122.2689521305503
2231 2231 2231 063 295205600 615 Spruce St 615 SPRUCE ST 615 SPRUCE ST 615.0 SPRUCE ST     Berkeley 94707 37.89961993431722 -122.27071652327794
2993 2993 2993 061 258802200 1054 Spruce St B 1054 SPRUCE ST B 1054 SPRUCE ST 1054.0 SPRUCE ST B   Berkeley 94707 37.889581478001915 -122.2672500126314
3382 3382 3382 063 295206500 557 Spruce St 557 SPRUCE ST 557 SPRUCE ST 557.0 SPRUCE ST     Berkeley 94707 37.90047341590298 -122.26986087437656
3439 3439 3439 061 255603700 1133 Spruce St 1133 SPRUCE ST 1133 SPRUCE ST 1133.0 SPRUCE ST     Berkeley 94707 37.88798380124233 -122.26645915561822
3891 3891 3891 063 297405200 999 Spruce St 999 SPRUCE ST 999 SPRUCE ST 999.0 SPRUCE ST     Berkeley 94707 37.89065174000136 -122.26682597637628
3951 3951 3951 061 255701100 1128 Spruce St 1128 SPRUCE ST 1128 SPRUCE ST 1128.0 SPRUCE ST     Berkeley 94707 37.88781570403158 -122.26714472828348
3985 3985 3985 063 295801300 693 Spruce St 693 SPRUCE ST 693 SPRUCE ST 693.0 SPRUCE ST     Berkeley 94707 37.89822166984301 -122.26962775976368
4563 4563 4563 061 258203100 818 Spruce St 818 SPRUCE ST 818 SPRUCE ST 818.0 SPRUCE ST     Berkeley 94707 37.894505068897665 -122.26892717535168
4663 4663 4663 061 255604100 1109 Spruce St 1109 SPRUCE ST 1109 SPRUCE ST 1109.0 SPRUCE ST     Berkeley 94707 37.888479220099626 -122.26644746224817
5148 5148 5148 061 258802900 1104 Spruce St 1104 SPRUCE ST 1104 SPRUCE ST 1104.0 SPRUCE ST     Berkeley 94707 37.888567032908625 -122.26707579695848
5848 5848 5848 061 258202900 800 Spruce St 800 SPRUCE ST 800 SPRUCE ST 800.0 SPRUCE ST     Berkeley 94707 37.89476341825562 -122.26895341064956
5895 5895 5895 063 297400100 959 Spruce St 959 SPRUCE ST 959 SPRUCE ST 959.0 SPRUCE ST     Berkeley 94707 37.89168180237869 -122.26697626182836
5975 5975 5975 061 255602400 1191 Spruce St 1191 SPRUCE ST 1191 SPRUCE ST 1191.0 SPRUCE ST     Berkeley 94707 37.886402288528814 -122.26628273458124
6043 6043 6043 063 295205400 625 Spruce St 625 SPRUCE ST 625 SPRUCE ST 625.0 SPRUCE ST     Berkeley 94707 37.89939766202801 -122.27048320384918
6142 6142 6142 062 293902400 560 Spruce St 560 SPRUCE ST 560 SPRUCE ST 560.0 SPRUCE ST     Berkeley 94707 37.90077528546027 -122.270483462564
6167 6167 6167 061 258200700 738 Spruce St 738 SPRUCE ST 738 SPRUCE ST 738.0 SPRUCE ST     Berkeley 94707 37.89659434883341 -122.26964890251222
6186 6186 6186 061 255701900 1166 Spruce St 1166 SPRUCE ST 1166 SPRUCE ST 1166.0 SPRUCE ST     Berkeley 94707 37.88696931357651 -122.26702629798967
6270 6270 6270 062 293902500 562 Spruce St 562 SPRUCE ST 562 SPRUCE ST 562.0 SPRUCE ST     Berkeley 94707 37.90067775555263 -122.27058466586558
6313 6313 6313 062 291403000 670 Spruce St 670 SPRUCE ST 670 SPRUCE ST 670.0 SPRUCE ST     Berkeley 94707 37.8981893229803 -122.27042018793033
6328 6328 6328 063 297304800 925 Spruce St 925 SPRUCE ST 925 SPRUCE ST 925.0 SPRUCE ST     Berkeley 94707 37.89280814807832 -122.26682711094848
6416 6416 6416 061 258802000 1030 Spruce St 1030 SPRUCE ST 1030 SPRUCE ST 1030.0 SPRUCE ST     Berkeley 94707 37.88997941221138 -122.26737468352148
7031 7031 7031 061 258900200 976 Spruce St 976 SPRUCE ST 976 SPRUCE ST 976.0 SPRUCE ST     Berkeley 94707 37.89125295240941 -122.26751215899762
7270 7270 7270 061 255602800 1169 Spruce St 1169 SPRUCE ST 1169 SPRUCE ST 1169.0 SPRUCE ST     Berkeley 94707 37.88695810685882 -122.26634437877266
7907 7907 7907 062 291402800 650 Spruce St 650 SPRUCE ST 650 SPRUCE ST 650.0 SPRUCE ST     Berkeley 94707 37.89861104040156 -122.27075619377918
8064 8064 8064 061 255701800 1160 Spruce St 1160 SPRUCE ST 1160 SPRUCE ST 1160.0 SPRUCE ST     Berkeley 94707 37.88711429178113 -122.267043850172
8134 8134 8134 061 258201000 754 Spruce St 754 SPRUCE ST 754 SPRUCE ST 754.0 SPRUCE ST     Berkeley 94707 37.89618476798728 -122.2697122678757
8139 8139 8139 061 255603700 1133 Spruce St B 1133 SPRUCE ST B 1133 SPRUCE ST 1133.0 SPRUCE ST B   Berkeley 94707 37.88798380124233 -122.26645915561822
9099 9099 9099 061 258202706 784 Spruce St 784 SPRUCE ST 784 SPRUCE ST 784.0 SPRUCE ST     Berkeley 94707 37.89504795325541 -122.26918128808433
9117 9117 9117 061 255602600 1179 Spruce St 1179 SPRUCE ST 1179 SPRUCE ST 1179.0 SPRUCE ST     Berkeley 94707 37.88669457373947 -122.26631656603318
10041 10041 10041 061 255603001 1159 Spruce St 1159 SPRUCE ST 1159 SPRUCE ST 1159.0 SPRUCE ST     Berkeley 94707 37.88722646995193 -122.26637689958258
10218 10218 10218 061 259000700 938 Spruce St 938 SPRUCE ST 938 SPRUCE ST 938.0 SPRUCE ST     Berkeley 94707 37.8923343052705 -122.26725481951648
10478 10478 10478 062 293902800 580 Spruce St 580 SPRUCE ST 580 SPRUCE ST 580.0 SPRUCE ST     Berkeley 94707 37.90033917887713 -122.27087479744785
10777 10777 10777 061 258201500 776 Spruce St 776 SPRUCE ST 776 SPRUCE ST 776.0 SPRUCE ST     Berkeley 94707 37.8954012056228 -122.26954334058486
10789 10789 10789 063 295206300 567 Spruce St 567 SPRUCE ST 567 SPRUCE ST 567.0 SPRUCE ST     Berkeley 94707 37.90023231078941 -122.27008147186424
12554 12554 12554 062 293902900 584 Spruce St 584 SPRUCE ST 584 SPRUCE ST 584.0 SPRUCE ST     Berkeley 94707 37.9001827895093 -122.2709461991399
13566 13566 13566 061 255604200 1137 Spruce St 1137 SPRUCE ST 1137 SPRUCE ST 1137.0 SPRUCE ST     Berkeley 94707 37.88782112973 -122.26636239718064
13751 13751 13751 061 258203802 878 Spruce St 878 SPRUCE ST 878 SPRUCE ST 878.0 SPRUCE ST     Berkeley 94707 37.89333025473421 -122.26834023590796
13829 13829 13829 061 258200200 714 Spruce St 714 SPRUCE ST 714 SPRUCE ST 714.0 SPRUCE ST     Berkeley 94707 37.897327391382184 -122.27009732443406
14017 14017 14017 063 295206100 579 Spruce St 579 SPRUCE ST 579 SPRUCE ST 579.0 SPRUCE ST     Berkeley 94707 37.89997877030175 -122.27027176019423
14324 14324 14324 061 255501500 1035 Spruce St 1035 SPRUCE ST 1035 SPRUCE ST 1035.0 SPRUCE ST     Berkeley 94707 37.89006401668666 -122.26681001870358
14725 14725 14725 062 291402005 620 Spruce St 620 SPRUCE ST 620 SPRUCE ST 620.0 SPRUCE ST     Berkeley 94707 37.89889529045409 -122.27120305622569
15154 15154 15154 063 295206300 565 Spruce St 565 SPRUCE ST 565 SPRUCE ST 565.0 SPRUCE ST     Berkeley 94707 37.90023231078941 -122.27008147186424
15245 15245 15245 061 258802100 1050 Spruce St 1050 SPRUCE ST 1050 SPRUCE ST 1050.0 SPRUCE ST     Berkeley 94707 37.88973770911266 -122.26729881720247
15426 15426 15426 063 295900100 701 Spruce St 701 SPRUCE ST 701 SPRUCE ST 701.0 SPRUCE ST     Berkeley 94707 37.89797643317202 -122.26954804685862
15647 15647 15647 063 297304600 931 Spruce St 931 SPRUCE ST 931 SPRUCE ST 931.0 SPRUCE ST     Berkeley 94707 37.8925385200607 -122.26671124893808
15764 15764 15764 061 255602700 1175 Spruce St 1175 SPRUCE ST 1175 SPRUCE ST 1175.0 SPRUCE ST     Berkeley 94707 37.88683385446861 -122.26633274109815
15993 15993 15993 061 258802500 1074 Spruce St 1074 SPRUCE ST 1074 SPRUCE ST 1074.0 SPRUCE ST     Berkeley 94707 37.88917545606136 -122.26711901670342
16184 16184 16184 061 255604200 1135 Spruce St 1135 SPRUCE ST 1135 SPRUCE ST 1135.0 SPRUCE ST     Berkeley 94707 37.88782112973 -122.26636239718064
16388 16388 16388 061 255603400 1147 Spruce St 1147 SPRUCE ST 1147 SPRUCE ST 1147.0 SPRUCE ST     Berkeley 94707 37.88752244489745 -122.2664869081706
16443 16443 16443 061 258204100 898 Spruce St 898 SPRUCE ST 898 SPRUCE ST 898.0 SPRUCE ST     Berkeley 94707 37.89303381185828 -122.26810739078972
16972 16972 16972 063 297400400 987 Spruce St 987 SPRUCE ST 987 SPRUCE ST 987.0 SPRUCE ST     Berkeley 94707 37.89103814898141 -122.26689668995878
16994 16994 16994 063 297304300 941 Spruce St 941 SPRUCE ST 941 SPRUCE ST 941.0 SPRUCE ST     Berkeley 94707 37.89209999970991 -122.26666441886398
17370 17370 17370 063 297305100 905 Spruce St 905 SPRUCE ST 905 SPRUCE ST 905.0 SPRUCE ST     Berkeley 94707 37.89316353651247 -122.26719232462052
17493 17493 17493 063 295800100 657 Spruce St 657 SPRUCE ST 657 SPRUCE ST 657.0 SPRUCE ST     Berkeley 94707 37.89898665780298 -122.27006145829802
17798 17798 17798 061 255701200 1132 Spruce St 1132 SPRUCE ST 1132 SPRUCE ST 1132.0 SPRUCE ST     Berkeley 94707 37.887753759017635 -122.26708163241456
17816 17816 17816 061 259000100 902 Spruce St 902 SPRUCE ST 902 SPRUCE ST 902.0 SPRUCE ST     Berkeley 94707 37.89286061206412 -122.26782958948304
18445 18445 18445 061 258801600 1000 Spruce St 1000 SPRUCE ST 1000 SPRUCE ST 1000.0 SPRUCE ST     Berkeley 94707 37.89065832885524 -122.26757021352118
18606 18606 18606 063 295206700 547 Spruce St A 547 SPRUCE ST A 547 SPRUCE ST 547.0 SPRUCE ST A   Berkeley 94707 37.900723298493496 -122.26970202977644
18622 18622 18622 063 295905500 737 Spruce St 737 SPRUCE ST 737 SPRUCE ST 737.0 SPRUCE ST     Berkeley 94707 37.89689294724143 -122.26899623333917
19462 19462 19462 061 258900300 972 Spruce St 972 SPRUCE ST 972 SPRUCE ST 972.0 SPRUCE ST     Berkeley 94707 37.891392839866405 -122.26754626443568
19472 19472 19472 062 291402900 660 Spruce St 660 SPRUCE ST 660 SPRUCE ST 660.0 SPRUCE ST     Berkeley 94707 37.89835038444159 -122.2705744169865
19481 19481 19481 061 255603200 1151 Spruce St 1151 SPRUCE ST 1151 SPRUCE ST 1151.0 SPRUCE ST     Berkeley 94707 37.88742880171333 -122.26647868499246
19758 19758 19758 061 258201400 774 Spruce St 774 SPRUCE ST 774 SPRUCE ST 774.0 SPRUCE ST     Berkeley 94707 37.89549893959372 -122.26961278125462
19921 19921 19921 062 291403300 710 Spruce St 710 SPRUCE ST 710 SPRUCE ST 710.0 SPRUCE ST     Berkeley 94707 37.89758562804878 -122.27023641777603
19947 19947 19947 061 258200403 730 Spruce St 730 SPRUCE ST 730 SPRUCE ST 730.0 SPRUCE ST     Berkeley 94707 37.89686414984832 -122.26976874046603
20074 20074 20074 061 255701100 1130 Spruce St 1130 SPRUCE ST 1130 SPRUCE ST 1130.0 SPRUCE ST     Berkeley 94707 37.88781570403158 -122.26714472828348
20278 20278 20278 061 259000500 920 Spruce St 920 SPRUCE ST 920 SPRUCE ST 920.0 SPRUCE ST     Berkeley 94707 37.89263238643529 -122.26733473903406
20897 20897 20897 061 259000400 912 Spruce St 912 SPRUCE ST 912 SPRUCE ST 912.0 SPRUCE ST     Berkeley 94707 37.892689251501295 -122.26746524987178
21050 21050 21050 063 295906100 711 Spruce St 711 SPRUCE ST 711 SPRUCE ST 711.0 SPRUCE ST     Berkeley 94707 37.89769287284432 -122.26940087676395
21951 21951 21951 061 258902200 964 Spruce St 964 SPRUCE ST 964 SPRUCE ST 964.0 SPRUCE ST     Berkeley 94707 37.891532155661814 -122.2674835467575
22609 22609 22609 061 258203300 836 Spruce St 836 SPRUCE ST 836 SPRUCE ST 836.0 SPRUCE ST     Berkeley 94707 37.8941621295978 -122.26887494640278
22983 22983 22983 061 258801700 1008 Spruce St 1008 SPRUCE ST 1008 SPRUCE ST 1008.0 SPRUCE ST     Berkeley 94707 37.890504032971215 -122.26753546758432
23683 23683 23683 061 258900100 984 Spruce St 984 SPRUCE ST 984 SPRUCE ST 984.0 SPRUCE ST     Berkeley 94707 37.89107410248929 -122.26747691000416
24351 24351 24351 061 259000200 904 Spruce St 904 SPRUCE ST 904 SPRUCE ST 904.0 SPRUCE ST     Berkeley 94707 37.89281985865343 -122.26768498138355
24412 24412 24412 061 258200900 750 Spruce St 750 SPRUCE ST 750 SPRUCE ST 750.0 SPRUCE ST     Berkeley 94707 37.896320689804256 -122.26964182109285
25006 25006 25006 063 295206800 543 Spruce St 543 SPRUCE ST 543 SPRUCE ST 543.0 SPRUCE ST     Berkeley 94707 37.90085144377325 -122.2696268443804
26137 26137 26137 063 295905800 725 Spruce St 725 SPRUCE ST 725 SPRUCE ST 725.0 SPRUCE ST     Berkeley 94707 37.89729163870363 -122.2692163044141
26550 26550 26550 063 295206602 551 Spruce St 551 SPRUCE ST 551 SPRUCE ST 551.0 SPRUCE ST     Berkeley 94707 37.90061516851882 -122.26980879454791
27035 27035 27035 061 258802600 1080 Spruce St 1080 SPRUCE ST 1080 SPRUCE ST 1080.0 SPRUCE ST     Berkeley 94707 37.889042403649775 -122.26708375333692
27446 27446 27446 062 293902600 564 Spruce St 564 SPRUCE ST 564 SPRUCE ST 564.0 SPRUCE ST     Berkeley 94707 37.900572843648206 -122.2706654280029
27553 27553 27553 061 258202709 780 Spruce St 780 SPRUCE ST 780 SPRUCE ST 780.0 SPRUCE ST     Berkeley 94707 37.89516344404613 -122.26929898175958
27729 27729 27729 061 255501300 1049 Spruce St 1049 SPRUCE ST 1049 SPRUCE ST 1049.0 SPRUCE ST     Berkeley 94707 37.8897490784647 -122.26671327463902
27944 27944 27944 063 295206200 573 Spruce St 573 SPRUCE ST 573 SPRUCE ST 573.0 SPRUCE ST     Berkeley 94707 37.900070997553 -122.27013549295216
28931 28931 28931 061 255501200 1055 Spruce St 1055 SPRUCE ST 1055 SPRUCE ST 1055.0 SPRUCE ST     Berkeley 94707 37.889621132920674 -122.26665568634112
28989 28989 28989 061 258200800 744 Spruce St 744 SPRUCE ST 744 SPRUCE ST 744.0 SPRUCE ST     Berkeley 94707 37.89645884859677 -122.26962891948872
29107 29107 29107 061 258200402 722 Spruce St A 722 SPRUCE ST A 722 SPRUCE ST 722.0 SPRUCE ST A   Berkeley 94707 37.89701108703921 -122.26987440210642
29641 29641 29641 061 258200300 720 Spruce St 720 SPRUCE ST 720 SPRUCE ST 720.0 SPRUCE ST     Berkeley 94707 37.89716111887909 -122.2699974578256
29655 29655 29655 063 295905300 743 Spruce St 743 SPRUCE ST 743 SPRUCE ST 743.0 SPRUCE ST     Berkeley 94707 37.89661776594165 -122.26891682945458

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