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

31 rows where street_name = "ORDWAY" and zipcode = 94706

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94706 · 31 ✖

street_type 1

street_name 1

  • ORDWAY · 31 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1218 1218 1218 060 242702800 1217 Ordway St 1217 ORDWAY ST 1217 ORDWAY ST 1217.0 ORDWAY ST     Berkeley 94706 37.88163957852294 -122.28602326864532
1839 1839 1839 060 241600101 1206 Ordway St 1206 ORDWAY ST 1206 ORDWAY ST 1206.0 ORDWAY ST     Berkeley 94706 37.88233575294989 -122.28643702368204
2541 2541 2541 060 241601700 1244 Ordway St 1244 ORDWAY ST 1244 ORDWAY ST 1244.0 ORDWAY ST     Berkeley 94706 37.88085185816721 -122.28699119348248
2584 2584 2584 060 241600700 1218 Ordway St 1218 ORDWAY ST 1218 ORDWAY ST 1218.0 ORDWAY ST     Berkeley 94706 37.88174877508788 -122.2866558505903
3766 3766 3766 060 241600500 1214 Ordway St 1214 ORDWAY ST 1214 ORDWAY ST 1214.0 ORDWAY ST     Berkeley 94706 37.88196488468778 -122.28657699647464
9490 9490 9490 060 242703100 1209 Ordway St 1209 ORDWAY ST 1209 ORDWAY ST 1209.0 ORDWAY ST     Berkeley 94706 37.88202159420917 -122.28587229957527
10146 10146 10146 060 242702300 1235 Ordway St 1235 ORDWAY ST 1235 ORDWAY ST 1235.0 ORDWAY ST     Berkeley 94706 37.88112172963621 -122.28621361267088
10309 10309 10309 060 241600900 1222 Ordway St 1222 ORDWAY ST 1222 ORDWAY ST 1222.0 ORDWAY ST     Berkeley 94706 37.88157755102995 -122.28672453038703
11252 11252 11252 060 242702200 1237 Ordway St 1237 ORDWAY ST 1237 ORDWAY ST 1237.0 ORDWAY ST     Berkeley 94706 37.88103386469777 -122.28624614336228
11353 11353 11353 060 241601200 1228 Ordway St 1228 ORDWAY ST 1228 ORDWAY ST 1228.0 ORDWAY ST     Berkeley 94706 37.88131349170137 -122.28681944637997
11888 11888 11888 060 241600400 1212 Ordway St 1212 ORDWAY ST 1212 ORDWAY ST 1212.0 ORDWAY ST     Berkeley 94706 37.88205708274919 -122.28654199631455
13069 13069 13069 060 241601000 1224 Ordway St 1224 ORDWAY ST 1224 ORDWAY ST 1224.0 ORDWAY ST     Berkeley 94706 37.88149754617185 -122.2867529755405
13785 13785 13785 060 241601600 1240 Ordway St 1240 ORDWAY ST 1240 ORDWAY ST 1240.0 ORDWAY ST     Berkeley 94706 37.88094528211638 -122.2869561834409
15364 15364 15364 060 242702400 1231 Ordway St 1231 ORDWAY ST 1231 ORDWAY ST 1231.0 ORDWAY ST     Berkeley 94706 37.88122978827148 -122.2861729297683
16704 16704 16704 060 241601300 1230 Ordway St 1230 ORDWAY ST 1230 ORDWAY ST 1230.0 ORDWAY ST     Berkeley 94706 37.88121799076976 -122.28685621622115
18410 18410 18410 060 242703200 1207 Ordway St 1207 ORDWAY ST 1207 ORDWAY ST 1207.0 ORDWAY ST     Berkeley 94706 37.882150202418835 -122.28582594291338
19054 19054 19054 060 242700100 1199 Ordway St 1199 ORDWAY ST 1199 ORDWAY ST 1199.0 ORDWAY ST     Berkeley 94706 37.88239573783885 -122.28572532710996
19966 19966 19966 060 241600800 1220 Ordway St 1220 ORDWAY ST 1220 ORDWAY ST 1220.0 ORDWAY ST     Berkeley 94706 37.881645533607646 -122.28669662512104
29368 29368 29368 060 241601400 1234 Ordway St 1234 ORDWAY ST 1234 ORDWAY ST 1234.0 ORDWAY ST     Berkeley 94706 37.88112483730619 -122.28689293126514
33663 33663 33663 060 242702100 1239 Ordway St 1239 ORDWAY ST 1239 ORDWAY ST 1239.0 ORDWAY ST     Berkeley 94706 37.88094566924664 -122.28628041858192
35497 35497 35497 060 242703002 1211 Ordway St 1211 ORDWAY ST 1211 ORDWAY ST 1211.0 ORDWAY ST     Berkeley 94706 37.88189963284326 -122.28588870191406
36095 36095 36095 060 242703300 1201 Ordway St 1201 ORDWAY ST 1201 ORDWAY ST 1201.0 ORDWAY ST     Berkeley 94706 37.88228418617009 -122.28577643046984
37680 37680 37680 060 241600600 1216 Ordway St 1216 ORDWAY ST 1216 ORDWAY ST 1216.0 ORDWAY ST     Berkeley 94706 37.88186988304251 -122.2866128742888
45223 45223 45223 060 242702900 1215 Ordway St 1215 ORDWAY ST 1215 ORDWAY ST 1215.0 ORDWAY ST     Berkeley 94706 37.881758529812416 -122.28597772675536
48592 48592 48592 060 241601100 1226 Ordway St 1226 ORDWAY ST 1226 ORDWAY ST 1226.0 ORDWAY ST     Berkeley 94706 37.881406791694566 -122.28678625902008
48963 48963 48963 060 242702600 1225 Ordway St 1225 ORDWAY ST 1225 ORDWAY ST 1225.0 ORDWAY ST     Berkeley 94706 37.88144509961416 -122.28609236346372
50117 50117 50117 060 241600200 1208 Ordway St 1208 ORDWAY ST 1208 ORDWAY ST 1208.0 ORDWAY ST     Berkeley 94706 37.88224137217315 -122.28647450498892
51172 51172 51172 060 241601500 1236 Ordway St 1236 ORDWAY ST 1236 ORDWAY ST 1236.0 ORDWAY ST     Berkeley 94706 37.88103407173418 -122.28692455016648
52087 52087 52087 060 242702700 1221 Ordway St 1221 ORDWAY ST 1221 ORDWAY ST 1221.0 ORDWAY ST     Berkeley 94706 37.88154125468049 -122.28605828767004
55033 55033 55033 060 242702500 1229 Ordway St 1229 ORDWAY ST 1229 ORDWAY ST 1229.0 ORDWAY ST     Berkeley 94706 37.88134507172281 -122.28612890423452
58257 58257 58257 060 241600300 1210 Ordway St 1210 ORDWAY ST 1210 ORDWAY ST 1210.0 ORDWAY ST     Berkeley 94706 37.882153100176026 -122.28650617419598

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