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,
