Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
49 rows where street_name = "HILL"
This data as json, CSV (advanced)
| 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
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);