-- ============================================================ -- address-bound-coord-updates.sql -- Generated from address_util/vague-address-bounds.txt (416 rows). -- -- bound_id = 1: 332 -- bound_id = 2: 63 -- bound_id = NULL: 21 (blank Bound in the txt) -- latitude/longitude updates (area coords): 130 -- vague_backfilled_coords = 1 for every row in this batch. -- -- Every statement is idempotent and scoped to one id. Every row in the -- batch also sets vague_backfilled_coords = 1, including the 130 rows that -- receive area-level coordinates. -- -- Apply: -- wrangler d1 execute --remote --config wrangler.prod.toml \ -- --file address_util/address-bound-coord-updates.sql -- ============================================================ UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 1; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 2; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 3; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 4; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 5; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 6; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 7; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 8; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 9; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 10; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 11; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 12; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 13; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 14; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 15; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 16; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 21; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 22; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 23; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 25; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 28; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 29; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 30; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 31; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 32; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 33; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 34; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 35; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 36; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 37; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 39; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 40; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 41; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 42; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 43; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 44; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 45; UPDATE addresses SET bound_id = 2, latitude = 16.755649, longitude = 78.017013, vague_backfilled_coords = 1 WHERE id = 46; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 51; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 52; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 53; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 55; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 56; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 57; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 60; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 66; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 69; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 73; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 74; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 81; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 83; UPDATE addresses SET bound_id = 2, latitude = 16.749234, longitude = 78.027886, vague_backfilled_coords = 1 WHERE id = 84; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 86; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 87; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 88; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 89; UPDATE addresses SET bound_id = 2, latitude = 16.749234, longitude = 78.027886, vague_backfilled_coords = 1 WHERE id = 90; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 91; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 93; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 94; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 95; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 96; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 98; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 99; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 100; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 101; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 102; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 103; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 106; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 108; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 111; UPDATE addresses SET bound_id = 1, latitude = 16.752972, longitude = 78.017824, vague_backfilled_coords = 1 WHERE id = 112; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 114; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 116; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 117; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 119; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 120; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 121; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 124; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 125; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 126; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 128; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 131; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 135; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 137; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 138; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 139; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 141; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 142; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 146; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 147; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 150; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 151; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 153; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 154; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 155; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 157; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 159; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 162; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 164; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 165; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 166; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 169; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 171; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 172; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 173; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 178; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 179; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 182; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 183; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 184; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 185; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 186; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 188; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 190; UPDATE addresses SET bound_id = 2, latitude = 16.749234, longitude = 78.027886, vague_backfilled_coords = 1 WHERE id = 195; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 196; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 197; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 199; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 203; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 204; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 205; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 208; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 210; UPDATE addresses SET bound_id = 2, latitude = 16.744645, longitude = 78.014443, vague_backfilled_coords = 1 WHERE id = 211; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 214; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 215; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 216; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 218; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 220; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 222; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 224; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 225; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 227; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 228; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 229; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 230; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 234; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 235; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 236; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 238; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 245; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 246; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 248; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 249; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 251; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 253; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 254; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 258; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 259; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 260; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 261; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 262; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 265; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 268; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 269; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 271; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 272; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 273; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 274; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 276; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 277; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 278; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 279; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 282; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 283; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 285; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 287; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 288; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 289; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 290; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 291; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 295; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 299; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 302; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 303; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 304; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 305; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 309; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 311; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 312; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 316; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 320; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 321; UPDATE addresses SET bound_id = 2, latitude = 16.744645, longitude = 78.014443, vague_backfilled_coords = 1 WHERE id = 323; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 324; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 327; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 330; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 331; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 333; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 336; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 338; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 345; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 347; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 348; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 350; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 351; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 353; UPDATE addresses SET bound_id = 2, latitude = 16.749234, longitude = 78.027886, vague_backfilled_coords = 1 WHERE id = 357; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 358; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 359; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 360; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 363; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 366; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 368; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 373; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 374; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 377; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 379; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 381; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 382; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 383; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 385; UPDATE addresses SET bound_id = 2, latitude = 16.724600, longitude = 77.984973, vague_backfilled_coords = 1 WHERE id = 386; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 387; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 390; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 391; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 392; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 401; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 406; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 411; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 415; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 417; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 421; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 425; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 426; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 427; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 430; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 431; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 432; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 435; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 439; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 440; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 446; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 451; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 452; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 453; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 454; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 456; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 459; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 460; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 461; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 462; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 463; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 465; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 471; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 477; UPDATE addresses SET bound_id = 2, latitude = 16.755649, longitude = 78.017013, vague_backfilled_coords = 1 WHERE id = 482; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 483; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 485; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 487; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 488; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 489; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 490; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 491; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 492; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 494; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 496; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 497; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 504; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 507; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 508; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 511; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 518; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 520; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 524; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 525; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 528; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 530; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 534; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 538; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 539; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 544; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 547; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 549; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 550; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 552; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 554; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 564; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 567; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 568; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 573; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 575; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 577; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 578; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 584; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 587; UPDATE addresses SET bound_id = 1, latitude = 16.752972, longitude = 78.017824, vague_backfilled_coords = 1 WHERE id = 588; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 589; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 591; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 592; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 593; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 594; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 596; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 597; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 598; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 600; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 602; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 605; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 607; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 609; UPDATE addresses SET bound_id = 2, latitude = 16.749234, longitude = 78.027886, vague_backfilled_coords = 1 WHERE id = 613; UPDATE addresses SET bound_id = 2, latitude = 16.755649, longitude = 78.017013, vague_backfilled_coords = 1 WHERE id = 614; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 616; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 617; UPDATE addresses SET bound_id = 2, latitude = 16.758734, longitude = 78.041012, vague_backfilled_coords = 1 WHERE id = 618; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 619; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 620; UPDATE addresses SET bound_id = 2, latitude = 16.724600, longitude = 77.984973, vague_backfilled_coords = 1 WHERE id = 622; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 624; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 625; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 626; UPDATE addresses SET bound_id = 2, latitude = 16.724600, longitude = 77.984973, vague_backfilled_coords = 1 WHERE id = 631; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 632; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 635; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 638; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 640; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 642; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 643; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 644; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 648; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 649; UPDATE addresses SET bound_id = 2, latitude = 16.758734, longitude = 78.041012, vague_backfilled_coords = 1 WHERE id = 650; UPDATE addresses SET bound_id = 1, latitude = 16.758734, longitude = 78.041012, vague_backfilled_coords = 1 WHERE id = 655; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 656; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 658; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 659; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 661; UPDATE addresses SET bound_id = 2, latitude = 16.749234, longitude = 78.027886, vague_backfilled_coords = 1 WHERE id = 665; UPDATE addresses SET bound_id = 2, latitude = 16.753344, longitude = 78.032133, vague_backfilled_coords = 1 WHERE id = 667; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 670; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 673; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 679; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 682; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 684; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 688; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 691; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 692; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 695; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 698; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 704; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 706; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 707; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 708; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 713; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 714; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 717; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 720; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 722; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 726; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 730; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 735; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 738; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 741; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 743; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 744; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 745; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 753; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 754; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 755; UPDATE addresses SET bound_id = 2, latitude = 16.755649, longitude = 78.017013, vague_backfilled_coords = 1 WHERE id = 756; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 761; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 766; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 768; UPDATE addresses SET bound_id = 2, latitude = 16.721995, longitude = 78.018658, vague_backfilled_coords = 1 WHERE id = 769; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 775; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 780; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 782; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 783; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 784; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 785; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 788; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 795; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 799; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 802; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 807; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 808; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 809; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 811; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 814; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 816; UPDATE addresses SET bound_id = 1, latitude = 16.740450, longitude = 78.004159, vague_backfilled_coords = 1 WHERE id = 817; UPDATE addresses SET bound_id = 2, latitude = 16.744645, longitude = 78.014443, vague_backfilled_coords = 1 WHERE id = 818; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 820; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 825; UPDATE addresses SET bound_id = 2, vague_backfilled_coords = 1 WHERE id = 829; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 830; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 834; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 843; UPDATE addresses SET bound_id = 2, latitude = 16.760099, longitude = 78.009772, vague_backfilled_coords = 1 WHERE id = 844; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 846; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 848; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 849; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 855; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 856; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 857; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 858; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 859; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 862; UPDATE addresses SET bound_id = 1, latitude = 16.752972, longitude = 78.017824, vague_backfilled_coords = 1 WHERE id = 864; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 870; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 871; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 872; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 874; UPDATE addresses SET bound_id = NULL, vague_backfilled_coords = 1 WHERE id = 875; UPDATE addresses SET bound_id = 2, latitude = 16.749234, longitude = 78.027886, vague_backfilled_coords = 1 WHERE id = 877; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 882; UPDATE addresses SET bound_id = 1, latitude = 16.733798, longitude = 77.999953, vague_backfilled_coords = 1 WHERE id = 883; UPDATE addresses SET bound_id = 1, latitude = 16.752972, longitude = 78.017824, vague_backfilled_coords = 1 WHERE id = 886; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 887; UPDATE addresses SET bound_id = 2, latitude = 16.754539, longitude = 78.035332, vague_backfilled_coords = 1 WHERE id = 897; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 898; UPDATE addresses SET bound_id = 1, latitude = 16.743916, longitude = 78.012978, vague_backfilled_coords = 1 WHERE id = 900; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 903; UPDATE addresses SET bound_id = 1, vague_backfilled_coords = 1 WHERE id = 909; UPDATE addresses SET bound_id = 1, latitude = 16.747980, longitude = 78.005575, vague_backfilled_coords = 1 WHERE id = 912; -- Verification (only the addressed rows): -- SELECT COUNT(*) AS addressed, -- SUM(bound_id = 1) AS bound_1, -- SUM(bound_id = 2) AS bound_2, -- SUM(bound_id IS NULL) AS bound_null, -- SUM(vague_backfilled_coords = 1) AS vague -- FROM addresses WHERE id IN ( -- 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 21, 22, 23, 25, -- 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 39, 40, 41, 42, 43, 44, 45, 46, 51, 52, -- 53, 55, 56, 57, 60, 66, 69, 73, 74, 81, 83, 84, 86, 87, 88, 89, 90, 91, 93, 94, -- 95, 96, 98, 99, 100, 101, 102, 103, 106, 108, 111, 112, 114, 116, 117, 119, 120, 121, 124, 125, -- 126, 128, 131, 135, 137, 138, 139, 141, 142, 146, 147, 150, 151, 153, 154, 155, 157, 159, 162, 164, -- 165, 166, 169, 171, 172, 173, 178, 179, 182, 183, 184, 185, 186, 188, 190, 195, 196, 197, 199, 203, -- 204, 205, 208, 210, 211, 214, 215, 216, 218, 220, 222, 224, 225, 227, 228, 229, 230, 234, 235, 236, -- 238, 245, 246, 248, 249, 251, 253, 254, 258, 259, 260, 261, 262, 265, 268, 269, 271, 272, 273, 274, -- 276, 277, 278, 279, 282, 283, 285, 287, 288, 289, 290, 291, 295, 299, 302, 303, 304, 305, 309, 311, -- 312, 316, 320, 321, 323, 324, 327, 330, 331, 333, 336, 338, 345, 347, 348, 350, 351, 353, 357, 358, -- 359, 360, 363, 366, 368, 373, 374, 377, 379, 381, 382, 383, 385, 386, 387, 390, 391, 392, 401, 406, -- 411, 415, 417, 421, 425, 426, 427, 430, 431, 432, 435, 439, 440, 446, 451, 452, 453, 454, 456, 459, -- 460, 461, 462, 463, 465, 471, 477, 482, 483, 485, 487, 488, 489, 490, 491, 492, 494, 496, 497, 504, -- 507, 508, 511, 518, 520, 524, 525, 528, 530, 534, 538, 539, 544, 547, 549, 550, 552, 554, 564, 567, -- 568, 573, 575, 577, 578, 584, 587, 588, 589, 591, 592, 593, 594, 596, 597, 598, 600, 602, 605, 607, -- 609, 613, 614, 616, 617, 618, 619, 620, 622, 624, 625, 626, 631, 632, 635, 638, 640, 642, 643, 644, -- 648, 649, 650, 655, 656, 658, 659, 661, 665, 667, 670, 673, 679, 682, 684, 688, 691, 692, 695, 698, -- 704, 706, 707, 708, 713, 714, 717, 720, 722, 726, 730, 735, 738, 741, 743, 744, 745, 753, 754, 755, -- 756, 761, 766, 768, 769, 775, 780, 782, 783, 784, 785, 788, 795, 799, 802, 807, 808, 809, 811, 814, -- 816, 817, 818, 820, 825, 829, 830, 834, 843, 844, 846, 848, 849, 855, 856, 857, 858, 859, 862, 864, -- 870, 871, 872, 874, 875, 877, 882, 883, 886, 887, 897, 898, 900, 903, 909, 912);