Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
15 rows where street_name = "PAGE" and zipcode = 94702
This data as json, CSV (advanced)
Suggested facets: apn, base_address, street_number, unit, latitude, longitude
| Link | rowid ▼ | address_id | apn | address_full | address_normalized | base_address | street_number | street_name | street_type | unit | unit_type | city | zipcode | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 789 | 789 | 789 | 060 239400100 | 1140 Page St | 1140 PAGE ST | 1140 PAGE ST | 1140.0 | PAGE | ST | Berkeley | 94702 | 37.87764312810754 | -122.29365836285878 | ||
| 3769 | 3769 | 3769 | 060 239701100 | 1141 Page St A | 1141 PAGE ST A | 1141 PAGE ST | 1141.0 | PAGE | ST | A | Berkeley | 94702 | 37.87793746251888 | -122.29375472873257 | |
| 10400 | 10400 | 10400 | 060 239400100 | 1134 Page St | 1134 PAGE ST | 1134 PAGE ST | 1134.0 | PAGE | ST | Berkeley | 94702 | 37.87764312810754 | -122.29365836285878 | ||
| 18501 | 18501 | 18501 | 060 239601100 | 1123 Page St | 1123 PAGE ST | 1123 PAGE ST | 1123.0 | PAGE | ST | Berkeley | 94702 | 37.87783944784755 | -122.29424785890777 | ||
| 19895 | 19895 | 19895 | 060 239601000 | 1131 Page St | 1131 PAGE ST | 1131 PAGE ST | 1131.0 | PAGE | ST | Berkeley | 94702 | 37.877859431273585 | -122.294138352478 | ||
| 24113 | 24113 | 24113 | 060 239701000 | 1151 Page St | 1151 PAGE ST | 1151 PAGE ST | 1151.0 | PAGE | ST | Berkeley | 94702 | 37.878011376890775 | -122.29342129835362 | ||
| 26952 | 26952 | 26952 | 060 239400100 | 1132 Page St | 1132 PAGE ST | 1132 PAGE ST | 1132.0 | PAGE | ST | Berkeley | 94702 | 37.87764312810754 | -122.29365836285878 | ||
| 32533 | 32533 | 32533 | 060 239701100 | 1135 Page St | 1135 PAGE ST | 1135 PAGE ST | 1135.0 | PAGE | ST | Berkeley | 94702 | 37.87793746251888 | -122.29375472873257 | ||
| 33860 | 33860 | 33860 | 060 239701100 | 1141 Page St | 1141 PAGE ST | 1141 PAGE ST | 1141.0 | PAGE | ST | Berkeley | 94702 | 37.87793746251888 | -122.29375472873257 | ||
| 39228 | 39228 | 39228 | 060 239701100 | 1135 Page St B | 1135 PAGE ST B | 1135 PAGE ST | 1135.0 | PAGE | ST | B | Berkeley | 94702 | 37.87793746251888 | -122.29375472873257 | |
| 45897 | 45897 | 45897 | 060 239701100 | 1141 Page St B | 1141 PAGE ST B | 1141 PAGE ST | 1141.0 | PAGE | ST | B | Berkeley | 94702 | 37.87793746251888 | -122.29375472873257 | |
| 48649 | 48649 | 48649 | 060 239500100 | 1100 Page St | 1100 PAGE ST | 1100 PAGE ST | 1100.0 | PAGE | ST | Berkeley | 94702 | 37.87747314032893 | -122.29448507343156 | ||
| 51150 | 51150 | 51150 | 060 239500200 | 1116 Page St | 1116 PAGE ST | 1116 PAGE ST | 1116.0 | PAGE | ST | Berkeley | 94702 | 37.87753645751805 | -122.29415913949366 | ||
| 52264 | 52264 | 52264 | 060 239601201 | 1119 Page St | 1119 PAGE ST | 1119 PAGE ST | 1119.0 | PAGE | ST | Berkeley | 94702 | 37.877801303263574 | -122.29443910663848 | ||
| 55898 | 55898 | 55898 | 060 239701100 | 1135 Page St A | 1135 PAGE ST A | 1135 PAGE ST | 1135.0 | PAGE | ST | A | Berkeley | 94702 | 37.87793746251888 | -122.29375472873257 |
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);