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

33 rows where street_name = "HILL" and street_type = "RD"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • HILL · 33 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
89 89 89 060 249400301 104 Hill Rd 104 HILL RD 104 HILL RD 104.0 HILL RD     Berkeley 94708 37.887867387461775 -122.25092691155494
750 750 750 060 249502100 121 Hill Rd 121 HILL RD 121 HILL RD 121.0 HILL RD     Berkeley 94708 37.88756490559485 -122.25011621435038
1822 1822 1822 060 249400401 108 Hill Rd 108 HILL RD 108 HILL RD 108.0 HILL RD     Berkeley 94708 37.8877387743483 -122.25086200647904
6834 6834 6834 060 249400601 120 Hill Rd 120 HILL RD 120 HILL RD 120.0 HILL RD     Berkeley 94708 37.88748627909204 -122.25061303390645
8993 8993 8993 060 249401200 156 Hill Rd 1 156 HILL RD 1 156 HILL RD 156.0 HILL RD 1   Berkeley 94708 37.88687732159528 -122.2501865560304
9274 9274 9274 060 249400800 134 Hill Rd 134 HILL RD 134 HILL RD 134.0 HILL RD     Berkeley 94708 37.887338316154704 -122.25047392349651
10106 10106 10106 063 316102403 55 Hill Rd 55 HILL RD 55 HILL RD 55.0 HILL RD     Berkeley 94708 37.889351604536024 -122.25086869084306
10252 10252 10252 063 316003100 30 Hill Rd 30 HILL RD 30 HILL RD 30.0 HILL RD     Berkeley 94708 37.889776598286936 -122.25177580961696
13462 13462 13462 060 249401200 156 Hill Rd 2 156 HILL RD 2 156 HILL RD 156.0 HILL RD 2   Berkeley 94708 37.88687732159528 -122.2501865560304
14659 14659 14659 063 316100700 80 Hill Rd 80 HILL RD 80 HILL RD 80.0 HILL RD     Berkeley 94708 37.88834704057574 -122.25104446778796
15172 15172 15172 060 249400500 116 Hill Rd 116 HILL RD 116 HILL RD 116.0 HILL RD     Berkeley 94708 37.88763904355435 -122.25075597203784
15430 15430 15430 063 316003500 12 Hill Rd 12 HILL RD 12 HILL RD 12.0 HILL RD     Berkeley 94708 37.89035177496415 -122.25195818109437
15936 15936 15936 063 316002900 34 Hill Rd 34 HILL RD 34 HILL RD 34.0 HILL RD     Berkeley 94708 37.88957281467369 -122.2514542926953
17799 17799 17799 063 316102600 48 Hill Rd 48 HILL RD 48 HILL RD 48.0 HILL RD     Berkeley 94708 37.88899294360983 -122.25125429627202
19859 19859 19859 060 249401000 144 Hill Rd 144 HILL RD 144 HILL RD 144.0 HILL RD     Berkeley 94708 37.88712360694237 -122.25032238130132
21828 21828 21828 063 316101600 75 Hill Rd 75 HILL RD 75 HILL RD 75.0 HILL RD     Berkeley 94708 37.88887124475899 -122.2505627192674
24478 24478 24478 060 249401100 150 Hill Rd 150 HILL RD 150 HILL RD 150.0 HILL RD     Berkeley 94708 37.887015928456 -122.25026405548658
26979 26979 26979 060 249401200 156 Hill Rd 156 HILL RD 156 HILL RD 156.0 HILL RD     Berkeley 94708 37.88687732159528 -122.2501865560304
28759 28759 28759 060 249307300 159 Hill Rd 159 HILL RD 159 HILL RD 159.0 HILL RD     Berkeley 94708 37.88684431536568 -122.2496406740867
28889 28889 28889 063 316100200 40 Hill Rd 40 HILL RD 40 HILL RD 40.0 HILL RD     Berkeley 94708 37.88932954629859 -122.25132555603028
31187 31187 31187 060 249306901 185 Hill Rd 185 HILL RD 185 HILL RD 185.0 HILL RD     Berkeley 94708 37.886316727688445 -122.2492040191968
33867 33867 33867 060 249400200 100 Hill Rd 100 HILL RD 100 HILL RD 100.0 HILL RD     Berkeley 94708 37.88800942525169 -122.25099100006224
34510 34510 34510 063 316100900 90 Hill Rd 90 HILL RD 90 HILL RD 90.0 HILL RD     Berkeley 94708 37.888381322256535 -122.2507715380451
34815 34815 34815 063 316002405 41 Hill Rd 41 HILL RD 41 HILL RD 41.0 HILL RD     Berkeley 94708 37.889596730278 -122.25034926518283
38083 38083 38083 063 316001900 11 Hill Rd 11 HILL RD 11 HILL RD 11.0 HILL RD     Berkeley 94708 37.89042786962352 -122.25153373430916
40628 40628 40628 060 249401300 160 Hill Rd 160 HILL RD 160 HILL RD 160.0 HILL RD     Berkeley 94708 37.886748550778265 -122.25010878887625
43276 43276 43276 060 249401500 168 Hill Rd 168 HILL RD 168 HILL RD 168.0 HILL RD     Berkeley 94708 37.88647457652115 -122.24989056204258
44980 44980 44980 063 316001601 37 Hill Rd 37 HILL RD 37 HILL RD 37.0 HILL RD     Berkeley 94708 37.89014054976915 -122.25110008787708
45141 45141 45141 063 316002101 29 Hill Rd 29 HILL RD 29 HILL RD 29.0 HILL RD     Berkeley 94708 37.89001963123396 -122.25130807122156
46319 46319 46319 063 316102504 57 Hill Rd 57 HILL RD 57 HILL RD 57.0 HILL RD     Berkeley 94708 37.889273082029895 -122.25065051701
49319 49319 49319 060 249307200 171 Hill Rd 171 HILL RD 171 HILL RD 171.0 HILL RD     Berkeley 94708 37.8866168438699 -122.24946243485962
52996 52996 52996 060 249400900 140 Hill Rd 140 HILL RD 140 HILL RD 140.0 HILL RD     Berkeley 94708 37.88722989640048 -122.25039438216967
58319 58319 58319 060 249401400 164 Hill Rd 164 HILL RD 164 HILL RD 164.0 HILL RD     Berkeley 94708 37.886618414958825 -122.25001019068895

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