Extracting Coordinates from Polylines thru SQL Server

LorindaGilbert — Wed, 31 Jul 2013 17:22:59 GMT

Hi All,
I've been using FME to extract the start x, y; mid x, y; and end x, y from our street centerlines for another user. We've decided that rather than having this data move through multiple formats that we would like to attempt to do a view in the geodatabase that could then be used by other users.

I have created a MV view of our street centerlines and the nodes (intersection points) that accomodates the delta tables with the business table. The intersection points (nodes) are real easy to get the x, y coordinate. Just used the MV view and the f table to get the eminx and eminy - as a point they are rather self evident as to what to use. This will also be used for another point table.

Now.... I need to get the start point, mid point and end points for the centerlines. These could have 2 points or many points. In FME, there is a command to get the coordinates and it uses the index of the number of points, i.e. 0 for start, -1 for the end and then use mod of the number of points for the ones over 2, otherwise, simple math for the 2 point centerlines. How do you locate the coordinate list for vertices in SDE? I was thinking that it was in the s table, but not seeing that since even if there are mulitple sp_fid's the numbers are the same in the other columns.

Thanks for any help!
Thanks,

topic Extracting Coordinates from Polylines thru SQL Server in Data Management Questions

Extracting Coordinates from Polylines thru SQL Server