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

56 rows where street_type = "CT" and zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

street_name 6

zipcode 1

  • 94705 · 56 ✖

street_type 1

Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
516 516 516 052 157600800 3042 Halcyon Ct 3042 HALCYON CT 3042 HALCYON CT 3042.0 HALCYON CT     Berkeley 94705 37.854349793368115 -122.26140754519496
803 803 803 064 429503300 9 Eton Ct 9 ETON CT 9 ETON CT 9.0 ETON CT     Berkeley 94705 37.85184917262645 -122.2493830354666
1108 1108 1108 064 425502000 40 Roble Ct 40 ROBLE CT 40 ROBLE CT 40.0 ROBLE CT     Berkeley 94705 37.852500640998585 -122.2381403403098
3001 3001 3001 064 429503100 5 Eton Ct 5 ETON CT 5 ETON CT 5.0 ETON CT     Berkeley 94705 37.85211598256747 -122.2494308887218
3600 3600 3600 053 170106102 2817 Palm Ct 2817 PALM CT 2817 PALM CT 2817.0 PALM CT     Berkeley 94705 37.860353689456595 -122.2501050491897
3839 3839 3839 064 425501500 5 Roble Ct 5 ROBLE CT 5 ROBLE CT 5.0 ROBLE CT     Berkeley 94705 37.85277918751188 -122.23706173674144
5013 5013 5013 052 156504600 2910 Elmwood Ct 2910 ELMWOOD CT 2910 ELMWOOD CT 2910.0 ELMWOOD CT     Berkeley 94705 37.85746417639932 -122.24778497210204
5501 5501 5501 052 157604000 3039 Halcyon Ct 3039 HALCYON CT 3039 HALCYON CT 3039.0 HALCYON CT     Berkeley 94705 37.85465142005452 -122.26073883211096
6423 6423 6423 064 424700800 12 Hillcrest Ct 12 HILLCREST CT 12 HILLCREST CT 12.0 HILLCREST CT     Berkeley 94705 37.85357814958102 -122.24780494973564
6648 6648 6648 053 170105900 2827 Palm Ct 2827 PALM CT 2827 PALM CT 2827.0 PALM CT     Berkeley 94705 37.86036685130795 -122.24969141722218
7893 7893 7893 053 170106101 2823 Palm Ct 2823 PALM CT 2823 PALM CT 2823.0 PALM CT     Berkeley 94705 37.860364217944976 -122.24996836602764
8213 8213 8213 053 170106102 2819 Palm Ct 2819 PALM CT 2819 PALM CT 2819.0 PALM CT     Berkeley 94705 37.860353689456595 -122.2501050491897
10817 10817 10817 052 157601000 3048 Halcyon Ct 1 3048 HALCYON CT 1 3048 HALCYON CT 3048.0 HALCYON CT 1   Berkeley 94705 37.85410926638225 -122.2613559540499
12792 12792 12792 052 157604600 3038 Halcyon Ct 3038 HALCYON CT 3038 HALCYON CT 3038.0 HALCYON CT     Berkeley 94705 37.854484083022506 -122.2613868120782
13702 13702 13702 064 424700600 18 Hillcrest Ct 18 HILLCREST CT 18 HILLCREST CT 18.0 HILLCREST CT     Berkeley 94705 37.85375442361445 -122.24739649206415
15255 15255 15255 052 156504500 2908 Elmwood Ct 2908 ELMWOOD CT 2908 ELMWOOD CT 2908.0 ELMWOOD CT     Berkeley 94705 37.85760375567408 -122.24779778387462
16490 16490 16490 064 424700700 16 Hillcrest Ct 16 HILLCREST CT 16 HILLCREST CT 16.0 HILLCREST CT     Berkeley 94705 37.8537649182901 -122.24769370776076
16792 16792 16792 052 157600900 3044 Halcyon Ct A 3044 HALCYON CT A 3044 HALCYON CT 3044.0 HALCYON CT A   Berkeley 94705 37.8542276315669 -122.26138038014078
17132 17132 17132 052 157603700 3045 Halcyon Ct 3045 HALCYON CT 3045 HALCYON CT 3045.0 HALCYON CT     Berkeley 94705 37.85436977961872 -122.26069351749476
17564 17564 17564 064 425002200 5 Hillcrest Ct 5 HILLCREST CT 5 HILLCREST CT 5.0 HILLCREST CT     Berkeley 94705 37.853302076563736 -122.24711317510166
17806 17806 17806 052 156505301 2935 Elmwood Ct 2935 ELMWOOD CT 2935 ELMWOOD CT 2935.0 ELMWOOD CT     Berkeley 94705 37.85743796372007 -122.24715643976238
19734 19734 19734 053 170106101 2821 Palm Ct 2821 PALM CT 2821 PALM CT 2821.0 PALM CT     Berkeley 94705 37.860364217944976 -122.24996836602764
21028 21028 21028 064 429503500 15 Eton Ct 15 ETON CT 15 ETON CT 15.0 ETON CT     Berkeley 94705 37.8519307141254 -122.24982741856292
21195 21195 21195 053 170106000 2825 Palm Ct 2825 PALM CT 2825 PALM CT 2825.0 PALM CT     Berkeley 94705 37.86038253091527 -122.2498338163644
23584 23584 23584 053 170105800 2828 Palm Ct 2828 PALM CT 2828 PALM CT 2828.0 PALM CT     Berkeley 94705 37.86014238815777 -122.24953966751616
26288 26288 26288 052 157601000 3048 Halcyon Ct 2 3048 HALCYON CT 2 3048 HALCYON CT 3048.0 HALCYON CT 2   Berkeley 94705 37.85410926638225 -122.2613559540499
26556 26556 26556 052 157600900 3044 Halcyon Ct B 3044 HALCYON CT B 3044 HALCYON CT 3044.0 HALCYON CT B   Berkeley 94705 37.8542276315669 -122.26138038014078
26974 26974 26974 064 425501600 17 Roble Ct 17 ROBLE CT 17 ROBLE CT 17.0 ROBLE CT     Berkeley 94705 37.85274243082382 -122.2374494460248
28209 28209 28209 052 157600900 3044 Halcyon Ct 3044 HALCYON CT 3044 HALCYON CT 3044.0 HALCYON CT     Berkeley 94705 37.8542276315669 -122.26138038014078
30100 30100 30100 052 157601000 3048 Halcyon Ct 3 3048 HALCYON CT 3 3048 HALCYON CT 3048.0 HALCYON CT 3   Berkeley 94705 37.85410926638225 -122.2613559540499
30342 30342 30342 064 424700900 10 Hillcrest Ct 10 HILLCREST CT 10 HILLCREST CT 10.0 HILLCREST CT     Berkeley 94705 37.85339428141503 -122.24781540432892
32870 32870 32870 064 425002300 9 Hillcrest Ct 9 HILLCREST CT 9 HILLCREST CT 9.0 HILLCREST CT     Berkeley 94705 37.85343242444899 -122.24712227503548
32944 32944 32944 052 156505000 2947 Elmwood Ct 2947 ELMWOOD CT 2947 ELMWOOD CT 2947.0 ELMWOOD CT     Berkeley 94705 37.85709332052097 -122.2471701480536
33128 33128 33128 064 424701101 2 Hillcrest Ct 2 HILLCREST CT 2 HILLCREST CT 2.0 HILLCREST CT     Berkeley 94705 37.85303483185944 -122.24768601818192
34606 34606 34606 052 156504700 2916 Elmwood Ct 2916 ELMWOOD CT 2916 ELMWOOD CT 2916.0 ELMWOOD CT     Berkeley 94705 37.85732226482285 -122.24777026847744
36613 36613 36613 052 156504800 2918 Elmwood Ct 2918 ELMWOOD CT 2918 ELMWOOD CT 2918.0 ELMWOOD CT     Berkeley 94705 37.85718409927645 -122.24775168772412
37899 37899 37899 052 157601000 3048 Halcyon Ct 3048 HALCYON CT 3048 HALCYON CT 3048.0 HALCYON CT     Berkeley 94705 37.85410926638225 -122.2613559540499
38938 38938 38938 064 429502900 1 Eton Ct 1 ETON CT 1 ETON CT 1.0 ETON CT     Berkeley 94705 37.85231552460523 -122.24967989632866
40665 40665 40665 064 429503400 11 Eton Ct 11 ETON CT 11 ETON CT 11.0 ETON CT     Berkeley 94705 37.85179800583772 -122.24972353738347
41822 41822 41822 064 425501800 35 Roble Ct 35 ROBLE CT 35 ROBLE CT 35.0 ROBLE CT     Berkeley 94705 37.852992961964006 -122.23778070337907
42152 42152 42152 064 425502100 24 Roble Ct 24 ROBLE CT 24 ROBLE CT 24.0 ROBLE CT     Berkeley 94705 37.852366019323135 -122.23788742053988
42177 42177 42177 064 424701000 6 Hillcrest Ct 6 HILLCREST CT 6 HILLCREST CT 6.0 HILLCREST CT     Berkeley 94705 37.85326047067831 -122.24773614956467
43356 43356 43356 064 429503200 7 Eton Ct 7 ETON CT 7 ETON CT 7.0 ETON CT     Berkeley 94705 37.85199225091174 -122.24927855870412
43383 43383 43383 052 157603800 3043 Halcyon Ct 3043 HALCYON CT 3043 HALCYON CT 3043.0 HALCYON CT     Berkeley 94705 37.85446374925344 -122.2607121440622
46472 46472 46472 052 157600800 3040 Halcyon Ct 3040 HALCYON CT 3040 HALCYON CT 3040.0 HALCYON CT     Berkeley 94705 37.854349793368115 -122.26140754519496
49153 49153 49153 064 425502200 18 Roble Ct 18 ROBLE CT 18 ROBLE CT 18.0 ROBLE CT     Berkeley 94705 37.852335371674194 -122.23741780466554
50434 50434 50434 064 425502500 44 Roble Ct 44 ROBLE CT 44 ROBLE CT 44.0 ROBLE CT     Berkeley 94705 37.85250752478894 -122.23914130158988
50611 50611 50611 052 157603600 3047 Halcyon Ct 3047 HALCYON CT 3047 HALCYON CT 3047.0 HALCYON CT     Berkeley 94705 37.8542769801869 -122.2606739593744
53207 53207 53207 064 429503000 3 Eton Ct 3 ETON CT 3 ETON CT 3.0 ETON CT     Berkeley 94705 37.85219942471256 -122.24953440069368
54301 54301 54301 052 156504900 2944 Elmwood Ct 2944 ELMWOOD CT 2944 ELMWOOD CT 2944.0 ELMWOOD CT     Berkeley 94705 37.85705638866897 -122.24769044687628
54316 54316 54316 064 425002400 15 Hillcrest Ct 15 HILLCREST CT 15 HILLCREST CT 15.0 HILLCREST CT     Berkeley 94705 37.85362769440049 -122.2471972978364
54388 54388 54388 052 157603500 3049 Halcyon Ct 3049 HALCYON CT 3049 HALCYON CT 3049.0 HALCYON CT     Berkeley 94705 37.85418326069255 -122.26065530046765
55803 55803 55803 064 425502403 8 Roble Ct 8 ROBLE CT 8 ROBLE CT 8.0 ROBLE CT     Berkeley 94705 37.85237824064409 -122.23657074904816
56001 56001 56001 052 156505100 2943 Elmwood Ct 2943 ELMWOOD CT 2943 ELMWOOD CT 2943.0 ELMWOOD CT     Berkeley 94705 37.85722912228053 -122.24713671006376
57583 57583 57583 064 425501700 23 Roble Ct 23 ROBLE CT 23 ROBLE CT 23.0 ROBLE CT     Berkeley 94705 37.85275538053459 -122.23773830828756
58031 58031 58031 052 157603900 3041 Halcyon Ct 3041 HALCYON CT 3041 HALCYON CT 3041.0 HALCYON CT     Berkeley 94705 37.85455588101418 -122.2607307643414

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