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

25 rows where street_name = "SPRUCE" and zipcode = 94708

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94708 · 25 ✖

street_type 1

street_name 1

  • SPRUCE · 25 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
2202 2202 2202 062 294600102 438 Spruce St 438 SPRUCE ST 438 SPRUCE ST 438.0 SPRUCE ST     Berkeley 94708 37.90367388795444 -122.27075405219556
2710 2710 2710 062 294501800 488 Spruce St 488 SPRUCE ST 488 SPRUCE ST 488.0 SPRUCE ST     Berkeley 94708 37.901842681958534 -122.27102060749316
9125 9125 9125 062 294600500 460 Spruce St 460 SPRUCE ST 460 SPRUCE ST 460.0 SPRUCE ST     Berkeley 94708 37.90303526073082 -122.27091490003876
10700 10700 10700 062 294600400 444 Spruce St 444 SPRUCE ST 444 SPRUCE ST 444.0 SPRUCE ST     Berkeley 94708 37.90326322799411 -122.27090094650744
13440 13440 13440 063 295102100 421 Spruce St 421 SPRUCE ST 421 SPRUCE ST 421.0 SPRUCE ST     Berkeley 94708 37.90397238038136 -122.27016775594558
14013 14013 14013 063 295208300 487 Spruce St 487 SPRUCE ST 487 SPRUCE ST 487.0 SPRUCE ST     Berkeley 94708 37.90220466137745 -122.27034225099456
18014 18014 18014 063 295101600 443 Spruce St 443 SPRUCE ST 443 SPRUCE ST 443.0 SPRUCE ST     Berkeley 94708 37.903293259764986 -122.27024000564724
22778 22778 22778 062 294600700 464 Spruce St 464 SPRUCE ST 464 SPRUCE ST 464.0 SPRUCE ST     Berkeley 94708 37.90269883837361 -122.27088037059586
23630 23630 23630 063 295102000 425 Spruce St 425 SPRUCE ST 425 SPRUCE ST 425.0 SPRUCE ST     Berkeley 94708 37.90383931998175 -122.27018366960084
24421 24421 24421 063 295102200 417 Spruce St 417 SPRUCE ST 417 SPRUCE ST 417.0 SPRUCE ST     Berkeley 94708 37.90410851250882 -122.27015550023016
31665 31665 31665 062 294600103 430 Spruce St 430 SPRUCE ST 430 SPRUCE ST 430.0 SPRUCE ST     Berkeley 94708 37.90376607938759 -122.27096108961402
31855 31855 31855 062 294502000 492 Spruce St 492 SPRUCE ST 492 SPRUCE ST 492.0 SPRUCE ST     Berkeley 94708 37.90160998877312 -122.270847764446
35072 35072 35072 063 295102303 401 Spruce St 401 SPRUCE ST 401 SPRUCE ST 401.0 SPRUCE ST     Berkeley 94708 37.90424331537423 -122.27012797944312
39857 39857 39857 063 295207801 499 Spruce St 499 SPRUCE ST 499 SPRUCE ST 499.0 SPRUCE ST     Berkeley 94708 37.90190912680768 -122.2701884926556
40520 40520 40520 062 294600800 470 Spruce St 470 SPRUCE ST 470 SPRUCE ST 470.0 SPRUCE ST     Berkeley 94708 37.90250412872361 -122.27085659219028
44756 44756 44756 062 294502100 496 Spruce St 496 SPRUCE ST 496 SPRUCE ST 496.0 SPRUCE ST     Berkeley 94708 37.901496483611545 -122.270752221429
45114 45114 45114 062 294501900 490 Spruce St 490 SPRUCE ST 490 SPRUCE ST 490.0 SPRUCE ST     Berkeley 94708 37.90171922731355 -122.27094509870363
46151 46151 46151 063 295101900 431 Spruce St 431 SPRUCE ST 431 SPRUCE ST 431.0 SPRUCE ST     Berkeley 94708 37.903705107524296 -122.27019959044262
46695 46695 46695 062 294600600 462 Spruce St 462 SPRUCE ST 462 SPRUCE ST 462.0 SPRUCE ST     Berkeley 94708 37.9028527720084 -122.2708964782872
46716 46716 46716 063 295101800 435 Spruce St 435 SPRUCE ST 435 SPRUCE ST 435.0 SPRUCE ST     Berkeley 94708 37.903568759171804 -122.27021188209063
50730 50730 50730 063 295101500 449 Spruce St 449 SPRUCE ST 449 SPRUCE ST 449.0 SPRUCE ST     Berkeley 94708 37.90315266767733 -122.27023665852452
52223 52223 52223 062 294600900 484 Spruce St 484 SPRUCE ST 484 SPRUCE ST 484.0 SPRUCE ST     Berkeley 94708 37.90228929858506 -122.27089082968072
54145 54145 54145 063 295101700 439 Spruce St 439 SPRUCE ST 439 SPRUCE ST 439.0 SPRUCE ST     Berkeley 94708 37.903431015622225 -122.27022680131093
55000 55000 55000 063 295101400 455 Spruce St 455 SPRUCE ST 455 SPRUCE ST 455.0 SPRUCE ST     Berkeley 94708 37.903011754935754 -122.27019680925852
56416 56416 56416 062 294600201 440 Spruce St 440 SPRUCE ST 440 SPRUCE ST 440.0 SPRUCE ST     Berkeley 94708 37.90348971384151 -122.27087955941715

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