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

32 rows where street_name = "FOREST" and street_type = "LN"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • FOREST · 32 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
261 261 261 063 296304500 5 Forest Ln 5 FOREST LN 5 FOREST LN 5.0 FOREST LN     Berkeley 94708 37.89563575942078 -122.26267876552656
692 692 692 063 296403200 161 Forest Ln 161 FOREST LN 161 FOREST LN 161.0 FOREST LN     Berkeley 94708 37.89609339361597 -122.26130132749748
1085 1085 1085 063 296304000 65 Forest Ln 65 FOREST LN 65 FOREST LN 65.0 FOREST LN     Berkeley 94708 37.89561624088709 -122.26211578325318
1411 1411 1411 063 296905400 140 Forest Ln 140 FOREST LN 140 FOREST LN 140.0 FOREST LN     Berkeley 94708 37.89573572394884 -122.2609004525053
3806 3806 3806 063 296905304 136 Forest Ln 136 FOREST LN 136 FOREST LN 136.0 FOREST LN     Berkeley 94708 37.89552751918296 -122.26086673244448
4723 4723 4723 063 296403101 171 Forest Ln 171 FOREST LN 171 FOREST LN 171.0 FOREST LN     Berkeley 94708 37.89621523152061 -122.26129457306484
12744 12744 12744 063 297000602 60 Forest Ln 60 FOREST LN 60 FOREST LN 60.0 FOREST LN     Berkeley 94708 37.895324751733696 -122.26172724123154
14404 14404 14404 063 296403500 141 Forest Ln 141 FOREST LN 141 FOREST LN 141.0 FOREST LN     Berkeley 94708 37.89567872654735 -122.26140554105358
15558 15558 15558 063 297000202 10 Forest Ln 10 FOREST LN 10 FOREST LN 10.0 FOREST LN     Berkeley 94708 37.8951897935895 -122.2625839222972
16970 16970 16970 063 296900300 168 Forest Ln 168 FOREST LN 168 FOREST LN 168.0 FOREST LN     Berkeley 94708 37.8960893948017 -122.26075798419282
17586 17586 17586 063 296805100 200 Forest Ln 200 FOREST LN 200 FOREST LN 200.0 FOREST LN     Berkeley 94708 37.89641240344734 -122.26014789606256
21807 21807 21807 063 296403001 179 Forest Ln 179 FOREST LN 179 FOREST LN 179.0 FOREST LN     Berkeley 94708 37.89637844166711 -122.26124646289148
22277 22277 22277 063 296403400 145 Forest Ln 145 FOREST LN 145 FOREST LN 145.0 FOREST LN     Berkeley 94708 37.89586218154776 -122.26130895599086
26509 26509 26509 063 296800400 204 Forest Ln 204 FOREST LN 204 FOREST LN 204.0 FOREST LN     Berkeley 94708 37.89654917975264 -122.26014063947169
31857 31857 31857 063 296904903 110 Forest Ln 110 FOREST LN 110 FOREST LN 110.0 FOREST LN     Berkeley 94708 37.89505050031147 -122.2608500417465
32032 32032 32032 063 296303900 95 Forest Ln 95 FOREST LN 95 FOREST LN 95.0 FOREST LN     Berkeley 94708 37.895820961933616 -122.2620759241057
32510 32510 32510 063 297000301 18 Forest Ln 18 FOREST LN 18 FOREST LN 18.0 FOREST LN     Berkeley 94708 37.8950990382649 -122.262243966556
34588 34588 34588 063 296304100 51 Forest Ln 51 FOREST LN 51 FOREST LN 51.0 FOREST LN     Berkeley 94708 37.89545085346696 -122.26209540407264
34740 34740 34740 063 296800300 208 Forest Ln 208 FOREST LN 208 FOREST LN 208.0 FOREST LN     Berkeley 94708 37.89673663207193 -122.26004722007202
35739 35739 35739 063 297000702 70 Forest Ln 70 FOREST LN 70 FOREST LN 70.0 FOREST LN     Berkeley 94708 37.89549352438557 -122.26170640570685
43839 43839 43839 063 296402900 199 Forest Ln 199 FOREST LN 199 FOREST LN 199.0 FOREST LN     Berkeley 94708 37.896610341852885 -122.26136049233872
44511 44511 44511 063 296304400 15 Forest Ln 15 FOREST LN 15 FOREST LN 15.0 FOREST LN     Berkeley 94708 37.89560713166912 -122.26254433893251
47688 47688 47688 063 297000500 50 Forest Ln 50 FOREST LN 50 FOREST LN 50.0 FOREST LN     Berkeley 94708 37.89512758540034 -122.26193405496952
47826 47826 47826 063 296403500 139 Forest Ln 139 FOREST LN 139 FOREST LN 139.0 FOREST LN     Berkeley 94708 37.89567872654735 -122.26140554105358
48755 48755 48755 063 296701200 263 Forest Ln 263 FOREST LN 263 FOREST LN 263.0 FOREST LN     Berkeley 94708 37.89718132248379 -122.26066308526788
52690 52690 52690 063 296304300 25 Forest Ln 25 FOREST LN 25 FOREST LN 25.0 FOREST LN     Berkeley 94708 37.89556900904815 -122.2624107675346
53369 53369 53369 063 296904902 108 Forest Ln 108 FOREST LN 108 FOREST LN 108.0 FOREST LN     Berkeley 94708 37.89510963125961 -122.26113704449662
54638 54638 54638 063 296304600 1 Forest Ln 1 FOREST LN 1 FOREST LN 1.0 FOREST LN     Berkeley 94708 37.89568167693876 -122.2628078013306
55334 55334 55334 063 296304200 33 Forest Ln 33 FOREST LN 33 FOREST LN 33.0 FOREST LN     Berkeley 94708 37.895502433001774 -122.26228913115357
57027 57027 57027 063 296403303 155 Forest Ln 155 FOREST LN 155 FOREST LN 155.0 FOREST LN     Berkeley 94708 37.89597926038128 -122.26130390027242
57284 57284 57284 063 296905000 120 Forest Ln 120 FOREST LN 120 FOREST LN 120.0 FOREST LN     Berkeley 94708 37.89524013770831 -122.260930627814
57535 57535 57535 063 296904701 106 Forest Ln 106 FOREST LN 106 FOREST LN 106.0 FOREST LN     Berkeley 94708 37.89488271129986 -122.26115301744068

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