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

18 rows where street_name = "BAY VIEW"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, base_address, street_number, unit, latitude, longitude

zipcode 1

street_type 1

street_name 1

  • BAY VIEW · 18 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
2273 2273 2273 060 246501000 1304 Bay View Pl 2 1304 BAY VIEW PL 2 1304 BAY VIEW PL 1304.0 BAY VIEW PL 2   Berkeley 94708 37.88441967577247 -122.26332487250647
3042 3042 3042 060 246501600 1324 Bay View Pl 1324 BAY VIEW PL 1324 BAY VIEW PL 1324.0 BAY VIEW PL     Berkeley 94708 37.88397975287476 -122.26448519132468
7953 7953 7953 060 246501501 1322 Bay View Pl 1322 BAY VIEW PL 1322 BAY VIEW PL 1322.0 BAY VIEW PL     Berkeley 94708 37.88411425086696 -122.26435509281364
11233 11233 11233 060 246501700 1328 Bay View Pl 1328 BAY VIEW PL 1328 BAY VIEW PL 1328.0 BAY VIEW PL     Berkeley 94708 37.88371953928389 -122.26447552814716
17511 17511 17511 060 246501200 1310 Bay View Pl 1310 BAY VIEW PL 1310 BAY VIEW PL 1310.0 BAY VIEW PL     Berkeley 94708 37.884325615297165 -122.26363545333788
20152 20152 20152 060 246501100 1306 Bay View Pl 1 1306 BAY VIEW PL 1 1306 BAY VIEW PL 1306.0 BAY VIEW PL 1   Berkeley 94708 37.88438925627893 -122.26348220344536
38738 38738 38738 060 246501400 1320 Bay View Pl 1320 BAY VIEW PL 1320 BAY VIEW PL 1320.0 BAY VIEW PL     Berkeley 94708 37.88415671069361 -122.2641168649902
39681 39681 39681 060 246501100 1306 Bay View Pl 2 1306 BAY VIEW PL 2 1306 BAY VIEW PL 1306.0 BAY VIEW PL 2   Berkeley 94708 37.88438925627893 -122.26348220344536
39765 39765 39765 060 246501300 1314 Bay View Pl 1314 BAY VIEW PL 1314 BAY VIEW PL 1314.0 BAY VIEW PL     Berkeley 94708 37.88423870778357 -122.26386805321606
41172 41172 41172 060 246501801 1336 Bay View Pl 1336 BAY VIEW PL 1336 BAY VIEW PL 1336.0 BAY VIEW PL     Berkeley 94708 37.883457956392824 -122.26431119933224
42135 42135 42135 059 224900400 1305 Bay View Pl 1305 BAY VIEW PL 1305 BAY VIEW PL 1305.0 BAY VIEW PL     Berkeley 94708 37.88389870768528 -122.26306865951273
45320 45320 45320 060 246501000 1304 Bay View Pl 1 1304 BAY VIEW PL 1 1304 BAY VIEW PL 1304.0 BAY VIEW PL 1   Berkeley 94708 37.88441967577247 -122.26332487250647
48025 48025 48025 059 224904500 1345 Bay View Pl 1345 BAY VIEW PL 1345 BAY VIEW PL 1345.0 BAY VIEW PL     Berkeley 94708 37.88360450911895 -122.26340121852586
48047 48047 48047 059 224900201 1311 Bay View Pl 1311 BAY VIEW PL 1311 BAY VIEW PL 1311.0 BAY VIEW PL     Berkeley 94708 37.88383922599392 -122.26346810977684
51670 51670 51670 059 224900300 1307 Bay View Pl 1307 BAY VIEW PL 1307 BAY VIEW PL 1307.0 BAY VIEW PL     Berkeley 94708 37.88391683613825 -122.26329671032232
52914 52914 52914 060 246501000 1304 Bay View Pl 1304 BAY VIEW PL 1304 BAY VIEW PL 1304.0 BAY VIEW PL     Berkeley 94708 37.88441967577247 -122.26332487250647
53583 53583 53583 060 246501100 1306 Bay View Pl 1306 BAY VIEW PL 1306 BAY VIEW PL 1306.0 BAY VIEW PL     Berkeley 94708 37.88438925627893 -122.26348220344536
56483 56483 56483 059 224900101 1321 Bay View Pl 1321 BAY VIEW PL 1321 BAY VIEW PL 1321.0 BAY VIEW PL     Berkeley 94708 37.88381461298842 -122.2638450267004

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