Christchurch, Canterbury
102,255 rows
This data as json, CSV (advanced)
Link | rowid ▼ | House number | Street name | Postal code | Latitude | Longitude |
---|---|---|---|---|---|---|
1 | 1 | 142 | Peverel Street | 8041 | -43.5348688 | 172.5898422 |
2 | 2 | 2 | Russley Road | 8042 | -43.5199871 | 172.5347836 |
3 | 3 | 70 | Edgeware Road | 8014 | -43.5135395 | 172.6372653 |
4 | 4 | 61 | Edgeware Road | 8014 | -43.5133288 | 172.6369471 |
5 | 5 | 1066 | Colombo Street | 8014 | -43.5138197 | 172.6369492 |
6 | 6 | 250 | Barrington Street | 8024 | -43.5572167 | 172.6191273 |
7 | 7 | 2 | Colombo Street | 8022 | -43.5674279 | 172.6354054 |
8 | 8 | 39 | Fern Drive | 8025 | -43.5775535 | 172.5631720 |
9 | 9 | 189 | Deans Avenue | 8011 | -43.5264122 | 172.6118653 |
10 | 10 | 24 | Logistics Drive | 8051 | -43.4721283 | 172.5640673 |
11 | 11 | 303 | Colombo Street | 8023 | -43.5492787 | 172.6362715 |
12 | 12 | 289 | Colombo Street | 8023 | -43.5499632 | 172.6361501 |
13 | 13 | 300 | Colombo Street | 8023 | -43.5492167 | 172.6373034 |
14 | 14 | 300 | Colombo Street | 8023 | -43.5493965 | 172.6372980 |
15 | 15 | 181 | Clarence Street | 8011 | -43.5316584 | 172.6019502 |
16 | 16 | 28 | Rotherham Street | 8041 | -43.5303845 | 172.6005804 |
17 | 17 | 20 | Rotherham Street | 8041 | -43.5305187 | 172.6005965 |
18 | 18 | 28 | Rotherham Street | 8041 | -43.5313199 | 172.6006769 |
19 | 19 | 536 | Wairakei Road | 8053 | -43.4888915 | 172.5657746 |
20 | 20 | 899 | Main North Road | 8051 | -43.4379519 | 172.6366847 |
21 | 21 | 50 | Ferrymead Park Drive | 8022 | -43.5661100 | 172.7003977 |
22 | 22 | 23 | Humphreys Drive | 8241 | -43.5567691 | 172.7050276 |
23 | 23 | 500 | Cranford Street | 8051 | -43.4901522 | 172.6211981 |
24 | 24 | 142 | Somerfield Street | 8024 | -43.5576963 | 172.6359499 |
25 | 25 | 7 | Chalmers Street | 8042 | -43.5429974 | 172.5220397 |
26 | 26 | 36 | Main North Road | 8053 | -43.4952129 | 172.6093154 |
27 | 27 | 481 | Papanui Road | 8053 | -43.4982693 | 172.6088015 |
28 | 28 | 75 | Rutland Street | 8014 | -43.5062251 | 172.6284517 |
29 | 29 | 233A | Riccarton Road | 8041 | -43.5308500 | 172.5876470 |
30 | 30 | 20 | Colombo Street | 8022 | -43.5668998 | 172.6357840 |
31 | 31 | 18 | Colombo Street | 8022 | -43.5669094 | 172.6357171 |
32 | 32 | 8 | Colombo Street | 8022 | -43.5671369 | 172.6354797 |
33 | 33 | 315 | Main North Road | 8051 | -43.4789285 | 172.6162767 |
34 | 34 | 68 | Rapaki Road | 8022 | -43.5696218 | 172.6634665 |
35 | 35 | 58 | Rapaki Road | 8022 | -43.5691280 | 172.6634875 |
36 | 36 | 64 | Rapaki Road | 8022 | -43.5694620 | 172.6632675 |
37 | 37 | 247 | Burwood Road | 8083 | -43.4839013 | 172.6808609 |
38 | 38 | 2 | Buckleys Road | 8062 | -43.5334675 | 172.6737788 |
39 | 39 | 263 | Bealey Ave | 8013 | -43.5204303 | 172.6442619 |
40 | 40 | 2 | Somerfield Street | 8024 | -43.5634965 | 172.6260782 |
41 | 41 | 7 | Marshland Road | 8061 | -43.5074809 | 172.6624122 |
42 | 42 | 548 | Main North Road | 8051 | -43.4590433 | 172.6238043 |
43 | 43 | 235 | Annex Road | 8024 | -43.5432911 | 172.5809815 |
44 | 44 | 7c | Witham Street | 8042 | -43.5515754 | 172.5308876 |
45 | 45 | 24 | Grampian Street | 8051 | -43.4801723 | 172.6033940 |
46 | 46 | 16 | Grampian Street | 8051 | -43.4803415 | 172.6032838 |
47 | 47 | 61 | Mandeville Street | 8011 | -43.5330542 | 172.6062897 |
48 | 48 | 376 | Ilam Road | 8053 | -43.5095130 | 172.5902803 |
49 | 49 | 339 | Main North Road | 8051 | -43.4774150 | 172.6164750 |
50 | 50 | 2 | Birmingham Drive | 8024 | -43.5443431 | 172.5940025 |
51 | 51 | 101 | Main North Road | 8052 | -43.4912030 | 172.6125793 |
52 | 52 | 409 | Harewood Road | 8051 | -43.4843222 | 172.5784462 |
53 | 53 | 19 | Memorial Avenue | 8053 | -43.5181536 | 172.5878385 |
54 | 54 | 19-23 | Memorial Avenue | 8053 | -43.5179319 | 172.5883750 |
55 | 55 | 290 | Wairakei Rd | 8053 | -43.4992884 | 172.5859982 |
56 | 56 | 291 | Wairakei Road | 8053 | -43.4993490 | 172.5852642 |
57 | 57 | 35 | Riccarton Road | 8011 | -43.5296844 | 172.6084570 |
58 | 58 | 87 | Effingham Street | 8083 | -43.4905542 | 172.7180813 |
59 | 59 | 17 | Papanui Road | 8014 | -43.5195733 | 172.6269082 |
60 | 60 | 1066d | Colombo Street | 8014 | -43.5138117 | 172.6370620 |
61 | 61 | 1 | Riccarton Road | 8011 | -43.5289756 | 172.6116933 |
62 | 62 | 64-66 | Riccarton Road | 8011 | -43.5291401 | 172.6043366 |
63 | 63 | 13a | Riccarton Road | 8011 | -43.5289914 | 172.6110422 |
64 | 64 | 32 | Riccarton Road | 8011 | -43.5286550 | 172.6082567 |
65 | 65 | 235 | Papanui Road | 8014 | -43.5107555 | 172.6202494 |
66 | 66 | 86 | Harris Crescent | 8053 | -43.4960248 | 172.5953114 |
67 | 67 | 84 | Harris Crescent | 8053 | -43.4960659 | 172.5953832 |
68 | 68 | 80 | Harris Crescent | 8053 | -43.4961231 | 172.5955106 |
69 | 69 | 244 | Cranford Street | 8052 | -43.5019943 | 172.6324768 |
70 | 70 | 159 | Cranford Street | 8014 | -43.5063035 | 172.6358792 |
71 | 71 | 236 | Papanui Road | 8014 | -43.5102790 | 172.6205476 |
72 | 72 | 215 | Innes Road | 8052 | -43.5023415 | 172.6329269 |
73 | 73 | 29 | Colombo Street | 8022 | -43.5649309 | 172.6369000 |
74 | 74 | 29 | Colombo Street | 8022 | -43.5649589 | 172.6369031 |
75 | 75 | 202 | Withells Road | 8042 | -43.5117196 | 172.5559710 |
76 | 76 | 150 | Cavendish Road | 8051 | -43.4738589 | 172.6076905 |
77 | 77 | 376 | Ilam Road | 8053 | -43.5091323 | 172.5902159 |
78 | 78 | 164 | Queenspark Drive | 8083 | -43.4778368 | 172.6959984 |
79 | 79 | 390 | Montreal Street | 8013 | -43.5234881 | 172.6308289 |
80 | 80 | 438 | Papanui Road | 8052 | -43.5003140 | 172.6115319 |
81 | 81 | 106 | Memorial Avenue | 8041 | -43.5120918 | 172.5805194 |
82 | 82 | 28 | North Avon Road | 8013 | -43.5179147 | 172.6539529 |
83 | 83 | 215 | Ashgrove Terrace | 8024 | -43.5669028 | 172.6293675 |
84 | 84 | 249 | Papanui Road | 8140 | -43.5106550 | 172.6184237 |
85 | 85 | 288 | Woodham Road | 8062 | -43.5253525 | 172.6806349 |
86 | 86 | 250 | Pages Road | 8062 | -43.5214616 | 172.6991365 |
87 | 87 | 23 | Main North Road | 8053 | -43.4956428 | 172.6082268 |
88 | 88 | 461 | Papanui Road | 8053 | -43.4995580 | 172.6097839 |
89 | 89 | 261 | Stanmore Road | 8013 | -43.5218711 | 172.6561234 |
90 | 90 | 175 | Wainoni Road | 8061 | -43.5118722 | 172.6921195 |
91 | 91 | 619 | Ferry Road | 8023 | -43.5471963 | 172.6795717 |
92 | 92 | 417 | Ferry Road | 8023 | -43.5433243 | 172.6679775 |
93 | 93 | 155 | Salisbury Street | 8013 | -43.5239725 | 172.6394360 |
94 | 94 | 20 | Troup Drive | 8149 | -43.5404831 | 172.6065550 |
95 | 95 | 3/92 | Wilsons Road South | 8022 | -43.5582099 | 172.6547467 |
96 | 96 | 132 | Peterborough Street | 8013 | -43.5264417 | 172.6378242 |
97 | 97 | 10 | Athelstan Street | 8024 | -43.5572839 | 172.6199754 |
98 | 98 | 189 | Papanui Road | 8014 | -43.5122464 | 172.6215421 |
99 | 99 | 1005 | Ferry Road | 8023 | -43.5569352 | 172.7014708 |
100 | 100 | 2 | Waterman Place | 8023 | -43.5560950 | 172.6981127 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [Christchurch, Canterbury] ( [House number] TEXT, [Street name] TEXT, [Postal code] TEXT, [Latitude] TEXT, [Longitude] TEXT );