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

90 rows where street_name = "FAIRLAWN" and street_type = "DR"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • FAIRLAWN · 90 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
865 865 865 060 248604900 15 Fairlawn Dr 15 FAIRLAWN DR 15 FAIRLAWN DR 15.0 FAIRLAWN DR     Berkeley 94708 37.88608497019509 -122.2530158054076
900 900 900 060 248602200 57 Fairlawn Dr 57 FAIRLAWN DR 57 FAIRLAWN DR 57.0 FAIRLAWN DR     Berkeley 94708 37.88772562447604 -122.2531147162086
1899 1899 1899 060 248704700 165 Fairlawn Dr 165 FAIRLAWN DR 165 FAIRLAWN DR 165.0 FAIRLAWN DR     Berkeley 94708 37.88559028675282 -122.25034903701078
1916 1916 1916 060 249001802 277 Fairlawn Dr 277 FAIRLAWN DR 277 FAIRLAWN DR 277.0 FAIRLAWN DR     Berkeley 94708 37.8827108400976 -122.25022723533972
2022 2022 2022 060 248502700 160 Fairlawn Dr 160 FAIRLAWN DR 160 FAIRLAWN DR 160.0 FAIRLAWN DR     Berkeley 94708 37.88527592919921 -122.25060485833906
2223 2223 2223 060 248500800 94 Fairlawn Dr 94 FAIRLAWN DR 94 FAIRLAWN DR 94.0 FAIRLAWN DR     Berkeley 94708 37.88651558938456 -122.25231035392342
3118 3118 3118 060 248704500 173 Fairlawn Dr 173 FAIRLAWN DR 173 FAIRLAWN DR 173.0 FAIRLAWN DR     Berkeley 94708 37.88549102452459 -122.2500212776962
3948 3948 3948 060 248500100 50 Fairlawn Dr 50 FAIRLAWN DR 50 FAIRLAWN DR 50.0 FAIRLAWN DR     Berkeley 94708 37.88737889890248 -122.2528702145512
4758 4758 4758 060 248503100 200 Fairlawn Dr 200 FAIRLAWN DR 200 FAIRLAWN DR 200.0 FAIRLAWN DR     Berkeley 94708 37.88477085712103 -122.25062693443716
5024 5024 5024 060 248503005 192 Fairlawn Dr 192 FAIRLAWN DR 192 FAIRLAWN DR 192.0 FAIRLAWN DR     Berkeley 94708 37.88485591779117 -122.25056215512538
5130 5130 5130 060 248501401 120 Fairlawn Dr 120 FAIRLAWN DR 120 FAIRLAWN DR 120.0 FAIRLAWN DR     Berkeley 94708 37.88587634323241 -122.25159031559564
5452 5452 5452 060 248601200 91 Fairlawn Dr 91 FAIRLAWN DR 91 FAIRLAWN DR 91.0 FAIRLAWN DR     Berkeley 94708 37.88681233429658 -122.2519596453483
6672 6672 6672 060 248506700 32 Fairlawn Dr 32 FAIRLAWN DR 32 FAIRLAWN DR 32.0 FAIRLAWN DR     Berkeley 94708 37.88674083288795 -122.25282632196812
6723 6723 6723 060 248506800 36 Fairlawn Dr 36 FAIRLAWN DR 36 FAIRLAWN DR 36.0 FAIRLAWN DR     Berkeley 94708 37.88687297346585 -122.25285983361977
10663 10663 10663 060 248500300 80 Fairlawn Dr 80 FAIRLAWN DR 80 FAIRLAWN DR 80.0 FAIRLAWN DR     Berkeley 94708 37.88720367162264 -122.25258925297136
10824 10824 10824 060 248601400 83 Fairlawn Dr 83 FAIRLAWN DR 83 FAIRLAWN DR 83.0 FAIRLAWN DR     Berkeley 94708 37.88705952663481 -122.25208087119924
10861 10861 10861 060 248902800 249 Fairlawn Dr 249 FAIRLAWN DR 249 FAIRLAWN DR 249.0 FAIRLAWN DR     Berkeley 94708 37.88325742168985 -122.2498801370937
11016 11016 11016 060 248506900 38 Fairlawn Dr 38 FAIRLAWN DR 38 FAIRLAWN DR 38.0 FAIRLAWN DR     Berkeley 94708 37.88702126488299 -122.2528791770428
11475 11475 11475 060 248504601 212 Fairlawn Dr 212 FAIRLAWN DR 212 FAIRLAWN DR 212.0 FAIRLAWN DR     Berkeley 94708 37.884150510498365 -122.25062147537518
12657 12657 12657 060 248501801 152 Fairlawn Dr 152 FAIRLAWN DR 152 FAIRLAWN DR 152.0 FAIRLAWN DR     Berkeley 94708 37.8854150190583 -122.25108977521762
13555 13555 13555 060 248703700 209 Fairlawn Dr 209 FAIRLAWN DR 209 FAIRLAWN DR 209.0 FAIRLAWN DR     Berkeley 94708 37.88448976427967 -122.25004758485927
13798 13798 13798 060 248501500 130 Fairlawn Dr 130 FAIRLAWN DR 130 FAIRLAWN DR 130.0 FAIRLAWN DR     Berkeley 94708 37.88573425169896 -122.25143860900876
13850 13850 13850 060 248602100 59 Fairlawn Dr 59 FAIRLAWN DR 59 FAIRLAWN DR 59.0 FAIRLAWN DR     Berkeley 94708 37.887750416960216 -122.25291710930397
14293 14293 14293 060 248704900 151 Fairlawn Dr 151 FAIRLAWN DR 151 FAIRLAWN DR 151.0 FAIRLAWN DR     Berkeley 94708 37.88569373752516 -122.25070682251368
14539 14539 14539 060 248704000 195 Fairlawn Dr 195 FAIRLAWN DR 195 FAIRLAWN DR 195.0 FAIRLAWN DR     Berkeley 94708 37.884848381913514 -122.25001678072988
16578 16578 16578 060 248703500 221 Fairlawn Dr 221 FAIRLAWN DR 221 FAIRLAWN DR 221.0 FAIRLAWN DR     Berkeley 94708 37.88426402255516 -122.24990315013464
16640 16640 16640 060 248501001 100 Fairlawn Dr 100 FAIRLAWN DR 100 FAIRLAWN DR 100.0 FAIRLAWN DR     Berkeley 94708 37.88621745296882 -122.25204825426958
16941 16941 16941 060 248705300 125 Fairlawn Dr 125 FAIRLAWN DR 125 FAIRLAWN DR 125.0 FAIRLAWN DR     Berkeley 94708 37.886072526172 -122.25111395696676
18844 18844 18844 060 248500900 98 Fairlawn Dr 98 FAIRLAWN DR 98 FAIRLAWN DR 98.0 FAIRLAWN DR     Berkeley 94708 37.88635402205179 -122.25217279939554
19253 19253 19253 060 248506600 28 Fairlawn Dr 28 FAIRLAWN DR 28 FAIRLAWN DR 28.0 FAIRLAWN DR     Berkeley 94708 37.88661658154908 -122.2527818661413
20470 20470 20470 060 248704800 157 Fairlawn Dr 157 FAIRLAWN DR 157 FAIRLAWN DR 157.0 FAIRLAWN DR     Berkeley 94708 37.88562476539686 -122.25052364884074
20975 20975 20975 060 248500200 78 Fairlawn Dr 78 FAIRLAWN DR 78 FAIRLAWN DR 78.0 FAIRLAWN DR     Berkeley 94708 37.88739614099816 -122.25261264060975
21598 21598 21598 060 248704400 175 Fairlawn Dr 175 FAIRLAWN DR 175 FAIRLAWN DR 175.0 FAIRLAWN DR     Berkeley 94708 37.88538355067509 -122.2498779164583
21687 21687 21687 060 249001600 293 Fairlawn Dr 293 FAIRLAWN DR 293 FAIRLAWN DR 293.0 FAIRLAWN DR     Berkeley 94708 37.882223789251135 -122.25029154393428
22646 22646 22646 060 248502903 188 Fairlawn Dr 188 FAIRLAWN DR 188 FAIRLAWN DR 188.0 FAIRLAWN DR     Berkeley 94708 37.88497681431981 -122.25041703049462
23171 23171 23171 060 248602800 37 Fairlawn Dr 37 FAIRLAWN DR 37 FAIRLAWN DR 37.0 FAIRLAWN DR     Berkeley 94708 37.88680834844869 -122.2533120931445
24097 24097 24097 060 249001700 285 Fairlawn Dr 285 FAIRLAWN DR 285 FAIRLAWN DR 285.0 FAIRLAWN DR     Berkeley 94708 37.88239931624153 -122.25031024865513
24983 24983 24983 060 248704600 169 Fairlawn Dr 169 FAIRLAWN DR 169 FAIRLAWN DR 169.0 FAIRLAWN DR     Berkeley 94708 37.88555189023928 -122.25019023283484
25059 25059 25059 060 248500600 88 Fairlawn Dr 88 FAIRLAWN DR 88 FAIRLAWN DR 88.0 FAIRLAWN DR     Berkeley 94708 37.88678235181021 -122.25246693566731
25403 25403 25403 060 248503300 210 Fairlawn Dr 210 FAIRLAWN DR 210 FAIRLAWN DR 210.0 FAIRLAWN DR     Berkeley 94708 37.88446917291619 -122.2505679501573
25797 25797 25797 060 248601800 67 Fairlawn Dr 2 67 FAIRLAWN DR 2 67 FAIRLAWN DR 67.0 FAIRLAWN DR 2   Berkeley 94708 37.88764294782631 -122.25233252793788
26112 26112 26112 060 248601500 75 Fairlawn Dr 75 FAIRLAWN DR 75 FAIRLAWN DR 75.0 FAIRLAWN DR     Berkeley 94708 37.88719103636678 -122.25213413860064
28135 28135 28135 060 248602900 33 Fairlawn Dr 33 FAIRLAWN DR 33 FAIRLAWN DR 33.0 FAIRLAWN DR     Berkeley 94708 37.88665012528371 -122.25327802004576
28205 28205 28205 060 248603100 21 Fairlawn Dr 21 FAIRLAWN DR 21 FAIRLAWN DR 21.0 FAIRLAWN DR     Berkeley 94708 37.886367150190694 -122.25320137039586
28258 28258 28258 060 248601100 93 Fairlawn Dr 93 FAIRLAWN DR 93 FAIRLAWN DR 93.0 FAIRLAWN DR     Berkeley 94708 37.886690322728754 -122.25187918145164
28663 28663 28663 060 248502800 180 Fairlawn Dr 180 FAIRLAWN DR 180 FAIRLAWN DR 180.0 FAIRLAWN DR     Berkeley 94708 37.88520455462564 -122.25037027138744
30699 30699 30699 060 248501700 144 Fairlawn Dr 144 FAIRLAWN DR 144 FAIRLAWN DR 144.0 FAIRLAWN DR     Berkeley 94708 37.885539096596226 -122.2512451262696
31260 31260 31260 060 248601800 67 Fairlawn Dr 67 FAIRLAWN DR 67 FAIRLAWN DR 67.0 FAIRLAWN DR     Berkeley 94708 37.88764294782631 -122.25233252793788
31924 31924 31924 060 248503800 230 Fairlawn Dr 230 FAIRLAWN DR 230 FAIRLAWN DR 230.0 FAIRLAWN DR     Berkeley 94708 37.88382539265627 -122.25036864543677
31952 31952 31952 060 248500700 90 Fairlawn Dr 90 FAIRLAWN DR 90 FAIRLAWN DR 90.0 FAIRLAWN DR     Berkeley 94708 37.88665084631113 -122.25239706290787
32148 32148 32148 060 248601700 69 Fairlawn Dr 69 FAIRLAWN DR 69 FAIRLAWN DR 69.0 FAIRLAWN DR     Berkeley 94708 37.88749276117514 -122.25224086384628
32455 32455 32455 060 248705000 141 Fairlawn Dr 141 FAIRLAWN DR 141 FAIRLAWN DR 141.0 FAIRLAWN DR     Berkeley 94708 37.88577600373525 -122.2508197641011
32818 32818 32818 060 248501201 116 Fairlawn Dr 116 FAIRLAWN DR 116 FAIRLAWN DR 116.0 FAIRLAWN DR     Berkeley 94708 37.88601922075159 -122.251749727931
34011 34011 34011 060 248705200 131 Fairlawn Dr 131 FAIRLAWN DR 131 FAIRLAWN DR 131.0 FAIRLAWN DR     Berkeley 94708 37.88597816010997 -122.25101198830056
34679 34679 34679 060 248603203 17 Fairlawn Dr 17 FAIRLAWN DR 17 FAIRLAWN DR 17.0 FAIRLAWN DR     Berkeley 94708 37.88623238690131 -122.25313647340478
37107 37107 37107 060 248703900 199 Fairlawn Dr 199 FAIRLAWN DR 199 FAIRLAWN DR 199.0 FAIRLAWN DR     Berkeley 94708 37.88473054518928 -122.250054251257
38095 38095 38095 060 248705100 137 Fairlawn Dr 137 FAIRLAWN DR 137 FAIRLAWN DR 137.0 FAIRLAWN DR     Berkeley 94708 37.88588226819729 -122.25091699595085
38160 38160 38160 060 248902700 251 Fairlawn Dr 251 FAIRLAWN DR 251 FAIRLAWN DR 251.0 FAIRLAWN DR     Berkeley 94708 37.88315844417448 -122.25014439000928
38749 38749 38749 060 248401400 280 Fairlawn Dr 280 FAIRLAWN DR 280 FAIRLAWN DR 280.0 FAIRLAWN DR     Berkeley 94708 37.88259758372778 -122.25073793835853
39680 39680 39680 060 248501600 140 Fairlawn Dr 140 FAIRLAWN DR 140 FAIRLAWN DR 140.0 FAIRLAWN DR     Berkeley 94708 37.88563653312433 -122.25134281715846
41971 41971 41971 060 248602600 43 Fairlawn Dr 43 FAIRLAWN DR 43 FAIRLAWN DR 43.0 FAIRLAWN DR     Berkeley 94708 37.88717413665553 -122.25332768250796
42375 42375 42375 060 248704200 183 Fairlawn Dr 183 FAIRLAWN DR 183 FAIRLAWN DR 183.0 FAIRLAWN DR     Berkeley 94708 37.885097144876106 -122.2498612949306
43199 43199 43199 060 248603400 13 Fairlawn Dr 13 FAIRLAWN DR 13 FAIRLAWN DR 13.0 FAIRLAWN DR     Berkeley 94708 37.88592052841402 -122.25293948454106
43966 43966 43966 060 248602700 41 Fairlawn Dr 41 FAIRLAWN DR 41 FAIRLAWN DR 41.0 FAIRLAWN DR     Berkeley 94708 37.88697688893957 -122.25333974957717
45058 45058 45058 060 248506401 96 Fairlawn Dr 96 FAIRLAWN DR 96 FAIRLAWN DR 96.0 FAIRLAWN DR     Berkeley 94708 37.88629628713918 -122.25259131729987
46328 46328 46328 060 248501100 110 Fairlawn Dr 110 FAIRLAWN DR 110 FAIRLAWN DR 110.0 FAIRLAWN DR     Berkeley 94708 37.886128747588046 -122.25181995911824
46508 46508 46508 060 248703400 225 Fairlawn Dr 225 FAIRLAWN DR 225 FAIRLAWN DR 225.0 FAIRLAWN DR     Berkeley 94708 37.88414169338736 -122.24985888025914
46753 46753 46753 060 248400802 256 Fairlawn Dr 256 FAIRLAWN DR 256 FAIRLAWN DR 256.0 FAIRLAWN DR     Berkeley 94708 37.883206021463224 -122.25055401099904
46836 46836 46836 060 248602000 61 Fairlawn Dr 61 FAIRLAWN DR 61 FAIRLAWN DR 61.0 FAIRLAWN DR     Berkeley 94708 37.88776108403564 -122.25264073721692
47754 47754 47754 060 248603500 9 Fairlawn Dr 9 FAIRLAWN DR 9 FAIRLAWN DR 9.0 FAIRLAWN DR     Berkeley 94708 37.88581776567365 -122.25284333875452
47853 47853 47853 060 248601900 63 Fairlawn Dr 63 FAIRLAWN DR 63 FAIRLAWN DR 63.0 FAIRLAWN DR     Berkeley 94708 37.88776820274437 -122.25245057285444
48949 48949 48949 060 248705500 115 Fairlawn Dr 115 FAIRLAWN DR 115 FAIRLAWN DR 115.0 FAIRLAWN DR     Berkeley 94708 37.886242555784534 -122.25130990827633
50280 50280 50280 060 248603000 29 Fairlawn Dr 29 FAIRLAWN DR 29 FAIRLAWN DR 29.0 FAIRLAWN DR     Berkeley 94708 37.886505052580375 -122.25324343400902
50775 50775 50775 060 248601300 85 Fairlawn Dr 85 FAIRLAWN DR 85 FAIRLAWN DR 85.0 FAIRLAWN DR     Berkeley 94708 37.88693661791788 -122.25202330176596
51081 51081 51081 060 248602300 53 Fairlawn Dr 53 FAIRLAWN DR 53 FAIRLAWN DR 53.0 FAIRLAWN DR     Berkeley 94708 37.88761531093617 -122.25322705143316
51843 51843 51843 060 248401600 288 Fairlawn Dr 288 FAIRLAWN DR 288 FAIRLAWN DR 288.0 FAIRLAWN DR     Berkeley 94708 37.88227833110844 -122.25074601241629
52008 52008 52008 060 248704100 189 Fairlawn Dr 189 FAIRLAWN DR 189 FAIRLAWN DR 189.0 FAIRLAWN DR     Berkeley 94708 37.88496706498447 -122.24995480775506
52014 52014 52014 060 248401500 284 Fairlawn Dr 284 FAIRLAWN DR 284 FAIRLAWN DR 284.0 FAIRLAWN DR     Berkeley 94708 37.88244279165793 -122.25073001881098
52183 52183 52183 060 248601600 71 Fairlawn Dr 71 FAIRLAWN DR 71 FAIRLAWN DR 71.0 FAIRLAWN DR     Berkeley 94708 37.88732800279324 -122.25218491407544
53265 53265 53265 060 248703600 215 Fairlawn Dr 215 FAIRLAWN DR 215 FAIRLAWN DR 215.0 FAIRLAWN DR     Berkeley 94708 37.884376783609405 -122.24998058940372
53748 53748 53748 060 248705400 123 Fairlawn Dr 123 FAIRLAWN DR 123 FAIRLAWN DR 123.0 FAIRLAWN DR     Berkeley 94708 37.88616847597327 -122.25120892146872
53850 53850 53850 060 248703800 205 Fairlawn Dr 205 FAIRLAWN DR 205 FAIRLAWN DR 205.0 FAIRLAWN DR     Berkeley 94708 37.88460978721928 -122.25007091590383
54163 54163 54163 060 248500500 84 Fairlawn Dr 84 FAIRLAWN DR 84 FAIRLAWN DR 84.0 FAIRLAWN DR     Berkeley 94708 37.88690820798278 -122.25251946734852
54271 54271 54271 060 248503200 206 Fairlawn Dr 206 FAIRLAWN DR 206 FAIRLAWN DR 206.0 FAIRLAWN DR     Berkeley 94708 37.8846215692888 -122.25062795043176
55463 55463 55463 060 248601800 67 Fairlawn Dr 1 67 FAIRLAWN DR 1 67 FAIRLAWN DR 67.0 FAIRLAWN DR 1   Berkeley 94708 37.88764294782631 -122.25233252793788
55480 55480 55480 060 248703300 231 Fairlawn Dr 231 FAIRLAWN DR 231 FAIRLAWN DR 231.0 FAIRLAWN DR     Berkeley 94708 37.88402336348624 -122.24982599922478
56032 56032 56032 060 248705600 111 Fairlawn Dr 111 FAIRLAWN DR 111 FAIRLAWN DR 111.0 FAIRLAWN DR     Berkeley 94708 37.88634944772754 -122.25140828457972
56088 56088 56088 060 248500400 82 Fairlawn Dr 82 FAIRLAWN DR 82 FAIRLAWN DR 82.0 FAIRLAWN DR     Berkeley 94708 37.887049000542994 -122.25255283616804
57471 57471 57471 060 248704300 179 Fairlawn Dr 179 FAIRLAWN DR 179 FAIRLAWN DR 179.0 FAIRLAWN DR     Berkeley 94708 37.88525101748083 -122.24980116350214
58182 58182 58182 060 248507000 44 Fairlawn Dr 44 FAIRLAWN DR 44 FAIRLAWN DR 44.0 FAIRLAWN DR     Berkeley 94708 37.88718110157455 -122.25288580391462

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