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

72 rows where street_name = "THE UPLANDS" and zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94705 · 72 ✖

street_name 1

  • THE UPLANDS · 72 ✖

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
1496 1496 1496 064 423202000 239 The Uplands 239 THE UPLANDS 239 THE UPLANDS 239.0 THE UPLANDS       Berkeley 94705 37.85358055763121 -122.2396755162146
1915 1915 1915 064 425102000 70 The Uplands 70 THE UPLANDS 70 THE UPLANDS 70.0 THE UPLANDS       Berkeley 94705 37.85352115005176 -122.24519125290747
2769 2769 2769 064 425503800 230 The Uplands 230 THE UPLANDS 230 THE UPLANDS 230.0 THE UPLANDS       Berkeley 94705 37.85340319228664 -122.23901771047476
5717 5717 5717 064 425102400 92 The Uplands 92 THE UPLANDS 92 THE UPLANDS 92.0 THE UPLANDS       Berkeley 94705 37.85368659475026 -122.2442793290451
6743 6743 6743 064 424700400 18 The Uplands 18 THE UPLANDS 18 THE UPLANDS 18.0 THE UPLANDS       Berkeley 94705 37.85403799424789 -122.2474314356304
8813 8813 8813 064 425000400 38 The Uplands 38 THE UPLANDS 38 THE UPLANDS 38.0 THE UPLANDS       Berkeley 94705 37.853604823963835 -122.24655977246243
9364 9364 9364 064 425503700 226 The Uplands 226 THE UPLANDS 226 THE UPLANDS 226.0 THE UPLANDS       Berkeley 94705 37.85328831196794 -122.2394592324369
9752 9752 9752 064 425001000 64 The Uplands 64 THE UPLANDS 64 THE UPLANDS 64.0 THE UPLANDS       Berkeley 94705 37.85351375779235 -122.24546771662268
9780 9780 9780 064 424700300 14 The Uplands 14 THE UPLANDS 14 THE UPLANDS 14.0 THE UPLANDS       Berkeley 94705 37.85406104754664 -122.24763457885211
10107 10107 10107 064 425000200 30 The Uplands 30 THE UPLANDS 30 THE UPLANDS 30.0 THE UPLANDS       Berkeley 94705 37.85380505353068 -122.24689843732456
10290 10290 10290 064 425503202 250 The Uplands 250 THE UPLANDS 250 THE UPLANDS 250.0 THE UPLANDS       Berkeley 94705 37.85408369441592 -122.2389069697598
11530 11530 11530 064 425000600 50 The Uplands 50 THE UPLANDS 50 THE UPLANDS 50.0 THE UPLANDS       Berkeley 94705 37.85355713747757 -122.24621358600643
11626 11626 11626 064 425503600 260 The Uplands 260 THE UPLANDS 260 THE UPLANDS 260.0 THE UPLANDS       Berkeley 94705 37.854775379891755 -122.2386093084988
11872 11872 11872 064 425103500 138 The Uplands 138 THE UPLANDS 138 THE UPLANDS 138.0 THE UPLANDS       Berkeley 94705 37.853051496113736 -122.24241063382816
12485 12485 12485 064 424403200 211 The Uplands 211 THE UPLANDS 211 THE UPLANDS 211.0 THE UPLANDS       Berkeley 94705 37.85349119231681 -122.24052829859193
14267 14267 14267 064 425102200 84 The Uplands 84 THE UPLANDS 84 THE UPLANDS 84.0 THE UPLANDS       Berkeley 94705 37.8535962074732 -122.24469349910346
14314 14314 14314 064 425102300 90 The Uplands 90 THE UPLANDS 90 THE UPLANDS 90.0 THE UPLANDS       Berkeley 94705 37.853606929145144 -122.24445950503996
14744 14744 14744 064 425503100 240 The Uplands 240 THE UPLANDS 240 THE UPLANDS 240.0 THE UPLANDS       Berkeley 94705 37.85370161968356 -122.23914475022224
14960 14960 14960 064 424403900 151 The Uplands 151 THE UPLANDS 151 THE UPLANDS 151.0 THE UPLANDS       Berkeley 94705 37.853143105468675 -122.24187149733396
15032 15032 15032 064 425900500 210 The Uplands 210 THE UPLANDS 210 THE UPLANDS 210.0 THE UPLANDS       Berkeley 94705 37.85314270187847 -122.24055957972672
15998 15998 15998 064 424403500 199 The Uplands 199 THE UPLANDS 199 THE UPLANDS 199.0 THE UPLANDS       Berkeley 94705 37.8534563879617 -122.2411958824936
16243 16243 16243 064 425102500 98 The Uplands 98 THE UPLANDS 98 THE UPLANDS 98.0 THE UPLANDS       Berkeley 94705 37.85361159132711 -122.24411749485174
17260 17260 17260 064 425000500 42 The Uplands 42 THE UPLANDS 42 THE UPLANDS 42.0 THE UPLANDS       Berkeley 94705 37.85357229436576 -122.24638785288336
17490 17490 17490 064 424403800 175 The Uplands 175 THE UPLANDS 175 THE UPLANDS 175.0 THE UPLANDS       Berkeley 94705 37.85323389901882 -122.24171444936442
17946 17946 17946 064 425900200 190 The Uplands 190 THE UPLANDS 190 THE UPLANDS 190.0 THE UPLANDS       Berkeley 94705 37.85289415728636 -122.24135144375136
18349 18349 18349 064 424404100 135 The Uplands 135 THE UPLANDS 135 THE UPLANDS 135.0 THE UPLANDS       Berkeley 94705 37.85342459809244 -122.24205956053704
18365 18365 18365 064 425000800 56 The Uplands 56 THE UPLANDS 56 THE UPLANDS 56.0 THE UPLANDS       Berkeley 94705 37.85353565439727 -122.24587088860704
18394 18394 18394 064 425103302 130 The Uplands 130 THE UPLANDS 130 THE UPLANDS 130.0 THE UPLANDS       Berkeley 94705 37.85317544800171 -122.24275716883048
19308 19308 19308 064 425102800 110 The Uplands 110 THE UPLANDS 110 THE UPLANDS 110.0 THE UPLANDS       Berkeley 94705 37.85361245169928 -122.24359937444363
19314 19314 19314 064 423201300 295 The Uplands 295 THE UPLANDS 295 THE UPLANDS 295.0 THE UPLANDS       Berkeley 94705 37.85482143778967 -122.2400428499107
22285 22285 22285 064 425102700 106 The Uplands 106 THE UPLANDS 106 THE UPLANDS 106.0 THE UPLANDS       Berkeley 94705 37.853613226956355 -122.24377111076636
22957 22957 22957 064 423900900 9 The Uplands 9 THE UPLANDS 9 THE UPLANDS 9.0 THE UPLANDS       Berkeley 94705 37.85455094652694 -122.24727244101162
23567 23567 23567 064 425000100 26 The Uplands 26 THE UPLANDS 26 THE UPLANDS 26.0 THE UPLANDS       Berkeley 94705 37.85395093326054 -122.24710631107456
25314 25314 25314 064 424700200 4 The Uplands 4 THE UPLANDS 4 THE UPLANDS 4.0 THE UPLANDS       Berkeley 94705 37.8540812225462 -122.24785972630671
25627 25627 25627 064 423202100 221 The Uplands 221 THE UPLANDS 221 THE UPLANDS 221.0 THE UPLANDS       Berkeley 94705 37.85356231744679 -122.24007342407138
26184 26184 26184 064 424404000 147 The Uplands 147 THE UPLANDS 147 THE UPLANDS 147.0 THE UPLANDS       Berkeley 94705 37.85329337208502 -122.24194660188162
26306 26306 26306 064 425900300 200 The Uplands 200 THE UPLANDS 200 THE UPLANDS 200.0 THE UPLANDS       Berkeley 94705 37.85295186305307 -122.24108106971548
26469 26469 26469 064 423201000 299 The Uplands 299 THE UPLANDS 299 THE UPLANDS 299.0 THE UPLANDS       Berkeley 94705 37.854907999124954 -122.2395204750814
27910 27910 27910 064 424403300 205 The Uplands 205 THE UPLANDS 205 THE UPLANDS 205.0 THE UPLANDS       Berkeley 94705 37.85350147636963 -122.24083950734568
28507 28507 28507 064 423201900 241 The Uplands 241 THE UPLANDS 241 THE UPLANDS 241.0 THE UPLANDS       Berkeley 94705 37.85382487324562 -122.23965125092217
28650 28650 28650 064 423201400 291 The Uplands 291 THE UPLANDS 291 THE UPLANDS 291.0 THE UPLANDS       Berkeley 94705 37.85448378866945 -122.23986791289056
29011 29011 29011 064 425102100 78 The Uplands 78 THE UPLANDS 78 THE UPLANDS 78.0 THE UPLANDS       Berkeley 94705 37.85355748148486 -122.24495987743302
29150 29150 29150 064 425503201 248 The Uplands 248 THE UPLANDS 248 THE UPLANDS 248.0 THE UPLANDS       Berkeley 94705 37.853693011006435 -122.238907491681
29165 29165 29165 064 425103000 118 The Uplands 118 THE UPLANDS 118 THE UPLANDS 118.0 THE UPLANDS       Berkeley 94705 37.85353159652864 -122.24326009513383
29251 29251 29251 064 425900400 206 The Uplands 206 THE UPLANDS 206 THE UPLANDS 206.0 THE UPLANDS       Berkeley 94705 37.85301580563715 -122.24085959457376
29603 29603 29603 064 423201700 255 The Uplands 255 THE UPLANDS 255 THE UPLANDS 255.0 THE UPLANDS       Berkeley 94705 37.85428692225412 -122.23961542251534
31052 31052 31052 064 425102900 116 The Uplands 116 THE UPLANDS 116 THE UPLANDS 116.0 THE UPLANDS       Berkeley 94705 37.85359392993343 -122.24342496293797
33034 33034 33034 064 423202203 223 The Uplands 223 THE UPLANDS 223 THE UPLANDS 223.0 THE UPLANDS       Berkeley 94705 37.853750977876416 -122.24000165676505
33436 33436 33436 064 425103100 122 The Uplands 122 THE UPLANDS 122 THE UPLANDS 122.0 THE UPLANDS       Berkeley 94705 37.85336570107983 -122.24309713804638
34002 34002 34002 064 423201801 249 The Uplands 249 THE UPLANDS 249 THE UPLANDS 249.0 THE UPLANDS       Berkeley 94705 37.85406486493728 -122.23975648316778
34353 34353 34353 064 425503203 252 The Uplands 252 THE UPLANDS 252 THE UPLANDS 252.0 THE UPLANDS       Berkeley 94705 37.85433093629524 -122.2386495260741
37711 37711 37711 064 425500100 284 The Uplands 284 THE UPLANDS 284 THE UPLANDS 284.0 THE UPLANDS       Berkeley 94705 37.855009831854474 -122.23888734785902
37916 37916 37916 064 424403700 185 The Uplands 185 THE UPLANDS 185 THE UPLANDS 185.0 THE UPLANDS       Berkeley 94705 37.85336234753205 -122.24156663966929
38334 38334 38334 064 423901000 5 The Uplands 5 THE UPLANDS 5 THE UPLANDS 5.0 THE UPLANDS       Berkeley 94705 37.85457770992755 -122.2476786295387
39023 39023 39023 064 425103200 126 The Uplands 126 THE UPLANDS 126 THE UPLANDS 126.0 THE UPLANDS       Berkeley 94705 37.85323448844417 -122.24293173664302
39712 39712 39712 064 425000700 52 The Uplands 52 THE UPLANDS 52 THE UPLANDS 52.0 THE UPLANDS       Berkeley 94705 37.85354639239173 -122.2460444287469
40121 40121 40121 064 425100100 140 The Uplands 140 THE UPLANDS 140 THE UPLANDS 140.0 THE UPLANDS       Berkeley 94705 37.85295097784772 -122.24218217159014
42833 42833 42833 064 425000300 34 The Uplands 34 THE UPLANDS 34 THE UPLANDS 34.0 THE UPLANDS       Berkeley 94705 37.85375029837518 -122.24672778886162
43229 43229 43229 064 423201600 285 The Uplands 285 THE UPLANDS 285 THE UPLANDS 285.0 THE UPLANDS       Berkeley 94705 37.8543863322135 -122.23921501644378
44102 44102 44102 064 425503302 256 The Uplands 256 THE UPLANDS 256 THE UPLANDS 256.0 THE UPLANDS       Berkeley 94705 37.854550854320074 -122.2384348772302
44263 44263 44263 064 423201500 287 The Uplands 287 THE UPLANDS 287 THE UPLANDS 287.0 THE UPLANDS       Berkeley 94705 37.85462258628332 -122.23945905187551
44563 44563 44563 064 425102400 94 The Uplands 94 THE UPLANDS 94 THE UPLANDS 94.0 THE UPLANDS       Berkeley 94705 37.85361016635777 -122.24428805707642
44942 44942 44942 064 425502900 220 The Uplands 220 THE UPLANDS 220 THE UPLANDS 220.0 THE UPLANDS       Berkeley 94705 37.85320608324333 -122.2399477174238
46670 46670 46670 064 425102600 102 The Uplands 102 THE UPLANDS 102 THE UPLANDS 102.0 THE UPLANDS       Berkeley 94705 37.85361228075973 -122.24394258927263
48055 48055 48055 064 423200900 305 The Uplands 305 THE UPLANDS 305 THE UPLANDS 305.0 THE UPLANDS       Berkeley 94705 37.85503064920137 -122.23965921269053
49438 49438 49438 064 424700500 22 The Uplands 22 THE UPLANDS 22 THE UPLANDS 22.0 THE UPLANDS       Berkeley 94705 37.85401755325314 -122.24725288199296
49534 49534 49534 064 424403400 201 The Uplands 201 THE UPLANDS 201 THE UPLANDS 201.0 THE UPLANDS       Berkeley 94705 37.853502868713534 -122.24103202798916
49634 49634 49634 064 425000900 60 The Uplands 60 THE UPLANDS 60 THE UPLANDS 60.0 THE UPLANDS       Berkeley 94705 37.85352294811127 -122.24568111860496
50424 50424 50424 064 425103400 134 The Uplands 134 THE UPLANDS 134 THE UPLANDS 134.0 THE UPLANDS       Berkeley 94705 37.853108104473776 -122.2425838496762
50554 50554 50554 064 424700100 2 The Uplands 2 THE UPLANDS 2 THE UPLANDS 2.0 THE UPLANDS       Berkeley 94705 37.854171341827254 -122.2481399557596
51516 51516 51516 064 424403600 195 The Uplands 195 THE UPLANDS 195 THE UPLANDS 195.0 THE UPLANDS       Berkeley 94705 37.853427640257024 -122.24135862578208
52220 52220 52220 064 425900101 160 The Uplands 160 THE UPLANDS 160 THE UPLANDS 160.0 THE UPLANDS       Berkeley 94705 37.852783764630075 -122.2416463112518

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