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

143 rows where street_name = "PANORAMIC" and street_type = "WY"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 2

street_type 1

  • WY · 143 ✖

street_name 1

  • PANORAMIC · 143 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1643 1643 1643 055 186202701 265 Panoramic Way 265 PANORAMIC WAY 265 PANORAMIC WY 265.0 PANORAMIC WY     Berkeley 94704 37.86939779173353 -122.24742054445588
1734 1734 1734 055 185302400 122 Panoramic Way 122 PANORAMIC WAY 122 PANORAMIC WY 122.0 PANORAMIC WY     Berkeley 94704 37.86834258389829 -122.24799477633158
2491 2491 2491 055 185905100 336 Panoramic Way 336 PANORAMIC WAY 336 PANORAMIC WY 336.0 PANORAMIC WY     Berkeley 94704 37.86870982254391 -122.24593399435742
2557 2557 2557 055 185900700 208 Panoramic Way 208 PANORAMIC WAY 208 PANORAMIC WY 208.0 PANORAMIC WY     Berkeley 94704 37.8689939589804 -122.24673535447292
2618 2618 2618 055 185902801 345 Panoramic Way 345 PANORAMIC WAY 345 PANORAMIC WY 345.0 PANORAMIC WY     Berkeley 94704 37.86959616016689 -122.24539743243486
3100 3100 3100 055 185302705 152 Panoramic Way 2 152 PANORAMIC WAY 2 152 PANORAMIC WY 152.0 PANORAMIC WY 2   Berkeley 94704 37.868262456874 -122.24636572468296
3308 3308 3308 055 185301900 70 Panoramic Way 70 PANORAMIC WAY 70 PANORAMIC WY 70.0 PANORAMIC WY     Berkeley 94704 37.86859778494689 -122.2485352827566
3513 3513 3513 055 186100601 57 Panoramic Way 57 PANORAMIC WAY 57 PANORAMIC WY 57.0 PANORAMIC WY     Berkeley 94704 37.8682447656606 -122.2486781481244
3847 3847 3847 055 185302707 156 Panoramic Way D 156 PANORAMIC WAY D 156 PANORAMIC WY 156.0 PANORAMIC WY D   Berkeley 94704 37.868228516149344 -122.2459744239351
4063 4063 4063 055 185307800 2 Panoramic Way 101 2 PANORAMIC WAY 101 2 PANORAMIC WY 2.0 PANORAMIC WY 101   Berkeley 94704 37.869169198383226 -122.249890423702
4871 4871 4871 055 186100502 27 Panoramic Way 27 PANORAMIC WAY 27 PANORAMIC WY 27.0 PANORAMIC WY     Berkeley 94704 37.86851727029543 -122.2489799703818
5288 5288 5288 055 185902801 363 Panoramic Way 363 PANORAMIC WAY 363 PANORAMIC WY 363.0 PANORAMIC WY     Berkeley 94704 37.86959616016689 -122.24539743243486
6444 6444 6444 055 185904401 360 Panoramic Way G 360 PANORAMIC WAY G 360 PANORAMIC WY 360.0 PANORAMIC WY G   Berkeley 94704 37.869075692129584 -122.24550071713296
6725 6725 6725 055 185904401 360 Panoramic Way H 360 PANORAMIC WAY H 360 PANORAMIC WY 360.0 PANORAMIC WY H   Berkeley 94704 37.869075692129584 -122.24550071713296
7113 7113 7113 055 185307800 2 Panoramic Way 301 2 PANORAMIC WAY 301 2 PANORAMIC WY 2.0 PANORAMIC WY 301   Berkeley 94704 37.869169198383226 -122.249890423702
7977 7977 7977 055 185301800 66 Panoramic Way 66 PANORAMIC WAY 66 PANORAMIC WY 66.0 PANORAMIC WY     Berkeley 94704 37.868428191857944 -122.24843733315294
8454 8454 8454 055 185301405 56 Panoramic Way 56 PANORAMIC WAY 56 PANORAMIC WY 56.0 PANORAMIC WY     Berkeley 94704 37.86762923828077 -122.24765524549356
8656 8656 8656 055 185300400 18 Panoramic Way 18 PANORAMIC WAY 18 PANORAMIC WY 18.0 PANORAMIC WY     Berkeley 94704 37.86857622327978 -122.24949620881937
9420 9420 9420 055 185302702 150 Panoramic Way 1 150 PANORAMIC WAY 1 150 PANORAMIC WY 150.0 PANORAMIC WY 1   Berkeley 94704 37.86829708971487 -122.24655068151178
9994 9994 9994 055 185901400 301 Panoramic Way 301 PANORAMIC WAY 301 PANORAMIC WY 301.0 PANORAMIC WY     Berkeley 94704 37.86976659940499 -122.2460987615502
10810 10810 10810 055 185904700 280 Panoramic Way 280 PANORAMIC WAY 280 PANORAMIC WY 280.0 PANORAMIC WY     Berkeley 94704 37.869745713888 -122.24677656917818
10973 10973 10973 055 186100300 23 Panoramic Way 23 PANORAMIC WAY 23 PANORAMIC WY 23.0 PANORAMIC WY     Berkeley 94704 37.86878746848627 -122.2491476714723
12217 12217 12217 055 186101600 9 Panoramic Way 9 PANORAMIC WAY 9 PANORAMIC WY 9.0 PANORAMIC WY     Berkeley 94704 37.86886520086255 -122.24945279683494
12392 12392 12392 055 185307800 2 Panoramic Way 205 2 PANORAMIC WAY 205 2 PANORAMIC WY 2.0 PANORAMIC WY 205   Berkeley 94704 37.869169198383226 -122.249890423702
13945 13945 13945 055 185307800 2 Panoramic Way 202 2 PANORAMIC WAY 202 2 PANORAMIC WY 2.0 PANORAMIC WY 202   Berkeley 94704 37.869169198383226 -122.249890423702
14238 14238 14238 055 185904100 358 Panoramic Way 358 PANORAMIC WAY 358 PANORAMIC WY 358.0 PANORAMIC WY     Berkeley 94704 37.8692513284577 -122.24533850834209
14822 14822 14822 055 185904401 360 Panoramic Way B 360 PANORAMIC WAY B 360 PANORAMIC WY 360.0 PANORAMIC WY B   Berkeley 94704 37.869075692129584 -122.24550071713296
16055 16055 16055 055 185300400 14 Panoramic Way 14 PANORAMIC WAY 14 PANORAMIC WY 14.0 PANORAMIC WY     Berkeley 94704 37.86862851731447 -122.24951009407869
16203 16203 16203 055 185301201 52 Panoramic Way 52 PANORAMIC WAY 52 PANORAMIC WY 52.0 PANORAMIC WY     Berkeley 94704 37.86753382669049 -122.24807183112172
16358 16358 16358 055 185900500 330 Panoramic Way 1 330 PANORAMIC WAY 1 330 PANORAMIC WY 330.0 PANORAMIC WY 1   Berkeley 94704 37.86907574176966 -122.2462463143272
17868 17868 17868 055 185904401 360 Panoramic Way 360 PANORAMIC WAY 360 PANORAMIC WY 360.0 PANORAMIC WY     Berkeley 94704 37.869075692129584 -122.24550071713296
17928 17928 17928 055 186100200 75 Panoramic Way 75 PANORAMIC WAY 75 PANORAMIC WY 75.0 PANORAMIC WY     Berkeley 94704 37.868989227566054 -122.24902597220915
18146 18146 18146 055 186100601 61 Panoramic Way 61 PANORAMIC WAY 61 PANORAMIC WY 61.0 PANORAMIC WY     Berkeley 94704 37.8682447656606 -122.2486781481244
18920 18920 18920 055 185902701 367 Panoramic Way 367 PANORAMIC WAY 367 PANORAMIC WY 367.0 PANORAMIC WY     Berkeley 94704 37.86960172194399 -122.24522432438468
19917 19917 19917 055 185904401 360 Panoramic Way K 360 PANORAMIC WAY K 360 PANORAMIC WY 360.0 PANORAMIC WY K   Berkeley 94704 37.869075692129584 -122.24550071713296
21451 21451 21451 055 185302500 130 Panoramic Way 130 PANORAMIC WAY 130 PANORAMIC WY 130.0 PANORAMIC WY     Berkeley 94704 37.86822102608367 -122.2475473272852
21580 21580 21580 055 185302705 152 Panoramic Way 3 152 PANORAMIC WAY 3 152 PANORAMIC WY 152.0 PANORAMIC WY 3   Berkeley 94704 37.868262456874 -122.24636572468296
22615 22615 22615 055 185300701 26 Panoramic Way 26 PANORAMIC WAY 26 PANORAMIC WY 26.0 PANORAMIC WY     Berkeley 94704 37.86828869690617 -122.24926161468125
23063 23063 23063 055 185301500 60 Panoramic Way 60 PANORAMIC WAY 60 PANORAMIC WY 60.0 PANORAMIC WY     Berkeley 94704 37.86810180472897 -122.24805135312651
23067 23067 23067 055 185300800 34 Panoramic Way 34 PANORAMIC WAY 34 PANORAMIC WY 34.0 PANORAMIC WY     Berkeley 94704 37.8681682133691 -122.2490515346689
23151 23151 23151 055 186204201 121 Panoramic Way 121 PANORAMIC WAY 121 PANORAMIC WY 121.0 PANORAMIC WY     Berkeley 94704 37.8687679130515 -122.24806435085036
23357 23357 23357 055 186204203 111 Panoramic Way 111 PANORAMIC WAY 111 PANORAMIC WY 111.0 PANORAMIC WY     Berkeley 94704 37.868988976528755 -122.24828014594452
24341 24341 24341 055 185300701 24 Panoramic Way 24 PANORAMIC WAY 24 PANORAMIC WY 24.0 PANORAMIC WY     Berkeley 94704 37.86828869690617 -122.24926161468125
24589 24589 24589 055 185307800 2 Panoramic Way 103 2 PANORAMIC WAY 103 2 PANORAMIC WY 2.0 PANORAMIC WY 103   Berkeley 94704 37.869169198383226 -122.249890423702
24614 24614 24614 055 186202403 255 Panoramic Way 255 PANORAMIC WAY 255 PANORAMIC WY 255.0 PANORAMIC WY     Berkeley 94704 37.86906250701351 -122.2473344175797
25209 25209 25209 055 185301404 54 Panoramic Way A 54 PANORAMIC WAY A 54 PANORAMIC WY 54.0 PANORAMIC WY A   Berkeley 94704 37.86758395853196 -122.24782009083977
25585 25585 25585 055 185301700 64 Panoramic Way 64 PANORAMIC WAY 64 PANORAMIC WY 64.0 PANORAMIC WY     Berkeley 94704 37.86829402476195 -122.24832077135493
26276 26276 26276 055 185302003 74 Panoramic Way 74 PANORAMIC WAY 74 PANORAMIC WY 74.0 PANORAMIC WY     Berkeley 94704 37.868883529449135 -122.24868892072128
26496 26496 26496 055 185900500 330 Panoramic Way 330 PANORAMIC WAY 330 PANORAMIC WY 330.0 PANORAMIC WY     Berkeley 94704 37.86907574176966 -122.2462463143272
26898 26898 26898 055 185301800 66 Panoramic Way C 66 PANORAMIC WAY C 66 PANORAMIC WY 66.0 PANORAMIC WY C   Berkeley 94704 37.868428191857944 -122.24843733315294
27497 27497 27497 055 185302704 158 Panoramic Way 2 158 PANORAMIC WAY 2 158 PANORAMIC WY 158.0 PANORAMIC WY 2   Berkeley 94704 37.868259137334064 -122.24575842492337
27617 27617 27617 055 186202303 299 Panoramic Way 299 PANORAMIC WAY 299 PANORAMIC WY 299.0 PANORAMIC WY     Berkeley 94704 37.87000889990184 -122.24623133132658
28392 28392 28392 055 185904401 360 Panoramic Way J 360 PANORAMIC WAY J 360 PANORAMIC WY 360.0 PANORAMIC WY J   Berkeley 94704 37.869075692129584 -122.24550071713296
28458 28458 28458 055 185900200 314 Panoramic Way 314 PANORAMIC WAY 314 PANORAMIC WY 314.0 PANORAMIC WY     Berkeley 94704 37.86947011343537 -122.24648083839674
28719 28719 28719 055 185903000 339 Panoramic Way 339 PANORAMIC WAY 339 PANORAMIC WY 339.0 PANORAMIC WY     Berkeley 94704 37.86958894325876 -122.24552382719196
28771 28771 28771 055 185302707 156 Panoramic Way 156 PANORAMIC WAY 156 PANORAMIC WY 156.0 PANORAMIC WY     Berkeley 94704 37.868228516149344 -122.2459744239351
28921 28921 28921 055 185900303 222 Panoramic Way 222 PANORAMIC WAY 222 PANORAMIC WY 222.0 PANORAMIC WY     Berkeley 94704 37.86918970254473 -122.24694615134084
29175 29175 29175 055 185307800 2 Panoramic Way 304 2 PANORAMIC WAY 304 2 PANORAMIC WY 2.0 PANORAMIC WY 304   Berkeley 94704 37.869169198383226 -122.249890423702
29341 29341 29341 055 185904000 356 Panoramic Way 356 PANORAMIC WAY 356 PANORAMIC WY 356.0 PANORAMIC WY     Berkeley 94704 37.86922899614388 -122.2455106417202
29428 29428 29428 055 186100400 25 Panoramic Way 25 PANORAMIC WAY 25 PANORAMIC WY 25.0 PANORAMIC WY     Berkeley 94704 37.86863735613871 -122.24906724889816
29469 29469 29469 055 185904401 360 Panoramic Way I 360 PANORAMIC WAY I 360 PANORAMIC WY 360.0 PANORAMIC WY I   Berkeley 94704 37.869075692129584 -122.24550071713296
30390 30390 30390 055 185301410 58 Panoramic Way D 58 PANORAMIC WAY D 58 PANORAMIC WY 58.0 PANORAMIC WY D   Berkeley 94704 37.86789979856063 -122.24807793966563
30653 30653 30653 055 185307800 2 Panoramic Way 302 2 PANORAMIC WAY 302 2 PANORAMIC WY 2.0 PANORAMIC WY 302   Berkeley 94704 37.869169198383226 -122.249890423702
30748 30748 30748 055 185305800 160 Panoramic Way 160 PANORAMIC WAY 160 PANORAMIC WY 160.0 PANORAMIC WY     Berkeley 94704 37.86825253938465 -122.24550546652586
31743 31743 31743 055 186204001 125 Panoramic Way 125 PANORAMIC WAY 125 PANORAMIC WY 125.0 PANORAMIC WY     Berkeley 94704 37.86863774687941 -122.2478580141178
31930 31930 31930 055 185904401 360 Panoramic Way C 360 PANORAMIC WAY C 360 PANORAMIC WY 360.0 PANORAMIC WY C   Berkeley 94704 37.869075692129584 -122.24550071713296
32015 32015 32015 055 185302704 158 Panoramic Way 1 158 PANORAMIC WAY 1 158 PANORAMIC WY 158.0 PANORAMIC WY 1   Berkeley 94704 37.868259137334064 -122.24575842492337
32263 32263 32263 055 185900800 260 Panoramic Way 260 PANORAMIC WAY 260 PANORAMIC WY 260.0 PANORAMIC WY     Berkeley 94704 37.86936979768104 -122.24694409779214
33252 33252 33252 055 185300300 10 Panoramic Way 10 PANORAMIC WAY 10 PANORAMIC WY 10.0 PANORAMIC WY     Berkeley 94704 37.86877021139688 -122.24972990015064
33262 33262 33262 055 185307800 2 Panoramic Way 305 2 PANORAMIC WAY 305 2 PANORAMIC WY 2.0 PANORAMIC WY 305   Berkeley 94704 37.869169198383226 -122.249890423702
33525 33525 33525 055 185301100 50 Panoramic Way 50 PANORAMIC WAY 50 PANORAMIC WY 50.0 PANORAMIC WY     Berkeley 94704 37.867817625848595 -122.24834427846928
33538 33538 33538 055 185307800 2 Panoramic Way 105 2 PANORAMIC WAY 105 2 PANORAMIC WY 2.0 PANORAMIC WY 105   Berkeley 94704 37.869169198383226 -122.249890423702
33855 33855 33855 055 185301000 38 Panoramic Way 38 PANORAMIC WAY 38 PANORAMIC WY 38.0 PANORAMIC WY     Berkeley 94704 37.868028733526536 -122.24869795058656
33941 33941 33941 054 171601300 344 Panoramic Way 344 PANORAMIC WAY 344 PANORAMIC WY 344.0 PANORAMIC WY     Berkeley 94705 37.85955839664617 -122.26107039040086
33950 33950 33950 055 185302704 158 Panoramic Way A 158 PANORAMIC WAY A 158 PANORAMIC WY 158.0 PANORAMIC WY A   Berkeley 94704 37.868259137334064 -122.24575842492337
34156 34156 34156 055 185302707 156 Panoramic Way A 156 PANORAMIC WAY A 156 PANORAMIC WY 156.0 PANORAMIC WY A   Berkeley 94704 37.868228516149344 -122.2459744239351
34264 34264 34264 055 185301410 58 Panoramic Way 58 PANORAMIC WAY 58 PANORAMIC WY 58.0 PANORAMIC WY     Berkeley 94704 37.86789979856063 -122.24807793966563
34933 34933 34933 055 185900304 240 Panoramic Way 240 PANORAMIC WAY 240 PANORAMIC WY 240.0 PANORAMIC WY     Berkeley 94704 37.86926726146601 -122.24664538819722
36043 36043 36043 055 185900400 332 Panoramic Way 332 PANORAMIC WAY 332 PANORAMIC WY 332.0 PANORAMIC WY     Berkeley 94704 37.86920184023409 -122.24631258394402
36797 36797 36797 055 185302705 152 Panoramic Way 152 PANORAMIC WAY 152 PANORAMIC WY 152.0 PANORAMIC WY     Berkeley 94704 37.868262456874 -122.24636572468296
36887 36887 36887 055 185307800 2 Panoramic Way 102 2 PANORAMIC WAY 102 2 PANORAMIC WY 2.0 PANORAMIC WY 102   Berkeley 94704 37.869169198383226 -122.249890423702
37940 37940 37940 055 186101600 11 Panoramic Way 11 PANORAMIC WAY 11 PANORAMIC WY 11.0 PANORAMIC WY     Berkeley 94704 37.86882228829504 -122.2494385522495
38016 38016 38016 055 185301410 58 Panoramic Way C 58 PANORAMIC WAY C 58 PANORAMIC WY 58.0 PANORAMIC WY C   Berkeley 94704 37.86789979856063 -122.24807793966563
38061 38061 38061 055 186204300 109 Panoramic Way 109 PANORAMIC WAY 109 PANORAMIC WY 109.0 PANORAMIC WY     Berkeley 94704 37.86909461138059 -122.24837991014503
38461 38461 38461 055 185301404 54 Panoramic Way 54 PANORAMIC WAY 54 PANORAMIC WY 54.0 PANORAMIC WY     Berkeley 94704 37.86758395853196 -122.24782009083977
39224 39224 39224 055 186100200 77 Panoramic Way 77 PANORAMIC WAY 77 PANORAMIC WY 77.0 PANORAMIC WY     Berkeley 94704 37.868989227566054 -122.24902597220915
39356 39356 39356 055 186204400 107 Panoramic Way 1 107 PANORAMIC WAY 1 107 PANORAMIC WY 107.0 PANORAMIC WY 1   Berkeley 94704 37.8691960770302 -122.24847059507296
39664 39664 39664 055 185302704 158 Panoramic Way 158 PANORAMIC WAY 158 PANORAMIC WY 158.0 PANORAMIC WY     Berkeley 94704 37.868259137334064 -122.24575842492337
40148 40148 40148 055 185900301 320 Panoramic Way 320 PANORAMIC WAY 320 PANORAMIC WY 320.0 PANORAMIC WY     Berkeley 94704 37.86936287646267 -122.2463492756318
40174 40174 40174 055 185903901 352 Panoramic Way 352 PANORAMIC WAY 352 PANORAMIC WY 352.0 PANORAMIC WY     Berkeley 94704 37.86919755984793 -122.24571083397625
40845 40845 40845 055 185904401 340 Panoramic Way 340 PANORAMIC WAY 340 PANORAMIC WY 340.0 PANORAMIC WY     Berkeley 94704 37.869075692129584 -122.24550071713296
41080 41080 41080 055 185300900 36 Panoramic Way 36 PANORAMIC WAY 36 PANORAMIC WY 36.0 PANORAMIC WY     Berkeley 94704 37.86810167211726 -122.24889048290814
41603 41603 41603 055 185307800 2 Panoramic Way 204 2 PANORAMIC WAY 204 2 PANORAMIC WY 2.0 PANORAMIC WY 204   Berkeley 94704 37.869169198383226 -122.249890423702
41877 41877 41877 055 185307800 2 Panoramic Way 306 2 PANORAMIC WAY 306 2 PANORAMIC WY 2.0 PANORAMIC WY 306   Berkeley 94704 37.869169198383226 -122.249890423702
42035 42035 42035 055 185903200 335 Panoramic Way 335 PANORAMIC WAY 335 PANORAMIC WY 335.0 PANORAMIC WY     Berkeley 94704 37.86957904793126 -122.24569164416512
42422 42422 42422 055 186101600 5 Panoramic Way 5 PANORAMIC WAY 5 PANORAMIC WY 5.0 PANORAMIC WY     Berkeley 94704 37.86893932431634 -122.24949252123513
42527 42527 42527 055 186100900 65 Panoramic Way 65 PANORAMIC WAY 65 PANORAMIC WY 65.0 PANORAMIC WY     Berkeley 94704 37.868378413038776 -122.24893024952912
43407 43407 43407 055 185904000 354 Panoramic Way 354 PANORAMIC WAY 354 PANORAMIC WY 354.0 PANORAMIC WY     Berkeley 94704 37.86922899614388 -122.2455106417202
43433 43433 43433 055 186101600 7 Panoramic Way 7 PANORAMIC WAY 7 PANORAMIC WY 7.0 PANORAMIC WY     Berkeley 94704 37.86890106095138 -122.24947128685844
44320 44320 44320 055 186100900 65 Panoramic Way Ca 65 PANORAMIC WAY CA 65 PANORAMIC WY 65.0 PANORAMIC WY CA   Berkeley 94704 37.868378413038776 -122.24893024952912

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