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

26 rows where street_name = "CURTIS" and zipcode = 94706

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, base_address, street_number, unit, latitude, longitude

zipcode 1

  • 94706 · 26 ✖

street_type 1

street_name 1

  • CURTIS · 26 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
3099 3099 3099 060 241202302 1211 Curtis St 1211 CURTIS ST 1211 CURTIS ST 1211.0 CURTIS ST     Berkeley 94706 37.88256843474398 -122.2893138065142
4276 4276 4276 060 241202000 1227 Curtis St 1227 CURTIS ST 1227 CURTIS ST 1227.0 CURTIS ST     Berkeley 94706 37.88212691825835 -122.28947992387484
7780 7780 7780 060 241202200 1219 Curtis St B 1219 CURTIS ST B 1219 CURTIS ST 1219.0 CURTIS ST B   Berkeley 94706 37.88232402794502 -122.28940408720024
10402 10402 10402 060 241202301 1217 Curtis St 1217 CURTIS ST 1217 CURTIS ST 1217.0 CURTIS ST     Berkeley 94706 37.88243798666072 -122.2893626083903
11484 11484 11484 060 241202301 1217 Curtis St A 1217 CURTIS ST A 1217 CURTIS ST 1217.0 CURTIS ST A   Berkeley 94706 37.88243798666072 -122.2893626083903
13938 13938 13938 060 241100202 1202 Curtis St B 1202 CURTIS ST B 1202 CURTIS ST 1202.0 CURTIS ST B   Berkeley 94706 37.88278252479936 -122.28974062125852
14461 14461 14461 060 241201900 1229 Curtis St 1229 CURTIS ST 1229 CURTIS ST 1229.0 CURTIS ST     Berkeley 94706 37.88202780309192 -122.28951906706506
16019 16019 16019 060 241200100 1201 Curtis St 1201 CURTIS ST 1201 CURTIS ST 1201.0 CURTIS ST     Berkeley 94706 37.882990073614565 -122.2891402457131
18531 18531 18531 060 241202100 1221 Curtis St 1221 CURTIS ST 1221 CURTIS ST 1221.0 CURTIS ST     Berkeley 94706 37.88222433306755 -122.28943891218888
19861 19861 19861 060 241202200 1219 Curtis St A 1219 CURTIS ST A 1219 CURTIS ST 1219.0 CURTIS ST A   Berkeley 94706 37.88232402794502 -122.28940408720024
21557 21557 21557 060 241201800 1231 Curtis St 1231 CURTIS ST 1231 CURTIS ST 1231.0 CURTIS ST     Berkeley 94706 37.881911383440496 -122.28956127620528
28105 28105 28105 060 241100603 1216 Curtis St 1216 CURTIS ST 1216 CURTIS ST 1216.0 CURTIS ST     Berkeley 94706 37.882433772273075 -122.28991480099884
30004 30004 30004 060 241100202 1202 Curtis St 1202 CURTIS ST 1202 CURTIS ST 1202.0 CURTIS ST     Berkeley 94706 37.882835805620246 -122.28974912740594
30310 30310 30310 060 241100400 1206 Curtis St 1206 CURTIS ST 1206 CURTIS ST 1206.0 CURTIS ST     Berkeley 94706 37.88261712981946 -122.28983135289884
31170 31170 31170 060 241202400 1209 Curtis St 1209 CURTIS ST 1209 CURTIS ST 1209.0 CURTIS ST     Berkeley 94706 37.882679878921195 -122.28926622005866
32255 32255 32255 060 241100802 1236 Curtis St 1236 CURTIS ST 1236 CURTIS ST 1236.0 CURTIS ST     Berkeley 94706 37.88220963513415 -122.2899843180254
33021 33021 33021 060 241202302 1213 Curtis St 1213 CURTIS ST 1213 CURTIS ST 1213.0 CURTIS ST     Berkeley 94706 37.88256843474398 -122.2893138065142
33910 33910 33910 060 241202200 1219 Curtis St 1219 CURTIS ST 1219 CURTIS ST 1219.0 CURTIS ST     Berkeley 94706 37.88232402794502 -122.28940408720024
37255 37255 37255 060 241100501 1212 Curtis St 1212 CURTIS ST 1212 CURTIS ST 1212.0 CURTIS ST     Berkeley 94706 37.88252982962262 -122.28986556164318
42042 42042 42042 060 241201701 1237 Curtis St 1237 CURTIS ST 1237 CURTIS ST 1237.0 CURTIS ST     Berkeley 94706 37.88177519395326 -122.28959091252484
45353 45353 45353 060 241100300 1204 Curtis St 1204 CURTIS ST 1204 CURTIS ST 1204.0 CURTIS ST     Berkeley 94706 37.88271590670269 -122.28979476900888
47362 47362 47362 060 241100900 1244 Curtis St 1244 CURTIS ST 1244 CURTIS ST 1244.0 CURTIS ST     Berkeley 94706 37.88203430976222 -122.29005360238834
51624 51624 51624 060 241100701 1230 Curtis St 1230 CURTIS ST 1230 CURTIS ST 1230.0 CURTIS ST     Berkeley 94706 37.88223819152149 -122.28986865005112
51852 51852 51852 060 241202600 1205 Curtis St 1205 CURTIS ST 1205 CURTIS ST 1205.0 CURTIS ST     Berkeley 94706 37.88288014506361 -122.28919312683894
52024 52024 52024 060 241100202 1202 Curtis St A 1202 CURTIS ST A 1202 CURTIS ST 1202.0 CURTIS ST A   Berkeley 94706 37.88279794864662 -122.2897927361214
58163 58163 58163 060 241202500 1207 Curtis St 1207 CURTIS ST 1207 CURTIS ST 1207.0 CURTIS ST     Berkeley 94706 37.88277859049117 -122.28922960293104

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