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

39 rows where street_name = "THE PLAZA" and street_type = "DR"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • THE PLAZA · 39 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1100 1100 1100 064 424500700 80 The Plaza Dr 80 THE PLAZA DR 80 THE PLAZA DR 80.0 THE PLAZA DR     Berkeley 94705 37.85480988927242 -122.24306734991156
3171 3171 3171 064 424201800 87 The Plaza Dr 87 THE PLAZA DR 87 THE PLAZA DR 87.0 THE PLAZA DR     Berkeley 94705 37.85530976634374 -122.24236693078956
6982 6982 6982 064 424501100 106 The Plaza Dr 106 THE PLAZA DR 106 THE PLAZA DR 106.0 THE PLAZA DR     Berkeley 94705 37.85451875567489 -122.242519721643
7913 7913 7913 064 424500300 60 The Plaza Dr 60 THE PLAZA DR 60 THE PLAZA DR 60.0 THE PLAZA DR     Berkeley 94705 37.854762566008624 -122.24391839045552
8056 8056 8056 064 424202000 81 The Plaza Dr 81 THE PLAZA DR 81 THE PLAZA DR 81.0 THE PLAZA DR     Berkeley 94705 37.85528752272027 -122.24281974637148
8796 8796 8796 064 424401700 99 The Plaza Dr 99 THE PLAZA DR 99 THE PLAZA DR 99.0 THE PLAZA DR     Berkeley 94705 37.854979971186495 -122.24204939250632
9170 9170 9170 064 424202100 77 The Plaza Dr 77 THE PLAZA DR 77 THE PLAZA DR 77.0 THE PLAZA DR     Berkeley 94705 37.85528075976652 -122.2429951612953
10969 10969 10969 064 424201900 85 The Plaza Dr 85 THE PLAZA DR 85 THE PLAZA DR 85.0 THE PLAZA DR     Berkeley 94705 37.8552911152067 -122.2426110578495
11311 11311 11311 064 424201700 95 The Plaza Dr 95 THE PLAZA DR 95 THE PLAZA DR 95.0 THE PLAZA DR     Berkeley 94705 37.85516853365431 -122.24222937356674
11525 11525 11525 064 424501000 96 The Plaza Dr 96 THE PLAZA DR 96 THE PLAZA DR 96.0 THE PLAZA DR     Berkeley 94705 37.85483146489725 -122.24254331679224
11934 11934 11934 064 424500601 72 The Plaza Dr 72 THE PLAZA DR 72 THE PLAZA DR 72.0 THE PLAZA DR     Berkeley 94705 37.85479189905918 -122.243402895823
12166 12166 12166 064 424000500 45 The Plaza Dr 45 THE PLAZA DR 45 THE PLAZA DR 45.0 THE PLAZA DR     Berkeley 94705 37.85522544679657 -122.24437010380456
15181 15181 15181 064 424000600 41 The Plaza Dr 41 THE PLAZA DR 41 THE PLAZA DR 41.0 THE PLAZA DR     Berkeley 94705 37.85521596233981 -122.24454045582348
15651 15651 15651 064 424001000 25 The Plaza Dr 25 THE PLAZA DR 25 THE PLAZA DR 25.0 THE PLAZA DR     Berkeley 94705 37.855173520586746 -122.24523931097852
16068 16068 16068 064 424500800 84 The Plaza Dr 84 THE PLAZA DR 84 THE PLAZA DR 84.0 THE PLAZA DR     Berkeley 94705 37.85482160163364 -122.2428943730154
16824 16824 16824 064 424001100 21 The Plaza Dr 21 THE PLAZA DR 21 THE PLAZA DR 21.0 THE PLAZA DR     Berkeley 94705 37.85516403825114 -122.24541134644028
16999 16999 16999 064 424000400 49 The Plaza Dr 49 THE PLAZA DR 49 THE PLAZA DR 49.0 THE PLAZA DR     Berkeley 94705 37.85523586537019 -122.24419539585486
18155 18155 18155 064 424500200 56 The Plaza Dr 56 THE PLAZA DR 56 THE PLAZA DR 56.0 THE PLAZA DR     Berkeley 94705 37.85475238568683 -122.24408873708455
18347 18347 18347 064 424500900 88 The Plaza Dr 88 THE PLAZA DR 88 THE PLAZA DR 88.0 THE PLAZA DR     Berkeley 94705 37.85483340690882 -122.2427187793268
19523 19523 19523 064 424000200 59 The Plaza Dr 59 THE PLAZA DR 59 THE PLAZA DR 59.0 THE PLAZA DR     Berkeley 94705 37.85525570243242 -122.24383219710404
19802 19802 19802 064 424500602 76 The Plaza Dr 76 THE PLAZA DR 76 THE PLAZA DR 76.0 THE PLAZA DR     Berkeley 94705 37.85480143889448 -122.24323250427824
20519 20519 20519 064 424602000 28 The Plaza Dr 28 THE PLAZA DR 28 THE PLAZA DR 28.0 THE PLAZA DR     Berkeley 94705 37.85468098650331 -122.24536194808282
21098 21098 21098 064 424602200 36 The Plaza Dr 36 THE PLAZA DR 36 THE PLAZA DR 36.0 THE PLAZA DR     Berkeley 94705 37.85470084570262 -122.24501332180252
23242 23242 23242 064 424601601 12 The Plaza Dr 12 THE PLAZA DR 12 THE PLAZA DR 12.0 THE PLAZA DR     Berkeley 94705 37.854650185193144 -122.245861830894
23688 23688 23688 064 424001300 9 The Plaza Dr 9 THE PLAZA DR 9 THE PLAZA DR 9.0 THE PLAZA DR     Berkeley 94705 37.85514221660413 -122.2457590214047
24554 24554 24554 064 424000300 53 The Plaza Dr 53 THE PLAZA DR 53 THE PLAZA DR 53.0 THE PLAZA DR     Berkeley 94705 37.85524454195775 -122.24404056223248
25777 25777 25777 064 424602100 32 The Plaza Dr 32 THE PLAZA DR 32 THE PLAZA DR 32.0 THE PLAZA DR     Berkeley 94705 37.85469150799984 -122.24519328130336
34282 34282 34282 064 424401500 103 The Plaza Dr 103 THE PLAZA DR 103 THE PLAZA DR 103.0 THE PLAZA DR     Berkeley 94705 37.85463843946834 -122.24190711284004
35571 35571 35571 064 424601900 24 The Plaza Dr 24 THE PLAZA DR 24 THE PLAZA DR 24.0 THE PLAZA DR     Berkeley 94705 37.85467087284284 -122.24553488904635
40844 40844 40844 064 424000800 37 The Plaza Dr 37 THE PLAZA DR 37 THE PLAZA DR 37.0 THE PLAZA DR     Berkeley 94705 37.85519499184134 -122.24488817570364
44874 44874 44874 064 424401600 101 The Plaza Dr 101 THE PLAZA DR 101 THE PLAZA DR 101.0 THE PLAZA DR     Berkeley 94705 37.85478839166222 -122.24197294138408
45675 45675 45675 064 424500500 68 The Plaza Dr 68 THE PLAZA DR 68 THE PLAZA DR 68.0 THE PLAZA DR     Berkeley 94705 37.85478143361027 -122.2435732128076
47103 47103 47103 064 424601500 6 The Plaza Dr 6 THE PLAZA DR 6 THE PLAZA DR 6.0 THE PLAZA DR     Berkeley 94705 37.85463891752505 -122.24605810469876
51763 51763 51763 064 424000900 29 The Plaza Dr 29 THE PLAZA DR 29 THE PLAZA DR 29.0 THE PLAZA DR     Berkeley 94705 37.85518443708064 -122.24506458236758
52153 52153 52153 064 424001400 1 The Plaza Dr 1 THE PLAZA DR 1 THE PLAZA DR 1.0 THE PLAZA DR     Berkeley 94705 37.855124974760614 -122.24604136459344
52237 52237 52237 064 424600100 42 The Plaza Dr 42 THE PLAZA DR 42 THE PLAZA DR 42.0 THE PLAZA DR     Berkeley 94705 37.85478779728429 -122.24474861703438
54341 54341 54341 064 424001200 17 The Plaza Dr 17 THE PLAZA DR 17 THE PLAZA DR 17.0 THE PLAZA DR     Berkeley 94705 37.85515325438919 -122.24558438711684
56968 56968 56968 064 424500400 64 The Plaza Dr 64 THE PLAZA DR 64 THE PLAZA DR 64.0 THE PLAZA DR     Berkeley 94705 37.85477288180178 -122.24374454848174
57731 57731 57731 064 424202200 73 The Plaza Dr 73 THE PLAZA DR 73 THE PLAZA DR 73.0 THE PLAZA DR     Berkeley 94705 37.85527145121757 -122.24316218864936

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