Created
February 29, 2012 18:44
-
-
Save mvexel/1943433 to your computer and use it in GitHub Desktop.
NBI <> OSM conflation first try
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Query: select a.gid as nbi_id, a.facility_ca as nbi_name, a.route_numbe as nbi_ref, b.tags->'name' as osm_name, b.tags->'ref' as osm_ref from nbi_all_viaducts a, ways b where ST_Buffer(a.the_geom, 0.001) && b.linestring LIMIT 200; | |
| nbi_id | nbi_name | nbi_ref | osm_name | osm_ref | |
| --------+--------------------+---------+----------------------------+------------------------- | |
| 43993 | I-471 NC | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 43993 | I-471 NC | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 43994 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 43994 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 44019 | I-471 | 00471 | | | |
| 44019 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 44019 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 44026 | I-471 NC | 00471 | | | |
| 44026 | I-471 NC | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 44026 | I-471 NC | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 44026 | I-471 NC | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 44027 | I-471 | 00471 | | | |
| 44027 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 44027 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 45599 | I-471 NC | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45599 | I-471 NC | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45600 | I-471 | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45600 | I-471 | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45631 | I-471 | 00471 | | | |
| 45631 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 45631 | I-471 | 00471 | Daniel Carter Beard Bridge | I 471 | |
| 45639 | I-471 NC | 00008 | | | |
| 45639 | I-471 NC | 00008 | Daniel Carter Beard Bridge | I 471 | |
| 45639 | I-471 NC | 00008 | Daniel Carter Beard Bridge | I 471 | |
| 45639 | I-471 NC | 00008 | Daniel Carter Beard Bridge | I 471 | |
| 45640 | I-471 NC | 01000 | | | |
| 45640 | I-471 NC | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45640 | I-471 NC | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45640 | I-471 NC | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45641 | I-471 | 01000 | | | |
| 45641 | I-471 | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45641 | I-471 | 01000 | Daniel Carter Beard Bridge | I 471 | |
| 45642 | I-471 | 00008 | | | |
| 45642 | I-471 | 00008 | Daniel Carter Beard Bridge | I 471 | |
| 45642 | I-471 | 00008 | Daniel Carter Beard Bridge | I 471 | |
| 146888 | WILD GOOSE RD.-CO. | 00000 | East 6800 North Street | | |
| 147005 | CO.RD. INTCHG.X-RD | 00000 | | | |
| 147756 | WILD GOOSE RD.-CO. | 00015 | East 6800 North Street | | |
| 147867 | CO.RD. INTCHG.X-RD | 00070 | | | |
| 149552 | COUNTY ROAD 25 | 00000 | 25 Road | | |
| 149553 | COUNTY ROAD 24 | 00000 | 24 Road | | |
| 149554 | COUNTY ROAD 26.5 | 00000 | 26 1/2 Road | | |
| 149555 | COUNTY ROAD 24.5 | 00000 | 24 1/2 Road | | |
| 149556 | COUNTY ROAD 27 | 00000 | 27 Road | | |
| 149557 | I 70 ML WBND | 0070A | | I 70 | |
| 149557 | I 70 ML WBND | 0070A | | I 70 | |
| 149558 | I 70 ML EBND | 0070A | | I 70 | |
| 149558 | I 70 ML EBND | 0070A | | I 70 | |
| 149559 | COUNTY ROAD 26 | 00000 | 26 Road | | |
| 149564 | I 70 ML WBND | 0070A | | I 70 | |
| 149564 | I 70 ML WBND | 0070A | | I 70 | |
| 149565 | I 70 ML EBND | 0070A | | I 70 | |
| 149565 | I 70 ML EBND | 0070A | | I 70 | |
| 149566 | I 70 ML WBND | 0070A | | I 70 | |
| 149566 | I 70 ML WBND | 0070A | | I 70 | |
| 149567 | US 6 ML | 0006A | | I 70 | |
| 149567 | US 6 ML | 0006A | | I 70 | |
| 149575 | COUNTY ROAD 29 | 00000 | 29 Road | | |
| 149576 | COUNTY ROAD 23 | 00000 | 23 Road | | |
| 149580 | I 70 ML WBND | 0070A | | I 70 | |
| 149580 | I 70 ML WBND | 0070A | | I 70 | |
| 149581 | I 70 ML EBND | 0070A | | I 70 | |
| 149581 | I 70 ML EBND | 0070A | | I 70 | |
| 149582 | I 70 BUS ROUTE | 0070B | | | |
| 149582 | I 70 BUS ROUTE | 0070B | | I 70 Business | |
| 150486 | COUNTY ROAD 25 | 0070A | 25 Road | | |
| 150487 | COUNTY ROAD 24 | 0070A | 24 Road | | |
| 150488 | COUNTY ROAD 26.5 | 0070A | 26 1/2 Road | | |
| 150489 | COUNTY ROAD 24.5 | 0070A | 24 1/2 Road | | |
| 150490 | COUNTY ROAD 27 | 0070A | 27 Road | | |
| 150491 | COUNTY ROAD 26 | 0070A | 26 Road | | |
| 150496 | I 70 ML WBND | 0006A | | I 70 | |
| 150496 | I 70 ML WBND | 0006A | | I 70 | |
| 150497 | US 6 ML | 0070B | | I 70 | |
| 150497 | US 6 ML | 0070B | | I 70 | |
| 150500 | COUNTY ROAD 29 | 0070A | 29 Road | | |
| 150501 | COUNTY ROAD 23 | 0070A | 23 Road | | |
| 150505 | I 70 BUS ROUTE | 0070A | | | |
| 150505 | I 70 BUS ROUTE | 0070A | | I 70 Business | |
| 162639 | RP IS70E TO IS670W | 00000 | | | |
| 162639 | RP IS70E TO IS670W | 00000 | | | |
| 162639 | RP IS70E TO IS670W | 00000 | Charlotte St | | |
| 162639 | RP IS70E TO IS670W | 00000 | | US 71 | |
| 162639 | RP IS70E TO IS670W | 00000 | | | |
| 162639 | RP IS70E TO IS670W | 00000 | | I 70;US 40 | |
| 162653 | RP US71N TO 11TH S | 00000 | | I 70;US 40;US 71 | |
| 162653 | RP US71N TO 11TH S | 00000 | | I 70;US 40 | |
| 162653 | RP US71N TO 11TH S | 00000 | | US 71 | |
| 162653 | RP US71N TO 11TH S | 00000 | | US 71 | |
| 162653 | RP US71N TO 11TH S | 00000 | | | |
| 162653 | RP US71N TO 11TH S | 00000 | | | |
| 162670 | IS 70 E | 00070 | | I 70;US 24;US 40;US 169 | |
| 162670 | IS 70 E | 00070 | | I 70;US 24;US 40;US 169 | |
| 162670 | IS 70 E | 00070 | | | |
| 162670 | IS 70 E | 00070 | | I 70;US 24;US 40;US 169 | |
| 162908 | WILSON AVE E | 00000 | Wilson Ave | | |
| 162935 | IS 435 S | 00435 | | I 435 | |
| 162935 | IS 435 S | 00435 | | I 435 | |
| 162936 | IS 435 N | 00435 | | I 435 | |
| 162936 | IS 435 N | 00435 | | I 435 | |
| 163204 | IS 70 E | 00070 | | | |
| 163204 | IS 70 E | 00070 | | | |
| 163204 | IS 70 E | 00070 | | I 70;US 40;US 71 | |
| 163204 | IS 70 E | 00070 | | I 70;US 40 | |
| 163204 | IS 70 E | 00070 | | US 71 | |
| 163204 | IS 70 E | 00070 | | US 71 | |
| 163209 | US 71 N | 00071 | | | |
| 163209 | US 71 N | 00071 | | | |
| 163209 | US 71 N | 00071 | | I 70;US 40;US 71 | |
| 163209 | US 71 N | 00071 | | I 70;US 40 | |
| 163209 | US 71 N | 00071 | | US 71 | |
| 163209 | US 71 N | 00071 | | US 71 | |
| 163212 | IS 70 E | 00070 | | I 70;US 40;US 71 | |
| 163212 | IS 70 E | 00070 | | I 70;US 40 | |
| 163212 | IS 70 E | 00070 | | | |
| 163212 | IS 70 E | 00070 | | I 70;US 40;US 71 | |
| 163212 | IS 70 E | 00070 | | I 70;US 40 | |
| 163212 | IS 70 E | 00070 | | US 71 | |
| 163212 | IS 70 E | 00070 | | US 71 | |
| 163212 | IS 70 E | 00070 | | US 71 | |
| 163212 | IS 70 E | 00070 | | | |
| 163212 | IS 70 E | 00070 | | | |
| 163215 | IS 70 W | 00070 | | I 70;US 40;US 71 | |
| 163215 | IS 70 W | 00070 | | I 70;US 40 | |
| 163215 | IS 70 W | 00070 | | I 70;US 40 | |
| 163215 | IS 70 W | 00070 | | US 71 | |
| 163215 | IS 70 W | 00070 | | US 71 | |
| 163215 | IS 70 W | 00070 | | US 71 | |
| 163215 | IS 70 W | 00070 | | | |
| 163215 | IS 70 W | 00070 | | | |
| 163221 | US 71 N | 00071 | | I 70;US 40;US 71 | |
| 163221 | US 71 N | 00071 | | I 70;US 40 | |
| 163221 | US 71 N | 00071 | | US 71 | |
| 163221 | US 71 N | 00071 | | US 71 | |
| 163221 | US 71 N | 00071 | | | |
| 163221 | US 71 N | 00071 | | | |
| 163344 | GLADSTONE BLVD | 00222 | Gladstone Blvd | | |
| 163346 | LEXINGTON AVE | 00000 | Lexington Ave | | |
| 163347 | GRAND AVE | 00222 | | | |
| 163347 | GRAND AVE | 00222 | Heart of America Brg | 9 | |
| 163347 | GRAND AVE | 00222 | | | |
| 163347 | GRAND AVE | 00222 | Grand Ave | | |
| 163347 | GRAND AVE | 00222 | Heart of America Brg | 9 | |
| 163348 | 12TH ST | 00000 | West 12th Street | | |
| 163349 | BRUCE FORRESTER VD | 00000 | Forrester Road | | |
| 163439 | IS 670 E | 00670 | | | |
| 163439 | IS 670 E | 00670 | | I 670 | |
| 163439 | IS 670 E | 00670 | | | |
| 163439 | IS 670 E | 00670 | | I 670 | |
| 163440 | IS 670 W | 00670 | | | |
| 163440 | IS 670 W | 00670 | | I 670 | |
| 163440 | IS 670 W | 00670 | | | |
| 163440 | IS 670 W | 00670 | | I 670 | |
| 163442 | RP WYOMING ST TO I | 00000 | | | |
| 163442 | RP WYOMING ST TO I | 00000 | | I 670 | |
| 163442 | RP WYOMING ST TO I | 00000 | | | |
| 163442 | RP WYOMING ST TO I | 00000 | | I 670 | |
| 163443 | RP IS670W TO WYOMI | 00000 | | | |
| 163443 | RP IS670W TO WYOMI | 00000 | | I 670 | |
| 163443 | RP IS670W TO WYOMI | 00000 | | | |
| 163443 | RP IS670W TO WYOMI | 00000 | | I 670 | |
| 163906 | IS 35 N | 00035 | Admiral Blvd | | |
| 163906 | IS 35 N | 00035 | | US 24 | |
| 163906 | IS 35 N | 00035 | | I 70;US 40 | |
| 163906 | IS 35 N | 00035 | | I 35 | |
| 163906 | IS 35 N | 00035 | | I 35 | |
| 163907 | IS 35 N | 00035 | Admiral Blvd | | |
| 163907 | IS 35 N | 00035 | | US 24 | |
| 163907 | IS 35 N | 00035 | | I 70;US 40 | |
| 163907 | IS 35 N | 00035 | | I 35 | |
| 163907 | IS 35 N | 00035 | Independence Ave | US 24 | |
| 163907 | IS 35 N | 00035 | | I 35 | |
| 163939 | BRUCE FORRESTER VD | 00000 | Forrester Road | | |
| 163972 | RP IS29S TO US24 W | 00000 | | | |
| 163972 | RP IS29S TO US24 W | 00000 | | | |
| 164031 | MO 9 S | 00009 | | | |
| 164031 | MO 9 S | 00009 | | | |
| 164031 | MO 9 S | 00009 | Heart of America Brg | 9 | |
| 164031 | MO 9 S | 00009 | Heart of America Brg | 9 | |
| 164032 | MO 9 N | 00009 | | | |
| 164032 | MO 9 N | 00009 | | | |
| 164032 | MO 9 N | 00009 | Heart of America Brg | 9 | |
| 164032 | MO 9 N | 00009 | Heart of America Brg | 9 | |
| 164054 | MO 9 S | 00009 | | 9 | |
| 164054 | MO 9 S | 00009 | | 9 | |
| 164054 | MO 9 S | 00009 | | | |
| 164054 | MO 9 S | 00009 | | | |
| 164055 | RP MO9S TO IS35S S | 00000 | | | |
| 164055 | RP MO9S TO IS35S S | 00000 | | | |
| 164056 | RP IS35N TO MO9N N | 00000 | | | |
| 164057 | RP MO9S TO IS35N S | 00000 | | | |
| 164057 | RP MO9S TO IS35N S | 00000 | | | |
| 164082 | IS 70 W | 00070 | | I 70;US 24;US 40;US 169 | |
| 164082 | IS 70 W | 00070 | | I 70;US 24;US 40;US 169 | |
| 164082 | IS 70 W | 00070 | | | |
| 164082 | IS 70 W | 00070 | | I 70;US 24;US 40;US 169 | |
| 164084 | DELAWARE ST S | 00000 | Delaware St | | |
| 164085 | GRAND AVE S | 00000 | Grand Ave | | |
| 164117 | MO 9 N | 00009 | | 9 | |
| 164117 | MO 9 N | 00009 | | 9 | |
| (200 rows) | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment