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

44 rows where street_name = "ORDWAY" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94702 · 44 ✖

street_type 1

street_name 1

  • ORDWAY · 44 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1205 1205 1205 060 242309100 1480 Ordway St 1480 ORDWAY ST 1480 ORDWAY ST 1480.0 ORDWAY ST     Berkeley 94702 37.87761374529964 -122.28722770372713
4359 4359 4359 060 241608500 1320 Ordway St C 1320 ORDWAY ST C 1320 ORDWAY ST 1320.0 ORDWAY ST C   Berkeley 94702 37.87982568936161 -122.28737189051677
4942 4942 4942 060 242307700 1455 Ordway St 1455 ORDWAY ST 1455 ORDWAY ST 1455.0 ORDWAY ST     Berkeley 94702 37.87809490387775 -122.28691439291558
7658 7658 7658 060 241604200 1318 Ordway St 1318 ORDWAY ST 1318 ORDWAY ST 1318.0 ORDWAY ST     Berkeley 94702 37.87994991174328 -122.28732640611896
8864 8864 8864 060 242302100 1307 Ordway St 1307 ORDWAY ST 1307 ORDWAY ST 1307.0 ORDWAY ST     Berkeley 94702 37.880246589519835 -122.2865408338946
10190 10190 10190 060 242301300 1329 Ordway St 1329 ORDWAY ST 1329 ORDWAY ST 1329.0 ORDWAY ST     Berkeley 94702 37.87946037161976 -122.28689005575792
11364 11364 11364 060 241608500 1541 Ordway St 1541 ORDWAY ST 1541 ORDWAY ST 1541.0 ORDWAY ST     Berkeley 94702 37.87982568936161 -122.28737189051677
18716 18716 18716 060 242301500 1325 Ordway St 1325 ORDWAY ST 1325 ORDWAY ST 1325.0 ORDWAY ST     Berkeley 94702 37.879651131879626 -122.28676128405856
21289 21289 21289 060 241608500 1320 Ordway St B 1320 ORDWAY ST B 1320 ORDWAY ST 1320.0 ORDWAY ST B   Berkeley 94702 37.87982568936161 -122.28737189051677
21694 21694 21694 060 241604700 1338 Ordway St 1338 ORDWAY ST 1338 ORDWAY ST 1338.0 ORDWAY ST     Berkeley 94702 37.879401715925894 -122.28753066594658
23543 23543 23543 060 241604100 1316 Ordway St 1316 ORDWAY ST 1316 ORDWAY ST 1316.0 ORDWAY ST     Berkeley 94702 37.880042011643674 -122.28729052920316
25465 25465 25465 060 242301700 1317 Ordway St 1317 ORDWAY ST 1317 ORDWAY ST 1317.0 ORDWAY ST     Berkeley 94702 37.87985644257102 -122.28668560548746
25930 25930 25930 060 242302200 1305 Ordway St 1305 ORDWAY ST 1305 ORDWAY ST 1305.0 ORDWAY ST     Berkeley 94702 37.880340585719466 -122.28650497764
26423 26423 26423 060 242307400 1485 Ordway St 1485 ORDWAY ST 1485 ORDWAY ST 1485.0 ORDWAY ST     Berkeley 94702 37.87777288909518 -122.2868027062746
27217 27217 27217 060 242301800 1315 Ordway St 1315 ORDWAY ST 1315 ORDWAY ST 1315.0 ORDWAY ST     Berkeley 94702 37.87995186160148 -122.28665159257584
27704 27704 27704 060 241604802 1342 Ordway St 1342 ORDWAY ST 1342 ORDWAY ST 1342.0 ORDWAY ST     Berkeley 94702 37.879220355557486 -122.28760256350868
28681 28681 28681 060 242301400 1327 Ordway St 1327 ORDWAY ST 1327 ORDWAY ST 1327.0 ORDWAY ST     Berkeley 94702 37.87953997737231 -122.28680628336608
30979 30979 30979 060 242304900 1449 Ordway St 1449 ORDWAY ST 1449 ORDWAY ST 1449.0 ORDWAY ST     Berkeley 94702 37.87846042550906 -122.28713080155912
32217 32217 32217 060 241605000 1346 Ordway St 1346 ORDWAY ST 1346 ORDWAY ST 1346.0 ORDWAY ST     Berkeley 94702 37.87904228968912 -122.2876735061616
33909 33909 33909 060 242308900 1460 Ordway St 1460 ORDWAY ST 1460 ORDWAY ST 1460.0 ORDWAY ST     Berkeley 94702 37.87782484476217 -122.2873176340702
34581 34581 34581 060 242308600 1448 Ordway St 1448 ORDWAY ST 1448 ORDWAY ST 1448.0 ORDWAY ST     Berkeley 94702 37.8781434998068 -122.28745438191096
34753 34753 34753 060 241604000 1314 Ordway St 1314 ORDWAY ST 1314 ORDWAY ST 1314.0 ORDWAY ST     Berkeley 94702 37.88013846137437 -122.28725209927528
35779 35779 35779 060 241604900 1344 Ordway St 1344 ORDWAY ST 1344 ORDWAY ST 1344.0 ORDWAY ST     Berkeley 94702 37.87913203385149 -122.2876359898204
36997 36997 36997 060 242301900 1311 Ordway St 1311 ORDWAY ST 1311 ORDWAY ST 1311.0 ORDWAY ST     Berkeley 94702 37.88005004930334 -122.2866123272148
38614 38614 38614 060 242308700 1450 Ordway St 1450 ORDWAY ST 1450 ORDWAY ST 1450.0 ORDWAY ST     Berkeley 94702 37.87803737591645 -122.28740860735736
39655 39655 39655 060 242308800 1454 Ordway St 1454 ORDWAY ST 1454 ORDWAY ST 1454.0 ORDWAY ST     Berkeley 94702 37.87793149720753 -122.28736173955402
43186 43186 43186 060 241608500 1320 Ordway St D 1320 ORDWAY ST D 1320 ORDWAY ST 1320.0 ORDWAY ST D   Berkeley 94702 37.87982568936161 -122.28737189051677
44023 44023 44023 060 241603700 1308 Ordway St 1308 ORDWAY ST 1308 ORDWAY ST 1308.0 ORDWAY ST     Berkeley 94702 37.88042357190767 -122.28714979284254
44733 44733 44733 060 241603500 1300 Ordway St 1300 ORDWAY ST 1300 ORDWAY ST 1300.0 ORDWAY ST     Berkeley 94702 37.88060036739458 -122.28708127384424
45736 45736 45736 060 241604802 1342 Ordway St A 1342 ORDWAY ST A 1342 ORDWAY ST 1342.0 ORDWAY ST A   Berkeley 94702 37.879220355557486 -122.28760256350868
46281 46281 46281 060 241604801 1340 Ordway St 1340 ORDWAY ST 1340 ORDWAY ST 1340.0 ORDWAY ST     Berkeley 94702 37.8793114020195 -122.28756742770295
47310 47310 47310 060 242309000 1470 Ordway St 1470 ORDWAY ST 1470 ORDWAY ST 1470.0 ORDWAY ST     Berkeley 94702 37.877718847334584 -122.28727351241672
47705 47705 47705 060 242307500 1473 Ordway St 1473 ORDWAY ST 1473 ORDWAY ST 1473.0 ORDWAY ST     Berkeley 94702 37.87787782143792 -122.28683990101898
48629 48629 48629 060 242302000 1309 Ordway St 1309 ORDWAY ST 1309 ORDWAY ST 1309.0 ORDWAY ST     Berkeley 94702 37.88014916287714 -122.28657571368043
50144 50144 50144 060 242307600 1465 Ordway St 1465 ORDWAY ST 1465 ORDWAY ST 1465.0 ORDWAY ST     Berkeley 94702 37.87798677682781 -122.28687628548292
50629 50629 50629 060 241603800 1310 Ordway St 1310 ORDWAY ST 1310 ORDWAY ST 1310.0 ORDWAY ST     Berkeley 94702 37.880332350270585 -122.2871823055676
52158 52158 52158 060 241603600 1304 Ordway St 1304 ORDWAY ST 1304 ORDWAY ST 1304.0 ORDWAY ST     Berkeley 94702 37.88051361643549 -122.28711473968184
52366 52366 52366 060 241604500 1334 Ordway St 1334 ORDWAY ST 1334 ORDWAY ST 1334.0 ORDWAY ST     Berkeley 94702 37.87958728472617 -122.28746320965526
52610 52610 52610 060 242301600 1321 Ordway St 1321 ORDWAY ST 1321 ORDWAY ST 1321.0 ORDWAY ST     Berkeley 94702 37.879762560618175 -122.28672065325826
52669 52669 52669 060 241604600 1336 Ordway St 1336 ORDWAY ST 1336 ORDWAY ST 1336.0 ORDWAY ST     Berkeley 94702 37.879494201522554 -122.28749734024618
54071 54071 54071 060 242308500 1440 Ordway St 1440 ORDWAY ST 1440 ORDWAY ST 1440.0 ORDWAY ST     Berkeley 94702 37.87824689509781 -122.2875002049736
55391 55391 55391 060 241603900 1312 Ordway St 1312 ORDWAY ST 1312 ORDWAY ST 1312.0 ORDWAY ST     Berkeley 94702 37.880237640769614 -122.28721555131796
57125 57125 57125 060 241608500 1320 Ordway St A 1320 ORDWAY ST A 1320 ORDWAY ST 1320.0 ORDWAY ST A   Berkeley 94702 37.87982568936161 -122.28737189051677
58093 58093 58093 060 241604400 1332 Ordway St 1332 ORDWAY ST 1332 ORDWAY ST 1332.0 ORDWAY ST     Berkeley 94702 37.87968970589406 -122.28742154489407

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