Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
30 rows where street_name = "WALNUT" and zipcode = 94707
This data as json, CSV (advanced)
Suggested facets: apn, base_address, street_number, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2350 | 2350 | 2350 | 061 256100200 | 1108 Walnut St | 1108 WALNUT ST | 1108 WALNUT ST | 1108.0 | WALNUT | ST | Berkeley | 94707 | 37.88760582072267 | -122.26990698220514 | ||
| 3055 | 3055 | 3055 | 061 255804000 | 1141 Walnut St | 1141 WALNUT ST | 1141 WALNUT ST | 1141.0 | WALNUT | ST | Berkeley | 94707 | 37.886782870069894 | -122.26861378998 | ||
| 9374 | 9374 | 9374 | 061 255804400 | 1127 Walnut St | 1127 WALNUT ST | 1127 WALNUT ST | 1127.0 | WALNUT | ST | Berkeley | 94707 | 37.88779651167473 | -122.26883002704528 | ||
| 10808 | 10808 | 10808 | 061 256100900 | 1132 Walnut St | 1132 WALNUT ST | 1132 WALNUT ST | 1132.0 | WALNUT | ST | Berkeley | 94707 | 37.8869851307351 | -122.2693412591718 | ||
| 13878 | 13878 | 13878 | 061 255803900 | 1145 Walnut St | 1145 WALNUT ST | 1145 WALNUT ST | 1145.0 | WALNUT | ST | Berkeley | 94707 | 37.88665023233893 | -122.2686019582694 | ||
| 20664 | 20664 | 20664 | 061 256100400 | 1112 Walnut St | 1112 WALNUT ST | 1112 WALNUT ST | 1112.0 | WALNUT | ST | Berkeley | 94707 | 37.887433302237945 | -122.26975818076988 | ||
| 22508 | 22508 | 22508 | 061 256100800 | 1128 Walnut St | 1128 WALNUT ST | 1128 WALNUT ST | 1128.0 | WALNUT | ST | Berkeley | 94707 | 37.88709966784763 | -122.2693682355798 | ||
| 23422 | 23422 | 23422 | 061 256101200 | 1148 Walnut St | 1148 WALNUT ST | 1148 WALNUT ST | 1148.0 | WALNUT | ST | Berkeley | 94707 | 37.88643382524739 | -122.26925957446473 | ||
| 24452 | 24452 | 24452 | 061 255803700 | 1151 Walnut St | 1151 WALNUT ST | 1151 WALNUT ST | 1151.0 | WALNUT | ST | Berkeley | 94707 | 37.88641526139307 | -122.26857378979705 | ||
| 26247 | 26247 | 26247 | 061 256100500 | 1116 Walnut St | 1116 WALNUT ST | 1116 WALNUT ST | 1116.0 | WALNUT | ST | Berkeley | 94707 | 37.887353715651855 | -122.26963602426432 | ||
| 26958 | 26958 | 26958 | 061 256100600 | 1120 Walnut St | 1120 WALNUT ST | 1120 WALNUT ST | 1120.0 | WALNUT | ST | Berkeley | 94707 | 37.88728604603601 | -122.26951473553127 | ||
| 28342 | 28342 | 28342 | 061 255804200 | 1133 Walnut St Lowr | 1133 WALNUT ST LOWR | 1133 WALNUT ST | 1133.0 | WALNUT | ST | LOWR | Berkeley | 94707 | 37.88703564069213 | -122.26863859695656 | |
| 32209 | 32209 | 32209 | 061 255804600 | 1101 Walnut St | 1101 WALNUT ST | 1101 WALNUT ST | 1101.0 | WALNUT | ST | Berkeley | 94707 | 37.887753399572766 | -122.26949120056914 | ||
| 33699 | 33699 | 33699 | 061 255804100 | 1135 Walnut St | 1135 WALNUT ST | 1135 WALNUT ST | 1135.0 | WALNUT | ST | Berkeley | 94707 | 37.886908833296424 | -122.26863324928568 | ||
| 33839 | 33839 | 33839 | 061 256100300 | 1110 Walnut St | 1110 WALNUT ST | 1110 WALNUT ST | 1110.0 | WALNUT | ST | Berkeley | 94707 | 37.88751750127422 | -122.2698461599722 | ||
| 34258 | 34258 | 34258 | 061 255803400 | 1195 Walnut St | 1195 WALNUT ST | 1195 WALNUT ST | 1195.0 | WALNUT | ST | Berkeley | 94707 | 37.886066711114424 | -122.26864344336752 | ||
| 35073 | 35073 | 35073 | 061 255803800 | 1147 Walnut St | 1147 WALNUT ST | 1147 WALNUT ST | 1147.0 | WALNUT | ST | Berkeley | 94707 | 37.88652858137127 | -122.26858873596672 | ||
| 37330 | 37330 | 37330 | 061 256101500 | 1162 Walnut St | 1162 WALNUT ST | 1162 WALNUT ST | 1162.0 | WALNUT | ST | Berkeley | 94707 | 37.88599927215267 | -122.26904315144812 | ||
| 38622 | 38622 | 38622 | 061 256101300 | 1154 Walnut St | 1154 WALNUT ST | 1154 WALNUT ST | 1154.0 | WALNUT | ST | Berkeley | 94707 | 37.88632671647963 | -122.26924316673605 | ||
| 39297 | 39297 | 39297 | 061 256101400 | 1156 Walnut St | 1156 WALNUT ST | 1156 WALNUT ST | 1156.0 | WALNUT | ST | Berkeley | 94707 | 37.886215075053165 | -122.26923193240508 | ||
| 39439 | 39439 | 39439 | 061 256101400 | 1156 Walnut St Lowr | 1156 WALNUT ST LOWR | 1156 WALNUT ST | 1156.0 | WALNUT | ST | LOWR | Berkeley | 94707 | 37.886215075053165 | -122.26923193240508 | |
| 40572 | 40572 | 40572 | 061 256101200 | 1148 Walnut St Lowr | 1148 WALNUT ST LOWR | 1148 WALNUT ST | 1148.0 | WALNUT | ST | LOWR | Berkeley | 94707 | 37.88643382524739 | -122.26925957446473 | |
| 45205 | 45205 | 45205 | 061 256101100 | 1140 Walnut St | 1140 WALNUT ST | 1140 WALNUT ST | 1140.0 | WALNUT | ST | Berkeley | 94707 | 37.88665341067314 | -122.26927716527462 | ||
| 48729 | 48729 | 48729 | 061 255804200 | 1133 Walnut St | 1133 WALNUT ST | 1133 WALNUT ST | 1133.0 | WALNUT | ST | Berkeley | 94707 | 37.88703564069213 | -122.26863859695656 | ||
| 50125 | 50125 | 50125 | 061 255803500 | 1189 Walnut St | 1189 WALNUT ST | 1189 WALNUT ST | 1189.0 | WALNUT | ST | Berkeley | 94707 | 37.88618070657734 | -122.26859854197636 | ||
| 51637 | 51637 | 51637 | 061 256101000 | 1134 Walnut St | 1134 WALNUT ST | 1134 WALNUT ST | 1134.0 | WALNUT | ST | Berkeley | 94707 | 37.886862358725736 | -122.26932179896782 | ||
| 53826 | 53826 | 53826 | 061 255804500 | 1111 Walnut St | 1111 WALNUT ST | 1111 WALNUT ST | 1111.0 | WALNUT | ST | Berkeley | 94707 | 37.88769170406208 | -122.26919078327688 | ||
| 55692 | 55692 | 55692 | 061 255803600 | 1155 Walnut St | 1155 WALNUT ST | 1155 WALNUT ST | 1155.0 | WALNUT | ST | Berkeley | 94707 | 37.88629519956655 | -122.2685634025774 | ||
| 55965 | 55965 | 55965 | 061 255804300 | 1125 Walnut St | 1125 WALNUT ST | 1125 WALNUT ST | 1125.0 | WALNUT | ST | Berkeley | 94707 | 37.88760884233416 | -122.26910479923282 | ||
| 57749 | 57749 | 57749 | 061 256100700 | 1124 Walnut St | 1124 WALNUT ST | 1124 WALNUT ST | 1124.0 | WALNUT | ST | Berkeley | 94707 | 37.887203716996666 | -122.26941576993306 |
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);