Querying GIS Data
I have GIS dataset which i want to query for finding intersections.
The data goes like this:
ID Street1 Street2 Intersection
1 407 HWY 407 RAMP 407 HWY & 407 RAMP
2 407 HWY 410 HWY 407 HWY & 410 HWY
3 407 HWY 427 HWY 407 HWY & 427 HWY
5 407 RAMP 410 HWY 407 RAMP & 410 HWY
6 407 RAMP AIRPORT RD 407 RAMP & AIRPORT RD
7 407 RAMP BRAMALEA RD 407 RAMP & BRAMALEA RD
8 407 RAMP DIXIE RD 407 RAMP & DIXIE RD
9 407 RAMP GOREWAY DR 407 RAMP & GOREWAY DR
10 407 RAMP HURONTARIO ST 407 RAMP & HURONTARIO ST
11 407 RAMP MAVIS RD 407 RAMP & MAVIS RD
12 407 RAMP MISSISSAUGA RD 407 RAMP & MISSISSAUGA RD
14 410 HWY 407 RAMP 410 HWY & 407 RAMP
15 410 HWY 410 RAMP 410 HWY & 410 RAMP
16 410 HWY HEART LAKE RD 410 HWY & HEART LAKE RD
17 410 HWY PROPOSED 410 HWY & PROPOSED
18 410 RAMP 410 HWY 410 RAMP & 410 HWY
19 410 RAMP BOVAIRD DR 410 RAMP & BOVAIRD DR
20 410 RAMP CLARK BLVD 410 RAMP & CLARK BLVD
My question is how can i get unique list of intersections from this data using access or oracle.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 19, 2005 10:12 AM
UPDATED:
August 19, 2005 1:40 PM
Answer Wiki:
You can try something like this:
SELECT Street1||? `||Street2||? `||Intersection address FROM your_table group by Street1||? `||Street2||? `||Intersection
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
