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

11 rows where street_name = "AJAX" and street_type = "PL"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • AJAX · 11 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
7004 7004 7004 063 316101200 11 Ajax Pl 11 AJAX PL 11 AJAX PL 11.0 AJAX PL     Berkeley 94708 37.888678382933215 -122.250078273106
8794 8794 8794 063 316102200 7 Ajax Pl 7 AJAX PL 7 AJAX PL 7.0 AJAX PL     Berkeley 94708 37.88848865561094 -122.24961051225274
13772 13772 13772 063 316102100 9 Ajax Pl 9 AJAX PL 9 AJAX PL 9.0 AJAX PL     Berkeley 94708 37.888822628968185 -122.24963385587372
24291 24291 24291 060 249500201 4 Ajax Pl 4 AJAX PL 4 AJAX PL 4.0 AJAX PL     Berkeley 94708 37.88788788996365 -122.2502791920991
29418 29418 29418 063 316102000 20 Ajax Pl 20 AJAX PL 20 AJAX PL 20.0 AJAX PL     Berkeley 94708 37.889080854350325 -122.24988980386448
35222 35222 35222 063 316101100 12 Ajax Pl 12 AJAX PL 12 AJAX PL 12.0 AJAX PL     Berkeley 94708 37.88852446290078 -122.25052502505976
43200 43200 43200 063 316101000 10 Ajax Pl 10 AJAX PL 10 AJAX PL 10.0 AJAX PL     Berkeley 94708 37.88830593869466 -122.2504448585055
44623 44623 44623 063 316102300 5 Ajax Pl 5 AJAX PL 5 AJAX PL 5.0 AJAX PL     Berkeley 94708 37.88841002654973 -122.24989710896436
45535 45535 45535 060 249501901 1 Ajax Pl 1 AJAX PL 1 AJAX PL 1.0 AJAX PL     Berkeley 94708 37.8880879725012 -122.24975529552373
45683 45683 45683 060 249500100 6 Ajax Pl 6 AJAX PL 6 AJAX PL 6.0 AJAX PL     Berkeley 94708 37.88811503991843 -122.25044158324798
53481 53481 53481 060 249502000 2 Ajax Pl 1000 2 AJAX PL 1000 2 AJAX PL 2.0 AJAX PL 1000   Berkeley 94708 37.887736025693414 -122.24977547437996

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