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

26 rows where street_name = "MENLO" and street_type = "PL"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • MENLO · 26 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
2028 2028 2028 062 289401000 14 Menlo Pl 14 MENLO PL 14 MENLO PL 14.0 MENLO PL     Berkeley 94707 37.89785729329466 -122.28295823216727
3260 3260 3260 062 289500400 84 Menlo Pl 84 MENLO PL 84 MENLO PL 84.0 MENLO PL     Berkeley 94707 37.898546813434166 -122.28199914046432
5525 5525 5525 062 290702300 11 Menlo Pl 11 MENLO PL 11 MENLO PL 11.0 MENLO PL     Berkeley 94707 37.89764983175333 -122.28348776477274
5759 5759 5759 062 290701700 45 Menlo Pl 45 MENLO PL 45 MENLO PL 45.0 MENLO PL     Berkeley 94707 37.89845860706008 -122.28314852498885
5910 5910 5910 062 290702400 7 Menlo Pl 7 MENLO PL 7 MENLO PL 7.0 MENLO PL     Berkeley 94707 37.897508785841 -122.28347207749292
6025 6025 6025 062 290702100 25 Menlo Pl 25 MENLO PL 25 MENLO PL 25.0 MENLO PL     Berkeley 94707 37.89792755544235 -122.28360701702502
9043 9043 9043 062 290700900 89 Menlo Pl 89 MENLO PL 89 MENLO PL 89.0 MENLO PL     Berkeley 94707 37.89890859073553 -122.28180234563668
11732 11732 11732 062 289400100 30 Menlo Pl 30 MENLO PL 30 MENLO PL 30.0 MENLO PL     Berkeley 94707 37.89806584732095 -122.28313994338296
14518 14518 14518 062 289500200 66 Menlo Pl 66 MENLO PL 66 MENLO PL 66.0 MENLO PL     Berkeley 94707 37.8984702387616 -122.28222084108312
14912 14912 14912 062 290701500 53 Menlo Pl 53 MENLO PL 53 MENLO PL 53.0 MENLO PL     Berkeley 94707 37.898658472313414 -122.28287663729168
18706 18706 18706 062 290701600 51 Menlo Pl 51 MENLO PL 51 MENLO PL 51.0 MENLO PL     Berkeley 94707 37.89855667580671 -122.28301222900068
19043 19043 19043 062 289400900 12 Menlo Pl 12 MENLO PL 12 MENLO PL 12.0 MENLO PL     Berkeley 94707 37.89766898751591 -122.28291041035313
19311 19311 19311 062 290701900 31 Menlo Pl 31 MENLO PL 31 MENLO PL 31.0 MENLO PL     Berkeley 94707 37.898267525494575 -122.28347464577632
21887 21887 21887 062 289500500 90 Menlo Pl 90 MENLO PL 90 MENLO PL 90.0 MENLO PL     Berkeley 94707 37.8985607949932 -122.2818196561722
23221 23221 23221 062 290701400 59 Menlo Pl 59 MENLO PL 59 MENLO PL 59.0 MENLO PL     Berkeley 94707 37.898754956495495 -122.28274758172468
24195 24195 24195 062 290702200 21 Menlo Pl 21 MENLO PL 21 MENLO PL 21.0 MENLO PL     Berkeley 94707 37.89778312947247 -122.2835265423486
27324 27324 27324 062 290701800 39 Menlo Pl 39 MENLO PL 39 MENLO PL 39.0 MENLO PL     Berkeley 94707 37.898376973148345 -122.2833077010673
37896 37896 37896 062 290701200 73 Menlo Pl 73 MENLO PL 73 MENLO PL 73.0 MENLO PL     Berkeley 94707 37.899065177037265 -122.28244491774592
39695 39695 39695 062 289400200 42 Menlo Pl 42 MENLO PL 42 MENLO PL 42.0 MENLO PL     Berkeley 94707 37.898201799689794 -122.28289117562625
44587 44587 44587 062 290702500 1 Menlo Pl 1 MENLO PL 1 MENLO PL 1.0 MENLO PL     Berkeley 94707 37.89736738309593 -122.283466880739
46596 46596 46596 062 289500300 76 Menlo Pl 76 MENLO PL 76 MENLO PL 76.0 MENLO PL     Berkeley 94707 37.89865719565795 -122.2822044046084
50984 50984 50984 062 290702001 27 Menlo Pl 27 MENLO PL 27 MENLO PL 27.0 MENLO PL     Berkeley 94707 37.89811514602426 -122.28361174396004
51630 51630 51630 062 290701000 85 Menlo Pl 85 MENLO PL 85 MENLO PL 85.0 MENLO PL     Berkeley 94707 37.899081228354845 -122.28197125765618
53785 53785 53785 062 290701100 77 Menlo Pl 77 MENLO PL 77 MENLO PL 77.0 MENLO PL     Berkeley 94707 37.89908681271544 -122.28223899154348
54907 54907 54907 062 289401100 20 Menlo Pl 20 MENLO PL 20 MENLO PL 20.0 MENLO PL     Berkeley 94707 37.89796696768663 -122.28306980202724
56256 56256 56256 062 290701300 69 Menlo Pl 69 MENLO PL 69 MENLO PL 69.0 MENLO PL     Berkeley 94707 37.898931357794886 -122.28260811827684

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