MySQL Forums
Forum List  »  GIS

Coordinates of intersection
Posted by: Glenn Puckett
Date: March 01, 2015 11:45AM

Hi, I am a long time user of MySQL but extremely new to the spatial extension. I am currently using server v5.5 becuase of legacy code. I hope upgrade to v5.6 soon. I have loaded a streets shape file (lines) to my MySQL database. Now I want to create a table I will use to search for specific intersctions.

This looks pretty easy. I created an intersection list with the following select:

SELECT a.roadname, b.roadname FROM gis.streets a, gis.streets b where(Intersects(a.shape,b.shape) and a.roadname != b.roadname);

But one more thin I want to include in the new table is the coordinates of the intersection. I can't figure out how to get that. I came accross the description of an Intersection(a,b) command that appears to do what I want, but evidently it doesn't exist in v5.5.

Options: ReplyQuote

Written By
Coordinates of intersection
March 01, 2015 11:45AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.