Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
28 rows where street_type = "WK"
This data as json, CSV (advanced)
Suggested facets: street_number, longitude
These facets timed out: street_name
| Link | rowid ▼ | address_id | apn | address_full | address_normalized | base_address | street_number | street_name | street_type | unit | unit_type | city | zipcode | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2319 | 2319 | 2319 | 060 246800702 | 2525 Rose Walk | 2525 ROSE WALK | 2525 ROSE WK | 2525.0 | ROSE | WK | Berkeley | 94708 | 37.88327706332237 | -122.26142840856744 | ||
| 3754 | 3754 | 3754 | 060 246800800 | 2565 Rose Walk | 2565 ROSE WALK | 2565 ROSE WK | 2565.0 | ROSE | WK | Berkeley | 94708 | 37.8833544485951 | -122.26078916830956 | ||
| 4749 | 4749 | 4749 | 060 246800702 | 2527 Rose Walk | 2527 ROSE WALK | 2527 ROSE WK | 2527.0 | ROSE | WK | Berkeley | 94708 | 37.883282566637035 | -122.26139514664744 | ||
| 7276 | 7276 | 7276 | 059 224800100 | 2500 Rose Walk | 2500 ROSE WALK | 2500 ROSE WK | 2500.0 | ROSE | WK | Berkeley | 94708 | 37.88300146882383 | -122.2614363406914 | ||
| 7314 | 7314 | 7314 | 060 246800702 | 2519 Rose Walk | 2519 ROSE WALK | 2519 ROSE WK | 2519.0 | ROSE | WK | Berkeley | 94708 | 37.88326519382982 | -122.26150483902843 | ||
| 7628 | 7628 | 7628 | 060 246800800 | 2555 Rose Walk | 2555 ROSE WALK | 2555 ROSE WK | 2555.0 | ROSE | WK | Berkeley | 94708 | 37.8833544485951 | -122.26078916830956 | ||
| 9957 | 9957 | 9957 | 061 256400100 | 10 Terrace Walk | 10 TERRACE WALK | 10 TERRACE WK | 10.0 | TERRACE | WK | Berkeley | 94707 | 37.888725731916935 | -122.2719881882756 | ||
| 10453 | 10453 | 10453 | 060 246800800 | 2567 Rose Walk | 2567 ROSE WALK | 2567 ROSE WK | 2567.0 | ROSE | WK | Berkeley | 94708 | 37.8833544485951 | -122.26078916830956 | ||
| 15856 | 15856 | 15856 | 061 256301600 | 21 Terrace Walk | 21 TERRACE WALK | 21 TERRACE WK | 21.0 | TERRACE | WK | Berkeley | 94707 | 37.88883351779078 | -122.27157817831532 | ||
| 16106 | 16106 | 16106 | 060 246801002 | 2537 Rose Walk | 2537 ROSE WALK | 2537 ROSE WK | 2537.0 | ROSE | WK | Berkeley | 94708 | 37.88352482764198 | -122.26099915040557 | ||
| 16965 | 16965 | 16965 | 060 246800702 | 2511 Rose Walk | 2511 ROSE WALK | 2511 ROSE WK | 2511.0 | ROSE | WK | Berkeley | 94708 | 37.88326024495775 | -122.26159677800452 | ||
| 17999 | 17999 | 17999 | 059 224800200 | 2518 Rose Walk | 2518 ROSE WALK | 2518 ROSE WK | 2518.0 | ROSE | WK | Berkeley | 94708 | 37.883001505692334 | -122.26126275922908 | ||
| 19988 | 19988 | 19988 | 061 257200800 | 1011 Fountain Walk A | 1011 FOUNTAIN WALK A | 1011 FOUNTAIN WK | 1011.0 | FOUNTAIN | WK | A | Berkeley | 94707 | 37.88950495497251 | -122.272191530025 | |
| 22689 | 22689 | 22689 | 061 256400300 | 30 Terrace Walk | 30 TERRACE WALK | 30 TERRACE WK | 30.0 | TERRACE | WK | Berkeley | 94707 | 37.8884270571345 | -122.27165098407414 | ||
| 23977 | 23977 | 23977 | 061 256301500 | 29 Terrace Walk | 29 TERRACE WALK | 29 TERRACE WK | 29.0 | TERRACE | WK | Berkeley | 94707 | 37.88882149180604 | -122.2713876312705 | ||
| 24879 | 24879 | 24879 | 060 246800702 | 2523 Rose Walk | 2523 ROSE WALK | 2523 ROSE WK | 2523.0 | ROSE | WK | Berkeley | 94708 | 37.88327083114771 | -122.26146255622636 | ||
| 25453 | 25453 | 25453 | 060 246800702 | 2505 Rose Walk | 2505 ROSE WALK | 2505 ROSE WK | 2505.0 | ROSE | WK | Berkeley | 94708 | 37.88328144144246 | -122.2616144281032 | ||
| 27728 | 27728 | 27728 | 060 246800800 | 2553 Rose Walk | 2553 ROSE WALK | 2553 ROSE WK | 2553.0 | ROSE | WK | Berkeley | 94708 | 37.8833544485951 | -122.26078916830956 | ||
| 33369 | 33369 | 33369 | 061 256301700 | 15 Terrace Walk | 15 TERRACE WALK | 15 TERRACE WK | 15.0 | TERRACE | WK | Berkeley | 94707 | 37.88889373346834 | -122.2717132409166 | ||
| 35046 | 35046 | 35046 | 061 257200800 | 1011 Fountain Walk | 1011 FOUNTAIN WALK | 1011 FOUNTAIN WK | 1011.0 | FOUNTAIN | WK | Berkeley | 94707 | 37.88950495497251 | -122.272191530025 | ||
| 38571 | 38571 | 38571 | 060 246800800 | 2577 Rose Walk | 2577 ROSE WALK | 2577 ROSE WK | 2577.0 | ROSE | WK | Berkeley | 94708 | 37.8833544485951 | -122.26078916830956 | ||
| 44306 | 44306 | 44306 | 061 256400300 | 28 Terrace Walk | 28 TERRACE WALK | 28 TERRACE WK | 28.0 | TERRACE | WK | Berkeley | 94707 | 37.8884270571345 | -122.27165098407414 | ||
| 45584 | 45584 | 45584 | 061 256400200 | 20 Terrace Walk | 20 TERRACE WALK | 20 TERRACE WK | 20.0 | TERRACE | WK | Berkeley | 94707 | 37.88855358045985 | -122.27176397776384 | ||
| 46502 | 46502 | 46502 | 060 246800702 | 2507 Rose Walk | 2507 ROSE WALK | 2507 ROSE WK | 2507.0 | ROSE | WK | Berkeley | 94708 | 37.88325745430421 | -122.26164003188546 | ||
| 48486 | 48486 | 48486 | 061 256000202 | 70 Terrace Walk | 70 TERRACE WALK | 70 TERRACE WK | 70.0 | TERRACE | WK | Berkeley | 94707 | 37.88807775424556 | -122.27045974165058 | ||
| 49417 | 49417 | 49417 | 060 246800702 | 2501 Rose Walk | 2501 ROSE WALK | 2501 ROSE WK | 2501.0 | ROSE | WK | Berkeley | 94708 | 37.88330753503286 | -122.26163941564118 | ||
| 50355 | 50355 | 50355 | 061 255901300 | 81 Terrace Walk | 81 TERRACE WALK | 81 TERRACE WK | 81.0 | TERRACE | WK | Berkeley | 94707 | 37.88837053971076 | -122.27019947276332 | ||
| 54032 | 54032 | 54032 | 060 246800702 | 2515 Rose Walk | 2515 ROSE WALK | 2515 ROSE WK | 2515.0 | ROSE | WK | Berkeley | 94708 | 37.88323473202792 | -122.26158082931497 |
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);