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

60 rows where street_name = "HAWTHORNE" and zipcode = 94708

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94708 · 60 ✖

street_type 1

street_name 1

  • HAWTHORNE · 60 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
221 221 221 059 224902500 1424 Hawthorne Ter 1424 HAWTHORNE TER 1424 HAWTHORNE TE 1424.0 HAWTHORNE TE     Berkeley 94708 37.882064360829595 -122.26293750637956
2125 2125 2125 059 224902800 1450 Hawthorne Ter 1450 HAWTHORNE TER 1450 HAWTHORNE TE 1450.0 HAWTHORNE TE     Berkeley 94708 37.881349942730736 -122.2629209576154
4014 4014 4014 059 225002901 1573 Hawthorne Ter 1573 HAWTHORNE TER 1573 HAWTHORNE TE 1573.0 HAWTHORNE TE     Berkeley 94708 37.87983306905533 -122.26209799211895
4102 4102 4102 059 224902700 1440 Hawthorne Ter 1440 HAWTHORNE TER 1440 HAWTHORNE TE 1440.0 HAWTHORNE TE     Berkeley 94708 37.88165952830287 -122.2629559236395
5156 5156 5156 059 225003300 1531 Hawthorne Ter 1531 HAWTHORNE TER 1531 HAWTHORNE TE 1531.0 HAWTHORNE TE     Berkeley 94708 37.880595635307536 -122.26219373276533
6161 6161 6161 059 225000300 1403 Hawthorne Ter 1403 HAWTHORNE TER 1403 HAWTHORNE TE 1403.0 HAWTHORNE TE     Berkeley 94708 37.882305082312705 -122.26187117469628
6963 6963 6963 059 225003100 1551 Hawthorne Ter 1551 HAWTHORNE TER 1551 HAWTHORNE TE 1551.0 HAWTHORNE TE     Berkeley 94708 37.88027676043475 -122.26216181831823
7204 7204 7204 059 224902500 1430 Hawthorne Ter 1430 HAWTHORNE TER 1430 HAWTHORNE TE 1430.0 HAWTHORNE TE     Berkeley 94708 37.882064360829595 -122.26293750637956
7274 7274 7274 059 225002700 1591 Hawthorne Ter 1591 HAWTHORNE TER 1591 HAWTHORNE TE 1591.0 HAWTHORNE TE     Berkeley 94708 37.87960733220086 -122.26213821957572
9210 9210 9210 059 224902301 1410 Hawthorne Ter 1410 HAWTHORNE TER 1410 HAWTHORNE TE 1410.0 HAWTHORNE TE     Berkeley 94708 37.882535933528345 -122.26279700717416
10531 10531 10531 059 225004200 1429 Hawthorne Ter 1429 HAWTHORNE TER 1429 HAWTHORNE TE 1429.0 HAWTHORNE TE     Berkeley 94708 37.882078990017135 -122.2623061066175
10707 10707 10707 059 225100600 1530 Hawthorne Ter A 1530 HAWTHORNE TER A 1530 HAWTHORNE TE 1530.0 HAWTHORNE TE A   Berkeley 94708 37.88055300822289 -122.2627384990014
10888 10888 10888 059 224902000 1404 Hawthorne Ter 1404 HAWTHORNE TER 1404 HAWTHORNE TE 1404.0 HAWTHORNE TE     Berkeley 94708 37.882793125947245 -122.26215056602098
11528 11528 11528 059 225002600 1597 Hawthorne Ter 1597 HAWTHORNE TER 1597 HAWTHORNE TE 1597.0 HAWTHORNE TE     Berkeley 94708 37.8794890701728 -122.26209551546371
12401 12401 12401 059 225003200 1541 Hawthorne Ter 1 1541 HAWTHORNE TER 1 1541 HAWTHORNE TE 1541.0 HAWTHORNE TE 1   Berkeley 94708 37.88042222545061 -122.26219840669977
12928 12928 12928 058 224700201 2526 Hawthorne Ter 2526 HAWTHORNE TER 2526 HAWTHORNE TE 2526.0 HAWTHORNE TE     Berkeley 94708 37.8814823262513 -122.26114564137389
13600 13600 13600 059 225000100 1415 Hawthorne Ter 1415 HAWTHORNE TER 1415 HAWTHORNE TE 1415.0 HAWTHORNE TE     Berkeley 94708 37.88238442265463 -122.2622370594098
13650 13650 13650 059 225004301 1427 Hawthorne Ter 1427 HAWTHORNE TER 1427 HAWTHORNE TE 1427.0 HAWTHORNE TE     Berkeley 94708 37.88228275395598 -122.26238278231854
14402 14402 14402 059 225003800 1443 Hawthorne Ter 1443 HAWTHORNE TER 1443 HAWTHORNE TE 1443.0 HAWTHORNE TE     Berkeley 94708 37.88138237498529 -122.26227213323176
15540 15540 15540 058 224700100 2506 Hawthorne Ter 1 2506 HAWTHORNE TER 1 2506 HAWTHORNE TE 2506.0 HAWTHORNE TE 1   Berkeley 94708 37.88190682585674 -122.2612476738205
15950 15950 15950 059 225101001 1570 Hawthorne Ter 1570 HAWTHORNE TER 1570 HAWTHORNE TE 1570.0 HAWTHORNE TE     Berkeley 94708 37.87987787472766 -122.26273019317829
16139 16139 16139 059 225000200 1411 Hawthorne Ter 1411 HAWTHORNE TER 1411 HAWTHORNE TE 1411.0 HAWTHORNE TE     Berkeley 94708 37.88231993266559 -122.26203471479036
16212 16212 16212 059 224801100 2525 Hawthorne Ter 2525 HAWTHORNE TER 2525 HAWTHORNE TE 2525.0 HAWTHORNE TE     Berkeley 94708 37.88222169126846 -122.26091486687234
17606 17606 17606 058 224700100 2506 Hawthorne Ter 2506 HAWTHORNE TER 2506 HAWTHORNE TE 2506.0 HAWTHORNE TE     Berkeley 94708 37.88190682585674 -122.2612476738205
19719 19719 19719 059 225003400 1521 Hawthorne Ter 1521 HAWTHORNE TER 1521 HAWTHORNE TE 1521.0 HAWTHORNE TE     Berkeley 94708 37.88075128706088 -122.262269333183
21421 21421 21421 059 225100800 1550 Hawthorne Ter 1550 HAWTHORNE TER 1550 HAWTHORNE TE 1550.0 HAWTHORNE TE     Berkeley 94708 37.88020794276625 -122.26269825268004
21750 21750 21750 058 224700100 2506 Hawthorne Ter A 2506 HAWTHORNE TER A 2506 HAWTHORNE TE 2506.0 HAWTHORNE TE A   Berkeley 94708 37.88190682585674 -122.2612476738205
24056 24056 24056 059 225101002 1576 Hawthorne Ter 1576 HAWTHORNE TER 1576 HAWTHORNE TE 1576.0 HAWTHORNE TE     Berkeley 94708 37.87976436796407 -122.26270549310122
25042 25042 25042 059 225100600 1530 Hawthorne Ter 1530 HAWTHORNE TER 1530 HAWTHORNE TE 1530.0 HAWTHORNE TE     Berkeley 94708 37.88055300822289 -122.2627384990014
26209 26209 26209 059 225100500 1518 Hawthorne Ter 1518 HAWTHORNE TER 1518 HAWTHORNE TE 1518.0 HAWTHORNE TE     Berkeley 94708 37.88072775358795 -122.26278161903336
26563 26563 26563 059 225003200 1541 Hawthorne Ter 2 1541 HAWTHORNE TER 2 1541 HAWTHORNE TE 1541.0 HAWTHORNE TE 2   Berkeley 94708 37.88040837090912 -122.2620882777375
27290 27290 27290 059 224905900 1416 Hawthorne Ter 1416 HAWTHORNE TER 1416 HAWTHORNE TE 1416.0 HAWTHORNE TE     Berkeley 94708 37.88231962849747 -122.26274841101224
28354 28354 28354 059 224905900 1412 Hawthorne Ter 1412 HAWTHORNE TER 1412 HAWTHORNE TE 1412.0 HAWTHORNE TE     Berkeley 94708 37.88231962849747 -122.26274841101224
29607 29607 29607 059 225003200 1541 Hawthorne Ter A 1541 HAWTHORNE TER A 1541 HAWTHORNE TE 1541.0 HAWTHORNE TE A   Berkeley 94708 37.88047740251869 -122.26209593407864
30206 30206 30206 059 224901900 1402 Hawthorne Ter 1402 HAWTHORNE TER 1402 HAWTHORNE TE 1402.0 HAWTHORNE TE     Berkeley 94708 37.88273022379528 -122.2619752310472
31546 31546 31546 059 225003900 1441 Hawthorne Ter 1441 HAWTHORNE TER 1441 HAWTHORNE TE 1441.0 HAWTHORNE TE     Berkeley 94708 37.88159518019277 -122.26229110744718
32175 32175 32175 059 225004100 1435 Hawthorne Ter 1435 HAWTHORNE TER 1435 HAWTHORNE TE 1435.0 HAWTHORNE TE     Berkeley 94708 37.88194290719292 -122.26231932442856
32471 32471 32471 059 225100700 1542 Hawthorne Ter 1542 HAWTHORNE TER 1542 HAWTHORNE TE 1542.0 HAWTHORNE TE     Berkeley 94708 37.880375605688144 -122.26276720825956
32946 32946 32946 059 224901800 1400 Hawthorne Ter 1400 HAWTHORNE TER 1400 HAWTHORNE TE 1400.0 HAWTHORNE TE     Berkeley 94708 37.8826059961768 -122.26178155067868
34088 34088 34088 059 225000300 1401 Hawthorne Ter 1401 HAWTHORNE TER 1401 HAWTHORNE TE 1401.0 HAWTHORNE TE     Berkeley 94708 37.882305082312705 -122.26187117469628
34094 34094 34094 059 224801000 2535 Hawthorne Ter 2535 HAWTHORNE TER 2535 HAWTHORNE TE 2535.0 HAWTHORNE TE     Berkeley 94708 37.8821460908223 -122.26077114990164
34161 34161 34161 059 224901800 1400 Hawthorne Ter A 1400 HAWTHORNE TER A 1400 HAWTHORNE TE 1400.0 HAWTHORNE TE A   Berkeley 94708 37.8826059961768 -122.26178155067868
34615 34615 34615 059 225003500 1505 Hawthorne Ter 1505 HAWTHORNE TER 1505 HAWTHORNE TE 1505.0 HAWTHORNE TE     Berkeley 94708 37.880922372651824 -122.26221701440257
35099 35099 35099 059 225101300 1598 Hawthorne Ter 1598 HAWTHORNE TER 1598 HAWTHORNE TE 1598.0 HAWTHORNE TE     Berkeley 94708 37.87944269302191 -122.26240988089742
36067 36067 36067 059 225100900 1560 Hawthorne Ter 1560 HAWTHORNE TER 1560 HAWTHORNE TE 1560.0 HAWTHORNE TE     Berkeley 94708 37.880033989582024 -122.26267854543936
37754 37754 37754 059 224905900 1414 Hawthorne Ter 1414 HAWTHORNE TER 1414 HAWTHORNE TE 1414.0 HAWTHORNE TE     Berkeley 94708 37.88231962849747 -122.26274841101224
39561 39561 39561 059 224902202 1408 Hawthorne Ter 1408 HAWTHORNE TER 1408 HAWTHORNE TE 1408.0 HAWTHORNE TE     Berkeley 94708 37.88276894225357 -122.2626781546722
39925 39925 39925 059 225101200 1584 Hawthorne Ter 1584 HAWTHORNE TER 1584 HAWTHORNE TE 1584.0 HAWTHORNE TE     Berkeley 94708 37.87956142805615 -122.26243855062972
42563 42563 42563 059 225003200 1541 Hawthorne Ter 1541 HAWTHORNE TER 1541 HAWTHORNE TE 1541.0 HAWTHORNE TE     Berkeley 94708 37.8804125145092 -122.26228992706092
42765 42765 42765 059 224801300 2501 Hawthorne Ter 2501 HAWTHORNE TER 2501 HAWTHORNE TE 2501.0 HAWTHORNE TE     Berkeley 94708 37.88215083202695 -122.26131251781094
44341 44341 44341 059 225004200 1429 Hawthorne Ter 2 1429 HAWTHORNE TER 2 1429 HAWTHORNE TE 1429.0 HAWTHORNE TE 2   Berkeley 94708 37.882078990017135 -122.2623061066175
48284 48284 48284 059 224902600 1438 Hawthorne Ter 1438 HAWTHORNE TER 1438 HAWTHORNE TE 1438.0 HAWTHORNE TE     Berkeley 94708 37.88185029704735 -122.2629694756239
48676 48676 48676 059 224902101 1406 Hawthorne Ter 1406 HAWTHORNE TER 1406 HAWTHORNE TE 1406.0 HAWTHORNE TE     Berkeley 94708 37.88286930428235 -122.2623707781314
50285 50285 50285 059 225004200 1429 Hawthorne Ter 1 1429 HAWTHORNE TER 1 1429 HAWTHORNE TE 1429.0 HAWTHORNE TE 1   Berkeley 94708 37.882078990017135 -122.2623061066175
51549 51549 51549 059 224801200 2519 Hawthorne Ter 2519 HAWTHORNE TER 2519 HAWTHORNE TE 2519.0 HAWTHORNE TE     Berkeley 94708 37.88216920055832 -122.26108168761388
54258 54258 54258 059 224902102 1406 Hawthorne Ter A 1406 HAWTHORNE TER A 1406 HAWTHORNE TE 1406.0 HAWTHORNE TE A   Berkeley 94708 37.88265989893005 -122.26238917742506
54426 54426 54426 059 225101100 1580 Hawthorne Ter 1580 HAWTHORNE TER 1580 HAWTHORNE TE 1580.0 HAWTHORNE TE     Berkeley 94708 37.87966700378826 -122.26254248570808
54453 54453 54453 058 224700300 2528 Hawthorne Ter 2528 HAWTHORNE TER 2528 HAWTHORNE TE 2528.0 HAWTHORNE TE     Berkeley 94708 37.88181487930985 -122.26088133815269
54771 54771 54771 059 225003000 1561 Hawthorne Ter 1561 HAWTHORNE TER 1561 HAWTHORNE TE 1561.0 HAWTHORNE TE     Berkeley 94708 37.88008156108978 -122.26214860050716
56154 56154 56154 059 225004000 1439 Hawthorne Ter 1439 HAWTHORNE TER 1439 HAWTHORNE TE 1439.0 HAWTHORNE TE     Berkeley 94708 37.88180000403933 -122.26230898392132

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