Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
15 rows where street_name = "HENRY" and zipcode = 94704
This data as json, CSV (advanced)
Suggested facets: apn, base_address, street_number, unit, latitude, longitude
| Link | rowid ▼ | address_id | apn | address_full | address_normalized | base_address | street_number | street_name | street_type | unit | unit_type | city | zipcode | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8339 | 8339 | 8339 | 057 205101601 | 1905 Henry St | 1905 HENRY ST | 1905 HENRY ST | 1905.0 | HENRY | ST | Berkeley | 94704 | 37.87353635313117 | -122.26953863610773 | ||
| 21183 | 21183 | 21183 | 057 205103200 | 1912 Henry St | 1912 HENRY ST | 1912 HENRY ST | 1912.0 | HENRY | ST | Berkeley | 94704 | 37.87320181123998 | -122.26983201869298 | ||
| 21242 | 21242 | 21242 | 057 205102000 | 1902 Henry St C | 1902 HENRY ST C | 1902 HENRY ST | 1902.0 | HENRY | ST | C | Berkeley | 94704 | 37.87345750530209 | -122.26988995823218 | |
| 25694 | 25694 | 25694 | 057 205102000 | 1902 Henry St A | 1902 HENRY ST A | 1902 HENRY ST | 1902.0 | HENRY | ST | A | Berkeley | 94704 | 37.87345750530209 | -122.26988995823218 | |
| 25912 | 25912 | 25912 | 057 205101602 | 1901 Henry St | 1901 HENRY ST | 1901 HENRY ST | 1901.0 | HENRY | ST | Berkeley | 94704 | 37.87363032031165 | -122.269554880343 | ||
| 27150 | 27150 | 27150 | 057 205103100 | 1918 Henry St 3 | 1918 HENRY ST 3 | 1918 HENRY ST | 1918.0 | HENRY | ST | 3 | Berkeley | 94704 | 37.87301846996452 | -122.26979550576996 | |
| 29979 | 29979 | 29979 | 057 205101601 | 1905 Henry St 1 | 1905 HENRY ST 1 | 1905 HENRY ST | 1905.0 | HENRY | ST | 1 | Berkeley | 94704 | 37.87353635313117 | -122.26953863610773 | |
| 36409 | 36409 | 36409 | 057 205103100 | 1918 Henry St 4 | 1918 HENRY ST 4 | 1918 HENRY ST | 1918.0 | HENRY | ST | 4 | Berkeley | 94704 | 37.87301846996452 | -122.26979550576996 | |
| 42616 | 42616 | 42616 | 057 205102000 | 1902 Henry St | 1902 HENRY ST | 1902 HENRY ST | 1902.0 | HENRY | ST | Berkeley | 94704 | 37.87345750530209 | -122.26988995823218 | ||
| 44432 | 44432 | 44432 | 057 205101601 | 1905 Henry St 2 | 1905 HENRY ST 2 | 1905 HENRY ST | 1905.0 | HENRY | ST | 2 | Berkeley | 94704 | 37.87353635313117 | -122.26953863610773 | |
| 45767 | 45767 | 45767 | 057 205102000 | 1902 Henry St D | 1902 HENRY ST D | 1902 HENRY ST | 1902.0 | HENRY | ST | D | Berkeley | 94704 | 37.87345750530209 | -122.26988995823218 | |
| 53234 | 53234 | 53234 | 057 205103100 | 1918 Henry St | 1918 HENRY ST | 1918 HENRY ST | 1918.0 | HENRY | ST | Berkeley | 94704 | 37.87301846996452 | -122.26979550576996 | ||
| 53328 | 53328 | 53328 | 057 205102000 | 1902 Henry St B | 1902 HENRY ST B | 1902 HENRY ST | 1902.0 | HENRY | ST | B | Berkeley | 94704 | 37.87345750530209 | -122.26988995823218 | |
| 55843 | 55843 | 55843 | 057 205103100 | 1918 Henry St 1 | 1918 HENRY ST 1 | 1918 HENRY ST | 1918.0 | HENRY | ST | 1 | Berkeley | 94704 | 37.87301846996452 | -122.26979550576996 | |
| 58276 | 58276 | 58276 | 057 205103100 | 1918 Henry St 2 | 1918 HENRY ST 2 | 1918 HENRY ST | 1918.0 | HENRY | ST | 2 | Berkeley | 94704 | 37.87301846996452 | -122.26979550576996 |
Advanced export
JSON shape: default, array, newline-delimited
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);