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

17 rows where street_name = "CHABOLYN" and street_type = "TE"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • CHABOLYN · 17 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
918 918 918 064 425201600 6023 Chabolyn Ter 6023 CHABOLYN TER 6023 CHABOLYN TE 6023.0 CHABOLYN TE     Berkeley 94618 37.85215886443242 -122.24413689127536
3154 3154 3154 064 425205702 6030 Chabolyn Ter 6030 CHABOLYN TER 6030 CHABOLYN TE 6030.0 CHABOLYN TE     Berkeley 94618 37.851826060472646 -122.24417437437889
3370 3370 3370 064 425206002 6004 Chabolyn Ter 6004 CHABOLYN TER 6004 CHABOLYN TE 6004.0 CHABOLYN TE     Berkeley 94618 37.851821597493945 -122.24473107114024
5111 5111 5111 064 425201900 6015 Chabolyn Ter 6015 CHABOLYN TER 6015 CHABOLYN TE 6015.0 CHABOLYN TE     Berkeley 94618 37.85221206171464 -122.24459010301427
6464 6464 6464 064 425202000 6009 Chabolyn Ter 6009 CHABOLYN TER 6009 CHABOLYN TE 6009.0 CHABOLYN TE     Berkeley 94618 37.8522063390312 -122.2447291882714
12053 12053 12053 064 425205802 6016 Chabolyn Ter 6016 CHABOLYN TER 6016 CHABOLYN TE 6016.0 CHABOLYN TE     Berkeley 94618 37.85184021333397 -122.2444192479388
21244 21244 21244 064 425201103 6037 Chabolyn Ter 6037 CHABOLYN TER 6037 CHABOLYN TE 6037.0 CHABOLYN TE     Berkeley 94618 37.851929421055125 -122.24334131002206
21486 21486 21486 064 425201201 6035 Chabolyn Ter 6035 CHABOLYN TER 6035 CHABOLYN TE 6035.0 CHABOLYN TE     Berkeley 94618 37.85199435401118 -122.24357503728594
24829 24829 24829 064 425201700 6019 Chabolyn Ter 6019 CHABOLYN TER 6019 CHABOLYN TE 6019.0 CHABOLYN TE     Berkeley 94618 37.852189095791786 -122.24428909552888
31318 31318 31318 064 425202900 6001 Chabolyn Ter 6001 CHABOLYN TER 6001 CHABOLYN TE 6001.0 CHABOLYN TE     Berkeley 94618 37.85177180391128 -122.24530152649848
33443 33443 33443 064 425201500 6029 Chabolyn Ter 6029 CHABOLYN TER 6029 CHABOLYN TE 6029.0 CHABOLYN TE     Berkeley 94618 37.85211877156338 -122.24399481911992
37804 37804 37804 064 425205902 6012 Chabolyn Ter 6012 CHABOLYN TER 6012 CHABOLYN TE 6012.0 CHABOLYN TE     Berkeley 94618 37.85183911886879 -122.24458373395892
42403 42403 42403 064 425201400 6031 Chabolyn Ter 6031 CHABOLYN TER 6031 CHABOLYN TE 6031.0 CHABOLYN TE     Berkeley 94618 37.85208754076098 -122.2438566932635
45509 45509 45509 064 425201300 6033 Chabolyn Ter 6033 CHABOLYN TER 6033 CHABOLYN TE 6033.0 CHABOLYN TE     Berkeley 94618 37.85203319289128 -122.24372913428978
45887 45887 45887 064 425201800 6017 Chabolyn Ter 6017 CHABOLYN TER 6017 CHABOLYN TE 6017.0 CHABOLYN TE     Berkeley 94618 37.85220468989395 -122.24443936660792
45912 45912 45912 064 425202100 6007 Chabolyn Ter 6007 CHABOLYN TER 6007 CHABOLYN TE 6007.0 CHABOLYN TE     Berkeley 94618 37.852183079453646 -122.2448679492367
54867 54867 54867 064 425201102 6039 Chabolyn Ter 6039 CHABOLYN TER 6039 CHABOLYN TE 6039.0 CHABOLYN TE     Berkeley 94618 37.85190340217715 -122.24277005067162

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