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

29 rows where street_name = "CARLETON" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94710 · 29 ✖

street_type 1

street_name 1

  • CARLETON · 29 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
3917 3917 3917 054 177000402 811 Carleton St 811 CARLETON ST 811 CARLETON ST 811.0 CARLETON ST     Berkeley 94710 37.85721395976086 -122.2947121486708
8272 8272 8272 054 174400201 1032 Carleton St 1032 CARLETON ST 1032 CARLETON ST 1032.0 CARLETON ST     Berkeley 94710 37.857618979818675 -122.28934076495588
16321 16321 16321 054 177000302 845 Carleton St 845 CARLETON ST 845 CARLETON ST 845.0 CARLETON ST     Berkeley 94710 37.857112091066845 -122.29380321619831
19364 19364 19364 054 174703200 928 Carleton St 928 CARLETON ST 928 CARLETON ST 928.0 CARLETON ST     Berkeley 94710 37.85688455612374 -122.29216074551596
19632 19632 19632 054 174501804 1013 Carleton St G 1013 CARLETON ST G 1013 CARLETON ST 1013.0 CARLETON ST G   Berkeley 94710 37.85739626016369 -122.29034967812284
23945 23945 23945 054 174703200 930 Carleton St 930 CARLETON ST 930 CARLETON ST 930.0 CARLETON ST     Berkeley 94710 37.85688455612374 -122.29216074551596
27220 27220 27220 054 176500401 941 Carleton St 941 CARLETON ST 941 CARLETON ST 941.0 CARLETON ST     Berkeley 94710 37.85766841978989 -122.2911245406324
31344 31344 31344 054 174703200 924 Carleton St 924 CARLETON ST 924 CARLETON ST 924.0 CARLETON ST     Berkeley 94710 37.85688455612374 -122.29216074551596
31784 31784 31784 054 174400201 1030 Carleton St 1030 CARLETON ST 1030 CARLETON ST 1030.0 CARLETON ST     Berkeley 94710 37.857618979818675 -122.28934076495588
36271 36271 36271 054 174501804 1014 Carleton St 1014 CARLETON ST 1014 CARLETON ST 1014.0 CARLETON ST     Berkeley 94710 37.85718939105364 -122.2901168994799
38566 38566 38566 054 174501804 1013 Carleton St A 1013 CARLETON ST A 1013 CARLETON ST 1013.0 CARLETON ST A   Berkeley 94710 37.85747747849 -122.29001879626436
39909 39909 39909 054 176401204 1011 Carleton St 1011 CARLETON ST 1011 CARLETON ST 1011.0 CARLETON ST     Berkeley 94710 37.858047358227054 -122.29048238444314
40652 40652 40652 054 174501804 1010 Carleton St 1010 CARLETON ST 1010 CARLETON ST 1010.0 CARLETON ST     Berkeley 94710 37.85747780120128 -122.29020204898904
40988 40988 40988 054 176300700 1043 Carleton St 1043 CARLETON ST 1043 CARLETON ST 1043.0 CARLETON ST     Berkeley 94710 37.85812746798845 -122.28895557185362
41714 41714 41714 054 174501804 1013 Carleton St E 1013 CARLETON ST E 1013 CARLETON ST 1013.0 CARLETON ST E   Berkeley 94710 37.85742246363743 -122.29024292413108
44850 44850 44850 054 177000501 709 Carleton St 709 CARLETON ST 709 CARLETON ST 709.0 CARLETON ST     Berkeley 94710 37.856998497451855 -122.29631474223932
47172 47172 47172 054 174703200 926 Carleton St 926 CARLETON ST 926 CARLETON ST 926.0 CARLETON ST     Berkeley 94710 37.85688455612374 -122.29216074551596
50332 50332 50332 054 174400400 1034 Carleton St 1034 CARLETON ST 1034 CARLETON ST 1034.0 CARLETON ST     Berkeley 94710 37.85766148186891 -122.28916603185334
51492 51492 51492 054 174501804 1013 Carleton St C 1013 CARLETON ST C 1013 CARLETON ST 1013.0 CARLETON ST C   Berkeley 94710 37.85744949693126 -122.29013279157556
51865 51865 51865 054 174501804 1013 Carleton St D 1013 CARLETON ST D 1013 CARLETON ST 1013.0 CARLETON ST D   Berkeley 94710 37.85743611610813 -122.2901873058386
54480 54480 54480 054 174501804 1013 Carleton St F 1013 CARLETON ST F 1013 CARLETON ST 1013.0 CARLETON ST F   Berkeley 94710 37.857409504107586 -122.2902957217136
56049 56049 56049 054 174400500 1036 Carleton St 1036 CARLETON ST 1036 CARLETON ST 1036.0 CARLETON ST     Berkeley 94710 37.85769037970281 -122.28905158199454
56615 56615 56615 054 176500401 941 Carleton St 1 941 CARLETON ST 1 941 CARLETON ST 941.0 CARLETON ST 1   Berkeley 94710 37.85766841978989 -122.2911245406324
56700 56700 56700 054 174501804 1016 Carleton St 1016 CARLETON ST 1016 CARLETON ST 1016.0 CARLETON ST     Berkeley 94710 37.85718939105364 -122.2901168994799
57301 57301 57301 054 176300800 1035 Carleton St 1035 CARLETON ST 1035 CARLETON ST 1035.0 CARLETON ST     Berkeley 94710 37.858107038057106 -122.28927122187817
57585 57585 57585 054 174501804 1013 Carleton St B 1013 CARLETON ST B 1013 CARLETON ST 1013.0 CARLETON ST B   Berkeley 94710 37.85746329479437 -122.29007657859836
57786 57786 57786 054 177000202 893 Carleton St 893 CARLETON ST 893 CARLETON ST 893.0 CARLETON ST     Berkeley 94710 37.85720576144517 -122.29340931392942
58201 58201 58201 054 176300900 1025 Carleton St 1025 CARLETON ST 1025 CARLETON ST 1025.0 CARLETON ST     Berkeley 94710 37.85802010670336 -122.28954188966314
58271 58271 58271 054 176300700 1039 Carleton St 1039 CARLETON ST 1039 CARLETON ST 1039.0 CARLETON ST     Berkeley 94710 37.85812746798845 -122.28895557185362

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