Querying GIS Data

pts.
Tags:
Data analysis
Database
Development
IBM DB2
Oracle
Software
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can try something like this:

SELECT Street1||? `||Street2||? `||Intersection address FROM your_table group by Street1||? `||Street2||? `||Intersection

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • RPandya
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/querying-gis-data/ (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following