Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
10 rows where street_name = "SANTA FE" and zipcode = 94706
This data as json, CSV (advanced)
Suggested facets: apn, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9121 | 9121 | 9121 | 060 241100103 | 1205 Santa Fe Ave | 1205 SANTA FE AVE | 1205 SANTA FE AV | 1205.0 | SANTA FE | AV | Berkeley | 94706 | 37.88296158841979 | -122.29006496966996 | ||
| 11567 | 11567 | 11567 | 060 241101702 | 1219 Santa Fe Ave | 1219 SANTA FE AVE | 1219 SANTA FE AV | 1219.0 | SANTA FE | AV | Berkeley | 94706 | 37.88240244938218 | -122.29023025429234 | ||
| 11589 | 11589 | 11589 | 060 241101702 | 1221 Santa Fe Ave | 1221 SANTA FE AVE | 1221 SANTA FE AV | 1221.0 | SANTA FE | AV | Berkeley | 94706 | 37.88240244938218 | -122.29023025429234 | ||
| 12561 | 12561 | 12561 | 060 241101504 | 1231 Santa Fe Ave | 1231 SANTA FE AVE | 1231 SANTA FE AV | 1231.0 | SANTA FE | AV | Berkeley | 94706 | 37.88206279744268 | -122.29046112401532 | ||
| 14444 | 14444 | 14444 | 060 241101703 | 1215 Santa Fe Ave | 1215 SANTA FE AVE | 1215 SANTA FE AV | 1215.0 | SANTA FE | AV | Berkeley | 94706 | 37.882608405405605 | -122.29018574636324 | ||
| 15198 | 15198 | 15198 | 060 240906200 | 1228 Santa Fe Ave | 1228 SANTA FE AVE | 1228 SANTA FE AV | 1228.0 | SANTA FE | AV | Berkeley | 94706 | 37.88221298807834 | -122.29075217277747 | ||
| 19065 | 19065 | 19065 | 060 241100102 | 1209 Santa Fe Ave | 1209 SANTA FE AVE | 1209 SANTA FE AV | 1209.0 | SANTA FE | AV | Berkeley | 94706 | 37.88275766824947 | -122.29013882735596 | ||
| 25354 | 25354 | 25354 | 060 241101703 | 1217 Santa Fe Ave | 1217 SANTA FE AVE | 1217 SANTA FE AV | 1217.0 | SANTA FE | AV | Berkeley | 94706 | 37.882608405405605 | -122.29018574636324 | ||
| 43169 | 43169 | 43169 | 060 241101504 | 1235 Santa Fe Ave | 1235 SANTA FE AVE | 1235 SANTA FE AV | 1235.0 | SANTA FE | AV | Berkeley | 94706 | 37.88206279744268 | -122.29046112401532 | ||
| 44471 | 44471 | 44471 | 060 240907004 | 1218 Santa Fe Ave | 1218 SANTA FE AVE | 1218 SANTA FE AV | 1218.0 | SANTA FE | AV | Berkeley | 94706 | 37.88268561483674 | -122.29082255847491 |
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);