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

646 rows where street_name = "BANCROFT" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

zipcode 1

  • 94704 · 646 ✖

street_type 1

street_name 1

  • BANCROFT · 646 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
178 178 178 055 187701902 2560 Bancroft Way 166 2560 BANCROFT WAY 166 2560 BANCROFT WY 2560.0 BANCROFT WY 166   Berkeley 94704 37.868744223283414 -122.25767525629354
220 220 220 055 187701300 2510 Bancroft Way 310 2510 BANCROFT WAY 310 2510 BANCROFT WY 2510.0 BANCROFT WY 310   Berkeley 94704 37.86853942270108 -122.25886489252936
250 250 250 055 187701902 2580 Bancroft Way Apt 506 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 506 APT Berkeley 94704 37.86863805606804 -122.25762325910996
252 252 252 055 187001501 2736 Bancroft Way 2736 BANCROFT WAY 2736 BANCROFT WY 2736.0 BANCROFT WY     Berkeley 94704 37.869221065802336 -122.25295637646164
255 255 255 055 187701902 2580 Bancroft Way Apt 408 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 408 APT Berkeley 94704 37.86862112869765 -122.25756914010566
299 299 299 055 187701300 2510 Bancroft Way 204 2510 BANCROFT WAY 204 2510 BANCROFT WY 2510.0 BANCROFT WY 204   Berkeley 94704 37.86853942270108 -122.25886489252936
423 423 423 055 187701902 2580 Bancroft Way Apt 606 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 606 APT Berkeley 94704 37.86866084808889 -122.25762981501492
511 511 511 055 189300701 2124 Bancroft Way Apt 309 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 309 APT Berkeley 94704 37.86725807967805 -122.26648072776143
740 740 740 055 189401401 2020 Bancroft Way 402 2020 BANCROFT WAY 402 2020 BANCROFT WY 2020.0 BANCROFT WY 402   Berkeley 94704 37.86695279564912 -122.26925847223184
809 809 809 055 187801900 2452 Bancroft Way 5 2452 BANCROFT WAY 5 2452 BANCROFT WY 2452.0 BANCROFT WY 5   Berkeley 94704 37.86830536622177 -122.26018143107042
973 973 973 057 202801402 2005 Bancroft Way 316 2005 BANCROFT WAY 316 2005 BANCROFT WY 2005.0 BANCROFT WY 316   Berkeley 94704 37.8678249152641 -122.26942837149984
1163 1163 1163 055 187801700 2428 Bancroft Way 1 2428 BANCROFT WAY 1 2428 BANCROFT WY 2428.0 BANCROFT WY 1   Berkeley 94704 37.868237121001386 -122.26069700116142
1167 1167 1167 055 187701902 2580 Bancroft Way Apt 404 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 404 APT Berkeley 94704 37.86860827609093 -122.25766552214913
1280 1280 1280 055 187802100 2468 Bancroft Way 10 2468 BANCROFT WAY 10 2468 BANCROFT WY 2468.0 BANCROFT WY 10   Berkeley 94704 37.86835075828235 -122.2598204269038
1335 1335 1335 057 202801402 2005 Bancroft Way 341 2005 BANCROFT WAY 341 2005 BANCROFT WY 2005.0 BANCROFT WY 341   Berkeley 94704 37.8678249152641 -122.26942837149984
1369 1369 1369 055 187701300 2510 Bancroft Way 320 2510 BANCROFT WAY 320 2510 BANCROFT WY 2510.0 BANCROFT WY 320   Berkeley 94704 37.86853942270108 -122.25886489252936
1371 1371 1371 055 189300701 2124 Bancroft Way Apt 504 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 504 APT Berkeley 94704 37.867435596066485 -122.26656526731452
1399 1399 1399 055 189401401 2020 Bancroft Way 313 2020 BANCROFT WAY 313 2020 BANCROFT WY 2020.0 BANCROFT WY 313   Berkeley 94704 37.86695279564912 -122.26925847223184
1558 1558 1558 055 187701902 2580 Bancroft Way Apt 706 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 706 APT Berkeley 94704 37.86868460312538 -122.25763579150647
1592 1592 1592 055 187701902 2560 Bancroft Way 21 2560 BANCROFT WAY 21 2560 BANCROFT WY 2560.0 BANCROFT WY 21   Berkeley 94704 37.868744223283414 -122.25767525629354
1723 1723 1723 055 189401401 2020 Bancroft Way 321 2020 BANCROFT WAY 321 2020 BANCROFT WY 2020.0 BANCROFT WY 321   Berkeley 94704 37.86695279564912 -122.26925847223184
2029 2029 2029 055 187701902 2580 Bancroft Way Apt 816 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 816 APT Berkeley 94704 37.868737298460495 -122.25741757006271
2366 2366 2366 055 187701902 2560 Bancroft Way 87 2560 BANCROFT WAY 87 2560 BANCROFT WY 2560.0 BANCROFT WY 87   Berkeley 94704 37.868744223283414 -122.25767525629354
2386 2386 2386 055 187701902 2580 Bancroft Way Apt 507 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 507 APT Berkeley 94704 37.868641326659635 -122.25759873600104
2389 2389 2389 055 187701902 2580 Bancroft Way Apt 414 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 414 APT Berkeley 94704 37.86863869713807 -122.2574373931861
2418 2418 2418 055 187701902 2580 Bancroft Way Apt 403 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 403 APT Berkeley 94704 37.868604815446055 -122.25769147268106
2514 2514 2514 055 189300701 2124 Bancroft Way Apt 603 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 603 APT Berkeley 94704 37.86746794792993 -122.26659550101373
2721 2721 2721 057 202801402 2005 Bancroft Way 226 2005 BANCROFT WAY 226 2005 BANCROFT WY 2005.0 BANCROFT WY 226   Berkeley 94704 37.8678249152641 -122.26942837149984
2735 2735 2735 055 187701902 2580 Bancroft Way Apt 701 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 701 APT Berkeley 94704 37.868667541027605 -122.257763743044
2842 2842 2842 055 187701902 2554 Bancroft Way 2 2554 BANCROFT WAY 2 2554 BANCROFT WY 2554.0 BANCROFT WY 2   Berkeley 94704 37.8687325854675 -122.25777266960296
3003 3003 3003 055 189401401 2020 Bancroft Way 224 2020 BANCROFT WAY 224 2020 BANCROFT WY 2020.0 BANCROFT WY 224   Berkeley 94704 37.86695279564912 -122.26925847223184
3058 3058 3058 057 202801402 2005 Bancroft Way 426 2005 BANCROFT WAY 426 2005 BANCROFT WY 2005.0 BANCROFT WY 426   Berkeley 94704 37.8678249152641 -122.26942837149984
3104 3104 3104 057 202801402 2005 Bancroft Way 340 2005 BANCROFT WAY 340 2005 BANCROFT WY 2005.0 BANCROFT WY 340   Berkeley 94704 37.8678249152641 -122.26942837149984
3172 3172 3172 055 189401401 2020 Bancroft Way 318 2020 BANCROFT WAY 318 2020 BANCROFT WY 2020.0 BANCROFT WY 318   Berkeley 94704 37.86695279564912 -122.26925847223184
3199 3199 3199 055 187701300 2510 Bancroft Way 301 2510 BANCROFT WAY 301 2510 BANCROFT WY 2510.0 BANCROFT WY 301   Berkeley 94704 37.86853942270108 -122.25886489252936
3216 3216 3216 055 187802000 2462 Bancroft Way 2462 BANCROFT WAY 2462 BANCROFT WY 2462.0 BANCROFT WY     Berkeley 94704 37.86832833279673 -122.2600026447693
3288 3288 3288 057 202801402 2005 Bancroft Way 136 2005 BANCROFT WAY 136 2005 BANCROFT WY 2005.0 BANCROFT WY 136   Berkeley 94704 37.8678249152641 -122.26942837149984
3380 3380 3380 055 187701400 2522 Bancroft Way 2522 BANCROFT WAY 2522 BANCROFT WY 2522.0 BANCROFT WY     Berkeley 94704 37.86850857399582 -122.25849618980078
3545 3545 3545 057 202801402 2005 Bancroft Way 338 2005 BANCROFT WAY 338 2005 BANCROFT WY 2005.0 BANCROFT WY 338   Berkeley 94704 37.8678249152641 -122.26942837149984
4040 4040 4040 055 187801900 2454 Bancroft Way 4 2454 BANCROFT WAY 4 2454 BANCROFT WY 2454.0 BANCROFT WY 4   Berkeley 94704 37.86830536622177 -122.26018143107042
4460 4460 4460 055 187701902 2580 Bancroft Way Apt 707 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 707 APT Berkeley 94704 37.868687873714904 -122.25761126839754
4917 4917 4917 055 187701902 2580 Bancroft Way Apt 811 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 811 APT Berkeley 94704 37.868722897805235 -122.2575255601363
4930 4930 4930 055 187701300 2510 Bancroft Way 2510 BANCROFT WAY 2510 BANCROFT WY 2510.0 BANCROFT WY     Berkeley 94704 37.86853942270108 -122.25886489252936
4937 4937 4937 055 187701902 2580 Bancroft Way Ste 2 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 2 STE Berkeley 94704 37.86853152987017 -122.25769892959624
4961 4961 4961 055 187801700 2428 Bancroft Way 4 2428 BANCROFT WAY 4 2428 BANCROFT WY 2428.0 BANCROFT WY 4   Berkeley 94704 37.868237121001386 -122.26069700116142
4988 4988 4988 055 189401600 2032 Bancroft Way 2 2032 BANCROFT WAY 2 2032 BANCROFT WY 2032.0 BANCROFT WY 2   Berkeley 94704 37.86721106154514 -122.26868244731884
5116 5116 5116 055 187701902 2580 Bancroft Way Apt 601 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 601 APT Berkeley 94704 37.86864378598557 -122.2577577665524
5218 5218 5218 055 187701902 2560 Bancroft Way 229 2560 BANCROFT WAY 229 2560 BANCROFT WY 2560.0 BANCROFT WY 229   Berkeley 94704 37.868744223283414 -122.25767525629354
5227 5227 5227 055 189300701 2124 Bancroft Way Apt 405 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 405 APT Berkeley 94704 37.867403573239145 -122.2665350920058
5304 5304 5304 057 202801402 2005 Bancroft Way 244 2005 BANCROFT WAY 244 2005 BANCROFT WY 2005.0 BANCROFT WY 244   Berkeley 94704 37.8678249152641 -122.26942837149984
5441 5441 5441 055 189401401 2020 Bancroft Way 127 2020 BANCROFT WAY 127 2020 BANCROFT WY 2020.0 BANCROFT WY 127   Berkeley 94704 37.86695279564912 -122.26925847223184
5517 5517 5517 055 188500800 2338 Bancroft Way 2338 BANCROFT WAY 2338 BANCROFT WY 2338.0 BANCROFT WY     Berkeley 94704 37.868032019746565 -122.26270521372516
5547 5547 5547 055 189401401 2020 Bancroft Way 112 2020 BANCROFT WAY 112 2020 BANCROFT WY 2020.0 BANCROFT WY 112   Berkeley 94704 37.86695279564912 -122.26925847223184
5600 5600 5600 055 187801700 2428 Bancroft Way 5 2428 BANCROFT WAY 5 2428 BANCROFT WY 2428.0 BANCROFT WY 5   Berkeley 94704 37.868237121001386 -122.26069700116142
5658 5658 5658 057 202801402 2005 Bancroft Way 230 2005 BANCROFT WAY 230 2005 BANCROFT WY 2005.0 BANCROFT WY 230   Berkeley 94704 37.8678249152641 -122.26942837149984
5823 5823 5823 055 189301800 2126 Bancroft Way 4 2126 BANCROFT WAY 4 2126 BANCROFT WY 2126.0 BANCROFT WY 4   Berkeley 94704 37.86756143565828 -122.2664203996019
5837 5837 5837 055 189401401 2020 Bancroft Way 324 2020 BANCROFT WAY 324 2020 BANCROFT WY 2020.0 BANCROFT WY 324   Berkeley 94704 37.86695279564912 -122.26925847223184
5890 5890 5890 055 187701902 2580 Bancroft Way Apt 808 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 808 APT Berkeley 94704 37.86871374554803 -122.25759419411892
5932 5932 5932 055 189401401 2020 Bancroft Way 130 2020 BANCROFT WAY 130 2020 BANCROFT WY 2020.0 BANCROFT WY 130   Berkeley 94704 37.86695279564912 -122.26925847223184
6218 6218 6218 057 202801402 2005 Bancroft Way 344 2005 BANCROFT WAY 344 2005 BANCROFT WY 2005.0 BANCROFT WY 344   Berkeley 94704 37.8678249152641 -122.26942837149984
6234 6234 6234 055 187801700 2428 Bancroft Way 3 2428 BANCROFT WAY 3 2428 BANCROFT WY 2428.0 BANCROFT WY 3   Berkeley 94704 37.868237121001386 -122.26069700116142
6341 6341 6341 055 187701902 2580 Bancroft Way Apt 809 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 809 APT Berkeley 94704 37.86871686579704 -122.25757079390412
6348 6348 6348 055 187701902 2560 Bancroft Way 172 2560 BANCROFT WAY 172 2560 BANCROFT WY 2560.0 BANCROFT WY 172   Berkeley 94704 37.868744223283414 -122.25767525629354
6496 6496 6496 055 189401401 2020 Bancroft Way 223 2020 BANCROFT WAY 223 2020 BANCROFT WY 2020.0 BANCROFT WY 223   Berkeley 94704 37.86695279564912 -122.26925847223184
6505 6505 6505 057 202801402 2005 Bancroft Way 126 2005 BANCROFT WAY 126 2005 BANCROFT WY 2005.0 BANCROFT WY 126   Berkeley 94704 37.8678249152641 -122.26942837149984
6518 6518 6518 057 202801402 2005 Bancroft Way 420 2005 BANCROFT WAY 420 2005 BANCROFT WY 2005.0 BANCROFT WY 420   Berkeley 94704 37.8678249152641 -122.26942837149984
6675 6675 6675 055 189300701 2124 Bancroft Way Apt 407 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 407 APT Berkeley 94704 37.86733254656403 -122.26652029405814
6804 6804 6804 057 202801402 2005 Bancroft Way 431 2005 BANCROFT WAY 431 2005 BANCROFT WY 2005.0 BANCROFT WY 431   Berkeley 94704 37.8678249152641 -122.26942837149984
6981 6981 6981 055 189401401 2020 Bancroft Way 325 2020 BANCROFT WAY 325 2020 BANCROFT WY 2020.0 BANCROFT WY 325   Berkeley 94704 37.86695279564912 -122.26925847223184
7143 7143 7143 055 187001000 2700 Bancroft Way 1 2700 BANCROFT WAY 1 2700 BANCROFT WY 2700.0 BANCROFT WY 1   Berkeley 94704 37.86896937008906 -122.25425457409956
7176 7176 7176 055 187701902 2580 Bancroft Way Apt 613 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 613 APT Berkeley 94704 37.86868206508539 -122.25747070990336
7210 7210 7210 055 187701300 2510 Bancroft Way 314 2510 BANCROFT WAY 314 2510 BANCROFT WY 2510.0 BANCROFT WY 314   Berkeley 94704 37.86853942270108 -122.25886489252936
7249 7249 7249 055 189300701 2124 Bancroft Way Apt 408 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 408 APT Berkeley 94704 37.867293038495994 -122.2665120627952
7286 7286 7286 055 188500702 2300 Bancroft Way 2300 BANCROFT WAY 2300 BANCROFT WY 2300.0 BANCROFT WY     Berkeley 94704 37.86793950699419 -122.26331027488308
7409 7409 7409 055 189300701 2124 Bancroft Way Apt 601 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 601 APT Berkeley 94704 37.867536199536026 -122.26660972044635
7511 7511 7511 055 187701902 2580 Bancroft Way Apt 602 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 602 APT Berkeley 94704 37.86864741469677 -122.25773055209086
7516 7516 7516 055 187701902 2580 Bancroft Way Apt 303 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 303 APT Berkeley 94704 37.86858153764098 -122.25768550607094
7523 7523 7523 057 202801402 2005 Bancroft Way 124 2005 BANCROFT WAY 124 2005 BANCROFT WY 2005.0 BANCROFT WY 124   Berkeley 94704 37.8678249152641 -122.26942837149984
7648 7648 7648 055 187701300 2510 Bancroft Way 303 2510 BANCROFT WAY 303 2510 BANCROFT WY 2510.0 BANCROFT WY 303   Berkeley 94704 37.86853942270108 -122.25886489252936
7674 7674 7674 055 189401401 2020 Bancroft Way 332 2020 BANCROFT WAY 332 2020 BANCROFT WY 2020.0 BANCROFT WY 332   Berkeley 94704 37.86695279564912 -122.26925847223184
7691 7691 7691 055 187701902 2560 Bancroft Way 233 2560 BANCROFT WAY 233 2560 BANCROFT WY 2560.0 BANCROFT WY 233   Berkeley 94704 37.868744223283414 -122.25767525629354
7757 7757 7757 055 187701902 2580 Bancroft Way Apt 410 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 410 APT Berkeley 94704 37.868627325236126 -122.25752267115432
8078 8078 8078 055 187701902 2580 Bancroft Way Apt 807 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 807 APT Berkeley 94704 37.86871067493926 -122.25761722243124
8091 8091 8091 055 187701902 2580 Bancroft Way Apt 315 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 315 APT Berkeley 94704 37.86861834670846 -122.25740947354709
8349 8349 8349 055 187801800 2440 Bancroft Way 2440 BANCROFT WAY 2440 BANCROFT WY 2440.0 BANCROFT WY     Berkeley 94704 37.868272026877634 -122.2604369460732
8356 8356 8356 055 189401401 2020 Bancroft Way 234 2020 BANCROFT WAY 234 2020 BANCROFT WY 2020.0 BANCROFT WY 234   Berkeley 94704 37.86695279564912 -122.26925847223184
8407 8407 8407 057 202801402 2005 Bancroft Way 227 2005 BANCROFT WAY 227 2005 BANCROFT WY 2005.0 BANCROFT WY 227   Berkeley 94704 37.8678249152641 -122.26942837149984
8443 8443 8443 055 189401401 2020 Bancroft Way 230 2020 BANCROFT WAY 230 2020 BANCROFT WY 2020.0 BANCROFT WY 230   Berkeley 94704 37.86695279564912 -122.26925847223184
8455 8455 8455 055 187801800 2440 Bancroft Way 207 2440 BANCROFT WAY 207 2440 BANCROFT WY 2440.0 BANCROFT WY 207   Berkeley 94704 37.868272026877634 -122.2604369460732
8475 8475 8475 055 189401401 2020 Bancroft Way 403 2020 BANCROFT WAY 403 2020 BANCROFT WY 2020.0 BANCROFT WY 403   Berkeley 94704 37.86695279564912 -122.26925847223184
8532 8532 8532 055 187701902 2580 Bancroft Way Apt 406 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 406 APT Berkeley 94704 37.86861478678324 -122.25761669242524
8836 8836 8836 055 187701902 2580 Bancroft Way Ste 1 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 1 STE Berkeley 94704 37.86852790115333 -122.25772614405774
8870 8870 8870 055 187701300 2510 Bancroft Way 209 2510 BANCROFT WAY 209 2510 BANCROFT WY 2510.0 BANCROFT WY 209   Berkeley 94704 37.86853942270108 -122.25886489252936
8935 8935 8935 055 187701902 2580 Bancroft Way Apt 212 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 212 APT Berkeley 94704 37.868585632265926 -122.25746710855738
9050 9050 9050 057 202801402 2005 Bancroft Way 432 2005 BANCROFT WAY 432 2005 BANCROFT WY 2005.0 BANCROFT WY 432   Berkeley 94704 37.8678249152641 -122.26942837149984
9179 9179 9179 055 187701902 2580 Bancroft Way Apt 612 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 612 APT Berkeley 94704 37.86867920083733 -122.25749218682516
9237 9237 9237 055 187701902 2580 Bancroft Way Apt 216 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 216 APT Berkeley 94704 37.868597172951624 -122.25738056126966
9264 9264 9264 055 187800100 2486 Bancroft Way 2486 BANCROFT WAY 2486 BANCROFT WY 2486.0 BANCROFT WY     Berkeley 94704 37.8684522313386 -122.25939058483702
9388 9388 9388 055 187701902 2580 Bancroft Way Apt 810 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 810 APT Berkeley 94704 37.86871994278788 -122.2575477251676
9572 9572 9572 055 187701902 2560 Bancroft Way 33 2560 BANCROFT WAY 33 2560 BANCROFT WY 2560.0 BANCROFT WY 33   Berkeley 94704 37.868744223283414 -122.25767525629354

Next page

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