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 = "BROOKSIDE" and street_type = "DR"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • BROOKSIDE · 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
20244 20244 20244 052 156315600 180 Brookside Dr 180 BROOKSIDE DR 180 BROOKSIDE DR 180.0 BROOKSIDE DR     Berkeley 94705 37.853094688107014 -122.24982802851902
21378 21378 21378 052 156315500 170 Brookside Dr 170 BROOKSIDE DR 170 BROOKSIDE DR 170.0 BROOKSIDE DR     Berkeley 94705 37.85318261331996 -122.24994484004868
21742 21742 21742 052 156314700 130 Brookside Dr 130 BROOKSIDE DR 130 BROOKSIDE DR 130.0 BROOKSIDE DR     Berkeley 94705 37.85375940638672 -122.2495224297442
27813 27813 27813 052 156316300 171 Brookside Dr 171 BROOKSIDE DR 171 BROOKSIDE DR 171.0 BROOKSIDE DR     Berkeley 94705 37.853345190387714 -122.249672497804
31431 31431 31431 052 156314800 140 Brookside Dr 140 BROOKSIDE DR 140 BROOKSIDE DR 140.0 BROOKSIDE DR     Berkeley 94705 37.85375485131719 -122.24970873224927
33069 33069 33069 052 156314600 120 Brookside Dr 120 BROOKSIDE DR 120 BROOKSIDE DR 120.0 BROOKSIDE DR     Berkeley 94705 37.85374856132025 -122.2493524370514
37628 37628 37628 052 156315800 190 Brookside Dr 190 BROOKSIDE DR 190 BROOKSIDE DR 190.0 BROOKSIDE DR     Berkeley 94705 37.8530276324805 -122.24966396650372
38201 38201 38201 052 156315400 160 Brookside Dr 160 BROOKSIDE DR 160 BROOKSIDE DR 160.0 BROOKSIDE DR     Berkeley 94705 37.85329885848858 -122.25005810143632
39061 39061 39061 052 156316200 181 Brookside Dr 181 BROOKSIDE DR 181 BROOKSIDE DR 181.0 BROOKSIDE DR     Berkeley 94705 37.853248664441935 -122.24947580718094
40018 40018 40018 052 156315200 156 Brookside Dr 156 BROOKSIDE DR 156 BROOKSIDE DR 156.0 BROOKSIDE DR     Berkeley 94705 37.85352888064338 -122.25023099748412
45727 45727 45727 052 156315300 158 Brookside Dr 158 BROOKSIDE DR 158 BROOKSIDE DR 158.0 BROOKSIDE DR     Berkeley 94705 37.85342788780085 -122.25013114255376
51010 51010 51010 052 156315900 151 Brookside Dr 151 BROOKSIDE DR 151 BROOKSIDE DR 151.0 BROOKSIDE DR     Berkeley 94705 37.853495532486576 -122.24974896509592
51613 51613 51613 052 156316000 121 Brookside Dr 121 BROOKSIDE DR 121 BROOKSIDE DR 121.0 BROOKSIDE DR     Berkeley 94705 37.85348622229365 -122.24950116841804
52117 52117 52117 052 156314900 150 Brookside Dr 150 BROOKSIDE DR 150 BROOKSIDE DR 150.0 BROOKSIDE DR     Berkeley 94705 37.8537120597513 -122.24991190870868
52299 52299 52299 052 156315100 154 Brookside Dr 154 BROOKSIDE DR 154 BROOKSIDE DR 154.0 BROOKSIDE DR     Berkeley 94705 37.853683898021615 -122.25040728736704
52863 52863 52863 052 156316100 111 Brookside Dr 111 BROOKSIDE DR 111 BROOKSIDE DR 111.0 BROOKSIDE DR     Berkeley 94705 37.85341335222517 -122.24935450048162
56216 56216 56216 052 156315000 152 Brookside Dr 152 BROOKSIDE DR 152 BROOKSIDE DR 152.0 BROOKSIDE DR     Berkeley 94705 37.85374030303872 -122.25011964501644
57028 57028 57028 052 156314500 110 Brookside Dr 110 BROOKSIDE DR 110 BROOKSIDE DR 110.0 BROOKSIDE DR     Berkeley 94705 37.853603435877645 -122.24919688118354

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