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

51 rows where street_name = "PARDEE" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn

zipcode 1

street_type 1

street_name 1

  • PARDEE · 51 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
5820 5820 5820 054 174501804 1013 Pardee St 207 1013 PARDEE ST 207 1013 PARDEE ST 1013.0 PARDEE ST 207   Berkeley 94710 37.856929736057445 -122.29006024453156
6013 6013 6013 054 174501804 1013 Pardee St 106 1013 PARDEE ST 106 1013 PARDEE ST 1013.0 PARDEE ST 106   Berkeley 94710 37.85704790734107 -122.28981123602637
6041 6041 6041 054 174504403 1006 Pardee St 1006 PARDEE ST 1006 PARDEE ST 1006.0 PARDEE ST     Berkeley 94710 37.85654133808696 -122.29008912087636
6135 6135 6135 054 174600902 935 Pardee St 935 PARDEE ST 935 PARDEE ST 935.0 PARDEE ST     Berkeley 94710 37.856682644037456 -122.29119601957954
8852 8852 8852 054 174704000 915 Pardee St 915 PARDEE ST 915 PARDEE ST 915.0 PARDEE ST     Berkeley 94710 37.85640693586053 -122.2919994574983
10828 10828 10828 054 174401000 1031 Pardee St 1031 PARDEE ST 1031 PARDEE ST 1031.0 PARDEE ST     Berkeley 94710 37.85718614690565 -122.2891728195236
11775 11775 11775 054 174601100 931 Pardee St 931 PARDEE ST 931 PARDEE ST 931.0 PARDEE ST     Berkeley 94710 37.85662288929075 -122.29143186327424
12394 12394 12394 054 174502400 1012 Pardee St 1012 PARDEE ST 1012 PARDEE ST 1012.0 PARDEE ST     Berkeley 94710 37.85657854255451 -122.2899393833966
14037 14037 14037 054 174501804 1013 Pardee St 203 1013 PARDEE ST 203 1013 PARDEE ST 1013.0 PARDEE ST 203   Berkeley 94710 37.85698297245268 -122.28984335978092
14569 14569 14569 054 174501804 1013 Pardee St 202 1013 PARDEE ST 202 1013 PARDEE ST 1013.0 PARDEE ST 202   Berkeley 94710 37.856996770403114 -122.28978714680372
14606 14606 14606 054 174501804 1013 Pardee St 101 1013 PARDEE ST 101 1013 PARDEE ST 1013.0 PARDEE ST 101   Berkeley 94710 37.85706209040736 -122.28975345369236
15778 15778 15778 054 174601705 940 Pardee St 940 PARDEE ST 940 PARDEE ST 940.0 PARDEE ST     Berkeley 94710 37.85636662330142 -122.2907783353118
16057 16057 16057 054 174501804 1013 Pardee St 208 1013 PARDEE ST 208 1013 PARDEE ST 1013.0 PARDEE ST 208   Berkeley 94710 37.85691596362781 -122.29011635240587
16365 16365 16365 054 174704000 919 Pardee St 919 PARDEE ST 919 PARDEE ST 919.0 PARDEE ST     Berkeley 94710 37.85640693586053 -122.2919994574983
16623 16623 16623 054 174501804 1013 Pardee St 107 1013 PARDEE ST 107 1013 PARDEE ST 1013.0 PARDEE ST 107   Berkeley 94710 37.85703410940019 -122.28986744810526
18231 18231 18231 054 174401500 1020 Pardee St 1020 PARDEE ST 1020 PARDEE ST 1020.0 PARDEE ST     Berkeley 94710 37.85675148297202 -122.28922989757848
19126 19126 19126 054 174401800 1034 Pardee St 1034 PARDEE ST 1034 PARDEE ST 1034.0 PARDEE ST     Berkeley 94710 37.85683389427791 -122.28890707270976
21650 21650 21650 054 174501804 1013 Pardee St 109 1013 PARDEE ST 109 1013 PARDEE ST 1013.0 PARDEE ST 109   Berkeley 94710 37.85702072850168 -122.28992196236828
23348 23348 23348 054 174704000 925 Pardee St 925 PARDEE ST 925 PARDEE ST 925.0 PARDEE ST     Berkeley 94710 37.85640693586053 -122.2919994574983
26055 26055 26055 054 174401900 1036 Pardee St 1036 PARDEE ST 1036 PARDEE ST 1036.0 PARDEE ST     Berkeley 94710 37.856864886176304 -122.28878651790028
26595 26595 26595 054 174403300 1033 Pardee St A 1033 PARDEE ST A 1033 PARDEE ST 1033.0 PARDEE ST A   Berkeley 94710 37.857215149186814 -122.28905751357038
28578 28578 28578 054 174501804 1013 Pardee St 205 1013 PARDEE ST 205 1013 PARDEE ST 1013.0 PARDEE ST 205   Berkeley 94710 37.85695593898775 -122.28995349233644
28670 28670 28670 054 174501804 1013 Pardee St 1013 PARDEE ST 1013 PARDEE ST 1013.0 PARDEE ST     Berkeley 94710 37.856990299112205 -122.29003811722949
29317 29317 29317 054 174400803 1037 Pardee St 1037 PARDEE ST 1037 PARDEE ST 1037.0 PARDEE ST     Berkeley 94710 37.85729409241498 -122.28893895571582
30327 30327 30327 054 174502001 1000 Pardee St 1000 PARDEE ST 1000 PARDEE ST 1000.0 PARDEE ST     Berkeley 94710 37.856498557358954 -122.2902612695258
30438 30438 30438 054 174403300 1033 Pardee St 1033 PARDEE ST 1033 PARDEE ST 1033.0 PARDEE ST     Berkeley 94710 37.857215149186814 -122.28905751357038
30878 30878 30878 054 174704000 923 Pardee St 923 PARDEE ST 923 PARDEE ST 923.0 PARDEE ST     Berkeley 94710 37.85640693586053 -122.2919994574983
30881 30881 30881 054 174701100 920 Pardee St 920 PARDEE ST 920 PARDEE ST 920.0 PARDEE ST     Berkeley 94710 37.85599675629761 -122.29210837014168
30989 30989 30989 054 174401900 1038 Pardee St 1038 PARDEE ST 1038 PARDEE ST 1038.0 PARDEE ST     Berkeley 94710 37.856864886176304 -122.28878651790028
31566 31566 31566 054 174704000 917 Pardee St 917 PARDEE ST 917 PARDEE ST 917.0 PARDEE ST     Berkeley 94710 37.85640693586053 -122.2919994574983
33066 33066 33066 054 174601403 938 Pardee St 938 PARDEE ST 938 PARDEE ST 938.0 PARDEE ST     Berkeley 94710 37.856307820134646 -122.29101180745413
33780 33780 33780 054 174704000 921 Pardee St 921 PARDEE ST 921 PARDEE ST 921.0 PARDEE ST     Berkeley 94710 37.85640693586053 -122.2919994574983
34221 34221 34221 054 174501804 1013 Pardee St 209 1013 PARDEE ST 209 1013 PARDEE ST 1013.0 PARDEE ST 209   Berkeley 94710 37.85690285931968 -122.2901697374866
35000 35000 35000 054 174401600 1028 Pardee St 1028 PARDEE ST 1028 PARDEE ST 1028.0 PARDEE ST     Berkeley 94710 37.856779634309405 -122.28913083855544
35265 35265 35265 054 174701100 904 Pardee St 904 PARDEE ST 904 PARDEE ST 904.0 PARDEE ST     Berkeley 94710 37.85599675629761 -122.29210837014168
36669 36669 36669 054 174501804 1001 Pardee St 1001 PARDEE ST 1001 PARDEE ST 1001.0 PARDEE ST     Berkeley 94710 37.85718939105364 -122.2901168994799
36852 36852 36852 054 174502802 1018 Pardee St 1018 PARDEE ST 1018 PARDEE ST 1018.0 PARDEE ST     Berkeley 94710 37.85666703456946 -122.28958643532148
38346 38346 38346 054 174501804 1013 Pardee St 211 1013 PARDEE ST 211 1013 PARDEE ST 1013.0 PARDEE ST 211   Berkeley 94710 37.85687581164012 -122.29027993022925
38709 38709 38709 054 174501804 1013 Pardee St 206 1013 PARDEE ST 206 1013 PARDEE ST 1013.0 PARDEE ST 206   Berkeley 94710 37.856942980085165 -122.29000628902064
39850 39850 39850 054 174604000 927 Pardee St 3 927 PARDEE ST 3 927 PARDEE ST 927.0 PARDEE ST 3   Berkeley 94710 37.85659444851371 -122.2915446314868
42450 42450 42450 054 174501804 1013 Pardee St 212 1013 PARDEE ST 212 1013 PARDEE ST 1013.0 PARDEE ST 212   Berkeley 94710 37.85686131220736 -122.29033899895074
44021 44021 44021 054 174403300 1033 Pardee St B 1033 PARDEE ST B 1033 PARDEE ST 1033.0 PARDEE ST B   Berkeley 94710 37.857215149186814 -122.28905751357038
46175 46175 46175 054 174502501 1014 Pardee St 1014 PARDEE ST 1014 PARDEE ST 1014.0 PARDEE ST     Berkeley 94710 37.85662106577334 -122.28977494319057
47389 47389 47389 054 174501804 1013 Pardee St 201 1013 PARDEE ST 201 1013 PARDEE ST 1013.0 PARDEE ST 201   Berkeley 94710 37.857010953479254 -122.289729365368
47773 47773 47773 054 174501804 1013 Pardee St 110 1013 PARDEE ST 110 1013 PARDEE ST 1013.0 PARDEE ST 110   Berkeley 94710 37.85700707595403 -122.28997758066076
51844 51844 51844 054 174501804 1013 Pardee St 210 1013 PARDEE ST 210 1013 PARDEE ST 1013.0 PARDEE ST 210   Berkeley 94710 37.85688908688507 -122.29022584536092
52580 52580 52580 054 174401700 1032 Pardee St 1032 PARDEE ST 1032 PARDEE ST 1032.0 PARDEE ST     Berkeley 94710 37.85680330877369 -122.2890284270198
56055 56055 56055 054 174603600 947 Pardee St 947 PARDEE ST 947 PARDEE ST 947.0 PARDEE ST     Berkeley 94710 37.8567618190555 -122.290882643191
56056 56056 56056 054 174501804 1013 Pardee St 214 1013 PARDEE ST 214 1013 PARDEE ST 1013.0 PARDEE ST 214   Berkeley 94710 37.856846804969855 -122.29039809911328
56187 56187 56187 054 174401100 1029 Pardee St 1029 PARDEE ST 1029 PARDEE ST 1029.0 PARDEE ST     Berkeley 94710 37.85716384781689 -122.2892649175015
57115 57115 57115 054 174501804 1013 Pardee St 204 1013 PARDEE ST 204 1013 PARDEE ST 1013.0 PARDEE ST 204   Berkeley 94710 37.856969591544875 -122.28989787404396

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