wasCSharpSQLite – Blame information for rev 4
?pathlinks?
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | office | 1 | # 2011 March 25 |
| 2 | # |
||
| 3 | # The author disclaims copyright to this source code. In place of |
||
| 4 | # a legal notice, here is a blessing: |
||
| 5 | # |
||
| 6 | # May you do good and not evil. |
||
| 7 | # May you find forgiveness for yourself and forgive others. |
||
| 8 | # May you share freely, never taking more than you give. |
||
| 9 | # |
||
| 10 | #*********************************************************************** |
||
| 11 | # This file implements regression tests for TCL interface to the |
||
| 12 | # SQLite library. |
||
| 13 | # |
||
| 14 | # The focus of the tests is the word-fuzzer virtual table. |
||
| 15 | # |
||
| 16 | |||
| 17 | set testdir [file dirname $argv0] |
||
| 18 | source $testdir/tester.tcl |
||
| 19 | |||
| 20 | ifcapable !vtab { |
||
| 21 | finish_test |
||
| 22 | return |
||
| 23 | } |
||
| 24 | |||
| 25 | register_fuzzer_module db |
||
| 26 | do_test fuzzer1-1.0 { |
||
| 27 | catchsql {CREATE VIRTUAL TABLE fault1 USING fuzzer;} |
||
| 28 | } {1 {fuzzer virtual tables must be TEMP}} |
||
| 29 | do_test fuzzer1-1.1 { |
||
| 30 | db eval {CREATE VIRTUAL TABLE temp.f1 USING fuzzer;} |
||
| 31 | } {} |
||
| 32 | do_test fuzzer1-1.2 { |
||
| 33 | db eval { |
||
| 34 | INSERT INTO f1(cfrom, cto, cost) VALUES('e','a',1); |
||
| 35 | INSERT INTO f1(cfrom, cto, cost) VALUES('a','e',10); |
||
| 36 | INSERT INTO f1(cfrom, cto, cost) VALUES('e','o',100); |
||
| 37 | } |
||
| 38 | } {} |
||
| 39 | |||
| 40 | do_test fuzzer1-1.3 { |
||
| 41 | db eval { |
||
| 42 | SELECT word, distance FROM f1 WHERE word MATCH 'abcde' |
||
| 43 | } |
||
| 44 | } {abcde 0 abcda 1 ebcde 10 ebcda 11 abcdo 100 ebcdo 110 obcde 110 obcda 111 obcdo 210} |
||
| 45 | |||
| 46 | do_test fuzzer1-2.0 { |
||
| 47 | execsql { |
||
| 48 | CREATE VIRTUAL TABLE temp.f2 USING fuzzer; |
||
| 49 | -- costs based on English letter frequencies |
||
| 50 | INSERT INTO f2(cFrom,cTo,cost) VALUES('a','e',24); |
||
| 51 | INSERT INTO f2(cFrom,cTo,cost) VALUES('a','o',47); |
||
| 52 | INSERT INTO f2(cFrom,cTo,cost) VALUES('a','u',50); |
||
| 53 | INSERT INTO f2(cFrom,cTo,cost) VALUES('e','a',23); |
||
| 54 | INSERT INTO f2(cFrom,cTo,cost) VALUES('e','i',33); |
||
| 55 | INSERT INTO f2(cFrom,cTo,cost) VALUES('e','o',37); |
||
| 56 | INSERT INTO f2(cFrom,cTo,cost) VALUES('i','e',33); |
||
| 57 | INSERT INTO f2(cFrom,cTo,cost) VALUES('i','y',33); |
||
| 58 | INSERT INTO f2(cFrom,cTo,cost) VALUES('o','a',41); |
||
| 59 | INSERT INTO f2(cFrom,cTo,cost) VALUES('o','e',46); |
||
| 60 | INSERT INTO f2(cFrom,cTo,cost) VALUES('o','u',57); |
||
| 61 | INSERT INTO f2(cFrom,cTo,cost) VALUES('u','o',58); |
||
| 62 | INSERT INTO f2(cFrom,cTo,cost) VALUES('y','i',33); |
||
| 63 | |||
| 64 | INSERT INTO f2(cFrom,cTo,cost) VALUES('t','th',70); |
||
| 65 | INSERT INTO f2(cFrom,cTo,cost) VALUES('th','t',66); |
||
| 66 | |||
| 67 | |||
| 68 | INSERT INTO f2(cFrom,cTo,cost) VALUES('a','',84); |
||
| 69 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','b',106); |
||
| 70 | INSERT INTO f2(cFrom,cTo,cost) VALUES('b','',106); |
||
| 71 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','c',94); |
||
| 72 | INSERT INTO f2(cFrom,cTo,cost) VALUES('c','',94); |
||
| 73 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','d',89); |
||
| 74 | INSERT INTO f2(cFrom,cTo,cost) VALUES('d','',89); |
||
| 75 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','e',83); |
||
| 76 | INSERT INTO f2(cFrom,cTo,cost) VALUES('e','',83); |
||
| 77 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','f',97); |
||
| 78 | INSERT INTO f2(cFrom,cTo,cost) VALUES('f','',97); |
||
| 79 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','g',99); |
||
| 80 | INSERT INTO f2(cFrom,cTo,cost) VALUES('g','',99); |
||
| 81 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','h',86); |
||
| 82 | INSERT INTO f2(cFrom,cTo,cost) VALUES('h','',86); |
||
| 83 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','i',85); |
||
| 84 | INSERT INTO f2(cFrom,cTo,cost) VALUES('i','',85); |
||
| 85 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','j',120); |
||
| 86 | INSERT INTO f2(cFrom,cTo,cost) VALUES('j','',120); |
||
| 87 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','k',120); |
||
| 88 | INSERT INTO f2(cFrom,cTo,cost) VALUES('k','',120); |
||
| 89 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','l',89); |
||
| 90 | INSERT INTO f2(cFrom,cTo,cost) VALUES('l','',89); |
||
| 91 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','m',96); |
||
| 92 | INSERT INTO f2(cFrom,cTo,cost) VALUES('m','',96); |
||
| 93 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','n',85); |
||
| 94 | INSERT INTO f2(cFrom,cTo,cost) VALUES('n','',85); |
||
| 95 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','o',85); |
||
| 96 | INSERT INTO f2(cFrom,cTo,cost) VALUES('o','',85); |
||
| 97 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','p',100); |
||
| 98 | INSERT INTO f2(cFrom,cTo,cost) VALUES('p','',100); |
||
| 99 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','q',120); |
||
| 100 | INSERT INTO f2(cFrom,cTo,cost) VALUES('q','',120); |
||
| 101 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','r',86); |
||
| 102 | INSERT INTO f2(cFrom,cTo,cost) VALUES('r','',86); |
||
| 103 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','s',86); |
||
| 104 | INSERT INTO f2(cFrom,cTo,cost) VALUES('s','',86); |
||
| 105 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','t',84); |
||
| 106 | INSERT INTO f2(cFrom,cTo,cost) VALUES('t','',84); |
||
| 107 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','u',94); |
||
| 108 | INSERT INTO f2(cFrom,cTo,cost) VALUES('u','',94); |
||
| 109 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','v',120); |
||
| 110 | INSERT INTO f2(cFrom,cTo,cost) VALUES('v','',120); |
||
| 111 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','w',96); |
||
| 112 | INSERT INTO f2(cFrom,cTo,cost) VALUES('w','',96); |
||
| 113 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','x',120); |
||
| 114 | INSERT INTO f2(cFrom,cTo,cost) VALUES('x','',120); |
||
| 115 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','y',100); |
||
| 116 | INSERT INTO f2(cFrom,cTo,cost) VALUES('y','',100); |
||
| 117 | INSERT INTO f2(cFrom,cTo,cost) VALUES('','z',120); |
||
| 118 | INSERT INTO f2(cFrom,cTo,cost) VALUES('z','',120); |
||
| 119 | |||
| 120 | -- Street names for the 28269 ZIPCODE. |
||
| 121 | -- |
||
| 122 | CREATE TEMP TABLE streetname(n TEXT UNIQUE); |
||
| 123 | INSERT INTO streetname VALUES('abbotsinch'); |
||
| 124 | INSERT INTO streetname VALUES('abbottsgate'); |
||
| 125 | INSERT INTO streetname VALUES('abbywood'); |
||
| 126 | INSERT INTO streetname VALUES('abner'); |
||
| 127 | INSERT INTO streetname VALUES('acacia ridge'); |
||
| 128 | INSERT INTO streetname VALUES('acorn creek'); |
||
| 129 | INSERT INTO streetname VALUES('acorn forest'); |
||
| 130 | INSERT INTO streetname VALUES('adel'); |
||
| 131 | INSERT INTO streetname VALUES('ainslie'); |
||
| 132 | INSERT INTO streetname VALUES('airways'); |
||
| 133 | INSERT INTO streetname VALUES('alabaster'); |
||
| 134 | INSERT INTO streetname VALUES('alba'); |
||
| 135 | INSERT INTO streetname VALUES('albertine'); |
||
| 136 | INSERT INTO streetname VALUES('alden glen'); |
||
| 137 | INSERT INTO streetname VALUES('alderson'); |
||
| 138 | INSERT INTO streetname VALUES('allen'); |
||
| 139 | INSERT INTO streetname VALUES('allen a brown'); |
||
| 140 | INSERT INTO streetname VALUES('allness glen'); |
||
| 141 | INSERT INTO streetname VALUES('aloysia'); |
||
| 142 | INSERT INTO streetname VALUES('alpine'); |
||
| 143 | INSERT INTO streetname VALUES('alwyn'); |
||
| 144 | INSERT INTO streetname VALUES('amaranthus'); |
||
| 145 | INSERT INTO streetname VALUES('amber glen'); |
||
| 146 | INSERT INTO streetname VALUES('amber leigh way'); |
||
| 147 | INSERT INTO streetname VALUES('amber meadows'); |
||
| 148 | INSERT INTO streetname VALUES('amberway'); |
||
| 149 | INSERT INTO streetname VALUES('ame'); |
||
| 150 | INSERT INTO streetname VALUES('amesbury hill'); |
||
| 151 | INSERT INTO streetname VALUES('anderson'); |
||
| 152 | INSERT INTO streetname VALUES('andrew thomas'); |
||
| 153 | INSERT INTO streetname VALUES('anduin falls'); |
||
| 154 | INSERT INTO streetname VALUES('ankeny'); |
||
| 155 | INSERT INTO streetname VALUES('annandale'); |
||
| 156 | INSERT INTO streetname VALUES('annbick'); |
||
| 157 | INSERT INTO streetname VALUES('antelope'); |
||
| 158 | INSERT INTO streetname VALUES('anzack'); |
||
| 159 | INSERT INTO streetname VALUES('apple glen'); |
||
| 160 | INSERT INTO streetname VALUES('applevalley'); |
||
| 161 | INSERT INTO streetname VALUES('appley mead'); |
||
| 162 | INSERT INTO streetname VALUES('aragorn'); |
||
| 163 | INSERT INTO streetname VALUES('arbor creek'); |
||
| 164 | INSERT INTO streetname VALUES('arbor day'); |
||
| 165 | INSERT INTO streetname VALUES('arbor meadows'); |
||
| 166 | INSERT INTO streetname VALUES('arbor spring'); |
||
| 167 | INSERT INTO streetname VALUES('arborview'); |
||
| 168 | INSERT INTO streetname VALUES('arklow'); |
||
| 169 | INSERT INTO streetname VALUES('armitage'); |
||
| 170 | INSERT INTO streetname VALUES('arvin'); |
||
| 171 | INSERT INTO streetname VALUES('ash cove'); |
||
| 172 | INSERT INTO streetname VALUES('ashford leigh'); |
||
| 173 | INSERT INTO streetname VALUES('ashmont'); |
||
| 174 | INSERT INTO streetname VALUES('atlas'); |
||
| 175 | INSERT INTO streetname VALUES('atwater'); |
||
| 176 | INSERT INTO streetname VALUES('auburn hill'); |
||
| 177 | INSERT INTO streetname VALUES('aulton link'); |
||
| 178 | INSERT INTO streetname VALUES('austin dekota'); |
||
| 179 | INSERT INTO streetname VALUES('austin knoll'); |
||
| 180 | INSERT INTO streetname VALUES('auten'); |
||
| 181 | INSERT INTO streetname VALUES('autumn harvest'); |
||
| 182 | INSERT INTO streetname VALUES('autumn oak'); |
||
| 183 | INSERT INTO streetname VALUES('autumn ridge'); |
||
| 184 | INSERT INTO streetname VALUES('avalon forest'); |
||
| 185 | INSERT INTO streetname VALUES('avalon loop'); |
||
| 186 | INSERT INTO streetname VALUES('avon farm'); |
||
| 187 | INSERT INTO streetname VALUES('avonhurst'); |
||
| 188 | INSERT INTO streetname VALUES('avonlea'); |
||
| 189 | INSERT INTO streetname VALUES('aynrand'); |
||
| 190 | INSERT INTO streetname VALUES('azure valley'); |
||
| 191 | INSERT INTO streetname VALUES('baberton'); |
||
| 192 | INSERT INTO streetname VALUES('baffin'); |
||
| 193 | INSERT INTO streetname VALUES('baggins'); |
||
| 194 | INSERT INTO streetname VALUES('balata'); |
||
| 195 | INSERT INTO streetname VALUES('ballantray'); |
||
| 196 | INSERT INTO streetname VALUES('ballston'); |
||
| 197 | INSERT INTO streetname VALUES('balsam tree'); |
||
| 198 | INSERT INTO streetname VALUES('bambi'); |
||
| 199 | INSERT INTO streetname VALUES('banwell'); |
||
| 200 | INSERT INTO streetname VALUES('barbee'); |
||
| 201 | INSERT INTO streetname VALUES('barefoot forest'); |
||
| 202 | INSERT INTO streetname VALUES('barnview'); |
||
| 203 | INSERT INTO streetname VALUES('baroda'); |
||
| 204 | INSERT INTO streetname VALUES('barson'); |
||
| 205 | INSERT INTO streetname VALUES('baskerville'); |
||
| 206 | INSERT INTO streetname VALUES('battle creek'); |
||
| 207 | INSERT INTO streetname VALUES('baucom'); |
||
| 208 | INSERT INTO streetname VALUES('bay pines'); |
||
| 209 | INSERT INTO streetname VALUES('beaker'); |
||
| 210 | INSERT INTO streetname VALUES('beard'); |
||
| 211 | INSERT INTO streetname VALUES('beardsley'); |
||
| 212 | INSERT INTO streetname VALUES('bearoak'); |
||
| 213 | INSERT INTO streetname VALUES('beauvista'); |
||
| 214 | INSERT INTO streetname VALUES('beaver creek'); |
||
| 215 | INSERT INTO streetname VALUES('beaver hollow'); |
||
| 216 | INSERT INTO streetname VALUES('bedlington'); |
||
| 217 | INSERT INTO streetname VALUES('beech cove'); |
||
| 218 | INSERT INTO streetname VALUES('beech crest'); |
||
| 219 | INSERT INTO streetname VALUES('beith'); |
||
| 220 | INSERT INTO streetname VALUES('bell glen'); |
||
| 221 | INSERT INTO streetname VALUES('bellmore'); |
||
| 222 | INSERT INTO streetname VALUES('bells mill'); |
||
| 223 | INSERT INTO streetname VALUES('bellville'); |
||
| 224 | INSERT INTO streetname VALUES('belmar place'); |
||
| 225 | INSERT INTO streetname VALUES('bembridge'); |
||
| 226 | INSERT INTO streetname VALUES('bennett neely'); |
||
| 227 | INSERT INTO streetname VALUES('bentgrass run'); |
||
| 228 | INSERT INTO streetname VALUES('benthaven'); |
||
| 229 | INSERT INTO streetname VALUES('bernardy'); |
||
| 230 | INSERT INTO streetname VALUES('bernbrook shadow'); |
||
| 231 | INSERT INTO streetname VALUES('berrybrook'); |
||
| 232 | INSERT INTO streetname VALUES('berrybush'); |
||
| 233 | INSERT INTO streetname VALUES('berwick'); |
||
| 234 | INSERT INTO streetname VALUES('betterton'); |
||
| 235 | INSERT INTO streetname VALUES('bickham'); |
||
| 236 | INSERT INTO streetname VALUES('billingham'); |
||
| 237 | INSERT INTO streetname VALUES('birchcroft'); |
||
| 238 | INSERT INTO streetname VALUES('birchstone'); |
||
| 239 | INSERT INTO streetname VALUES('birdwell'); |
||
| 240 | INSERT INTO streetname VALUES('bisaner'); |
||
| 241 | INSERT INTO streetname VALUES('bitterbush'); |
||
| 242 | INSERT INTO streetname VALUES('bitterroot'); |
||
| 243 | INSERT INTO streetname VALUES('black fox'); |
||
| 244 | INSERT INTO streetname VALUES('black maple'); |
||
| 245 | INSERT INTO streetname VALUES('black trail'); |
||
| 246 | INSERT INTO streetname VALUES('blackbird'); |
||
| 247 | INSERT INTO streetname VALUES('blake a dare'); |
||
| 248 | INSERT INTO streetname VALUES('blasdell'); |
||
| 249 | INSERT INTO streetname VALUES('blue aster'); |
||
| 250 | INSERT INTO streetname VALUES('blue finch'); |
||
| 251 | INSERT INTO streetname VALUES('blue lilac'); |
||
| 252 | INSERT INTO streetname VALUES('blue sky'); |
||
| 253 | INSERT INTO streetname VALUES('blue tick'); |
||
| 254 | INSERT INTO streetname VALUES('bob beatty'); |
||
| 255 | INSERT INTO streetname VALUES('bobcat'); |
||
| 256 | INSERT INTO streetname VALUES('bolton'); |
||
| 257 | INSERT INTO streetname VALUES('boomerang'); |
||
| 258 | INSERT INTO streetname VALUES('boulder'); |
||
| 259 | INSERT INTO streetname VALUES('boxer'); |
||
| 260 | INSERT INTO streetname VALUES('boxmeer'); |
||
| 261 | INSERT INTO streetname VALUES('brachnell view'); |
||
| 262 | INSERT INTO streetname VALUES('bradford lake'); |
||
| 263 | INSERT INTO streetname VALUES('bradwell'); |
||
| 264 | INSERT INTO streetname VALUES('brady'); |
||
| 265 | INSERT INTO streetname VALUES('braids bend'); |
||
| 266 | INSERT INTO streetname VALUES('bralers'); |
||
| 267 | INSERT INTO streetname VALUES('brandie glen'); |
||
| 268 | INSERT INTO streetname VALUES('brandy ridge'); |
||
| 269 | INSERT INTO streetname VALUES('brandybuck'); |
||
| 270 | INSERT INTO streetname VALUES('branthurst'); |
||
| 271 | INSERT INTO streetname VALUES('brassy creek'); |
||
| 272 | INSERT INTO streetname VALUES('brathay'); |
||
| 273 | INSERT INTO streetname VALUES('brawer farm'); |
||
| 274 | INSERT INTO streetname VALUES('breezy morn'); |
||
| 275 | INSERT INTO streetname VALUES('brenda'); |
||
| 276 | INSERT INTO streetname VALUES('brenly'); |
||
| 277 | INSERT INTO streetname VALUES('brenock'); |
||
| 278 | INSERT INTO streetname VALUES('brianwood'); |
||
| 279 | INSERT INTO streetname VALUES('briar rose'); |
||
| 280 | INSERT INTO streetname VALUES('briarcrest'); |
||
| 281 | INSERT INTO streetname VALUES('briarthorne'); |
||
| 282 | INSERT INTO streetname VALUES('brick dust'); |
||
| 283 | INSERT INTO streetname VALUES('bridgepath'); |
||
| 284 | INSERT INTO streetname VALUES('bridle ridge'); |
||
| 285 | INSERT INTO streetname VALUES('briggs'); |
||
| 286 | INSERT INTO streetname VALUES('brightleaf'); |
||
| 287 | INSERT INTO streetname VALUES('brigstock'); |
||
| 288 | INSERT INTO streetname VALUES('broad ridge'); |
||
| 289 | INSERT INTO streetname VALUES('brock'); |
||
| 290 | INSERT INTO streetname VALUES('brockhampton'); |
||
| 291 | INSERT INTO streetname VALUES('broken pine'); |
||
| 292 | INSERT INTO streetname VALUES('brompton'); |
||
| 293 | INSERT INTO streetname VALUES('brook falls'); |
||
| 294 | INSERT INTO streetname VALUES('brookings'); |
||
| 295 | INSERT INTO streetname VALUES('browne'); |
||
| 296 | INSERT INTO streetname VALUES('brownes creek'); |
||
| 297 | INSERT INTO streetname VALUES('brownes ferry'); |
||
| 298 | INSERT INTO streetname VALUES('brownestone view'); |
||
| 299 | INSERT INTO streetname VALUES('brumit'); |
||
| 300 | INSERT INTO streetname VALUES('bryn athyn'); |
||
| 301 | INSERT INTO streetname VALUES('buck'); |
||
| 302 | INSERT INTO streetname VALUES('bucklebury'); |
||
| 303 | INSERT INTO streetname VALUES('buckminister'); |
||
| 304 | INSERT INTO streetname VALUES('buckspring'); |
||
| 305 | INSERT INTO streetname VALUES('burch'); |
||
| 306 | INSERT INTO streetname VALUES('burch shire'); |
||
| 307 | INSERT INTO streetname VALUES('burkston'); |
||
| 308 | INSERT INTO streetname VALUES('burmith'); |
||
| 309 | INSERT INTO streetname VALUES('burnaby'); |
||
| 310 | INSERT INTO streetname VALUES('butterfly'); |
||
| 311 | INSERT INTO streetname VALUES('cabin creek'); |
||
| 312 | INSERT INTO streetname VALUES('cairns mill'); |
||
| 313 | INSERT INTO streetname VALUES('callender'); |
||
| 314 | INSERT INTO streetname VALUES('cambellton'); |
||
| 315 | INSERT INTO streetname VALUES('cambridge bay'); |
||
| 316 | INSERT INTO streetname VALUES('canary'); |
||
| 317 | INSERT INTO streetname VALUES('canbury'); |
||
| 318 | INSERT INTO streetname VALUES('candle leaf'); |
||
| 319 | INSERT INTO streetname VALUES('canipe'); |
||
| 320 | INSERT INTO streetname VALUES('canipe farm'); |
||
| 321 | INSERT INTO streetname VALUES('cannon'); |
||
| 322 | INSERT INTO streetname VALUES('canopy'); |
||
| 323 | INSERT INTO streetname VALUES('canso'); |
||
| 324 | INSERT INTO streetname VALUES('canterbrook'); |
||
| 325 | INSERT INTO streetname VALUES('cardinal glen'); |
||
| 326 | INSERT INTO streetname VALUES('cardinal point'); |
||
| 327 | INSERT INTO streetname VALUES('cardinals nest'); |
||
| 328 | INSERT INTO streetname VALUES('carlota'); |
||
| 329 | INSERT INTO streetname VALUES('carmathen'); |
||
| 330 | INSERT INTO streetname VALUES('carver'); |
||
| 331 | INSERT INTO streetname VALUES('carver pond'); |
||
| 332 | INSERT INTO streetname VALUES('casa loma'); |
||
| 333 | INSERT INTO streetname VALUES('caselton'); |
||
| 334 | INSERT INTO streetname VALUES('castello'); |
||
| 335 | INSERT INTO streetname VALUES('castle ridge'); |
||
| 336 | INSERT INTO streetname VALUES('castleglen'); |
||
| 337 | INSERT INTO streetname VALUES('castlemaine'); |
||
| 338 | INSERT INTO streetname VALUES('cavett'); |
||
| 339 | INSERT INTO streetname VALUES('caymus'); |
||
| 340 | INSERT INTO streetname VALUES('cedardale ridge'); |
||
| 341 | INSERT INTO streetname VALUES('cedarhurst'); |
||
| 342 | INSERT INTO streetname VALUES('cemkey way'); |
||
| 343 | INSERT INTO streetname VALUES('cerise'); |
||
| 344 | INSERT INTO streetname VALUES('chaceview'); |
||
| 345 | INSERT INTO streetname VALUES('chadsworth'); |
||
| 346 | INSERT INTO streetname VALUES('chadwell'); |
||
| 347 | INSERT INTO streetname VALUES('champions crest'); |
||
| 348 | INSERT INTO streetname VALUES('chandler haven'); |
||
| 349 | INSERT INTO streetname VALUES('chapel crossing'); |
||
| 350 | INSERT INTO streetname VALUES('chapel ridge'); |
||
| 351 | INSERT INTO streetname VALUES('charles crawford'); |
||
| 352 | INSERT INTO streetname VALUES('charminster'); |
||
| 353 | INSERT INTO streetname VALUES('chasewind'); |
||
| 354 | INSERT INTO streetname VALUES('chavel'); |
||
| 355 | INSERT INTO streetname VALUES('chelsea jade'); |
||
| 356 | INSERT INTO streetname VALUES('chestnut knoll'); |
||
| 357 | INSERT INTO streetname VALUES('cheviot'); |
||
| 358 | INSERT INTO streetname VALUES('chickadee'); |
||
| 359 | INSERT INTO streetname VALUES('chidley'); |
||
| 360 | INSERT INTO streetname VALUES('chimney ridge'); |
||
| 361 | INSERT INTO streetname VALUES('chimney springs'); |
||
| 362 | INSERT INTO streetname VALUES('chinaberry'); |
||
| 363 | INSERT INTO streetname VALUES('chinemist'); |
||
| 364 | INSERT INTO streetname VALUES('chinquapin'); |
||
| 365 | INSERT INTO streetname VALUES('chiswell'); |
||
| 366 | INSERT INTO streetname VALUES('christenbury'); |
||
| 367 | INSERT INTO streetname VALUES('christenbury hills'); |
||
| 368 | INSERT INTO streetname VALUES('churchill'); |
||
| 369 | INSERT INTO streetname VALUES('cindy'); |
||
| 370 | INSERT INTO streetname VALUES('cinnamon teal'); |
||
| 371 | INSERT INTO streetname VALUES('citadel'); |
||
| 372 | INSERT INTO streetname VALUES('clare olivia'); |
||
| 373 | INSERT INTO streetname VALUES('clarke creek'); |
||
| 374 | INSERT INTO streetname VALUES('clarke ridge'); |
||
| 375 | INSERT INTO streetname VALUES('clear day'); |
||
| 376 | INSERT INTO streetname VALUES('clear stream'); |
||
| 377 | INSERT INTO streetname VALUES('cleve brown'); |
||
| 378 | INSERT INTO streetname VALUES('cliff cameron'); |
||
| 379 | INSERT INTO streetname VALUES('cliffvale'); |
||
| 380 | INSERT INTO streetname VALUES('cloverside'); |
||
| 381 | INSERT INTO streetname VALUES('clymer'); |
||
| 382 | INSERT INTO streetname VALUES('coatbridge'); |
||
| 383 | INSERT INTO streetname VALUES('cobble glen'); |
||
| 384 | INSERT INTO streetname VALUES('cochran farm'); |
||
| 385 | INSERT INTO streetname VALUES('cochrane'); |
||
| 386 | INSERT INTO streetname VALUES('coleridge'); |
||
| 387 | INSERT INTO streetname VALUES('coleshire'); |
||
| 388 | INSERT INTO streetname VALUES('collins'); |
||
| 389 | INSERT INTO streetname VALUES('colvard'); |
||
| 390 | INSERT INTO streetname VALUES('colvard park'); |
||
| 391 | INSERT INTO streetname VALUES('condor'); |
||
| 392 | INSERT INTO streetname VALUES('conner ridge'); |
||
| 393 | INSERT INTO streetname VALUES('connery'); |
||
| 394 | INSERT INTO streetname VALUES('cooper run'); |
||
| 395 | INSERT INTO streetname VALUES('coopers ridge'); |
||
| 396 | INSERT INTO streetname VALUES('copper hill'); |
||
| 397 | INSERT INTO streetname VALUES('coppermine'); |
||
| 398 | INSERT INTO streetname VALUES('cornelia'); |
||
| 399 | INSERT INTO streetname VALUES('corner'); |
||
| 400 | INSERT INTO streetname VALUES('cornerstone'); |
||
| 401 | INSERT INTO streetname VALUES('cottage oaks'); |
||
| 402 | INSERT INTO streetname VALUES('cougar'); |
||
| 403 | INSERT INTO streetname VALUES('coves end'); |
||
| 404 | INSERT INTO streetname VALUES('cragland'); |
||
| 405 | INSERT INTO streetname VALUES('crail'); |
||
| 406 | INSERT INTO streetname VALUES('cranberry nook'); |
||
| 407 | INSERT INTO streetname VALUES('crawford brook'); |
||
| 408 | INSERT INTO streetname VALUES('crayton'); |
||
| 409 | INSERT INTO streetname VALUES('creek breeze'); |
||
| 410 | INSERT INTO streetname VALUES('crescent ridge'); |
||
| 411 | INSERT INTO streetname VALUES('crescent view'); |
||
| 412 | INSERT INTO streetname VALUES('cresta'); |
||
| 413 | INSERT INTO streetname VALUES('crestfield'); |
||
| 414 | INSERT INTO streetname VALUES('crestland'); |
||
| 415 | INSERT INTO streetname VALUES('crestwick'); |
||
| 416 | INSERT INTO streetname VALUES('crisfield'); |
||
| 417 | INSERT INTO streetname VALUES('crisp wood'); |
||
| 418 | INSERT INTO streetname VALUES('croft haven'); |
||
| 419 | INSERT INTO streetname VALUES('crofton springs'); |
||
| 420 | INSERT INTO streetname VALUES('cross'); |
||
| 421 | INSERT INTO streetname VALUES('crosspoint center'); |
||
| 422 | INSERT INTO streetname VALUES('crownvista'); |
||
| 423 | INSERT INTO streetname VALUES('crystal arms'); |
||
| 424 | INSERT INTO streetname VALUES('crystal crest'); |
||
| 425 | INSERT INTO streetname VALUES('crystal leaf'); |
||
| 426 | INSERT INTO streetname VALUES('cunningham park'); |
||
| 427 | INSERT INTO streetname VALUES('cypress pond'); |
||
| 428 | INSERT INTO streetname VALUES('daffodil'); |
||
| 429 | INSERT INTO streetname VALUES('daisyfield'); |
||
| 430 | INSERT INTO streetname VALUES('dalecrest'); |
||
| 431 | INSERT INTO streetname VALUES('dannelly park'); |
||
| 432 | INSERT INTO streetname VALUES('daphne'); |
||
| 433 | INSERT INTO streetname VALUES('daria'); |
||
| 434 | INSERT INTO streetname VALUES('dartmouth'); |
||
| 435 | INSERT INTO streetname VALUES('datha'); |
||
| 436 | INSERT INTO streetname VALUES('david cox'); |
||
| 437 | INSERT INTO streetname VALUES('davis'); |
||
| 438 | INSERT INTO streetname VALUES('davis crossing'); |
||
| 439 | INSERT INTO streetname VALUES('davis lake'); |
||
| 440 | INSERT INTO streetname VALUES('davis ridge'); |
||
| 441 | INSERT INTO streetname VALUES('dawnmist'); |
||
| 442 | INSERT INTO streetname VALUES('daybreak'); |
||
| 443 | INSERT INTO streetname VALUES('dearmon'); |
||
| 444 | INSERT INTO streetname VALUES('dearview'); |
||
| 445 | INSERT INTO streetname VALUES('deaton hill'); |
||
| 446 | INSERT INTO streetname VALUES('deer cross'); |
||
| 447 | INSERT INTO streetname VALUES('deerton'); |
||
| 448 | INSERT INTO streetname VALUES('degrasse'); |
||
| 449 | INSERT INTO streetname VALUES('delamere'); |
||
| 450 | INSERT INTO streetname VALUES('dellfield'); |
||
| 451 | INSERT INTO streetname VALUES('dellinger'); |
||
| 452 | INSERT INTO streetname VALUES('demington'); |
||
| 453 | INSERT INTO streetname VALUES('denmeade'); |
||
| 454 | INSERT INTO streetname VALUES('derita'); |
||
| 455 | INSERT INTO streetname VALUES('derita woods'); |
||
| 456 | INSERT INTO streetname VALUES('deruyter'); |
||
| 457 | INSERT INTO streetname VALUES('dervish'); |
||
| 458 | INSERT INTO streetname VALUES('devas'); |
||
| 459 | INSERT INTO streetname VALUES('devon croft'); |
||
| 460 | INSERT INTO streetname VALUES('devonbridge'); |
||
| 461 | INSERT INTO streetname VALUES('devongate'); |
||
| 462 | INSERT INTO streetname VALUES('devonhill'); |
||
| 463 | INSERT INTO streetname VALUES('dewmorn'); |
||
| 464 | INSERT INTO streetname VALUES('distribution center'); |
||
| 465 | INSERT INTO streetname VALUES('dominion crest'); |
||
| 466 | INSERT INTO streetname VALUES('dominion green'); |
||
| 467 | INSERT INTO streetname VALUES('dominion village'); |
||
| 468 | INSERT INTO streetname VALUES('dorshire'); |
||
| 469 | INSERT INTO streetname VALUES('double creek crossing'); |
||
| 470 | INSERT INTO streetname VALUES('dow'); |
||
| 471 | INSERT INTO streetname VALUES('downfield wood'); |
||
| 472 | INSERT INTO streetname VALUES('downing creek'); |
||
| 473 | INSERT INTO streetname VALUES('driscol'); |
||
| 474 | INSERT INTO streetname VALUES('driwood'); |
||
| 475 | INSERT INTO streetname VALUES('dry brook'); |
||
| 476 | INSERT INTO streetname VALUES('dumont'); |
||
| 477 | INSERT INTO streetname VALUES('dunblane'); |
||
| 478 | INSERT INTO streetname VALUES('dunfield'); |
||
| 479 | INSERT INTO streetname VALUES('dunoon'); |
||
| 480 | INSERT INTO streetname VALUES('dunslow'); |
||
| 481 | INSERT INTO streetname VALUES('dunstaff'); |
||
| 482 | INSERT INTO streetname VALUES('durham'); |
||
| 483 | INSERT INTO streetname VALUES('durston'); |
||
| 484 | INSERT INTO streetname VALUES('dusty cedar'); |
||
| 485 | INSERT INTO streetname VALUES('dusty trail'); |
||
| 486 | INSERT INTO streetname VALUES('dutchess'); |
||
| 487 | INSERT INTO streetname VALUES('duxford'); |
||
| 488 | INSERT INTO streetname VALUES('eagle creek'); |
||
| 489 | INSERT INTO streetname VALUES('eagles field'); |
||
| 490 | INSERT INTO streetname VALUES('eargle'); |
||
| 491 | INSERT INTO streetname VALUES('earlswood'); |
||
| 492 | INSERT INTO streetname VALUES('early mist'); |
||
| 493 | INSERT INTO streetname VALUES('earthenware'); |
||
| 494 | INSERT INTO streetname VALUES('eastfield park'); |
||
| 495 | INSERT INTO streetname VALUES('eastfield village'); |
||
| 496 | INSERT INTO streetname VALUES('easy'); |
||
| 497 | INSERT INTO streetname VALUES('eben'); |
||
| 498 | INSERT INTO streetname VALUES('edgepine'); |
||
| 499 | INSERT INTO streetname VALUES('edgewier'); |
||
| 500 | INSERT INTO streetname VALUES('edinburgh'); |
||
| 501 | INSERT INTO streetname VALUES('edinmeadow'); |
||
| 502 | INSERT INTO streetname VALUES('edmonton'); |
||
| 503 | INSERT INTO streetname VALUES('edwin jones'); |
||
| 504 | INSERT INTO streetname VALUES('elberon'); |
||
| 505 | INSERT INTO streetname VALUES('elderslie'); |
||
| 506 | INSERT INTO streetname VALUES('elementary view'); |
||
| 507 | INSERT INTO streetname VALUES('elendil'); |
||
| 508 | INSERT INTO streetname VALUES('elizabeth'); |
||
| 509 | INSERT INTO streetname VALUES('elm cove'); |
||
| 510 | INSERT INTO streetname VALUES('elrond'); |
||
| 511 | INSERT INTO streetname VALUES('elsenham'); |
||
| 512 | INSERT INTO streetname VALUES('elven'); |
||
| 513 | INSERT INTO streetname VALUES('emma lynn'); |
||
| 514 | INSERT INTO streetname VALUES('english setter'); |
||
| 515 | INSERT INTO streetname VALUES('enoch'); |
||
| 516 | INSERT INTO streetname VALUES('equipment'); |
||
| 517 | INSERT INTO streetname VALUES('ernest russell'); |
||
| 518 | INSERT INTO streetname VALUES('ernie'); |
||
| 519 | INSERT INTO streetname VALUES('esmeralda'); |
||
| 520 | INSERT INTO streetname VALUES('evergreen hollow'); |
||
| 521 | INSERT INTO streetname VALUES('eversfield'); |
||
| 522 | INSERT INTO streetname VALUES('ewen'); |
||
| 523 | INSERT INTO streetname VALUES('ewert cut'); |
||
| 524 | INSERT INTO streetname VALUES('exbury'); |
||
| 525 | INSERT INTO streetname VALUES('fair grounds park'); |
||
| 526 | INSERT INTO streetname VALUES('fairbourne'); |
||
| 527 | INSERT INTO streetname VALUES('fairchase'); |
||
| 528 | INSERT INTO streetname VALUES('faircreek'); |
||
| 529 | INSERT INTO streetname VALUES('fairglen'); |
||
| 530 | INSERT INTO streetname VALUES('fairlea'); |
||
| 531 | INSERT INTO streetname VALUES('fairmead'); |
||
| 532 | INSERT INTO streetname VALUES('fairmeadows'); |
||
| 533 | INSERT INTO streetname VALUES('fairstone'); |
||
| 534 | INSERT INTO streetname VALUES('fairvista'); |
||
| 535 | INSERT INTO streetname VALUES('fairway point'); |
||
| 536 | INSERT INTO streetname VALUES('falconcrest'); |
||
| 537 | INSERT INTO streetname VALUES('falls ridge'); |
||
| 538 | INSERT INTO streetname VALUES('falmouth'); |
||
| 539 | INSERT INTO streetname VALUES('far west'); |
||
| 540 | INSERT INTO streetname VALUES('farlow'); |
||
| 541 | INSERT INTO streetname VALUES('farris wheel'); |
||
| 542 | INSERT INTO streetname VALUES('fawndale'); |
||
| 543 | INSERT INTO streetname VALUES('feather bend'); |
||
| 544 | INSERT INTO streetname VALUES('fernledge'); |
||
| 545 | INSERT INTO streetname VALUES('fernmoss'); |
||
| 546 | INSERT INTO streetname VALUES('ferrell commons'); |
||
| 547 | INSERT INTO streetname VALUES('fieldstone'); |
||
| 548 | INSERT INTO streetname VALUES('fillian'); |
||
| 549 | INSERT INTO streetname VALUES('fincher'); |
||
| 550 | INSERT INTO streetname VALUES('foggy meadow'); |
||
| 551 | INSERT INTO streetname VALUES('fordyce'); |
||
| 552 | INSERT INTO streetname VALUES('forest grove'); |
||
| 553 | INSERT INTO streetname VALUES('forest path'); |
||
| 554 | INSERT INTO streetname VALUES('forestridge commons'); |
||
| 555 | INSERT INTO streetname VALUES('forestrock'); |
||
| 556 | INSERT INTO streetname VALUES('fortunes ridge'); |
||
| 557 | INSERT INTO streetname VALUES('founders club'); |
||
| 558 | INSERT INTO streetname VALUES('fountaingrass'); |
||
| 559 | INSERT INTO streetname VALUES('fox chase'); |
||
| 560 | INSERT INTO streetname VALUES('fox glen'); |
||
| 561 | INSERT INTO streetname VALUES('fox hill'); |
||
| 562 | INSERT INTO streetname VALUES('fox point'); |
||
| 563 | INSERT INTO streetname VALUES('fox trot'); |
||
| 564 | INSERT INTO streetname VALUES('foxbriar'); |
||
| 565 | INSERT INTO streetname VALUES('frank little'); |
||
| 566 | INSERT INTO streetname VALUES('franzia'); |
||
| 567 | INSERT INTO streetname VALUES('french woods'); |
||
| 568 | INSERT INTO streetname VALUES('frostmoor'); |
||
| 569 | INSERT INTO streetname VALUES('frye'); |
||
| 570 | INSERT INTO streetname VALUES('furlong'); |
||
| 571 | INSERT INTO streetname VALUES('galena view'); |
||
| 572 | INSERT INTO streetname VALUES('gallery pointe'); |
||
| 573 | INSERT INTO streetname VALUES('gammon'); |
||
| 574 | INSERT INTO streetname VALUES('garden grove'); |
||
| 575 | INSERT INTO streetname VALUES('gardendale'); |
||
| 576 | INSERT INTO streetname VALUES('garganey'); |
||
| 577 | INSERT INTO streetname VALUES('garnet field'); |
||
| 578 | INSERT INTO streetname VALUES('garrison'); |
||
| 579 | INSERT INTO streetname VALUES('garvin'); |
||
| 580 | INSERT INTO streetname VALUES('garvis'); |
||
| 581 | INSERT INTO streetname VALUES('gaskill'); |
||
| 582 | INSERT INTO streetname VALUES('gemstone'); |
||
| 583 | INSERT INTO streetname VALUES('gibbon'); |
||
| 584 | INSERT INTO streetname VALUES('gibbon terrace'); |
||
| 585 | INSERT INTO streetname VALUES('gibbons link'); |
||
| 586 | INSERT INTO streetname VALUES('gillman'); |
||
| 587 | INSERT INTO streetname VALUES('gladwood'); |
||
| 588 | INSERT INTO streetname VALUES('gladwyne'); |
||
| 589 | INSERT INTO streetname VALUES('glamorgan'); |
||
| 590 | INSERT INTO streetname VALUES('glaze'); |
||
| 591 | INSERT INTO streetname VALUES('glen brook'); |
||
| 592 | INSERT INTO streetname VALUES('glen cove'); |
||
| 593 | INSERT INTO streetname VALUES('glen hope'); |
||
| 594 | INSERT INTO streetname VALUES('glen manor'); |
||
| 595 | INSERT INTO streetname VALUES('glen olden'); |
||
| 596 | INSERT INTO streetname VALUES('glencairn'); |
||
| 597 | INSERT INTO streetname VALUES('glendock'); |
||
| 598 | INSERT INTO streetname VALUES('glenolden'); |
||
| 599 | INSERT INTO streetname VALUES('glenover'); |
||
| 600 | INSERT INTO streetname VALUES('glenshire'); |
||
| 601 | INSERT INTO streetname VALUES('glenstone'); |
||
| 602 | INSERT INTO streetname VALUES('gold dust'); |
||
| 603 | INSERT INTO streetname VALUES('golden pond'); |
||
| 604 | INSERT INTO streetname VALUES('goldenblush'); |
||
| 605 | INSERT INTO streetname VALUES('goldenfield'); |
||
| 606 | INSERT INTO streetname VALUES('goose landing'); |
||
| 607 | INSERT INTO streetname VALUES('gorham gate'); |
||
| 608 | INSERT INTO streetname VALUES('grabill'); |
||
| 609 | INSERT INTO streetname VALUES('graburns ford'); |
||
| 610 | INSERT INTO streetname VALUES('graham'); |
||
| 611 | INSERT INTO streetname VALUES('grahamson'); |
||
| 612 | INSERT INTO streetname VALUES('granard'); |
||
| 613 | INSERT INTO streetname VALUES('grand teton'); |
||
| 614 | INSERT INTO streetname VALUES('grande heights'); |
||
| 615 | INSERT INTO streetname VALUES('grandeur'); |
||
| 616 | INSERT INTO streetname VALUES('granite creek'); |
||
| 617 | INSERT INTO streetname VALUES('grasset'); |
||
| 618 | INSERT INTO streetname VALUES('graypark'); |
||
| 619 | INSERT INTO streetname VALUES('grays ridge'); |
||
| 620 | INSERT INTO streetname VALUES('great bear'); |
||
| 621 | INSERT INTO streetname VALUES('green clover'); |
||
| 622 | INSERT INTO streetname VALUES('green hedge'); |
||
| 623 | INSERT INTO streetname VALUES('green meadow'); |
||
| 624 | INSERT INTO streetname VALUES('green pasture'); |
||
| 625 | INSERT INTO streetname VALUES('greene'); |
||
| 626 | INSERT INTO streetname VALUES('greenloch'); |
||
| 627 | INSERT INTO streetname VALUES('greenock ridge'); |
||
| 628 | INSERT INTO streetname VALUES('greenware'); |
||
| 629 | INSERT INTO streetname VALUES('greenway village'); |
||
| 630 | INSERT INTO streetname VALUES('grenelefe village'); |
||
| 631 | INSERT INTO streetname VALUES('grey dogwood'); |
||
| 632 | INSERT INTO streetname VALUES('greyhound'); |
||
| 633 | INSERT INTO streetname VALUES('greylock ridge'); |
||
| 634 | INSERT INTO streetname VALUES('grosbeak'); |
||
| 635 | INSERT INTO streetname VALUES('grove'); |
||
| 636 | INSERT INTO streetname VALUES('groveton'); |
||
| 637 | INSERT INTO streetname VALUES('groveview'); |
||
| 638 | INSERT INTO streetname VALUES('hackberry creek'); |
||
| 639 | INSERT INTO streetname VALUES('hackberry grove'); |
||
| 640 | INSERT INTO streetname VALUES('hackett'); |
||
| 641 | INSERT INTO streetname VALUES('haddington'); |
||
| 642 | INSERT INTO streetname VALUES('hagler'); |
||
| 643 | INSERT INTO streetname VALUES('halcott'); |
||
| 644 | INSERT INTO streetname VALUES('half dome'); |
||
| 645 | INSERT INTO streetname VALUES('hallam'); |
||
| 646 | INSERT INTO streetname VALUES('hamilton russell'); |
||
| 647 | INSERT INTO streetname VALUES('hampton place'); |
||
| 648 | INSERT INTO streetname VALUES('hankins'); |
||
| 649 | INSERT INTO streetname VALUES('harburn forest'); |
||
| 650 | INSERT INTO streetname VALUES('harringham'); |
||
| 651 | INSERT INTO streetname VALUES('harrington woods'); |
||
| 652 | INSERT INTO streetname VALUES('harris corners'); |
||
| 653 | INSERT INTO streetname VALUES('harris cove'); |
||
| 654 | INSERT INTO streetname VALUES('harris glen'); |
||
| 655 | INSERT INTO streetname VALUES('harris hill'); |
||
| 656 | INSERT INTO streetname VALUES('harris oak'); |
||
| 657 | INSERT INTO streetname VALUES('harris pointe'); |
||
| 658 | INSERT INTO streetname VALUES('harris pond'); |
||
| 659 | INSERT INTO streetname VALUES('harris ridge'); |
||
| 660 | INSERT INTO streetname VALUES('harris technology'); |
||
| 661 | INSERT INTO streetname VALUES('harris woods'); |
||
| 662 | INSERT INTO streetname VALUES('hartfield downs'); |
||
| 663 | INSERT INTO streetname VALUES('hattie little'); |
||
| 664 | INSERT INTO streetname VALUES('hatwynn'); |
||
| 665 | INSERT INTO streetname VALUES('hawkins'); |
||
| 666 | INSERT INTO streetname VALUES('hawksnest'); |
||
| 667 | INSERT INTO streetname VALUES('haybridge'); |
||
| 668 | INSERT INTO streetname VALUES('hayden'); |
||
| 669 | INSERT INTO streetname VALUES('hazelcroft'); |
||
| 670 | INSERT INTO streetname VALUES('hazlitt'); |
||
| 671 | INSERT INTO streetname VALUES('hazy valley'); |
||
| 672 | INSERT INTO streetname VALUES('hearst'); |
||
| 673 | INSERT INTO streetname VALUES('heathcrest'); |
||
| 674 | INSERT INTO streetname VALUES('heathcroft'); |
||
| 675 | INSERT INTO streetname VALUES('hedge maple'); |
||
| 676 | INSERT INTO streetname VALUES('hedgecrest'); |
||
| 677 | INSERT INTO streetname VALUES('hedingham'); |
||
| 678 | INSERT INTO streetname VALUES('heman'); |
||
| 679 | INSERT INTO streetname VALUES('henderson'); |
||
| 680 | INSERT INTO streetname VALUES('henderson oaks'); |
||
| 681 | INSERT INTO streetname VALUES('henderson valley'); |
||
| 682 | INSERT INTO streetname VALUES('hendry'); |
||
| 683 | INSERT INTO streetname VALUES('heritage hills'); |
||
| 684 | INSERT INTO streetname VALUES('heritage woods'); |
||
| 685 | INSERT INTO streetname VALUES('heron cove'); |
||
| 686 | INSERT INTO streetname VALUES('heron glen'); |
||
| 687 | INSERT INTO streetname VALUES('hewitt'); |
||
| 688 | INSERT INTO streetname VALUES('hey rock'); |
||
| 689 | INSERT INTO streetname VALUES('heysham'); |
||
| 690 | INSERT INTO streetname VALUES('hickory cove'); |
||
| 691 | INSERT INTO streetname VALUES('hidden meadow'); |
||
| 692 | INSERT INTO streetname VALUES('high glen'); |
||
| 693 | INSERT INTO streetname VALUES('high laurel'); |
||
| 694 | INSERT INTO streetname VALUES('high valley'); |
||
| 695 | INSERT INTO streetname VALUES('highcroft'); |
||
| 696 | INSERT INTO streetname VALUES('highland'); |
||
| 697 | INSERT INTO streetname VALUES('highland commons'); |
||
| 698 | INSERT INTO streetname VALUES('highland creek'); |
||
| 699 | INSERT INTO streetname VALUES('highland glen'); |
||
| 700 | INSERT INTO streetname VALUES('highland park'); |
||
| 701 | INSERT INTO streetname VALUES('highlander'); |
||
| 702 | INSERT INTO streetname VALUES('highstream'); |
||
| 703 | INSERT INTO streetname VALUES('hilltop'); |
||
| 704 | INSERT INTO streetname VALUES('hobbitshire'); |
||
| 705 | INSERT INTO streetname VALUES('hoffman'); |
||
| 706 | INSERT INTO streetname VALUES('hogans way'); |
||
| 707 | INSERT INTO streetname VALUES('holbert'); |
||
| 708 | INSERT INTO streetname VALUES('hollow ridge'); |
||
| 709 | INSERT INTO streetname VALUES('holly vista'); |
||
| 710 | INSERT INTO streetname VALUES('hollywood'); |
||
| 711 | INSERT INTO streetname VALUES('hoover'); |
||
| 712 | INSERT INTO streetname VALUES('hopkins'); |
||
| 713 | INSERT INTO streetname VALUES('horace mann'); |
||
| 714 | INSERT INTO streetname VALUES('hornbeam'); |
||
| 715 | INSERT INTO streetname VALUES('horse pasture'); |
||
| 716 | INSERT INTO streetname VALUES('hosta'); |
||
| 717 | INSERT INTO streetname VALUES('howard'); |
||
| 718 | INSERT INTO streetname VALUES('hubbard'); |
||
| 719 | INSERT INTO streetname VALUES('hubbard falls'); |
||
| 720 | INSERT INTO streetname VALUES('hubbard woods'); |
||
| 721 | INSERT INTO streetname VALUES('hucks'); |
||
| 722 | INSERT INTO streetname VALUES('hunters creek'); |
||
| 723 | INSERT INTO streetname VALUES('hunters pointe'); |
||
| 724 | INSERT INTO streetname VALUES('hunters spring'); |
||
| 725 | INSERT INTO streetname VALUES('hunters whip'); |
||
| 726 | INSERT INTO streetname VALUES('huntmeadow'); |
||
| 727 | INSERT INTO streetname VALUES('hutchison mcdonald'); |
||
| 728 | INSERT INTO streetname VALUES('ingleton'); |
||
| 729 | INSERT INTO streetname VALUES('insdale'); |
||
| 730 | INSERT INTO streetname VALUES('interstate 85 service'); |
||
| 731 | INSERT INTO streetname VALUES('iola'); |
||
| 732 | INSERT INTO streetname VALUES('iredell'); |
||
| 733 | INSERT INTO streetname VALUES('iron brigade'); |
||
| 734 | INSERT INTO streetname VALUES('irwin valley'); |
||
| 735 | INSERT INTO streetname VALUES('irwin wood'); |
||
| 736 | INSERT INTO streetname VALUES('ivy brook'); |
||
| 737 | INSERT INTO streetname VALUES('ivy ridge'); |
||
| 738 | INSERT INTO streetname VALUES('jack russell'); |
||
| 739 | INSERT INTO streetname VALUES('jackson'); |
||
| 740 | INSERT INTO streetname VALUES('jacob martin'); |
||
| 741 | INSERT INTO streetname VALUES('jamison'); |
||
| 742 | INSERT INTO streetname VALUES('jane'); |
||
| 743 | INSERT INTO streetname VALUES('jaspar crest'); |
||
| 744 | INSERT INTO streetname VALUES('jessica'); |
||
| 745 | INSERT INTO streetname VALUES('jimmy oehler'); |
||
| 746 | INSERT INTO streetname VALUES('jocelyn'); |
||
| 747 | INSERT INTO streetname VALUES('johnston mill'); |
||
| 748 | INSERT INTO streetname VALUES('johnston oehler'); |
||
| 749 | INSERT INTO streetname VALUES('judal'); |
||
| 750 | INSERT INTO streetname VALUES('junipeous'); |
||
| 751 | INSERT INTO streetname VALUES('juniper'); |
||
| 752 | INSERT INTO streetname VALUES('juniperus'); |
||
| 753 | INSERT INTO streetname VALUES('kalispell'); |
||
| 754 | INSERT INTO streetname VALUES('karylsturn'); |
||
| 755 | INSERT INTO streetname VALUES('katelyn'); |
||
| 756 | INSERT INTO streetname VALUES('kayron'); |
||
| 757 | INSERT INTO streetname VALUES('keaton'); |
||
| 758 | INSERT INTO streetname VALUES('keble'); |
||
| 759 | INSERT INTO streetname VALUES('keels'); |
||
| 760 | INSERT INTO streetname VALUES('keith'); |
||
| 761 | INSERT INTO streetname VALUES('keithwood'); |
||
| 762 | INSERT INTO streetname VALUES('kelden walker'); |
||
| 763 | INSERT INTO streetname VALUES('kelsey emma'); |
||
| 764 | INSERT INTO streetname VALUES('kendrick'); |
||
| 765 | INSERT INTO streetname VALUES('kenmont'); |
||
| 766 | INSERT INTO streetname VALUES('kennerly cove'); |
||
| 767 | INSERT INTO streetname VALUES('kenninghall'); |
||
| 768 | INSERT INTO streetname VALUES('kent village'); |
||
| 769 | INSERT INTO streetname VALUES('kestral ridge'); |
||
| 770 | INSERT INTO streetname VALUES('kestrel'); |
||
| 771 | INSERT INTO streetname VALUES('kilmartin'); |
||
| 772 | INSERT INTO streetname VALUES('kilty'); |
||
| 773 | INSERT INTO streetname VALUES('kinglet'); |
||
| 774 | INSERT INTO streetname VALUES('kingsland'); |
||
| 775 | INSERT INTO streetname VALUES('kingsnorth'); |
||
| 776 | INSERT INTO streetname VALUES('kinsmore'); |
||
| 777 | INSERT INTO streetname VALUES('kirkgard'); |
||
| 778 | INSERT INTO streetname VALUES('kirkmont'); |
||
| 779 | INSERT INTO streetname VALUES('knightsgate'); |
||
| 780 | INSERT INTO streetname VALUES('kobuk'); |
||
| 781 | INSERT INTO streetname VALUES('kotlik'); |
||
| 782 | INSERT INTO streetname VALUES('kotz'); |
||
| 783 | INSERT INTO streetname VALUES('kyndall walk'); |
||
| 784 | INSERT INTO streetname VALUES('laborde'); |
||
| 785 | INSERT INTO streetname VALUES('lady bank'); |
||
| 786 | INSERT INTO streetname VALUES('lagrande'); |
||
| 787 | INSERT INTO streetname VALUES('lake'); |
||
| 788 | INSERT INTO streetname VALUES('lakeridge commons'); |
||
| 789 | INSERT INTO streetname VALUES('lakeview'); |
||
| 790 | INSERT INTO streetname VALUES('lakewood edge'); |
||
| 791 | INSERT INTO streetname VALUES('lakota'); |
||
| 792 | INSERT INTO streetname VALUES('lambrook'); |
||
| 793 | INSERT INTO streetname VALUES('lampkin'); |
||
| 794 | INSERT INTO streetname VALUES('lampkin park'); |
||
| 795 | INSERT INTO streetname VALUES('langham'); |
||
| 796 | INSERT INTO streetname VALUES('lanzerac manor'); |
||
| 797 | INSERT INTO streetname VALUES('larkmead forest'); |
||
| 798 | INSERT INTO streetname VALUES('lattice'); |
||
| 799 | INSERT INTO streetname VALUES('laurel crest'); |
||
| 800 | INSERT INTO streetname VALUES('laurel ridge'); |
||
| 801 | INSERT INTO streetname VALUES('laurel run'); |
||
| 802 | INSERT INTO streetname VALUES('laurenfield'); |
||
| 803 | INSERT INTO streetname VALUES('laveta'); |
||
| 804 | INSERT INTO streetname VALUES('lazy day'); |
||
| 805 | INSERT INTO streetname VALUES('leawood run'); |
||
| 806 | INSERT INTO streetname VALUES('lee marie'); |
||
| 807 | INSERT INTO streetname VALUES('legacy lake'); |
||
| 808 | INSERT INTO streetname VALUES('legacy park'); |
||
| 809 | INSERT INTO streetname VALUES('legato'); |
||
| 810 | INSERT INTO streetname VALUES('legolas'); |
||
| 811 | INSERT INTO streetname VALUES('leigh glen'); |
||
| 812 | INSERT INTO streetname VALUES('lence'); |
||
| 813 | INSERT INTO streetname VALUES('lenox hill'); |
||
| 814 | INSERT INTO streetname VALUES('leonine'); |
||
| 815 | INSERT INTO streetname VALUES('leslie'); |
||
| 816 | INSERT INTO streetname VALUES('lester hill'); |
||
| 817 | INSERT INTO streetname VALUES('levisey'); |
||
| 818 | INSERT INTO streetname VALUES('liberty bell'); |
||
| 819 | INSERT INTO streetname VALUES('linden berry'); |
||
| 820 | INSERT INTO streetname VALUES('lisbon'); |
||
| 821 | INSERT INTO streetname VALUES('little stoney'); |
||
| 822 | INSERT INTO streetname VALUES('livengood'); |
||
| 823 | INSERT INTO streetname VALUES('lochway'); |
||
| 824 | INSERT INTO streetname VALUES('lockman'); |
||
| 825 | INSERT INTO streetname VALUES('loganville'); |
||
| 826 | INSERT INTO streetname VALUES('lone tree'); |
||
| 827 | INSERT INTO streetname VALUES('long creek park'); |
||
| 828 | INSERT INTO streetname VALUES('long forest'); |
||
| 829 | INSERT INTO streetname VALUES('looking glass'); |
||
| 830 | INSERT INTO streetname VALUES('lookout point'); |
||
| 831 | INSERT INTO streetname VALUES('lowen'); |
||
| 832 | INSERT INTO streetname VALUES('lusby'); |
||
| 833 | INSERT INTO streetname VALUES('lyleton'); |
||
| 834 | INSERT INTO streetname VALUES('lynn lee'); |
||
| 835 | INSERT INTO streetname VALUES('lynnewood glen'); |
||
| 836 | INSERT INTO streetname VALUES('machrie'); |
||
| 837 | INSERT INTO streetname VALUES('mackinac'); |
||
| 838 | INSERT INTO streetname VALUES('maddox'); |
||
| 839 | INSERT INTO streetname VALUES('madison park'); |
||
| 840 | INSERT INTO streetname VALUES('mallard'); |
||
| 841 | INSERT INTO streetname VALUES('mallard cove'); |
||
| 842 | INSERT INTO streetname VALUES('mallard forest'); |
||
| 843 | INSERT INTO streetname VALUES('mallard grove'); |
||
| 844 | INSERT INTO streetname VALUES('mallard hill'); |
||
| 845 | INSERT INTO streetname VALUES('mallard park'); |
||
| 846 | INSERT INTO streetname VALUES('mallard ridge'); |
||
| 847 | INSERT INTO streetname VALUES('mallard view'); |
||
| 848 | INSERT INTO streetname VALUES('manbey'); |
||
| 849 | INSERT INTO streetname VALUES('manning'); |
||
| 850 | INSERT INTO streetname VALUES('mantario'); |
||
| 851 | INSERT INTO streetname VALUES('maple'); |
||
| 852 | INSERT INTO streetname VALUES('maple cove'); |
||
| 853 | INSERT INTO streetname VALUES('maple park'); |
||
| 854 | INSERT INTO streetname VALUES('marathon hill'); |
||
| 855 | INSERT INTO streetname VALUES('marbury'); |
||
| 856 | INSERT INTO streetname VALUES('marett'); |
||
| 857 | INSERT INTO streetname VALUES('marigold'); |
||
| 858 | INSERT INTO streetname VALUES('marionwood'); |
||
| 859 | INSERT INTO streetname VALUES('marshbank'); |
||
| 860 | INSERT INTO streetname VALUES('mason'); |
||
| 861 | INSERT INTO streetname VALUES('mayapple'); |
||
| 862 | INSERT INTO streetname VALUES('maylandia'); |
||
| 863 | INSERT INTO streetname VALUES('mayspring'); |
||
| 864 | INSERT INTO streetname VALUES('mcadam'); |
||
| 865 | INSERT INTO streetname VALUES('mcchesney'); |
||
| 866 | INSERT INTO streetname VALUES('mccurdy'); |
||
| 867 | INSERT INTO streetname VALUES('mcgrath'); |
||
| 868 | INSERT INTO streetname VALUES('mckendree'); |
||
| 869 | INSERT INTO streetname VALUES('mclaughlin'); |
||
| 870 | INSERT INTO streetname VALUES('mctaggart'); |
||
| 871 | INSERT INTO streetname VALUES('meadow green'); |
||
| 872 | INSERT INTO streetname VALUES('meadow knoll'); |
||
| 873 | INSERT INTO streetname VALUES('meadow post'); |
||
| 874 | INSERT INTO streetname VALUES('meadowmont'); |
||
| 875 | INSERT INTO streetname VALUES('meadowmont view'); |
||
| 876 | INSERT INTO streetname VALUES('meadowview hills'); |
||
| 877 | INSERT INTO streetname VALUES('melshire'); |
||
| 878 | INSERT INTO streetname VALUES('melstrand'); |
||
| 879 | INSERT INTO streetname VALUES('mentone'); |
||
| 880 | INSERT INTO streetname VALUES('meridale crossing'); |
||
| 881 | INSERT INTO streetname VALUES('merion hills'); |
||
| 882 | INSERT INTO streetname VALUES('merlot'); |
||
| 883 | INSERT INTO streetname VALUES('mersham'); |
||
| 884 | INSERT INTO streetname VALUES('metromont'); |
||
| 885 | INSERT INTO streetname VALUES('metromont industrial'); |
||
| 886 | INSERT INTO streetname VALUES('michaw'); |
||
| 887 | INSERT INTO streetname VALUES('milhaven'); |
||
| 888 | INSERT INTO streetname VALUES('milhof'); |
||
| 889 | INSERT INTO streetname VALUES('millstream ridge'); |
||
| 890 | INSERT INTO streetname VALUES('mineral ridge'); |
||
| 891 | INSERT INTO streetname VALUES('mint thistle'); |
||
| 892 | INSERT INTO streetname VALUES('mintleaf'); |
||
| 893 | INSERT INTO streetname VALUES('mintvale'); |
||
| 894 | INSERT INTO streetname VALUES('misty'); |
||
| 895 | INSERT INTO streetname VALUES('misty arbor'); |
||
| 896 | INSERT INTO streetname VALUES('misty creek'); |
||
| 897 | INSERT INTO streetname VALUES('misty oaks'); |
||
| 898 | INSERT INTO streetname VALUES('misty wood'); |
||
| 899 | INSERT INTO streetname VALUES('mitzi deborah'); |
||
| 900 | INSERT INTO streetname VALUES('mobile'); |
||
| 901 | INSERT INTO streetname VALUES('molly elizabeth'); |
||
| 902 | INSERT INTO streetname VALUES('monmouth'); |
||
| 903 | INSERT INTO streetname VALUES('montrose'); |
||
| 904 | INSERT INTO streetname VALUES('moonlight'); |
||
| 905 | INSERT INTO streetname VALUES('moose'); |
||
| 906 | INSERT INTO streetname VALUES('morning dew'); |
||
| 907 | INSERT INTO streetname VALUES('morningsong'); |
||
| 908 | INSERT INTO streetname VALUES('morningview'); |
||
| 909 | INSERT INTO streetname VALUES('morsey'); |
||
| 910 | INSERT INTO streetname VALUES('moss glen'); |
||
| 911 | INSERT INTO streetname VALUES('mossy bank'); |
||
| 912 | INSERT INTO streetname VALUES('motor sport'); |
||
| 913 | INSERT INTO streetname VALUES('mountain laurel'); |
||
| 914 | INSERT INTO streetname VALUES('mourning dove'); |
||
| 915 | INSERT INTO streetname VALUES('mozart'); |
||
| 916 | INSERT INTO streetname VALUES('munsing'); |
||
| 917 | INSERT INTO streetname VALUES('murray'); |
||
| 918 | INSERT INTO streetname VALUES('nathan'); |
||
| 919 | INSERT INTO streetname VALUES('netherhall'); |
||
| 920 | INSERT INTO streetname VALUES('netherton'); |
||
| 921 | INSERT INTO streetname VALUES('neuhoff'); |
||
| 922 | INSERT INTO streetname VALUES('nevin'); |
||
| 923 | INSERT INTO streetname VALUES('nevin brook'); |
||
| 924 | INSERT INTO streetname VALUES('nevin glen'); |
||
| 925 | INSERT INTO streetname VALUES('nevin place'); |
||
| 926 | INSERT INTO streetname VALUES('new england'); |
||
| 927 | INSERT INTO streetname VALUES('new house'); |
||
| 928 | INSERT INTO streetname VALUES('newbary'); |
||
| 929 | INSERT INTO streetname VALUES('newchurch'); |
||
| 930 | INSERT INTO streetname VALUES('newfane'); |
||
| 931 | INSERT INTO streetname VALUES('newgard'); |
||
| 932 | INSERT INTO streetname VALUES('nicholas'); |
||
| 933 | INSERT INTO streetname VALUES('nicole'); |
||
| 934 | INSERT INTO streetname VALUES('nobility'); |
||
| 935 | INSERT INTO streetname VALUES('norcroft'); |
||
| 936 | INSERT INTO streetname VALUES('northridge'); |
||
| 937 | INSERT INTO streetname VALUES('northside'); |
||
| 938 | INSERT INTO streetname VALUES('northwoods business'); |
||
| 939 | INSERT INTO streetname VALUES('norway'); |
||
| 940 | INSERT INTO streetname VALUES('nottinghill'); |
||
| 941 | INSERT INTO streetname VALUES('numenore'); |
||
| 942 | INSERT INTO streetname VALUES('nyewood'); |
||
| 943 | INSERT INTO streetname VALUES('oak'); |
||
| 944 | INSERT INTO streetname VALUES('oak cove'); |
||
| 945 | INSERT INTO streetname VALUES('oak pasture'); |
||
| 946 | INSERT INTO streetname VALUES('oakburn'); |
||
| 947 | INSERT INTO streetname VALUES('oakwinds'); |
||
| 948 | INSERT INTO streetname VALUES('oakwood'); |
||
| 949 | INSERT INTO streetname VALUES('obrien'); |
||
| 950 | INSERT INTO streetname VALUES('ocala'); |
||
| 951 | INSERT INTO streetname VALUES('old bridge'); |
||
| 952 | INSERT INTO streetname VALUES('old fox'); |
||
| 953 | INSERT INTO streetname VALUES('old potters'); |
||
| 954 | INSERT INTO streetname VALUES('old statesville'); |
||
| 955 | INSERT INTO streetname VALUES('old steine'); |
||
| 956 | INSERT INTO streetname VALUES('old stoney creek'); |
||
| 957 | INSERT INTO streetname VALUES('old sugar creek'); |
||
| 958 | INSERT INTO streetname VALUES('old timber'); |
||
| 959 | INSERT INTO streetname VALUES('old wagon'); |
||
| 960 | INSERT INTO streetname VALUES('old willow'); |
||
| 961 | INSERT INTO streetname VALUES('oldenway'); |
||
| 962 | INSERT INTO streetname VALUES('oneida'); |
||
| 963 | INSERT INTO streetname VALUES('ontario'); |
||
| 964 | INSERT INTO streetname VALUES('oriole'); |
||
| 965 | INSERT INTO streetname VALUES('orofino'); |
||
| 966 | INSERT INTO streetname VALUES('orr'); |
||
| 967 | INSERT INTO streetname VALUES('osage'); |
||
| 968 | INSERT INTO streetname VALUES('osceola'); |
||
| 969 | INSERT INTO streetname VALUES('osprey knoll'); |
||
| 970 | INSERT INTO streetname VALUES('oxford hill'); |
||
| 971 | INSERT INTO streetname VALUES('painted fern'); |
||
| 972 | INSERT INTO streetname VALUES('painted pony'); |
||
| 973 | INSERT INTO streetname VALUES('paisley'); |
||
| 974 | INSERT INTO streetname VALUES('pale moss'); |
||
| 975 | INSERT INTO streetname VALUES('palladium'); |
||
| 976 | INSERT INTO streetname VALUES('palmutum'); |
||
| 977 | INSERT INTO streetname VALUES('palustris'); |
||
| 978 | INSERT INTO streetname VALUES('panglemont'); |
||
| 979 | INSERT INTO streetname VALUES('panther'); |
||
| 980 | INSERT INTO streetname VALUES('panthersville'); |
||
| 981 | INSERT INTO streetname VALUES('paper whites'); |
||
| 982 | INSERT INTO streetname VALUES('park'); |
||
| 983 | INSERT INTO streetname VALUES('parker green'); |
||
| 984 | INSERT INTO streetname VALUES('parkhouse'); |
||
| 985 | INSERT INTO streetname VALUES('passour ridge'); |
||
| 986 | INSERT INTO streetname VALUES('pasture view'); |
||
| 987 | INSERT INTO streetname VALUES('patricia ann'); |
||
| 988 | INSERT INTO streetname VALUES('patton'); |
||
| 989 | INSERT INTO streetname VALUES('patton ridge'); |
||
| 990 | INSERT INTO streetname VALUES('pawpaw'); |
||
| 991 | INSERT INTO streetname VALUES('peach'); |
||
| 992 | INSERT INTO streetname VALUES('peakwood'); |
||
| 993 | INSERT INTO streetname VALUES('pebble creek'); |
||
| 994 | INSERT INTO streetname VALUES('pecan cove'); |
||
| 995 | INSERT INTO streetname VALUES('pedigree'); |
||
| 996 | INSERT INTO streetname VALUES('pelorus'); |
||
| 997 | INSERT INTO streetname VALUES('penmore'); |
||
| 998 | INSERT INTO streetname VALUES('pensfold'); |
||
| 999 | INSERT INTO streetname VALUES('pepperstone'); |
||
| 1000 | INSERT INTO streetname VALUES('peregrine'); |
||
| 1001 | INSERT INTO streetname VALUES('periwinkle'); |
||
| 1002 | INSERT INTO streetname VALUES('perkins'); |
||
| 1003 | INSERT INTO streetname VALUES('pete brown'); |
||
| 1004 | INSERT INTO streetname VALUES('phillips'); |
||
| 1005 | INSERT INTO streetname VALUES('pickway'); |
||
| 1006 | INSERT INTO streetname VALUES('piercy woods'); |
||
| 1007 | INSERT INTO streetname VALUES('pierpoint'); |
||
| 1008 | INSERT INTO streetname VALUES('pine'); |
||
| 1009 | INSERT INTO streetname VALUES('pine branch'); |
||
| 1010 | INSERT INTO streetname VALUES('pine meadow'); |
||
| 1011 | INSERT INTO streetname VALUES('pineleaf'); |
||
| 1012 | INSERT INTO streetname VALUES('pinewood'); |
||
| 1013 | INSERT INTO streetname VALUES('pintail'); |
||
| 1014 | INSERT INTO streetname VALUES('pipestone'); |
||
| 1015 | INSERT INTO streetname VALUES('placer maple'); |
||
| 1016 | INSERT INTO streetname VALUES('plover'); |
||
| 1017 | INSERT INTO streetname VALUES('plum'); |
||
| 1018 | INSERT INTO streetname VALUES('po box'); |
||
| 1019 | INSERT INTO streetname VALUES('pochard'); |
||
| 1020 | INSERT INTO streetname VALUES('pointview'); |
||
| 1021 | INSERT INTO streetname VALUES('polk and white'); |
||
| 1022 | INSERT INTO streetname VALUES('pond valley'); |
||
| 1023 | INSERT INTO streetname VALUES('pondridge'); |
||
| 1024 | INSERT INTO streetname VALUES('pope farm'); |
||
| 1025 | INSERT INTO streetname VALUES('poplar grove'); |
||
| 1026 | INSERT INTO streetname VALUES('poplar springs'); |
||
| 1027 | INSERT INTO streetname VALUES('portola'); |
||
| 1028 | INSERT INTO streetname VALUES('potters glen'); |
||
| 1029 | INSERT INTO streetname VALUES('powatan'); |
||
| 1030 | INSERT INTO streetname VALUES('prairie valley'); |
||
| 1031 | INSERT INTO streetname VALUES('prescott'); |
||
| 1032 | INSERT INTO streetname VALUES('presmann'); |
||
| 1033 | INSERT INTO streetname VALUES('prestigious'); |
||
| 1034 | INSERT INTO streetname VALUES('princess'); |
||
| 1035 | INSERT INTO streetname VALUES('prosperity'); |
||
| 1036 | INSERT INTO streetname VALUES('prosperity church'); |
||
| 1037 | INSERT INTO streetname VALUES('prosperity commons'); |
||
| 1038 | INSERT INTO streetname VALUES('prosperity park'); |
||
| 1039 | INSERT INTO streetname VALUES('prosperity point'); |
||
| 1040 | INSERT INTO streetname VALUES('prosperity ridge'); |
||
| 1041 | INSERT INTO streetname VALUES('prosperity view'); |
||
| 1042 | INSERT INTO streetname VALUES('purple finch'); |
||
| 1043 | INSERT INTO streetname VALUES('quail'); |
||
| 1044 | INSERT INTO streetname VALUES('queensbury'); |
||
| 1045 | INSERT INTO streetname VALUES('quinn'); |
||
| 1046 | INSERT INTO streetname VALUES('racine'); |
||
| 1047 | INSERT INTO streetname VALUES('radbourne'); |
||
| 1048 | INSERT INTO streetname VALUES('raddington'); |
||
| 1049 | INSERT INTO streetname VALUES('raku'); |
||
| 1050 | INSERT INTO streetname VALUES('rancliffe'); |
||
| 1051 | INSERT INTO streetname VALUES('ravencrest'); |
||
| 1052 | INSERT INTO streetname VALUES('reames'); |
||
| 1053 | INSERT INTO streetname VALUES('rebecca run'); |
||
| 1054 | INSERT INTO streetname VALUES('red bluff'); |
||
| 1055 | INSERT INTO streetname VALUES('red clay'); |
||
| 1056 | INSERT INTO streetname VALUES('red clover'); |
||
| 1057 | INSERT INTO streetname VALUES('red rose'); |
||
| 1058 | INSERT INTO streetname VALUES('red shed'); |
||
| 1059 | INSERT INTO streetname VALUES('red tail'); |
||
| 1060 | INSERT INTO streetname VALUES('redbridge'); |
||
| 1061 | INSERT INTO streetname VALUES('redstart'); |
||
| 1062 | INSERT INTO streetname VALUES('redstone view'); |
||
| 1063 | INSERT INTO streetname VALUES('reedmont'); |
||
| 1064 | INSERT INTO streetname VALUES('reeves'); |
||
| 1065 | INSERT INTO streetname VALUES('regal'); |
||
| 1066 | INSERT INTO streetname VALUES('reinbeck'); |
||
| 1067 | INSERT INTO streetname VALUES('retriever'); |
||
| 1068 | INSERT INTO streetname VALUES('ribbonwalk'); |
||
| 1069 | INSERT INTO streetname VALUES('richardson park'); |
||
| 1070 | INSERT INTO streetname VALUES('richfield'); |
||
| 1071 | INSERT INTO streetname VALUES('riddings'); |
||
| 1072 | INSERT INTO streetname VALUES('ridge'); |
||
| 1073 | INSERT INTO streetname VALUES('ridge cliff'); |
||
| 1074 | INSERT INTO streetname VALUES('ridge path'); |
||
| 1075 | INSERT INTO streetname VALUES('ridge peak'); |
||
| 1076 | INSERT INTO streetname VALUES('ridgefield'); |
||
| 1077 | INSERT INTO streetname VALUES('ridgeline'); |
||
| 1078 | INSERT INTO streetname VALUES('ridgeview commons'); |
||
| 1079 | INSERT INTO streetname VALUES('riley'); |
||
| 1080 | INSERT INTO streetname VALUES('riley woods'); |
||
| 1081 | INSERT INTO streetname VALUES('rillet'); |
||
| 1082 | INSERT INTO streetname VALUES('rindle'); |
||
| 1083 | INSERT INTO streetname VALUES('rivendell'); |
||
| 1084 | INSERT INTO streetname VALUES('robin'); |
||
| 1085 | INSERT INTO streetname VALUES('robins nest'); |
||
| 1086 | INSERT INTO streetname VALUES('robur'); |
||
| 1087 | INSERT INTO streetname VALUES('robyns glen'); |
||
| 1088 | INSERT INTO streetname VALUES('rock stream'); |
||
| 1089 | INSERT INTO streetname VALUES('rockwell'); |
||
| 1090 | INSERT INTO streetname VALUES('rockwell church'); |
||
| 1091 | INSERT INTO streetname VALUES('rocky brook'); |
||
| 1092 | INSERT INTO streetname VALUES('rocky ford club'); |
||
| 1093 | INSERT INTO streetname VALUES('rotary'); |
||
| 1094 | INSERT INTO streetname VALUES('rouda'); |
||
| 1095 | INSERT INTO streetname VALUES('royal bluff'); |
||
| 1096 | INSERT INTO streetname VALUES('royal celadon'); |
||
| 1097 | INSERT INTO streetname VALUES('rubin lura'); |
||
| 1098 | INSERT INTO streetname VALUES('runswyck'); |
||
| 1099 | INSERT INTO streetname VALUES('ruth ferrell'); |
||
| 1100 | INSERT INTO streetname VALUES('ruth polk'); |
||
| 1101 | INSERT INTO streetname VALUES('ryan jay'); |
||
| 1102 | INSERT INTO streetname VALUES('sackett'); |
||
| 1103 | INSERT INTO streetname VALUES('saddle pace'); |
||
| 1104 | INSERT INTO streetname VALUES('saddle run'); |
||
| 1105 | INSERT INTO streetname VALUES('saddle trail'); |
||
| 1106 | INSERT INTO streetname VALUES('saguaro'); |
||
| 1107 | INSERT INTO streetname VALUES('saint audrey'); |
||
| 1108 | INSERT INTO streetname VALUES('saint bernard'); |
||
| 1109 | INSERT INTO streetname VALUES('saint frances'); |
||
| 1110 | INSERT INTO streetname VALUES('sam roper'); |
||
| 1111 | INSERT INTO streetname VALUES('samara'); |
||
| 1112 | INSERT INTO streetname VALUES('sanders creek'); |
||
| 1113 | INSERT INTO streetname VALUES('saquache'); |
||
| 1114 | INSERT INTO streetname VALUES('sarnia'); |
||
| 1115 | INSERT INTO streetname VALUES('savannah springs'); |
||
| 1116 | INSERT INTO streetname VALUES('sawgrass ridge'); |
||
| 1117 | INSERT INTO streetname VALUES('saxonbury'); |
||
| 1118 | INSERT INTO streetname VALUES('scotch moss'); |
||
| 1119 | INSERT INTO streetname VALUES('seasons'); |
||
| 1120 | INSERT INTO streetname VALUES('serenity'); |
||
| 1121 | INSERT INTO streetname VALUES('seths'); |
||
| 1122 | INSERT INTO streetname VALUES('shadow lawn'); |
||
| 1123 | INSERT INTO streetname VALUES('shadow oaks'); |
||
| 1124 | INSERT INTO streetname VALUES('shadow pine'); |
||
| 1125 | INSERT INTO streetname VALUES('shadyside'); |
||
| 1126 | INSERT INTO streetname VALUES('shallow oak'); |
||
| 1127 | INSERT INTO streetname VALUES('shelley'); |
||
| 1128 | INSERT INTO streetname VALUES('shining oak'); |
||
| 1129 | INSERT INTO streetname VALUES('ship'); |
||
| 1130 | INSERT INTO streetname VALUES('shore haven'); |
||
| 1131 | INSERT INTO streetname VALUES('shuman'); |
||
| 1132 | INSERT INTO streetname VALUES('sidney'); |
||
| 1133 | INSERT INTO streetname VALUES('silver birch'); |
||
| 1134 | INSERT INTO streetname VALUES('silvermere'); |
||
| 1135 | INSERT INTO streetname VALUES('simonton'); |
||
| 1136 | INSERT INTO streetname VALUES('singing hills'); |
||
| 1137 | INSERT INTO streetname VALUES('singing oak'); |
||
| 1138 | INSERT INTO streetname VALUES('sipes'); |
||
| 1139 | INSERT INTO streetname VALUES('six point'); |
||
| 1140 | INSERT INTO streetname VALUES('skycrest'); |
||
| 1141 | INSERT INTO streetname VALUES('skyline'); |
||
| 1142 | INSERT INTO streetname VALUES('small'); |
||
| 1143 | INSERT INTO streetname VALUES('smith corners'); |
||
| 1144 | INSERT INTO streetname VALUES('smithwood'); |
||
| 1145 | INSERT INTO streetname VALUES('snow hill'); |
||
| 1146 | INSERT INTO streetname VALUES('soapstone'); |
||
| 1147 | INSERT INTO streetname VALUES('sobeck'); |
||
| 1148 | INSERT INTO streetname VALUES('socata'); |
||
| 1149 | INSERT INTO streetname VALUES('solace'); |
||
| 1150 | INSERT INTO streetname VALUES('solway'); |
||
| 1151 | INSERT INTO streetname VALUES('song sparrow'); |
||
| 1152 | INSERT INTO streetname VALUES('sorrento'); |
||
| 1153 | INSERT INTO streetname VALUES('spector'); |
||
| 1154 | INSERT INTO streetname VALUES('spin drift'); |
||
| 1155 | INSERT INTO streetname VALUES('spring crest'); |
||
| 1156 | INSERT INTO streetname VALUES('spring lee'); |
||
| 1157 | INSERT INTO streetname VALUES('spring park'); |
||
| 1158 | INSERT INTO streetname VALUES('spring terrace'); |
||
| 1159 | INSERT INTO streetname VALUES('spring trace'); |
||
| 1160 | INSERT INTO streetname VALUES('springhaven'); |
||
| 1161 | INSERT INTO streetname VALUES('squirrel trail'); |
||
| 1162 | INSERT INTO streetname VALUES('stardust'); |
||
| 1163 | INSERT INTO streetname VALUES('stargaze'); |
||
| 1164 | INSERT INTO streetname VALUES('starita'); |
||
| 1165 | INSERT INTO streetname VALUES('starmount'); |
||
| 1166 | INSERT INTO streetname VALUES('statesville'); |
||
| 1167 | INSERT INTO streetname VALUES('steed'); |
||
| 1168 | INSERT INTO streetname VALUES('steelewood'); |
||
| 1169 | INSERT INTO streetname VALUES('steepleglen'); |
||
| 1170 | INSERT INTO streetname VALUES('stephens farm'); |
||
| 1171 | INSERT INTO streetname VALUES('stewarton'); |
||
| 1172 | INSERT INTO streetname VALUES('stone park'); |
||
| 1173 | INSERT INTO streetname VALUES('stonebrook'); |
||
| 1174 | INSERT INTO streetname VALUES('stonefield'); |
||
| 1175 | INSERT INTO streetname VALUES('stoneglen'); |
||
| 1176 | INSERT INTO streetname VALUES('stonemarsh'); |
||
| 1177 | INSERT INTO streetname VALUES('stoney garden'); |
||
| 1178 | INSERT INTO streetname VALUES('stoney run'); |
||
| 1179 | INSERT INTO streetname VALUES('stoney valley'); |
||
| 1180 | INSERT INTO streetname VALUES('stoneykirk'); |
||
| 1181 | INSERT INTO streetname VALUES('stream bank'); |
||
| 1182 | INSERT INTO streetname VALUES('stream ridge'); |
||
| 1183 | INSERT INTO streetname VALUES('suburban'); |
||
| 1184 | INSERT INTO streetname VALUES('suffield'); |
||
| 1185 | INSERT INTO streetname VALUES('sugar creek'); |
||
| 1186 | INSERT INTO streetname VALUES('sugarberry'); |
||
| 1187 | INSERT INTO streetname VALUES('sugarstone'); |
||
| 1188 | INSERT INTO streetname VALUES('summer creek'); |
||
| 1189 | INSERT INTO streetname VALUES('summer valley'); |
||
| 1190 | INSERT INTO streetname VALUES('summercrest'); |
||
| 1191 | INSERT INTO streetname VALUES('summercroft'); |
||
| 1192 | INSERT INTO streetname VALUES('summerford'); |
||
| 1193 | INSERT INTO streetname VALUES('summergold'); |
||
| 1194 | INSERT INTO streetname VALUES('sunbeam'); |
||
| 1195 | INSERT INTO streetname VALUES('sunbridge'); |
||
| 1196 | INSERT INTO streetname VALUES('sunpath'); |
||
| 1197 | INSERT INTO streetname VALUES('sunset'); |
||
| 1198 | INSERT INTO streetname VALUES('sunset ridge'); |
||
| 1199 | INSERT INTO streetname VALUES('sunstone'); |
||
| 1200 | INSERT INTO streetname VALUES('suntrace'); |
||
| 1201 | INSERT INTO streetname VALUES('sunwalk'); |
||
| 1202 | INSERT INTO streetname VALUES('sutters hill'); |
||
| 1203 | INSERT INTO streetname VALUES('suttonview'); |
||
| 1204 | INSERT INTO streetname VALUES('swallow tail'); |
||
| 1205 | INSERT INTO streetname VALUES('swanston'); |
||
| 1206 | INSERT INTO streetname VALUES('sweet grove'); |
||
| 1207 | INSERT INTO streetname VALUES('sweet rose'); |
||
| 1208 | INSERT INTO streetname VALUES('sweetbriar ridge'); |
||
| 1209 | INSERT INTO streetname VALUES('sweetfield'); |
||
| 1210 | INSERT INTO streetname VALUES('sydney overlook'); |
||
| 1211 | INSERT INTO streetname VALUES('sylvan'); |
||
| 1212 | INSERT INTO streetname VALUES('symphony woods'); |
||
| 1213 | INSERT INTO streetname VALUES('tallia'); |
||
| 1214 | INSERT INTO streetname VALUES('tallu'); |
||
| 1215 | INSERT INTO streetname VALUES('talwyn'); |
||
| 1216 | INSERT INTO streetname VALUES('tanager'); |
||
| 1217 | INSERT INTO streetname VALUES('tanager park'); |
||
| 1218 | INSERT INTO streetname VALUES('tangley'); |
||
| 1219 | INSERT INTO streetname VALUES('taranasay'); |
||
| 1220 | INSERT INTO streetname VALUES('tarby'); |
||
| 1221 | INSERT INTO streetname VALUES('tarland'); |
||
| 1222 | INSERT INTO streetname VALUES('tarpway'); |
||
| 1223 | INSERT INTO streetname VALUES('tauten'); |
||
| 1224 | INSERT INTO streetname VALUES('taymouth'); |
||
| 1225 | INSERT INTO streetname VALUES('ten trees'); |
||
| 1226 | INSERT INTO streetname VALUES('terrace view'); |
||
| 1227 | INSERT INTO streetname VALUES('terrier'); |
||
| 1228 | INSERT INTO streetname VALUES('tesh'); |
||
| 1229 | INSERT INTO streetname VALUES('teton'); |
||
| 1230 | INSERT INTO streetname VALUES('tewkesbury'); |
||
| 1231 | INSERT INTO streetname VALUES('thelema'); |
||
| 1232 | INSERT INTO streetname VALUES('thistle bloom'); |
||
| 1233 | INSERT INTO streetname VALUES('thistledown'); |
||
| 1234 | INSERT INTO streetname VALUES('thomas ridge'); |
||
| 1235 | INSERT INTO streetname VALUES('thornbrook'); |
||
| 1236 | INSERT INTO streetname VALUES('tifton grass'); |
||
| 1237 | INSERT INTO streetname VALUES('tigerton'); |
||
| 1238 | INSERT INTO streetname VALUES('tomsie efird'); |
||
| 1239 | INSERT INTO streetname VALUES('tor'); |
||
| 1240 | INSERT INTO streetname VALUES('torphin'); |
||
| 1241 | INSERT INTO streetname VALUES('torrence'); |
||
| 1242 | INSERT INTO streetname VALUES('towering pine'); |
||
| 1243 | INSERT INTO streetname VALUES('towhee'); |
||
| 1244 | INSERT INTO streetname VALUES('toxaway'); |
||
| 1245 | INSERT INTO streetname VALUES('tracy glenn'); |
||
| 1246 | INSERT INTO streetname VALUES('tradition view'); |
||
| 1247 | INSERT INTO streetname VALUES('trailer'); |
||
| 1248 | INSERT INTO streetname VALUES('transport'); |
||
| 1249 | INSERT INTO streetname VALUES('trehurst'); |
||
| 1250 | INSERT INTO streetname VALUES('trexler'); |
||
| 1251 | INSERT INTO streetname VALUES('trillium fields'); |
||
| 1252 | INSERT INTO streetname VALUES('trimbach'); |
||
| 1253 | INSERT INTO streetname VALUES('tucker'); |
||
| 1254 | INSERT INTO streetname VALUES('tullamore'); |
||
| 1255 | INSERT INTO streetname VALUES('tullock creek'); |
||
| 1256 | INSERT INTO streetname VALUES('tunston'); |
||
| 1257 | INSERT INTO streetname VALUES('tupelo'); |
||
| 1258 | INSERT INTO streetname VALUES('turnabout'); |
||
| 1259 | INSERT INTO streetname VALUES('turney'); |
||
| 1260 | INSERT INTO streetname VALUES('turtle cross'); |
||
| 1261 | INSERT INTO streetname VALUES('turtleback'); |
||
| 1262 | INSERT INTO streetname VALUES('twelvestone'); |
||
| 1263 | INSERT INTO streetname VALUES('twin'); |
||
| 1264 | INSERT INTO streetname VALUES('twin brook'); |
||
| 1265 | INSERT INTO streetname VALUES('twin lakes'); |
||
| 1266 | INSERT INTO streetname VALUES('twisted pine'); |
||
| 1267 | INSERT INTO streetname VALUES('tyler finley'); |
||
| 1268 | INSERT INTO streetname VALUES('university station'); |
||
| 1269 | INSERT INTO streetname VALUES('uphill'); |
||
| 1270 | INSERT INTO streetname VALUES('valeview'); |
||
| 1271 | INSERT INTO streetname VALUES('valhalla'); |
||
| 1272 | INSERT INTO streetname VALUES('van'); |
||
| 1273 | INSERT INTO streetname VALUES('vance davis'); |
||
| 1274 | INSERT INTO streetname VALUES('vanhoy'); |
||
| 1275 | INSERT INTO streetname VALUES('veckman'); |
||
| 1276 | INSERT INTO streetname VALUES('victoria'); |
||
| 1277 | INSERT INTO streetname VALUES('victory'); |
||
| 1278 | INSERT INTO streetname VALUES('village glen'); |
||
| 1279 | INSERT INTO streetname VALUES('vireo'); |
||
| 1280 | INSERT INTO streetname VALUES('viscount'); |
||
| 1281 | INSERT INTO streetname VALUES('voeltz'); |
||
| 1282 | INSERT INTO streetname VALUES('wade e morgan'); |
||
| 1283 | INSERT INTO streetname VALUES('wake'); |
||
| 1284 | INSERT INTO streetname VALUES('wales'); |
||
| 1285 | INSERT INTO streetname VALUES('wallace ridge'); |
||
| 1286 | INSERT INTO streetname VALUES('waltham'); |
||
| 1287 | INSERT INTO streetname VALUES('wanamassa'); |
||
| 1288 | INSERT INTO streetname VALUES('warbler wood'); |
||
| 1289 | INSERT INTO streetname VALUES('washington'); |
||
| 1290 | INSERT INTO streetname VALUES('water'); |
||
| 1291 | INSERT INTO streetname VALUES('waterelm'); |
||
| 1292 | INSERT INTO streetname VALUES('waterford hills'); |
||
| 1293 | INSERT INTO streetname VALUES('waterford valley'); |
||
| 1294 | INSERT INTO streetname VALUES('waterloo'); |
||
| 1295 | INSERT INTO streetname VALUES('waterton leas'); |
||
| 1296 | INSERT INTO streetname VALUES('waverly lynn'); |
||
| 1297 | INSERT INTO streetname VALUES('waverlyglen'); |
||
| 1298 | INSERT INTO streetname VALUES('wayside'); |
||
| 1299 | INSERT INTO streetname VALUES('westbury lake'); |
||
| 1300 | INSERT INTO streetname VALUES('westray'); |
||
| 1301 | INSERT INTO streetname VALUES('whistlers chase'); |
||
| 1302 | INSERT INTO streetname VALUES('whistley green'); |
||
| 1303 | INSERT INTO streetname VALUES('whistling oak'); |
||
| 1304 | INSERT INTO streetname VALUES('whitcomb'); |
||
| 1305 | INSERT INTO streetname VALUES('white aspen'); |
||
| 1306 | INSERT INTO streetname VALUES('white cascade'); |
||
| 1307 | INSERT INTO streetname VALUES('white mist'); |
||
| 1308 | INSERT INTO streetname VALUES('white rock'); |
||
| 1309 | INSERT INTO streetname VALUES('white stag'); |
||
| 1310 | INSERT INTO streetname VALUES('whitegate'); |
||
| 1311 | INSERT INTO streetname VALUES('whitehill'); |
||
| 1312 | INSERT INTO streetname VALUES('whitetail'); |
||
| 1313 | INSERT INTO streetname VALUES('whitewood'); |
||
| 1314 | INSERT INTO streetname VALUES('wilburn park'); |
||
| 1315 | INSERT INTO streetname VALUES('wild garden'); |
||
| 1316 | INSERT INTO streetname VALUES('wild rose'); |
||
| 1317 | INSERT INTO streetname VALUES('wilkins terrace'); |
||
| 1318 | INSERT INTO streetname VALUES('william ficklen'); |
||
| 1319 | INSERT INTO streetname VALUES('wiltshire ridge'); |
||
| 1320 | INSERT INTO streetname VALUES('windchase'); |
||
| 1321 | INSERT INTO streetname VALUES('winding jordan'); |
||
| 1322 | INSERT INTO streetname VALUES('windy meadow'); |
||
| 1323 | INSERT INTO streetname VALUES('winghaven'); |
||
| 1324 | INSERT INTO streetname VALUES('wingmont'); |
||
| 1325 | INSERT INTO streetname VALUES('winslow'); |
||
| 1326 | INSERT INTO streetname VALUES('winter pine'); |
||
| 1327 | INSERT INTO streetname VALUES('winter view'); |
||
| 1328 | INSERT INTO streetname VALUES('wolf creek'); |
||
| 1329 | INSERT INTO streetname VALUES('wondering oak'); |
||
| 1330 | INSERT INTO streetname VALUES('woodard'); |
||
| 1331 | INSERT INTO streetname VALUES('woodfire'); |
||
| 1332 | INSERT INTO streetname VALUES('woodland commons'); |
||
| 1333 | INSERT INTO streetname VALUES('woodland hills'); |
||
| 1334 | INSERT INTO streetname VALUES('woodnotch'); |
||
| 1335 | INSERT INTO streetname VALUES('woodstone'); |
||
| 1336 | INSERT INTO streetname VALUES('worsley'); |
||
| 1337 | INSERT INTO streetname VALUES('wren creek'); |
||
| 1338 | INSERT INTO streetname VALUES('wrens nest'); |
||
| 1339 | INSERT INTO streetname VALUES('wrexham'); |
||
| 1340 | INSERT INTO streetname VALUES('wt harris'); |
||
| 1341 | INSERT INTO streetname VALUES('wylie meadow'); |
||
| 1342 | INSERT INTO streetname VALUES('wynborough'); |
||
| 1343 | INSERT INTO streetname VALUES('wynbrook'); |
||
| 1344 | INSERT INTO streetname VALUES('wyndham hill'); |
||
| 1345 | INSERT INTO streetname VALUES('yandem'); |
||
| 1346 | INSERT INTO streetname VALUES('yellow rose'); |
||
| 1347 | INSERT INTO streetname VALUES('yellow spaniel'); |
||
| 1348 | INSERT INTO streetname VALUES('yorkford'); |
||
| 1349 | INSERT INTO streetname VALUES('ziegler'); |
||
| 1350 | INSERT INTO streetname VALUES('zion renaissance'); |
||
| 1351 | |||
| 1352 | SELECT count(*) FROM streetname; |
||
| 1353 | } |
||
| 1354 | } {1228} |
||
| 1355 | |||
| 1356 | do_test fuzzer1-2.1 { |
||
| 1357 | execsql { |
||
| 1358 | SELECT n, distance FROM f2, streetname |
||
| 1359 | WHERE f2.word MATCH 'wersley' |
||
| 1360 | AND f2.distance<=150 |
||
| 1361 | AND f2.word=streetname.n |
||
| 1362 | } |
||
| 1363 | } {worsley 37} |
||
| 1364 | do_test fuzzer1-2.2 { |
||
| 1365 | execsql { |
||
| 1366 | SELECT n, distance FROM f2, streetname |
||
| 1367 | WHERE f2.word MATCH 'testledown' |
||
| 1368 | AND f2.distance<=150 |
||
| 1369 | AND f2.word=streetname.n |
||
| 1370 | } |
||
| 1371 | } {thistledown 103} |
||
| 1372 | do_test fuzzer1-2.3 { |
||
| 1373 | execsql { |
||
| 1374 | SELECT DISTINCT streetname.n FROM f2, streetname |
||
| 1375 | WHERE f2.word MATCH 'tayle' |
||
| 1376 | AND f2.distance<=200 |
||
| 1377 | AND streetname.n>=f2.word AND streetname.n<=(f2.word || x'F7BFBFBF') |
||
| 1378 | } |
||
| 1379 | } {steelewood tallia tallu talwyn taymouth thelema trailer {tyler finley}} |
||
| 1380 | |||
| 1381 | |||
| 1382 | finish_test |