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

30 rows where street_name = "WALNUT" and zipcode = 94707

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, base_address, street_number, latitude, longitude

zipcode 1

  • 94707 · 30 ✖

street_type 1

street_name 1

  • WALNUT · 30 ✖
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

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