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

47 rows where street_name = "AVENIDA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

street_type 1

street_name 1

  • AVENIDA · 47 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1338 1338 1338 060 248703000 151 Avenida Dr 151 AVENIDA DR 151 AVENIDA DR 151.0 AVENIDA DR     Berkeley 94708 37.88426457061045 -122.24948753738192
10062 10062 10062 060 248703200 111 Avenida Dr 111 AVENIDA DR 111 AVENIDA DR 111.0 AVENIDA DR     Berkeley 94708 37.88389312642651 -122.24979727469524
10322 10322 10322 060 248203200 33 Avenida Dr 2 33 AVENIDA DR 2 33 AVENIDA DR 33.0 AVENIDA DR 2   Berkeley 94708 37.883696884505504 -122.25190358957624
10348 10348 10348 060 248504100 61 Avenida Dr 61 AVENIDA DR 61 AVENIDA DR 61.0 AVENIDA DR     Berkeley 94708 37.88379396258892 -122.25091537000016
12750 12750 12750 060 248203200 33 Avenida Dr 33 AVENIDA DR 33 AVENIDA DR 33.0 AVENIDA DR     Berkeley 94708 37.883696884505504 -122.25190358957624
14670 14670 14670 060 248203400 29 Avenida Dr 29 AVENIDA DR 29 AVENIDA DR 29.0 AVENIDA DR     Berkeley 94708 37.88350354472871 -122.25216474150744
18000 18000 18000 060 248702300 185 Avenida Dr 185 AVENIDA DR 185 AVENIDA DR 185.0 AVENIDA DR     Berkeley 94708 37.8850840789019 -122.24929946160248
18740 18740 18740 060 248503900 91 Avenida Dr 91 AVENIDA DR 91 AVENIDA DR 91.0 AVENIDA DR     Berkeley 94708 37.8837019333177 -122.25036719465758
20055 20055 20055 060 248203600 25 Avenida Dr 25 AVENIDA DR 25 AVENIDA DR 25.0 AVENIDA DR     Berkeley 94708 37.88315587756382 -122.2521964897662
20192 20192 20192 060 248504300 41 Avenida Dr 41 AVENIDA DR 41 AVENIDA DR 41.0 AVENIDA DR     Berkeley 94708 37.88378800625997 -122.251279813816
21585 21585 21585 060 248203400 29 Avenida Dr 1 29 AVENIDA DR 1 29 AVENIDA DR 29.0 AVENIDA DR 1   Berkeley 94708 37.88350354472871 -122.25216474150744
22290 22290 22290 060 248903801 148 Avenida Dr 148 AVENIDA DR 148 AVENIDA DR 148.0 AVENIDA DR     Berkeley 94708 37.88440799080316 -122.2488571383431
22376 22376 22376 060 248504000 81 Avenida Dr 81 AVENIDA DR 81 AVENIDA DR 81.0 AVENIDA DR     Berkeley 94708 37.883793160707256 -122.2506758899252
22510 22510 22510 060 248903900 154 Avenida Dr 154 AVENIDA DR 154 AVENIDA DR 154.0 AVENIDA DR     Berkeley 94708 37.88451873100021 -122.24897957422472
23317 23317 23317 060 248302900 10 Avenida Dr 10 AVENIDA DR 10 AVENIDA DR 10.0 AVENIDA DR     Berkeley 94708 37.88262797489183 -122.25214338046828
23432 23432 23432 060 248702900 155 Avenida Dr A 155 AVENIDA DR A 155 AVENIDA DR 155.0 AVENIDA DR A   Berkeley 94708 37.88438904925196 -122.2495714247581
25462 25462 25462 060 248904100 98 Avenida Dr 98 AVENIDA DR 98 AVENIDA DR 98.0 AVENIDA DR     Berkeley 94708 37.88352107913281 -122.24983759737344
27837 27837 27837 060 248903300 124 Avenida Dr 124 AVENIDA DR 124 AVENIDA DR 124.0 AVENIDA DR     Berkeley 94708 37.88374620063032 -122.24931824357844
28034 28034 28034 060 248904100 98 Avenida Dr 1 98 AVENIDA DR 1 98 AVENIDA DR 98.0 AVENIDA DR 1   Berkeley 94708 37.88352107913281 -122.24983759737344
28280 28280 28280 060 248203500 27 Avenida Dr 27 AVENIDA DR 27 AVENIDA DR 27.0 AVENIDA DR     Berkeley 94708 37.88331053413255 -122.25213688924202
28778 28778 28778 060 248400701 90 Avenida Dr 90 AVENIDA DR 90 AVENIDA DR 90.0 AVENIDA DR     Berkeley 94708 37.88337396612564 -122.25048826689664
30144 30144 30144 060 248203300 31 Avenida Dr 31 AVENIDA DR 31 AVENIDA DR 31.0 AVENIDA DR     Berkeley 94708 37.8836280048044 -122.25205822017936
30857 30857 30857 060 248702400 175 Avenida Dr 2 175 AVENIDA DR 2 175 AVENIDA DR 175.0 AVENIDA DR 2   Berkeley 94708 37.88502472933122 -122.24945835650824
31328 31328 31328 060 248400200 50 Avenida Dr 50 AVENIDA DR 50 AVENIDA DR 50.0 AVENIDA DR     Berkeley 94708 37.88329985294125 -122.25136893118376
34047 34047 34047 060 248504200 51 Avenida Dr 51 AVENIDA DR 51 AVENIDA DR 51.0 AVENIDA DR     Berkeley 94708 37.88381760923144 -122.2511161623308
37369 37369 37369 060 248702400 175 Avenida Dr 3 175 AVENIDA DR 3 175 AVENIDA DR 175.0 AVENIDA DR 3   Berkeley 94708 37.88502472933122 -122.24945835650824
38517 38517 38517 060 248702900 155 Avenida Dr 155 AVENIDA DR 155 AVENIDA DR 155.0 AVENIDA DR     Berkeley 94708 37.88438904925196 -122.2495714247581
38952 38952 38952 060 248400500 78 Avenida Dr 78 AVENIDA DR 78 AVENIDA DR 78.0 AVENIDA DR     Berkeley 94708 37.88342057619105 -122.2507926259964
39874 39874 39874 060 248702200 191 Avenida Dr 191 AVENIDA DR 191 AVENIDA DR 191.0 AVENIDA DR     Berkeley 94708 37.88506368338586 -122.24893523517896
41277 41277 41277 060 248904001 180 Avenida Dr 180 AVENIDA DR 180 AVENIDA DR 180.0 AVENIDA DR     Berkeley 94708 37.88467859297565 -122.24910694814552
41597 41597 41597 060 248203800 1 Avenida Dr 1 AVENIDA DR 1 AVENIDA DR 1.0 AVENIDA DR     Berkeley 94708 37.8828662704232 -122.2524078301149
43587 43587 43587 060 248903400 130 Avenida Dr 130 AVENIDA DR 130 AVENIDA DR 130.0 AVENIDA DR     Berkeley 94708 37.883849307291385 -122.2492028271324
47301 47301 47301 060 248904100 98 Avenida Dr 2 98 AVENIDA DR 2 98 AVENIDA DR 98.0 AVENIDA DR 2   Berkeley 94708 37.88352107913281 -122.24983759737344
47484 47484 47484 060 248400403 70 Avenida Dr 70 AVENIDA DR 70 AVENIDA DR 70.0 AVENIDA DR     Berkeley 94708 37.88341071675373 -122.25106088180485
47721 47721 47721 060 248903501 140 Avenida Dr 140 AVENIDA DR 140 AVENIDA DR 140.0 AVENIDA DR     Berkeley 94708 37.883993671972384 -122.24899718389923
47746 47746 47746 060 248702500 171 Avenida Dr 171 AVENIDA DR 171 AVENIDA DR 171.0 AVENIDA DR     Berkeley 94708 37.88495026827554 -122.24960177074672
49458 49458 49458 060 248702400 175 Avenida Dr 175 AVENIDA DR 175 AVENIDA DR 175.0 AVENIDA DR     Berkeley 94708 37.88502472933122 -122.24945835650824
49911 49911 49911 060 248702700 165 Avenida Dr 165 AVENIDA DR 165 AVENIDA DR 165.0 AVENIDA DR     Berkeley 94708 37.884665186610135 -122.24970080731184
49912 49912 49912 060 248702600 169 Avenida Dr 169 AVENIDA DR 169 AVENIDA DR 169.0 AVENIDA DR     Berkeley 94708 37.88482357072744 -122.24968076320292
52124 52124 52124 060 248203200 33 Avenida Dr 1 33 AVENIDA DR 1 33 AVENIDA DR 33.0 AVENIDA DR 1   Berkeley 94708 37.883696884505504 -122.25190358957624
52471 52471 52471 060 248703100 131 Avenida Dr 131 AVENIDA DR 131 AVENIDA DR 131.0 AVENIDA DR     Berkeley 94708 37.88413028771957 -122.24944711049922
52621 52621 52621 060 248702800 161 Avenida Dr 161 AVENIDA DR 161 AVENIDA DR 161.0 AVENIDA DR     Berkeley 94708 37.884520655922614 -122.24965240249112
53921 53921 53921 060 248203400 29 Avenida Dr 2 29 AVENIDA DR 2 29 AVENIDA DR 29.0 AVENIDA DR 2   Berkeley 94708 37.88350354472871 -122.25216474150744
56346 56346 56346 060 248300100 20 Avenida Dr 20 AVENIDA DR 20 AVENIDA DR 20.0 AVENIDA DR     Berkeley 94708 37.882949311195354 -122.25188326519292
57203 57203 57203 060 248904200 100 Avenida Dr 100 AVENIDA DR 100 AVENIDA DR 100.0 AVENIDA DR     Berkeley 94708 37.883288289743504 -122.2497120461344
57387 57387 57387 060 248903200 122 Avenida Dr 122 AVENIDA DR 122 AVENIDA DR 122.0 AVENIDA DR     Berkeley 94708 37.88365095100452 -122.24943744552506
58131 58131 58131 060 248203700 21 Avenida Dr 21 AVENIDA DR 21 AVENIDA DR 21.0 AVENIDA DR     Berkeley 94708 37.88300046273864 -122.2522518196995

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