text: DROP TABLE IF EXISTS streets_types;
  
  CREATE TABLE streets_types
  (
      pid   TEXT PRIMARY KEY,
      label TEXT
  );
  
  INSERT INTO streets_types (pid, label) VALUES ('st:ACCESS', 'Accs');
  INSERT INTO streets_types (pid, label) VALUES ('st:ACRE', 'Acre');
  INSERT INTO streets_types (pid, label) VALUES ('st:AIRWALK', 'Awlk');
  INSERT INTO streets_types (pid, label) VALUES ('st:ALLEY', 'Ally');
  INSERT INTO streets_types (pid, label) VALUES ('st:ALLEYWAY', 'Alwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:AMBLE', 'Ambl');
  INSERT INTO streets_types (pid, label) VALUES ('st:APPROACH', 'App');
  INSERT INTO streets_types (pid, label) VALUES ('st:ARCADE', 'Arc');
  INSERT INTO streets_types (pid, label) VALUES ('st:ARTERIAL', 'Artl');
  INSERT INTO streets_types (pid, label) VALUES ('st:ARTERY', 'Arty');
  INSERT INTO streets_types (pid, label) VALUES ('st:AVENUE', 'Av');
  INSERT INTO streets_types (pid, label) VALUES ('st:BANAN', 'Ba');
  INSERT INTO streets_types (pid, label) VALUES ('st:BANK', 'Bank');
  INSERT INTO streets_types (pid, label) VALUES ('st:BAY', 'Bay');
  INSERT INTO streets_types (pid, label) VALUES ('st:BEACH', 'Bch');
  INSERT INTO streets_types (pid, label) VALUES ('st:BEND', 'Bend');
  INSERT INTO streets_types (pid, label) VALUES ('st:BOARDWALK', 'Bwlk');
  INSERT INTO streets_types (pid, label) VALUES ('st:BOULEVARD', 'Bvd');
  INSERT INTO streets_types (pid, label) VALUES ('st:BOULEVARDE', 'Bvde');
  INSERT INTO streets_types (pid, label) VALUES ('st:BOUNDARY', 'Bdy');
  INSERT INTO streets_types (pid, label) VALUES ('st:BOWL', 'Bowl');
  INSERT INTO streets_types (pid, label) VALUES ('st:BRACE', 'Br');
  INSERT INTO streets_types (pid, label) VALUES ('st:BRAE', 'Brae');
  INSERT INTO streets_types (pid, label) VALUES ('st:BRANCH', 'Bran');
  INSERT INTO streets_types (pid, label) VALUES ('st:BREAK', 'Brk');
  INSERT INTO streets_types (pid, label) VALUES ('st:BRETT', 'Bret');
  INSERT INTO streets_types (pid, label) VALUES ('st:BRIDGE', 'Bdge');
  INSERT INTO streets_types (pid, label) VALUES ('st:BROADWALK', 'Brdwlk');
  INSERT INTO streets_types (pid, label) VALUES ('st:BROADWAY', 'Bdwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:BROW', 'Brow');
  INSERT INTO streets_types (pid, label) VALUES ('st:BULL', 'Bull');
  INSERT INTO streets_types (pid, label) VALUES ('st:BUSWAY', 'Bswy');
  INSERT INTO streets_types (pid, label) VALUES ('st:BYPASS', 'Bypa');
  INSERT INTO streets_types (pid, label) VALUES ('st:BYWAY', 'Bywy');
  INSERT INTO streets_types (pid, label) VALUES ('st:CAUSEWAY', 'Cswy');
  INSERT INTO streets_types (pid, label) VALUES ('st:CENTRE', 'Ctr');
  INSERT INTO streets_types (pid, label) VALUES ('st:CENTREWAY', 'Cnwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:CHASE', 'Ch');
  INSERT INTO streets_types (pid, label) VALUES ('st:CIRCLE', 'Cir');
  INSERT INTO streets_types (pid, label) VALUES ('st:CIRCLET', 'Clt');
  INSERT INTO streets_types (pid, label) VALUES ('st:CIRCUIT', 'Cct');
  INSERT INTO streets_types (pid, label) VALUES ('st:CIRCUS', 'Crcs');
  INSERT INTO streets_types (pid, label) VALUES ('st:CLOSE', 'Cl');
  INSERT INTO streets_types (pid, label) VALUES ('st:CLUSTER', 'Clr');
  INSERT INTO streets_types (pid, label) VALUES ('st:COLONNADE', 'Clde');
  INSERT INTO streets_types (pid, label) VALUES ('st:COMMON', 'Cmmn');
  INSERT INTO streets_types (pid, label) VALUES ('st:COMMONS', 'Cmmns');
  INSERT INTO streets_types (pid, label) VALUES ('st:CONCORD', 'Cncd');
  INSERT INTO streets_types (pid, label) VALUES ('st:CONCOURSE', 'Con');
  INSERT INTO streets_types (pid, label) VALUES ('st:CONNECTION', 'Cntn');
  INSERT INTO streets_types (pid, label) VALUES ('st:CONNECTOR', 'Conr');
  INSERT INTO streets_types (pid, label) VALUES ('st:COPSE', 'Cps');
  INSERT INTO streets_types (pid, label) VALUES ('st:CORNER', 'Cnr');
  INSERT INTO streets_types (pid, label) VALUES ('st:CORSO', 'Cso');
  INSERT INTO streets_types (pid, label) VALUES ('st:COURSE', 'Crse');
  INSERT INTO streets_types (pid, label) VALUES ('st:COURT', 'Ct');
  INSERT INTO streets_types (pid, label) VALUES ('st:COURTYARD', 'Ctyd');
  INSERT INTO streets_types (pid, label) VALUES ('st:COVE', 'Cove');
  INSERT INTO streets_types (pid, label) VALUES ('st:CRESCENT', 'Cr');
  INSERT INTO streets_types (pid, label) VALUES ('st:CREST', 'Crst');
  INSERT INTO streets_types (pid, label) VALUES ('st:CRIEF', 'Crf');
  INSERT INTO streets_types (pid, label) VALUES ('st:CROOK', 'Crk');
  INSERT INTO streets_types (pid, label) VALUES ('st:CROSS', 'Crss');
  INSERT INTO streets_types (pid, label) VALUES ('st:CROSSING', 'Crsg');
  INSERT INTO streets_types (pid, label) VALUES ('st:CROSSOVER', 'Crvr');
  INSERT INTO streets_types (pid, label) VALUES ('st:CRUISEWAY', 'Cuwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:CUL-DE-SAC', 'Csac');
  INSERT INTO streets_types (pid, label) VALUES ('st:CUT', 'Cut');
  INSERT INTO streets_types (pid, label) VALUES ('st:CUTTING', 'Cutt');
  INSERT INTO streets_types (pid, label) VALUES ('st:DALE', 'Dale');
  INSERT INTO streets_types (pid, label) VALUES ('st:DASH', 'Dash');
  INSERT INTO streets_types (pid, label) VALUES ('st:DELL', 'Dell');
  INSERT INTO streets_types (pid, label) VALUES ('st:DENE', 'Dene');
  INSERT INTO streets_types (pid, label) VALUES ('st:DEVIATION', 'De');
  INSERT INTO streets_types (pid, label) VALUES ('st:DIP', 'Dip');
  INSERT INTO streets_types (pid, label) VALUES ('st:DISTRIBUTOR', 'Dstr');
  INSERT INTO streets_types (pid, label) VALUES ('st:DIVIDE', 'Div');
  INSERT INTO streets_types (pid, label) VALUES ('st:DOCK', 'Dock');
  INSERT INTO streets_types (pid, label) VALUES ('st:DOMAIN', 'Dom');
  INSERT INTO streets_types (pid, label) VALUES ('st:DOWN', 'Down');
  INSERT INTO streets_types (pid, label) VALUES ('st:DOWNS', 'Dwns');
  INSERT INTO streets_types (pid, label) VALUES ('st:DRIVE', 'Dr');
  INSERT INTO streets_types (pid, label) VALUES ('st:DRIVEWAY', 'Dvwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:EASEMENT', 'Esmt');
  INSERT INTO streets_types (pid, label) VALUES ('st:EAST', 'East');
  INSERT INTO streets_types (pid, label) VALUES ('st:EDGE', 'Edge');
  INSERT INTO streets_types (pid, label) VALUES ('st:ELBOW', 'Elb');
  INSERT INTO streets_types (pid, label) VALUES ('st:END', 'End');
  INSERT INTO streets_types (pid, label) VALUES ('st:ENTRANCE', 'Ent');
  INSERT INTO streets_types (pid, label) VALUES ('st:ESPLANADE', 'Esp');
  INSERT INTO streets_types (pid, label) VALUES ('st:ESTATE', 'Est');
  INSERT INTO streets_types (pid, label) VALUES ('st:EXPRESSWAY', 'Exp');
  INSERT INTO streets_types (pid, label) VALUES ('st:EXTENSION', 'Extn');
  INSERT INTO streets_types (pid, label) VALUES ('st:FAIRWAY', 'Fawy');
  INSERT INTO streets_types (pid, label) VALUES ('st:FIREBREAK', 'Fbrk');
  INSERT INTO streets_types (pid, label) VALUES ('st:FIRELINE', 'Flne');
  INSERT INTO streets_types (pid, label) VALUES ('st:FIRETRACK', 'Ftrk');
  INSERT INTO streets_types (pid, label) VALUES ('st:FIRETRAIL', 'Fitr');
  INSERT INTO streets_types (pid, label) VALUES ('st:FLAT', 'Flat');
  INSERT INTO streets_types (pid, label) VALUES ('st:FLATS', 'Flts');
  INSERT INTO streets_types (pid, label) VALUES ('st:FOLLOW', 'Folw');
  INSERT INTO streets_types (pid, label) VALUES ('st:FOOTWAY', 'Ftwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:FORD', 'Ford');
  INSERT INTO streets_types (pid, label) VALUES ('st:FORESHORE', 'Fshr');
  INSERT INTO streets_types (pid, label) VALUES ('st:FORK', 'Fork');
  INSERT INTO streets_types (pid, label) VALUES ('st:FORMATION', 'Form');
  INSERT INTO streets_types (pid, label) VALUES ('st:FREEWAY', 'Fwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:FRONT', 'Frnt');
  INSERT INTO streets_types (pid, label) VALUES ('st:FRONTAGE', 'Frtg');
  INSERT INTO streets_types (pid, label) VALUES ('st:GAP', 'Gap');
  INSERT INTO streets_types (pid, label) VALUES ('st:GARDEN', 'Gdn');
  INSERT INTO streets_types (pid, label) VALUES ('st:GARDENS', 'Gdns');
  INSERT INTO streets_types (pid, label) VALUES ('st:GATE', 'Gte');
  INSERT INTO streets_types (pid, label) VALUES ('st:GATEWAY', 'Gwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:GLADE', 'Glde');
  INSERT INTO streets_types (pid, label) VALUES ('st:GLEN', 'Glen');
  INSERT INTO streets_types (pid, label) VALUES ('st:GRANGE', 'Gra');
  INSERT INTO streets_types (pid, label) VALUES ('st:GREEN', 'Grn');
  INSERT INTO streets_types (pid, label) VALUES ('st:GROVE', 'Gr');
  INSERT INTO streets_types (pid, label) VALUES ('st:GULLY', 'Gly');
  INSERT INTO streets_types (pid, label) VALUES ('st:HARBOUR', 'Hrbr');
  INSERT INTO streets_types (pid, label) VALUES ('st:HAVEN', 'Hvn');
  INSERT INTO streets_types (pid, label) VALUES ('st:HEATH', 'Hth');
  INSERT INTO streets_types (pid, label) VALUES ('st:HEIGHTS', 'Hts');
  INSERT INTO streets_types (pid, label) VALUES ('st:HIGHROAD', 'Hird');
  INSERT INTO streets_types (pid, label) VALUES ('st:HIGHWAY', 'Hwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:HIKE', 'Hike');
  INSERT INTO streets_types (pid, label) VALUES ('st:HILL', 'Hill');
  INSERT INTO streets_types (pid, label) VALUES ('st:HILLS', 'Hills');
  INSERT INTO streets_types (pid, label) VALUES ('st:HOLLOW', 'Hllw');
  INSERT INTO streets_types (pid, label) VALUES ('st:HUB', 'Hub');
  INSERT INTO streets_types (pid, label) VALUES ('st:INLET', 'Inlt');
  INSERT INTO streets_types (pid, label) VALUES ('st:INTERCHANGE', 'Intg');
  INSERT INTO streets_types (pid, label) VALUES ('st:ISLAND', 'Id');
  INSERT INTO streets_types (pid, label) VALUES ('st:JUNCTION', 'Jnc');
  INSERT INTO streets_types (pid, label) VALUES ('st:KEY', 'Key');
  INSERT INTO streets_types (pid, label) VALUES ('st:KEYS', 'Keys');
  INSERT INTO streets_types (pid, label) VALUES ('st:KNOLL', 'Knol');
  INSERT INTO streets_types (pid, label) VALUES ('st:LADDER', 'Ladr');
  INSERT INTO streets_types (pid, label) VALUES ('st:LANDING', 'Ldg');
  INSERT INTO streets_types (pid, label) VALUES ('st:LANE', 'Lane');
  INSERT INTO streets_types (pid, label) VALUES ('st:LANEWAY', 'Lnwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:LEAD', 'Lead');
  INSERT INTO streets_types (pid, label) VALUES ('st:LEADER', 'Ledr');
  INSERT INTO streets_types (pid, label) VALUES ('st:LINE', 'Line');
  INSERT INTO streets_types (pid, label) VALUES ('st:LINK', 'Link');
  INSERT INTO streets_types (pid, label) VALUES ('st:LOOKOUT', 'Lkt');
  INSERT INTO streets_types (pid, label) VALUES ('st:LOOP', 'Loop');
  INSERT INTO streets_types (pid, label) VALUES ('st:LYNNE', 'Lynn');
  INSERT INTO streets_types (pid, label) VALUES ('st:MALL', 'Mall');
  INSERT INTO streets_types (pid, label) VALUES ('st:MANOR', 'Manr');
  INSERT INTO streets_types (pid, label) VALUES ('st:MART', 'Mart');
  INSERT INTO streets_types (pid, label) VALUES ('st:MAZE', 'Mz');
  INSERT INTO streets_types (pid, label) VALUES ('st:MEAD', 'Mead');
  INSERT INTO streets_types (pid, label) VALUES ('st:MEANDER', 'Mndr');
  INSERT INTO streets_types (pid, label) VALUES ('st:MEW', 'Mew');
  INSERT INTO streets_types (pid, label) VALUES ('st:MEWS', 'Mews');
  INSERT INTO streets_types (pid, label) VALUES ('st:MILE', 'Mile');
  INSERT INTO streets_types (pid, label) VALUES ('st:MOTORWAY', 'Mtwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:NOOK', 'Nook');
  INSERT INTO streets_types (pid, label) VALUES ('st:NORTH', 'Nth');
  INSERT INTO streets_types (pid, label) VALUES ('st:NULL', 'Null');
  INSERT INTO streets_types (pid, label) VALUES ('st:OUTLET', 'Otlt');
  INSERT INTO streets_types (pid, label) VALUES ('st:OUTLOOK', 'Otlk');
  INSERT INTO streets_types (pid, label) VALUES ('st:OVAL', 'Oval');
  INSERT INTO streets_types (pid, label) VALUES ('st:PALMS', 'Plms');
  INSERT INTO streets_types (pid, label) VALUES ('st:PARADE', 'Pde');
  INSERT INTO streets_types (pid, label) VALUES ('st:PARADISE', 'Prds');
  INSERT INTO streets_types (pid, label) VALUES ('st:PARK', 'Park');
  INSERT INTO streets_types (pid, label) VALUES ('st:PARKWAY', 'Pwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:PART', 'Part');
  INSERT INTO streets_types (pid, label) VALUES ('st:PASS', 'Pass');
  INSERT INTO streets_types (pid, label) VALUES ('st:PASSAGE', 'Psge');
  INSERT INTO streets_types (pid, label) VALUES ('st:PATH', 'Path');
  INSERT INTO streets_types (pid, label) VALUES ('st:PATHWAY', 'Pway');
  INSERT INTO streets_types (pid, label) VALUES ('st:PENINSULA', 'Psla');
  INSERT INTO streets_types (pid, label) VALUES ('st:PIAZZA', 'Piaz');
  INSERT INTO streets_types (pid, label) VALUES ('st:PLACE', 'Pl');
  INSERT INTO streets_types (pid, label) VALUES ('st:PLAZA', 'Plza');
  INSERT INTO streets_types (pid, label) VALUES ('st:POCKET', 'Pkt');
  INSERT INTO streets_types (pid, label) VALUES ('st:POINT', 'Pnt');
  INSERT INTO streets_types (pid, label) VALUES ('st:PORT', 'Port');
  INSERT INTO streets_types (pid, label) VALUES ('st:PRECINCT', 'Prec');
  INSERT INTO streets_types (pid, label) VALUES ('st:PROMENADE', 'Prom');
  INSERT INTO streets_types (pid, label) VALUES ('st:PURSUIT', 'Prst');
  INSERT INTO streets_types (pid, label) VALUES ('st:QUAD', 'Quad');
  INSERT INTO streets_types (pid, label) VALUES ('st:QUADRANT', 'Qdrt');
  INSERT INTO streets_types (pid, label) VALUES ('st:QUAY', 'Qy');
  INSERT INTO streets_types (pid, label) VALUES ('st:QUAYS', 'Qys');
  INSERT INTO streets_types (pid, label) VALUES ('st:RAMBLE', 'Rmbl');
  INSERT INTO streets_types (pid, label) VALUES ('st:RAMP', 'Ramp');
  INSERT INTO streets_types (pid, label) VALUES ('st:RANGE', 'Rnge');
  INSERT INTO streets_types (pid, label) VALUES ('st:REACH', 'Rch');
  INSERT INTO streets_types (pid, label) VALUES ('st:REEF', 'Reef');
  INSERT INTO streets_types (pid, label) VALUES ('st:RESERVE', 'Res');
  INSERT INTO streets_types (pid, label) VALUES ('st:REST', 'Rest');
  INSERT INTO streets_types (pid, label) VALUES ('st:RETREAT', 'Rtt');
  INSERT INTO streets_types (pid, label) VALUES ('st:RETURN', 'Rtn');
  INSERT INTO streets_types (pid, label) VALUES ('st:RIDE', 'Ride');
  INSERT INTO streets_types (pid, label) VALUES ('st:RIDGE', 'Rdge');
  INSERT INTO streets_types (pid, label) VALUES ('st:RIGHTOFWAY', 'Rofw');
  INSERT INTO streets_types (pid, label) VALUES ('st:RING', 'Ring');
  INSERT INTO streets_types (pid, label) VALUES ('st:RISE', 'Rise');
  INSERT INTO streets_types (pid, label) VALUES ('st:RISING', 'Rsng');
  INSERT INTO streets_types (pid, label) VALUES ('st:RIVER', 'Rvr');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROAD', 'Rd');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROADS', 'Rds');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROADWAY', 'Rdwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROTARY', 'Rty');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROUND', 'Rnd');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROUTE', 'Rte');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROW', 'Row');
  INSERT INTO streets_types (pid, label) VALUES ('st:ROWE', 'Rowe');
  INSERT INTO streets_types (pid, label) VALUES ('st:RUE', 'Rue');
  INSERT INTO streets_types (pid, label) VALUES ('st:RUN', 'Run');
  INSERT INTO streets_types (pid, label) VALUES ('st:SERVICEWAY', 'Svwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:SHUNT', 'Shun');
  INSERT INTO streets_types (pid, label) VALUES ('st:SKYLINE', 'Skln');
  INSERT INTO streets_types (pid, label) VALUES ('st:SLOPE', 'Slpe');
  INSERT INTO streets_types (pid, label) VALUES ('st:SOUTH', 'Sth');
  INSERT INTO streets_types (pid, label) VALUES ('st:SPUR', 'Spur');
  INSERT INTO streets_types (pid, label) VALUES ('st:SQUARE', 'Sq');
  INSERT INTO streets_types (pid, label) VALUES ('st:STEPS', 'Stps');
  INSERT INTO streets_types (pid, label) VALUES ('st:STRAIGHT', 'Strt');
  INSERT INTO streets_types (pid, label) VALUES ('st:STRAIT', 'Stai');
  INSERT INTO streets_types (pid, label) VALUES ('st:STRAND', 'Stra');
  INSERT INTO streets_types (pid, label) VALUES ('st:STREET', 'St');
  INSERT INTO streets_types (pid, label) VALUES ('st:STRIP', 'Strp');
  INSERT INTO streets_types (pid, label) VALUES ('st:SUBWAY', 'Sbwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:TARN', 'Tarn');
  INSERT INTO streets_types (pid, label) VALUES ('st:TERRACE', 'Tce');
  INSERT INTO streets_types (pid, label) VALUES ('st:THOROUGHFARE', 'Thfr');
  INSERT INTO streets_types (pid, label) VALUES ('st:THROUGHWAY', 'Thru');
  INSERT INTO streets_types (pid, label) VALUES ('st:TOLLWAY', 'Tlwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:TOP', 'Top');
  INSERT INTO streets_types (pid, label) VALUES ('st:TOR', 'Tor');
  INSERT INTO streets_types (pid, label) VALUES ('st:TRACK', 'Trk');
  INSERT INTO streets_types (pid, label) VALUES ('st:TRAIL', 'Trl');
  INSERT INTO streets_types (pid, label) VALUES ('st:TRAMWAY', 'Tmwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:TRAVERSE', 'Tvse');
  INSERT INTO streets_types (pid, label) VALUES ('st:TRIANGLE', 'Triangle');
  INSERT INTO streets_types (pid, label) VALUES ('st:TRUNKWAY', 'Tkwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:TUNNEL', 'Tunl');
  INSERT INTO streets_types (pid, label) VALUES ('st:TURN', 'Turn');
  INSERT INTO streets_types (pid, label) VALUES ('st:TWIST', 'Twist');
  INSERT INTO streets_types (pid, label) VALUES ('st:UNDERPASS', 'Upas');
  INSERT INTO streets_types (pid, label) VALUES ('st:VALE', 'Vale');
  INSERT INTO streets_types (pid, label) VALUES ('st:VALLEY', 'Vlly');
  INSERT INTO streets_types (pid, label) VALUES ('st:VERGE', 'Verge');
  INSERT INTO streets_types (pid, label) VALUES ('st:VIADUCT', 'Viad');
  INSERT INTO streets_types (pid, label) VALUES ('st:VIEW', 'View');
  INSERT INTO streets_types (pid, label) VALUES ('st:VIEWS', 'Vws');
  INSERT INTO streets_types (pid, label) VALUES ('st:VILLA', 'Vlla');
  INSERT INTO streets_types (pid, label) VALUES ('st:VILLAGE', 'Vlge');
  INSERT INTO streets_types (pid, label) VALUES ('st:VILLAS', 'Vlls');
  INSERT INTO streets_types (pid, label) VALUES ('st:VISTA', 'Vsta');
  INSERT INTO streets_types (pid, label) VALUES ('st:VUE', 'Vue');
  INSERT INTO streets_types (pid, label) VALUES ('st:WADE', 'Wade');
  INSERT INTO streets_types (pid, label) VALUES ('st:WALK', 'Walk');
  INSERT INTO streets_types (pid, label) VALUES ('st:WALKWAY', 'Wkwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:WATERS', 'Wtrs');
  INSERT INTO streets_types (pid, label) VALUES ('st:WATERWAY', 'Wtwy');
  INSERT INTO streets_types (pid, label) VALUES ('st:WAY', 'Way');
  INSERT INTO streets_types (pid, label) VALUES ('st:WEST', 'West');
  INSERT INTO streets_types (pid, label) VALUES ('st:WHARF', 'Whrf');
  INSERT INTO streets_types (pid, label) VALUES ('st:WOOD', 'Wd');
  INSERT INTO streets_types (pid, label) VALUES ('st:WOODS', 'Wds');
  INSERT INTO streets_types (pid, label) VALUES ('st:WYND', 'Wynd');
  INSERT INTO streets_types (pid, label) VALUES ('st:YARD', 'Yard');