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

49 rows where street_name = "HILL"

✎ View and edit SQL

This data as json, CSV (advanced)

street_type 2

zipcode 1

street_name 1

  • HILL · 49 ✖
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
3202 3202 3202 058 224601200 2522 Hill Ct 2522 HILL CT 2522 HILL CT 2522.0 HILL CT     Berkeley 94708 37.87976846409461 -122.26027412103808
6085 6085 6085 058 224601505 2502 Hill Ct 2502 HILL CT 2502 HILL CT 2502.0 HILL CT     Berkeley 94708 37.8798831202058 -122.26112093051704
6834 6834 6834 060 249400601 120 Hill Rd 120 HILL RD 120 HILL RD 120.0 HILL RD     Berkeley 94708 37.88748627909204 -122.25061303390645
7911 7911 7911 058 224601700 2525 Hill Ct 2525 HILL CT 2525 HILL CT 2525.0 HILL CT     Berkeley 94708 37.879913742218825 -122.26011730213892
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
11704 11704 11704 058 224601300 2518 Hill Ct 2518 HILL CT 2518 HILL CT 2518.0 HILL CT     Berkeley 94708 37.879776415281086 -122.2604427240371
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
17249 17249 17249 058 224601600 2514 Hill Ct 2514 HILL CT 2514 HILL CT 2514.0 HILL CT     Berkeley 94708 37.8798437642211 -122.26062668822752
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
23451 23451 23451 058 224602100 2513 Hill Ct 2513 HILL CT 2513 HILL CT 2513.0 HILL CT     Berkeley 94708 37.88005353351789 -122.26063417748205
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
32137 32137 32137 058 224601900 2521 Hill Ct 2521 HILL CT 2521 HILL CT 2521.0 HILL CT     Berkeley 94708 37.880079306348655 -122.2603125383895
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
36512 36512 36512 058 224601506 2512 Hill Ct 2512 HILL CT 2512 HILL CT 2512.0 HILL CT     Berkeley 94708 37.87983040448111 -122.26083310670676
37614 37614 37614 058 224601300 2520 Hill Ct 2520 HILL CT 2520 HILL CT 2520.0 HILL CT     Berkeley 94708 37.879776415281086 -122.2604427240371
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
48855 48855 48855 058 224601506 2510 Hill Ct 2510 HILL CT 2510 HILL CT 2510.0 HILL CT     Berkeley 94708 37.87983040448111 -122.26083310670676
49319 49319 49319 060 249307200 171 Hill Rd 171 HILL RD 171 HILL RD 171.0 HILL RD     Berkeley 94708 37.8866168438699 -122.24946243485962
49475 49475 49475 058 224602300 2509 Hill Ct 2509 HILL CT 2509 HILL CT 2509.0 HILL CT     Berkeley 94708 37.880060750819005 -122.26094009695542
50222 50222 50222 058 224602000 2519 Hill Ct 2519 HILL CT 2519 HILL CT 2519.0 HILL CT     Berkeley 94708 37.88007005694594 -122.2604422640997
52996 52996 52996 060 249400900 140 Hill Rd 140 HILL RD 140 HILL RD 140.0 HILL RD     Berkeley 94708 37.88722989640048 -122.25039438216967
54036 54036 54036 058 224601505 2504 Hill Ct 2504 HILL CT 2504 HILL CT 2504.0 HILL CT     Berkeley 94708 37.8798831202058 -122.26112093051704
55473 55473 55473 058 224602100 2515 Hill Ct 2515 HILL CT 2515 HILL CT 2515.0 HILL CT     Berkeley 94708 37.88005353351789 -122.26063417748205
57106 57106 57106 058 224602400 2501 Hill Ct 2501 HILL CT 2501 HILL CT 2501.0 HILL CT     Berkeley 94708 37.880062222782456 -122.26114916456642
57273 57273 57273 058 224602201 2511 Hill Ct 2511 HILL CT 2511 HILL CT 2511.0 HILL CT     Berkeley 94708 37.88006640469008 -122.26081665585896
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);