Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
92 rows where street_name = "HILLCREST" and zipcode = 94705
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 10 | 10 | 064 425001100 | 145 Hillcrest Rd | 145 HILLCREST RD | 145 HILLCREST RD | 145.0 | HILLCREST | RD | Berkeley | 94705 | 37.853069712308425 | -122.24551551058904 | ||
| 334 | 334 | 334 | 064 425204000 | 162 Hillcrest Rd | 162 HILLCREST RD | 162 HILLCREST RD | 162.0 | HILLCREST | RD | Berkeley | 94705 | 37.85253752619113 | -122.245056896382 | ||
| 492 | 492 | 492 | 064 424701500 | 81 Hillcrest Rd | 81 HILLCREST RD | 81 HILLCREST RD | 81.0 | HILLCREST | RD | Berkeley | 94705 | 37.85236445956179 | -122.24728212754536 | ||
| 850 | 850 | 850 | 064 424901500 | 104 Hillcrest Rd | 104 HILLCREST RD | 104 HILLCREST RD | 104.0 | HILLCREST | RD | Berkeley | 94705 | 37.85263786485812 | -122.24698107963576 | ||
| 2278 | 2278 | 2278 | 064 424900100 | 120 Hillcrest Rd | 120 HILLCREST RD | 120 HILLCREST RD | 120.0 | HILLCREST | RD | Berkeley | 94705 | 37.85284380408093 | -122.24709150594038 | ||
| 2505 | 2505 | 2505 | 064 425205400 | 220 Hillcrest Rd | 220 HILLCREST RD | 220 HILLCREST RD | 220.0 | HILLCREST | RD | Berkeley | 94705 | 37.85211336380512 | -122.24265447163054 | ||
| 2874 | 2874 | 2874 | 064 425200300 | 262 Hillcrest Rd | 262 HILLCREST RD | 262 HILLCREST RD | 262.0 | HILLCREST | RD | Berkeley | 94705 | 37.85214000750845 | -122.24159298635824 | ||
| 3349 | 3349 | 3349 | 064 425001401 | 125 Hillcrest Rd | 125 HILLCREST RD | 125 HILLCREST RD | 125.0 | HILLCREST | RD | Berkeley | 94705 | 37.853100093665375 | -122.24623059111477 | ||
| 3378 | 3378 | 3378 | 064 429500700 | 20 Hillcrest Rd | 20 HILLCREST RD | 20 HILLCREST RD | 20.0 | HILLCREST | RD | Berkeley | 94705 | 37.85268346659185 | -122.24880596581296 | ||
| 4525 | 4525 | 4525 | 064 425901801 | 263 Hillcrest Rd | 263 HILLCREST RD | 263 HILLCREST RD | 263.0 | HILLCREST | RD | Berkeley | 94705 | 37.85247259158551 | -122.24139984408058 | ||
| 5383 | 5383 | 5383 | 064 425204601 | 186 Hillcrest Rd | 186 HILLCREST RD | 186 HILLCREST RD | 186.0 | HILLCREST | RD | Berkeley | 94705 | 37.852430898696866 | -122.24394236379553 | ||
| 6383 | 6383 | 6383 | 064 429501400 | 54 Hillcrest Rd | 54 HILLCREST RD | 54 HILLCREST RD | 54.0 | HILLCREST | RD | Berkeley | 94705 | 37.851999548276346 | -122.2475982258292 | ||
| 6423 | 6423 | 6423 | 064 424700800 | 12 Hillcrest Ct | 12 HILLCREST CT | 12 HILLCREST CT | 12.0 | HILLCREST | CT | Berkeley | 94705 | 37.85357814958102 | -122.24780494973564 | ||
| 8382 | 8382 | 8382 | 064 425200100 | 254 Hillcrest Rd | 254 HILLCREST RD | 254 HILLCREST RD | 254.0 | HILLCREST | RD | Berkeley | 94705 | 37.85237540697178 | -122.2418171735138 | ||
| 9284 | 9284 | 9284 | 064 429500800 | 24 Hillcrest Rd | 24 HILLCREST RD | 24 HILLCREST RD | 24.0 | HILLCREST | RD | Berkeley | 94705 | 37.85257499441207 | -122.248687674758 | ||
| 11194 | 11194 | 11194 | 064 425101600 | 165 Hillcrest Rd | 165 HILLCREST RD | 165 HILLCREST RD | 165.0 | HILLCREST | RD | Berkeley | 94705 | 37.85303769175047 | -122.2446702426191 | ||
| 12410 | 12410 | 12410 | 064 424900900 | 70 Hillcrest Rd | 70 HILLCREST RD | 70 HILLCREST RD | 70.0 | HILLCREST | RD | Berkeley | 94705 | 37.851686358186946 | -122.2469186341471 | ||
| 13207 | 13207 | 13207 | 064 425001700 | 115 Hillcrest Rd | 115 HILLCREST RD | 115 HILLCREST RD | 115.0 | HILLCREST | RD | Berkeley | 94705 | 37.85314758680915 | -122.24657425959302 | ||
| 13702 | 13702 | 13702 | 064 424700600 | 18 Hillcrest Ct | 18 HILLCREST CT | 18 HILLCREST CT | 18.0 | HILLCREST | CT | Berkeley | 94705 | 37.85375442361445 | -122.24739649206415 | ||
| 14694 | 14694 | 14694 | 064 425200400 | 266 Hillcrest Rd Flat | 266 HILLCREST RD FLAT | 266 HILLCREST RD | 266.0 | HILLCREST | RD | FLAT | Berkeley | 94705 | 37.85199836160348 | -122.24155966245446 | |
| 15482 | 15482 | 15482 | 064 425205300 | 214 Hillcrest Rd | 214 HILLCREST RD | 214 HILLCREST RD | 214.0 | HILLCREST | RD | Berkeley | 94705 | 37.85211073511241 | -122.2428213166266 | ||
| 16488 | 16488 | 16488 | 064 425001801 | 109 Hillcrest Rd | 109 HILLCREST RD | 109 HILLCREST RD | 109.0 | HILLCREST | RD | Berkeley | 94705 | 37.85325363660898 | -122.24674226611074 | ||
| 16490 | 16490 | 16490 | 064 424700700 | 16 Hillcrest Ct | 16 HILLCREST CT | 16 HILLCREST CT | 16.0 | HILLCREST | CT | Berkeley | 94705 | 37.8537649182901 | -122.24769370776076 | ||
| 16703 | 16703 | 16703 | 064 424702100 | 15 Hillcrest Rd | 15 HILLCREST RD | 15 HILLCREST RD | 15.0 | HILLCREST | RD | Berkeley | 94705 | 37.85319749011292 | -122.24828149790902 | ||
| 17564 | 17564 | 17564 | 064 425002200 | 5 Hillcrest Ct | 5 HILLCREST CT | 5 HILLCREST CT | 5.0 | HILLCREST | CT | Berkeley | 94705 | 37.853302076563736 | -122.24711317510166 | ||
| 17706 | 17706 | 17706 | 064 424901100 | 82 Hillcrest Rd | 82 HILLCREST RD | 82 HILLCREST RD | 82.0 | HILLCREST | RD | Berkeley | 94705 | 37.85200194786642 | -122.246824606588 | ||
| 18604 | 18604 | 18604 | 064 425101400 | 173 Hillcrest Rd | 173 HILLCREST RD | 173 HILLCREST RD | 173.0 | HILLCREST | RD | Berkeley | 94705 | 37.85302322277187 | -122.24432884328525 | ||
| 18675 | 18675 | 18675 | 064 425203700 | 152 Hillcrest Rd | 152 HILLCREST RD | 152 HILLCREST RD | 152.0 | HILLCREST | RD | Berkeley | 94705 | 37.85255278259137 | -122.24558556570648 | ||
| 19319 | 19319 | 19319 | 064 429501500 | 58 Hillcrest Rd | 58 HILLCREST RD | 58 HILLCREST RD | 58.0 | HILLCREST | RD | Berkeley | 94705 | 37.85183748178159 | -122.24766056262172 | ||
| 20229 | 20229 | 20229 | 064 425100200 | 233 Hillcrest Rd | 233 HILLCREST RD | 233 HILLCREST RD | 233.0 | HILLCREST | RD | Berkeley | 94705 | 37.852752370260774 | -122.2421901216804 | ||
| 20563 | 20563 | 20563 | 064 424701700 | 35 Hillcrest Rd | 35 HILLCREST RD | 35 HILLCREST RD | 35.0 | HILLCREST | RD | Berkeley | 94705 | 37.85275526633709 | -122.2477996649468 | ||
| 21960 | 21960 | 21960 | 064 425200400 | 266 Hillcrest Rd | 266 HILLCREST RD | 266 HILLCREST RD | 266.0 | HILLCREST | RD | Berkeley | 94705 | 37.85199836160348 | -122.24155966245446 | ||
| 22383 | 22383 | 22383 | 064 425100701 | 203 Hillcrest Rd | 203 HILLCREST RD | 203 HILLCREST RD | 203.0 | HILLCREST | RD | Berkeley | 94705 | 37.85277528564785 | -122.24311512680994 | ||
| 22453 | 22453 | 22453 | 064 425100502 | 215 Hillcrest Rd | 215 HILLCREST RD | 215 HILLCREST RD | 215.0 | HILLCREST | RD | Berkeley | 94705 | 37.85267462585411 | -122.24287396329213 | ||
| 22767 | 22767 | 22767 | 064 425203900 | 158 Hillcrest Rd | 158 HILLCREST RD | 158 HILLCREST RD | 158.0 | HILLCREST | RD | Berkeley | 94705 | 37.85254370776793 | -122.2452276724057 | ||
| 23266 | 23266 | 23266 | 064 425100800 | 199 Hillcrest Rd | 199 HILLCREST RD | 199 HILLCREST RD | 199.0 | HILLCREST | RD | Berkeley | 94705 | 37.852868901246346 | -122.24329932456232 | ||
| 23810 | 23810 | 23810 | 064 425101300 | 177 Hillcrest Rd | 177 HILLCREST RD | 177 HILLCREST RD | 177.0 | HILLCREST | RD | Berkeley | 94705 | 37.85301018515514 | -122.24415368797452 | ||
| 24404 | 24404 | 24404 | 064 425100400 | 217 Hillcrest Rd | 217 HILLCREST RD | 217 HILLCREST RD | 217.0 | HILLCREST | RD | Berkeley | 94705 | 37.852625582580174 | -122.24261204150474 | ||
| 24792 | 24792 | 24792 | 064 425203600 | 142 Hillcrest Rd | 142 HILLCREST RD | 142 HILLCREST RD | 142.0 | HILLCREST | RD | Berkeley | 94705 | 37.85255964509777 | -122.24582988051432 | ||
| 24978 | 24978 | 24978 | 064 425205500 | 226 Hillcrest Rd | 226 HILLCREST RD | 226 HILLCREST RD | 226.0 | HILLCREST | RD | Berkeley | 94705 | 37.85215377799309 | -122.24248442683547 | ||
| 25282 | 25282 | 25282 | 064 425204300 | 172 Hillcrest Rd | 172 HILLCREST RD | 172 HILLCREST RD | 172.0 | HILLCREST | RD | Berkeley | 94705 | 37.85251648116317 | -122.24454111698354 | ||
| 26280 | 26280 | 26280 | 064 424701300 | 89 Hillcrest Rd | 89 HILLCREST RD | 89 HILLCREST RD | 89.0 | HILLCREST | RD | Berkeley | 94705 | 37.85268827423904 | -122.2476156594339 | ||
| 26735 | 26735 | 26735 | 064 429500901 | 28 Hillcrest Rd | 28 HILLCREST RD | 28 HILLCREST RD | 28.0 | HILLCREST | RD | Berkeley | 94705 | 37.85247060766275 | -122.24837491551204 | ||
| 27284 | 27284 | 27284 | 064 425101800 | 159 Hillcrest Rd | 159 HILLCREST RD | 159 HILLCREST RD | 159.0 | HILLCREST | RD | Berkeley | 94705 | 37.853052799803834 | -122.24504825458897 | ||
| 28117 | 28117 | 28117 | 064 425001200 | 143 Hillcrest Rd | 143 HILLCREST RD | 143 HILLCREST RD | 143.0 | HILLCREST | RD | Berkeley | 94705 | 37.85307652866235 | -122.24572510281618 | ||
| 28159 | 28159 | 28159 | 064 425001300 | 139 Hillcrest Rd | 139 HILLCREST RD | 139 HILLCREST RD | 139.0 | HILLCREST | RD | Berkeley | 94705 | 37.85308089793776 | -122.24589764582608 | ||
| 30342 | 30342 | 30342 | 064 424700900 | 10 Hillcrest Ct | 10 HILLCREST CT | 10 HILLCREST CT | 10.0 | HILLCREST | CT | Berkeley | 94705 | 37.85339428141503 | -122.24781540432892 | ||
| 31231 | 31231 | 31231 | 064 424702000 | 19 Hillcrest Rd | 19 HILLCREST RD | 19 HILLCREST RD | 19.0 | HILLCREST | RD | Berkeley | 94705 | 37.85301160588022 | -122.24824326561054 | ||
| 31581 | 31581 | 31581 | 064 429501600 | 66 Hillcrest Rd | 66 HILLCREST RD | 66 HILLCREST RD | 66.0 | HILLCREST | RD | Berkeley | 94705 | 37.85167766202924 | -122.24784208788611 | ||
| 31705 | 31705 | 31705 | 064 424901400 | 98 Hillcrest Rd | 98 HILLCREST RD | 98 HILLCREST RD | 98.0 | HILLCREST | RD | Berkeley | 94705 | 37.85250035940513 | -122.2469093895845 | ||
| 32059 | 32059 | 32059 | 064 425101100 | 185 Hillcrest Rd | 185 HILLCREST RD | 185 HILLCREST RD | 185.0 | HILLCREST | RD | Berkeley | 94705 | 37.85296848547752 | -122.2438124934566 | ||
| 32439 | 32439 | 32439 | 064 424901300 | 92 Hillcrest Rd | 92 HILLCREST RD | 92 HILLCREST RD | 92.0 | HILLCREST | RD | Berkeley | 94705 | 37.852338010289174 | -122.24684485820777 | ||
| 32531 | 32531 | 32531 | 064 425204400 | 178 Hillcrest Rd | 178 HILLCREST RD | 178 HILLCREST RD | 178.0 | HILLCREST | RD | Berkeley | 94705 | 37.85250766168455 | -122.24437024753502 | ||
| 32808 | 32808 | 32808 | 064 425203800 | 156 Hillcrest Rd | 156 HILLCREST RD | 156 HILLCREST RD | 156.0 | HILLCREST | RD | Berkeley | 94705 | 37.85254821113324 | -122.24540010043124 | ||
| 32870 | 32870 | 32870 | 064 425002300 | 9 Hillcrest Ct | 9 HILLCREST CT | 9 HILLCREST CT | 9.0 | HILLCREST | CT | Berkeley | 94705 | 37.85343242444899 | -122.24712227503548 | ||
| 33128 | 33128 | 33128 | 064 424701101 | 2 Hillcrest Ct | 2 HILLCREST CT | 2 HILLCREST CT | 2.0 | HILLCREST | CT | Berkeley | 94705 | 37.85303483185944 | -122.24768601818192 | ||
| 33208 | 33208 | 33208 | 064 425200200 | 258 Hillcrest Rd | 258 HILLCREST RD | 258 HILLCREST RD | 258.0 | HILLCREST | RD | Berkeley | 94705 | 37.85225306386313 | -122.2417555248308 | ||
| 33563 | 33563 | 33563 | 064 425901901 | 257 Hillcrest Rd | 257 HILLCREST RD | 257 HILLCREST RD | 257.0 | HILLCREST | RD | Berkeley | 94705 | 37.85257739823925 | -122.24150805064812 | ||
| 33651 | 33651 | 33651 | 064 425205200 | 210 Hillcrest Rd | 210 HILLCREST RD | 210 HILLCREST RD | 210.0 | HILLCREST | RD | Berkeley | 94705 | 37.85213368403639 | -122.24299224985548 | ||
| 33773 | 33773 | 33773 | 064 425205600 | 230 Hillcrest Rd | 230 HILLCREST RD | 230 HILLCREST RD | 230.0 | HILLCREST | RD | Berkeley | 94705 | 37.852247092216494 | -122.24230001169082 | ||
| 34144 | 34144 | 34144 | 064 425204900 | 200 Hillcrest Rd | 200 HILLCREST RD | 200 HILLCREST RD | 200.0 | HILLCREST | RD | Berkeley | 94705 | 37.85227737248171 | -122.24351613295612 | ||
| 36319 | 36319 | 36319 | 064 424901200 | 86 Hillcrest Rd | 86 HILLCREST RD | 86 HILLCREST RD | 86.0 | HILLCREST | RD | Berkeley | 94705 | 37.85216996224592 | -122.24682358430518 | ||
| 36470 | 36470 | 36470 | 064 425101700 | 161 Hillcrest Rd | 161 HILLCREST RD | 161 HILLCREST RD | 161.0 | HILLCREST | RD | Berkeley | 94705 | 37.85304598344776 | -122.24485317464526 | ||
| 36589 | 36589 | 36589 | 064 425200400 | 266 Hillcrest Rd B | 266 HILLCREST RD B | 266 HILLCREST RD | 266.0 | HILLCREST | RD | B | Berkeley | 94705 | 37.85199836160348 | -122.24155966245446 | |
| 37912 | 37912 | 37912 | 064 429501300 | 50 Hillcrest Rd | 50 HILLCREST RD | 50 HILLCREST RD | 50.0 | HILLCREST | RD | Berkeley | 94705 | 37.852240148110795 | -122.24765285148332 | ||
| 38052 | 38052 | 38052 | 064 425204500 | 180 Hillcrest Rd | 180 HILLCREST RD | 180 HILLCREST RD | 180.0 | HILLCREST | RD | Berkeley | 94705 | 37.85248519875003 | -122.24419744581034 | ||
| 42177 | 42177 | 42177 | 064 424701000 | 6 Hillcrest Ct | 6 HILLCREST CT | 6 HILLCREST CT | 6.0 | HILLCREST | CT | Berkeley | 94705 | 37.85326047067831 | -122.24773614956467 | ||
| 44967 | 44967 | 44967 | 064 425101500 | 167 Hillcrest Rd | 167 HILLCREST RD | 167 HILLCREST RD | 167.0 | HILLCREST | RD | Berkeley | 94705 | 37.853031017961904 | -122.2444986742813 | ||
| 45194 | 45194 | 45194 | 064 425101200 | 181 Hillcrest Rd | 181 HILLCREST RD | 181 HILLCREST RD | 181.0 | HILLCREST | RD | Berkeley | 94705 | 37.852991926387794 | -122.24398442112047 | ||
| 45926 | 45926 | 45926 | 064 424701900 | 25 Hillcrest Rd | 25 HILLCREST RD | 25 HILLCREST RD | 25.0 | HILLCREST | RD | Berkeley | 94705 | 37.85286166142111 | -122.24816409888118 | ||
| 46273 | 46273 | 46273 | 064 429501000 | 32 Hillcrest Rd | 32 HILLCREST RD | 32 HILLCREST RD | 32.0 | HILLCREST | RD | Berkeley | 94705 | 37.85237478633011 | -122.2481954860172 | ||
| 47044 | 47044 | 47044 | 064 429500500 | 10 Hillcrest Rd | 10 HILLCREST RD | 10 HILLCREST RD | 10.0 | HILLCREST | RD | Berkeley | 94705 | 37.85296885785946 | -122.24885537584848 | ||
| 47444 | 47444 | 47444 | 064 424901000 | 76 Hillcrest Rd | 76 HILLCREST RD | 76 HILLCREST RD | 76.0 | HILLCREST | RD | Berkeley | 94705 | 37.85184337118143 | -122.24688028237266 | ||
| 48222 | 48222 | 48222 | 064 429501200 | 40 Hillcrest Rd | 40 HILLCREST RD | 40 HILLCREST RD | 40.0 | HILLCREST | RD | Berkeley | 94705 | 37.852275436786506 | -122.24787642149629 | ||
| 48942 | 48942 | 48942 | 064 425204800 | 196 Hillcrest Rd | 196 HILLCREST RD | 196 HILLCREST RD | 196.0 | HILLCREST | RD | Berkeley | 94705 | 37.852346495705426 | -122.24368848013329 | ||
| 49058 | 49058 | 49058 | 064 425204102 | 166 Hillcrest Rd | 166 HILLCREST RD | 166 HILLCREST RD | 166.0 | HILLCREST | RD | Berkeley | 94705 | 37.85253099209002 | -122.24488351704058 | ||
| 49340 | 49340 | 49340 | 064 424701400 | 85 Hillcrest Rd | 85 HILLCREST RD | 85 HILLCREST RD | 85.0 | HILLCREST | RD | Berkeley | 94705 | 37.852550072344464 | -122.24747179783444 | ||
| 50354 | 50354 | 50354 | 064 425901600 | 267 Hillcrest Rd | 267 HILLCREST RD | 267 HILLCREST RD | 267.0 | HILLCREST | RD | Berkeley | 94705 | 37.85224366343138 | -122.24117221458084 | ||
| 51230 | 51230 | 51230 | 064 425205000 | 202 Hillcrest Rd | 202 HILLCREST RD | 202 HILLCREST RD | 202.0 | HILLCREST | RD | Berkeley | 94705 | 37.852215153580744 | -122.2433353523951 | ||
| 51634 | 51634 | 51634 | 064 425901700 | 265 Hillcrest Rd | 265 HILLCREST RD | 265 HILLCREST RD | 265.0 | HILLCREST | RD | Berkeley | 94705 | 37.852350609674325 | -122.24130862375672 | ||
| 52829 | 52829 | 52829 | 064 425001902 | 101 Hillcrest Rd | 101 HILLCREST RD | 101 HILLCREST RD | 101.0 | HILLCREST | RD | Berkeley | 94705 | 37.85317774541474 | -122.2470987607346 | ||
| 54316 | 54316 | 54316 | 064 425002400 | 15 Hillcrest Ct | 15 HILLCREST CT | 15 HILLCREST CT | 15.0 | HILLCREST | CT | Berkeley | 94705 | 37.85362769440049 | -122.2471972978364 | ||
| 54622 | 54622 | 54622 | 064 425101900 | 151 Hillcrest Rd | 151 HILLCREST RD | 151 HILLCREST RD | 151.0 | HILLCREST | RD | Berkeley | 94705 | 37.85306056732812 | -122.245239785289 | ||
| 54923 | 54923 | 54923 | 064 429501100 | 36 Hillcrest Rd | 36 HILLCREST RD | 36 HILLCREST RD | 36.0 | HILLCREST | RD | Berkeley | 94705 | 37.85233193792808 | -122.24802760077208 | ||
| 55226 | 55226 | 55226 | 064 425101000 | 189 Hillcrest Rd | 189 HILLCREST RD | 189 HILLCREST RD | 189.0 | HILLCREST | RD | Berkeley | 94705 | 37.852938985016024 | -122.24363780437147 | ||
| 55264 | 55264 | 55264 | 064 425100900 | 193 Hillcrest Rd | 193 HILLCREST RD | 193 HILLCREST RD | 193.0 | HILLCREST | RD | Berkeley | 94705 | 37.85290394207557 | -122.24346832731167 | ||
| 55390 | 55390 | 55390 | 064 429500400 | 6 Hillcrest Rd | 6 HILLCREST RD | 6 HILLCREST RD | 6.0 | HILLCREST | RD | Berkeley | 94705 | 37.85314648385183 | -122.2488623925892 | ||
| 55445 | 55445 | 55445 | 064 425100300 | 225 Hillcrest Rd | 225 HILLCREST RD | 225 HILLCREST RD | 225.0 | HILLCREST | RD | Berkeley | 94705 | 37.85267867029316 | -122.24242985058874 | ||
| 55462 | 55462 | 55462 | 064 425200600 | 240 Hillcrest Rd | 240 HILLCREST RD | 240 HILLCREST RD | 240.0 | HILLCREST | RD | Berkeley | 94705 | 37.85249297342712 | -122.24213656412316 | ||
| 55465 | 55465 | 55465 | 064 424701800 | 29 Hillcrest Rd | 29 HILLCREST RD | 29 HILLCREST RD | 29.0 | HILLCREST | RD | Berkeley | 94705 | 37.85280576926541 | -122.24798284490798 | ||
| 56434 | 56434 | 56434 | 064 425204200 | 170 Hillcrest Rd | 170 HILLCREST RD | 170 HILLCREST RD | 170.0 | HILLCREST | RD | Berkeley | 94705 | 37.852524290592825 | -122.2447101403941 | ||
| 57707 | 57707 | 57707 | 064 425205100 | 206 Hillcrest Rd | 206 HILLCREST RD | 206 HILLCREST RD | 206.0 | HILLCREST | RD | Berkeley | 94705 | 37.85216495808696 | -122.24316193532444 |
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);